state.php — VikAppointments Services Booking Calendar 1.2.21

vikappointments / admin / tables / state.php

vikappointments / admin / tables Last commit date

state.php

126 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 state table.
16	*
17	* @since 1.7
18	*/
19	class VAPTableState 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_states', 'id', $db);
29
30	// register required fields
31	$this->_requiredFields[] = 'state_name';
32	$this->_requiredFields[] = 'state_2_code';
33	$this->_requiredFields[] = 'id_country';
34	}
35
36	/**
37	* Method to bind an associative array or object to the Table instance. This
38	* method only binds properties that are publicly accessible and optionally
39	* takes an array of properties to ignore when binding.
40	*
41	* @param array\|object $src An associative array or object to bind to the Table instance.
42	* @param array\|string $ignore An optional array or space separated list of properties to ignore while binding.
43	*
44	* @return boolean True on success.
45	*/
46	public function bind($src, $ignore = array())
47	{
48	$src = (array) $src;
49
50	if (isset($src['state_2_code']))
51	{
52	// use only uppercase letters
53	$src['state_2_code'] = strtoupper($src['state_2_code']);
54	}
55
56	if (isset($src['state_3_code']))
57	{
58	// use only uppercase letters
59	$src['state_3_code'] = strtoupper($src['state_3_code']);
60	}
61
62	// bind the details before save
63	return parent::bind($src, $ignore);
64	}
65
66	/**
67	* Method to perform sanity checks on the Table instance properties to
68	* ensure they are safe to store in the database.
69	*
70	* @return boolean True if the instance is sane and able to be stored in the database.
71	*/
72	public function check()
73	{
74	// check integrity using parent
75	if (!parent::check())
76	{
77	return false;
78	}
79
80	// in case of state codes, make sure we are not going to create duplicated
81	if (!empty($this->state_2_code) \|\| !empty($this->state_3_code))
82	{
83	if (empty($this->id_country))
84	{
85	// the country ID is mandatory when changing a unique code
86	$this->setError(JText::sprintf('VAP_INVALID_REQ_FIELD', JText::translate('VAPMANAGECUSTOMER5')));
87
88	return false;
89	}
90
91	$dbo = JFactory::getDbo();
92
93	$q = $dbo->getQuery(true);
94
95	if ($this->state_2_code)
96	{
97	$where[] = $dbo->qn('state_2_code') . ' = ' . $dbo->q($this->state_2_code);
98	}
99
100	if ($this->state_3_code)
101	{
102	$where[] = $dbo->qn('state_3_code') . ' = ' . $dbo->q($this->state_3_code);
103	}
104
105	$q->select(1);
106	$q->from($dbo->qn($this->getTableName()));
107	$q->where($dbo->qn('id') . ' <> ' . (int) $this->id);
108	$q->where($dbo->qn('id_country') . ' = ' . (int) $this->id_country);
109	$q->andWhere($where, 'OR');
110
111	$dbo->setQuery($q, 0, 1);
112	$dbo->execute();
113
114	if ($dbo->getNumRows() > 0)
115	{
116	// a state already exists with the given code(s)
117	$this->setError(JText::translate('VAPSTATEUNIQUEERROR'));
118
119	return false;
120	}
121	}
122
123	return true;
124	}
125	}
126