@extends('layouts.app') @section('content') @if(session()->has('success'))
{{ session()->get('success') }}
@endif

Box Orders

@if(count($orders) > 0)
@csrf
@foreach($orders as $order)
{{ $order->box_number }}
{{ $order->order_number }}

    @foreach(App\OrderItem::where([['order_id', $order->order_id], ['product_type', 'simple']]) ->join('product_details', 'product_details.sku', 'order_items.sku') ->join('product_attributes', function ($join) { $join->on('product_attributes.product_id', '=', 'product_details.entity_id'); $join->where('product_attributes.key', '=', 'upc'); }) ->select('product_attributes.value as upc') ->get() as $key => $item)
  • {{ ($key+1) .') '.$item->upc }}
  • @endforeach
@endforeach

End Shift
@else
No record found
@endif
@endsection @section('right_sidebar') @endsection @section('script') @endsection