Untitled

INSERT INTO holidays (id, holiday_date, description, year, created_at) VALUES
(1, '2024-04-01', 'Additional Holidays', 2024, '2025-01-09 11:26:18.631805'),
(2, '2024-04-07', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(3, '2024-04-14', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(4, '2024-04-21', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(5, '2024-04-28', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(6, '2024-05-05', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(7, '2024-05-12', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(8, '2024-05-19', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(9, '2024-05-26', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(10, '2024-06-02', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(11, '2024-06-09', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(12, '2024-06-10', 'Summer Shutdown', 2024, '2025-01-09 11:26:18.631805'),
(13, '2024-06-11', 'Summer Shutdown', 2024, '2025-01-09 11:26:18.631805'),
(14, '2024-06-12', 'Summer Shutdown', 2024, '2025-01-09 11:26:18.631805'),
(15, '2024-06-13', 'Summer Shutdown', 2024, '2025-01-09 11:26:18.631805'),
(16, '2024-06-14', 'Summer Shutdown', 2024, '2025-01-09 11:26:18.631805'),
(17, '2024-06-15', 'Summer Shutdown', 2024, '2025-01-09 11:26:18.631805'),
(18, '2024-06-16', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(19, '2024-06-17', 'Eid A1-Adha', 2024, '2025-01-09 11:26:18.631805'),
(20, '2024-06-18', 'Eid A1-Adha', 2024, '2025-01-09 11:26:18.631805'),
(21, '2024-06-19', 'Eid A1-Adha', 2024, '2025-01-09 11:26:18.631805'),
(22, '2024-06-23', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(23, '2024-06-30', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(24, '2024-07-07', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(25, '2024-07-14', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(26, '2024-07-21', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(27, '2024-07-28', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(28, '2024-08-04', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(29, '2024-08-11', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(30, '2024-08-18', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(31, '2024-08-25', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(32, '2024-09-01', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(33, '2024-09-08', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(34, '2024-09-15', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(35, '2024-09-16', 'Eid e-Milad-un Nabi', 2024, '2025-01-09 11:26:18.631805'),
(36, '2024-09-22', 'holiday', 2024, '2025-01-09 11:26:18.631805'),
(37, '2024-09-29', 'holiday', 2024, '2025-01-09 11:26:18.631805');





INSERT INTO "msil-iot-em-holidays-association" (date, hierarchy_type_id, hierarchy_ref_id, holiday_id, is_active) VALUES
('2025-01-07 00:00:00', 1, 1, 1, true),
('2024-04-07 00:00:00', 1, 1, 2, true),
('2024-04-14 00:00:00', 1, 1, 3, true),
('2024-04-21 00:00:00', 1, 1, 4, true),
('2024-04-28 00:00:00', 1, 1, 5, true),
('2024-05-05 00:00:00', 1, 1, 6, true),
('2024-05-12 00:00:00', 1, 1, 7, true),
('2024-05-19 00:00:00', 1, 1, 8, true),
('2024-05-26 00:00:00', 1, 1, 9, true),
('2024-06-02 00:00:00', 1, 1, 10, true),
('2024-06-09 00:00:00', 1, 1, 11, true),
('2024-06-10 00:00:00', 1, 1, 12, true),
('2024-06-11 00:00:00', 1, 1, 13, true),
('2024-06-12 00:00:00', 1, 1, 14, true),
('2024-06-13 00:00:00', 1, 1, 15, true),
('2024-06-14 00:00:00', 1, 1, 16, true),
('2024-06-15 00:00:00', 1, 1, 17, true),
('2024-06-16 00:00:00', 1, 1, 18, true),
('2024-06-17 00:00:00', 1, 1, 19, true),
('2024-06-23 00:00:00', 1, 1, 20, true),
('2024-06-30 00:00:00', 1, 1, 21, true),
('2024-07-07 00:00:00', 1, 1, 22, true),
('2024-07-14 00:00:00', 1, 1, 23, true),
('2024-07-21 00:00:00', 1, 1, 24, true),
('2024-07-28 00:00:00', 1, 1, 25, true),
('2024-08-04 00:00:00', 1, 1, 26, true),
('2024-08-11 00:00:00', 1, 1, 27, true),
('2024-08-15 00:00:00', 1, 1, 28, true),
('2024-08-18 00:00:00', 1, 1, 29, true),
('2024-08-19 00:00:00', 1, 1, 30, true),
('2024-08-20 00:00:00', 1, 1, 31, true),
('2024-08-25 00:00:00', 1, 1, 32, true),
('2024-08-26 00:00:00', 1, 1, 33, true),
('2024-09-01 00:00:00', 1, 1, 34, true),
('2024-09-07 00:00:00', 1, 1, 35, true),
('2024-09-08 00:00:00', 1, 1, 36, true),
('2024-09-15 00:00:00', 1, 1, 37, true);