🏥 STICA Clinic Management System

Important

Project status: Academic prototype - maintenance-only

This repository is retained as a portfolio artifact from a five-person capstone project. I served as the project lead and lead programmer. It is not actively maintained or production-ready, and some workflows may be incomplete, outdated, or defective. Installation and feature behavior are not guaranteed in current environments.

Do not use this software with real patient, student, employee, or medical data. Its security, privacy, backup, data-retention, and regulatory requirements have not been validated.

An academic clinic-management prototype originally built for STI College Alabang to explore student and employee health-visit tracking, consultations, and medical-record workflows.

---

Maintenance status

• No active maintenance, support, or compatibility guarantee.
• Some workflows—including authentication, record management, reports, and imports—have not been recently verified and may not function as intended.
• Dependencies, setup instructions, and environment assumptions may be outdated.
• Security, privacy, access control, backups, and data retention have not been professionally audited.
• Use synthetic test data only. This is not production medical software.

The repository remains useful as a demonstration of PHP MVC structure, SQLite data modeling, interface design, and technical leadership in a student team.

---

✨ Features

👥 Patient Management

• Student Records - Manage student information with ID, name, age, gender, contact, and course/year
• Employee Records - Track employee details including position and contact information
• Emergency Contacts - Dedicated fields for emergency contact name and phone number
• Excel Import - Bulk import students/employees from Excel files
• Multi-Select Delete - Select and delete multiple records at once

🩺 Consultation Tracking

• Real-time Timer - Track consultation duration with live timer
• Vital Signs Recording - Blood pressure, temperature, weight, pulse rate (with color-coded limit alerts)
• Smart Quick-Picks - One-click common diagnoses and treatments (e.g., Hot/Cold Compress, Paracetamol)
• Diagnosis & Treatment - Document reasons, diagnoses, and interventions
• Visit History - Complete history of all clinic visits per patient

📊 Dashboard

• Daily Statistics - Today's visits, active consultations, total patients
• Visual Charts - Weekly visit trends with Chart.js
• Clinic Activity Feed - Real-time activity tracking
• Audit Trails - Track system usage, user logins, and record changes

💊 Medicine Inventory

• Stock Management - Track medicine quantities and units
• Expiration Tracking - Monitor medicine expiration dates
• Quick Updates - Easy stock adjustments

🚀 Quick Actions & Tools

• Consultation Print - One-click print for consultation records (A4 format)
• Instant Search - DataTables-powered search and filtering
• Responsive Design - Works on desktop and mobile devices

---

🛠️ Tech Stack

Layer	Technology
Backend	PHP 7.4+ (Custom MVC Framework)
Database	SQLite (portable, no setup required)
Frontend	HTML5, CSS3, JavaScript
UI Framework	Bootstrap 5.3
Charts	Chart.js
Tables	DataTables
Icons	Font Awesome 6

---

📦 Installation

Prerequisites

• PHP 7.4 or higher
• No additional database server required (uses SQLite)

Local inspection (legacy instructions)

These instructions are retained for code review and may not work in current environments.

1. Clone the repository

   git clone https://github.com/chaaruze/stica-clinic.git
   cd stica-clinic

2. Initialize the database

   php database/migrate.php

3. Start the development server

   # Using the included batch file (Windows)
   start.bat
   
   # Or manually with PHP built-in server
   php -S localhost:8080 router.php

4. Access the application

   http://localhost:8080
   

Alternative: XAMPP/WAMP Setup

1. Move to web server directory

   # For XAMPP
   mv stica-clinic C:/xampp/htdocs/

2. Configure URL root (if needed)

   • Edit app/config/config.php

   define('URLROOT', 'http://localhost/stica-clinic');

3. Access the application

   http://localhost/stica-clinic
   

---

📁 Project Structure

stica-clinic/
├── app/
│   ├── config/          # Configuration files
│   ├── controllers/     # MVC Controllers (10 controllers)
│   │   ├── Dashboard.php
│   │   ├── Employees.php
│   │   ├── Home.php     # Authentication
│   │   ├── Logs.php
│   │   ├── Maintenance.php
│   │   ├── Medicines.php
│   │   ├── Students.php
│   │   ├── System.php
│   │   ├── Users.php
│   │   └── Visits.php
│   ├── core/            # Core framework classes
│   │   ├── App.php      # URL Router
│   │   ├── Controller.php
│   │   └── Database.php # PDO wrapper
│   ├── helpers/         # Helper functions
│   ├── libraries/       # PHPMailer for emails
│   ├── models/          # Database models (6 models)
│   └── views/           # View templates (12 directories)
├── public/
│   ├── index.php        # Entry point
│   └── assets/          # CSS, JS, Images
├── database/
│   ├── clinic.sqlite    # SQLite database
│   └── migrate.php      # Schema migration
└── router.php           # PHP dev server router

---

🗄️ Database Schema

Table	Description
nurses	Staff/admin login credentials
student_details	Student information (ID, name, contact, course)
employee_details	Employee information (ID, name, contact, position)
student_history	Student clinic visit records with vitals
employee_history	Employee clinic visit records with vitals
medicines	Medicine inventory (name, stock, expiration)
activity_logs	Audit trail of all user actions
login_logs	Login history tracking
remember_tokens	Persistent login tokens

---

🎨 Screenshots

---

👨‍💻 Author

John Charles Omagap

Project lead and lead programmer in a five-person capstone team.

• GitHub: @chaaruze

---

📄 License

No license file is currently provided. The repository is retained for portfolio reference.

---

Academic capstone prototype retained for reference.