<?php 
ob_start();
include_once("include/head.php");

// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);

require_once "config.php";


if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $client_name = $_POST['client_name'];
    $phone = $_POST['phone'];
    $email = $_POST['email'];
    $company_name = $_POST['company_name'];
    $gst = $_POST['gst'];
    $address = $_POST['address'];
    
    $sub_total = 0;
    $discount = 0; 
    $total_tax = 0;
    $total_amount = 0;

    $stmt = $conn->prepare("INSERT INTO custom_orders (client_name, phone, email, company_name, gst, address, sub_total, discount, total_tax, total_amount) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
    $stmt->bind_param('ssssssdddd', $client_name, $phone, $email, $company_name, $gst, $address, $sub_total, $discount, $total_tax, $total_amount);
    $stmt->execute();
    
    $order_id = $stmt->insert_id; 
    $stmt->close();

    if (isset($_POST['product_name']) && isset($_POST['product_description']) && isset($_POST['price']) && isset($_POST['quantity']) && isset($_POST['amount']) && isset($_POST['gst'])) {
        $product_names = $_POST['product_name'];
        $product_descriptions = $_POST['product_description'];
        $prices = $_POST['price'];
        $quantities = $_POST['quantity'];
        $amounts = $_POST['amount'];
        $gsts = $_POST['gst'];

        $stmt = $conn->prepare("INSERT INTO custom_order_items (order_id, product_name, product_description, price, quantity, amount) VALUES (?, ?, ?, ?, ?, ?)");

        foreach ($product_names as $index => $product_name) {
            $product_description = $product_descriptions[$index];
            $price = $prices[$index];
            $quantity = $quantities[$index];
            $amount = $amounts[$index];

            $stmt->bind_param('issddd', $order_id, $product_name, $product_description, $price, $quantity, $amount);
            $stmt->execute();

            $sub_total += $amount;
            $total_tax += ($amount * $gsts[$index] / 100);
        }

        $stmt->close();

        $total_amount = $sub_total + $total_tax - $discount;

        $stmt = $conn->prepare("UPDATE custom_orders SET sub_total = ?, discount = ?, total_tax = ?, total_amount = ? WHERE id = ?");
        $stmt->bind_param('dddii', $sub_total, $discount, $total_tax, $total_amount, $order_id);
        $stmt->execute();
        $stmt->close();
    }

    $conn->close();

    echo "Order has been successfully placed.";
    exit;
}


ob_end_flush();
?>

<div class="main-panel">
    <div class="content-wrapper">
        <div class="card">
            <div class="card-body">
                <div class="row">
                    <div class="col-md-3">
                        <h4 class="card-title"> CUSTOM CONTAINER</h4>
                    </div>
                </div>
                
                <div class="row">
                    <div class="col-12">
                        <form class="cmxform" id="productForm" method="post" action="">
                            <fieldset>
                                <div class="p-3 card">
                                    <div class="row">
                                        <div class="form-group col-md-4">
                                            <label for="client_name">Client Name</label>
                                            <input class="form-control" type="text" name="client_name" id="client_name" placeholder="Client Name" required>
                                        </div>
                                        <div class="form-group col-md-4">
                                            <label for="phone">Phone</label>
                                            <input class="form-control" type="text" name="phone" id="phone" placeholder="Client phone" required>
                                        </div>
                                        <div class="form-group col-md-4">
                                            <label for="email">Email</label>
                                            <input class="form-control" type="email" name="email" id="email" placeholder="Client email" required>
                                        </div>
                                        <div class="form-group col-md-4">
                                            <label for="company_name">Company Name</label>
                                            <input class="form-control" type="text" name="company_name" id="company_name" placeholder="Company name" required>
                                        </div>
                                        <div class="form-group col-md-4">
                                            <label for="gst">GST</label>
                                            <input class="form-control" type="text" name="gst" id="gst" placeholder="Client GST No" required>
                                        </div>
                                        <div class="form-group col-md-12">
                                            <label for="address">Description</label>
                                            <textarea class="form-control" name="address" id="address" placeholder="Description" required></textarea>
                                        </div>
                                    </div>
                                </div>

                                <div class="row my-4 px-3">
                                    <div class="col-md-12">
                                        <h2 class="card-title">Select Equipments</h2>
                                        <div id="productSelection" class="row p-3">
                                            <?php
                                            $typesQuery = "SELECT id, name FROM office_equipments";
                                            $productResult = $conn->query($typesQuery);
                            
                                            if ($productResult && $productResult->num_rows > 0) {
                                                while ($row = $productResult->fetch_assoc()) {
                                                    $id = $row['id'];
                                                    $name = $row['name'];
                                                    ?>
                                                    <div class="form-group col-md-3 mb-0">
                                                        <input type="checkbox" id="product_<?php echo $id; ?>" name="product_ids[]" value="<?php echo $id; ?>">
                                                        <label for="product_<?php echo $id; ?>"> <?php echo $name; ?></label>
                                                    </div>
                                                    <?php
                                                }
                                            } else {
                                                echo '<p>No products found.</p>';
                                            }
                                            ?>
                                        </div>
                                    </div>
                                </div>

                                <div class="row my-4 px-3 justify-content-between">
                                    <div class="">
                                        <h2 class="card-title">Product Details</h2>
                                    </div>
                                </div>

                                <div class="p-3 card">
                                    <div class="row mt-3" id="productContainer" style="width: 100%; overflow-x: auto;">
                                    </div>
                                </div>

     

                                <div class="row mt-5">
                                    <div class="col-md-6 offset-md-6">
                                        <table class="table">
                                            <tr>
                                                <th>Sub Total</th>
                                                <td id="subTotal">Rs 0.00</td>
                                            </tr>
                                            <tr>
                                                <th>Discount</th>
                                                <td id="totalDiscount">Rs 0.00</td>
                                            </tr>
                                            <tr>
                                                <th>Tax</th>
                                                <td id="totalTax">Rs 0.00</td>
                                            </tr>
                                            <tr>
                                                <th>Total Amount</th>
                                                <td id="totalAmount">Rs 0.00</td>
                                            </tr>
                                        </table>
                                    </div>
                                </div>

                                <input class="btn btn-primary" type="submit" value="Submit">
                            </fieldset>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css">

<!-- jQuery and Bootstrap JS -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"></script>

<script>
function calculateTotals() {
    let subTotal = 0;
    let totalDiscount = 0;
    let totalTax = 0;
    let totalAmount = 0;

    $('.product-row').each(function() {
        let price = parseFloat($(this).find('[name="price[]"]').val()) || 0;
        let quantity = parseFloat($(this).find('[name="quantity[]"]').val()) || 0;
        let gstRate = parseFloat($(this).find('[name="gst[]"]').val()) || 0;

        let amount = price * quantity;
        $(this).find('[name="amount[]"]').val(amount.toFixed(2));
        subTotal += amount;

        let tax = (amount * gstRate / 100);
        totalTax += tax;
    });

    totalDiscount = 0;
    totalAmount = subTotal + totalTax - totalDiscount;

    $('#subTotal').text(`Rs ${subTotal.toFixed(2)}`);
    $('#totalDiscount').text(`Rs ${totalDiscount.toFixed(2)}`);
    $('#totalTax').text(`Rs ${totalTax.toFixed(2)}`);
    $('#totalAmount').text(`Rs ${totalAmount.toFixed(2)}`);
}

$(document).ready(function() {
    function fetchProductDetails(productIds) {
        $.ajax({
            url: 'fetch_office_equipment.php',
            type: 'POST',
            data: { ids: productIds },
            success: function(response) {
                $('#productContainer').html(response);
                calculateTotals();
            }
        });
    }

    $('#productSelection').on('change', 'input[name="product_ids[]"]', function() {
        let selectedProductIds = $('input[name="product_ids[]"]:checked').map(function() {
            return $(this).val();
        }).get();
        fetchProductDetails(selectedProductIds);
    });

    $('#productContainer').on('input', 'input[name="price[]"], input[name="quantity[]"], input[name="gst[]"]', calculateTotals);
});
</script>

<?php include_once("include/footer.php"); ?>
</body>
</html>
