/* eslint-disable max-len */ // eslint-disable-next-line @typescript-eslint/consistent-type-imports import { MigrationInterface, QueryRunner } from 'typeorm'; export class AddNameIntoPublicHoliday1701354013716 implements MigrationInterface { name = 'AddNameIntoPublicHoliday1701354013716'; public async up(queryRunner: QueryRunner): Promise { await queryRunner.query( `ALTER TABLE "public_holidays" ADD "name" character varying NOT NULL`, ); await queryRunner.query( `ALTER TABLE "ot_settings" ALTER COLUMN "extra_rate_per" SET DEFAULT '1.5'`, ); // Add Vehicle Name await queryRunner.query( `INSERT INTO "vehicle_names" ("id", "name", "is_active") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d0fa', 'KUBOTA', TRUE)`, ); await queryRunner.query( `INSERT INTO "vehicle_names" ("id", "name", "is_active") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d1fa', 'LANDINI', TRUE)`, ); await queryRunner.query( `INSERT INTO "vehicle_names" ("id", "name", "is_active") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d2fa', 'YAN MAR', TRUE)`, ); // Add Incentive Setting await queryRunner.query( `INSERT INTO "incentive_settings" ("id", "name", "is_active", "amount", "threshold", "type", "period", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d0fa', 'meal', TRUE, 5, 3, 'FIXED_AMOUNT', 'DAILY', 'hour')`, ); await queryRunner.query( `INSERT INTO "incentive_settings" ("id", "name", "is_active", "amount", "threshold", "type", "period", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d0fb', 'perfect attendance', TRUE, 50, 26, 'FIXED_AMOUNT', 'MONTHLY', 'day')`, ); await queryRunner.query( `INSERT INTO "incentive_settings" ("id", "name", "is_active", "amount", "threshold", "type", "period", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d0fc', 'sucker planting', TRUE, 20, 1000, 'FIXED_AMOUNT', 'DAILY', 'pcs')`, ); await queryRunner.query( `INSERT INTO "incentive_settings" ("id", "name", "is_active", "amount", "threshold", "type", "period", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d0fd', 'sucker harvest', TRUE, 20, 1000, 'FIXED_AMOUNT', 'DAILY', 'pcs')`, ); await queryRunner.query( `INSERT INTO "incentive_settings" ("id", "name", "is_active", "amount", "threshold", "type", "period", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d0fe', 'referral', TRUE, 100, 3, 'FIXED_AMOUNT', 'ONLY_ONCE', 'month')`, ); await queryRunner.query( `INSERT INTO "incentive_settings" ("id", "name", "is_active", "amount", "threshold", "type", "period", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d0ff', 'fruit harvest', TRUE, 0.025, 43.75, 'PERCENTAGE', 'DAILY', 'pcs')`, ); await queryRunner.query( `INSERT INTO "incentive_settings" ("id", "name", "is_active", "amount", "threshold", "type", "period", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d1fa', 'long service', TRUE, 100, 2, 'FIXED_AMOUNT', 'MONTHLY', 'year')`, ); await queryRunner.query( `INSERT INTO "incentive_settings" ("id", "name", "is_active", "amount", "threshold", "type", "period", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d1fb', 'long service', TRUE, 150, 3, 'FIXED_AMOUNT', 'MONTHLY', 'year')`, ); await queryRunner.query( `INSERT INTO "incentive_settings" ("id", "name", "is_active", "amount", "threshold", "type", "period", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d1fc', 'long service', TRUE, 200, 4, 'FIXED_AMOUNT', 'MONTHLY', 'year')`, ); await queryRunner.query( `INSERT INTO "incentive_settings" ("id", "name", "is_active", "amount", "threshold", "type", "period", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-e100f065d1fd', 'long service', TRUE, 250, 6, 'FIXED_AMOUNT', 'MONTHLY', 'year')`, ); // Add sector await queryRunner.query( `INSERT INTO "sectors" ("id", "name") VALUES ('a8cee0ed-b6e7-4e8a-b53a-f100f065d0fa', 'daily rate')`, ); await queryRunner.query( `INSERT INTO "sectors" ("id", "name") VALUES ('a8cee0ed-b6e7-4e8a-b53a-f100f065d1fa', 'zero rate')`, ); await queryRunner.query( `INSERT INTO "sectors" ("id", "name") VALUES ('a8cee0ed-b6e7-4e8a-b53a-f100f065d2fa', 'unpaid leave')`, ); await queryRunner.query( `INSERT INTO "sectors" ("id", "name") VALUES ('a8cee0ed-b6e7-4e8a-b53a-f100f065d3fa', 'sucker harvest and planting')`, ); await queryRunner.query( `INSERT INTO "sectors" ("id", "name") VALUES ('a8cee0ed-b6e7-4e8a-b53a-f100f065d4fa', 'spraying team')`, ); await queryRunner.query( `INSERT INTO "sectors" ("id", "name") VALUES ('a8cee0ed-b6e7-4e8a-b53a-f100f065d5fa', 'land preparation')`, ); await queryRunner.query( `INSERT INTO "sectors" ("id", "name") VALUES ('a8cee0ed-b6e7-4e8a-b53a-f100f065d6fa', 'manuring')`, ); await queryRunner.query( `INSERT INTO "sectors" ("id", "name") VALUES ('a8cee0ed-b6e7-4e8a-b53a-f100f065d7fa', 'grass cutting')`, ); await queryRunner.query( `INSERT INTO "sectors" ("id", "name") VALUES ('a8cee0ed-b6e7-4e8a-b53a-f100f065d8fa', 'plastic mulch and bedding fertilizer')`, ); await queryRunner.query( `INSERT INTO "sectors" ("id", "name") VALUES ('a8cee0ed-b6e7-4e8a-b53a-f100f065d9fa', 'fruit harvest and grading')`, ); // Add Activity Setting await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065d0fa', 'daily rate', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d0fa', TRUE, 50, 'day')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065d1fa', 'annual leave', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d1fa', TRUE, 0, 'day')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065d2fa', 'sick leave', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d1fa', TRUE, 0, 'day')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065d3fa', 'unpaid leave', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d2fa', TRUE, -50, 'day')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit", "incentive_name") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065d4fa', 'sucker planting', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d3fa', TRUE, 0.04, 'pcs', 'sucker planting')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit", "incentive_name") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065d5fa', 'sucker harvest', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d3fa', TRUE, 0.06, 'pcs', 'sucker harvest')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065d6fa', 'fertilizer', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d4fa', TRUE, 35, 'tank')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065d7fa', 'herbicide', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d4fa', TRUE, 35, 'tank')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065d8fa', 'hormone', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d4fa', TRUE, 35, 'tank')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065d9fa', 'insecticide', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d4fa', TRUE, 35, 'tank')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065e0fa', 'fungicide', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d4fa', TRUE, 35, 'tank')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065e1fa', 'land leveling', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d5fa', TRUE, 58, 'tank')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065e2fa', 'plowing', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d5fa', TRUE, 58, 'tank')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065e3fa', 'roto-tiling', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d5fa', TRUE, 58, 'tank')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065e4fa', 'bedding', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d5fa', TRUE, 58, 'tank')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065e5fa', 'plastic mulch (land)', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d5fa', TRUE, 58, 'tank')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065e6fa', 'roto-tiling and bedding (land)', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d5fa', TRUE, 58, 'tank')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065e7fa', 'npk', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d6fa', TRUE, 28, 'bag')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065e8fa', 'grass cutting', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d7fa', TRUE, 0.07, 'tree')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065e9fa', 'plastic mulch', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d8fa', TRUE, 36, 'tree')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065f0fa', 'bedding fertilizer', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d8fa', TRUE, 26.2, 'tree')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit", "incentive_name") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065f1fa', 'fruit harvest', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d9fa', TRUE, 0.1, 'pcs', 'fruit harvest')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065f2fa', 'fruit grading', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d9fa', TRUE, 0.05, 'pcs')`, ); await queryRunner.query( `INSERT INTO "activity_record_settings" ("id", "name", "sector_id", "is_active", "rate", "unit") VALUES ('c8cee0ed-b6e7-4e8a-b53a-f100f065f3fa', 'zero rate', 'a8cee0ed-b6e7-4e8a-b53a-f100f065d1fa', TRUE, 0, 'day')`, ); } public async down(queryRunner: QueryRunner): Promise { await queryRunner.query( `ALTER TABLE "ot_settings" ALTER COLUMN "extra_rate_per" SET DEFAULT 1.5`, ); await queryRunner.query(`ALTER TABLE "public_holidays" DROP COLUMN "name"`); } }