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