RxRefund - Furkan Enes Celtik; Kerem Gurses; Umut Baris Basol; Mustafa Ikbal Mehmedoglu

Week 1

Title: Briefing

Date: 02/21/2021

Place: Online

Attendance: Merwyn Jones, Furkan Enes Celtik, Kerem Gurses, Umut Baris Basol, Mustafa Ikbal Mehmedoglu

Accomplishments

- Group members and Professor Jones had a briefing about the upcoming weeks and the process of filling CPT forms.
- Group members have learned about the CPT forms and filled the required parts, then sent the files to Professor Jones.
- Group members have arranged a meeting with Jamie Williams for the next week.
- Group members have filled the last two months of 2020 for all different pages which were missing before.

Problems

- We were using a function to assign the current year to a variable but since the year has changed to 2021 and the data we had was of 2020, therefore, we manually assigned it to 2020.

To do

- Group members will arrange a meeting with Jamie Williams and discuss this semester's work on the project.
- Group members will check the previous work done to see everything still works as intended.

Week 2

Title: Meeting, Implementation

Date: 02/28/2021

Place: Online

Attendance: Merwyn Jones, Jamie Williams, Furkan Enes Celtik, Kerem Gurses, Umut Baris Basol, Mustafa Ikbal Mehmedoglu

Accomplishments

- Group members, Professor Jones and Jamie had a meeting about the upcoming weeks and the next stages of the project.
- Group members have made small fixes to various pages, aligning tables, texts, changing font sizes, and adding '$' and '%' signs wherever they are required.
- Group members have created a third table on pages; 'all', 'ltc', and 'retail' to include 2021's mintx data.
- Group members have filled the first two months of 2021 with the provided mintx files and the rest was populated with example numbers.
- Group members have created another step on the savings page that allows the user to search RX by NDC specified number.
- Group members have arranged a meeting with Professor Jones and Jamie for the next week.

Problems

- Group members were not able to create hyperlink connections in the savings page forwarding the user to specified GCN, the problem still continues.

To do

- Group members will arrange a meeting with Jamie Williams.
- Group members will search for a solution on how to implement hyperlink forwarding on the savings page.

Week 3

Title: Meeting, Implementation

Date: 03/08/2021

Place: Online

Attendance: Merwyn Jones, Jamie Williams, Furkan Enes Celtik, Kerem Gurses, Umut Baris Basol, Mustafa Ikbal Mehmedoglu

Accomplishments

- Group members, Professor Jones and Jamie had a meeting about the upcoming weeks and the next stages of the project.
- Group members searched for a solution hyperlink forwarding on the Savings page.
- Group members have made additional small fixes to various pages.
- Group members have made some code simplifications to their programming environment.
- Group members have created necessary tables on the Home and Savings Page.
- Group members have arranged a meeting with Professor Jones and Jamie for the next week.

Problems

- We have not still implemented hyperlink connections in the Savings page on desired numbers like GCN, NDC.
- Margin calculation on the savings page is completely wrong.
- Because of rounding errors, savings with alternative unit cost is calculated incorrectly.

To do

- Group members will arrange a meeting with Jamie Williams.
- Group members will search for a solution on how to implement hyperlink forwarding on the savings page.
- Group members will do pagination on desired pages.
- Group members will look for a solution to the loading speed of the Home page.
- Group members will handle rounding numbers.

Week 4

Title: Meeting, Implementation

Date: 03/14/2021

Place: Online

Attendance: Merwyn Jones, Furkan Enes Celtik, Kerem Gurses, Umut Baris Basol, Mustafa Ikbal Mehmedoglu

Accomplishments

- Group members and Professor Jones had a meeting about the upcoming weeks and the next stages of the project.
- Group members searched for a solution and implemented hyperlink forwarding on the Savings page.
- Details about hyperlink creation;
   - We take GCN and NDC numbers in front of the "form" attribute and "input" attribute.
   - We take GCN and NDC numbers as a type of "submit" and their month and year info as a type of "hidden".
   - We use them in "isset" function with the POST method. 
   - For example, in each of the GCN and NDC tables, there are three constraints for ..._number, month, year.
- Group members implemented pagination on the Savings page with limited usability.
- Group members have fixed the rounding problems on the Savings page.
- Group members have implemented CSS to the web page.
- Group members have arranged a meeting with Professor Jones and Jamie for the next week.

Problems

- Pagination is not working properly and it does not show tables after clicking desired pages.
- Home page reload is still slow.
- Because of working with a template php (gcn.php) for hyperlink issue, some buttons do not work properly.
- Tables will be aligned. 
- Pagination will be fixed.

To do

- Group members will arrange a meeting with Professor Jones and Jamie Williams.
- Group members will work on fixing the existing problems that are mentioned above and in the previous weeks.

Week 5

Title: Meeting, Implementation

Date: 03/21/2021

Place: Online

Attendance: Merwyn Jones, Furkan Enes Celtik, Kerem Gurses, Umut Baris Basol, Mustafa Ikbal Mehmedoglu

Accomplishments

- Group members and Professor Jones had a meeting about the upcoming weeks and the next stages of the project.
- Group members have been still searching for a solution to the speed of the Home page.
- Group members fixed the problems of pagination on the Savings page.
- Group members fixed the buttons and their links problem.
- Group members fixed the margin problem.
- Group members have arranged a meeting with Professor Jones and Jamie for the next week.

Problems

- There is still a problem with the reload speed, group members are looking for a solution to make the Home page faster.

To do

- Group members will arrange a meeting with Professor Jones and Jamie Williams.
- Group members will create two tables: one for Worksheet, one for Savings.
- In these pages, after hitting the Save button, the info that the user enters will be saved into these tables.
- If there is prior info in these tables, they will also be shown on the web page.

Week 6

Title: Meeting, Implementation

Date: 03/28/2021

Place: Online

Attendance: Merwyn Jones, Jamie Williams, Furkan Enes Celtik, Kerem Gurses, Umut Baris Basol, Mustafa Ikbal Mehmedoglu

Accomplishments

- Group members and Professor Jones had a meeting about the upcoming weeks and the next stages of the project.
- Group members have been still searching for a solution to the speed of the Home page.
- Since the SQL is used with Jupyter Notebook, we could not find a solution like the "INDEX" statement on MySQL.
- Group members created two tables: one for Worksheet, one for Savings.
- Group members added "Save" buttons on these pages. 
- Group members have arranged a meeting with Professor Jones and Jamie for the next week.

Problems

- There is still a problem with the reload speed.
- Since group members are not close to Ajax or JavaScript, we could not implement dynamic parts.

To do

- Group members will arrange a meeting with Professor Jones and Jamie Williams.
- Group members will continue to work on the Worksheet and Savings page.