<?php

namespace Database\Seeders;

use Illuminate\Database\Console\Seeds\WithoutModelEvents;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class SubscriptionRateSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        DB::table('company_subscription_rates')->insert([
            'name' => 'Small Company',
            'description' => 'Full access to the system. Maximum employees of 5.',
            'monthly_rate' => 99,
            'yearly_rate' => 1089,
            'max_employee' => 5,
            'is_unlimited' => 0

        ]);

        DB::table('company_subscription_rates')->insert([
            'name' => 'Medium Company',
            'description' => 'Full access to the system. Maximum employees of 25.',
            'monthly_rate' => 149,
            'yearly_rate' => 1639,
            'max_employee' => 25,
            'is_unlimited' => 0
        ]);

        DB::table('company_subscription_rates')->insert([
            'name' => 'Large Company',
            'description' => 'Full access to the system. Unlimited number of employees.',
            'monthly_rate' => 199,
            'yearly_rate' => 2189,
            'is_unlimited' => 1
        ]);

        /* JOBSEEKER RATES */
        DB::table('job_seekers_subscription_rates')->insert([
            'id' => 1,
            'name' => 'Beginner',
            'description' => '1 Month Full Access to the system.',
            'month' => 1,
            'rate' => 5,
            'is_disabled' => 0,
        ]);
        
        DB::table('job_seekers_subscription_rates')->insert([
            'id' => 2,
            'name' => 'Enhanced',
            'description' => '6 Months Full Access to the system.',
            'month' => 6,
            'rate' => 25,
            'is_disabled' => 0,
        ]);

        DB::table('job_seekers_subscription_rates')->insert([
            'id' => 3,
            'name' => 'Ultimate',
            'description' => '12 Months Full Access to the system.',
            'month' => 12,
            'rate' => 45,
            'is_disabled' => 0,
        ]);
    }
}