Problem
Healthcare providers in Colombia must report every step of a non-PBS treatment to the Ministry of Health's Mipres system: routing, scheduling, delivery and billing, plus a parallel urgent-care flow. Doing this by hand against the official SISPRO APIs is slow and error-prone: each operation requires a primary token, a daily token and a JSON payload in the exact shape the government expects. The client needed a tool that centralized the whole flow, prevented rejections from malformed data, and kept an audit trail of every transaction.
Solution
I designed and built a framework-free PHP+MySQL web app with 45 endpoints covering the full cycle: lookup by date or prescription, scheduling, delivery, delivery reporting, cancellations, billing and the urgent-care circuit. I integrated the two official APIs (WSSUMMIPRESNOPBS and WSFACMIPRESNOPBS on wsmipres.sispro.gov.co) over cURL, generating and reusing session tokens. Across 17 tables I persist every response for auditing. I added an AdminLTE backoffice and a printing module with html2pdf + TCPDF for receipts. The app runs entirely in the America/Bogota timezone.
Result
The platform unifies in one interface operations that were previously scattered across the government portal, with local persistence of each transaction and downloadable PDF receipts. It is a real system in production, now legacy and fully modernizable: a solid base to migrate to a framework like Laravel while keeping the already-proven Mipres integration.