phpstock/app/admin/controller/UserCompanyBasic.php

<?php

namespace app\admin\controller;

use app\admin\common\User as UserCommon;
use think\Exception;
use think\facade\Db;
use think\facade\Validate;

//【公司账号管理】
class UserCompanyBasic extends Base
{
    //列表
    public function getList()
    {

        $param = $this->request->only(['nickname' => '', 'username' => '', 'status' => '', 'page' => 1, 'size' => 10,'islevel'=>1,'relaComNo'=>''], 'post', 'trim');

        //排除超管账号
        $where=[['a.is_del','=',0]];
        if($param['relaComNo'] != '') $where[]=['a.companyNo','=',$param['relaComNo']];
        $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");
        $param['uid'] = $uid;

        $userCommon = new UserCommon();

        $rs = $userCommon->handle('userCompanyBasicList', $param);

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

    //添加
    public function add()
    {
        $param = $this->request->only(['nickname', 'mobile', 'email' => '', 'companyArr' => []], 'post', 'trim');

        $val = Validate::rule([
            'nickname|真实姓名' => 'require|min:2|max:200',
            'mobile|手机号' => 'require|number|length:11|mobile',
            'email|邮箱' => 'email',
            'companyArr|关联业务公司' => 'array|max:100',
        ]);

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

        $val_company = Validate::rule([
            'companyCode|公司编码' => 'require|length:18',
            'companyName|公司名称' => 'require',
            'company_type|公司类型' => 'require|number',
            'is_main|是否默认公司' => 'require|in:0,1',
            'roleid|角色id' => 'require|number|gt:0',
            'itemid|部门id' => 'require|number|gt:0',
        ]);

        foreach ($param['companyArr'] as $company) {
            if (!$val_company->check($company)) {
                return json_show(1004, $val_company->getError());
                break;
            }
        }

        $userCommon = new UserCommon();
        $rs = $userCommon->handle('userCompanyBasicAdd', $param);

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

            Db::startTrans();
            try{
                $date = date('Y-m-d H:i:s');
                $insert_data=[];
                foreach ($param['companyArr'] as $company) {
                    $insert_data[] = [
                        'uid' => $rs['data']['uid'],
                        'nickname'=>$param['nickname'],
                        'roleid' => $company['roleid'],
                        'companyNo' => $company['companyCode'],
                        'company_type' => $company['company_type'],
                        'itemid' => $company['itemid'],
                        'status' => 1,
                        'is_main' => $company['is_main'],
                        'is_del' => 0,
                        'addtime' => $date,
                        'updatetime' => $date,
                    ];
                }

                Db::name('user_role')->insertAll($insert_data);

                Db::commit();
                return json_show($rs['code'], $rs['message'], $rs['data']);
            }catch (Exception $exception){
                Db::rollback();
                return json_show(1004,'账户注册失败,'.$exception->getMessage());
            }
        }
    }

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

        $val = Validate::rule(['ids|账号ID' => 'require|array|max:100']);
        if (!$val->check($param)) return json_show(1004, $val->getError());

        $userCommon = new UserCommon();
        $rs = $userCommon->handle('userCompanyBasicDelete', $param);

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

    //编辑
    public function update()
    {
        $param = $this->request->only(['id', 'nickname', 'mobile', 'email' => '', 'portrait' => '', 'sex' => '',], 'post');

        $userCommon = new UserCommon();
        $rs = $userCommon->handle('userCompanyBasicUpdate', $param);

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

    //启禁用
    public function status()
    {
        $param = $this->request->only(['id', 'status'], 'post', 'trim');

        $userCommon = new UserCommon();
        $rs = $userCommon->handle('userCompanyBasicStatus', $param);

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

    //修改密码
    public function password()
    {
        $param = $this->request->only(['id', 'password'], 'post', 'trim');

        $userCommon = new UserCommon();
        $rs = $userCommon->handle('setpasswd', $param);

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

    //详情
    public function info(){

        $param = $this->request->only(['id'], 'post', 'trim');

        $userCommon = new UserCommon();

        $rs = $userCommon->handle('userCompanyBasicInfo', $param);

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


}