sfp_api_laravel_ginastica_cerebro/database/seeders/TbrBaseBracketsSeeder.php

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class TbrBaseBracketsSeeder extends Seeder
{
    public function run(): void
    {
        $now = now();

        DB::table('royalties_base_brackets')->insert([
            [
                'description' => 'Isento',
                'start_month' => 1,
                'end_month'   => 3,
                'percentage'  => 0.0000,
                'created_at'  => $now,
                'updated_at'  => $now,
            ],
            [
                'description' => 'Maior entre % fixo TBR ou 8% do faturamento',
                'start_month' => 4,
                'end_month'   => 12,
                'percentage'  => 0.0800,
                'created_at'  => $now,
                'updated_at'  => $now,
            ],
            [
                'description' => 'Maior entre % fixo TBR ou 8% do faturamento',
                'start_month' => 13,
                'end_month'   => 60,
                'percentage'  => 0.0800,
                'created_at'  => $now,
                'updated_at'  => $now,
            ],
        ]);

        DB::table('fnm_base_brackets')->insert([
            [
                'description' => 'Isento',
                'start_month' => 1,
                'end_month'   => 3,
                'percentage'  => 0.0000,
                'created_at'  => $now,
                'updated_at'  => $now,
            ],
            [
                'description' => 'Maior entre: % fixo TBR ou 2% do faturamento',
                'start_month' => 4,
                'end_month'   => 12,
                'percentage'  => 0.0200,
                'created_at'  => $now,
                'updated_at'  => $now,
            ],
            [
                'description' => 'Maior entre: % fixo TBR ou 2% do faturamento',
                'start_month' => 13,
                'end_month'   => 60,
                'percentage'  => 0.0200,
                'created_at'  => $now,
                'updated_at'  => $now,
            ],
        ]);

        DB::table('maintenance_base_brackets')->insert([
            [
                'description' => '30% fixo da TBR',
                'start_month' => 1,
                'end_month'   => 3,
                'percentage'  => 0.3000,
                'created_at'  => $now,
                'updated_at'  => $now,
            ],
            [
                'description' => '30% fixo da TBR',
                'start_month' => 4,
                'end_month'   => 12,
                'percentage'  => 0.3000,
                'created_at'  => $now,
                'updated_at'  => $now,
            ],
            [
                'description' => '30% fixo da TBR',
                'start_month' => 13,
                'end_month'   => 60,
                'percentage'  => 0.3000,
                'created_at'  => $now,
                'updated_at'  => $now,
            ],
        ]);
    }
}