guoyao-jiankang/application/api/controller/v1/Dep.php

<?php
namespace app\api\controller\v1;
use app\api\controller\Base;
use app\hander\HelpHander;
use think\Db;

class Dep extends Base
{
    public function cateList(){
        $lists = Db::name('dep_cate')
            ->field('id,title')
            ->where('org_id',$this->orgId)
            ->where('enable',1)
            ->where('del',0)
            ->select();
        array_unshift($lists,['id'=>0,'title'=>'未分组']);
        HelpHander::success($lists);
    }
    public function list(){
        $cateId = input('cate_id',-1);
        $lists = Db::name('dep')
            ->field('id,title')
            ->where('org_id',$this->orgId)
            ->where('cate_id',$cateId)
            ->where('enable',1)
            ->where('del',0)
            ->where('is_show',0)
           ->select();
        HelpHander::success($lists);
    }

    public function userByDep(){
        $depId = input('depId/d',0);
        $lists = Db::name('user')
            ->alias('u')
            ->field('u.id,u.account,u.real_name,u.mobile,u.head_image')
            ->join('user_dep ud','ud.user_id=u.id')
            ->where('u.del',0)
            ->where('u.del',0)
            ->where('ud.dep_id',$depId)
            ->select();

        HelpHander::success($lists);
    }


}