/home3/bmscom/jupiter.bms69.com/system/autoload/Inventory.php
<?php
Class Inventory{
public static function decreaseByItemNumber($item_number,$qty){
if($item_number == ''){
return false;
}
$item = ORM::for_table('sys_items')->where('item_number',$item_number)->first();
if(!$item && is_numeric($item_number)){
$item = Item::find($item_number);
}
if($item){
$current_qty = $item->inventory;
$updated_qty = $current_qty-$qty;
$item->inventory = $updated_qty;
$item->save();
return true;
}
return false;
}
public static function increaseByItemNumber($item_number,$qty){
if($item_number == ''){
return false;
}
$item = ORM::for_table('sys_items')->where('item_number',$item_number)->first();
if($item){
$current_qty = $item->inventory;
$updated_qty = $current_qty+$qty;
$item->inventory = $updated_qty;
$item->save();
return true;
}
return false;
}
public static function recountItemByItemNumber($item_number)
{
$invoice_items = InvoiceItem::where('item_number',$item_number)->get();
}
}