INSERT INTO apartment_services 
(
    id, 
    society_id,
    block_ids,                        
    apartment_ids,                   
    name,                      
    amount,
    payment_type_id,
    payment_type_id_name,
    applicable_date,
    due_date,
    late_penalty_amount,
    penalty_type_id,
    penalty_type_id_name,
    penalty_recuring_type_id,
    penalty_recuring_type_id_name 
) VALUES 
(1, 1, '[1,2]', '[1,2]', 'Maintenaince Charges', 4100, 2, 'Monthly', '2024-05-03', 03, 100, 2, 'Recuring', 1, 'Per Day'),
(2, 1, '[1,2]', '[1,2]', 'Water Service Billing', 200, 2, 'Monthly', '2024-05-03', 03, 10, 2, 'Recuring', 2, 'Per Month');

INSERT INTO service_apartment (id, service_id, apartment_id)
VALUES
(1, 1, 1),
(2, 2, 1),
(3, 1, 2),
(4, 2, 2);

INSERT INTO service_block (id, service_id, block_id)
VALUES
(1, 1, 1),
(2, 2, 1),
(3, 1, 2),
(4, 2, 2);