/** * Show the application dashboard to the user. * * @return Response */ public function index() { $banners = Banner::where('active', 'Y')->orderBy('id', 'desc')->get(); $news = News::orderBy('date', 'desc')->take(5)->get(); $videos = Video::orderBy('id', 'desc')->take(5)->get(); return view('home', compact('banners', 'news', 'videos')); }
public function index() { $activities = Activity::where('istop', 1)->where('states', 0)->orderBy('order_number')->take(4)->get(); $old_activities = Activity::where('states', 2)->orderBy('start_date', 'desc')->get(); $adverts = Banner::where('tag', 'indexAdvert')->take(2)->get(); return view('activity.index', compact('activities', 'old_activities', 'adverts')); }
public function index() { $activities = Activity::where('istop', 1)->where('states', 0)->orderBy('order_number')->get(); $guides = Guide::where('isbest', '=', 1)->orderBy('orders')->take(6)->get(); $topNotes = Note::topNotes()->with('user')->take(6)->get(); //$users = User::topUsers()->take(10)->get(); $adverts = Banner::where('tag', 'indexAdvert')->take(2)->get(); $banners = Banner::where('tag', 'indexBanner')->orderBy('orders')->get(); return view('index', compact('activities', 'guides', 'topNotes', 'adverts', 'banners')); }
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'); }
public function getList(Request $request, $type = 'all') { $perpage = 20; $banners = Banner::orderBy('banner_sort', 'ASC'); $allCount = Banner::count(); $onlineCount = Banner::where('banner_active', '=', '1')->count(); $offlineCount = Banner::where('banner_active', '=', '0')->count(); if ($type == 'online') { $banners = $banners->where('banner_active', '=', '1'); } elseif ($type == 'offline') { $banners = $banners->where('banner_active', '=', '0'); } $banners = $banners->paginate($perpage); session(['previousUrl' => URL::full()]); return view('manage.banner.list', ['TITLE' => '轮播列表', 'META_KEYWORDS' => META_KEYWORDS, 'META_DESC' => META_DESC, 'PAGE_CODE' => '/manage/banner/list', 'type' => $type, 'banners' => $banners, 'allCount' => $allCount, 'onlineCount' => $onlineCount, 'offlineCount' => $offlineCount]); }
public function search() { $giro = Request::get('giro'); $query = Request::get('q'); $ciudad = Request::get('ciudad'); DB::enableQueryLog(); $negocios = $ciudad ? Negocio::where('nombre_negocio', 'LIKE', "%{$query}%")->where('categoria', '=', $giro)->where('ciudad', '=', $ciudad)->where('status', 1)->paginate(20) : Negocio::where('status', 1)->paginate(20); // dd(DB::getQueryLog()); //Categories Stuff $categorias = Category::all(); $selectCategorias = array(); foreach ($categorias as $category) { $selectCategorias[$category->id] = $category->name; } $ciudades = DB::table('negocios')->where('status', '=', 1)->orderBy('ciudad', 'asc')->distinct()->lists('ciudad'); $ciudades_array = array(); foreach ($ciudades as $ciudad => $value) { $ciudades_array[$value] = $value; } $banners_inner = Banner::where('place', '=', 'inner')->where('status', '=', 1)->get(); return View('pages.search', compact('negocios', 'selectCategorias', 'ciudades_array', 'banners_inner')); }
public function composeSideAdvert() { view()->composer('common.side-advert', function ($view) { $view->with('adverts', Banner::where('tag', '=', 'sideAdvert')->get()); }); }
/** * Bootstrap any application services. * * @return void */ public function boot() { $banners_footer = Banner::where('place', '=', 'footer')->where('status', '=', 1)->get(); view()->share('banners_footer', $banners_footer); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $banners = Banner::where('lang', App::getLocale())->latest('published_at')->paginate(get_setting('pagination_num')); return view('admin.banners.index', compact('banners')); }
/** * Bootstrap any application services. * * @return void */ public function boot() { /** * Register custom Validator */ Validator::extend('require_one_of_array', function ($attribute, $value, $parameters, $validator) { if (!is_array($value)) { return false; } foreach ($value as $k => $v) { if (!empty($v)) { return true; } } return false; }); /** * Get Admin Menu from DB */ view()->composer('admin.layout.admin_index_layout', function ($view) { $adminMenu = new AdminMenu(); $view->with('adminMenu', $adminMenu->getMenu()); $controller = Util::getController(); $view->with('controller', $controller); $view->with('controller_parent_id', $adminMenu->getParent($controller)); }); /** * Get Settings From DB */ $settings = Cache::rememberForever('settings', function () { return Settings::all(); }); if (!$settings->isEmpty()) { foreach ($settings as $k => $v) { config(['dc.' . $v->setting_name => $v->setting_value]); } } /** * Get Custom Pages From DB, Get Central Banner */ view()->composer('layout.index_layout', function ($view) { //header menu $headerMenu = Cache::rememberForever('headerMenu', function () { return Page::select('page_title', 'page_slug')->where('page_position', Page::HEADER_MENU)->where('page_active', 1)->orderBy('page_ord', 'ASC')->get(); }); $view->with('headerMenu', $headerMenu); //footer menu $footerMenu = Cache::rememberForever('footerMenu', function () { return Page::select('page_title', 'page_slug')->where('page_position', Page::FOOTER_MENU)->where('page_active', 1)->orderBy('page_ord', 'ASC')->get(); }); $view->with('footerMenu', $footerMenu); //get central banner if any $today = date('Y-m-d'); $centralBanner = Banner::where('banner_active_from', '<=', $today)->where('banner_active_to', '>=', $today)->where('banner_position', Banner::BANNER_POSITION_LIST)->orderByRaw('rand()')->take(1)->first(); if (!empty($centralBanner)) { $centralBanner->increment('banner_num_views'); } $view->with('centralBanner', $centralBanner); }); /** * get ad detail/ad contact banner */ view()->composer(['ad.detail', 'ad.contact'], function ($view) { $today = date('Y-m-d'); $adDetailBanner = Banner::where('banner_active_from', '<=', $today)->where('banner_active_to', '>=', $today)->where('banner_position', Banner::BANNER_POSITION_DETAIL)->orderByRaw('rand()')->take(1)->first(); if (!empty($adDetailBanner)) { $adDetailBanner->increment('banner_num_views'); } $view->with('adDetailBanner', $adDetailBanner); }); }