Patient Record Management System

I need some help on implementing the following functionality. Please find the requirement for Admin, Doctor and Patient Role. I have the rest of the code functionality already built. 1. In Admin Role, a) I need to integrate the tax rules as per the current scheme. b) Implement functionality for Medical Records, Prescription, Payments, Low Stock Alerts, Scheduled Jobs 2. In Patient and Doctor Roles, need to work on rescheduling functionality. 3. Login and Sign-Up Page 4. Cross-validate if anything missed from the whole requirement provided below. Here is the complete detail of the entire project: Patient record management system - Web and Mobile 3 user roles are Admin, Patient and Doctor. 1. Patient: a) Patient Home – Patient can view his profile ID, Name, DOB, Gender, Phone, Email, Address , photo b) Current Appointment – Patient can view if he has some pending or approved appointment with a doctor c) Patient Rescheduling: Patients can reschedule their approved appointments directly from the Current Appointment tab. A rescheduling button will be available next to their approved appointment. When the patient clicks on the Reschedule button: 1. The system shows the doctor’s available slots for rescheduling. 2. The patient selects a new time slot and sends a reschedule request. 3. The doctor receives a notification for the reschedule request and can approve/reject it. 4. The patient is notified of the doctor's decision via the Notifications tab. d) Bills History – Patient can view the bill history of appointments that have been completed e) Treatment History – Patient can view the treatment history of appointments which have been completed f) Take Appointment – Patient can view all the departments, and then can select one dept. Then the doctors of that dept are shown. Then patient selects one doctor and the doctor’s profile is then shown along with a ‘take appointment’ button. When the button is clicked, the free slots of that particular doctor are shown. Patient selects a free slot of his choice and then sends request for that free slot to the doctor. The doctor will then approve/reject it. g) Notifications – In this tab, a notification is shown whenever the doctor accepts/rejects the requested appointment. h) Feedback – After an appointment is completed, patient can give feedback about that appointment by rating it from 1 – 5 i) A patient can request for only one appointment at a time and will not be allowed to take more than one appointments until the last appointment has been completed or cancelled. 2. Doctor: a) DoctorProfile: Doctor can see his own profile. Each doctor is assigned a unique identifier, and their profile includes their name, specialization, date of birth, gender, contact information (phone number, email), and address, photo. b) PendingAppointments: Doctor can see all the pending appointments against his doctor ID. c) TodaysAppointments: the appointments for current day will be shown. The doctor then can select/reject any appointment of that day. Once approved by doctor, it should get reflected under patient > current appointment d) Doctor Rescheduling: If a doctor wants to reschedule an approved appointment: a. The doctor selects the appointment from their Today’s Appointments or Pending Appointments tab. b. The doctor initiates the rescheduling process by proposing a new time slot. c. The patient is automatically notified about the proposed reschedule through the Notifications tab. d. The patient can accept/reject the proposed time. If rejected, the appointment remains in its original slot unless further actions are taken by the doctor or patient. If no response is received from the patient within 24 hours (or a defined period), the system can: e. Automatically approve the reschedule. f. Notify both the doctor and the patient of the final schedule. e) HistoryUpdate: He should be able to view earlier prescription,disease so that he can track progress of patient f) Prescription : He can update prescription,disease and progress of patient. Whatever updates here, should be automatically updated in the admin menu > 7. Medical records g) GenerateBill: He will then generate the bill. Whatever updates here, should be automatically updated in the admin menu > 9. Payment h) PatientHistory: Doctor will be able to see the treatment history of all his treated patients. If doctor wants to see the history of a particular patient he should be able to see it. He should also be able to search the history for a last week or last month or last year or years? 3. Administrator: a) Admin Home: • Weekly Appointments: • Display the total number of appointments scheduled and completed for the past week and the current week. • Clinic Income: • Show the clinic's income for the past week, current week, current month, last month, and the past year. • Registered Patients: • Provide a breakdown of patient registrations: o Total number of patients currently registered. o New patient registrations segmented by:  Past week.  Current week.  Current month.  Last month.  Past year. • Registered Doctors: • Show the total number of doctors currently associated with the clinic, categorized by their respective departments. • List of Departments: • Display all active departments in the clinic. • Search Capability: • Enable admin to search for specific stats or records, such as: o Patients by name, registration date, or contact information. o Doctors by name, department, or specialization. b) View Doctors: Admin can view the list of doctors currently registered along with their departments and other information. Complete profile will be shown when clicked. c) View Appointments: The system manages appointments effectively. Each appointment is assigned a unique identifier and includes the patient, doctor, appointment date and time, and appointment status. Appointment statuses include: Pending: The appointment has been scheduled but has not yet occurred. Confirmed: The appointment has been confirmed by both the patient and the healthcare provider. Completed: The appointment has taken place as scheduled. Canceled: The appointment has been canceled either by the patient or thehealthcare provider. Rescheduled: The appointment has been rescheduled for a different date or time. No Show: The patient did not show up for the appointment without canceling or rescheduling. d) Rescheduling Appointments : View logs of rescheduling activities for monitoring purposes. Overrule or manually resolve conflicts between the doctor and patient schedules (if needed). e) View Patients: Admin can view the list of patients currently registered along with their phone numbers and ids. Complete profile will be shown when clicked. f) View Other Staff: Admin can view other staff members along with their designations. g) Search Box: Admin can search for a specific employ within the company by name h) Add/Remove: Admin can Add/remove doctors patients and other staff members form the clinic. i) Medical Records The system maintains comprehensive medical records for patients. Each attended appointment is associated with a medical record. Each medical record is assigned a unique identifier and includes the patient, doctor, description of the visit, diagnosis, prescribed medication, and any additional notes. j) Prescription The system manages prescribed medications efficiently. For each medical record, there can be at most one prescription. Each prescription is assigned a unique identifier and includes the medical record, medication name, dosage, frequency, start date, end date, and any special instructions. k) Payments The system tracks payment information for appointments. Each payment is assigned a unique identifier and includes the patient, payment date, payment method, amount paid, and any additional notes. Payments are associated with individual appointments. l) Low Stock Alerts: Notify doctors and administrators when a medicine stock falls below a predefined threshold. Include details like medicine name, current stock, and reorder urgency. m) Scheduled Jobs: Stock Review Job: Periodically check stock levels (e.g., daily or hourly) and trigger notifications for low stock. Prescription Refill Job: Check prescription refill schedules and notify the respective patient and doctor. n) Under Admin > two Separate Menus - Profit Before Tax > Profit After Tax to be Provided. Profit Before Tax : Capture income and expenses Income section covers monthly income 2,50,000, and Any additional income (investors, interest) Expense section covers admin expenses, utility bills (electricity, water), maintenance, rent, salary employee, depreciation of assets, medicines purchased from vendors. Generate reports for Profit & Loss Statement Report: Displays clinic financial health showing income and expenses. Expense Summary Report: Breaks down operational costs Profit After Tax : Integrate Tax Rules : Create logic for tax saving deductions and applicable rules. Automated Tax Computation: Calculate taxable income, apply deductions, compute tax payable. Generate Reports: Monthly and Yearly Profit After Tax, Deduction & Tax Saving Summary. [login to view URL] [login to view URL]