@extends('frontend.layouts.app') @section('content') @if($flash_deal->status == 1 && strtotime(date('Y-m-d H:i:s')) <= $flash_deal->end_date)
{{ $flash_deal->title }}

{{ $flash_deal->title }}

@foreach ($flash_deal->flash_deal_products as $key => $flash_deal_product) @php if(session()->has('pincode_details')) { $pin_details = session()->get('pincode_details'); $latitude = (isset($pin_details['latitude']) && !empty($pin_details['latitude'])) ? $pin_details['latitude'] : 1.0000; $longitude= (isset($pin_details['longitude']) && !empty($pin_details['longitude'])) ? $pin_details['longitude'] : 1.0000; $pincode = $pin_details['pincode']; } else { $pincode = ''; $city = ""; $latitude = 1.0000; $longitude = 1.0000; } $distance_query = "( 6371 * acos( cos(radians(" .$latitude. ")) * cos(radians(`latitude`)) * cos(radians(`longitude`) - radians(" .$longitude. ")) + sin(radians(" .$latitude. ")) * sin(radians(`latitude`)) ) )"; $product = \App\Models\Product::where('id',$flash_deal_product->product_id); $product = $product->select('*')->selectRaw("$distance_query AS distance")->having("distance","<=",100); $product = $product->first(); @endphp @if (isset($product) && $product->published != 0)
@include('frontend.partials.product_box_1',['product' => $product])
@endif @endforeach
@else
{{ $flash_deal->title }}

{{ $flash_deal->title }}

{{ translate('This offer has been expired.') }}

@endif @endsection