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 the 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.
  - Savings page can also update any existing rows if entered row has its GCN in the 'savings_info' table.
- Group members have worked on the worksheet page and how to send data to the newly created 'worksheet_info' table.

Problems

- On the 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.

Week 9

Date: 04/18/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 put all three radio buttons to a single column on the worksheet page to properly create a form view, therefore solved the last week's problem.
- Group members have completed the insertion and update of the data put into worksheet and savings pages.
- Group members have completed the printing of existing data from 'worksheet_info' and 'savings_info' pages to webpage tables.

Problems

- On the worksheet page, the radio buttons don't show the current status.
- On both worksheet and savings pages if the page is not filtered again using the 'Filter' button, the newly added information is not printed to the table.

To do

- Group members will arrange a meeting with Professor Jones and Jamie Williams.
- Group members will work on solving the radio button issue, either by putting a new column or pre-checking the radio boxes on the worksheet page.
- Group members will work on the new data not being updated on the webpage tables on both worksheet and savings pages.
- Group members will change the update on the GitHub page in order to create documentation of the whole webpage.

Week 10

Date: 04/25/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 solved the radio button issue on the worksheet page by adding a new 'current status' column.
- Group members have updated the readme on the GitHub page, describing each page in detail.
   - Readme also has a tutorial on how to run the operation, starting from XAMPP to viewing web pages.

Problems

- On both worksheet and savings pages if the page is not filtered again using the 'Filter' button, the newly added information is not printed to the table.
- Since some tables were created in MySQL workbench, the exact files of these tables were not on the local folders, group members will have to find another way to upload tables to GitHub.

To do

- Group members will arrange a meeting with Professor Jones and Jamie Williams.
- Group members will work on creating a new page named 'search', this page will be able to group drugs by gcn number.
   - Search page will let the user select a starting and ending date and return results from the selected time window.
- Group members will change the update on the GitHub page adding further technical detail to the documentation.
- Group members will upload the database table to GitHub as well.

Week 11

Date: 05/02/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 created a new page named 'search', this page is able to filter drugs by gcn number.
  - For now, the search page retrieves the data from the database and splits it into years.
  - It groups all the data according to their gcn numbers and lists the data to web page table.
- Group members changed the update on the GitHub page adding further technical detail to the documentation.
- Group members uploaded the database table to GitHub as well.

Problems

- The search page does not have an interval filter working correctly instead it searches for a year only.
- Refresh and slowness problems are still present on the web page.

To do

- Group members will arrange a meeting with Professor Jones and Jamie Williams.
- Group members will work on the slowness of the home page; also, the months that have no mintx files will have N/A on the table instead of placeholders.
- Group members will work on the refresh problem on both worksheet and savings pages.
- Group members will continue to work on the search page.

Week 12

Date: 05/09/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 tried to make all the calculations on PHP that were previously done on SQL but this did not change the slowness of the home page.
- Group members have merged all.php, retail.php, and ltc.php on a new page called home.php, now a user opens the home page and selects which table they want to see.
- Group members have created a new way to print N/A to the table if no mintx file for a specific date has not been found.
- Group members have created to search textboxes to search for names and GCNs on the search page, these searches are made dynamically and show up instantly.
- Group members have solved the refresh issue on both the worksheet and the savings pages, these pages now instantly load the placeholder information.

Problems

- GCN search on search page does not work currently due to GCN number being inside buttons.
- Search page's filter does not work as intended but search for a month only.

To do

- Group members will arrange a meeting with Professor Jones and Jamie Williams.
- Group members will work on fixing the search pages time filter.
- Group members will work on fixing the GCN number search textbox.
- Group members will check the work done to prepare for the upcoming semester presentation.