public static function getSearch($input = array()) { $result = Product::where(function ($query) use($input) { if (!empty($input['category_id'])) { $query = $query->where('category_id', $input['category_id']); } if (!empty($input['type_id'])) { $query = $query->where('type_id', $input['type_id']); } if (!empty($input['price_id'])) { $query = $query->where('price_id', $input['price_id']); } if (!empty($input['time_id'])) { $inputDate = getTime($input['time_id']); $query = $query->where('start_time', '>=', $inputDate); } if (!empty($input['city_id'])) { $query = $query->where('city_id', $input['city_id']); } if (!empty($input['city'])) { $query = $query->where('city', $input['city']); } if (!empty($input['name'])) { $query = $query->where('name', 'like', '%' . $input['name'] . '%'); } //lat long $query = $query->where('status', ACTIVE); })->select(listFieldProduct())->get(); foreach ($result as $key => $value) { $value->avatar = url(PRODUCT_UPLOAD . '/' . $value->user_id . '/' . Product::find($value->id)->avatar); $value->block = Common::checkBlackList(Input::get('user_id'), $value->user_id); } return $result; }
public static function getProductDeleted($input = array()) { $result = Product::onlyTrashed()->where('user_id', $input['user_id'])->select(listFieldProduct())->orderBy('position', 'asc')->get(); foreach ($result as $key => $value) { $value->avatar = url(PRODUCT_UPLOAD . '/' . $value->user_id . '/' . $value->avatar); $value->block = Common::checkBlackList(Input::get('user_id'), $value->user_id); } return $result; }