migrations/Version20230705102937.php line 1

Open in your IDE?
  1. <?php
  3. /**
  4.  * @noinspection PhpUnused
  5.  * @noinspection PhpInternalEntityUsedInspection
  6.  */
  8. declare(strict_types=1);
  10. namespace DoctrineMigrations;
  12. use App\Helper\Api\Constants\Roles\AccidentManagement;
  13. use App\Helper\Api\Constants\Roles\Cmr;
  14. use App\Helper\Api\Constants\Roles\CoreModule;
  15. use App\Helper\Api\Constants\Roles\JobLab;
  16. use App\Helper\Api\Constants\Roles\MedicalSurveillance;
  17. use App\Helper\Api\Constants\Roles\OperationalIntegrationManagement;
  18. use App\Helper\Api\Constants\Roles\SkillScreening;
  19. use App\Helper\Api\Constants\Roles\SocialCounseling;
  20. use App\Helper\Api\Constants\Roles\WorkplaceConfigurator;
  21. use App\Validator\Constraints\Api\CoreModule\Module\AbstractModuleIdCompound;
  22. use Doctrine\DBAL\Schema\Schema;
  23. use Doctrine\Migrations\AbstractMigration;
  25. /**
  26.  * Auto-generated Migration: Please modify to your needs!
  27.  *
  28.  * @package API
  29.  * @internal
  30.  */
  31. final class Version20230705102937 extends AbstractMigration
  32. {
  34.     /**
  35.      * Local admin role name.
  36.      *
  37.      * Prevent SonarQube issue php:S1192 String literals should not be duplicated.
  38.      *
  39.      * @var string
  40.      */
  41.     public const LOCAL_ADMIN = 'Local admin';
  43.     public function down(Schema $schema): void
  44.     {
  45.         // this down() migration is auto-generated, please modify it to your needs
  46.     }
  48.     public function getDescription(): string
  49.     {
  50.         return
  51.             "- Seeding of role table.";
  52.     }
  54.     /**
  55.      * @param Schema $schema
  56.      * @return void
  57.      *
  58.      */
  59.     public function up(Schema $schema): void
  60.     {
  61.         // this up() migration is auto-generated, please modify it to your needs
  62.         $roles = [
  63.             AbstractModuleIdCompound::CORE_MODULE_MODULE_ID => [
  64.                 CoreModule::ROLE_CORE_MODULE_EMPLOYEE_MANAGER => 'Employee manager',
  65.                 CoreModule::ROLE_CORE_MODULE_HEALTH_INSURANCE_PROVIDER_MANAGER => 'Health insurance provider manager',
  66.                 CoreModule::ROLE_CORE_MODULE_ORG_UNIT_MANAGER => 'Organizational unit manager',
  67.                 CoreModule::ROLE_CORE_MODULE_ROLE_MANAGER => 'Role manager',
  68.                 CoreModule::ROLE_CORE_MODULE_SETTINGS_MANAGER => 'Settings manager',
  69.                 CoreModule::ROLE_CORE_MODULE_USER_MANAGER => 'User manager'
  70.             ],
  71.             AbstractModuleIdCompound::ACCIDENT_MANAGEMENT_MODULE_ID => [
  72.                 AccidentManagement::ROLE_ACCIDENT_MANAGEMENT_DATA_MANAGER => 'Accident ' . self::LOCAL_ADMIN,
  73.                 AccidentManagement::ROLE_ACCIDENT_MANAGEMENT_EMPLOYEE_REPRESENTATIVE => 'Work council',
  74.                 AccidentManagement::ROLE_ACCIDENT_MANAGEMENT_HEALTH_AND_SAFETY_OFFICER => 'Authorized person',
  75.                 AccidentManagement::ROLE_ACCIDENT_MANAGEMENT_SETTINGS_MANAGER => 'Accident management settings manager',
  76.                 AccidentManagement::ROLE_ACCIDENT_MANAGEMENT_USER => 'Accident management user'
  77.             ],
  78.             AbstractModuleIdCompound::OPERATIONAL_INTEGRATION_MANAGEMENT_MODULE_ID => [
  79.                 OperationalIntegrationManagement::ROLE_OPERATIONAL_INTEGRATION_MANAGEMENT_DATA_MANAGER =>
  80.                     'OIM ' . self::LOCAL_ADMIN,
  81.                 OperationalIntegrationManagement::ROLE_OPERATIONAL_INTEGRATION_MANAGEMENT_MANAGER =>
  82.                     'Operational integration management manager',
  83.                 OperationalIntegrationManagement::ROLE_OPERATIONAL_INTEGRATION_MANAGEMENT_SETTINGS_MANAGER =>
  84.                     'Operational integration management settings manager'
  85.             ],
  86.             AbstractModuleIdCompound::WORKPLACE_CONFIGURATOR_MODULE_ID => [
  87.                 WorkplaceConfigurator::ROLE_WORKPLACE_CONFIGURATOR_MANAGER => 'Workplace configurator manager',
  88.                 WorkplaceConfigurator::ROLE_WORKPLACE_CONFIGURATOR_SCREENING_MANAGER => 'Workplace screening manager',
  89.                 WorkplaceConfigurator::ROLE_WORKPLACE_CONFIGURATOR_DATA_MANAGER => 'Workplace ' . self::LOCAL_ADMIN
  90.             ],
  91.             AbstractModuleIdCompound::SKILL_SCREENING_MODULE_ID => [
  92.                 SkillScreening::ROLE_SKILL_SCREENING_MANAGER => 'Skill screening manager',
  93.                 SkillScreening::ROLE_SKILL_SCREENING_DATA_MANAGER => 'Skill screening ' . self::LOCAL_ADMIN
  94.             ],
  95.             AbstractModuleIdCompound::JOB_LAB_MODULE_ID => [
  96.                 JobLab::ROLE_JOB_LAB_DATA_MANAGER => 'Job lab ' . self::LOCAL_ADMIN,
  97.                 JobLab::ROLE_JOB_LAB_MANAGER => 'Job integration manager',
  98.                 JobLab::ROLE_JOB_LAB_SETTINGS_MANAGER => 'Job integration settings manager'
  99.             ],
  100.             AbstractModuleIdCompound::SOCIAL_COUNSELING_MODULE_ID => [
  101.                 SocialCounseling::ROLE_SOCIAL_COUNSELING_SETTINGS_MANAGER => 'SOB settings manager',
  102.                 SocialCounseling::ROLE_SOCIAL_COUNSELING_MANAGER => 'SOB manager',
  103.                 SocialCounseling::ROLE_SOCIAL_COUNSELING_DATA_MANAGER => 'SOB ' . self::LOCAL_ADMIN,
  104.                 SocialCounseling::ROLE_SOCIAL_COUNSELING_REGISTRAR => 'SOB registrar',
  105.             ],
  106.             AbstractModuleIdCompound::MEDICAL_SURVEILLANCE_ID => [
  107.                 MedicalSurveillance::ROLE_MEDICAL_SURVEILLANCE_SETTINGS_MANAGER => 'Medical surveillance settings manager',
  108.                 MedicalSurveillance::ROLE_MEDICAL_SURVEILLANCE_MANAGER => 'Medical surveillance manager',
  109.                 MedicalSurveillance::ROLE_MEDICAL_SURVEILLANCE_DATA_MANAGER => 'Medical surveillance ' . self::LOCAL_ADMIN,
  110.                 MedicalSurveillance::ROLE_MEDICAL_SURVEILLANCE_MEDICAL_MANAGER => 'Medical surveillance medical manager',
  111.                 MedicalSurveillance::ROLE_MEDICAL_SURVEILLANCE_SAFETY_MANAGER => 'Medical surveillance safety manager',
  112.                 MedicalSurveillance::ROLE_MEDICAL_SURVEILLANCE_SAFETY_OFFICER => 'Medical surveillance safety officer',
  113.             ],
  114.             AbstractModuleIdCompound::CMR_MODULE_ID => [
  115.                 Cmr::ROLE_CMR_DATA_MANAGER => 'Cmr ' . self::LOCAL_ADMIN,
  116.                 Cmr::ROLE_CMR_MANAGER => 'Cmr manager',
  117.                 Cmr::ROLE_CMR_SETTINGS_MANAGER => 'Cmr settings manager'
  118.             ],
  119.         ];
  120.         foreach ($roles as $moduleId => $roleDataSets) {
  121.             foreach ($roleDataSets as $id => $name) {
  122.                 $this->addSql(
  123.                     '
  124.                     INSERT INTO role
  125.                         (id, name, module_id)
  126.                     VALUES
  127.                         (:id, :name, :moduleId)
  128.                     ;
  129.                 ',
  130.                     [
  131.                         'id' => $id,
  132.                         'name' => $name,
  133.                         'moduleId' => $moduleId
  134.                     ]
  135.                 );
  136.             }
  137.         }
  138.     }
  140. }