<?php

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

class CreateBlacksoilPaymentTransactionsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('blacksoil_payment_transactions', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('emi_payment_id')->index();
            $table->decimal('amount', 10, 2);
            $table->string('mode', 191)->nullable();
            $table->string('trasanction_id', 191)->nullable()->index();
            $table->text('trasanction_acknowledgement')->nullable();
            $table->timestamp('payment_date')->useCurrent()->useCurrentOnUpdate();
            $table->date('settlement_date')->nullable();
            $table->string('status', 191)->nullable();
            $table->timestamps();
            $table->string('paid_by', 255)->nullable();
            $table->string('collected_by', 255)->nullable();
            $table->string('wallet_name', 255)->nullable();
            $table->text('reason')->nullable();
            $table->string('umrn', 255)->nullable();
            $table->bigInteger('cust_id')->nullable();
            $table->bigInteger('loan_id')->nullable()->default(0)->index();
            $table->string('payment_for', 255)->nullable();
            $table->timestamp('payment_reconciliation_date')->nullable();
            $table->string('cf_transaction_id', 191)->nullable();
            $table->integer('bank_id')->nullable();
            $table->string('bank_name', 191)->nullable();
            $table->softDeletes(); // For deleted_at
            $table->timestamp('is_deleted_at')->nullable()->index();
            $table->integer('deleted_by')->nullable();
            $table->dateTime('refunded_at')->nullable()->index();
            $table->integer('refunded_by')->nullable();
            $table->tinyInteger('collected_by_type')->nullable()->default(1);
            $table->string('adjust_with_disbursement', 12)->nullable()->default('0');
            $table->integer('adjusted_to')->nullable()->default(0);
            $table->integer('adjusted_by')->nullable()->default(0);
            $table->integer('differ_id')->nullable();
            $table->string('is_advance_payment', 191)->nullable();
            $table->integer('refund_maker_id')->nullable();
            $table->timestamp('refund_maker_at')->nullable();
        });
    }

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