project/app/user/controller/Company.php

<?php


namespace app\user\controller;


use think\App;
class Company extends Base{
    public function __construct(App $app) {
        parent::__construct($app);
        $this->model=new \app\user\model\Headquarters();
    }
    /**
    * @return \think\Response|\think\response\Json
    * @throws \think\db\exception\DbException
     */
    public function list(){
        $post = $this->request->param(['code' => '', 'name' => '', 'status' => '', 'page' => 1, 'size' => 10, 'level' =>
         '1', 'account_id' => '', 'type' =>[]], 'post');
        $condition = [['is_del', '=', 0]];
        if ($post['code'] != '') $condition[] = ['code', 'like', "%{$post['code']}%"];
        if ($post['name'] != '') $condition[] = ['name', 'like', "%{$post['name']}%"];
        if ($post['status'] != '') $condition[] = ['status', '=', $post['status']];
        if ($this->level != 1  && $post['level'] != 1) $condition[] = ['code', 'in', function ($query) use ($post) {
            return $query->name('account_company')->where(['account_id'=>$this->uid,"is_del"=>0,'status'=>1])
            ->column('companyCode');
        }];
        if (!empty($post['type'])) $condition[] = ['type', 'in', $post['type']];
        $list = $this->model->field('id,code,name,type,status,addtime,relation_code')->where($condition)->order('id', 'desc')->paginate( ['page' => $post['page'], 'list_rows'
         => $post['size']]);
        return success('获取成功', ["list"=>$list->items(),"count"=>$list->total()]);
    }
    /**
    * @return \think\Response|\think\response\Json
    * @throws \think\db\exception\DataNotFoundException
    * @throws \think\db\exception\DbException
    * @throws \think\db\exception\ModelNotFoundException
     */
    public function query(){
        $post = $this->request->param(['code' => '', 'name' => '', 'status' => '', 'level' =>1, 'size' => 100,  'type' =>[]], 'post');
        $condition = [['is_del', '=', 0]];
        if ($post['code'] != '') $condition[] = ['code', 'like', "%{$post['code']}%"];
        if ($post['name'] != '') $condition[] =['name', 'like', "%{$post['name']}%"];
        if ($post['status'] != '') $condition[] = ['status', '=', $post['status']];
        if ($this->level != 1 && $post['level'] != 1) $condition[] = ['code', 'in', function ($query) use ($post) {
            return $query->name('account_company')->where(['account_id'=>$this->uid,'is_del'=>0,'status'=>1])
            ->column('companyCode');
        }];
       if (!empty($post['type'])) $condition[] = ['type', 'in', $post['type']];
        $list = $this->model->field('id,code,name,type,status,addtime,relation_code,length(name) len_name')->where
        ($condition)->order('len_name', 'asc')->select();
        return success('获取成功', $list);
    }

    public function companyType(){
        $param = $this->request->only(['company_type' => '', 'status' => ''], 'post', 'trim');
        $where=[["is_del","=",0]];
        if ($param['company_type'] != '') $where[] = ['company_type', 'like', "%{$param['company_type']}%"];
        if ($param['status'] !== '') $where[] = ['status', '=', $param['status']];
        $list = \app\user\model\CompanyType::where($where)->order('id', 'desc')->select();
        return success('获取成功', $list);
    }

}