/** * Set the user's Seller * * @param string $value * @return string */ public function setSkuAttribute($value) { $categories = ProdCat::where('product_id', $this->id)->first(); if (!$value || strpos($value, '00000-') !== false) { if ($categories) { $category = $categories->category_id; } else { $category = '0'; } $this->attributes['sku'] = str_pad($category, 5, "0", STR_PAD_LEFT) . '-' . str_pad($this->id, 5, "0", STR_PAD_LEFT); } else { $this->attributes['sku'] = $value; } }
public function resetProductsSku() { $products = Product::all(); foreach ($products as $prod => $value) { $categories = ProdCat::where('product_id', $value->id)->first(); if ($categories) { $category = $categories->category_id; } else { $category = '0'; } $product = Product::find($value->id); $product->sku = str_pad($category, 5, "0", STR_PAD_LEFT) . '-' . str_pad($value->id, 5, "0", STR_PAD_LEFT); $product->save(); } }