review.php — VikAppointments Services Booking Calendar 1.2.21

vikappointments / admin / tables / review.php

vikappointments / admin / tables Last commit date

review.php

98 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 review table.
16	*
17	* @since 1.7
18	*/
19	class VAPTableReview 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_reviews', 'id', $db);
29
30	// register required fields
31	$this->_requiredFields[] = 'title';
32	$this->_requiredFields[] = 'name';
33	$this->_requiredFields[] = 'email';
34	$this->_requiredFields[] = 'timestamp';
35	}
36
37	/**
38	* Method to bind an associative array or object to the Table instance. This
39	* method only binds properties that are publicly accessible and optionally
40	* takes an array of properties to ignore when binding.
41	*
42	* @param array\|object $src An associative array or object to bind to the Table instance.
43	* @param array\|string $ignore An optional array or space separated list of properties to ignore while binding.
44	*
45	* @return boolean True on success.
46	*/
47	public function bind($src, $ignore = array())
48	{
49	$src = (array) $src;
50
51	if (isset($src['rating']))
52	{
53	// the rating must be in the range [1,5]
54	$src['rating'] = min(array(5, (int) $src['rating']));
55	$src['rating'] = max(array(1, (int) $src['rating']));
56	}
57
58	if ((empty($src['id']) \|\| isset($src['timestamp'])) && (empty($src['timestamp']) \|\| VAPDateHelper::isNull($src['timestamp'])))
59	{
60	// use current date and time
61	$src['timestamp'] = JFactory::getDate()->toSql();
62	}
63
64	if ((empty($src['id']) \|\| isset($src['langtag'])) && empty($src['langtag']))
65	{
66	// use current lang tag if empty or missing while creating a new review
67	$src['langtag'] = JFactory::getLanguage()->getTag();
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	// when creating a new review, make sure at least one between
89	// service and employee have been selected
90	if (empty($this->id) && (int) $this->id_service <= 0 && (int) $this->id_employee <= 0)
91	{
92	return false;
93	}
94
95	return true;
96	}
97	}
98