coupon.php — VikAppointments Services Booking Calendar 1.2.20

vikappointments / admin / tables / coupon.php

vikappointments / admin / tables Last commit date

coupon.php

147 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	/**
15	* VikAppointments coupon table.
16	*
17	* @since 1.7
18	*/
19	class VAPTableCoupon extends JTableVAP
20	{
21	/**
22	* Class constructor.
23	*
24	* @param object $db The database driver instance.
25	*/
26	public function __construct($db)
27	{
28	parent::__construct('#__vikappointments_coupon', 'id', $db);
29
30	// register required fields
31	$this->_requiredFields[] = 'code';
32	}
33
34	/**
35	* Method to bind an associative array or object to the Table instance. This
36	* method only binds properties that are publicly accessible and optionally
37	* takes an array of properties to ignore when binding.
38	*
39	* @param array\|object $src An associative array or object to bind to the Table instance.
40	* @param array\|string $ignore An optional array or space separated list of properties to ignore while binding.
41	*
42	* @return boolean True on success.
43	*/
44	public function bind($src, $ignore = array())
45	{
46	$src = (array) $src;
47
48	// auto-generate the coupon code if not specified
49	if ((empty($src['id']) \|\| isset($src['code'])) && empty($src['code']))
50	{
51	$src['code'] = VikAppointments::generateSerialCode(12, 'coupon');
52	}
53
54	if (!empty($src['code']))
55	{
56	/**
57	* Sanitize coupon code. Only the following characters are accepted:
58	* - letters (a-z and A-Z)
59	* - numbers (0-9)
60	* - hyphens (-) and underscores (_)
61	*
62	* @since 1.7
63	*/
64	$src['code'] = preg_replace("/[^a-zA-Z0-9\-_]+/", '', $src['code']);
65	}
66
67	// make sure the type is an accepted value
68	if (isset($src['type']) && !in_array($src['type'], array(1, 2)))
69	{
70	// set the default PERMANENT type
71	$src['type'] = 1;
72	}
73
74	// make sure the percentot is an accepted value
75	if (isset($src['type']) && !in_array($src['percentot'], array(1, 2)))
76	{
77	// set the default TOTAL type
78	$src['percentot'] = 2;
79	}
80
81	// only positive amount
82	if (isset($src['value']))
83	{
84	$src['value'] = abs($src['value']);
85	}
86
87	// only positive amount
88	if (isset($src['mincost']))
89	{
90	$src['mincost'] = abs($src['mincost']);
91	}
92
93	// make sure the start date is not higher than the end date
94	if (isset($src['dstart']) && isset($src['dend']) && $src['dstart'] > $src['dend'] && !VAPDateHelper::isNull($src['dend']))
95	{
96	// swap the specified dates
97	$app = $src['dstart'];
98	$src['dstart'] = $src['dend'];
99	$src['dend'] = $app;
100	}
101
102	// bind the details before save
103	return parent::bind($src, $ignore);
104	}
105
106	/**
107	* Method to perform sanity checks on the Table instance properties to
108	* ensure they are safe to store in the database.
109	*
110	* @return boolean True if the instance is sane and able to be stored in the database.
111	*/
112	public function check()
113	{
114	// check integrity using parent
115	if (!parent::check())
116	{
117	return false;
118	}
119
120	// in case of coupon code, make sure we are not going to create a duplicate
121	if (!empty($this->code))
122	{
123	$dbo = JFactory::getDbo();
124
125	$q = $dbo->getQuery(true);
126
127	$q->select(1);
128	$q->from($dbo->qn($this->getTableName()));
129	$q->where($dbo->qn('id') . ' <> ' . (int) $this->id);
130	$q->where($dbo->qn('code') . ' = ' . $dbo->q($this->code));
131
132	$dbo->setQuery($q, 0, 1);
133	$dbo->execute();
134
135	if ($dbo->getNumRows() > 0)
136	{
137	// a coupon already exists with the given code
138	$this->setError(JText::translate('VAPCOUPONDUPLICATEERR'));
139
140	return false;
141	}
142	}
143
144	return true;
145	}
146	}
147