@extends('layout.main') @section('content')
<section class="forms">
    <div class="container-fluid">
        <div class="card">
            <div class="card-header mt-2">
                <h3 class="text-center">{{trans('file.Customer Report')}}</h3>
            </div>
            {!! Form::open(['route' => 'report.customer', 'method' => 'post']) !!}
            <div class="row mb-3">
                <div class="col-md-3 offset-md-1 mt-3">
                    <label class="d-tc mt-2"><strong>{{trans('file.Choose Your Date')}}</strong> &nbsp;</label>
                    <div class="form-group row">
                        <div class="d-tc">
                            <div class="input-group">
                                <input type="text" id="daterangepicker-change-date" class="daterangepicker-field form-control" value="{{date('d-m-Y', strtotime($start_date))}} To {{date('d-m-Y', strtotime($end_date))}}" required />
                                <input type="hidden" name="start_date" value="{{$start_date}}" />
                                <input type="hidden" name="end_date" value="{{$end_date}}" />
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-6 mt-3">
                    <label class="d-tc mt-2"><strong>{{trans('file.Choose Customer')}}</strong> &nbsp;</label>
                    <div class="form-group row">
                        <div class="d-tc col-md-11">
                            <input type="hidden" name="customer_id_hidden" value="{{$customer_id}}" />
                            <select id="customer_id" name="customer_id" class="form-control-select2" style="width: 100%;">
                                <option value="0">{{trans('file.All Customer')}}</option>
                                @foreach($lims_customer_list as $customer)
                                <option value="{{$customer->id}}">{{$customer->name}} ({{$customer->phone_number}})</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                </div>
                <div class="col-md-2 mt-4">
                    <div class="form-group mt-4">
                        <button class="btn btn-primary" type="submit">{{trans('file.submit')}}</button>
                    </div>
                </div>
            </div>
            {!! Form::close() !!}
        </div>
    </div>
    <ul class="nav nav-tabs ml-4 mt-3" role="tablist">
      <li class="nav-item">
        <a class="nav-link active" href="#customer-sale" role="tab" data-toggle="tab">{{trans('file.Sale')}}</a>
      </li>
      <!-- <li class="nav-item">
        <a class="nav-link" href="#customer-payments" role="tab" data-toggle="tab">{{trans('file.Payment')}}</a>
      </li> -->
      <li class="nav-item">
        <a class="nav-link" href="#customer-return" role="tab" data-toggle="tab">{{trans('file.return')}}</a>
      </li>
    </ul>

    <div class="tab-content">

        <div role="tabpanel" class="tab-pane fade show active" id="customer-sale">
            <div class="table-responsive mb-4">
                <table id="sale-table" class="table table-hover">
                    <thead>
                        <tr>
                            <th class="not-exported-sale"></th>
                            <th>{{trans('file.Date')}}</th>
                            <th>{{trans('file.Biller')}}</th>
                            <th>{{trans('file.Warehouse')}}</th>
                            <th>{{trans('file.Code')}}</th>
                            <th>{{trans('file.product')}}</th>
                            <th>{{trans('file.Unit')}}</th>
                            <th>{{trans('file.Quantity')}}</th>
                            <th>{{trans('file.Unit Price')}}</th>
                            <th>{{trans('file.grand total')}}</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($lims_data_sale as $key=>$data)
                            @foreach($data[0] as $idx=>$sale)  
                                <tr>
                                    <td class="text-center">{{$idx}}</td>
                                    <td class="text-center">{{date($general_setting->date_format, strtotime($sale->created_at->toDateString()))}}</td>
                                    <td>{{$sale->biller}}</td>
                                    <td>{{$sale->warehouse}}</td>
                                    <td class="text-right">{{$sale->product_code}}</td>
                                    <td>{{$sale->product_name}}</td>
                                    <td class="text-center">{{$sale->unit}}</td>
                                    <td class="text-right">{{number_format((float)$sale->total_quantity, 0, '.', '.')}}</td>    
                                    <td class="text-right">{{number_format((float)$sale->net_unit_price, 0, '.', '.')}}</td>    
                                    <td class="text-right">{{number_format((float)$sale->total_amount, 0, '.', '.')}}</td>                      
                                </tr>
                            @endforeach
                        @endforeach
                    </tbody>
                    <tfoot class="tfoot active">
                        <tr>
                            <th></th>
                            <th>Total:</th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th class="text-right">0</th>
                            <th></th>
                            <th class="text-right">0</th>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>

        <div role="tabpanel" class="tab-pane fade" id="customer-payments">
            <div class="table-responsive mb-4">
                <table id="payment-table" class="table table-hover">
                    <thead>
                        <tr>
                            <th class="not-exported-payment"></th>
                            <th>{{trans('file.Date')}}</th>
                            <th>{{trans('file.Payment Reference')}}</th>
                            <th>{{trans('file.Sale Reference')}}</th>
                            <th>{{trans('file.Amount')}}</th>
                            <th>{{trans('file.Paid Method')}}</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($lims_payment_data as $key=>$payment)
                            <tr>
                                <td class="text-center">{{$key}}</td>
                                <td class="text-center">{{date($general_setting->date_format, strtotime($payment->created_at))}}</td>
                                <td>{{$payment->payment_reference}}</td>
                                <td>{{$payment->sale_reference}}</td>
                                <td class="text-right">{{$payment->amount}}</td>
                                <td class="text-center">{{$payment->paying_method}}</td>
                            </tr>
                        @endforeach
                    </tbody>
                    <tfoot class="tfoot active">
                        <tr>
                            <th></th>
                            <th>Total:</th>
                            <th></th>
                            <th></th>
                            <th class="text-right">0</th>
                            <th></th>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>

        <div role="tabpanel" class="tab-pane fade" id="customer-return">
            <div class="table-responsive mb-4">
                <table id="return-table" class="table table-hover">
                    <thead>
                        <tr>
                            <th class="not-exported-return"></th>
                            <th>{{trans('file.Date')}}</th>
                            <th>{{trans('file.Biller')}}</th>
                            <th>{{trans('file.Warehouse')}}</th>
                            <th>{{trans('file.Code')}}</th>
                            <th>{{trans('file.product')}}</th>
                            <th>{{trans('file.Unit')}}</th>
                            <th>{{trans('file.qty')}}</th>
                            <th>{{trans('file.grand total')}}</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($lims_data_return as $key=>$data)
                            @foreach($data[0] as $idx=>$return)  
                                <tr>
                                    <td class="text-center">{{$idx}}</td>
                                    <td class="text-center">{{date($general_setting->date_format, strtotime($return->created_at->toDateString()))}}</td>
                                    <td>{{$return->biller}}</td>
                                    <td>{{$return->warehouse}}</td>
                                    <td class="text-right">{{$return->product_code}}</td>
                                    <td>{{$return->product_name}}</td>
                                    <td class="text-center">{{$return->unit}}</td>
                                    <td class="text-right">{{number_format((float)$return->total_quantity, 0, '.', '.')}}</td>    
                                    <td class="text-right">{{number_format((float)$return->total_amount, 0, '.', '.')}}</td>                      
                                </tr>
                            @endforeach
                        @endforeach
                    </tbody>
                    <tfoot class="tfoot active">
                        <tr>
                            <th></th>
                            <th>Total:</th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th class="text-right">0</th>
                            <th class="text-right">0</th>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>

    </div>
</section>

<script type="text/javascript">
    $("ul#report").siblings('a').attr('aria-expanded','true');
    $("ul#report").addClass("show");
    $("ul#report #customer-report-menu").addClass("active");
    $("table").css({ "color": "#000000" });
    $("th").css({ "border": "1px solid #333333", "text-align": "center" });
    $("td").css({ "border": "1px solid #333333" });
    
    $('#customer_id').val($('input[name="customer_id_hidden"]').val());
    $('.selectpicker').selectpicker('refresh');

    $('#customer_id').select2({
        placeholder: "Select customer..."
    });

    $( "span.selection" ).css( "width", "100%" );
    $( ".select2-container .select2-selection--single" ).css({"height":"38px", "padding": "4px 0 6px" });
    $( ".select2-selection__arrow" ).css( "top", "5px" );
    $( ".select2-container--default .select2-selection--single").css({"borderColor": "#e4e6fc", "backgroundColor": "#fdfdff"});
    $( ".select2-selection__placeholder").css({"fontSize": "14px"});

    $('#sale-table').DataTable( {
        "order": [],
        "createdRow": function( row, data, dataIndex ) {
            $('td', row).css( "border", "1px solid #333333" );
        },
        'columnDefs': [
            {
                "orderable": false,
                'targets': [1, 2, 3, 4, 5, 6, 7, 8, 9]
            },
            {
                'render': function(data, type, row, meta){
                    if(type === 'display'){
                        data = '<div class="checkbox"><input type="checkbox" class="dt-checkboxes"><label></label></div>';
                    }
                   return data;
                },
                'checkboxes': {
                   'selectRow': true,
                   'selectAllRender': '<div class="checkbox"><input type="checkbox" class="dt-checkboxes"><label></label></div>'
                },
                'targets': [0]
                
            }
        ],
        'select': { style: 'multi',  selector: 'td:first-child'},
        'lengthMenu': [[10, 25, 50, -1], [10, 25, 50, "All"]],
        dom: '<"row"lfB>rtip',
        buttons: [
            {
                extend: 'pdf',     
                text: '{{trans("file.PDF")}}',        
                exportOptions: {
                    columns: ':visible:Not(.not-exported-sale)',
                    rows: ':visible'
                },
                action: function(e, dt, button, config) {
                    datatable_sum_sale(dt, true);
                    $.fn.dataTable.ext.buttons.pdfHtml5.action.call(this, e, dt, button, config);
                    datatable_sum_sale(dt, false);
                },
                footer:true
            },
            {
                extend: 'csv',
                text: '{{trans("file.CSV")}}',
                charset: 'UTF-8',
                bom: true,
                exportOptions: {
                    columns: ':visible:Not(.not-exported-sale)',
                    rows: ':visible'
                },
                action: function(e, dt, button, config) {
                    datatable_sum_sale(dt, true);
                    $.fn.dataTable.ext.buttons.csvHtml5.action.call(this, e, dt, button, config);
                    datatable_sum_sale(dt, false);
                },
                footer:true
            },
            {
                extend: 'print',
                text: '{{trans("file.Print")}}',
                messageTop: function(){
                    return `
                        <div> 
                            <div style="display:flex;justify-content: center">
                                <div style="padding-right: 15px"> 
                                    <img src="{{url('public/logo', $general_setting->site_logo)}}" width="65">
                                </div>
                                <div> 
                                    <h4 style="text-align:left;color:red;">{{trans('file.Company name system')}}</h4> 
                                    <p style="text-align:left;color:red;">{{trans('file.Company address system')}}</p> 
                                </div>
                            </div>
                            <div style="text-align:center;">         
                                <br>                
                                <h3 style="text-transform: uppercase" class="modal-title text-center container-fluid">{{trans('file.Sale Report')}}</h3>
                                <p class="modal-title text-center container-fluid">{{trans('file.From date')}} {{date('d-m-Y', strtotime($start_date))}} {{trans('file.To date')}} {{date('d-m-Y', strtotime($end_date))}}</p>
                            </div>
                        </div>
                    
                    `;
                },
          
                exportOptions: {
                    columns: ':visible:Not(.not-exported-sale)',
                    rows: ':visible'
                },
                customize: function ( doc ) {
                    $(doc.document.body).find('table td').css('border', '1px solid #333333');
                    $(doc.document.body).find('table th').css({'border': '1px solid #333333', "text-align": "center"});
                    $(doc.document.body).find('table td:nth-child(1)').css({'text-align': 'center'});
                    $(doc.document.body).find('table td:nth-child(6)').css({'text-align': 'center'});
                    $(doc.document.body).find('table td:nth-child(4)').css({'text-align': 'right'});
                    $(doc.document.body).find('table td:nth-child(7)').css({'text-align': 'right'});
                    $(doc.document.body).find('table td:nth-child(8)').css({'text-align': 'right'});
                    $(doc.document.body).find('table td:nth-child(9)').css({'text-align': 'right'});
                },
                action: function(e, dt, button, config) {
                    datatable_sum_sale(dt, true);
                    $.fn.dataTable.ext.buttons.print.action.call(this, e, dt, button, config);
                    datatable_sum_sale(dt, false);
                },
                footer:true
            },
            {
                extend: 'colvis',
                columns: ':gt(0)'
            }
        ],
        drawCallback: function () {
            var api = this.api();
            datatable_sum_sale(api, false);
        }
    } );

    function datatable_sum_sale(dt_selector, is_calling_first) {
        if (dt_selector.rows( '.selected' ).any() && is_calling_first) {
            var rows = dt_selector.rows( '.selected' ).indexes();
            var column7Sum = 0;
            var column9Sum = 0;

            dt_selector.cells( rows, 7, { page: 'current' }).data().each(function(value) {
                column7Sum += parseFloat(value.replace(/\./g, ""));
            });
            dt_selector.cells( rows, 9, { page: 'current' }).data().each(function(value) {
                column9Sum += parseFloat(value.replace(/\./g, ""));
            });

            $( dt_selector.column( 7 ).footer() ).html(column7Sum.toFixed(0).replace(/(\d)(?=(\d{3})+(?!\d))/g, "$1."));
            $( dt_selector.column( 9 ).footer() ).html(column9Sum.toFixed(0).replace(/(\d)(?=(\d{3})+(?!\d))/g, "$1."));
        }
        else {
            var column7Sum = 0;
            var column9Sum = 0;

            dt_selector.column(7, { page: 'current' }).data().each(function(value) {
                column7Sum += parseFloat(value.replace(/\./g, ""));
            });
            dt_selector.column(9, { page: 'current' }).data().each(function(value) {
                column9Sum += parseFloat(value.replace(/\./g, ""));
            });

            $( dt_selector.column( 7 ).footer() ).html(column7Sum.toFixed(0).replace(/(\d)(?=(\d{3})+(?!\d))/g, "$1."));
            $( dt_selector.column( 9 ).footer() ).html(column9Sum.toFixed(0).replace(/(\d)(?=(\d{3})+(?!\d))/g, "$1."));
        }
    }

    $('#payment-table').DataTable( {
        "order": [],
        "createdRow": function( row, data, dataIndex ) {
            $('td', row).css( "border", "1px solid #333333" );
        },
        'columnDefs': [
            {
                "orderable": false,
                'targets': [1, 2, 3, 4, 5]
            },
            {
                'render': function(data, type, row, meta){
                    if(type === 'display'){
                        data = '<div class="checkbox"><input type="checkbox" class="dt-checkboxes"><label></label></div>';
                    }

                   return data;
                },
                'checkboxes': {
                   'selectRow': true,
                   'selectAllRender': '<div class="checkbox"><input type="checkbox" class="dt-checkboxes"><label></label></div>'
                },
                'targets': [0]
            }
        ],
        'select': { style: 'multi',  selector: 'td:first-child'},
        'lengthMenu': [[10, 25, 50, -1], [10, 25, 50, "All"]],
        dom: '<"row"lfB>rtip',
        buttons: [
            {
                extend: 'pdf',
                text: '{{trans("file.PDF")}}',
                exportOptions: {
                    columns: ':visible:Not(.not-exported-payment)',
                    rows: ':visible'
                },
                action: function(e, dt, button, config) {
                    datatable_sum_payment(dt, true);
                    $.fn.dataTable.ext.buttons.pdfHtml5.action.call(this, e, dt, button, config);
                    datatable_sum_payment(dt, false);
                },
                footer:true
            },
            {
                extend: 'csv',
                text: '{{trans("file.CSV")}}',
                charset: 'UTF-8',
                bom: true, 
                exportOptions: {
                    columns: ':visible:Not(.not-exported-payment)',
                    rows: ':visible'
                },
                action: function(e, dt, button, config) {
                    datatable_sum_payment(dt, true);
                    $.fn.dataTable.ext.buttons.csvHtml5.action.call(this, e, dt, button, config);
                    datatable_sum_payment(dt, false);
                },
                footer:true
            },
            {
                extend: 'print',
                text: '{{trans("file.Print")}}',
                messageTop: function(){
                    return `
                        <div> 
                            <div style="display:flex;justify-content: center">
                                <div style="padding-right: 15px"> 
                                    <img src="{{url('public/logo', $general_setting->site_logo)}}" width="65">
                                </div>
                                <div> 
                                    <h4 style="text-align:left;color:red;">{{trans('file.Company name system')}}</h4> 
                                    <p style="text-align:left;color:red;">{{trans('file.Company address system')}}</p> 
                                </div>
                            </div>
                            <div style="text-align:center;">         
                                <br>                
                                <h3 style="text-transform: uppercase" class="modal-title text-center container-fluid">{{trans('file.Payment Report')}}</h3>
                                <p class="modal-title text-center container-fluid">{{trans('file.From date')}} {{date('d-m-Y', strtotime($start_date))}} {{trans('file.To date')}} {{date('d-m-Y', strtotime($end_date))}}</p>
                            </div>
                        </div>
                    
                    `;
                },
                exportOptions: {
                    columns: ':visible:Not(.not-exported-payment)',
                    rows: ':visible'
                },
                customize: function ( doc ) {
                    $(doc.document.body).find('table td').css('border', '1px solid #333333');
                    $(doc.document.body).find('table th').css({'border': '1px solid #333333', "text-align": "center"});
                    $(doc.document.body).find('table td:nth-child(1)').css({'text-align': 'center'});
                    $(doc.document.body).find('table td:nth-child(5)').css({'text-align': 'right'});
                    $(doc.document.body).find('table td:nth-child(4)').css({'text-align': 'right'});
                },
                action: function(e, dt, button, config) {
                    datatable_sum_payment(dt, true);
                    $.fn.dataTable.ext.buttons.print.action.call(this, e, dt, button, config);
                    datatable_sum_payment(dt, false);
                },
                footer:true
            },
            {
                extend: 'colvis',
                columns: ':gt(0)'
            }
        ],
        drawCallback: function () {
            var api = this.api();
            datatable_sum_payment(api, false);
        }
    } );

    function datatable_sum_payment(dt_selector, is_calling_first) {
        if (dt_selector.rows( '.selected' ).any() && is_calling_first) {
            var rows = dt_selector.rows( '.selected' ).indexes();
            var column4Sum = 0;

            dt_selector.cells( rows, 4, { page: 'current' }).data().each(function(value) {
                column8Sum += parseFloat(value.replace(/\./g, ""));
            });

            $( dt_selector.column( 4 ).footer() ).html(column4Sum.toFixed(0).replace(/(\d)(?=(\d{3})+(?!\d))/g, "$1."));
        }
        else {
            var column4Sum = 0;

            dt_selector.column(4, { page: 'current' }).data().each(function(value) {
                column4Sum += parseFloat(value.replace(/\./g, ""));
            });

            $( dt_selector.column( 4 ).footer() ).html(column4Sum.toFixed(0).replace(/(\d)(?=(\d{3})+(?!\d))/g, "$1."));
        }
    }

    $('#return-table').DataTable( {
        "order": [],
        "createdRow": function( row, data, dataIndex ) {
            $('td', row).css( "border", "1px solid #333333" );
        },
        'columnDefs': [
            {
                "orderable": false,
                'targets': [1, 2, 3, 4, 5, 6, 7, 8]
            },
            {
                'render': function(data, type, row, meta){
                    if(type === 'display'){
                        data = '<div class="checkbox"><input type="checkbox" class="dt-checkboxes"><label></label></div>';
                    }

                   return data;
                },
                'checkboxes': {
                   'selectRow': true,
                   'selectAllRender': '<div class="checkbox"><input type="checkbox" class="dt-checkboxes"><label></label></div>'
                },
                'targets': [0]
            }
        ],
        'select': { style: 'multi',  selector: 'td:first-child'},
        'lengthMenu': [[10, 25, 50, -1], [10, 25, 50, "All"]],
        dom: '<"row"lfB>rtip',
        buttons: [
            {
                extend: 'pdf',
                text: '{{trans("file.PDF")}}',
                exportOptions: {
                    columns: ':visible:Not(.not-exported-return)',
                    rows: ':visible'
                },
                action: function(e, dt, button, config) {
                    datatable_sum_return(dt, true);
                    $.fn.dataTable.ext.buttons.pdfHtml5.action.call(this, e, dt, button, config);
                    datatable_sum_return(dt, false);
                },
                footer:true
            },
            {
                extend: 'csv',
                charset: 'UTF-8',
                bom: true, 
                text: '{{trans("file.CSV")}}',
                exportOptions: {
                    columns: ':visible:Not(.not-exported-return)',
                    rows: ':visible'
                },
                action: function(e, dt, button, config) {
                    datatable_sum_return(dt, true);
                    $.fn.dataTable.ext.buttons.csvHtml5.action.call(this, e, dt, button, config);
                    datatable_sum_return(dt, false);
                },
                footer:true
            },
            {
                extend: 'print',
                text: '{{trans("file.Print")}}',
                messageTop: function(){
                    return `
                        <div> 
                            <div style="display:flex;justify-content: center">
                                <div style="padding-right: 15px"> 
                                    <img src="{{url('public/logo', $general_setting->site_logo)}}" width="65">
                                </div>
                                <div> 
                                    <h4 style="text-align:left;color:red;">{{trans('file.Company name system')}}</h4> 
                                    <p style="text-align:left;color:red;">{{trans('file.Company address system')}}</p> 
                                </div>
                            </div>
                            <div style="text-align:center;">         
                                <br>                
                                <h3 style="text-transform: uppercase" class="modal-title text-center container-fluid">{{trans('file.Return Report')}}</h3>
                                <p class="modal-title text-center container-fluid">{{trans('file.From date')}} {{date('d-m-Y', strtotime($start_date))}} {{trans('file.To date')}} {{date('d-m-Y', strtotime($end_date))}}</p>
                            </div>
                        </div>
                    
                    `;
                },
                exportOptions: {
                    columns: ':visible:Not(.not-exported-return)',
                    rows: ':visible',
                    stripHtml: false

                },
                customize: function ( doc ) {
                    $(doc.document.body).find('table td').css('border', '1px solid #333333');
                    $(doc.document.body).find('table th').css({'border': '1px solid #333333', "text-align": "center"});
                    $(doc.document.body).find('table td:nth-child(1)').css({'text-align': 'center'});
                    $(doc.document.body).find('table td:nth-child(6)').css({'text-align': 'center'});
                    $(doc.document.body).find('table td:nth-child(4)').css({'text-align': 'right'});
                    $(doc.document.body).find('table td:nth-child(7)').css({'text-align': 'right'});
                    $(doc.document.body).find('table td:nth-child(8)').css({'text-align': 'right'});
                },
                action: function(e, dt, button, config) {
                    datatable_sum_return(dt, true);
                    $.fn.dataTable.ext.buttons.print.action.call(this, e, dt, button, config);
                    datatable_sum_return(dt, false);
                },
                footer:true
            },
            {
                extend: 'colvis',
                columns: ':gt(0)'
            }
        ],
        drawCallback: function () {
            var api = this.api();
            datatable_sum_return(api, false);
        }
    } );

    function datatable_sum_return(dt_selector, is_calling_first) {
        if (dt_selector.rows( '.selected' ).any() && is_calling_first) {
            var rows = dt_selector.rows( '.selected' ).indexes();
            var column7Sum = 0;
            var column8Sum = 0;

            dt_selector.cells( rows, 7, { page: 'current' }).data().each(function(value) {
                column7Sum += parseFloat(value.replace(/\./g, ""));
            });
            dt_selector.cells( rows, 8, { page: 'current' }).data().each(function(value) {
                column8Sum += parseFloat(value.replace(/\./g, ""));
            });

            $( dt_selector.column( 7 ).footer() ).html(column7Sum.toFixed(0).replace(/(\d)(?=(\d{3})+(?!\d))/g, "$1."));
            $( dt_selector.column( 8 ).footer() ).html(column8Sum.toFixed(0).replace(/(\d)(?=(\d{3})+(?!\d))/g, "$1."));
        }
        else {
            var column7Sum = 0;
            var column8Sum = 0;

            dt_selector.column(7, { page: 'current' }).data().each(function(value) {
                column7Sum += parseFloat(value.replace(/\./g, ""));
            });
            dt_selector.column(8, { page: 'current' }).data().each(function(value) {
                column8Sum += parseFloat(value.replace(/\./g, ""));
            });

            $( dt_selector.column( 7 ).footer() ).html(column7Sum.toFixed(0).replace(/(\d)(?=(\d{3})+(?!\d))/g, "$1."));
            $( dt_selector.column( 8 ).footer() ).html(column8Sum.toFixed(0).replace(/(\d)(?=(\d{3})+(?!\d))/g, "$1."));
        }
    }

    $(".daterangepicker-field").daterangepicker({
        callback: function(startDate, endDate, period){
            var start_date = startDate.format('YYYY-MM-DD');
            var end_date = endDate.format('YYYY-MM-DD'); 

            var display_start_date = startDate.format('DD-MM-YYYY');
            var display_end_date = endDate.format('DD-MM-YYYY');  
            var title = display_start_date + ' To ' + display_end_date;
            $(this).val(title);
            $('input[name="start_date"]').val(start_date);
            $('input[name="end_date"]').val(end_date);
        }
    });

    $('#daterangepicker-change-date').on("change", function(){
        var date_value = $(this).val();
        var arrDate = (date_value.trim()).split("To")

        var start = arrDate[0].trim().split("-")
        var end = arrDate[1].trim().split("-")
        var start_date = start[2] + '-' + start[1] + '-' + start[0]
        var end_date = end[2] + '-' + end[1] + '-' + end[0]

        $('input[name="start_date"]').val(start_date);
        $('input[name="end_date"]').val(end_date);
    }); 

</script>
@endsection