/** * Display a listing of the resource. * * @return Response */ public function index() { $canbos = Canbo::join('danhmucphongs', 'canbos.danhmucphong_id', '=', 'danhmucphongs.id')->join('danhmucchucvus', 'canbos.danhmucchucvu_id', '=', 'danhmucchucvus.id')->select('canbos.id', 'canbos.name as hoten', 'danhmucphongs.name as phong', 'danhmucchucvus.name as chucvu')->orderBy('danhmucphongs.name')->orderBy('canbos.name')->get(); //echo '<pre>'; //print_r($canbos); return view('canbo.index')->with(array('canbos' => $canbos, 'menus' => $this->menus, 'rolechucnangs' => $this->rolechucnangs)); }