employee.php — VikAppointments Services Booking Calendar 1.2.21

vikappointments / admin / tables / employee.php

vikappointments / admin / tables Last commit date

employee.php

109 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 employee table.
16	*
17	* @since 1.7
18	*/
19	class VAPTableEmployee 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_employee', 'id', $db);
29
30	// register required fields
31	$this->_requiredFields[] = 'firstname';
32	$this->_requiredFields[] = 'lastname';
33	$this->_requiredFields[] = 'nickname';
34	}
35
36	/**
37	* Method to bind an associative array or object to the Table instance. This
38	* method only binds properties that are publicly accessible and optionally
39	* takes an array of properties to ignore when binding.
40	*
41	* @param array\|object $src An associative array or object to bind to the Table instance.
42	* @param array\|string $ignore An optional array or space separated list of properties to ignore while binding.
43	*
44	* @return boolean True on success.
45	*/
46	public function bind($src, $ignore = array())
47	{
48	$src = (array) $src;
49
50	if (empty($src['id']))
51	{
52	if (empty($src['synckey']))
53	{
54	// generate sync key
55	$src['synckey'] = VikAppointments::generateSerialCode(12, 'employee-synckey');
56	}
57
58	$src['id'] = 0;
59	}
60
61	// generate alias in case it is empty when creating or updating
62	if (empty($src['alias']) && (empty($src['id']) \|\| isset($src['alias'])))
63	{
64	// generate unique alias starting from nominative
65	$src['alias'] = $src['nickname'];
66	}
67
68	// check if we are going to update an empty alias
69	if (isset($src['alias']) && strlen($src['alias']) == 0)
70	{
71	// avoid to update an empty alias by using a unique ID
72	$src['alias'] = uniqid();
73	}
74
75	if (!empty($src['alias']))
76	{
77	VAPLoader::import('libraries.sef.helper');
78	// make sure the alias is unique
79	$src['alias'] = VAPSefHelper::getUniqueAlias($src['alias'], 'employee', $src['id']);
80	}
81
82	if (isset($src['active_to']) && $src['active_to'] != 1)
83	{
84	// use null date in case the activation is set to LIFETIME or PENDING
85	$src['active_to_date'] = JFactory::getDbo()->getNullDate();
86	}
87
88	if (isset($src['synckey']) && !$src['synckey'])
89	{
90	// avoid updating an empty key
91	unset($src['synckey']);
92	}
93
94	// iterate custom fields
95	foreach ($src as $k => $v)
96	{
97	// make sure the property starts with "field_" and it is not scalar
98	if (preg_match("/^field_/", $k) && $v && !is_scalar($v))
99	{
100	// JSON encode the property value for correct saving
101	$src[$k] = json_encode($v);
102	}
103	}
104
105	// bind the details before save
106	return parent::bind($src, $ignore);
107	}
108	}
109