report/app/enterprise/controller/Talent.php

<?php

namespace app\enterprise\controller;

use app\enterprise\common\EnterpriseController;
use app\enterprise\api\TalentApi;
use app\enterprise\model\Talent as TalentModel;
use think\facade\Db;
use app\common\api\TalentLogApi;
use app\common\api\TalentState;

// 0正在填写 1保存未提交 2已提交未审核 3已审核 4驳回 5保存补充材料未提交 6提交补充材料进入初审 7初审通过 8初审驳回 9部门审核通过 10部门审核驳回 11复核通过 12复核驳回 13复核失败

/**
 * Description of Talent
 *
 * @author sgq
 */
class Talent extends EnterpriseController {

    public function index() {
        return view();
    }

    public function list() {
        $res = TalentApi::getList($this->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("<script>parent.TalentInfoInfoDlg.infoCallback(%s);</script>", 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("<script>parent.TalentInfoInfoDlg.infoCallback(%s);</script>", 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("<br>", $return)];
                echo sprintf("<script>parent.TalentInfoInfoDlg.infoCallback(%s);</script>", json_encode($res));
                exit;
            }
            if (!preg_match("/^(13|14|15|17|18|19)[\d]{9}$/", $data["phone"])) {
                $res = ["msg" => "手机号码格式错误"];
                echo sprintf("<script>parent.TalentInfoInfoDlg.infoCallback(%s);</script>", json_encode($res));
                exit;
            }
            if (!filter_var($data["email"], FILTER_VALIDATE_EMAIL)) {
                $res = ["msg" => "电子邮箱格式错误"];
                echo sprintf("<script>parent.TalentInfoInfoDlg.infoCallback(%s);</script>", json_encode($res));
                exit;
            }

            if (!in_array($data["talent_arrange"], [1, 2, 3, 4, 5, 6, 7])) {
                $res = ["msg" => "人才层次只能在预设范围内选择"];
                echo sprintf("<script>parent.TalentInfoInfoDlg.infoCallback(%s);</script>", json_encode($res));
                exit;
            }
            if (!in_array($data["source"], [1, 2, 3, 4, 5])) {
                $res = ["msg" => "来源只能在预设范围内选择"];
                echo sprintf("<script>parent.TalentInfoInfoDlg.infoCallback(%s);</script>", 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("<script>parent.TalentInfoInfoDlg.infoCallback(%s);</script>", 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("<script>parent.TalentInfoInfoDlg.infoCallback(%s);</script>", json_encode($res));
            } else {
                $res = ["code" => 500, "msg" => "保存失败"];
                echo sprintf("<script>parent.TalentInfoInfoDlg.infoCallback(%s);</script>", 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;
    }

}