migrations/Version20221121003520.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\CoreModule\Setting\AbstractSettingIdCompound;
  13. use App\Validator\Constraints\Api\CoreModule\Setting\AbstractSettingsGroupIdCompound;
  14. use App\Validator\Constraints\Api\CoreModule\Setting\Value\CoreModule\AccidentRetentionTimeSpanYearsCompound;
  15. use App\Validator\Constraints\Api\CoreModule\Setting\Value\CoreModule\DefaultItemsPerPageCompound;
  16. use App\Validator\Constraints\Api\CoreModule\Setting\Value\CoreModule\EntityRetentionTimeSpanDaysCompound;
  17. use App\Validator\Constraints\Api\CoreModule\Setting\Value\JobLabKOCriteria\DefaultKOCriteriaCompound;
  18. use App\Validator\Constraints\Api\CoreModule\Setting\Value\Ta\WeeksSickLeaveCompound;
  19. use Doctrine\DBAL\Schema\Schema;
  20. use Doctrine\Migrations\AbstractMigration;
  22. /**
  23.  * Auto-generated Migration: Please modify to your needs!
  24.  *
  25.  * @package API
  26.  * @internal
  27.  */
  28. final class Version20221121003520 extends AbstractMigration
  29. {
  31.     public function down(Schema $schema): void
  32.     {
  33.         // this down() migration is auto-generated, please modify it to your needs
  34.     }
  36.     public function getDescription(): string
  37.     {
  38.         return
  39.             "- Seeding of setting table.";
  40.     }
  42.     public function up(Schema $schema): void
  43.     {
  44.         // this up() migration is auto-generated, please modify it to your needs
  45.         $this->addSql(
  46.             "
  47.                 INSERT INTO setting
  48.                     (id, group_id, value)
  49.                 VALUES
  50.                     (:defaultItemsPerPage, :core_module, :defaultItemsPerPageValue),
  51.                     (:accidentRetentionTimeSpanYears, :core_module, :accidentRetentionTimeSpanYearsValue),
  52.                     (:entityRetentionTimeSpanDays, :core_module, :entityRetentionTimeSpanDaysValue),
  53.                     (:companyFullAddress, :ta, null),
  54.                     (:companyName, :ta, null),
  55.                     (:companyPhone, :ta, null),
  56.                     (:companyNumber, :ta, null),
  57.                     (:email, :ta, null),
  58.                     (:receiverFullAddress, :ta, null),
  59.                     (:receiverName, :ta, null),
  60.                     (:weeksSickLeave, :ta, :defaultWeeksSickLeaveValue);
  61.             ",
  62.             [
  63.                 'defaultItemsPerPage' => AbstractSettingIdCompound::CORE_MODULE_DEFAULT_ITEMS_PER_PAGE,
  64.                 'accidentRetentionTimeSpanYears' =>
  65.                     AbstractSettingIdCompound::CORE_MODULE_ACCIDENT_RETENTION_TIME_SPAN_YEARS,
  66.                 'entityRetentionTimeSpanDays' => AbstractSettingIdCompound::CORE_MODULE_ENTITY_RETENTION_TIME_SPAN_DAYS,
  67.                 'companyFullAddress' => AbstractSettingIdCompound::TA_COMPANY_FULL_ADDRESS,
  68.                 'companyName' => AbstractSettingIdCompound::TA_COMPANY_NAME,
  69.                 'companyPhone' => AbstractSettingIdCompound::TA_COMPANY_PHONE,
  70.                 'companyNumber' => AbstractSettingIdCompound::TA_COMPANY_NUMBER,
  71.                 'email' => AbstractSettingIdCompound::TA_EMAIL,
  72.                 'receiverFullAddress' => AbstractSettingIdCompound::TA_RECEIVER_FULL_ADDRESS,
  73.                 'receiverName' => AbstractSettingIdCompound::TA_RECEIVER_NAME,
  74.                 'weeksSickLeave' => AbstractSettingIdCompound::TA_WEEKS_SICK_LEAVE,
  75.                 'core_module' => AbstractSettingsGroupIdCompound::CORE_MODULE_SETTINGS_GROUP_ID,
  76.                 'ta' => AbstractSettingsGroupIdCompound::TRADE_ASSOCIATION_SETTINGS_GROUP_ID,
  77.                 'defaultItemsPerPageValue' => strval(DefaultItemsPerPageCompound::DEFAULT_ITEMS_PER_PAGE),
  78.                 'accidentRetentionTimeSpanYearsValue' => strval(
  79.                     AccidentRetentionTimeSpanYearsCompound::DEFAULT_ACCIDENT_RETENTION_TIME_SPAN_YEARS
  80.                 ),
  81.                 'entityRetentionTimeSpanDaysValue' => strval(
  82.                     EntityRetentionTimeSpanDaysCompound::DEFAULT_ENTITY_RETENTION_TIME_SPAN_DAYS
  83.                 ),
  84.                 'defaultWeeksSickLeaveValue' => strval(WeeksSickLeaveCompound::DEFAULT_WEEKS_SICK_LEAVE)
  85.             ]
  86.         );
  87.         $this->addSql(
  88.             "
  89.                 INSERT INTO setting
  90.                     (id, group_id, value)
  91.                 VALUES
  92.                     (:visualAcuityClose, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  93.                     (:visualAcuityFar, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  94.                     (:spatialVision, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  95.                     (:colorVision, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  96.                     (:soundOrSpeechRecognition, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  97.                     (:deploymentOnRotatingMachines, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  98.                     (:fallHazard, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  99.                     (:impairing_noise, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  100.                     (:dangerous_noise, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  101.                     (:fullBodyVibrations, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  102.                     (:rightHandArmVibration, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  103.                     (:leftHandArmVibrations, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  104.                     (:solventsAndVarnishes, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  105.                     (:gasesVaporsAerosolDustSmoke, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  106.                     (:oilFatEmulsions, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  107.                     (:wetWorks, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  108.                     (:electromagneticFields, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  109.                     (:heat, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  110.                     (:normalShift, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  111.                     (:alternationShiftWithoutNight, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  112.                     (:alternationShiftWithNight, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  113.                     (:permanentNightShift, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  114.                     (:rigidTactBinding, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  115.                     (:drivingAndSteeringActivities, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  116.                     (:withForkliftJob, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  117.                     (:driversLicenceB, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  118.                     (:driversLicenceCCE, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  119.                     (:driversLicenceFloorConveyors, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  120.                     (:seatingOpportunityAvailable, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  121.                     (:seatingWorkplace, :job_lab_ko_criteria, :defaultJobLabKOCriteria),
  122.                     (:workplaceWithVisibleColleagues, :job_lab_ko_criteria, :defaultJobLabKOCriteria);
  123.             ",
  124.             [
  125.                 'visualAcuityClose' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_VISUAL_ACUITY_CLOSE,
  126.                 'visualAcuityFar' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_VISUAL_ACUITY_FAR,
  127.                 'spatialVision' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_SPATIAL_VISION,
  128.                 'colorVision' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_COLOR_VISION,
  129.                 'soundOrSpeechRecognition' =>
  130.                     AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_SOUND_OR_SPEECH_RECOGNITION,
  131.                 'deploymentOnRotatingMachines' =>
  132.                     AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_DEPLOYMENT_ON_ROTATING_MACHINES,
  133.                 'fallHazard' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_FALL_HAZARD,
  134.                 'impairing_noise' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_IMPAIRING_NOISE,
  135.                 'dangerous_noise' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_DANGEROUS_NOISE,
  136.                 'fullBodyVibrations' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_FULL_BODY_VIBRATIONS,
  137.                 'rightHandArmVibration' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_RIGHT_HAND_ARM_VIBRATIONS,
  138.                 'leftHandArmVibrations' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_LEFT_HAND_ARM_VIBRATIONS,
  139.                 'solventsAndVarnishes' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_SOLVENTS_AND_VARNISHES,
  140.                 'gasesVaporsAerosolDustSmoke' =>
  141.                     AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_GASES_VAPORS_AEROSOL_DUST_SMOKE,
  142.                 'oilFatEmulsions' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_OIL_FAT_EMULSIONS,
  143.                 'wetWorks' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_WET_WORKS,
  144.                 'electromagneticFields' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_ELECTROMAGNETIC_FIELDS,
  145.                 'heat' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_HEAT,
  146.                 'normalShift' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_NORMAL_SHIFT,
  147.                 'alternationShiftWithoutNight' =>
  148.                     AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_ALTERNATION_SHIFT_WITHOUT_NIGHT,
  149.                 'alternationShiftWithNight' =>
  150.                     AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_ALTERNATION_SHIFT_WITH_NIGHT,
  151.                 'permanentNightShift' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_PERMANENT_NIGHT_SHIFT,
  152.                 'rigidTactBinding' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_RIGID_TACT_BINDING,
  153.                 'drivingAndSteeringActivities' =>
  154.                     AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_DRIVING_AND_STEERING_ACTIVITIES,
  155.                 'withForkliftJob' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_WITH_FORKLIFT_JOB,
  156.                 'driversLicenceB' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_DRIVERS_LICENCE_B,
  157.                 'driversLicenceCCE' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_DRIVERS_LICENCE_C_CE,
  158.                 'driversLicenceFloorConveyors' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_DRIVERS_LICENCE_FLOOR_CONVEYORS,
  159.                 'seatingOpportunityAvailable' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_SEATING_OPPORTUNITY_AVAILABLE,
  160.                 'seatingWorkplace' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_SEATING_WORKPLACE,
  161.                 'workplaceWithVisibleColleagues' => AbstractSettingIdCompound::JOB_LAB_KO_CRITERIA_WORKPLACE_WITH_VISIBLE_COLLEAGUES,
  162.                 'defaultJobLabKOCriteria' => DefaultKOCriteriaCompound::DEFAULT_KO_CRITERIA_VALUE,
  163.                 'job_lab_ko_criteria' => AbstractSettingsGroupIdCompound::JOB_LAB_KO_CRITERIA_SETTINGS_GROUP_ID,
  164.             ]
  165.         );
  166.     }
  168. }