2018073100_disclosureTitlesUpd.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 DisclosureTitlesUpd extends AbstractMigration {
    public function up() {
      $tableName = "cucmsdocs";

      if ($this->hasTable($tableName)) {
        // check for specific docsid 59 ACH Notice
        $docs = $this->fetchRow("SELECT * FROM cucmsdocs WHERE docsid = 59");
        if ($docs) {
          $this->query("UPDATE cucmsdocs SET docstitle='ACH Transfer' WHERE docsid = 59");
        } else {
          $this->query("INSERT INTO cucmsdocs VALUES (59, 'achNotice', 'ACH Notice', 2, 'Y', 'Notice', ' ', 'D', 'ACH Transfer', 'Products', 10, NULL, NULL)");
        }

        // check for specific docsid 60 ACH Terms of Use
        $docs = $this->fetchRow("SELECT * FROM cucmsdocs WHERE docsid = 60");
        if ($docs) {
          $this->query("UPDATE cucmsdocs SET docstitle='ACH Transfer' WHERE docsid = 60");
        } else {
          $this->query("INSERT INTO cucmsdocs VALUES (60, 'achTerms', 'ACH Terms of Use', 1, 'Y', 'Terms of Use', 'Y', 'T', 'ACH Transfer', 'Products', 20, NULL, NULL)");
        }

        // check for specific docsid 61 ACH Upload CSV Notice
        $docs = $this->fetchRow("SELECT * FROM cucmsdocs WHERE docsid = 61");
        if ($docs) {
          $this->query("UPDATE cucmsdocs SET docstitle='ACH Transfer', docsdisplaytext='ACH Upload CSV File' WHERE docsid = 61");
        } else {
          $this->query("INSERT INTO cucmsdocs VALUES (61, 'achUploadCSV', 'ACH Upload CSV Notice', 2, 'Y', 'Notice', ' ', 'D', 'ACH Upload CSV File', 'Products', 10, NULL, NULL)");
        }

        // check for specific docsid 64 Ext Notice
        $docs = $this->fetchRow("SELECT * FROM cucmsdocs WHERE docsid = 62");
        if ($docs) {
          $this->query("UPDATE cucmsdocs SET docstitle='EXT Transfer' WHERE docsid = 62");
        } else {
          $this->query("INSERT INTO cucmsdocs VALUES (62, 'extAccountNotice', 'Ext Notice', 2, 'Y', 'Notice', ' ', 'D', 'EXT Transfer', 'Products', 10, NULL, NULL)");
        }

        // check for specific docsid 65 Ext Terms of Use
        $docs = $this->fetchRow("SELECT * FROM cucmsdocs WHERE docsid = 63");
        if ($docs) {
          $this->query("UPDATE cucmsdocs SET docstitle='EXT Transfer' WHERE docsid = 63");
        } else {
          $this->query("INSERT INTO cucmsdocs VALUES (63, 'extAccountTerms', 'Ext Terms of Use', 1, 'Y', 'Terms of Use', 'Y', 'T', 'EXT Transfer', 'Products', 20, NULL, NULL)");
        }

        // check for specific docsid 64 M2M Notice
        $docs = $this->fetchRow("SELECT * FROM cucmsdocs WHERE docsid = 64");
        if ($docs) {
          $this->query("UPDATE cucmsdocs SET docstitle='M2M Transfer' WHERE docsid = 64");
        } else {
          $this->query("INSERT INTO cucmsdocs VALUES (64, 'm2mAccountNotice', 'M2M Notice', 2, 'Y', 'Notice', ' ', 'D', 'M2M Transfer', 'Products', 10, NULL, NULL)");
        }

        // check for specific docsid 65 M2M Terms of Use
        $docs = $this->fetchRow("SELECT * FROM cucmsdocs WHERE docsid = 65");
        if ($docs) {
          $this->query("UPDATE cucmsdocs SET docstitle='M2M Transfer' WHERE docsid = 65");
        } else {
          $this->query("INSERT INTO cucmsdocs VALUES (65, 'm2mAccountTerms', 'M2M Terms of Use', 1, 'Y', 'Terms of Use', 'Y', 'T', 'M2M Transfer', 'Products', 20, NULL, NULL)");
        }

        // check for specific docsid 36 CheckFree Bill Pay SSO Terms of Use
        $docs = $this->fetchRow("SELECT * FROM cucmsdocs WHERE docsid = 36");
        if ($docs) {
          $this->query("UPDATE cucmsdocs SET docstitle='Bill Pay' WHERE docsid = 36");
        } else {
          $this->query("INSERT INTO cucmsdocs VALUES (36, 'ChkFreeSSO_TOS', 'CheckFree Bill Pay SSO Terms of Service', 1, 'Y', 'Terms of Use', 'Y', 'T', 'Bill Pay', '3rd Party', 30, NULL, NULL)");
        }
      }
    }

    public function down() {
      
    }
}