Web Clinic Calendar & Reporting System

Hello All

I am looking for who can help me to complete the funtions, db for a simple schedule calendar and record appointments, for save info about pantiens

[Demo Interface Link](https://s3.amazonaws.com/capshn1.0/index.html)

#### 1. User Authentication
- Implement email and password authentication.
[Login Interface Link](https://s3.amazonaws.com/capshn1.0/login.html)

#### 2. User Roles and Permissions
- **Admin**: Can delete data.
- **Admin and Professional**: Can create and edit users with roles "Agent" and "Professional", but cannot delete appointments or users.
- **Agent**: Can create and edit patients, add and edit appointments, but cannot create or edit users or disable appointments or users. Can only edit their own password.
- Adding an Agent requires: First Name, Last Name, ID number, and Email Address.
- Email and ID number should not be editable when editing a user.
- Active users should be able to change their passwords.
[Add Agent Interface Link](https://s3.amazonaws.com/capshn1.0/add-agent.html)

#### 3. Patient Management
- Filter patients by different fields.
- Display age, referral (if applicable), appointments, and appointment history in patient profiles.
[Patients Interface Link](https://s3.amazonaws.com/capshn1.0/patients.html)

#### 4. Appointments Management
- Display appointments in a calendar.
[Calendar Interface Link](https://s3.amazonaws.com/capshn1.0/calendar.html)
- Maintain a list and record of patients, displaying age automatically.
- Required fields for creating a patient: First Name, Last Name, ID Number (format: XXXX-XXXX-XXXXX, X=0-9).
- Display Guardianship section for patients over 21.
- Display "Student Info" section for patients in the "UNAH-VS" program.
[Add Patient Interface Link](https://s3.amazonaws.com/capshn1.0/add-patient.html)
- Maintain a record of past and future appointments.
- Add filters for searching appointments easily.
- Allow users to customize the appointments list (hide/show columns, filter values).
[Appointments Interface Link](https://s3.amazonaws.com/capshn1.0/appointments.html)
- Schedule new appointments with auto-generated ID (format: CAPS.SAP-A0001 to Z9999).
- Require at least one patient to be added before creating an appointment (searchable by name or ID number).
- Each appointment should have a scheduled date and patient.
[Add Appointment Interface Link](https://s3.amazonaws.com/capshn1.0/add-appointment.html)

#### 5. Reporting
- Generate reports in xlsx or csv format about the patients.
[Reports Interface Link](https://s3.amazonaws.com/capshn1.0/patients-reports.html)
- Allow editing of appointments to set new patient data for diagnosis and referral if applicable.
[Edit Appointment Interface Link](https://s3.amazonaws.com/capshn1.0/edit-appointment.html)

#### 6. UI Sections
- **Calendar Section**: Users can see scheduled appointments, create new appointments, and create new users.
- **Agents Section**: Users can see, add, and edit Agents.
- **Patients Section**: Users can list, add, edit, and search Patients.

Please review these tasks and prioritize accordingly. If there are any questions or clarifications needed, feel free to ask. Thank you!