Bill

@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) ->join('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(); $courier = \App\Courier::find($sale->courier); @endphp

{{ $courier->name }}

{{-- add / in checking email have or not --}} @if ($courier->email && $courier->landline) {{ $courier->email }} / {{ $courier->landline }} @elseif ($courier->email || $courier->landline) {{ $courier->email ?: $courier->landline }}
@else
@endif

{{ $sale->full_waybill_no }}

Sender

Name :	{!! $setting->name !!}
Address :	{!! $setting->landmark !!} , {!! $setting->landmark_2 !!} , @if ($city) {{ $city->name_en }} @endif
Contact No :	{!! $setting->mobile !!}

Receiver

Name :	{!! $sale->name !!}
Address :	{!! $sale->landmark !!} ,
City :	{!! $sale->districtName !!}
Contact No :	{!! $sale->mobile !!} @if (!empty($sale->mobile_2)) / {!! $sale->mobile_2 !!} @endif

Package Desription

Total Value : {!! number_format($sale->invoice_nettotal, 2) !!} LKR

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