<?php

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

return new class extends Migration
{
    public function up(): void
    {
        // tenant_id=1 에 휴가신청 결재 양식 등록 (이미 존재하면 무시)
        DB::table('approval_forms')->insertOrIgnore([
            'tenant_id' => 1,
            'name' => '휴가신청',
            'code' => 'leave',
            'category' => 'request',
            'template' => json_encode([
                'fields' => [
                    ['name' => 'user_name', 'type' => 'text', 'label' => '신청자'],
                    ['name' => 'leave_type', 'type' => 'text', 'label' => '휴가유형'],
                    ['name' => 'period', 'type' => 'text', 'label' => '기간'],
                    ['name' => 'days', 'type' => 'number', 'label' => '일수'],
                    ['name' => 'reason', 'type' => 'text', 'label' => '사유'],
                    ['name' => 'remaining_days', 'type' => 'text', 'label' => '잔여연차'],
                ],
            ], JSON_UNESCAPED_UNICODE),
            'is_active' => true,
            'created_by' => 1,
            'created_at' => now(),
            'updated_at' => now(),
        ]);
    }

    public function down(): void
    {
        DB::table('approval_forms')
            ->where('tenant_id', 1)
            ->where('code', 'leave')
            ->delete();
    }
};
