2019040401_userHubPermissions.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 UserHubPermissions 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 = 'Change or unlock user accounts and login authority.' where program = 'userSupport'";
            $this->query($sql);

            $sql = "insert into $tableName (program, displaytext, description, sort_order, def_set)
                    values ('userSupportAdv', 'User Advanced Controls', 'Add/delete users, change account access, or financial limits.', 23, 1)";
            $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, 'userSupportAdv'
                    from $tableName aa
                    where aa.program = 'userSupport'";
            $this->query($sql);
        }

    }

    public function down() {

        // Part 1: Change User Hub permissions back
        $tableName = "cuadminprogs";
        if ($this->hasTable($tableName)) {
            $sql = "update $tableName set description = 'Add, change, unlock, or delete user accounts and login authority.' where program = 'userSupport'";
            $this->query($sql);

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

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