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'));
}
