migrations/Version20250318095465.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\Validator\Constraints\Api\SocialCounseling\CategoryType\AbstractCategoryTypeIdCompound;
  13. use Doctrine\DBAL\Schema\Schema;
  14. use Doctrine\Migrations\AbstractMigration;
  16. /**
  17.  * Auto-generated Migration: Please modify to your needs!
  18.  */
  19. final class Version20250318095465 extends AbstractMigration
  20. {
  22.     public function down(Schema $schema): void
  23.     {
  24.         // this down() migration is auto-generated, please modify it to your needs
  25.     }
  27.     public function getDescription(): string
  28.     {
  29.         return 'Seeding of SOB assistance categories and topics.';
  30.     }
  32.     public function up(Schema $schema): void
  33.     {
  34.         // this up() migration is auto-generated, please modify it to your needs
  35.         // personal categories
  36.         $created = time();
  37.         $this->addSql(
  38.             '
  39.                 INSERT INTO sob_employee_assistance_category
  40.                     (id, created, type_id, active)
  41.                 VALUES
  42.                     (1, :createdTimeStamp, :typeId, 1),
  43.                     (2, :createdTimeStamp, :typeId, 1),
  44.                     (3, :createdTimeStamp, :typeId, 1),
  45.                     (4, :createdTimeStamp, :typeId, 1),
  46.                     (5, :createdTimeStamp, :typeId, 1)
  47.                 ;
  48.             ',
  49.             ['createdTimeStamp' => $created, 'typeId' => AbstractCategoryTypeIdCompound::PERSONAL]
  50.         );
  52.         // leadership categories
  53.         $this->addSql(
  54.             '
  55.                 INSERT INTO sob_employee_assistance_category
  56.                     (id, created, type_id, active)
  57.                 VALUES
  58.                     (6, :createdTimeStamp, :typeId, 1),
  59.                     (7, :createdTimeStamp, :typeId, 1),
  60.                     (8, :createdTimeStamp, :typeId, 1),
  61.                     (9, :createdTimeStamp, :typeId, 1)
  62.                 ;
  63.             ',
  64.             ['createdTimeStamp' => $created, 'typeId' => AbstractCategoryTypeIdCompound::LEADERSHIP]
  65.         );
  67.         // Localized names for categories
  68.         $this->addSql(
  69.             '
  70.                 INSERT INTO sob_employee_assistance_category_l10n
  71.                     (language_id, parent_entity_id, name)
  72.                 VALUES
  73.                     (\'de\', 1, \'Abhängigkeit/Missbrauch\'),
  74.                     (\'de\', 2, \'Arbeitsplatz\'),
  75.                     (\'de\', 3, \'Persönliche Themen\'),
  76.                     (\'de\', 4, \'Psychische Themen\'),
  77.                     (\'de\', 5, \'Veränderungen\'),
  78.                     (\'de\', 6, \'Beratung in Bereichs-/Centerthemen\'),
  79.                     (\'de\', 7, \'Beratung zum Führungsverhalten\'),
  80.                     (\'de\', 8, \'Mitarbeiterbezogene Beratung\'),
  81.                     (\'de\', 9, \'Persönlichkeitsberatung\'),
  82.                     (\'en\', 1, \'Addiction/Abuse\'),
  83.                     (\'en\', 2, \'Workplace\'),
  84.                     (\'en\', 3, \'Personal issues\'),
  85.                     (\'en\', 4, \'Psychological issues\'),
  86.                     (\'en\', 5, \'Changes\'),
  87.                     (\'en\', 6, \'Departmental/center topics consultation\'),
  88.                     (\'en\', 7, \'Leadership behavior consultation\'),
  89.                     (\'en\', 8, \'Employee-related consultation\'),
  90.                     (\'en\', 9, \'Personality counseling\')
  91.                 ;
  92.             '
  93.         );
  95.         // Seeding of SOB employee assistance topics for Addiction/Abuse category
  96.         $this->addSql(
  97.             '
  98.                 INSERT INTO sob_employee_assistance_topic
  99.                     (id, created, category_id, active)
  100.                 VALUES
  101.                     (1, :createdTimeStamp, :categoryId, 1),
  102.                     (2, :createdTimeStamp, :categoryId, 1),
  103.                     (3, :createdTimeStamp, :categoryId, 1),
  104.                     (4, :createdTimeStamp, :categoryId, 1),
  105.                     (5, :createdTimeStamp, :categoryId, 1),
  106.                     (6, :createdTimeStamp, :categoryId, 1)
  107.                 ;
  108.             ',
  109.             ['createdTimeStamp' => $created, 'categoryId' => 1]
  110.         );
  112.         // Seeding of SOB employee assistance topics for Workplace category
  113.         $this->addSql(
  114.             '
  115.                 INSERT INTO sob_employee_assistance_topic
  116.                     (id, created, category_id, active)
  117.                 VALUES
  118.                     (7, :createdTimeStamp, :categoryId, 1),
  119.                     (8, :createdTimeStamp, :categoryId, 1),
  120.                     (9, :createdTimeStamp, :categoryId, 1),
  121.                     (10, :createdTimeStamp, :categoryId, 1),
  122.                     (11, :createdTimeStamp, :categoryId, 1),
  123.                     (12, :createdTimeStamp, :categoryId, 1),
  124.                     (13, :createdTimeStamp, :categoryId, 1),
  125.                     (14, :createdTimeStamp, :categoryId, 1),
  126.                     (15, :createdTimeStamp, :categoryId, 1),
  127.                     (16, :createdTimeStamp, :categoryId, 1)
  128.                 ;
  129.             ',
  130.             ['createdTimeStamp' => $created, 'categoryId' => 2]
  131.         );
  133.         // Seeding of SOB employee assistance topics for Personal Issues category
  134.         $this->addSql(
  135.             '
  136.                 INSERT INTO sob_employee_assistance_topic
  137.                     (id, created, category_id, active)
  138.                 VALUES
  139.                     (17, :createdTimeStamp, :categoryId, 1),
  140.                     (18, :createdTimeStamp, :categoryId, 1),
  141.                     (19, :createdTimeStamp, :categoryId, 1),
  142.                     (20, :createdTimeStamp, :categoryId, 1)
  143.                 ;
  144.             ',
  145.             ['createdTimeStamp' => $created, 'categoryId' => 3]
  146.         );
  148.         // Seeding of SOB employee assistance topics for Psychological Issues category
  149.         $this->addSql(
  150.             '
  151.                 INSERT INTO sob_employee_assistance_topic
  152.                     (id, created, category_id, active)
  153.                 VALUES
  154.                     (21, :createdTimeStamp, :categoryId, 1),
  155.                     (22, :createdTimeStamp, :categoryId, 1),
  156.                     (23, :createdTimeStamp, :categoryId, 1),
  157.                     (24, :createdTimeStamp, :categoryId, 1),
  158.                     (25, :createdTimeStamp, :categoryId, 1)
  159.                 ;
  160.             ',
  161.             ['createdTimeStamp' => $created, 'categoryId' => 4]
  162.         );
  164.         // Seeding of SOB employee assistance topics for Changes category
  165.         $this->addSql(
  166.             '
  167.                 INSERT INTO sob_employee_assistance_topic
  168.                     (id, created, category_id, active)
  169.                 VALUES
  170.                     (26, :createdTimeStamp, :categoryId, 1),
  171.                     (27, :createdTimeStamp, :categoryId, 1),
  172.                     (28, :createdTimeStamp, :categoryId, 1),
  173.                     (29, :createdTimeStamp, :categoryId, 1),
  174.                     (30, :createdTimeStamp, :categoryId, 1),
  175.                     (31, :createdTimeStamp, :categoryId, 1),
  176.                     (32, :createdTimeStamp, :categoryId, 1),
  177.                     (33, :createdTimeStamp, :categoryId, 1),
  178.                     (34, :createdTimeStamp, :categoryId, 1),
  179.                     (35, :createdTimeStamp, :categoryId, 1)
  180.                 ;
  181.             ',
  182.             ['createdTimeStamp' => $created, 'categoryId' => 5]
  183.         );
  185.         // Seeding of SOB employee assistance topics for Departmental/Center Topics category
  186.         $this->addSql(
  187.             '
  188.                 INSERT INTO sob_employee_assistance_topic
  189.                     (id, created, category_id, active)
  190.                 VALUES
  191.                     (36, :createdTimeStamp, :categoryId, 1),
  192.                     (37, :createdTimeStamp, :categoryId, 1),
  193.                     (38, :createdTimeStamp, :categoryId, 1),
  194.                     (39, :createdTimeStamp, :categoryId, 1),
  195.                     (40, :createdTimeStamp, :categoryId, 1),
  196.                     (41, :createdTimeStamp, :categoryId, 1),
  197.                     (42, :createdTimeStamp, :categoryId, 1),
  198.                     (43, :createdTimeStamp, :categoryId, 1),
  199.                     (44, :createdTimeStamp, :categoryId, 1),
  200.                     (45, :createdTimeStamp, :categoryId, 1),
  201.                     (46, :createdTimeStamp, :categoryId, 1)
  202.                 ;
  203.             ',
  204.             ['createdTimeStamp' => $created, 'categoryId' => 6]
  205.         );
  207.         // Seeding of SOB employee assistance topics for Leadership Behavior Consultation category
  208.         $this->addSql(
  209.             '
  210.                 INSERT INTO sob_employee_assistance_topic
  211.                     (id, created, category_id, active)
  212.                 VALUES
  213.                     (47, :createdTimeStamp, :categoryId, 1)
  214.                 ;
  215.             ',
  216.             ['createdTimeStamp' => $created, 'categoryId' => 7]
  217.         );
  219.         // Seeding of SOB employee assistance topics for Employee-Related Consultation category
  220.         $this->addSql(
  221.             '
  222.                 INSERT INTO sob_employee_assistance_topic
  223.                     (id, created, category_id, active)
  224.                 VALUES
  225.                     (48, :createdTimeStamp, :categoryId, 1),
  226.                     (49, :createdTimeStamp, :categoryId, 1),
  227.                     (50, :createdTimeStamp, :categoryId, 1),
  228.                     (51, :createdTimeStamp, :categoryId, 1),
  229.                     (52, :createdTimeStamp, :categoryId, 1),
  230.                     (53, :createdTimeStamp, :categoryId, 1),
  231.                     (54, :createdTimeStamp, :categoryId, 1)
  232.                 ;
  233.             ',
  234.             ['createdTimeStamp' => $created, 'categoryId' => 8]
  235.         );
  237.         // Seeding of SOB employee assistance topics for Personality Counseling category
  238.         $this->addSql(
  239.             '
  240.                 INSERT INTO sob_employee_assistance_topic
  241.                     (id, created, category_id, active)
  242.                 VALUES
  243.                     (55, :createdTimeStamp, :categoryId, 1),
  244.                     (56, :createdTimeStamp, :categoryId, 1),
  245.                     (57, :createdTimeStamp, :categoryId, 1)
  246.                 ;
  247.             ',
  248.             ['createdTimeStamp' => $created, 'categoryId' => 9]
  249.         );
  251.         // Localized names for topics for Addiction/Abuse category
  252.         $this->addSql(
  253.             '
  254.                 INSERT INTO sob_employee_assistance_topic_l10n
  255.                     (language_id, parent_entity_id, name)
  256.                 VALUES
  257.                     (\'de\', 1, \'Alkohol\'),
  258.                     (\'de\', 2, \'Andere\'),
  259.                     (\'de\', 3, \'Illegale Drogen\'),
  260.                     (\'de\', 4, \'Medikamente\'),
  261.                     (\'de\', 5, \'Gaming\'),
  262.                     (\'de\', 6, \'Internet\'),
  263.                     (\'de\', 7, \'Arbeitssicherheit\'),
  264.                     (\'de\', 8, \'Diskriminierung\'),
  265.                     (\'de\', 9, \'Kollegiale Konflikte\'),
  266.                     (\'de\', 10, \'Konflikte mit Arbeitsbedingungen\'),
  267.                     (\'de\', 11, \'Konflikte mit der Führung\'),
  268.                     (\'de\', 12, \'Mobbing\'),
  269.                     (\'de\', 13, \'MOVE\'),
  270.                     (\'de\', 14, \'Sexuelle Belästigung\'),
  271.                     (\'de\', 15, \'Unfaires Verhalten\'),
  272.                     (\'de\', 16, \'Veränderung\'),
  273.                     (\'de\', 17, \'Berufliche Krise\'),
  274.                     (\'de\', 18, \'Familiäre/private Probleme\'),
  275.                     (\'de\', 19, \'Finanzielle Probleme\'),
  276.                     (\'de\', 20, \'Persönlichkeitsberatung\'),
  277.                     (\'de\', 21, \'Bezug zum Arbeitsplatz\'),
  278.                     (\'de\', 22, \'Persönlichkeitsbezogene Auffälligkeiten\'),
  279.                     (\'de\', 23, \'Psychische Störung\'),
  280.                     (\'de\', 24, \'Psychisches Befinden\'),
  281.                     (\'de\', 25, \'Psychosomatik\'),
  282.                     (\'de\', 26, \'Veränderung der Organisationsstruktur\'),
  283.                     (\'de\', 27, \'Veränderung von Rolle oder Verantwortlichkeiten\'),
  284.                     (\'de\', 28, \'Veränderung von Prozessen oder Arbeitsabläufen\'),
  285.                     (\'de\', 29, \'Veränderung von Technologien oder IT-Systemen\'),
  286.                     (\'de\', 30, \'Veränderung des Arbeitsortes oder Arbeitsplatzes\'),
  287.                     (\'de\', 31, \'Veränderung von Richtlinien oder Compliance-Vorgaben\'),
  288.                     (\'de\', 32, \'Veränderung der Teamzusammensetzung\'),
  289.                     (\'de\', 33, \'Veränderung der Berichtslinie\'),
  290.                     (\'de\', 34, \'Veränderung von Schicht- oder Arbeitszeiten\'),
  291.                     (\'de\', 35, \'Veränderung von Vergütung oder Benefits\'),
  292.                     (\'de\', 36, \'Andere\'),
  293.                     (\'de\', 37, \'Anwesenheit\'),
  294.                     (\'de\', 38, \'Auswirkung von Veränderungsprozessen\'),
  295.                     (\'de\', 39, \'Demographie/Altersstruktur\'),
  296.                     (\'de\', 40, \'Fluktuation\'),
  297.                     (\'de\', 41, \'Genderthemen\'),
  298.                     (\'de\', 42, \'Konflikte\'),
  299.                     (\'de\', 43, \'Projekte\'),
  300.                     (\'de\', 44, \'Seminar\'),
  301.                     (\'de\', 45, \'Sonstiges\'),
  302.                     (\'de\', 46, \'Workshop\'),
  303.                     (\'de\', 47, \'Förderung Führungskompetenz\'),
  304.                     (\'de\', 48, \'Führungsverhalten bzgl. Mitarbeiter\'),
  305.                     (\'de\', 49, \'Auffälliges Verhalten\'),
  306.                     (\'de\', 50, \'Corona\'),
  307.                     (\'de\', 51, \'Eigener Anteil im Führungsverhalten\'),
  308.                     (\'de\', 52, \'Konflikte unter Mitarbeitern\'),
  309.                     (\'de\', 53, \'Konflikte zwischen MA und Führungskraft\'),
  310.                     (\'de\', 54, \'Sonstiges\'),
  311.                     (\'de\', 55, \'Coaching\'),
  312.                     (\'de\', 56, \'Supervision\'),
  313.                     (\'de\', 57, \'Veränderungen\'),
  314.                     (\'en\', 1, \'Alcohol\'),
  315.                     (\'en\', 2, \'Others\'),
  316.                     (\'en\', 3, \'Illegal substances\'),
  317.                     (\'en\', 4, \'Medication\'),
  318.                     (\'en\', 5, \'Gaming\'),
  319.                     (\'en\', 6, \'Internet\'),
  320.                     (\'en\', 7, \'Safety at work\'),
  321.                     (\'en\', 8, \'Discrimination\'),
  322.                     (\'en\', 9, \'Colleague conflicts\'),
  323.                     (\'en\', 10, \'Conflicts with working conditions\'),
  324.                     (\'en\', 11, \'Conflicts with management\'),
  325.                     (\'en\', 12, \'Bullying\'),
  326.                     (\'en\', 13, \'MOVE\'),
  327.                     (\'en\', 14, \'Sexual harassment\'),
  328.                     (\'en\', 15, \'Unfair behavior\'),
  329.                     (\'en\', 16, \'Change\'),
  330.                     (\'en\', 17, \'Career crisis\'),
  331.                     (\'en\', 18, \'Family/private issues\'),
  332.                     (\'en\', 19, \'Financial problems\'),
  333.                     (\'en\', 20, \'Personality counseling\'),
  334.                     (\'en\', 21, \'Work-related issues\'),
  335.                     (\'en\', 22, \'Personality-related abnormalities\'),
  336.                     (\'en\', 23, \'Psychological disorder\'),
  337.                     (\'en\', 24, \'Psychological well-being\'),
  338.                     (\'en\', 25, \'Psychosomatics\'),
  339.                     (\'en\', 26, \'Organizational structure change\'),
  340.                     (\'en\', 27, \'Role or responsibility change\'),
  341.                     (\'en\', 28, \'Process or workflow change\'),
  342.                     (\'en\', 29, \'Technology or system change\'),
  343.                     (\'en\', 30, \'Location or workplace change\'),
  344.                     (\'en\', 31, \'Policy or compliance change\'),
  345.                     (\'en\', 32, \'Team composition change\'),
  346.                     (\'en\', 33, \'Reporting line change\'),
  347.                     (\'en\', 34, \'Shift or working time change\'),
  348.                     (\'en\', 35, \'Compensation or benefit change\'),
  349.                     (\'en\', 36, \'Other\'),
  350.                     (\'en\', 37, \'Attendance\'),
  351.                     (\'en\', 38, \'Impact of change processes\'),
  352.                     (\'en\', 39, \'Demographics/age structure\'),
  353.                     (\'en\', 40, \'Employee turnover\'),
  354.                     (\'en\', 41, \'Gender issues\'),
  355.                     (\'en\', 42, \'Conflicts\'),
  356.                     (\'en\', 43, \'Projects\'),
  357.                     (\'en\', 44, \'Seminar\'),
  358.                     (\'en\', 45, \'Miscellaneous\'),
  359.                     (\'en\', 46, \'Workshop\'),
  360.                     (\'en\', 47, \'Promotion of leadership competency\'),
  361.                     (\'en\', 48, \'Leadership behavior regarding employees.\'),
  362.                     (\'en\', 49, \'Noticeable behavior\'),
  363.                     (\'en\', 50, \'COVID-19\'),
  364.                     (\'en\', 51, \'Own Share in leadership behavior\'),
  365.                     (\'en\', 52, \'Conflicts among employees\'),
  366.                     (\'en\', 53, \'Conflicts between employees and management\'),
  367.                     (\'en\', 54, \'Miscellaneous\'),
  368.                     (\'en\', 55, \'Coaching\'),
  369.                     (\'en\', 56, \'Supervision\'),
  370.                     (\'en\', 57, \'Changes\')
  371.                 ;
  372.             '
  373.         );
  374.     }
  376. }