@extends('layouts.master') @section('title') Aramian Brother`s Jewelry @endsection @section('content') @php use App\Models\ProductImage; use App\Models\ProductPcs; use App\Models\Product; use App\Models\ProductMainMenu; use App\Helpers\Helpers; use Illuminate\Support\Facades\Auth; use App\Models\Wishlist; @endphp
@php $productsAllImage = ProductImage:: select('id', 'products_id', 'image_name', 'main_image' ) ->where('products_id', $products->id) ->distinct() ->get(); @endphp
{{--
--}}

{{$products->title}}

@if(isset($products->discount_price)) @else @endif @php $productsPcs = ProductPcs:: select('id', 'products_id', 'pcs_img', 'pcs_count', 'pcs_txt', 'pcs_ct_size', 'pcs_size_type', 'gia_code', 'gia_url' ) ->where('products_id', $products->id) ->distinct() ->get(); @endphp @foreach ($productsPcs as $productsPcsVal) @if (!empty($productsPcsVal->products_id)) @endif @endforeach
{{$products->code}}
Price
{{ Helpers::getUserNumberFormat()->format($products->price) }}
Discount
{{ Helpers::getUserNumberFormat()->format($products->discount_price) }}
Price
{{ Helpers::getUserNumberFormat()->format($products->price) }}
Material {{$products->material}}
Purity {{$products->purity}}
Weight {{$products->weight}}
Diamond {{$products->diamond}}
@if (!empty($productsPcsVal->pcs_img)) @endif {{$productsPcsVal->pcs_count}} {{$productsPcsVal->pcs_txt}}

{{$productsPcsVal->gia_code}}

{{$productsPcsVal->pcs_ct_size}} {{$productsPcsVal->pcs_size_type}}
@if ($products->category->short_name == 'rings')
{{--
--}} Size guide {{--
--}}
@endif
{{-- @if (!empty($addCart)) --}} {{-- @else @endif --}}
  • @if (!empty($wishlists)) @else @endif
Category: {{$products->category->category_name}}/ @foreach ($products->productMenu as $mainMenu) {{$mainMenu->mainMenu->name}} @endforeach
{{--
--}} {{--
--}}
@if (!empty($products->description))

{{$products->description}}

@endif

Related products

@php $getProduct = Product::inRandomOrder() ->select('products.*', 'products_menu.products_id', 'products_image.products_id', 'products_image.main_image', 'products_image.image_name', ) ->leftJoin('products_menu', function($join){ $join->on('products_menu.products_id', '=', 'products.id'); }) ->leftJoin('products_image', function($join){ $join->on('products_image.products_id', '=', 'products.id'); }) ->where('products.status', 1) ->where('products.category_id', $products->category_id) ->whereNotNull('products_image.main_image') ->distinct() ->limit(12) ->get(); @endphp @foreach ($getProduct as $getProductVal)
@php $productsAllImage = Product:: select('products.*', 'products_menu.products_id', 'products_menu.menu_type_id', 'products_image.products_id', 'products_image.main_image', 'products_image.image_name', ) ->leftJoin('products_menu', function($join){ $join->on('products_menu.products_id', '=', 'products.id'); }) ->leftJoin('products_image', function($join){ $join->on('products_image.products_id', '=', 'products.id'); }) ->where('products.status', 1) ->where('products.id', $getProductVal->id) // ->where('menu_type_id', 1) ->get(); @endphp @if (count($productsAllImage) > 1) @foreach ($productsAllImage as $allImg) @endforeach @else @endif

{{$getProductVal->title}}

@if(isset($getProductVal->discount_price)) {{Helpers::getUserNumberFormat()->format($getProductVal->price)}} {{Helpers::getUserNumberFormat()->format($getProductVal->discount_price)}} @else {{Helpers::getUserNumberFormat()->format($getProductVal->price)}} @endif

{{$getProductVal->description}}

@endforeach
@endsection @section('script') @endsection