apilog.php — VikAppointments Services Booking Calendar 1.2.20

vikappointments / admin / models / apilog.php

vikappointments / admin / models Last commit date

apilog.php

115 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 API log model.
18	*
19	* @since 1.7
20	*/
21	class VikAppointmentsModelApilog extends JModelVAP
22	{
23	/**
24	* Extend delete implementation to delete any related records
25	* stored within a separated table.
26	*
27	* @param mixed $ids Either the record ID or a list of records.
28	*
29	* @return boolean True on success, false otherwise.
30	*/
31	public function delete($ids)
32	{
33	// only int values are accepted
34	$ids = array_map('intval', (array) $ids);
35
36	if (!$ids)
37	{
38	// nothing to delete
39	return false;
40	}
41
42	$dbo = JFactory::getDbo();
43
44	// find number of existing logs
45	$q = $dbo->getQuery(true)
46	->select('COUNT(1)')
47	->from($dbo->qn('#__vikappointments_api_login_logs'));
48
49	$dbo->setQuery($q, 0, 1);
50
51	if ((int) $dbo->loadResult() == count($ids))
52	{
53	// truncate all in case the user selected all the existing logs
54	return $this->truncate();
55	}
56
57	// otherwise invoke parent to delete logs
58	return parent::delete($ids);
59	}
60
61	/**
62	* Method to truncate the table.
63	*
64	* @param integer $id_login An optional ID to delete all the logs assigned to the
65	* specified account.
66	*
67	* @return boolean True on success.
68	*/
69	public function truncate($id_login = null)
70	{
71	$dbo = JFactory::getDbo();
72
73	if ($id_login)
74	{
75	// delete only the logs assigned to the specified account
76	$q = $dbo->getQuery(true)
77	->delete($dbo->qn('#__vikappointments_api_login_logs'))
78	->where($dbo->qn('id_login') . ' = ' . (int) $id_login);
79	}
80	else
81	{
82	// truncate API logs
83	$q = "TRUNCATE TABLE " . $dbo->qn('#__vikappointments_api_login_logs');
84	}
85
86	$dbo->setQuery($q);
87	return $dbo->execute();
88	}
89
90	/**
91	* Flushes older API logs.
92	*
93	* @return void
94	*/
95	public function flush()
96	{
97	$factor = VAPFactory::getConfig()->getUint('apilogflush');
98
99	if ($factor > 0)
100	{
101	$dbo = JFactory::getDbo();
102
103	$now = JFactory::getDate();
104	$now->modify('-' . $factor . ' days');
105
106	$q = $dbo->getQuery(true)
107	->delete($dbo->qn('#__vikappointments_api_login_logs'))
108	->where($dbo->qn('createdon') . ' < ' . $dbo->q($now->toSql()));
109
110	$dbo->setQuery($q);
111	$dbo->execute();
112	}
113	}
114	}
115