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.
Bu iş için 24 freelancer ortalamada $427 teklif veriyor
Hi, kindly see PM to get an attractive bid and portfolio. Thanks
I am an experienced PHP developer and can easily work on this project as per your requirements and expectations. Thanks
Hi. I am ready to start your project. Please check out my portfolio. Thanks.
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 Daha Fazla
I am a perfect fit for this project. I could have this completed in 10 days or less.
Hi, Interested in working with you on this project. Please view PMB for details. Regards, Abbas
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
Will be glad to hear from You and do some work together :)
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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. Daha Fazla