{% load static %}
{% include 'includes/header.html' %}
{% include 'includes/wholesale_sidebar.html' %}
{% include 'includes/navbar.html' %}
<style>
    #datatable {
        border-collapse: collapse;
        width: 100%;
    }

    #datatable th,
    #datatable td {
        border: 1px solid #ccc;
        padding: 8px;
        text-align: center;
        vertical-align: middle;
    }

    #datatable thead th {
        background-color: #f9faf8;
        font-weight: bold;
    }

    .bg-credit {
        background-color: #d1f7d6 !important;
        /* Light green */
    }

    .bg-debit {
        background-color: #fce4e4 !important;
        /* Light red */
    }

    .bg-balance {
        background-color: #f0f8ff !important;
        /* Light blue */
    }

    #datatable tfoot {
        background-color: #f3f4f6 !important;
        font-weight: 600;
        border-top: 2px solid #d1d5db;
    }

    #datatable tfoot th {
        padding: 8px 10px;
    }
</style>


<div class="container-xxl flex-grow-1 container-p-y">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div class="d-flex align-items-center">
            <h4 class="mb-0 me-3">Stock Summary</h4>
            <button class="btn btn-success" onclick="downloadSampleFile()">
                <i class="fas fa-download"></i> &nbsp; Sample
            </button>&nbsp;

            <button class="btn btn-primary" id="btn-import" data-bs-toggle="modal" data-bs-target="#import_modal">
                <i class="fas fa-file-import"></i> &nbsp; Import
            </button>
        </div>


        <nav aria-label="breadcrumb">
            <ol class="breadcrumb mb-0">
                <li class="breadcrumb-item">
                    <a href="/store/dashboard" class="d-flex align-items-center text-decoration-none">
                        <i class="ti tabler-home me-1"></i>
                    </a>
                </li>
                <li class="breadcrumb-item active" aria-current="page">Stock Summary</li>
            </ol>
        </nav>
    </div>

    <div class="card mt-3">
        <div class="card-header border-bottom">
            <div class="row mt-2">

                <div class="col-2">
                    <label for="filter_category_id" class="form-label">Category</label>
                    <select class="select2 form-control" id="filter_category_id" name="category_id">
                        <option value="">Select</option>
                        {% for k in category %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="col-2">
                    <label for="filter_subcategory_id" class="form-label">Sub Category</label>
                    <select class="select2 form-control" id="filter_subcategory_id" name="subcategory_id">
                        <option value="">Select</option>
                        {% for k in sub_category %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="col-2">
                    <label for="brand_id" class="form-label">Brand</label>
                    <select class="select2 form-control" id="brand_id" name="brand_id">
                        <option value="">Select</option>
                        {% for k in brand %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="col-3 mb-4">
                    <label for="name" class="form-label">Search Keyword</label>
                    <input class="form-control" type="text" id="keyword_search" name="keyword_search">

                    <div class="mt-2">
                        <div class="form-check form-check-inline">
                            <input class="form-check-input" type="radio" name="search_type" id="search_name"
                                value="name" checked>
                            <label class="form-label" for="search_name">Name</label>
                        </div>
                        <div class="form-check form-check-inline">
                            <input class="form-check-input" type="radio" name="search_type" id="search_sku" value="sku">
                            <label class="form-label" for="search_sku">SKU</label>
                        </div>
                    </div>
                </div>

                <div class="col-2 mt-6">
                    <button type="button" class="btn btn-primary" onclick="refresh_data()"><i
                            class="fas fa-refresh"></i>&nbsp; Refresh</button>
                </div>

            </div>
        </div>

        <div class="card-body">
            <div class="card-datatable table-responsive pt-0">
                <table class="datatables-basic table" id="datatable">
                    <thead>
                        {% csrf_token %}
                        <tr>
                            <th>ID</th>
                            <th>EAN</th>
                            <th>Subcategory</th>
                            <th>Brand</th>
                            <th>Model</th>
                            <th>Variant</th>
                            <th>Color</th>
                            <th>Opening Stock</th>
                            <th>Inward</th>
                            <th>Sales</th>
                            <th>Available Stock</th>
                        </tr>

                    </thead>
                    <tbody></tbody>
                </table>
            </div>

            <div class="modal fade" id="opening_modal" tabindex="-1" aria-labelledby="importModalLabel"
                aria-hidden="true">
                <div class="modal-dialog modal-xl">
                    <div class="modal-content">
                        {% csrf_token %}
                        <div class="modal-header">
                            <h5 class="modal-title" id="importModalLabel">Opening Stock - &nbsp;<span
                                    id="open_item_name" style="color: red;"></span></h5>
                            <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                        </div>
                        <div class="modal-body">
                            <div class="table-responsive">
                                <table class="datatables-basic table" id="opening_table">
                                    {% csrf_token %}
                                    <thead>
                                        <tr>
                                            <th>ID</th>
                                            <th>Opening No </th>
                                            <th>Opening Date </th>
                                            <th>Imei No </th>
                                            <th>FSP </th>
                                            <th>WSP</th>
                                            <th>MOP</th>
                                            <th>BOP</th>
                                            <th>Mrp</th>
                                        </tr>
                                    </thead>
                                </table>
                            </div>
                        </div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                        </div>
                        </form>
                    </div>
                </div>
            </div>


            <div class="modal fade" id="stock_modal" tabindex="-1" aria-labelledby="importModalLabel"
                aria-hidden="true">
                <div class="modal-dialog modal-xl">
                    <div class="modal-content">

                        {% csrf_token %}
                        <div class="modal-header">
                            <h5 class="modal-title" id="importModalLabel">Purchase - &nbsp;<span id="item_name"
                                    style="color: red;"></span></h5>
                            <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                        </div>
                        <div class="modal-body">
                            <div class="table-responsive">
                                <table class="datatables-basic table" id="purchase_table">
                                    {% csrf_token %}
                                    <thead>
                                        <tr>
                                            <th>ID</th>
                                            <th>Inward No </th>
                                            <th>Inward Date </th>
                                            <th>Imei No </th>
                                            <th>FSP </th>
                                            <th>WSP</th>
                                            <th>MOP</th>
                                            <th>BOP</th>
                                            <th>Mrp</th>
                                        </tr>
                                    </thead>
                                </table>
                            </div>
                        </div>
                        <div class="modal-footer">
                            <input type="hidden" id="item_id" name="item_id">
                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                        </div>
                        </form>
                    </div>
                </div>
            </div>


            <div class="modal fade" id="sales_modal" tabindex="-1" aria-labelledby="importModalLabel"
                aria-hidden="true">
                <div class="modal-dialog modal-xl">
                    <div class="modal-content">

                        {% csrf_token %}
                        <div class="modal-header">
                            <h5 class="modal-title" id="importModalLabel">Sales - &nbsp;<span id="sales_item_name"
                                    style="color: red;"></span></h5>
                            <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                        </div>
                        <div class="modal-body">
                            <div class="table-responsive">
                                <table class="datatables-basic table" id="sales_table">
                                    {% csrf_token %}
                                    <thead>
                                        <tr>
                                            <th>ID</th>
                                            <th>Inv No </th>
                                            <th>Inv Date </th>
                                            <th>Imei No </th>
                                            <th>rate </th>
                                            <th>amount</th>
                                            <th>tax CGST</th>
                                            <th>tax SGST</th>
                                            <th>BOP</th>
                                        </tr>
                                    </thead>
                                </table>
                            </div>
                        </div>
                        <div class="modal-footer">
                            <input type="hidden" id="item_id" name="item_id">
                            <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                        </div>
                    </div>
                </div>
            </div>
            <div class="modal fade" id="import_modal" tabindex="-1" aria-labelledby="importModalLabel"
                aria-hidden="true">
                <div class="modal-dialog">
                    <div class="modal-content">
                        {% csrf_token %}

                        <form id="importForm" enctype="multipart/form-data">
                            <div class="modal-header">
                                <h5 class="modal-title" id="importModalLabel">Import Stock Data</h5>
                                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                            </div>

                            <div class="modal-body">
                                <input type="file" id="file" name="file" class="form-control" accept=".xlsx, .xls"
                                    required>
                            </div>

                            <div class="modal-footer">
                                <button type="button" class="btn btn-danger" data-bs-dismiss="modal">Close</button>
                                <button type="submit" class="btn btn-success" id="upload_btn">Upload</button>
                            </div>
                        </form>
                    </div>
                </div>
            </div>


        </div>
    </div>







</div>



{% include 'includes/footer.html' %}
{% include 'includes/common_js.html' %}


<script>

    var table;
    $(document).ready(function () {
        refresh_data();
    });

    function initializeDataTable() {
        table = $('#datatable').DataTable({
            "processing": true,
            "pageLength": 50,
            "destroy": true,
            "order": [],
            "dom": getDataTableDom(),
            "buttons": getExportButtons(),

            "columns": [
                { "data": "id", "title": "ID" },
                { "data": "ean", "title": "EAN" },
                { "data": "sub_category", "title": "Subcategory" },
                { "data": "brand", "title": "Brand" },
                { "data": "model", "title": "Model" },
                { "data": "variant", "title": "Variant" },
                { "data": "color", "title": "Color" },
                { "data": "opening", "title": "Opening Stock", "className": "text-end" },
                { "data": "purchase", "title": "Inward", "className": "text-end" },
                { "data": "sales", "title": "Sales", "className": "text-end" },
                { "data": "stock", "title": "Available Stock", "className": "text-end" },

            ],

            "ajax": {
                "url": '/ajax_wholesale_stock_summary/',

                "type": "POST",
                "data": function (data) {
                    data.csrfmiddlewaretoken = document.getElementsByName("csrfmiddlewaretoken")[0].value;
                    const categoryId = $('#filter_category_id').val();
                    const subcategoryId = $('#filter_subcategory_id').val();
                    const brandId = $('#brand_id').val();
                    const keyword = $('#keyword_search').val();
                    const searchType = $("input[name='search_type']:checked").val();

                    if (categoryId) data.category_id = categoryId;
                    if (subcategoryId) data.subcategory = subcategoryId;
                    if (brandId) data.brand_id = brandId;
                    if (keyword) data.keyword_search = keyword;
                    if (searchType) data.search_type = searchType;
                },
                dataSrc: function (response) {
                    if (response.message === 'permission') {
                        showSweetAlert('warning', response.error_message || 'Access Denied');
                        // We return an empty array so DataTables doesn't crash
                        return [];
                    }

                    // IMPORTANT: You must return the array containing your rows
                    // Based on your Python view, this is 'response.data'
                    return response.data || [];
                }
            },





        });
    }



    function refresh_data() {
        if (!table) {
            initializeDataTable();
        } else {
            table.ajax.reload();
        }
    }








    function loadStockTable() {
        var table = $('#stock_table').DataTable({
            "processing": true,
            "pageLength": 50,
            "destroy": true,
            "order": [],
            "dom": 't',
            "columns": [
                {
                    "data": null, // no data from server, we generate it
                    "title": "ID",
                    "render": function (data, type, row, meta) {
                        return meta.row + 1; // row index starts at 0
                    }
                },
                { "data": "action", "title": "Action" },
                { "data": "batch_no", "title": "Batch No" },
                { "data": "barcode_number", "title": "Barcode No" },
                { "data": "available", "title": "Quantity", "className": "text-end" },
                { "data": "rate", "title": "Rate", "className": "text-end" },
                { "data": "mrp", "title": "MRP", "className": "text-end" },
            ],
            "ajax": {
                "url": '/ajax_stock_detail/',
                "type": "POST",
                "data": function (data) {
                    data.csrfmiddlewaretoken = document.getElementsByName("csrfmiddlewaretoken")[0].value;
                    data.item_id = $('#item_id').val();
                },
                dataSrc: function (response) {
                    console.log(response);
                    if (response.message === 'permission') {
                        showSweetAlert('warning', response.error_message || 'You do not have permission to view the user role.');
                        return [];
                    }

                    return response.data || [];
                }
            }
        });
    }




    function open_data(id, name) {
        var tkn = document.getElementsByName("csrfmiddlewaretoken")[0].value;
        $.post('/stock_view/', { id: id, csrfmiddlewaretoken: tkn }, function (res) {
            $('#open_item_id').val(res.id);
            $('#open_item_name').text(res.name || '-');
            $('#open_modal').modal('show');
            loadOpenTable();
        });
    }

    function loadOpenTable() {
        var table = $('#open_table').DataTable({
            "processing": true,
            "pageLength": 50,
            "destroy": true,
            "order": [],
            "dom": 't',
            "columns": [
                { "data": "id", "title": "Id" },
                { "data": "action", "title": "Action" },
                { "data": "date", "title": "date" },
                { "data": "stock", "title": "Stock No" },
                { "data": "qty", "title": "Quantity", "className": "text-end" },
                { "data": "rate", "title": "Rate", "className": "text-end" },
                { "data": "mrp", "title": "MRP", "className": "text-end" },
            ],
            "ajax": {
                "url": '/ajax_open_detail/',
                "type": "POST",
                "data": function (data) {
                    data.csrfmiddlewaretoken = document.getElementsByName("csrfmiddlewaretoken")[0].value;
                    data.item_id = $('#open_item_id').val();

                }
            }
        });
    }

    function barcode_data(id, name) {
        var tkn = document.getElementsByName("csrfmiddlewaretoken")[0].value;
        $.post('/barcode_view/', { id: id, csrfmiddlewaretoken: tkn }, function (res) {
            $('#barcode_id').val(res.id);
            $('#barcode_type').val('stock');
            $('#barcode_modal').modal('show');
        });
    }




    $('#barcodeForm').submit(function (e) {
        e.preventDefault();
        $('#count-error').text('');
        var formData = new FormData(this);

        $.ajax({
            url: '/generate_barcodes/',
            method: 'POST',
            data: formData,
            processData: false,
            contentType: false,
            success: function (response) {

                // 🛑 Permission Denied Block
                if (response.message === 'warning') {
                    Swal.fire({
                        icon: 'warning',
                        title: 'Permission Denied',
                        text: response.error_message,
                    });
                    return; // Stop right here!
                }

                if (response.status === 'error') {
                    $('#count-error').text(response.message);
                    return;
                }

                // Normal Success Flow
                $('#count').val('');
                $('#barcode_type').val('');
                $('#barcode_id').val('');

                var newWindow = window.open("/barcode/", "_blank");
                $('#barcode_modal').modal('hide');
                $('#open_modal').modal('hide');
            },

            error: function (err) {
                $('#count-error').text('Unexpected error occurred while generating barcode.');
            }
        });
    });



    $('#barcode_modal').on('hidden.bs.modal', function () {
        $('#count-error').text('');
        $('#count').val('');
        $('#barcode_id').val('');
        $('#barcode_type').val('');
    });


    function edit_open(id, name) {
        var tkn = document.getElementsByName("csrfmiddlewaretoken")[0].value;
        $.post('/edit_open_stock/', { id: id, csrfmiddlewaretoken: tkn }, function (res) {
            $('#edit_open_id').val(res.id);
            $('#quantity').val(res.opening_stock);
            $('#purchase_price').val(res.purchase_price);
            $('#mrp').val(res.mrp);
            $('#stock_no').text(res.stock_no);
            $('#edit_modal').modal('show');
        });

    }

    $("#edit_form").submit(function (e) {
        e.preventDefault();
        handleFormSubmit(this, '/open_stock_update/', 'edit_modal', 'edit_form', false, 'Opening Stock details',);
    });



    function formatNumberWithCommas(x) {
        if (!x) return '0';
        return x.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",");
    }



    function print_all_barcodes(itemId, batchNo, available_qty) {
        var tkn = document.getElementsByName("csrfmiddlewaretoken")[0].value;

        var formData = new FormData();
        formData.append("item_id", itemId);
        formData.append("batch_no", batchNo);
        formData.append("available_qty", available_qty);
        formData.append("csrfmiddlewaretoken", tkn);
        formData.append("barcode_type", "stock_all_barcodes"); // 👈 special flag

        $.ajax({
            url: "/generate_barcodes/",
            method: "POST",
            data: formData,
            processData: false,
            contentType: false,
            success: function (response) {
                if (response.status === "error") {
                    alert(response.message);
                    return;
                }

                // Open print window directly
                var newWindow = window.open("", "_blank");
                newWindow.document.write(response);
                newWindow.document.close();


            },
            error: function (err) {
                alert("Unexpected error occurred while printing all barcodes.");
            }
        });
    }


    function opening_data(subcategoryId, brandId, modelId, variantId, colorId) {

        $('#opening_modal').modal('show');
        $('#open_item_name').text('Loading...');


        if ($.fn.DataTable.isDataTable('#opening_table')) {
            $('#opening_table').DataTable().destroy();
        }
        let openingTable = $('#opening_table').DataTable({
            "processing": true,
            "pageLength": 10,
            "dom": 'tp',
            "ajax": {
                "url": "/load_opening_imeis/", // Update with your actual URL path
                "type": "POST",
                "data": {
                    "csrfmiddlewaretoken": document.querySelector('[name=csrfmiddlewaretoken]').value,
                    "subcategory_id": subcategoryId,
                    "brand_id": brandId,
                    "model_id": modelId,
                    "variant_id": variantId,
                    "color_id": colorId,
                },
                "dataSrc": function (json) {
                    $('#open_item_name').text(json.item_name);
                    return json.data;
                }
            },
            "columns": [
                { "data": "id", "title": "ID" },
                { "data": "pu_no", "title": "Inward no" },
                { "data": "pu_date", "title": "Inward Date" },
                { "data": "imei_no", "title": "IMEI No" },
                { "data": "fsp", "title": "FSP", "className": "text-end" },
                { "data": "wsp", "title": "WSP", "className": "text-end" },
                { "data": "mop", "title": "MOP", "className": "text-end" },
                { "data": "bop", "title": "BOP", "className": "text-end" },
                { "data": "mrp", "title": "MRP", "className": "text-end" }
            ]
        });
    }




    function purchase_data(subcategoryId, brandId, modelId, variantId, colorId) {

        $('#stock_modal').modal('show');
        $('#item_name').text('Loading...');


        if ($.fn.DataTable.isDataTable('#purchase_table')) {
            $('#purchase_table').DataTable().destroy();
        }
        let purchaseTable = $('#purchase_table').DataTable({
            "processing": true,
            "pageLength": 10,
            "dom": 't',
            "ajax": {
                "url": "/load_purchase_imeis/", // Update with your actual URL path
                "type": "POST",
                "data": {
                    "csrfmiddlewaretoken": document.querySelector('[name=csrfmiddlewaretoken]').value,
                    "subcategory_id": subcategoryId,
                    "brand_id": brandId,
                    "model_id": modelId,
                    "variant_id": variantId,
                    "color_id": colorId,
                },
                "dataSrc": function (json) {
                    $('#item_name').text(json.item_name);
                    return json.data;
                }
            },
            "columns": [
                { "data": "id", "title": "ID" },
                { "data": "pu_no", "title": "Inward no" },
                { "data": "pu_date", "title": "Inward Date" },
                { "data": "imei_no", "title": "IMEI No" },
                { "data": "fsp", "title": "FSP", "className": "text-end" },
                { "data": "wsp", "title": "WSP", "className": "text-end" },
                { "data": "mop", "title": "MOP", "className": "text-end" },
                { "data": "bop", "title": "BOP", "className": "text-end" },
                { "data": "mrp", "title": "MRP", "className": "text-end" }
            ]
        });
    }




    function sales_data(subcategoryId, brandId, modelId, variantId, colorId) {
        $('#sales_modal').modal('show');
        $('#sales_item_name').text('Loading...');

        if ($.fn.DataTable.isDataTable('#sales_table')) {
            $('#sales_table').DataTable().destroy();
        }

        let salesTable = $('#sales_table').DataTable({
            "processing": true,
            "pageLength": 10,
            "dom": 't',
            "ajax": {
                "url": "/load_sales_imeis/", // Update with your actual URL path
                "type": "POST",
                "data": {
                    "subcategory_id": subcategoryId,
                    "brand_id": brandId,
                    "model_id": modelId,
                    "variant_id": variantId,
                    "color_id": colorId,
                    "csrfmiddlewaretoken": document.querySelector('[name=csrfmiddlewaretoken]').value
                },
                "dataSrc": function (json) {
                    $('#sales_item_name').text(json.item_name);
                    return json.data;
                }
            },
            "columns": [
                { "data": "id", "title": "ID" },
                { "data": "inv_no", "title": "Inv No" },
                { "data": "inv_date", "title": "Inv Date" },
                { "data": "imei_no", "title": "IMEI No" },
                { "data": "rate", "title": "Rate", "className": "text-end" },
                { "data": "amount", "title": "Amount", "className": "text-end" },
                { "data": "tax_cgst", "title": "CGST", "className": "text-end" },
                { "data": "tax_sgst", "title": "SGST", "className": "text-end" },
                { "data": "bop", "title": "BOP", "className": "text-end" }
            ]
        });
    }


    function downloadSampleFile() {
        showToast('info', 'Started Downloading ....');
        window.location.href = '/wholesale/download-sample/';
    }

    // $('#importForm').on('submit', function (e) {
    //     e.preventDefault();

    //     const formData = new FormData(this);
    //     const csrftoken = getCookie('csrftoken');

    //     $('#upload_btn').prop('disabled', true);

    //     $.ajax({
    //         url: '/import-opening-stock/',
    //         type: 'POST',
    //         data: formData,
    //         processData: false,
    //         contentType: false,
    //         headers: {
    //             'X-CSRFToken': csrftoken
    //         },
    //         success: function (response) {
    //             $('#import_modal').modal('hide');
    //             showToast('success', response.message || 'Import successful.');
    //             $('#file').val('');

    //             // setTimeout(() => location.reload(), 1000);
    //         },
    //         error: function (xhr) {
    //             showToast(
    //                 'error',
    //                 xhr.responseJSON?.message || 'Import failed.'
    //             );
    //         },
    //         complete: function () {
    //             $('#upload_btn').prop('disabled', false);
    //         }
    //     });
    // });

    $('#importForm').on('submit', function (e) {
        e.preventDefault();

        const formData = new FormData(this);
        const csrftoken = getCookie('csrftoken');

        $('#upload_btn').prop('disabled', true);

        $.ajax({
            url: '/wholesale/import-opening-stock/',
            type: 'POST',
            data: formData,
            processData: false,
            contentType: false,
            headers: {
                'X-CSRFToken': csrftoken
            },
            success: function (response) {
                $('#import_modal').modal('hide');
                $('#file').val('');

                // ✅ Success summary
                showToast('success', response.message || 'Import successful.');


                // ⚠️ Show skipped info (if any)
                let alertMsg = '';

                if (response.skipped_imeis && response.skipped_imeis.length) {
                    alertMsg += `Skipped IMEIs:\n\n` +
                        response.skipped_imeis.join('\n') + '\n\n';
                }

                if (response.skipped_rows && response.skipped_rows.length) {
                    alertMsg += `Skipped Rows:\n\n` +
                        response.skipped_rows.join('\n');
                }

                if (alertMsg) {
                    setTimeout(() => {
                        showSweetAlert('info', alertMsg); // simple + reliable
                    }, 300);
                }
                refresh_data();
            },
            error: function (xhr) {
                showToast(
                    'error',
                    xhr.responseJSON?.message || 'Import failed.'
                );
            },
            complete: function () {
                $('#upload_btn').prop('disabled', false);
            }
        });
    });


    function getCookie(name) {
        let cookieValue = null;
        if (document.cookie && document.cookie !== '') {
            const cookies = document.cookie.split(';');
            for (let i = 0; i < cookies.length; i++) {
                const cookie = cookies[i].trim();
                if (cookie.substring(0, name.length + 1) === (name + '=')) {
                    cookieValue = decodeURIComponent(cookie.substring(name.length + 1));
                    break;
                }
            }
        }
        return cookieValue;
    }

</script>