<?php

namespace App\Database\Migrations;

use CodeIgniter\Database\Migration;

class AddRegistrationExperienceFinancialFields extends Migration
{
    public function up()
    {
        if (! $this->db->tableExists('school_years')) {
            return;
        }

        $fields = [];
        $this->addColumnIfMissing($fields, 'registration_fee', ['type' => 'DECIMAL', 'constraint' => '10,2', 'default' => 0, 'after' => 'adult_student_registration_enabled']);
        $this->addColumnIfMissing($fields, 'tuition_due_at_registration', ['type' => 'DECIMAL', 'constraint' => '10,2', 'default' => 0, 'after' => 'registration_fee']);
        $this->addColumnIfMissing($fields, 'mandatory_fees', ['type' => 'DECIMAL', 'constraint' => '10,2', 'default' => 0, 'after' => 'tuition_due_at_registration']);
        $this->addColumnIfMissing($fields, 'carry_over_balance_behavior', ['type' => 'VARCHAR', 'constraint' => 60, 'default' => 'information_only', 'after' => 'mandatory_fees']);
        $this->addColumnIfMissing($fields, 'financial_policy_message', ['type' => 'TEXT', 'null' => true, 'after' => 'carry_over_balance_behavior']);
        $this->addColumnIfMissing($fields, 'payment_plan_available', ['type' => 'TINYINT', 'constraint' => 1, 'default' => 0, 'after' => 'financial_policy_message']);

        if ($fields !== []) {
            $this->forge->addColumn('school_years', $fields);
        }
    }

    public function down()
    {
        if (! $this->db->tableExists('school_years')) {
            return;
        }

        foreach ([
            'registration_fee',
            'tuition_due_at_registration',
            'mandatory_fees',
            'carry_over_balance_behavior',
            'financial_policy_message',
            'payment_plan_available',
        ] as $field) {
            if ($this->db->fieldExists($field, 'school_years')) {
                $this->forge->dropColumn('school_years', $field);
            }
        }
    }

    private function addColumnIfMissing(array &$fields, string $name, array $definition): void
    {
        if (! $this->db->fieldExists($name, 'school_years')) {
            $fields[$name] = $definition;
        }
    }
}