116 lines
3.4 KiB
PHP
116 lines
3.4 KiB
PHP
<?php
|
|
|
|
namespace Database\Seeders;
|
|
|
|
use App\Models\CustomField;
|
|
use App\Models\CustomFieldset;
|
|
use Illuminate\Database\Schema\Blueprint;
|
|
use Illuminate\Database\Seeder;
|
|
use Illuminate\Support\Facades\DB;
|
|
use Illuminate\Support\Facades\Schema;
|
|
|
|
class CustomFieldSeeder extends Seeder
|
|
{
|
|
public function run()
|
|
{
|
|
$columns = DB::getSchemaBuilder()->getColumnListing('assets');
|
|
|
|
foreach ($columns as $column) {
|
|
if (strpos($column, '_snipeit_') !== false) {
|
|
Schema::table('assets', function (Blueprint $table) use ($column) {
|
|
$table->dropColumn($column);
|
|
});
|
|
}
|
|
}
|
|
CustomField::truncate();
|
|
CustomFieldset::truncate();
|
|
DB::table('custom_field_custom_fieldset')->truncate();
|
|
|
|
CustomFieldset::factory()->count(1)->mobile()->create();
|
|
CustomFieldset::factory()->count(1)->computer()->create();
|
|
CustomField::factory()->count(1)->imei()->create();
|
|
CustomField::factory()->count(1)->phone()->create();
|
|
CustomField::factory()->count(1)->ram()->create();
|
|
CustomField::factory()->count(1)->cpu()->create();
|
|
CustomField::factory()->count(1)->macAddress()->create();
|
|
CustomField::factory()->count(1)->testEncrypted()->create();
|
|
CustomField::factory()->count(1)->testCheckbox()->create();
|
|
CustomField::factory()->count(1)->testRadio()->create();
|
|
|
|
|
|
DB::table('custom_field_custom_fieldset')->insert([
|
|
[
|
|
'custom_field_id' => '1',
|
|
'custom_fieldset_id' => '1',
|
|
'order' => 0,
|
|
'required' => 0,
|
|
],
|
|
[
|
|
'custom_field_id' => '2',
|
|
'custom_fieldset_id' => '1',
|
|
'order' => 0,
|
|
'required' => 0,
|
|
],
|
|
[
|
|
'custom_field_id' => '3',
|
|
'custom_fieldset_id' => '2',
|
|
'order' => 0,
|
|
'required' => 0,
|
|
],
|
|
[
|
|
'custom_field_id' => '4',
|
|
'custom_fieldset_id' => '2',
|
|
'order' => 0,
|
|
'required' => 0,
|
|
],
|
|
[
|
|
'custom_field_id' => '5',
|
|
'custom_fieldset_id' => '2',
|
|
'order' => 0,
|
|
'required' => 0,
|
|
],
|
|
|
|
[
|
|
'custom_field_id' => '6',
|
|
'custom_fieldset_id' => '2',
|
|
'order' => 0,
|
|
'required' => 0,
|
|
],
|
|
|
|
[
|
|
'custom_field_id' => '6',
|
|
'custom_fieldset_id' => '1',
|
|
'order' => 0,
|
|
'required' => 0,
|
|
],
|
|
|
|
[
|
|
'custom_field_id' => '7',
|
|
'custom_fieldset_id' => '2',
|
|
'order' => 0,
|
|
'required' => 0,
|
|
],
|
|
[
|
|
'custom_field_id' => '7',
|
|
'custom_fieldset_id' => '1',
|
|
'order' => 0,
|
|
'required' => 0,
|
|
],
|
|
|
|
[
|
|
'custom_field_id' => '8',
|
|
'custom_fieldset_id' => '2',
|
|
'order' => 0,
|
|
'required' => 0,
|
|
],
|
|
[
|
|
'custom_field_id' => '8',
|
|
'custom_fieldset_id' => '1',
|
|
'order' => 0,
|
|
'required' => 0,
|
|
],
|
|
|
|
]);
|
|
}
|
|
}
|