where('name', 'like', '%'.$postdata["keyword"].'%'); } if(!empty($postdata["category_id"])){ if($postdata["category_id"] == '-1'){ //根据分类匹配 $category_ids = (new ProjectModel())->where('user_id','=',$user_id) ->where('project_type','=',$postdata["product_type"]) ->column('category_id'); if(!empty($category_ids)){ $model = $model->where('category_id', 'in', $category_ids); } }else{ $model = $model->where('category_id', '=', $postdata["category_id"]); } } $list = $model->with(['category','user'])->where('is_delete', '=', 0) ->where('project_type', '=', $postdata["product_type"]) ->where('status', '=', 1) ->where('is_show', '=', 1) ->where('user_id', '<>', $user_id) ->order(['create_time' => 'desc']) ->paginate($postdata); foreach($list as &$val){ if($postdata["product_type"] == 0){ $release_user = DemandUserModel::detail($val['user_id'],['grade']); }else{ $release_user = SupplyUserModel::detail($val['user_id'],['grade']); } $val['grade'] = empty($release_user['grade']) ? '' : $release_user['grade']; $image_list = ReleaseProjectImageModel::getImage($val["project_id"]); $val['image'] = empty($image_list[0]) ? '/static/default.png' : $image_list[0]['file_path']; } return $list; } /** * 获取列表 */ public function getIndexList($user, $show_num=2) { $model = $this; if(!empty($user)){ //根据分类匹配 $category_ids = (new ProjectModel())->where('user_id','=',$user['user_id']) ->column('category_id'); if(!empty($category_ids)){ $model = $model->where('category_id', 'in', $category_ids); } } $list = $model->with(['category','user'])->where('is_delete', '=', 0) ->where('status', '=', 1) ->where('is_show', '=', 1) ->order(['create_time' => 'desc']) ->paginate($show_num); foreach($list as &$val){ if($val["product_type"] == 0){ $release_user = DemandUserModel::detail($val['user_id'],['grade']); }else{ $release_user = SupplyUserModel::detail($val['user_id'],['grade']); } $val['is_check'] = empty($release_user['is_check']) ? 0 : $release_user['is_check']; $val['grade'] = empty($release_user['grade']) ? '' : $release_user['grade']; $image_list = ReleaseProjectImageModel::getImage($val["project_id"]); $val['image'] = empty($image_list[0]) ? '/static/default.png' : $image_list[0]['file_path']; } return $list; } }