mirror of
https://github.com/opensourcepos/opensourcepos.git
synced 2026-01-18 22:38:00 -05:00
ba9bcd7786
- Added missing PHPdocs - Corrected Syntax - Added noinspection parameters to PHPdoc for AJAX called functions - Added missing function return types - Added missing parameter types - Added public keyword to functions without visibility modifier - Corrected incorrectly formatted PHPdocs - Added public to constants and functions missing a visibility keyword
106 lines
2.2 KiB
PHP
106 lines
2.2 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]);
|
|
}
|
|
}
|