<?php
include 'core/vendor/autoload.php';
$app = include_once 'core/bootstrap/app.php';
$kernel = $app->make(Illuminate\Contracts\Http\Kernel::class);
$response = $kernel->handle(
    $request = Illuminate\Http\Request::capture()
);

use Illuminate\Support\Facades\Schema;

$results = [];

if (Schema::hasColumn('users', 'subadmin_id')) {
    $results[] = "users table has subadmin_id column.";
} else {
    $results[] = "users table DOES NOT have subadmin_id column. Adding it...";
    Schema::table('users', function ($table) {
        $table->integer('subadmin_id')->default(0)->after('id');
    });
    $results[] = "Added subadmin_id to users.";
}

if (Schema::hasColumn('admins', 'wallet')) {
    $results[] = "admins table has wallet column.";
} else {
    $results[] = "admins table DOES NOT have wallet column. Adding it...";
    Schema::table('admins', function ($table) {
        $table->decimal('wallet', 28, 8)->default(0)->after('email');
    });
    $results[] = "Added wallet to admins.";
}

if (Schema::hasTable('user_deposit_requests')) {
    $results[] = "user_deposit_requests table exists.";
} else {
    $results[] = "user_deposit_requests table DOES NOT exist. Creating it...";
    Schema::create('user_deposit_requests', function ($table) {
        $table->id();
        $table->integer('user_id');
        $table->integer('subadmin_id');
        $table->decimal('amount', 28, 8)->default(0);
        $table->string('trx_id', 191)->nullable();
        $table->string('screenshot', 191)->nullable();
        $table->integer('status')->default(0)->comment('0: pending, 1: approved, 2: rejected');
        $table->timestamps();
    });
    $results[] = "Created user_deposit_requests table.";
}

echo implode("\n", $results);
unlink(__FILE__);