2019030600_check_number_to_fifteen.php

<?php 
/* Notes:
 * 1. Anything complicated needs to be done with SQL.
 * 2. Always have a check to know if the migration needs to occur (up or down).
 * 3. Use up() and down(), not change(), because of the SQL
 */
use Phinx\Migration\AbstractMigration;

/*
 * Expanding checknumber column to 15 characters
 */
class CheckNumberToFifteen extends AbstractMigration {
    public function up() {

        $cuList = $this->fetchAll('SELECT cu FROM cuadmin');
        foreach ($cuList as $cuListItem) {
            $cu = strtolower(trim($cuListItem['cu']));
            $accountHistoryTableName = "{$cu}accounthistory";
            if ($this->hasTable($accountHistoryTableName)) {
                $accountHistoryTable = $this->table($accountHistoryTableName);
                $accountHistoryTable->changeColumn('checknumber', 'string', ['null' => true, 'limit' => 15])->save();
            }
        }

        if ($this->hasTable('cutronah')) {
            $cutronahTable = $this->table('cutronah');
            $cutronahTable->changeColumn('checknumber', 'string', ['null' => true, 'limit' => 15])->save();
        }
    }

    public function down() {
    }
}