@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) ->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(); @endphp
Order No :{{ $sale->invoice_no }}
To
order_sale_note != '1') style="display: none" @endif>
Name : {!! $sale->name !!}
Address : {!! $sale->landmark !!} , @if ($sale->cityName != 'Other') {!! $sale->cityName !!} , @endif
Sale Note :
{!! $sale->sale_note !!}
Contact No : {!! $sale->mobile !!} @if (!empty($sale->mobile_2)) {!! $sale->mobile_2 !!} @endif
@if ($setting->name == 'Quickly.lk')
Product Details
@foreach ($item_names as $item) @php $second_value = \Illuminate\Support\Facades\DB::table('stocks') ->join( 'attribute_values', 'stocks.second_attribute_value_id', '=', 'attribute_values.id', ) ->where('product_id', $item->product_id) ->first(); @endphp {{ $item->product_name }} - {{ $item->sku }} {{ !empty($item->attribute_value) ? '- ' . $item->attribute_value : ' ' }} {{ !empty($second_value->value) ? '- ' . $second_value->value : ' ' }} x {{ $item->qty }} / @endforeach
@else
From
@if ($setting->is_enable_sale_items_for_waybill) @endif
Name : {{ $setting->name }}
Address : {{ $setting->landmark }} , {{ $setting->landmark_2 }} , @if ($city) {{ $city->name_en }} @endif
Contact No : {{ $setting->mobile }}
Parcel Desc : @foreach ($item_names as $item) @php $second_value = \Illuminate\Support\Facades\DB::table('stocks') ->join('attribute_values', 'stocks.second_attribute_value_id', '=', 'attribute_values.id') ->where('product_id', $item->product_id) ->first(); @endphp {{ $item->product_name }} {{ !empty($item->attribute_value) ? '- ' . $item->attribute_value : ' ' }} {{ !empty($second_value->value) ? '- ' . $second_value->value : ' ' }} x {{ $item->qty }} / @endforeach
@endif
@if ($sale->payment_status == 'due') COD : {!! number_format($sale->invoice_nettotal, 2) !!} @if (!empty($sale->currency_type)) {{ $sale->currency_type == 'usd' ? '$' : ' LKR' }} @else LKR @endif @elseif ($sale->payment_status == 'partial') Balance : {!! number_format($sale->invoice_balance, 2) !!} @if (!empty($sale->currency_type)) {{ $sale->currency_type == 'usd' ? '$' : ' LKR' }} @else LKR @endif @else @if ($setting->name == 'Quickly.lk') @else FREE @endif @endif

barcode
{{ $sale->waybill_prefix . $sale->waybill_no . $sale->waybill_postfix }}
@endforeach