@extends('layouts/pos_layout')
@section('title', '| ' . $data['pageTitle'])
@section('content')
    <style>
        .page-item.active .page-link {
            background-color: lightgrey !important;
            border: 1px solid black;
        }

        .page-link {
            color: black !important;
        }

        .table.table-condensed>thead>tr>td,
        .table.table-condensed>tbody>tr>td,
        .table.table-condensed>tfoot>tr>td,
        .table.table-condensed>thead>tr>th,
        .table.table-condensed>tbody>tr>th,
        .table.table-condensed>tfoot>tr>th {
            padding: 5px 3px !important;
            font-size: 11px !important;
            border: 1px solid #dbdbdb !important;

        }

        .table thead tr th {
            font-size: 11px !important;
        }

        tr.footerrow {
            font-weight: bold;
        }

        p.text-center.reportHeading {
            font-size: 13px;
        }

        @media only screen and (max-width: 1320px) {

            .select2-container {
                min-width: 100% !important;
                height: 33px;
                width: 13vw !important;
            }
        }
    </style>

    <div class="row page-wrap ">
        <div class="col-md-12">
            <div class="" style="">
                <div class=" ">


                    <div class="panel panel-default" style="background-color:#708090;">
                        <div class="panel-heading" style="padding-bottom:0px">
                            <div class="panel-title">
                                <h2>{{ $data['pageTitle'] }}</h2>
                            </div>
                            <div class="panel-options">
                                <a href="" class="btn btn-info pull-right addViewBtn printIcon"
                                    id="exportExcelButton">
                                    <i class="glyphicon glyphicon-plus-sign addIcon"></i>Excel
                                </a>
                            </div>
                        </div>


                        <div class="panel-body panelBodyView printIcon" id="printDiv">
                            @php
                                $searchElements = [
                                    ['element' => 'fillBranchIdForExportImport'],
                                    ['element' => 'customerId'],
                                    ['element' => 'dateTo'],
                                ];
                            @endphp
                            @include('partials.searchPanel.main', ['searchElements' => $searchElements])

                            <div class="row vert-offset-top-2" id="stockReportPdf">

                                <style>
                                    @media print {

                                        #stockReportPdf {
                                            visibility: visible;
                                            overflow-x: unset;
                                        }

                                        .text-nowrap {
                                            white-space: normal;
                                        }

                                        table th {
                                            border-top: 1px solid red !important;
                                        }

                                        .table thead tr th {
                                            font-size: 11px !important;
                                            border: 1px solid #474444 !important;
                                            font-weight: bold;
                                        }

                                        .table thead tr td {
                                            border: 1px solid #848484 !important;
                                        }

                                        .table.table-condensed>tbody>tr>td {
                                            border: 1px solid #848484 !important;
                                            color: #000 !important;
                                            padding: 5px 2px !important;
                                            font-size: 11px !important;
                                        }

                                        .table.table-condensed>tfoot>tr>th {
                                            border: 1px solid #827a7a !important;
                                            border-left: 1px solid #827a7a !important;
                                            border-right: 1px solid #827a7a !important;
                                        }

                                        tr.footerrow {
                                            font-weight: bold;
                                        }

                                        p.text-center.reportHeading {
                                            font-size: 15px;
                                        }
                                    }
                                </style>
                                <p class="text-center reportHeading">
                                    <span class="companyNameData" style="color:#fff;"><b> {{ $data['company']->name }}
                                        </b></span><br>
                                    <span
                                        style="color:#fff;font-size:11px;"><b>{{ $data['company']->address }}</b></span><br>
                                    <span style="color:#fff;"><b>{{ $data['pageTitle'] }}</b></span><br>
                                    <span style="color:#fff;"><b><span id="reportlevelName">Branch Name: </span></b></span>
                                    <span id="brnachName" style="color:#fff;"></span><br>
                                    <span style="color:#fff;"><b>As on:</b></span><span id="daterange"
                                        style="color:#fff;"></span><br>
                                </p>

                                <p class="text-right" style="color:#fff;">Printed Date: {{ date('d-m-Y') }}</p>
                                <table
                                    class="table table-striped table-bordered table-condensed first-col-dark dataTable no-footer"
                                    cellpadding="0" cellspacing="0" width="100">
                                    <thead>
                                        <tr>
                                            <th width="0"><b>SL No</b></th>
                                            <th class="text-nowrap"><b>Branch Opening Date</b></th>
                                            <th class="text-nowrap"><b>Sales Date</b></th>
                                            <th class="text-nowrap"><b>Last Collecction Date</b></th>
                                            <th class="text-nowrap"><b>Customer</b></th>
                                            <th class="text-nowrap"><b>Customer Mobile</b></th>
                                            <th class="text-nowrap"><b>Sales Info</b></th>
                                            <th class="text-nowrap"><b>Product</b></th>
                                            <th class="text-nowrap"><b>PID/EMEI Number</b></th>
                                            <th class="text-nowrap"><b>Qty</b></th>
                                            <th class="text-nowrap"><b>Sales Price (Tk)</b></th>
                                            <th class="text-nowrap"><b>Installment Amount (Tk)</b></th>
                                            {{-- <th class="text-nowrap"><b>Fee(Processing/Others) (Tk)</b></th> --}}
                                            <th class="text-nowrap"><b>Gross Amount (Tk)</b></th>
                                            <th class="text-nowrap"><b>Principle Amount (Tk)</b></th>
                                            <th class="text-nowrap"><b>Profit Amount (Tk)</b></th>
                                            <th class="text-nowrap"><b>Cash Amount (Tk)</b></th>
                                            <th class="text-nowrap"><b>Paid Amount (Tk)</b></th>
                                            <th class="text-nowrap"><b>Balance Amount (Tk)</b></th>
                                        </tr>

                                    </thead>
                                    <tbody id="table_data">
                                    </tbody>
                                    <tfoot align="right" id="table_footer_data">
                                    </tfoot>
                                </table>

                                <div id="forDownLoadExcelDiv" style="display: none;">
                                    {{-- <div id="forDownLoadExcelDiv"> --}}
                                    <p class="text-center reportHeadingForExcell">
                                        <span style="color:#fff;"><b>{{ $data['pageTitle'] }}</b></span><br>
                                        <span style="color:#fff;"><b><span>Branch Name: </span></b></span> <span
                                            id="brnachNameForExcell" style="color:#fff;"></span><br>
                                    </p>
                                    <table id="forDownLoadExcelTable"
                                        class="table table-striped table-bordered table-condensed first-col-dark dataTable no-footer"
                                        cellpadding="0" cellspacing="0" width="100">
                                    </table>
                                </div>

                                {{-- <div class="row userInfoMainDiv" style="padding: 100px 15px 5px 15px; ">
                                <table class="" id="" style="color:black;font-size: 12px; font-weight: bold; width:100%">
                                    <tbody>
                                        <tr>
                                            <td style="text-align:left;  width: 25%">Prepared By</td>
                                            <td style="text-align:center;  width: 20%">Verified By</td>
                                            <td style="text-align:right; width: 25%">Reviewed By</td>
                                            <td style="text-align:right;">Approved By</td>
                                        </tr>
                                    </tbody>
                                </table>

                            </div> --}}
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <script src="{{ asset('js/eims/sheetjs/xlsx.full.min.js') }}"></script>
    <script>
        $(document).ready(function() {

            $('#fillBranchIdForExportImport').change(function() {
                var branchId = $(this).val();
                if (branchId) {
                    getCustomerByBranch(branchId);
                }
            });

            $('form').submit(function(event) {
                event.preventDefault();
                $('#daterange').html('');
                $('#table_footer_data').html('');
                // for as on date
                var datehtml = '';
                var branchhtml = '';
                var dateTo = $('#fillDateTo').val();
                datehtml = dateTo;
                $('#daterange').html(datehtml);

                $('#loadingModal').show();
                var form = $('form').serialize();
                $('#table_data').html('');
                $('#forDownLoadExcelTable').html('');
                //check date is selected or not

                var fillBranchIdForExportImport = $('#fillBranchIdForExportImport').val();
                if (fillBranchIdForExportImport == "") {

                    $('#loadingModal').hide();
                    Swal.fire({
                        icon: 'error',
                        title: 'Please select branch!',
                        showConfirmButton: true,
                    })
                    return false;
                }

                var enddate = $('#fillDateTo').val();
                if (enddate == "") {

                    $('#loadingModal').hide();
                    Swal.fire({
                        icon: 'error',
                        title: 'Please select  end date first!',
                        showConfirmButton: true,
                    })
                    return false;
                }

                $.ajax({
                    type: 'post',
                    url: '{{ Request::url() }}',
                    data: $('form').serialize(),
                    dataType: 'json',
                    success: function(_response) {
                        console.log(_response.data);
                        $('#loadingModal').hide();
                        if (_response.responseTitle == 'success') {
                            $('#brnachName').html(_response.branch);
                            $('#brnachNameForExcell').html(_response.branch);
                            var finalTotalQuantity = 0;
                            var finalTotalSalesAmount = 0;
                            var finalTotalInstallmentAmount = 0;
                            var finalTotalFee = 0;
                            var finalTotalAmount = 0;
                            var finalTotalPrincipleAmount = 0;
                            var finalTotalProfitAmount = 0;
                            var finalTotalCashAmount = 0;
                            var finalTotalPaidAmount = 0;
                            var finalTotalBalanceAmount = 0;
                            var serial = 0;

                            var htmlBodyDataForViewReport = '';

                            var htmlTableDataForDownLoadExcel = '';

                            htmlTableDataForDownLoadExcel = '<thead><tr>';
                            htmlTableDataForDownLoadExcel += '<th width="0">sl_no</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">branch_code</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">branch_opening_date</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">sales_date</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">last_collection_date</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">customer_id_no</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">customer_mobile</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">customer_unique_id</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">sales_bill_no</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">pass_book_no</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">sales_type</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">installment_package</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">installment_type</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">supplier_name</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">supplier_company_name</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">group_name</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">category_name</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">sub_category_name</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">brand_name</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">model_name</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">size_name</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">color_name</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">uom_name</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">barcode</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">pid_emei_number</th>';
                            htmlTableDataForDownLoadExcel += '<th class="text-nowrap">qty</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">product_cost_price</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">product_sales_price</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">sales_amount</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">installment_amount</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">processing_fee_id</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">processing_fee</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">others_fee_id</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">others_fee</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">gross_amount</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">principal_amount</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">profit_amount</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">cash_amount</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">paid_amount</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">balance_amount</th>';
                            htmlTableDataForDownLoadExcel +=
                                '<th class="text-nowrap">is_sale_replace</th>';
                            htmlTableDataForDownLoadExcel += '<th class="text-nowrap">old_company_name_from_import</th>';
                            htmlTableDataForDownLoadExcel += '</thead></tr>';

                            $.each(_response.data, function(key, value) {
                                serial++;
                                htmlBodyDataForViewReport = '<tr>';
                                htmlBodyDataForViewReport += '<td>' + serial + ' </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_branch_opening_date + ' </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_sales_date + ' </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_last_collection_date + ' </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_customer_id_no + '-' + value
                                    .view_customer_name + ' </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_customer_mobile_no + ' </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_sales_bill_no + '<br>' + value
                                    .view_pass_book_no + '<br>' + value
                                    .view_installment_type + '<br>' + value
                                    .view_installment_package + ' </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_product_name + '-' + value
                                    .view_product_barcode + '  </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_barcode_serial + '  </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_product_qty + '  </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:right"> ' + zerocheck(value
                                        .view_sales_amount) + '  </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:right"> ' + zerocheck(value
                                        .view_installment_amount) + '  </td>';
                                // htmlBodyDataForViewReport +=
                                //     '<td  style="text-align:right"> ' + zerocheck(value
                                //         .view_processing_fee) + '<br>' + zerocheck(value
                                //         .view_others_fee) + '  </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:right"> ' + zerocheck(value
                                        .view_total) + '  </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_principal_total + '  </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_profit_total + '  </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_cash_total + '  </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:right"> ' + zerocheck(value
                                        .view_paid_total) + '  </td>';
                                htmlBodyDataForViewReport +=
                                    '<td  style="text-align:right"> ' + zerocheck(value
                                        .view_balance_amount) + '  </td>';
                                htmlBodyDataForViewReport += '</tr> ';

                                finalTotalQuantity += parseFloat(value
                                    .view_product_qty);
                                finalTotalSalesAmount += parseFloat(value
                                    .view_sales_amount);
                                finalTotalInstallmentAmount += parseFloat(value
                                    .view_installment_amount);
                                // finalTotalFee += parseFloat(value.view_fee_total);
                                finalTotalAmount += parseFloat(value.view_total);
                                finalTotalPrincipleAmount += parseFloat(value.view_principal_total);
                                finalTotalProfitAmount += parseFloat(value.view_profit_total);
                                finalTotalCashAmount += parseFloat(value.view_cash_total);
                                finalTotalPaidAmount += parseFloat(value
                                    .view_paid_total);
                                finalTotalBalanceAmount += parseFloat(value
                                    .view_balance_amount);
                                $('#table_data').append(htmlBodyDataForViewReport);

                                htmlTableDataForDownLoadExcel += '<tr>';
                                htmlTableDataForDownLoadExcel += '<td>' + serial +
                                    ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_branch_code + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_branch_opening_date + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_sales_date + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_last_collection_date + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_customer_id_no + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_customer_mobile_no + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_customer_unique_id + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_sales_bill_no_val + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_pass_book_no + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_sales_type + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_installment_package + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_installment_type + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_supplier_name + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_supplier_company_name + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_group_name + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_category_name + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_sub_category_name + ' </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_brand_name + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_model_name + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_size_name + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_color_name + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_uom_name + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_product_barcode + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_barcode_serial + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_product_qty + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_product_cost_price + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_product_sales_price + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_sales_amount + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_installment_amount + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_processing_fee_id + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_processing_fee + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_others_fee_id + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_others_fee + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_total + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_principal_total + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_profit_total + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_cash_total + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_paid_total + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:right"> ' + value
                                    .view_balance_amount + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_is_sale_replace + '  </td>';
                                htmlTableDataForDownLoadExcel +=
                                    '<td  style="text-align:center"> ' + value
                                    .view_old_company_name_from_import + '  </td>';
                                htmlTableDataForDownLoadExcel += '</tr> ';
                            });
                            var htmlFooterDataForViewReport = '';
                            htmlFooterDataForViewReport = '<tr class="footerrow">';
                            htmlFooterDataForViewReport +=
                                '<td style="text-align:center" class="text-nowrap" colspan="9">Total</td>';
                            htmlFooterDataForViewReport +=
                                '<td style="text-align:center" class="text-nowrap">' +
                                finalTotalQuantity + '</td>';
                            htmlFooterDataForViewReport += '<td style="text-align:right" >' +
                                zerocheck(finalTotalSalesAmount) + '</td>';
                            htmlFooterDataForViewReport += '<td style="text-align:right" >' +
                                zerocheck(finalTotalInstallmentAmount) + '</td>';
                            // htmlFooterDataForViewReport += '<td style="text-align:right" >' +
                            //     zerocheck(finalTotalFee) + '</td>';
                            htmlFooterDataForViewReport += '<td style="text-align:right" >' +
                                zerocheck(finalTotalAmount) + '</td>';
                            htmlFooterDataForViewReport += '<td style="text-align:right" >' +
                                zerocheck(finalTotalPrincipleAmount) + '</td>';
                            htmlFooterDataForViewReport += '<td style="text-align:right" >' +
                                zerocheck(finalTotalProfitAmount) + '</td>';
                            htmlFooterDataForViewReport += '<td style="text-align:right" >' +
                                zerocheck(finalTotalCashAmount) + '</td>';
                            htmlFooterDataForViewReport += '<td style="text-align:right" >' +
                                zerocheck(finalTotalPaidAmount) + '</td>';
                            htmlFooterDataForViewReport += '<td style="text-align:right" >' +
                                zerocheck(finalTotalBalanceAmount) + '</td>';
                            htmlFooterDataForViewReport += '</tr> ';

                            $('#table_data').append(htmlFooterDataForViewReport);
                            $('#forDownLoadExcelTable').append(htmlTableDataForDownLoadExcel);


                        } else {
                            $('#loadingModal').hide();
                            Swal.fire({
                                icon: 'error',
                                title: 'Something went wrong!',
                                showConfirmButton: true
                            })
                            return false;
                        }

                    },
                    error: function(_response) {
                        toastr.error('_response.errors');
                        $('#loadingModal').hide();

                    }
                });
            });

        });

        function getCustomerByBranch(branchId, setCustomer) {
            if (branchId) {
                $.ajax({
                    type: "POST",
                    url: '{{ route('get-branch-wise-customer') }}',
                    data: {
                        '_token': $('input[name=_token]').val(),
                        'branchId': branchId
                    },
                    success: function(res) {
                        if (res) {
                            var selected = '';
                            $("#customer_id").empty();
                            $("#customer_id").prepend(
                                '<option value="">Select Customer</option>');

                            $.each(res, function(key, value) {
                                if (key == setCustomer) {
                                    selected = 'selected="selected"';
                                } else {
                                    selected = '';
                                }
                                console.log(selected);
                                $('#customer_id').append("<option " + selected + " value='" + key +
                                    "'>" + value +
                                    "</option>");
                            });
                        } else {
                            $('#customer_id').empty().append('<option value="0">Select Customer</option>');
                        }
                    }
                });
            }
        }

        function zerocheck(value) {

            if (value == 0) {
                return "-";
            } else {
                return value.toLocaleString("en-IN", {
                    minimumFractionDigits: 2,
                    maximumFractionDigits: 2
                });
                // return value;
            }

        }


        document.getElementById('exportExcelButton').addEventListener('click', (event) => {
            event.preventDefault(); // Prevent default action if this button triggers one
            generateXLSX('xlsx'); // Call the export function
            //exportTableToText('forDownLoadExcelTable'); // Call the export function
        });

        function readTableData(tableId) {
            const table = document.getElementById(tableId); // Use tableId passed as argument
            const rows = table.getElementsByTagName('tr');
            const data = [];

            // Read headings (assuming headings are in the first row <th> elements)
            const headings = rows[0].getElementsByTagName('th');
            const headerData = [];
            for (let i = 0; i < headings.length; i++) {
                headerData.push(headings[i].textContent.trim()); // Trim spaces from header text
            }
            data.push(headerData); // Add headings as the first row

            // Read table rows
            for (let i = 1; i < rows.length; i++) {
                const cells = rows[i].getElementsByTagName('td');
                const rowData = [];
                for (let j = 0; j < cells.length; j++) {
                    rowData.push(cells[j].textContent.trim()); // Trim spaces from cell text
                }
                data.push(rowData);
            }

            return data;
        }
        // function readTableData(tableId) {
        //     const table = document.getElementById(tableId); // Use tableId passed as argument
        //     const rows = table.getElementsByTagName('tr');
        //     const data = [];

        //     // Read headings (assuming headings are in the first row <th> elements)
        //     const headings = rows[0].getElementsByTagName('th');
        //     const headerData = [];
        //     for (let i = 0; i < headings.length; i++) {
        //         headerData.push(headings[i].textContent);
        //     }
        //     data.push(headerData); // Add headings as the first row

        //     // Read table rows
        //     for (let i = 1; i < rows.length; i++) {
        //         const cells = rows[i].getElementsByTagName('td');
        //         const rowData = [];
        //         for (let j = 0; j < cells.length; j++) {
        //             rowData.push(cells[j].textContent);
        //         }
        //         data.push(rowData);
        //     }

        //     return data;
        // }

        function generateXLSX(fileFormat = 'xlsx') {
            const fileName1 = `pos_opening_balance_${new Date().toISOString().replace(/[:.]/g, '-')}`.toLowerCase();

            const tableData = readTableData('forDownLoadExcelTable'); // Pass tableId here
            const ws = XLSX.utils.aoa_to_sheet(tableData);
            const wb = XLSX.utils.book_new();

            XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');

            let extension;
            switch (fileFormat.toLowerCase()) {
                case 'xls':
                    extension = '.xls';
                    break;
                case 'csv':
                    extension = '.csv';
                    break;
                case 'xlsx':
                default:
                    extension = '.xlsx';
                    break;
            }

            // Generate the file name with the specified extension
            const fileName = `${fileName1}${extension}`;

            // Save the file based on the format
            if (fileFormat === 'csv') {
                XLSX.writeFile(wb, fileName, {
                    bookType: 'csv'
                });
            } else if (fileFormat === 'xls') {
                XLSX.writeFile(wb, fileName, {
                    bookType: 'xls'
                });
            } else {
                XLSX.writeFile(wb, fileName, {
                    bookType: 'xlsx'
                });
            }
        }

        $("#printIcon").click(function() {

            var printContents = document.getElementById("stockReportPdf").innerHTML;
            var printStyle =
                '<style>@page {size: auto;margin: 0mm;margin-top:20px;margin-bottom:20px;margin-right:10px;} @media print  { .table thead tr th {white-space: normal;} #stockReportPdf {width: 100%;height: auto;overflow: visible;} }</style>';
            var printDiv =
                '<div id="order-details-wrapper" style="margin-top:25px;padding-left:10px;padding-right:10px;">' +
                printStyle + printContents + '</div>';

            document.body.innerHTML = printDiv;

            var originalContents = document.body.innerHTML;
            window.print();
            document.body.innerHTML = originalContents;
            // location.reload();

        });
    </script>
@endsection