本文整理汇总了PHP中Walker::whereIn方法的典型用法代码示例。如果您正苦于以下问题:PHP Walker::whereIn方法的具体用法?PHP Walker::whereIn怎么用?PHP Walker::whereIn使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Walker
的用法示例。
在下文中一共展示了Walker::whereIn方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: get_providers
//.........这里部分代码省略.........
foreach ($type1 as $key) {
$type[] = (int) $key;
}
Log::info('type = ' . print_r($type, true));
$count = count($type);
}
if (!$type) {
// choose default type
$provider_type = ProviderType::where('is_default', 1)->first();
if (!$provider_type) {
$type = 1;
} else {
$type = $provider_type->id;
}
}
$settings = Settings::where('key', 'default_search_radius')->first();
$distance = $settings->value;
$settings = Settings::where('key', 'default_distance_unit')->first();
$unit = $settings->value;
if ($unit == 0) {
$multiply = 1.609344;
} elseif ($unit == 1) {
$multiply = 1;
}
$query = "SELECT " . "walker.id, " . "walker.first_name, " . "walker.last_name, " . "walker.picture, " . "walker.phone, " . "walker.latitude, " . "walker.longitude, " . "ROUND(" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * " . "cos( radians(latitude) ) * " . "cos( radians(longitude) - radians('{$longitude}') ) + " . "sin( radians('{$latitude}') ) * " . "sin( radians(latitude) ) ) ,8) as distance " . "from walker " . "where is_available = 1 and " . "is_active = 1 and " . "is_approved = 1 and " . "ROUND((" . $multiply . " * 3956 * acos( cos( radians('{$latitude}') ) * " . "cos( radians(latitude) ) * " . "cos( radians(longitude) - radians('{$longitude}') ) + " . "sin( radians('{$latitude}') ) * " . "sin( radians(latitude) ) ) ) ,8) <= {$distance} " . "order by distance " . "LIMIT 5";
$walker = DB::select(DB::raw($query));
$typewalker = array();
$typewalker1 = array();
foreach ($walker as $key) {
$typewalker[] = $key->id;
}
$flag = 0;
if ($typewalker) {
$walkers = ProviderServices::whereIn('provider_id', $typewalker)->whereIn('type', $type)->groupBy('provider_id')->havingRaw('count(distinct type) = ' . $count)->get();
foreach ($walkers as $key) {
$typewalker1[] = $key->provider_id;
}
if ($typewalker1) {
$walkers = Walker::whereIn('id', $typewalker1)->get();
if ($walkers) {
$flag = 1;
}
}
}
if ($flag == 1) {
$c = 0;
foreach ($walkers as $key) {
$provider[$c]['id'] = $key->id;
$provider[$c]['first_name'] = $key->first_name;
$provider[$c]['last_name'] = $key->last_name;
$provider[$c]['picture'] = $key->picture;
$provider[$c]['phone'] = $key->phone;
$provider[$c]['latitude'] = $key->latitude;
$provider[$c]['longitude'] = $key->longitude;
$provider[$c]['rating'] = $key->rate;
$provider[$c]['car_model'] = $key->car_model;
$provider[$c]['car_number'] = $key->car_number;
$provider[$c]['bearing'] = $key->bearing;
$provserv = ProviderServices::where('provider_id', $key->id)->get();
foreach ($provserv as $ps) {
$provider[$c]['type'] = $ps->type;
$provider[$c]['base_price'] = $ps->base_price;
}
/* $rat = WalkerReview::where('walker_id', $key->id)->get();
$countRating = count($rat);