@extends('layouts.frontapp')

@section('title', 'Home')

@section('content')

@php
    function banners(){
        $result=DB::table('banner_images')->where('status','1')->where('is_delete','0')->get();
        return isset($result)?$result:'';
    }
    function spl_banners($id){
        $result=DB::table('special_offers')->where('status','1')->where('position',$id)->first();
        return isset($result)?$result:'';
    }
    
    function products_with_tag(){
        $result=DB::table('products')->where('status','1')->where('is_delete','0')->where('tag_id','!=','')->groupBy('tag_id')->limit('3')->get();
        return isset($result)?$result:'';
    }

    function new_products(){
        $result=DB::table('products')->where('status','1')->where('is_delete','0')->orderBy(DB::raw('RAND()'))->limit('15')->get();
        return isset($result)?$result:'';
    }

    function top_products(){
        $result=DB::table('products')->where('status','1')->where('is_delete','0')->orderBy(DB::raw('RAND()'))->limit('15')->get();
        return isset($result)?$result:'';
    }

    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:'';
    }

    $banner_one = spl_banners('1');
    $banner_two = spl_banners('2');
    $ad_one = spl_banners('3');
    $ad_two = spl_banners('5');
    $banners = banners();
    $new_products = new_products();
    $top_products = top_products();
@endphp

    <!--slider area start-->
    <section class="slider_section slider_s_two mb-30">
        <div class="slider_area owl-carousel">
            
            @foreach($banners as $key=>$item)
                <div class="single_slider d-flex align-items-center" data-bgimg="{{url('/')}}/uploads/banner/{{ $item->banner_images }}">
                    <div class="container">
                        <div class="row">
                            <div class="col-12">
                                <div class="slider_content slider_C_two">
                                    <h1> {{ isset($item->title)?$item->title:'' }}</h1>
                                    <h2>{{ isset($item->subtitle)?$item->subtitle:'' }}</h2>
                                    <!-- <h3>Is Such Perfect</h3> -->
                                    <a class="button" target="_blank" href="{{ $item->action_link }}">{{ isset($item->button_name)?$item->button_name:'' }}</a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            @endforeach

        </div>
    </section>
    <!--slider area end-->

    <!--brand area start-->
    @if(isset($ad_one))
        @if(isset($ad_one->offer_image))
            <div class="brand_area brand_three mb-30 slider_s_three">
                <div class="container">
                    <div class="row">
                        <div class="col-12">
                            <a target="_blank" href="{{isset($ad_one->offer_link)?$ad_one->offer_link:''}}">
                                <img src="{{url('/')}}/uploads/offer/{{isset($ad_one->offer_image)?$ad_one->offer_image:''}}" class="img-fluid" alt="" style="width: 100%;">
                            </a>
                        </div>
                    </div>
                </div>
            </div>
        @endif 
    @endif 
    <!--brand area end-->

    <!--banner area start-->
    <div class="banner_area banner_area_two mb-68">
        <div class="container">
            <div class="row">
                <div class="col-lg-4 col-md-4">
                    <figure class="single_banner mb-30">
                        <div class="banner_thumb">
                            <a href="{{url('/')}}/product"><img src="{{url('/')}}/assets/frontend/img/bg/banner8.jpg" alt=""></a>
                            <div class="banner_text">
                                <h4>Women’s Fitness bodycare</h4>
                                <p>Only $10</p>
                            </div>
                        </div>
                    </figure>
                </div>
                <div class="col-lg-4 col-md-4">
                    <figure class="single_banner mb-30">
                        <div class="banner_thumb">
                            <a href="{{url('/')}}/product"><img src="{{url('/')}}/assets/frontend/img/bg/banner9.jpg" alt=""></a>
                            <div class="banner_text">
                                <h4>Accessories</h4>
                                <p>Up to -30%</p>
                            </div>
                        </div>
                    </figure>
                </div>
                <div class="col-lg-4 col-md-4">
                    <figure class="single_banner mb-30">
                        <div class="banner_thumb">
                            <a href="{{url('/')}}/product"><img src="{{url('/')}}/assets/frontend/img/bg/banner10.jpg" alt=""></a>
                            <div class="banner_text">
                                <h4>Women’s Running Sale</h4>
                                <p>Buy 2 free 1</p>
                            </div>
                        </div>
                    </figure>
                </div>
            </div>
        </div>
    </div>
    <!--banner area end-->

    <!--product area start-->
    <div class="product_area mb-95">
        <div class="container">
            <div class="row">
                <div class="col-12">
                    <div class="section_title">
                       <h3>made the hard way</h3>
                       <h2>Our Products</h2>
                    </div>
                </div>
            </div> 
            <div class="tab-content">
                <div class="tab-pane fade show active" id="Men" role="tabpanel">
                    <div class="row">
                        <div class="product_carousel product_column4 owl-carousel">
                            
                            @foreach($top_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="col-lg-12">
                                <article class="single_product">
                                    <figure>
                                        <div class="product_thumb">

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

                                            @php
                                                $imgurl1 = url('/').'/uploads/product_images/'.$img->image_name;
                                            @endphp

                                            <a @if($key==0) class="primary_img" @else class="secondary_img" @endif href="{{url('/')}}/product-details/{{$item->id}}"><img src="{{$imgurl1}}" alt=""></a>
                                            @endforeach

                                            @if(isset($item->tag_id) && $item->tag_id!=0)
                                            <div class="label_product">
                                                <span class="label_new">{{tagname($item->tag_id)}}</span>
                                            </div>
                                            @endif

                                            <div class="action_links">
                                                <ul>
                                                    <li class="add_to_cart"><a onclick="btnAddCart({{$item->id}})" title="Add to cart"><i class="fa fa-shopping-cart" aria-hidden="true"></i></a>
                                                    </li>
                                                    <li class="wishlist"><a onclick="btnAddToWishlist({{$item->id}})" title="Add to Wishlist"><i class="fa fa-heart" aria-hidden="true"></i></a></li>
                                                    <li class="quick_button">
                                                        <a href="{{url('/')}}/product-details/{{$item->id}}" title="quick view"> <i class="fa fa-search" aria-hidden="true"></i></a>
                                                    </li>
                                                </ul>
                                            </div>
                                        </div>
                                        <figcaption class="product_content">
                                            <div class="product_rating">
                                                @php 
                                                    $rating = 0; 
                                                    $overallrating=DB::table('product_reviews')->where("product_id",$item->id)->avg('rating');

                                                    $rating = $overallrating; 
                                                @endphp

                                                <ul style="font-size: 20px;">
                                                @foreach(range(1,5) as $i)
                                                    <li><a> 
                                                    @if($rating >0)
                                                        @if($rating >0.5)
                                                            <i class="fa fa-star"></i>
                                                        @else
                                                            <i class="fa fa-star-half-o"></i>
                                                        @endif
                                                    @else
                                                        <i class="fa  fa-star-o"></i>
                                                    @endif
                                                                                                        </a></li>
                                                @endforeach
                                            </div>
                                            <h4 class="product_name"><a href="">{{isset($item->product_name)?$item->product_name:''}}</a></h4>
                                            <div class="price_box">
                                                <span class="current_price">{!!currency()!!}

                                                 @if($item->product_type==3)
                                                    {{number_format($item->product_price,2)}}
                                                @endif

                                                </span>
                                            </div>
                                        </figcaption>
                                    </figure>
                                </article>
                            </div>
                            @endforeach

                        </div> 
                    </div>   
                </div>
            </div>   
        </div>
    </div>
    <!--product area end-->