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