@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 @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' : '' ) @endforeach
Action FSP Order# OrderDate Total Product ID Contact# Shipping.Method 1.Area 2.Zone 3.Available 4.Av.Loc 5.Cust.Confirm. 6.Pay.Method. 7.Pay.Confirm. 8.Int.Loc 9.Int.# 10.Serial# 11.InvBill# 12.Int.Rcved. 13.Packed_by 14.SippingDate 15.Vehicle 16.Deliv.Complete 17.Undelivery 18.Re.Deliv.Sched. 19.Re.Deliv.Complete 20.BillVoid Note Delivery Type
{{-- Edit
--}} View
{{ $order_delivery->fsp_name }} {{ $order_delivery->order_id }} {{ date('M d, Y h:i a', strtotime($order_delivery->created_at)) }} {{ number_format($order_delivery->grand_total, 0) }} {{ $order_delivery->product_code_inv }} {{ $order_delivery->customer_id_contact }} {{ $shipping_method }} {{ $area }} {{ $zone }} {{ $available }} {{ $available_location }} {{ $pre_confirmation }} {{ $customer_confirmation }} {{ $qc_pass }} {{ $inter_change_location }} {{ $inter_change_no }} {{ $serial_no }} {{ $inv_bill_no }} {{ $inter_change_rcved }} {{ $packed_by }} {{ $shipping_date }} {{ $vehicle }} {{ $delivery_complete }} {{ $undelivery }} {{ $re_delivery_schedule }} {{ $re_delivery_complete }} {{ $bill_void }} {{ $delivery_complete_note }} {!! $order_delivery->shipping_type_name !!}
dataseparator @php($blank_data_count=0) @if(count($ordersDeliveries)>0)
@for($i=0; $i{{$status_values[$i]["heading"] }}: {{$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') {{ $status_values[$i]["heading"] }}: {{$status_values[$i]["blank_data"]}}, @php($blank_data_count += intval($status_values[$i]["blank_data"])) @else {{ $status_values[$i]["heading"] }}: {{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
@endif blank_data_count_separator{{ $blank_data_count }} dataseparator
Total Data:{{ count($ordersDeliveries) }}
@if(count($ordersDeliveries)>0)
@php($count = 1) @foreach($status_values as $status_value)
{{ $status_value["heading"] }}
    @for($i=0; $i{!! $status_value["data"][$i] . ' (' . $status_value["data_count"][$i] . ')' !!} @endfor
@if($count == 4)
@php($count = 0) @endif @php($count++) @endforeach
@endif dataseparator{{ number_format($order_total) }}dataseparator{{ number_format($shipping_cost_total) }} {{-- Modal --}} {{-- Modal --}}