PluginProbe ʕ •ᴥ•ʔ
VikAppointments Services Booking Calendar / 1.2.21
VikAppointments Services Booking Calendar v1.2.21
1.2.21 1.2.20 trunk 1.2.17 1.2.18 1.2.19
vikappointments / admin / tables / service.php
vikappointments / admin / tables Last commit date
apiban.php 3 days ago apilog.php 3 days ago apiuser.php 3 days ago apiuseroptions.php 3 days ago city.php 3 days ago configuration.php 3 days ago conversion.php 3 days ago country.php 3 days ago coupon.php 3 days ago couponemployee.php 3 days ago coupongroup.php 3 days ago couponservice.php 3 days ago cronjob.php 3 days ago cronjoblog.php 3 days ago customer.php 3 days ago customf.php 3 days ago customfservice.php 3 days ago empgroup.php 3 days ago employee.php 3 days ago empsettings.php 3 days ago group.php 3 days ago index.html 3 days ago invoice.php 3 days ago langcustomf.php 3 days ago langempgroup.php 3 days ago langemployee.php 3 days ago langgroup.php 3 days ago langmedia.php 3 days ago langoption.php 3 days ago langoptiongroup.php 3 days ago langoptionvar.php 3 days ago langpackage.php 3 days ago langpackgroup.php 3 days ago langpayment.php 3 days ago langservice.php 3 days ago langstatuscode.php 3 days ago langsubscr.php 3 days ago langtax.php 3 days ago langtaxrule.php 3 days ago location.php 3 days ago mailtext.php 3 days ago media.php 3 days ago option.php 3 days ago optiongroup.php 3 days ago optionvar.php 3 days ago orderstatus.php 3 days ago package.php 3 days ago packageservice.php 3 days ago packgroup.php 3 days ago packorder.php 3 days ago packorderitem.php 3 days ago payment.php 3 days ago rate.php 3 days ago reservation.php 3 days ago resoptassoc.php 3 days ago restriction.php 3 days ago review.php 3 days ago serempassoc.php 3 days ago seroptassoc.php 3 days ago serrateassoc.php 3 days ago serrestrassoc.php 3 days ago service.php 3 days ago state.php 3 days ago statswidget.php 3 days ago statuscode.php 3 days ago subscription.php 3 days ago subscrorder.php 3 days ago tag.php 3 days ago tax.php 3 days ago taxrule.php 3 days ago usernote.php 3 days ago waitinglist.php 3 days ago webhook.php 3 days ago worktime.php 3 days ago
service.php
150 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 service table.
16 *
17 * @since 1.7
18 */
19 class VAPTableService 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_service', 'id', $db);
29
30 // register required fields
31 $this->_requiredFields[] = 'name';
32 }
33
34 /**
35 * Method to bind an associative array or object to the Table instance. This
36 * method only binds properties that are publicly accessible and optionally
37 * takes an array of properties to ignore when binding.
38 *
39 * @param array|object $src An associative array or object to bind to the Table instance.
40 * @param array|string $ignore An optional array or space separated list of properties to ignore while binding.
41 *
42 * @return boolean True on success.
43 */
44 public function bind($src, $ignore = array())
45 {
46 $src = (array) $src;
47
48 // fetch ordering for new record
49 if (empty($src['id']))
50 {
51 $src['ordering'] = $this->getNextOrder();
52
53 if (empty($src['color']))
54 {
55 // assign random color to service
56 $src['color'] = $this->getRandomColor($src['ordering']);
57 }
58
59 $src['id'] = 0;
60 }
61
62 if (isset($src['max_capacity']))
63 {
64 // max capacity cannot be lower than 1
65 $src['max_capacity'] = max(array($src['max_capacity'], 1));
66
67 if ($src['max_capacity'] == 1)
68 {
69 // unset related settings in case of single capacity
70 $src['app_per_slot'] = 1;
71 $src['display_seats'] = 0;
72 }
73 }
74
75 if (isset($src['max_per_res']) && isset($src['max_capacity']))
76 {
77 // validate max number of people against capacity
78 $src['max_per_res'] = min(array($src['max_per_res'], $src['max_capacity']));
79 }
80
81 if (isset($src['min_per_res']) && isset($src['max_per_res']))
82 {
83 // validate min number of people against max
84 $src['min_per_res'] = min(array($src['min_per_res'], $src['max_per_res']));
85 }
86
87 // generate alias in case it is empty when creating or updating
88 if (empty($src['alias']) && (empty($src['id']) || isset($src['alias'])))
89 {
90 // generate unique alias starting from name
91 $src['alias'] = $src['name'];
92 }
93
94 // check if we are going to update an empty alias
95 if (isset($src['alias']) && strlen($src['alias']) == 0)
96 {
97 // avoid to update an empty alias by using a unique ID
98 $src['alias'] = uniqid();
99 }
100
101 if (!empty($src['alias']))
102 {
103 VAPLoader::import('libraries.sef.helper');
104 // make sure the alias is unique
105 $src['alias'] = VAPSefHelper::getUniqueAlias($src['alias'], 'service', $src['id']);
106 }
107
108 if (isset($src['attachments']) && !is_string($src['attachments']))
109 {
110 // stringify attachments list
111 $src['attachments'] = json_encode($src['attachments']);
112 }
113
114 if (isset($src['metadata']) && !is_string($src['metadata']))
115 {
116 // stringify metadata array/object
117 $src['metadata'] = json_encode($src['metadata']);
118 }
119
120 if (!empty($src['layout']))
121 {
122 // make class suffix safe
123 $src['layout'] = preg_replace("/[^a-zA-Z0-9_\-\s]+/", '', (string) $src['layout']);
124 }
125
126 // bind the details before save
127 return parent::bind($src, $ignore);
128 }
129
130 /**
131 * Fetches a random color to assign to the service
132 * based on the current ordering, so that we can
133 * maintain a progressive logic.
134 *
135 * @param integer $ordering The current ordering.
136 *
137 * @return string The service color.
138 */
139 protected function getRandomColor($ordering = 1)
140 {
141 // get list of preset colors
142 $colors = JHtml::fetch('vaphtml.color.preset', $array = true, $group = false);
143
144 // find next one
145 $i = (abs($ordering) - 1) % count($colors);
146
147 return $colors[$i];
148 }
149 }
150