| Foundations | Schema: properties, units, occupants, assets, services, work_orders, visitors, meters, readings, events | Built | db.init() on an empty file creates exactly those 10 tables plus schema_version; running it twice is a no-op (row counts unchanged) |
| Foundations | Synthetic seed: a Hyderabad facility firm's four properties | Built | seeded DB holds 4 properties of 4 different types, >=130 units, >=100 occupants, >=30 assets, >=60 work orders covering every status and priority, >=12 weeks of readings on >=10 meters and >=20 visitors; reseeding an empty DB gives the same counts |
| Foundations | App shell: FastAPI boot, /healthz, base layout with design tokens | Built | curl /healthz returns 200 JSON with ok=true, db path, property/unit/work-order counts and ai provider; the signed-in dashboard returns 200 HTML with the nav |
| Foundations | Test harness | Built | pytest -q runs >=1 test against a temp DB via TestClient and passes |
| Portfolio | Property list with health tiles (occupancy, open work, overdue service, SLA breaches) | Built | GET /properties shows one card per seeded property; each card's occupancy % equals occupied/total units from SQL and its open-work count equals the SQL count of unclosed work orders |
| Portfolio | Property detail: floor-by-floor unit grid coloured by status, systems, open work, meters | Built | GET /properties/{id} renders one cell per unit grouped by floor (headless: cell count == SQL unit count, 0 console errors) plus the property's assets and its open work orders |
| Portfolio | Units and occupants: move-in, move-out, lease dates, vacancy derived from occupants | Built | POST a move-in on a vacant unit makes it occupied and writes an 'occupant.moved_in' event; a second move-in on the same unit returns 409; move-out makes it vacant again; unit status is never stored, only derived |
| Portfolio | Occupant directory with search and lease-expiry filter | Built | GET /occupants?q=<fragment> lists only matches; ?expiring=60 lists exactly the occupants whose lease ends within 60 days of today (SQL check) |
| Portfolio | Property create/edit with unit generator (floors x units per floor) | Built | POST /properties with floors=3 and per_floor=4 creates the property and 12 units numbered 101…304; a missing name returns 422 with the field message |
| Work orders | Work-order register with property, status, priority, category and technician filters | Built | GET /work?status=open&priority=critical returns only rows matching both; headless: one row per matching seeded work order with 0 console errors |
| Work orders | Create work order (property, unit, asset, category, priority) with sequential WO numbers | Built | POST /work creates WO-<year>-NNNN one higher than the last and an event; a unit from another property is refused with 422 |
| Work orders | Lifecycle: open → assigned → in progress ⇄ on hold → resolved → closed; reopen guarded | Built | tests/test_lifecycle.py walks every legal edge and asserts 409 on open→closed, closed→in_progress and resolved→assigned; resolving stamps resolved_at and needs a resolution note |
| Work orders | SLA clock computed at read time from priority (critical 4 h, high 24 h, medium 72 h, low 7 d) | Built | tests/test_sla.py freezes 'now' and asserts due time, time left and breached flag for one work order per priority, including one resolved late (breached stays true) and one on hold |
| Work orders | Technician board: each technician's open work, oldest first, with breach count | Built | GET /board lists every technician with a count equal to SQL open work orders assigned to them; unassigned work appears in its own column |
| Assets | Asset register per property: lifts, DG sets, pumps, STP, fire systems, HVAC, transformers | Built | GET /assets?property=<id> lists only that property's assets; ?kind=lift lists only lifts |
| Assets | Preventive schedule derived from last service + interval: overdue / due in 7 days / later | Built | GET /maintenance groups every asset into overdue, due this week and later with counts equal to a SQL recomputation for today's date |
| Assets | Record a service: log row, next due date moves, asset status can change | Built | POST /assets/{id}/service with a date and note writes a services row and an event; the asset's next due date becomes that date + interval; a future date is refused with 422 |
| Assets | AMC (annual maintenance contract) tracking with expiry flags | Built | assets whose AMC ends within 30 days show an 'AMC expiring' flag on the asset page and in the dashboard flags; the seeded DB has >=1 such asset |
| Assets | Asset breakdown raises a work order linked to the asset | Built | POST /assets/{id}/breakdown marks the asset out of service and creates a high-priority work order whose asset_id is that asset; resolving the work order offers to return the asset to service |
| Residents & gate | Public request page per property (QR poster link) with no login | Built | GET /r/<property token> returns 200 without a session; POST with flat and message creates a work order with source=resident, category and priority set by triage, and redirects to a tracking link; a bad token is 404 |
| Residents & gate | Resident tracking page shows status and time line, never other residents' data | Built | GET /t/<signed token> shows only that work order's status history; a tampered token returns 404 |
| Residents & gate | Printable QR poster for each property's request link | Built | GET /properties/{id}/poster returns 200 HTML containing an inline SVG QR code that decodes to that property's request URL (checked by a QR decoder in the test) |
| Residents & gate | Gate register: visitor in / out, purpose, unit visited, on-premises list, overstay flag | Built | POST /gate logs a visitor in and an event; POST /gate/{id}/out stamps exit; GET /gate lists on-premises visitors only; a visitor in for >8 h carries the overstay class |
| Utilities & dashboard | Meter readings entry: electricity (kWh), DG diesel (litres), water (kL); consumption derived | Built | POST a reading lower than the previous one on the same meter returns 422 ('meter went backwards'); a valid reading appears and weekly consumption equals the difference of successive readings |
| Utilities & dashboard | 12-week utility trends per property plus energy intensity (kWh per 1,000 sq ft) | Built | GET /utilities renders 12 bars per meter kind (headless: bar count check) and an intensity figure equal to hand-computed kWh / area * 1000 for one property in a test |
| Utilities & dashboard | Dashboard: occupancy, open work, SLA breaches, overdue service, today's visitors, flags | Built | a test asserts each dashboard tile equals its SQL definition on the seeded DB; headless: 0 console errors |
| Utilities & dashboard | Attention flags: SLA breaches, overdue service, AMC expiring, leases expiring, diesel spike | Built | the seeded DB raises >=3 flag kinds; each flag links to the record it names and the link returns 200 |
| Utilities & dashboard | Activity log and CSV exports (work orders, occupants, assets, readings) | Built | GET /export/work.csv has work-order count + 1 rows with an SLA-breached column; /activity lists events newest first and filters by kind |
| Assistant | Provider layer: Anthropic → OpenRouter → heuristic; never raises; badge in /healthz | Built | with no keys set /healthz ai=heuristic; a test monkeypatches a failing provider and the assistant still answers with provider='heuristic' |
| Assistant | Complaint triage: a resident's WhatsApp-style message → category, priority, flat, asset, title | Built | tests/test_triage.py runs >=12 labelled messages (English and Hinglish) through the heuristic; category accuracy >=10/12, every 'lift stuck' / 'fire' / 'gas smell' message is critical; LLM output is validated against the same schema and rejected on mismatch |
| Assistant | Today's plan: ranked next actions across the portfolio with the reason for each | Built | GET /copilot/plan returns >=5 actions on the seeded DB, ordered by score, each naming a record id that exists; every SLA breach on the seeded DB appears before any routine service item |
| Assistant | Property brief: one paragraph with the numbers and one recommended action | Built | the brief for a seeded property mentions its occupancy %, open work count, breach count and overdue service count exactly as the property page shows them |
| Assistant | Assistant drawer on every page with an honest provider badge; triage prefills the form | Built | headless: drawer hidden at rest, opens, badge text matches /healthz ai, sample triage fills category and priority on /work/new and closes the drawer |
| Accounts | Roles manager / helpdesk / technician with signed-cookie sessions | Built | signed-out GET /desk redirects to /login; each seeded login signs in; a technician POST /properties returns 403 and a helpdesk POST /work returns 303 |
| Accounts | Shared OC Apps guest login (guest-YYMMDD-xxxx, HMAC password, 2 days) | Built | a test derives a guest password with SESSION_SECRET, signs in and gets the manager role; a 4-day-old guest name is refused |
| Accounts | Users page: invite link, role change, deactivate (manager only) | Built | a manager creates an invite, signing up with it yields that role; a helpdesk GET /users returns 403 |
| Ship | JSON API v1 with feed token (properties, work orders, readings) | Built | GET /api/v1/work without token returns 401 JSON; with ?token=<FEED_TOKEN> returns 200 with count equal to the work-order table |
| Ship | Local lane under pm2 on :8381, survives restart | Built | pm2 shows 'keystone' online; curl 127.0.0.1:8381/healthz ok=true after pm2 restart keystone; pm2 save done |
| Ship | Headless walk of every page: 0 console errors, 0 failed requests, both themes | Built | tools/walk.py exits 0 against :8381 and prints every check as ok |
| Ship | Hosted twin on Vercel behind the shared OC Apps gate | Built | keystone.ajaykongala.online/healthz returns ok=true; /desk without the oc_access cookie redirects to /demo; with the PIN and a shared guest login the dashboard renders (walk against the twin exits 0) |
| Ship | Betadoc LONG: story, architecture, honest matrix generated from this tracker, documentation page | Built | GET / and /documentation.html on the twin return 200; the matrix block equals tools/matrix.py output for the current tasks.db; walk of both pages in light and dark has 0 console errors |
| Ship | OC Apps card: apps.json entry, mark, /keystone/ rewrite, measured memory, deploy | Built | tools/check_apps.py says schema ok; build_site.py renders a Keystone card; oc-apps.ajaykongala.online/keystone/ returns the betadoc |
| Ship | Register: port registry rows, HOME.md line, mirror repo ajay-453/keystone | Built | port_registry.py list shows 8381 and 6802; tools/mirror_repos.sh keystone pushes and prints the commit count |
| Beyond v1 | Live sensor ingest (BACnet / Modbus gateway) replacing hand-entered readings | Roadmap | a gateway process posts readings every 15 min from a real or simulated BMS (building management system) for 24 h and /utilities shows them with no manual entry |
| Beyond v1 | HVAC and lighting set-point advice from occupancy and weather | Roadmap | for a week of real readings the advice predicts next-day kWh within 15% and names one set-point change per property |
| Beyond v1 | Maintenance dues billing and UPI collection for residents | Roadmap | a resident receives a monthly dues bill, pays by UPI in a sandbox, and the ledger shows paid with the reference |
| Beyond v1 | ESG report per property (energy, water, diesel per sq ft, year on year) | Roadmap | GET /properties/{id}/esg renders a one-page report whose figures match the readings table for the chosen year |