Esempio n. 1
0
 /**
  * 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));
 }