-- MMC Financial Dashboard - Seed Data (Demo)

-- Demo agencies
INSERT OR IGNORE INTO agencies (name, contact, notes) VALUES
  ('MedSupply Co', '9876543210', 'Main pharmacy supplier'),
  ('LabEquip India', '9876543211', 'Lab equipment and consumables'),
  ('CleanCare Services', '9876543212', 'Housekeeping & laundry');

-- Demo daily entries (last 7 days)
INSERT OR IGNORE INTO daily_entries (entry_date, reception_cash, pharmacy_cash, lab_cash, upi_bank, total_expenses, agency_bills, notes) VALUES
  (date('now', '-6 days'), 12500, 8200, 4300, 6100, 3200, 1500, 'Normal day'),
  (date('now', '-5 days'), 15000, 9100, 5200, 7800, 4100, 0, 'High footfall'),
  (date('now', '-4 days'), 11200, 7600, 3800, 5400, 2900, 2000, ''),
  (date('now', '-3 days'), 13800, 8900, 4700, 6900, 3700, 0, 'Pharmacy restock'),
  (date('now', '-2 days'), 16200, 10100, 5900, 8300, 4800, 3000, 'Good collections'),
  (date('now', '-1 days'), 14500, 9300, 5100, 7200, 3500, 1800, ''),
  (date('now'), 13000, 8700, 4600, 6500, 3100, 0, 'Entered today');

-- Demo agency bills
INSERT OR IGNORE INTO agency_bills (agency_id, bill_date, amount, description) VALUES
  (1, date('now', '-6 days'), 1500, 'Pharmacy consumables'),
  (2, date('now', '-4 days'), 2000, 'Lab reagents'),
  (1, date('now', '-2 days'), 3000, 'Monthly medicines'),
  (3, date('now', '-1 days'), 1800, 'Cleaning supplies');

-- Demo outflows
INSERT OR IGNORE INTO outflows (category_id, outflow_date, amount, notes) VALUES
  (1, date('now', '-5 days'), 45000, 'Staff salaries - March'),
  (2, date('now', '-4 days'), 8500, 'AC maintenance'),
  (3, date('now', '-3 days'), 12000, 'EB bill - March'),
  (8, date('now', '-2 days'), 25000, 'Monthly rent'),
  (4, date('now', '-1 days'), 15000, 'Home expenses'),
  (9, date('now'), 3500, 'Maid salary');
