2019111900_AddProducts.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 AddProducts extends AbstractMigration {
    public function up() {
        $tableName = "cuprodlist";
        $productList = array(
            "HBBatch" => "Batch Home Banking",
            "HBLive" => "Live Home Banking",
            "UpgradeBL" => "Batch to Live HB Upgrade",
            "Intuit" => "Intuit",
            "SSL" => "SSL Hosting",
            "SecForm" => "Secure Forms",
            "Gold" => "Gold Package ",
            "Platinum" => "Platinum Package ",
            "Silver" => "Silver Package",
            "ODYUP" => "Odyssey Upgrade",
            "A2A" => "Account to Account EFT",
            "M2M" => "Member to Member"
        );
        // Check for table
        if ($this->hasTable($tableName)) {
            foreach ($productList as $key => $value) {
                // See if product already exists
                $prodRow = $this->fetchRow("SELECT COUNT(*) as count FROM cuprodlist WHERE trim(home_cu_code) = '$key';");
                // Add product if it doesn't exist
                if ($prodRow['count'] == 0) {
                    $this->query("INSERT INTO $tableName (home_cu_code, home_cu_desc) VALUES ('$key', '$value')");
                }               
            }
        }
    }

    public function down() {
        
    }
}