2019071200_utilitySupport.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 UtilitySupport extends AbstractMigration {
    public function up() {
        $tableName = "cucmsdocs";
        // Check for table
        if ($this->hasTable($tableName)) {
            $index = 177;
            $section = "Utility";
            $doctype = 4;
            $vendor = "pdxUtility";
            $sort = 1;

            $sql = "insert into $tableName (docsid, docsname, docsdesc, docstype, docstitle, docsmaintsection, docsmaintsort)
                    values (" . $index++ . ", 'EHL_house',   'Equal Housing Lender',    $doctype, '$vendor', '$section', " . $sort++ . "),
                           (" . $index++ . ", 'NCUA_box',    'NCUA Logo (Box)',         $doctype, '$vendor', '$section', " . $sort++ . "),
                           (" . $index++ . ", 'NCUA_circle', 'NCUA Logo (Circle)',      $doctype, '$vendor', '$section', " . $sort++ . "),
                           (" . $index++ . ", 'NCUA_rect',   'NCUA Logo (Rectangle)',   $doctype, '$vendor', '$section', " . $sort++ . "),
                           (" . $index++ . ", 'recform_1',   'Reconciliation Form (1)', $doctype, '$vendor', '$section', " . $sort++ . "),
                           (" . $index++ . ", 'recform_2',   'Reconciliation Form (2)', $doctype, '$vendor', '$section', " . $sort++ . "),
                           (" . $index++ . ", 'recform_3',   'Reconciliation Form (3)', $doctype, '$vendor', '$section', " . $sort++ . "),
                           (" . $index++ . ", 'recform_4',   'Reconciliation Form (4)', $doctype, '$vendor', '$section', " . $sort++ . "),
                           (" . $index++ . ", 'recform_5',   'Reconciliation Form (5)', $doctype, '$vendor', '$section', " . $sort++ . "),
                           (" . $index++ . ", 'recform_6',   'Reconciliation Form (6)', $doctype, '$vendor', '$section', " . $sort++ . ")";
            $this->query($sql);
        }
    }

    public function down() {

    }
}