Kapalı

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.

Beceriler: MySQL, PHP

Daha fazlasını görün: 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

İşveren Hakkında:
( 0 değerlendirme ) Muskogee, United States

Proje NO: #741425

24 freelancers are bidding on average $427 for this job

samsakthi

Hi Check pm

in 9 gün içinde700$ USD
(22 Değerlendirme)
6.7
arnab0143

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

in 10 gün içinde500$ USD
(69 Değerlendirme)
6.6
AbrarHassan

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

in 5 gün içinde300$ USD
(1 Değerlendirme)
4.8
anjeko

Hello, Please read my PM Regards Jerry

in 5 gün içinde250$ USD
(3 Değerlendirme)
4.5
codetoon

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

in 15 gün içinde300$ USD
(10 Değerlendirme)
4.3
comet511

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

in 7 gün içinde250$ USD
(2 Değerlendirme)
4.0
islbd

Please check PMB

in 15 gün içinde350$ USD
(6 Değerlendirme)
4.0
stefancutrei

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 fazlası

in 10 gün içinde250$ USD
(1 Değerlendirme)
3.8
brijesht

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

in 10 gün içinde300$ USD
(2 Değerlendirme)
3.6
mdpauley

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

in 10 gün içinde450$ USD
(5 Değerlendirme)
2.5
pphaicom

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

in 7 gün içinde250$ USD
(1 Değerlendirme)
1.0
thewebsquare

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

in 10 gün içinde300$ USD
(1 Değerlendirme)
1.0
coding4u

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

in 25 gün içinde750$ USD
(0 Değerlendirme)
0.0
berckoff

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

in 14 gün içinde500$ USD
(0 Değerlendirme)
0.0
SalesSSSoftTec

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 fazlası

in 15 gün içinde655$ USD
(0 Değerlendirme)
0.0
MrCroft

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 fazlası

in 14 gün içinde450$ USD
(0 Değerlendirme)
0.0
mahendraliya

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 fazlası

in 45 gün içinde800$ USD
(0 Değerlendirme)
0.0
akhkharu

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 fazlası

in 20 gün içinde1000$ USD
(0 Değerlendirme)
1.4
zurman

### I'm interested on this.

in 7 gün içinde250$ USD
(0 Değerlendirme)
0.0
tulipneo

Hi Pls see my Pm. Br Tulip

in 20 gün içinde500$ USD
(0 Değerlendirme)
0.0