<?php 
ob_start();
session_start();
include_once("include/head.php");

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);


if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $client_name = $conn->real_escape_string($_POST['client_name']);
    $client_name = $conn->real_escape_string($_POST['client_name']);
    $address = $conn->real_escape_string($_POST['address']);
    $status = 'interested';
    $product_name = isset($_POST['product_name']) ? implode(',', $_POST['product_name']) : '';
    $quantity = isset($_POST['quantity']) ? implode(',', $_POST['quantity']) : '';
    $price = isset($_POST['price']) ? implode(',', $_POST['price']) : '';
    // $remarks = $conn->real_escape_string($_POST['remarks']);
    $phone = $conn->real_escape_string($_POST['phone']);
    $email = $conn->real_escape_string($_POST['email']);
    $company_name = $conn->real_escape_string($_POST['company_name']);
    $gst = $conn->real_escape_string($_POST['gst']);

    $sql = "INSERT INTO proposals (client_name, email, phone, company_name, gst, address, status, interested_in, quantity, price, remarks, created_by, updated_by, created_at, updated_at) 
            VALUES ('$client_name','$email', '$phone', '$company_name','$gst', '$address', '$status', '$product_name', '$quantity', '$price', '', 1, 1, NOW(), NOW())"; 

    if ($conn->query($sql) === TRUE) {
          $_SESSION['success_message'] = "New proposal created successfully!";
           header("location: proposal.php");
            exit;
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }

    $conn->close();
    // die;

}
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">CREATE PROPOSAL</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="col-md-12">-->
                                        <!--    <h2 class="card-title">Client Details</h2>-->
                                        <!--</div>-->
                                        <!-- <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">-->
                                        <!--    <span id="error_client_name" class="text-danger error"></span>-->
                                        <!--</div>-->
                                        <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">
                                            <span id="error_client_name" class="text-danger error"></span>
                                        </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">
                                            <span id="error_client_phone" class="text-danger error"></span>
                                        </div>
                                        <div class="form-group col-md-4">
                                            <label for="email">Email</label>
                                            <input class="form-control" type="text" name="email" id="email" placeholder="Client email">
                                            <span id="error_client_email" class="text-danger error"></span>
                                        </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">
                                            <span id="error_company_name" class="text-danger error"></span>
                                        </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 ">
                                            <span id="error_client_gst" class="text-danger error"></span>
                                        </div>
        
                                        <div class="form-group col-md-12">
                                            <label for="address">Address</label>
                                            <textarea class="form-control" name="address" id="address" placeholder="Company address"></textarea>
                                            <span id="error_company_address" class="text-danger error"></span>
                                        </div>
                                    </div>
                                 </div>

                                <div class="row my-4 px-3 justify-content-between ">
                                    <div class="">
                                        <h2 class="card-title">Product Details</h2>
                                    </div>
                                    <div class="text-end">
                                        <button type="button" class="btn-sm btn-primary text-white" id="addProduct">Add Product</button>
                                    </div>
                                </div>

                                 <div class=" p-3 card">
                                    <div class="row mt-3" id="productContainer" style="width: 100%; overflow-x: auto;">
                                        <div class="product-row form-row m-2">
                                            <div class="form-group col-md-2">
                                                <label for="product_type[]">Product Type</label>
                                                <select name="product_type[]" class="form-control product_type">
                                                    <option value="">Choose Type</option>
                                                    <?php
                                                        $typequery = "SELECT type_id, type_name FROM product_type";
                                                        $typeresult = $conn->query($typequery);
                                                    
                                                        while ($typeRow = $typeresult->fetch_assoc()) {
                                                            $productTypes = $typeRow;
                                                        
                                                    ?>
                                                        <option value="<?php echo $productTypes['type_id'] ?>"><?php echo $productTypes['type_name'] ?></option>
                                                    <?php
                                                        }
                                                    ?>

                                                </select>
                                                <span class="text-danger error"></span>
                                            </div>
                                            <div class="form-group col-md-3">
                                                <label for="product_name[]">Product Name</label>
                                                <select name="product_name[]" class="form-control product_name">
                                                    <option value="">Select Product</option>
                                                </select>
                                                <span class="text-danger error"></span>
                                            </div>
                                            <div class="form-group col-md-1">
                                                <label for="quantity[]">Quantity</label>
                                                <input type="text" name="quantity[]" class="form-control quantity" placeholder="">
                                                <span class="text-danger error"></span>
                                            </div>
                                            <div class="form-group col-md-2">
                                                <label for="price[]">Price</label>
                                                <input type="text" name="price[]" class="form-control price" placeholder="">
                                                <span class="text-danger error"></span>
                                            </div>
                                            <div class="form-group col-md-1">
                                                <label for="discount[]">Discount</label>
                                                <input type="text" name="discount[]" class="form-control discount" placeholder="">
                                                <span class="text-danger error"></span>
                                            </div>
                                            <div class="form-group col-md-1">
                                                <label for="tax[]">Tax</label>
                                                <input type="text" name="tax[]" class="form-control tax" placeholder="">
                                                <span class="text-danger error"></span>
                                            </div>
                                            <!--<div class="form-group col-md-2">-->
                                            <!--    <label for="amount[]">Amount</label>-->
                                            <!--    <input type="text" name="amount[]" class="form-control amount" placeholder="">-->
                                            <!--    <span class="text-danger error"></span>-->
                                            <!--</div>-->
                                            <div class="form-group col-md-1 align-self-end">
                                                <button type="button" class="btn btn-danger removeProduct">Delete</button>
                                            </div>
                                        </div>
                                    </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.2.1.slim.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.11.0/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"></script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

<script>
$(document).ready(function() {
        // Function to add a new product row
        function addProductRow() {
            let newRow = `
                <div class="product-row form-row m-2">
                    <div class="form-group col-md-2">
                        <label for="product_type[]">Product Type</label>
                        <select name="product_type[]" class="form-control product_type">
                            <option value="">Choose Type</option>
                            <?php
                                $typequery = "SELECT type_id, type_name FROM product_type";
                                $typeresult = $conn->query($typequery);
                            
                                while ($typeRow = $typeresult->fetch_assoc()) {
                                    echo "<option value=\"{$typeRow['type_id']}\">{$typeRow['type_name']}</option>";
                                }
                            ?>
                        </select>
                        <span class="text-danger error"></span>
                    </div>
                    <div class="form-group col-md-3">
                        <label for="product_name[]">Product Name</label>
                        <select name="product_name[]" class="form-control product_name">
                            <option value="">Select Product</option>
                        </select>
                        <span class="text-danger error"></span>
                    </div>
                    <div class="form-group col-md-1">
                        <label for="quantity[]">Quantity</label>
                        <input type="text" name="quantity[]" class="form-control quantity" placeholder="">
                        <span class="text-danger error"></span>
                    </div>
                    <div class="form-group col-md-2">
                        <label for="price[]">Price</label>
                        <input type="text" name="price[]" class="form-control price" placeholder="">
                        <span class="text-danger error"></span>
                    </div>
                    <div class="form-group col-md-1">
                        <label for="discount[]">Discount</label>
                        <input type="text" name="discount[]" class="form-control discount" placeholder="">
                        <span class="text-danger error"></span>
                    </div>
                    <div class="form-group col-md-1">
                        <label for="tax[]">Tax</label>
                        <input type="text" name="tax[]" class="form-control tax" placeholder="">
                        <span class="text-danger error"></span>
                    </div>
                    <div class="form-group col-md-1 align-self-end">
                        <button type="button" class="btn btn-danger removeProduct">Delete</button>
                    </div>
                </div>`;
            $("#productContainer").append(newRow);
        }

        // Fetch product names based on the selected product type
        function fetchProducts(type, selectElement) {
            $.ajax({
                url: 'fetch_products_name.php',
                type: 'GET',
                data: { type: type },
                success: function(response) {
                    const products = JSON.parse(response);
                    let options = '<option value="">Select Product</option>';
                    products.forEach(function(product) {
                        options += `<option value="${product.id}">${product.name} (SKU: ${product.sku})</option>`;
                    });
                    selectElement.html(options);
                }
            });
        }

        // Event handlers
        $(document).on('change', '.product_type', function() {
            const selectedType = $(this).val();
            const productNameSelect = $(this).closest('.product-row').find('.product_name');
            if (selectedType) {
                fetchProducts(selectedType, productNameSelect);
            } else {
                productNameSelect.html('<option value="">Select Product</option>');
            }
        });

        $("#addProduct").click(function() {
            addProductRow();
        });

        $(document).on('click', '.removeProduct', function() {
            if ($('.product-row').length > 1) {
                $(this).closest('.product-row').remove();
                calculateTotals();
            } else {
                alert("At least one product should be present.");
            }
        });

        $(document).on('input', '.price, .quantity, .discount, .tax', function() {
            calculateTotals();
        });

        // Calculate totals
        function calculateTotals() {
            let subTotal = 0;
            let totalDiscount = 0;
            let totalTax = 0;

            $('.product-row').each(function() {
                const price = parseFloat($(this).find('.price').val()) || 0;
                const quantity = parseFloat($(this).find('.quantity').val()) || 0;
                const discount = parseFloat($(this).find('.discount').val()) || 0;
                const tax = parseFloat($(this).find('.tax').val()) || 0;

                const amount = (price * quantity);
                subTotal += amount;
                totalDiscount += (amount * (discount / 100));
                totalTax += (amount * (tax / 100));
            });

            const totalAmount = subTotal - totalDiscount + totalTax;

            $('#subTotal').text(`Rs ${subTotal.toFixed(2)}`);
            $('#totalDiscount').text(`Rs ${totalDiscount.toFixed(2)}`);
            $('#totalTax').text(`Rs ${totalTax.toFixed(2)}`);
            $('#totalAmount').text(`Rs ${totalAmount.toFixed(2)}`);
        }

        // Form validation
        $("#productForm").on('submit', function(event) {
            let isValid = true;
            $(".error").text(""); 

            if ($("#client_name").val().trim() === "") {
                $("#error_client_name").text("Client Name is required.");
                isValid = false;
            }

            if ($("#address").val().trim() === "") {
                $("#error_company_address").text("Address is required.");
                isValid = false;
            }

            if (!isValid) {
                event.preventDefault();
            }
        });
    });

</script>


<?php include_once("include/footer.php"); ?>
</body>
</html>
