2019031200_billingpermissions.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 BillingPermissions extends AbstractMigration {
    public function up() {
        $tableName = "dmsmonitorusers";
        $removalList = array("chris", "elaine", "jan", "joe", "kip", "maddie", "manny");
        // Check for table
        if ($this->hasTable($tableName)) {
            // Remove from list.  When assigning tasks to people, there is a bloated list.
            $sql = "delete from $tableName where user_name in ('" . implode("', '", $removalList) . "')";
            $this->query($sql);

            // Now replace the hcubill permission with the billing permission.  Only four users in mammoth monitor do not have permissions to all scripts.
            // At this time, this change will only affect Casey.
            $sql = "update dmsmonitorusers set allowed_scripts = replace(allowed_scripts, 'hcubill', 'billing') where strpos(allowed_scripts, 'hcubill') > 0";
            $this->query($sql);

            // The other permissions are more complicated but fortunately at this time, all users in those lists are allowed access to all scripts.
        }
    }

    public function down() {

    }
}