<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        DB::table('categories')->insert([
            [
                'c_code' => 'PERMANENT',
                'c_name' => 'Phép cộng nhân viên chính thức',
                'c_type' => 'PERMANENT_ONLEAVE',
                'c_value' => 1,
                'c_active' => 1,
                'created_at' => now(),
                'updated_at' => now(),
            ],
            [
                'c_code' => 'TEMPORARY_ONLEAVE',
                'c_name' => 'Nghỉ dự kiến',
                'c_type' => 'REASON_NOTES',
                'c_value' => "",
                'c_active' => 1,
                'created_at' => now(),
                'updated_at' => now(),
            ],
        ]);
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        DB::table('categories')->where('c_code', 'PERMANENT')->where('c_type', 'PERMANENT_ONLEAVE')->delete();
        DB::table('categories')->where('c_code', 'TEMPORARY_ONLEAVE')->where('c_type', 'REASON_NOTES')->delete();
    }
};
