@php
// ดึง order
if(Session::has('order_id')){
$order = DB::table('orders')->where('id', Session::get('order_id'))->first();
} else {
$order = isset($order->transaction_number)
? DB::table('orders')->where('transaction_number', $order->transaction_number)->first()
: null;
}
$Order_products_list = $order
? DB::table('order_products_lists as opl')
->leftJoin('items as i', 'opl.sku', '=', 'i.sku')
->leftJoin('brands as b', 'i.brand_id', '=', 'b.id')
->leftJoin('categories as c', 'i.category_id', '=', 'c.id')
->leftJoin('subcategories as sc', 'i.subcategory_id', '=', 'sc.id')
->leftJoin('chield_categories as cc', 'i.childcategory_id', '=', 'cc.id')
->where('opl.order_id_fk', $order->id)
->select(
'opl.*',
'i.brand_id',
'i.category_id',
'i.subcategory_id',
'i.childcategory_id',
'b.name as brand_name',
'c.name as category_name',
'sc.name as subcategory_name',
'cc.name as childcategory_name'
)
->get()
: collect();
$order_products_lists_free = $order
? DB::table('order_products_lists_free')->where('order_id_fk', $order->id)->get()
: collect();
@endphp
@if(Session::has('message'))
{{ Session::get('message') }}
@else
{{ __('Thank you for your order') }}
@endif
@if($order)
| {{ __('รูปสินค้า') }} |
{{ __('ชื่อสินค้า') }} |
{{ __('จำนวน') }} |
{{ __('ราคา/หน่วย') }} |
{{ __('ราคารวม') }} |
@foreach ($Order_products_list as $value)
|
SKU: {{ $value->sku }}
CODE: {{ $value->bar_code }}
{{ $value->product_name }}
|
{{ number_format($value->amt) }} |
{{ number_format($value->selling_price, 2) }} |
{{ number_format($value->total_price, 2) }} |
@endforeach
@if ($order_products_lists_free->count() > 0)
| {{ __('สินค้าแถม') }} |
{{ __('ชื่อสินค้า') }} |
{{ __('จำนวน') }} |
{{ __('ราคา/หน่วย') }} |
{{ __('ราคารวม') }} |
@foreach ($order_products_lists_free as $value_get_free)
|
{{ __('โปรโมชั่น') }}: {{ $value_get_free->pro_name }}
{{ Str::limit($value_get_free->product_name, 45) }}
{{ __('รหัสสินค้า') }}: {{ $value_get_free->sku }}
|
{{ number_format($value_get_free->free_tqy) }} |
0 |
0 |
@endforeach
@endif
@if ($order->transaction_slip1)
 }})
@endif
@if ($order->payment_method == 'Quote')
รายละเอียดการขอใบเสนอราคา
{{ $order->note }}
@endif
| {{ __('ราคารวมสินค้า:') }} |
{{ number_format($order->item_amount, 2) }} {{ __('THB') }} |
| {{ __('ค่าจัดส่ง:') }} |
{{ number_format($order->shipping, 2) }} {{ __('THB') }} |
| {{ __('ส่วนลด:') }} |
{{ number_format($order->discount_price, 2) }} {{ __('THB') }} |
| {{ __('ยอดรวมสุทธิ:') }} |
{{ number_format($order->total_amount, 2) }} {{ __('THB') }} |
@endif