apiban.php
4 years ago
apilog.php
2 years ago
apiplugin.php
4 years ago
apiuser.php
2 years ago
apiuseroptions.php
2 years ago
backup.php
5 months ago
caldays.php
1 month ago
calendar.php
1 month ago
city.php
4 years ago
closure.php
1 month ago
configapp.php
4 years ago
configcldays.php
4 years ago
configcron.php
4 years ago
configemp.php
4 years ago
configsmsapi.php
4 years ago
configuration.php
5 months ago
conversion.php
4 years ago
country.php
2 years ago
coupon.php
2 years ago
couponemployee.php
4 years ago
coupongroup.php
2 years ago
couponservice.php
4 years ago
cronjob.php
2 years ago
cronjoblog.php
4 years ago
customer.php
5 months ago
customf.php
2 years ago
customfservice.php
4 years ago
customizer.php
4 years ago
empgroup.php
2 years ago
employee.php
2 years ago
empsettings.php
4 years ago
file.php
4 years ago
findreservation.php
1 month ago
group.php
2 years ago
import.php
4 years ago
index.html
4 years ago
invoice.php
1 month ago
langcustomf.php
4 years ago
langempgroup.php
4 years ago
langemployee.php
4 years ago
langgroup.php
4 years ago
langmedia.php
4 years ago
langoption.php
2 years ago
langoptiongroup.php
4 years ago
langoptionvar.php
4 years ago
langpackage.php
4 years ago
langpackgroup.php
4 years ago
langpayment.php
4 years ago
langservice.php
4 years ago
langstatuscode.php
4 years ago
langsubscr.php
4 years ago
langtax.php
2 years ago
langtaxrule.php
4 years ago
location.php
2 years ago
mailtext.php
2 years ago
makerecurrence.php
1 month ago
media.php
2 years ago
multiorder.php
1 month ago
option.php
1 year ago
optiongroup.php
2 years ago
optionvar.php
1 year ago
orderstatus.php
2 years ago
package.php
2 years ago
packageservice.php
4 years ago
packgroup.php
2 years ago
packorder.php
2 years ago
packorderitem.php
1 month ago
payment.php
2 years ago
rate.php
2 years ago
reportsemp.php
5 months ago
reportsser.php
5 months ago
reservation.php
1 month ago
resoptassoc.php
2 years ago
restriction.php
2 years ago
review.php
3 years ago
serempassoc.php
1 year ago
seroptassoc.php
4 years ago
serrateassoc.php
4 years ago
serrestrassoc.php
4 years ago
service.php
2 years ago
state.php
2 years ago
statswidget.php
2 years ago
statuscode.php
2 years ago
subscription.php
1 month ago
subscrorder.php
1 month ago
tag.php
4 years ago
tax.php
2 years ago
taxrule.php
2 years ago
updateprogram.php
4 years ago
usernote.php
2 years ago
waitinglist.php
1 month ago
webhook.php
1 year ago
worktime.php
1 month ago
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 |