statswidget.php — VikAppointments Services Booking Calendar 1.2.21

vikappointments / admin / models / statswidget.php

vikappointments / admin / models Last commit date

statswidget.php

108 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	VAPLoader::import('libraries.mvc.model');
15
16	/**
17	* VikAppointments statistics widget model.
18	*
19	* @since 1.7
20	*/
21	class VikAppointmentsModelStatswidget extends JModelVAP
22	{
23	/**
24	* Basic item loading implementation.
25	*
26	* @param mixed $pk An optional primary key value to load the row by, or an array of fields to match.
27	* If not set the instance property value is used.
28	* @param boolean $new True to return an empty object if missing.
29	*
30	* @return mixed The record object on success, null otherwise.
31	*/
32	public function getItem($pk, $new = false)
33	{
34	// load item through parent
35	$item = parent::getItem($pk, $new);
36
37	if ($item)
38	{
39	$item->params = $item->params ? (array) json_decode($item->params, true) : array();
40	}
41
42	return $item;
43	}
44
45	/**
46	* Returns the configuration parameters stored within the record of the specified widget ID.
47	*
48	* @param integer $id The widget ID.
49	*
50	* @return array The configuration associative array.
51	*/
52	public function getParams($id)
53	{
54	// load widget details
55	$item = $this->getItem($id);
56
57	if (!$item)
58	{
59	// return an empty configuration
60	return array();
61	}
62
63	return $item->params;
64	}
65
66	/**
67	* Extend delete implementation to delete any related records
68	* stored within a separated table.
69	*
70	* @param mixed $ids Either the record ID or a list of records.
71	*
72	* @return boolean True on success, false otherwise.
73	*/
74	public function delete($ids)
75	{
76	// only int values are accepted
77	$ids = array_map('intval', (array) $ids);
78
79	if (!$ids)
80	{
81	// nothing to delete
82	return false;
83	}
84
85	$dbo = JFactory::getDbo();
86
87	// filter the selected widgets and exclude those ones that haven't
88	// been assigned to any user, meaning they act as a demo
89	$q = $dbo->getQuery(true)
90	->select($dbo->qn('id'))
91	->from($dbo->qn('#__vikappointments_stats_widget'))
92	->where($dbo->qn('id_user') . ' > 0')
93	->where($dbo->qn('id') . ' IN (' . implode(',', $ids) . ')');
94
95	$dbo->setQuery($q);
96	$rows = $dbo->loadColumn();
97
98	if (!$rows)
99	{
100	// nothing to delete
101	return false;
102	}
103
104	// otherwise invoke parent to delete widgets
105	return parent::delete($rows);
106	}
107	}
108