public function maintenanceSupplier()
{
$ids = DB::table('tblSupplier')->select('strSuppId')->orderBy('created_at', 'desc')->orderBy('strSuppId', 'desc')->take(1)->get();
$ID = $ids["0"]->strSuppId;
$newID = $this->smart($ID);
$supplier = MSupplier::all();
return View::make('supplierMaintenance')->with('suppliers', $supplier)->with('newID', $newID);
}
public function maintenanceProduct()
{
$ids = DB::table('tblProduct')->select('strProdId')->orderBy('created_at', 'desc')->orderBy('strProdId', 'desc')->take(1)->get();
$ID = $ids["0"]->strProdId;
$newID = $this->smart($ID);
$product = DB::table('tblProduct')->join('tblSupplier', 'tblProduct.strPSupp', '=', 'tblSupplier.strSuppId')->join('tblUOM', 'tblProduct.strPUOM', '=', 'tblUOM.strUOMId')->join('tblProdSerCat', 'tblProduct.strPCategory', '=', 'tblProdSerCat.strCategId')->select('tblProduct.*', 'tblSupplier.strSuppName', 'tblUOM.strUOMDesc', 'tblProdSerCat.strCategName')->get();
$category = MProdServCat::all();
$supplier = MSupplier::all();
$uom = MUOM::all();
return View::make('productMaintenance')->with('newID', $newID)->with('products', $product)->with('uom', $uom)->with('uom2', $uom)->with('categories', $category)->with('suppliers', $supplier);
}
