public function Autocomplit2()
{
$products = Product::leftjoin('variants', 'products.id', '=', 'variants.product_id')->leftjoin("detAtr", "variants.id", "=", "detAtr.variant_id")->leftjoin('brands', 'products.brand_id', '=', 'brands.id')->leftjoin('types', 'products.type_id', '=', 'types.id')->leftjoin('materials', 'materials.id', '=', 'products.material_id')->select(\DB::raw('products.id as proId,brands.nombre as BraName,types.nombre as TName,products.codigo as proCodigo,products.nombre as proNombre,products.modelo as modelo,
variants.id as varid,variants.sku as varcode,variants.suppPri as varPrice,variants.price as precioProducto,
products.hasVariants as TieneVariante,products.created_at as proCreado,brands.id as BraID,materials.id as MId
,materials.nombre as Mnombre,variants.codigo as varCodigo,detAtr.descripcion as descripcion,products.quantVar as proQuantvar,(SELECT GROUP_CONCAT(CONCAT(atributes.shortname,":",detAtr.descripcion) SEPARATOR "/") FROM variants
INNER JOIN detAtr ON detAtr.variant_id = variants.id
INNER JOIN atributes ON atributes.id = detAtr.atribute_id
where variants.id=varid
GROUP BY variants.id) as NombreAtributos'))->groupBy('variants.id')->paginate();
return $products;
}
