/**
* 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);
});
}
