2019072500_updateTrustedMasterRDC.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 UpdateTrustedMasterRDC extends AbstractMigration {

    public function up() {

        $hcuFwdList = ['Type' => 'string', 'Default' => '', 'Message' => '-1 to forward all OR csv list of member numbers to forward OR 0-empty-undefined no forwarding'];
        $hcuFwdToVen = ['Type' => 'string', 'Default' => '', 'Message' => 'trustedID of forward-to vendor. Case and spelling matter'];

        $tableName = "cutrustedmaster";
        $exists = $this->hasTable($tableName);

        if ($exists) {
            $sql = "select  trustedid, trustedfields from ${tableName} where trustedid like 'RDC%'";
            $trustedMasterList = $this->fetchAll($sql);

            for ($i = 0; $i < count($trustedMasterList); $i++) {

                $trustedid = trim($trustedMasterList[$i]["trustedid"]);
                $trustedfields = trim($trustedMasterList[$i]["trustedfields"]);
                $trustedarr = json_decode($trustedfields, true);
                $trustedarr['hcuFwdToVen'] = $hcuFwdToVen;
                $trustedarr['hcuFwdList'] = $hcuFwdList;
                $unpreppedDetailString = json_encode($trustedarr);
                $detailsString = pg_escape_string($unpreppedDetailString);

                $sql = "update ${tableName} set trustedfields = '${detailsString}' where trustedid='${trustedid}'";
                $this->query($sql);
            }
        }
    }

    /* To execute this you need to run the following command:
     * php vendor/bin/phinx rollback (using correct path to phinx)
     */

    public function down() {

    }

}

?>