ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / crypto.keyreum.com / database / seeders

<?php

namespace Database\Seeders;

use Botble\Base\Enums\BaseStatusEnum;
use Botble\Base\Models\MetaBox as MetaBoxModel;
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 MetaBox;
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,
                'layout'      => 'product-right-sidebar',
            ],
            [
                'id'          => 2,
                'name'        => 'Headphone Ultra Bass',
                'price'       => $faker->numberBetween(200, 500),
                'sale_price'  => $faker->numberBetween(150, 200),
                'is_featured' => true,
                'layout'      => 'product-left-sidebar',
            ],
            [
                'id'          => 3,
                'name'        => 'Boxed - Bluetooth Headphone',
                'price'       => $faker->numberBetween(200, 500),
                'sale_price'  => $faker->numberBetween(50, 60),
                'is_featured' => true,
                'layout'      => 'product-full-width',
            ],
            [
                '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,
            ],
        ];

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();
        MetaBoxModel::where('reference_type', Product::class)->delete();

foreach ($products as $key => $item) {
 if (!isset($item['description'])) {
 $item['description'] = 'Short Hooded Coat features a straight body, large pockets with button flaps, ventilation air holes, and a string detail along the hemline.<ul>
 <li class="mb-10"> 1 Year AL Jazeera Brand Warranty</li>
 <li class="mb-10"> 30 Day Return Policy</li>
 <li> Cash on Delivery available</li>
 </ul>';
 }

$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(Arr::except($item, ['layout']));

$layout = isset($item['layout']) ? $item['layout'] : null;
            if ($layout) {
                MetaBox::saveMetaBoxData($product, 'layout', $layout);
            }

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 % 7 == 0) {
                $product->productLabels()->sync([$faker->numberBetween(1, 3)]);
            }

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

$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,
                ]);
            }
        }

DB::table('ec_products_translations')->truncate();

$translations = [
            [
                'name' => 'Loa thông minh',
            ],
            [
                'name' => 'Tai nghe Ultra Bass',
            ],
            [
                'name' => 'Tai nghe Bluetooth',
            ],
            [
                'name' => 'Chikie - Loa Bluetooth',
            ],
            [
                'name' => 'Camera Hikvision HK-35VS8',
            ],
            [
                'name' => 'Camera Samsung SS-24',
            ],
            [
                'name' => 'Dây đeo đồng hồ da',
            ],
            [
                'name' => 'Điện thoại Apple iPhone 13 Plus',
            ],
            [
                'name' => 'Máy tính Macbook Pro 2015',
            ],
            [
                'name' => 'Máy tính Macbook Air 12 inch',
            ],
            [
                'name' => 'Đồng hồ Apple Serial 7',
            ],
            [
                'name' => 'Máy tính Macbook Pro 13 inch',
            ],
            [
                'name' => 'Bàn phím Apple',
            ],
            [
                'name' => 'Cục sạc MacSafe 80W',
            ],
            [
                'name' => 'Tay cầm chơi game',
            ],
            [
                'name' => 'Apple Airpods Serial 3',
            ],
            [
                'name' => 'Cool Smart Watches',
            ],
            [
                'name' => 'Black Smart Watches',
            ],
            [
                'name' => 'Leather Watch Band Serial 3',
            ],
            [
                'name' => 'Macbook Pro 2015 13 inch',
            ],
            [
                'name' => 'Đồng hồ báo thức cổ điển',
            ],
            [
                'name' => 'Kính đen cool ngầu',
            ],
            [
                'name' => 'Chuột máy tính Phillips',
            ],
            [
                'name' => 'Bàn phím chơi game',
            ],
        ];

foreach ($translations as $index => $item) {
            $item['lang_code'] = 'vi';
            $item['ec_products_id'] = $index + 1;

DB::table('ec_products_translations')->insert($item);

$product = Product::find($index + 1);
            if ($product) {
                $variations = $product->variations()->get();

foreach ($variations as $variation) {
                    $item['lang_code'] = 'vi';
                    $item['ec_products_id'] = $variation->product->id;

DB::table('ec_products_translations')->insert($item);
                }
            }
        }
    }

/**
     * @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;
    }
}

[-] FlashSaleSeeder.php [edit]
[-] WidgetSeeder.php [edit]
[-] CurrencySeeder.php [edit]
[+] ..
[-] ProductSeeder.php [edit]
[-] ProductCollectionSeeder.php [edit]
[-] AdsSeeder.php [edit]
[-] CustomerSeeder.php [edit]
[-] ReviewSeeder.php [edit]
[-] PageSeeder.php [edit]
[-] BrandSeeder.php [edit]
[-] ThemeOptionSeeder.php [edit]
[-] ProductAttributeSeeder.php [edit]
[-] BlogSeeder.php [edit]
[-] SimpleSliderSeeder.php [edit]
[-] ProductCategorySeeder.php [edit]
[-] MenuSeeder.php [edit]
[-] DatabaseSeeder.php [edit]
[-] UserSeeder.php [edit]
[+] files
[-] SettingSeeder.php [edit]
[-] TaxSeeder.php [edit]
[-] LanguageSeeder.php [edit]
[-] ShippingSeeder.php [edit]
[-] ProductLabelSeeder.php [edit]
[-] OrderEcommerceSeeder.php [edit]
[-] StoreLocatorSeeder.php [edit]
[-] ProductTagSeeder.php [edit]