reservation.php — VikAppointments Services Booking Calendar 1.2.21

vikappointments / admin / tables / reservation.php

vikappointments / admin / tables Last commit date

reservation.php

132 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 appointment table.
16	*
17	* @since 1.7
18	*/
19	class VAPTableReservation 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_reservation', 'id', $db);
29	}
30
31	/**
32	* Method to bind an associative array or object to the Table instance. This
33	* method only binds properties that are publicly accessible and optionally
34	* takes an array of properties to ignore when binding.
35	*
36	* @param array\|object $src An associative array or object to bind to the Table instance.
37	* @param array\|string $ignore An optional array or space separated list of properties to ignore while binding.
38	*
39	* @return boolean True on success.
40	*/
41	public function bind($src, $ignore = array())
42	{
43	$src = (array) $src;
44
45	if (empty($src['id']))
46	{
47	$src['createdon'] = JFactory::getDate()->toSql();
48	$src['createdby'] = JFactory::getUser()->id;
49
50	if (!isset($src['sid']))
51	{
52	// generate order key
53	$src['sid'] = VikAppointments::generateSerialCode(16, 'appointment-sid');
54	// generate confirmation key
55	$src['conf_key'] = VikAppointments::generateSerialCode(12, 'appointment-confkey');
56	}
57	}
58
59	if (isset($src['total_cost']))
60	{
61	// total cost cannot be lower than 0
62	$src['total_cost'] = max(array(0, (float) $src['total_cost']));
63	}
64
65	if (isset($src['duration']))
66	{
67	// duration cannot be lower than 1
68	$src['duration'] = max(array(1, (int) $src['duration']));
69	}
70
71	if (isset($src['custom_f']) && !is_string($src['custom_f']))
72	{
73	// encode array/object in JSON format
74	$src['custom_f'] = json_encode($src['custom_f']);
75	}
76
77	if (isset($src['attendees']) && !is_string($src['attendees']))
78	{
79	// encode array/object in JSON format
80	$src['attendees'] = json_encode($src['attendees']);
81	}
82
83	if (isset($src['uploads']) && !is_string($src['uploads']))
84	{
85	// encode array in JSON format
86	$src['uploads'] = json_encode($src['uploads']);
87	}
88
89	if (isset($src['fields_data']))
90	{
91	$src['fields_data'] = (array) $src['fields_data'];
92
93	$lookup = array(
94	'purchaser_nominative',
95	'purchaser_mail',
96	'purchaser_phone',
97	'purchaser_prefix',
98	'purchaser_country',
99	);
100
101	// set up billing according to the specified custom fields,
102	// only in case the targeted field is empty
103	foreach ($lookup as $k)
104	{
105	if (empty($src[$k]) && !empty($src['fields_data'][$k]))
106	{
107	$src[$k] = $src['fields_data'][$k];
108	}
109	}
110	}
111
112	// stringify coupon code when passed as array/object
113	if (isset($src['coupon']) && !is_string($src['coupon']))
114	{
115	$cpn = (array) $src['coupon'];
116	$src['coupon_str'] = $cpn['code'] . ';;' . $cpn['percentot'] . ';;' . $cpn['value'];
117	}
118
119	if (isset($src['cc_data']) && !is_string($src['cc_data']))
120	{
121	// encode array/object in JSON format
122	$src['cc_data'] = json_encode($src['cc_data']);
123	}
124
125	// always calculate lock time after creating/updating a reservation
126	$src['locked_until'] = strtotime('+' . VAPFactory::getConfig()->getUint('keepapplock') . 'minutes');
127
128	// bind the details before save
129	return parent::bind($src, $ignore);
130	}
131	}
132