public function disablevar($id)
{
\DB::beginTransaction();
//print_r($id); die();
$variant = Variant::find($id);
$estado = $variant->estado;
if ($estado == 1) {
$variant->estado = 0;
} else {
$variant->estado = 1;
}
$variant->save();
\DB::commit();
return response()->json(['estado' => true]);
}
public function Paginar_por_Variante()
{
$variants = Variant::leftjoin('detAtr', 'variants.id', '=', 'detAtr.variant_id')->join('products', 'products.id', '=', 'variants.product_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')->get();
return $variants;
}
public function destroy(Request $request)
{
//$customer= $this->productRepo->find($request->id);
\DB::beginTransaction();
$product = Product::find($request->proId);
if ($product->hasVariants == 0) {
$variant = Variant::where('product_id', $product->id)->first();
$variant->warehouse()->detach();
$variant->presentation()->detach();
$variant->delete();
//die();
$product->delete();
//Event::fire('update.customer',$customer->all());
\DB::commit();
}
return response()->json(['estado' => true, 'nombre' => $product->nombre]);
}
