<?php

class AssetManagementReservationModel extends TTCrudBaseModel {
    public int $id;
    public int $assetId;
    public int $userId;
    public int $startDate;
    public ?int $endDate;
    public ?string $notes;
    public int $createBy;
    public int $create;

    public static function getConflictingReservations($assetId): array
    {
        $db = self::getDB();
        $table = self::getFullyQualifiedTable();
        $now = time();

        $sql = "SELECT * FROM $table 
                WHERE assetId = $assetId AND startDate <= $now AND (endDate IS NULL OR endDate >= $now)
            ";

        $result = $db->query($sql);
        $reservations = [];
        while ($row = $result->fetch_assoc()) {
            $reservations[] = new self($row);
        }
        return $reservations;
    }
}