<?php

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

class AddBureauSurrogateToEmiCalculationTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('emi_calculation', function (Blueprint $table) {
            if (!Schema::hasColumn('emi_calculation', 'bureau_surrogate_amount')) {
                $table->unsignedBigInteger('bureau_surrogate_amount')->nullable()->after('residual_emi');
            }
        });

        // Update the enum column to include 'bureau_surrogate_limit'
        // Laravel 5.5 does not support updating enum via schema builder.
        DB::statement("ALTER TABLE emi_calculation MODIFY COLUMN table_of_offers_logic ENUM('residual_emi', 'minimum_tenure', 'power_saving', 'bureau_surrogate_limit') NULL");
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        // Revert the enum column
        DB::statement("ALTER TABLE emi_calculation MODIFY COLUMN table_of_offers_logic ENUM('residual_emi', 'minimum_tenure', 'power_saving') NULL");

        Schema::table('emi_calculation', function (Blueprint $table) {
            if (Schema::hasColumn('emi_calculation', 'bureau_surrogate_amount')) {
                $table->dropColumn('bureau_surrogate_amount');
            }
        });
    }
}