<?php
include 'db.php';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $customer_id = $_POST['customer_id'];
    $quantities = $_POST['quantity'];
    $items = $_POST['item_name'];
    $prices = $_POST['price'];
    $taxables = $_POST['taxable'] ?? [];
    $notes = $_POST['notes'] ?? [];

    $stmt = $conn->prepare("INSERT INTO transactions (customer_id, quantity, item_name, price, taxable, notes, date)
                            VALUES (?, ?, ?, ?, ?, ?, CURRENT_DATE)");

    for ($i = 0; $i < count($items); $i++) {
        $item = trim($items[$i]);
        $qty = intval($quantities[$i]);
        $price = floatval($prices[$i]);
        $note = trim($notes[$i] ?? '');
        $taxable = isset($taxables[$i]) ? 1 : 0;

        if ($item !== '' && $qty > 0 && $price >= 0) {
            $stmt->bind_param("iisdds", $customer_id, $qty, $item, $price, $taxable, $note);
            $stmt->execute();
        }
    }

    header("Location: view_account.php?customer_id=" . $customer_id);
    exit;
}
?>