PHP Script (web based) for rooms rental

I need a system to manage the rental of hotel rooms.

I already have a booking system, but I need a lean system to manage the rooms that I rent on daily base.

I would like a system accessible from the web (responsive graphics) so that it can also be accessed easily from a smartphone.

To access the system must have a password login required.

Once logged in (a single administrator user is enough) you will see a calendar that shows the current week as a base, from Monday to Sunday, but must be possible to go backward or forward in calender.

Above the calendar there is a menu, with links to access RESERVATIONS, the CUSTOMER ARCHIVE, a SEARCH FIELD (that will be able to search for the data entered in the CUSTOMER SHEET) and STATISTICS (link to statistcs page, see below).

On each day visible in the calendar, current bookings will be shown, with these items visible:

- Reservation ID
- Room number
- Customer name and surname
- Room status
- Time of arrival
- Time of departure
- Price
- Payment status

To insert the sheets I will first have to create a customer archive.

In the customer sheet, I want to insert these data:

- Customer name and surname (MANDATORY - simple text field)
- Telephone 1 (MANDATORY - text field that accepts numbers only)
- Telephone 2 (OPTIONAL - text field that accepts numbers only)
- Telephone 3 (OPTIONAL - text field that only accepts numbers)
- Telephone 4 (OPTIONAL - text field that only accepts numbers)
- Notes (OPTIONAL - text field) with the possibility of adding X notes with the click of a button ("add a new note"), in order to have multiple notes in the customer sheet. Each note created will have to show the date it was created. The NOTES field must be sorted by date, with the most recent in first position.
- Reservations (dynamic field that will show the history of reservations, see below, made by this customer and will show DATE, ROOM NUMBER, PRICE and PAYMENT STATUS)
- # reservations (Simple number showing the total of reservations made by this customer)
- SAVE / MODIFY / CANCEL button

Once the customer sheet has been created, the reservation can be inserted.

In the reservation sheet, I want to insert these data:

- Reservation ID (automatic increasing value)
- Date of booking: today's date by default
- Customer name and surname: to be chosen among the customers included in the customer archive (the one created before..)
- Room number: a text field that only accepts numbers
- Room status: "BOOKED / OCCUPIED". By default "booked" but I can change it to "occupied"
- Time of arrival: optional text field that only accepts hours
- Departure time: optional text field that only accepts hours
- Price: default "50 €", but I can vary it and only accept numbers
- Payment status: "UNPAID / PAID". By default "unpaid" but I can change it to "paid".
- SAVE / MODIFY / CANCEL button

When the reservation in entered, I can see it on the calendar, i.e. the initial screen of the script, like above..

On the calendar it is important that some datas are clickable, and that they allow me to access the customer sheet or booking sheet on the fly.

Summarizing then on the calendar the reservations will be shown, with these data:

- Reservation ID (CLICKABLE, which will send me to the form where I can modify the reservation)
- Room number
- Customer's name and surname (CLICKABLE, which will send me to the customer sheet)
- Room status (will show the status, if it is "BOOKED" or "OCCUPIED", and I can change it on the fly from the calendar without having to enter the sheet)
- Time of arrival
- Time of departure
- Price
- Payment status (will show the status, if it is "UNPAID" or "PAID", and I can change it on the fly from the calendar without having to enter the form)

STATISTICS page
The STATISTICS page should summarize:
- total of bookings made in the current week
- total of bookings made in the last week

- total money earned in the current week
- total money earned in the last week

- total of bookings made in the current year
- total of bookings made in the previous year

- total money earned in the current year
- total money earned in the previous year

if possible, a search field by date, which shows the NUMBER OF BOOKINGS and MONEY EARNED on a selected period of time

I await the various proposals to evaluate