Tul xxx Tul

Viewing: CashPendingMovement.php

<?php

class CashPendingMovement
{
    public static function forBatch(int $batchId): array
    {
        $pdo = (new Database())->getConnection();
        $stmt = $pdo->prepare('SELECT m.*, u.username AS user_name
                               FROM cash_pending_movements m
                               LEFT JOIN users u ON u.id = m.created_by_user_id
                               WHERE m.batch_id = :id
                               ORDER BY m.created_at ASC, m.id ASC');
        $stmt->execute([':id' => $batchId]);
        return $stmt->fetchAll(PDO::FETCH_ASSOC) ?: [];
    }

    public static function create(array $data, ?PDO $pdo = null): int
    {
        $pdo = $pdo ?: (new Database())->getConnection();
        $stmt = $pdo->prepare("INSERT INTO cash_pending_movements
            (batch_id, movement_type, reference, description, amount, document_path, created_by_user_id, created_at)
            VALUES (:batch_id, :type, :reference, :description, :amount, :document_path, :user_id, :created_at)");
        $stmt->execute([
            ':batch_id' => (int)$data['batch_id'],
            ':type' => $data['movement_type'],
            ':reference' => $data['reference'] ?? null,
            ':description' => $data['description'] ?? null,
            ':amount' => (float)$data['amount'],
            ':document_path' => $data['document_path'] ?? null,
            ':user_id' => $data['created_by_user_id'] ?? null,
            ':created_at' => $data['created_at'] ?? date('Y-m-d H:i:s'),
        ]);
        return (int)$pdo->lastInsertId();
    }
}

User / IP	: 216.73.216.183
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