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