public function view($name) { $lake_seo_url = addslashes(strip_tags($name)); $lakeDetails = Lake::with(['images', 'fishs', 'baits'])->where('seo_url', '=', $lake_seo_url)->get()->toArray(); return view('admin.lake.view')->with('details', $lakeDetails); }
public function kereses() { if (Request::isMethod('post')) { $lake = addslashes(strip_tags(Request::input('lake_name'))); $county = addslashes(strip_tags(Request::input('county'))); $fishs = addslashes(strip_tags(Request::input('fishs'))); $baits = addslashes(strip_tags(Request::input('enabled_baits'))); $nightFishing = addslashes(strip_tags(Request::input('night_fishing'))); $fishCondition = ''; if (!empty($fishs)) { $fishCondition = 'JOIN fish_lake AS fl ON(fl.lake_id = l.id) AND fl.fish_id IN(' . $fishs . ') '; } $baitCondition = ''; if (!empty($baits)) { $baitCondition = 'JOIN bait_lake AS bl on(bl.lake_id = l.id) AND bl.bait_id IN(' . $baits . ')'; } $countyCondition = ''; if (!empty($county)) { $countyCondition = 'JOIN county_county_lake AS ccl ON(ccl.lake_id = l.id) AND ccl.county_id = ' . $county . ''; } $sql = 'SELECT l.id FROM lakes AS l ' . $fishCondition . $baitCondition . $countyCondition . ' WHERE l.status = 1 GROUP BY l.id'; $lakes = DB::select($sql); $lakeIDs = ''; if (!empty($lakes)) { foreach ($lakes as $key => $lake) { $lakeIDs[] = $lake->id; } $lakesObj = Lake::with(['images'])->whereIn('lakes.id', $lakeIDs)->get()->toArray(); return view('search.lakesList')->with('lakes', $lakesObj); } return Redirect::to('/')->with('message', 'Sajnáljuk de a keresési kritériumokra nincs találat'); } else { return Redirect::to('/')->with('message', 'Sajnáljuk de a keresési kritériumokra nincs találat'); } }