migrations/Version20240927061039.php line 1

Open in your IDE?
  1. <?php
  2. declare(strict_types=1);
  3. namespace DoctrineMigrations;
  4. use Doctrine\DBAL\Schema\Schema;
  5. use Doctrine\Migrations\AbstractMigration;
  6. /**
  7.  * Auto-generated Migration: Please modify to your needs!
  8.  */
  9. final class Version20240927061039 extends AbstractMigration
  10. {
  11.     public function getDescription(): string
  12.     {
  13.         return '';
  14.     }
  15.     public function up(Schema $schema): void
  16.     {
  17.         $this->addSql("UPDATE `user` SET `roles` = '[\"ROLE_USER_MANAGEMENT_ADMIN\",\"ROLE_USER_PRIVILEGE_ADMIN\",\"ROLE_ACCOUNT_SETTINGS_ADMIN\",\"ROLE_PRODUCT_MANAGEMENT_ADMIN\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_ADMIN\",\"ROLE_CUSTOMER_MANAGEMENT_ADMIN\",\"ROLE_BOARD_SETTINGS_ADMIN\",\"ROLE_ASSY_STOCK_MANAGEMENT_ADMIN\",\"ROLE_SMT_STOCK_MANAGEMENT_ADMIN\",\"ROLE_DAILY_PLAN_ADMIN\",\"ROLE_WORKORDER_DETAILS_ADMIN\",\"ROLE_DOWNTIME_PLANNING_ADMIN\",\"ROLE_IMPORT_HISTORY_ADMIN\",\"ROLE_RUNNING_ORDER_ADMIN\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_ADMIN\",\"ROLE_ACTIVITY_LOG_ADMIN\",\"ROLE_MANAGE_SHIFT_ADMIN\",\"ROLE_OEE_DAILY_TARGET_ADMIN\"]' WHERE `user`.`roles` = '[\"ROLE_ADMIN\"]';
  18.         ");
  19.         $this->addSql("UPDATE `user` SET `roles` = '[\"ROLE_USER_MANAGEMENT_VIEW\",\"ROLE_USER_PRIVILEGE_VIEW\",\"ROLE_ACCOUNT_SETTINGS_VIEW\",\"ROLE_PRODUCT_MANAGEMENT_VIEW\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_VIEW\",\"ROLE_CUSTOMER_MANAGEMENT_VIEW\",\"ROLE_BOARD_SETTINGS_VIEW\",\"ROLE_ASSY_STOCK_MANAGEMENT_VIEW\",\"ROLE_SMT_STOCK_MANAGEMENT_VIEW\",\"ROLE_DAILY_PLAN_VIEW\",\"ROLE_WORKORDER_DETAILS_VIEW\",\"ROLE_DOWNTIME_PLANNING_VIEW\",\"ROLE_IMPORT_HISTORY_VIEW\",\"ROLE_RUNNING_ORDER_VIEW\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_VIEW\",\"ROLE_ACTIVITY_LOG_VIEW\",\"ROLE_MANAGE_SHIFT_VIEW\",\"ROLE_OEE_DAILY_TARGET_VIEW\"]' WHERE `user`.`roles` = '[\"ROLE_USER\"]';
  20.         ");
  21.         $this->addSql("UPDATE `tc_user_type` SET `roles` = '[\"ROLE_USER_MANAGEMENT_ADMIN\",\"ROLE_USER_PRIVILEGE_ADMIN\",\"ROLE_ACCOUNT_SETTINGS_ADMIN\",\"ROLE_PRODUCT_MANAGEMENT_ADMIN\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_ADMIN\",\"ROLE_CUSTOMER_MANAGEMENT_ADMIN\",\"ROLE_BOARD_SETTINGS_ADMIN\",\"ROLE_ASSY_STOCK_MANAGEMENT_ADMIN\",\"ROLE_SMT_STOCK_MANAGEMENT_ADMIN\",\"ROLE_DAILY_PLAN_ADMIN\",\"ROLE_WORKORDER_DETAILS_ADMIN\",\"ROLE_DOWNTIME_PLANNING_ADMIN\",\"ROLE_IMPORT_HISTORY_ADMIN\",\"ROLE_RUNNING_ORDER_ADMIN\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_ADMIN\",\"ROLE_ACTIVITY_LOG_ADMIN\",\"ROLE_MANAGE_SHIFT_ADMIN\",\"ROLE_OEE_DAILY_TARGET_ADMIN\"]' WHERE `tc_user_type`.`roles` = '[\"ROLE_ADMIN\"]';
  22.         ");
  23.         $this->addSql("UPDATE `tc_user_type` SET `roles` = '[\"ROLE_USER_MANAGEMENT_VIEW\",\"ROLE_USER_PRIVILEGE_VIEW\",\"ROLE_ACCOUNT_SETTINGS_VIEW\",\"ROLE_PRODUCT_MANAGEMENT_VIEW\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_VIEW\",\"ROLE_CUSTOMER_MANAGEMENT_VIEW\",\"ROLE_BOARD_SETTINGS_VIEW\",\"ROLE_ASSY_STOCK_MANAGEMENT_VIEW\",\"ROLE_SMT_STOCK_MANAGEMENT_VIEW\",\"ROLE_DAILY_PLAN_VIEW\",\"ROLE_WORKORDER_DETAILS_VIEW\",\"ROLE_DOWNTIME_PLANNING_VIEW\",\"ROLE_IMPORT_HISTORY_VIEW\",\"ROLE_RUNNING_ORDER_VIEW\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_VIEW\",\"ROLE_ACTIVITY_LOG_VIEW\",\"ROLE_MANAGE_SHIFT_VIEW\",\"ROLE_OEE_DAILY_TARGET_VIEW\"]' WHERE `tc_user_type`.`roles` = '[\"ROLE_USER\"]';
  24.         ");
  25.     }
  26.     public function down(Schema $schema): void
  27.     {
  28.         $this->addSql("UPDATE `user` SET `roles` = '[\"ROLE_ADMIN\"]' WHERE `roles` = '[\"ROLE_USER_MANAGEMENT_ADMIN\",\"ROLE_USER_PRIVILEGE_ADMIN\",\"ROLE_ACCOUNT_SETTINGS_ADMIN\",\"ROLE_PRODUCT_MANAGEMENT_ADMIN\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_ADMIN\",\"ROLE_CUSTOMER_MANAGEMENT_ADMIN\",\"ROLE_BOARD_SETTINGS_ADMIN\",\"ROLE_ASSY_STOCK_MANAGEMENT_ADMIN\",\"ROLE_SMT_STOCK_MANAGEMENT_ADMIN\",\"ROLE_DAILY_PLAN_ADMIN\",\"ROLE_WORKORDER_DETAILS_ADMIN\",\"ROLE_DOWNTIME_PLANNING_ADMIN\",\"ROLE_IMPORT_HISTORY_ADMIN\",\"ROLE_RUNNING_ORDER_ADMIN\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_ADMIN\",\"ROLE_ACTIVITY_LOG_ADMIN\",\"ROLE_MANAGE_SHIFT_ADMIN\",\"ROLE_OEE_DAILY_TARGET_ADMIN\"]';
  29.             ");
  30.         $this->addSql("UPDATE `user` SET `roles` = '[\"ROLE_USER\"]' WHERE `roles` = '[\"ROLE_USER_MANAGEMENT_VIEW\",\"ROLE_USER_PRIVILEGE_VIEW\",\"ROLE_ACCOUNT_SETTINGS_VIEW\",\"ROLE_PRODUCT_MANAGEMENT_VIEW\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_VIEW\",\"ROLE_CUSTOMER_MANAGEMENT_VIEW\",\"ROLE_BOARD_SETTINGS_VIEW\",\"ROLE_ASSY_STOCK_MANAGEMENT_VIEW\",\"ROLE_SMT_STOCK_MANAGEMENT_VIEW\",\"ROLE_DAILY_PLAN_VIEW\",\"ROLE_WORKORDER_DETAILS_VIEW\",\"ROLE_DOWNTIME_PLANNING_VIEW\",\"ROLE_IMPORT_HISTORY_VIEW\",\"ROLE_RUNNING_ORDER_VIEW\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_VIEW\",\"ROLE_ACTIVITY_LOG_VIEW\",\"ROLE_MANAGE_SHIFT_VIEW\",\"ROLE_OEE_DAILY_TARGET_VIEW\"]';
  31.             ");
  32.         $this->addSql("UPDATE `tc_user_type` SET `roles` = '[\"ROLE_ADMIN\"]' WHERE `roles` = '[\"ROLE_USER_MANAGEMENT_ADMIN\",\"ROLE_USER_PRIVILEGE_ADMIN\",\"ROLE_ACCOUNT_SETTINGS_ADMIN\",\"ROLE_PRODUCT_MANAGEMENT_ADMIN\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_ADMIN\",\"ROLE_CUSTOMER_MANAGEMENT_ADMIN\",\"ROLE_BOARD_SETTINGS_ADMIN\",\"ROLE_ASSY_STOCK_MANAGEMENT_ADMIN\",\"ROLE_SMT_STOCK_MANAGEMENT_ADMIN\",\"ROLE_DAILY_PLAN_ADMIN\",\"ROLE_WORKORDER_DETAILS_ADMIN\",\"ROLE_DOWNTIME_PLANNING_ADMIN\",\"ROLE_IMPORT_HISTORY_ADMIN\",\"ROLE_RUNNING_ORDER_ADMIN\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_ADMIN\",\"ROLE_ACTIVITY_LOG_ADMIN\",\"ROLE_MANAGE_SHIFT_ADMIN\",\"ROLE_OEE_DAILY_TARGET_ADMIN\"]';
  33.             ");
  34.             
  35.         $this->addSql("UPDATE `tc_user_type` SET `roles` = '[\"ROLE_USER\"]' WHERE `roles` = '[\"ROLE_USER_MANAGEMENT_VIEW\",\"ROLE_USER_PRIVILEGE_VIEW\",\"ROLE_ACCOUNT_SETTINGS_VIEW\",\"ROLE_PRODUCT_MANAGEMENT_VIEW\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_VIEW\",\"ROLE_CUSTOMER_MANAGEMENT_VIEW\",\"ROLE_BOARD_SETTINGS_VIEW\",\"ROLE_ASSY_STOCK_MANAGEMENT_VIEW\",\"ROLE_SMT_STOCK_MANAGEMENT_VIEW\",\"ROLE_DAILY_PLAN_VIEW\",\"ROLE_WORKORDER_DETAILS_VIEW\",\"ROLE_DOWNTIME_PLANNING_VIEW\",\"ROLE_IMPORT_HISTORY_VIEW\",\"ROLE_RUNNING_ORDER_VIEW\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_VIEW\",\"ROLE_ACTIVITY_LOG_VIEW\",\"ROLE_MANAGE_SHIFT_VIEW\",\"ROLE_OEE_DAILY_TARGET_VIEW\"]';
  36.             ");
  37.             
  38.     }
  39. }