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');
}
}
