<?php

namespace App\Http\Controllers\Api;
use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;

use App\Product;
use App\UserInformation;
use App\Parameter;
use App\Subcategories;
use App\ProductAttribute;

class ProductApiController extends Controller
{
    public function searchProducts(Request $request){
      $parameter = Parameter::where('id',1)->select('sucursal_products')->first();
      $products = Product::with('brand','subcategoryProduct','productImages')
                          ->has('subcategoryProduct')
                          ->where('active', true)
                          ->where('name', 'like', '%' . $request["value_search"] . '%')
                          ->offset($request["offset"])
                          ->take($request["take"]);

      if ($parameter->sucursal_products) {
        $user_id = Auth::user()->id;
        $sucursal = UserInformation::where('user_id', $user_id)->select('current_sucursal_id')->first();
        $products = $products->where('sucursal_id', $sucursal->current_sucursal_id)->get();
      }else{
        $products = $products->get();
        $sucursal = null;
      }


      if ($products) {
          foreach ($products as $product) {
            $product->category = Subcategories::where('id', $product->subcategoryProduct[0]->subcategory_id)->first();
            $product->product_attributes = ProductAttribute::where('product_id', $product->id)->with('attribute')->get()->groupBy('attribute_id')->toArray();
          }
        $data = array('status' => 'success', 'products' => $products);
        return response()->json($data, 200);
      }else{
        $data = array('status' => 'error', 'products' => null);
        return response()->json($data, 200);
      }
    }
}