jili2/application/api/controller/v1/Cate.php

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

class Cate extends Base
{

    public function cateList(){
        $deptId = input('deptId/d',0);
        if ($deptId > 0){
            $map[] = ['','exp',Db::raw('FIND_IN_SET('.$deptId.',deps)')];
        }
        $map = !empty($map)?$map:true;
        $list = Db::name('cate')
            ->where('enable',1)
            ->where('del',0)
            ->field('id,title,price')
            ->where('org_id',$this->orgId)
            ->where($map)
            ->select();
        if (!$list){
            $list = Db::name('cate')
                ->where('enable',1)
                ->where('del',0)
                ->field('id,title,price')
                ->where('org_id',$this->orgId)
                ->where('deps','=','')
                ->select();
        }
        $list = $list?$list:[];
        HelpHander::success($list);
    }

}