migrations/Version20230510094651.php line 1

Open in your IDE?
  1. <?php
  3. /* @noinspection PhpUnused */
  5. declare(strict_types=1);
  7. namespace DoctrineMigrations;
  9. use Doctrine\DBAL\Schema\Schema;
  10. use Doctrine\Migrations\AbstractMigration;
  12. /**
  13.  * Auto-generated Migration: Please modify to your needs!
  14.  *
  15.  * @package API
  16.  * @internal
  17.  */
  18. final class Version20230510094651 extends AbstractMigration
  19. {
  21.     public function down(Schema $schema): void
  22.     {
  23.         // this down() migration is auto-generated, please modify it to your needs
  24.     }
  26.     public function getDescription(): string
  27.     {
  28.         return
  29.             "- Seeding of measure and measure category tables.\n" .
  30.             "- Seeding of measure and measure category localizations with German and English.\n" .
  31.             "- Seeding of social_security_agency table.\n" .
  32.             "- Seeding of social_security_agency localizations with German and English.\n" .
  33.             "- Seeding of oim_status table.\n" .
  34.             "- Seeding of oim_status localizations with German and English.";
  35.     }
  37.     public function up(Schema $schema): void
  38.     {
  39.         // this up() migration is auto-generated, please modify it to your needs
  40.         $created = time();
  41.         $this->addSql(
  42.             '
  43.                 INSERT INTO oim_measure_category
  44.                     (id, created, active)
  45.                 VALUES
  46.                     (1, :createdTimeStamp, 1),
  47.                     (2, :createdTimeStamp, 1),
  48.                     (3, :createdTimeStamp, 1),
  49.                     (4, :createdTimeStamp, 1)
  50.                 ;
  51.             ',
  52.             ['createdTimeStamp' => $created]
  53.         );
  54.         $this->addSql(
  55.             '
  56.                 INSERT INTO oim_measure_category_l10n
  57.                     (language_id, parent_entity_id, name)
  58.                 VALUES
  59.                     (\'de\', 1, \'Technisch\'),
  60.                     (\'de\', 2, \'Organisatorisch\'),
  61.                     (\'de\', 3, \'Persönlich\'),
  62.                     (\'de\', 4, \'SV-Maßnahme\'),
  63.                     (\'en\', 1, \'Technical\'),
  64.                     (\'en\', 2, \'Organisational\'),
  65.                     (\'en\', 3, \'Personal\'),
  66.                     (\'en\', 4, \'Delegated to Social Security\')
  67.                 ;
  68.             '
  69.         );
  70.         $this->addSql(
  71.             '
  72.                 INSERT INTO oim_measure
  73.                     (id, created, category_id, active)
  74.                 VALUES
  75.                     (1, :createdTimeStamp, 1, 1),
  76.                     (2, :createdTimeStamp, 1, 1),
  77.                     (3, :createdTimeStamp, 1, 1),
  78.                     (4, :createdTimeStamp, 2, 1),
  79.                     (5, :createdTimeStamp, 2, 1),
  80.                     (6, :createdTimeStamp, 2, 1),
  81.                     (7, :createdTimeStamp, 2, 1),
  82.                     (8, :createdTimeStamp, 2, 1),
  83.                     (9, :createdTimeStamp, 2, 1),
  84.                     (10, :createdTimeStamp, 2, 1),
  85.                     (11, :createdTimeStamp, 3, 1),
  86.                     (12, :createdTimeStamp, 4, 1),
  87.                     (13, :createdTimeStamp, 4, 1),
  88.                     (14, :createdTimeStamp, 4, 1),
  89.                     (15, :createdTimeStamp, 4, 1)
  90.                 ;
  91.             ',
  92.             ['createdTimeStamp' => $created]
  93.         );
  94.         $this->addSql(
  95.             '
  96.                 INSERT INTO oim_measure_l10n
  97.                     (language_id, parent_entity_id, name)
  98.                 VALUES
  99.                     (\'de\', 1, \'Stehhilfe\'),
  100.                     (\'de\', 2, \'Tischhöhe angepasst\'),
  101.                     (\'de\', 3, \'Schuheinlagen\'),
  102.                     (\'de\', 4, \'Abteilungswechsel\'),
  103.                     (\'de\', 5, \'Schichtwechsel\'),
  104.                     (\'de\', 6, \'Dauerschicht\'),
  105.                     (\'de\', 7, \'Verbleib in Abteilung\'),
  106.                     (\'de\', 8, \'Keine Verschiebung\'),
  107.                     (\'de\', 9, \'Neue Wiedereingliederung\'),
  108.                     (\'de\', 10, \'Arbeitsversuch\'),
  109.                     (\'de\', 11, \'Gespräch mit Vorges.\'),
  110.                     (\'de\', 12, \'Termin Betriebsarzt\'),
  111.                     (\'de\', 13, \'Eingansuntersuchung\'),
  112.                     (\'de\', 14, \'Zwischenuntersuchung\'),
  113.                     (\'de\', 15, \'Abschlussuntersuchung\'),
  114.                     (\'en\', 1, \'Upright Working Support Device\'),
  115.                     (\'en\', 2, \'Adapted Height of Workdesk\'),
  116.                     (\'en\', 3, \'Insoles\'),
  117.                     (\'en\', 4, \'Transfer to Another Department\'),
  118.                     (\'en\', 5, \'Change of Shift\'),
  119.                     (\'en\', 6, \'Permanent constant shift\'),
  120.                     (\'en\', 7, \'Continuance in Current Department\'),
  121.                     (\'en\', 8, \'No Transfer\'),
  122.                     (\'en\', 9, \'New OIM Process to be Started\'),
  123.                     (\'en\', 10, \'Work Attempt\'),
  124.                     (\'en\', 11, \'Meeting with Line Manager\'),
  125.                     (\'en\', 12, \'Appointment with Company Medical Officer\'),
  126.                     (\'en\', 13, \'Initial Medical Examination\'),
  127.                     (\'en\', 14, \'Intermediate Medical Examination\'),
  128.                     (\'en\', 15, \'Final Medical Examination\')
  129.                 ;
  130.             '
  131.         );
  132.         $this->addSql(
  133.             '
  134.             INSERT INTO social_security_agency
  135.                     (id, created, active)
  136.                 VALUES
  137.                     (1, :createdTimeStamp, 1),
  138.                     (2, :createdTimeStamp, 1),
  139.                     (3, :createdTimeStamp, 1),
  140.                     (4, :createdTimeStamp, 1),
  141.                     (5, :createdTimeStamp, 1),
  142.                     (6, :createdTimeStamp, 1)
  143.                 ;
  144.             ',
  145.             ['createdTimeStamp' => $created]
  146.         );
  147.         $this->addSql(
  148.             '
  149.                 INSERT INTO social_security_agency_l10n
  150.                     (language_id, parent_entity_id, name)
  151.                 VALUES
  152.                     (\'de\', 1, \'Krankenkasse\'),
  153.                     (\'de\', 2, \'DRV\'),
  154.                     (\'de\', 3, \'Integrationsamt\'),
  155.                     (\'de\', 4, \'Berufsgenossenschaft\'),
  156.                     (\'de\', 5, \'Arbeitsagentur\'),
  157.                     (\'de\', 6, \'Arbeitgeber\'),
  158.                     (\'en\', 1, \'Health Insurance\'),
  159.                     (\'en\', 2, \'German Pension Insurance\'),
  160.                     (\'en\', 3, \'Public Integration Office\'),
  161.                     (\'en\', 4, \'Employers Insurance Association\'),
  162.                     (\'en\', 5, \'Job Center\'),
  163.                     (\'en\', 6, \'Employer\')
  164.                 ;
  165.             '
  166.         );
  168.         $this->addSql(
  169.             '
  170.             INSERT INTO oim_status
  171.                     (id, created, active, internal_status_id)
  172.                 VALUES
  173.                     (1, :createdTimeStamp, 1, \'active\'),
  174.                     (2, :createdTimeStamp, 1, \'active\'),
  175.                     (3, :createdTimeStamp, 1, \'active\'),
  176.                     (4, :createdTimeStamp, 1, \'canceled\'),
  177.                     (5, :createdTimeStamp, 1, \'completed\'),
  178.                     (6, :createdTimeStamp, 1, \'canceled\'),
  179.                     (7, :createdTimeStamp, 1, \'active\'),
  180.                     (8, :createdTimeStamp, 1, \'canceled\'),
  181.                     (9, :createdTimeStamp, 1, \'canceled\'),
  182.                     (10, :createdTimeStamp, 1, \'canceled\'),
  183.                     (11, :createdTimeStamp, 1, \'active\'),
  184.                     (12, :createdTimeStamp, 1, \'active\'),
  185.                     (13, :createdTimeStamp, 1, \'active\'),
  186.                     (14, :createdTimeStamp, 1, \'active\'),
  187.                     (15, :createdTimeStamp, 1, \'canceled\'),
  188.                     (16, :createdTimeStamp, 1, \'active\'),
  189.                     (17, :createdTimeStamp, 1, \'active\'),
  190.                     (18, :createdTimeStamp, 1, \'active\'),
  191.                     (19, :createdTimeStamp, 1, \'active\')
  192.                 ;
  193.             ',
  194.             ['createdTimeStamp' => $created]
  195.         );
  197.         $this->addSql(
  198.             '
  199.             INSERT INTO oim_status_l10n
  200.                     (language_id, parent_entity_id, name)
  201.                 VALUES
  202.                     (\'de\', 1, \'BEM angenommen\'),
  203.                     (\'de\', 2, \'BEM angenommen - meldet sich nach AU\'),
  204.                     (\'de\', 3, \'BEM angenommen - MA wartet auf Termin\'),
  205.                     (\'de\', 4, \'BEM abgelehnt\'),
  206.                     (\'de\', 5, \'BEM erfolgreich abgeschlossen\'),
  207.                     (\'de\', 6, \'BEM nicht erfolgreich abgeschlossen\'),
  208.                     (\'de\', 7, \'BEM berechtigt - kein BEM möglich\'),
  209.                     (\'de\', 8, \'BEM beendet (Abbruch)\'),
  210.                     (\'de\', 9, \'BEM beendet da keine Antwort\'),
  211.                     (\'de\', 10, \'BEM beendet\'),
  212.                     (\'de\', 11, \'Infogespräch - warten auf Antwort\'),
  213.                     (\'de\', 12, \'Keine Antwort\'),
  214.                     (\'de\', 13, \'1. Einladung, keine Antwort\'),
  215.                     (\'de\', 14, \'1. Einladung, keine Antwort\'),
  216.                     (\'de\', 15, \'Nicht BEM berechtigt\'),
  217.                     (\'de\', 16, \'BEM berechtigt - noch kein Angebot\'),
  218.                     (\'de\', 17, \'Post-Unzustellbar\'),
  219.                     (\'de\', 18, \'Post-Annahme verweigert\'),
  220.                     (\'de\', 19, \'BEM angeschrieben\'),
  221.                     (\'en\', 1, \'OIM Accepted\'),
  222.                     (\'en\', 2, \'OIM Accepted - Employee will contact\'),
  223.                     (\'en\', 3, \'OIM Accepted - Employee waits for appointment\'),
  224.                     (\'en\', 4, \'OIM Declined\'),
  225.                     (\'en\', 5, \'OIM Completed Successfully\'),
  226.                     (\'en\', 6, \'OIM Completed Unsuccessfully\'),
  227.                     (\'en\', 7, \'Employee Eligible for OIM - no OIM possible\'),
  228.                     (\'en\', 8, \'OIM Completed (Cancelled)\'),
  229.                     (\'en\', 9, \'OIM Cancelled - No Answer\'),
  230.                     (\'en\', 10, \'OIM Completed\'),
  231.                     (\'en\', 11, \'OIM Briefing - waiting for response\'),
  232.                     (\'en\', 12, \'No Response\'),
  233.                     (\'en\', 13, \'1st Invitation - no response\'),
  234.                     (\'en\', 14, \'2nd Invitation - no response\'),
  235.                     (\'en\', 15, \'Employee Not Eligible for OIM\'),
  236.                     (\'en\', 16, \'Employee Eligible for OIM - official offer pending\'),
  237.                     (\'en\', 17, \'Letter Mail Not Deliverable\'),
  238.                     (\'en\', 18, \'Letter Mail Declined by Receiver\'),
  239.                     (\'en\', 19, \'OIM Letter Mail Sent to Employee\')
  240.                 ;
  241.             '
  242.         );
  243.     }
  245. }