<?php include 'templates/header.php'; ?>
<?php include 'templates/navbar.php'; ?>

<div class="container mt-4">
    <h2>Invoice Management</h2>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Order ID</th>
                <th>Order Date</th>
                <th>Order Type</th>
                <th>Invoice Number</th>
                <th>Status</th>
                <th>Update Invoice</th>
            </tr>
        </thead>
        <tbody>
            <?php
            require_once 'includes/db.php';
            $result = $conn->query("SELECT * FROM orders WHERE order_type='Invoice'");
            while ($row = $result->fetch_assoc()):
            ?>
            <tr>
                <td><?php echo $row['id']; ?></td>
                <td><?php echo $row['order_date']; ?></td>
                <td><?php echo $row['order_type']; ?></td>
                <td>
                    <?php echo $row['invoice_number'] ? $row['invoice_number'] : 'N/A'; ?>
                </td>
                <td><?php echo $row['status']; ?></td>
                <td>
                    <?php if ($row['status'] == 'Unaccounted'): ?>
                        <form action="process_invoice_update.php" method="POST" class="form-inline">
                            <input type="hidden" name="order_id" value="<?php echo $row['id']; ?>">
                            <input type="text" name="new_invoice_number" placeholder="New Invoice #" class="form-control form-control-sm mr-2" required>
                            <button type="submit" class="btn btn-sm btn-primary">Update</button>
                        </form>
                    <?php else: ?>
                        <span class="text-success">Accounted</span>
                    <?php endif; ?>
                </td>
            </tr>
            <?php endwhile; ?>
        </tbody>
    </table>
</div>

<?php include 'templates/footer.php'; ?>