['goods_status'], '%like%' => ['goods_name','goods_brand'], 'between' => ['service_total', 'service_fee'], ]; } public function queryWhere() { $where = []; if (!empty($this->params['goods_category_id'])) { $goodsCategoryId = end($this->params['goods_category_id']); $goodsCategoryData = GoodsCategory::where(['status'=>1])->order(['pid' => 'asc','weigh' => 'desc', 'id' => 'desc']) ->select()->toArray(); $ids =get_tree_ids($goodsCategoryData,$goodsCategoryId); $ids[] = $goodsCategoryId; $where[] = ['goods_category_id','in' ,$ids]; } return $where; } /** * @notes 获取列表 * @return array * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @author likeadmin * @date 2024/07/07 18:37 */ public function lists(): array { $lists = Goods::order(['id' => 'desc']) ->where($this->searchWhere) ->where($this->queryWhere()) ->limit($this->limitOffset, $this->limitLength) ->select() ->toArray(); $goodsCategoryObj = GoodsCategory::where(['status'=>1])->order(['pid' => 'asc','weigh' => 'desc', 'id' => 'desc']) ->select(); foreach ($lists as &$item) { $item['goods_category_ids'] = array_map("intval",$item['goods_category_ids']); $item['goods_category_ids_str'] = implode(' / ',$goodsCategoryObj->whereIn('id', $item['goods_category_ids'])->column('name')); $item['goods_image'] = $item['goods_image'] ? FileService::getFileUrl($item['goods_image']):null; $item['goods_video'] = $item['goods_video'] ? FileService::getFileUrl($item['goods_video']):null; } return $lists; } /** * @notes 获取数量 * @return int * @author likeadmin * @date 2024/07/07 18:37 */ public function count(): int { return Goods::where($this->searchWhere)->where($this->queryWhere())->count(); } }