/**
* @param Product $product
* @param $quantity
* @return \Illuminate\Http\RedirectResponse
*/
public function add($product, $quantity, $provider)
{
$product = ProductProvider::with('product', 'provider')->find($product);
$cart = Session::get('cart');
$product->quantity = $quantity;
Session::flash('buy', 1);
$cart[$product->id] = $product;
$this->valueTotal($cart);
Session::put('cart', $cart);
return back();
}
function newProductProvider(Request $request)
{
$inputs = $request->all();
$inputs['provider_id'] = auth()->user()->provider->id;
if ($request->has('taxes')) {
$inputs['taxes'] = implode(';', $inputs['taxes']);
}
$productProvider = ProductProvider::create($inputs);
if ($request->has('has_offer')) {
$dataOffer = ['offer_on' => $inputs['offer_on'], 'offer_off' => $inputs['offer_off'], 'offer_price' => $inputs['offer_price']];
$offer = new Offer($dataOffer);
$productProvider->offer()->save($offer);
}
return redirect()->back()->with('messageSuccess', 1);
}
/**
* @param $name Name subcategories
* @return \Illuminate\Database\Eloquent\Collection|static[]
*/
function index($name)
{
if (!$name) {
return Product::whereHas('providers', function ($query) {
$query->where('isActive', 1);
})->with(['subcategory', 'files'])->whereRaw('active = 1 ')->get();
}
return Product::where('active', 1)->whereHas('providers', function ($query) {
$query->where('isActive', 1);
})->with(['files', 'subcategory' => function ($sql) use($name) {
$sql->where('slug', $name);
}])->whereHas('subcategory', function ($sql) use($name) {
$sql->where('slug', $name);
})->get();
/* Esto es temoporal focus group */
if (empty($request->get('subcategory'))) {
return ProductProvider::all();
return ProductProvider::with(['offers', 'product'])->where('id', '>', 0)->get();
}
return ProductProvider::all();
$sqlAdd = $request->get('subcategory') ? ' subcategory_id = ' . $request->get('subcategory') : '';
return ProductProvider::with(['offers', 'product'])->whereRaw($sqlAdd)->get();
/* Esto es temoporal focus group */
$sqlAdd = $request->get('subcategory') ? ' and subcategory_id = ' . $request->get('subcategory') : '';
$products = Product::whereRaw('isValidate = 1 and isActive = 1' . $sqlAdd)->with(['offers', 'productFiles', 'subcategory'])->get();
$lat = '-75.58121155000003';
$lng = '6.244207994244943';
$position = $request->get('position')['coords'];
if ($position) {
$lat = $position['longitude'];
$lng = $position['latitude'];
}
foreach ($products as $product) {
$product->location2 = explode(';', $product->location);
$product->distance = $this->distance($lat, $lng, $product->location2);
}
$sorted = $products->sortBy(function ($p, $key) {
$m[-1][-1] = -1;
$m[-1][0] = 0;
$m[-1][1] = 1;
$m[0][-1] = 0;
$m[0][0] = 0;
$m[0][1] = 1;
$m[1][-1] = 0;
$m[1][0] = 0;
$m[1][1] = 1;
return $m[$this->distancePriority($p['distance'])][$this->farms($p['farms'])];
});
/*$sorted = $products->sortBy(function ($p, $key) {
return $this->distancePriority($p['distance']);
});*/
/* foreach($sorted as $p){
echo 'Producto: ';print_r($p->id);echo '<br>';
echo "     nombre: ";print_r($p->name);echo '<br>';
echo "     cordenadas: ";print_r($p->location);echo '<br>';
echo "     cordenadas 2: ";print_r($p->location2);echo '<br>';
echo "     distancia: ";print_r($p->distance );echo '<br>';
}
dd();*/
return $sorted->slice(1, 36);
}
