public function showspj() { $data['active'] = 'oss'; $data['spj'] = true; $data['oss'] = OSS::where('oss_type', '=', 'spj')->get(); $data['sites'] = DB::table('mastertp')->groupBy('sitelocation')->get(); $data['shoplists'] = Shoplist::all(); $data['bantek'] = Bantek::all(); $data['userno'] = User::where('role', '=', 'no')->get(); return View::make(Auth::user()->role . '.oss.showspj', $data); }