apiuser.php — VikAppointments Services Booking Calendar 1.2.20

vikappointments / admin / tables / apiuser.php

vikappointments / admin / tables Last commit date

apiuser.php

119 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 API user table.
16	*
17	* @since 1.7
18	*/
19	class VAPTableApiuser 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_api_login', 'id', $db);
29
30	// register required fields
31	$this->_requiredFields[] = 'username';
32	$this->_requiredFields[] = 'password';
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	// properly format "denied plugins" list
50	if (isset($src['denied']) && is_array($src['denied']))
51	{
52	$src['denied'] = json_encode($src['denied']);
53	}
54
55	// properly format "allowed IPs" list
56	if (isset($src['ips']) && is_array($src['ips']))
57	{
58	$src['ips'] = json_encode($src['ips']);
59	}
60
61	if (isset($src['last_login']))
62	{
63	// last ping specified, fetch current date and time
64	if ($src['last_login'] === 'now' \|\| $src['last_login'] === true \|\| $src['last_login'] === 1)
65	{
66	$src['last_login'] = JFactory::getDate()->toSql();
67	}
68	}
69
70	// bind the details before save
71	return parent::bind($src, $ignore);
72	}
73
74	/**
75	* Method to perform sanity checks on the Table instance properties to
76	* ensure they are safe to store in the database.
77	*
78	* @return boolean True if the instance is sane and able to be stored in the database.
79	*/
80	public function check()
81	{
82	// check integrity using parent
83	if (!parent::check())
84	{
85	return false;
86	}
87
88	// make sure the username doesn't already exist
89	if (isset($this->username))
90	{
91	$dbo = JFactory::getDbo();
92
93	$q = $dbo->getQuery(true)
94	->select(1)
95	->from($dbo->qn($this->getTableName()))
96	->where($dbo->qn('username') . ' = ' . $dbo->q($this->username));
97
98	if ($this->id)
99	{
100	$q->where($dbo->qn('id') . ' <> ' . (int) $this->id);
101	}
102
103	$dbo->setQuery($q, 0, 1);
104	$dbo->execute();
105
106	if ($dbo->getNumRows())
107	{
108	// register error message
109	$this->setError(JText::translate('VAPAPIUSERUSERNAMEEXISTS'));
110
111	// invalid start date
112	return false;
113	}
114	}
115
116	return true;
117	}
118	}
119