<?php
include 'db.php';

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $invoice_no = $_POST['invoice_no'];
    $vendor_id = $_POST['vendor_id'];
    $bill_date = $_POST['bill_date'];

    // Insert into `purchases` table
    $stmt = $con->prepare("INSERT INTO purchases (invoice_no, vendor_id, bill_date) VALUES (?, ?, ?)");
    if (!$stmt) {
        die("Prepare failed for purchases: (" . $con->errno . ") " . $con->error);
    }

    $stmt->bind_param("sis", $invoice_no, $vendor_id, $bill_date);
    if (!$stmt->execute()) {
        die("Execute failed for purchases: (" . $stmt->errno . ") " . $stmt->error);
    }

    $purchase_id = $stmt->insert_id;
    $stmt->close();

    // Insert items into `purchase_items`
    foreach ($_POST['kt_docs_repeater_basic'] as $item) {
        $product_id = $item['pid'];
        $qty_type = ($item['qtytype'] == "0") ? 0 : 1; // Store as 0 for NOS, 1 for KG
        $quantity = $item['quantity'];
        $price = $item['price'];
        $total = $item['total'];

        $stmt = $con->prepare("INSERT INTO purchase_items (purchase_id, product_id, qty_type, quantity, price, total) VALUES (?, ?, ?, ?, ?, ?)");
        if (!$stmt) {
            die("Prepare failed for purchase_items: (" . $con->errno . ") " . $con->error);
        }

        $stmt->bind_param("iiisii", $purchase_id, $product_id, $qty_type, $quantity, $price, $total);
        if (!$stmt->execute()) {
            die("Execute failed for purchase_items: (" . $stmt->errno . ") " . $stmt->error);
        }

        $stmt->close();
    }

    echo "<script>
        alert('Purchase saved successfully!');
        window.location.href = 'add_purchaseEntry.php';
    </script>";
}
?>