@extends('layouts.main', ['title' => 'LOGISTICS | Driver\'s Losses'])
@section('navigation')
    <ul class="breadcrumb">
        <li><a href="{{route('home')}}">Dashboard</a><span class="divider">/</span></li>
        <li class="active">Driver's Loss</li>
    </ul>
@stop
@section('title')
    Driver's Loss
@endsection

@section('contentinner')

    <div class="row-fluid">
        <div class="span12">
            <table style="width: 100%" class="table table-bordered logistics_table" id="operation_driver_losses">
                <thead>
                <tr>
                    <th width='5px'><input type="checkbox" class="checkall"/></th>
                    <th>D.O.N</th>
                    <th>Loading Date</th>
                    <th>Offloading Date</th>
                    <th>Truck</th>
                    <th>Commodity</th>
                    {{--<th>Loading</th>--}}
                    <th>Destination</th>
                    <th>Loaded QTY</th>
                    <th>Received QTY</th>
                    <th>Difference</th>
                    <th>Allowable</th>
                    <th>Excess/Loss</th>
                    <th>Deduction</th>
                    <th>Action</th>
                </tr>
                </thead>
                {{--*/ $total = 0 /*--}}
                {{--*/ $total_quantity =0 /*--}}
                {{--*/ $total_quantity_lossed =0 /*--}}
                {{--*/ $total_losses_amount =0 /*--}}
                {{--*/ $total_bonus_amount =0 /*--}}
                <tfoot>
                <tr>
                    <td colspan="8" style="text-align: right;font-size: 10px;line-height: 10px">TOTAL</td>
                    <td style="text-align: right"></td>
                    <td colspan="2"></td>
                    <td style="text-align: right"></td>
                    <td style="text-align: right">{{number_format($total_losses_amount,2)}}</td>
                    <td style="text-align: right">{{number_format($total_bonus_amount,2)}}</td>
                </tr>
                </tfoot>
            </table>
        </div><!--span12-->
    </div>
 
        <script>
            var mainDataTable = jQuery('#operation_driver_losses').on('error.dt', function (e, settings, techNote, message) {
                console.log('An error has been reported by DataTables: ', message);
                $.jGrowl("ERROR LOADING DATA!", {header: 'Important'});
                stopSpinner();
            })
                .DataTable({
                    "oLanguage": {
                        "sLoadingRecords": startSpinner(),
                        "sZeroRecords": "No Orders available.",
                        "sInfoEmpty": "No entries to display."
                    },
                    "initComplete": function (settings, json) {
                        stopSpinner();
                    },
                    ajax: {
                        url: "{{ route('driver_losses_management.all_losses.datatable',['driver_id'=>$driver->id]) }}",
                        data: function (d) {
                            d.search_field = $('input[name=search_field]').val();
                            d.truck_id = $('#truck_id').val();
                            d.client_id = $('#client_id').val();
                            d.starting_date = $('#starting_date').val();
                            d.end_date = $('#end_date').val();
                            d.cargo_types = $('#cargo_types').val();
                            d.driver_loss = $('#driver_loss').val();
                            d.driver_id = '{{$driver->id}}';
                            d.driver_loss_equation = $('#driver_loss_equation').val();
                        }
                    },
                    scrollCollapse: true,
                    "sPaginationType": "full_numbers",
                    processing: true,
                    serverSide: true,
                    "aoColumnDefs": [{
                        "aTargets": [7],
                        "fnCreatedCell": function (nTd, sData, oData, iRow, iCol) {
                            jQuery(nTd).css('text-align', 'right');
                            if ((sData == 0.00)) {
                                jQuery(nTd).addClass('highlight-red')
                            }
                        }
                    },{
                        "aTargets": [8],
                        "fnCreatedCell": function (nTd, sData, oData, iRow, iCol) {
                            jQuery(nTd).css('text-align', 'right');
                            if ((sData == 0.00)) {
                                jQuery(nTd).addClass('highlight-red')
                            }
                        }
                    },
                        {
                            "aTargets": [9],
                            "fnCreatedCell": function (nTd, sData, oData, iRow, iCol) {
                                jQuery(nTd).css('text-align', 'right');
                                if ((sData == 0.00)) {
                                    jQuery(nTd).addClass('highlight-red')
                                }
                            }
                        },
                        {
                            "aTargets": [10],
                            "fnCreatedCell": function (nTd, sData, oData, iRow, iCol) {
                                jQuery(nTd).css('text-align', 'right');
                                if ((sData == 0.00)) {
                                    jQuery(nTd).addClass('highlight-red')
                                }
                            }
                        },
                        {
                            "aTargets": [11],
                            "fnCreatedCell": function (nTd, sData, oData, iRow, iCol) {
                                jQuery(nTd).css('text-align', 'right');
                                if ((sData == 0.00)) {
                                    jQuery(nTd).addClass('highlight-red')
                                }
                            }
                        },
                        {
                            "aTargets": [12],
                            "fnCreatedCell": function (nTd, sData, oData, iRow, iCol) {
                                jQuery(nTd).css('text-align', 'right');
                                if ((sData == 0.00)) {
                                    jQuery(nTd).addClass('highlight-red')
                                }
                            }
                        }
                    ],
                    "columns": [
                        {
                            data: 'checkbox',
                            "class": "dt_checkbox",
                            "orderable": false
                        },
                        {"class": "link", data: 'route_assignment_id'},
                        {"class": "link", data: 'loading_date'},
                        {"class": "link", data: 'offload_date'},
                        {"class": "link", data: 'truck'},
                        {"class": "link", data: 'product'},
                        {"class": "link", data: 'destination'},
                        {"class": "link", data: 'loading_quantity'},
                        {"class": "link", data: 'offloading_quantity'},
                        {"class": "link", data: 'different_quantity'},
                        {"class": "link", data: 'allowable_loss'},
                        {"class": "link", data: 'driver_loss'},
                        {"class": "link", data: 'driver_loss_amount'},
                        {"class": "link", data: 'action'}
                    ],
                    "footerCallback": function (row, data, start, end, display) {
                        var api = this.api(), data;

                        // Remove the formatting to get integer data for summation
                        var intVal = function (i) {
                            return typeof i === 'string' ?
                                i.replace(/[\$,]/g, '') * 1 :
                                typeof i === 'number' ?
                                    i : 0;
                        };

                        // Total over all pages
                        total_amount = api
                            .column(8)
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);
                        total_amount_debit = api
                            .column(11)
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);
                        total_amount_credit = api
                            .column(12)
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);

    //                        total_paid_amount = api
    //                            .column(8)
    //                            .data()
    //                            .reduce(function (a, b) {
    //                                return intVal(a) + intVal(b);
    //                            }, 0);
    //                        total_paid_amount_balance = api
    //                            .column(11)
    //                            .data()
    //                            .reduce(function (a, b) {
    //                                return intVal(a) + intVal(b);
    //                            }, 0);

                        // Update footer
                        jQuery(api.column(8).footer()).html( total_amount.toLocaleString());
                        jQuery(api.column(11).footer()).html( total_amount_debit.toLocaleString());
                        jQuery(api.column(12).footer()).html( total_amount_credit.toLocaleString());
                        {{--jQuery(api.column(7).footer()).html('{{$total_invoice_amount['currency']}}  ' + total_paid_amount.toLocaleString());--}}
                        {{--jQuery(api.column(8).footer()).html('{{$total_invoice_amount['currency']}}  ' + total_paid_amount_balance.toLocaleString());--}}
                    },
                    "bStateSave": true
                });


            $('#operation_driver_losses tbody').on('dblclick', 'tr td.link', function () {
                var tr = $(this).closest('tr');
                var loading_order_vehicle_id = tr.find('.loading_order_destination_id').val();

                var url = "{{route('driver_managements.loading_order_destinations.driver_losses.print',[':id'])}}";
                url = url.replace(":id", loading_order_vehicle_id);
    //            window.open(url, '_blank');
                winClose=popupwindow(url, 'DRIVER LOSS',3508,4961);
            });
        </script>


@stop