cronjoblog.php — VikAppointments Services Booking Calendar 1.2.20

vikappointments / admin / models / cronjoblog.php

vikappointments / admin / models Last commit date

cronjoblog.php

133 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 cron job log model.
18	*
19	* @since 1.7
20	*/
21	class VikAppointmentsModelCronjoblog extends JModelVAP
22	{
23	/**
24	* Basic save implementation.
25	*
26	* @param mixed $data Either an array or an object of data to save.
27	*
28	* @return mixed The ID of the record on success, false otherwise.
29	*/
30	public function save($data)
31	{
32	// fetch cron logging mode:
33	// - [1] only with errors
34	// - [2] always
35	$cron_logging_mode = VAPFactory::getConfig()->getUint('cron_log_mode');
36
37	// auto-flush existing logs first
38	$this->flush(@$data['id_cronjob']);
39
40	if ($cron_logging_mode == 1 && !empty($data['status']))
41	{
42	// get last succesful log
43	$last = $this->getItem(array(
44	'id_cronjob' => @$data['id_cronjob'],
45	'status' => 1,
46	));
47
48	if ($last)
49	{
50	// delete log found
51	$this->delete($last->id);
52	}
53	}
54
55	// attempt to save the cron job log
56	return parent::save($data);
57	}
58
59	/**
60	* Method to truncate the table.
61	*
62	* @param int $id_cron An optional ID to delete all the logs assigned to the
63	* specified cron job.
64	*
65	* @return bool True on success, false otherwise.
66	*
67	* @since 1.7.3
68	*/
69	public function truncate($id_cron = null)
70	{
71	$dbo = JFactory::getDbo();
72
73	if ($id_cron)
74	{
75	// delete only the logs assigned to the specified cron job
76	$q = $dbo->getQuery(true)
77	->delete($dbo->qn('#__vikappointments_cronjob_log'))
78	->where($dbo->qn('id_cronjob') . ' = ' . (int) $id_cron);
79	}
80	else
81	{
82	// truncate all the logs registered by any cron jobs
83	$q = "TRUNCATE TABLE " . $dbo->qn('#__vikappointments_cronjob_log');
84	}
85
86	$dbo->setQuery($q);
87	return $dbo->execute();
88	}
89
90	/**
91	* Flushes all the cron logs that are at least N days in the past, where
92	* N is equals to the passed argument.
93	*
94	* @param int $id_cron An optional cron ID to flush only the logs
95	* assigned to the latter.
96	* @param int\|null $days The threshold in days. Use the defaul system
97	* setting when not specified.
98	*
99	* @return void
100	*
101	* @since 1.7.3
102	*/
103	public function flush($id_cron = null, $days = null)
104	{
105	if (is_null($days))
106	{
107	// use global setting
108	$days = VAPFactory::getConfig()->getUint('cron_log_flush', 0);
109	}
110
111	if ($days > 0)
112	{
113	$dbo = JFactory::getDbo();
114
115	$now = JFactory::getDate();
116	$now->modify('-' . $days . ' days');
117
118	$q = $dbo->getQuery(true)
119	->delete($dbo->qn('#__vikappointments_cronjob_log'))
120	->where($dbo->qn('createdon') . ' < ' . $dbo->q($now->toSql()));
121
122	if ($id_cron)
123	{
124	// filter logs by cron job
125	$q->where($dbo->qn('id_cronjob') . ' = ' . (int) $id_cron);
126	}
127
128	$dbo->setQuery($q);
129	$dbo->execute();
130	}
131	}
132	}
133