Gamusi/m-lis

Offline medical laboratory performance tracker and diagnostic reporting system for Ahmadiyya Muslim Hospital, Mbale. # M-LIS **Laboratory Information System** **A high-performance, air-gapped desktop laboratory information system engineered for extreme low-spec hardware.** Overview • The Excel Problem • Features • Architecture • Air-Gapped Deployment • Customization --- ## Overview **M-LIS** is an offline-first laboratory management system built to digitize diagnostic reporting and client test workflows. Designed to comply with standard **HMIS 105 Section 6 Laboratory Surveillance** guidelines, it completely replaces fragile legacy Excel macros with a robust, relational database-backed application. It is specifically engineered to run flawlessly on legacy hospital workstations (Core 2 Duo / 2GB RAM) without requiring an internet connection, complex installations, or heavy browser frameworks. --- ## The Legacy Excel Problem This system was built to directly solve the structural vulnerabilities of the previous macro-heavy `.xlsb` reporting system: | The Legacy Excel Problem | The AMH Tracker Solution | | :--- | :--- | | **Silent Data Loss:** Full delete-and-reinsert macros wiped historical data if a test name was changed. | **Relational Integrity:** Raw SQLite ensures permanent, structured data retention and safe migrations. | | **Formula Corruption:** Technicians accidentally overwrote `SUMIFS` cells with static numbers, freezing reports. | **Immutable Logic:** Calculations happen dynamically on the FastAPI backend; the UI is strictly read-only for reports. | | **Hardcoded Limits:** Trend calculations stopped at row 292; later entries were silently ignored. | **Infinite Scaling:** Dynamic database queries aggregate thousands of records in milliseconds. | | **Zero Accountability:** No audit trail for who entered or altered data. | **Session Tracking:** Every entry, edit, and configuration change is stamped with the authenticated user ID and timestamp. | --- ## Features - **Client Diagnostic Logging:** Track client demographics alongside detailed multi-parameter …