2019080900_UpdateIpayV3.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;

/**
 * Updates trusted master to include EnrollMICR for IPAY_V3
 */
class UpdateIpayV3 extends AbstractMigration {

  /** @var string  */
  protected $trusted_table    = "cutrustedmaster";

  /** @var array - use in part for updates, completely for insert */
  protected $trusted_default  = [
    'trustedid'     => 'IPAY_V3',
    'trustedvendor' => 'IPAY',
    'trustedtype'   => 'BillPay',
    'hcuinterface'  => '\["CLS","CMB"\]',
    'trustedfields' => [
      'skip_company'=> [
        'Type'    => 'digits',
        'Default' => 0,
        'Message' => "set to 1 to exclude ''CompanyID'' tag in Login XML"
      ],
      'moc_session' => [
        'Type'    => 'string',
        'Default' => 'https://moc.billpaysite.com/messaging/messagehandler.aspx',
      ],
      'moc_login' => [
        'Type'    => 'string',
        'Default' => 'https://moc.billpaysite.com/intro.asp',
      ],
      'moc_key' => [
        'Type'    => 'string',
        'Default' => '',
      ],
      'prod_session' => [
        'Type'    => 'string',
        'Default' => 'https://www.billpaysite.com/messaging/messagehandler.aspx',
      ],
      'prod_login' => [
        'Type'    => 'string',
        'Default' => 'https://www.billpaysite.com/intro.asp',
      ],
      'prod_key' => [
        'Type'    => 'digits',
        'Default' => '',
        'Message' => 'issued by iPay / Jack Henry'
      ],
      'ipay_instid' => [
        'Type' => 'digits',
        'Default' => '',
        'Message' => 'issued by iPay / Jack Henry'
      ],
      'hcu_iv' => [
        'Type'    => 'string',
        'Default' => '',
        'Message' => "From linux run pwgen 16 -C and pick a value"
      ],
      'moc' => [
        'Type'    => 'digits',
        'Default' => 1,
      ],
      'hcuLogging'  => [
        'Type'    => 'string',
        'Default' => 0
      ],
      'EnrollMICR' => [
        'Type'    => 'string',
        'Default' => 0,
        'Message' => '0=Enroll using member number as AccountNumber or 1= Enroll using micraccount as AccountNumber'
      ]
    ]
  ];

  /**
   * See if IPAY_V3 exists, if so if the EnrollMIRC key is not present update it.
   * If there's more than 1 record, we wind up updating all of them and something else is messed up.
   * @return void
   */
    public function up() {

        if ($this->hasTable($this->trusted_table)) {

      $def      = $this->trusted_default;
      $ipay_row = $this->fetchRow("select * from {$this->trusted_table} where trustedid = 'IPAY_V3'");

      if (count($ipay_row) > 0) {

          $details = json_decode($ipay_row['trustedfields'], 1);
          if (array_key_exists('EnrollMICR', $details)) {

            return;
          }

          // Else . . .
                    $sql = "update {$this->trusted_table} set trustedfields = '"
                        . json_encode($def['trustedfields'])
                        . "' where trustedid = 'IPAY_V3'";

                    $this->query($sql);

          return;
      }

      if (count($ipay_row) == 0) {

        $sql = "insert into {$this->trusted_table} (trustedid, trustedvendor, trustedtype, hcuinterface, trustedfields)"
              . " values('{$def['trustedid']}', '{$def['trustedvendor']}', '{$def['trustedtype']},'"
              . " '{$def['hcuinterface']}', '" . json_encode($def['trustedfields']) . "'";

        $this->query($sql);
      }
        }


    }

  /**
   * **Assuming** the previous state was properly added without EnrollMICR, re-add it as such.
   * @return void
   */
    public function down() {

    $def = $this->trusted_default;
    unset ($def['trustedfields']['EnrollMICR']);

    $sql = "update {$this->trusted_table} set trustedfields = '"
      . json_encode($def['trustedfields'])
      . "' where trustedid = 'IPAY_V3'";

    $this->query($sql);
    }
}