Bank queue tickets

This project was made for the entrance to NFQ academy. Task can be found in task.pdf file. The whole idea behind this task is to make a way for customers who come to any bank and take waiting ticket number to see the estimated time left before they will be serviced.

How to install

1. Download this project.
2. Upload everything to live server (FTP) except task.pdf and database.sql.
3. Upload database.sql file to your MySQL server.
4. Locate and open database.config file in includes folder.
5. Write your database information in this principle HOST_SERVER:DB_USER:DB_PASSWORD:DB_NAME for example localhost:root::you_db_name
6. You are good to go. Temporary spcialist loggings are username: admin and password: admin.

Run this project locally with Docker

1. Have docker and Makefile installed
2. Clone this repository
3. $ make prepare
4. $ make prepare-db
5. visit localhost:80
6. To login as specialist use admin:admin. To login as client, create an account.

User/Specialist guide

1. You can register as a User by pressing Prisijungti kaip klientui on the navigation bar and then pressing Neesate užisiregistravę? Užsiregistruokite!
2. You can log in with the credentials you just created
3. Go to client zone by clicking on Kliento zona
4. Write the estimated time you will be there and click Registruotis
5. You can write your number to see the estimated waiting time left.
6. You can cancel your visit by clicking on Atšaukti vizitą
7. You can delay your visit by clicking on Pavėlinti
8. You can log out from the system and click on Prisijungti kaip specialistui to log in as a specialist. Temporary loggings are admin/admin
9. You can go to admin zone by clicking on Admin zona
10. When a client comes you can start the visit by clicking on Klientas pradėtas aptarnauti and when a client leaves you can click on Klientas aptarnautas. Also, you can see how much time you've spent servicing the client.
11. You can view statistics when exactly the place is busiest by clicking on Statistika

What can be improved

1. Back-end validation can be manipulated by modifying GET/POST requests.
2. No password hashing.
3. MVC model is not perfect.
4. Not every acceptance criteria were done.

What has been used

1. PHP 7.4
2. MySQL
3. HTML+CSS
4. MVC