$date_max = CValue::get("_date_max"); $page = (int) CValue::get("page", 0); $where = array(); if ($status) { $where["status"] = "= '{$status}'"; } if ($error) { $where["error"] = "LIKE '%{$error}%'"; } if ($cronjob_id) { $where["cronjob_id"] = "= '{$cronjob_id}'"; } if ($date_min) { $where["start_datetime"] = ">= '{$date_min}'"; } if ($date_max) { $where["start_datetime"] = $date_min ? $where["start_datetime"] . "AND start_datetime <= '{$date_max}'" : "<= '{$date_max}'"; } $log = new CCronJobLog(); /** @var CCronJobLog[] $logs */ $nb_log = $log->countList($where); $logs = $log->loadList($where, "start_datetime DESC", "{$page}, 30"); $cronjobs = CCronJobLog::massLoadFwdRef($logs, "cronjob_id"); foreach ($logs as $_log) { $_log->_ref_cronjob = CMbArray::get($cronjobs, $_log->cronjob_id); } $smarty = new CSmartyDP(); $smarty->assign("logs", $logs); $smarty->assign("page", $page); $smarty->assign("nb_log", $nb_log); $smarty->display("inc_cronjobs_logs.tpl");
$do_purge = CValue::get("do_purge"); $date_max = CValue::get("_date_max"); $months = CValue::get("months"); $max = CValue::get("max", 1); $delete = CValue::get("delete"); if ($months) { $date_max = CMbDT::date("- {$months} MONTHS"); } if (!$date_max) { CAppUI::stepAjax("Merci d'indiquer une date fin de recherche.", UI_MSG_ERROR); } $cronjob_log = new CCronJobLog(); $ds = $cronjob_log->_spec->ds; // comptage des echanges à supprimer $count_delete = 0; $date_max_delete = $delete ? CMbDT::date("-6 MONTHS", $date_max) : $date_max; $where = array(); $where["start_datetime"] = "< '{$date_max_delete}'"; $count_to_delete = $cronjob_log->countList($where); CAppUI::stepAjax("{$cronjob_log->_class}-msg-delete_count", UI_MSG_OK, $count_to_delete); if (!$do_purge) { return; } $query = "DELETE FROM `{$cronjob_log->_spec->table}`\r\n WHERE `start_datetime` < '{$date_max_delete}'\r\n LIMIT {$max}"; $ds->exec($query); $count_delete = $ds->affectedRows(); CAppUI::stepAjax("{$cronjob_log->_class}-msg-deleted_count", UI_MSG_OK, $count_delete); // on continue si on est en auto if ($count_to_delete + $count_delete) { echo "<script type='text/javascript'>CronJob.purge();</script>"; }