2019070300_ACHPermissions.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;

/*
 * Expanding checknumber column to 15 characters
 */
class ACHPermissions extends AbstractMigration {
    public function up() {

        // Part 1: Change one User Hub permission into two: basic and advanced.
        $tableName = "cuadminprogs";
        if ($this->hasTable($tableName)) {
            $sql = "update $tableName
                    set description = 'Allow the user to access the ACH screens but not do anything.', displaytext = 'ACH Basic'
                    where program = 'aACH'";
            $this->query($sql);

            $sql = "insert into $tableName (program, displaytext, description, sort_order, def_set)
                    values ('aACHAdv', 'ACH Advanced', 'Allow the user to create/modify ACH files.', 65, 0)";
            $this->query($sql);

            $sql = "update $tableName
                    set sort_order = 66
                    where program = 'AdmDeposits'";
            $this->query($sql);
        }

        // Part 2: Add advanced permissions to admin users that have the original permission.
        $tableName = "cuadminallow";
        if ($this->hasTable($tableName)) {
            $sql = "insert into $tableName (cu, user_name, program)
                    select aa.cu, aa.user_name, 'aACHAdv'
                    from $tableName aa
                    where aa.program = 'aACH'";
            $this->query($sql);
        }

    }

    public function down() {

        // Part 1: Change User Hub permissions back
        $tableName = "cuadminprogs";
        if ($this->hasTable($tableName)) {
            $sql = "update $tableName
                    set description = 'Allow the user to report and export user ACH transaction requests.', displaytext = 'ACH Export'
                    where program = 'aACH'";
            $this->query($sql);

            $sql = "delete from $tableName where program = 'aACHAdv'";
            $this->query($sql);

            $sql = "update $tableName
                    set sort_order = 65
                    where program = 'AdmDeposits'";
            $this->query($sql);
        }

        // Part 2: Remove advanced permissions
        $tableName = "cuadminallow";
        if ($this->hasTable($tableName)) {
            $sql = "delete from $tableName where program = 'aACHAdv'";
            $this->query($sql);
        }
    }
}