2018053000_eStatementUpdate.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 eStatementUpdate extends AbstractMigration {
    public function up() {
      // get the list of credit unions
      $tableName = "cucmsdocs";

      if ($this->hasTable($tableName)) {
        // check for specific docsid 1: Start Disclosure
        $docs = $this->fetchRow("SELECT * FROM cucmsdocs WHERE docsid = 1");
        if ($docs) {
          $this->query("UPDATE cucmsdocs SET docsdesc='eStatement Start Disclosure' WHERE docsid = 1");
        } else {
          $this->query("INSERT INTO cucmsdocs VALUES (1, 'esTermsStart', 'eStatement Start Disclosure', 1, ' ', 'Start e-Statements', 'Y', 'T', 'e-Statements', 'Products', 25, NULL, NULL)");
        }

        // check for specific docsid 8: Stop Disclosure
        $docs = $this->fetchRow("SELECT * FROM cucmsdocs WHERE docsid = 8");
        if ($docs) {
          $this->query("UPDATE cucmsdocs SET docsdesc='eStatement Stop Disclosure' WHERE docsid = 8");
        } else {
          $this->query("INSERT INTO cucmsdocs VALUES (8, 'esTermsStop', 'eStatement Stop Disclosure', 1, ' ', 'Stop e-Statements', 'Y', 'T', 'e-Statements', 'Products', 30, NULL, NULL)");
        }

        // check for specific docsid 11: Notice
        $docs = $this->fetchRow("SELECT * FROM cucmsdocs WHERE docsid = 11");
        if ($docs) {
          $this->query("UPDATE cucmsdocs SET docsdesc='eStatement Screen Message' WHERE docsid = 11");
        } else {
          $this->query("INSERT INTO cucmsdocs VALUES (11, 'esNotice', 'eStatement Screen Message', 2, 'Y', 'E-Statement Message', ' ', 'D', 'e-Statement Notice', 'Products', 35, NULL, NULL)");
        }
      }
    }

    public function down() {
      
    }
}