芝麻web文件管理V1.00

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

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

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

/* Try to check if the status_page posts exists via the cache */
        $cache_instance = cache()->getItem('s_heartbeat_logs?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_logs_result = database()->query("SELECT * FROM `heartbeats_logs` WHERE `heartbeat_id` = {$heartbeat_id} AND (`datetime` BETWEEN '{$start_datetime}' AND '{$end_datetime}')");

while($row = $heartbeat_logs_result->fetch_object()) $heartbeat_logs[] = $row;

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

} else {

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

}

return $heartbeat_logs;

}

}