<?php

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

class CreateAccruedRevenueRpsDataTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('accrued_revenue_rps_data', function (Blueprint $table) {
            $table->increments('id');
            $table->unsignedBigInteger('application_id');
            $table->date('emi_date')->nullable();
            
            $table->decimal('net_loan_amount', 15, 2)->default(0);
            
            // varchar(181) for IRR as per request
            $table->string('customer_interest_rate', 181)->nullable();
            $table->string('company_irr', 181)->nullable();
            $table->string('eir', 181)->nullable();
            
            $table->decimal('opening_outstanding', 15, 2)->default(0);
            $table->decimal('opening_net_principal_outlay', 15, 2)->default(0);
            $table->decimal('opening_subvention_balance', 15, 2)->default(0);
            $table->decimal('principal_payable', 15, 2)->default(0);
            $table->decimal('emi_amount', 15, 2)->default(0);
            $table->decimal('closing_outstanding', 15, 2)->default(0);
            $table->decimal('revenue', 15, 2)->default(0);
            $table->decimal('interest', 15, 2)->default(0);
            $table->decimal('subvention', 15, 2)->default(0);
            $table->decimal('processing_fees', 15, 2)->default(0);
            $table->decimal('bounce_charges', 15, 2)->default(0);
            $table->decimal('penal_interest', 15, 2)->default(0);
            $table->decimal('subvention_balance', 15, 2)->default(0);
            $table->decimal('closing_net_principal_outlay', 15, 2)->default(0);
            
            $table->decimal('opening_outstanding_as_per_eir', 15, 2)->default(0);
            $table->decimal('interest_as_per_eir', 15, 2)->default(0);
            $table->decimal('outflows', 15, 2)->default(0);
            $table->decimal('closing_outstanding_as_per_eir', 15, 2)->default(0);

            $table->timestamps();
            $table->softDeletes();
            
            // Unique index for upsert logic
            $table->unique(['application_id', 'emi_date'], 'app_id_emi_date_unique');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('accrued_revenue_rps_data');
    }
}