['type', 'source'], '%like%' => ['name'] ]; } /** * @notes 额外查询处理 * @return array * @author 段誉 * @date 2024/2/7 10:26 */ public function queryWhere(): array { $where = []; // 如果cid为0则为未分组 if("0" === $this->params['cid']){ $where[] = ['cid', '=', '0']; } if (!empty($this->params['cid'])) { $cateChild = FileLogic::getCateIds($this->params['cid']); $cateChild[] = (int)$this->params['cid']; $where[] = ['cid', 'in', $cateChild]; } $where['tenant_id'] = $this->adminInfo['tenant_id']; return $where; } /** * @notes 获取文件列表 * @return array * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @author 段誉 * @date 2021/12/29 14:27 */ public function lists(): array { $lists = (new TenantFile())->field(['id,cid,type,name,uri,create_time']) ->order('id', 'desc') ->where($this->searchWhere) ->where($this->queryWhere()) // ->where('source', FileEnum::SOURCE_ADMIN) ->limit($this->limitOffset, $this->limitLength) ->select() ->toArray(); foreach ($lists as &$item) { $item['url'] = FileService::getFileUrl($item['uri']); } return $lists; } /** * @notes 获取文件数量 * @return int * @author 段誉 * @date 2021/12/29 14:29 */ public function count(): int { return (new TenantFile())->where($this->searchWhere) ->where($this->queryWhere()) // ->where('source', FileEnum::SOURCE_ADMIN) ->count(); } }