saien0507alfa/CCRMS

Web-based clinic record management system for CCMDD community clinics in South Africa. Built with PHP, MySQL, HTML, CSS on XAMPP. # CCRMS — Community Clinic Record Management System A web-based electronic health record (EHR) system developed to replace paper-based patient file management at CCMDD (Central Chronic Medicines Dispensing and Distribution) community clinics in South Africa. Built as a final-year IT Project (IT Project 700D) for the Bachelor of Science in Information Technology at Richfield Graduate Institute of Technology — awarded **Cum Laude**. --- ## Project Overview Over 2 million South Africans collect chronic medication through community-based CCMDD pick-up points (PuPs). These volunteer-run clinics have historically relied entirely on paper-based record systems, leading to: - Poor patient data security and confidentiality - Lost, duplicated, and illegible patient files - Long patient wait times due to manual file retrieval - No backup or recovery mechanisms for patient records **CCRMS** digitises the full patient management workflow — from registration and medical consultations to chronic medication collection tracking — through a secure, role-based web application backed by a MySQL database. --- ## Tech Stack | Layer | Technology | |-------|------------| | Frontend | HTML5, CSS3 | | Backend | PHP | | Database | MySQL | | Local Server | XAMPP (Apache + MySQL) | | Security | MD5 password hashing, AES-128 log encryption, prepared statements | | Testing | Manual functional, security, UI, and performance testing | --- ## Key Features - **Role-based access control (RBAC)** — Three user privilege levels: Receptionist (Level 1), Medical Staff (Level 2), Administrator (Level 3) - **Patient registration** — Create, search, update, and delete patient records with SA ID number validation (auto-extracts date of birth and gender) - **Medical record management** — Record vital signs (blood pressure, pulse, respiratory rate, blood sugar) and medical notes per visit - **Chronic medication collection tracking** — Track CCMDD medication collection dates with 3-week grace period c …