thinkphp之接口查询返回指定字段(4)

叁歲伎倆 2022-04-05 09:46 417阅读 0赞

查询一个驾校的相关业务员，入参驾校id。

/**
         * 获取驾校相关业务员
         */
        public function querySchoolSaleman(){
            $request = Request::instance();
            if ($request->isGet()) {
                $param['schoolId'] = $request->get('schoolId');
                $ret = ApiResultUtils::isEmpty($param);
                if ($ret) {
                    return $ret;
                }
                $schoolId = $request->get('schoolId');
    
                //检测驾校是否存在
                $schoolDAO = new schoolInfo();
                $schoolInfo = $schoolDAO->querySchoolInfoById($schoolId);
                if (empty($schoolInfo)) {
                    return ApiResultUtils::ofFail('驾校信息不存在');
                }
    
                $stuDAO = new StudentInfo();
                $saleman = $stuDAO->querySalemanBySchoolId($schoolId);
                $sa = array();
                foreach ($saleman as $arr) {
                    //假如salesman_id字段为空,则执行if语体里的语句
                    if (empty($arr['salesman_id'])) {
                        continue;
                    }
                    if (empty($arr['salesman_name'])) {
                        continue;
                    }
                    $sa[] = $arr;
                }
                if (empty($sa)) {
                    return ApiResultUtils::ofFail('没有数据');
                }
    
                return ApiResultUtils::ofSuccess($sa);
            } else {
                return ApiResultUtils::ofFail('http error,need GET');
            }
            
        }

model

public function querySchoolInfoById($schoolId){
    		if (empty($schoolId)) {
    			return null;
    		}
    
    		$schoolInfo = $this->db('school_info')->where('id',$schoolId)->find();
    		return $schoolInfo;
    	}
    
    public function querySalemanBySchoolId($schoolId){
    		if (empty($schoolId)) {
    			return null;
    		}
    
    		$saleman = $this->db('student_info')
                            //要返回的字段
    			->field(['salesman_id','salesman_name','salesman_mobile'])
    			->where('school_id',$schoolId)
                            //去重
    			->distinct(true)
    			->select();
    
    		return $saleman;
    	}