/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index($variable_search) { $variable_search = urldecode($variable_search); $resultDBArray = Place::select('place_id', 'place_name', 'place_city')->whereRaw("MATCH(place_name) AGAINST(? IN BOOLEAN MODE)", array($variable_search))->orderBy('views')->get(); if (count($resultDBArray) > 0) { $resultJSON["success"] = "1"; $resultJSON["items"] = $resultDBArray; for ($i = 0; $i < count($resultDBArray); $i++) { $place_id = $resultJSON["items"][$i]['place_id']; $city_id = $resultJSON["items"][$i]['place_city']; $resultDBImages = $this->getImages($place_id); $city_nameArray = $this->getCityName($city_id); $resultJSON["items"][$i]['place_city'] = $city_nameArray['city_name']; $resultJSON["items"][$i]['images'] = $resultDBImages; } } else { $resultJSON["success"] = "0"; } echo json_encode($resultJSON); }
public function place($place_id = null) { $resultDBArray = Place::select('place_id', 'place_name', 'place_desc', 'place_city', 'picture')->where('place_id', '=', $place_id)->first(); if (count($resultDBArray) > 0) { $resultJSON["success"] = "1"; $resultJSON["item"] = $resultDBArray; $resultDBImages = $this->getImages($place_id); $locationArray = $this->getLocation($place_id); $city_nameArray = $this->getCityName($resultDBArray['place_city']); $pointsArray = $this->getPoints($place_id); $price = $this->getPrice($place_id); $resultJSON["item"]['place_city'] = $city_nameArray['city_name']; $resultJSON["item"]['longitude'] = $locationArray['longitude']; $resultJSON["item"]['latitude'] = $locationArray['latitude']; $resultJSON["item"]['images'] = $resultDBImages; $resultJSON["item"]['points'] = $pointsArray; $resultJSON["item"]['price'] = $price; } else { $resultJSON["success"] = "0"; } echo json_encode($resultJSON); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function filter($city = null, $rest = null, $catForApp = null) { $catForApp = urldecode($catForApp); $city = urldecode($city); $rest = urldecode($rest); $str = "любой"; strnatcasecmp($rest, $str) == 0 ? $rest = null : false; strnatcasecmp($city, $str) == 0 ? $city = null : false; $rest != null ? $arrayPlaceId = $this->getPlaceIdByRestId($this->getRestId($rest)) : ($arrayPlaceId = null); $city != null ? $cityId = $this->getCityId($city) : ($cityId = null); if ($arrayPlaceId != null && $cityId != null) { if ($catForApp != null) { $resultDBArray = Place::select('place_id', 'place_name', 'place_city', 'picture')->whereIn('place_id', $arrayPlaceId)->where('cat_for_app_id', $catForApp)->with('location')->where('place_city', $cityId)->orderBy('views')->get(); } else { $resultDBArray = Place::select('place_id', 'place_name', 'place_city', 'picture')->whereIn('place_id', $arrayPlaceId)->with('location')->where('place_city', $cityId)->orderBy('views')->get(); } } else { if ($arrayPlaceId != null && $cityId == null) { if ($catForApp != null) { $resultDBArray = Place::select('place_id', 'place_name', 'place_city', 'picture')->where('cat_for_app_id', $catForApp)->with('location')->whereIn('place_id', $arrayPlaceId)->orderBy('views')->get(); } else { $resultDBArray = Place::select('place_id', 'place_name', 'place_city', 'picture')->whereIn('place_id', $arrayPlaceId)->orderBy('views')->with('location')->get(); } } else { if ($arrayPlaceId == null && $cityId != null) { if ($catForApp != null) { $resultDBArray = Place::select('place_id', 'place_name', 'place_city', 'picture')->where('cat_for_app_id', $catForApp)->with('location')->where('place_city', $cityId)->orderBy('views')->get(); } else { $resultDBArray = Place::select('place_id', 'place_name', 'place_city', 'picture')->where('place_city', $cityId)->orderBy('views')->get(); } } else { if ($catForApp != null) { $resultDBArray = Place::select('place_id', 'place_name', 'place_city', 'picture')->where('cat_for_app_id', $catForApp)->with('location')->orderBy('views')->get(); } else { $resultDBArray = Place::select('place_id', 'place_name', 'place_city', 'picture')->with('location')->orderBy('views')->get(); } } } } if (count($resultDBArray) > 0) { $resultJSON["success"] = "1"; $resultJSON["items"] = $resultDBArray; for ($i = 0; $i < count($resultDBArray); $i++) { $place_id = $resultJSON["items"][$i]['place_id']; $city_id = $resultJSON["items"][$i]['place_city']; $resultDBImages = $this->getImages($place_id); $city_nameArray = $this->getCityName($city_id); $resultJSON["items"][$i]['place_city'] = $city_nameArray['city_name']; $resultJSON["items"][$i]['images'] = $resultDBImages; } } else { $resultJSON["success"] = "0"; } echo json_encode($resultJSON); }
public function gide(Request $request = null) { if ($request->input) { $rest = urldecode($request->input('typerest')); $city = urldecode($request->input('town')); $str = "любой"; strnatcasecmp($rest, $str) == 0 ? $rest = null : false; strnatcasecmp($city, $str) == 0 ? $city = null : false; $rest != null ? $arrayPlaceId = $this->getPlaceIdByRestId($this->getRestId($rest)) : ($arrayPlaceId = null); $city != null ? $cityId = $this->getCityId($city) : ($cityId = null); if ($arrayPlaceId != null && $cityId != null) { $resultDBArray = Place::select('place_id', 'place_name', 'picture')->where('cat_for_app_id', '=', '4')->with('location')->whereIn('place_id', $arrayPlaceId)->where('place_city', $cityId)->get(); } else { if ($arrayPlaceId != null && $cityId == null) { $resultDBArray = Place::select('place_id', 'place_name', 'picture')->where('cat_for_app_id', '=', '4')->with('location')->whereIn('place_id', $arrayPlaceId)->get(); } else { if ($arrayPlaceId == null && $cityId != null) { $resultDBArray = Place::select('place_id', 'place_name', 'picture')->where('cat_for_app_id', '=', '4')->with('location')->where('place_city', $cityId)->get(); } else { $resultDBArray = Place::select('place_id', 'place_name', 'picture')->where('cat_for_app_id', '=', '4')->with('location')->get(); } } } } else { $resultDBArray = Place::select('place_id', 'place_name', 'picture')->where('cat_for_app_id', '=', '4')->with('location')->get(); } if (count($resultDBArray) > 0) { $content["success"] = "Экскурсии"; $content["check"][0] = "Культура и отдых"; $content["check"][1] = "Где поспать"; $content["check"][2] = "Где поспать"; $resultJSON["items"] = $resultDBArray; for ($i = 0; $i < count($resultDBArray); $i++) { $lng = $resultJSON["items"][$i]['location']['longitude']; $lat = $resultJSON["items"][$i]['location']['latitude']; $resultJSON["items"][$i]['longitude'] = $lng; $resultJSON["items"][$i]['latitude'] = $lat; unset($resultJSON["items"][$i]['location']); } } else { $resultJSON["success"] = "0"; } $cities = City::select('city_name')->distinct()->get(); $rests = Rest::select('rest_type')->distinct()->get(); $content['cities'] = $cities; $content['rests'] = $rests; $content['dbArray'] = $resultDBArray; $content['JSONarray'] = json_encode($resultJSON); return view('filter', $content); }