public function getIndex() { $slide = new slideshow(); $data = $slide->select('slideshow.*', DB::raw("(case when page=0 then 'Trang Chu' else (select name from category where slideshow.page=category.id) end) as namepage"))->orderBy('id', 'desc')->get(); $datac = category::get(); return view("admin.slide.index", array('data' => $data, 'datac' => $datac)); }