Tul xxx Tul

Viewing: FixedAsset.php

<?php
class FixedAsset
{
    public static function getAll(int $page = 1, int $perPage = 15): array
    {
        $pdo = (new Database())->getConnection();
        $offset = ($page - 1) * $perPage;

        $count = (int)$pdo->query("SELECT COUNT(*) FROM fixed_assets")->fetchColumn();

        $stmt = $pdo->prepare("SELECT * FROM fixed_assets ORDER BY id DESC LIMIT :limit OFFSET :offset");
        $stmt->bindValue(':limit', $perPage, PDO::PARAM_INT);
        $stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
        $stmt->execute();
        $items = $stmt->fetchAll(PDO::FETCH_ASSOC) ?: [];

        return [ 'items' => $items, 'total' => $count, 'page' => $page, 'perPage' => $perPage ];
    }

    public static function create(array $data): int
    {
        $pdo = (new Database())->getConnection();
        $sql = "INSERT INTO fixed_assets (name, description, acquisition_value, useful_life_years, acquisition_date, annual_depreciation) VALUES (:name, :description, :acquisition_value, :useful_life_years, :acquisition_date, :annual_depreciation)";
        $stmt = $pdo->prepare($sql);
        $stmt->execute([
            ':name' => (string)($data['name'] ?? ''),
            ':description' => ($data['description'] ?? null),
            ':acquisition_value' => (float)($data['acquisition_value'] ?? 0),
            ':useful_life_years' => (int)($data['useful_life_years'] ?? 0),
            ':acquisition_date' => (string)($data['acquisition_date'] ?? ''),
            ':annual_depreciation' => (float)($data['annual_depreciation'] ?? 0),
        ]);
        return (int)$pdo->lastInsertId();
    }

    public static function findById(int $id): ?array
    {
        $pdo = (new Database())->getConnection();
        $stmt = $pdo->prepare("SELECT * FROM fixed_assets WHERE id = :id LIMIT 1");
        $stmt->execute([':id' => $id]);
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        return $row ?: null;
    }

    public static function update(int $id, array $data): bool
    {
        $pdo = (new Database())->getConnection();
        $sql = "UPDATE fixed_assets SET name=:name, description=:description, acquisition_value=:acquisition_value, useful_life_years=:useful_life_years, acquisition_date=:acquisition_date, annual_depreciation=:annual_depreciation, updated_at = CURRENT_TIMESTAMP WHERE id=:id";
        $stmt = $pdo->prepare($sql);
        return $stmt->execute([
            ':id' => $id,
            ':name' => (string)($data['name'] ?? ''),
            ':description' => ($data['description'] ?? null),
            ':acquisition_value' => (float)($data['acquisition_value'] ?? 0),
            ':useful_life_years' => (int)($data['useful_life_years'] ?? 0),
            ':acquisition_date' => (string)($data['acquisition_date'] ?? ''),
            ':annual_depreciation' => (float)($data['annual_depreciation'] ?? 0),
        ]);
    }

    public static function delete(int $id): void
    {
        $pdo = (new Database())->getConnection();
        $stmt = $pdo->prepare("DELETE FROM fixed_assets WHERE id = :id");
        $stmt->execute([':id' => $id]);
    }

    public static function listAll(): array
    {
        $pdo = (new Database())->getConnection();
        return $pdo->query("SELECT * FROM fixed_assets ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC) ?: [];
    }
}
User / IP	: 216.73.217.33
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64