@foreach ($courier_orders as $data)

Biz 99 Pvt Ltd
206/A/1/1, Lake Road, Boralesgamuwa.
071 700 1717

@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 !!} --}}
Mobile No {!! $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