tax.php — VikAppointments Services Booking Calendar 1.2.18

vikappointments / admin / models / tax.php

vikappointments / admin / models Last commit date

tax.php

140 lines

1	<?php
2	/**
3	* @package VikAppointments
4	* @subpackage core
5	* @author E4J s.r.l.
6	* @copyright Copyright (C) 2021 E4J s.r.l. All Rights Reserved.
7	* @license http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
8	* @link https://vikwp.com
9	*/
10
11	// No direct access
12	defined('ABSPATH') or die('No script kiddies please!');
13
14	VAPLoader::import('libraries.mvc.model');
15
16	/**
17	* VikAppointments tax model.
18	*
19	* @since 1.7
20	*/
21	class VikAppointmentsModelTax extends JModelVAP
22	{
23	/**
24	* Extend duplicate implementation to clone any related records
25	* stored within a separated table.
26	*
27	* @param mixed $ids Either the record ID or a list of records.
28	* @param mixed $src Specifies some values to be used while duplicating.
29	* @param array $ignore A list of columns to skip.
30	*
31	* @return mixed The ID of the records on success, false otherwise.
32	*/
33	public function duplicate($ids, $src = array(), $ignore = array())
34	{
35	$new_ids = array();
36
37	// do not copy creation date
38	$ignore[] = 'createdon';
39
40	$dbo = JFactory::getDbo();
41
42	// get taxes rules children model
43	$ruleModel = JModelVAP::getInstance('taxrule');
44
45	// DO NOT copy translation because of the complexity
46	// between the tax-rule and taxlang-rulelang
47	// relations
48
49	foreach ($ids as $id_tax)
50	{
51	// start by duplicating the whole record
52	$new_id = parent::duplicate($id_tax, $src, $ignore);
53
54	if ($new_id)
55	{
56	$new_id = array_shift($new_id);
57
58	// register copied
59	$new_ids[] = $new_id;
60
61	// load any children rule
62	$q = $dbo->getQuery(true)
63	->select($dbo->qn('id'))
64	->from($dbo->qn('#__vikappointments_tax_rule'))
65	->where($dbo->qn('id_tax') . ' = ' . (int) $id_tax);
66
67	$dbo->setQuery($q);
68
69	if ($duplicate = $dbo->loadColumn())
70	{
71	$rule_data = array();
72	$rule_data['id_tax'] = $new_id;
73
74	// duplicate rules by using the new tax ID
75	$ruleModel->duplicate($duplicate, $rule_data);
76	}
77	}
78	}
79
80	return $new_ids;
81	}
82
83	/**
84	* Extend delete implementation to delete any related records
85	* stored within a separated table.
86	*
87	* @param mixed $ids Either the record ID or a list of records.
88	*
89	* @return boolean True on success, false otherwise.
90	*/
91	public function delete($ids)
92	{
93	// only int values are accepted
94	$ids = array_map('intval', (array) $ids);
95
96	// invoke parent first
97	if (!parent::delete($ids))
98	{
99	// nothing to delete
100	return false;
101	}
102
103	$dbo = JFactory::getDbo();
104
105	// load any assigned translation
106	$q = $dbo->getQuery(true)
107	->select($dbo->qn('id'))
108	->from($dbo->qn('#__vikappointments_lang_tax'))
109	->where($dbo->qn('id_tax') . ' IN (' . implode(',', $ids) . ')' );
110
111	$dbo->setQuery($q);
112
113	if ($lang_ids = $dbo->loadColumn())
114	{
115	// get translation model
116	$model = JModelVAP::getInstance('langtax');
117	// delete assigned translations
118	$model->delete($lang_ids);
119	}
120
121	// load any children rules
122	$q = $dbo->getQuery(true)
123	->select($dbo->qn('id'))
124	->from($dbo->qn('#__vikappointments_tax_rule'))
125	->where($dbo->qn('id_tax') . ' IN (' . implode(',', $ids) . ')' );
126
127	$dbo->setQuery($q);
128
129	if ($rule_ids = $dbo->loadColumn())
130	{
131	// get rule model
132	$model = JModelVAP::getInstance('taxrule');
133	// delete children
134	$model->delete($rule_ids);
135	}
136
137	return true;
138	}
139	}
140