public function newrelease() { // $products = DB::table('tblInventory as a') // ->join('tblProducts as b', 'b.strProdID', '=', 'a.strProdID') // ->get(); $products = DB::table('tblProducts')->get(); $branches = Branch::lists('strBrchName', 'strBrchID'); $ids = DB::table('tblReleases')->select('strReleasesID')->orderBy('updated_at', 'desc')->orderBy('strReleasesID', 'desc')->take(1)->get(); $ID = $ids["0"]->strReleasesID; $newID = $this->smart($ID); Session::put('newreleaseid', $newID); return View::make('newrelease')->with('products', $products)->with('branches', $branches); }
/** * @param $id * @return \Illuminate\View\View */ public function getAddroleindex($id) { $person = People::findOrFail($id); $roles = Role::lists('name_rol', 'id'); $branches = Branch::lists('name', 'id'); return view('admin.addroles.addrole', compact('person', 'roles', 'branches')); }