mirror of
https://github.com/opensourcepos/opensourcepos.git
synced 2025-12-30 04:57:54 -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
105 lines
2.6 KiB
PHP
105 lines
2.6 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use CodeIgniter\Database\ResultInterface;
|
|
use CodeIgniter\Model;
|
|
|
|
/**
|
|
* Customer_rewards class
|
|
*/
|
|
class Customer_rewards extends Model
|
|
{
|
|
protected $table = 'customer_packages';
|
|
protected $primaryKey = 'package_id';
|
|
protected $useAutoIncrement = true;
|
|
protected $useSoftDeletes = false;
|
|
protected $allowedFields = [
|
|
'package_name',
|
|
'points_percent',
|
|
'deleted'
|
|
];
|
|
|
|
/**
|
|
* @param int $package_id
|
|
* @return bool
|
|
*/
|
|
public function exists(int $package_id): bool
|
|
{
|
|
$builder = $this->db->table('customers_packages');
|
|
$builder->where('package_id', $package_id);
|
|
|
|
return ($builder->get()->getNumRows() >= 1);
|
|
}
|
|
|
|
/**
|
|
* @param array $package_data
|
|
* @param int $package_id
|
|
* @return bool
|
|
*/
|
|
public function save_value(array $package_data, int $package_id): bool
|
|
{
|
|
$package_data_to_save = [
|
|
'package_name' => $package_data['package_name'],
|
|
'deleted' => 0,
|
|
'points_percent' => $package_data['points_percent']
|
|
];
|
|
|
|
if (!$this->exists($package_id)) {
|
|
$builder = $this->db->table('customers_packages');
|
|
return $builder->insert($package_data_to_save);
|
|
}
|
|
|
|
$builder = $this->db->table('customers_packages');
|
|
$builder->where('package_id', $package_id);
|
|
|
|
return $builder->update($package_data_to_save);
|
|
}
|
|
|
|
/**
|
|
* @param int $package_id
|
|
* @return string
|
|
*/
|
|
public function get_name(int $package_id): string
|
|
{
|
|
$builder = $this->db->table('customers_packages');
|
|
$builder->where('package_id', $package_id);
|
|
|
|
return $builder->get()->getRow()->package_name;
|
|
}
|
|
|
|
/**
|
|
* @param int $package_id
|
|
* @return float
|
|
*/
|
|
public function get_points_percent(int $package_id): float
|
|
{
|
|
$builder = $this->db->table('customers_packages');
|
|
$builder->where('package_id', $package_id);
|
|
|
|
return $builder->get()->getRow()->points_percent;
|
|
}
|
|
|
|
/**
|
|
* @return ResultInterface
|
|
*/
|
|
public function get_all(): ResultInterface
|
|
{
|
|
$builder = $this->db->table('customers_packages');
|
|
$builder->where('deleted', 0);
|
|
|
|
return $builder->get();
|
|
}
|
|
|
|
/**
|
|
* Deletes one reward package
|
|
*/
|
|
public function delete($package_id = null, bool $purge = false): bool
|
|
{
|
|
$builder = $this->db->table('customers_packages');
|
|
$builder->where('package_id', $package_id);
|
|
|
|
return $builder->update(['deleted' => 1]);
|
|
}
|
|
}
|