<?php

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

return new class extends Migration
{
    public function up(): void
    {
        $tenants = DB::table('tenants')->whereNull('deleted_at')->pluck('id');

        foreach ($tenants as $tenantId) {
            $exists = DB::table('approval_forms')
                ->where('tenant_id', $tenantId)
                ->where('code', 'appointment_cert')
                ->exists();

            if (! $exists) {
                DB::table('approval_forms')->insert([
                    'tenant_id' => $tenantId,
                    'name' => '위촉증명서',
                    'code' => 'appointment_cert',
                    'category' => 'certificate',
                    'template' => '[]',
                    'body_template' => '',
                    'is_active' => true,
                    'created_at' => now(),
                    'updated_at' => now(),
                ]);
            }
        }
    }

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