133 lines
3.8 KiB
PHP
133 lines
3.8 KiB
PHP
<?php
|
|
|
|
namespace Database\Seeders;
|
|
|
|
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
|
|
use Illuminate\Database\Seeder;
|
|
use Illuminate\Support\Facades\DB;
|
|
use App\Models\Band;
|
|
use Illuminate\Support\Facades\Schema;
|
|
|
|
class BandSeeder extends Seeder
|
|
{
|
|
/**
|
|
* Run the database seeds.
|
|
*/
|
|
public function run(): void
|
|
{
|
|
|
|
Schema::disableForeignKeyConstraints();
|
|
DB::table('bands')->truncate();
|
|
Schema::enableForeignKeyConstraints();
|
|
|
|
$bands = [
|
|
[
|
|
'name' => '50 MHz',
|
|
'order' => 10,
|
|
'edi_band_begin' => 50,
|
|
'edi_band_end' => 54,
|
|
'has_power_category' => false,
|
|
],
|
|
[
|
|
'name' => '145 MHz',
|
|
'order' => 20,
|
|
'edi_band_begin' => 144,
|
|
'edi_band_end' => 148,
|
|
'has_power_category' => true,
|
|
],
|
|
[
|
|
'name' => '435 MHz',
|
|
'order' => 30,
|
|
'edi_band_begin' => 430,
|
|
'edi_band_end' => 440,
|
|
'has_power_category' => true,
|
|
],
|
|
[
|
|
'name' => '1,3 GHz',
|
|
'order' => 40,
|
|
'edi_band_begin' => 1240,
|
|
'edi_band_end' => 1300,
|
|
'has_power_category' => false,
|
|
],
|
|
[
|
|
'name' => '2,3 GHz',
|
|
'order' => 50,
|
|
'edi_band_begin' => 2300,
|
|
'edi_band_end' => 2450,
|
|
'has_power_category' => false,
|
|
],
|
|
[
|
|
'name' => '3,4 GHz',
|
|
'order' => 60,
|
|
'edi_band_begin' => 3400,
|
|
'edi_band_end' => 3600,
|
|
'has_power_category' => false,
|
|
],
|
|
[
|
|
'name' => '5,7 GHz',
|
|
'order' => 70,
|
|
'edi_band_begin' => 5650,
|
|
'edi_band_end' => 5850,
|
|
'has_power_category' => false,
|
|
],
|
|
[
|
|
'name' => '10 GHz',
|
|
'order' => 80,
|
|
'edi_band_begin' => 10000,
|
|
'edi_band_end' => 10500,
|
|
'has_power_category' => false,
|
|
],
|
|
[
|
|
'name' => '24 GHz',
|
|
'order' => 90,
|
|
'edi_band_begin' => 24000,
|
|
'edi_band_end' => 24250,
|
|
'has_power_category' => false,
|
|
],
|
|
[
|
|
'name' => '47 GHz',
|
|
'order' => 100,
|
|
'edi_band_begin' => 47000,
|
|
'edi_band_end' => 47200,
|
|
'has_power_category' => false,
|
|
],
|
|
[
|
|
'name' => '76 GHz',
|
|
'order' => 110,
|
|
'edi_band_begin' => 75500,
|
|
'edi_band_end' => 81000,
|
|
'has_power_category' => false,
|
|
],
|
|
[
|
|
'name' => '120 GHz',
|
|
'order' => 120,
|
|
'edi_band_begin' => 122250,
|
|
'edi_band_end' => 123000,
|
|
'has_power_category' => false,
|
|
],
|
|
[
|
|
'name' => '134 GHz',
|
|
'order' => 130,
|
|
'edi_band_begin' => 134000,
|
|
'edi_band_end' => 144000,
|
|
'has_power_category' => false,
|
|
],
|
|
[
|
|
'name' => '287 GHz',
|
|
'order' => 140,
|
|
'edi_band_begin' => 287000,
|
|
'edi_band_end' => 287000,
|
|
'has_power_category' => false,
|
|
],
|
|
|
|
];
|
|
|
|
foreach ($bands as &$band) {
|
|
$band['created_at'] = now();
|
|
$band['updated_at'] = now();
|
|
};
|
|
|
|
DB::table('bands')->insert($bands);
|
|
}
|
|
}
|