@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" => "3. Available Location", "data" => array("No data", "Data given"), "data_count" => array(0, 0)),

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

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

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

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

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

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

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

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

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

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

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

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

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

    array("type" => "yesno", "column_name" => "orders_deliveries.re_delivery_schedule", "heading" => "17. 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" => "18. 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" => "19. 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 style="width: 40px;">Action</th>

        <th>FSP</th>

        <th>Order#</th>

        <th>OrderDate</th>

        <th>Total</th>

        <th>Product&nbsp;ID</th>

        <th>Contact#</th>

        <th>Shipping.Method</th>

        <th>1.Area</th>

        <th>2.Zone</th>

        {{-- <th>3.Available</th> --}}

        <th>3.Av.Loc</th>

        <th>4.Cust.Confirm.</th>

        <th>5.Pay.Method.</th>

        <th>6.Pay.Confirm.</th>

        <th>7.Int.Loc</th>

        <th>8.Int.#</th>

        <th>9.Serial#</th>

        <th>10.InvBill#</th>

        <th>11.Int.Rcved.</th>

        <th>12.Packed_by</th>

        <th>13.SippingDate</th>

        <th>14.Vehicle</th>

        <th>15.Deliv.Complete</th>

        <th>16.Undelivery</th>

        <th>17.Re.Deliv.Sched.</th>

        <th>18.Re.Deliv.Complete</th>

        <th>19.BillVoid</th>

        <th>Note</th>

        <th>Delivery Type</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 }}">

                <a  rel="noreferrer"  class="btn btn-xs btn-warning" style="width: 50px; text-align: center;" target="_blank"

                   href="{{ route('order-deliveries.edit', $order_delivery->id) }}"><i class="fa fa-edit"></i> Edit</a>

                <br>

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

                   href="{{ url('admin/order-deliveries/' . $order_delivery->id) }}" target="_blank"><i

                            class="fa fa-eye"></i> View</a>

            </td>

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

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

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

            <td bgcolor="{{ $bgcolor }}">{{ number_format($order_delivery->grand_total, 0) }}</td>

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

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


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


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

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

            {{-- <td bgcolor="{{ $bgcolor }}">{{ $available }}</td> --}}

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            <td bgcolor="{{ $bgcolor }}">{{ $delivery_complete_note }}</td>
            <td bgcolor="{{ $bgcolor }}">{!! $order_delivery->shipping_type_name !!}</td>
        </tr>

    @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) }}