AllPawsInn Project -- Yusuf Okutan

Week 1

Title: Second Semester Plan

Date: 01/28/2019

Attendance: Yusuf Okutan

Accomplishments

- Last term project plan checked
- Github throughput examined

TODO

- Discussion about arranging groups to reach a more efficient project.

Week 2

Title: Setup and Planning

Date: 02/03/2019

Attendance: Yusuf Okutan

Accomplishments

- Last term data examined. Started to plan how we should move on for this term. Next steps are determined.
- GitHub files downloaded and checked for which programs needed.
- JS(JavaScript) learning has been started.

Problems

- I had some hardware problems on my computer.

TODO

- Discussion about arranging groups to reach a more efficient project.
- Meeting with Merwyn Jones for the next week.

Week 3

Title: Data and Implementation

Date: 02/11/2019

Attendance: Yusuf Okutan

Accomplishments

- I started to make research about NodeJS and MySQL works.
- All past semester data received from Amit Kumar(who was working with us last semester).
- NodeJS setup completed.
- I am trying to understand the implementations.

Problems

- Due to hardware problems, I formatted my PC and having a problem with MySQL right now.
- .NET Framework problem appeared.

TODO

- I am going to meet with Merwyn Jones and rest of AllPawsInn members this week.
- The old data will be shared with new group members.

Week 4

Title: Setup

Date: 02/18/2019

Attendance: Yusuf Okutan, Darshak Sundar, Kundan Shrivastav

Accomplishments

- Research on NodeJS & SQL.
- I received updated KMDB.sql.
- Working on MSSQL configurations. 

Problems

- Need some advice to set up properly from my teammates.

TODO

- I will meet with my teammates and Prof. Merwyn in next days.

- We will have a meeting with team members and Prof. Merwyn on Monday to see what our plan will be.

Week 5

Title: Setup

Date: 02/24/2019

Attendance: Yusuf Okutan, Darshak Sundar, Kundan Shrivastav, Amit Kumar

Accomplishments

- We had a meeting on Monday to set up the database into new group members. And talk about project and interfaces.
- NodeJS setup completed.
- MSSQL and Tools setup completed.
- KMDB.sql imported to the new created database.
- Now all functions and data are available to reach. 
- In the project file, I did all configurations to connect to the KMDB database.

Problems

- After I opened a terminal in a file path, I did npm install, npm update and npm start. Application opened but had some problem while checking data.
- Seems database connection is a problem. 

TODO

- We will have a meeting with team members and Prof. Merwyn on Monday to see where we are and how to fix this connection issue.

Week 6

Title: Errors & Start Coding

Date: 03/03/2019

Attendance: Yusuf Okutan

Accomplishments

- I was not able to attend last meeting. But I had all news from my teammate Darshak.
- I am working on separating checkout and payment page.
- The connection problem caused due to SQL Server Agent was not running. I started it to fix the problem.
- To check that system is working or not I created a new KMDB database again.
- allpawsinn project file extracted and SQL configurations change it to my SQL information.
- Tables and other functions are available to see and design.

Problems

- Still having warnings after npm install. 4 warnings which are:
  - Regular Expression Denial of Service (High)
  - Directory Traversal
  - Root Path Disclosure
  - Regular Expression Denial of Service (Moderate)
- After npm start, I am having different problem which prevents me to check SQL data. 
- I shared the problem opening application console with my teammates through the whatsapp.

TODO

- I am going to meet with my teammate Darshak on Tuesday or maybe next days to fix this problem.
- As a team we are going to meet with Merwyn but not on Monday due to Professor is not available.
- We are going to arrange new day to figure out what we are going to do on next.

Week 7

Title: Keep Working

Date: 03/10/2019

Attendance: Yusuf Okutan, Darshak Sundar

Accomplishments

- I met with Darshak to fix my connection issue between SQL and application.
- The problem repeated several times. But after the deletion of whole SQL and application files, and set up everything again Darshak overcame it.
- The application is available to show every data in the database.
- Now I can check and design JS codes.
- Darshak explained the next step to me. We are going to re-design Checked In, Checked Out, Payment functions.
- I am also working on Monday and Tuesday sections click-box issue.

Problems

- The problems are clear but it is hard to change them. 
- I am trying to understand how to code in JS to solve these problems.

TODO

- We will have a meeting with team members and Prof. Merwyn on Monday to see where we are at.

Week 8

Title: Guide & Code

Date: 03/17/2019

Attendance: Yusuf Okutan

Accomplishments

- We had a meeting last week and I was not able to end it but we checked on bugs and how we are going to fix them
- I am working on separating payment and checkout pages.
- Trying to learn JS step by step and understand the code

Problems

- I am trying to understand how to code in JS to solve these problems.
- We are in spring break that's why we couldn't have any meeting and couldn't discuss any step.

TODO

- After 2 weeks we have to share what we have done and where we are right now.

Week 9

Title: Guide & Code 2

Date: 03/24/2019

Attendance: Yusuf Okutan

Accomplishments

- Still working on problems. Payment and checkout.
- I made some changes on payment pages but didn't get good results. (Function is not working properly after changes)
- Still learning JS.

Problems

- I am trying to understand how to code in JS to solve these problems.
- Have to figure out how I should implement edited function on payment page.

TODO

- Next week on Monday we will have a meeting.

Week 10

Title: Coding

Date: 03/30/2019

Attendance: Yusuf Okutan

Accomplishments

- Payment and checkout pages seperated
- Added new columns in SQL 
- Implementations of new columns to have new well-design interface
- Graphical changes
- Check-In, check-out, deletion parts implemented with new code and design
- For some parts refresh issue fixed

Problems

- Refresh issue is on going. Still trying to solve this problem.
- In my opinion problem's solution hides in the first steps of this project. 
- All in all it is not going to have enough time to fix refresh issue for this semester. But I will keep working on it.

TODO

- Next week on Monday we will have a meeting.

Week 11

Title: Coding & Fixations

Date: 04/08/2019

Attendance: Yusuf Okutan, Darshak Sundar, Kundan Shrivastav

Accomplishments

- Payments page updated with fields for Amount Paid, Balance to pay per booking and balance in the client's account.
- Added new column TotalToPay in BookingObjects table in the database.
- Added all fields in Payments page as columns in payments table.
- Freezing daycare values for the current day after check-in is done.
- Changed discount field to editable.
- Few minor bugs on payments and grid being fixed.

Problems

- Refresh issue still to be resolved.
- Client's balance to be accessed and displayed.
- Payment to be done on a daily basis.

TODO

- Fix graphical changes on the payments page.
- Fixing balance calculation bug in payments page.
- Combine different check-in(s) of the same client, if present.