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

        // dd($order->toArray());
    @endphp
    <form method="post" action='/reports/orders'>
        @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>Order Reports</p>
          </div>
        </div>
        <div class="col-md-6">
          <div class="text-right">
            <button type="button" class="btn btn-danger mr-2" id="orderExport">Download</button>
          </div>
        </div>
        <div class="col-md-12">
          <div class="table-responsive">
            <table class="table table-striped " id="reportDataTable">
                {{-- <table class="table table-striped" id="codStatementDataTables"> --}}

              <thead>
                <tr>
                  <th scope="col">S.No</th>
                  <th scope="col">Order Id </th>
                  <th scope="col">Order Creation Date</th>
                  <th scope="col">Order Creation <br> Date & Time</th>
                  <th scope="col">AWB No.</th>
                  {{-- <th scope="col">AWB No. Date & Time Stamp</th> --}}
                  <th scope="col">Manifest Date & Time Stamp</th>
                  <th scope="col">Customer Details <br>(Name, Email, Phone No.) </th>
                  <th scope="col">Customer Address</th>
                  <th scope="col">Product Details
                    Product Name- SKU - Quantity </th>
                    <th scope="col">Volumetric Weight</th>
                  <th scope="col">Actual Weight</th>
                  <th scope="col">Chargable Weight (Customer)</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">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>
                  <th scope="col">RTO reference docket</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 = $("#reportDataTable").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('/report') }}",
            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: 'created_at',
                name: 'created_at',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            // {
            //     data: 'created_at_time',
            //     name: 'created_at_time',
            //     searchable: true,
            //     orderable: false,
            //     defaultContent: 'NA'
            // },
            {
                data: 'created_at_time',
                name: 'created_at_time',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'docket_no',
                name: 'docket_no',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },

            {
                data: 'manifest_generated_on',
                name: 'manifest_generated_on',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'customer_details',
                name: 'customer_details',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'toAddress',
                name: 'toAddress',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'products',
                name: 'products',
                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: '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 date',
                name: 'Shipment Claim date',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            },
            {
                data: 'docket_no',
                name: 'docket_no',
                searchable: true,
                orderable: false,
                defaultContent: 'NA'
            }
        ],
        select: {
            style: 'multi',
        },
    });

    $('#orderExport').click(function() {

         window.location = "{{route('order-report-exports')}}";

         // window.location = "{{route('order-table-export')}}?date="+date+"&continent_name="+continent_name+"&origin="+origin+"&origin_both="+origin_both+"&pod="+pod+"&pod_both="+pod_both+"&location1="+location1+"&location3="+location3+"&uploader_id="+uploader_id;
                       
            return;
    });

    });
</script>
@endsection