request);
return json($res);
}
public function second(\think\Request $request) {
$params = $request->param();
$id = $params["id"];
$info = \app\common\api\VerifyApi::getTalentInfoById($id);
if (!$info || $info["enterprise_id"] != $this->user["uid"]) {
$res = ["msg" => "错误的访问方式"];
echo sprintf("", json_encode($res));
exit;
}
$info["real_state"] = TalentLogApi::getLastLog($id, 1)["state"];
if ($request->isPost()) {
$batch = \app\common\api\BatchApi::getValidBatch(1, $this->user["type"]);
if (!$batch) {
$res = ["msg" => "不在人才认定申报申请时间内"];
echo sprintf("", json_encode($res));
exit;
}
$field_dict = \app\common\api\DictApi::getTalentFields(2);
//可以用匹配键的方式，可以少很多代码。。先这样吧。
$all_valid_keys = ["applay_year", "import_way", "cur_entry_time", "position",
"source", "source_batch", "fujian_highcert_pubtime", "fujian_highcert_exptime", "quanzhou_highcert_pubtime", "quanzhou_highcert_exptime", "source_city", "source_county",
"talent_arrange", "talent_condition", "highest_degree", "graduate_school", "major", "professional", "bank", "bank_number", "bank_branch_name", "bank_account",
"study_abroad", "abroad_school", "abroad_major", "phone", "email", "annual_salary"];
foreach ($all_valid_keys as $key) {
$data[$key] = trim($params[$key]);
if (strpos($key, "time") !== false && strtotime($params[$key]) === false) {
unset($data[$key]); //时间格式的验证不通过就清掉，下面判断是否为空如果赫然在列就不能通过
}
}
$no_empty = ["talent_arrange", "talent_condition", "highest_degree", "graduate_school", "major", "bank", "bank_number", "bank_branch_name",
"bank_account", "study_abroad", "phone", "email", "import_way", "cur_entry_time", "cur_entry_time", "position", "source"];
$where = [];
$where[] = ["rel", "=", "study_abroad"];
$where[] = ["step", "=", 2];
$where[] = ["project", "=", 1];
$where[] = ["active", "=", 1];
$where[] = ["delete", "=", 0];
$where[] = ["type", "=", $this->user["type"]];
$where[] = ["isConditionFile", "<>", 1];
$abroad_files = Db::table("new_common_filetype")->where($where)->select()->toArray(); //留学的附件
$abroad_file_ids = null;
if ($abroad_files)
$abroad_file_ids = array_column($abroad_files, "id");
if ($data["study_abroad"] == 1) {
$no_empty[] = "abroad_school";
$no_empty[] = "abroad_major";
}
if (in_array($data["source"], [1, 3])) {
$no_empty[] = "source_batch";
$no_empty[] = "fujian_highcert_pubtime";
$no_empty[] = "fujian_highcert_exptime";
if ($data["source"] == 3) {
$no_empty[] = "source_city";
}
}
if (in_array($data["source"], [2, 4])) {
$no_empty[] = "source_batch";
$no_empty[] = "quanzhou_highcert_pubtime";
$no_empty[] = "quanzhou_highcert_exptime";
if ($data["source"] == 4) {
$no_empty[] = "source_county";
}
}
$condition_info = Db::table("new_talent_condition")->findOrEmpty($params["talent_condition"]);
if ($condition_info["isSalary"] == 1) {
$no_empty[] = "annual_salary";
}
$no_empty = array_filter($no_empty);
$return = [];
foreach ($no_empty as $key) {
if (!$data[$key]) {
$return[] = sprintf("请填写“%s”", $field_dict[$key]);
}
}
if (count($return) > 0) {
$res = ["msg" => implode("
", $return)];
echo sprintf("", json_encode($res));
exit;
}
if (!preg_match("/^(13|14|15|17|18|19)[\d]{9}$/", $data["phone"])) {
$res = ["msg" => "手机号码格式错误"];
echo sprintf("", json_encode($res));
exit;
}
if (!filter_var($data["email"], FILTER_VALIDATE_EMAIL)) {
$res = ["msg" => "电子邮箱格式错误"];
echo sprintf("", json_encode($res));
exit;
}
if (!in_array($data["talent_arrange"], [1, 2, 3, 4, 5, 6, 7])) {
$res = ["msg" => "人才层次只能在预设范围内选择"];
echo sprintf("", json_encode($res));
exit;
}
if (!in_array($data["source"], [1, 2, 3, 4, 5])) {
$res = ["msg" => "来源只能在预设范围内选择"];
echo sprintf("", json_encode($res));
exit;
}
if ($condition_info["bindFileTypes"]) {
$whr[] = ["id", "in", $condition_info["bindFileTypes"]];
$whr[] = ["must", "=", 1];
}
$where = [];
$where[] = ["step", "=", 2];
$where[] = ["project", "=", 1];
$where[] = ["type", "=", $this->user["type"]];
$where[] = ["must", "=", 1];
$where[] = ["active", "=", 1];
$where[] = ["delete", "=", 0];
$where[] = ["isConditionFile", "<>", 1];
if ($whr) {
$filetypes = Db::table("new_common_filetype")->where([$where, $whr])->select()->toArray();
} else {
$filetypes = Db::table("new_common_filetype")->where($where)->select()->toArray();
}
$ft_ids = array_column($filetypes, "id");
if ($data["study_abroad"] == 1) {
//选中留学，如果存在留学附件变成必传
$ft_ids = array_unique(array_merge($ft_ids, (array) $abroad_file_ids));
} else {
//没选中，留学附件就算设成必传也不用验证
$ft_ids = array_diff($ft_ids, (array) $abroad_file_ids);
}
$whr = [];
$whr[] = ["typeId", "in", $ft_ids];
$whr[] = ["mainId", "=", $id];
$distinct_filetypes = Db::table("new_talent_file")->where($whr)->distinct(true)->field("typeId")->select();
$upload_type_counts = count($distinct_filetypes);
if ($upload_type_counts != count($ft_ids)) {
$res = ["msg" => "请留意附件上传栏中带*号的内容均为必传项，请上传完整再提交审核"];
echo sprintf("", json_encode($res));
exit;
}
if ($info["real_state"] == 8) {
//真实状态8是驳回，需要判断什么字段可以提交
$modify_fields = array_filter(explode(",", $info["modify_fields"]));
$tmp_data = $data;
$data = [];
foreach ($modify_fields as $field) {
$data[$field] = $tmp_data[$field];
}
}
$data["apply_year"] = $batch["batch"];
$data["id"] = $id;
$data["checkState"] = TalentState::SCND_SAVE;
if (TalentModel::update($data)) {
$res = ["code" => 200, "msg" => "保存成功", "obj" => ["id" => $id, "checkState" => TalentState::SCND_SAVE]];
echo sprintf("", json_encode($res));
} else {
$res = ["code" => 500, "msg" => "保存失败"];
echo sprintf("", json_encode($res));
}
exit();
}
$enterprise_info = \app\common\model\Enterprise::find($this->user["uid"]);
$info["enterprise"] = $enterprise_info;
$batch = \app\common\api\BatchApi::getValidBatch(1, $enterprise_info["type"]);
return view("second", ["year" => $info["apply_year"] ?: $batch["batch"], "row" => $info]);
}
public function view(\think\Request $request) {
$id = $request->param("id");
$info = \app\common\api\VerifyApi::getTalentInfoById($id);
return view("view", ["row" => $info]);
}
// 1保存未提交 2已提交未审核 3已审核 4驳回 5保存补充材料未提交 6提交补充材料进入初审 7初审通过 8初审驳回 9部门审核通过 10部门审核驳回 11复核通过 12复核驳回 13复核失败
public function submit() {
$id = $this->request->param("id");
if (!$info = self::chkIsOwner($id, $this->user["uid"]))
return json(["msg" => "没有对应的人才认定申报信息"]);
$checkState = $info["checkState"];
if ($checkState == TalentState::BASE_VERIFY_PASS || $checkState == 0) {
return json(["msg" => '请先保存资料并上传相应附件后再点击提交审核']);
} else if ($checkState == TalentState::SCND_SAVE) {
$condition_info = Db::table("new_talent_condition")->findOrEmpty($info["talent_condition"]);
if ($condition_info["bindFileTypes"]) {
$whr[] = ["id", "in", $condition_info["bindFileTypes"]];
$whr[] = ["must", "=", 1];
}
$where = [];
$where[] = ["rel", "=", "study_abroad"];
$where[] = ["step", "=", 2];
$where[] = ["project", "=", 1];
$where[] = ["active", "=", 1];
$where[] = ["delete", "=", 0];
$where[] = ["type", "=", $this->user["type"]];
$where[] = ["isConditionFile", "<>", 1];
$abroad_files = Db::table("new_common_filetype")->where($where)->select()->toArray(); //留学的附件
$abroad_file_ids = null;
if ($abroad_files)
$abroad_file_ids = array_column($abroad_files, "id");
$where = [];
$where[] = ["step", "=", 2];
$where[] = ["project", "=", 1];
$where[] = ["type", "=", $this->user["type"]];
$where[] = ["must", "=", 1];
$where[] = ["active", "=", 1];
$where[] = ["delete", "=", 0];
$where[] = ["isConditionFile", "<>", 1];
if ($whr) {
$filetypes = Db::table("new_common_filetype")->where([$where, $whr])->select()->toArray();
} else {
$filetypes = Db::table("new_common_filetype")->where($where)->select()->toArray();
}
$ft_ids = array_column($filetypes, "id");
if ($info["study_abroad"] == 1) {
//选中留学，如果存在留学附件变成必传
$ft_ids = array_unique(array_merge($ft_ids, (array) $abroad_file_ids));
} else {
//没选中，留学附件就算设成必传也不用验证
$ft_ids = array_diff($ft_ids, (array) $abroad_file_ids);
}
$whr = [];
$whr[] = ["typeId", "in", $ft_ids];
$whr[] = ["mainId", "=", $id];
$distinct_filetypes = Db::table("new_talent_file")->where($whr)->distinct(true)->field("typeId")->select();
$upload_type_counts = count($distinct_filetypes);
if ($upload_type_counts != count($ft_ids)) {
return json(["msg" => "请留意附件上传栏中带*号的内容均为必传项，请上传完整再提交审核"]);
}
$change_state = TalentState::SCND_SUBMIT; //等待初审
$data["id"] = $id;
$data["checkState"] = $change_state;
$data["active"] = 1;
$data["new_submit_time"] = date("Y-m-d H:i:s");
TalentModel::update($data);
TalentLogApi::write(1, $id, $change_state, "确认提交审核", 1);
return json(["code" => 200, "msg" => "提交成功"]);
} else if ($checkState == TalentState::REVERIFY_FAIL) {
return ["msg" => "审核失败，不能再提交审核"];
}
return json(["msg" => "已提交审核，请耐心等待"]);
}
public function delete() {
$id = $this->request->param("talentInfoId");
$info = Talent::chkIsOwner($id, $this->user["uid"]);
if (!$info) {
return json(["msg" => "操作失败"]);
}
$checkState = $info["checkState"];
if (in_array($checkState, [0, 1])) {
$log = TalentLogApi::getLastLog($id, 1);
if ($log["state"] > 1) {
//有提交审核记录
return json(["msg" => "操作失败"]);
}
}
$data["id"] = $id;
$data["delete"] = 1;
TalentModel::update($data);
return json(["msg" => "删除成功"]);
}
static public function chkIsOwner($id, $uid) {
$where[] = ["id", "=", $id];
$where[] = ["enterprise_id", "=", $uid];
$info = TalentModel::where($where)->findOrEmpty()->toArray();
return $info;
}
}