<?php
require_once 'includes/db.php';

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // Retrieve form values
    $order_date = $_POST['order_date'];
    $order_type = $_POST['order_type']; // 'Invoice' or 'SlipOnly'
    $is_accounted = isset($_POST['is_accounted']) ? 1 : 0;
    $product_id = $_POST['product_id'];
    $quantity = $_POST['quantity'];
    $packaging_type = $_POST['packaging_type'];

    // Insert into orders table
    $invoice_number = null;
    $status = 'Pending';
    if ($order_type == 'Invoice' && $is_accounted) {
        // Generate a unique invoice number (here, using a simple timestamp-based method)
        $invoice_number = "INV" . time();
        $status = 'Accounted';
    } elseif ($order_type == 'Invoice' && !$is_accounted) {
        $status = 'Unaccounted';
    }
    $stmt = $conn->prepare("INSERT INTO orders (order_date, order_type, invoice_number, is_accounted, status) VALUES (?, ?, ?, ?, ?)");
    $stmt->bind_param("sssis", $order_date, $order_type, $invoice_number, $is_accounted, $status);
    $stmt->execute();
    $order_id = $stmt->insert_id;
    $stmt->close();

    // Insert order item (for simplicity, one item per order)
    $stmt = $conn->prepare("INSERT INTO order_items (order_id, product_id, quantity, packaging_type) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("iiis", $order_id, $product_id, $quantity, $packaging_type);
    $stmt->execute();
    $stmt->close();

    // Optionally: Deduct finished goods and packaging materials here

    // Generate a slip (for demo purposes, simply output order details)
    echo "<h3>Order Processed Successfully!</h3>";
    echo "<p>Order Date: " . $order_date . "</p>";
    echo "<p>Order Type: " . $order_type . "</p>";
    if ($order_type == 'Invoice') {
        echo "<p>Invoice Number: " . ($invoice_number ? $invoice_number : "Not Accounted") . "</p>";
    }
    echo "<p>Product ID: " . $product_id . "</p>";
    echo "<p>Quantity: " . $quantity . "</p>";
    echo "<p>Packaging: " . $packaging_type . "</p>";
    echo "<p><a href='pages/orders.php'>Back to Orders</a></p>";
}
?>