bar top left
bar top right
left curve
right curve
Welcome, Guest
Forgot your Password? Forgot your Username? Create Account
Go to bottom
Post Reply
Post New Topic
Page: 12345
TOPIC: Problema con RoomX
#106786
Re:Problema con RoomX 10 Months, 3 Weeks ago Karma: 162
very differents?
Yes, DAHDI/27 is different of DAHDI/g27

You use a trunk for each port.
My way was to taking each trunk declared into Elastix and use them for my billing report.
But here, it seems a bad way.

yes, 2 calls.
Good, ok!

I'll try to find a real solution to fix the bug.

In any case, thanks alot for your feedback which helping me so much.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
danardf
Administrator
Posts: 6406
graph
User Offline Click here to see the profile of this user
Gender: Male Location: France - Trans sur Erdre Birthday: 12/31

Links hidden for unregistered users. Login or register Here - Links hidden for unregistered users. Login or register Here - Franck Danard - franck.danard@roomx.fr
Reply Quote
 
#106832
Re:Problema con RoomX 10 Months, 3 Weeks ago Karma: 0
ok, thanks
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
loveral76
Fresh Boarder
Posts: 25
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#107022
Re:Problema con RoomX 10 Months, 3 Weeks ago Karma: 162
Hi.

Could you send me your data from asteriskcdrdb ?
Just the part about room using Mysql dump.
(I would like all between check in and check out date).

like this, i could make some tests from my side.

Thanks
regards
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
danardf
Administrator
Posts: 6406
graph
User Offline Click here to see the profile of this user
Gender: Male Location: France - Trans sur Erdre Birthday: 12/31

Links hidden for unregistered users. Login or register Here - Links hidden for unregistered users. Login or register Here - Franck Danard - franck.danard@roomx.fr
Reply Quote
 
#107037
Re:Problema con RoomX 10 Months, 3 Weeks ago Karma: 0
ok,
these are my data
File Attachment:
File Name: asteriskcdr.txt
File Size: 1853
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
loveral76
Fresh Boarder
Posts: 25
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2012/07/31 08:03 By loveral76.
Reply Quote
 
#107038
Re:Problema con RoomX 10 Months, 3 Weeks ago Karma: 162
Ok, thanks alot.

Wonderful.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
danardf
Administrator
Posts: 6406
graph
User Offline Click here to see the profile of this user
Gender: Male Location: France - Trans sur Erdre Birthday: 12/31

Links hidden for unregistered users. Login or register Here - Links hidden for unregistered users. Login or register Here - Franck Danard - franck.danard@roomx.fr
Reply Quote
 
#107092
Re:Problema con RoomX 10 Months, 3 Weeks ago Karma: 162
Hi.
About checkout module, into index.php at line 306,

Replace:
Code:
   
foreach($arrTrk as $key_trk => $value_trk){
  $trunk = $value_trk['trunk'];
  if(substr($trunk,0,strlen('DAHDI')) == 'DAHDI')
     $dahdi_t = "dstchannel LIKE '%DAHDI%' OR ";
  if(substr($trunk,0,strlen('mISDN')) == 'mISDN')
     $misdn_t = "dstchannel LIKE '%mISDN%' OR ";
  if(substr($trunk,0,strlen('CAPI')) == 'CAPI')
     $capi_t  = "dstchannel LIKE '%CAPI%' OR ";
  $condition = "substr(cdr.dstchannel,1,length('$trunk')) = '".$trunk."'";
  if( $key_trk < (count($arrTrk)-1)){
     $condition = "substr(cdr.dstchannel,1,length('$trunk')) = '".$trunk."' OR ";
  }
  $dst_info = $dst_info.$condition;
}


By

Code:

foreach($arrTrk as $key_trk => $value_trk){
  $trunk = $value_trk['trunk'];
  if(substr($trunk,0,strlen('DAHDI')) == 'DAHDI')
    $dahdi_t = "dstchannel LIKE '%DAHDI%' OR ";
  if(substr($trunk,0,strlen('mISDN')) == 'mISDN')
    $misdn_t = "dstchannel LIKE '%mISDN%' OR ";
  if(substr($trunk,0,strlen('CAPI')) == 'CAPI')
    $capi_t  = "dstchannel LIKE '%CAPI%' OR ";
  $condition = "substr(cdr.lastdata,1,length('$trunk')) = '".$trunk."'";
  if( $key_trk < (count($arrTrk)-1)){
    $condition = "substr(cdr.lastdata,1,length('$trunk')) = '".$trunk."' OR ";
  }
  $dst_info = $dst_info.$condition;
}


Let me know.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
danardf
Administrator
Posts: 6406
graph
User Offline Click here to see the profile of this user
Gender: Male Location: France - Trans sur Erdre Birthday: 12/31
Last Edit: 2012/08/01 12:56 By danardf.

Links hidden for unregistered users. Login or register Here - Links hidden for unregistered users. Login or register Here - Franck Danard - franck.danard@roomx.fr
Reply Quote
 
#107129
Re:Problema con RoomX 10 Months, 2 Weeks ago Karma: 0
Helo:

was given the code on line 289. replace the code and the problem persists.

Thanks.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
loveral76
Fresh Boarder
Posts: 25
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#107136
Re:Problema con RoomX 10 Months, 2 Weeks ago Karma: 162
It's weird, because when i send the request into MySQL, i've 2 records.

Retry to display the mysql request and sending it into mysql directly and next, give me the result please.

SELECT `calldate` , `dst` , `billsec` , `dstchannel`
FROM cdr
WHERE channel LIKE '%/1534%'
AND billsec > '0'
AND calldate > '2012-07-24 07:54:31'
AND calldate < '2012-07-26 07:55:16'
AND disposition = 'ANSWERED'
AND accountcode = '18'
AND (
substr( cdr.lastdata, 1, length( 'DAHDI/g1' ) ) = 'DAHDI/g1'
OR substr( cdr.lastdata, 1, length( 'DAHDI/g26' ) ) = 'DAHDI/g26'
)
LIMIT 0 , 30

Code:
2012-07-25 07:54:31    9420804  31  DAHDI/1-1
2012-07-25 07:55:16  915617074  57  DAHDI/26-1
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
danardf
Administrator
Posts: 6406
graph
User Offline Click here to see the profile of this user
Gender: Male Location: France - Trans sur Erdre Birthday: 12/31

Links hidden for unregistered users. Login or register Here - Links hidden for unregistered users. Login or register Here - Franck Danard - franck.danard@roomx.fr
Reply Quote
 
#107137
Re:Problema con RoomX 10 Months, 2 Weeks ago Karma: 0
calldate | dst | billsec | dstchannel |
+---------------------+-----------+---------+------------+
| 2012-07-25 07:54:31 | 9420804 | 31 | DAHDI/1-1 |
| 2012-07-25 07:55:16 | 915617074 | 57 | DAHDI/26-1
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
loveral76
Fresh Boarder
Posts: 25
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#107139
Re:Problema con RoomX 10 Months, 2 Weeks ago Karma: 162
Graet..... but retry with your real request, an not with mine.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
danardf
Administrator
Posts: 6406
graph
User Offline Click here to see the profile of this user
Gender: Male Location: France - Trans sur Erdre Birthday: 12/31

Links hidden for unregistered users. Login or register Here - Links hidden for unregistered users. Login or register Here - Franck Danard - franck.danard@roomx.fr
Reply Quote
 
Go to top
Post Reply
Post New Topic
Page: 12345
Elastix Forums :: Open Source Unified Communications Server
Localized forums
Español
Componentes de Elastix
Otros
Moderators: jgutierrez, jcastellanos
Powered by Kunena | KunenaSpanishget the latest posts directly to your desktop

Copyright © 2006 - 2013 PaloSanto Solutions. All Rights Reserved.

Banner

elastix

Protected by Spam Fighter