芝麻web文件管理V1.00

编辑当前文件:/home/pulsehostuk9/www/status.pulsehost.co.uk/app/models/MonitorsIncidents.php

<?php
/*
 * @copyright Copyright (c) 2024 AltumCode (https://altumcode.com/)
 *
 * This software is exclusively sold through https://altumcode.com/ by the AltumCode author.
 * Downloading this product from any other sources and running it without a proper license is illegal,
 *  except the official ones linked from https://altumcode.com/.
 */

namespace Altum\Models;

class MonitorsIncidents extends Model {

public function get_monitor_incidents_by_monitor_id_and_start_datetime_and_end_datetime($monitor_id, $start_datetime, $end_datetime) {

/* Get all available monitor logs */
        $monitor_incidents = [];

/* Try to check if the status_page posts exists via the cache */
        $cache_instance = cache()->getItem('s_monitor_incidents?monitor_id=' . $monitor_id . '&start_datetime=' . md5($start_datetime) . '&end_datetime=' . md5($end_datetime));

/* Set cache if not existing */
        if(is_null($cache_instance->get())) {

/* Get data from the database */
            $monitor_incidents_result = database()->query("SELECT * FROM `incidents` WHERE `monitor_id` = {$monitor_id} AND `start_datetime` >= '{$start_datetime}' AND (`end_datetime` <= '{$end_datetime}' OR `end_datetime` IS NULL) ORDER BY `incident_id` DESC");

while($row = $monitor_incidents_result->fetch_object()) $monitor_incidents[] = $row;

cache()->save(
                $cache_instance->set($monitor_incidents)->expiresAfter(CACHE_DEFAULT_SECONDS)->addTag('monitor_id=' . $monitor_id)
            );

} else {

/* Get cache */
            $monitor_incidents = $cache_instance->get();

}

return $monitor_incidents;

}

}