sprintf("编码[%s]已经存在", $data["code"])]; $items = array_filter(explode(";", $values)); $id = Dict::insertGetId($data); $childs = []; for ($i = 0; $i < count($items); $i++) { $fields = array_filter(explode(":", $items[$i])); $childs[] = ["pid" => $id, "code" => $fields[0], "name" => $fields[1], "num" => $fields[2]]; } Dict::insertAll($childs); return ["code" => 200, "msg" => "成功"]; } public static function update($params) { $data["id"] = $params["dictId"]; $data["code"] = $params["dictCode"]; $data["name"] = $params["dictName"]; $data["tips"] = $params["dictTips"]; $data["pid"] = 0; $values = $params["dictValues"]; if (self::isExistByCode($data["code"], $params["dictId"])) return ["msg" => sprintf("编码[%s]已经存在", $data["code"])]; $items = array_filter(explode(";", $values)); Dict::update($data); //删除原来的子项 Dict::where(["pid" => $params["dictId"]])->delete(); $childs = []; for ($i = 0; $i < count($items); $i++) { $fields = array_filter(explode(":", $items[$i])); $childs[] = ["pid" => $params["dictId"], "code" => $fields[0], "name" => $fields[1], "num" => $fields[2]]; } Dict::insertAll($childs); return ["code" => 200, "msg" => "成功"]; } public static function delete($id) { Dict::where(["id" => $id])->delete(); Dict::where(["pid" => $id])->delete(); return ["code" => 200, "msg" => "成功"]; } public static function isExistByCode($code, $id = 0) { $where = []; if ($id > 0) { $where[] = ["id", "<>", $id]; } $where[] = ["code", "=", $code]; $dict = Dict::where($where)->findOrEmpty()->toArray(); return $dict; } /** * 获取一条 * @param type $id * @return type */ public static function getOne($id) { $info = Dict::where("id", $id)->findOrEmpty()->toArray(); if ($info) { $items = Dict::where("pid", "=", $id)->select()->toArray(); $info["children"] = $items; } return $info; } /** * 获取列表 * @param type $request * @return type */ public static function getList($request) { $order = trim($request->param("order")) ?: "desc"; $offset = trim($request->param("offset")) ?: 0; $limit = trim($request->param("limit")) ?: 10; $name = trim($request->param("condition")); $where = []; $where[] = ["pid", "=", "0"]; if ($name) { $where[] = ["name", "like", "%" . $name . "%"]; } $count = Dict::where($where)->count(); $list = Dict::where($where)->limit($offset, $limit)->order("id " . $order)->select()->toArray(); foreach ($list as &$item) { $items = Dict::where("pid", "=", $item["id"])->column("name"); $item["detail"] = implode(",", $items); } return ["total" => $count, "rows" => $list]; } /** * * @param type $code * @return type */ public static function selectByParentCode($code) { $parent = Dict::where("code", $code)->findOrEmpty()->toArray(); $dictList = Dict::where("pid", $parent["id"])->select()->toArray(); $tmp = []; foreach ($dictList as $dict) { $tmp[$dict["code"]] = $dict["name"]; } return $tmp; } /** * * @param type $code * @return type */ public static function findChildDictByCode($code) { $parent = Dict::where("code", $code)->findOrEmpty()->toArray(); $dictList = Dict::where("pid", $parent["id"])->select()->toArray(); return $dictList; } public static function findDictByCode($code) { $dict = Dict::where("code", $code)->findOrEmpty(); return $dict; } public static function getTalentFields($step) { $dict1 = [ "talent_type" => "人才类型", "tax_insurance_month" => "在我市缴交社会保险或个人所得税月份", "labor_contract_rangetime" => "劳动合同起止时间", "pre_import_type" => "预引进类型", "name" => "姓名", "card_type" => "证件类型", "card_number" => "证件号码", "sex" => "性别", "birthday" => "出生日期", "nationality" => "国籍/地区", "province" => "籍贯省", "city" => "籍贯市", "county" => "籍贯县", "nation" => "民族", "politics" => "政治面貌", "fst_work_time" => "来晋工作时间", "experience" => "工作简历", "education" => "教育背景", ]; $dict2 = [ "talent_arrange" => "人才层次", "talent_arrange_category" => "人才条款", "talent_condition" => "认定条件", "highest_degree" => "最高学历", "graduate_school" => "毕业院校", "major" => "专业", "professional" => "专业技术职称", "pro_qua" => "职业资格", "bank" => "开户银行", "bank_number" => "银行行号", "bank_branch_name" => "开户银行网点", "bank_account" => "银行账号", "study_abroad" => "是否有留学经历", "abroad_school" => "留学毕业院校", "abroad_major" => "留学专业", "phone" => "手机号码", "email" => "电子邮箱", "apply_year" => "申报年度", "import_way" => "引进方式", "cur_entry_time" => "本单位入职时间", "position" => "本单位现任职务", "source" => "申报来源", "source_city" => "入选来源地级市", "source_county" => "入选来源县市区", "source_batch" => "入选名单的文件号及批次", "fujian_highcert_pubtime" => "福建省高层次人才证书发证日期", "fujian_highcert_exptime" => "福建省高层次人才证书有效期", "quanzhou_highcert_pubtime" => "泉州高层次人才证书发证日期", "quanzhou_highcert_exptime" => "泉州高层次人才证书有效期", "annual_salary" => "上一年度年薪（元）" ]; if ($step == 1) { return $dict1; } if ($step == 2) { return $dict2; } if ($step == 3) { return null; } return array_merge($dict1, $dict2); } // 1保存未提交 2已提交未审核 3已审核 4驳回 5保存补充材料未提交 6提交补充材料进入初审 7初审通过 8初审驳回 9部门审核通过 10部门审核驳回 11复核通过 12复核驳回 13复核失败 public static function getCheckLogStepName($state, $step) { $stepName = ""; switch ($state) { case -1: case 3: case 4: $stepName = '基础条件审核'; break; case -2: case 7: case 8: if ($step == 3) { $stepName = '部门审核'; } else { $stepName = '初级审核'; } break; case 9: case 10: $stepName = '部门审核'; break; case 11: case 12: $stepName = '复核'; break; case 13: $stepName = '审核不通过'; break; case 21: case 22: $stepName = '核查征信'; break; case 23: case 24: case 25: $stepName = '公示'; break; case 26: case 27: $stepName = '公布'; break; case 28: $stepName = '发放人才码'; break; default: $stepName = '用户操作'; break; } return $stepName; } public static function getTalentInfoStateName($state, $step = 0, $last_state = 0) { $str = ""; switch ($state) { case -2: $str = '初审失败'; break; case -1: $str = '基础信息审核失败'; break; case 1: if ($last_state > $state) { $str = '基审驳回'; } else { $str = '待提交基础信息'; } break; case 2: if ($last_state > $state) { $str = '待重审'; } else { $str = '待审核'; } break; case 3: $str = '基审通过'; break; case 4: $str = '再提交基础信息'; break; case 5: if ($last_state > $state) { $str = '初审驳回'; } else { $str = '待提交认定材料'; } break; case 6: if ($step == 3) { $str = '部门驳回'; } else { if ($last_state == 8) { $str = '待重审'; } else if ($last_state == 7) { $str = '部门驳回'; } else if ($last_state == 9) { $str = '复核驳回'; } else { $str = '待初审'; } } break; case 7: if ($step == 3) { $str = '待部门审核'; } else { $str = '待复核'; } break; case 8: $str = '再提交认定材料'; break; case 9: if ($step == 3) { $str = '部门通过'; } else { $str = '待复核'; } break; case 10: if ($step == 3) { $str = '部门驳回'; } else { $str = '待初审'; } break; case 11: $str = '待核查征信'; break; case 12: $str = '待重新审核'; break; case 13: $str = '复核不通过'; break; case 22: $str = '征信不通过'; break; case 25: $str = '公示审核不通过'; break; case 27: $str = '公布不通过'; break; case 21: $str = '待公示'; break; case 23: $str = '待公示审核'; break; case 24: $str = '待公布'; break; case 26: $str = '待发放人才码'; break; case 28: $str = '已发放人才码'; break; } return $str; } public static function findByParentCodeAndCode($parentCode, $code) { $parent_info = Dict::where('code', $parentCode)->findOrEmpty(); if ($parent_info) { return Dict::where('pid', $parent_info['id'])->where('code', $code)->findOrEmpty(); } return false; } public static function getLayerCatsByLayer($lv) { $kv = [1 => "A", 2 => "B", 3 => "C", 4 => "D", 5 => "E", 6 => "F", 7 => "G"]; $chr = $kv[$lv]; if ($chr) { $parent_info = Dict::where('code', "talent_condition_cats")->findOrEmpty(); $where[] = ["pid", "=", $parent_info["id"]]; if ($parent_info) { $where[] = ["code", "like", $chr . "%"]; return Dict::where($where)->select()->toArray(); } } return false; } }