@extends('layout.master')
@section('content')
    @php

        //    dd($user->toArray());
    @endphp
    <form method="post" action='/reports/freight'>
        @csrf
<section class="content pb-5">
    <div class="container-fluid">

        <meta name="csrf-token" content="{!! csrf_token() !!}">


      <div class="row pt-4">
        <div class="col-md-6">
          <div class="title-section">
            <p>Freight Reports</p>
          </div>
        </div>
        <div class="col-md-12">
          <div class="text-right">
            <button type="button" class="btn btn-danger mr-2" id="freightExport">Download</button>
          </div>
        </div>
        <div class="col-md-12">
          <div class="table-responsive">
            <table class="table table-striped "id="FreightDataTable">
              <thead>
                <tr>
                  <th scope="col">S.No</th>
                  <th scope="col">Order Id </th>
                  <th scope="col">Movement type</th>
                  <th scope="col">AWB No.</th>
                  <th scope="col">Product Details </th>
                  <th scope="col">AWB Date</th>
                  <th scope="col">Shipper Invoice No. </th>
                  <th scope="col">Shipper Ref No.</th>
                  <th scope="col">Shipper name</th>
                  <th scope="col">Shipper Zone</th>
                  <th scope="col">Shipper location</th>
                  <th scope="col">Shipper pin code</th>
                  <th scope="col">Consigneed name</th>
                  <th scope="col">Consignee Zone</th>
                  <th scope="col">Consignee location</th>
                  <th scope="col">Consignee pin code</th>
                  <th scope="col">Total Boxes</th>
                  <th scope="col">Applied Weight (Customer)</th>
                  <th scope="col">Charged weight</th>
                  <th scope="col">Volume weight</th>
                  <th scope="col">Applied Weight (LSP)</th>
                  <th scope="col">Base freight Amount</th>
                  <th scope="col">Freight on value (FOV)</th>
                  <th scope="col">Fuel surcharge (FSC)</th>
                  <th scope="col">Docket Charge</th>
                  <th scope="col">COD Charges</th>
                  <th scope="col">Pick-up ODA</th>
                  <th scope="col">Delivery ODA</th>
                  <th scope="col">Green TaX</th>
                  <th scope="col">CAF (Currency adjustment factor)</th>
                  <th scope="col">RAS (Remote area surcharge)</th>
                  <th scope="col">ODC Charge (Odd Dimensional Cargo)</th>
                  <th scope="col">Union Charges</th>
                  <th scope="col">Unloading Charges</th>
                  <th scope="col">Other charge 1</th>
                  <th scope="col">Other Charge 2</th>
                  <th scope="col">Total Freight</th>
                  <th scope="col">SGST</th>
                  <th scope="col">CGST</th>
                  <th scope="col">IGST</th>
                  <th scope="col">Grand total</th>
                </tr>
            </thead>
            <tbody>
            </tbody>
          </table>
        </div>
      </div>
    </div>
  </div>
</form>
</section>
@endsection
@section('scripts')

<script src="https://checkout.razorpay.com/v1/checkout.js"></script>
<script>
let creditPaymentValue = 0;
let skuIdPaymentStatus = [];
$(document).ready(function() {

    let example = $("#FreightDataTable").DataTable({
        "language": {
            "zeroRecords": "No record(s) found."
        },
        select: {
            style: 'os',
            selector: 'td:first-child'
        },
        order: [
            [1, 'asc']
        ],
        processing: true,
        serverSide: true,
        lengthChange: true,
        order: [0, 'asc'],
        searchable: true,
        bStateSave: false,

        ajax: {
            url: "{{ url('/freightReport') }}",
            type: "POST",
            data: { 
                _token: "{{csrf_token()}}" 
            },
        },

        columns: [/*{
                data: 'checkbox',
                name: 'checkbox',
                sortable: false,
            },*/
            {
                data: 'DT_RowIndex',
                name: 'DT_RowIndex',
                sortable: false,
            },

            {
                data: 'order_no',
                name: 'order_no',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Mode_of_Shipment',
                name: 'Mode_of_Shipment',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },

            {
                data: 'docket_no',
                name: 'docket_no',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'products',
                name: 'products',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'created_at',
                name: 'created_at',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Shipper_InvoiceNo',
                name: 'Shipper_InvoiceNo',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Shipper Ref No.',
                name: 'Shipper Ref No.',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Shipper_name',
                name: 'Shipper_name',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Shipper_Zone',
                name: 'Shipper_Zone',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Receiving_location',
                name: 'Receiving_location',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Shipper_pin_code',
                name: 'Shipper_pin_code',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Consigneed_name',
                name: 'Consigneed_name',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Consignee_Zone',
                name: 'Consignee_Zone',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Consignee_location',
                name: 'Consignee_location',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Consignee_pincode',
                name: 'Consignee_pincode',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'total_box',
                name: 'total_box',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Applied_Weight',
                name: 'Applied_Weight',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'base_charges',
                name: 'base_charges',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Volume_weight',
                name: 'Volume_weight',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Applied_Weight_(LSP)',
                name: 'Applied_Weight_(LSP)',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Base_freight_Amount',
                name: 'Base_freight_Amount',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Freight_on_value_(FOV)',
                name: 'Freight_on_value_(FOV)',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Fuel_surcharge_(FSC)',
                name: 'Fuel_surcharge_(FSC)',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Docket_Charge',
                name: 'Docket_Charge',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            }


        ],
        select: {
            style: 'multi',
        },
    });
    $('#freightExport').click(function() {
                        window.location = "{{ route('freight-report-exports') }}";
                    });
});

</script>
@endsection