@php

    $status_indexes = array("area", "zone", "available", "available_location", "pre_confirmation", "customer_confirmation", "interchange_no",

    "inter_change_location", "serial_no", "inv_bill_no", "interchange_rcved", "qc", "packed_by", "delivery_date", "vehicle", "delivery_complete",

    "undelivery", "re_delivery_schedule", "re_delivery_complete", "bill_void");

    $status_values = array(

    array("type" => "yesno", "column_name" => "shipping_area_threes.shipping_area_three_name", "heading" => "1. Area", "data" => array("No data", "Data given"), "data_count" => array(0, 0)),

    array("type" => "yesno", "column_name" => "inv_zones.inv_zone_name", "heading" => "2. Zone", "data" => array("No data", "Data given"), "data_count" => array(0, 0)),

    array("type" => "exactval", "column_name" => "orders_deliveries.available", "heading" => "3. Available", "data" => array("No data"), "data_count" => array(0)),

    array("type" => "yesno", "column_name" => "orders_deliveries.available_locations", "heading" => "4. Available Location", "data" => array("No data", "Data given"), "data_count" => array(0, 0)),

    array("type" => "rawval", "column_name" => "orders_deliveries.pre_confirmation", "heading" => "5. Order Confirmation", "data" => array("No data"), "data_count" => array(0), "raw_val" => array('')),

    array("type" => "exactval", "column_name" => "orders_deliveries.customer_confirmation", "heading" => "6. Payment Method", "data" => array("No data"), "data_count" => array(0)),

    array("type" => "exactval", "column_name" => "orders_deliveries.qc_passed", "heading" => "7. Payment Confirmation", "data" => array("No data"), "data_count" => array(0)),

    array("type" => "yesno", "column_name" => "orders_deliveries.inter_change_locations", "heading" => "8. Interchange Location", "data" => array("No data", "Data given"), "data_count" => array(0, 0)),

    array("type" => "yesno", "column_name" => "orders_deliveries.inter_change_no", "heading" => "9. Interchange#", "data" => array("No data", "Data given"), "data_count" => array(0, 0)),

    array("type" => "yesno", "column_name" => "orders_deliveries.serial_no", "heading" => "10. Serial#", "data" => array("No data", "Data given"), "data_count" => array(0, 0)),

    array("type" => "yesno", "column_name" => "orders_deliveries.inv_bill_no", "heading" => "11. Inv Bill#", "data" => array("No data", "Data given"), "data_count" => array(0, 0)),

    array("type" => "rawval", "column_name" => "orders_deliveries.inter_received", "heading" => "12. Interchange Received", "data" => array("No data"), "data_count" => array(0), "raw_val" => array('')),

    array("type" => "yesno", "column_name" => "orders_deliveries.packed_by", "heading" => "13. Packed By", "data" => array("No data", "Data given"), "data_count" => array(0, 0)),

    array("type" => "yesno", "column_name" => "orders_deliveries.delivery_date", "heading" => "14. Shipping Date", "data" => array("No data", "Data given"), "data_count" => array(0, 0)),

    array("type" => "yesno", "column_name" => "orders_deliveries.vehicle", "heading" => "15. Vehicle", "data" => array("No data", "Data given"), "data_count" => array(0, 0)),

    array("type" => "rawval", "column_name" => "orders_deliveries.delivery_complete", "heading" => "16. Delivery Complete", "data" => array("No data"), "data_count" => array(0), "raw_val" => array('')),

    array("type" => "exactval", "column_name" => "orders_deliveries.undelivery", "heading" => "17. Undelivery", "data" => array("No data"), "data_count" => array(0), "blank_data" => 0),

    array("type" => "yesno", "column_name" => "orders_deliveries.re_delivery_schedule", "heading" => "18. Re Delivery Schedule", "data" => array("No data", "Data given"), "data_count" => array(0, 0), "blank_data" => 0),

    array("type" => "rawval", "column_name" => "orders_deliveries.re_delivery_complete", "heading" => "19. Re Delivery Complete", "data" => array("No data"), "data_count" => array(0), "raw_val" => array(''), "blank_data" => 0),

    array("type" => "rawval", "column_name" => "orders_deliveries.bill_void", "heading" => "20. Bill Void", "data" => array("No data"), "data_count" => array(0), "raw_val" => array(''), "blank_data" => 0),

    );

@endphp

<table class="table table-bordered table-striped" id="order_delivery_list_table">

    <thead>

    <tr>

        <th>ID</th>

        <th>Name</th>

        <th>Contact</th>

        <th>Reg Date</th>

        <th>Shipping No</th>

        <th>Area</th>

        <th>Zone</th>

        <th>Last Order Id</th>

        <th>Last Order Date</th>

        <th>Total Orders</th>

        <th>Total Order Amount</th>

        <th style="width: 40px;">Action</th>

    </tr>

    </thead>

    <tbody>

    @php($order_total=0)

    @php($shipping_cost_total=0)

    @foreach($ordersDeliveries as $order_delivery)
        @php($bgcolor = str_contains($order_delivery->shipping_type_name,"Express") ? 'yellow' : '' )

        
        <tr>
            <td bgcolor="{{ $bgcolor }}">{{ $order_delivery->cus_id }}</td>

            <td bgcolor="{{ $bgcolor }}">{{ $order_delivery->shipping_name }}</td>

            <td bgcolor="{{ $bgcolor }}">{{ $order_delivery->customer_id_contact }}</td>

            <td bgcolor="{{ $bgcolor }}">{{ date('M d, Y h:i a', strtotime($order_delivery->cus_created_at)) }}</td>

            <td bgcolor="{{ $bgcolor }}">{{ $order_delivery->shipping_contact }}</td>

            <td bgcolor="{{ $bgcolor }}">{{ $area }}</td>

            <td bgcolor="{{ $bgcolor }}">{{ $zone }}</td>

            <td bgcolor="{{ $bgcolor }}"><a href="{{url('/admin/orders/'.$order_delivery->last_order_id)}}" target="_blank">{{ $order_delivery->last_order_id }}</a></td>

            <td bgcolor="{{ $bgcolor }}">{{ date('M d, Y h:i a', strtotime($order_delivery->last_order_date)) }}</td>

            <td bgcolor="{{ $bgcolor }}">{{ $order_delivery->total_orders }}</td>

            <td bgcolor="{{ $bgcolor }}">{{ $order_delivery->total_order_amount }}</td>

            <td bgcolor="{{ $bgcolor }}">

                {{-- <a type="button" rel="noreferrer"  class="btn btn-xs btn-primary" style="margin-top: 2px; width: 50px; text-align: center;"

                    target="_blank" data-toggle="modal" data-target="#myModal"><i

                            class="fa fa-eye"></i> View</a> --}}
                            <button type="button" class="btn btn-xs btn-primary" onclick="fetchData({{ $order_delivery->cus_id }}, '{{ $fromDate }}', '{{ $toDate }}')">
                                <i class="fa fa-eye"></i> View
                            </button>

            </td>

        </tr>

        <div class="modal fade" id="myModal_{{$order_delivery->cus_id}}" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
            <div class="modal-dialog" role="document">
              <div class="modal-content">
                <div class="modal-header">
                  <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                  <h4 class="modal-title" id="myModalLabel">{{ $order_delivery->shipping_name }} - {{ $order_delivery->shipping_contact }}</h4>
                </div>
                <div class="modal-body">
                    {{ $order_delivery->shipping_name }}
                </div>
                <div class="modal-footer">
                  <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                </div>
              </div>
            </div>
          </div>

    @endforeach

    </tbody>

</table>

dataseparator

@php($blank_data_count=0)

@if(count($ordersDeliveries)>0)

    <div class="row">

        <div class="col-md-12">

            @for($i=0; $i<count($status_values); $i++)

                @if($i==0)

                    <b>{{$status_values[$i]["heading"] }}: </b>{{$status_values[$i]["data_count"][0]}},

                    @php($blank_data_count += intval($status_values[$i]["data_count"][0]))

                @else

                    @if($status_values[$i]["heading"] == 'Undelivery' or $status_values[$i]["heading"] == 'Re Delivery Schedule' or $status_values[$i]["heading"] == 'Re Delivery Complete' or $status_values[$i]["heading"] == 'Bill Void')

                        <b>{{ $status_values[$i]["heading"] }}: </b>{{$status_values[$i]["blank_data"]}},

                        @php($blank_data_count += intval($status_values[$i]["blank_data"]))

                    @else

                        <b>{{ $status_values[$i]["heading"] }}: </b>{{intval($status_values[$i]["data_count"][0]) - intval($status_values[$i-1]["data_count"][0])}},

                        @php($blank_data_count += intval($status_values[$i]["data_count"][0]) - intval($status_values[$i-1]["data_count"][0]))

                    @endif

                @endif

            @endfor

        </div>

    </div>

@endif

blank_data_count_separator{{ $blank_data_count }}

dataseparator

<div class="row">

    <div class="col-md-12" style="margin-bottom: 10px;">Total Data: <span

                style="color: red; font-weight: bold;">{{ count($ordersDeliveries) }}</span></div>

</div>

@if(count($ordersDeliveries)>0)

    <div class="row">

        @php($count = 1)

        @foreach($status_values as $status_value)

            <div class="col-md-3">

                <div class="box" style="min-height: 142px; box-shadow: none;">

                    <div class="box-header with-border">

                        <h6 class="box-title"

                            style="font-size: 14px; font-weight: bold;">{{ $status_value["heading"] }}</h6>

                    </div>

                    <div class="box-body">

                        <ol class="report-statistic-list">

                            @for($i=0; $i<count($status_value["data"]); $i++)

                                @if($status_value["data_count"][$i] == '0')

                                    @continue

                                @endif

                                
                                <li class="status_link" style="cursor: pointer;"

                                    onclick="search_from_status('{!! $status_value["column_name"] !!}', '{!! $data_search !!}')">{!! $status_value["data"][$i] . ' (<span style="color: red;">' . $status_value["data_count"][$i] . '</span>)' !!}</li>

                            @endfor

                        </ol>

                    </div>

                </div>

            </div>



            @if($count == 4)

                <div class="clearfix"></div>

                @php($count = 0)

            @endif

            @php($count++)

        @endforeach

    </div>

@endif

dataseparator{{ number_format($order_total) }}dataseparator{{ number_format($shipping_cost_total) }}