The Admin Web Panel is the central management hub for the Dental Clinic Online Appointment Scheduling System with SMS Notifications. Built as a comprehensive tool for a solo practitioner and their team, it streamlines patient flow, automates schedule management, and maintains detailed clinical records with a focus on security and ease of use.
- Real-time Analytics: Summary cards displaying appointment counts by status (Pending, Rescheduled, Approved, No Show).
- Data Visualization:
- Monthly bar graphs tracking appointment outcomes (Completed, Declined, Cancelled).
- Patient acquisition charts showing new mobile app registrations per month.
- Calendar View: Visual representation of daily appointment density.
- Dynamic Blocking: Ability to block specific dates or time slots for emergencies or clinic maintenance, automatically preventing new bookings during those periods.
The heart of the application, allowing for granular control over the patient lifecycle:
- Status Workflow: Manage appointments through a structured pipeline (Pending → Approved/Declined/Rescheduled).
- Intelligent Actions:
- Approved: Access to "Completed" or "No Show" status updates.
- Rescheduled: Integrated patient response tracking (Accept/Decline).
- Archiving: Soft-delete functionality for Declined or resolved appointments.
- Centralized Archives: Secure storage for all soft-deleted records (Cancelled, Declined, No Show).
- Professional Reporting: Comprehensive tables of finished appointments with a one-click PDF Export feature for physical documentation and audits.
- CRM Functionality: Full patient profiles including contact info and visit history.
- Automated "No Show" Ban: The system automatically imposes a 30-day ban on patients with two "No Show" records. Admins retain the authority to manually unban users.
- Transparency: A dedicated audit trail for all outgoing SMS alerts, including message content, recipient details, and the specific admin/staff member who triggered the notification.
- Access Control: The primary Admin (Dentist) can create, manage, and toggle the status (Active/Inactive) of staff accounts to maintain system security as the team changes.
-
To eliminate the high monthly costs of traditional SMS providers, this system utilizes TextBee to bridge the web panel with a local Android SMS gateway.
-
Implementation: The PHP backend communicates with the TextBee REST API to send outbound messages through a dedicated clinic smartphone.
-
Management Logs: A dedicated "SMS Notifications" page provides a full audit trail of every message sent, including the recipient, status, and which admin/staff member processed the action.
-
Cost-Efficiency: Utilizes local SIM card SMS plans, providing a high-speed notification system at a fraction of the cost of standard gateways.
- Tech Stack: PHP (Backend), MySQL (Database), HTML/CSS/JavaScript (Frontend).
- API Integration: TextBee REST API for SMS Gateway
- Data Management: All tables feature Live Search, Multi-column Filtering, Sorting, and Pagination.
- Safety First: Confirmation modals are implemented across all modules to prevent accidental data changes or deletions.
- Security: Integrated CAPTCHA and a single-OTP verification system for secure access.
Developed by Villaluna, Zuriel Anthony L.