Example #1
0
 public function index()
 {
     if (Auth::check()) {
         $sum1 = Salary::select(DB::raw('count(distinct cid) as a'))->where('level', '=', 'พกส.(ปฏิบัติงาน)')->first();
         $sum2 = Salary::select(DB::raw('count(distinct cid) as a'))->where('level', '=', 'ลูกจ้างประจำ')->first();
         $sum3 = Salary::select(DB::raw('count(distinct cid) as a'))->where('level', '=', 'ข้าราชการ')->first();
         $sum4 = Salary::select(DB::raw('count(distinct cid) as a'))->where('level', '=', 'ลูกจ้างชั่วคราว')->first();
         return View::make('home.index', array('sum1' => $sum1, 'sum2' => $sum2, 'sum3' => $sum3, 'sum4' => $sum4));
     } else {
         //return login
         return View::make('users.index');
     }
 }