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.

Week 7

Date: 04/04/2021

Place: Online

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

Accomplishments

- Group members and Jamie had a meeting about the progress we have made and the problems we had this week.
- Group members have worked on a method to take data from the created tables.
- Group members have created regexes for some of the javascript functions we have created.
- Group members have created an algorithm to print out the data we take from the tables.
- Group members have arranged a meeting with Professor Jones and Jamie for the next week.

Problems

- There is still a problem with the load speed of the home page, but the issue might not be solvable as there is too much data in the database making our efficiency close to the best available.
- After discussing with Jamie, it was best to take raw data instead of the ones we were taking from the created tables, making most of our code this week obsolete.

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.

Week 8

Date: 04/11/2021

Place: Online

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

Accomplishments

- Group members and Jamie had a meeting about the progress we have made and the problems we had this week.
- Group members have worked on the savings page and how to send data to newly created 'savings_info' table.
  - Savings page has now the ability to send all the row's raw data into the 'savings_info' table.
  - Savings page has also the ability to send alternative unit cost and savings columns to the 'savings_info' table as well.
- Group members have worked on the worksheet page and how to send data to newly created 'worksheet_info' table.

Problems

- On worksheet page, there were radio buttons on different columns and no correct form structure, we either need to create a single column for them or use a different method to be able to use radio buttons correctly.

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.
- Group members will work on printing the existing data on newly created database tables to the tables on the webpage for entered rx numbers and gcn numbers for worksheet and savings pages respectively.