city.php — VikAppointments Services Booking Calendar 1.2.21

vikappointments / admin / tables / city.php

vikappointments / admin / tables Last commit date

city.php

155 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 city table.
16	*
17	* @since 1.7
18	*/
19	class VAPTableCity 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_cities', 'id', $db);
29
30	// register required fields
31	$this->_requiredFields[] = 'city_name';
32	$this->_requiredFields[] = 'id_state';
33	}
34
35	/**
36	* Method to bind an associative array or object to the Table instance. This
37	* method only binds properties that are publicly accessible and optionally
38	* takes an array of properties to ignore when binding.
39	*
40	* @param array\|object $src An associative array or object to bind to the Table instance.
41	* @param array\|string $ignore An optional array or space separated list of properties to ignore while binding.
42	*
43	* @return boolean True on success.
44	*/
45	public function bind($src, $ignore = array())
46	{
47	$src = (array) $src;
48
49	if (isset($src['city_2_code']))
50	{
51	// use only uppercase letters
52	$src['city_2_code'] = strtoupper($src['city_2_code']);
53	}
54
55	if (isset($src['city_3_code']))
56	{
57	// use only uppercase letters
58	$src['city_3_code'] = strtoupper($src['city_3_code']);
59	}
60
61	if (isset($src['latitude']) && strlen($src['latitude']))
62	{
63	// latitude must be in the range of [-90, 90]
64	if ($src['latitude'] < -90 \|\| $src['latitude'] > 90)
65	{
66	// invalid latitude, unset it
67	$src['latitude'] = '';
68	}
69	}
70
71	if (isset($src['longitude']) && strlen($src['longitude']))
72	{
73	// longitude must be in the range of [-180, 180]
74	if ($src['longitude'] < -180 \|\| $src['longitude'] > 180)
75	{
76	// invalid longitude, unset it
77	$src['longitude'] = '';
78	}
79	}
80
81	if ((isset($src['latitude']) && strlen($src['latitude']) == 0)
82	\|\| (isset($src['longitude']) && strlen($src['longitude']) == 0))
83	{
84	// unset both lat and lng in case at least one of them is invalid
85	$src['latitude'] = $src['longitude'] = null;
86
87	// force update of NULL columns
88	$this->_updateNulls = true;
89	}
90
91	// bind the details before save
92	return parent::bind($src, $ignore);
93	}
94
95	/**
96	* Method to perform sanity checks on the Table instance properties to
97	* ensure they are safe to store in the database.
98	*
99	* @return boolean True if the instance is sane and able to be stored in the database.
100	*/
101	public function check()
102	{
103	// check integrity using parent
104	if (!parent::check())
105	{
106	return false;
107	}
108
109	// in case of city codes, make sure we are not going to create duplicated
110	if (!empty($this->city_2_code) \|\| !empty($this->city_3_code))
111	{
112	if (empty($this->id_state))
113	{
114	// the state ID is mandatory when changing a unique code
115	$this->setError(JText::sprintf('VAP_INVALID_REQ_FIELD', JText::translate('VAPMANAGEEMPLOCATION2')));
116
117	return false;
118	}
119
120	$dbo = JFactory::getDbo();
121
122	$q = $dbo->getQuery(true);
123
124	if ($this->city_2_code)
125	{
126	$where[] = $dbo->qn('city_2_code') . ' = ' . $dbo->q($this->city_2_code);
127	}
128
129	if ($this->city_3_code)
130	{
131	$where[] = $dbo->qn('city_3_code') . ' = ' . $dbo->q($this->city_3_code);
132	}
133
134	$q->select(1);
135	$q->from($dbo->qn($this->getTableName()));
136	$q->where($dbo->qn('id') . ' <> ' . $this->id);
137	$q->where($dbo->qn('id_state') . ' = ' . (int) $this->id_state);
138	$q->andWhere($where, 'OR');
139
140	$dbo->setQuery($q, 0, 1);
141	$dbo->execute();
142
143	if ($dbo->getNumRows() > 0)
144	{
145	// a city already exists with the given code(s)
146	$this->setError(JText::translate('VAPCITYUNIQUEERROR'));
147
148	return false;
149	}
150	}
151
152	return true;
153	}
154	}
155