FM / seeders

/home/techb158/immovalet.com/database/seeders/

/home/techb158/immovalet.com/database/seeders

Name	Size	Mode	Actions
files/	-	0755	rm
BlogSeeder.php	9541	0644	edit dl rm
BrandSeeder.php	1481	0644	edit dl rm
CurrencySeeder.php	1345	0644	edit dl rm
CustomerSeeder.php	2825	0644	edit dl rm
DatabaseSeeder.php	1354	0644	edit dl rm
FlashSaleSeeder.php	1308	0644	edit dl rm
MenuSeeder.php	8275	0644	edit dl rm
OrderEcommerceSeeder.php	13529	0644	edit dl rm
PageSeeder.php	5915	0644	edit dl rm
ProductAttributeSeeder.php	3958	0644	edit dl rm
ProductCategorySeeder.php	6457	0644	edit dl rm
ProductCollectionSeeder.php	811	0644	edit dl rm
ProductLabelSeeder.php	750	0644	edit dl rm
ProductSeeder.php	17719	0644	edit dl rm
ProductTagSeeder.php	1248	0644	edit dl rm
ReviewSeeder.php	969	0644	edit dl rm
SettingSeeder.php	2726	0644	edit dl rm
ShippingSeeder.php	775	0644	edit dl rm
SimpleSliderSeeder.php	1709	0644	edit dl rm
StoreLocatorSeeder.php	799	0644	edit dl rm
TaxSeeder.php	697	0644	edit dl rm
TestimonialSeeder.php	1183	0644	edit dl rm
ThemeOptionSeeder.php	3646	0644	edit dl rm
UserSeeder.php	1042	0644	edit dl rm
WidgetSeeder.php	1622	0644	edit dl rm

Edit: /home/techb158/immovalet.com/database/seeders/ProductSeeder.php (17719B)

<?php

namespace Database\Seeders;

use Botble\Base\Enums\BaseStatusEnum;
use Botble\Base\Supports\BaseSeeder;
use Botble\Ecommerce\Models\Order;
use Botble\Ecommerce\Models\OrderAddress;
use Botble\Ecommerce\Models\OrderHistory;
use Botble\Ecommerce\Models\OrderProduct;
use Botble\Ecommerce\Models\Product;
use Botble\Ecommerce\Models\ProductVariation;
use Botble\Ecommerce\Models\ProductVariationItem;
use Botble\Ecommerce\Models\Shipment;
use Botble\Ecommerce\Models\ShipmentHistory;
use Botble\Ecommerce\Models\Wishlist;
use Botble\Payment\Models\Payment;
use Botble\Slug\Models\Slug;
use Faker\Factory;
use File;
use Illuminate\Support\Arr;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Str;
use SlugHelper;

class ProductSeeder extends BaseSeeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $this->uploadFiles('products');

$faker = Factory::create();

$products = [
            [
                'id'          => 1,
                'name'        => 'Smart Home Speaker',
                'price'       => $faker->numberBetween(200, 500),
                'is_featured' => true,
            ],
            [
                'id'          => 2,
                'name'        => 'Headphone Ultra Bass',
                'price'       => $faker->numberBetween(200, 500),
                'sale_price'  => $faker->numberBetween(150, 200),
                'is_featured' => true,
            ],
            [
                'id'          => 3,
                'name'        => 'Boxed - Bluetooth Headphone',
                'price'       => $faker->numberBetween(200, 500),
                'sale_price'  => $faker->numberBetween(50, 60),
                'is_featured' => true,
            ],
            [
                'id'          => 4,
                'name'        => 'Chikie - Bluetooth Speaker',
                'price'       => $faker->numberBetween(70, 90),
                'is_featured' => true,
            ],
            [
                'id'          => 5,
                'name'        => 'Camera Hikvision HK-35VS8',
                'price'       => $faker->numberBetween(40, 50),
                'sale_price'  => $faker->numberBetween(50, 60),
                'is_featured' => true,
            ],
            [
                'id'          => 6,
                'name'        => 'Camera Samsung SS-24',
                'price'       => $faker->numberBetween(50, 60),
                'is_featured' => true,
            ],
            [
                'id'          => 7,
                'name'        => 'Leather Watch Band',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 8,
                'name'        => 'Apple iPhone 13 Plus',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 9,
                'name'        => 'Macbook Pro 2015',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 10,
                'name'        => 'Macbook Air 12 inch',
                'price'       => $faker->numberBetween(200, 500),
                'sale_price'  => $faker->numberBetween(150, 200),
                'is_featured' => true,
            ],
            [
                'id'          => 11,
                'name'        => 'Apple Watch Serial 7',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 12,
                'name'        => 'Macbook Pro 13 inch',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 13,
                'name'        => 'Apple Keyboard',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 14,
                'name'        => 'MacSafe 80W',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 15,
                'name'        => 'Hand playstation',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 16,
                'name'        => 'Apple Airpods Serial 3',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 17,
                'name'        => 'Cool Smart Watches',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 18,
                'name'        => 'Black Smart Watches',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 19,
                'name'        => 'Leather Watch Band Serial 3',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 20,
                'name'        => 'Macbook Pro 2015 13 inch',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 21,
                'name'        => 'Historic Alarm Clock',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 22,
                'name'        => 'Black Glasses',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 23,
                'name'        => 'Phillips Mouse',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'          => 24,
                'name'        => 'Gaming Keyboard',
                'price'       => $faker->numberBetween(110, 130),
                'sale_price'  => $faker->numberBetween(90, 100),
                'is_featured' => true,
            ],
            [
                'id'         => 25,
                'name'       => 'Dual Camera 20MP',
                'price'      => 80.25,
                'sale_price' => 55,
            ],
            [
                'id'         => 26,
                'name'       => 'Smart Watches',
                'price'      => 40.5,
                'sale_price' => 35,
            ],
            [
                'id'         => 27,
                'name'       => 'Beat Headphone',
                'price'      => 20,
                'sale_price' => 15,
            ],
            [
                'id'    => 28,
                'name'  => 'Red & Black Headphone',
                'price' => $faker->numberBetween(50, 60),
            ],
            [
                'id'    => 29,
                'name'  => 'Audio Equipment',
                'price' => $faker->numberBetween(50, 60),
            ],
            [
                'id'         => 30,
                'name'       => 'Smart Televisions',
                'price'      => $faker->numberBetween(110, 130),
                'sale_price' => $faker->numberBetween(80, 100),
            ],
            [
                'id'    => 31,
                'name'  => 'Samsung Smart TV',
                'price' => $faker->numberBetween(50, 60),
            ],
        ];

Product::truncate();
        DB::table('ec_product_with_attribute_set')->truncate();
        DB::table('ec_product_with_attribute')->truncate();
        DB::table('ec_product_variations')->truncate();
        DB::table('ec_product_variation_items')->truncate();
        DB::table('ec_product_collection_products')->truncate();
        DB::table('ec_product_label_products')->truncate();
        DB::table('ec_product_category_product')->truncate();
        DB::table('ec_product_related_relations')->truncate();
        Slug::where('reference_type', Product::class)->delete();
        Wishlist::truncate();
        Order::truncate();
        OrderAddress::truncate();
        OrderProduct::truncate();
        OrderHistory::truncate();
        Shipment::truncate();
        ShipmentHistory::truncate();
        Payment::truncate();

foreach ($products as $key => $item) {
 $item['description'] = 'Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.';
 $item['content'] = 'Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains&rsquo; signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.
 - Casual unisex fit

- 64% polyester, 36% polyurethane

- Water column pressure: 4000 mm

- Model is 187cm tall and wearing a size S / M

- Unisex fit

- Drawstring hood with built-in cap

- Front placket with snap buttons

- Ventilation under armpit

- Adjustable cuffs

- Double welted front pockets

- Adjustable elastic string at hempen

- Ultrasonically welded seams

This is a unisex item, please check our clothing &amp; footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.';
 $item['status'] = BaseStatusEnum::PUBLISHED;
 $item['sku'] = 'HS-' . $faker->numberBetween(100, 200);
 $item['brand_id'] = $faker->numberBetween(1, 7);
 $item['tax_id'] = 1;
 $item['views'] = $faker->numberBetween(1000, 200000);
 $item['quantity'] = $faker->numberBetween(10, 20);
 $item['length'] = $faker->numberBetween(10, 20);
 $item['wide'] = $faker->numberBetween(10, 20);
 $item['height'] = $faker->numberBetween(10, 20);
 $item['weight'] = $faker->numberBetween(500, 900);
 $item['with_storehouse_management'] = true;

$images = [
                'products/' . ($key + 1) . '.jpg',
            ];

for ($i = 1; $i <= 10; $i++) {
 if (File::exists(database_path('seeders/files/products/' . ($key + 1) . '-' . $i . '.jpg'))) {
 $images[] = 'products/' . ($key + 1) . '-' . $i . '.jpg';
 }
 }

$item['images'] = json_encode($images);

$product = Product::create($item);

Slug::create([
                'reference_type' => Product::class,
                'reference_id'   => $product->id,
                'key'            => Str::slug($product->name),
                'prefix'         => SlugHelper::getPrefix(Product::class),
            ]);

$product->productCollections()->sync([$faker->numberBetween(1, 3)]);

if ($product->id % 3 == 0) {
                $product->productLabels()->sync([$faker->numberBetween(1, 3)]);
            }

$product->categories()->sync([
                $faker->numberBetween(1, 14),
                $faker->numberBetween(1, 14),
                $faker->numberBetween(1, 14),
            ]);

$product->tags()->sync([
                $faker->numberBetween(1, 6),
                $faker->numberBetween(1, 6),
                $faker->numberBetween(1, 6),
            ]);
        }

$countProducts = count($products);

foreach ($products as $key => $item) {
            $product = Product::find($key + 1);
            if (!$product) {
                continue;
            }

$product->productAttributeSets()->sync([1, 2]);
            $product->productAttributes()->sync([$faker->numberBetween(1, 5), $faker->numberBetween(6, 10)]);

$product->crossSales()->sync([
                $this->random(1, $countProducts, [$product->id]),
                $this->random(1, $countProducts, [$product->id]),
                $this->random(1, $countProducts, [$product->id]),
                $this->random(1, $countProducts, [$product->id]),
            ]);

for ($j = 0; $j < $faker->numberBetween(1, 5); $j++) {
 $variation = Product::create([
 'name' => $product->name,
 'status' => BaseStatusEnum::PUBLISHED,
 'sku' => $product->sku . '-A' . $j,
 'quantity' => $product->quantity,
 'weight' => $product->weight,
 'height' => $product->height,
 'wide' => $product->wide,
 'length' => $product->length,
 'price' => $product->price,
 'sale_price' => $product->id % 4 == 0 ? ($product->price - $product->price * $faker->numberBetween(10,
 30) / 100) : null,
 'brand_id' => $product->brand_id,
 'with_storehouse_management' => $product->with_storehouse_management,
 'is_variation' => true,
 'images' => json_encode([isset($product->images[$j]) ? $product->images[$j] : Arr::first($product->images)]),
 ]);

$productVariation = ProductVariation::create([
                    'product_id'              => $variation->id,
                    'configurable_product_id' => $product->id,
                    'is_default'              => $j == 0,
                ]);

if ($productVariation->is_default) {
                    $product->update([
                        'sku'        => $variation->sku,
                        'sale_price' => $variation->sale_price,
                    ]);
                }

ProductVariationItem::create([
                    'attribute_id' => $faker->numberBetween(1, 5),
                    'variation_id' => $productVariation->id,
                ]);

ProductVariationItem::create([
                    'attribute_id' => $faker->numberBetween(6, 10),
                    'variation_id' => $productVariation->id,
                ]);
            }
        }
    }

/**
     * @param int $from
     * @param int $to
     * @param array $exceptions
     * @return int
     */
    protected function random($from, $to, array $exceptions = [])
    {
        sort($exceptions); // lets us use break; in the foreach reliably
        $number = rand($from, $to - count($exceptions)); // or mt_rand()

foreach ($exceptions as $exception) {
 if ($number >= $exception) {
 $number++; // make up for the gap
 } else /*if ($number < $exception)*/ {
 break;
 }
 }

return $number;
    }
}

uploadFiles('products'); $faker = Factory::create(); $products = [ [ 'id' => 1, 'name' => 'Smart Home Speaker', 'price' => $faker->numberBetween(200, 500), 'is_featured' => true, ], [ 'id' => 2, 'name' => 'Headphone Ultra Bass', 'price' => $faker->numberBetween(200, 500), 'sale_price' => $faker->numberBetween(150, 200), 'is_featured' => true, ], [ 'id' => 3, 'name' => 'Boxed - Bluetooth Headphone', 'price' => $faker->numberBetween(200, 500), 'sale_price' => $faker->numberBetween(50, 60), 'is_featured' => true, ], [ 'id' => 4, 'name' => 'Chikie - Bluetooth Speaker', 'price' => $faker->numberBetween(70, 90), 'is_featured' => true, ], [ 'id' => 5, 'name' => 'Camera Hikvision HK-35VS8', 'price' => $faker->numberBetween(40, 50), 'sale_price' => $faker->numberBetween(50, 60), 'is_featured' => true, ], [ 'id' => 6, 'name' => 'Camera Samsung SS-24', 'price' => $faker->numberBetween(50, 60), 'is_featured' => true, ], [ 'id' => 7, 'name' => 'Leather Watch Band', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 8, 'name' => 'Apple iPhone 13 Plus', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 9, 'name' => 'Macbook Pro 2015', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 10, 'name' => 'Macbook Air 12 inch', 'price' => $faker->numberBetween(200, 500), 'sale_price' => $faker->numberBetween(150, 200), 'is_featured' => true, ], [ 'id' => 11, 'name' => 'Apple Watch Serial 7', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 12, 'name' => 'Macbook Pro 13 inch', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 13, 'name' => 'Apple Keyboard', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 14, 'name' => 'MacSafe 80W', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 15, 'name' => 'Hand playstation', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 16, 'name' => 'Apple Airpods Serial 3', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 17, 'name' => 'Cool Smart Watches', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 18, 'name' => 'Black Smart Watches', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 19, 'name' => 'Leather Watch Band Serial 3', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 20, 'name' => 'Macbook Pro 2015 13 inch', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 21, 'name' => 'Historic Alarm Clock', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 22, 'name' => 'Black Glasses', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 23, 'name' => 'Phillips Mouse', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 24, 'name' => 'Gaming Keyboard', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(90, 100), 'is_featured' => true, ], [ 'id' => 25, 'name' => 'Dual Camera 20MP', 'price' => 80.25, 'sale_price' => 55, ], [ 'id' => 26, 'name' => 'Smart Watches', 'price' => 40.5, 'sale_price' => 35, ], [ 'id' => 27, 'name' => 'Beat Headphone', 'price' => 20, 'sale_price' => 15, ], [ 'id' => 28, 'name' => 'Red & Black Headphone', 'price' => $faker->numberBetween(50, 60), ], [ 'id' => 29, 'name' => 'Audio Equipment', 'price' => $faker->numberBetween(50, 60), ], [ 'id' => 30, 'name' => 'Smart Televisions', 'price' => $faker->numberBetween(110, 130), 'sale_price' => $faker->numberBetween(80, 100), ], [ 'id' => 31, 'name' => 'Samsung Smart TV', 'price' => $faker->numberBetween(50, 60), ], ]; Product::truncate(); DB::table('ec_product_with_attribute_set')->truncate(); DB::table('ec_product_with_attribute')->truncate(); DB::table('ec_product_variations')->truncate(); DB::table('ec_product_variation_items')->truncate(); DB::table('ec_product_collection_products')->truncate(); DB::table('ec_product_label_products')->truncate(); DB::table('ec_product_category_product')->truncate(); DB::table('ec_product_related_relations')->truncate(); Slug::where('reference_type', Product::class)->delete(); Wishlist::truncate(); Order::truncate(); OrderAddress::truncate(); OrderProduct::truncate(); OrderHistory::truncate(); Shipment::truncate(); ShipmentHistory::truncate(); Payment::truncate(); foreach ($products as $key => $item) { $item['description'] = '

Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.

'; $item['content'] = '

Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline. The style is completed with a drawstring hood, featuring Rains’ signature built-in cap. Made from waterproof, matte PU, this lightweight unisex rain jacket is an ode to nostalgia through its classic silhouette and utilitarian design details.

- Casual unisex fit

- 64% polyester, 36% polyurethane

- Water column pressure: 4000 mm

- Model is 187cm tall and wearing a size S / M

- Unisex fit

- Drawstring hood with built-in cap

- Front placket with snap buttons

- Ventilation under armpit

- Adjustable cuffs

- Double welted front pockets

- Adjustable elastic string at hempen

- Ultrasonically welded seams

This is a unisex item, please check our clothing & footwear sizing guide for specific Rains jacket sizing information. RAINS comes from the rainy nation of Denmark at the edge of the European continent, close to the ocean and with prevailing westerly winds; all factors that contribute to an average of 121 rain days each year. Arising from these rainy weather conditions comes the attitude that a quick rain shower may be beautiful, as well as moody- but first and foremost requires the right outfit. Rains focus on the whole experience of going outside on rainy days, issuing an invitation to explore even in the most mercurial weather.

'; $item['status'] = BaseStatusEnum::PUBLISHED; $item['sku'] = 'HS-' . $faker->numberBetween(100, 200); $item['brand_id'] = $faker->numberBetween(1, 7); $item['tax_id'] = 1; $item['views'] = $faker->numberBetween(1000, 200000); $item['quantity'] = $faker->numberBetween(10, 20); $item['length'] = $faker->numberBetween(10, 20); $item['wide'] = $faker->numberBetween(10, 20); $item['height'] = $faker->numberBetween(10, 20); $item['weight'] = $faker->numberBetween(500, 900); $item['with_storehouse_management'] = true; $images = [ 'products/' . ($key + 1) . '.jpg', ]; for ($i = 1; $i <= 10; $i++) { if (File::exists(database_path('seeders/files/products/' . ($key + 1) . '-' . $i . '.jpg'))) { $images[] = 'products/' . ($key + 1) . '-' . $i . '.jpg'; } } $item['images'] = json_encode($images); $product = Product::create($item); Slug::create([ 'reference_type' => Product::class, 'reference_id' => $product->id, 'key' => Str::slug($product->name), 'prefix' => SlugHelper::getPrefix(Product::class), ]); $product->productCollections()->sync([$faker->numberBetween(1, 3)]); if ($product->id % 3 == 0) { $product->productLabels()->sync([$faker->numberBetween(1, 3)]); } $product->categories()->sync([ $faker->numberBetween(1, 14), $faker->numberBetween(1, 14), $faker->numberBetween(1, 14), ]); $product->tags()->sync([ $faker->numberBetween(1, 6), $faker->numberBetween(1, 6), $faker->numberBetween(1, 6), ]); } $countProducts = count($products); foreach ($products as $key => $item) { $product = Product::find($key + 1); if (!$product) { continue; } $product->productAttributeSets()->sync([1, 2]); $product->productAttributes()->sync([$faker->numberBetween(1, 5), $faker->numberBetween(6, 10)]); $product->crossSales()->sync([ $this->random(1, $countProducts, [$product->id]), $this->random(1, $countProducts, [$product->id]), $this->random(1, $countProducts, [$product->id]), $this->random(1, $countProducts, [$product->id]), ]); for ($j = 0; $j < $faker->numberBetween(1, 5); $j++) { $variation = Product::create([ 'name' => $product->name, 'status' => BaseStatusEnum::PUBLISHED, 'sku' => $product->sku . '-A' . $j, 'quantity' => $product->quantity, 'weight' => $product->weight, 'height' => $product->height, 'wide' => $product->wide, 'length' => $product->length, 'price' => $product->price, 'sale_price' => $product->id % 4 == 0 ? ($product->price - $product->price * $faker->numberBetween(10, 30) / 100) : null, 'brand_id' => $product->brand_id, 'with_storehouse_management' => $product->with_storehouse_management, 'is_variation' => true, 'images' => json_encode([isset($product->images[$j]) ? $product->images[$j] : Arr::first($product->images)]), ]); $productVariation = ProductVariation::create([ 'product_id' => $variation->id, 'configurable_product_id' => $product->id, 'is_default' => $j == 0, ]); if ($productVariation->is_default) { $product->update([ 'sku' => $variation->sku, 'sale_price' => $variation->sale_price, ]); } ProductVariationItem::create([ 'attribute_id' => $faker->numberBetween(1, 5), 'variation_id' => $productVariation->id, ]); ProductVariationItem::create([ 'attribute_id' => $faker->numberBetween(6, 10), 'variation_id' => $productVariation->id, ]); } } } /** * @param int $from * @param int $to * @param array $exceptions * @return int */ protected function random($from, $to, array $exceptions = []) { sort($exceptions); // lets us use break; in the foreach reliably $number = rand($from, $to - count($exceptions)); // or mt_rand() foreach ($exceptions as $exception) { if ($number >= $exception) { $number++; // make up for the gap } else /*if ($number < $exception)*/ { break; } } return $number; } }