<?php 
include 'templates/header.php'; 
include 'templates/navbar.php'; 
require_once 'includes/db.php';

function safe_output($data) {
    return htmlspecialchars($data, ENT_QUOTES, 'UTF-8');
}

$msg = "";
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    if (!empty($_POST['type']) && !empty($_POST['size']) && isset($_POST['quantity'])) {
        $type = trim($_POST['type']);
        $size = trim($_POST['size']);
        $quantity = intval($_POST['quantity']);
        
        $stmt = $conn->prepare("INSERT INTO packaging_materials (type, size, quantity) VALUES (?, ?, ?)");
        $stmt->bind_param("ssi", $type, $size, $quantity);
        
        if ($stmt->execute()) {
            $msg = '<div class="alert alert-success">Packaging material added successfully!</div>';
        } else {
            $msg = '<div class="alert alert-danger">Error: ' . safe_output($conn->error) . '</div>';
        }
        $stmt->close();
    } else {
        $msg = '<div class="alert alert-warning">Please fill in all required fields.</div>';
    }
}
?>

<div class="container mt-4">
    <h2>Packaging Materials</h2>
    <?php echo $msg; ?>
    <!-- Form to Add Packaging Material -->
    <form method="POST" action="packaging.php">
        <div class="form-group">
            <label for="type">Packaging Type</label>
            <input type="text" class="form-control" id="type" name="type" placeholder="e.g., Plain Cover, Sack, Carton" required>
        </div>
        <div class="form-group">
            <label for="size">Size</label>
            <input type="text" class="form-control" id="size" name="size" placeholder="e.g., 200g, 500ml" required>
        </div>
        <div class="form-group">
            <label for="quantity">Quantity in Stock</label>
            <input type="number" class="form-control" id="quantity" name="quantity" required>
        </div>
        <button type="submit" class="btn btn-primary">Add Packaging Material</button>
    </form>

    <hr>
    <h3>Existing Packaging Materials</h3>
    <table class="table table-bordered">
        <thead class="thead-dark">
            <tr>
                <th>Packaging Type</th>
                <th>Size</th>
                <th>Quantity</th>
            </tr>
        </thead>
        <tbody>
            <?php 
            $result = $conn->query("SELECT * FROM packaging_materials ORDER BY id DESC");
            while ($row = $result->fetch_assoc()):
            ?>
            <tr>
                <td><?php echo safe_output($row['type']); ?></td>
                <td><?php echo safe_output($row['size']); ?></td>
                <td><?php echo safe_output($row['quantity']); ?></td>
            </tr>
            <?php endwhile; ?>
        </tbody>
    </table>
</div>

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