{% load static %}
{% include 'includes/header.html' %}
{% include 'includes/store_sidebar.html' %}
{% include 'includes/navbar.html' %}
{% include 'includes/datatable_css.html' %}

<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">Price List</h4>
        </div>

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

    <div class="card">
        <div class="card-header border-bottom">
            <div class="row mt-2">
                <div class="col-2 mb-3">
                    <label for="filter_category_id" class="form-label">Subcategory</label>
                    <select class="select2 form-control" id="filter_sub_category_id" name="sub_category_id">
                        <option value="">Select</option>
                        {% for k in sub_category %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="col-2 mb-3">
                    <label for="filter_category_id" class="form-label">Brand</label>
                    <select class="select2 form-control" id="filter_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-2 mb-3">
                    <label for="filter_model_id" class="form-label">Model</label>
                    <select class="select2 form-control" id="filter_model_id" name="model_id">
                        <option value="">Select</option>
                        {% for k in model %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="col-2 mb-3">
                    <label for="filter_model_id" class="form-label">variant</label>
                    <select class="select2 form-control" id="filter_variant_id" name="variant_id">
                        <option value="">Select</option>
                        {% for k in variant %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>
                <div class="col-2 mt-6">
                    <button type="button" class="btn btn-primary" onclick="refresh_data()">&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">
                    {% csrf_token %}
                    <thead>
                        {% csrf_token %}
                        <tr>
                            <th>Id</th>
                            <th>Branch</th>
                            <th>Subcategory</th>
                            <th>Brand</th>
                            <th>Model</th>
                            <th>Variant</th>
                            <th>Color</th>
                            <th>HSN Code</th>
                            <th>Shelf Life</th>
                            <th>IMEI</th>
                            <th>Source</th>
                            <th>DB Price (₹)</th>
                            <th>MRP (₹)</th>
                            <th>MOP (₹)</th>
                            <th>BOP (₹)</th>
                        </tr>
                    </thead>
                </table>
            </div>
        </div>
    </div>




</div>


{% include 'includes/footer.html' %}
{% include 'includes/common_js.html' %}
{% include 'includes/load_dropdown.html' %}
{% include 'includes/price_helper.html' %}
<script>
    var table;

    $(document).ready(function () {
        initializeDateRangePicker('this_month');
        refresh_data();

    });


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

            columns: [
                { data: "id", title: "Id" },
                { data: "branch", title: "Branch" },
                { data: "sub_category", title: "Subcategory" },
                { data: "brand", title: "Brand" },
                { data: "model", title: "Model" },
                { data: "variant", title: "Variant" },
                { data: "color", title: "Color" },
                { data: "hsn_code", title: "HSN Code" },
                { data: "shelf_life", title: "Shelf Life" },
                { data: "imei", title: "IMEI" },
                { data: "source", title: "Source" },
                { data: "db_price", title: "Amount (₹)", className: "text-end" },



                { data: "mrp", title: "MRP (₹)", className: "text-end" },
                { data: "mop", title: "MOP (₹)", className: "text-end" },
                { data: "bop", title: "BOP (₹)", className: "text-end" },
                // { data: "stock", title: "Stock", className: "text-end" },

            ],

            ajax: {
                url: '/ajax_price_list_view/',
                type: 'POST',
                data: function (data) {
                    data.csrfmiddlewaretoken = document.getElementsByName("csrfmiddlewaretoken")[0].value;
                    data.subcategory = $('#filter_subcategory_id').val();
                    data.brand_id = $('#filter_brand_id').val();
                    data.model_id = $('#filter_model_id').val();
                    data.variant_id = $('#filter_variant_id').val();
                    data.color_id = $('#filter_color_id').val();
                    data.stock = $('#filter_stock').val();
                    data.branch_id = $('#filter_branch').val();
                },
                dataSrc: function (response) {
                    if (response.message === 'permission') {
                        showSweetAlert('warning', response.error_message || 'You do not have permission to view the user role.');
                        table.clear().draw();
                        return [];
                    }

                    let availableStock = parseFloat(response.available_qty || 0);
                    $('#total_available_stock').text(availableStock);

                    // 🔥 HIDE FSP & WSP FOR NON-HO
                    if (response.is_ho == 0) {
                        table.column(10).visible(false); // FSP index
                        table.column(11).visible(false); // WSP index
                        // table.column(1).visible(false); // WSP index
                    }

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

            // 🎨 ROW COLOR LOGIC
            rowCallback: function (row, data) {
                if (parseInt(data.stock) === 0) {
                    // $(row).addClass('bg-debit'); // Bootstrap red
                }

            }
        });
    }



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








    function edit_data(id) {
        var encodedId = btoa(id);
        window.location.href = '/price-drop/edit/?id=' + encodedId;
    }
</script>