-- ============================================================ -- ZIPO ENERGY SYSTEM - TEST DATA -- ============================================================ -- Run this in phpMyAdmin to populate the database -- All passwords are password123 (bcrypt hashed) -- ============================================================ SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE disconnection_logs; TRUNCATE TABLE support_tickets; TRUNCATE TABLE alerts; TRUNCATE TABLE transactions; TRUNCATE TABLE meter_readings; TRUNCATE TABLE meters; TRUNCATE TABLE units; TRUNCATE TABLE properties; TRUNCATE TABLE wallets; TRUNCATE TABLE system_configs; TRUNCATE TABLE users; TRUNCATE TABLE personal_access_tokens; SET FOREIGN_KEY_CHECKS = 1; -- ============================================================ -- 1. SYSTEM CONFIGURATIONS -- ============================================================ INSERT INTO `system_configs` (`key`, `value`, `created_at`, `updated_at`) VALUES ('tax_percentage', '5.0', NOW(), NOW()), ('landlord_uedcl_meter', '4521987', NOW(), NOW()), ('uedcl_ussd_code', '*185*4*1*1*2*', NOW(), NOW()), ('unit_price_per_kwh', '120', NOW(), NOW()), ('platform_name', 'Zipo Energy', NOW(), NOW()), ('currency', 'UGX', NOW(), NOW()), ('support_email', 'support@zipoenergy.com', NOW(), NOW()), ('support_phone', '+256700100200', NOW(), NOW()), ('disconnection_fee', '25000', NOW(), NOW()), ('reconnection_fee', '15000', NOW(), NOW()); -- ============================================================ -- 2. USERS (password123) -- ============================================================ INSERT INTO `users` (`id`, `name`, `full_name`, `email`, `email_verified_at`, `password`, `phone`, `role`, `account_number`, `address`, `company`, `property_id`, `is_active`, `status`, `photo_url`, `last_login_at`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'System Admin', 'System Administrator', 'admin@zipo.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256700100200', 'super_admin', 'ADM-001', 'Kampala, Uganda', 'Zipo Energy Ltd', NULL, 1, 'active', NULL, NOW(), NULL, NOW(), NOW()), (2, 'John Mukasa', 'John Mukasa', 'john.mukasa@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256701100101', 'landlord', 'LL-001', 'Bukoto, Kampala', 'Mukasa Properties Ltd', NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 1 DAY), NULL, NOW(), NOW()), (3, 'Sarah Nabatanzi', 'Sarah Nabatanzi', 'sarah.nabatanzi@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256702200202', 'landlord', 'LL-002', 'Muyenga, Kampala', 'Nabatanzi Real Estate', NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 2 DAY), NULL, NOW(), NOW()), (4, 'Robert Ssempijja', 'Robert Ssempijja', 'robert.ssempijja@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256703300303', 'landlord', 'LL-003', 'Ntinda, Kampala', 'Ssempijja Holdings', NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 3 DAY), NULL, NOW(), NOW()), (5, 'Grace Nakato', 'Grace Nakato', 'grace.nakato@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256704400404', 'landlord', 'LL-004', 'Kololo, Kampala', 'Nakato Estates', NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 5 HOUR), NULL, NOW(), NOW()), (6, 'Peter Wasswa', 'Peter Wasswa', 'peter.wasswa@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256705500505', 'landlord', 'LL-005', 'Bugolobi, Kampala', 'Wasswa Properties', NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 12 HOUR), NULL, NOW(), NOW()), (7, 'Alice Akello', 'Alice Akello', 'alice.akello@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256701100001', 'tenant', 'TEN-0001', 'Plot 45, Jinja Road, Kampala', NULL, NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 10 MINUTE), NULL, NOW(), NOW()), (8, 'Brian Odoi', 'Brian Odoi', 'brian.odoi@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256702200002', 'tenant', 'TEN-0002', 'Plot 120, Bombo Road, Kampala', NULL, NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 30 MINUTE), NULL, NOW(), NOW()), (9, 'Catherine Nassozi', 'Catherine Nassozi', 'catherine.nassozi@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256703300003', 'tenant', 'TEN-0003', 'Plot 78, Gayaza Road, Wakiso', NULL, NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 2 HOUR), NULL, NOW(), NOW()), (10, 'David Kaggwa', 'David Kaggwa', 'david.kaggwa@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256704400004', 'tenant', 'TEN-0004', 'Plot 200, Entebbe Road, Kampala', NULL, NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 1 DAY), NULL, NOW(), NOW()), (11, 'Esther Nambi', 'Esther Nambi', 'esther.nambi@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256705500005', 'tenant', 'TEN-0005', 'Plot 56, Lumumba Ave, Kampala', NULL, NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 6 HOUR), NULL, NOW(), NOW()), (12, 'Fred Lukyamuzi', 'Fred Lukyamuzi', 'fred.lukyamuzi@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256706600006', 'tenant', 'TEN-0006', 'Plot 34, Hoima Road, Kampala', NULL, NULL, 1, 'active', NULL, NOW(), NULL, NOW(), NOW()), (13, 'Grace Nakibuuka', 'Grace Nakibuuka', 'grace.nakibuuka@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256707700007', 'tenant', 'TEN-0007', 'Plot 89, Masaka Road, Kampala', NULL, NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 4 HOUR), NULL, NOW(), NOW()), (14, 'Henry Ssembatya', 'Henry Ssembatya', 'henry.ssembatya@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256708800008', 'tenant', 'TEN-0008', 'Plot 15, Gulu Road, Kampala', NULL, NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 3 HOUR), NULL, NOW(), NOW()), (15, 'Irene Nakamya', 'Irene Nakamya', 'irene.nakamya@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256709900009', 'tenant', 'TEN-0009', 'Plot 67, Jinja Road, Mukono', NULL, NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 8 HOUR), NULL, NOW(), NOW()), (16, 'James Mugerwa', 'James Mugerwa', 'james.mugerwa@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256710100010', 'tenant', 'TEN-0010', 'Plot 23, Bombo Road, Wakiso', NULL, NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 15 MINUTE), NULL, NOW(), NOW()), (17, 'Kevin Ssebunnya', 'Kevin Ssebunnya', 'kevin.ssebunnya@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256711100011', 'tenant', 'TEN-0011', 'Plot 150, Gayaza Road, Kampala', NULL, NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 45 MINUTE), NULL, NOW(), NOW()), (18, 'Louisa Nakanwagi', 'Louisa Nakanwagi', 'louisa.nakanwagi@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256712200012', 'tenant', 'TEN-0012', 'Plot 88, Entebbe Road, Entebbe', NULL, NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 20 MINUTE), NULL, NOW(), NOW()), (19, 'Mohammed Ssali', 'Mohammed Ssali', 'mohammed.ssali@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256713300013', 'tenant', 'TEN-0013', 'Plot 44, Lumumba Ave, Kampala', NULL, NULL, 1, 'active', NULL, DATE_SUB(NOW(), INTERVAL 1 DAY), NULL, NOW(), NOW()), (20, 'Nancy Nakato', 'Nancy Nakato', 'nancy.nakato@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256714400014', 'tenant', 'TEN-0014', 'Plot 12, Masaka Road, Kampala', NULL, NULL, 1, 'inactive', NULL, DATE_SUB(NOW(), INTERVAL 30 DAY), NULL, NOW(), NOW()), (21, 'Oscar Kiwanuka', 'Oscar Kiwanuka', 'oscar.kiwanuka@gmail.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256715500015', 'tenant', 'TEN-0015', 'Plot 99, Jinja Road, Jinja', NULL, NULL, 1, 'inactive', NULL, DATE_SUB(NOW(), INTERVAL 25 DAY), NULL, NOW(), NOW()), (22, 'Jane Akello', 'Jane Akello', 'jane.akello@zipo.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256716600016', 'property_manager', 'PM-001', 'Kampala, Uganda', 'Zipo Energy Ltd', NULL, 1, 'active', NULL, NOW(), NULL, NOW(), NOW()), (23, 'Tom Ssali', 'Tom Ssali', 'tom.ssali@zipo.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256717700017', 'accountant', 'ACC-001', 'Kampala, Uganda', 'Zipo Energy Ltd', NULL, 1, 'active', NULL, NOW(), NULL, NOW(), NOW()), (24, 'Sarah Kemigisha', 'Sarah Kemigisha', 'sarah.kemigisha@zipo.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256718800018', 'support_agent', 'SA-001', 'Kampala, Uganda', 'Zipo Energy Ltd', NULL, 1, 'active', NULL, NOW(), NULL, NOW(), NOW()), (25, 'Paul Mugisha', 'Paul Mugisha', 'paul.mugisha@zipo.com', NOW(), '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+256719900019', 'technician', 'TECH-001', 'Kampala, Uganda', 'Zipo Energy Ltd', NULL, 1, 'active', NULL, NOW(), NULL, NOW(), NOW()); -- ============================================================ -- 3. WALLETS -- ============================================================ INSERT INTO `wallets` (`user_id`, `balance`, `total_collected`, `total_tax_deducted`, `total_spent_on_uedcl`, `momo_number`, `created_at`, `updated_at`) VALUES (1, 15000000.00, 50000000.00, 3500000.00, 18000000.00, '+256700100200', NOW(), NOW()), (2, 2500000.00, 12000000.00, 600000.00, 4500000.00, '+256701100101', NOW(), NOW()), (3, 3500000.00, 15000000.00, 750000.00, 5200000.00, '+256702200202', NOW(), NOW()), (4, 1800000.00, 8000000.00, 400000.00, 3100000.00, '+256703300303', NOW(), NOW()), (5, 4200000.00, 18000000.00, 900000.00, 6800000.00, '+256704400404', NOW(), NOW()), (6, 2900000.00, 11000000.00, 550000.00, 3900000.00, '+256705500505', NOW(), NOW()), (7, 125000.00, 0, 0, 0, '+256701100001', NOW(), NOW()), (8, 85000.00, 0, 0, 0, '+256702200002', NOW(), NOW()), (9, 210000.00, 0, 0, 0, '+256703300003', NOW(), NOW()), (10, 45000.00, 0, 0, 0, '+256704400004', NOW(), NOW()), (11, 320000.00, 0, 0, 0, '+256705500005', NOW(), NOW()), (12, 95000.00, 0, 0, 0, '+256706600006', NOW(), NOW()), (13, 180000.00, 0, 0, 0, '+256707700007', NOW(), NOW()), (14, 65000.00, 0, 0, 0, '+256708800008', NOW(), NOW()), (15, 275000.00, 0, 0, 0, '+256709900009', NOW(), NOW()), (16, 110000.00, 0, 0, 0, '+256710100010', NOW(), NOW()), (17, 43000.00, 0, 0, 0, '+256711100011', NOW(), NOW()), (18, 198000.00, 0, 0, 0, '+256712200012', NOW(), NOW()), (19, 56000.00, 0, 0, 0, '+256713300013', NOW(), NOW()), (20, 0, 0, 0, 0, '+256714400014', NOW(), NOW()), (21, 0, 0, 0, 0, '+256715500015', NOW(), NOW()); -- ============================================================ -- 4. PROPERTIES -- ============================================================ INSERT INTO `properties` (`id`, `landlord_id`, `user_id`, `name`, `address`, `description`, `city`, `total_units`, `occupied_units`, `status`, `created_at`, `updated_at`) VALUES (1, 2, 2, 'Sunset Apartments', 'Plot 12, Bukoto', 'Sunset Apartments offers modern living spaces in prime Kampala location.', 'Kampala', 8, 6, 'active', NOW(), NOW()), (2, 3, 3, 'Green Valley Residences','Plot 45, Muyenga', 'Green Valley Residences offers modern living spaces in prime Kampala location.','Kampala', 6, 5, 'active', NOW(), NOW()), (3, 4, 4, 'Ntinda Towers', 'Plot 7, Ntinda', 'Ntinda Towers offers modern living spaces in prime Kampala location.', 'Kampala', 12, 10, 'active', NOW(), NOW()), (4, 5, 5, 'Kololo Heights', 'Plot 3, Kololo', 'Kololo Heights offers modern living spaces in prime Kampala location.', 'Kampala', 5, 4, 'active', NOW(), NOW()), (5, 6, 6, 'Bugolobi Court', 'Plot 22, Bugolobi', 'Bugolobi Court offers modern living spaces in prime Kampala location.', 'Kampala', 10, 8, 'active', NOW(), NOW()), (6, 2, 2, 'Mukasa Villas', 'Plot 8, Bukoto', 'Mukasa Villas offers modern living spaces in prime Kampala location.', 'Kampala', 4, 3, 'active', NOW(), NOW()), (7, 3, 3, 'Nabatanzi Plaza', 'Plot 15, Muyenga', 'Nabatanzi Plaza offers modern living spaces in prime Kampala location.', 'Kampala', 20, 16, 'active', NOW(), NOW()), (8, 4, 4, 'Ssempijja Heights', 'Plot 10, Ntinda', 'Ssempijja Heights offers modern living spaces in prime Kampala location.', 'Kampala', 8, 7, 'active', NOW(), NOW()), (9, 5, 5, 'Nakato Gardens', 'Plot 5, Kololo', 'Nakato Gardens offers modern living spaces in prime Kampala location.', 'Kampala', 6, 5, 'active', NOW(), NOW()), (10, 6, 6, 'Wasswa Mansions', 'Plot 18, Bugolobi', 'Wasswa Mansions offers modern living spaces in prime Kampala location.', 'Kampala', 15, 12, 'active', NOW(), NOW()), (11, 2, 2, 'Bukoto Suites', 'Plot 30, Bukoto', 'Bukoto Suites offers modern living spaces in prime Kampala location.', 'Kampala', 10, 8, 'active', NOW(), NOW()), (12, 3, 3, 'Muyenga Court', 'Plot 25, Muyenga', 'Muyenga Court offers modern living spaces in prime Kampala location.', 'Kampala', 7, 6, 'active', NOW(), NOW()); -- ============================================================ -- 5. UNITS -- ============================================================ INSERT INTO `units` (`property_id`, `user_id`, `tenant_id`, `unit_number`, `name`, `description`, `rent_amount`, `monthly_rent`, `status`, `created_at`, `updated_at`) VALUES (1, 2, 7, 'SUN-01', 'Sunset Apartments Unit 1', 'Occupied by Alice Akello', 500000.00, 500000.00, 'occupied', NOW(), NOW()), (1, 2, 8, 'SUN-02', 'Sunset Apartments Unit 2', 'Occupied by Brian Odoi', 550000.00, 550000.00, 'occupied', NOW(), NOW()), (1, 2, 9, 'SUN-03', 'Sunset Apartments Unit 3', 'Occupied by Catherine Nassozi',600000.00, 600000.00, 'occupied', NOW(), NOW()), (1, 2, 10, 'SUN-04', 'Sunset Apartments Unit 4', 'Occupied by David Kaggwa', 480000.00, 480000.00, 'occupied', NOW(), NOW()), (1, 2, 11, 'SUN-05', 'Sunset Apartments Unit 5', 'Occupied by Esther Nambi', 520000.00, 520000.00, 'occupied', NOW(), NOW()), (1, 2, 12, 'SUN-06', 'Sunset Apartments Unit 6', 'Occupied by Fred Lukyamuzi', 580000.00, 580000.00, 'occupied', NOW(), NOW()), (1, 2, NULL, 'SUN-07', 'Sunset Apartments Unit 7', 'Vacant unit ready for occupancy', 450000.00, 450000.00, 'vacant', NOW(), NOW()), (1, 2, NULL, 'SUN-08', 'Sunset Apartments Unit 8', 'Under maintenance', 350000.00, 350000.00, 'maintenance', NOW(), NOW()), (2, 3, 13, 'GRN-01', 'Green Valley Unit 1', 'Occupied by Grace Nakibuuka', 700000.00, 700000.00, 'occupied', NOW(), NOW()), (2, 3, 14, 'GRN-02', 'Green Valley Unit 2', 'Occupied by Henry Ssembatya', 750000.00, 750000.00, 'occupied', NOW(), NOW()), (2, 3, 15, 'GRN-03', 'Green Valley Unit 3', 'Occupied by Irene Nakamya', 680000.00, 680000.00, 'occupied', NOW(), NOW()), (2, 3, 16, 'GRN-04', 'Green Valley Unit 4', 'Occupied by James Mugerwa', 720000.00, 720000.00, 'occupied', NOW(), NOW()), (2, 3, 17, 'GRN-05', 'Green Valley Unit 5', 'Occupied by Kevin Ssebunnya', 650000.00, 650000.00, 'occupied', NOW(), NOW()), (2, 3, NULL, 'GRN-06', 'Green Valley Unit 6', 'Vacant unit ready for occupancy', 600000.00, 600000.00, 'vacant', NOW(), NOW()), (3, 4, 18, 'NTN-01', 'Ntinda Towers Unit 1', 'Occupied by Louisa Nakanwagi', 900000.00, 900000.00, 'occupied', NOW(), NOW()), (3, 4, 19, 'NTN-02', 'Ntinda Towers Unit 2', 'Occupied by Mohammed Ssali', 850000.00, 850000.00, 'occupied', NOW(), NOW()), (3, 4, 20, 'NTN-03', 'Ntinda Towers Unit 3', 'Occupied by Nancy Nakato', 800000.00, 800000.00, 'occupied', NOW(), NOW()), (3, 4, 21, 'NTN-04', 'Ntinda Towers Unit 4', 'Occupied by Oscar Kiwanuka', 950000.00, 950000.00, 'occupied', NOW(), NOW()), (3, 4, 7, 'NTN-05', 'Ntinda Towers Unit 5', 'Occupied by Alice Akello', 880000.00, 880000.00, 'occupied', NOW(), NOW()), (3, 4, 8, 'NTN-06', 'Ntinda Towers Unit 6', 'Occupied by Brian Odoi', 820000.00, 820000.00, 'occupied', NOW(), NOW()), (3, 4, 9, 'NTN-07', 'Ntinda Towers Unit 7', 'Occupied by Catherine Nassozi', 780000.00, 780000.00, 'occupied', NOW(), NOW()), (3, 4, 10, 'NTN-08', 'Ntinda Towers Unit 8', 'Occupied by David Kaggwa', 920000.00, 920000.00, 'occupied', NOW(), NOW()), (3, 4, 11, 'NTN-09', 'Ntinda Towers Unit 9', 'Occupied by Esther Nambi', 860000.00, 860000.00, 'occupied', NOW(), NOW()), (3, 4, 12, 'NTN-10', 'Ntinda Towers Unit 10', 'Occupied by Fred Lukyamuzi', 790000.00, 790000.00, 'occupied', NOW(), NOW()), (3, 4, NULL, 'NTN-11', 'Ntinda Towers Unit 11', 'Vacant unit ready for occupancy', 750000.00, 750000.00, 'vacant', NOW(), NOW()), (3, 4, NULL, 'NTN-12', 'Ntinda Towers Unit 12', 'Vacant unit ready for occupancy', 700000.00, 700000.00, 'vacant', NOW(), NOW()), (4, 5, 13, 'KOL-01', 'Kololo Heights Unit 1', 'Occupied by Grace Nakibuuka', 1200000.00, 1200000.00, 'occupied', NOW(), NOW()), (4, 5, 14, 'KOL-02', 'Kololo Heights Unit 2', 'Occupied by Henry Ssembatya', 1100000.00, 1100000.00, 'occupied', NOW(), NOW()), (4, 5, 15, 'KOL-03', 'Kololo Heights Unit 3', 'Occupied by Irene Nakamya', 1300000.00, 1300000.00, 'occupied', NOW(), NOW()), (4, 5, 16, 'KOL-04', 'Kololo Heights Unit 4', 'Occupied by James Mugerwa', 1150000.00, 1150000.00, 'occupied', NOW(), NOW()), (4, 5, NULL, 'KOL-05', 'Kololo Heights Unit 5', 'Vacant unit ready for occupancy', 1000000.00, 1000000.00, 'vacant', NOW(), NOW()), (5, 6, 17, 'BUG-01', 'Bugolobi Court Unit 1', 'Occupied by Kevin Ssebunnya', 650000.00, 650000.00, 'occupied', NOW(), NOW()), (5, 6, 18, 'BUG-02', 'Bugolobi Court Unit 2', 'Occupied by Louisa Nakanwagi', 600000.00, 600000.00, 'occupied', NOW(), NOW()), (5, 6, 19, 'BUG-03', 'Bugolobi Court Unit 3', 'Occupied by Mohammed Ssali', 700000.00, 700000.00, 'occupied', NOW(), NOW()), (5, 6, 20, 'BUG-04', 'Bugolobi Court Unit 4', 'Occupied by Nancy Nakato', 550000.00, 550000.00, 'occupied', NOW(), NOW()), (5, 6, 21, 'BUG-05', 'Bugolobi Court Unit 5', 'Occupied by Oscar Kiwanuka', 620000.00, 620000.00, 'occupied', NOW(), NOW()), (5, 6, 7, 'BUG-06', 'Bugolobi Court Unit 6', 'Occupied by Alice Akello', 580000.00, 580000.00, 'occupied', NOW(), NOW()), (5, 6, 8, 'BUG-07', 'Bugolobi Court Unit 7', 'Occupied by Brian Odoi', 670000.00, 670000.00, 'occupied', NOW(), NOW()), (5, 6, 9, 'BUG-08', 'Bugolobi Court Unit 8', 'Occupied by Catherine Nassozi', 630000.00, 630000.00, 'occupied', NOW(), NOW()), (5, 6, NULL, 'BUG-09', 'Bugolobi Court Unit 9', 'Vacant unit ready for occupancy', 500000.00, 500000.00, 'vacant', NOW(), NOW()), (5, 6, NULL, 'BUG-10', 'Bugolobi Court Unit 10', 'Vacant unit ready for occupancy', 480000.00, 480000.00, 'vacant', NOW(), NOW()), (6, 2, 10, 'MUK-01', 'Mukasa Villas Unit 1', 'Occupied by David Kaggwa', 450000.00, 450000.00, 'occupied', NOW(), NOW()), (6, 2, 11, 'MUK-02', 'Mukasa Villas Unit 2', 'Occupied by Esther Nambi', 500000.00, 500000.00, 'occupied', NOW(), NOW()), (6, 2, 12, 'MUK-03', 'Mukasa Villas Unit 3', 'Occupied by Fred Lukyamuzi', 420000.00, 420000.00, 'occupied', NOW(), NOW()), (6, 2, NULL, 'MUK-04', 'Mukasa Villas Unit 4', 'Vacant unit ready for occupancy', 380000.00, 380000.00, 'vacant', NOW(), NOW()), (7, 3, 13, 'NBP-01', 'Nabatanzi Plaza Unit 1', 'Occupied by Grace Nakibuuka', 350000.00, 350000.00, 'occupied', NOW(), NOW()), (7, 3, 14, 'NBP-02', 'Nabatanzi Plaza Unit 2', 'Occupied by Henry Ssembatya', 380000.00, 380000.00, 'occupied', NOW(), NOW()), (7, 3, 15, 'NBP-03', 'Nabatanzi Plaza Unit 3', 'Occupied by Irene Nakamya', 400000.00, 400000.00, 'occupied', NOW(), NOW()), (7, 3, 16, 'NBP-04', 'Nabatanzi Plaza Unit 4', 'Occupied by James Mugerwa', 420000.00, 420000.00, 'occupied', NOW(), NOW()), (7, 3, 17, 'NBP-05', 'Nabatanzi Plaza Unit 5', 'Occupied by Kevin Ssebunnya', 360000.00, 360000.00, 'occupied', NOW(), NOW()), (7, 3, 18, 'NBP-06', 'Nabatanzi Plaza Unit 6', 'Occupied by Louisa Nakanwagi', 390000.00, 390000.00, 'occupied', NOW(), NOW()), (7, 3, 19, 'NBP-07', 'Nabatanzi Plaza Unit 7', 'Occupied by Mohammed Ssali', 370000.00, 370000.00, 'occupied', NOW(), NOW()), (7, 3, 20, 'NBP-08', 'Nabatanzi Plaza Unit 8', 'Occupied by Nancy Nakato', 340000.00, 340000.00, 'occupied', NOW(), NOW()), (7, 3, 21, 'NBP-09', 'Nabatanzi Plaza Unit 9', 'Occupied by Oscar Kiwanuka', 410000.00, 410000.00, 'occupied', NOW(), NOW()), (7, 3, 7, 'NBP-10', 'Nabatanzi Plaza Unit 10', 'Occupied by Alice Akello', 430000.00, 430000.00, 'occupied', NOW(), NOW()), (7, 3, 8, 'NBP-11', 'Nabatanzi Plaza Unit 11', 'Occupied by Brian Odoi', 450000.00, 450000.00, 'occupied', NOW(), NOW()), (7, 3, 9, 'NBP-12', 'Nabatanzi Plaza Unit 12', 'Occupied by Catherine Nassozi', 380000.00, 380000.00, 'occupied', NOW(), NOW()), (7, 3, 10, 'NBP-13', 'Nabatanzi Plaza Unit 13', 'Occupied by David Kaggwa', 400000.00, 400000.00, 'occupied', NOW(), NOW()), (7, 3, 11, 'NBP-14', 'Nabatanzi Plaza Unit 14', 'Occupied by Esther Nambi', 420000.00, 420000.00, 'occupied', NOW(), NOW()), (7, 3, 12, 'NBP-15', 'Nabatanzi Plaza Unit 15', 'Occupied by Fred Lukyamuzi', 390000.00, 390000.00, 'occupied', NOW(), NOW()), (7, 3, NULL, 'NBP-16', 'Nabatanzi Plaza Unit 16', 'Under maintenance', 350000.00, 350000.00, 'maintenance', NOW(), NOW()), (7, 3, NULL, 'NBP-17', 'Nabatanzi Plaza Unit 17', 'Vacant unit ready for occupancy', 320000.00, 320000.00, 'vacant', NOW(), NOW()), (7, 3, NULL, 'NBP-18', 'Nabatanzi Plaza Unit 18', 'Vacant unit ready for occupancy', 300000.00, 300000.00, 'vacant', NOW(), NOW()), (7, 3, NULL, 'NBP-19', 'Nabatanzi Plaza Unit 19', 'Vacant unit ready for occupancy', 330000.00, 330000.00, 'vacant', NOW(), NOW()), (7, 3, NULL, 'NBP-20', 'Nabatanzi Plaza Unit 20', 'Vacant unit ready for occupancy', 310000.00, 310000.00, 'vacant', NOW(), NOW()), (8, 4, 14, 'SSH-01', 'Ssempijja Heights Unit 1', 'Occupied by Henry Ssembatya', 800000.00, 800000.00, 'occupied', NOW(), NOW()), (8, 4, 15, 'SSH-02', 'Ssempijja Heights Unit 2', 'Occupied by Irene Nakamya', 750000.00, 750000.00, 'occupied', NOW(), NOW()), (8, 4, 16, 'SSH-03', 'Ssempijja Heights Unit 3', 'Occupied by James Mugerwa', 820000.00, 820000.00, 'occupied', NOW(), NOW()), (8, 4, 17, 'SSH-04', 'Ssempijja Heights Unit 4', 'Occupied by Kevin Ssebunnya', 780000.00, 780000.00, 'occupied', NOW(), NOW()), (8, 4, 18, 'SSH-05', 'Ssempijja Heights Unit 5', 'Occupied by Louisa Nakanwagi', 850000.00, 850000.00, 'occupied', NOW(), NOW()), (8, 4, 19, 'SSH-06', 'Ssempijja Heights Unit 6', 'Occupied by Mohammed Ssali', 790000.00, 790000.00, 'occupied', NOW(), NOW()), (8, 4, 20, 'SSH-07', 'Ssempijja Heights Unit 7', 'Occupied by Nancy Nakato', 730000.00, 730000.00, 'occupied', NOW(), NOW()), (8, 4, NULL, 'SSH-08', 'Ssempijja Heights Unit 8', 'Vacant unit ready for occupancy', 700000.00, 700000.00, 'vacant', NOW(), NOW()), (9, 5, 21, 'NKG-01', 'Nakato Gardens Unit 1', 'Occupied by Oscar Kiwanuka', 950000.00, 950000.00, 'occupied', NOW(), NOW()), (9, 5, 7, 'NKG-02', 'Nakato Gardens Unit 2', 'Occupied by Alice Akello', 880000.00, 880000.00, 'occupied', NOW(), NOW()), (9, 5, 8, 'NKG-03', 'Nakato Gardens Unit 3', 'Occupied by Brian Odoi', 920000.00, 920000.00, 'occupied', NOW(), NOW()), (9, 5, 9, 'NKG-04', 'Nakato Gardens Unit 4', 'Occupied by Catherine Nassozi', 890000.00, 890000.00, 'occupied', NOW(), NOW()), (9, 5, 10, 'NKG-05', 'Nakato Gardens Unit 5', 'Occupied by David Kaggwa', 860000.00, 860000.00, 'occupied', NOW(), NOW()), (9, 5, NULL, 'NKG-06', 'Nakato Gardens Unit 6', 'Vacant unit ready for occupancy', 800000.00, 800000.00, 'vacant', NOW(), NOW()), (10, 6, 11, 'WSW-01', 'Wasswa Mansions Unit 1', 'Occupied by Esther Nambi', 650000.00, 650000.00, 'occupied', NOW(), NOW()), (10, 6, 12, 'WSW-02', 'Wasswa Mansions Unit 2', 'Occupied by Fred Lukyamuzi', 600000.00, 600000.00, 'occupied', NOW(), NOW()), (10, 6, 13, 'WSW-03', 'Wasswa Mansions Unit 3', 'Occupied by Grace Nakibuuka', 620000.00, 620000.00, 'occupied', NOW(), NOW()), (10, 6, 14, 'WSW-04', 'Wasswa Mansions Unit 4', 'Occupied by Henry Ssembatya', 680000.00, 680000.00, 'occupied', NOW(), NOW()), (10, 6, 15, 'WSW-05', 'Wasswa Mansions Unit 5', 'Occupied by Irene Nakamya', 590000.00, 590000.00, 'occupied', NOW(), NOW()), (10, 6, 16, 'WSW-06', 'Wasswa Mansions Unit 6', 'Occupied by James Mugerwa', 640000.00, 640000.00, 'occupied', NOW(), NOW()), (10, 6, 17, 'WSW-07', 'Wasswa Mansions Unit 7', 'Occupied by Kevin Ssebunnya', 610000.00, 610000.00, 'occupied', NOW(), NOW()), (10, 6, 18, 'WSW-08', 'Wasswa Mansions Unit 8', 'Occupied by Louisa Nakanwagi', 670000.00, 670000.00, 'occupied', NOW(), NOW()), (10, 6, 19, 'WSW-09', 'Wasswa Mansions Unit 9', 'Occupied by Mohammed Ssali', 630000.00, 630000.00, 'occupied', NOW(), NOW()), (10, 6, 20, 'WSW-10', 'Wasswa Mansions Unit 10', 'Occupied by Nancy Nakato', 570000.00, 570000.00, 'occupied', NOW(), NOW()), (10, 6, 21, 'WSW-11', 'Wasswa Mansions Unit 11', 'Occupied by Oscar Kiwanuka', 660000.00, 660000.00, 'occupied', NOW(), NOW()), (10, 6, NULL, 'WSW-12', 'Wasswa Mansions Unit 12', 'Under maintenance', 550000.00, 550000.00, 'maintenance', NOW(), NOW()), (10, 6, NULL, 'WSW-13', 'Wasswa Mansions Unit 13', 'Vacant unit ready for occupancy', 520000.00, 520000.00, 'vacant', NOW(), NOW()), (10, 6, NULL, 'WSW-14', 'Wasswa Mansions Unit 14', 'Vacant unit ready for occupancy', 500000.00, 500000.00, 'vacant', NOW(), NOW()), (10, 6, NULL, 'WSW-15', 'Wasswa Mansions Unit 15', 'Vacant unit ready for occupancy', 480000.00, 480000.00, 'vacant', NOW(), NOW()), (11, 2, 10, 'BKT-01', 'Bukoto Suites Unit 1', 'Occupied by David Kaggwa', 550000.00, 550000.00, 'occupied', NOW(), NOW()), (11, 2, 11, 'BKT-02', 'Bukoto Suites Unit 2', 'Occupied by Esther Nambi', 600000.00, 600000.00, 'occupied', NOW(), NOW()), (11, 2, 12, 'BKT-03', 'Bukoto Suites Unit 3', 'Occupied by Fred Lukyamuzi', 520000.00, 520000.00, 'occupied', NOW(), NOW()), (11, 2, 13, 'BKT-04', 'Bukoto Suites Unit 4', 'Occupied by Grace Nakibuuka', 580000.00, 580000.00, 'occupied', NOW(), NOW()), (11, 2, 14, 'BKT-05', 'Bukoto Suites Unit 5', 'Occupied by Henry Ssembatya', 540000.00, 540000.00, 'occupied', NOW(), NOW()), (11, 2, 15, 'BKT-06', 'Bukoto Suites Unit 6', 'Occupied by Irene Nakamya', 620000.00, 620000.00, 'occupied', NOW(), NOW()), (11, 2, 16, 'BKT-07', 'Bukoto Suites Unit 7', 'Occupied by James Mugerwa', 560000.00, 560000.00, 'occupied', NOW(), NOW()), (11, 2, 17, 'BKT-08', 'Bukoto Suites Unit 8', 'Occupied by Kevin Ssebunnya', 590000.00, 590000.00, 'occupied', NOW(), NOW()), (11, 2, NULL, 'BKT-09', 'Bukoto Suites Unit 9', 'Vacant unit ready for occupancy', 480000.00, 480000.00, 'vacant', NOW(), NOW()), (11, 2, NULL, 'BKT-10', 'Bukoto Suites Unit 10', 'Vacant unit ready for occupancy', 460000.00, 460000.00, 'vacant', NOW(), NOW()), (12, 3, 18, 'MYG-01', 'Muyenga Court Unit 1', 'Occupied by Louisa Nakanwagi', 750000.00, 750000.00, 'occupied', NOW(), NOW()), (12, 3, 19, 'MYG-02', 'Muyenga Court Unit 2', 'Occupied by Mohammed Ssali', 700000.00, 700000.00, 'occupied', NOW(), NOW()), (12, 3, 20, 'MYG-03', 'Muyenga Court Unit 3', 'Occupied by Nancy Nakato', 680000.00, 680000.00, 'occupied', NOW(), NOW()), (12, 3, 21, 'MYG-04', 'Muyenga Court Unit 4', 'Occupied by Oscar Kiwanuka', 720000.00, 720000.00, 'occupied', NOW(), NOW()), (12, 3, 7, 'MYG-05', 'Muyenga Court Unit 5', 'Occupied by Alice Akello', 780000.00, 780000.00, 'occupied', NOW(), NOW()), (12, 3, 8, 'MYG-06', 'Muyenga Court Unit 6', 'Occupied by Brian Odoi', 650000.00, 650000.00, 'occupied', NOW(), NOW()), (12, 3, NULL, 'MYG-07', 'Muyenga Court Unit 7', 'Vacant unit ready for occupancy', 600000.00, 600000.00, 'vacant', NOW(), NOW()); -- ============================================================ -- 6. METERS -- ============================================================ INSERT INTO `meters` (`unit_id`, `user_id`, `meter_number`, `meter_type`, `type`, `status`, `balance`, `voltage`, `current`, `power`, `relay_status`, `battery`, `battery_level`, `last_reading_kwh`, `location`, `last_reading_at`, `created_at`, `updated_at`) VALUES (1, 7, 'MTR-00001', 'submeter', 'submeter', 'active', 185000.00, 228.45, 12.5, 2850.32, 1, 100, 90, 3450, 'Sunset Apartments Unit 1', DATE_SUB(NOW(), INTERVAL 2 HOUR), NOW(), NOW()), (2, 8, 'MTR-00002', 'submeter', 'submeter', 'active', 92000.00, 222.30, 18.2, 4100.50, 1, 80, 85, 5200, 'Sunset Apartments Unit 2', DATE_SUB(NOW(), INTERVAL 4 HOUR), NOW(), NOW()), (3, 9, 'MTR-00003', 'submeter', 'submeter', 'offline', 45000.00, 0, 0, 0, 0, 15, 12, 2800, 'Sunset Apartments Unit 3', DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()), (4, 10, 'MTR-00004', 'submeter', 'submeter', 'active', 210000.00, 235.60, 8.5, 2010.75, 1, 100, 95, 4100, 'Sunset Apartments Unit 4', DATE_SUB(NOW(), INTERVAL 1 HOUR), NOW(), NOW()), (5, 11, 'MTR-00005', 'submeter', 'submeter', 'active', 128000.00, 220.15, 15.8, 3500.00, 1, 70, 65, 3800, 'Sunset Apartments Unit 5', DATE_SUB(NOW(), INTERVAL 6 HOUR), NOW(), NOW()), (6, 12, 'MTR-00006', 'submeter', 'submeter', 'active', 76000.00, 232.80, 22.1, 5150.40, 1, 90, 88, 6100, 'Sunset Apartments Unit 6', DATE_SUB(NOW(), INTERVAL 3 HOUR), NOW(), NOW()), (9, 13, 'MTR-00007', 'submeter', 'submeter', 'active', 245000.00, 225.50, 14.2, 3200.00, 1, 100, 92, 2900, 'Green Valley Unit 1', DATE_SUB(NOW(), INTERVAL 1 HOUR), NOW(), NOW()), (10, 14, 'MTR-00008', 'submeter', 'submeter', 'faulty', 32000.00, 190.20, 25.8, 4900.00, 0, 45, 40, 4500, 'Green Valley Unit 2', DATE_SUB(NOW(), INTERVAL 12 HOUR), NOW(), NOW()), (11, 15, 'MTR-00009', 'submeter', 'submeter', 'active', 189000.00, 230.40, 10.5, 2420.60, 1, 100, 96, 2100, 'Green Valley Unit 3', DATE_SUB(NOW(), INTERVAL 30 MINUTE), NOW(), NOW()), (12, 16, 'MTR-00010', 'submeter', 'submeter', 'active', 156000.00, 228.90, 16.3, 3720.80, 1, 85, 82, 4900, 'Green Valley Unit 4', DATE_SUB(NOW(), INTERVAL 5 HOUR), NOW(), NOW()), (13, 17, 'MTR-00011', 'submeter', 'submeter', 'offline', 28000.00, 0, 0, 0, 0, 20, 18, 3200, 'Green Valley Unit 5', DATE_SUB(NOW(), INTERVAL 3 DAY), NOW(), NOW()), (15, 18, 'MTR-00012', 'submeter', 'submeter', 'active', 320000.00, 225.80, 20.1, 4580.00, 1, 80, 78, 6750, 'Ntinda Towers Unit 1', DATE_SUB(NOW(), INTERVAL 45 MINUTE), NOW(), NOW()), (16, 19, 'MTR-00013', 'submeter', 'submeter', 'active', 198000.00, 232.40, 12.8, 2950.50, 1, 95, 93, 4200, 'Ntinda Towers Unit 2', DATE_SUB(NOW(), INTERVAL 2 HOUR), NOW(), NOW()), (17, 20, 'MTR-00014', 'submeter', 'submeter', 'active', 65000.00, 226.70, 18.5, 4180.30, 1, 60, 58, 5200, 'Ntinda Towers Unit 3', DATE_SUB(NOW(), INTERVAL 1 HOUR), NOW(), NOW()), (18, 21, 'MTR-00015', 'submeter', 'submeter', 'offline', 12000.00, 0, 0, 0, 0, 10, 8, 1800, 'Ntinda Towers Unit 4', DATE_SUB(NOW(), INTERVAL 5 DAY), NOW(), NOW()), (19, 7, 'MTR-00016', 'submeter', 'submeter', 'active', 275000.00, 220.10, 22.5, 5100.00, 1, 100, 98, 7800, 'Ntinda Towers Unit 5', DATE_SUB(NOW(), INTERVAL 15 MINUTE), NOW(), NOW()), (27, 13, 'MTR-00017', 'submeter', 'submeter', 'active', 520000.00, 236.20, 9.8, 2300.00, 1, 100, 95, 1500, 'Kololo Heights Unit 1', DATE_SUB(NOW(), INTERVAL 10 MINUTE), NOW(), NOW()), (28, 14, 'MTR-00018', 'submeter', 'submeter', 'active', 480000.00, 234.50, 11.2, 2600.50, 1, 95, 92, 2200, 'Kololo Heights Unit 2', DATE_SUB(NOW(), INTERVAL 20 MINUTE), NOW(), NOW()), (29, 15, 'MTR-00019', 'submeter', 'submeter', 'active', 560000.00, 238.80, 7.5, 1750.00, 1, 100, 97, 1200, 'Kololo Heights Unit 3', DATE_SUB(NOW(), INTERVAL 5 MINUTE), NOW(), NOW()), (30, 16, 'MTR-00020', 'submeter', 'submeter', 'active', 495000.00, 230.40, 13.6, 3150.80, 1, 90, 88, 3500, 'Kololo Heights Unit 4', DATE_SUB(NOW(), INTERVAL 25 MINUTE), NOW(), NOW()), (33, 17, 'MTR-00021', 'submeter', 'submeter', 'active', 142000.00, 225.30, 16.8, 3800.00, 1, 80, 78, 4800, 'Bugolobi Court Unit 1', DATE_SUB(NOW(), INTERVAL 4 HOUR), NOW(), NOW()), (34, 18, 'MTR-00022', 'submeter', 'submeter', 'active', 168000.00, 228.60, 14.2, 3200.00, 1, 85, 83, 3600, 'Bugolobi Court Unit 2', DATE_SUB(NOW(), INTERVAL 2 HOUR), NOW(), NOW()), (35, 19, 'MTR-00023', 'submeter', 'submeter', 'offline', 22000.00, 0, 0, 0, 0, 25, 22, 2500, 'Bugolobi Court Unit 3', DATE_SUB(NOW(), INTERVAL 4 DAY), NOW(), NOW()), (36, 20, 'MTR-00024', 'submeter', 'submeter', 'active', 98000.00, 222.90, 19.5, 4400.00, 1, 70, 68, 5800, 'Bugolobi Court Unit 4', DATE_SUB(NOW(), INTERVAL 3 HOUR), NOW(), NOW()), (1, 2, 'MTR-00025', 'main', 'main', 'active', 2500000.00, 415.00, 150.0, 62250.00, 1, 100, 100, 150000, 'Sunset Apartments - Main', DATE_SUB(NOW(), INTERVAL 1 HOUR), NOW(), NOW()), (2, 3, 'MTR-00026', 'main', 'main', 'active', 3200000.00, 412.00, 180.0, 74160.00, 1, 100, 100, 180000, 'Green Valley - Main', DATE_SUB(NOW(), INTERVAL 1 HOUR), NOW(), NOW()), (3, 4, 'MTR-00027', 'main', 'main', 'active', 1800000.00, 418.00, 220.0, 91960.00, 1, 100, 100, 220000, 'Ntinda Towers - Main', DATE_SUB(NOW(), INTERVAL 1 HOUR), NOW(), NOW()), (4, 5, 'MTR-00028', 'main', 'main', 'active', 800000.00, 416.00, 95.0, 39520.00, 1, 100, 100, 95000, 'Kololo Heights - Main', DATE_SUB(NOW(), INTERVAL 1 HOUR), NOW(), NOW()), (5, 6, 'MTR-00029', 'main', 'main', 'active', 1500000.00, 413.00, 165.0, 68145.00, 1, 100, 100, 165000, 'Bugolobi Court - Main', DATE_SUB(NOW(), INTERVAL 1 HOUR), NOW(), NOW()); -- ============================================================ -- 7. METER READINGS -- ============================================================ INSERT INTO `meter_readings` (`meter_id`, `voltage`, `current`, `power`, `energy`, `balance`, `relay_on`, `read_at`, `created_at`, `updated_at`) VALUES (1, 228.45, 12.50, 2850.32, 45.20, 185000.00, 1, DATE_SUB(NOW(), INTERVAL 0 DAY), NOW(), NOW()), (1, 227.80, 11.20, 2540.00, 42.10, 180000.00, 1, DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), (1, 229.10, 13.80, 3150.50, 48.50, 175000.00, 1, DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()), (1, 228.90, 14.20, 3240.00, 52.80, 165000.00, 1, DATE_SUB(NOW(), INTERVAL 4 DAY), NOW(), NOW()), (1, 228.20, 10.80, 2450.00, 40.20, 195000.00, 1, DATE_SUB(NOW(), INTERVAL 7 DAY), NOW(), NOW()), (1, 229.50, 15.50, 3525.00, 58.10, 190000.00, 1, DATE_SUB(NOW(), INTERVAL 8 DAY), NOW(), NOW()), (1, 226.10, 9.50, 2150.00, 35.80, 185000.00, 1, DATE_SUB(NOW(), INTERVAL 9 DAY), NOW(), NOW()), (1, 228.40, 11.50, 2620.00, 43.50, 220000.00, 1, DATE_SUB(NOW(), INTERVAL 11 DAY), NOW(), NOW()), (1, 229.30, 16.00, 3650.00, 60.20, 215000.00, 1, DATE_SUB(NOW(), INTERVAL 12 DAY), NOW(), NOW()), (1, 225.80, 10.20, 2310.00, 38.50, 210000.00, 1, DATE_SUB(NOW(), INTERVAL 13 DAY), NOW(), NOW()), (1, 228.70, 14.50, 3300.00, 54.20, 205000.00, 1, DATE_SUB(NOW(), INTERVAL 15 DAY), NOW(), NOW()), (1, 229.00, 17.20, 3920.00, 65.00, 235000.00, 1, DATE_SUB(NOW(), INTERVAL 17 DAY), NOW(), NOW()), (1, 225.20, 9.80, 2210.00, 36.80, 230000.00, 1, DATE_SUB(NOW(), INTERVAL 18 DAY), NOW(), NOW()), (1, 228.80, 12.20, 2780.00, 45.80, 225000.00, 1, DATE_SUB(NOW(), INTERVAL 20 DAY), NOW(), NOW()), (1, 226.90, 10.80, 2455.00, 40.50, 260000.00, 1, DATE_SUB(NOW(), INTERVAL 21 DAY), NOW(), NOW()), (1, 229.60, 18.00, 4100.00, 68.20, 255000.00, 1, DATE_SUB(NOW(), INTERVAL 22 DAY), NOW(), NOW()), (1, 225.40, 9.20, 2080.00, 34.60, 250000.00, 1, DATE_SUB(NOW(), INTERVAL 23 DAY), NOW(), NOW()), (1, 227.80, 14.00, 3185.00, 52.80, 248000.00, 1, DATE_SUB(NOW(), INTERVAL 24 DAY), NOW(), NOW()), (1, 224.50, 19.20, 4320.00, 72.00, 300000.00, 1, DATE_SUB(NOW(), INTERVAL 25 DAY), NOW(), NOW()), (1, 229.80, 19.50, 4450.00, 74.00, 275000.00, 1, DATE_SUB(NOW(), INTERVAL 27 DAY), NOW(), NOW()), (2, 222.30, 18.20, 4100.50, 68.50, 92000.00, 1, DATE_SUB(NOW(), INTERVAL 0 DAY), NOW(), NOW()), (2, 221.80, 17.50, 3900.00, 65.20, 88000.00, 1, DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), (2, 223.40, 19.80, 4420.00, 74.00, 85000.00, 1, DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()), (2, 220.90, 16.20, 3600.00, 60.00, 82000.00, 1, DATE_SUB(NOW(), INTERVAL 3 DAY), NOW(), NOW()), (2, 222.60, 20.50, 4560.00, 76.20, 79000.00, 1, DATE_SUB(NOW(), INTERVAL 4 DAY), NOW(), NOW()), (2, 221.20, 15.80, 3500.00, 58.50, 76000.00, 1, DATE_SUB(NOW(), INTERVAL 5 DAY), NOW(), NOW()), (2, 223.80, 21.20, 4725.00, 79.00, 73000.00, 1, DATE_SUB(NOW(), INTERVAL 6 DAY), NOW(), NOW()), (2, 220.40, 14.50, 3200.00, 53.50, 120000.00, 1, DATE_SUB(NOW(), INTERVAL 7 DAY), NOW(), NOW()), (2, 221.50, 16.00, 3550.00, 59.50, 110000.00, 1, DATE_SUB(NOW(), INTERVAL 9 DAY), NOW(), NOW()), (2, 223.20, 22.00, 4900.00, 82.00, 105000.00, 1, DATE_SUB(NOW(), INTERVAL 10 DAY), NOW(), NOW()), (4, 235.60, 8.50, 2010.75, 28.50, 210000.00, 1, DATE_SUB(NOW(), INTERVAL 0 DAY), NOW(), NOW()), (4, 234.80, 7.90, 1860.00, 26.00, 205000.00, 1, DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), (4, 236.40, 9.20, 2170.00, 30.50, 200000.00, 1, DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()), (4, 233.90, 7.20, 1690.00, 23.80, 195000.00, 1, DATE_SUB(NOW(), INTERVAL 3 DAY), NOW(), NOW()), (4, 235.20, 10.00, 2350.00, 33.00, 190000.00, 1, DATE_SUB(NOW(), INTERVAL 4 DAY), NOW(), NOW()), (4, 234.40, 8.00, 1880.00, 26.50, 185000.00, 1, DATE_SUB(NOW(), INTERVAL 5 DAY), NOW(), NOW()), (4, 236.80, 11.50, 2710.00, 38.00, 180000.00, 1, DATE_SUB(NOW(), INTERVAL 6 DAY), NOW(), NOW()), (4, 233.50, 7.00, 1645.00, 23.00, 245000.00, 1, DATE_SUB(NOW(), INTERVAL 7 DAY), NOW(), NOW()), (4, 235.80, 9.50, 2240.00, 31.50, 240000.00, 1, DATE_SUB(NOW(), INTERVAL 8 DAY), NOW(), NOW()), (4, 234.20, 7.80, 1835.00, 25.80, 235000.00, 1, DATE_SUB(NOW(), INTERVAL 9 DAY), NOW(), NOW()), (4, 236.50, 12.00, 2830.00, 40.00, 230000.00, 1, DATE_SUB(NOW(), INTERVAL 10 DAY), NOW(), NOW()), (7, 225.50, 14.20, 3200.00, 52.00, 245000.00, 1, DATE_SUB(NOW(), INTERVAL 0 DAY), NOW(), NOW()), (7, 224.80, 13.50, 3040.00, 49.50, 240000.00, 1, DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), (7, 226.40, 15.80, 3560.00, 58.00, 235000.00, 1, DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()), (7, 223.90, 12.80, 2880.00, 47.00, 230000.00, 1, DATE_SUB(NOW(), INTERVAL 5 DAY), NOW(), NOW()), (7, 225.20, 16.50, 3720.00, 60.50, 280000.00, 1, DATE_SUB(NOW(), INTERVAL 7 DAY), NOW(), NOW()), (12, 225.80, 20.10, 4580.00, 72.00, 320000.00, 1, DATE_SUB(NOW(), INTERVAL 0 DAY), NOW(), NOW()), (12, 224.50, 19.20, 4320.00, 68.00, 315000.00, 1, DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), (12, 226.80, 22.50, 5085.00, 80.00, 310000.00, 1, DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()), (12, 223.60, 18.00, 4030.00, 63.50, 305000.00, 1, DATE_SUB(NOW(), INTERVAL 3 DAY), NOW(), NOW()), (12, 225.40, 21.80, 4910.00, 77.50, 300000.00, 1, DATE_SUB(NOW(), INTERVAL 7 DAY), NOW(), NOW()), (17, 236.20, 9.80, 2300.00, 32.00, 520000.00, 1, DATE_SUB(NOW(), INTERVAL 0 DAY), NOW(), NOW()), (17, 235.50, 9.00, 2120.00, 29.50, 515000.00, 1, DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), (17, 237.00, 10.50, 2485.00, 34.50, 510000.00, 1, DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()), (17, 234.80, 8.50, 2000.00, 28.00, 505000.00, 1, DATE_SUB(NOW(), INTERVAL 3 DAY), NOW(), NOW()), (17, 236.50, 11.20, 2650.00, 37.00, 500000.00, 1, DATE_SUB(NOW(), INTERVAL 7 DAY), NOW(), NOW()); -- ============================================================ -- 8. TRANSACTIONS -- ============================================================ INSERT INTO `transactions` (`transaction_number`, `user_id`, `from_user_id`, `to_user_id`, `from_name`, `to_name`, `meter_id`, `type`, `purpose`, `amount`, `tax_amount`, `tax_percentage`, `net_amount`, `provider`, `phone_number`, `reference`, `status`, `notes`, `transaction_date`, `created_at`, `updated_at`) VALUES ('TXN-A1B2C3', 7, 7, 2, 'Alice Akello', 'John Mukasa', 1, 'tenant_payment', 'rent', 500000.00, 25000.00, 5.00, 475000.00, 'MTN', '+256701100001', 'REF-MTN-001', 'completed', 'Monthly rent payment for July 2024', DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), ('TXN-D4E5F6', 8, 8, 2, 'Brian Odoi', 'John Mukasa', 2, 'tenant_payment', 'rent', 550000.00, 27500.00, 5.00, 522500.00, 'Airtel','+256702200002', 'REF-AIR-001', 'completed', 'Monthly rent payment for July 2024', DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), ('TXN-G7H8I9', 9, 9, 2, 'Catherine Nassozi','John Mukasa', 3, 'tenant_payment', 'rent', 600000.00, 30000.00, 5.00, 570000.00, 'MTN', '+256703300003', 'REF-MTN-002', 'completed', 'Monthly rent payment for July 2024', DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), ('TXN-J1K2L3', 10, 10, 2, 'David Kaggwa', 'John Mukasa', 4, 'tenant_payment', 'electricity', 480000.00, 24000.00, 5.00, 456000.00, 'CASH', '+256704400004', 'REF-CASH-01', 'completed', 'Electricity bill payment', DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), ('TXN-M4N5O6', 11, 11, 4, 'Esther Nambi', 'Robert Ssempijja', 5, 'tenant_payment', 'rent', 520000.00, 26000.00, 5.00, 494000.00, 'MTN', '+256705500005', 'REF-MTN-003', 'completed', 'Monthly rent payment', NOW(), NOW(), NOW()), ('TXN-P7Q8R9', 12, 12, 4, 'Fred Lukyamuzi', 'Robert Ssempijja', 6, 'tenant_payment', 'rent', 580000.00, 29000.00, 5.00, 551000.00, 'Flutterwave','+256706600006', 'REF-FLW-001', 'completed', 'Monthly rent payment', NOW(), NOW(), NOW()), ('TXN-S1T2U3', 13, 13, 3, 'Grace Nakibuuka', 'Sarah Nabatanzi', 7, 'tenant_payment', 'rent', 700000.00, 35000.00, 5.00, 665000.00, 'Airtel','+256707700007', 'REF-AIR-002', 'pending', 'Payment processing', NOW(), NOW(), NOW()), ('TXN-V4W5X6', 14, 14, 3, 'Henry Ssembatya', 'Sarah Nabatanzi', 8, 'tenant_payment', 'electricity', 750000.00, 37500.00, 5.00, 712500.00, 'MTN', '+256708800008', 'REF-MTN-004', 'completed', 'Electricity bill payment', NOW(), NOW(), NOW()), ('TXN-Y7Z8A9', 15, 15, 3, 'Irene Nakamya', 'Sarah Nabatanzi', 9, 'tenant_payment', 'rent', 680000.00, 34000.00, 5.00, 646000.00, 'MTN', '+256709900009', 'REF-MTN-005', 'completed', 'Monthly rent payment', DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()), ('TXN-B1C2D3', 16, 16, 5, 'James Mugerwa', 'Grace Nakato', 10, 'tenant_payment', 'rent', 720000.00, 36000.00, 5.00, 684000.00, 'CASH', '+256710100010', 'REF-CASH-02', 'completed', 'Monthly rent payment', DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()), ('TXN-E4F5G6', 17, 17, 6, 'Kevin Ssebunnya', 'Peter Wasswa', 11, 'tenant_payment', 'electricity', 650000.00, 32500.00, 5.00, 617500.00, 'Airtel','+256711100011', 'REF-AIR-003', 'failed', 'Payment failed - insufficient funds', DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()), ('TXN-H7I8J9', 18, 18, 4, 'Louisa Nakanwagi', 'Robert Ssempijja', 12, 'tenant_payment', 'rent', 900000.00, 45000.00, 5.00, 855000.00, 'Flutterwave','+256712200012', 'REF-FLW-002', 'completed', 'Monthly rent payment for July', DATE_SUB(NOW(), INTERVAL 3 DAY), NOW(), NOW()), ('TXN-K1L2M3', 19, 19, 4, 'Mohammed Ssali', 'Robert Ssempijja', 13, 'tenant_payment', 'rent', 850000.00, 42500.00, 5.00, 807500.00, 'MTN', '+256713300013', 'REF-MTN-006', 'completed', 'Monthly rent payment', DATE_SUB(NOW(), INTERVAL 3 DAY), NOW(), NOW()), ('TXN-N4O5P6', 20, 20, 5, 'Nancy Nakato', 'Grace Nakato', 14, 'tenant_payment', 'rent', 800000.00, 40000.00, 5.00, 760000.00, 'MTN', '+256714400014', 'REF-MTN-007', 'completed', 'Monthly rent payment', DATE_SUB(NOW(), INTERVAL 3 DAY), NOW(), NOW()), ('TXN-Q7R8S9', 21, 21, 6, 'Oscar Kiwanuka', 'Peter Wasswa', 15, 'tenant_payment', 'electricity', 950000.00, 47500.00, 5.00, 902500.00, 'Airtel','+256715500015', 'REF-AIR-004', 'completed', 'Electricity bill payment', DATE_SUB(NOW(), INTERVAL 5 DAY), NOW(), NOW()), ('TXN-T1U2V3', 7, 7, 2, 'Alice Akello', 'John Mukasa', 1, 'tax_deduction', 'platform_tax',25000.00, 0, 5.00, 25000.00, 'CASH', '+256701100001', 'REF-TAX-001', 'completed', 'Platform tax deduction', DATE_SUB(NOW(), INTERVAL 5 DAY), NOW(), NOW()), ('TXN-W4X5Y6', 2, 2, 1, 'John Mukasa', 'System Admin', NULL,'tax_deduction', 'platform_tax',25000.00, 0, 5.00, 25000.00, 'MTN', '+256701100101', 'REF-TAX-002', 'completed', 'Landlord platform fee', DATE_SUB(NOW(), INTERVAL 5 DAY), NOW(), NOW()), ('TXN-Z7A8B9', 13, 13, 3, 'Grace Nakibuuka', 'Sarah Nabatanzi', 7, 'uedcl_purchase', 'token_purchase',200000.00, 0, 5.00, 200000.00, 'MTN', '+256707700007', 'REF-UEDCL-01', 'completed', 'Purchased UEDCL tokens for meter', DATE_SUB(NOW(), INTERVAL 7 DAY), NOW(), NOW()), ('TXN-C1D2E3', 8, 8, 2, 'Brian Odoi', 'John Mukasa', 2, 'reconnection_fee','reconnection',15000.00, 750.00, 5.00, 14250.00, 'Airtel','+256702200002', 'REF-RECONN-1', 'completed', 'Reconnection fee after disconnection', DATE_SUB(NOW(), INTERVAL 7 DAY), NOW(), NOW()), ('TXN-F4G5H6', 14, 14, 3, 'Henry Ssembatya', 'Sarah Nabatanzi', 8, 'tenant_payment', 'water', 120000.00, 6000.00, 5.00, 114000.00, 'Flutterwave','+256708800008', 'REF-FLW-003', 'completed', 'Water bill payment', DATE_SUB(NOW(), INTERVAL 10 DAY), NOW(), NOW()), ('TXN-I7J8K9', 9, 9, 2, 'Catherine Nassozi','John Mukasa', 3, 'tenant_payment', 'rent', 600000.00, 30000.00, 5.00, 570000.00, 'MTN', '+256703300003', 'REF-MTN-008', 'completed', 'Monthly rent payment', DATE_SUB(NOW(), INTERVAL 10 DAY), NOW(), NOW()), ('TXN-L1M2N3', 10, 10, 5, 'David Kaggwa', 'Grace Nakato', 4, 'tenant_payment', 'rent', 480000.00, 24000.00, 5.00, 456000.00, 'CASH', '+256704400004', 'REF-CASH-03', 'completed', 'Monthly rent payment', DATE_SUB(NOW(), INTERVAL 14 DAY), NOW(), NOW()), ('TXN-O4P5Q6', 11, 11, 6, 'Esther Nambi', 'Peter Wasswa', 5, 'tenant_payment', 'electricity', 300000.00, 15000.00, 5.00, 285000.00, 'Airtel','+256705500005', 'REF-AIR-005', 'completed', 'Electricity bill', DATE_SUB(NOW(), INTERVAL 14 DAY), NOW(), NOW()), ('TXN-R7S8T9', 12, 12, 4, 'Fred Lukyamuzi', 'Robert Ssempijja', 6, 'tenant_payment', 'rent', 580000.00, 29000.00, 5.00, 551000.00, 'Flutterwave','+256706600006', 'REF-FLW-004', 'completed', 'Monthly rent payment', DATE_SUB(NOW(), INTERVAL 21 DAY), NOW(), NOW()), ('TXN-U1V2W3', 15, 15, 3, 'Irene Nakamya', 'Sarah Nabatanzi', 9, 'uedcl_purchase', 'token_purchase',350000.00, 0, 5.00, 350000.00, 'MTN', '+256709900009', 'REF-UEDCL-02', 'completed', 'Purchased UEDCL tokens', DATE_SUB(NOW(), INTERVAL 21 DAY), NOW(), NOW()), ('TXN-X4Y5Z6', 16, 16, 5, 'James Mugerwa', 'Grace Nakato', 10, 'tenant_payment', 'rent', 720000.00, 36000.00, 5.00, 684000.00, 'MTN', '+256710100010', 'REF-MTN-009', 'completed', 'Monthly rent payment', DATE_SUB(NOW(), INTERVAL 28 DAY), NOW(), NOW()), ('TXN-A7B8C9', 17, 17, 6, 'Kevin Ssebunnya', 'Peter Wasswa', 11, 'tenant_payment', 'electricity',250000.00, 12500.00, 5.00, 237500.00, 'CASH', '+256711100011', 'REF-CASH-04', 'completed', 'Electricity bill', DATE_SUB(NOW(), INTERVAL 28 DAY), NOW(), NOW()), ('TXN-D1E2F3', 18, 18, 4, 'Louisa Nakanwagi', 'Robert Ssempijja', 12, 'tenant_payment', 'rent', 900000.00, 45000.00, 5.00, 855000.00, 'Airtel','+256712200012', 'REF-AIR-006', 'completed', 'Monthly rent payment', DATE_SUB(NOW(), INTERVAL 30 DAY), NOW(), NOW()), ('TXN-G4H5I6', 19, 19, 4, 'Mohammed Ssali', 'Robert Ssempijja', 13, 'tenant_payment', 'water', 150000.00, 7500.00, 5.00, 142500.00, 'Flutterwave','+256713300013', 'REF-FLW-005', 'completed', 'Water bill payment', DATE_SUB(NOW(), INTERVAL 30 DAY), NOW(), NOW()), ('TXN-H7I8J9A', 1, 1, 1, 'System Admin', 'System Admin', NULL, 'subscription', 'platform_tax', 5000000.00, 0, 0, 5000000.00, 'MTN', '+256700100200', 'REF-SUB-001', 'completed', 'Platform subscription revenue', DATE_SUB(NOW(), INTERVAL 15 DAY), NOW(), NOW()), ('TXN-K1L2M3B', 1, 1, 1, 'System Admin', 'System Admin', NULL, 'subscription', 'platform_tax', 2500000.00, 0, 0, 2500000.00, 'Flutterwave','+256700100200', 'REF-SUB-002', 'completed', 'Platform subscription revenue', DATE_SUB(NOW(), INTERVAL 20 DAY), NOW(), NOW()); -- ============================================================ -- 9. SUPPORT TICKETS -- ============================================================ INSERT INTO `support_tickets` (`ticket_number`, `user_id`, `subject`, `description`, `priority`, `status`, `created_at`, `updated_at`) VALUES ('TKT-A1B2C3', 7, 'Meter not reading correctly', 'Dear support, I am having an issue with my unit. The meter display shows error codes and the reading seems inaccurate.', 'high', 'open', DATE_SUB(NOW(), INTERVAL 1 DAY), NOW()), ('TKT-D4E5F6', 8, 'No power in unit', 'There is no power in my unit since yesterday evening. I have checked the main switch but nothing works.', 'high', 'in_progress', DATE_SUB(NOW(), INTERVAL 2 DAY), NOW()), ('TKT-G7H8I9', 9, 'Billing inquiry', 'I would like to understand my latest bill. The charges seem higher than usual for this month.', 'medium', 'open', DATE_SUB(NOW(), INTERVAL 3 DAY), NOW()), ('TKT-J1K2L3', 10, 'Request for meter installation', 'I recently moved into a new unit and need a submeter installed. Please advise on the process and timeline.', 'medium', 'open', DATE_SUB(NOW(), INTERVAL 5 DAY), NOW()), ('TKT-M4N5O6', 11, 'Complaint about high bill', 'My electricity bill has doubled this month compared to last month. Please investigate.', 'high', 'resolved', DATE_SUB(NOW(), INTERVAL 7 DAY), NOW()), ('TKT-P7Q8R9', 12, 'Water pressure issue', 'The water pressure in my unit has been very low for the past week.', 'medium', 'in_progress', DATE_SUB(NOW(), INTERVAL 8 DAY), NOW()), ('TKT-S1T2U3', 13, 'Request for reconnection', 'My electricity was disconnected due to late payment. I have now paid and would like to be reconnected.', 'high', 'resolved', DATE_SUB(NOW(), INTERVAL 10 DAY), NOW()), ('TKT-V4W5X6', 14, 'Payment not reflecting', 'I made a payment via MTN Mobile Money three days ago but it is still not reflecting in my account.', 'high', 'open', DATE_SUB(NOW(), INTERVAL 12 DAY), NOW()), ('TKT-Y7Z8A9', 15, 'Damaged meter', 'The screen on my meter is cracked and the display is no longer readable.', 'medium', 'closed', DATE_SUB(NOW(), INTERVAL 15 DAY), NOW()), ('TKT-B1C2D3', 16, 'Relay not responding', 'The relay on my meter seems stuck. It has not switched off despite the balance being below the threshold.', 'low', 'closed', DATE_SUB(NOW(), INTERVAL 20 DAY), NOW()); -- ============================================================ -- 10. ALERTS -- ============================================================ INSERT INTO `alerts` (`user_id`, `type`, `message`, `priority`, `is_read`, `alert_date`, `created_at`, `updated_at`) VALUES (7, 'payment_received', 'Payment received successfully - 500,000 UGX from Alice Akello', 'low', 1, DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), (8, 'low_balance', 'Meter balance is low (92,000 UGX), please recharge soon', 'high', 0, NOW(), NOW(), NOW()), (9, 'meter_offline', 'Meter MTR-00003 has gone offline - Sunset Apartments Unit 3', 'high', 0, NOW(), NOW(), NOW()), (10, 'payment_received', 'Payment received successfully - 480,000 UGX from David Kaggwa', 'low', 1, DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), (11, 'high_usage', 'Unusually high power usage detected (4,100 kWh) - Unit SUN-05', 'medium', 0, DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()), (12, 'overdue_rent', 'Rent payment overdue for unit SUN-06 - Fred Lukyamuzi', 'high', 0, NOW(), NOW(), NOW()), (13, 'low_balance', 'Meter balance is low (32,000 UGX) - Green Valley Unit 2', 'high', 0, DATE_SUB(NOW(), INTERVAL 6 HOUR), NOW(), NOW()), (14, 'payment_received', 'Payment received successfully - 750,000 UGX from Henry Ssembatya', 'low', 1, NOW(), NOW(), NOW()), (15, 'high_usage', 'Unusually high power usage detected - Green Valley Unit 3', 'medium', 0, DATE_SUB(NOW(), INTERVAL 3 DAY), NOW(), NOW()), (16, 'overdue_rent', 'Rent payment overdue for unit GRN-04 - James Mugerwa', 'high', 0, DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()), (17, 'meter_offline', 'Meter MTR-00011 has gone offline - Green Valley Unit 5', 'high', 0, DATE_SUB(NOW(), INTERVAL 1 DAY), NOW(), NOW()), (18, 'payment_received', 'Payment received successfully - 900,000 UGX from Louisa Nakanwagi', 'low', 1, DATE_SUB(NOW(), INTERVAL 3 DAY), NOW(), NOW()), (19, 'low_balance', 'Meter balance is low (12,000 UGX) - Ntinda Towers Unit 4', 'high', 0, DATE_SUB(NOW(), INTERVAL 12 HOUR), NOW(), NOW()), (20, 'overdue_rent', 'Rent payment overdue for unit NTN-03 - Nancy Nakato', 'medium', 0, DATE_SUB(NOW(), INTERVAL 5 DAY), NOW(), NOW()), (21, 'meter_offline', 'Meter MTR-00015 has gone offline - Ntinda Towers Unit 4', 'high', 0, DATE_SUB(NOW(), INTERVAL 2 DAY), NOW(), NOW()); -- ============================================================ -- 11. DISCONNECTION LOGS -- ============================================================ INSERT INTO `disconnection_logs` (`user_id`, `tenant_id`, `unit_id`, `action_by`, `reason`, `status`, `disconnected_at`, `reconnected_at`, `created_at`, `updated_at`) VALUES (14, 14, 10, 1, 'Non-payment', 'active', DATE_SUB(NOW(), INTERVAL 3 DAY), NULL, NOW(), NOW()), (20, 20, 17, 1, 'Non-payment', 'active', DATE_SUB(NOW(), INTERVAL 5 DAY), NULL, NOW(), NOW()), (21, 21, 18, 1, 'Meter tampering', 'reconnected', DATE_SUB(NOW(), INTERVAL 10 DAY), DATE_SUB(NOW(), INTERVAL 8 DAY), NOW(), NOW()), (8, 8, 2, 1, 'Requested by landlord','reconnected', DATE_SUB(NOW(), INTERVAL 7 DAY), DATE_SUB(NOW(), INTERVAL 5 DAY), NOW(), NOW()), (16, 16, 30, 1, 'Non-payment', 'reconnected', DATE_SUB(NOW(), INTERVAL 14 DAY), DATE_SUB(NOW(), INTERVAL 12 DAY), NOW(), NOW()), (19, 19, 35, 1, 'Maintenance', 'resolved', DATE_SUB(NOW(), INTERVAL 6 DAY), DATE_SUB(NOW(), INTERVAL 4 DAY), NOW(), NOW());