Tul xxx Tul

Viewing: PaidProject.php

<?php

class PaidProject {
    private $db;

    public function __construct() {
        require_once __DIR__ . '/../core/Database.php';
        $this->db = (new Database())->connect();
    }

    public function getByProjectId($projectId) {
        return $this->getLatestByProjectId($projectId);
    }

    public function getLatestByProjectId($projectId) {
        $stmt = $this->db->prepare('SELECT * FROM paid_projects WHERE project_id = ? ORDER BY updated_at DESC, id DESC LIMIT 1');
        $stmt->execute([$projectId]);
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        return $row ?: null;
    }

    public function getAllByProjectId($projectId) {
        $stmt = $this->db->prepare('SELECT * FROM paid_projects WHERE project_id = ? ORDER BY updated_at DESC, id DESC');
        $stmt->execute([$projectId]);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }

    public function getById($id) {
        $stmt = $this->db->prepare('SELECT * FROM paid_projects WHERE id = ? LIMIT 1');
        $stmt->execute([$id]);
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        return $row ?: null;
    }

    public function create($projectId, $amount, $observations) {
        $amount = (int)max(0, $amount);
        $stmt = $this->db->prepare('INSERT INTO paid_projects (project_id, amount, observations) VALUES (?, ?, ?)');
        return $stmt->execute([$projectId, $amount, $observations]);
    }

    public function updateFields($paymentId, $amount = null, $observations = null) {
        $fields = [];
        $params = [];

        if ($amount !== null) {
            $fields[] = 'amount = ?';
            $params[] = (int)max(0, $amount);
        }

        if ($observations !== null) {
            $fields[] = 'observations = ?';
            $params[] = ($observations === '') ? null : $observations;
        }

        if (empty($fields)) {
            return false;
        }

        $fields[] = 'updated_at = NOW()';
        $sql = 'UPDATE paid_projects SET ' . implode(', ', $fields) . ' WHERE id = ?';
        $params[] = $paymentId;

        $stmt = $this->db->prepare($sql);
        return $stmt->execute($params);
    }

    public function deleteById($paymentId) {
        $stmt = $this->db->prepare('DELETE FROM paid_projects WHERE id = ?');
        return $stmt->execute([$paymentId]);
    }

    public function getSummaryByProjectId($projectId) {
        $stmt = $this->db->prepare('SELECT COALESCE(SUM(amount), 0) AS total_amount, COUNT(*) AS entries_count FROM paid_projects WHERE project_id = ?');
        $stmt->execute([$projectId]);
        $summary = $stmt->fetch(PDO::FETCH_ASSOC) ?: ['total_amount' => 0, 'entries_count' => 0];
        $summary['total_amount'] = (int)($summary['total_amount'] ?? 0);
        $summary['entries_count'] = (int)($summary['entries_count'] ?? 0);
        $summary['latest'] = $this->getLatestByProjectId($projectId);
        return $summary;
    }

    public function upsert($projectId, $amount, $observations) {
        // Mantener compatibilidad con llamadas existentes: insertar nuevo registro
        return $this->create($projectId, $amount, $observations);
    }
}
User / IP	: 216.73.216.159
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