2019070900_ccloadSupport.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 CcloadSupport extends AbstractMigration {
    public function up() {
        $tableName = "cucmsdocs";
        // Check for table
        if ($this->hasTable($tableName)) {
            $index = 169;
            $section = "Credit Card";
            $doctype = 4;

            $fbgDesc = "CCard Presentation Script.";
            $cfgDesc = "Client specific Credit Card configuration file.";
            $disclaimerDesc = "Disclaimer.";

            $vendor = "SYMITAR_CUSTOM";
            $sort = 1;
            $loadDesc = "Custom credit card include routines for $vendor core applications.";
            $filterDesc = "Custom credit card prefiltering program for $vendor core applications.";
            $sql = "insert into $tableName (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
                    values (" . $index++ . ", 'ccardFBG.pl',         '$fbgDesc',    $doctype, '$vendor', '$section', " . $sort++ . "),
                           (" . $index++ . ", 'ccardload.cfg',       '$cfgDesc',    $doctype, '$vendor', '$section', " . $sort++ . "),
                           (" . $index++ . ", 'ccardload.pi',        '$loadDesc',   $doctype, '$vendor', '$section', " . $sort++ . "),
                           (" . $index++ . ", 'ccardloadprefltr.pl', '$filterDesc', $doctype, '$vendor', '$section', " . $sort++ . ")";
            $this->query($sql);

            $vendor = "XPSystems";
            $sort = 1;
            $loadDesc = "Custom credit card include routines for $vendor core applications.";
            $filterDesc = "Custom credit card prefiltering program for $vendor core applications.";
            $sql = "insert into $tableName (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
                    values (" . $index++ . ", 'ccardload.cfg',       '$cfgDesc',        $doctype, '$vendor', '$section',   " . $sort++ . "),
                           (" . $index++ . ", 'ccardload.pi',        '$loadDesc',       $doctype, '$vendor', '$section',   " . $sort++ . "),
                           (" . $index++ . ", 'ccardloadprefltr.pl', '$filterDesc',     $doctype, '$vendor', '$section',   " . $sort++ . "),
                           (" . $index++ . ", 'disclaimerCC',        '$disclaimerDesc', $doctype, '$vendor', 'Disclosure', " . $sort++ . ")";
            $this->query($sql);

            // Change "Extra" section to "Disclosure"
            $sql = "update $tableName
                    set docsmaintsection = 'Disclosure'
                    where docsmaintsection = 'Extra' and docstype = $doctype";
            $this->query($sql);

            // Update description for the statement version of the FBG file.
            $sql = "update $tableName
                    set docsdesc = 'Stmnt Presentation Script.'
                    where docsname = 'stmntFBG.pl' and docstype = $doctype";
            $this->query($sql);
        }
    }

    public function down() {

    }
}