@extends('layouts.layout')

@section('title', 'Packaging')

@section('content')

@php
    function getname($table,$id){
        $result=DB::table('product_'.$table)->where('status','1')->where('id',$id)->first();
        $column_name = $table.'_name';
        return $result->$column_name;
    }
    function currency(){
        $result=DB::table('membership_currency')->where('status','Active')->first();
        return isset($result->currency_symbol)?$result->currency_symbol:'';
    }
    function tagname($id){
        $result=DB::table('product_tags')->where('status','1')->where('id',$id)->first();
        return isset($result->tag_name)?$result->tag_name:'';
    }
    function ingprocount($id) {
         return $result=DB::table('products')->where('status','1')->whereRaw('ingredients in ('.$id.')')->count();
    }
@endphp

<!-- Content Body Start -->
<div class="content-body">

    <!-- Page Headings Start -->
    <div class="row justify-content-between align-items-center mb-10">

        <!-- Page Heading Start -->
        <div class="col-12 col-lg-auto mb-20">
            <div class="page-heading">
                <h3 class="title">Products <span>/ list of products</span></h3>
            </div>
        </div><!-- Page Heading End -->
    </div><!-- Page Headings End -->

    <div class="row">

        <!--Export Data Table Start-->
        <div class="col-12 mb-30">
            <div class="box">
                <div class="box-body">

                    <div class="row shop_wrapper grid_4">

                    @if(count($products)>0)
                    @foreach($products as $key=>$item)

                    @php
                        $productimg=DB::table('product_images')->where('product_id',$item->id)->where('is_delete','0')->orderBy('id','ASC')->limit('2')->get()->toArray();
                    @endphp

                    <div class="pricing-two col-lg-4 col-md-4 col-sm-6 mb-50">
                        <div class="inner">

                            <div class="head">

                                @foreach($productimg as $key=>$img)

                                @php
                                    $imgurl1 = 'assets/images/icons/pricing-two-3.png';
                                    if($img->image_name) {
                                        $imgurl1 = url('/').'/uploads/product_images/'.$img->image_name;
                                    }
                                @endphp

                                @endforeach

                                <div class="icon"><img src="{{$imgurl1}}" alt=""></div>
                                <div class="info">
                                    <h5 class="title">{{isset($item->product_name)?$item->product_name:''}}</h5>
                                    <h1 class="price"> 
                                        {!!currency()!!}
                                        @if($item->product_type==3)
                                            {{number_format($item->product_price,2)}}
                                        @endif

                                        @if($item->price>0)
                                        {{number_format($item->price,2)}} 
                                        @endif 
                                    </h1>
                                </div>
                            </div>

                            @if($item->description)
                            <div class="body">
                                <ul>
                                    <li>{{isset($item->description)?$item->description:''}}</li>
                                </ul>
                            </div>
                            @endif

                            <div class="foot text-center">
                                <button class="button button-primary" onclick="btnAddCart({{$item->id}})">Add To Cart</button>
                            </div>

                        </div>
                    </div>

                    @endforeach
                    @else 
                    <h3 style="margin : 10% 20%; color: #5ad2ff; font-size: 24px;">Looks like there are no products in this category!</h3>
                    @endif
                    
                </div>

                @if(count($products)>0) 
                    @if($products->currentPage()==1) 
                        @if(count($products)>=16) 
                            <div class="shop_toolbar t_bottom">
                                <div class="pagination" style="margin-bottom: 5px;">
                                    {{ $products->links() }}
                                </div>
                            </div>
                        @endif
                    @else 
                        <div class="shop_toolbar t_bottom">
                            <div class="pagination" style="margin-bottom: 5px;">
                                {{ $products->links() }}
                            </div>
                        </div>
                    @endif
                @endif

                    
                </div>
            </div>
        </div>
        <!--Export Data Table End-->
    </div>

</div><!-- Content Body End -->

@endsection