-- =====================================================================
--  Fleet Service Link (NTA ADMIN) — dummy data
--  Demo password for every seeded user: Password123
--  Usage: mysql -u root -p fleet_service_link < seed.sql
-- =====================================================================
USE fleet_service_link;
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE audit_logs; TRUNCATE TABLE notifications; TRUNCATE TABLE pricing_rules;
TRUNCATE TABLE payments; TRUNCATE TABLE invoice_items; TRUNCATE TABLE invoices;
TRUNCATE TABLE transactions; TRUNCATE TABLE card_status_history; TRUNCATE TABLE fleet_cards;
TRUNCATE TABLE vehicles; TRUNCATE TABLE drivers; TRUNCATE TABLE suppliers; TRUNCATE TABLE companies;
TRUNCATE TABLE users; TRUNCATE TABLE roles; TRUNCATE TABLE settings; TRUNCATE TABLE password_resets;
SET FOREIGN_KEY_CHECKS = 1;

-- Roles -------------------------------------------------------------
INSERT INTO roles (id, name, slug, description, permissions, is_system) VALUES
('role-1','Administrator','admin','Full access to every module and setting.','["dashboard.view", "company.view", "company.create", "company.edit", "company.delete", "company.export", "driver.view", "driver.create", "driver.edit", "driver.delete", "driver.export", "vehicle.view", "vehicle.create", "vehicle.edit", "vehicle.delete", "vehicle.export", "card.view", "card.create", "card.edit", "card.delete", "card.activate", "card.block", "card.suspend", "card.cancel", "card.assign", "card.export", "transaction.view", "transaction.export", "supplier.view", "supplier.create", "supplier.edit", "supplier.delete", "supplier.export", "invoice.view", "invoice.create", "invoice.edit", "invoice.delete", "invoice.send", "invoice.cancel", "invoice.export", "payment.view", "payment.create", "payment.edit", "payment.delete", "payment.export", "pricing.view", "pricing.create", "pricing.edit", "pricing.delete", "pricing.activate", "pricing.export", "report.view", "report.export", "notification.view", "audit.view", "audit.export", "user.view", "user.create", "user.edit", "user.delete", "role.view", "role.create", "role.edit", "role.delete", "settings.view", "settings.edit"]',1),
('role-2','Support Agent','support','Read-only fleet visibility with card block and suspend rights.','["dashboard.view", "company.view", "driver.view", "vehicle.view", "card.view", "card.block", "card.suspend", "transaction.view", "transaction.export", "notification.view"]',1),
('role-3','Invoice Manager','invoice_manager','Owns billing, invoices and payment collection.','["dashboard.view", "company.view", "transaction.view", "transaction.export", "invoice.view", "invoice.create", "invoice.edit", "invoice.send", "invoice.cancel", "invoice.export", "payment.view", "payment.create", "payment.edit", "payment.export", "report.view", "report.export", "notification.view"]',1),
('role-4','Pricing Manager','pricing_manager','Maintains pricing rules and margin reports.','["dashboard.view", "company.view", "pricing.view", "pricing.create", "pricing.edit", "pricing.delete", "pricing.activate", "pricing.export", "transaction.view", "transaction.export", "report.view", "report.export", "notification.view"]',1);

-- Users (password for every demo account: Password123) --------------
INSERT INTO users (id, name, email, phone, password_hash, status, last_login_at, created_at) VALUES
('user-1','Aarav Sharma','admin@fleetservicelink.com','+91 98200 11001','$2y$10$kVbhm8k6QzPhxY9TSHOudONGdBbII0TMhSDtfvGRVVNbUlbThOtAC','active','2026-08-31 09:00:00','2025-11-01 10:00:00'),
('user-2','Neha Kapoor','support@fleetservicelink.com','+91 98200 11002','$2y$10$kVbhm8k6QzPhxY9TSHOudONGdBbII0TMhSDtfvGRVVNbUlbThOtAC','active','2026-08-31 09:07:00','2025-11-02 10:00:00'),
('user-3','Rohit Bansal','invoice@fleetservicelink.com','+91 98200 11003','$2y$10$kVbhm8k6QzPhxY9TSHOudONGdBbII0TMhSDtfvGRVVNbUlbThOtAC','active','2026-08-31 09:14:00','2025-11-03 10:00:00'),
('user-4','Divya Menon','pricing@fleetservicelink.com','+91 98200 11004','$2y$10$kVbhm8k6QzPhxY9TSHOudONGdBbII0TMhSDtfvGRVVNbUlbThOtAC','active','2026-08-31 09:21:00','2025-11-04 10:00:00'),
('user-5','Imran Qureshi','ops@fleetservicelink.com','+91 98200 11005','$2y$10$kVbhm8k6QzPhxY9TSHOudONGdBbII0TMhSDtfvGRVVNbUlbThOtAC','active','2026-08-31 09:28:00','2025-11-05 10:00:00');

-- Role assignments (a user may hold multiple roles) -------------------
INSERT INTO user_roles (user_id, role_id) VALUES
('user-1','role-1'),
('user-2','role-2'),
('user-3','role-3'),
('user-3','role-2'),
('user-4','role-4'),
('user-5','role-2');

-- Companies ---------------------------------------------------------
INSERT INTO companies (id, code, name, registration_number, contact_person, email, billing_email, phone, address, city, state, country, postal_code, tax_number, credit_limit, payment_terms, status, notes, created_at) VALUES
('com-1','CMP-0001','Vertex Logistics Pvt Ltd','U00010001','Rahul Menon','ops@vertex.in','billing@vertex.in','+91 22 4000 1001','11 Industrial Estate','Mumbai','Maharashtra','India','400001','27AAACF1001Q1Z1',2500000,'Net 30','active','Key account','2025-02-12 09:00:00'),
('com-2','CMP-0002','BlueLine Transport','U00010002','Anita Desai','ops@blueline.in','billing@blueline.in','+91 22 4000 1002','12 Industrial Estate','Pune','Maharashtra','India','400002','27AAACF1002Q1Z2',1200000,'Net 30','active','Key account','2025-03-12 09:00:00'),
('com-3','CMP-0003','Northstar Freight','U00010003','Vikram Singh','ops@northstar.in','billing@northstar.in','+91 22 4000 1003','13 Industrial Estate','Delhi','Delhi','India','400003','27AAACF1003Q1Z3',1800000,'Net 30','active','Key account','2025-04-12 09:00:00'),
('com-4','CMP-0004','Coastal Movers','U00010004','Priya Nair','ops@coastal.in','billing@coastal.in','+91 22 4000 1004','14 Industrial Estate','Kochi','Kerala','India','400004','27AAACF1004Q1Z4',900000,'Net 30','active','Key account','2025-05-12 09:00:00'),
('com-5','CMP-0005','IronRoad Haulage','U00010005','Sameer Kulkarni','ops@ironroad.in','billing@ironroad.in','+91 22 4000 1005','15 Industrial Estate','Nagpur','Maharashtra','India','400005','27AAACF1005Q1Z5',1500000,'Net 30','active','Key account','2025-06-12 09:00:00'),
('com-6','CMP-0006','Sunrise Distribution','U00010006','Meera Iyer','ops@sunrise.in','billing@sunrise.in','+91 22 4000 1006','16 Industrial Estate','Bengaluru','Karnataka','India','400006','27AAACF1006Q1Z6',700000,'Net 30','active','Key account','2025-07-12 09:00:00');

-- Suppliers ---------------------------------------------------------
INSERT INTO suppliers (id, code, name, type, registration_number, tax_number, contact_person, email, phone, address, city, state, country, payment_terms, bank_details, status, created_at) VALUES
('sup-1','SUP-0001','HighWay Fuels Andheri','Fuel Station','S00020001','27AASUP2001Q1Z1','Manager 1','contact1@supplier.in','+91 22 5000 2001','Plot 21, Service Road','Mumbai','Maharashtra','India','Net 15','HDFC ****4001','active','2025-02-11 09:00:00'),
('sup-2','SUP-0002','GreenPetro Hinjewadi','Fuel Station','S00020002','27AASUP2002Q1Z2','Manager 2','contact2@supplier.in','+91 22 5000 2002','Plot 22, Service Road','Pune','Maharashtra','India','Net 15','HDFC ****4002','active','2025-02-12 09:00:00'),
('sup-3','SUP-0003','TrackFix Service Center','Service Center','S00020003','27AASUP2003Q1Z3','Manager 3','contact3@supplier.in','+91 22 5000 2003','Plot 23, Service Road','Delhi','Maharashtra','India','Net 15','HDFC ****4003','active','2025-02-13 09:00:00'),
('sup-4','SUP-0004','Kerala Auto Workshop','Workshop','S00020004','27AASUP2004Q1Z4','Manager 4','contact4@supplier.in','+91 22 5000 2004','Plot 24, Service Road','Kochi','Maharashtra','India','Net 15','HDFC ****4004','active','2025-02-14 09:00:00'),
('sup-5','SUP-0005','PartsHub India','Parts Supplier','S00020005','27AASUP2005Q1Z5','Manager 5','contact5@supplier.in','+91 22 5000 2005','Plot 25, Service Road','Bengaluru','Maharashtra','India','Net 15','HDFC ****4005','active','2025-02-15 09:00:00');

-- Drivers -----------------------------------------------------------
INSERT INTO drivers (id, code, first_name, last_name, email, phone, date_of_birth, license_number, license_expiry, address, company_id, status, created_at) VALUES
('drv-1','DRV-0001','Arjun','Sharma','arjun.sharma@fleetdriver.in','+91 90000 10001','1981-02-11','MH1120191000001','2028-02-21','Flat 101, Transport Colony','com-1','active','2025-03-02 09:00:00'),
('drv-2','DRV-0002','Kiran','Patil','kiran.patil@fleetdriver.in','+91 90000 10002','1982-03-12','MH1220191000002','2028-03-22','Flat 102, Transport Colony','com-1','active','2025-03-03 09:00:00'),
('drv-3','DRV-0003','Suresh','Nair','suresh.nair@fleetdriver.in','+91 90000 10003','1983-04-13','MH1320191000003','2028-04-23','Flat 103, Transport Colony','com-2','active','2025-03-04 09:00:00'),
('drv-4','DRV-0004','Deepak','Yadav','deepak.yadav@fleetdriver.in','+91 90000 10004','1984-05-14','MH1420191000004','2028-05-24','Flat 104, Transport Colony','com-3','active','2025-03-05 09:00:00'),
('drv-5','DRV-0005','Mohit','Verma','mohit.verma@fleetdriver.in','+91 90000 10005','1985-06-15','MH1520191000005','2028-06-25','Flat 105, Transport Colony','com-3','active','2025-03-06 09:00:00'),
('drv-6','DRV-0006','Anil','Joseph','anil.joseph@fleetdriver.in','+91 90000 10006','1986-07-16','MH1620191000006','2028-07-26','Flat 106, Transport Colony','com-4','active','2025-03-07 09:00:00'),
('drv-7','DRV-0007','Ramesh','Gowda','ramesh.gowda@fleetdriver.in','+91 90000 10007','1987-08-17','MH1720191000007','2028-08-27','Flat 107, Transport Colony','com-5','active','2025-03-08 09:00:00'),
('drv-8','DRV-0008','Farhan','Sheikh','farhan.sheikh@fleetdriver.in','+91 90000 10008','1988-09-18','MH1820191000008','2028-09-28','Flat 108, Transport Colony','com-6','active','2025-03-09 09:00:00'),
('drv-9','DRV-0009','Nitin','Rao','nitin.rao@fleetdriver.in','+91 90000 10009','1989-01-19','MH1920191000009','2028-01-20','Flat 109, Transport Colony','com-2','active','2025-03-01 09:00:00'),
('drv-10','DRV-0010','Sanjay','Kumar','sanjay.kumar@fleetdriver.in','+91 90000 10010','1990-02-10','MH2020191000010','2028-02-21','Flat 110, Transport Colony','com-5','active','2025-03-02 09:00:00');

-- Vehicles ----------------------------------------------------------
INSERT INTO vehicles (id, code, registration_number, company_id, type, make, model, year, fuel_type, vin, driver_id, status, created_at) VALUES
('veh-1','VEH-0001','MH11AB1007','com-1','Truck','Ashok Leyland','Boss 1115',2019,'Diesel','MAT700000000001','drv-1','active','2025-04-01 09:00:00'),
('veh-2','VEH-0002','MH12AB1014','com-1','Truck','Mahindra','Blazo X 28',2020,'Diesel','MAT700000000002','drv-2','active','2025-04-01 09:00:00'),
('veh-3','VEH-0003','MH13AB1021','com-2','Truck','Eicher','Pro 3015',2021,'Diesel','MAT700000000003','drv-3','active','2025-04-01 09:00:00'),
('veh-4','VEH-0004','MH14AB1028','com-3','Truck','BharatBenz','1917R',2022,'Diesel','MAT700000000004','drv-4','active','2025-04-01 09:00:00'),
('veh-5','VEH-0005','MH15AB1035','com-3','Truck','Tata','Prima 4028',2023,'Diesel','MAT700000000005','drv-5','active','2025-04-01 09:00:00'),
('veh-6','VEH-0006','MH16AB1042','com-4','Truck','Ashok Leyland','Boss 1115',2024,'Diesel','MAT700000000006','drv-6','active','2025-04-01 09:00:00'),
('veh-7','VEH-0007','MH17AB1049','com-5','Truck','Mahindra','Blazo X 28',2018,'Diesel','MAT700000000007','drv-7','active','2025-04-01 09:00:00'),
('veh-8','VEH-0008','MH18AB1056','com-6','Truck','Eicher','Pro 3015',2019,'Diesel','MAT700000000008','drv-8','active','2025-04-01 09:00:00'),
('veh-9','VEH-0009','MH19AB1063','com-2','Truck','BharatBenz','1917R',2020,'Diesel','MAT700000000009','drv-9','active','2025-04-01 09:00:00'),
('veh-10','VEH-0010','MH20AB1070','com-5','Truck','Tata','Prima 4028',2021,'Diesel','MAT700000000010','drv-10','active','2025-04-01 09:00:00'),
('veh-11','VEH-0011','MH21AB1077','com-1','Truck','Ashok Leyland','Boss 1115',2022,'Diesel','MAT700000000011','drv-1','active','2025-04-01 09:00:00'),
('veh-12','VEH-0012','MH22AB1084','com-1','Truck','Mahindra','Blazo X 28',2023,'Diesel','MAT700000000012','drv-2','active','2025-04-01 09:00:00');

-- Fleet cards -------------------------------------------------------
INSERT INTO fleet_cards (id, card_number, masked, company_id, driver_id, vehicle_id, card_type, issue_date, expiry_date, status, spending_limit, used_amount) VALUES
('card-1','5412000198761001','**** **** **** 1013','com-1','drv-1','veh-1','Fuel','2025-05-01','2028-04-30','active',150000,0),
('card-2','5412000298761002','**** **** **** 1026','com-1','drv-2','veh-2','Fuel','2025-05-01','2028-04-30','active',150000,0),
('card-3','5412000398761003','**** **** **** 1039','com-2','drv-3','veh-3','Fuel','2025-05-01','2028-04-30','active',150000,0),
('card-4','5412000498761004','**** **** **** 1052','com-3','drv-4','veh-4','Fuel','2025-05-01','2028-04-30','active',150000,0),
('card-5','5412000598761005','**** **** **** 1065','com-3','drv-5','veh-5','Fuel','2025-05-01','2028-04-30','active',150000,0),
('card-6','5412000698761006','**** **** **** 1078','com-4','drv-6','veh-6','Fuel','2025-05-01','2028-04-30','active',150000,0),
('card-7','5412000798761007','**** **** **** 1091','com-5','drv-7','veh-7','Fuel','2025-05-01','2028-04-30','active',150000,0),
('card-8','5412000898761008','**** **** **** 1104','com-6','drv-8','veh-8','Fuel','2025-05-01','2028-04-30','active',150000,0),
('card-9','5412000998761009','**** **** **** 1117','com-2','drv-9','veh-9','Fuel','2025-05-01','2028-04-30','blocked',150000,0),
('card-10','5412001098761010','**** **** **** 1130','com-5','drv-10','veh-10','Fuel','2025-05-01','2028-04-30','suspended',150000,0),
('card-11','5412001198761011','**** **** **** 1143','com-1','drv-1','veh-11','Fuel','2025-05-01','2028-04-30','expired',150000,0),
('card-12','5412001298761012','**** **** **** 1156','com-1','drv-2','veh-12','Fuel','2025-05-01','2028-04-30','pending',150000,0);

INSERT INTO card_status_history (card_id, status, changed_by, note, changed_at) VALUES
('card-1','active','Aarav Sharma','Initial issue','2025-05-01 09:00:00'),
('card-2','active','Aarav Sharma','Initial issue','2025-05-01 09:00:00'),
('card-3','active','Aarav Sharma','Initial issue','2025-05-01 09:00:00'),
('card-4','active','Aarav Sharma','Initial issue','2025-05-01 09:00:00'),
('card-5','active','Aarav Sharma','Initial issue','2025-05-01 09:00:00'),
('card-6','active','Aarav Sharma','Initial issue','2025-05-01 09:00:00'),
('card-7','active','Aarav Sharma','Initial issue','2025-05-01 09:00:00'),
('card-8','active','Aarav Sharma','Initial issue','2025-05-01 09:00:00'),
('card-9','blocked','Aarav Sharma','Initial issue','2025-05-01 09:00:00'),
('card-10','suspended','Aarav Sharma','Initial issue','2025-05-01 09:00:00'),
('card-11','expired','Aarav Sharma','Initial issue','2025-05-01 09:00:00'),
('card-12','pending','Aarav Sharma','Initial issue','2025-05-01 09:00:00');

-- Cross links (driver <-> vehicle <-> card) -------------------------
UPDATE drivers SET vehicle_id='veh-1', card_id='card-1' WHERE id='drv-1';
UPDATE vehicles SET card_id='card-1' WHERE id='veh-1';
UPDATE drivers SET vehicle_id='veh-2', card_id='card-2' WHERE id='drv-2';
UPDATE vehicles SET card_id='card-2' WHERE id='veh-2';
UPDATE drivers SET vehicle_id='veh-3', card_id='card-3' WHERE id='drv-3';
UPDATE vehicles SET card_id='card-3' WHERE id='veh-3';
UPDATE drivers SET vehicle_id='veh-4', card_id='card-4' WHERE id='drv-4';
UPDATE vehicles SET card_id='card-4' WHERE id='veh-4';
UPDATE drivers SET vehicle_id='veh-5', card_id='card-5' WHERE id='drv-5';
UPDATE vehicles SET card_id='card-5' WHERE id='veh-5';
UPDATE drivers SET vehicle_id='veh-6', card_id='card-6' WHERE id='drv-6';
UPDATE vehicles SET card_id='card-6' WHERE id='veh-6';
UPDATE drivers SET vehicle_id='veh-7', card_id='card-7' WHERE id='drv-7';
UPDATE vehicles SET card_id='card-7' WHERE id='veh-7';
UPDATE drivers SET vehicle_id='veh-8', card_id='card-8' WHERE id='drv-8';
UPDATE vehicles SET card_id='card-8' WHERE id='veh-8';
UPDATE drivers SET vehicle_id='veh-9', card_id='card-9' WHERE id='drv-9';
UPDATE vehicles SET card_id='card-9' WHERE id='veh-9';
UPDATE drivers SET vehicle_id='veh-10', card_id='card-10' WHERE id='drv-10';
UPDATE vehicles SET card_id='card-10' WHERE id='veh-10';
UPDATE drivers SET vehicle_id='veh-11', card_id='card-11' WHERE id='drv-1';
UPDATE vehicles SET card_id='card-11' WHERE id='veh-11';
UPDATE drivers SET vehicle_id='veh-12', card_id='card-12' WHERE id='drv-2';
UPDATE vehicles SET card_id='card-12' WHERE id='veh-12';

-- Transactions ------------------------------------------------------
INSERT INTO transactions (id, reference, occurred_at, company_id, driver_id, card_id, vehicle_id, supplier_id, location, type, product, quantity, unit_price, tax, total, status) VALUES
('txn-1','TXN-000001','2026-05-04 09:23:00','com-2','drv-3','card-3','veh-3','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-2','TXN-000002','2026-05-04 08:27:00','com-5','drv-10','card-10','veh-10','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Diesel',202.84,95.4,3483.17,22834.11,'completed'),
('txn-3','TXN-000003','2026-05-04 07:52:00','com-5','drv-7','card-7','veh-7','sup-5','PartsHub India, Bengaluru','Fuel','Diesel',75.73,95.4,1300.44,8525.08,'completed'),
('txn-4','TXN-000004','2026-05-05 18:03:00','com-3','drv-4','card-4','veh-4','sup-5','PartsHub India, Bengaluru','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-5','TXN-000005','2026-05-06 19:09:00','com-1','drv-1','card-1','veh-1','sup-2','GreenPetro Hinjewadi, Pune','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-6','TXN-000006','2026-05-06 09:37:00','com-2','drv-9','card-9','veh-9','sup-5','PartsHub India, Bengaluru','Fuel','Diesel',138.47,95.4,2377.81,15587.85,'completed'),
('txn-7','TXN-000007','2026-05-07 07:39:00','com-4','drv-6','card-6','veh-6','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Diesel',134.07,95.4,2302.25,15092.53,'refunded'),
('txn-8','TXN-000008','2026-05-07 16:29:00','com-3','drv-4','card-4','veh-4','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-9','TXN-000009','2026-05-08 13:05:00','com-4','drv-6','card-6','veh-6','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-10','TXN-000010','2026-05-08 16:46:00','com-5','drv-10','card-10','veh-10','sup-5','PartsHub India, Bengaluru','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-11','TXN-000011','2026-05-08 09:32:00','com-6','drv-8','card-8','veh-8','sup-5','PartsHub India, Bengaluru','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-12','TXN-000012','2026-05-08 19:02:00','com-5','drv-7','card-7','veh-7','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',173.86,106.2,3323.51,21787.44,'completed'),
('txn-13','TXN-000013','2026-05-09 17:38:00','com-2','drv-9','card-9','veh-9','sup-3','TrackFix Service Center, Delhi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-14','TXN-000014','2026-05-10 14:30:00','com-5','drv-10','card-10','veh-10','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-15','TXN-000015','2026-05-10 15:41:00','com-1','drv-2','card-12','veh-12','sup-1','HighWay Fuels Andheri, Mumbai','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-16','TXN-000016','2026-05-10 18:56:00','com-5','drv-10','card-10','veh-10','sup-4','Kerala Auto Workshop, Kochi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-17','TXN-000017','2026-05-10 17:10:00','com-1','drv-1','card-11','veh-11','sup-1','HighWay Fuels Andheri, Mumbai','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-18','TXN-000018','2026-05-11 13:25:00','com-6','drv-8','card-8','veh-8','sup-3','TrackFix Service Center, Delhi','Fuel','Diesel',71.46,95.4,1227.11,8044.39,'completed'),
('txn-19','TXN-000019','2026-05-12 14:56:00','com-6','drv-8','card-8','veh-8','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',61.61,95.4,1057.97,6935.56,'pending'),
('txn-20','TXN-000020','2026-05-12 19:22:00','com-2','drv-3','card-3','veh-3','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-21','TXN-000021','2026-05-12 08:11:00','com-1','drv-1','card-11','veh-11','sup-2','GreenPetro Hinjewadi, Pune','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-22','TXN-000022','2026-05-12 11:16:00','com-2','drv-3','card-3','veh-3','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',155.12,106.2,2965.27,19439.01,'completed'),
('txn-23','TXN-000023','2026-05-13 16:08:00','com-1','drv-1','card-1','veh-1','sup-3','TrackFix Service Center, Delhi','Fuel','Petrol',109.6,106.2,2095.11,13734.63,'failed'),
('txn-24','TXN-000024','2026-05-13 20:57:00','com-1','drv-2','card-12','veh-12','sup-5','PartsHub India, Bengaluru','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-25','TXN-000025','2026-05-13 18:25:00','com-1','drv-1','card-11','veh-11','sup-4','Kerala Auto Workshop, Kochi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-26','TXN-000026','2026-05-14 12:04:00','com-6','drv-8','card-8','veh-8','sup-4','Kerala Auto Workshop, Kochi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-27','TXN-000027','2026-05-15 09:00:00','com-6','drv-8','card-8','veh-8','sup-5','PartsHub India, Bengaluru','Fuel','Petrol',50.89,106.2,972.81,6377.33,'completed'),
('txn-28','TXN-000028','2026-05-15 06:04:00','com-5','drv-10','card-10','veh-10','sup-3','TrackFix Service Center, Delhi','Fuel','Petrol',131.96,106.2,2522.55,16536.7,'failed'),
('txn-29','TXN-000029','2026-05-16 17:38:00','com-5','drv-10','card-10','veh-10','sup-2','GreenPetro Hinjewadi, Pune','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-30','TXN-000030','2026-05-16 21:29:00','com-4','drv-6','card-6','veh-6','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-31','TXN-000031','2026-05-17 09:47:00','com-6','drv-8','card-8','veh-8','sup-1','HighWay Fuels Andheri, Mumbai','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-32','TXN-000032','2026-05-17 11:33:00','com-4','drv-6','card-6','veh-6','sup-3','TrackFix Service Center, Delhi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-33','TXN-000033','2026-05-17 10:44:00','com-1','drv-1','card-1','veh-1','sup-5','PartsHub India, Bengaluru','Fuel','Petrol',210.69,106.2,4027.55,26402.83,'completed'),
('txn-34','TXN-000034','2026-05-17 14:33:00','com-2','drv-9','card-9','veh-9','sup-3','TrackFix Service Center, Delhi','Fuel','Diesel',174.05,95.4,2988.79,19593.16,'completed'),
('txn-35','TXN-000035','2026-05-18 16:40:00','com-2','drv-3','card-3','veh-3','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'pending'),
('txn-36','TXN-000036','2026-05-18 18:47:00','com-3','drv-4','card-4','veh-4','sup-2','GreenPetro Hinjewadi, Pune','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-37','TXN-000037','2026-05-18 06:50:00','com-3','drv-4','card-4','veh-4','sup-3','TrackFix Service Center, Delhi','Fuel','Petrol',128.35,106.2,2453.54,16084.31,'completed'),
('txn-38','TXN-000038','2026-05-19 17:28:00','com-6','drv-8','card-8','veh-8','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'failed'),
('txn-39','TXN-000039','2026-05-19 13:06:00','com-1','drv-2','card-12','veh-12','sup-3','TrackFix Service Center, Delhi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-40','TXN-000040','2026-05-19 12:30:00','com-3','drv-4','card-4','veh-4','sup-2','GreenPetro Hinjewadi, Pune','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-41','TXN-000041','2026-05-20 09:58:00','com-6','drv-8','card-8','veh-8','sup-3','TrackFix Service Center, Delhi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-42','TXN-000042','2026-05-21 16:05:00','com-1','drv-2','card-12','veh-12','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',120.83,106.2,2309.79,15141.94,'completed'),
('txn-43','TXN-000043','2026-05-21 08:46:00','com-1','drv-2','card-12','veh-12','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-44','TXN-000044','2026-05-21 20:51:00','com-2','drv-3','card-3','veh-3','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',218.69,106.2,4180.48,27405.36,'completed'),
('txn-45','TXN-000045','2026-05-21 17:09:00','com-1','drv-1','card-11','veh-11','sup-5','PartsHub India, Bengaluru','Fuel','Petrol',146.2,106.2,2794.76,18321.2,'completed'),
('txn-46','TXN-000046','2026-05-22 10:27:00','com-1','drv-1','card-1','veh-1','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Diesel',181.88,95.4,3123.24,20474.59,'completed'),
('txn-47','TXN-000047','2026-05-22 13:48:00','com-3','drv-4','card-4','veh-4','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',35.32,106.2,675.18,4426.16,'completed'),
('txn-48','TXN-000048','2026-05-23 07:58:00','com-3','drv-5','card-5','veh-5','sup-4','Kerala Auto Workshop, Kochi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-49','TXN-000049','2026-05-23 19:52:00','com-1','drv-2','card-12','veh-12','sup-4','Kerala Auto Workshop, Kochi','Service','Oil change',1,2400,432.0,2832.0,'refunded'),
('txn-50','TXN-000050','2026-05-23 06:55:00','com-2','drv-9','card-9','veh-9','sup-5','PartsHub India, Bengaluru','Fuel','Petrol',131.05,106.2,2505.15,16422.66,'completed'),
('txn-51','TXN-000051','2026-05-24 11:09:00','com-2','drv-3','card-3','veh-3','sup-1','HighWay Fuels Andheri, Mumbai','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-52','TXN-000052','2026-05-24 07:20:00','com-6','drv-8','card-8','veh-8','sup-1','HighWay Fuels Andheri, Mumbai','Toll','Toll pass',1,850,153.0,1003.0,'pending'),
('txn-53','TXN-000053','2026-05-24 21:50:00','com-1','drv-1','card-11','veh-11','sup-5','PartsHub India, Bengaluru','Toll','Toll pass',1,850,153.0,1003.0,'pending'),
('txn-54','TXN-000054','2026-05-24 12:17:00','com-1','drv-2','card-2','veh-2','sup-1','HighWay Fuels Andheri, Mumbai','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-55','TXN-000055','2026-05-25 06:48:00','com-1','drv-2','card-2','veh-2','sup-4','Kerala Auto Workshop, Kochi','Toll','Toll pass',1,850,153.0,1003.0,'pending'),
('txn-56','TXN-000056','2026-05-26 12:44:00','com-6','drv-8','card-8','veh-8','sup-5','PartsHub India, Bengaluru','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-57','TXN-000057','2026-05-27 13:44:00','com-6','drv-8','card-8','veh-8','sup-5','PartsHub India, Bengaluru','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-58','TXN-000058','2026-05-27 20:08:00','com-2','drv-9','card-9','veh-9','sup-5','PartsHub India, Bengaluru','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-59','TXN-000059','2026-05-27 13:27:00','com-5','drv-7','card-7','veh-7','sup-3','TrackFix Service Center, Delhi','Fuel','Diesel',104.55,95.4,1795.33,11769.4,'completed'),
('txn-60','TXN-000060','2026-05-28 10:45:00','com-3','drv-4','card-4','veh-4','sup-3','TrackFix Service Center, Delhi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-61','TXN-000061','2026-05-29 13:47:00','com-2','drv-3','card-3','veh-3','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-62','TXN-000062','2026-05-29 13:10:00','com-1','drv-2','card-2','veh-2','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-63','TXN-000063','2026-05-29 16:26:00','com-1','drv-2','card-12','veh-12','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-64','TXN-000064','2026-05-30 06:21:00','com-4','drv-6','card-6','veh-6','sup-1','HighWay Fuels Andheri, Mumbai','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-65','TXN-000065','2026-05-30 18:21:00','com-2','drv-9','card-9','veh-9','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-66','TXN-000066','2026-05-31 08:16:00','com-2','drv-9','card-9','veh-9','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Diesel',51.44,95.4,883.33,5790.71,'completed'),
('txn-67','TXN-000067','2026-05-31 10:52:00','com-3','drv-5','card-5','veh-5','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Diesel',202.12,95.4,3470.8,22753.05,'completed'),
('txn-68','TXN-000068','2026-05-31 10:34:00','com-5','drv-7','card-7','veh-7','sup-3','TrackFix Service Center, Delhi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-69','TXN-000069','2026-06-01 07:51:00','com-1','drv-2','card-12','veh-12','sup-1','HighWay Fuels Andheri, Mumbai','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-70','TXN-000070','2026-06-01 06:40:00','com-1','drv-2','card-12','veh-12','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',110.81,106.2,2118.24,13886.26,'completed'),
('txn-71','TXN-000071','2026-06-01 13:04:00','com-1','drv-2','card-2','veh-2','sup-1','HighWay Fuels Andheri, Mumbai','Service','Oil change',1,2400,432.0,2832.0,'failed'),
('txn-72','TXN-000072','2026-06-01 19:59:00','com-3','drv-5','card-5','veh-5','sup-3','TrackFix Service Center, Delhi','Fuel','Diesel',116.22,95.4,1995.73,13083.12,'pending'),
('txn-73','TXN-000073','2026-06-02 11:16:00','com-5','drv-10','card-10','veh-10','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',38.21,106.2,730.42,4788.32,'completed'),
('txn-74','TXN-000074','2026-06-02 12:18:00','com-1','drv-1','card-1','veh-1','sup-3','TrackFix Service Center, Delhi','Fuel','Petrol',68.34,106.2,1306.39,8564.1,'completed'),
('txn-75','TXN-000075','2026-06-02 17:51:00','com-6','drv-8','card-8','veh-8','sup-2','GreenPetro Hinjewadi, Pune','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-76','TXN-000076','2026-06-03 12:32:00','com-3','drv-5','card-5','veh-5','sup-5','PartsHub India, Bengaluru','Fuel','Diesel',32.92,95.4,565.3,3705.87,'pending'),
('txn-77','TXN-000077','2026-06-04 21:34:00','com-3','drv-4','card-4','veh-4','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-78','TXN-000078','2026-06-04 13:21:00','com-5','drv-7','card-7','veh-7','sup-3','TrackFix Service Center, Delhi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-79','TXN-000079','2026-06-04 17:03:00','com-3','drv-4','card-4','veh-4','sup-2','GreenPetro Hinjewadi, Pune','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-80','TXN-000080','2026-06-04 11:03:00','com-2','drv-3','card-3','veh-3','sup-3','TrackFix Service Center, Delhi','Fuel','Diesel',43.44,95.4,745.95,4890.13,'completed'),
('txn-81','TXN-000081','2026-06-05 13:44:00','com-1','drv-1','card-11','veh-11','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-82','TXN-000082','2026-06-06 14:28:00','com-1','drv-1','card-1','veh-1','sup-2','GreenPetro Hinjewadi, Pune','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-83','TXN-000083','2026-06-06 16:15:00','com-1','drv-1','card-1','veh-1','sup-3','TrackFix Service Center, Delhi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-84','TXN-000084','2026-06-06 11:00:00','com-1','drv-1','card-1','veh-1','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-85','TXN-000085','2026-06-07 13:32:00','com-5','drv-7','card-7','veh-7','sup-5','PartsHub India, Bengaluru','Fuel','Diesel',120.18,95.4,2063.73,13528.9,'completed'),
('txn-86','TXN-000086','2026-06-07 18:37:00','com-1','drv-1','card-1','veh-1','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Diesel',80.19,95.4,1377.02,9027.15,'completed'),
('txn-87','TXN-000087','2026-06-07 15:40:00','com-1','drv-1','card-1','veh-1','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-88','TXN-000088','2026-06-08 18:48:00','com-1','drv-2','card-2','veh-2','sup-5','PartsHub India, Bengaluru','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-89','TXN-000089','2026-06-08 15:46:00','com-4','drv-6','card-6','veh-6','sup-4','Kerala Auto Workshop, Kochi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-90','TXN-000090','2026-06-09 10:58:00','com-1','drv-1','card-1','veh-1','sup-5','PartsHub India, Bengaluru','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-91','TXN-000091','2026-06-09 13:05:00','com-2','drv-9','card-9','veh-9','sup-5','PartsHub India, Bengaluru','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-92','TXN-000092','2026-06-10 20:35:00','com-1','drv-1','card-1','veh-1','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',151.05,106.2,2887.47,18928.98,'completed'),
('txn-93','TXN-000093','2026-06-11 14:00:00','com-1','drv-1','card-11','veh-11','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Diesel',148.98,95.4,2558.28,16770.97,'completed'),
('txn-94','TXN-000094','2026-06-12 08:42:00','com-1','drv-2','card-2','veh-2','sup-5','PartsHub India, Bengaluru','Other','AdBlue',1,320,57.6,377.6,'pending'),
('txn-95','TXN-000095','2026-06-12 08:54:00','com-2','drv-9','card-9','veh-9','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',171.69,95.4,2948.26,19327.49,'completed'),
('txn-96','TXN-000096','2026-06-12 20:31:00','com-3','drv-5','card-5','veh-5','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',168.57,106.2,3222.38,21124.51,'completed'),
('txn-97','TXN-000097','2026-06-12 12:04:00','com-5','drv-7','card-7','veh-7','sup-3','TrackFix Service Center, Delhi','Fuel','Diesel',121.01,95.4,2077.98,13622.33,'completed'),
('txn-98','TXN-000098','2026-06-13 10:00:00','com-4','drv-6','card-6','veh-6','sup-3','TrackFix Service Center, Delhi','Service','Oil change',1,2400,432.0,2832.0,'failed'),
('txn-99','TXN-000099','2026-06-13 21:18:00','com-6','drv-8','card-8','veh-8','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Diesel',122.3,95.4,2100.14,13767.56,'completed'),
('txn-100','TXN-000100','2026-06-14 12:19:00','com-6','drv-8','card-8','veh-8','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-101','TXN-000101','2026-06-14 20:04:00','com-1','drv-2','card-2','veh-2','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-102','TXN-000102','2026-06-14 12:58:00','com-2','drv-9','card-9','veh-9','sup-3','TrackFix Service Center, Delhi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-103','TXN-000103','2026-06-15 14:23:00','com-1','drv-2','card-2','veh-2','sup-1','HighWay Fuels Andheri, Mumbai','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-104','TXN-000104','2026-06-15 09:45:00','com-2','drv-3','card-3','veh-3','sup-5','PartsHub India, Bengaluru','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-105','TXN-000105','2026-06-16 06:10:00','com-3','drv-4','card-4','veh-4','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-106','TXN-000106','2026-06-16 15:46:00','com-1','drv-1','card-1','veh-1','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-107','TXN-000107','2026-06-16 16:07:00','com-2','drv-3','card-3','veh-3','sup-3','TrackFix Service Center, Delhi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-108','TXN-000108','2026-06-17 09:59:00','com-1','drv-1','card-1','veh-1','sup-3','TrackFix Service Center, Delhi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-109','TXN-000109','2026-06-17 14:23:00','com-3','drv-4','card-4','veh-4','sup-1','HighWay Fuels Andheri, Mumbai','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-110','TXN-000110','2026-06-17 08:23:00','com-1','drv-2','card-2','veh-2','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'refunded'),
('txn-111','TXN-000111','2026-06-18 10:15:00','com-3','drv-5','card-5','veh-5','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Diesel',83.32,95.4,1430.77,9379.5,'completed'),
('txn-112','TXN-000112','2026-06-18 12:49:00','com-3','drv-5','card-5','veh-5','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-113','TXN-000113','2026-06-18 12:46:00','com-4','drv-6','card-6','veh-6','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-114','TXN-000114','2026-06-18 10:41:00','com-1','drv-2','card-2','veh-2','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',207.36,95.4,3560.79,23342.93,'completed'),
('txn-115','TXN-000115','2026-06-19 11:30:00','com-6','drv-8','card-8','veh-8','sup-5','PartsHub India, Bengaluru','Fuel','Diesel',203.26,95.4,3490.38,22881.38,'completed'),
('txn-116','TXN-000116','2026-06-19 14:47:00','com-5','drv-7','card-7','veh-7','sup-3','TrackFix Service Center, Delhi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-117','TXN-000117','2026-06-19 13:19:00','com-1','drv-2','card-12','veh-12','sup-3','TrackFix Service Center, Delhi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-118','TXN-000118','2026-06-20 11:41:00','com-2','drv-9','card-9','veh-9','sup-4','Kerala Auto Workshop, Kochi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-119','TXN-000119','2026-06-20 13:28:00','com-2','drv-3','card-3','veh-3','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',69.5,95.4,1193.45,7823.75,'pending'),
('txn-120','TXN-000120','2026-06-20 12:15:00','com-4','drv-6','card-6','veh-6','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-121','TXN-000121','2026-06-20 13:23:00','com-1','drv-2','card-2','veh-2','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',94.97,106.2,1815.45,11901.26,'completed'),
('txn-122','TXN-000122','2026-06-21 19:47:00','com-5','drv-10','card-10','veh-10','sup-4','Kerala Auto Workshop, Kochi','Fuel','Petrol',198.58,106.2,3796.06,24885.26,'completed'),
('txn-123','TXN-000123','2026-06-21 21:17:00','com-2','drv-9','card-9','veh-9','sup-3','TrackFix Service Center, Delhi','Fuel','Petrol',101.6,106.2,1942.19,12732.11,'completed'),
('txn-124','TXN-000124','2026-06-21 12:05:00','com-5','drv-10','card-10','veh-10','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-125','TXN-000125','2026-06-22 19:19:00','com-3','drv-4','card-4','veh-4','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-126','TXN-000126','2026-06-22 21:00:00','com-1','drv-1','card-1','veh-1','sup-4','Kerala Auto Workshop, Kochi','Fuel','Petrol',36.13,106.2,690.66,4527.67,'refunded'),
('txn-127','TXN-000127','2026-06-22 20:15:00','com-1','drv-2','card-2','veh-2','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-128','TXN-000128','2026-06-23 08:35:00','com-3','drv-4','card-4','veh-4','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',58.89,106.2,1125.74,7379.86,'completed'),
('txn-129','TXN-000129','2026-06-24 10:40:00','com-1','drv-1','card-1','veh-1','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',74.19,106.2,1418.22,9297.2,'completed'),
('txn-130','TXN-000130','2026-06-25 09:04:00','com-2','drv-9','card-9','veh-9','sup-4','Kerala Auto Workshop, Kochi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-131','TXN-000131','2026-06-25 18:16:00','com-3','drv-5','card-5','veh-5','sup-5','PartsHub India, Bengaluru','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-132','TXN-000132','2026-06-25 15:29:00','com-3','drv-4','card-4','veh-4','sup-1','HighWay Fuels Andheri, Mumbai','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-133','TXN-000133','2026-06-26 13:35:00','com-4','drv-6','card-6','veh-6','sup-2','GreenPetro Hinjewadi, Pune','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-134','TXN-000134','2026-06-26 06:12:00','com-3','drv-4','card-4','veh-4','sup-3','TrackFix Service Center, Delhi','Fuel','Diesel',212.52,95.4,3649.39,23923.8,'completed'),
('txn-135','TXN-000135','2026-06-26 14:14:00','com-6','drv-8','card-8','veh-8','sup-4','Kerala Auto Workshop, Kochi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-136','TXN-000136','2026-06-27 17:43:00','com-4','drv-6','card-6','veh-6','sup-3','TrackFix Service Center, Delhi','Fuel','Petrol',123.66,106.2,2363.88,15496.57,'completed'),
('txn-137','TXN-000137','2026-06-27 08:13:00','com-5','drv-7','card-7','veh-7','sup-3','TrackFix Service Center, Delhi','Fuel','Petrol',31.28,106.2,597.95,3919.89,'completed'),
('txn-138','TXN-000138','2026-06-27 20:14:00','com-6','drv-8','card-8','veh-8','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',89.23,106.2,1705.72,11181.95,'completed'),
('txn-139','TXN-000139','2026-06-27 21:39:00','com-3','drv-5','card-5','veh-5','sup-1','HighWay Fuels Andheri, Mumbai','Service','Oil change',1,2400,432.0,2832.0,'failed'),
('txn-140','TXN-000140','2026-06-28 10:59:00','com-3','drv-4','card-4','veh-4','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-141','TXN-000141','2026-06-28 19:03:00','com-5','drv-7','card-7','veh-7','sup-5','PartsHub India, Bengaluru','Fuel','Diesel',70.46,95.4,1209.94,7931.82,'completed'),
('txn-142','TXN-000142','2026-06-29 09:05:00','com-2','drv-3','card-3','veh-3','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-143','TXN-000143','2026-06-30 07:19:00','com-4','drv-6','card-6','veh-6','sup-5','PartsHub India, Bengaluru','Fuel','Petrol',65.25,106.2,1247.32,8176.87,'completed'),
('txn-144','TXN-000144','2026-06-30 16:28:00','com-1','drv-1','card-11','veh-11','sup-4','Kerala Auto Workshop, Kochi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-145','TXN-000145','2026-07-01 19:56:00','com-1','drv-2','card-2','veh-2','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Diesel',44.87,95.4,770.51,5051.11,'completed'),
('txn-146','TXN-000146','2026-07-01 17:49:00','com-1','drv-2','card-2','veh-2','sup-2','GreenPetro Hinjewadi, Pune','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-147','TXN-000147','2026-07-02 17:34:00','com-5','drv-7','card-7','veh-7','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',39.36,95.4,675.89,4430.83,'completed'),
('txn-148','TXN-000148','2026-07-02 19:15:00','com-6','drv-8','card-8','veh-8','sup-4','Kerala Auto Workshop, Kochi','Fuel','Petrol',91.43,106.2,1747.78,11457.65,'completed'),
('txn-149','TXN-000149','2026-07-02 07:29:00','com-1','drv-1','card-11','veh-11','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-150','TXN-000150','2026-07-03 16:23:00','com-1','drv-1','card-1','veh-1','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-151','TXN-000151','2026-07-04 16:59:00','com-4','drv-6','card-6','veh-6','sup-1','HighWay Fuels Andheri, Mumbai','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-152','TXN-000152','2026-07-04 08:01:00','com-3','drv-5','card-5','veh-5','sup-1','HighWay Fuels Andheri, Mumbai','Service','Oil change',1,2400,432.0,2832.0,'failed'),
('txn-153','TXN-000153','2026-07-04 14:58:00','com-3','drv-4','card-4','veh-4','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',120.29,95.4,2065.62,13541.29,'completed'),
('txn-154','TXN-000154','2026-07-05 15:52:00','com-6','drv-8','card-8','veh-8','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',206.34,106.2,3944.4,25857.71,'completed'),
('txn-155','TXN-000155','2026-07-05 20:23:00','com-1','drv-2','card-12','veh-12','sup-3','TrackFix Service Center, Delhi','Fuel','Petrol',145.38,106.2,2779.08,18218.44,'completed'),
('txn-156','TXN-000156','2026-07-05 13:26:00','com-5','drv-10','card-10','veh-10','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',127.26,95.4,2185.31,14325.91,'completed'),
('txn-157','TXN-000157','2026-07-05 16:10:00','com-1','drv-2','card-2','veh-2','sup-1','HighWay Fuels Andheri, Mumbai','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-158','TXN-000158','2026-07-06 09:26:00','com-1','drv-2','card-2','veh-2','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Diesel',80.33,95.4,1379.43,9042.91,'completed'),
('txn-159','TXN-000159','2026-07-06 13:08:00','com-6','drv-8','card-8','veh-8','sup-4','Kerala Auto Workshop, Kochi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-160','TXN-000160','2026-07-06 09:49:00','com-5','drv-7','card-7','veh-7','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-161','TXN-000161','2026-07-06 14:23:00','com-3','drv-5','card-5','veh-5','sup-3','TrackFix Service Center, Delhi','Service','Oil change',1,2400,432.0,2832.0,'refunded'),
('txn-162','TXN-000162','2026-07-07 13:11:00','com-1','drv-2','card-12','veh-12','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-163','TXN-000163','2026-07-07 16:04:00','com-3','drv-4','card-4','veh-4','sup-5','PartsHub India, Bengaluru','Fuel','Petrol',59.13,106.2,1130.33,7409.94,'completed'),
('txn-164','TXN-000164','2026-07-07 13:41:00','com-5','drv-7','card-7','veh-7','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-165','TXN-000165','2026-07-08 06:30:00','com-1','drv-1','card-11','veh-11','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-166','TXN-000166','2026-07-09 13:07:00','com-6','drv-8','card-8','veh-8','sup-1','HighWay Fuels Andheri, Mumbai','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-167','TXN-000167','2026-07-09 08:23:00','com-1','drv-1','card-1','veh-1','sup-5','PartsHub India, Bengaluru','Fuel','Petrol',144.09,106.2,2754.42,18056.78,'completed'),
('txn-168','TXN-000168','2026-07-10 09:40:00','com-6','drv-8','card-8','veh-8','sup-3','TrackFix Service Center, Delhi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-169','TXN-000169','2026-07-10 12:02:00','com-5','drv-10','card-10','veh-10','sup-5','PartsHub India, Bengaluru','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-170','TXN-000170','2026-07-11 12:52:00','com-4','drv-6','card-6','veh-6','sup-3','TrackFix Service Center, Delhi','Fuel','Petrol',38.39,106.2,733.86,4810.88,'completed'),
('txn-171','TXN-000171','2026-07-11 11:39:00','com-1','drv-1','card-1','veh-1','sup-4','Kerala Auto Workshop, Kochi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-172','TXN-000172','2026-07-11 21:04:00','com-3','drv-5','card-5','veh-5','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',68.65,95.4,1178.86,7728.07,'pending'),
('txn-173','TXN-000173','2026-07-12 08:41:00','com-1','drv-2','card-2','veh-2','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-174','TXN-000174','2026-07-12 15:42:00','com-2','drv-3','card-3','veh-3','sup-3','TrackFix Service Center, Delhi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-175','TXN-000175','2026-07-12 17:26:00','com-3','drv-5','card-5','veh-5','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-176','TXN-000176','2026-07-12 18:46:00','com-5','drv-7','card-7','veh-7','sup-3','TrackFix Service Center, Delhi','Fuel','Diesel',194.21,95.4,3334.97,21862.6,'completed'),
('txn-177','TXN-000177','2026-07-13 09:52:00','com-3','drv-4','card-4','veh-4','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Diesel',112.49,95.4,1931.68,12663.23,'completed'),
('txn-178','TXN-000178','2026-07-13 20:49:00','com-1','drv-2','card-2','veh-2','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-179','TXN-000179','2026-07-13 18:05:00','com-2','drv-3','card-3','veh-3','sup-5','PartsHub India, Bengaluru','Fuel','Petrol',32.82,106.2,627.39,4112.87,'completed'),
('txn-180','TXN-000180','2026-07-13 11:09:00','com-5','drv-10','card-10','veh-10','sup-3','TrackFix Service Center, Delhi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-181','TXN-000181','2026-07-14 18:31:00','com-3','drv-5','card-5','veh-5','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',129.02,106.2,2466.35,16168.27,'completed'),
('txn-182','TXN-000182','2026-07-14 21:20:00','com-3','drv-4','card-4','veh-4','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-183','TXN-000183','2026-07-14 11:40:00','com-1','drv-1','card-1','veh-1','sup-4','Kerala Auto Workshop, Kochi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-184','TXN-000184','2026-07-15 21:11:00','com-5','drv-10','card-10','veh-10','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-185','TXN-000185','2026-07-15 18:22:00','com-5','drv-10','card-10','veh-10','sup-5','PartsHub India, Bengaluru','Fuel','Petrol',37.93,106.2,725.07,4753.24,'completed'),
('txn-186','TXN-000186','2026-07-16 07:42:00','com-2','drv-3','card-3','veh-3','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',214.43,106.2,4099.04,26871.51,'completed'),
('txn-187','TXN-000187','2026-07-17 15:41:00','com-1','drv-2','card-2','veh-2','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-188','TXN-000188','2026-07-17 19:24:00','com-5','drv-7','card-7','veh-7','sup-5','PartsHub India, Bengaluru','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-189','TXN-000189','2026-07-17 20:11:00','com-1','drv-1','card-11','veh-11','sup-4','Kerala Auto Workshop, Kochi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-190','TXN-000190','2026-07-18 13:28:00','com-1','drv-1','card-1','veh-1','sup-4','Kerala Auto Workshop, Kochi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-191','TXN-000191','2026-07-19 08:08:00','com-2','drv-3','card-3','veh-3','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-192','TXN-000192','2026-07-19 20:32:00','com-4','drv-6','card-6','veh-6','sup-3','TrackFix Service Center, Delhi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-193','TXN-000193','2026-07-19 10:05:00','com-2','drv-9','card-9','veh-9','sup-1','HighWay Fuels Andheri, Mumbai','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-194','TXN-000194','2026-07-19 07:48:00','com-1','drv-2','card-12','veh-12','sup-5','PartsHub India, Bengaluru','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-195','TXN-000195','2026-07-20 09:12:00','com-1','drv-1','card-11','veh-11','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',34.91,106.2,667.34,4374.78,'failed'),
('txn-196','TXN-000196','2026-07-20 13:04:00','com-2','drv-3','card-3','veh-3','sup-3','TrackFix Service Center, Delhi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-197','TXN-000197','2026-07-20 16:57:00','com-4','drv-6','card-6','veh-6','sup-3','TrackFix Service Center, Delhi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-198','TXN-000198','2026-07-20 14:32:00','com-5','drv-10','card-10','veh-10','sup-4','Kerala Auto Workshop, Kochi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-199','TXN-000199','2026-07-21 13:20:00','com-3','drv-4','card-4','veh-4','sup-3','TrackFix Service Center, Delhi','Toll','Toll pass',1,850,153.0,1003.0,'failed'),
('txn-200','TXN-000200','2026-07-21 14:43:00','com-4','drv-6','card-6','veh-6','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',67.8,95.4,1164.26,7632.38,'completed'),
('txn-201','TXN-000201','2026-07-21 09:49:00','com-4','drv-6','card-6','veh-6','sup-2','GreenPetro Hinjewadi, Pune','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-202','TXN-000202','2026-07-21 09:16:00','com-2','drv-9','card-9','veh-9','sup-3','TrackFix Service Center, Delhi','Fuel','Diesel',150.9,95.4,2591.25,16987.11,'completed'),
('txn-203','TXN-000203','2026-07-22 17:36:00','com-1','drv-2','card-12','veh-12','sup-3','TrackFix Service Center, Delhi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-204','TXN-000204','2026-07-22 20:14:00','com-2','drv-3','card-3','veh-3','sup-3','TrackFix Service Center, Delhi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-205','TXN-000205','2026-07-22 14:19:00','com-2','drv-3','card-3','veh-3','sup-1','HighWay Fuels Andheri, Mumbai','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-206','TXN-000206','2026-07-22 07:14:00','com-1','drv-1','card-11','veh-11','sup-3','TrackFix Service Center, Delhi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-207','TXN-000207','2026-07-23 17:57:00','com-3','drv-5','card-5','veh-5','sup-4','Kerala Auto Workshop, Kochi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-208','TXN-000208','2026-07-23 06:03:00','com-1','drv-1','card-1','veh-1','sup-5','PartsHub India, Bengaluru','Fuel','Petrol',122.79,106.2,2347.25,15387.55,'completed'),
('txn-209','TXN-000209','2026-07-24 17:34:00','com-5','drv-10','card-10','veh-10','sup-3','TrackFix Service Center, Delhi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-210','TXN-000210','2026-07-25 10:13:00','com-5','drv-7','card-7','veh-7','sup-3','TrackFix Service Center, Delhi','Toll','Toll pass',1,850,153.0,1003.0,'refunded'),
('txn-211','TXN-000211','2026-07-25 10:00:00','com-4','drv-6','card-6','veh-6','sup-4','Kerala Auto Workshop, Kochi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-212','TXN-000212','2026-07-26 14:25:00','com-1','drv-2','card-12','veh-12','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',115.66,106.2,2210.96,14494.05,'completed'),
('txn-213','TXN-000213','2026-07-26 20:38:00','com-3','drv-5','card-5','veh-5','sup-5','PartsHub India, Bengaluru','Fuel','Diesel',40.66,95.4,698.21,4577.17,'completed'),
('txn-214','TXN-000214','2026-07-27 06:25:00','com-3','drv-4','card-4','veh-4','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',201.67,106.2,3855.12,25272.47,'completed'),
('txn-215','TXN-000215','2026-07-27 12:09:00','com-2','drv-3','card-3','veh-3','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',60.25,106.2,1151.74,7550.29,'completed'),
('txn-216','TXN-000216','2026-07-27 11:32:00','com-5','drv-7','card-7','veh-7','sup-5','PartsHub India, Bengaluru','Fuel','Petrol',128.47,106.2,2455.83,16099.34,'completed'),
('txn-217','TXN-000217','2026-07-27 06:24:00','com-3','drv-5','card-5','veh-5','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Diesel',87.05,95.4,1494.82,9799.39,'completed'),
('txn-218','TXN-000218','2026-07-28 11:14:00','com-1','drv-2','card-12','veh-12','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-219','TXN-000219','2026-07-28 09:21:00','com-1','drv-2','card-2','veh-2','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-220','TXN-000220','2026-07-28 14:40:00','com-1','drv-2','card-12','veh-12','sup-3','TrackFix Service Center, Delhi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-221','TXN-000221','2026-07-28 14:18:00','com-2','drv-9','card-9','veh-9','sup-4','Kerala Auto Workshop, Kochi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-222','TXN-000222','2026-07-29 14:57:00','com-1','drv-2','card-2','veh-2','sup-1','HighWay Fuels Andheri, Mumbai','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-223','TXN-000223','2026-07-29 16:12:00','com-3','drv-4','card-4','veh-4','sup-2','GreenPetro Hinjewadi, Pune','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-224','TXN-000224','2026-07-30 21:30:00','com-4','drv-6','card-6','veh-6','sup-2','GreenPetro Hinjewadi, Pune','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-225','TXN-000225','2026-07-30 19:46:00','com-2','drv-9','card-9','veh-9','sup-1','HighWay Fuels Andheri, Mumbai','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-226','TXN-000226','2026-07-30 18:39:00','com-3','drv-4','card-4','veh-4','sup-3','TrackFix Service Center, Delhi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-227','TXN-000227','2026-07-30 07:01:00','com-5','drv-10','card-10','veh-10','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Diesel',137.39,95.4,2359.26,15466.27,'completed'),
('txn-228','TXN-000228','2026-07-31 10:44:00','com-1','drv-2','card-2','veh-2','sup-2','GreenPetro Hinjewadi, Pune','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-229','TXN-000229','2026-08-01 07:04:00','com-1','drv-1','card-1','veh-1','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Diesel',56.3,95.4,966.78,6337.8,'completed'),
('txn-230','TXN-000230','2026-08-02 09:15:00','com-3','drv-4','card-4','veh-4','sup-1','HighWay Fuels Andheri, Mumbai','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-231','TXN-000231','2026-08-02 15:30:00','com-3','drv-4','card-4','veh-4','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',51.27,106.2,980.08,6424.95,'completed'),
('txn-232','TXN-000232','2026-08-02 16:21:00','com-1','drv-2','card-2','veh-2','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',48.59,106.2,928.85,6089.11,'completed'),
('txn-233','TXN-000233','2026-08-03 17:58:00','com-3','drv-5','card-5','veh-5','sup-3','TrackFix Service Center, Delhi','Fuel','Diesel',96.67,95.4,1660.02,10882.34,'completed'),
('txn-234','TXN-000234','2026-08-03 15:39:00','com-4','drv-6','card-6','veh-6','sup-5','PartsHub India, Bengaluru','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-235','TXN-000235','2026-08-03 09:22:00','com-1','drv-2','card-12','veh-12','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Diesel',179.92,95.4,3089.59,20253.96,'completed'),
('txn-236','TXN-000236','2026-08-03 12:45:00','com-6','drv-8','card-8','veh-8','sup-1','HighWay Fuels Andheri, Mumbai','Other','AdBlue',1,320,57.6,377.6,'pending'),
('txn-237','TXN-000237','2026-08-04 06:33:00','com-5','drv-10','card-10','veh-10','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-238','TXN-000238','2026-08-05 21:44:00','com-3','drv-5','card-5','veh-5','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',30.83,95.4,529.41,3470.59,'completed'),
('txn-239','TXN-000239','2026-08-05 14:36:00','com-2','drv-3','card-3','veh-3','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-240','TXN-000240','2026-08-06 11:07:00','com-3','drv-5','card-5','veh-5','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',208.27,106.2,3981.29,26099.56,'completed'),
('txn-241','TXN-000241','2026-08-06 16:22:00','com-1','drv-1','card-11','veh-11','sup-5','PartsHub India, Bengaluru','Fuel','Diesel',123.16,95.4,2114.9,13864.36,'completed'),
('txn-242','TXN-000242','2026-08-07 06:23:00','com-5','drv-7','card-7','veh-7','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-243','TXN-000243','2026-08-08 11:24:00','com-3','drv-5','card-5','veh-5','sup-4','Kerala Auto Workshop, Kochi','Service','Oil change',1,2400,432.0,2832.0,'pending'),
('txn-244','TXN-000244','2026-08-08 07:22:00','com-1','drv-1','card-11','veh-11','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',209.34,106.2,4001.74,26233.65,'pending'),
('txn-245','TXN-000245','2026-08-09 16:10:00','com-2','drv-9','card-9','veh-9','sup-4','Kerala Auto Workshop, Kochi','Fuel','Petrol',194.92,106.2,3726.09,24426.59,'pending'),
('txn-246','TXN-000246','2026-08-09 13:08:00','com-6','drv-8','card-8','veh-8','sup-3','TrackFix Service Center, Delhi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'refunded'),
('txn-247','TXN-000247','2026-08-09 12:17:00','com-4','drv-6','card-6','veh-6','sup-2','GreenPetro Hinjewadi, Pune','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-248','TXN-000248','2026-08-10 13:46:00','com-1','drv-2','card-12','veh-12','sup-2','GreenPetro Hinjewadi, Pune','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-249','TXN-000249','2026-08-10 11:15:00','com-4','drv-6','card-6','veh-6','sup-5','PartsHub India, Bengaluru','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-250','TXN-000250','2026-08-10 09:12:00','com-4','drv-6','card-6','veh-6','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Petrol',79.15,106.2,1513.03,9918.76,'completed'),
('txn-251','TXN-000251','2026-08-11 14:12:00','com-2','drv-3','card-3','veh-3','sup-3','TrackFix Service Center, Delhi','Fuel','Petrol',181.03,106.2,3460.57,22685.96,'completed'),
('txn-252','TXN-000252','2026-08-11 12:56:00','com-1','drv-2','card-2','veh-2','sup-1','HighWay Fuels Andheri, Mumbai','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-253','TXN-000253','2026-08-11 18:54:00','com-5','drv-7','card-7','veh-7','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-254','TXN-000254','2026-08-11 15:29:00','com-5','drv-7','card-7','veh-7','sup-2','GreenPetro Hinjewadi, Pune','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-255','TXN-000255','2026-08-12 06:47:00','com-2','drv-3','card-3','veh-3','sup-5','PartsHub India, Bengaluru','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-256','TXN-000256','2026-08-13 19:54:00','com-5','drv-7','card-7','veh-7','sup-5','PartsHub India, Bengaluru','Other','AdBlue',1,320,57.6,377.6,'refunded'),
('txn-257','TXN-000257','2026-08-13 11:41:00','com-3','drv-4','card-4','veh-4','sup-5','PartsHub India, Bengaluru','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-258','TXN-000258','2026-08-14 09:57:00','com-6','drv-8','card-8','veh-8','sup-3','TrackFix Service Center, Delhi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-259','TXN-000259','2026-08-15 19:30:00','com-3','drv-4','card-4','veh-4','sup-2','GreenPetro Hinjewadi, Pune','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-260','TXN-000260','2026-08-15 11:57:00','com-6','drv-8','card-8','veh-8','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',148.1,95.4,2543.17,16671.91,'completed'),
('txn-261','TXN-000261','2026-08-15 21:58:00','com-1','drv-1','card-11','veh-11','sup-1','HighWay Fuels Andheri, Mumbai','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-262','TXN-000262','2026-08-15 12:33:00','com-1','drv-2','card-2','veh-2','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Diesel',77.73,95.4,1334.78,8750.22,'completed'),
('txn-263','TXN-000263','2026-08-16 12:45:00','com-1','drv-2','card-2','veh-2','sup-4','Kerala Auto Workshop, Kochi','Toll','Toll pass',1,850,153.0,1003.0,'pending'),
('txn-264','TXN-000264','2026-08-16 16:26:00','com-6','drv-8','card-8','veh-8','sup-1','HighWay Fuels Andheri, Mumbai','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-265','TXN-000265','2026-08-16 18:32:00','com-1','drv-2','card-12','veh-12','sup-2','GreenPetro Hinjewadi, Pune','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-266','TXN-000266','2026-08-17 14:17:00','com-1','drv-2','card-12','veh-12','sup-3','TrackFix Service Center, Delhi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-267','TXN-000267','2026-08-18 17:37:00','com-5','drv-7','card-7','veh-7','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',32.53,95.4,558.6,3661.96,'completed'),
('txn-268','TXN-000268','2026-08-18 13:51:00','com-3','drv-5','card-5','veh-5','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',72.64,95.4,1247.37,8177.23,'completed'),
('txn-269','TXN-000269','2026-08-18 10:59:00','com-5','drv-7','card-7','veh-7','sup-2','GreenPetro Hinjewadi, Pune','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-270','TXN-000270','2026-08-18 13:52:00','com-1','drv-2','card-2','veh-2','sup-2','GreenPetro Hinjewadi, Pune','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-271','TXN-000271','2026-08-19 15:48:00','com-4','drv-6','card-6','veh-6','sup-4','Kerala Auto Workshop, Kochi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-272','TXN-000272','2026-08-19 17:50:00','com-2','drv-9','card-9','veh-9','sup-2','GreenPetro Hinjewadi, Pune','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-273','TXN-000273','2026-08-20 19:43:00','com-3','drv-5','card-5','veh-5','sup-4','Kerala Auto Workshop, Kochi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-274','TXN-000274','2026-08-20 17:15:00','com-2','drv-3','card-3','veh-3','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-275','TXN-000275','2026-08-21 08:42:00','com-4','drv-6','card-6','veh-6','sup-4','Kerala Auto Workshop, Kochi','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-276','TXN-000276','2026-08-21 08:52:00','com-4','drv-6','card-6','veh-6','sup-4','Kerala Auto Workshop, Kochi','Fuel','Petrol',206.46,106.2,3946.69,25872.74,'completed'),
('txn-277','TXN-000277','2026-08-21 17:40:00','com-5','drv-10','card-10','veh-10','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-278','TXN-000278','2026-08-22 14:38:00','com-1','drv-1','card-11','veh-11','sup-1','HighWay Fuels Andheri, Mumbai','Fuel','Diesel',69.85,95.4,1199.46,7863.15,'completed'),
('txn-279','TXN-000279','2026-08-23 17:50:00','com-5','drv-10','card-10','veh-10','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',192.29,106.2,3675.82,24097.02,'completed'),
('txn-280','TXN-000280','2026-08-24 08:42:00','com-3','drv-4','card-4','veh-4','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-281','TXN-000281','2026-08-24 21:44:00','com-2','drv-9','card-9','veh-9','sup-3','TrackFix Service Center, Delhi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-282','TXN-000282','2026-08-25 09:16:00','com-2','drv-9','card-9','veh-9','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',170.96,95.4,2935.72,19245.3,'completed'),
('txn-283','TXN-000283','2026-08-25 07:30:00','com-5','drv-7','card-7','veh-7','sup-4','Kerala Auto Workshop, Kochi','Fuel','Petrol',187.14,106.2,3577.37,23451.64,'completed'),
('txn-284','TXN-000284','2026-08-26 21:10:00','com-2','drv-3','card-3','veh-3','sup-4','Kerala Auto Workshop, Kochi','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-285','TXN-000285','2026-08-26 16:29:00','com-2','drv-9','card-9','veh-9','sup-1','HighWay Fuels Andheri, Mumbai','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-286','TXN-000286','2026-08-26 20:23:00','com-1','drv-2','card-12','veh-12','sup-4','Kerala Auto Workshop, Kochi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-287','TXN-000287','2026-08-26 17:40:00','com-5','drv-7','card-7','veh-7','sup-1','HighWay Fuels Andheri, Mumbai','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-288','TXN-000288','2026-08-27 09:32:00','com-1','drv-1','card-1','veh-1','sup-1','HighWay Fuels Andheri, Mumbai','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-289','TXN-000289','2026-08-28 16:06:00','com-6','drv-8','card-8','veh-8','sup-4','Kerala Auto Workshop, Kochi','Fuel','Petrol',36.44,106.2,696.59,4566.52,'completed'),
('txn-290','TXN-000290','2026-08-28 12:18:00','com-1','drv-1','card-11','veh-11','sup-3','TrackFix Service Center, Delhi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-291','TXN-000291','2026-08-28 07:52:00','com-5','drv-7','card-7','veh-7','sup-4','Kerala Auto Workshop, Kochi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-292','TXN-000292','2026-08-28 18:21:00','com-3','drv-5','card-5','veh-5','sup-3','TrackFix Service Center, Delhi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-293','TXN-000293','2026-08-29 09:21:00','com-2','drv-9','card-9','veh-9','sup-2','GreenPetro Hinjewadi, Pune','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-294','TXN-000294','2026-08-29 08:50:00','com-3','drv-4','card-4','veh-4','sup-3','TrackFix Service Center, Delhi','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-295','TXN-000295','2026-08-29 07:25:00','com-1','drv-1','card-1','veh-1','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed'),
('txn-296','TXN-000296','2026-08-30 07:50:00','com-1','drv-2','card-2','veh-2','sup-4','Kerala Auto Workshop, Kochi','Fuel','Diesel',38.82,95.4,666.62,4370.05,'failed'),
('txn-297','TXN-000297','2026-08-30 10:40:00','com-2','drv-9','card-9','veh-9','sup-5','PartsHub India, Bengaluru','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-298','TXN-000298','2026-08-30 12:02:00','com-1','drv-1','card-11','veh-11','sup-5','PartsHub India, Bengaluru','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-299','TXN-000299','2026-08-31 19:49:00','com-1','drv-1','card-11','veh-11','sup-2','GreenPetro Hinjewadi, Pune','Fuel','Petrol',49.26,106.2,941.65,6173.06,'completed'),
('txn-300','TXN-000300','2026-08-31 10:50:00','com-1','drv-2','card-2','veh-2','sup-1','HighWay Fuels Andheri, Mumbai','Other','AdBlue',1,320,57.6,377.6,'completed'),
('txn-301','TXN-000301','2026-08-31 11:26:00','com-3','drv-5','card-5','veh-5','sup-3','TrackFix Service Center, Delhi','Toll','Toll pass',1,850,153.0,1003.0,'completed'),
('txn-302','TXN-000302','2026-08-31 07:31:00','com-1','drv-1','card-1','veh-1','sup-1','HighWay Fuels Andheri, Mumbai','Service','Oil change',1,2400,432.0,2832.0,'completed'),
('txn-303','TXN-000303','2026-09-01 20:04:00','com-1','drv-2','card-2','veh-2','sup-5','PartsHub India, Bengaluru','Maintenance','Brake pads',1,5600,1008.0,6608.0,'completed');

-- Invoices, line items and payments ---------------------------------
INSERT INTO invoices (id, number, company_id, invoice_date, due_date, billing_period, subtotal, tax, discount, total, paid, outstanding, status, notes) VALUES
('inv-1','INV-2026-0001','com-1','2026-08-01','2026-08-31','August 2026',462234.96,83202.3,0,545437.26,545437.26,0.0,'paid','Monthly consolidated invoice'),
('inv-2','INV-2026-0002','com-2','2026-08-30','2026-09-29','August 2026',457967.91,82434.22,0,540402.13,216160.85,324241.28,'partially_paid','Monthly consolidated invoice'),
('inv-3','INV-2026-0003','com-3','2026-04-01','2026-05-01','April 2026',340766.03,61337.88,0,402103.91,0.0,402103.91,'sent','Monthly consolidated invoice'),
('inv-4','INV-2026-0004','com-4','2026-06-18','2026-07-18','June 2026',434461.27,78203.03,0,512664.3,0.0,512664.3,'overdue','Monthly consolidated invoice'),
('inv-5','INV-2026-0005','com-5','2026-05-29','2026-06-28','May 2026',374521.92,67413.95,0,441935.87,441935.87,0.0,'paid','Monthly consolidated invoice'),
('inv-6','INV-2026-0006','com-6','2026-06-27','2026-07-27','June 2026',407793.07,73402.75,0,481195.82,0.0,481195.82,'draft','Monthly consolidated invoice'),
('inv-7','INV-2026-0007','com-1','2026-07-26','2026-08-25','July 2026',370297.23,66653.51,0,436950.74,0.0,436950.74,'sent','Monthly consolidated invoice'),
('inv-8','INV-2026-0008','com-2','2026-08-24','2026-09-23','August 2026',450674.66,81121.45,0,531796.11,319077.67,212718.44,'partially_paid','Monthly consolidated invoice');
INSERT INTO invoice_items (id, invoice_id, description, quantity, unit_price, tax_rate, total) VALUES
('inv-1-item-1','inv-1','Diesel supply',528,100.4,18.00,62553.22),
('inv-1-item-2','inv-1','Service charges',1716,97.76,18.00,197952.27),
('inv-1-item-3','inv-1','Toll and misc',2420,99.78,18.00,284931.77),
('inv-2-item-1','inv-2','Diesel supply',1473,103.1,18.00,179202.23),
('inv-2-item-2','inv-2','Service charges',1623,83.06,18.00,159071.53),
('inv-2-item-3','inv-2','Toll and misc',1819,94.17,18.00,202128.37),
('inv-3-item-1','inv-3','Diesel supply',1783,80.47,18.00,169304.05),
('inv-3-item-2','inv-3','Service charges',509,80.28,18.00,48217.77),
('inv-3-item-3','inv-3','Toll and misc',1870,83.65,18.00,184582.09),
('inv-4-item-1','inv-4','Diesel supply',2479,105.75,18.00,309342.01),
('inv-4-item-2','inv-4','Service charges',946,106.09,18.00,118426.15),
('inv-4-item-3','inv-4','Toll and misc',764,94.17,18.00,84896.14),
('inv-5-item-1','inv-5','Diesel supply',1064,101.58,18.00,127535.72),
('inv-5-item-2','inv-5','Service charges',996,93.52,18.00,109912.19),
('inv-5-item-3','inv-5','Toll and misc',2024,85.62,18.00,204487.96),
('inv-6-item-1','inv-6','Diesel supply',1249,103.22,18.00,152127.7),
('inv-6-item-2','inv-6','Service charges',1961,100.85,18.00,233364.88),
('inv-6-item-3','inv-6','Toll and misc',796,101.89,18.00,95703.24),
('inv-7-item-1','inv-7','Diesel supply',672,88.79,18.00,70406.92),
('inv-7-item-2','inv-7','Service charges',1641,101.28,18.00,196116.57),
('inv-7-item-3','inv-7','Toll and misc',1443,100.09,18.00,170427.25),
('inv-8-item-1','inv-8','Diesel supply',2322,87.62,18.00,240075.3),
('inv-8-item-2','inv-8','Service charges',2474,81.58,18.00,238158.13),
('inv-8-item-3','inv-8','Toll and misc',565,80.34,18.00,53562.68);
INSERT INTO payments (id, reference, invoice_id, company_id, paid_at, amount, method, reference_number, status, created_by, notes) VALUES
('pay-1','PAY-2026-0001','inv-1','com-1','2026-08-26 11:15:00',545437.26,'Bank Transfer','NEFT700000001','completed','Rohit Bansal','Received against invoice INV-2026-0001'),
('pay-2','PAY-2026-0002','inv-2','com-2','2026-09-24 11:15:00',216160.85,'Bank Transfer','NEFT700000002','completed','Rohit Bansal','Received against invoice INV-2026-0002'),
('pay-3','PAY-2026-0003','inv-5','com-5','2026-06-23 09:15:00',441935.87,'Bank Transfer','NEFT700000003','completed','Rohit Bansal','Received against invoice INV-2026-0005'),
('pay-4','PAY-2026-0004','inv-8','com-2','2026-09-18 09:15:00',319077.67,'Bank Transfer','NEFT700000004','completed','Rohit Bansal','Received against invoice INV-2026-0008');

-- Pricing rules -----------------------------------------------------
INSERT INTO pricing_rules (id, code, company_id, supplier_id, category, product, base_price, markup, discount, tax_rate, final_price, effective_from, effective_to, status, updated_by, updated_at) VALUES
('prc-1','PRC-0001','com-2','sup-2','Fuel','Diesel',92.1,3,1,0,93.91,'2026-01-01',NULL,'active','Divya Menon','2026-08-21 11:00:00'),
('prc-2','PRC-0002',NULL,'sup-3','Fuel','Petrol',101.5,3,0,0,104.55,'2026-01-01',NULL,'active','Divya Menon','2026-08-22 11:00:00'),
('prc-3','PRC-0003','com-4',NULL,'Service','Oil change',2200,10,5,18,2712.82,'2026-01-01',NULL,'active','Divya Menon','2026-08-23 11:00:00'),
('prc-4','PRC-0004',NULL,'sup-5','Product','Brake pads',5200,12,0,18,6872.32,'2026-01-01',NULL,'active','Divya Menon','2026-08-24 11:00:00'),
('prc-5','PRC-0005','com-6','sup-1','Fee','Card replacement fee',500,0,0,18,590.0,'2026-01-01',NULL,'active','Divya Menon','2026-08-25 11:00:00'),
('prc-6','PRC-0006',NULL,NULL,'Discount','Volume rebate',100,0,5,0,95.0,'2026-01-01',NULL,'active','Divya Menon','2026-08-26 11:00:00');

-- Notifications -----------------------------------------------------
INSERT INTO notifications (id, title, message, type, severity, is_read, created_at) VALUES
('ntf-1','Invoice overdue','Invoice INV-2026-0004 for Coastal Movers is 45 days overdue.','invoice','error',0,'2026-08-21 01:30:00'),
('ntf-2','Card blocked','Card ending 1117 was blocked after 3 failed PIN attempts.','card','warning',0,'2026-08-22 02:30:00'),
('ntf-3','New company onboarded','Sunrise Distribution completed onboarding.','company','success',1,'2026-08-23 03:30:00'),
('ntf-4','Payment received','Payment PAY-2026-0001 was received in full.','payment','success',1,'2026-08-24 04:30:00'),
('ntf-5','Licence expiring','Driver Deepak Yadav licence expires in 30 days.','driver','warning',0,'2026-08-25 05:30:00'),
('ntf-6','Fuel price updated','Diesel base price changed to INR 92.10 per litre.','system','info',1,'2026-08-26 06:30:00'),
('ntf-7','Unusual transaction','A transaction exceeded the card daily limit.','transaction','warning',0,'2026-08-27 07:30:00'),
('ntf-8','Vehicle service due','Vehicle MH12AB1049 is due for scheduled service.','vehicle','info',1,'2026-08-28 08:30:00');

-- Audit logs --------------------------------------------------------
INSERT INTO audit_logs (id, logged_at, user_name, action, module, record, ip, description) VALUES
('aud-1','2026-08-21 11:03:00','Aarav Sharma','Login','Auth','admin@fleetservicelink.com','10.0.0.11','User signed in'),
('aud-2','2026-08-22 12:06:00','Aarav Sharma','Create','Companies','com-6','10.0.0.12','Company created: Sunrise Distribution'),
('aud-3','2026-08-23 13:09:00','Neha Kapoor','Status change','Cards','card-9','10.0.0.13','Card status set to blocked'),
('aud-4','2026-08-24 14:12:00','Rohit Bansal','Create','Invoices','inv-8','10.0.0.14','Invoice created'),
('aud-5','2026-08-25 15:15:00','Rohit Bansal','Create','Payments','pay-1','10.0.0.15','Payment recorded for INV-2026-0001'),
('aud-6','2026-08-26 16:18:00','Divya Menon','Update','Pricing','prc-1','10.0.0.16','Pricing rule updated'),
('aud-7','2026-08-27 17:21:00','Aarav Sharma','Update','Users','user-5','10.0.0.17','User updated'),
('aud-8','2026-08-28 18:24:00','Aarav Sharma','Update','Settings','settings','10.0.0.18','Application settings updated'),
('aud-9','2026-08-29 19:27:00','Neha Kapoor','Login','Auth','support@fleetservicelink.com','10.0.0.19','User signed in'),
('aud-10','2026-08-20 10:30:00','Divya Menon','Export','Reports','company-spend','10.0.0.20','Report exported to CSV');

-- Settings ----------------------------------------------------------
INSERT INTO settings (setting_key, setting_value) VALUES
('companyName','NTA ADMIN - Fleet Service Link'),
('email','admin@fleetservicelink.com'),
('phone','+91 22 4000 1000'),
('address','Unit 12, Trade Centre, Bandra Kurla Complex, Mumbai 400051'),
('currency','INR'),
('timezone','Asia/Kolkata'),
('dateFormat','dd/MM/yyyy'),
('sessionTimeoutMinutes','30'),
('passwordMinLength','8'),
('requireStrongPassword','1'),
('notifications.email','1'),
('notifications.invoices','1'),
('notifications.cardAlerts','1'),
('notifications.transactionAlerts','1'),
('notifications.systemAlerts','1');

-- Keep card usage in sync with the seeded transactions ---------------
UPDATE fleet_cards fc SET used_amount = COALESCE((SELECT SUM(t.total) FROM transactions t WHERE t.card_id = fc.id AND t.status = 'completed'), 0);