2017112000_adminsettings.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 AdminSettings extends AbstractMigration
{
    /* This is the process for moving forward. We are re-creating the table so if there is
     * existing data will need to create a temporary table, copy the data, drop the old table,
     * rename the temporary table.
     */
    public function up()
    {
      // add to cuadminprogs table
      $tableName = "cuadminprogs";
      $row = $this->fetchRow( "SELECT * FROM cuadminprogs WHERE program = 'aAdminSettings'" );
      if ( !$row ) {
        print "Adding 'aAdminSettings'\n";

        $singleRow = ["program" => "aAdminSettings",
                                "displaytext" => "Admin Settings",
                                "description" => "Allows you to set the default banking profile for new user who auto enroll and maintain the ACH batch settings.",
                                "sort_order" => 63,
                                "def_set" => "0" ];
        $table = $this->table( $tableName );
        $table->insert($singleRow)->saveData();
      } else {
        print "'aAdminSettings' already exists in table\n";
      }
    }

    /* To execute this you need to run the following command:
     * php vendor/bin/phinx rollback (using correct path to phinx)
     * Or, to roll back to a specific time:
     * php vendor/bin/phinx rollback -t 20151123211207
     */
    public function down()
    {
      print "Not implementing the 'down'";
    }
}