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

        //    dd($user->toArray());
    @endphp
    <form method="post" action='/reports/shipments'>
        @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>Shipment Reports</p>
          </div>
        </div>
        <div class="col-md-6">
          <div class="text-right">
            <button type="button" class="btn btn-danger mr-2" id="shipmentExport">Download</button>
          </div>
        </div>
        <div class="col-md-12">
          <div class="table-responsive">
            <table class="table table-striped "id="shipmentDataTable">

              <thead>
                <tr>
                  <th scope="col">S.No</th>
                  <th scope="col">Order Id </th>
                  <th scope="col">AWB No.</th>
                  <th scope="col">AWB Date & Time Stamp </th>
                  <th scope="col">Shipper Invoice No. </th>
                  <th scope="col">Shipper Ref No.</th>
                  <th scope="col">Shipper Invoice value</th>
                  <th scope="col">Volumetric Weight Dimension </th>
                  <th scope="col">Actual Weight </th>
                  <th scope="col">Chargable Weight (Customer)</th>
                  <th scope="col">Chargable Weight (Carrier)</th>
                  <th scope="col">Additional weight</th>
                  <th scope="col">Booked Freight Amount</th>
                  <th scope="col">Additional Freight </th>
                  <th scope="col">Total Freight</th>
                  <th scope="col">LSP Name</th>
                  {{-- <th scope="col">Total Freight</th>
                  <th scope="col">LSP Name </th> --}}
                  <th scope="col">Schedule Pickup Date& Time </th>
                  <th scope="col">Actual Pickup Date & Time</th>
                  <th scope="col">LSP Payment Term</th>
                  <th scope="col">Shipment Type</th>
                  <th scope="col">COD Amount</th>
                  <th scope="col">EDD( Expected Date of Delivery)</th>
                  <th scope="col">ADD( Actual Date & Time of Delivery)</th>
                  <th scope="col">Receiver Name</th>
                  <th scope="col">Receiver Contact Number </th>
                  <th scope="col">Last Shipment Status</th>
                  <th scope="col">Last Status Date & Time</th>
                  <th scope="col">Shipment Insurance</th>
                  <th scope="col">Delivery Qyality</th>
                  <th scope="col">POD</th>
                  <th scope="col">Shipment Performance</th>
                  <th scope="col">Delay Remarks 1</th>
                  <th scope="col">Delay Remarks 2</th>
                  <th scope="col">Sending Zone</th>
                  <th scope="col">Sending Location</th>
                  <th scope="col">Sending pin code</th>
                  <th scope="col">Receiving Zone</th>
                  <th scope="col">Receiving location</th>
                  <th scope="col">Receiving Pin code</th>
                  <th scope="col">Mode of Shipment</th>
                  <th scope="col">Shipment Claim Status</th>
                  <th scope="col">Claim Settlement Date</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 = $("#shipmentDataTable").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('/shipmentReport') }}",
            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: 'docket_no',
                name: 'docket_no',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'created_at_time',
                name: 'created_at_time',
                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_Invoice_value',
                name: 'Shipper_Invoice_value',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'volumetric_weight',
                name: 'volumetric_weight',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'package_weight',
                name: 'package_weight',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'weight_disc_charges',
                name: 'weight_disc_charges',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Chargable_Weight_(Carrier)',
                name: 'Chargable_Weight_(Carrier)',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'base_charges',
                name: 'base_charges',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Booked_Freight',
                name: 'Booked_Freight',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Additional',
                name: 'Additional',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Total',
                name: 'Total',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'lsp_name',
                name: 'lsp_name',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'lsp_pickup_scheduled_date',
                name: 'lsp_pickup_scheduled_date',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'pickup_expected_date',
                name: 'pickup_expected_date',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'lsppayment',
                name: 'lsppayment',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'category_id',
                name: 'category_id',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'payment',
                name: 'payment',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'edd',
                name: 'edd',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'add',
                name: 'add',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'recevier',
                name: 'recevier',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'recevier_contact',
                name: 'recevier_contact',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'product_status',
                name: 'product_status',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'updated_at',
                name: 'updated_at',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'is_insured',
                name: 'is_insured',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'qualty',
                name: 'qualty',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'POD',
                name: 'POD',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: '	Shipment Performance',
                name: '	Shipment Performance',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: '	Delay Remarks  1',
                name: '	Delay Remarks  1',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: '	Delay Remarks  2',
                name: '	Delay Remarks  2',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Sending_Zone',
                name: 'Sending_Zone',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Sending_Location',
                name: 'Sending_Location',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Sending_pincode',
                name: 'Sending_pincode',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Receiving_Zone',
                name: 'Receiving_Zone',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Receiving_location',
                name: 'Receiving_location',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Receiving_Pincode',
                name: 'Receiving_Pincode',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Mode_of_Shipment',
                name: 'Mode_of_Shipment',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Shipment Claim Status',
                name: 'Shipment Claim Status',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'Shipment Claim Status',
                name: 'Shipment Claim Status',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            }




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

</script>
@endsection