Short preview

Description:

This desktop app is developed using PYQT5 and SQLITE in Python programming language, the app enables you to insert, filter, edit, and delete your daily appointments and patient data and offers a statistical summary view.

Features:

1. Appointments:

• Add appointments of new patients and either create or not a patient record.

• Add appointments of already existing patients which will auto-fill some fields: some fields in the appointment can't be modified they can only be modified through the patients tab. 

• Delete appointments.

• Update appointments.

• Filter appointments by date.

• Filter appointments by field: Appointment ID, First Name, Last Name, Phone Number, Notes.

• Designated button to list empty time slots for a specific date.

• Status field in green (success) or red (error): empty first name error, empty phone number error, a contradiction in time slots error(if for the same date the "from" and "to" times contradict with already existing ones), "to time" is before "from time" error, appointment added success, appointment updated success.

• 

1. Patients:

• Add patients to the patients' database.

• Delete patients from the patients' database.

• Update/modify patients records.

• List all appointments of a selected patient.

• Add patient information automatically to the appointment form.

• 

1. Statistics and Charts:

• Statistical View (overall summary counts): appointments today, appointments tomorrow, appointments next week, appointments yesterday, total appointments appointments, total patients.

• Advanced Search: display the count of appointments and revenue.

• A bar chart that displays the appointments over time; can be filtered by day, month, or year.

• Line chart to track the revenue over time

•