|
@php
$business_id = request()->session()->get('user.business_id');
$pr = \App\Product::where('id',$product->product_id)->first();
$product_name = $pr->name;
$query = \App\Variation::join('products AS p', 'variations.product_id', '=', 'p.id')
->join('product_variations AS pv', 'variations.product_variation_id', '=', 'pv.id')
->leftjoin('variation_location_details AS vld', 'variations.id', '=', 'vld.variation_id')
->leftjoin('units', 'p.unit_id', '=', 'units.id')
->leftjoin('units as u', 'p.secondary_unit_id', '=', 'u.id')
->leftjoin('brands', function ($join) {
$join->on('p.brand_id', '=', 'brands.id')
->whereNull('brands.deleted_at');
})
->where('p.business_id', $business_id)
->where('variations.id', $product->variation_id);
$price = $query->select(
'variations.sell_price_inc_tax'
)
->firstOrFail();
$total += $price->sell_price_inc_tax * $product->quantity;
@endphp
{{$product_name}}
|
|
{{$price->sell_price_inc_tax}}
|
|
@endforeach