2019050600_update_loan_permissions.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;

/*
 * Updating loan account permissions to not allow external withdraws
 */
class UpdateLoanPermissions extends AbstractMigration {
    public function up() {

        /*
        * Updating ext_withdraw
        */
        $cuList = $this->fetchAll('SELECT cu FROM cuadmin');
        foreach ($cuList as $cuListItem) {
            $cu = strtolower(trim($cuListItem['cu']));
            $userAccountsTable = "{$cu}useraccounts";
            if ($this->hasTable($userAccountsTable)) {
                $sql = "update $userAccountsTable set ext_withdraw = 'false' where recordtype = 'L'";
                $this->query($sql);
            }
        }

    }

    public function down() {

        /*
        * Updating ext_withdraw
        */
        $cuList = $this->fetchAll('SELECT cu FROM cuadmin');
        foreach ($cuList as $cuListItem) {
            $cu = strtolower(trim($cuListItem['cu']));
            $userAccountsTable = "{$cu}useraccounts";
            if ($this->hasTable($userAccountsTable)) {
                $sql = "update $userAccountsTable set ext_withdraw = 'true' where recordtype = 'L'";
                $this->query($sql);
            }
        }
    }
}