✏️ Editing: 2018_11_19_164609_update_transactions_table.php

<?php

use Bavix\Wallet\Models\Transaction;
use Bavix\Wallet\Models\Wallet;
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\SQLiteConnection;

class UpdateTransactionsTable extends Migration
{

/**
     * @return string
     */
    protected function table(): string
    {
        return (new Transaction())->getTable();
    }

/**
     * @return string
     */
    protected function walletTable(): string
    {
        return (new Wallet())->getTable();
    }

/**
     * @return void
     */
    public function up(): void
    {
        Schema::table($this->table(), function (Blueprint $table) {
            $table->unsignedBigInteger('wallet_id')
                ->nullable()
                ->after('payable_id');

$table->foreign('wallet_id')
                ->references('id')
                ->on($this->walletTable())
                ->onDelete('cascade');
        });

$slug = config('wallet.wallet.default.slug', 'default');
        DB::transaction(function () use ($slug) {
            Wallet::where('slug', $slug)->each(function (Wallet $wallet) {
                Transaction::query()
                    ->where('payable_type', $wallet->holder_type)
                    ->where('payable_id', $wallet->holder_id)
                    ->update(['wallet_id' => $wallet->id]);
            });
        });
    }

/**
     * @return void
     */
    public function down(): void
    {
        Schema::table($this->table(), function (Blueprint $table) {
            if (!(DB::connection() instanceof SQLiteConnection)) {
                $table->dropForeign(['wallet_id']);
            }
            $table->dropColumn('wallet_id');
        });
    }

}

Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team



Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team