本文整理匯總了PHP中app\City::take方法的典型用法代碼示例。如果您正苦於以下問題:PHP City::take方法的具體用法?PHP City::take怎麽用?PHP City::take使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類app\City
的用法示例。
在下文中一共展示了City::take方法的1個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: homeSearch
public function homeSearch()
{
DB::connection()->enableQueryLog();
$user_config = array('keywords' => \Input::get('keywords'), 'location' => \Input::get('location'));
$ltype = '';
if (!is_numeric($user_config['location'])) {
if (strpos($user_config['location'], ',') === false) {
$data['location'] = $user_config['location'];
$ltype = 'city';
} else {
$loc = explode(', ', $user_config['location']);
$data['search_city'] = $loc[0];
$data['search_state'] = $loc[1];
$data['location'] = $data['search_city'] . ', ' . $data['search_state'];
$ltype = 'default';
}
} else {
//Assign zip code to the data
$data['location'] = $user_config['location'];
$ltype = 'zip';
}
//Get the filter options matching the location
$data['filter_options']['city'] = \App\City::take(5)->get();
if (count(Input::get()) == 3) {
if ($ltype == 'default') {
$search_type = 'default';
} elseif ($ltype == 'city') {
$search_type = 'default_city';
} else {
$search_type = 'default_zip';
}
} else {
if ($ltype == 'default') {
$search_type = 'filter';
} elseif ($ltype == 'city') {
$search_type = 'filter_city';
} else {
$search_type = 'filter_zip';
}
}
//echo $search_type;
//dd(Input::get());
switch ($search_type) {
case 'default':
$data['restaurants'] = \App\Restaurants::join('city', 'city.id', '=', 'restaurants.city_id')->join('state', 'state.id', '=', 'restaurants.state_id')->join('restaurants_info', 'restaurants_info.restaurants_id', '=', 'restaurants.id')->where(function ($query) use($user_config) {
$query->where('restaurants.name', 'LIKE', '%' . $user_config['keywords'] . '%')->orWhere('restaurants.categories', 'LIKE', '%' . $user_config['keywords'] . '%');
})->where('city.city', '=', $loc[0])->where('state.short', '=', $loc[1])->orderBy('restaurants.rank', 'desc')->orderBy('restaurants.categories', 'asc')->paginate(10);
foreach ($data['restaurants'] as $rest) {
$reviews = $this->getReviewsThree($rest->permalink);
//$data['restaurants'][$rest->permalink] = $rest;
$rest->reviews_group = $reviews;
//dd($rest);
}
$data['meta_title'] = 'Find the Best ' . $user_config['keywords'] . ' Restaurants in ' . $loc[0] . ', ' . $loc[1] . ' | Restaurant Listings|';
$data['meta_description'] = $user_config['keywords'] . ' in ' . $loc[0] . ', ' . $loc[1] . ' Online food Order, Get Menu, Reviews, Contact, Location Maps, Directions';
$data['meta_keywords'] = $loc[0] . ', ' . $loc[1] . ', ' . $user_config['keywords'] . ' Online food Order, Get Menu, Reviews, Contact, Location Maps, Directions';
session(["search_city" => $loc[0], "search_state" => $loc[1], "search_zip" => ""]);
break;
case 'default_city':
$data['restaurants'] = \App\Restaurants::join('city', 'city.id', '=', 'restaurants.city_id')->join('restaurants_info', 'restaurants_info.restaurants_id', '=', 'restaurants.id')->where(function ($query) use($user_config) {
$query->where('restaurants.name', 'LIKE', '%' . $user_config['keywords'] . '%')->orWhere('restaurants.categories', 'LIKE', '%' . $user_config['keywords'] . '%');
})->where('city.city', '=', $data['location'])->orderBy('restaurants.rank', 'desc')->orderBy('restaurants.categories', 'asc')->paginate(10);
foreach ($data['restaurants'] as $rest) {
$reviews = $this->getReviewsThree($rest->permalink);
//$data['restaurants'][$rest->permalink] = $rest;
$rest->reviews_group = $reviews;
//dd($rest);
}
$data['meta_title'] = 'Find the Best ' . $user_config['keywords'] . ' Restaurants in ' . $data['location'] . ' | Restaurant Listings|';
$data['meta_description'] = $user_config['keywords'] . ' in ' . $data['location'] . ' Online food Order, Get Menu, Reviews, Contact, Location Maps, Directions';
$data['meta_keywords'] = $data['location'] . ', ' . $user_config['keywords'] . ' Online food Order, Get Menu, Reviews, Contact, Location Maps, Directions';
session(["search_city" => $data['location'], "search_state" => "", "search_zip" => ""]);
break;
case 'default_zip':
//Get restaurants matching the keywords and the location
$data['restaurants'] = \App\Restaurants::join('city', 'city.id', '=', 'restaurants.city_id')->join('state', 'state.id', '=', 'restaurants.state_id')->join('restaurants_info', 'restaurants_info.restaurants_id', '=', 'restaurants.id')->where(function ($query) use($user_config) {
$query->where('restaurants.name', 'LIKE', '%' . $user_config['keywords'] . '%')->orWhere('restaurants.categories', 'LIKE', '%' . $user_config['keywords'] . '%');
})->where('restaurants.zip', 'LIKE', $user_config['location'])->orderBy('restaurants.rank', 'desc')->orderBy('restaurants.categories', 'asc')->paginate(10);
foreach ($data['restaurants'] as $rest) {
$reviews = $this->getReviewsThree($rest->permalink);
//$data['restaurants'][$rest->permalink] = $rest;
$rest->reviews_group = $reviews;
//dd($rest);
}
$data['meta_title'] = 'Find the Best ' . $user_config['keywords'] . ' Restaurants in ' . $user_config['location'] . ' | Restaurant Listings|';
$data['meta_description'] = $user_config['keywords'] . ' in ' . $user_config['location'] . ' Online food Order, Get Menu, Reviews, Contact, Location Maps, Directions';
$data['meta_keywords'] = $user_config['location'] . ', ' . $user_config['keywords'] . ' Online food Order, Get Menu, Reviews, Contact, Location Maps, Directions';
session(["search_city" => "", "search_state" => "", "search_zip" => $user_config['location']]);
break;
case 'filter':
$data['restaurants'] = \App\Restaurants::join('city', 'city.id', '=', 'restaurants.city_id')->join('state', 'state.id', '=', 'restaurants.state_id')->join('restaurants_info', 'restaurants_info.restaurants_id', '=', 'restaurants.id')->where(function ($query) use($user_config) {
$query->where('restaurants.name', 'LIKE', '%' . $user_config['keywords'] . '%')->orWhere('restaurants.categories', 'LIKE', '%' . $user_config['keywords'] . '%');
})->where('city.city', '=', $loc[0])->where('state.short', '=', $loc[1])->where(function ($query) {
$category = Input::has('category') ? Input::get('category') : NULL;
if (isset($category)) {
foreach ($category as $c) {
$query->orWhere('restaurants.categories', 'LIKE', '%' . $c . '%');
}
}
$ordering = Input::has('ordering') ? Input::get('ordering') : NULL;
//.........這裏部分代碼省略.........