public function getBanner($city_id = 0)
{
$res = ['response' => 'YES', 'status' => '1', 'data' => []];
if ($city_id == 0) {
$banners = Banner::where('banner_active', '=', '1');
} else {
$banners = Banner::whereRaw('( ( banner_active = 1 AND banner_city_id = 0 ) OR ( banner_active = 1 AND banner_city_id = ' . $city_id . ' ) )');
}
$banners = $banners->orderBy('banner_city_id', 'ASC')->orderBy('banner_sort', 'ASC')->get();
foreach ($banners as $banner) {
$img = $banner->img()->first();
$res['data'][] = ['id' => $banner->banner_id, 'city_id' => $banner->banner_city_id, 'sort' => $banner->banner_sort, 'title' => $banner->banner_title, 'url' => $banner->banner_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');
}