102 lines
4.4 KiB
PHP
102 lines
4.4 KiB
PHP
<?php
|
|
|
|
defined('BASEPATH') or exit('No direct script access allowed');
|
|
|
|
class Taxes_model extends App_Model {
|
|
public function __construct() {
|
|
parent::__construct();
|
|
}
|
|
|
|
/**
|
|
* Get tax by id
|
|
* @param mixed $id tax id
|
|
* @return mixed if id passed return object else array
|
|
*/
|
|
public function get($id = '', $playground = false) {
|
|
if (is_numeric($id)) {
|
|
$this->db->where('id', $id);
|
|
return $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'taxes')->row();
|
|
}
|
|
$this->db->order_by('taxrate', 'ASC');
|
|
return $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'taxes')->result_array();
|
|
}
|
|
|
|
/**
|
|
* Add new tax
|
|
* @param array $data tax data
|
|
* @return boolean
|
|
*/
|
|
public function add($data, $playground = false) {
|
|
unset($data['taxid']);
|
|
$data['name'] = trim($data['name']);
|
|
$data['taxrate'] = trim($data['taxrate']);
|
|
$data = hooks()->apply_filters('before_tax_created', $data);
|
|
$this->db->insert(($playground ? 'playground_' : '') . 'taxes', $data);
|
|
$insert_id = $this->db->insert_id();
|
|
if ($insert_id) {
|
|
log_activity('New Tax Added [ID: ' . $insert_id . ', ' . $data['name'] . ']');
|
|
hooks()->do_action('after_tax_created', ['id' => $insert_id, 'data' => $data, ]);
|
|
return true;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
/**
|
|
* Edit tax
|
|
* @param array $data tax data
|
|
* @return boolean
|
|
*/
|
|
public function edit($data, $playground = false) {
|
|
if (total_rows(db_prefix() . ($playground ? 'playground_' : '') . 'expenses', ['tax' => $data['taxid'], ]) > 0) {
|
|
return ['tax_is_using_expenses' => true, ];
|
|
}
|
|
$updated = false;
|
|
$taxid = $data['taxid'];
|
|
$original_tax = get_tax_by_id($taxid, $playground);
|
|
unset($data['taxid']);
|
|
$data['name'] = trim($data['name']);
|
|
$data['taxrate'] = trim($data['taxrate']);
|
|
$data = hooks()->apply_filters('before_update_tax', $data, $taxid);
|
|
$this->db->where('id', $taxid);
|
|
$this->db->update(($playground ? 'playground_' : '') . 'taxes', $data);
|
|
if ($this->db->affected_rows() > 0) {
|
|
// Check if this task is used in settings
|
|
$default_taxes = unserialize(get_option('default_tax'));
|
|
$i = 0;
|
|
foreach ($default_taxes as $tax) {
|
|
$current_tax = $this->get($taxid, $playground);
|
|
$tax_name = $original_tax->name . '|' . $original_tax->taxrate;
|
|
if (strpos('x' . $tax, $tax_name) !== false) {
|
|
$default_taxes[$i] = str_ireplace($tax_name, $current_tax->name . '|' . $current_tax->taxrate, $default_taxes[$i]);
|
|
}
|
|
$i++;
|
|
}
|
|
update_option('default_tax', serialize($default_taxes));
|
|
$updated = true;
|
|
}
|
|
hooks()->do_action('after_update_tax', ['id' => $taxid, 'data' => $data, 'updated' => & $updated, ]);
|
|
if ($updated) {
|
|
log_activity('Tax Updated [ID: ' . $taxid . ', ' . $data['name'] . ']');
|
|
}
|
|
return $updated;
|
|
}
|
|
|
|
/**
|
|
* Delete tax from database
|
|
* @param mixed $id tax id
|
|
* @return boolean
|
|
*/
|
|
public function delete($id, $playground = false) {
|
|
if (is_reference_in_table('tax', db_prefix() . ($playground ? 'playground_' : '') . 'items', $id) || is_reference_in_table('tax2', db_prefix() . ($playground ? 'playground_' : '') . 'items', $id) || is_reference_in_table('tax', db_prefix() . ($playground ? 'playground_' : '') . 'expenses', $id) || is_reference_in_table('tax2', db_prefix() . ($playground ? 'playground_' : '') . 'expenses', $id) || is_reference_in_table('tax_id', db_prefix() . ($playground ? 'playground_' : '') . 'subscriptions', $id) || is_reference_in_table('tax_id_2', db_prefix() . ($playground ? 'playground_' : '') . 'subscriptions', $id)) {
|
|
return ['referenced' => true, ];
|
|
}
|
|
$this->db->where('id', $id);
|
|
$this->db->delete(db_prefix() . ($playground ? 'playground_' : '') . 'taxes');
|
|
if ($this->db->affected_rows() > 0) {
|
|
log_activity('Tax Deleted [ID: ' . $id . ']');
|
|
return true;
|
|
}
|
|
return false;
|
|
}
|
|
}
|