useraccount/app/controller/UserCompany.php

<?php

namespace app\controller;

use app\BaseController;
use app\model\Account;
use app\model\AccountCompany;
use think\Exception;
use think\facade\Db;
use think\facade\Validate;

//【公司账号查询】
class UserCompany extends BaseController
{

    //列表
    public function getList()
    {
        $post = $this->request->only(['nickname' => '', 'username' => '', 'status' => '', 'page' => 1, 'size' => 10], 'post');
        $condition = [['a.is_del', '=', 0]];

        if ($post['nickname'] != '') $condition[] = ['b.nickname', 'like', "%{$post['nickname']}%"];
        if ($post['username'] != '') $condition[] = ['c.username', 'like', "%{$post['username']}%"];
        if ($post['status'] != '') $condition[] = ['a.status', '=', $post['status']];

        $count = Db::name('account_company')
            ->alias('a')
            ->leftJoin('user b', 'a.account_id=b.account_id')
            ->leftJoin('account c', 'c.id=a.account_id and c.is_del=0')
            ->where($condition)
            ->count('a.id');

        $list = Db::name('account_company')
            ->alias('a')
            ->field('a.id,a.account_id,a.companyCode,a.companyName,a.company_type,a.is_main,a.status com_status,c.username,c.mobile,c.source,c.status account_status,b.nickname,b.sex,b.email,c.addtime,c.updatetime')
            ->leftJoin('user b', 'a.account_id=b.account_id')
            ->leftJoin('account c', 'c.id=a.account_id and c.is_del=0')
            ->where($condition)
            ->page($post['page'], $post['size'])
            ->order('a.addtime desc')
            ->select()
            ->toArray();

        return json_show(0, '获取成功', ['list' => $list, 'count' => $count]);
    }

    //编辑
    public function update()
    {
        $post = $this->request->only(['id', 'nickname', 'mobile', 'email' => '', 'portrait' => '', 'sex' => '',], 'post');
        $validate = Validate::rule([
            'id|主键ID' => 'require|number|gt:0',
            'nickname|名称' => 'require|max:255',
            'mobile|手机号' => 'require|number|length:11|mobile',
            'email|名称' => 'email',
            'sex|性别' => 'number|in:0,1,2',
        ]);
        if ($validate->check($post) == false) return json_show(1004, $validate->getError());
        $account = Db::name('account')
            ->field('id')
            ->where([['id', '=', $post['id']], ['is_del', '=', 0]])
            ->findOrEmpty();
        if (empty($account)) return json_show(1003, '账户不存在');

        $accountinfo = Db::name('user')
            ->field('id')
            ->where([['account_id', '=', $post['id']]])
            ->findOrEmpty();
        if (empty($accountinfo)) return json_show(1003, '账户信息不存在');

        Db::startTrans();
        try {

            Db::name('user')
                ->where($accountinfo)
                ->update([
                    'nickname' => $post['nickname'],
                    'mobile' => $post['mobile'],
                    'email' => $post['email'],
                    'portrait' => $post['portrait'],
                    'sex' => $post['sex'],
                    'updatetime' => date('Y-m-d H:i:s')
                ]);

            Db::name('account')
                ->where(['account_id', $post['id']])
                ->update([
                    'id' => $post['id'],
                    'mobile' => $post['mobile'],
                    'username' => $post['mobile'],
                    'updatetime' => date('Y-m-d H:i:s'),
                ]);

            Db::commit();
            return json_show(0, '信息修改成功');
        } catch (Exception $exception) {
            Db::rollback();
            return json_show(1005, '信息修改失败,' . $exception->getMessage());
        }

    }

    //启禁用
    public function status()
    {
        $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) == false) return json_show(1004, $validate->getError());

        Db::name('account_company')
            ->where('status', '<>', $post['status'])
            ->where(['id' => $post['id'], 'is_del' => 0])
            ->save(['status' => $post['status'], 'updatetime' => date('Y-m-d H:i:s')]);

        return json_show(0, '操作成功');

    }

    //详情
    public function info()
    {

        $id = $this->request->post('id/d', 0, 'trim');
        if ($id == 0) return json_show(1003, "参数 id 不能为空");

        $rs = Db::name('account_company')
            ->alias('a')
            ->field('a.id,a.account_id,a.companyCode,a.companyName,a.company_type,a.is_main,a.status com_status,c.username,c.mobile,c.source,c.status account_status,b.nickname,b.sex,b.email,c.addtime,c.updatetime')
            ->leftJoin('user b', 'a.account_id=b.account_id')
            ->leftJoin('account c', 'c.id=a.account_id and c.is_del=0')
            ->where(['a.id' => $id, 'a.is_del' => 0])
            ->findOrEmpty();

        if (empty($rs)) return json_show(1004, '未找到用户信息');

        return json_show(0, '获取成功', $rs);
    }


}