2019112700_addBPCustomContent.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 addBPCustomContent extends AbstractMigration {
    public function up() {

      $table = "cucmsdocs";
      if ($this->hasTable($table)) {

          $name = "billpayTerms";
          $esText = "Products";
          $doctype = 1;
          $link = "Y";
          $pdfdefDesc = "CU provided terms for Bill Pay";
          $title = "Bill Pay Terms";
          $dispText = "Terms of Use";
          $default = "Y";
          $response = "T";

          $sort = 20;
          $sql = "insert into $table (docsname, docsdesc, docstype, docsdisplaylink, docsdisplaytext, docsdefaultavail, docsresponsetype, docstitle, docsmaintsection, docsmaintsort)
          values ('$name', '$pdfdefDesc', $doctype, '$link', '$dispText', '$default', '$response', '$title', '$esText', " . $sort . ")";
          $this->query($sql);
        }
    }
}