public function data() { $active = "oss"; $approvals = ApprovalPerson::all(); $sl_data = ShoppingList::all(); $dataoss = Oss::all(); $sites = Mastertp::distinct()->groupBy('sitelocation')->get(); $max = 1; $nomax = DB::table('oss')->orderBy('no_oss', 'desc')->take(1)->get(); foreach ($nomax as $nomax) { $max = $nomax->no_oss; $max = $max + 1; } return View::make('oss.list')->with('active', $active)->with('dataoss', $dataoss)->with('max', $max)->with('sites', $sites)->with('sl_data', $sl_data)->with('approvals', $approvals); }