// +---------------------------------------------------------------------- declare (strict_types=1); namespace app\api\model; use app\common\library\helper; use app\common\model\Region; use app\common\model\School as SchoolModel; /** * 学校模型类 * Class School * @package app\api\model */ class School extends SchoolModel { protected $globalScope = ['']; /** * 隐藏字段 * @var array */ protected $hidden = [ 'update_time' ]; /** * 获取列表 * @param array $param 查询条件 * @param int $listRows 分页数量 * @return mixed|\think\model\Collection|\think\Paginator * @throws \think\db\exception\DbException */ public function getList(array $param = [], int $listRows = 15) { // 整理查询参数 $params = array_merge($param, ['audit_status' => 1]); // 获取商品列表 $list = parent::getList($params, $listRows); if ($list->isEmpty()) { return $list; } // 隐藏冗余的字段 $list->hidden(array_merge($this->hidden, ['albums'])); // 整理列表数据并返回 return $this->setListDataFromApi($list); } /** * 设置展示的数据 api模块 * @param $info * @return mixed */ private function setListDataFromApi($info) { $specialityModel = new SchoolSpeciality; return $this->setListData($info, function ($data) use($specialityModel) { $data['speciality'] = $specialityModel->getHots($data['id']); // 整理数据 api模块 $this->setDataFromApi($data); }); } /** * 整理数据 api模块 * @param $info * @return mixed */ private function setDataFromApi($info) { return $this->setData($info, function ($data) { // logo封面 $data['logo'] = $data['logo']? getPreview($data['logo']) : ''; $data['labels'] = $data['labels']? explode(',', $data['labels']) : []; // 图片列表 $data['albums'] = helper::getArrayColumn($data['albums'], 'album_url'); // 地区 $data['province_name'] = $data['province_id']? Region::getNameById($data['province_id']) : ''; $data['city_name'] = $data['city_id']? Region::getNameById($data['city_id']) : ''; $data['region_name'] = $data['region_id']? Region::getNameById($data['region_id']) : ''; // 分类等级 $data['education_levels_text'] = isset($this->levelTypes[$data['education_levels']])? $this->levelTypes[$data['education_levels']] : '无'; // 距离 if(!is_null($data['distance'])){ $data['distance'] = $data['distance']? ($data['distance']<1000? "{$data['distance']}m" : ($data['distance']/1000).'km') :''; } // 浏览数 if(!is_null($data['views'])){ $data['views'] = $data['views']? ($data['views']<10000? "{$data['views']}" : round($data['views']/10000,1).'w') :''; } }); } /** * 获取选项列表 * @param array $param 查询条件 * @param int $listRows 分页数量 * @return mixed|\think\model\Collection|\think\Paginator * @throws \think\db\exception\DbException */ public function getOptionList(array $param = [], string $field='') { return $this->where(['audit_status'=> 1]) ->where(function ($query) use ($param){ $keyword = isset($param['keyword'])? trim($param['keyword']) : ''; if($keyword){ $query->where('school_name','like',"%{$keyword}%"); } }) ->field($field?:'id,school_name,type,level,hot_order') ->order('hot_order desc,views desc') ->select(); } /** * 获取学校信息 * @param $where * @param array $with * @return static|array|false|null */ public static function detail($where, array $with = []) { $filter = []; if (is_array($where)) { $filter = array_merge($filter, $where); } else { $filter['id'] = (int)$where; } $data = static::get($filter, $with); $data->hidden(['book_fields']); if($data['logo']){ $data['logo'] = getPreview($data['logo']); } return $data; } /** * 获取用户所属招生学校 * @param $userId * @param string $field * @return mixed */ public static function getUserSchool($userId, $field=''){ $model = new SchoolModel; return $model->userSchool($userId, $field??'id, school_name'); } }