report/app/admin/controller/TalentWorkUnitChange.php

<?php

namespace app\admin\controller;

use app\admin\common\AdminController;
use app\common\model\TalentWorkUnitChange as TwcModel;
use app\common\api\DictApi;
use app\common\state\MainState;
use app\common\model\TalentLog;
use app\common\state\ProjectState;
use think\facade\Db;
use app\common\api\EnterpriseApi;

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

    public function index() {
        return view("", ["type" => $this->user["type"]]);
    }

    public function list() {
        $params = $this->request->param();
        $offset = $params["offset"] ?: 0;
        $order = $params["order"] ?: "desc";
        $limit = $params["limit"] ?: 10;
        $where = $this->setTalentWorkunitChange($params);
        $where[] = ["type", "=", $this->user["type"]];
        $where[] = ["delete", "=", 0];
        //获取字典表人才层次
        $levelMap = DictApi::selectByParentCode("talent_arrange");
        $epMaps = \app\common\model\Enterprise::column("name", "id");
        $count = TwcModel::where($where)->count();
        $list = TwcModel::where($where)->limit($offset, $limit)->order("createTime {$order}")->select()->toArray();
        foreach ($list as $key => $item) {
            $list[$key]["talentArrangeName"] = $levelMap[$item["talentArrange"]];
            $list[$key]["oldEnterpriseName"] = $epMaps[$item["oldEnterpriseId"]];
            $list[$key]["newEnterpriseName"] = $epMaps[$item["newEnterpriseId"]];
            if ($item["checkState"] == -2) {
                $list[$key]["checkStateName"] = "审核不通过";
            }
            if ($item["checkState"] == -1) {
                $list[$key]["checkStateName"] = "待提交";
            }
            if ($item["checkState"] == 1) {
                $list[$key]["checkStateName"] = "待审核";
            }
            if ($item["checkState"] == 2) {
                $list[$key]["checkStateName"] = "审核驳回";
            }
            if ($item["checkState"] == 3) {
                $list[$key]["checkStateName"] = "已通过";
            }
            if ($item["checkState"] == 9) {
                $list[$key]["checkStateName"] = "重新提交";
            }
        }

        return json(["rows" => $list, "total" => $count]);
    }

    public function check() {
        $id = $this->request["id"];
        $info = TwcModel::where("id", $id)->find();
        $info["talentArrangeName"] = DictApi::selectByParentCode("talent_arrange")[$info["talentArrange"]];
        $epOld = EnterpriseApi::getOne($info["oldEnterpriseId"]);
        $epNew = EnterpriseApi::getOne($info["newEnterpriseId"]);
        $info["oldEnterpriseName"] = $epOld["name"];
        $info["newEnterpriseName"] = $epNew["name"];
        return view("check", ["type" => $this->user["type"], "row" => $info]);
    }

    public function submitToCheck() {
        $responseObj = new \stdClass();
        $responseObj->code = 500;
        $id = $this->request["id"];
        $checkState = $this->request["checkState"];
        $checkMsg = $this->request["checkMsg"];
        $info = TwcModel::where("id", $id)->find();
        if (!$info) {
            $responseObj->msg = "系统错误，请联系管理员";
            return $responseObj;
        }
        if (!$checkState) {
            $responseObj->msg = "请选择审核状态";
            return $responseObj;
        }
        $tmpState = $checkState == -2 ? -1 : $checkState;
        Db::startTrans();
        try {
            //添加日志
            $user = $this->user;
            $log["id"] = getStringId();
            $log["active"] = 1;
            $log["state"] = $tmpState;
            $log["step"] = 11;
            $log["stateChange"] = MainState::getStateName($info["checkState"]) . "->" . MainState::getStateName($tmpState);
            $log["type"] = ProjectState::WORKCHANGE;
            $log["mainId"] = $id;
            $log["description"] = $checkMsg;
            $log["createUser"] = $user ? sprintf("%s(%s)", $user["account"], $user["companyName"] ?: $user["rolename"]) : "系统";
            $log["createTime"] = date("Y-m-d H:i:s");
            $updWorkChange["id"] = $id;
            $updWorkChange["checkState"] = $checkState;
            $updWorkChange["checkMsg"] = $checkMsg;
            if ($checkState == 3) {
                //修改人才库信息
                $upd["id"] = $info["talentId"];
                $upd["enterprise_id"] = $info["newEnterpriseId"];
                $upd["labor_contract_rangetime"] = $info["starttime"] . " - " . $info["endtime"];
                $upd["cur_entry_time"] = $info["anyTime"];
                $upd["active"] = 1;
                $upd["cur_quit_time"] = null;
                $upd["position"] = $info["newPost"];
                Db::table("new_talent_info")->save($upd);

                $talentLog["id"] = getStringId();
                $talentLog["active"] = 1;
                $talentLog["step"] = 21;
                $talentLog["type"] = ProjectState::TALENT;
                $talentLog["mainId"] = $info["talentId"];
                $talentLog["description"] = "工作单位变更通过，同步到人才库";
                $talentLog["createUser"] = $user ? sprintf("%s(%s)", $user["account"], $user["companyName"] ?: $user["rolename"]) : "系统";
                $talentLog["createTime"] = date("Y-m-d H:i:s");
                Db::table("new_talent_checklog")->insert($talentLog);
                $updWorkChange["passTime"] = date("Y-m-d H:i:s");
            }
            Db::table("new_talent_checklog")->insert($log);
            Db::table("un_talent_workunit_change")->save($updWorkChange);
            $responseObj->code = 200;
            $responseObj->msg = "审核成功";

            Db::commit();
            return $responseObj;
        } catch (\think\db\exception\DbException $e) {
            $responseObj->msg = $e->getMessage();
            Db::rollback();
            return $responseObj;
        }
    }

    private function setTalentWorkunitChange($twcInfo) {
        $where = [];
        if (\StrUtil::isNotEmpAndNull($twcInfo["talentName"])) {
            $where[] = ["talentName", "=", $twcInfo["talentName"]];
        }
        if (\StrUtil::isNotEmpAndNull($twcInfo["idCard"])) {
            $where[] = ["idCard", "=", $twcInfo["IdCard"]];
        }
        if (\StrUtil::isNotEmpAndNull($twcInfo["oldEnterpriseName"])) {
            $whr = [];
            $whr[] = ["name", "like", "%{$params["oldEnterpriseName"]}%"];
            $ids = \app\common\model\Enterprise::where($whr)->column("id");
            $where[] = ["oldEnterpriseId", "in", $ids];
        }
        if (\StrUtil::isNotEmpAndNull($twcInfo["newEnterpriseName"])) {
            $whr = [];
            $whr[] = ["name", "like", "%{$params["newEnterpriseName"]}%"];
            $ids = \app\common\model\Enterprise::where($whr)->column("id");
            $where[] = ["newEnterpriseId", "in", $ids];
        }
        if ($twcInfo["checkState"] != null) {
            $where[] = ["checkState", "=", $talentQuitInfo["checkState"]];
        }
        return $where;
    }

}