Bill

@foreach ($courier_orders as $data) @php $setting = App\Setting::first(); $city = \App\City::where('id', $setting->city)->first(); $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 {{-- --}}

{{ $setting->name }}
{{-- {{ $setting->landmark }} , {{ $setting->landmark_2 }} , @if ($city) {{ $city->name_en }} @endif --}} {{--
--}} {{ $setting->mobile }}
{{ Carbon\Carbon::parse($sale->waybill_printed_date)->format('Y-m-d') }}

Name :-

{!! $sale->name !!}

Address :-

{!! $sale->landmark !!} / {!! $sale->cityName !!}

Contact :-

{!! $sale->mobile !!} @if (!empty($sale->mobile_2)) / {!! $sale->mobile_2 !!} @endif

Oder ID :-

{!! $sale->invoice_no !!}

Product Name :-

@foreach ($item_names as $item) {{ $item->product_name }} - {{ $item->qty }}/ @endforeach

COD :-

{!! number_format($sale->invoice_nettotal, 2) !!}

{{ $sale->waybill_prefix . $sale->waybill_no . $sale->waybill_postfix }}

@if (!$loop->last)

@endif @endforeach