{% 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">Sales Analysis</h4>
        </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">Reports</li>
                <li class="breadcrumb-item active" aria-current="page">Sales Analysis </li>
            </ol>
        </nav>
    </div>
    <div class="card">
        <div class="card-header border-bottom">
            <div class="row mt-2">
                <div class="col-2">
                    <label class="form-label">Date Filter</label>
                    <input type="checkbox" id="is_date" checked>
                    <input type="text" id="date_filter" class="form-control" style="cursor: pointer;" />
                    <input type="hidden" id="from_date" name="from_date">
                    <input type="hidden" id="to_date" name="to_date">
                </div>
                {% if request.session.is_ho == 1 %}
                <div class="col-2 mb-5">
                    <label for="name" class="form-label">Branch</label>
                    <select class="select2 form-control" id="filter_branch_id" name="branch_id">
                        <option value="">Select</option>
                        {% for k in branch %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>
                {% endif %}
                <div class="col-2 mb-5">
                    <label for="name" class="form-label">Customer</label>
                    <select class="select2 form-control" id="filter_customer_id" name="customer_id">
                        <option value="">Select</option>
                        {% for k in customers %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>

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

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


                <div class="col-2 mb-5">
                    <label for="name" class="form-label">Model</label>
                    <select class="select2 form-control" id="filter_model_id" name="model_id">
                        <option value="">Select</option>
                        {% for k in models %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="col-2 mb-5">
                    <label for="name" class="form-label">Variant</label>
                    <select class="select2 form-control" id="filter_variant_id" name="variant_id">
                        <option value="">Select</option>
                        {% for k in variants %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="col-2 mb-5">
                    <label for="name" class="form-label">Color</label>
                    <select class="select2 form-control" id="filter_color_id" name="color_id">
                        <option value="">Select</option>
                        {% for k in colors %}
                        <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()"><i
                            class="fas fa-search"></i>&nbsp; Search</button>
                </div>
            </div>
        </div>
        <div class="card-body">
            <div class="card-datatable table-responsive pt-0">
                <table class="datatables-basic table table-bordered" id="datatable">
                    <thead>
                        {% csrf_token %}
                        <tr>
                            <th rowspan="2">Id</th>
                            <th rowspan="2">Branch</th>
                            <th rowspan="2">SKU</th>
                            <th rowspan="2">Subcategory</th>
                            <th rowspan="2">Brand</th>
                            <th rowspan="2">Models</th>
                            <th rowspan="2">Variant</th>
                            <th rowspan="2">Color</th>
                            <th rowspan="2">Inward No</th>
                            <th rowspan="2">Inward Date</th>
                            <th rowspan="2">Supplier No</th>
                            <th rowspan="2">Supplier Date</th>
                            <th rowspan="2">Supplier</th>
                            <th rowspan="2">Purchase Price (₹)</th>
                            <th rowspan="2">IMEI</th>
                            <th rowspan="2">Inv Date</th>
                            <th rowspan="2">Inv No</th>
                            <th rowspan="2">Customer</th>
                            <th rowspan="2">Customer Phone</th>
                            <th rowspan="2">Customer Type</th>
                            <th rowspan="2">Selling Price (₹)</th>
                            <th rowspan="2">Margin (₹)</th>
                            <th rowspan="2">Special (₹)</th>
                            <th rowspan="2">Upgrade (₹)</th>
                            <th colspan="4">Price Drop (₹)</th>
                            <th rowspan="2">Employee</th>
                        </tr>
                        <tr>
                            <th>MOP (₹)</th>
                            <th>BOP (₹)</th>
                            <th>WSP (₹)</th>
                            <th>FSP (₹)</th>
                        </tr>
                    </thead>
                    <tbody></tbody>
                </table>
            </div>
        </div>


    </div>
</div>

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

    $(document).ready(function () {

        initializeDateRangePicker('this_month');
        refresh_data();



    });

    function initializeDataTable() {
        table = $('#datatable').DataTable({
            "processing": true,
            "pageLength": 50,
            "destroy": true,
            "order": [],
            "searching": true,
            "dom": getDataTableDom(),
            "buttons": getExportButtons(),
            "columns": [
                { "data": "id", "title": " ID #" },
                { "data": "branch", "title": "Branch" },
                { "data": "sku", "title": "SKU" },
                { "data": "subcategory", "title": "Subcategory" },
                { "data": "brand", "title": "Brand" },
                { "data": "model", "title": "Model" },
                { "data": "variant", "title": "Variant" },
                { "data": "color", "title": "Color" },
                { "data": "inward_no", "title": "Inward No" },
                { "data": "inward_date", "title": "Inward Date" },
                { "data": "supplier_no", "title": "Supplier No" },
                { "data": "supplier_date", "title": "Supplier Date" },
                { "data": "supplier", "title": "Supplier" },
                { "data": "purchase_price", "title": "Purchase Price (₹)", className: "text-end"},
                { "data": "imei", "title": "IMEI" },
                { "data": "inv_date", "title": "Inv Date" },
                { "data": "inv_no", "title": "Inv No" },
                { "data": "customer", "title": "Customer" },
                { "data": "customer_phone", "title": "Customer Phone" },
                { "data": "customer_type", "title": "Customer Type" },
                { "data": "selling_price", "title": "Selling Price (₹)", className: "text-end"},
                { "data": "margin", "title": "Margin (₹)", className: "text-end"},
                { "data": "special", "title": "Special (₹)", className: "text-end"},
                { "data": "upgrade", "title": "Upgrade (₹)", className: "text-end"},
                { "data": "mop_discount", "title": "MOP (₹)", className: "text-end"},
                { "data": "bop_discount", "title": "BOP (₹)", className: "text-end"},
                { "data": "wsp_discount", "title": "WSP (₹)", className: "text-end"},
                { "data": "fsp_discount", "title": "FSP (₹)", className: "text-end"},
                { "data": "employee", "title": "Employee" },



            ],
            "ajax": {
                "url": '/ajax_sales_analysis_report/',
                "type": "POST",

                "data": function (data) {
                    data.csrfmiddlewaretoken = document.getElementsByName("csrfmiddlewaretoken")[0].value;
                    const customer = $('#filter_customer_id').val();
                    const branch = $('#filter_branch_id').val();
                    const subcategory = $('#filter_subcategory_id').val();
                    const brand = $('#filter_brand_id').val();
                    const model = $('#filter_model_id').val();
                    const variant = $('#filter_variant_id').val();
                    const color = $('#filter_color_id').val();

                    const isDateChecked = $('#is_date').is(":checked");
                    const fromDate = $('#from_date').val();
                    const toDate = $('#to_date').val();

                    if (customer) data.customer_id = customer;
                    if (branch) data.branch_id = branch;
                    if (subcategory) data.subcategory_id = subcategory;
                    if (brand) data.brand_id = brand;
                    if (model) data.model_id = model;
                    if (variant) data.variant_id = variant;
                    if (color) data.color_id = color;

                    if (isDateChecked && fromDate && toDate) {
                        data.from_date = fromDate;
                        data.to_date = toDate;
                    }
                },
                dataSrc: function (response) {
                    if (response.message === 'permission') {
                        showSweetAlert('warning', response.error_message || 'You do not have permission.');
                        table.clear().draw();
                        return [];
                    }

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


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


    function sales_data(sales_id) {
        var encodedId = btoa(sales_id);
        window.location.href = '/sales?id=' + encodedId;
    }


</script>