['goods_status'], '%like%' => ['goods_name','goods_brand'], 'between' => ['service_total', 'service_fee'], ]; } public function queryWhere() { $where = []; $where['user_id'] = 0;//常规商品 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()) ->visible(['id','goods_name','goods_image']) ->limit($this->limitOffset, $this->limitLength) ->select() ->toArray(); 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(); } }