<?php

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

class CreateOdooExecutionsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        if (!Schema::hasTable('odoo_executions')) {
            Schema::create('odoo_executions', function (Blueprint $table) {
                $table->increments('id');
                $table->integer('application_id');
                $table->string('loan_no')->nullable();
                $table->string('customer_name')->nullable();
                $table->string('business_name');
                $table->string('system_slug')->default('da');
                $table->string('transaction_type');
                $table->string('step_key');
                $table->string('voucher_type')->default('Journal Voucher');
                $table->string('month')->nullable();
                $table->string('year')->nullable();
                $table->decimal('total_debit', 15, 2)->default(0.00);
                $table->decimal('total_credit', 15, 2)->default(0.00);
                $table->decimal('amount', 15, 2)->default(0.00);
                $table->longText('entries_json')->nullable();

                // Maker
                $table->integer('maker_id')->nullable();
                $table->string('maker_name')->nullable();
                $table->timestamp('initiated_at')->nullable();

                // L1 Checker
                $table->string('l1_status')->default('pending'); // pending, approved, rejected
                $table->integer('l1_user_id')->nullable();
                $table->string('l1_user_name')->nullable();
                $table->timestamp('l1_approved_at')->nullable();
                $table->text('l1_remarks')->nullable();

                // L2 Checker
                $table->string('l2_status')->default('pending'); // pending, approved, rejected
                $table->integer('l2_user_id')->nullable();
                $table->string('l2_user_name')->nullable();
                $table->timestamp('l2_approved_at')->nullable();
                $table->text('l2_remarks')->nullable();

                // Odoo Push
                $table->string('odoo_status')->default('pending'); // pending, ready, pushed, failed
                $table->string('transaction_number')->nullable();
                $table->string('odoo_move_id')->nullable();
                $table->string('odoo_voucher_number')->nullable();
                $table->longText('odoo_response')->nullable();
                $table->timestamp('pushed_at')->nullable();

                $table->timestamps();
            });
        }
    }

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