2019111200_updIPAYBPSTrustedMaster.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 override options for IPAYBPS
 */
class updIPAYBPSTrustedMaster extends AbstractMigration {

  /** @var string  */
  protected $trusted_table    = "cutrustedmaster";
  /** @var array - use in part for updates, completely for insert */
    protected $trusted_default  = [
    'trustedid'     => 'IPAYBPS',
    'trustedvendor' => 'IPAY',
    'trustedtype'   => 'BillPay',
    'hcuinterface'  => '',
    'trustedfields' => [
      'validconsmprod' => [
        'Type' => 'string',
        'Default' => 'HomeCU',
        'Message' => ''
      ],
      'validconsmname' => [
        'Type' => 'string',
        'Default' => 'DMS',
        'Message' => ''
      ],
      'workflowcorrelid' => [
        'Type' => 'string',
        'Default' => '?',
        'Message' => "do not leave empty, use question mark"
      ],
      'auditwsid' => [
        'Type' => 'string',
        'Default' => '?',
        'Message' => "do not leave empty, use question mark"
      ],
      'auditusrid' => [
        'Type' => 'string',
        'Default' => 'homecukim',
        'Message' => 'if this value is left blank, IPAYBPS.i will default the credit union code.'
      ],
      'institutionenvironment' => [
        'Type' => 'string',
        'Default' => 'PROD',
        'Message' => ''
      ],
      'username' => [
        'Type' => 'string',
        'Default' => 'jxep-HOMECUiJXGateway@jhahosting.com',
        'Message' => 'username for HOMECU'
      ],
      'consumerproduct' => [
        'Type' => 'string',
        'Default' => 'HomeCU',
        'Message' => ''
      ],
      'consumername' => [
        'Type' => 'string',
        'Default' => 'DMS',
        'Message' => ''
      ],
      'product' => [
        'Type' => 'string',
        'Default' => 'Bilpay',
        'Message' => "Bilpay with one l."
      ],
      'InstitutionId' => [
        'Type' => 'digits',
        'Default' => ''
      ],
      'password' => [
        'Type' => 'string',
        'Default' => 'fH!57$iEhB#1!w3Au6S#$d2Y9#Nj!Fs8g4C$Xz#7!R5k3$cUpM',
        'Message' => "password for HOMECU"
      ],
      'serviceurl' => [
        'Type' => 'string',
        'Default' => "https://jxappgtw.jhahosted.com/jxchange/2008/ServiceGateway/ServiceGateway.svc",
        'Message' => ""
      ],
      'datemodel' => [
        'Type' => 'string',
        'Default' => "payeeprocess",
        'Message' => "do not change"
      ],
      'moc' => [
        'Type' => 'digits',
        'Default' => "1",
        'Message' => ""
      ],
      'mocservice' => [
        'Type' => 'string',
        'Default' => "https://KIMjxtest.jackhenry.com/jxchange/2008/ServiceGateway/ServiceGateway.svc",
        'Message' => ""
      ],
      'mocpass' => [
        'Type' => 'string',
        'Default' => ""
      ],
      'ExtraOptions' => [
        'Type' => 'string',
        'Default' => "Transfer=1&Recur=0&PayeeMaint=0&AccountMaint=0&Enroll=0"
      ],
      'MoblPayName' => [
        'Type' => 'string',
        'Default' => "iPayBPS",
        'Message' => ""
      ],
      'hcuLogging' => [
        'Type' => 'string',
        'Default' => "0",
        'Message' => ""
      ],
      'xmlnamespace' => [
        'Type' => 'string',
        'Default' => "http://schemas.xmlsoap.org/soap/envelope/",
        'Message' => ""
      ],
      'xmlnamespaceresp' => [
        'Type' => 'string',
        'Default' => "http://jackhenry.com/jxchange/TPG/2008",
        'Message' => ""
      ],
      'version' => [
        'Type' => 'string',
        'Default' => "5",
        'Message' => "JX App Version"
      ],
      'accountspecs' => [
        'Type' => 'string',
        'Default' => "member",
        'Message' => "Format:  fieldname1(start char, length) | fieldname2(start char, length) | fieldname3(start char, length) Fields to choose: Suffix, micraccount, accounttype, member Example: member(1,2) | suffix | micraccount(1,6)"
      ],
      'override' => [
        'Type' => 'boolean',
        'Default' => "N",
        'Message' => "Check if overrides allowed at CU"
      ],
      'overridecodes' => [
        'Type' => 'string',
        'Default' => "8006",
        'Message' => "cvs list, defaults to duplicate payment error code"
      ]
    ]
  ];

  /**
   * See if IPAYBPS exists, if so, update it to force the override entries and
   * updated default values
   *
   * Since trustedid is unique key to table, counting on only one IPAYBPS entry
   * @return void
   */
    public function up() {

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

      $def = $this->trusted_default;
      $sql = "select * from {$this->trusted_table} where trustedid = '{$def['trustedid']}'";

      # note appears that fetchRow always returns count of 1, even if no row is found.
      # using fetchAll even though I expect max 1 record (trustedid is unique key)

      $trusted_row = $this->fetchAll($sql);

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

          echo " updating {$def['trustedid']} trusted master\n";
                    $this->query($sql);

      } else {

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

        echo " inserting {$def['trustedid']} trusted master\n";
        $this->query($sql);
      }
        }
    }

  /**
   * No Down
   * @return void
   */
    public function down() {

    }
}

?>