<?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'];
    $client_name = $_POST['client_name'];
    $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`, 
        `client_name`, `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', 
        '$client_name', '$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;
    }
}



if (isset($_POST['update_invoice'])) {
    $invoice_id = $_POST['invoice_id']; // Get Invoice ID
    $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'];
    $client_name = $_POST['client_name'];
    $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 JSON format
    $product_names = json_encode($_POST['product_name']);
    $quantities = json_encode($_POST['quantity']);
    $prices = json_encode($_POST['price']);
    $descriptions = json_encode($_POST['description']);

    // Update the invoice record
    $query = "UPDATE `invoices` SET 
        `invoice_number` = '$invoice_number',
        `invoice_date` = '$invoice_date',
        `due_date` = '$due_date',
        `own_company` = '$own_company',
        `own_phone` = '$own_phone',
        `own_email` = '$own_email',
        `own_gst` = '$own_gst',
        `client_name` = '$client_name',
        `cli_company` = '$cli_company',
        `cli_phone` = '$cli_phone',
        `cli_email` = '$cli_email',
        `cli_gst` = '$cli_gst',
        `product_names` = '$product_names',
        `quantities` = '$quantities',
        `prices` = '$prices',
        `descriptions` = '$descriptions',
        `status` = '$status'
        WHERE `id` = '$invoice_id'";

    if (mysqli_query($conn, $query)) {
        $_SESSION['status'] = "Invoice Updated Successfully";
        header('Location: view-invoice.php');
        exit;
    } else {
        $_SESSION['status'] = "Error Updating Invoice!";
        header('Location: edit-invoice.php?id=' . $invoice_id);
        exit;
    }
}

// Fetch existing invoice details for the edit form
if (isset($_GET['id'])) {
    $invoice_id = $_GET['id'];
    $query = "SELECT * FROM invoices WHERE id = '$invoice_id'";
    $result = mysqli_query($conn, $query);
    $invoice_data = mysqli_fetch_assoc($result);
}


if (isset($_POST['delete_invoice'])) {

    $id = $_POST['delete_id'];
    
    $query = "DELETE FROM `invoices` WHERE id = '$id'";
    $query_run = mysqli_query($conn, $query);

    if ($query_run) {
        $_SESSION['status'] = "Deleted Successfully";
        header('Location: view-invoice.php');
    } else {
        $_SESSION['status'] = "Not Deleted Successfully";
        header('Location: view-invoic.php');
    }
}
?>