Files
website/website/database/seeders/PlanSeeder.php
Claude Dev 81995079e6 feat: seed new VPS plans with multi-cycle pricing
Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
2026-03-14 23:33:27 -04:00

629 lines
26 KiB
PHP

<?php
declare(strict_types=1);
namespace Database\Seeders;
use App\Models\Plan;
use Illuminate\Database\Seeder;
class PlanSeeder extends Seeder
{
public function run(): void
{
// Archive old VPS plans instead of deleting (preserves foreign key relationships)
Plan::query()
->where('service_type', 'vps')
->whereNotIn('slug', [
'vps-1', 'vps-2', 'vps-4', 'vps-8', 'vps-16', 'vps-32',
'stor-500', 'stor-1tb',
])
->update(['status' => 'archived']);
$plans = [
// ─── VPS Plans ─────────────────────────────────────────────────
[
'name' => 'VPS-1',
'slug' => 'vps-1',
'description' => 'Entry-level VPS with 1 GB RAM for simple tasks, testing, and lightweight applications.',
'service_type' => 'vps',
'price' => 5.00,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '1 vCPU',
'ram' => '1 GB',
'storage' => '25 GB SSD',
'bandwidth' => 'Unmetered',
'ipv4' => '1 Included',
'ipv6' => '/64 Included',
'control_panel' => 'VirtFusion',
'os' => 'Linux & Windows (BYOL)',
'virtfusion_package_id' => 19,
],
'sort_order' => 1,
],
[
'name' => 'VPS-2',
'slug' => 'vps-2',
'description' => 'VPS with 2 GB RAM for small web apps, development servers, and lightweight services.',
'service_type' => 'vps',
'price' => 8.00,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '1 vCPU',
'ram' => '2 GB',
'storage' => '50 GB SSD',
'bandwidth' => 'Unmetered',
'ipv4' => '1 Included',
'ipv6' => '/64 Included',
'control_panel' => 'VirtFusion',
'os' => 'Linux & Windows (BYOL)',
'virtfusion_package_id' => 20,
],
'sort_order' => 2,
],
[
'name' => 'VPS-4',
'slug' => 'vps-4',
'description' => 'VPS with 4 GB RAM and dual vCPUs for web hosting, databases, and moderate workloads.',
'service_type' => 'vps',
'price' => 15.00,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '2 vCPU',
'ram' => '4 GB',
'storage' => '80 GB SSD',
'bandwidth' => 'Unmetered',
'ipv4' => '1 Included',
'ipv6' => '/64 Included',
'control_panel' => 'VirtFusion',
'os' => 'Linux & Windows (BYOL)',
'virtfusion_package_id' => 21,
],
'sort_order' => 3,
],
[
'name' => 'VPS-8',
'slug' => 'vps-8',
'description' => 'VPS with 8 GB RAM and quad vCPUs for production workloads and demanding applications.',
'service_type' => 'vps',
'price' => 30.00,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '4 vCPU',
'ram' => '8 GB',
'storage' => '160 GB SSD',
'bandwidth' => 'Unmetered',
'ipv4' => '1 Included',
'ipv6' => '/64 Included',
'control_panel' => 'VirtFusion',
'os' => 'Linux & Windows (BYOL)',
'virtfusion_package_id' => 22,
],
'sort_order' => 4,
],
[
'name' => 'VPS-16',
'slug' => 'vps-16',
'description' => 'High-performance VPS with 16 GB RAM and 6 vCPUs for heavy multi-threaded workloads.',
'service_type' => 'vps',
'price' => 55.00,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '6 vCPU',
'ram' => '16 GB',
'storage' => '320 GB SSD',
'bandwidth' => 'Unmetered',
'ipv4' => '1 Included',
'ipv6' => '/64 Included',
'control_panel' => 'VirtFusion',
'os' => 'Linux & Windows (BYOL)',
'virtfusion_package_id' => 23,
],
'sort_order' => 5,
],
[
'name' => 'VPS-32',
'slug' => 'vps-32',
'description' => 'Ultimate VPS with 32 GB RAM and 8 vCPUs for enterprise-grade production environments.',
'service_type' => 'vps',
'price' => 99.00,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '8 vCPU',
'ram' => '32 GB',
'storage' => '640 GB SSD',
'bandwidth' => 'Unmetered',
'ipv4' => '1 Included',
'ipv6' => '/64 Included',
'control_panel' => 'VirtFusion',
'os' => 'Linux & Windows (BYOL)',
'virtfusion_package_id' => 24,
],
'sort_order' => 6,
],
[
'name' => 'Storage 500',
'slug' => 'stor-500',
'description' => 'Storage-focused VPS with 500 GB SSD for backups, media, and file storage.',
'service_type' => 'vps',
'price' => 18.00,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '2 vCPU',
'ram' => '2 GB',
'storage' => '500 GB SSD',
'bandwidth' => 'Unmetered',
'ipv4' => '1 Included',
'ipv6' => '/64 Included',
'control_panel' => 'VirtFusion',
'os' => 'Linux & Windows (BYOL)',
'virtfusion_package_id' => 41,
],
'sort_order' => 7,
],
[
'name' => 'Storage 1TB',
'slug' => 'stor-1tb',
'description' => 'Mass storage VPS with 1 TB SSD for large-scale file storage and archives.',
'service_type' => 'vps',
'price' => 28.00,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '2 vCPU',
'ram' => '4 GB',
'storage' => '1 TB SSD',
'bandwidth' => 'Unmetered',
'ipv4' => '1 Included',
'ipv6' => '/64 Included',
'control_panel' => 'VirtFusion',
'os' => 'Linux & Windows (BYOL)',
'virtfusion_package_id' => 41,
],
'sort_order' => 8,
],
// ─── Dedicated Server Plans ──────────────────────────────────
[
'name' => 'Dell R330 LFF',
'slug' => 'dell-r330-lff',
'description' => 'Entry-level single-socket dedicated server with 4 large form factor drive bays.',
'service_type' => 'dedicated',
'price' => 44.39,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '1x Intel Xeon E3-1220 v5',
'cores' => '4C/4T',
'ram' => '16 GB',
'storage_bays' => '4x 3.5" bays',
'bandwidth' => '10 TB',
'ipv4' => '1 IPv4',
'ipv6' => '1 /64 IPv6',
'management' => 'SynergyCP',
],
'stock_quantity' => 3,
'sort_order' => 10,
],
[
'name' => 'Dell R420 LFF',
'slug' => 'dell-r420-lff',
'description' => 'Dual-socket server with 12 cores and 32 GB RAM for mid-range workloads.',
'service_type' => 'dedicated',
'price' => 58.79,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '2x Intel Xeon E5-2430v2',
'cores' => '12C/24T',
'ram' => '32 GB',
'storage_bays' => '4x 3.5" bays',
'bandwidth' => '10 TB',
'ipv4' => '1 IPv4',
'ipv6' => '1 /64 IPv6',
'management' => 'SynergyCP',
],
'stock_quantity' => 0,
'sort_order' => 11,
],
[
'name' => 'Dell R620 SFF 10-Bay',
'slug' => 'dell-r620-sff-10-bay',
'description' => 'High-performance 1U server with 10 small form factor bays and 16 cores.',
'service_type' => 'dedicated',
'price' => 61.19,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '2x Intel Xeon E5-2667v2',
'cores' => '16C/32T',
'ram' => '32 GB',
'storage_bays' => '10x 2.5" bays',
'bandwidth' => '10 TB',
'ipv4' => '1 IPv4',
'ipv6' => '1 /64 IPv6',
'management' => 'SynergyCP',
],
'stock_quantity' => 0,
'sort_order' => 12,
],
[
'name' => 'Dell R620 SFF 8-Bay',
'slug' => 'dell-r620-sff-8-bay',
'description' => 'High-performance 1U server with 8 small form factor bays and 16 cores.',
'service_type' => 'dedicated',
'price' => 61.19,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '2x Intel Xeon E5-2667v2',
'cores' => '16C/32T',
'ram' => '32 GB',
'storage_bays' => '8x 2.5" bays',
'bandwidth' => '10 TB',
'ipv4' => '1 IPv4',
'ipv6' => '1 /64 IPv6',
'management' => 'SynergyCP',
],
'stock_quantity' => 0,
'sort_order' => 13,
],
[
'name' => 'Dell R520 LFF',
'slug' => 'dell-r520-lff',
'description' => 'Storage-friendly 2U server with 8 large form factor bays and dual Xeons.',
'service_type' => 'dedicated',
'price' => 64.79,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '2x Intel Xeon E5-2420v2',
'cores' => '12C/24T',
'ram' => '32 GB',
'storage_bays' => '8x 3.5" bays',
'bandwidth' => '10 TB',
'ipv4' => '1 IPv4',
'ipv6' => '1 /64 IPv6',
'management' => 'SynergyCP',
],
'stock_quantity' => 2,
'sort_order' => 14,
],
[
'name' => 'Dell R430 LFF',
'slug' => 'dell-r430-lff',
'description' => 'Compact 1U server with high-clock v4 Xeons for compute-intensive tasks.',
'service_type' => 'dedicated',
'price' => 87.59,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '2x Intel Xeon E5-2667v4',
'cores' => '16C/32T',
'ram' => '32 GB',
'storage_bays' => '4x 3.5" bays',
'bandwidth' => '10 TB',
'ipv4' => '1 IPv4',
'ipv6' => '1 /64 IPv6',
'management' => 'SynergyCP',
],
'stock_quantity' => 1,
'sort_order' => 15,
],
[
'name' => 'Dell R630 SFF',
'slug' => 'dell-r630-sff',
'description' => 'High-core-count 1U server with 32 cores and 64 threads for heavy multi-threaded workloads.',
'service_type' => 'dedicated',
'price' => 93.59,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '2x Intel Xeon E5-2697A v4',
'cores' => '32C/64T',
'ram' => '32 GB',
'storage_bays' => '8x 2.5" bays',
'bandwidth' => '10 TB',
'ipv4' => '1 IPv4',
'ipv6' => '1 /64 IPv6',
'management' => 'SynergyCP',
],
'stock_quantity' => 1,
'sort_order' => 16,
],
[
'name' => 'Dell R730 LFF',
'slug' => 'dell-r730-lff',
'description' => 'Flagship 2U server with 28 cores, 56 threads, and 8 large form factor bays.',
'service_type' => 'dedicated',
'price' => 107.99,
'billing_cycle' => 'monthly',
'features' => [
'cpu' => '2x Intel Xeon E5-2680v4',
'cores' => '28C/56T',
'ram' => '32 GB',
'storage_bays' => '8x 3.5" bays',
'bandwidth' => '10 TB',
'ipv4' => '1 IPv4',
'ipv6' => '1 /64 IPv6',
'management' => 'SynergyCP',
],
'stock_quantity' => 1,
'sort_order' => 17,
],
// ─── Web Hosting Plans ───────────────────────────────────────
[
'name' => 'Small',
'slug' => 'hosting-small',
'description' => 'Starter web hosting plan for personal sites and blogs.',
'service_type' => 'hosting',
'price' => 2.39,
'billing_cycle' => 'monthly',
'features' => [
'storage' => '10 GB SSD',
'databases' => '2 MySQL',
'email' => '5 Accounts',
'domains' => '1',
'bandwidth' => '1 TB',
'ram' => '512 MB',
'cpu' => '1 Core',
'ssl' => 'Free SSL',
'panel' => 'Enhance',
],
'sort_order' => 20,
],
[
'name' => 'Medium',
'slug' => 'hosting-medium',
'description' => 'Mid-range hosting for small businesses and growing websites.',
'service_type' => 'hosting',
'price' => 3.99,
'billing_cycle' => 'monthly',
'features' => [
'storage' => '25 GB SSD',
'databases' => '6 MySQL',
'email' => '20 Accounts',
'domains' => '4',
'bandwidth' => '1 TB',
'ram' => '1 GB',
'cpu' => '1 Core',
'ssl' => 'Free SSL',
'panel' => 'Enhance',
],
'sort_order' => 21,
],
[
'name' => 'Large',
'slug' => 'hosting-large',
'description' => 'High-capacity hosting with unlimited databases and email for agencies and power users.',
'service_type' => 'hosting',
'price' => 7.19,
'billing_cycle' => 'monthly',
'features' => [
'storage' => '100 GB SSD',
'databases' => 'Unlimited MySQL',
'email' => 'Unlimited Accounts',
'domains' => '30',
'bandwidth' => '2 TB',
'ram' => '4 GB',
'cpu' => '4 Cores',
'ssl' => 'Free SSL',
'panel' => 'Enhance',
],
'sort_order' => 22,
],
[
'name' => 'Dedicated',
'slug' => 'hosting-dedicated',
'description' => 'Dedicated hosting resources with maximum performance and capacity.',
'service_type' => 'hosting',
'price' => 15.99,
'billing_cycle' => 'monthly',
'features' => [
'storage' => '160 GB SSD',
'databases' => 'Unlimited MySQL',
'email' => 'Unlimited Accounts',
'domains' => '100',
'bandwidth' => '4 TB',
'ram' => '8 GB',
'cpu' => '4 Cores',
'ssl' => 'Free SSL',
'panel' => 'Enhance',
],
'sort_order' => 23,
],
// ─── Game Server Plans ──────────────────────────────────────
[
'name' => 'Minecraft',
'slug' => 'game-minecraft',
'description' => 'Java & Bedrock Minecraft server with full mod support.',
'service_type' => 'game',
'price' => 7.99,
'billing_cycle' => 'monthly',
'features' => [
'ram' => '2 GB',
'slots' => '20 Players',
'storage' => '10 GB SSD',
'cpu' => '2 Threads',
'mods' => 'Full Mod Support',
'ddos' => 'DDoS Protection',
],
'sort_order' => 40,
],
[
'name' => 'Rust',
'slug' => 'game-rust',
'description' => 'High-performance Rust server with Oxide/uMod support.',
'service_type' => 'game',
'price' => 14.99,
'billing_cycle' => 'monthly',
'features' => [
'ram' => '4 GB',
'slots' => '50 Players',
'storage' => '25 GB SSD',
'cpu' => '3 Threads',
'mods' => 'Oxide/uMod Support',
'ddos' => 'DDoS Protection',
],
'sort_order' => 41,
],
[
'name' => 'ARK: Survival Evolved',
'slug' => 'game-ark',
'description' => 'ARK servers with cluster support and full mod compatibility.',
'service_type' => 'game',
'price' => 19.99,
'billing_cycle' => 'monthly',
'features' => [
'ram' => '8 GB',
'slots' => '30 Players',
'storage' => '50 GB SSD',
'cpu' => '4 Threads',
'mods' => 'Full Mod Support',
'ddos' => 'DDoS Protection',
],
'sort_order' => 42,
],
[
'name' => 'Valheim',
'slug' => 'game-valheim',
'description' => 'Dedicated Valheim server with BepInEx mod support.',
'service_type' => 'game',
'price' => 9.99,
'billing_cycle' => 'monthly',
'features' => [
'ram' => '4 GB',
'slots' => '10 Players',
'storage' => '10 GB SSD',
'cpu' => '2 Threads',
'mods' => 'BepInEx Support',
'ddos' => 'DDoS Protection',
],
'sort_order' => 43,
],
[
'name' => 'CS2',
'slug' => 'game-cs2',
'description' => 'Counter-Strike 2 competitive and casual servers.',
'service_type' => 'game',
'price' => 12.99,
'billing_cycle' => 'monthly',
'features' => [
'ram' => '4 GB',
'slots' => '32 Players',
'storage' => '15 GB SSD',
'cpu' => '3 Threads',
'mods' => 'Workshop Support',
'ddos' => 'DDoS Protection',
],
'sort_order' => 44,
],
[
'name' => 'Palworld',
'slug' => 'game-palworld',
'description' => 'Palworld dedicated server with full configuration.',
'service_type' => 'game',
'price' => 14.99,
'billing_cycle' => 'monthly',
'features' => [
'ram' => '8 GB',
'slots' => '32 Players',
'storage' => '20 GB SSD',
'cpu' => '4 Threads',
'mods' => 'Community Mods',
'ddos' => 'DDoS Protection',
],
'sort_order' => 45,
],
// ─── MySQL Hosting Plans ─────────────────────────────────────
[
'name' => 'Bronze',
'slug' => 'mysql-bronze',
'description' => 'Entry-level managed MySQL hosting with daily backups.',
'service_type' => 'mysql',
'price' => 6.00,
'billing_cycle' => 'monthly',
'features' => [
'storage' => '5 GB',
'backups' => 'Daily',
'ssl' => 'SSL Encrypted',
],
'sort_order' => 30,
],
[
'name' => 'Silver',
'slug' => 'mysql-silver',
'description' => 'Mid-tier managed MySQL hosting for growing applications.',
'service_type' => 'mysql',
'price' => 12.00,
'billing_cycle' => 'monthly',
'features' => [
'storage' => '15 GB',
'backups' => 'Daily',
'ssl' => 'SSL Encrypted',
],
'sort_order' => 31,
],
[
'name' => 'Gold',
'slug' => 'mysql-gold',
'description' => 'High-capacity managed MySQL hosting for production databases.',
'service_type' => 'mysql',
'price' => 18.00,
'billing_cycle' => 'monthly',
'features' => [
'storage' => '30 GB',
'backups' => 'Daily',
'ssl' => 'SSL Encrypted',
],
'sort_order' => 32,
],
[
'name' => 'Platinum',
'slug' => 'mysql-platinum',
'description' => 'Enterprise managed MySQL hosting with 100 GB storage for large-scale databases.',
'service_type' => 'mysql',
'price' => 30.00,
'billing_cycle' => 'monthly',
'features' => [
'storage' => '100 GB',
'backups' => 'Daily',
'ssl' => 'SSL Encrypted',
],
'sort_order' => 33,
],
];
foreach ($plans as $plan) {
Plan::updateOrCreate(
['slug' => $plan['slug']],
array_merge([
'currency' => 'USD',
'status' => 'active',
], $plan),
);
}
// ─── VPS Multi-Cycle Pricing ───────────────────────────────────
$vpsPricing = [
'vps-1' => ['monthly' => 5.00, 'quarterly' => 14.25, 'semi_annual' => 27.00, 'annual' => 51.00],
'vps-2' => ['monthly' => 8.00, 'quarterly' => 22.80, 'semi_annual' => 43.20, 'annual' => 81.60],
'vps-4' => ['monthly' => 15.00, 'quarterly' => 42.75, 'semi_annual' => 81.00, 'annual' => 153.00],
'vps-8' => ['monthly' => 30.00, 'quarterly' => 85.50, 'semi_annual' => 162.00, 'annual' => 306.00],
'vps-16' => ['monthly' => 55.00, 'quarterly' => 156.75, 'semi_annual' => 297.00, 'annual' => 561.00],
'vps-32' => ['monthly' => 99.00, 'quarterly' => 282.15, 'semi_annual' => 534.60, 'annual' => 1009.80],
'stor-500' => ['monthly' => 18.00, 'quarterly' => 51.30, 'semi_annual' => 97.20, 'annual' => 183.60],
'stor-1tb' => ['monthly' => 28.00, 'quarterly' => 79.80, 'semi_annual' => 151.20, 'annual' => 285.60],
];
foreach ($vpsPricing as $slug => $prices) {
$plan = Plan::where('slug', $slug)->first();
if (! $plan) {
continue;
}
foreach ($prices as $cycle => $price) {
\App\Models\PlanPrice::updateOrCreate(
['plan_id' => $plan->id, 'billing_cycle' => $cycle],
['price' => $price],
);
}
}
}
}