2018050100_grouptaxid.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;

class GroupTaxID extends AbstractMigration {
    public function up() {
      // get the list of credit unions
      $cuList = $this->fetchAll('SELECT cu FROM cuadmin');


      foreach ($cuList as $cuRow) {
        $cu = strtolower(trim($cuRow["cu"]));
        $tableName = "{$cu}group";
        
        // check if table exists
        if ($this->hasTable($tableName)) {
          $table = $this->table($tableName);
          $tableColumn = "tax_id";

          // add column if it doesn't exist
          if (!$table->hasColumn($tableColumn)) {
            $this->query("ALTER TABLE {$cu}group ADD COLUMN tax_id varchar(10)");
          }          
        }
      }
    }

    public function down() {
      // get the list of credit unions
      $cuList = $this->fetchAll('SELECT cu FROM cuadmin');


      foreach ($cuList as $cuRow) {
        $cu = strtolower(trim($cuRow["cu"]));
        $tableName = "{$cu}group";
        
        // check if table exists
        if ($this->hasTable($tableName)) {
          $table = $this->table($tableName);
          $tableColumn = "tax_id";

          // remove column if it exists
          if ($table->hasColumn($tableColumn)) {
            $this->query("ALTER TABLE {$cu}group DROP COLUMN tax_id");
          }          
        }
      }
    }
}