Hotel Property Management System

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.

Skills: MySQL, PHP

See more: property management system php, mysql property management, php property management system, hotel rates php mysql, php hotel property management, hotel property management system, hotel property management system php, property management system php mysql, property management hotel php, php mysql hotel management system, hotel management php, mysql hotel, PROPERTY MANAGEMENT SYSTEM, type of auditing, the need for auditing, rooms to go, person management, drivers select, customer table, auditing information, auditing i, a.i.m. property management, hotel php mysql, php mysql property management system, hotel management report php mysql

About the Employer:
( 0 reviews ) Muskogee, United States

Project ID: #741425

24 freelancers are bidding on average $427 for this job


Hi Check pm

$700 USD in 9 days
(22 Reviews)

--Hello Sir, Please check your pm. Thanks.--

$500 USD in 10 days
(69 Reviews)

Hi, kindly see PM to get an attractive bid and portfolio. Thanks

$300 USD in 5 days
(1 Review)

Hello, Please read my PM Regards Jerry

$250 USD in 5 days
(3 Reviews)

I am an experienced PHP developer and can easily work on this project as per your requirements and expectations. Thanks

$300 USD in 15 days
(10 Reviews)

Hi. I am ready to start your project. Please check out my portfolio. Thanks.

$250 USD in 7 days
(2 Reviews)

Please check PMB

$350 USD in 15 days
(6 Reviews)

Dear Sir, My name is Stefan and I'm a Romanian programmer. I find this project interesting and I think that it matches my skills. In order to complete it in a short time I will need more information about the projec More

$250 USD in 10 days
(1 Review)

Hi I can do this, Please see PM for other details

$300 USD in 10 days
(2 Reviews)

I am a perfect fit for this project. I could have this completed in 10 days or less.

$450 USD in 10 days
(5 Reviews)

Sir, I can do your project quickly,please check my PMB.

$250 USD in 7 days
(1 Review)

Hi, Interested in working with you on this project. Please view PMB for details. Regards, Abbas

$300 USD in 10 days
(1 Review)

Hi, We aim to provide you the Best quality [url removed, login to view] create your website is not enough so we will give you SEO friendly [url removed, login to view] more detail in PMB-Thanks

$750 USD in 25 days
(0 Reviews)

Will be glad to hear from You and do some work together :)

$500 USD in 14 days
(0 Reviews)

Hi, We are ready to work with you. We can convince you with our quality services. We are 35 members having expertise in ASP, ASP.Net, PHP, Flash, Abode & Java Technologies. Looking forward a long term relationship with More

$655 USD in 15 days
(0 Reviews)

Allright, I find this project fairly easy PHP&MySQL'wise. Time-wise however, being busy with my current job, even if this could be a 5-day - 1 person project, I have to give 2 weeks just to eliminate any doubt meetin More

$450 USD in 14 days
(0 Reviews)

Hi, I can provide you the 'Hotel management Software/website' as per your need. I can even provide you very good suggestions as you require it on your local server only. Just for your info, I have worked on 'Hospitalit More

$800 USD in 45 days
(0 Reviews)

Hey, I am the Ruby on Rails and PHP developer with 8 years of experience. I can build this system for you. I carefully walked through the project description. I would recommend to you to not to store scanned DLs in DB. More

$1000 USD in 20 days
(0 Reviews)

### I'm interested on this.

$250 USD in 7 days
(0 Reviews)

Hi Pls see my Pm. Br Tulip

$500 USD in 20 days
(0 Reviews)