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