mirror of
https://github.com/opensourcepos/opensourcepos.git
synced 2025-12-25 18:47:53 -05:00
e83c23cf0c
* Improve code style and PSR-12 compliance - refactored code formatting to adhere to PSR-12 guidelines - standardized coding conventions across the codebase - added missing framework files and reverted markup changes - reformatted arrays for enhanced readability - updated language files for consistent styling and clarity - minor miscellaneous improvements
101 lines
2.7 KiB
PHP
101 lines
2.7 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use CodeIgniter\Database\ResultInterface;
|
|
use CodeIgniter\Model;
|
|
|
|
/**
|
|
* Inventory class
|
|
*
|
|
* @property employee employee
|
|
*
|
|
*/
|
|
class Inventory extends Model
|
|
{
|
|
protected $table = 'inventory';
|
|
protected $primaryKey = 'trans_id';
|
|
protected $useAutoIncrement = true;
|
|
protected $useSoftDeletes = false;
|
|
protected $allowedFields = [
|
|
'trans_items',
|
|
'trans_user',
|
|
'trans_date',
|
|
'trans_comment',
|
|
'trans_inventory',
|
|
'trans_location'
|
|
];
|
|
|
|
/**
|
|
* @param $comment
|
|
* @param $inventory_data
|
|
* @return bool
|
|
*/
|
|
public function update($comment = null, $inventory_data = null): bool
|
|
{
|
|
$builder = $this->db->table('inventory');
|
|
$builder->where('trans_comment', $comment);
|
|
|
|
return $builder->update($inventory_data);
|
|
}
|
|
|
|
/**
|
|
* Retrieves inventory data given an item_id.
|
|
*
|
|
* @param int $item_id
|
|
* @param bool $location_id
|
|
* @return ResultInterface
|
|
*/
|
|
public function get_inventory_data_for_item(int $item_id, bool $location_id = false): ResultInterface
|
|
{
|
|
$builder = $this->db->table('inventory');
|
|
$builder->where('trans_items', $item_id);
|
|
|
|
if ($location_id) {
|
|
$builder->where('trans_location', $location_id);
|
|
}
|
|
|
|
$builder->orderBy('trans_date', 'desc');
|
|
|
|
return $builder->get();
|
|
}
|
|
|
|
/**
|
|
* @param int $item_id ID number for the item to have quantity reset.
|
|
* @return bool|int|string The row id of the inventory table on insert or false on failure
|
|
*/
|
|
public function reset_quantity(int $item_id): bool|int|string
|
|
{
|
|
$inventory_sums = $this->get_inventory_sum($item_id);
|
|
foreach ($inventory_sums as $inventory_sum) {
|
|
if ($inventory_sum['sum'] > 0) {
|
|
$employee = model(Employee::class);
|
|
|
|
return $this->insert([
|
|
'trans_inventory' => -1 * $inventory_sum['sum'],
|
|
'trans_items' => $item_id,
|
|
'trans_location' => $inventory_sum['location_id'],
|
|
'trans_comment' => lang('Items.is_deleted'),
|
|
'trans_user' => $employee->get_logged_in_employee_info()->person_id
|
|
]);
|
|
}
|
|
}
|
|
|
|
return true;
|
|
}
|
|
|
|
/**
|
|
* @param int $item_id
|
|
* @return array
|
|
*/
|
|
public function get_inventory_sum(int $item_id): array
|
|
{
|
|
$builder = $this->db->table('inventory');
|
|
$builder->select('SUM(trans_inventory) AS sum, MAX(trans_location) AS location_id');
|
|
$builder->where('trans_items', $item_id);
|
|
$builder->groupBy('trans_location');
|
|
|
|
return $builder->get()->getResultArray();
|
|
}
|
|
}
|