PIAF Hospitality Management System

[claudiopizzillo]

Hi everyone,

It's a beta version.

Features:

1. Rooms inventory management with bulk import from Freepbx extensions
2. Rates management: by prefix, with minute rate and fixed rate
3. Check-In and Check-Out (and associated actions)
4. Bills with search by dates and/or by rooms with details of calls
5. Integrated with Hotel wake-up module (you can delete it and insert new wake-up from web)
6. Delete every voicemail message and wake-up on check-out for the room/s (thanks TheShniz)

To install it:

cd /var/www/html
wget http://www.kefa.it/hotel.tar.gz
tar zxvf hotel.tar.gz
cd hotel
./loadmysql.sh

Go to http://MYPBX/hotel/index.php

To update it:

cd /var/www/html
wget http://www.kefa.it/hotel.tar.gz
tar zxvf hotel.tar.gz

Enjoy!!

Post errors or problems in the forum.

To Do:
Bugs fix?

P.S.
In my country if the room don't have check-in opened, you can call only the reception.
To control this actions put this in extensions_custom

exten => _X.,1,Set(result=${CURL(http://MYPBX/hotel/checkuser.php?Ext=${CALLERID(num)})}) 
exten => _X.,2,NoOp(Results: ${result})
exten => _X.,3,GotoIf($["${result}" = "OK"]?OK)
exten => _X.,4,GotoIf($["${result}" = "KO"]?KO)
exten => _X.,5(OK),Goto(outbound-allroutes,${DIAL},1)
exten => _X.,6,Hangup()
exten => _X.,7(KO),DIAL(SIP/RECEPTION)
exten => _X.,8,Hangup()

[wardmundy]

This is a phenomenal piece of software. I've unfortunately been sitting on it for several months waiting for a spare moment to review it on Nerd Vittles. Anyone in the hospitality business will love it. Period!

[bobvr]

Getting this error on install....

root@pbx:/var/www/html $ cd hotel
root@pbx:/var/www/html/hotel $ ./loadmysql.sh
-bash: ./loadmysql.sh: Permission denied

[wardmundy]

chmod 775 /var/www/html/hotel/loadmysql.sh

Then try again.

[bobvr]

Thanks Ward, worked now.

[cg180759]

sounds pretty good!

[TheShniz]

This is an exciting lil piece of software you've got right here...

While having an interface for Wake-Up Calls would be nice, the really, really important thing is to have the voicemailbox cleared out of any messages upon Check Out. Also, an added bonus would be for any mailbox greetings to be defaulted as well, but that could be handled by setting the files to read-only. The reason for this is so the next guest in doesn't get some risque' message for the one prior and is very important.

...could you give an example of what's expected under Rates, specifically with the Prefix and Type? I got it to work when they're set to blank, but that's all.

[claudiopizzillo]

Thanks,
here an example of Rates
Description Type Prefix Minute Rate Fixed Rate
Italy Landline 0 0.25 0.10
Italy Cellular 3 0.30 0.20
USA All 0011 0.30 0
UK All 0044 0.30 0.10

For each call, if a prefix match, the price is (Min.Rate/60 * secs of call from asterisk cdr) + Fixed Rate (if exist and > 0)

Do you use voicemail in hotel? When i prepare the extensions (normally pstn phones connected to fxs gateway) i set in freepbx no voicemail.
If you want i can put in the next release the clearing of voicemail in the check-out.

Insert the wake-up from web is MANDATORY in the next release.

Thanks for testing and suggestions.

[TheShniz]

Thanks for the description, I'll give the rates another shot...

Most (not all) of the hotels of any notable size (not a 10 room motel) here in the USA do have voicemail; The analog telephones do have MWL's, and only require the proper gateway to support it.

While I may not use voicemail in a hotel myself, I can easily imagine those that do. A possible example might be a large group that checks out multiple rooms and leaves messages from one room to another. This ability would be mandatory here for its use.

...I look forward to what you have in mind!

[claudiopizzillo]

New update for the software !
New features and bugs fix!