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 getIntegralFields() {
return [
"name" => "姓名",
"card_type" => "证件类型",
"card_number" => "证件号码",
"phone" => "手机号码",
"email" => "电子邮箱",
"shareholder" => "是否股东"
];
}
public static function getTalentFields($step, $isImport = 0) {
$dict1 = [
"name" => "姓名",
"nation" => "民族",
"headimgurl" => "头像",
"card_type" => "证件类型",
"card_number" => "证件号码",
"sex" => "性别",
"birthday" => "出生日期",
"politics" => "政治面貌",
"nationality" => "国籍/地区",
"province" => "籍贯省",
"city" => "籍贯市",
"county" => "籍贯县",
"talent_type" => "人才类型",
"fst_work_time" => "来晋工作时间",
"tax_insurance_month" => "在我市缴交社会保险或个人所得税月份",
"labor_contract_rangetime" => "劳动合同起止时间",
"salary_pay_way" => "工资发放渠道",
"salary_pay_month" => "工资发放月份",
"pre_import_type" => "预引进类型",
"return" => "流出晋江满3年后又返回晋江的",
"import_way" => "引进方式",
"cur_entry_time" => "本单位入职时间",
"position" => "本单位现任职务",
"experience" => "工作简历",
"education" => "教育背景",
];
$dict2 = [
"apply_year" => "申报年度",
"phone" => "手机号码",
"email" => "电子邮箱",
"highest_degree" => "最高学历",
"graduate_school" => "毕业院校",
"major" => "专业",
"study_abroad" => "是否有留学经历",
"abroad_school" => "留学毕业院校",
"abroad_major" => "留学专业",
"pro_qua" => "职业资格",
"professional" => "专业技术职称",
];
if ($isImport) {
$dict2["isMatchZhiren"] = "是否符合直认条件";
}
$dict2_ = [
"source" => "申报来源",
"source_city" => "入选来源地级市",
"source_county" => "入选来源县市区",
"talent_arrange" => "人才层次",
"talent_arrange_category" => "人才条款",
"talent_condition" => "认定条件",
"identifyGetTime" => "认定条件取得时间",
"annual_salary" => "上一年度年薪（元）",
"bank" => "开户银行",
"bank_number" => "银行行号",
"bank_branch_name" => "开户银行网点",
"bank_account" => "个人银行账号"
//"source_batch" => "入选名单的文件号及批次",
//"fujian_highcert_pubtime" => "福建省高层次人才证书发证日期",
//"fujian_highcert_exptime" => "福建省高层次人才证书有效期",
//"quanzhou_highcert_pubtime" => "泉州高层次人才证书发证日期",
//"quanzhou_highcert_exptime" => "泉州高层次人才证书有效期",
];
$dict2 = array_merge($dict2, $dict2_);
if ($step == 1) {
return $dict1;
}
if ($step == 2) {
return $dict2;
}
if ($step == 3) {
return null;
}
return array_merge($dict1, $dict2);
}
public static function getTalentFields_IC() {
$dict = [
"name" => "姓名",
"card_type" => "证件类型",
"card_number" => "证件号码",
"sex" => "性别",
"birthday" => "出生日期",
"nationality" => "国籍/地区",
"province" => "籍贯省",
"city" => "籍贯市",
"county" => "籍贯县",
"nation" => "民族",
"politics" => "政治面貌",
"break_faith" => "是否曾被相关主管部门列为失信个人",
"phone" => "手机号码",
"email" => "电子邮箱",
"highest_degree" => "最高学历",
"graduate_school" => "毕业院校",
"major" => "专业",
"study_abroad" => "是否有留学经历",
"position" => "职务",
"cur_entry_time" => "入职时间",
"labor_contract_rangetime" => "工作合同起止时间",
"talent_arrange" => "人才层次",
"talent_condition" => "认定条件",
"identifyConditionName" => "认定条件名称",
"identifyGetTime" => "认定条件取得时间",
"title" => "职称",
"pro_qua" => "国家职业资格",
"bank" => "开户银行",
"bank_branch_name" => "开户银行网点",
"bank_account" => "银行账号",
"education" => "教育背景及工作简历",
"experience" => "主要业绩及取得的荣誉",
"description" => "备注",
"headimgurl" => "头像"
];
return $dict;
}
// 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 5:
case 6:
case 7:
$stepName = '基础信息复审';
break;
case -2:
case 10:
case 11:
if ($step == 3) {
$stepName = '部门审核';
} else {
$stepName = '初级审核';
}
break;
case 12:
case 13:
$stepName = '部门审核';
break;
case 14:
case 15:
$stepName = '复核';
break;
case 16:
$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:
switch ($step) {
case 60:
$stepName = '取消优秀人才';
break;
case 65:
$stepName = '恢复优秀人才';
break;
default:
$stepName = '用户操作';
break;
}
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 */
if ($last_state == 3) {
$str = '基础信息复审驳回';
} else {
$str = '待审核';
}
break;
case 3:
$str = '基础信息审核通过';
break;
case 4:
$str = '再提交基础信息';
break;
case 5:
$str = '基础信息复审通过';
break;
case 6:
$str = '基础信息复审驳回';
break;
case 7:
$str = '基础信息复审失败';
break;
case 8:
if ($last_state > $state) {
$str = '初审驳回';
} else {
$str = '待提交认定材料';
}
break;
case 9:
if ($step == 3) {
$str = '部门驳回';
} else {
if ($last_state == TalentState::FST_VERIFY_REJECT) {
$str = '待重审';
} else if ($last_state == TalentState::DEPT_VERIFY_REJECT) {
$str = '部门驳回';
} else if ($last_state == TalentState::REVERIFY_REJECT) {
$str = '复核驳回';
} else {
$str = '待初审';
}
}
break;
case 10:
if ($step == 3) {
$str = '待部门审核';
} else {
$str = '待复审';
}
break;
case 11:
$str = '再提交认定材料';
break;
case 12:
if ($step == 3) {
$str = '部门通过';
} else {
$str = '待复审';
}
break;
case 13:
if ($step == 3) {
$str = '部门驳回';
} else {
$str = '待初审';
}
break;
case 14:
$str = '待核查征信';
break;
case 15:
$str = '待重新审核';
break;
case 16:
$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 getOldStateNameByState($state) {
switch ($state) {
case -2:
return "待提交";
case -1:
return "审核不通过";
case 1:
return "待审核";
case 2:
return "审核驳回";
case 3:
return "审核通过";
case 4:
return "上级驳回";
case 10:
return "冻结";
case 8:
return "提交审核";
case 11:
return "撤销审核";
case 9:
return "重新提交";
default:
return "";
}
}
public static function getOldStepNameByStep($step) {
switch ($step) {
case -1:
return "部门初审";
case 0:
return "用户操作";
case 1:
return "初级审核";
case 2:
return "部门审核";
case 3:
return "复核";
case 4:
return "核查征信";
case 5:
return "公示";
case 6:
return "公示再审核";
case 7:
return "公布";
case 8:
return "发证";
case 11:
return "审核";
case 12:
return "撤回审核";
case 20:
return "人才层次变更";
case 21:
return "工作单位变更";
case 22:
return "离职变更";
case 23:
return "银行账号变更";
case 24:
return "基础信息变更";
case 50:
return "兑现";
case 55:
return "撤销公布";
case 60:
return "取消优秀人才";
case 65:
return "恢复优秀人才";
case 70:
return "设置审核不通过";
default:
return "";
}
}
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;
}
}