RxRefund - Nilsu Bozan; Melis Atagun; Eylul Kadioglu; Buse Tosuner; Ahmet Ezdesir;

Week 1 (1.25.2024)

• Accomplishments:

1. A quick summary of the previous semester was made
2. The upload file, company, and user sections was reviewed
3. The page on Notion was updated, and tasks were assigned

• To-do:

1. Check if the database and code are up-to-date and working on AWS
2. Distribute tasks for the analytics, database and frontend
3. Create an architecture for users, including company admin, pharmacy admin, and super user
4. Upload new TXT files without making any changes

Week 2 (2.1.2024)

• Problems:

1. Archived transactions can not go to the archived_data table. We think that it is because new files contain a new column that we do not have in the archive_data table yet.
2. ec2 instance was unable to connect to the database due to security reasons.

• Accomplishments:

1. A quick summary of the previous semester was made
2. Some of the TX files are tested and they were uploaded successfully.
3. Tasks were assigned.
4. Permissions of the database in ec2 instance changed and then successfuly connected to database.

• To-do:

1. company users, access control, include permissions in menu items.
2. Break archive tables by NPI.
3. Implement tx_search for our current pharmacy (NPI) structure
4. Confirm page for #rows and date range in intersection.
5. Improve date range intersection algorithm