@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 }}
{{ $courier->email }}/{{ $courier->landline }}
 }})
{{ $sale->waybill_prefix . $sale->waybill_no . $sale->waybill_postfix }}
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
|
Pacakage Desription
@foreach ($item_names as $item)
{{ $item->product_name }} - {{ $item->qty }}
@endforeach
|
Total Value :
{!! number_format($sale->invoice_nettotal, 2) !!} LKR
|