本文整理匯總了PHP中app\Activity::whereRaw方法的典型用法代碼示例。如果您正苦於以下問題：PHP Activity::whereRaw方法的具體用法？PHP Activity::whereRaw怎麽用？PHP Activity::whereRaw使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類app\Activity的用法示例。
在下文中一共展示了Activity::whereRaw方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: getActivity
public function getActivity($city_id = 0)
{
$res = ['response' => 'YES', 'status' => '1', 'data' => []];
if ($city_id == 0) {
$activitys = Activity::where('activity_active', '=', '1');
} else {
$activitys = Activity::whereRaw('( ( activity_active = 1 AND activity_city_id = 0 ) OR ( activity_active = 1 AND activity_city_id = ' . $city_id . ' ) )');
}
$activitys = $activitys->orderBy('activity_city_id', 'ASC')->orderBy('activity_sort', 'ASC')->get();
foreach ($activitys as $activity) {
$img = $activity->img()->first();
$res['data'][] = ['id' => $activity->activity_id, 'city_id' => $activity->activity_city_id, 'sort' => $activity->activity_sort, 'title' => $activity->activity_title, 'author' => $activity->activity_author, 'summary' => $activity->activity_summary, 'url' => MAPI_HOST . 'activity/' . $activity->activity_url, 'imgs' => [MAPI_IMG_HOST . $img->img_square, MAPI_IMG_HOST . $img->img_tiny, MAPI_IMG_HOST . $img->img_small, MAPI_IMG_HOST . $img->img_big, MAPI_IMG_HOST . $img->img_hd]];
}
return response()->json($res)->header('Content-Type', 'application/json');
}