@foreach ($courier_orders as $data)

Bilesma Natural | 071-1984331

@php $sale_id = $data['sale_id']; $sale = \Illuminate\Support\Facades\DB::table('sales') ->where('sales.id', $sale_id) ->leftjoin('contacts', 'sales.contact_id', '=', 'contacts.id') ->leftjoin('districts', 'contacts.district_id', '=', 'districts.id') ->leftjoin('cities', 'contacts.city', '=', 'cities.id') ->select('sales.*', 'contacts.*', 'districts.name_en as districtName', 'cities.name_en as cityName') ->first(); $item_names = \Illuminate\Support\Facades\DB::table('sale_items') ->join('products', 'sale_items.product_id', '=', 'products.id') ->where('sale_id', $sale_id) ->where('sale_items.deleted_at', null) ->get(); @endphp
Name {!! $sale->name !!}
Address {!! $sale->landmark !!} / {!! $sale->cityName !!}
District {!! $sale->districtName !!}
Tele {!! $sale->mobile !!} @if (!empty($sale->mobile_2)) / {!! $sale->mobile_2 !!} @endif
Items @foreach ($item_names as $item) {{ $item->product_name }} -{{ $item->qty }}/ @endforeach
COD {!! number_format($sale->invoice_nettotal, 2) !!}
{{ Carbon\Carbon::parse($sale->created_at)->format('Y-m-d') }}

barcode
{{ $sale->waybill_prefix . $sale->waybill_no . $sale->waybill_postfix }}
@if (!$loop->last)
@endif @endforeach