public function adjustInv() { $ids = DB::table('tblAdjustments')->select('strAdjID')->orderBy('updated_at', 'desc')->orderBy('strAdjID', 'desc')->take(1)->get(); $ID = $ids["0"]->strAdjID; $newID = $this->smart($ID); $id = Input::get('batchID'); $invadj = Inventory::find($id); $qty = $invadj->intAvailQty; $prodID = $invadj->strProdID; $counter = Input::get('adjQTY'); $invadj->intAvailQty += $counter; $invadj->save(); $adjust = Adjust::create(array('strAdjID' => $newID, 'strAdjProdID' => $prodID, 'intAdjQtyBef' => $qty, 'intAdjQtyAft' => $qty + $counter, 'strAdjReason' => Input::get('adjRes'), 'dtAdjDate' => Input::get('dtAdj'), 'strAdjBatchID' => Input::get('batchID'))); $adjust->save(); return Redirect::to('/inventory'); }