RoomX CDR Billing Issue

[trilok]

Cannot see the call billing in roomx billing, can any one help me on this I have downloaded the latest version of RoomX 1.0.0-91 and am running the module in Elastix Centos 5.9 (Final)

First thanks for the wonderful module, I have been testing it since I got the module and have exploring the software. all the module is fine except the CDR billing in the roomx billing report the called details are not shown properly, but when viewed through the reports of elastix everything is correct. but in the roomx billing the cdr is not showing as the elastix billing report, could you please help me,
another thing is that we cannot see the mini bar bills in the reports ??

Please can any one help me on my above query

 

[danardf]

Hi

Well.

At first, download the manual from RoomX website (I just upload a new PDF document V2).
Next, usually, you have to setting up the Elastix billing rate and select one trunk (or more) which will be billable.
About mini-bar, read the documentation.

If all is here, i need to know your kind of trunk is used (SIP, Dahdi, or else).
What's your Elastix version.

Regards

 

[trilok]

Dear Franck,
Thank you for your prompt reply, and for the Manual, I went through the Manual and rechecked everything in the system and all is according to the manual, but still when I check in a room and make some call all the made calls are shown in the elastix billing report with prefix rate date dst and account code with given rate applied, but now when I do a check out of the room in the roomx billing I do not see the telephone bills I see only the room rate billed and also before check out after I pressed the Mini bar consumption from the room extension ( E.G *37112#) where 1 is for coca cola and 2 for apple juice with a rate tag of 50 for both configured in Minibar with vat is also not shown in the roomX bill. so is there any thing where I have missed out, please help me in resolving this issue.

I would again like to thank you for your prompt reply. looking forward for your help.

Trilok

 

[trilok]

Dear Franck,
Sorry I missed out you question I am using SIP trunk with a voip gate way with 2 FXO and 8 FXS Elastix version is 2.4.0
Trilok

 

[danardf]

Hmmm. It's weird.

Could you send me a backup of the roomx database please at [email protected]
Next, if you could sent me a part of the CDR data, i will try to check if some bug exist or not.

About the mini bar, you should hear this prompt (added your information sales).
And next, for each digit pressed, you have to hear which has been selected.
At the end, when you press the #, you have to hear : goodbye, right?

Next, the mini-bar informations are stored here.
roomx database, Table = room, key = mini_bar
if you can check it?

About the billing.
Make a checkin.
Launch some calls.
Goto the rooms list.
Click on (?) near the room and look at the information in the popup.
You must have the number of external calls displayed here.
If there's no call, it could have a SQL issue.

Give me the complet informations about Elastix version, (Asterisk, Elastix...etc)

 

[danardf]

Hmm Other.

When you make a checkout, don't forget to click on details option of course!!!

 

[danardf]

For dumping: mysqldump -u root -pyour_sql_pwd roomx > roomx.sql
Check if the good mysql password is setting up into this file: more /etc/asterisk/extensions_roomx.conf
included here; MYSQL(Connect connid localhost root eLaStIx.2oo7 roomx)

eLaStIx.2oo7 is the default password.
Replace if it's not the same and reload Asterisk using CLI mode : reload

 

[trilok]

Dear Franck,
Thanks for your prompt reply, ok I will first check with the instruction which you have said it could be the SQL Password as I had changed it to my own password I will have a look in detail and will give you the feed back of what happened, Thanks once again I will give you my feedback once I review all the files as you said.

Thanks Once Again,

Trilok

 

[danardf]

So now you can see the details of the mini-bar, right?
But the details for every calls too?

 

[trilok]

Franck,
Still not able to see the mini bar status and also the call billing on the roomx billing report. is there other places where I need to change the MySql password in roomx or on any conf file?
In the list when I press the (?) I just see the checkin room status only and cannot see the call details also the mini bar status cannot see. even though I made a random calls and also setup the mini bar consumption.

Trilok

 

[trilok]

Franck,
Still not able to see the mini bar status and also the call billing on the roomx billing report. is there other places where I need to change the MySql password in roomx or on any conf file?
In the list when I press the (?) I just see the checkin room status only and cannot see the call details also the mini bar status cannot see. even though I made a random calls and also setup the mini bar consumption.

Trilok

 

[danardf]

About minibar, (i am a nutt). :roll:
I lose my head. :lol:

it's a * and not #
so, you have to dial *37- 122 - * and not *37- 122 - #

# is to cancel.

Check your mail. :wink:

 

[danardf]

Indeed, an issue in the helper menu. !!!

English Details (Wrong way)

This menu affecting a product on each key with its price. You can enter 10 different products on this module.
2 V.A.T can be selected.
When the chambermaid checks a mini-bar, she dials the prefix (*37 by default) and presses the number of the product used.
The entering is ended by the # key. if the # key is not pressed, all products will not billed.
The # key cancels the entering.

Français Détails (Good way)

Ce menu affecte un produit sur chaque touche du clavier du téléphone avec son prix. Vous pouvez entrer 10 produits différents sur ce module.
2 TVA peuvent être sélectionnées.
Lorsque la femme de chambre vérifie un mini-bar, elle compose le préfixe (* 37 par défaut) et appuie sur la touche correspondant au produit utilisé.
L'entrée se termine par la touche *. Si la touche * n'est pas composée, tous les produits ne seront pas facturés.
La touche # annule aussi la saisie.

I must fix this wrong information..

 

[danardf]

Ok for resume:
A important bug has been detected.
I don't know if it's during install or else, but the Mysql password is not updated into extensions_roomx.conf.

Next, when you have no hidden digit into the billing rate, the called number is not displayed in the billing.
Only the number with some hidden digits are displayed.

The last point should be resolved the next week.

But freely, i see the problem like this:
Curent code:

				$Total_Calls    = $Total_Calls + $price_rate;
				$Total_Call_VAT = $Total_Calls / (1+(strval($Config['vat_1'])/100));
				$Total_Call_VAT = intval($Total_Call_VAT*100)/100;
            $Destination    = substr($value_cdr['dst'],0,-$arrRate[$idx_rate]['hided_digits']);
				$Destination    = $Destination.str_repeat("*",$arrRate[$idx_rate]['hided_digits']);

New code:

				$Total_Calls    = $Total_Calls + $price_rate;
				$Total_Call_VAT = $Total_Calls / (1+(strval($Config['vat_1'])/100));
				$Total_Call_VAT = intval($Total_Call_VAT*100)/100;
            $Destination    = $value_cdr['dst'];
            if ( $arrRate[$idx_rate]['hided_digits'] > 0 ) {
                $Destination    = substr($value_cdr['dst'],0,-$arrRate[$idx_rate]['hided_digits']);
		          $Destination    = $Destination.str_repeat("*",$arrRate[$idx_rate]['hided_digits']);
            }

Thanks to trilok for sharing his server.

 

[mikehan23]

How would you handle billing with more than 1 phone in the room?

Each room will have multi-phones (1 main, bathroom phone, etc...), but the room will only have 1 bill. What would be the best way to solve this problem?

 

[trilok]

hi
The simple method for solving the multiple phone issue is to have the same number for all, its obvious that in a hotel the extension is defined using the room number right in my case I define the extension using a room number and within the room I place all the telephone number in parallel mode so that all the telephone within the room will have the same number. so you wont be having issue with the phone bills.

Regards
Trilok

 

[danardf]

How would you handle billing with more than 1 phone in the room?

Each room will have multi-phones (1 main, bathroom phone, etc...), but the room will only have 1 bill. What would be the best way to solve this problem?

Hi.
Sorry, i missed this post.

Today, the "Suite" room is not implemented yet.
But the idea will be to setting up the guest id into the account code of each extension and avoid to launch the SQL request with the room extension. (keep only the account code request)
With your version the SQL request is based on the extension and account code for looking for any calls of room.

In a next vesrion (Pro i guess), i think to be able to add some suite room. for example:
Room 100 = extension 1000, 1001,1002
And during the check in, the guest id will be inserted into each extension of the suite.

Regards

 

[danardf]

hi
The simple method for solving the multiple phone issue is to have the same number for all, its obvious that in a hotel the extension is defined using the room number right in my case I define the extension using a room number and within the room I place all the telephone number in parallel mode so that all the telephone within the room will have the same number. so you wont be having issue with the phone bills.

Regards
Trilok

Sure, it's a way, but the SIP fork seems not be supported by Asterisk.
If you have 3 SIP phone for one SIP account, you could have some problem.
It's not a nice method.