@extends('layouts.app', ['stock_report' => true])

@section('title', __('Stock Report '))

@section('content')

    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1>{{ __('report.stock_report') }}</h1>
    </section>

    <!-- Main content -->
    <section class="content">
        <div class="row">
            <div class="col-md-12">
                @component('components.filters', ['title' => __('report.filters')])
                    {!! Form::open([
                        'url' => action('ReportController@getStockReport'),
                        'method' => 'get',
                        'id' => 'stock_report_filter_form',
                    ]) !!}
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('location_id', __('purchase.business_location') . ':') !!}
                            {!! Form::select('location_id', $business_locations, 1, [
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('category_id', __('category.category') . ':') !!}
                            {!! Form::select('category', $categories, null, [
                                'placeholder' => __('messages.all'),
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                                'id' => 'category_id',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('sub_category_id', __('product.sub_category') . ':') !!}
                            {!! Form::select('sub_category', [], null, [
                                'placeholder' => __('messages.all'),
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                                'id' => 'sub_category_id',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('brand', __('product.brand') . ':') !!}
                            {!! Form::select('brand', $brands, null, [
                                'placeholder' => __('messages.all'),
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('active_state', 'Active Status:') !!}
                            <select class="form-control select2" name="" id="active_state">
                                <option value="">All</option>
                                <option value="active" selected>Active</option>
                                <option value="inactive">Inactive</option>
                            </select>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('unit', __('product.unit') . ':') !!}
                            {!! Form::select('unit', $units, null, [
                                'placeholder' => __('messages.all'),
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Product Search</label>
                            <div class="input-group input-group-sm">
                                <input id="product_list_filter_product_search" name="product_list_filter_product_search"
                                    value="" type="text" class="form-control">
                                <span class="input-group-btn">
                                    <button id="product_search_button" type="button" class="btn btn-info btn-flat"><i
                                            class="fa fa-search"></i></button>
                                </span>
                            </div>
                            <!-- /input-group -->
                        </div>
                    </div>
                    @if ($show_manufacturing_data)
                        <div class="col-md-3">
                            <div class="form-group">
                                <br>
                                <div class="checkbox">
                                    <label>
                                        {!! Form::checkbox('only_mfg', 1, false, ['class' => 'input-icheck', 'id' => 'only_mfg_products']) !!} {{ __('manufacturing::lang.only_mfg_products') }}
                                    </label>
                                </div>
                            </div>
                        </div>
                    @endif
                    {!! Form::close() !!}
                @endcomponent
            </div>
        </div>
        @can('view_product_stock_value')
            <div class="row">
                <div class="col-md-12">
                    @component('components.widget', ['class' => 'box-solid'])
                        <table class="table no-border">
                            <tr>
                                <td>@lang('report.closing_stock') (@lang('lang_v1.by_purchase_price'))</td>
                                <td>@lang('report.closing_stock') (@lang('lang_v1.by_sale_price'))</td>
                                <td>@lang('lang_v1.potential_profit')</td>
                                <td>@lang('lang_v1.profit_margin')</td>
                            </tr>
                            <tr>
                                <td>
                                    {{-- <h3 id="closing_stock_by_pp" class="mb-0 mt-0"></h3> --}}
                                    <h3 id="closing_stock_by_pp_new" class="mb-0 mt-0"></h3>
                                </td>
                                <td>
                                    {{-- <h3 id="closing_stock_by_sp" class="mb-0 mt-0"></h3> --}}
                                    <h3 id="closing_stock_by_sp_new" class="mb-0 mt-0"></h3>
                                </td>
                                <td>
                                    {{-- <h3 id="potential_profit" class="mb-0 mt-0"></h3> --}}
                                    <h3 id="potential_profit_new" class="mb-0 mt-0"></h3>
                                </td>
                                <td>
                                    {{-- <h3 id="profit_margin" class="mb-0 mt-0"></h3> --}}
                                    <h3 id="profit_margin_new" class="mb-0 mt-0"></h3>
                                </td>
                            </tr>
                        </table>
                    @endcomponent
                </div>
            </div>
        @endcan
        <div class="row">
            <div class="col-md-12">
                @component('components.widget', ['class' => 'box-solid'])
                    @include('report.partials.stock_report_table')
                @endcomponent
            </div>
        </div>
    </section>
    <!-- /.content -->

@endsection

@section('javascript')
    {{-- <script src="{{ asset('js/report.js?v=' . $asset_v) }}"></script> --}}
    <script type="text/javascript">
        $(document).ready(function() {
            //Purchase & Sell report
            //Date range as a button
            if ($('#purchase_sell_date_filter').length == 1) {
                dateRangeSettings.startDate = moment().startOf('year');
                dateRangeSettings.endDate = moment().endOf('year');
                $('#purchase_sell_date_filter').daterangepicker(dateRangeSettings, function(start, end) {
                    $('#purchase_sell_date_filter span').html(
                        start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                    );
                    updatePurchaseSell();
                });
                $('#purchase_sell_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                    $('#purchase_sell_date_filter').html(
                        '<i class="fa fa-calendar"></i> ' + LANG.filter_by_date
                    );
                });
                updatePurchaseSell();
            }

            if ($('#scr_date_filter').length == 1) {
                dateRangeSettings.startDate = moment().startOf('year');
                dateRangeSettings.endDate = moment().endOf('year');
                $('#scr_date_filter').daterangepicker(dateRangeSettings, function(start, end) {
                    $('#scr_date_filter').val(
                        start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                    );
                    supplier_report_tbl.ajax.reload();
                });
                $('#scr_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                    $('#scr_date_filter').val('');
                    supplier_report_tbl.ajax.reload();
                });
            }

            //contact report
            supplier_report_tbl = $('#supplier_report_tbl').DataTable({
                processing: true,
                serverSide: true,

                ajax: {
                    url: '/reports/customer-supplier',
                    data: function(d) {
                        d.customer_group_id = $('#cnt_customer_group_id').val();
                        d.contact_type = $('#contact_type').val();
                        d.location_id = $('#cs_report_location_id').val();
                        var start = $('input#scr_date_filter')
                            .data('daterangepicker')
                            .startDate.format('YYYY-MM-DD');
                        var end = $('input#scr_date_filter')
                            .data('daterangepicker')
                            .endDate.format('YYYY-MM-DD');
                        d.start_date = start;
                        d.end_date = end;
                        d.contact_id = $('#scr_contact_id').val();
                    }
                },
                columnDefs: [{
                        targets: [5],
                        orderable: false,
                        searchable: false
                    },
                    {
                        targets: [1, 2, 3, 4],
                        searchable: false
                    },
                ],
                columns: [{
                        data: 'name',
                        name: 'name'
                    },
                    {
                        data: 'total_purchase',
                        name: 'total_purchase'
                    },
                    {
                        data: 'total_purchase_return',
                        name: 'total_purchase_return'
                    },
                    {
                        data: 'total_invoice',
                        name: 'total_invoice'
                    },
                    {
                        data: 'total_sell_return',
                        name: 'total_sell_return'
                    },
                    {
                        data: 'opening_balance_due',
                        name: 'opening_balance_due'
                    },
                    {
                        data: 'due',
                        name: 'due'
                    },
                ],
                fnDrawCallback: function(oSettings) {
                    var total_purchase = sum_table_col($('#supplier_report_tbl'), 'total_purchase');
                    $('#footer_total_purchase').text(total_purchase);

                    var total_purchase_return = sum_table_col(
                        $('#supplier_report_tbl'),
                        'total_purchase_return'
                    );
                    $('#footer_total_purchase_return').text(total_purchase_return);

                    var total_sell = sum_table_col($('#supplier_report_tbl'), 'total_invoice');
                    $('#footer_total_sell').text(total_sell);

                    var total_sell_return = sum_table_col($('#supplier_report_tbl'),
                        'total_sell_return');
                    $('#footer_total_sell_return').text(total_sell_return);

                    var total_opening_bal_due = sum_table_col(
                        $('#supplier_report_tbl'),
                        'opening_balance_due'
                    );
                    $('#footer_total_opening_bal_due').text(total_opening_bal_due);

                    var total_due = sum_table_col($('#supplier_report_tbl'), 'total_due');
                    $('#footer_total_due').text(total_due);

                    __currency_convert_recursively($('#supplier_report_tbl'));
                },
            });

            if ($('#supplier_report_tbl').length != 0) {
                $('#cnt_customer_group_id, #contact_type, #cs_report_location_id, #scr_contact_id').change(
                    function() {
                        supplier_report_tbl.ajax.reload();
                    });
            }

            var stock_report_cols = [{
                    data: 'sku',
                    name: 'variations.sub_sku'
                },
                {
                    data: 'product',
                    name: 'p.name'
                },
                // {
                //     data: 'variation',
                //     name: 'variation'
                // },
                {
                    data: 'category_name',
                    name: 'c.name'
                },
                {
                    data: 'location_name',
                    name: 'l.name'
                },
                {
                    data: 'unit_price',
                    name: 'variations.sell_price_inc_tax'
                },
                {
                    data: 'stock',
                    name: 'stock',
                    searchable: false
                },
            ];
            if ($('th.stock_price').length) {
                stock_report_cols.push({
                    data: 'stock_price',
                    name: 'stock_price',
                    searchable: false
                });
                stock_report_cols.push({
                    data: 'stock_value_by_sale_price',
                    name: 'stock_value_by_sale_price',
                    searchable: false,
                    orderable: false
                });
                stock_report_cols.push({
                    data: 'potential_profit',
                    name: 'potential_profit',
                    searchable: false,
                    orderable: false
                });
            }

            stock_report_cols.push({
                data: 'total_sold',
                name: 'total_sold',
                searchable: false
            });
            stock_report_cols.push({
                data: 'total_transfered',
                name: 'total_transfered',
                searchable: false
            });
            stock_report_cols.push({
                data: 'total_adjusted',
                name: 'total_adjusted',
                searchable: false
            });
            // stock_report_cols.push({
            //     data: 'product_custom_field1',
            //     name: 'p.product_custom_field1'
            // });
            // stock_report_cols.push({
            //     data: 'product_custom_field2',
            //     name: 'p.product_custom_field2'
            // });
            // stock_report_cols.push({
            //     data: 'product_custom_field3',
            //     name: 'p.product_custom_field3'
            // });
            // stock_report_cols.push({
            //     data: 'product_custom_field4',
            //     name: 'p.product_custom_field4'
            // });

            if ($('th.current_stock_mfg').length) {
                stock_report_cols.push({
                    data: 'total_mfg_stock',
                    name: 'total_mfg_stock',
                    searchable: false
                });
            }
            //Stock report table
            stock_report_table = $('#stock_report_table').DataTable({
                processing: true,
                serverSide: true,
                scrollY: "75vh",
                scrollX: true,
                scrollCollapse: true,
                ajax: {
                    url: '/reports/stock-report',
                    data: function(d) {
                        d.location_id = $('#location_id').val();
                        d.category_id = $('#category_id').val();
                        d.sub_category_id = $('#sub_category_id').val();
                        d.brand_id = $('#brand').val();
                        d.active_state = $('#active_state').val();
                        d.unit_id = $('#unit').val();
                        d.product_search_keyword = $('#product_list_filter_product_search').val();
                        d.only_mfg_products = $('#only_mfg_products').length && $('#only_mfg_products')
                            .is(':checked') ? 1 : 0;
                    },
                },
                columns: stock_report_cols,
                fnDrawCallback: function(oSettings) {
                    __currency_convert_recursively($('#stock_report_table'));
                },
                "footerCallback": function(row, data, start, end, display) {
                    var footer_total_stock = 0;
                    var footer_total_sold = 0;
                    var footer_total_transfered = 0;
                    var total_adjusted = 0;
                    var total_stock_price = 0;
                    var footer_stock_value_by_sale_price = 0;
                    var total_potential_profit = 0;
                    var footer_total_mfg_stock = 0;
                    for (var r in data) {
                        footer_total_stock += $(data[r].stock).data('orig-value') ?
                            parseFloat($(data[r].stock).data('orig-value')) : 0;

                        footer_total_sold += $(data[r].total_sold).data('orig-value') ?
                            parseFloat($(data[r].total_sold).data('orig-value')) : 0;

                        footer_total_transfered += $(data[r].total_transfered).data('orig-value') ?
                            parseFloat($(data[r].total_transfered).data('orig-value')) : 0;

                        total_adjusted += $(data[r].total_adjusted).data('orig-value') ?
                            parseFloat($(data[r].total_adjusted).data('orig-value')) : 0;

                        total_stock_price += $(data[r].stock_price).data('orig-value') ?
                            parseFloat($(data[r].stock_price).data('orig-value')) : 0;

                        footer_stock_value_by_sale_price += $(data[r].stock_value_by_sale_price).data(
                                'orig-value') ?
                            parseFloat($(data[r].stock_value_by_sale_price).data('orig-value')) : 0;

                        total_potential_profit += $(data[r].potential_profit).data('orig-value') ?
                            parseFloat($(data[r].potential_profit).data('orig-value')) : 0;

                        footer_total_mfg_stock += $(data[r].total_mfg_stock).data('orig-value') ?
                            parseFloat($(data[r].total_mfg_stock).data('orig-value')) : 0;
                    }

                    document.getElementById("closing_stock_by_pp_new").innerHTML =
                        __currency_trans_from_en(total_stock_price, false);
                    document.getElementById("closing_stock_by_sp_new").innerHTML =
                        __currency_trans_from_en(footer_stock_value_by_sale_price, false);
                    document.getElementById("potential_profit_new").innerHTML =
                        __currency_trans_from_en(total_potential_profit, false);
                    var total_margin = (footer_stock_value_by_sale_price &&
                            footer_stock_value_by_sale_price !== 0) ?
                        (total_potential_profit / footer_stock_value_by_sale_price) * 100 :
                        0;
                    document.getElementById("profit_margin_new").innerHTML =
                        __currency_trans_from_en(total_margin, false);

                    $('.footer_total_stock').html(__currency_trans_from_en(footer_total_stock, false));
                    $('.footer_total_stock_price').html(__currency_trans_from_en(total_stock_price));
                    $('.footer_total_sold').html(__currency_trans_from_en(footer_total_sold, false));
                    $('.footer_total_transfered').html(__currency_trans_from_en(footer_total_transfered,
                        false));
                    $('.footer_total_adjusted').html(__currency_trans_from_en(total_adjusted, false));
                    $('.footer_stock_value_by_sale_price').html(__currency_trans_from_en(
                        footer_stock_value_by_sale_price));
                    $('.footer_potential_profit').html(__currency_trans_from_en(
                        total_potential_profit));
                    if ($('th.current_stock_mfg').length) {
                        $('.footer_total_mfg_stock').html(__currency_trans_from_en(
                            footer_total_mfg_stock, false));
                    }
                },
            });

            if ($('#trending_product_date_range').length == 1) {
                get_sub_categories();
                $('#trending_product_date_range').daterangepicker({
                    ranges: ranges,
                    autoUpdateInput: false,
                    locale: {
                        format: moment_date_format,
                        cancelLabel: LANG.clear,
                        applyLabel: LANG.apply,
                        customRangeLabel: LANG.custom_range,
                    },
                });
                $('#trending_product_date_range').on('apply.daterangepicker', function(ev, picker) {
                    $(this).val(
                        picker.startDate.format(moment_date_format) +
                        ' ~ ' +
                        picker.endDate.format(moment_date_format)
                    );
                });

                $('#trending_product_date_range').on('cancel.daterangepicker', function(ev, picker) {
                    $(this).val('');
                });
            }

            $('#stock_report_filter_form #location_id, #stock_report_filter_form #category_id, #stock_report_filter_form #sub_category_id, #active_state, #stock_report_filter_form #brand, #stock_report_filter_form #unit,#stock_report_filter_form #view_stock_filter')
                .change(function() {
                    stock_report_table.ajax.reload();
                    stock_expiry_report_table.ajax.reload();
                    get_stock_value();
                });

            // search filter
            $(document).on('click', '#product_search_button', function() {
                stock_report_table.ajax.reload();
            });

            $('#only_mfg_products').on('ifChanged', function(event) {
                stock_report_table.ajax.reload();
                lot_report.ajax.reload();
                stock_expiry_report_table.ajax.reload();
                items_report_table.ajax.reload();
            });

            $('#purchase_sell_location_filter').change(function() {
                updatePurchaseSell();
            });

            //Stock Adjustment Report
            if ($('#stock_adjustment_date_filter').length == 1) {
                dateRangeSettings.startDate = moment().startOf('year');
                dateRangeSettings.endDate = moment().endOf('year');
                $('#stock_adjustment_date_filter').daterangepicker(dateRangeSettings, function(start, end) {
                    $('#stock_adjustment_date_filter span').html(
                        start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                    );
                    updateStockAdjustmentReport();
                });
                $('#purchase_sell_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                    $('#purchase_sell_date_filter').html(
                        '<i class="fa fa-calendar"></i> ' + LANG.filter_by_date
                    );
                });
                updateStockAdjustmentReport();
            }

            $('#stock_adjustment_location_filter').change(function() {
                updateStockAdjustmentReport();
            });

            if ($('#register_report_date_range').length == 1) {
                $('#register_report_date_range').daterangepicker({
                    ranges: ranges,
                    autoUpdateInput: false,
                    locale: {
                        format: moment_date_format,
                        cancelLabel: LANG.clear,
                        applyLabel: LANG.apply,
                        customRangeLabel: LANG.custom_range,
                    },
                });
                $('#register_report_date_range').on('apply.daterangepicker', function(ev, picker) {
                    $(this).val(
                        picker.startDate.format(moment_date_format) +
                        ' ~ ' +
                        picker.endDate.format(moment_date_format)
                    );
                    updateRegisterReport();
                });

                $('#register_report_date_range').on('cancel.daterangepicker', function(ev, picker) {
                    $(this).val('');
                    updateRegisterReport();
                });
            }

            //Register report
            register_report_table = $('#register_report_table').DataTable({
                processing: true,
                serverSide: true,
                scrollY: "75vh",
                scrollX: true,
                scrollCollapse: true,
                ajax: '/reports/register-report',
                columns: [{
                        data: 'created_at',
                        name: 'created_at'
                    },
                    {
                        data: 'closed_at',
                        name: 'closed_at'
                    },
                    {
                        data: 'location_name',
                        name: 'bl.name'
                    },
                    {
                        data: 'user_name',
                        name: 'user_name'
                    },
                    {
                        data: 'total_card_payment',
                        name: 'total_card_payment',
                        searchable: false
                    },
                    {
                        data: 'total_cheque_payment',
                        name: 'total_cheque_payment',
                        searchable: false
                    },
                    {
                        data: 'total_cash_payment',
                        name: 'total_cash_payment',
                        searchable: false
                    },
                    {
                        data: 'total_bank_transfer_payment',
                        name: 'total_bank_transfer_payment',
                        searchable: false
                    },
                    {
                        data: 'total_advance_payment',
                        name: 'total_advance_payment',
                        searchable: false
                    },
                    {
                        data: 'total_custom_pay_1',
                        name: 'total_custom_pay_1',
                        searchable: false
                    },
                    {
                        data: 'total_custom_pay_2',
                        name: 'total_custom_pay_2',
                        searchable: false
                    },
                    {
                        data: 'total_custom_pay_3',
                        name: 'total_custom_pay_3',
                        searchable: false
                    },
                    {
                        data: 'total_custom_pay_4',
                        name: 'total_custom_pay_4',
                        searchable: false
                    },
                    {
                        data: 'total_custom_pay_5',
                        name: 'total_custom_pay_5',
                        searchable: false
                    },
                    {
                        data: 'total_custom_pay_6',
                        name: 'total_custom_pay_6',
                        searchable: false
                    },
                    {
                        data: 'total_custom_pay_7',
                        name: 'total_custom_pay_7',
                        searchable: false
                    },
                    {
                        data: 'total_other_payment',
                        name: 'total_other_payment',
                        searchable: false
                    },
                    {
                        data: 'total',
                        name: 'total',
                        orderable: false,
                        searchable: false
                    },
                    {
                        data: 'action',
                        name: 'action',
                        orderable: false,
                        searchable: false
                    },
                ],
                "footerCallback": function(row, data, start, end, display) {
                    var total_card_payment = 0;
                    var total_cheque_payment = 0;
                    var total_cash_payment = 0;
                    var total_bank_transfer_payment = 0;
                    var total_other_payment = 0;
                    var total_advance_payment = 0;
                    var total_custom_pay_1 = 0;
                    var total_custom_pay_2 = 0;
                    var total_custom_pay_3 = 0;
                    var total_custom_pay_4 = 0;
                    var total_custom_pay_5 = 0;
                    var total_custom_pay_6 = 0;
                    var total_custom_pay_7 = 0;
                    var total = 0;
                    for (var r in data) {
                        total_card_payment += $(data[r].total_card_payment).data('orig-value') ?
                            parseFloat($(data[r].total_card_payment).data('orig-value')) : 0;

                        total_cheque_payment += $(data[r].total_cheque_payment).data('orig-value') ?
                            parseFloat($(data[r].total_cheque_payment).data('orig-value')) : 0;

                        total_cash_payment += $(data[r].total_cash_payment).data('orig-value') ?
                            parseFloat($(data[r].total_cash_payment).data('orig-value')) : 0;

                        total_bank_transfer_payment += $(data[r].total_bank_transfer_payment).data(
                                'orig-value') ?
                            parseFloat($(data[r].total_bank_transfer_payment).data('orig-value')) : 0;

                        total_other_payment += $(data[r].total_other_payment).data('orig-value') ?
                            parseFloat($(data[r].total_other_payment).data('orig-value')) : 0;

                        total_advance_payment += $(data[r].total_advance_payment).data('orig-value') ?
                            parseFloat($(data[r].total_advance_payment).data('orig-value')) : 0;

                        total_custom_pay_1 += $(data[r].total_custom_pay_1).data('orig-value') ?
                            parseFloat($(data[r].total_custom_pay_1).data('orig-value')) : 0;

                        total_custom_pay_2 += $(data[r].total_custom_pay_2).data('orig-value') ?
                            parseFloat($(data[r].total_custom_pay_2).data('orig-value')) : 0;

                        total_custom_pay_3 += $(data[r].total_custom_pay_3).data('orig-value') ?
                            parseFloat($(data[r].total_custom_pay_3).data('orig-value')) : 0;

                        total_custom_pay_4 += $(data[r].total_custom_pay_4).data('orig-value') ?
                            parseFloat($(data[r].total_custom_pay_4).data('orig-value')) : 0;

                        total_custom_pay_5 += $(data[r].total_custom_pay_5).data('orig-value') ?
                            parseFloat($(data[r].total_custom_pay_5).data('orig-value')) : 0;

                        total_custom_pay_6 += $(data[r].total_custom_pay_6).data('orig-value') ?
                            parseFloat($(data[r].total_custom_pay_6).data('orig-value')) : 0;

                        total_custom_pay_7 += $(data[r].total_custom_pay_7).data('orig-value') ?
                            parseFloat($(data[r].total_custom_pay_7).data('orig-value')) : 0;

                        total += $(data[r].total).data('orig-value') ?
                            parseFloat($(data[r].total).data('orig-value')) : 0;
                    }

                    $('.footer_total_card_payment').html(__currency_trans_from_en(total_card_payment));
                    $('.footer_total_cheque_payment').html(__currency_trans_from_en(
                        total_cheque_payment));
                    $('.footer_total_cash_payment').html(__currency_trans_from_en(total_cash_payment));
                    $('.footer_total_bank_transfer_payment').html(__currency_trans_from_en(
                        total_bank_transfer_payment));
                    $('.footer_total_other_payments').html(__currency_trans_from_en(
                        total_other_payment));
                    $('.footer_total_advance_payment').html(__currency_trans_from_en(
                        total_advance_payment));
                    $('.footer_total_custom_pay_1').html(__currency_trans_from_en(total_custom_pay_1));
                    $('.footer_total_custom_pay_2').html(__currency_trans_from_en(total_custom_pay_2));
                    $('.footer_total_custom_pay_3').html(__currency_trans_from_en(total_custom_pay_3));
                    $('.footer_total_custom_pay_4').html(__currency_trans_from_en(total_custom_pay_4));
                    $('.footer_total_custom_pay_5').html(__currency_trans_from_en(total_custom_pay_5));
                    $('.footer_total_custom_pay_6').html(__currency_trans_from_en(total_custom_pay_6));
                    $('.footer_total_custom_pay_7').html(__currency_trans_from_en(total_custom_pay_7));
                    $('.footer_total').html(__currency_trans_from_en(total));
                },
            });
            $('.view_register').on('shown.bs.modal', function() {
                __currency_convert_recursively($(this));
            });
            $(document).on('submit', '#register_report_filter_form', function(e) {
                e.preventDefault();
                updateRegisterReport();
            });

            $('#register_user_id, #register_status').change(function() {
                updateRegisterReport();
            });

            //Sales representative report
            if ($('#sr_date_filter').length == 1) {
                //date range setting
                dateRangeSettings.startDate = moment().startOf('year');
                dateRangeSettings.endDate = moment().endOf('year');
                $('input#sr_date_filter').daterangepicker(dateRangeSettings, function(start, end) {
                    $('input#sr_date_filter').val(
                        start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                    );
                    updateSalesRepresentativeReport();
                });
                $('input#sr_date_filter').on('apply.daterangepicker', function(ev, picker) {
                    $(this).val(
                        picker.startDate.format(moment_date_format) +
                        ' ~ ' +
                        picker.endDate.format(moment_date_format)
                    );
                });

                $('input#sr_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                    $(this).val('');
                });

                //Sales representative report -> Total expense
                if ($('span#sr_total_expenses').length > 0) {
                    salesRepresentativeTotalExpense();
                }
                //Sales representative report -> Total sales
                if ($('span#sr_total_sales').length > 0) {
                    salesRepresentativeTotalSales();
                }

                if ($('#sr_payments_with_commission_table').length > 0) {
                    sr_payments_with_commission_report =
                        $('table#sr_payments_with_commission_table').DataTable({
                            processing: true,
                            serverSide: true,
                            aaSorting: [
                                [1, 'desc']
                            ],
                            ajax: {
                                url: '/reports/sell-payment-report',
                                data: function(d) {

                                    var start = $('input#sr_date_filter')
                                        .data('daterangepicker')
                                        .startDate.format('YYYY-MM-DD');
                                    var end = $('input#sr_date_filter')
                                        .data('daterangepicker')
                                        .endDate.format('YYYY-MM-DD');
                                    var commission_agent = $('select#sr_id').val();
                                    d.commission_agent = commission_agent != '' ? $('select#sr_id').val() :
                                        0;
                                    d.location_id = $('select#sr_business_id').val();
                                    d.start_date = start;
                                    d.end_date = end;
                                },
                            },
                            columns: [{
                                    data: 'payment_ref_no',
                                    name: 'payment_ref_no'
                                },
                                {
                                    data: 'paid_on',
                                    name: 'paid_on'
                                },
                                {
                                    data: 'amount',
                                    name: 'transaction_payments.amount'
                                },
                                {
                                    data: 'customer',
                                    orderable: false,
                                    searchable: false
                                },
                                {
                                    data: 'method',
                                    name: 'method'
                                },
                                {
                                    data: 'invoice_no',
                                    name: 't.invoice_no'
                                },
                                {
                                    data: 'action',
                                    orderable: false,
                                    searchable: false
                                },
                            ],
                            fnDrawCallback: function(oSettings) {
                                var total_amount = sum_table_col($('#sr_payments_with_commission_table'),
                                    'paid-amount');
                                $('#footer_total_amount').text(total_amount);
                                __currency_convert_recursively($('#sr_payments_with_commission_table'));
                            }
                        });
                }

                //Sales representative report -> Sales
                sr_sales_report = $('table#sr_sales_report').DataTable({
                    processing: true,
                    serverSide: true,
                    aaSorting: [
                        [0, 'desc']
                    ],
                    ajax: {
                        url: '/sells',
                        data: function(d) {
                            var start = $('input#sr_date_filter')
                                .data('daterangepicker')
                                .startDate.format('YYYY-MM-DD');
                            var end = $('input#sr_date_filter')
                                .data('daterangepicker')
                                .endDate.format('YYYY-MM-DD');

                            (d.created_by = $('select#sr_id').val()),
                            (d.location_id = $('select#sr_business_id').val()),
                            (d.start_date = start),
                            (d.end_date = end);
                        },
                    },
                    columns: [{
                            data: 'transaction_date',
                            name: 'transaction_date'
                        },
                        {
                            data: 'invoice_no',
                            name: 'invoice_no'
                        },
                        {
                            data: 'conatct_name',
                            name: 'conatct_name'
                        },
                        {
                            data: 'business_location',
                            name: 'bl.name'
                        },
                        {
                            data: 'payment_status',
                            name: 'payment_status'
                        },
                        {
                            data: 'final_total',
                            name: 'final_total'
                        },
                        {
                            data: 'total_paid',
                            name: 'total_paid'
                        },
                        {
                            data: 'total_remaining',
                            name: 'total_remaining'
                        },
                    ],
                    columnDefs: [{
                        searchable: false,
                        targets: [6],
                    }, ],
                    fnDrawCallback: function(oSettings) {
                        $('#sr_footer_sale_total').text(
                            sum_table_col($('#sr_sales_report'), 'final-total')
                        );

                        $('#sr_footer_total_paid').text(sum_table_col($('#sr_sales_report'),
                            'total-paid'));

                        $('#sr_footer_total_remaining').text(
                            sum_table_col($('#sr_sales_report'), 'payment_due')
                        );
                        $('#sr_footer_total_sell_return_due').text(
                            sum_table_col($('#sr_sales_report'), 'sell_return_due')
                        );

                        $('#sr_footer_payment_status_count ').html(
                            __sum_status_html($('#sr_sales_report'), 'payment-status-label')
                        );
                        __currency_convert_recursively($('#sr_sales_report'));
                    },
                });

                //Sales representative report -> Expenses
                sr_expenses_report = $('table#sr_expenses_report').DataTable({
                    processing: true,
                    serverSide: true,
                    aaSorting: [
                        [0, 'desc']
                    ],
                    ajax: {
                        url: '/expenses',
                        data: function(d) {
                            var start = $('input#sr_date_filter')
                                .data('daterangepicker')
                                .startDate.format('YYYY-MM-DD');
                            var end = $('input#sr_date_filter')
                                .data('daterangepicker')
                                .endDate.format('YYYY-MM-DD');

                            (d.expense_for = $('select#sr_id').val()),
                            (d.location_id = $('select#sr_business_id').val()),
                            (d.start_date = start),
                            (d.end_date = end);
                        },
                    },
                    columnDefs: [{
                        targets: 7,
                        orderable: false,
                        searchable: false,
                    }, ],
                    columns: [{
                            data: 'transaction_date',
                            name: 'transaction_date'
                        },
                        {
                            data: 'ref_no',
                            name: 'ref_no'
                        },
                        {
                            data: 'category',
                            name: 'ec.name'
                        },
                        {
                            data: 'location_name',
                            name: 'bl.name'
                        },
                        {
                            data: 'payment_status',
                            name: 'payment_status'
                        },
                        {
                            data: 'final_total',
                            name: 'final_total'
                        },
                        {
                            data: 'expense_for',
                            name: 'expense_for'
                        },
                        {
                            data: 'additional_notes',
                            name: 'additional_notes'
                        },
                    ],
                    fnDrawCallback: function(oSettings) {
                        var expense_total = sum_table_col($('#sr_expenses_report'), 'final-total');
                        $('#footer_expense_total').text(expense_total);
                        $('#er_footer_payment_status_count').html(
                            __sum_status_html($('#sr_expenses_report'), 'payment-status')
                        );
                        __currency_convert_recursively($('#sr_expenses_report'));
                    },
                });

                //Sales representative report -> Sales with commission
                sr_sales_commission_report = $('table#sr_sales_with_commission_table').DataTable({
                    processing: true,
                    serverSide: true,
                    aaSorting: [
                        [0, 'desc']
                    ],
                    ajax: {
                        url: '/sells',
                        data: function(d) {
                            var start = $('input#sr_date_filter')
                                .data('daterangepicker')
                                .startDate.format('YYYY-MM-DD');
                            var end = $('input#sr_date_filter')
                                .data('daterangepicker')
                                .endDate.format('YYYY-MM-DD');

                            (d.commission_agent = $('select#sr_id').val()),
                            (d.location_id = $('select#sr_business_id').val()),
                            (d.start_date = start),
                            (d.end_date = end);
                        },
                    },
                    columns: [{
                            data: 'transaction_date',
                            name: 'transaction_date'
                        },
                        {
                            data: 'invoice_no',
                            name: 'invoice_no'
                        },
                        {
                            data: 'conatct_name',
                            name: 'conatct_name'
                        },
                        {
                            data: 'business_location',
                            name: 'bl.name'
                        },
                        {
                            data: 'payment_status',
                            name: 'payment_status'
                        },
                        {
                            data: 'final_total',
                            name: 'final_total'
                        },
                        {
                            data: 'total_paid',
                            name: 'total_paid'
                        },
                        {
                            data: 'total_remaining',
                            name: 'total_remaining'
                        },
                    ],
                    columnDefs: [{
                        searchable: false,
                        targets: [6],
                    }, ],
                    fnDrawCallback: function(oSettings) {
                        $('#footer_sale_total').text(
                            sum_table_col($('#sr_sales_with_commission_table'), 'final-total')
                        );

                        $('#footer_total_paid').text(
                            sum_table_col($('#sr_sales_with_commission_table'), 'total-paid')
                        );

                        $('#footer_total_remaining').text(
                            sum_table_col($('#sr_sales_with_commission_table'), 'payment_due')
                        );
                        $('#footer_total_sell_return_due').text(
                            sum_table_col($('#sr_sales_with_commission_table'), 'sell_return_due')
                        );

                        $('#footer_payment_status_count ').html(
                            __sum_status_html($('#sr_sales_with_commission_table'),
                                'payment-status-label')
                        );
                        __currency_convert_recursively($('#sr_sales_with_commission_table'));
                        __currency_convert_recursively($('#sr_sales_with_commission'));
                    },
                });

                //Sales representive filter
                $('select#sr_id, select#sr_business_id').change(function() {
                    updateSalesRepresentativeReport();
                });
            }

            //Stock expiry report table
            stock_expiry_report_table = $('table#stock_expiry_report_table').DataTable({
                processing: true,
                serverSide: true,
                ajax: {
                    url: '/reports/stock-expiry',
                    data: function(d) {
                        d.location_id = $('#location_id').val();
                        d.category_id = $('#category_id').val();
                        d.sub_category_id = $('#sub_category_id').val();
                        d.brand_id = $('#brand').val();
                        d.unit_id = $('#unit').val();
                        d.exp_date_filter = $('#view_stock_filter').val();
                        d.only_mfg_products = $('#only_mfg_products').length && $('#only_mfg_products')
                            .is(':checked') ? 1 : 0;
                    },
                },
                order: [
                    [4, 'asc']
                ],
                columns: [{
                        data: 'product',
                        name: 'p.name'
                    },
                    {
                        data: 'sku',
                        name: 'p.sku'
                    },
                    // { data: 'ref_no', name: 't.ref_no' },
                    {
                        data: 'location',
                        name: 'l.name'
                    },
                    {
                        data: 'stock_left',
                        name: 'stock_left',
                        searchable: false
                    },
                    {
                        data: 'lot_number',
                        name: 'lot_number'
                    },
                    {
                        data: 'exp_date',
                        name: 'exp_date'
                    },
                    {
                        data: 'mfg_date',
                        name: 'mfg_date'
                    },
                    // { data: 'edit', name: 'edit' },
                ],
                fnDrawCallback: function(oSettings) {
                    __show_date_diff_for_human($('#stock_expiry_report_table'));
                    $('button.stock_expiry_edit_btn').click(function() {
                        var purchase_line_id = $(this).data('purchase_line_id');

                        $.ajax({
                            method: 'GET',
                            url: '/reports/stock-expiry-edit-modal/' + purchase_line_id,
                            dataType: 'html',
                            success: function(data) {
                                $('div.exp_update_modal')
                                    .html(data)
                                    .modal('show');
                                $('input#exp_date_expiry_modal').datepicker({
                                    autoclose: true,
                                    format: datepicker_date_format,
                                });

                                $('form#stock_exp_modal_form').submit(function(e) {
                                    e.preventDefault();

                                    $.ajax({
                                        method: 'POST',
                                        url: $(
                                                'form#stock_exp_modal_form'
                                            )
                                            .attr('action'),
                                        dataType: 'json',
                                        data: $(
                                                'form#stock_exp_modal_form'
                                            )
                                            .serialize(),
                                        success: function(data) {
                                            if (data.success ==
                                                1) {
                                                $('div.exp_update_modal')
                                                    .modal(
                                                        'hide');
                                                toastr.success(
                                                    data.msg
                                                );
                                                stock_expiry_report_table
                                                    .ajax
                                                    .reload();
                                            } else {
                                                toastr.error(
                                                    data.msg
                                                );
                                            }
                                        },
                                    });
                                });
                            },
                        });
                    });
                    $('#footer_total_stock_left').html(
                        __sum_stock($('#stock_expiry_report_table'), 'stock_left')
                    );
                    __currency_convert_recursively($('#stock_expiry_report_table'));
                },
            });

            //Profit / Loss
            if ($('#profit_loss_date_filter').length == 1) {
                dateRangeSettings.startDate = moment().startOf('year');
                dateRangeSettings.endDate = moment().endOf('year');
                $('#profit_loss_date_filter').daterangepicker(dateRangeSettings, function(start, end) {
                    $('#profit_loss_date_filter span').html(
                        start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                    );
                    updateProfitLoss();
                });
                $('#profit_loss_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                    $('#profit_loss_date_filter').html(
                        '<i class="fa fa-calendar"></i> ' + LANG.filter_by_date
                    );
                });
                updateProfitLoss();
            }
            $('#profit_loss_location_filter').change(function() {
                updateProfitLoss();
            });

            //Product Purchase Report
            if ($('#product_pr_date_filter').length == 1) {
                dateRangeSettings.startDate = moment().startOf('year');
                dateRangeSettings.endDate = moment().endOf('year');
                $('#product_pr_date_filter').daterangepicker(dateRangeSettings, function(start, end) {
                    $('#product_pr_date_filter').val(
                        start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                    );
                    product_purchase_report.ajax.reload();
                });
                $('#product_pr_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                    $('#product_pr_date_filter').val('');
                    product_purchase_report.ajax.reload();
                });
            }
            $(
                '#product_purchase_report_form #variation_id, \
                                                                        #product_purchase_report_form #location_id, \
                                                                        #product_purchase_report_form #supplier_id, \
                                                                        #product_purchase_report_form \
                                                                        #product_pr_date_filter, #ppr_brand_id'
            ).change(function() {
                product_purchase_report.ajax.reload();
            });
            product_purchase_report = $('table#product_purchase_report_table').DataTable({
                processing: true,
                serverSide: true,
                aaSorting: [
                    [3, 'desc']
                ],
                ajax: {
                    url: '/reports/product-purchase-report',
                    data: function(d) {
                        var start = '';
                        var end = '';
                        if ($('#product_pr_date_filter').val()) {
                            start = $('input#product_pr_date_filter')
                                .data('daterangepicker')
                                .startDate.format('YYYY-MM-DD');
                            end = $('input#product_pr_date_filter')
                                .data('daterangepicker')
                                .endDate.format('YYYY-MM-DD');
                        }
                        d.start_date = start;
                        d.end_date = end;
                        d.variation_id = $('#variation_id').val();
                        d.supplier_id = $('select#supplier_id').val();
                        d.location_id = $('select#location_id').val();
                        d.brand_id = $('select#ppr_brand_id').val();
                    },
                },
                columns: [{
                        data: 'product_name',
                        name: 'p.name'
                    },
                    {
                        data: 'sub_sku',
                        name: 'v.sub_sku'
                    },
                    {
                        data: 'supplier',
                        name: 'c.name'
                    },
                    {
                        data: 'ref_no',
                        name: 't.ref_no'
                    },
                    {
                        data: 'transaction_date',
                        name: 't.transaction_date'
                    },
                    {
                        data: 'purchase_qty',
                        name: 'purchase_lines.quantity'
                    },
                    {
                        data: 'quantity_adjusted',
                        name: 'purchase_lines.quantity_adjusted'
                    },
                    {
                        data: 'unit_purchase_price',
                        name: 'purchase_lines.purchase_price_inc_tax'
                    },
                    {
                        data: 'subtotal',
                        name: 'subtotal',
                        searchable: false
                    },
                ],
                fnDrawCallback: function(oSettings) {
                    $('#footer_subtotal').text(
                        sum_table_col($('#product_purchase_report_table'), 'row_subtotal')
                    );
                    $('#footer_total_purchase').html(
                        __sum_stock($('#product_purchase_report_table'), 'purchase_qty')
                    );
                    $('#footer_total_adjusted').html(
                        __sum_stock($('#product_purchase_report_table'), 'quantity_adjusted')
                    );
                    __currency_convert_recursively($('#product_purchase_report_table'));
                },
            });

            if ($('#search_product').length > 0) {
                $('#search_product').autocomplete({
                    source: function(request, response) {
                        $.ajax({
                            url: '/purchases/get_products?check_enable_stock=false',
                            dataType: 'json',
                            data: {
                                term: request.term,
                            },
                            success: function(data) {
                                response(
                                    $.map(data, function(v, i) {
                                        if (v.variation_id) {
                                            return {
                                                label: v.text,
                                                value: v.variation_id
                                            };
                                        }
                                        return false;
                                    })
                                );
                            },
                        });
                    },
                    minLength: 2,
                    select: function(event, ui) {
                        $('#variation_id')
                            .val(ui.item.value)
                            .change();
                        event.preventDefault();
                        $(this).val(ui.item.label);
                    },
                    focus: function(event, ui) {
                        event.preventDefault();
                        $(this).val(ui.item.label);
                    },
                });
            }

            //Product Sell Report
            if ($('#product_sr_date_filter').length == 1) {
                dateRangeSettings.startDate = moment().startOf('year');
                dateRangeSettings.endDate = moment().endOf('year');
                $('#product_sr_date_filter').daterangepicker(
                    dateRangeSettings,
                    function(start, end) {
                        $('#product_sr_date_filter').val(
                            start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                        );
                        product_sell_report.ajax.reload();
                        product_sell_grouped_report.ajax.reload();
                        product_sell_report_with_purchase_table.ajax.reload();
                        $('.nav-tabs li.active').find('a[data-toggle="tab"]').trigger('shown.bs.tab');
                    }
                );
                $('#product_sr_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                    $('#product_sr_date_filter').val('');
                    product_sell_report.ajax.reload();
                    product_sell_grouped_report.ajax.reload();
                    product_sell_report_with_purchase_table.ajax.reload();
                    $('.nav-tabs li.active').find('a[data-toggle="tab"]').trigger('shown.bs.tab');
                });

                $('#product_sr_start_time, #product_sr_end_time').datetimepicker({
                    format: moment_time_format,
                    ignoreReadonly: true,
                }).on('dp.change', function(ev) {
                    product_sell_report.ajax.reload();
                    product_sell_report_with_purchase_table.ajax.reload();
                    product_sell_grouped_report.ajax.reload();
                    $('.nav-tabs li.active').find('a[data-toggle="tab"]').trigger('shown.bs.tab');
                });

            }
            product_sell_report = $('table#product_sell_report_table').DataTable({
                processing: true,
                serverSide: true,
                aaSorting: [
                    [4, 'desc']
                ],
                ajax: {
                    url: '/reports/product-sell-report',
                    data: function(d) {
                        var start = '';
                        var end = '';
                        var start_time = $('#product_sr_start_time').val();
                        var end_time = $('#product_sr_end_time').val();

                        if ($('#product_sr_date_filter').val()) {
                            start = $('input#product_sr_date_filter')
                                .data('daterangepicker')
                                .startDate.format('YYYY-MM-DD');

                            start = moment(start + " " + start_time, "YYYY-MM-DD" + " " +
                                moment_time_format).format('YYYY-MM-DD HH:mm');
                            end = $('input#product_sr_date_filter')
                                .data('daterangepicker')
                                .endDate.format('YYYY-MM-DD');
                            end = moment(end + " " + end_time, "YYYY-MM-DD" + " " + moment_time_format)
                                .format('YYYY-MM-DD HH:mm');
                        }
                        d.start_date = start;
                        d.end_date = end;

                        d.variation_id = $('#variation_id').val();
                        d.customer_id = $('select#customer_id').val();
                        d.location_id = $('select#location_id').val();
                        d.category_id = $('select#psr_filter_category_id').val();
                        d.brand_id = $('select#psr_filter_brand_id').val();
                        d.customer_group_id = $('#psr_customer_group_id').val();
                    },
                },
                columns: [{
                        data: 'product_name',
                        name: 'p.name'
                    },
                    {
                        data: 'sub_sku',
                        name: 'v.sub_sku'
                    },
                    {
                        data: 'customer',
                        name: 'c.name'
                    },
                    {
                        data: 'contact_id',
                        name: 'c.contact_id'
                    },
                    {
                        data: 'invoice_no',
                        name: 't.invoice_no'
                    },
                    {
                        data: 'transaction_date',
                        name: 't.transaction_date'
                    },
                    {
                        data: 'sell_qty',
                        name: 'transaction_sell_lines.quantity'
                    },
                    {
                        data: 'unit_price',
                        name: 'transaction_sell_lines.unit_price_before_discount'
                    },
                    {
                        data: 'discount_amount',
                        name: 'transaction_sell_lines.line_discount_amount'
                    },
                    {
                        data: 'tax',
                        name: 'tax_rates.name'
                    },
                    {
                        data: 'unit_sale_price',
                        name: 'transaction_sell_lines.unit_price_inc_tax'
                    },
                    {
                        data: 'subtotal',
                        name: 'subtotal',
                        searchable: false
                    },
                ],
                fnDrawCallback: function(oSettings) {
                    $('#footer_subtotal').text(
                        sum_table_col($('#product_sell_report_table'), 'row_subtotal')
                    );
                    $('#footer_total_sold').html(__sum_stock($('#product_sell_report_table'),
                        'sell_qty'));
                    $('#footer_tax').html(__sum_stock($('#product_sell_report_table'), 'tax', 'left'));
                    __currency_convert_recursively($('#product_sell_report_table'));
                },
            });

            var is_lot_enabled = $('#lot_enabled').length > 0 ? true : false;
            product_sell_report_with_purchase_table = $('table#product_sell_report_with_purchase_table').DataTable({
                processing: true,
                serverSide: true,
                aaSorting: [
                    [4, 'desc']
                ],
                ajax: {
                    url: '/reports/product-sell-report-with-purchase',
                    data: function(d) {
                        var start = '';
                        var end = '';
                        var start_time = $('#product_sr_start_time').val();
                        var end_time = $('#product_sr_end_time').val();
                        if ($('#product_sr_date_filter').val()) {
                            start = $('input#product_sr_date_filter')
                                .data('daterangepicker')
                                .startDate.format('YYYY-MM-DD');
                            end = $('input#product_sr_date_filter')
                                .data('daterangepicker')
                                .endDate.format('YYYY-MM-DD');

                            start = moment(start + " " + start_time, "YYYY-MM-DD" + " " +
                                moment_time_format).format('YYYY-MM-DD HH:mm');
                            end = moment(end + " " + end_time, "YYYY-MM-DD" + " " + moment_time_format)
                                .format('YYYY-MM-DD HH:mm');
                        }
                        d.start_date = start;
                        d.end_date = end;

                        d.variation_id = $('#variation_id').val();
                        d.customer_id = $('select#customer_id').val();
                        d.location_id = $('select#location_id').val();
                        d.category_id = $('select#psr_filter_category_id').val();
                        d.brand_id = $('select#psr_filter_brand_id').val();
                        d.customer_group_id = $('#psr_customer_group_id').val();
                    },
                },
                columns: [{
                        data: 'product_name',
                        name: 'p.name'
                    },
                    {
                        data: 'sub_sku',
                        name: 'v.sub_sku'
                    },
                    {
                        data: 'customer',
                        name: 'c.name'
                    },
                    {
                        data: 'invoice_no',
                        name: 't.invoice_no'
                    },
                    {
                        data: 'transaction_date',
                        name: 't.transaction_date'
                    },
                    {
                        data: 'ref_no',
                        name: 'purchase.ref_no'
                    },
                    {
                        data: 'lot_number',
                        name: 'pl.lot_number',
                        visible: is_lot_enabled
                    },
                    {
                        data: 'supplier_name',
                        name: 'supplier.name'
                    },
                    {
                        data: 'purchase_quantity',
                        name: 'tspl.quantity'
                    },
                ],
                fnDrawCallback: function(oSettings) {
                    __currency_convert_recursively($('#product_sell_report_with_purchase_table'));
                },
            });

            product_sell_grouped_report = $('table#product_sell_grouped_report_table').DataTable({
                processing: true,
                serverSide: true,
                aaSorting: [
                    [1, 'desc']
                ],
                ajax: {
                    url: '/reports/product-sell-grouped-report',
                    data: function(d) {
                        var start = '';
                        var end = '';
                        var start_time = $('#product_sr_start_time').val();
                        var end_time = $('#product_sr_end_time').val();
                        if ($('#product_sr_date_filter').val()) {
                            start = $('input#product_sr_date_filter')
                                .data('daterangepicker')
                                .startDate.format('YYYY-MM-DD');
                            end = $('input#product_sr_date_filter')
                                .data('daterangepicker')
                                .endDate.format('YYYY-MM-DD');

                            start = moment(start + " " + start_time, "YYYY-MM-DD" + " " +
                                moment_time_format).format('YYYY-MM-DD HH:mm');
                            end = moment(end + " " + end_time, "YYYY-MM-DD" + " " + moment_time_format)
                                .format('YYYY-MM-DD HH:mm');
                        }
                        d.start_date = start;
                        d.end_date = end;

                        d.variation_id = $('#variation_id').val();
                        d.customer_id = $('select#customer_id').val();
                        d.location_id = $('select#location_id').val();
                        d.category_id = $('select#psr_filter_category_id').val();
                        d.brand_id = $('select#psr_filter_brand_id').val();
                        d.customer_group_id = $('#psr_customer_group_id').val();
                    },
                },
                columns: [{
                        data: 'product_name',
                        name: 'p.name'
                    },
                    {
                        data: 'sub_sku',
                        name: 'v.sub_sku'
                    },
                    {
                        data: 'transaction_date',
                        name: 't.transaction_date'
                    },
                    {
                        data: 'current_stock',
                        name: 'current_stock',
                        searchable: false,
                        orderable: false
                    },
                    {
                        data: 'total_qty_sold',
                        name: 'total_qty_sold',
                        searchable: false
                    },
                    {
                        data: 'subtotal',
                        name: 'subtotal',
                        searchable: false
                    },
                ],
                fnDrawCallback: function(oSettings) {
                    $('#footer_grouped_subtotal').text(
                        sum_table_col($('#product_sell_grouped_report_table'), 'row_subtotal')
                    );
                    $('#footer_total_grouped_sold').html(
                        __sum_stock($('#product_sell_grouped_report_table'), 'sell_qty')
                    );
                    __currency_convert_recursively($('#product_sell_grouped_report_table'));
                },
            });

            $(
                '#psr_customer_group_id, #psr_filter_category_id, #psr_filter_brand_id, #product_sell_report_form #variation_id, #product_sell_report_form #location_id, #product_sell_report_form #customer_id'
            ).change(function() {
                product_sell_report.ajax.reload();
                product_sell_grouped_report.ajax.reload();
                product_sell_report_with_purchase_table.ajax.reload();
            });

            $('#product_sell_report_form #search_product').keyup(function() {
                if (
                    $(this)
                    .val()
                    .trim() == ''
                ) {
                    $('#product_sell_report_form #variation_id')
                        .val('')
                        .change();
                }
            });

            $(document).on('click', '.remove_from_stock_btn', function() {
                swal({
                    title: LANG.sure,
                    icon: 'warning',
                    buttons: true,
                    dangerMode: true,
                }).then(willDelete => {
                    if (willDelete) {
                        $.ajax({
                            method: 'GET',
                            url: $(this).data('href'),
                            dataType: 'json',
                            success: function(result) {
                                if (result.success == true) {
                                    toastr.success(result.msg);
                                    stock_expiry_report_table.ajax.reload();
                                } else {
                                    toastr.error(result.msg);
                                }
                            },
                        });
                    }
                });
            });

            //Product lot Report
            lot_report = $('table#lot_report').DataTable({
                processing: true,
                serverSide: true,
                // aaSorting: [[3, 'desc']],

                ajax: {
                    url: '/reports/lot-report',
                    data: function(d) {
                        d.location_id = $('#location_id').val();
                        d.category_id = $('#category_id').val();
                        d.sub_category_id = $('#sub_category_id').val();
                        d.brand_id = $('#brand').val();
                        d.unit_id = $('#unit').val();
                        d.only_mfg_products = $('#only_mfg_products').length && $('#only_mfg_products')
                            .is(':checked') ? 1 : 0;
                    },
                },
                columns: [{
                        data: 'sub_sku',
                        name: 'v.sub_sku'
                    },
                    {
                        data: 'product',
                        name: 'products.name'
                    },
                    {
                        data: 'lot_number',
                        name: 'pl.lot_number'
                    },
                    {
                        data: 'exp_date',
                        name: 'pl.exp_date'
                    },
                    {
                        data: 'stock',
                        name: 'stock',
                        searchable: false
                    },
                    {
                        data: 'total_sold',
                        name: 'total_sold',
                        searchable: false
                    },
                    {
                        data: 'total_adjusted',
                        name: 'total_adjusted',
                        searchable: false
                    },
                ],

                fnDrawCallback: function(oSettings) {
                    $('#footer_total_stock').html(__sum_stock($('#lot_report'), 'total_stock'));
                    $('#footer_total_sold').html(__sum_stock($('#lot_report'), 'total_sold'));
                    $('#footer_total_adjusted').html(__sum_stock($('#lot_report'), 'total_adjusted'));

                    __currency_convert_recursively($('#lot_report'));
                    __show_date_diff_for_human($('#lot_report'));
                },
            });

            if ($('table#lot_report').length == 1) {
                $('#location_id, #category_id, #sub_category_id, #unit, #brand').change(function() {
                    lot_report.ajax.reload();
                });
            }

            //Purchase Payment Report
            purchase_payment_report = $('table#purchase_payment_report_table').DataTable({
                processing: true,
                serverSide: true,
                aaSorting: [
                    [2, 'desc']
                ],
                ajax: {
                    url: '/reports/purchase-payment-report',
                    data: function(d) {
                        d.supplier_id = $('select#supplier_id').val();
                        d.location_id = $('select#location_id').val();
                        var start = '';
                        var end = '';
                        if ($('input#ppr_date_filter').val()) {
                            start = $('input#ppr_date_filter')
                                .data('daterangepicker')
                                .startDate.format('YYYY-MM-DD');
                            end = $('input#ppr_date_filter')
                                .data('daterangepicker')
                                .endDate.format('YYYY-MM-DD');
                        }
                        d.start_date = start;
                        d.end_date = end;
                    },
                },
                columns: [{
                        orderable: false,
                        searchable: false,
                        data: null,
                        defaultContent: '',
                    },
                    {
                        data: 'payment_ref_no',
                        name: 'payment_ref_no'
                    },
                    {
                        data: 'paid_on',
                        name: 'paid_on'
                    },
                    {
                        data: 'amount',
                        name: 'transaction_payments.amount'
                    },
                    {
                        data: 'supplier',
                        orderable: false,
                        searchable: false
                    },
                    {
                        data: 'method',
                        name: 'method'
                    },
                    {
                        data: 'ref_no',
                        name: 't.ref_no'
                    },
                    {
                        data: 'action',
                        orderable: false,
                        searchable: false
                    },
                ],
                fnDrawCallback: function(oSettings) {
                    var total_amount = sum_table_col($('#purchase_payment_report_table'),
                        'paid-amount');
                    $('#footer_total_amount').text(total_amount);
                    __currency_convert_recursively($('#purchase_payment_report_table'));
                },
                createdRow: function(row, data, dataIndex) {
                    if (!data.transaction_id) {
                        $(row)
                            .find('td:eq(0)')
                            .addClass('details-control');
                    }
                },
            });

            // Array to track the ids of the details displayed rows
            var ppr_detail_rows = [];

            $('#purchase_payment_report_table tbody').on('click', 'tr td.details-control', function() {
                var tr = $(this).closest('tr');
                var row = purchase_payment_report.row(tr);
                var idx = $.inArray(tr.attr('id'), ppr_detail_rows);

                if (row.child.isShown()) {
                    tr.removeClass('details');
                    row.child.hide();

                    // Remove from the 'open' array
                    ppr_detail_rows.splice(idx, 1);
                } else {
                    tr.addClass('details');

                    row.child(show_child_payments(row.data())).show();

                    // Add to the 'open' array
                    if (idx === -1) {
                        ppr_detail_rows.push(tr.attr('id'));
                    }
                }
            });

            // On each draw, loop over the `detailRows` array and show any child rows
            purchase_payment_report.on('draw', function() {
                $.each(ppr_detail_rows, function(i, id) {
                    $('#' + id + ' td.details-control').trigger('click');
                });
            });

            if ($('#ppr_date_filter').length == 1) {
                dateRangeSettings.startDate = moment().startOf('year');
                dateRangeSettings.endDate = moment().endOf('year');
                $('#ppr_date_filter').daterangepicker(dateRangeSettings, function(start, end) {
                    $('#ppr_date_filter span').val(
                        start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                    );
                    purchase_payment_report.ajax.reload();
                });
                $('#ppr_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                    $('#ppr_date_filter').val('');
                    purchase_payment_report.ajax.reload();
                });
            }

            $(
                '#purchase_payment_report_form #location_id, #purchase_payment_report_form #supplier_id'
            ).change(function() {
                purchase_payment_report.ajax.reload();
            });

            //Sell Payment Report
            sell_payment_report = $('table#sell_payment_report_table').DataTable({
                processing: true,
                serverSide: true,
                aaSorting: [
                    [2, 'desc']
                ],
                ajax: {
                    url: '/reports/sell-payment-report',
                    data: function(d) {
                        d.supplier_id = $('select#customer_id').val();
                        d.location_id = $('select#location_id').val();
                        d.payment_types = $('select#payment_types').val();
                        d.customer_group_id = $('select#customer_group_filter').val();
                        var start = '';
                        var end = '';
                        if ($('input#spr_date_filter').val()) {
                            start = $('input#spr_date_filter')
                                .data('daterangepicker')
                                .startDate.format('YYYY-MM-DD');
                            end = $('input#spr_date_filter')
                                .data('daterangepicker')
                                .endDate.format('YYYY-MM-DD');
                        }
                        d.start_date = start;
                        d.end_date = end;
                    },
                },
                columns: [{
                        orderable: false,
                        searchable: false,
                        data: null,
                        defaultContent: '',
                    },
                    {
                        data: 'payment_ref_no',
                        name: 'payment_ref_no'
                    },
                    {
                        data: 'paid_on',
                        name: 'paid_on'
                    },
                    {
                        data: 'amount',
                        name: 'transaction_payments.amount'
                    },
                    {
                        data: 'customer',
                        orderable: false,
                        searchable: false
                    },
                    {
                        data: 'customer_group',
                        name: 'customer_group',
                        searchable: false
                    },
                    {
                        data: 'method',
                        name: 'method'
                    },
                    {
                        data: 'invoice_no',
                        name: 't.invoice_no'
                    },
                    {
                        data: 'action',
                        orderable: false,
                        searchable: false
                    },
                ],
                fnDrawCallback: function(oSettings) {
                    var total_amount = sum_table_col($('#sell_payment_report_table'), 'paid-amount');
                    $('#footer_total_amount').text(total_amount);
                    __currency_convert_recursively($('#sell_payment_report_table'));
                },
                createdRow: function(row, data, dataIndex) {
                    if (!data.transaction_id) {
                        $(row)
                            .find('td:eq(0)')
                            .addClass('details-control');
                    }
                },
            });
            // Array to track the ids of the details displayed rows
            var spr_detail_rows = [];

            $('#sell_payment_report_table tbody').on('click', 'tr td.details-control', function() {
                var tr = $(this).closest('tr');
                var row = sell_payment_report.row(tr);
                var idx = $.inArray(tr.attr('id'), spr_detail_rows);

                if (row.child.isShown()) {
                    tr.removeClass('details');
                    row.child.hide();

                    // Remove from the 'open' array
                    spr_detail_rows.splice(idx, 1);
                } else {
                    tr.addClass('details');

                    row.child(show_child_payments(row.data())).show();

                    // Add to the 'open' array
                    if (idx === -1) {
                        spr_detail_rows.push(tr.attr('id'));
                    }
                }
            });

            // On each draw, loop over the `detailRows` array and show any child rows
            sell_payment_report.on('draw', function() {
                $.each(spr_detail_rows, function(i, id) {
                    $('#' + id + ' td.details-control').trigger('click');
                });
            });

            if ($('#spr_date_filter').length == 1) {
                dateRangeSettings.startDate = moment().startOf('year');
                dateRangeSettings.endDate = moment().endOf('year');
                $('#spr_date_filter').daterangepicker(dateRangeSettings, function(start, end) {
                    $('#spr_date_filter span').val(
                        start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                    );
                    sell_payment_report.ajax.reload();
                });
                $('#spr_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                    $('#spr_date_filter').val('');
                    sell_payment_report.ajax.reload();
                });
            }

            $('#sell_payment_report_form #location_id, #sell_payment_report_form #customer_id, #sell_payment_report_form #payment_types, #sell_payment_report_form #customer_group_filter')
                .change(
                    function() {
                        sell_payment_report.ajax.reload();
                    }
                );

            //Items report
            if ($('#ir_purchase_date_filter').length == 1) {
                dateRangeSettings.startDate = moment().startOf('year');
                dateRangeSettings.endDate = moment().endOf('year');
                $('#ir_purchase_date_filter').daterangepicker(dateRangeSettings, function(start, end) {
                    $('#ir_purchase_date_filter').val(
                        start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                    );
                    items_report_table.ajax.reload();
                });
                $('#ir_purchase_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                    $('#ir_purchase_date_filter').val('');
                    items_report_table.ajax.reload();
                });
            }
            if ($('#ir_sale_date_filter').length == 1) {
                dateRangeSettings.startDate = moment().startOf('year');
                dateRangeSettings.endDate = moment().endOf('year');
                $('#ir_sale_date_filter').daterangepicker(dateRangeSettings, function(start, end) {
                    $('#ir_sale_date_filter').val(
                        start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                    );
                    items_report_table.ajax.reload();
                });
                $('#ir_sale_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                    $('#ir_sale_date_filter').val('');
                    items_report_table.ajax.reload();
                });
            }
            items_report_table = $('#items_report_table').DataTable({
                processing: true,
                serverSide: true,
                ajax: {
                    url: '/reports/items-report',
                    data: function(d) {
                        var purchase_start = '';
                        var purchase_end = '';
                        if ($('#ir_purchase_date_filter').val()) {
                            purchase_start = $('input#ir_purchase_date_filter')
                                .data('daterangepicker')
                                .startDate.format('YYYY-MM-DD');
                            purchase_end = $('input#ir_purchase_date_filter')
                                .data('daterangepicker')
                                .endDate.format('YYYY-MM-DD');
                        }
                        console.log(purchase_end);

                        var sale_start = '';
                        var sale_end = '';
                        if ($('#ir_sale_date_filter').val()) {
                            sale_start = $('input#ir_sale_date_filter')
                                .data('daterangepicker')
                                .startDate.format('YYYY-MM-DD');
                            sale_end = $('input#ir_sale_date_filter')
                                .data('daterangepicker')
                                .endDate.format('YYYY-MM-DD');
                        }

                        d.purchase_start = purchase_start;
                        d.purchase_end = purchase_end;

                        d.sale_start = sale_start;
                        d.sale_end = sale_end;

                        d.supplier_id = $('select#ir_supplier_id').val();
                        d.customer_id = $('select#ir_customer_id').val();
                        d.location_id = $('select#ir_location_id').val();
                        d.only_mfg_products = $('#only_mfg_products').length && $('#only_mfg_products')
                            .is(':checked') ? 1 : 0;
                    },
                },
                columns: [{
                        data: 'product_name',
                        name: 'p.name'
                    },
                    {
                        data: 'sku',
                        name: 'v.sub_sku'
                    },
                    {
                        data: 'sell_line_note',
                        name: 'SL.sell_line_note'
                    },
                    {
                        data: 'purchase_date',
                        name: 'purchase.transaction_date'
                    },
                    {
                        data: 'purchase_ref_no',
                        name: 'purchase.ref_no'
                    },
                    {
                        data: 'lot_number',
                        name: 'PL.lot_number'
                    },
                    {
                        data: 'supplier',
                        name: 'suppliers.name'
                    },
                    {
                        data: 'purchase_price',
                        name: 'PL.purchase_price_inc_tax'
                    },
                    {
                        data: 'sell_date',
                        searchable: false
                    },
                    {
                        data: 'sale_invoice_no',
                        name: 'sale_invoice_no'
                    },
                    {
                        data: 'customer',
                        searchable: false
                    },
                    {
                        data: 'location',
                        name: 'bl.name'
                    },
                    {
                        data: 'quantity',
                        searchable: false
                    },
                    {
                        data: 'selling_price',
                        searchable: false
                    },
                    {
                        data: 'subtotal',
                        searchable: false
                    }
                ],
                fnDrawCallback: function(oSettings) {
                    $('#footer_total_pp').html(sum_table_col($('#items_report_table'),
                        'purchase_price'));
                    $('#footer_total_sp').html(sum_table_col($('#items_report_table'),
                        'row_selling_price'));
                    $('#footer_total_subtotal').html(
                        sum_table_col($('#items_report_table'), 'row_subtotal')
                    );
                    $('#footer_total_qty').html(
                        __sum_stock($('#items_report_table'), 'quantity')
                    );

                    __currency_convert_recursively($('#items_report_table'));
                },
            });
            $(document).on('change', '#ir_supplier_id, #ir_customer_id, #ir_location_id', function() {
                items_report_table.ajax.reload();
            });

            expense_report_table = $('#expense_report_table').DataTable();

            if ($('#closing_stock_by_pp').length == 1) {
                get_stock_value();
            }

            if ($('#tax_report_date_range').length == 1) {
                updateTaxReport();
            }

            $('#tax_report_location_id, #tax_report_date_range, #tax_report_contact_id').change(function() {
                updateTaxReport();
            });
        });

        function updatePurchaseSell() {
            var start = $('#purchase_sell_date_filter')
                .data('daterangepicker')
                .startDate.format('YYYY-MM-DD');
            var end = $('#purchase_sell_date_filter')
                .data('daterangepicker')
                .endDate.format('YYYY-MM-DD');
            var location_id = $('#purchase_sell_location_filter').val();

            var data = {
                start_date: start,
                end_date: end,
                location_id: location_id
            };

            var loader = __fa_awesome();
            $('.total_purchase').html(loader);
            $('.purchase_due').html(loader);
            $('.total_sell').html(loader);
            $('.invoice_due').html(loader);
            $('.purchase_return_inc_tax').html(loader);
            $('.total_sell_return').html(loader);

            $.ajax({
                method: 'GET',
                url: '/reports/purchase-sell',
                dataType: 'json',
                data: data,
                success: function(data) {
                    $('.total_purchase').html(
                        __currency_trans_from_en(data.purchase.total_purchase_exc_tax, true)
                    );
                    $('.purchase_inc_tax').html(
                        __currency_trans_from_en(data.purchase.total_purchase_inc_tax, true)
                    );
                    $('.purchase_due').html(__currency_trans_from_en(data.purchase.purchase_due, true));

                    $('.total_sell').html(__currency_trans_from_en(data.sell.total_sell_exc_tax, true));
                    $('.sell_inc_tax').html(__currency_trans_from_en(data.sell.total_sell_inc_tax, true));
                    $('.sell_due').html(__currency_trans_from_en(data.sell.invoice_due, true));
                    $('.purchase_return_inc_tax').html(
                        __currency_trans_from_en(data.total_purchase_return, true)
                    );
                    $('.total_sell_return').html(__currency_trans_from_en(data.total_sell_return, true));

                    $('.sell_minus_purchase').html(__currency_trans_from_en(data.difference.total, true));
                    __highlight(data.difference.total, $('.sell_minus_purchase'));

                    $('.difference_due').html(__currency_trans_from_en(data.difference.due, true));
                    __highlight(data.difference.due, $('.difference_due'));

                    // $('.purchase_due').html( __currency_trans_from_en(data.purchase_due, true));
                },
            });
        }

        function get_stock_details(rowData) {
            var div = $('<div/>')
                .addClass('loading')
                .text('Loading...');
            var location_id = $('#location_id').val();
            $.ajax({
                url: '/reports/stock-details?location_id=' + location_id,
                data: {
                    product_id: rowData.DT_RowId,
                },
                dataType: 'html',
                success: function(data) {
                    div.html(data).removeClass('loading');
                    __currency_convert_recursively(div);
                },
            });

            return div;
        }

        function updateStockAdjustmentReport() {
            var location_id = $('#stock_adjustment_location_filter').val();
            var start = $('#stock_adjustment_date_filter')
                .data('daterangepicker')
                .startDate.format('YYYY-MM-DD');
            var end = $('#stock_adjustment_date_filter')
                .data('daterangepicker')
                .endDate.format('YYYY-MM-DD');

            var data = {
                start_date: start,
                end_date: end,
                location_id: location_id
            };

            var loader = __fa_awesome();
            $('.total_amount').html(loader);
            $('.total_recovered').html(loader);
            $('.total_normal').html(loader);
            $('.total_abnormal').html(loader);
            $('.total_increase').html(loader);
            $('.total_descrease').html(loader);

            $.ajax({
                method: 'GET',
                url: '/reports/stock-adjustment-report',
                dataType: 'json',
                data: data,
                success: function(data) {
                    $('.total_amount').html(__currency_trans_from_en(data.total_amount, true));
                    $('.total_recovered').html(__currency_trans_from_en(data.total_recovered, true));
                    $('.total_normal').html(__currency_trans_from_en(data.total_normal, true));
                    $('.total_abnormal').html(__currency_trans_from_en(data.total_abnormal, true));
                    $('.total_increase').html(__currency_trans_from_en(data.total_increase, true));
                    $('.total_descrease').html(__currency_trans_from_en(data.total_descrease, true));
                },
            });

            stock_adjustment_table.ajax
                .url(
                    '/stock-adjustments?location_id=' +
                    location_id +
                    '&start_date=' +
                    start +
                    '&end_date=' +
                    end
                )
                .load();
        }

        function updateRegisterReport() {
            var start = $('#register_report_date_range')
                .data('daterangepicker')
                .startDate.format('YYYY-MM-DD');
            var end = $('#register_report_date_range')
                .data('daterangepicker')
                .endDate.format('YYYY-MM-DD');

            var data = {
                user_id: $('#register_user_id').val(),
                status: $('#register_status').val(),
                start_date: start,
                end_date: end
            };
            var out = [];

            for (var key in data) {
                out.push(key + '=' + encodeURIComponent(data[key]));
            }
            url_data = out.join('&');
            register_report_table.ajax.url('/reports/register-report?' + url_data).load();
        }

        function updateSalesRepresentativeReport() {
            //Update total expenses and total sales
            salesRepresentativeTotalExpense();
            salesRepresentativeTotalSales();
            salesRepresentativeTotalCommission();

            //Expense and expense table refresh
            sr_expenses_report.ajax.reload();
            sr_sales_report.ajax.reload();
            sr_sales_commission_report.ajax.reload();

            if ($('#sr_payments_with_commission_table').length > 0) {
                sr_payments_with_commission_report.ajax.reload();
            }
        }

        function salesRepresentativeTotalExpense() {
            var start = $('input#sr_date_filter')
                .data('daterangepicker')
                .startDate.format('YYYY-MM-DD');
            var end = $('input#sr_date_filter')
                .data('daterangepicker')
                .endDate.format('YYYY-MM-DD');

            var data_expense = {
                expense_for: $('select#sr_id').val(),
                location_id: $('select#sr_business_id').val(),
                start_date: start,
                end_date: end,
            };

            $('span#sr_total_expenses').html(__fa_awesome());

            $.ajax({
                method: 'GET',
                url: '/reports/sales-representative-total-expense',
                dataType: 'json',
                data: data_expense,
                success: function(data) {
                    $('span#sr_total_expenses').html(__currency_trans_from_en(data.total_expense, true));
                },
            });
        }

        function salesRepresentativeTotalSales() {
            var start = $('input#sr_date_filter')
                .data('daterangepicker')
                .startDate.format('YYYY-MM-DD');
            var end = $('input#sr_date_filter')
                .data('daterangepicker')
                .endDate.format('YYYY-MM-DD');

            var data_expense = {
                created_by: $('select#sr_id').val(),
                location_id: $('select#sr_business_id').val(),
                start_date: start,
                end_date: end,
            };

            $('span#sr_total_sales').html(__fa_awesome());
            $('span#sr_total_sales_return').html(__fa_awesome());
            $('span#sr_total_sales_final').html(__fa_awesome());

            $.ajax({
                method: 'GET',
                url: '/reports/sales-representative-total-sell',
                dataType: 'json',
                data: data_expense,
                success: function(data) {
                    $('span#sr_total_sales').html(__currency_trans_from_en(data.total_sell_exc_tax, true));
                    $('span#sr_total_sales_return').html(
                        __currency_trans_from_en(data.total_sell_return_exc_tax, true)
                    );
                    $('span#sr_total_sales_final').html(__currency_trans_from_en(data.total_sell, true));
                },
            });
        }

        function salesRepresentativeTotalCommission() {
            var start = $('input#sr_date_filter')
                .data('daterangepicker')
                .startDate.format('YYYY-MM-DD');
            var end = $('input#sr_date_filter')
                .data('daterangepicker')
                .endDate.format('YYYY-MM-DD');

            var data_sell = {
                commission_agent: $('select#sr_id').val(),
                location_id: $('select#sr_business_id').val(),
                start_date: start,
                end_date: end,
            };
            $('div#total_payment_with_commsn_div').addClass('hide');
            $('span#sr_total_commission').html(__fa_awesome());
            $('span#total_payment_with_commsn').html(__fa_awesome());
            if (data_sell.commission_agent) {
                $('div#total_commission_div').removeClass('hide');
                $.ajax({
                    method: 'GET',
                    url: '/reports/sales-representative-total-commission',
                    dataType: 'json',
                    data: data_sell,
                    success: function(data) {
                        var str =
                            '<div style="padding-right:15px; display: inline-block">' +
                            __currency_trans_from_en(data.total_commission, true) +
                            '</div>';
                        if (data.commission_percentage != 0) {
                            if (data.total_sales_with_commission) {
                                str +=
                                    ' <small>(' +
                                    data.commission_percentage +
                                    '% of ' +
                                    __currency_trans_from_en(data.total_sales_with_commission) +
                                    ')</small>';
                            }

                            if (data.total_payment_with_commission) {
                                $('div#total_payment_with_commsn_div').removeClass('hide');
                                $('span#total_payment_with_commsn').html(__currency_trans_from_en(data
                                    .total_payment_with_commission));
                                str +=
                                    ' <small>(' +
                                    data.commission_percentage +
                                    '% of ' +
                                    __currency_trans_from_en(data.total_payment_with_commission) +
                                    ')</small>';
                            }
                        }

                        $('span#sr_total_commission').html(str);
                    },
                });
            } else {
                $('div#total_commission_div').addClass('hide');
            }
        }

        function show_child_payments(rowData) {
            var div = $('<div/>')
                .addClass('loading')
                .text('Loading...');
            $.ajax({
                url: '/payments/show-child-payments/' + rowData.DT_RowId,
                dataType: 'html',
                success: function(data) {
                    div.html(data).removeClass('loading');
                    __currency_convert_recursively(div);
                },
            });

            return div;
        }

        function get_stock_value() {
            // var loader = __fa_awesome();
            // $('#closing_stock_by_pp').html(loader);
            // $('#closing_stock_by_sp').html(loader);
            // $('#potential_profit').html(loader);
            // $('#profit_margin').html(loader);
            // var data = {
            //     location_id: $('#location_id').val(),
            //     category_id: $('#category_id').val(),
            //     sub_category_id: $('#sub_category_id').val(),
            //     brand_id: $('#brand').val(),
            //     unit_id: $('#unit').val(),
            // }
            // $.ajax({
            //     url: '/reports/get-stock-value',
            //     data: data,
            //     success: function(data) {
            //         $('#closing_stock_by_pp').text(__currency_trans_from_en(data.closing_stock_by_pp));
            //         $('#closing_stock_by_sp').text(__currency_trans_from_en(data.closing_stock_by_sp));
            //         $('#potential_profit').text(__currency_trans_from_en(data.potential_profit));
            //         $('#profit_margin').text(__currency_trans_from_en(data.profit_margin, false));
            //     },
            // });
        }

        function updateTaxReport() {
            var start = $('#tax_report_date_range')
                .data('daterangepicker')
                .startDate.format('YYYY-MM-DD');
            var end = $('#tax_report_date_range')
                .data('daterangepicker')
                .endDate.format('YYYY-MM-DD');
            var location_id = $('#tax_report_location_id').val();
            var contact_id = $('#tax_report_contact_id').val();
            var data = {
                start_date: start,
                end_date: end,
                location_id: location_id,
                contact_id: contact_id
            };

            var loader = '<i class="fas fa-sync fa-spin fa-fw margin-bottom"></i>';
            $('.tax_diff').html(loader);
            $.ajax({
                method: 'GET',
                url: '/reports/tax-report',
                dataType: 'json',
                data: data,
                success: function(data) {
                    $('.tax_diff').html(__currency_trans_from_en(data.tax_diff, true));
                    __highlight(data.tax_diff, $('.tax_diff'));
                },
            });
        }
        document.title = `Stock Report`;
        $('#location_id').on('change', function() {
            var location_id = $(this).val();
            $.ajax({
                url: '/print/location/name',
                type: 'POST',
                data: {
                    location_id: location_id
                },
                headers: {
                    'X-CSRF-TOKEN': '{{ csrf_token() }}'
                },
                success: function(response) {
                    console.log('Success:', response);
                    if (response.location_name) {
                        document.title = `Stock Report - ${response.date} - ${response.location_name}`;
                    }
                },
                error: function(xhr, status, error) {
                    console.error('Error:', error);
                }
            });
        });
    </script>
@endsection