I want to create a Hotel property management system in php/mysql, it is a small hotel with 38 rooms. Essentially it involves 3 tables:
1. Customer Info (with blob column for image-scan of drivers license (DL), scanned independently of this system)
2. Rooms (with today's occupancy info as well as past occupancy, customer name, rate, payment amount, payment type, check in date, check out date)
3. Rates (only 6 rows)
The main display would be a list of each room number and then unoccupied if it is unoccupied today or the occupant's name. If unoccupied, I would want to click it to place a customer in the room.
This would bring up a form to search current customers by last name (would bring up the image of DL as well as the rest of customer info). I would select the customer and it would show me the last 5 rates offered to that customer (array in customer table, dropping oldest to add a new one).
If the customer is not there, I would want to create customer, basically 15 txt fields. The image of their DL would be scanned by a USB scanner to a set location, user would need to "select file" and then it would be copied to the database.
Then the next screen would be rate selection, (each room is assigned a type which correlates with the rates table), the rates would be displayed and then there would be a text box to enter the rate (rate is at discretion of user). Next screen is payment, here the payment type is entered and amount paid is entered. The information now would be entered into the rooms table with today's date (check in date), customer info, rate,payment amount, payment type, and check out date. Rate info would also be added to array in customer table.
The date would also have to be slightly altered from the date() function, the "day" must run until 6am the next morning, where then an alert would come up on the main function to close out the day. This would then create new rows in the table for today's date for each room (if there is not a person occupying it, i.e. someone staying for 3 days would still show up on the next day's screen).
Also I would like an auditing report generated (manually) (csv file compatible with excel) which lists each room, customer name, rate, payment amount, payment type, check in date, check out date. At the bottom of the report I would like the totals of each payment type (to compare with actual). I also want to be able to go back and pull these reports for any date.
The auditing report as well as a way to set the rates I would like in a separate page (e.g. that is not accessible to general users, unless they know about it).
This project would run on a local server running W-A-M-P with the latest PHP/MySQL updates.
Please let me know the feasibility and cost of this project.
24 freelancers are bidding on average $427 for this job
Hi, We aim to provide you the Best quality work.Just create your website is not enough so we will give you SEO friendly website.See more detail in PMB-Thanks