<?php
include("inc/config.php");

if (isset($_POST['add_invoice'])) {
    $invoice_number = $_POST['invoice_number'];
    $invoice_date = $_POST['invoice_date'];
    $due_date = $_POST['due_date'];
    $own_company = $_POST['own_company'];
    $own_phone = $_POST['own_phone'];
    $own_email = $_POST['own_email'];
    $own_gst = $_POST['own_gst'];
    $cli_company = $_POST['cli_company'];
    $cli_phone = $_POST['cli_phone'];
    $cli_email = $_POST['cli_email'];
    $cli_gst = $_POST['cli_gst'];
    $status = $_POST['status'];

    // Convert product details into separate JSON arrays
    $product_names = json_encode($_POST['product_name']);  // Store product names as JSON array
    $quantities = json_encode($_POST['quantity']);         // Store quantities as JSON array
    $prices = json_encode($_POST['price']);               // Store prices as JSON array
    $descriptions = json_encode($_POST['description']);   // Store descriptions as JSON array

    // Insert invoice with JSON-encoded product details
    $query = "INSERT INTO `invoices` (
        `invoice_number`, `invoice_date`, `due_date`, 
        `own_company`, `own_phone`, `own_email`, `own_gst`, 
        `cli_company`, `cli_phone`, `cli_email`, `cli_gst`, 
        `product_names`, `quantities`, `prices`, `descriptions`, `status`
    ) VALUES (
        '$invoice_number', '$invoice_date', '$due_date', 
        '$own_company', '$own_phone', '$own_email', '$own_gst', 
        '$cli_company', '$cli_phone', '$cli_email', '$cli_gst', 
        '$product_names', '$quantities', '$prices', '$descriptions', '$status'
    )";

    if (mysqli_query($conn, $query)) {
        $_SESSION['status'] = "Invoice Added Successfully";
        header('Location: view-invoice.php');
        exit;
    } else {
        $_SESSION['status'] = "Error Adding Invoice!";
        header('Location: add-invoice.php');
        exit;
    }
}
?>