芝麻web文件管理V1.00

编辑当前文件:/home/pulsehostuk9/www/status.pulsehost.co.uk/app/models/HeartbeatsIncidents.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 HeartbeatsIncidents extends Model {

public function get_heartbeat_incidents_by_heartbeat_id_and_start_datetime_and_end_datetime($heartbeat_id, $start_datetime, $end_datetime) {

/* Get all available heartbeat logs */
        $heartbeat_incidents = [];

/* Try to check if the status_page posts exists via the cache */
        $cache_instance = cache()->getItem('s_heartbeat_incidents?heartbeat_id=' . $heartbeat_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 */
            $heartbeat_incidents_result = database()->query("SELECT * FROM `incidents` WHERE `heartbeat_id` = {$heartbeat_id} AND `start_datetime` >= '{$start_datetime}' AND (`end_datetime` <= '{$end_datetime}' OR `end_datetime` IS NULL) ORDER BY `incident_id` DESC");

while($row = $heartbeat_incidents_result->fetch_object()) $heartbeat_incidents[] = $row;

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

} else {

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

}

return $heartbeat_incidents;

}

}