tag.php — VikAppointments Services Booking Calendar 1.2.21

vikappointments / admin / tables / tag.php

vikappointments / admin / tables Last commit date

tag.php

130 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 tag table.
16	*
17	* @since 1.7
18	*/
19	class VAPTableTag 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_tag', 'id', $db);
29
30	// register required fields
31	$this->_requiredFields[] = 'name';
32	$this->_requiredFields[] = 'group';
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	// fetch ordering for new separators
50	if (empty($src['id']))
51	{
52	$dbo = JFactory::getDbo();
53
54	// fetch next ordering
55	$src['ordering'] = $this->getNextOrder($dbo->qn('group') . ' = ' . $dbo->q(@$src['group']));
56
57	// set creation date and author
58	$src['createdon'] = JFactory::getDate()->toSql();
59	$src['author'] = JFactory::getUser()->id;
60	}
61
62	// validate color, if specified
63	if (!empty($src['color']) && !preg_match("/^#?[0-9a-f]{6,6}$/i", $src['color']))
64	{
65	// invalid color
66	$src['color'] = '';
67	}
68
69	if ((empty($src['id']) \|\| isset($src['color'])) && empty($src['color']))
70	{
71	// use random color
72	$src['color'] = JHtml::fetch('vaphtml.color.preset');
73	}
74
75	if (!empty($src['color']))
76	{
77	// always trim initial "#"
78	$src['color'] = ltrim($src['color'], '#');
79	}
80
81	// bind the details before save
82	return parent::bind($src, $ignore);
83	}
84
85	/**
86	* Method to perform sanity checks on the Table instance properties to
87	* ensure they are safe to store in the database.
88	*
89	* @return boolean True if the instance is sane and able to be stored in the database.
90	*/
91	public function check()
92	{
93	// check integrity using parent
94	if (!parent::check())
95	{
96	return false;
97	}
98
99	if (isset($this->name))
100	{
101	// make sure we are not creating a duplicate entry
102	$dbo = JFactory::getDbo();
103
104	$q = $dbo->getQuery(true)
105	->select(1)
106	->from($dbo->qn($this->getTableName()))
107	->where($dbo->qn('name') . ' = ' . $dbo->q($this->name));
108
109	if ($this->id)
110	{
111	// exclude current record
112	$q->where($dbo->qn('id') . ' <> ' . (int) $this->id);
113	}
114
115	$dbo->setQuery($q, 0, 1);
116	$dbo->execute();
117
118	if ($dbo->getNumRows())
119	{
120	// a tag with the specified name already exists
121	$this->setError('Duplicate entry.');
122
123	return false;
124	}
125	}
126
127	return true;
128	}
129	}
130