AllPawsInn: Difference between revisions
| Line 186: | Line 186: | ||
Changes on UI: |
Changes on UI: |
||
- A new page for "Reports" is created. Customer will be able to print receipts and reports from this page. |
- A new page for "Reports" is created. Customer will be able to print receipts and reports from this page. |
||
- A button is added to the hamburger menu. |
- A button is added to the hamburger menu. |
||
- A table is added to reports page. A reservation of a customer can be choosen from this table. |
- A table is added to reports page. A reservation of a customer can be choosen from this table. |
||
- 6 buttons added to the page. But there is no functionality atm. Buttons are; |
- 6 buttons added to the page. But there is no functionality atm. Buttons are; |
||
- A button to get a receipt for selected booking (reservation). This one will print all payments done for that booking. |
- A button to get a receipt for selected booking (reservation). This one will print all payments done for that booking. |
||
- A button to get a report for all bookings made and payments done by a selected customer. |
- A button to get a report for all bookings made and payments done by a selected customer. |
||
- A button to get a report for all bookings made and payments done within selected dates. |
- A button to get a report for all bookings made and payments done within selected dates. |
||
- A button to get a report for all bookings made and payments done within selected dates by a selected customer. |
- A button to get a report for all bookings made and payments done within selected dates by a selected customer. |
||
- 2 date input areas added to the page. |
- 2 date input areas added to the page. |
||
- Payment page is updated. Services table is removed. A new table for "Unpaid Bookings" added. |
- Payment page is updated. Services table is removed. A new table for "Unpaid Bookings" added. |
||
- We were using services table to add multiple services at one time, however this operation was not needed. |
- We were using services table to add multiple services at one time, however this operation was not needed. |
||
- Now, the customer can add one service at a time. |
- Now, the customer can add one service at a time. |
||
- A checkbox is added for Daycare. Customer now can create a service without a daycare when adding a service. |
- A checkbox is added for Daycare. Customer now can create a service without a daycare when adding a service. |
||
- All unpaid bookings will be listed on the "Unpaid Bookings" table. |
- All unpaid bookings will be listed on the "Unpaid Bookings" table. |
||
- Customer can select one booking from the table and make a payment for the booking. |
- Customer can select one booking from the table and make a payment for the booking. |
||
- If it is fully paid, then it is removed from the list. |
- If it is fully paid, then it is removed from the list. |
||
Changes on Database: |
Changes on Database: |
||
- 5 new columns added to the "ServicesDetails" table. |
- 5 new columns added to the "ServicesDetails" table. |
||
- New columns are: |
- New columns are: |
||
- paidAmount => Shows the paid amount for a specific booking. |
- paidAmount => Shows the paid amount for a specific booking. |
||
- dateIn => Shows the date the customer created the service/booking. |
- dateIn => Shows the date the customer created the service/booking. |
||
- dateOut => Shows the date the customer checked out. |
- dateOut => Shows the date the customer checked out. |
||
- paid => Boolean field to show whether the service/booking is completely paid. |
- paid => Boolean field to show whether the service/booking is completely paid. |
||
- animalId => Shows the animalId of the service/booking. |
- animalId => Shows the animalId of the service/booking. |
||
- These columns were added to make the program be able to create a receipt for previous payments. |
- These columns were added to make the program be able to create a receipt for previous payments. |
||
- From now on, all the bookings, reservations, and services will be saved to this data table, ServicesDetails. |
- From now on, all the bookings, reservations, and services will be saved to this data table, ServicesDetails. |
||
Changes on Backend: |
Changes on Backend: |
||
- A class is created for the "Reports" page. This class will contain all the functions required for the page. |
- A class is created for the "Reports" page. This class will contain all the functions required for the page. |
||
- The button on the hamburger menu is connected to the Reports page. |
- The button on the hamburger menu is connected to the Reports page. |
||
- A function to display customers on the table is created. |
- A function to display customers on the table is created. |
||
- A function to find unpaid reservations on the database is added to PaymentFunctions class. An SQL Query function is also added to DatabaseClass. |
- A function to find unpaid reservations on the database is added to PaymentFunctions class. An SQL Query function is also added to DatabaseClass. |
||
- A function to pay for an unpaid reservation is added. If payment is fully completed, the "paid" column changes to "true". An SQL Query function is also added to DatabaseClass. |
- A function to pay for an unpaid reservation is added. If payment is fully completed, the "paid" column changes to "true". An SQL Query function is also added to DatabaseClass. |
||
Revision as of 16:55, 7 March 2022
Week 1
Date: 01/31/2022
Accomplishments
-Team members had a meeting with Prof. Jones
Problems
- No problems for this week
To do
- In Client info, "Notes" will be changed to "E-mail"
- In the payment section, Take payment does not work correctly. It sometimes adds up instead of substraction. Find the problem there.
- In the payment section, when a customer is chosen and some services are added to the list, the client is unchangeable until the payment action is completed, even we remove the service.
- On the Edit Client page, add a field to edit "Name", "Surname".
- In client info, there is no space between name & surname. Add it.
- On the reservation page, the "Remove Day" button does not work.
- On the weekly schedule page, dates are sometimes shown as "1/1/2000". Find the reason and fix it. Note: when pushed "this week", dates return to correct dates; however, the schedule is shifted right. It was monday-friday but shifted wed-sunday.
- Improve the UX in the payment section. Take payment button is broking the structure.
- Check-in button on the Daily Schedule page needs to be resized.
- It is better to clean out some tables in the database. Tables are; BookingObjects, Payments, Services Details. Also ClientDetails.AccountBalance should be set to 0.
- move DB to my machine process
Week 2
Date: 02/07/2022
Accomplishments
- In Client info, "Notes" changed to "E-mail"
- On the Edit Client page, added a field to edit "Name", "Surname"
- Improved the UX in the payment section. Take payment button is not broking the structure.
- Check-in button on the Daily Schedule page resized.
- In client info, there is space between name & surname.
- On the reservation page, the "Remove Day" button works now.
- On the weekly schedule page, dates are sometimes shown as "1/1/2000". It has been fixed.
Problems
- No problems for this week
To do
- Team members will have a meeting for the updates.
Week 3
Date: 02/14/2022
Accomplishments
- Team members prepared document for database import.
- Team members prepared document for database back-up.
- Team members made some changes for UI design such as background color.
- Team members look through the website "revelationpets" as Prof. Jones suggested.
Problems
- No problems for this week
To do
- Team members will try to import recent database to Prof. Jones system. - Team members will have a meeting for the updates.
Week 4
Date: 02/21/2022
Accomplishments
- Team members has accomplished database import to the Prof.Jones system
- Team members opened "revelationpets" account.
- Team members tested data import-export through "revelationpets".
- In the payment section, Take payment does not work correctly. It sometimes adds up instead of substraction. It has been fixed.
- The days and reservations in the weekly schedule is not correct. It has been fixed.
- In the payment section, when a customer is chosen and some services are added to the list, the client is unchangeable until the payment action is completed, even we remove the services. It has been fixed
- Saved some space from hamburger
- Added check out title above paynow & paylater
- Changed the actual window size
- Color theme: https://coolors.co/5b4c49-9e7153-e0965d-ebcdb3-eadece-455f6c-45637c-44668c
- Minimum size is set to 1240x820, and starting size is set to 1400x900
- We have a bug in customer display areas due to the address bug. Fix it.
Problems
- No problems for this week
To do
- Team members will have a meeting for the updates.
Week 5
Date: 02/28/2022
Accomplishments
- Homepage reservation bugs were fixed, - customer name sometimes does not appear on "checked out" list. fixed
- take payment section add column names and extra information - fixed
- Get rid of IDs in the selection tables, all of them. -- fixed
Problems
- No problems for this week
To do
- Team members will have a meeting for the updates.
Week 6
Date: 03/07/2022
Accomplishments
Changes on UI:
- A new page for "Reports" is created. Customer will be able to print receipts and reports from this page.
- A button is added to the hamburger menu.
- A table is added to reports page. A reservation of a customer can be choosen from this table.
- 6 buttons added to the page. But there is no functionality atm. Buttons are;
- A button to get a receipt for selected booking (reservation). This one will print all payments done for that booking.
- A button to get a report for all bookings made and payments done by a selected customer.
- A button to get a report for all bookings made and payments done within selected dates.
- A button to get a report for all bookings made and payments done within selected dates by a selected customer.
- 2 date input areas added to the page.
- Payment page is updated. Services table is removed. A new table for "Unpaid Bookings" added.
- We were using services table to add multiple services at one time, however this operation was not needed.
- Now, the customer can add one service at a time.
- A checkbox is added for Daycare. Customer now can create a service without a daycare when adding a service.
- All unpaid bookings will be listed on the "Unpaid Bookings" table.
- Customer can select one booking from the table and make a payment for the booking.
- If it is fully paid, then it is removed from the list.
Changes on Database:
- 5 new columns added to the "ServicesDetails" table.
- New columns are:
- paidAmount => Shows the paid amount for a specific booking.
- dateIn => Shows the date the customer created the service/booking.
- dateOut => Shows the date the customer checked out.
- paid => Boolean field to show whether the service/booking is completely paid.
- animalId => Shows the animalId of the service/booking.
- These columns were added to make the program be able to create a receipt for previous payments.
- From now on, all the bookings, reservations, and services will be saved to this data table, ServicesDetails.
Changes on Backend:
- A class is created for the "Reports" page. This class will contain all the functions required for the page.
- The button on the hamburger menu is connected to the Reports page.
- A function to display customers on the table is created.
- A function to find unpaid reservations on the database is added to PaymentFunctions class. An SQL Query function is also added to DatabaseClass.
- A function to pay for an unpaid reservation is added. If payment is fully completed, the "paid" column changes to "true". An SQL Query function is also added to DatabaseClass.
Problems
- No problems for this week
To do
- Team members will have a meeting for the updates and discuss new ideas with Prof. Jones.
