383 lines
15 KiB
PHP
383 lines
15 KiB
PHP
<?php
|
|
|
|
namespace Database\Seeders;
|
|
|
|
use Illuminate\Database\Seeder;
|
|
use App\Models\Product;
|
|
use App\Models\ProductCategories;
|
|
use App\Models\ProductPricings;
|
|
use App\Models\Os;
|
|
use App\Models\OsGroup;
|
|
use App\Models\Addon;
|
|
|
|
class VPSProductSeeder extends Seeder
|
|
{
|
|
public function run(): void
|
|
{
|
|
// Create VPS Category
|
|
$vpsCategory = ProductCategories::updateOrCreate(
|
|
['slug' => 'vps'],
|
|
[
|
|
'name' => 'VPS',
|
|
'is_active' => true,
|
|
'sort_order' => 1,
|
|
'type' => 'vps',
|
|
]
|
|
);
|
|
|
|
// Create child categories for VPS
|
|
$ubuntuCategory = ProductCategories::updateOrCreate(
|
|
['slug' => 'vps-ubuntu'],
|
|
[
|
|
'name' => 'VPS Ubuntu',
|
|
'parent_id' => $vpsCategory->id,
|
|
'is_active' => true,
|
|
'sort_order' => 1,
|
|
'type' => 'vps',
|
|
]
|
|
);
|
|
|
|
$windowsCategory = ProductCategories::updateOrCreate(
|
|
['slug' => 'vps-windows'],
|
|
[
|
|
'name' => 'VPS Windows',
|
|
'parent_id' => $vpsCategory->id,
|
|
'is_active' => true,
|
|
'sort_order' => 2,
|
|
'type' => 'vps',
|
|
]
|
|
);
|
|
|
|
// Get or create Ubuntu OS Group - each version has different template_id from vCenter
|
|
$ubuntuGroup = OsGroup::updateOrCreate(
|
|
['name' => 'Ubuntu'],
|
|
[
|
|
'thumbnail' => 'ubuntu.png',
|
|
'status' => 1,
|
|
]
|
|
);
|
|
|
|
// Create Ubuntu OS versions - each with DIFFERENT template_id from vCenter
|
|
$ubuntuVersions = [
|
|
['version' => '20.04 LTS', 'template_id' => 'vm-3005'], // Ubuntu 20.04
|
|
['version' => '22.04 LTS', 'template_id' => 'vm-3010'], // Ubuntu 22.04
|
|
['version' => '24.04 LTS', 'template_id' => 'vm-3011'], // Ubuntu 24.04
|
|
];
|
|
|
|
$ubuntuOS = [];
|
|
foreach ($ubuntuVersions as $uv) {
|
|
$os = Os::updateOrCreate(
|
|
[
|
|
'os_group_id' => $ubuntuGroup->id,
|
|
'version' => $uv['version'],
|
|
],
|
|
[
|
|
'template_id' => $uv['template_id'],
|
|
'status' => 1,
|
|
]
|
|
);
|
|
$ubuntuOS[] = $os;
|
|
$this->command->info("Created Ubuntu {$uv['version']} with template_id: {$uv['template_id']}");
|
|
}
|
|
|
|
// Create Windows OS Group - each version has different template_id from vCenter
|
|
$windowsGroup = OsGroup::updateOrCreate(
|
|
['name' => 'Windows Server'],
|
|
[
|
|
'thumbnail' => 'windows.png',
|
|
'status' => 1,
|
|
]
|
|
);
|
|
|
|
$windowsVersions = [
|
|
['version' => '2019', 'template_id' => 'vm-3006'], // Windows 2019
|
|
['version' => '2022', 'template_id' => 'vm-3007'], // Windows 2022
|
|
];
|
|
|
|
$windowsOS = [];
|
|
foreach ($windowsVersions as $wv) {
|
|
$os = Os::updateOrCreate(
|
|
[
|
|
'os_group_id' => $windowsGroup->id,
|
|
'version' => $wv['version'],
|
|
],
|
|
[
|
|
'template_id' => $wv['template_id'],
|
|
'status' => 1,
|
|
]
|
|
);
|
|
$windowsOS[] = $os;
|
|
$this->command->info("Created Windows {$wv['version']} with template_id: {$wv['template_id']}");
|
|
}
|
|
|
|
// VPS Products Data - using vm-3008 as template_id for items
|
|
$vpsProducts = [
|
|
// Ubuntu VPS Plans
|
|
[
|
|
'name' => 'VPS Basic Ubuntu',
|
|
'slug' => 'vps-basic-ubuntu',
|
|
'short_description' => 'VPS Basic với Ubuntu - Phù hợp cho website nhỏ',
|
|
'description' => '<p>VPS Basic với Ubuntu 22.04 LTS - Phù hợp cho website cá nhân, blog</p>',
|
|
'thumbnail' => '/images/vps/basic.png',
|
|
'cpu' => 1,
|
|
'ram' => 1,
|
|
'disk' => 25,
|
|
'bandwidth' => 100,
|
|
'stock' => 100,
|
|
'is_active' => true,
|
|
'product_categories_id' => $ubuntuCategory->id,
|
|
'template_id' => 'vm-3008',
|
|
'pricing' => [
|
|
['billing_cycle' => 'monthly', 'price' => 150000, 'price_sale' => 99000],
|
|
['billing_cycle' => 'quarterly', 'price' => 450000, 'price_sale' => 297000],
|
|
['billing_cycle' => 'semi_annually', 'price' => 900000, 'price_sale' => 594000],
|
|
['billing_cycle' => 'annually', 'price' => 1800000, 'price_sale' => 1188000],
|
|
],
|
|
'os' => [0, 1, 2], // Ubuntu versions
|
|
],
|
|
[
|
|
'name' => 'VPS Standard Ubuntu',
|
|
'slug' => 'vps-standard-ubuntu',
|
|
'short_description' => 'VPS Standard với Ubuntu - Cân bằng giá và hiệu suất',
|
|
'description' => '<p>VPS Standard với Ubuntu 22.04 LTS - Phù hợp cho website vừa và nhỏ</p>',
|
|
'thumbnail' => '/images/vps/standard.png',
|
|
'cpu' => 2,
|
|
'ram' => 2,
|
|
'disk' => 50,
|
|
'bandwidth' => 200,
|
|
'stock' => 100,
|
|
'is_active' => true,
|
|
'product_categories_id' => $ubuntuCategory->id,
|
|
'template_id' => 'vm-3008',
|
|
'pricing' => [
|
|
['billing_cycle' => 'monthly', 'price' => 250000, 'price_sale' => 199000],
|
|
['billing_cycle' => 'quarterly', 'price' => 750000, 'price_sale' => 597000],
|
|
['billing_cycle' => 'semi_annually', 'price' => 1500000, 'price_sale' => 1194000],
|
|
['billing_cycle' => 'annually', 'price' => 3000000, 'price_sale' => 2388000],
|
|
],
|
|
'os' => [0, 1, 2],
|
|
],
|
|
[
|
|
'name' => 'VPS Professional Ubuntu',
|
|
'slug' => 'vps-professional-ubuntu',
|
|
'short_description' => 'VPS Professional với Ubuntu - Cho ứng dụng web',
|
|
'description' => '<p>VPS Professional với Ubuntu 22.04 LTS - Phù hợp cho website thương mại điện tử</p>',
|
|
'thumbnail' => '/images/vps/professional.png',
|
|
'cpu' => 4,
|
|
'ram' => 4,
|
|
'disk' => 100,
|
|
'bandwidth' => 500,
|
|
'stock' => 50,
|
|
'is_active' => true,
|
|
'product_categories_id' => $ubuntuCategory->id,
|
|
'template_id' => 'vm-3008',
|
|
'pricing' => [
|
|
['billing_cycle' => 'monthly', 'price' => 450000, 'price_sale' => 399000],
|
|
['billing_cycle' => 'quarterly', 'price' => 1350000, 'price_sale' => 1197000],
|
|
['billing_cycle' => 'semi_annually', 'price' => 2700000, 'price_sale' => 2394000],
|
|
['billing_cycle' => 'annually', 'price' => 5400000, 'price_sale' => 4788000],
|
|
],
|
|
'os' => [0, 1, 2],
|
|
],
|
|
[
|
|
'name' => 'VPS Enterprise Ubuntu',
|
|
'slug' => 'vps-enterprise-ubuntu',
|
|
'short_description' => 'VPS Enterprise với Ubuntu - Hiệu suất cao',
|
|
'description' => '<p>VPS Enterprise với Ubuntu 22.04 LTS - Cho ứng dụng enterprise</p>',
|
|
'thumbnail' => '/images/vps/enterprise.png',
|
|
'cpu' => 8,
|
|
'ram' => 8,
|
|
'disk' => 200,
|
|
'bandwidth' => 1000,
|
|
'stock' => 20,
|
|
'is_active' => true,
|
|
'product_categories_id' => $ubuntuCategory->id,
|
|
'template_id' => 'vm-3008',
|
|
'pricing' => [
|
|
['billing_cycle' => 'monthly', 'price' => 850000, 'price_sale' => 799000],
|
|
['billing_cycle' => 'quarterly', 'price' => 2550000, 'price_sale' => 2397000],
|
|
['billing_cycle' => 'semi_annually', 'price' => 5100000, 'price_sale' => 4794000],
|
|
['billing_cycle' => 'annually', 'price' => 10200000, 'price_sale' => 9588000],
|
|
],
|
|
'os' => [0, 1, 2],
|
|
],
|
|
// Windows VPS Plans
|
|
[
|
|
'name' => 'VPS Basic Windows',
|
|
'slug' => 'vps-basic-windows',
|
|
'short_description' => 'VPS Basic với Windows Server',
|
|
'description' => '<p>VPS Basic với Windows Server 2019 - Phù hợp cho ứng dụng .NET</p>',
|
|
'thumbnail' => '/images/vps/windows-basic.png',
|
|
'cpu' => 1,
|
|
'ram' => 2,
|
|
'disk' => 40,
|
|
'bandwidth' => 100,
|
|
'stock' => 50,
|
|
'is_active' => true,
|
|
'product_categories_id' => $windowsCategory->id,
|
|
'template_id' => 'vm-3008',
|
|
'pricing' => [
|
|
['billing_cycle' => 'monthly', 'price' => 250000, 'price_sale' => 199000],
|
|
['billing_cycle' => 'quarterly', 'price' => 750000, 'price_sale' => 597000],
|
|
['billing_cycle' => 'semi_annually', 'price' => 1500000, 'price_sale' => 1194000],
|
|
['billing_cycle' => 'annually', 'price' => 3000000, 'price_sale' => 2388000],
|
|
],
|
|
'os' => [0, 1], // Windows versions
|
|
],
|
|
[
|
|
'name' => 'VPS Standard Windows',
|
|
'slug' => 'vps-standard-windows',
|
|
'short_description' => 'VPS Standard với Windows Server',
|
|
'description' => '<p>VPS Standard với Windows Server 2022 - Phù hợp cho enterprise</p>',
|
|
'thumbnail' => '/images/vps/windows-standard.png',
|
|
'cpu' => 2,
|
|
'ram' => 4,
|
|
'disk' => 80,
|
|
'bandwidth' => 200,
|
|
'stock' => 30,
|
|
'is_active' => true,
|
|
'product_categories_id' => $windowsCategory->id,
|
|
'template_id' => 'vm-3008',
|
|
'pricing' => [
|
|
['billing_cycle' => 'monthly', 'price' => 450000, 'price_sale' => 399000],
|
|
['billing_cycle' => 'quarterly', 'price' => 1350000, 'price_sale' => 1197000],
|
|
['billing_cycle' => 'semi_annually', 'price' => 2700000, 'price_sale' => 2394000],
|
|
['billing_cycle' => 'annually', 'price' => 5400000, 'price_sale' => 4788000],
|
|
],
|
|
'os' => [0, 1],
|
|
],
|
|
[
|
|
'name' => 'VPS Professional Windows',
|
|
'slug' => 'vps-professional-windows',
|
|
'short_description' => 'VPS Professional với Windows Server',
|
|
'description' => '<p>VPS Professional với Windows Server 2022 - Cho enterprise</p>',
|
|
'thumbnail' => '/images/vps/windows-professional.png',
|
|
'cpu' => 4,
|
|
'ram' => 8,
|
|
'disk' => 160,
|
|
'bandwidth' => 500,
|
|
'stock' => 15,
|
|
'is_active' => true,
|
|
'product_categories_id' => $windowsCategory->id,
|
|
'template_id' => 'vm-3008',
|
|
'pricing' => [
|
|
['billing_cycle' => 'monthly', 'price' => 850000, 'price_sale' => 749000],
|
|
['billing_cycle' => 'quarterly', 'price' => 2550000, 'price_sale' => 2247000],
|
|
['billing_cycle' => 'semi_annually', 'price' => 5100000, 'price_sale' => 4494000],
|
|
['billing_cycle' => 'annually', 'price' => 10200000, 'price_sale' => 8988000],
|
|
],
|
|
'os' => [0, 1],
|
|
],
|
|
];
|
|
|
|
// Create Products
|
|
foreach ($vpsProducts as $productData) {
|
|
$productCategoriesId = $productData['product_categories_id'];
|
|
$templateId = $productData['template_id'];
|
|
$pricingData = $productData['pricing'];
|
|
$osIndices = $productData['os'];
|
|
unset($productData['product_categories_id'], $productData['template_id'], $productData['pricing'], $productData['os']);
|
|
|
|
// Determine OS list based on category
|
|
$osList = ($productCategoriesId === $ubuntuCategory->id) ? $ubuntuOS : $windowsOS;
|
|
|
|
$product = Product::updateOrCreate(
|
|
['slug' => $productData['slug']],
|
|
array_merge($productData, [
|
|
'product_categories_id' => $productCategoriesId,
|
|
])
|
|
);
|
|
|
|
// Add template_id as attribute (stored in a separate table or as meta)
|
|
// For now, we store it as part of product's custom attributes if needed
|
|
// The template_id will be used when creating VM
|
|
|
|
// Attach OS versions
|
|
$osToAttach = [];
|
|
foreach ($osIndices as $index) {
|
|
if (isset($osList[$index])) {
|
|
$osToAttach[] = $osList[$index]->id;
|
|
}
|
|
}
|
|
if (!empty($osToAttach)) {
|
|
$product->osVersions()->sync($osToAttach);
|
|
}
|
|
|
|
// Create pricing tiers
|
|
foreach ($pricingData as $pricing) {
|
|
ProductPricings::updateOrCreate(
|
|
[
|
|
'product_id' => $product->id,
|
|
'billing_cycle' => $pricing['billing_cycle'],
|
|
],
|
|
[
|
|
'price' => $pricing['price'],
|
|
'price_sale' => $pricing['price_sale'],
|
|
'currency' => 'VND',
|
|
'is_active' => true,
|
|
]
|
|
);
|
|
}
|
|
|
|
$this->command->info("Created product: {$product->name}");
|
|
}
|
|
|
|
// Make sure we have VPS addons
|
|
$this->ensureVPSAddons();
|
|
|
|
$this->command->info('VPS Products seeding completed!');
|
|
}
|
|
|
|
private function ensureVPSAddons(): void
|
|
{
|
|
$vpsAddons = [
|
|
[
|
|
'type' => 'vps',
|
|
'code' => 'cpu',
|
|
'name' => 'CPU',
|
|
'price' => 25000,
|
|
'min' => 1,
|
|
'max' => 32,
|
|
'step' => 1,
|
|
'prefix' => 'vCore',
|
|
'input_type' => 'number',
|
|
'status' => true,
|
|
'sort_order' => 0,
|
|
],
|
|
[
|
|
'type' => 'vps',
|
|
'code' => 'ram',
|
|
'name' => 'RAM',
|
|
'price' => 15000,
|
|
'min' => 1,
|
|
'max' => 64,
|
|
'step' => 1,
|
|
'prefix' => 'GB',
|
|
'input_type' => 'number',
|
|
'status' => true,
|
|
'sort_order' => 1,
|
|
],
|
|
[
|
|
'type' => 'vps',
|
|
'code' => 'disk',
|
|
'name' => 'SSD',
|
|
'price' => 5000,
|
|
'min' => 10,
|
|
'max' => 1000,
|
|
'step' => 10,
|
|
'prefix' => 'GB',
|
|
'input_type' => 'number',
|
|
'status' => true,
|
|
'sort_order' => 2,
|
|
],
|
|
];
|
|
|
|
foreach ($vpsAddons as $addon) {
|
|
Addon::updateOrCreate(
|
|
['code' => $addon['code'], 'type' => $addon['type']],
|
|
$addon
|
|
);
|
|
}
|
|
}
|
|
}
|