/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function index()
{
$titr1 = news::where('publi', 6)->where('admin', 1)->orderBy('created_at', 'desc')->first();
$titr = news::where('publi', 6)->where('admin', 1)->orderBy('created_at', 'desc')->skip(1)->take(4)->get();
$spec1 = news::where('publi', 4)->where('admin', 1)->orderBy('created_at', 'desc')->first();
$spec2 = news::where('publi', 4)->where('admin', 1)->orderBy('created_at', 'desc')->skip(1)->first();
$spec3 = news::where('publi', 5)->where('admin', 1)->orderBy('created_at', 'desc')->first();
$spec4 = news::where('publi', 5)->where('admin', 1)->orderBy('created_at', 'desc')->skip(1)->first();
$best = news::where('publi', 3)->where('admin', 1)->orderBy('created_at', 'desc')->take(8)->get();
$lastk = news::where('dep', 1)->where('admin', 1)->orderBy('created_at', 'desc')->take(30)->get();
$lasts = news::where('dep', 2)->where('admin', 1)->orderBy('created_at', 'desc')->take(30)->get();
$lastt = news::where('dep', 3)->where('admin', 1)->orderBy('created_at', 'desc')->take(30)->get();
$lastso = news::where('dep', 4)->where('admin', 1)->orderBy('created_at', 'desc')->take(30)->get();
return view('home')->with(array('titr1' => $titr1, 'titr' => $titr, 'spec1' => $spec1, 'spec2' => $spec2, 'spec3' => $spec3, 'spec4' => $spec4, 'best' => $best, 'lastk' => $lastk, 'lasts' => $lasts, 'lastt' => $lastt, 'lastso' => $lastso));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$new = news::find($id);
$new->delete();
return redirect('news');
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function news()
{
$newsArticles = news::all();
return view('pages.news', compact('newsArticles'));
}
