public static function published($limit = 5, $type = 'news') { $n = new \App\News(); return $n->where('type', $type)->where('published_at', '<', Carbon::now())->orderBy('published_at', 'DESC')->orderBy('order')->limit($limit)->get(); }
<?php $nd = Carbon\Carbon::today()->addMonth(); $incomingEvents = App\Event::where('private', 0)->where('active', 1)->where('date', '>=', DB::raw('NOW()'))->where('date', '<=', $nd)->orderBy('date', 'ASC')->get(); $lastNews = App\News::where('active', 1)->where('published_at', '<=', DB::raw('NOW()'))->orderBy('published_at', 'DESC')->limit(5)->get(); ?> <!DOCTYPE html> <html> <head> <title>DjMaker | @section('title') Accueil @show </title> <link rel="stylesheet" type="text/css" href="{{ url('vendor/css/bootstrap.css') }}" /> {{-- <link rel="stylesheet/less" type="text/css" href="{{ url('vendor/css/style.less') }}" /> --}} <meta name="csrf-token" content="{{ csrf_token() }}" /> <link rel="stylesheet" type="text/css" href="{{ url('vendor/css/less.css') }}"> <link rel="stylesheet" type="text/css" href="{{ url('vendor/css/css.css') }}"> <link rel="stylesheet" type="text/css" href="{{ url('vendor/css/hover.min.css') }}"> <link rel="stylesheet" type="text/css" href="{{ url('vendor/js/jquery-ui/jquery-ui.min.css') }}"> <link rel="stylesheet" type="text/css" href="{{ url('vendor/js/timepicker/stylesheets/wickedpicker.css') }}"> <link href="{{ URL::asset('vendor/js/file-input/css/fileinput.min.css') }}" media="all" rel="stylesheet" type="text/css" /> <script src="{{ URL::asset('vendor/js/less.js') }}"></script> <script src="{{ URL::asset('vendor/js/jquery.js') }}"></script> <script src="{{ URL::asset('vendor/js/bootstrap.min.js') }}"></script> </head> <body> <header> <div class="banner" id="banner"> <a href="{{ url('/') }}"> <h1>DjMaker</h1> </a>
$stores = App\Gallery::where('tag', 'store_item')->get(); return view('pages.stores', compact('slides', 'stores'))->render(); }); Route::get('/contacto', function () { return view('pages.contacto')->render(); }); Route::post('/contacto', function (Request $request) { $input = Input::all(); Mail::send('emails.contacto', $input, function ($m) use($input) { $m->to('*****@*****.**')->subject('Consulta desde OC SPORT Website'); }); return redirect('/contacto/enviado')->with($input); }); Route::get('/contacto/enviado', function () { return view('pages.contacto-thanks')->render(); }); Route::post('/subscribir', function (Request $request) { $datos = Input::all(); $item = App\Subscription::create($datos); $item->save(); return view('pages.subscription-thanks', $datos); }); Route::get('/news', function () { $destacadas = App\News::where('pin', true)->take(2)->get(); $news = App\News::paginate(6); return view('pages.news', ['destacadas' => $destacadas, 'news' => $news])->render(); }); Route::get('/news/{slug}', function ($slug) { $post = App\News::with('gallery')->where('slug', $slug)->first(); return view('pages.news-single', ['post' => $post])->render(); });