PawsitiveCare: Pet Management System
A comprehensive management platform for veterinary clinics to digitize pet records, track appointment lifecycles, and automate client communication.
Project Overview
- Lead Developer Renielyn Lenon
- Architecture Independent Refactor
- Type Web Platform
-
Original PHP Foundation
Developed in collaboration with:
Daniecy Calica
Eric Ebuna
Lyeanne Gadiano
Krissha Monte
Tech Stack
Key Features
- Pet Profile Management
- Appointment Lifecycle
- Role-Based Access Control
- Medical History PDFs
- Email & Dashboard Notifications
- Real-Time Status Tracking
- Pet Birthday Countdowns
- Inquiry Management
System Objectives
PawsitiveCare was designed to replace manual paperwork with a secure digital ecosystem, built around three core objectives:
Secure Digital Management
Maintain accurate pet identification, medical histories, and vaccination records with robust security measures.
Operational Efficiency
Enhance coordination between clients and veterinary staff through efficient appointment scheduling and clinic operations.
Clinic Productivity
Improve overall productivity through organized workflows, system scalability, and data-driven decision-making.
Public Landing Page
- Mobile-Optimized Design: The landing page is fully responsive and includes dedicated sections for About Us, Services, Contact, and Login.
- Interactive Inquiry System: Features a custom UI script to manage submission states, toggling button text to 'Sending' and triggering success alerts.
- Omnichannel Notifications: Administrators and staff receive inquiries via official admin email and the dashboard message center for effective communication.
- Secure Contact Access: To maintain data quality, the contact form is restricted to users whose email addresses are already registered in the system.
Authentication System
Secure authentication with role-based access control ensures proper data segregation between Administrators, Staff, and Clients.
- User Experience: The login interface features a 'Remember Me' option and a password visibility toggle for enhanced usability.
- Secure Recovery: The system sends password reset links exclusively to registered email addresses, confirmed by real-time success UI alerts.
- Automated Identification: Generates species-specific IDs during registration (e.g., 2026-D001 for dogs and 2026-C001 for cats).
- Welcome Notifications: Triggers an automated welcome email to newly registered pet owners upon successful enrollment in the system.
Administrator Portal
User Management
Appointment Management
Clients & Pets Database
- Analytics Dashboard: Localized Manila-time greetings with Chart.js integration for real-time appointment trend visualization.
- User Control: Full authority to view, deactivate, or delete user accounts with advanced filtering for efficient sorting.
- Smart Scheduling: Two-step appointment flow that auto-syncs owner data via Custom Pet ID for streamlined booking.
- Centralized Records: Comprehensive pet database with automated archiving of completed visits into medical histories.
- Message Center: Integrated inbox to manage site inquiries with synchronized email alerts for new submissions.
- Profile Personalization: Self-service settings for administrators to update profile photos and account credentials.
Staff Portal
- Appointment Management: Full access to schedule and manage the appointment lifecycle via the calendar.
- Pet Database: Authority to register new clients and pets and maintain accurate patient records.
- Inquiry Center: Access to the dashboard message center to view and process client inquiries.
- Email Integration: Automated system triggers for appointment confirmations and status notifications.
- Operational Access: Strategic role-based access that excludes system settings and user management.
- Data Integrity: Permissions limited to adding and editing; record deletion is restricted to Admin only.
Client Portal
Pet Management
Appointment Management
- Mobile-Optimized: Fully responsive interface for seamless use on any device.
- Pet Profile Sidebar: Quick-switch navigation to view individual details for multiple pets.
- Real-Time Alerts: Notification system for upcoming appointments and clinic updates.
- PDF Exports: One-click downloads for medical records and appointment histories.
- Health Monitoring: Dynamic "Medical Status" cards to track ongoing pet wellness.
- Engagement: Interactive birthday countdowns for a personalized user experience.
- Secure Controls: Independent pet registration with restricted deletion to ensure data integrity.
Email Notification System
- Onboarding: Newly registered pet owners receive an automated email notification confirming their successful enrollment in the system.
- Scheduling: Pet owners are notified of scheduled appointments via email and through real-time updates on their client dashboard.
- Finalization: Upon appointment completion, owners receive an email confirmation and the record is automatically added to their history for PDF download.
- Staff Alerts: Administrators and staff receive inquiries through official admin email and the dashboard message center to ensure effective communication.
- Reliable Delivery: The system utilizes Gmail SMTP to maintain high deliverability for all branded, professional communications.
- Automated Lifecycle: Keeps all stakeholders informed throughout the entire appointment process without manual intervention.
Core Features Breakdown
Pet & Owner Management
Clients can register multiple pets with individual profiles including photo uploads, breed information, weight tracking, and birthdate records.
Appointment Lifecycle
Complete scheduling workflow with six status types:
Medical Records Management
Staff can manage medical treatments and surgeries including pre- and post-treatment notes, prescription tracking, and follow-up schedules.
Automated PDF Generation
System automatically generates downloadable PDF pet details and medical histories.
Dual Notification System
Real-time dashboard bell alerts for internal updates combined with branded email notifications for external client communication.
Database Architecture
| Table | Description |
|---|---|
| users | Stores credentials, profile paths, and roles (Admin, Staff, Client) |
| pets | Stores pet profiles, photos, and links to owners via owner_id |
| appointments | Tracks scheduling data, services requested, and status updates |
| messages | Stores public inquiries from the contact form |
| notifications | Logs real-time dashboard alerts for users |
Current Limitations & Future Development
Current Limitations
- Specialized for cats and dogs only
- No inventory tracking for medicines or supplies
- Internal-only appointment booking (clients cannot book online yet)
Planned Features
- Client-facing online appointment booking
- Pet lodging management system
- Automated payment processing integration
Project Impact
PawsitiveCare successfully digitizes traditional veterinary workflows by replacing manual paperwork with a secure, role-based ecosystem. The platform optimizes clinic productivity through automated appointment scheduling, synchronized client communications, and real-time medical record tracking. By implementing strict data integrity protocols across administrator, staff, and client portals, the system ensures high standards of privacy while delivering a modern, mobile-responsive user experience.