report/app/admin/controller/TalentAllowance.php

<?php

namespace app\admin\controller;

use app\admin\common\AdminController;
use app\common\model\TalentAllowance as TaModel;
use think\facade\Db;
use app\common\api\DictApi;
use app\common\state\AllowanceStateEnum;
use app\common\state\AllowanceProjectEnum;
use app\common\api\TalentAllowanceApi;

/**
 * Description of TalentAllowance
 *
 * @author sgq
 */
class TalentAllowance extends AdminController {

    public function index() {
        $process = $this->request["process"];
        $type = $this->user["type"];
        $assigns = ["process" => $process, "type" => $type];
        if ($process == 4) {
            if ($type == 1) {
                $msgBody["typeName"] = "晋江市优秀人才津补贴申报";
                $msgBody["address"] = "聚才网/人才晋江微信公众号";
                $msgBody["dep"] = "中共晋江市委人才办、晋江市纪委监委驻市人力资源和社会保障局纪检监察组或晋江市公共就业和人才服务中心";
                $msgBody["phone"] = "0595-85633128";
                $msgBody["email"] = "jjrc85661234@163.com";
            }
            if ($type == 2) {
                $msgBody["typeName"] = "晋江市集成电路产业优秀人才津补贴申报";
                $msgBody["address"] = "福建（晋江）集成电路产业园官方网站及微信公众号";
                $msgBody["dep"] = "集成电路产业园区";
                $msgBody["phone"] = "0595-82250007、0595-82250001";
                $msgBody["email"] = "jjjcdr@163.com";
            }
            $assigns["message"] = $msgBody;
        }

        return view("", $assigns);
    }

    /**
     * 获取优秀人才津补贴列表
     */
    public function list() {
        $param = $this->request->param();
        $offset = $param["offset"] ?: 0;
        $limit = $param["limit"] ?: 10;
        $process = $param["process"];
        $where = [];
        $where[] = ["type", "=", $this->user["type"]];
        $order = "newSubmitTime desc";
        $where = $this->setTalentAllowanceInfo($where, $param, $process);
        switch ($process) {
            case 1:
                $where[] = ["checkState", "in", [1, 5, 10, 13, 15, 20, 25, 30]];
                break;
            case 2:
                $where[] = ["firstPassTime", "EXP", Db::raw("is not null")];
                break;
            case 3:
                $where[] = ["visitPassTime", "EXP", Db::raw("is not null")];
                break;
            case 4:
                if ($param["publicState"]) {
                    $where[] = ["publicState", "=", $param["publicState"]];
                }
                $where[] = ["checkState", "in", [-1, 30]];
                break;
        }
        $count = TaModel::where($where)->count();
        $list = TaModel::where($where)->limit($offset, $limit)->order($order)->select()->toArray();
        $list = $this->translateChinese($list);
        return json(["rows" => $list, "total" => $count]);
    }

    public function toCheckPage() {
        $id = $this->request["id"];
        $process = $this->request["process"];
        $obj = TalentAllowanceApi::getInfoById($id);
        $this->translateToChinese($obj);
        return view("info", ["row" => $obj, "process" => $process]);
    }
    
    /**
     * 校验是否在审核范围内
     */
    public function validateIsCheck() {
        $id = $this->request["id"];
        $type = $this->request["type"];
        $process = $this->request["process"];
        
        $response = new \stdClass();
        $response->code = 500;
        
        $info = null;
        switch ($type) {
            case 1:                 //编辑合同
                $detail = \app\common\model\TalentAllowancecontractDetail::find($id);
                $info = TalentAllowanceApi::getInfoById($detail["mainId"]);
                break;
            case 2:                 //编辑项目
                $project = \app\common\model\TalentAllowanceProject::find($id);
                $info = TalentAllowanceApi::getInfoById($project["mainId"]);
                break;
            case 3:
                $info = TalentAllowanceApi::getInfoById($id);
                break;
        }
        if (!$info) {
            $response->msg = "校验不通过，无法操作";
            return $response;
        }
        $where = [];
        $where[] = ["mainId","=",$info["id"]];
        $where[] = ["step","=",$process];
        $where[] = ["active","=",2];
        \app\common\model\TalentChecklog::where($where)->order("createTime desc")->find();
        $log = null;
        switch ($process) {
            case 1:
                if (info.getCheckState() != AllowanceStateEnum.NEED_CHECK.getCode() && info.getCheckState() != AllowanceStateEnum.REJECT_TO_FIRST.getCode()) {
                    return new ResponseObj(ResponseObj.FAILD, "不在审核范围内");
                } else {
                    TalentDepcheckstate depcheckstate = this.talentDepcheckstateService.selectOne(new EntityWrapper<TalentDepcheckstate>().eq("mainId", info.getId()).eq("companyId", companyId).last("limit 1"));
                    if (depcheckstate.getState() != BasicStateEnum.RCRD_BASIC_NEED.getCode() && depcheckstate.getState() != BasicStateEnum.RCRD_BASEIC_RESUBMIT.getCode()
                            && depcheckstate.getState() != BasicStateEnum.RCRD_BASIC_UPREJECT.getCode()) {
                        return new ResponseObj(ResponseObj.FAILD, "不在审核范围内");
                    }
                }
                logWrapper.eq("companyId", companyId);
                log = this.talentChecklogService.selectOne(logWrapper);
                break;
            case 2:
                if (info.getCheckState() != AllowanceStateEnum.NEED_VISIT_CHECK.getCode() && info.getCheckState() != AllowanceStateEnum.REVIEW_REJECT.getCode()) {
                    return new ResponseObj(ResponseObj.FAILD, "不在审核范围内");
                }
                break;
            case 3:
                if (info.getCheckState() != AllowanceStateEnum.NEED_REVIEW.getCode() && info.getCheckState() != AllowanceStateEnum.PUBLIC_REJECT.getCode()) {
                    return new ResponseObj(ResponseObj.FAILD, "不在审核范围内");
                }
                log = this.talentChecklogService.selectOne(logWrapper);
                break;
        }
        if (log != null) {
            info.setCheckState(log.getState());
            info.setCheckMsg(log.getDescription());
        } else {
            info.setCheckState(null);
            info.setCheckMsg("");
        }
        Map<String, Object> res = new HashMap<>();
        res.put("info", info);
        if (type == 3) {
            Map<String, String> enterpriseMap = this.enterpriseService.selectListForMap(new EntityWrapper<Enterprise>());
            EntityWrapper<TalentAllowanceProject> projectEntityWrapper = new EntityWrapper<>();
            projectEntityWrapper.eq("mainId", id).eq("isLock", 1);
            if (ShiroKit.getUser().getType() == 1) {
                projectEntityWrapper.eq("project", AllowanceProjectEnum.PROJECT_TAX.getCode());
            }
            List<TalentAllowanceProject> projectList = this.talentAllowanceProjectService.selectList(projectEntityWrapper);
            List<TalentAllowancecontractDetail> detailList = this.talentAllowancecontractDetailService.selectList(new EntityWrapper<TalentAllowancecontractDetail>().eq("mainId", id));
            Map<String, TalentAllowancecontractDetail> detailMap = detailList.stream().collect(Collectors.toMap(TalentAllowancecontractDetail::getId, Function.identity()));
            for (TalentAllowancecontractDetail detail : detailList) {
                detail.setEnterpriseName(enterpriseMap.get(detail.getEnterpriseId()) + "(" + detail.getStartTime() + "至" + detail.getEndTime() + ")");
            }
            for (TalentAllowanceProject project : projectList) {
                Enterprise enterprise = this.enterpriseService.selectById(project.getEnterpriseId());
                TalentAllowancecontractDetail detail = detailMap.get(project.getBaseId());
                project.setProjectName(AllowanceProjectEnum.valueOf(project.getProject()) + "(" + enterprise.getName() + "(" + detail.getStartTime() + "至" + detail.getEndTime() + "))");
            }
            EntityWrapper<UnCommonFiletype> filetypeEntityWrapper = new EntityWrapper<>();
            filetypeEntityWrapper.eq("project", ProjectEnum.JBT.getCode()).eq("active", 1).eq("type", info.getType());
            List<UnCommonFiletype> filetypeList = this.unCommonFiletypeService.selectList(filetypeEntityWrapper);
            res.put("files", filetypeList);
            res.put("projects", projectList);
            res.put("concats", detailList);
        }
        return new ResponseObj(ResponseObj.SUCCESS, "", res);
    }
    
    /**
     * 查询工作单位
     */
    public function findAllowanceContractDetail() {
        $mainId = $this->request["mainId"];
        $offset = $this->request["offset"] ?: 0;
        $limit = $this->request["limit"] ?: 1000;
        $count = \app\common\model\TalentAllowancecontractDetail::where("mainId", $mainId)->count();
        $list = \app\common\model\TalentAllowancecontractDetail::where("mainId", $mainId)->limit($offset, $limit)->select()->toArray();
        $enterpriseMap = \app\common\model\Enterprise::column("name", "id");
        foreach ($list as &$row) {
            $row["enterpriseName"] = $enterpriseMap[$row["enterpriseId"]];
        }unset($row);
        return json(["rows" => $list, "total" => $count]);
    }

    /**
     * 查询核查项目情况
     */
    public function findAllowanceProject() {
        $mainId = $this->request["mainId"];
        $baseId = $this->request["baseId"];
        $offset = $this->request["offset"] ?: 0;
        $limit = $this->request["limit"] ?: 1000;
        $where = [];
        $where[] = ["mainId", "=", $mainId];
        $where[] = ["baseId", "=", $baseId];
        $count = \app\common\model\TalentAllowanceProject::where($where)->count();
        $list = \app\common\model\TalentAllowanceProject::where($where)->limit($offset, $limit)->select()->toArray();
        $info = TalentAllowanceApi::getInfoById($mainId);
        foreach ($list as &$project) {
            $project["projectName"] = AllowanceProjectEnum::getProjectName($project["project"]);
            if ($info["checkState"] == 1) {
                $project["isEdit"] = in_array($project["project"], [
                            AllowanceProjectEnum::PROJECT_CONTRACT,
                            AllowanceProjectEnum::PROJECT_TAX,
                            AllowanceProjectEnum::PROJECT_WAGES,
                            AllowanceProjectEnum::PROJECT_ATTENDANCE,
                            AllowanceProjectEnum::PROJECT_SB_PENSION,
                            AllowanceProjectEnum::PROJECT_SB_UNEMPLOYMENT,
                            AllowanceProjectEnum::PROJECT_SB_MEDICA,
                            AllowanceProjectEnum::PROJECT_WORKDAY
                        ]) ? 1 : 2;
            } else if ($info["checkState"] == 10) {
                $projects = explode(",", $info["projects"]);
                if (in_array($project["id"], $projects)) {
                    $project["isEdit"] = 1;
                } else {
                    $project["isEdit"] = 2;
                }
            } else {
                $project["isEdit"] = 2;
            }
        }unset($project);
        return json(["rows" => $list, "total" => $count]);
    }

    /**
     * 查询人才层次变更记录
     */
    public function findAllowanceArrange() {
        $mainId = $this->request["mainId"];
        $offset = $this->request["offset"] ?: 0;
        $limit = $this->request["limit"] ?: 1000;
        $where = [];
        $where[] = ["mainId", "=", $mainId];
        $count = \app\common\model\TalentAllowanceArrange::where($where)->count();
        $list = \app\common\model\TalentAllowanceArrange::where($where)->limit($offset, $limit)->select()->toArray();
        foreach ($list as &$arrange) {
            $condition = \app\common\api\TalentConditionApi::getOne($arrange["identifyCondition"]);
            $arrange["identifyConditionText"] = $condition["name"];
            $arrange["talentArrangeName"] = \app\common\state\CommonConst::getLayerNameByLayer($arrange["talentArrange"]);
        }unset($arrange);
        return json(["rows" => $list, "total" => $count]);
    }

    private function setTalentAllowanceInfo($where, $query, $process) {
        if (\StrUtil::isNotEmpAndNull($query["year"])) {
            $where[] = ["year", "=", $query["year"]];
        }
        if (\StrUtil::isNotEmpAndNull($query["enterpriseName"])) {
            $where[] = ["enterpriseName", "like", "%" . $query["enterpriseName"] . "%"];
        }
        if (\StrUtil::isNotEmpAndNull($query["name"])) {
            $where[] = ["name", "like", "%" . $query["name"] . "%"];
        }
        if (\StrUtil::isNotEmpAndNull($query["talentType"])) {
            $where[] = ["talentType", "=", $query["talentType"]];
        }
        if (\StrUtil::isNotEmpAndNull($query["talentArrange"])) {
            $where[] = ["talentArrange", "=", $query["talentArrange"]];
        }
        if (\StrUtil::isNotEmpAndNull($query["identifyCondition"])) {
            $where[] = ["identifyCondition", "=", $query["identifyCondition"]];
        }
        if (\StrUtil::isNotEmpAndNull($query["address"])) {
            $where[] = ["address", "=", $query["address"]];
        }
        if ($query["recommendAllowanceType"]) {
            $where[] = ["recommendAllowanceType", "=", $query["recommendAllowanceType"]];
        }
        if ($query["publicState"]) {
            $where[] = ["publicState", "=", $query["publicState"]];
        }
        if (\StrUtil::isNotEmpAndNull($query["introductionMode"])) {
            $where[] = ["introductionMode", "=", $query["introductionMode"]];
        }
        if (\StrUtil::isNotEmpAndNull($query["firstJJStartTime"])) {
            $where[] = ["firstInJJTime", ">=", $query["firstJJStartTime"]];
        }
        if (\StrUtil::isNotEmpAndNull($query["firstJJEndTime"])) {
            $where[] = ["firstInJJTime", "<=", $query["firstJJEndTime"]];
        }
        if ($process == 4) {
            if ($query["isSupple"]) {
                $where[] = ["isSupple", "=", $query["isSupple"]];
            }
            if ($query["isPublicCheck"]) {
                $where[] = ["isPublicCheck", "=", $query["isPublicCheck"]];
            }
        }
        if ($query["checkState"]) {
            if ($query["checkState"] == -1) {
                $where[] = ["checkState", "=", $query["checkState"]];
            } else {
                if ($process == 1) {
                    switch ($query["checkState"]) {
                        case 0:     //保存未提交
                            $where[] = ["checkState", "=", 1];
                            break;
                        case 1:
                            $where[] = ["checkState", "=", 5];
                            break;
                        case 2:     //驳回
                            $where[] = ["checkState", "=", 10];
                            break;
                        case 3:     //通过
                            $where[] = ["checkState", "in", [15, 20, 30, 25]];
                            break;
                        case 4:     //重新提交
                            $where[] = ["checkState", "=", 5];
                            $where[] = ["highProcess", ">=", $process];
                            break;
                        case 5:     //上级驳回
                            $where[] = ["checkState", "=", 13];
                            break;
                    }
                }
                if ($process == 2) {
                    switch ($query["checkState"]) {
                        case 1:
                            $where[] = ["checkState", "=", 15];
                            break;
                        case 2:     //驳回
                            $where[] = ["checkState", "in", [1, 5, 10]];
                            $where[] = ["highProcess", ">=", $process];
                            break;
                        case 3:     //通过                            
                            $where[] = ["checkState", "in", [20, 30]];
                            break;
                        case 9:   //重新提交                            
                            $where[] = ["checkState", "=", 15];
                            $where[] = ["highProcess", ">=", $process];
                            break;
                        case 4:     //上级驳回                            
                            $where[] = ["checkState", "=", 25];
                            break;
                        case -1:
                            $where[] = ["checkState", "=", -1];
                            break;
                    }
                }
                if ($process == 3) {
                    switch ($query["checkState"]) {
                        case -1:
                            $where[] = ["checkState", "=", -1];
                            break;
                        case 1:
                            $where[] = ["checkState", "=", 20];
                            break;
                        case 2:     //驳回 
                            $where[] = ["checkState", "in", [1, 5, 10, 15, 25]];
                            $where[] = ["highProcess", ">=", $process];
                            break;
                        case 3:     //通过 
                            $where[] = ["checkState", "=", 30];
                            break;
                        case 9:     //重新提交 
                            $where[] = ["checkState", "=", 20];
                            $where[] = ["highProcess", ">=", $process];
                            break;
                        case 4:     //上级驳回 
                            $where[] = ["checkState", "=", 35];
                            break;
                    }
                }
                if ($process == 4) {
                    switch ($query["checkState"]) {
                        case -1:
                            $where[] = ["checkState", "=", -1];
                            break;
                        case 3:     //通过 
                            $where[] = ["checkState", "=", 30];
                            break;
                    }
                }
            }
        }
        return $where;
    }

    private function translateToChinese(&$obj) {
        if (\StrUtil::isNotEmpAndNull($obj["address"])) {
            $obj["addressName"] = DictApi::findByParentCodeAndCode("street", $obj["address"])["name"];
        }
        if (\StrUtil::isNotEmpAndNull($obj["talentType"])) {
            $obj["talentTypeName"] = DictApi::findByParentCodeAndCode("enterprise_tag", $obj["talentType"])["name"];
        }
        if (\StrUtil::isNotEmpAndNull($obj["talentArrange"])) {
            $obj["talentArrangeName"] = DictApi::findByParentCodeAndCode("talent_arrange", $obj["talentArrange"])["name"];
        }
        if (\StrUtil::isNotEmpAndNull($obj["identifyCondition"])) {
            $obj["identifyConditionText"] = \app\common\api\TalentConditionApi::getOne($obj["identifyCondition"])["name"];
        }
        if (\StrUtil::isNotEmpAndNull($obj["introductionMode"])) {
            $obj["introductionModeName"] = DictApi::findByParentCodeAndCode("import_way", $obj["introductionMode"])["name"];
        }
    }

    private function translateChinese($list) {
        //获取字典表
        $levelMap = DictApi::selectByParentCode("talent_arrange");
        $talentTypeMap = DictApi::selectByParentCode("enterprise_tag");
        $streetMap = DictApi::selectByParentCode("street");
        $cardTypeMap = DictApi::selectByParentCode("card_type");
        $modeMap = DictApi::selectByParentCode("import_way");
        $where = [];
        $where[] = ["type", "=", $this->user["type"]];
        $where[] = ["id", "in", array_column($list, "identifyCondition")];
        $icmap = \app\common\model\TalentCondition::where($where)->column("name", "id");
        foreach ($list as &$info) {
            if (\StrUtil::isNotEmpAndNull($info["talentArrange"])) {
                $info["talentArrangeName"] = $levelMap[$info["talentArrange"]];
            }
            $info["talentTypeName"] = $talentTypeMap[$info["talentType"]];
            if (\StrUtil::isNotEmpAndNull($info["identifyCondition"])) {
                $info["identifyConditionText"] = $icmap[$info["identifyCondition"]];
            }
            $info["addressName"] = $streetMap[$info["address"]];
            $info["sexName"] = $info["sex"] == 1 ? "男" : "女";
            $info["checkStateName"] = AllowanceStateEnum::getStateName($info["checkState"]);
            $info["cardTypeName"] = $cardTypeMap[$info["cardType"]];
            $info["isSuppleName"] = $info["isSupple"] == 1 ? "是" : "否";
            $info["isPublicCheckName"] = $info["isPublicCheckName"] == 1 ? "是" : "否";
            $info["recomendAllowanceTypeName"] = \app\common\state\AllowanceTypeEnum::getTypeName($info["recomendAllowanceType"]);
            $info["allowanceTypeName"] = \app\common\state\AllowanceTypeEnum::getTypeName($info["allowanceType"]);
            $info["recommendTalentArrangeName"] = $levelMap[$info["recommendTalentArrange"]];
            $info["jtTalentArrangeName"] = $levelMap[$info["jtTalentArrange"]];
            $info["introductionModeName"] = $modeMap[$info["introductionMode"]];
        }unset($info);
        return $list;
    }

}