usernote.php — VikAppointments Services Booking Calendar 1.2.20

vikappointments / admin / tables / usernote.php

vikappointments / admin / tables Last commit date

usernote.php

102 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 user note table.
16	*
17	* @since 1.7
18	*/
19	class VAPTableUsernote 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_user_notes', '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	$now = JFactory::getDate()->toSql();
46
47	if (empty($src['id']))
48	{
49	// set creation date and author
50	$src['createdon'] = $now;
51	$src['author'] = JFactory::getUser()->id;
52	}
53	else
54	{
55	if (!isset($src['modifiedon']))
56	{
57	// auto-fill modification date
58	$src['modifiedon'] = $now;
59	}
60	}
61
62	if (empty($src['title']))
63	{
64	// missing title, use a default text "Y-m-d H:i:s"
65	$src['title'] = JHtml::fetch('date', $now, JText::translate('DATE_FORMAT_LC6'));
66	}
67
68	if (isset($src['attachments']))
69	{
70	if (!is_array($src['attachments']))
71	{
72	// convert JSON string into an array
73	$src['attachments'] = json_decode($src['attachments']);
74	}
75
76	// get rid of the base upload path to save space
77	$src['attachments'] = array_map(function($path)
78	{
79	return str_replace(VAPCUSTOMERS_DOCUMENTS . DIRECTORY_SEPARATOR, '', $path);
80	}, $src['attachments']);
81
82	if ($src['attachments'] && empty($src['secret']))
83	{
84	// extract secret key from last uploaded file
85	$src['secret'] = basename(dirname(end($src['attachments'])));
86	}
87
88	// stringify attachments in JSON
89	$src['attachments'] = json_encode($src['attachments']);
90	}
91
92	if (isset($src['tags']) && !is_string($src['tags']))
93	{
94	// stringify tags in a comma-separated list
95	$src['tags'] = implode(',', $src['tags']);
96	}
97
98	// bind the details before save
99	return parent::bind($src, $ignore);
100	}
101	}
102