phpstock/app/admin/controller/User.php

<?php
declare (strict_types=1);

namespace app\admin\controller;

use think\facade\Db;
use app\admin\model\ActionLog;
use think\facade\Validate;
use app\admin\common\User as CommonUser;

//运营账户
class User extends Base
{
    //登录
    public function login()
    {
        $param = $this->request->only(['username', 'password'], 'post', 'trim');
        $val = Validate::rule([
            'username|用户名' => 'require',
            'password|密码' => 'require',
        ]);

        if (!$val->check($param)) return json_show(1004, $val->getError());

        $user = new CommonUser();
        $rs = $user->login(array_merge($param, ['plat_code' => 'cx']));

        $rs = json_decode($rs, true);

        if(!isset($rs['code'])|| $rs['code']!=0)  return json_show(1004,$rs['message']);

        $role =Db::name('user_role')
            ->where(['uid'=>$rs['data']['id'],'is_main'=>1,'is_del'=>0])
            ->findOrEmpty();

        if(empty($role)) return json_show(1004,'未开通登录权限');

        $company_name = Db::name('supplier')
            ->where(['code' => $role['companyNo']])
            ->value('name', '');

        $roleinfo = Db::name('role')
            ->where(['id' => $role['roleid']])
            ->field('role_name,level')
            ->find();

        //数据合并
        $data = array_merge($rs['data'], [
            'role_name' => $roleinfo['role_name'] ?? '',
            'company_name' => $company_name ?? '',
            'role_level' => $roleinfo['level'] ?? '',
            'role_id' => $role['roleid'] ?? '',
            'companyNo' => $role['companyNo'] ?? '',
            'company_type' => $role['company_type'] ?? '',
        ]);

        return json_show(0,'登录成功',$data);

    }


    public function list(){
        $param = $this->request->only(['nickname' => '', 'username' => '', 'status' => '', 'page' => 1, 'size' => 10, 'uid' => '', 'nuid' => '','companyNo'=>''], 'post', 'trim');

        $userCommon = new CommonUser();
        $rs = $userCommon->GetUserlist($param);

        $rs = json_decode($rs, true);
        return json_show($rs['code'], $rs['message'], $rs['data']);
    }

    //删除
    public function delete()
    {
        $param = $this->request->only(['ids'], 'post', 'trim');

        $val = Validate::rule([
            'ids' => 'require|array|max:100',
        ]);

        if (!$val->check($param)) return json_show(1004, $val->getError());

        if (in_array($this->uid, $param['ids'])) return json_show(1004, '自己不能删除自己');

        $userCommon = new CommonUser();
        $rs = $userCommon->userDelete($param);

        $rs = json_decode($rs, true);
        return json_show($rs['code'], $rs['message'], $rs['data']);
    }

    //详情
    public function userInfo()
    {
        /**
         * $post = $this->request->post();
         * $token = isset($post['token']) ? trim($post['token']) : "";
         * if ($token == "") {
         * return app_show(101, 'token不能为空');
         * }
         * $effetc = VerifyTokens($token);
         * if (!empty($effetc) && $effetc['code'] != 0) {
         * return app_show($effetc['code'], $effetc['message']);
         * }
         * $userinfo = GetUserInfo($token);
         * if (empty($userinfo) || $userinfo['code'] != 0) {
         * return app_show(102, "员工信息不存在");
         * }
         * $id = isset($post['id']) && $post['id'] !== "" ? trim($post['id']) : "";
         * if ($id == "") {
         * return error_show(1004, "id不能为空");
         * }
         * $to = GetInfoById($token, ['id' => $id]);
         * if (empty($to) || $to['code'] != 0) {
         * return app_show(1002, "员工信息不存在");
         * }
         * // $nickname = isset($to['data']['nickname']) &&$to['data']['nickname']!="" ? $to['data']['nickname'] :"" ;
         * $data = $to['data'];
         * $role = Db::name("user_role")->alias('a')->leftJoin('role b', "a.roleid = b.id")->where("a.uid", "=", $data['id'])
         * ->field("roleid,role_name,business_all,uid,a.status")->find();
         * $data['role_name'] = isset($role['role_name']) ? $role['role_name'] : "";
         * $data['roleid'] = isset($role['roleid']) ? $role['roleid'] : "";
         * $data['status'] = isset($role['status']) ? $role['status'] : '0';
         * $st = Db::name('user_business')->where(['userid' => $role['uid'], "is_del" => 0])->field('businessid,is_main')->select()->toArray();
         * $val = [];
         * if (!empty($st)) {
         * foreach ($st as $itom) {
         * $tep = [];
         * $business = Db::name('business')->where(['id' => $itom['businessid'], "is_del" => 0])->field("company,companyNo")->find();
         * $tep['company'] = isset($business['company']) ? $business['company'] : "";
         * $tep['companyNo'] = isset($business['companyNo']) ? $business['companyNo'] : "";
         * $tep['businessid'] = $itom['businessid'];
         * $tep['is_main'] = $itom['is_main'];
         * $val[] = $tep;
         * }
         * }
         * $data['business'] = $val;
         * $info = [];
         * $stn = Db::name('user_platform')->where(['uid' => $role['uid']])->find();
         * if ($stn != false) {
         * $plat = isset($stn['platform']) ? explode(",", $stn['platform']) : "";
         * if ($plat != "") {
         * $platform = Db::name('platform')->where(['id' => $plat, 'is_del' => 0])->column("id,platform_name,platform_code");
         * $info = $platform;
         * }
         *
         * }
         * $depart = Db::name("depart_user")->where([["uid", "=", $data['id']], ["is_del", "=", 0]])->column("itemid");
         * $data['depart'] = "";
         *
         * if (!empty($depart)) {
         * $deparname = Db::name("company_item")->where(["id" => $depart, "is_del" => 0])->field("id,name,depart_link")->select()->toArray();
         * if (!empty($deparname)) {
         * foreach ($deparname as $ky => $item) {
         * $deparname[$ky]['depart_code'] = array_filter(explode("-", $item['depart_link']));
         * }
         * }
         * $data['depart'] = $deparname;
         * }
         * $data['platform'] = $info;
         *
         * return app_show(0, "获取成功", $data);
         * **/

//        $id = $this->request->post('id/d', 0, "trim");

        $userCommon = new CommonUser();
        $rs = json_decode($userCommon->GetUserInfo(['id' => $this->uid]), true);

        $rs['data']['level'] = $this->level;

        return json_show($rs['code'], $rs['message'], $rs['data']);

    }

    /**
     * @param token
     * @param passwd
     * @return \think\response\Json
     * @throws \think\exception\DbException
     */
    public function resetPwd()
    {
        $post = $this->request->post();
        $token = isset($post['token']) ? trim($post['token']) : "";
        if ($token == "") {
            return error_show(101, 'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if (!empty($effetc) && $effetc['code'] != 0) {
            return error_show($effetc['code'], $effetc['message']);
        }
        $newPwd = isset($post['newpwd']) ? trim($post['newpwd']) : "";
        if ($newPwd == "") {
            return error_show(1001, '新密码不能为空');
        }
        $oldpwd = isset($post['oldpwd']) ? trim($post['oldpwd']) : "";
        if ($oldpwd == "") {
            return error_show(1002, "原密码不能为空");
        }
        $data = resetpasswd($token, ['newpwd' => $newPwd, 'oldpwd' => $oldpwd]);
        if (empty($userinfo) || $userinfo['code'] != 0) {
            return error_show($userinfo['code'], $userinfo['message']);
        } else {
            return app_show(0, "密码修改成功");
        }
    }

    public function userAll()
    {
        $post = $this->request->post();
        $token = isset($post['token']) ? trim($post['token']) : "";
        if ($token == "") {
            return app_show(101, 'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if (!empty($effetc) && $effetc['code'] != 0) {
            return app_show($effetc['code'], $effetc['message']);
        }
        if (isset($post['status']) && $post['status'] !== '') {
            $uid = Db::name("user_role")->where(["status" => 1, "is_del" => 0])->column("uid");
            if ($post['status'] == 1) {
                $post['uid'] = $uid;
            } else {
                $post['nouid'] = $uid;
            }
            unset($post['status']);
        }

        $userinfo = GetAccountall($token, $post);
        if (empty($userinfo) || $userinfo['code'] != 0) {
            return app_show(1002, "员工信息不存在");
        }
        $data = $userinfo['data'];
        $list = [];
        foreach ($data as $value) {
            $role = Db::name("user_role")->alias('a')->leftJoin('role b', "a.roleid = b.id")->where("a.uid", "=", $value['id'])
                ->field("roleid,role_name,a.status")->find();
            $value['roleid'] = isset($role['roleid']) ? $role['roleid'] : "";
            $value['role_name'] = isset($role['role_name']) ? $role['role_name'] : "";
            $depart = Db::name("depart_user")->where([["uid", "=", $value['id']], ["is_del", "=", 0]])->column("itemid");
            $value['depart'] = "";
            $value['status'] = isset($role['status']) ? $role['status'] : '0';
            if (!empty($depart)) {
                $deparname = Db::name("company_item")->where(["id" => $depart, "is_del" => 0])->field("id,name,depart_link")
                    ->select()->toArray();

                array_walk($deparname, function (&$v) {
                    $v = array_filter(explode("-", $v['depart_link']));
                });
                $value['depart'] = $deparname;
            }
            $list[] = $value;
        }
        return app_show(0, "获取成功", $list);
    }

    /**
     * @return \think\response\Json|void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function userList()
    {
        $post = $this->request->post();
        $token = isset($post['token']) ? trim($post['token']) : "";
        if ($token == "") {
            return app_show(101, 'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if (!empty($effetc) && $effetc['code'] != 0) {
            return app_show($effetc['code'], $effetc['message']);
        }
        $itemid = isset($post['itemid']) && $post['itemid'] !== "" ? intval($post['itemid']) : "";
        if ($itemid !== "") {
            $uids = Db::name("depart_user")->where([["itemid", "=", $itemid], ["is_del", "=", 0]])->column("uid");
            $post['uid'] = $uids;
        }
        if (isset($post['status']) && $post['status'] !== '') {
            $uid = Db::name("user_role")->where(["status" => 1, "is_del" => 0])->column("uid");
            if ($post['status'] == 1) {
                $post['uid'] = isset($uids) ? array_unique(array_merge($uids, $uid)) : $uid;
            } else {
                $post['nouid'] = $uid;
            }
            unset($post['status']);
        }
        $userinfo = GetList($token, $post);
        if (empty($userinfo) || $userinfo['code'] != 0) {
            return app_show($userinfo['code'], $userinfo['msg']);
        }
        $data = $userinfo['data']['list'];
        $list = [];
        foreach ($data as $value) {
            $role = Db::name("user_role")->alias('a')->leftJoin('role b', "a.roleid = b.id")->where("a.uid", "=", $value['id'])
                ->field("roleid,role_name,a.status")->find();
            $value['roleid'] = isset($role['roleid']) ? $role['roleid'] : "";
            $value['role_name'] = isset($role['role_name']) ? $role['role_name'] : "";
            $depart = Db::name("depart_user")->where([["uid", "=", $data['uid']], ["is_del", "=", 0]])->column("itemid");
            $value['depart'] = "";
            $value['status'] = isset($role['status']) ? $role['status'] : '0';
            if (!empty($depart)) {
                $deparname = Db::name("company_item")->where(["id" => $depart, "is_del" => 0])->field("id,name,depart_link")
                    ->select()->toArray();
                $value['depart'] = $deparname;
                $value['depart_code'] = [];
                if (!empty($deparname)) {
                    foreach ($deparname as $item) {
                        $value['depart_code'][] = array_filter(explode("-", $item['depart_link']));
                    }
                }
            }
            $list[] = $value;
        }
        return app_show(0, "获取成功", ["list" => $list, "count" => $userinfo['data']["count"]]);
    }

    //账户角色列表
    public function userRoleList()
    {
        $post = $this->request->only(["token" => "", "nickname" => "", "relaComNo" => "", "islevel" => "", "username" => "", "companyNo" => "", "status" => "", "page" => 1, "size" => 10], "post");
        if ($this->level == 1) {
            $companyNo = $post['companyNo'] ?? "";
        } else {
            $companyNo = $post['relaComNo'] ?? "";
            $post['companyNo'] = $post['relaComNo'] ?? "";
        }
        $where = [["a.is_del", "=", 0]];
        unset($post['relaComNo']);
        if ($post['companyNo'] != "") {
            $where[] = ["a.companyNo", "=", $companyNo];
        }
        if ($post['status'] !== '') {
            $uid = Db::name("user_role")->alias("a")->where(["status" => 1, "is_del" => 0])->where($where)->column("uid");
            if ($post['status'] == 1) {
                $where[] = ["a.status", "=", 1];
                $post['uid'] = $uid;
            } else {
                $post['nuid'] = $uid;
            }
            unset($post['status']);
        }
        if ($post["islevel"] != "") {
            $uid = Db::name("user_role")->alias("a")
                ->leftJoin("role b", "a.roleid=b.id")->where([["b.level", "=", 1], ["a.is_del", "=", 0]])->where($where)->column
                ("uid");
            if ($post['islevel'] == 1) {
                $post['uid'] = $uid;
            } else {
                $post['nuid'] = $uid;
            }
            unset($post["islevel"]);
        }
//    	var_dump($post);
//        $userinfo=GetUserList($post);
        $userCommon = new CommonUser();
        $userinfo = $userCommon->GetList($post);
        $userinfo = json_decode($userinfo, true);
        if (empty($userinfo) || $userinfo['code'] != 0) {
            return app_show($userinfo['code'], $userinfo['msg']);
        }
        $data = $userinfo['data']['list'];
        $list = [];
        foreach ($data as $value) {
            $roleArr = Db::name("user_role")->alias("a")
                ->leftJoin("role b", "a.roleid=b.id")
                ->where(["uid" => $value['id'], "a.companyNo" => $value['companyCode'], "is_del" => 0])
                ->field("role_name,roleid,a.status,b.level")->findOrEmpty();
            $value['roleid'] = $roleArr['roleid'] ?? "";
            $value['status'] = $value['status'] == 1 ? ($roleArr['status'] ?? 0) : 0;
            $value["role_name"] = $roleArr['role_name'] ?? "";
            $value["role_level"] = $roleArr['level'] ?? "";
            $list[] = $value;
        }
        return app_show(0, "获取成功", ["list" => $list, "count" => $userinfo['data']["count"]]);
    }

    //账号角色修改
    public function setRole()
    {
        $post = $this->request->only(["id" => "", "nickname" => "", "mobile" => "", "relaComNo" => "", "companyNo" => "", "roleid" => "", "token" => ""], "post", "trim");

        $valide = Validate::rule([
            "id|账户ID" => "require|number|gt:0",
            "nickname|名称" => "require|max:255",
            "mobile|手机号" => "require|mobile",
            "relaComNo|业务公司" => "max:255",
            "companyNo|业务公司" => "max:255",
            "roleid|角色ID" => "require|number",
        ]);
        if ($valide->check($post) == false) return json_show(1004, $valide->getError());
        if ($post['roleid'] != 0) {
            $roleinfo = Db::name("role")->where("id", "=", $post['roleid'])->find();
            if (empty($roleinfo)) return json_show(1002, "角色不存在");
            if ($roleinfo['status'] == 0) return json_show(1002, "角色已禁用");
            if ($roleinfo['level'] == 1) return json_show(1002, "超管级别角色不允许设置");
        }
        if ($this->level == 1) $companyNo = isset($post['companyNo']) && $post['companyNo'] !== '' ? trim($post['companyNo']) : "";
        else  $companyNo = isset($post['relaComNo']) && $post['relaComNo'] !== '' ? trim($post['relaComNo']) : "";

        if ($companyNo == "") return json_show(1004, "业务公司编号不能为空");

        $company = Db::name("supplier_info")->where(["code" => $companyNo])->find();
        if ($company == false) return json_show(1004, "业务公司不存在");

        $isSuper = Db::name("user_role")->alias("a")
            ->leftJoin("role b", "a.roleid=b.id")
            ->where(["a.uid" => $post['id'], "a.is_del" => 0, "b.level" => 1])
            ->findOrEmpty();
        if (!empty($isSuper)) return json_show(1002, "超管账户不允许设置其他角色");
        $userrole = Db::name("user_role")
            ->where(["uid" => $post['id'], "companyNo" => $companyNo, "is_del" => 0])
            ->find();
        $ismain = Db::name("user_role")->where(["uid" => $post['id'], "is_main" => 1, "is_del" => 0])->find();
        Db::startTrans();
        try {

            if (empty($userrole)) {
                $roledata = [
                    "uid" => $post['id'],
                    "roleid" => $post['roleid'],
                    "nickname" => $post['nickname'],
                    "companyNo" => $companyNo,
                    "company_type" => $company["type"] == 3 ? 2 : 1,
                    "is_main" => $ismain ? 0 : 1,
                    "status" => 1,
                    "addtime" => date("Y-m-d H:i:s"),
                    "updatetime" => date("Y-m-d H:i:s")
                ];
                $companyarr = [
                    [
                        "companyCode" => $company["code"],
                        "companyName" => $company["name"],
                        "company_type" => $company["type"] == 3 ? 2 : 1,
                        "is_main" => $ismain ? 0 : 1
                    ]
                ];

                $companyinfo = ["id" => $post['id'], "company" => $companyarr, "token" => $post['token']];

                $userCommon = new \app\admin\common\User();
                $companyset = $userCommon->handle('setcompany', $companyinfo);

                if (!isset($companyset['code']) || $companyset['code'] != 0) return json_show(1004, $companyset['message']);


                $up = Db::name("user_role")->insert($roledata);
            } else {
                $userrole['roleid'] = $post['roleid'];
                $userrole['nickname'] = $post['nickname'];
                $userrole['companyNo'] = $companyNo;
                $userrole['company_type'] = $company["type"] == 3 ? 2 : 1;
                $userrole['updatetime'] = date("Y-m-d H:i:s");
                $up = Db::name("user_role")->where(["uid" => $post['id'], "companyNo" => $companyNo, "is_del" => 0])->save($userrole);
            }
            $saveinfo = [
                "id" => $post['id'],
                "nickname" => $post['nickname'],
                "mobile" => $post['mobile'],
                "token" => $post['token']
            ];
//            $saev = resetinfo($saveinfo);
            $userCommon = new \app\admin\common\User();
            $saev = $userCommon->handle('usersave', $saveinfo);
            if (!isset($saev['code']) || $saev['code'] != 0) {
                return json_show(1004, $saev['message']);
            }
            if ($up == false) {
                Db::rollback();
                return json_show(1004, '用户信息更新失败');
            }
            Db::commit();
            return json_show(0, '用户信息更新成功');
        } catch (\Exception $e) {
            Db::rollback();
            return json_show(1004, $e->getMessage());
        }
    }

    //修改
    public function UserSave()
    {
        /**
         * $post = $this->request->post();
         * $toke = isset($post['token']) ? trim($post['token']) : "";
         * if ($toke == "") {
         * return app_show(100, "token不能为空");
         * }
         * $verify = VerifyTokens($toke);
         * if ($verify['code'] != 0) {
         * return app_show($verify['code'], $verify['message']);
         * }
         * $userid = isset($post['id']) && $post['id'] !== "" ? intval($post['id']) : "";
         * if ($userid == "") {
         * return error_show(1004, "参数id 不能为空");
         * }
         *
         * $nickname = isset($post['nickname']) ? trim($post['nickname']) : "";
         * if ($nickname == "") {
         * return app_show(1001, "昵称不能为空");
         * }
         * $mobile = isset($post['mobile']) ? trim($post['mobile']) : "";
         * if ($mobile == "") {
         * return app_show(1002, "手机号不能为空");
         * }
         * if (checkMobile($mobile) == false) {
         * return app_show(1002, "手机号格式不正确");
         * }
         * $email = isset($post['email']) ? trim($post['email']) : "";
         * $role = isset($post['role']) ? intval($post['role']) : 0;
         * if ($role != 0) {
         * $roleinfo = Db::name("role")->where("id", "=", $role)->find();
         * if (empty($roleinfo)) {
         * return error_show(1002, "角色不存在");
         * }
         * if ($roleinfo['status'] == 0) {
         * return error_show(1002, "角色已禁用");
         * }
         * }
         * $itemid = isset($post['itemid']) && $post['itemid'] !== "" ? $post['itemid'] : "";
         * $item_arr = [];
         * if ($itemid !== "") {
         * foreach ($itemid as $value) {
         * $item_arr[] = end($value);
         * }
         * $iteminfo = Db::name("company_item")->where(["id" => $item_arr, 'is_del' => 0])->select()->toArray();
         * if (empty($iteminfo)) {
         * return error_show(1002, "未找到部门信息");
         * }
         * }
         * $companyArr = isset($post['companyArr']) && !empty($post['companyArr']) ? $post['companyArr'] : "";
         * if ($companyArr == "") {
         * return error_show(1004, "参数companyArr不能为空");
         * }
         * $compArr = [];
         * foreach ($companyArr as $value) {
         * $tmp = [];
         * if (!isset($value['businessid']) || $value['businessid'] == '') {
         * return error_show(1004, "参数业务公司businessid不能为空");
         * }
         * $tmp['userid'] = $userid;
         * $tmp['businessid'] = $value['businessid'];
         * $tmp['is_main'] = isset($value['is_main']) ? $value['is_main'] : 0;
         * $tmp['is_del'] = 0;
         * $tmp['addtime'] = date("Y-m-d H:i:s");
         * $tmp['updatetime'] = date("Y-m-d H:i:s");
         * $compArr[] = $tmp;
         * }
         * $platform = isset($post['platform']) && !empty($post['platform']) ? $post['platform'] : "";
         * if ($platform == "") {
         * return error_show(1004, "参数platform不能为空");
         * }
         * $plta = Db::name("platform")->where(["id" => $platform, "is_del" => 0])->select()->toArray();
         * if (empty($plta)) {
         * return error_show(1004, "未找到可用平台");
         * }
         * $userplat = Db::name("user_platform")->where(["uid" => $userid, "is_del" => 0])->find();
         *
         * $isall = isset($post['is_all']) && $post['is_all'] !== "" ? intval($post['is_all']) : "0";
         *
         * Db::startTrans();
         * try {
         * $sc = Db::name("user_business")->where(["userid" => $userid, "is_del" => 0])->select()->toArray();
         * if (!empty($sc)) {
         * $del = Db::name("user_business")->where(["userid" => $userid, "is_del" => 0])->save(["is_del" => 1,
         * "updatetime" => date("Y-m-d H:i:s")]);
         * if ($del == false) {
         * Db::rollback();
         * return error_show(1005, '业务公司添加失败');
         * }
         * }
         * if (!empty($compArr)) {
         * $in = Db::name("user_business")->insertAll($compArr);
         * if ($in == 0) {
         * Db::rollback();
         * return error_show(1005, '业务公司添加失败');
         * }
         * }
         *
         * if ($userplat == false) {
         * $userplat = [
         * "uid" => $userid,
         * "platform" => implode(",", $platform),
         * "is_del" => 0,
         * "addtime" => date("Y-m-d H:i:s"),
         * "updatetime" => date("Y-m-d H:i:s")
         * ];
         * } else {
         * $userplat['platform'] = implode(",", $platform);
         * $userplat['updatetime'] = date("Y-m-d H:i:s");
         * }
         * $patup = Db::name("user_platform")->save($userplat);
         * if ($patup == false) {
         * Db::rollback();
         * return error_show(1005, '业务平台添加失败');
         * }
         * $userrole = Db::name("user_role")->where(["uid" => $userid, "is_del" => 0])->find();
         * if (empty($userrole)) {
         * $roledata = [
         * "uid" => $userid,
         * "roleid" => $role,
         * "status" => 1,
         * "business_all" => $isall,
         * "addtime" => date("Y-m-d H:i:s"),
         * "updatetime" => date("Y-m-d H:i:s")
         * ];
         * $up = Db::name("user_role")->insert($roledata);
         * } else {
         * $userrole['roleid'] = $role;
         * $userrole['business_all'] = $isall;
         * $userrole['updatetime'] = date("Y-m-d H:i:s");
         * $up = Db::name("user_role")->save($userrole);
         * }
         * if ($up) {
         * Db::name("depart_user")->where(["uid" => $userid])->save(['is_del' => 1]);
         * if (isset($item_arr) && !empty($item_arr)) {
         * foreach ($item_arr as $v) {
         * $depin = [
         * "uid" => $userid,
         * "nickname" => $nickname,
         * "itemid" => $v,
         * "is_del" => 0,
         * "updatetime" => date("Y-m-d H:i:s")
         * ];
         * $ist = Db::name("depart_user")->where(["uid" => $userid, "itemid" => $v])->find();
         * if ($ist) {
         * $up = Db::name("depart_user")->where(["uid" => $userid, "itemid" => $v])->save($depin);
         * } else {
         * $depin['addtime'] = date("Y-m-d H:i:s");
         * $up = Db::name("depart_user")->insert($depin);
         * }
         * if ($up == false) {
         * Db::rollback();
         * return error_show(1005, '用户部门更新失败');
         * }
         * }
         * }
         * } else {
         * Db::rollback();
         * return error_show(1005, '角色更新失败');
         * }
         * $data = [
         * "id" => $userid,
         * "nickname" => $nickname,
         * "mobile" => $mobile,
         * "email" => $email
         * ];
         * $save = resetinfo($toke, $data);
         * if (!empty($save) && $save['code'] != 0) {
         * Db::rollback();
         * return error_show($save['code'], $save['message']);
         * }
         * Db::commit();
         * return app_show(0, "更新成功");
         * } catch (\Exception $e) {
         * Db::rollback();
         * return app_show(1002, $e->getMessage());
         * }
         *
         * **/

        $post = $this->request->only(["id", "nickname", "mobile", "email" => "", "portrait" => "", "sex" => ""], "post", 'trim');
        $validate = Validate::rule([
            'id|主键ID' => 'require|number|gt:0',
            'nickname|名称' => 'require|max:255',
            'mobile|手机号' => 'require|mobile',
            'email|名称' => 'email',
            'sex|性别' => 'number|in:0,1,2',
        ]);
        if ($validate->check($post) == false) return json_show(1004, $validate->getError());

        $userCommon = new CommonUser();
        $rs = json_decode($userCommon->userSave($post), true);

        return json_show($rs['code'], $rs['message'], $rs['data']);
    }

    //修改密码
    public function setPwd()
    {
        /**
         * $post = $this->request->post();
         * $token = isset($post['token']) ? trim($post['token']) : "";
         * if ($token == "") {
         * return error_show(101, 'token不能为空');
         * }
         * $effetc = VerifyTokens($token);
         * if (!empty($effetc) && $effetc['code'] != 0) {
         * return error_show($effetc['code'], $effetc['message']);
         * }
         * $userid = isset($post['id']) && $post['id'] !== "" ? intval($post['id']) : "";
         * if ($userid == "") {
         * return error_show(1004, "参数id 不能为空");
         * }
         * $newPwd = isset($post['password']) ? trim($post['password']) : "";
         * if ($newPwd == "") {
         * return error_show(1001, '密码不能为空');
         * }
         *
         * $data = resetpwd($token, ["id" => $userid, 'password' => $newPwd]);
         * if (empty($data) || $data['code'] != 0) {
         * return error_show($data['code'], $data['message']);
         * } else {
         * return app_show(0, "密码修改成功");
         * }
         * **/
        $post = $this->request->only(["id", "password"], "post", "trim");
        $validate = Validate::rule([
            'id|账户ID' => 'require|number',
            'password|密码' => 'require|min:6|max:200',
        ]);
        if (!$validate->check($post)) return json_show(1004, $validate->getError());

        $userCommon = new CommonUser();
        $rs = json_decode($userCommon->resetPasswd($post), true);

        return json_show($rs['code'], $rs['message'], $rs['data']);
    }

    //启禁用
    public function userStatus()
    {
        /**
         * $post = $this->request->post();
         * $toke = isset($post['token']) ? trim($post['token']) : "";
         * if ($toke == "") {
         * return app_show(100, "token不能为空");
         * }
         * $verify = VerifyTokens($toke);
         * if ($verify['code'] != 0) {
         * return app_show($verify['code'], $verify['message']);
         * }
         * $userid = isset($post['id']) && $post['id'] !== "" ? intval($post['id']) : "";
         * if ($userid == "") {
         * return error_show(1004, "参数userid 不能为空");
         * }
         * $status = isset($post['status']) && $post['status'] != "" ? intval($post['status']) : "";
         *
         * if ($status === "") {
         * return error_show(1004, "参数status 不能为空");
         * }
         * if (!in_array($status, [0, 1])) {
         * return error_show(1004, "参数status无效");
         * }
         * $message = $status == 1 ? "启用" : "禁用";
         * $userinfo = Db::name("user_role")->where(["uid" => $userid, "is_del" => 0])->find();
         * if ($userinfo == false) {
         * $data = [
         * "uid" => $userid,
         * "roleid" => 0,
         * "status" => $status,
         * "is_del" => 0,
         * "addtime" => date("Y-m-d H:i:s"),
         * "updatetime" => date("Y-m-d H:i:s"),
         * ];
         * $sa = Db::name("user_role")->save($data);
         * } else {
         * $userinfo['status'] = $status;
         * $userinfo['updatetime'] = date("Y-m-d H:i:s");
         * $sa = Db::name("user_role")->save($userinfo);
         * }
         * if ($sa == false) {
         * return error_show(1005, "{$message}失败");
         * } else {
         *
         * return app_show(0, "{$message}成功");
         * }
         *
         * //        $set = resetstatus($toke,["id"=>$userid,"status"=>$status]);
         * //
         * //        if(empty($set)||$set['code']!=0){
         * //            return error_show(1005,"{$message}失败");
         * //        }else{
         * //            D
         * //            return app_show(0,"{$message}成功");
         * //        }
         * **/

        $post = $this->request->only(["id", "status"], "post", 'trim');
        $validate = Validate::rule([
            'id|主键ID' => 'require|number|gt:0',
            'status|状态' => 'require|number|in:0,1',
        ]);
        if (!$validate->check($post)) return json_show(1004, $validate->getError());

        $userCommon = new CommonUser();
        $rs = json_decode($userCommon->resetState($post), true);

        return json_show($rs['code'], $rs['message'], $rs['data']);
    }

    public function getinfo()
    {
        $post = $this->request->post();
        $token = isset($post['token']) ? trim($post['token']) : "";
        if ($token == "") {
            return app_show(101, 'token不能为空');
        }
        $effetc = VerifyTokens($token);
        if (!empty($effetc) && $effetc['code'] != 0) {
            return app_show($effetc['code'], $effetc['message']);
        }
        $userinfo = GetUserInfo($token);
        if (empty($userinfo) || $userinfo['code'] != 0) {
            return app_show(102, "员工信息不存在");
        }

        $data = $userinfo['data'];
        $role = Db::name("user_role")->alias('a')->leftJoin('role b', "a.roleid = b.id")->where("a.uid", "=", $data['id'])
            ->field("roleid,role_name,business_all,uid")->find();
        $data['role_name'] = isset($role['role_name']) ? $role['role_name'] : "";
        $data['roleid'] = isset($role['roleid']) ? $role['roleid'] : "";
        $st = Db::name('user_business')->where(['userid' => $role['uid'], "is_del" => 0])->field('businessid,is_main')->select()->toArray();
        $val = [];
        if (!empty($st)) {
            foreach ($st as $itom) {
                $tep = [];
                $business = Db::name('business')->where(['id' => $itom['businessid'], "is_del" => 0])->field("company,companyNo")->find();
                $tep['company'] = isset($business['company']) ? $business['company'] : "";
                $tep['companyNo'] = isset($business['companyNo']) ? $business['companyNo'] : "";
                $tep['businessid'] = $itom['businessid'];
                $tep['is_main'] = $itom['is_main'];
                $val[] = $tep;
            }
        }
        $data['private_field'] = [];
        if ($data['roleid'] != "") {
            $action = Db::name("role_action")->where(["role_id" => $data['roleid'], "status" => 1])->find();
            if ($action != false) {
                $data['private_field'] = isset($action['private_field']) && $action['private_field'] != "" ? explode(",",$action['private_field']) : [];
            }
        }
        $data['business'] = $val;
        $info = [];
        $stn = Db::name('user_platform')->where(['uid' => $role['uid']])->find();
        if ($stn != false) {
            $plat = isset($stn['platform']) ? explode(",", $stn['platform']) : "";
            if ($plat != "") {
                $platform = Db::name('platform')->where(['id' => $plat, 'is_del' => 0])->column("id,platform_name,platform_code");
                $info = $platform;
            }

        }
        $depart = Db::name("depart_user")->where([["uid", "=", $data['id']], ["is_del", "=", 0]])->column("itemid");
        $data['depart'] = "";
        if (!empty($depart)) {
            $deparname = Db::name("company_item")->where(["id" => $depart, "is_del" => 0])->field("id,name,depart_link")->select()->toArray();
            if (!empty($deparname)) {
                foreach ($deparname as $ky => $item) {
                    $deparname[$ky]['depart_code'] = array_filter(explode("-", $item['depart_link']));
                }
            }
            $data['depart'] = $deparname;
        }
        $data['platform'] = $info;

        return app_show(0, "获取成功", $data);
    }


    //超管账号列表
    public function userSingleList()
    {
        $post = $this->request->only(["token" => "", "nickname" => "", "relaComNo" => "", "islevel" => "", "username" => "", "companyNo" => "", "status" => "", "page" => 1, "size" => 10], "post");
        if ($this->level == 1) {
            $companyNo = $post['companyNo'] ?? "";
        } else {
            $companyNo = $post['relaComNo'] ?? "";
            $post['companyNo'] = $post['relaComNo'] ?? "";
        }
        $where = [["a.is_del", "=", 0]];
        unset($post['relaComNo']);
        if ($post['companyNo'] != "") {
            $where[] = ["a.companyNo", "=", $companyNo];
        }
        if ($post["islevel"] != "") {
            $uid = Db::name("user_role")->alias("a")
                ->leftJoin("role b", "a.roleid=b.id")->where([["b.level", "=", 1], ["a.is_del", "=", 0]])->where($where)->column
                ("uid");
            if ($post['islevel'] == 1) $post['uid'] = $uid;
             else $post['nuid'] = $uid;

            unset($post["islevel"]);
        }

        $userCommon = new \app\admin\common\User();
        $userinfo = $userCommon->GetAccountall($post);
        $userinfo = json_decode($userinfo,true);
        if (empty($userinfo) || $userinfo['code'] != 0) return app_show($userinfo['code'], $userinfo['msg']);

        $data = $userinfo['data']['list'];
        $list = [];
        foreach ($data as $value) {
            if (isset($value['company_relaton']) && !empty($value['company_relaton'])) {
                foreach ($value['company_relaton'] as &$item) {
                    $roleArr = Db::name("user_role")->alias("a")
                        ->leftJoin("role b", "a.roleid=b.id")
                        ->where(["uid" => $value['id'], "a.companyNo" => $item['companyCode'], "is_del" => 0])
                        ->field("role_name,roleid,a.status,b.level")->findOrEmpty();
                    $item['roleid'] = $roleArr['roleid'] ?? "";
                    $item['status'] = $roleArr['status'] ?? 0;
                    $item["role_name"] = $roleArr['role_name'] ?? "";
                    $item["role_level"] = $roleArr['level'] ?? "";
                }

            }

            $value['roleid'] = $roleArr['roleid'] ?? "";
            $value['status'] = $value['status'] ?? 0;
            $value["role_name"] = $roleArr['role_name'] ?? "";
            $value["role_level"] = $roleArr['level'] ?? "";
            $list[] = $value;
        }
        return app_show(0, "获取成功", ["list" => $list, "count" => $userinfo['data']["count"]]);
    }

}