worktime.php — VikAppointments Services Booking Calendar 1.2.21

vikappointments / admin / tables / worktime.php

vikappointments / admin / tables Last commit date

worktime.php

92 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 working time table.
16	*
17	* @since 1.7
18	*/
19	class VAPTableWorktime 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_emp_worktime', 'id', $db);
29
30	// register required fields
31	$this->_requiredFields[] = 'id_employee';
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	if (!isset($src['ts']) && !empty($src['date']))
49	{
50	$src['ts'] = $src['date'];
51	}
52
53	if (isset($src['ts']))
54	{
55	// check whether we have a date string
56	if (!preg_match("/^[0-9]+$/", $src['ts']))
57	{
58	// convert it into a timestamp
59	$src['ts'] = VikAppointments::createTimestamp($src['ts'], 0, 0);
60	}
61
62	if ($src['ts'] != -1)
63	{
64	// we have a timestamp, recalculate correct day of the week
65	$src['day'] = (int) date('w', $src['ts']);
66	// create date string to be stored within the DB
67	$src['tsdate'] = JFactory::getDate(date('Y-m-d', $src['ts']))->toSql();
68	}
69	else
70	{
71	// use a null date otherwise
72	$src['tsdate'] = JFactory::getDbo()->getNullDate();
73	}
74	}
75
76	if (!isset($src['fromts']) && isset($src['from']))
77	{
78	// initial time is located in a different attribute
79	$src['fromts'] = $src['from'];
80	}
81
82	if (!isset($src['endts']) && isset($src['to']))
83	{
84	// initial time is located in a different attribute
85	$src['endts'] = $src['to'];
86	}
87
88	// bind the details before save
89	return parent::bind($src, $ignore);
90	}
91	}
92