<?php include "../../root.class.php";
$html = new html();
$html->add_styles_page();
$db = new db_safeguard();
session_start();

$jobcard_no = $_POST['jobcard_no'];

$payment_history_res = $db->query(
    "jobcard_payments",
    "SELECT * FROM jobcard_payments WHERE jobcard_id = '{$jobcard_no}' ORDER BY record_id DESC"
);

$total_amount = 0;
?>

<table style="width:100%; border-collapse:collapse; background:white;">
    <tr>
        <!-- <th>USER</th> -->
        <th>METHOD</th>
        <th>FILE</th>
        <th>DATE TIME</th>
        <th>AMOUNT</th>
    </tr>

    <?php if ($payment_history_res->num_rows > 0): ?>
        <?php while ($p = $payment_history_res->fetch_assoc()): ?>
            <?php
            $total_amount += (float) $p['amount'];

            $user_res = $db->query(
                "users",
                "SELECT username FROM users WHERE record_id = '{$p['user_id']}'"
            );
            $user = $user_res->fetch_assoc();
            ?>
            <tr>
                <!-- <td><= $user['username']; ?></td> -->
                <td><?= $p['payment_method']; ?></td>
                <td>
                    <?php if ($p['file'] != ""): ?>
                        <a href="../jobcards/slips/<?= $p['file']; ?>" target="_blank" style="text-decoration:none;color:black; font-weight:bold;">VIEW</a>
                    <?php else: ?>
                        N/A
                    <?php endif; ?>
                </td>
                <td><?= $p['date_time']; ?></td>
                <td>
                    R <?= number_format($p['amount'], 2); ?>
                </td>
            </tr>
        <?php endwhile; ?>

        <!-- TOTAL ROW -->
        <tr style="font-weight:bold; background:#f2f2f2;">
            <td colspan="3" style="text-align:right;">TOTAL</td>
            <td>R <?= number_format($total_amount, 2); ?></td>

        </tr>

    <?php else: ?>
        <tr>
            <td colspan="5" style="text-align:center;">No payment found.</td>
        </tr>
    <?php endif; ?>
</table>