Difference between revisions of "Output of the API LISTING task"

From VoIPmonitor.org
Jump to navigation Jump to search
Line 16: Line 16:
 
Because the response for single CDR is json string that contains over 16k of chars, here is result after passing the string to json_decode fce with use of var_dump for printing its contents splited by fields:
 
Because the response for single CDR is json string that contains over 16k of chars, here is result after passing the string to json_decode fce with use of var_dump for printing its contents splited by fields:
  
−
<code>testCode<br>TestCode</code>
 
  
−
<code>testCode&60br&62TestCode</code>
+
<code>
 +
(
 +
    [total] => 1
 +
    [deferTotal] =>
 +
    [results] => Array
 +
        (
 +
            [0] => stdClass Object
 +
                (
 +
                    [ID] => 55
 +
                    [calldate] => 2023-05-12 16:33:17
 +
                    [callend] => 2023-05-12 16:50:12
 +
                    [duration] => 16:55
 +
                    [connect_duration] => 16:40
 +
                    [progress_time] => 0
 +
                    [first_rtp_time] => 0
 +
                    [caller] => 11
 +
                    [caller_domain] => 192.168.88.199
 +
                    [caller_reverse] => 11
 +
                    [callername] =>
 +
                    [callername_reverse] =>
 +
                    [called] => 34567654567865
 +
                    [called_domain] => 192.168.88.199
 +
                    [called_reverse] => 56876545676543
 +
                    [sipcallerip] => 192.168.88.174
 +
                    [sipcallerport] => 5060
 +
                    [sipcalledip] => 192.168.88.199
 +
                    [sipcalledport] => 5060
 +
                    [whohanged] => callee
 +
                    [bye] => 3
 +
                    [lastSIPresponse_id] => 1
 +
                    [lastSIPresponseNum] => 200
 +
                    [reason_sip_cause] =>
 +
                    [reason_sip_text_id] =>
 +
                    [reason_q850_cause] =>
 +
                    [reason_q850_text_id] =>
 +
                    [sighup] => 0
 +
                    [dscp] => 0
 +
                    [a_index] => 0
 +
                    [b_index] =>
 +
                    [a_payload] => 8
 +
                    [b_payload] =>
 +
                    [a_saddr] => 192.168.88.174
 +
                    [b_saddr] =>
 +
                    [a_received] => 50725
 +
                    [b_received] =>
 +
                    [a_lost] => 0
 +
                    [b_lost] =>
 +
                    [a_ua_id] => 3
 +
                    [b_ua_id] => 1
 +
                    [a_avgjitter_mult10] => 4
 +
                    [b_avgjitter_mult10] =>
 +
                    [a_maxjitter] => 10
 +
                    [b_maxjitter] =>
 +
                    [a_sl1] => 0
 +
                    [a_sl2] => 0
 +
                    [a_sl3] => 0
 +
                    [a_sl4] => 0
 +
                    [a_sl5] => 0
 +
                    [a_sl6] => 0
 +
                    [a_sl7] => 0
 +
                    [a_sl8] => 0
 +
                    [a_sl9] => 0
 +
                    [a_sl10] => 0
 +
                    [a_d50] => 0
 +
                    [a_d70] => 0
 +
                    [a_d90] => 0
 +
                    [a_d120] => 0
 +
                    [a_d150] => 0
 +
                    [a_d200] => 0
 +
                    [a_d300] => 0
 +
                    [b_sl1] =>
 +
                    [b_sl2] =>
 +
                    [b_sl3] =>
 +
                    [b_sl4] =>
 +
                    [b_sl5] =>
 +
                    [b_sl6] =>
 +
                    [b_sl7] =>
 +
                    [b_sl8] =>
 +
                    [b_sl9] =>
 +
                    [b_sl10] =>
 +
                    [b_d50] =>
 +
                    [b_d70] =>
 +
                    [b_d90] =>
 +
                    [b_d120] =>
 +
                    [b_d150] =>
 +
                    [b_d200] =>
 +
                    [b_d300] =>
 +
                    [a_mos_lqo_mult10] =>
 +
                    [b_mos_lqo_mult10] =>
 +
                    [a_mos_f1_min_mult10] => 45
 +
                    [a_mos_f2_min_mult10] => 45
 +
                    [a_mos_adapt_min_mult10] => 39
 +
                    [a_mos_xr_min_mult10] =>
 +
                    [a_mos_silence_min_mult10] => 45
 +
                    [b_mos_f1_min_mult10] =>
 +
                    [b_mos_f2_min_mult10] =>
 +
                    [b_mos_adapt_min_mult10] =>
 +
                    [b_mos_xr_min_mult10] =>
 +
                    [b_mos_silence_min_mult10] =>
 +
                    [a_mos_f1_mult10] => 45
 +
                    [a_mos_f2_mult10] => 45
 +
                    [a_mos_adapt_mult10] => 45
 +
                    [a_mos_xr_mult10] =>
 +
                    [a_mos_silence_mult10] => 45
 +
                    [b_mos_f1_mult10] =>
 +
                    [b_mos_f2_mult10] =>
 +
                    [b_mos_adapt_mult10] =>
 +
                    [b_mos_xr_mult10] =>
 +
                    [b_mos_silence_mult10] =>
 +
                    [a_rtcp_loss] => 0
 +
                    [a_rtcp_maxfr] => 0
 +
                    [a_rtcp_avgfr_mult10] => 0
 +
                    [a_rtcp_maxjitter] => 1
 +
                    [a_rtcp_avgjitter_mult10] => 3
 +
                    [a_rtcp_avgrtd_mult10] =>
 +
                    [a_rtcp_maxrtd_mult10] =>
 +
                    [a_rtcp_avgrtd_w] => 1
 +
                    [a_rtcp_maxrtd_w] => 2
 +
                    [b_rtcp_loss] =>
 +
                    [b_rtcp_maxfr] =>
 +
                    [b_rtcp_avgfr_mult10] =>
 +
                    [b_rtcp_maxjitter] =>
 +
                    [b_rtcp_avgjitter_mult10] =>
 +
                    [b_rtcp_avgrtd_mult10] =>
 +
                    [b_rtcp_maxrtd_mult10] =>
 +
                    [b_rtcp_avgrtd_w] =>
 +
                    [b_rtcp_maxrtd_w] =>
 +
                    [a_last_rtp_from_end] => 0
 +
                    [b_last_rtp_from_end] =>
 +
                    [a_rtcp_fraclost_pktcount] => 0
 +
                    [b_rtcp_fraclost_pktcount] =>
 +
                    [a_rtp_ptime] => 20
 +
                    [b_rtp_ptime] =>
 +
                    [payload] => 8
 +
                    [jitter_mult10] => 4
 +
                    [mos_min_mult10] => 45
 +
                    [a_mos_min_mult10] => 45
 +
                    [b_mos_min_mult10] =>
 +
                    [packet_loss_perc_mult1000] => 0
 +
                    [a_packet_loss_perc_mult1000] => 0
 +
                    [b_packet_loss_perc_mult1000] =>
 +
                    [delay_sum] => 0
 +
                    [a_delay_sum] => 0
 +
                    [b_delay_sum] =>
 +
                    [delay_avg_mult100] => 0
 +
                    [a_delay_avg_mult100] => 0
 +
                    [b_delay_avg_mult100] =>
 +
                    [delay_cnt] => 0
 +
                    [a_delay_cnt] => 0
 +
                    [b_delay_cnt] =>
 +
                    [rtcp_avgfr_mult10] => 0
 +
                    [rtcp_avgjitter_mult10] => 3
 +
                    [lost] => 0
 +
                    [caller_clipping_div3] =>
 +
                    [called_clipping_div3] =>
 +
                    [caller_silence] =>
 +
                    [called_silence] =>
 +
                    [caller_silence_end] =>
 +
                    [called_silence_end] =>
 +
                    [response_time_100] => 28
 +
                    [response_time_xxx] => 0
 +
                    [max_retransmission_invite] =>
 +
                    [flags] => 131072
 +
                    [vlan] =>
 +
                    [id_sensor] =>
 +
                    [price_operator_currency_id] =>
 +
                    [price_customer_currency_id] =>
 +
                    [rtp_stream_used_in_another_call] => 0
 +
                    [sensorname] =>
 +
                    [lastSIPresponse] => 200 Ok
 +
                    [a_ua] => Linphone Desktop/5.0.0 (BobisekNTB) Windows 10 Version 2009, Qt 5.15.2 LinphoneCore/5.2.0-2-g29c553987
 +
                    [b_ua] => Asterisk PBX 16.28.0~dfsg-0+deb10u2
 +
                    [cdr_ID] => 55
 +
                    [custom_header1] =>
 +
                    [fbasename] => xZZvFAX6YP
 +
                    [digest_username] => 11
 +
                    [match_header] =>
 +
                    [GeoPosition] =>
 +
                    [hold] =>
 +
                    [spool_index] =>
 +
                    [custom_header_1_1] =>
 +
                    [custom_header_1_2] =>
 +
                    [sipcallerip_country_code] =>
 +
                    [sipcalledip_country_code] =>
 +
                    [caller_number_country_code] =>
 +
                    [called_number_country_code] =>
 +
                    [sipcallerip_country] =>
 +
                    [sipcalledip_country] =>
 +
                    [caller_number_country] =>
 +
                    [called_number_country] =>
 +
                    [price_operator] =>
 +
                    [price_customer] => 17000000
 +
                    [a_avgjitter] => 0.4
 +
                    [b_avgjitter] =>
 +
                    [a_mos_lqo] =>
 +
                    [b_mos_lqo] =>
 +
                    [a_mos_f1_min] => 4.5
 +
                    [a_mos_f2_min] => 4.5
 +
                    [a_mos_adapt_min] => 3.9
 +
                    [a_mos_xr_min] =>
 +
                    [a_mos_silence_min] => 4.5
 +
                    [b_mos_f1_min] =>
 +
                    [b_mos_f2_min] =>
 +
                    [b_mos_adapt_min] =>
 +
                    [b_mos_xr_min] =>
 +
                    [b_mos_silence_min] =>
 +
                    [a_mos_f1] => 4.5
 +
                    [a_mos_f2] => 4.5
 +
                    [a_mos_adapt] => 4.5
 +
                    [a_mos_xr] =>
 +
                    [a_mos_silence] => 4.5
 +
                    [b_mos_f1] =>
 +
                    [b_mos_f2] =>
 +
                    [b_mos_adapt] =>
 +
                    [b_mos_xr] =>
 +
                    [b_mos_silence] =>
 +
                    [a_rtcp_avgfr] => 0
 +
                    [a_rtcp_avgjitter] => 0.3
 +
                    [a_rtcp_avgrtd] =>
 +
                    [a_rtcp_maxrtd] =>
 +
                    [b_rtcp_avgfr] =>
 +
                    [b_rtcp_avgjitter] =>
 +
                    [b_rtcp_avgrtd] =>
 +
                    [b_rtcp_maxrtd] =>
 +
                    [jitter] => 0.4
 +
                    [mos_min] => 4.5
 +
                    [a_mos_min] => 4.5
 +
                    [b_mos_min] =>
 +
                    [packet_loss_perc] => 0
 +
                    [a_packet_loss_perc] => 0
 +
                    [b_packet_loss_perc] =>
 +
                    [delay_avg] => 0
 +
                    [a_delay_avg] => 0
 +
                    [b_delay_avg] =>
 +
                    [rtcp_avgfr] => 0
 +
                    [rtcp_avgjitter] => 0.3
 +
                    [_duration] => 1015
 +
                    [_connect_duration] => 1000
 +
                    [_sql_calldate] => 2023-05-12 16:33:17
 +
                    [calldate_userformat] => 2023-05-12 16:33:17
 +
                    [calldate2] => 2023-05-12&lt;br&gt;16:33:17
 +
                    [callend_userformat] => 2023-05-12 16:50:12
 +
                    [calldate2e] => 2023-05-12&lt;br&gt;16:33:17&lt;br&gt;<span style="color: grey;">16:50:12</span>
 +
                    [duration2] => <div style="text-align: left; margin-left: 4px;">16:55<span data-qtip="Post Dial Delay (PDD) is experienced by the customer originating the call from the time the final digit is dialled to the point at which they hear ring tone or other in-band information. Where the originating network is required to play an announcement before completing the call then this definition of PDD excludes the duration of such announcements." data-dismissDelay=10000 style="font-size: 9; color: green;">&nbsp(0)</span>&lt;br&gt;16:40<br>G.711a</div>
 +
                    [caller_icon_hanged] =>
 +
                    [called_icon_hanged] => <img src="images/icon/hangup8.gif"/>
 +
                    [lastresponse] => 200&lt;br&gt;200 Ok
 +
                    [callerrtp] => 192.168.88.174
 +
                    [sipcaller_host] =>
 +
                    [sipcaller_host_color] =>
 +
                    [sipcalled_host] =>
 +
                    [sipcalled_host_color] =>
 +
                    [callerrtp_host] =>
 +
                    [callerrtp_host_color] =>
 +
                    [caller_with_domain] => 11@<span panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).setFilterFromIpOrClipboard('192.168.88.199', 'domip');" style="cursor: pointer;">192.168.88.199</span>
 +
                    [called_with_domain] => 34567654567865@<span panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).setFilterFromIpOrClipboard('192.168.88.199', 'domip');" style="cursor: pointer;">192.168.88.199</span>
 +
                    [sipcalleripMenu] => <span panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).setFilterFromIpOrClipboard('192.168.88.174', 'ip');" style="cursor: pointer;">192.168.88.174</span>
 +
                    [sipcalledipMenu] => <span panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).setFilterFromIpOrClipboard('192.168.88.199', 'ip');" style="cursor: pointer;">192.168.88.199</span>
 +
                    [caller2] => 11@<span panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).setFilterFromIpOrClipboard('192.168.88.199', 'domip');" style="cursor: pointer;">192.168.88.199</span>&lt;br&gt;<i style="color: grey;">callername is empty</i> (11)&lt;br&gt;<font color=""><span panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).setFilterFromIpOrClipboard('192.168.88.174', 'ip');" style="cursor: pointer;">192.168.88.174</span></font> : 5060<br>Linphone Desktop/5.0.0 (BobisekNTB) Windows 10 Version 2009, Qt 5.15.2 LinphoneCore/5.2.0-2-g29c553987
 +
                    [called2] => 34567654567865@<span panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).setFilterFromIpOrClipboard('192.168.88.199', 'domip');" style="cursor: pointer;">192.168.88.199</span><img src="images/icon/hangup8.gif"/>&lt;br&gt;<font color=""><span panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).setFilterFromIpOrClipboard('192.168.88.199', 'ip');" style="cursor: pointer;">192.168.88.199</span></font> : 5060&lt;br&gt;Asterisk PBX 16.28.0~dfsg-0+deb10u2
 +
                    [sipcallerip2] => <font color="">192.168.88.174</font>&lt;br&gt;
 +
                    [sipcalledip2] => <font color="">192.168.88.199</font>&lt;br&gt;
 +
                    [ringing_time] => 15
 +
                    [sipresponse] => 200 Ok
 +
                    [a_codec] => G.711a
 +
                    [b_codec] =>
 +
                    [fbasename_orig] => xZZvFAX6YP
 +
                    [menu] => <table style="margin-left: auto; margin-bottom: 1; border: none; border-collapse: collapse; padding: 0; margin: 0;"><tr><td style="width:55px;font-size:11;padding-right:2px; "><span class="pcap-download" cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doDownloadPcap(this.attributes.cdr_id.nodeValue, false, false, event);" onmouseover="this.style.cursor='pointer';"><a>PCAP</a></span></td><td style="width:16px;"><div data-qtip="PCAP" class="pcap-download" cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doDownloadPcap(this.attributes.cdr_id.nodeValue, false, false, event);" onmouseover="this.style.cursor='pointer';"><img src="images/icon/disk.png"/></div</td><td style="width:19px; padding-left: 3px;"><div class="share-cdr" cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doShareCdrSipRtp(this.attributes.cdr_id.nodeValue, false, event);" onmouseover="this.style.cursor='pointer';"><img src="images/icon/link.png"/></div</td><td style="width:19px; padding-left: 3px;"><div data-qtip="Preserve PCAP/RTP graphs in Safe Spool" class="copy-safespool" cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doCopyPcapToSafeSpool(this.attributes.cdr_id.nodeValue, false, event);" onmouseover="this.style.cursor='pointer';"><img src="images/icon/lock.png"/></div</td></tr></table><table style="margin-left: auto; margin-bottom: 1; border: none; border-collapse: collapse; padding: 0; margin: 0;"><tr><td style="width:55px;font-size:11;padding-right:2px; "><span class="wav-download" cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doDownloadOgg(this.attributes.cdr_id.nodeValue, false, false, event);" onmouseover="this.style.cursor='pointer';"><a>OGG</a></span>&nbsp;<span class="wav-download" cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doDownloadWav(this.attributes.cdr_id.nodeValue, false, false, event);" onmouseover="this.style.cursor='pointer';"><a>WAV</a></span></td><td style="width:16px;"><div  class="wav-download" cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doDownloadSound(this.attributes.cdr_id.nodeValue, false, false, event);" onmouseover="this.style.cursor='pointer';"><img src="images/icon/sound.png"/></div</td><td style="width:19px; padding-left: 3px;"></td><td style="width:19px; padding-left: 3px;"></td></tr></table><div class="wav-player-png" style="padding-top: 3px; text-align: left;"><img src="images/wav-player.png" width=80 height=10 cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doPlayWavPlayer(this.attributes.cdr_id.nodeValue,false,false,event);" onmouseover="this.style.cursor='pointer';"></div>
 +
                    [menu_pcap] => <table style="margin-left: auto; margin-bottom: 1; border: none; border-collapse: collapse; padding: 0; margin: 0;"><tr><td style="width:55px;font-size:11;padding-right:2px; "><span class="pcap-download" cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doDownloadPcap(this.attributes.cdr_id.nodeValue, false, false, event);" onmouseover="this.style.cursor='pointer';"><a>PCAP</a></span></td><td style="width:16px;"><div data-qtip="PCAP" class="pcap-download" cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doDownloadPcap(this.attributes.cdr_id.nodeValue, false, false, event);" onmouseover="this.style.cursor='pointer';"><img src="images/icon/disk.png"/></div</td><td style="width:19px; padding-left: 3px;"></td><td style="width:19px; padding-left: 3px;"></td></tr></table>
 +
                    [menu_wav] => <table style="margin-left: auto; margin-bottom: 1; border: none; border-collapse: collapse; padding: 0; margin: 0;"><tr><td style="width:55px;font-size:11;padding-right:2px; "><span class="wav-download" cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doDownloadOgg(this.attributes.cdr_id.nodeValue, false, false, event);" onmouseover="this.style.cursor='pointer';"><a>OGG</a></span>&nbsp;<span class="wav-download" cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doDownloadWav(this.attributes.cdr_id.nodeValue, false, false, event);" onmouseover="this.style.cursor='pointer';"><a>WAV</a></span></td><td style="width:16px;"><div  class="wav-download" cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doDownloadSound(this.attributes.cdr_id.nodeValue, false, false, event);" onmouseover="this.style.cursor='pointer';"><img src="images/icon/sound.png"/></div</td><td style="width:19px; padding-left: 3px;"></td><td style="width:19px; padding-left: 3px;"></td></tr></table>
 +
                    [embedplayer_indirect] => <div style="margin-top: 7px; margin-bottom: 3px; margin-left: 5px" class="wav-player-expand-png"><img src="images/wav-player-expand.png" width=300 height=15 cdr_id=55 panel_id=__PANEL_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doPlayWavPlayer(this.attributes.cdr_id.nodeValue,true,false,event);" onmouseover="this.style.cursor='pointer';"></div>
 +
                    [callerrtp2] => <span onclick="showGraphOrRtpAnalysis(55, 'a', 1, null, '192.168.88.174');" style="cursor: pointer;">192.168.88.174</span><br><span data-qtip="MOS score for simulated fixed jitterbuffer with max size 50ms" data-dismissDelay=10000 ><b>4.5</b></span><font color="grey">|</font><span data-qtip="MOS score for simulated fixed jitterbuffer with max size 200ms" data-dismissDelay=10000 ><b>4.5</b></span><font color="grey">|</font><span data-qtip="MOS score for adaptive jitterbuffer with max size 500ms" data-dismissDelay=10000 ><b>4.5</b></span><font color="grey">|</font><span data-qtip="MOS Silence avg" data-dismissDelay=10000 style="color: darkcyan;"><b>4.5</b></span><font color="grey">|</font><span data-qtip="MOS Silence min" data-dismissDelay=10000 style="color: darkcyan;"><b>4.5</b></span><br><span data-qtip="RTCP part (if RTCP packet was captured) shows MAX RTP jitter (J:26.3) and MAX RTCP % loss (L:72.3). RTCP in Caller column shows how called side sees the stream." data-dismissDelay=10000 >J:0.3</span>&thinsp;|&thinsp;<span data-qtip="No jitter (PDV) in RTP packets." data-dismissDelay=10000 ><font color="grey">no jitter</font></span><br><span data-qtip="No packet loss in RTP packets." data-dismissDelay=10000 ><font color="grey">no packet loss</font></span>
 +
                    [calledrtp2] => N/A
 +
                    [allrtpstreams] => [{"cdr_ID":"55","calldate":"2023-05-12 16:33:17","saddr":"192.168.88.174","sport":"7078","daddr":"192.168.88.199","dport":"14518","ssrc":"1744777213","received":"50725","loss":"0","firsttime":"0.806428","payload":"8","maxjitter_mult10":"90","index":"1","flags":"6","duration":"1014.23"}]
 +
                    [orig_allrtpstreams] => [{"cdr_ID":"55","calldate":"2023-05-12 16:33:17","saddr":"192.168.88.174","sport":"7078","daddr":"192.168.88.199","dport":"14518","ssrc":"1744777213","received":"50725","loss":"0","firsttime":"0.806428","payload":"8","maxjitter_mult10":"90","index":"1","flags":"6","duration":"1014.23"}]
 +
                    [allsiprequests] => [{"SIPrequest":"INVITE","cnt":"2"},{"SIPrequest":"ACK","cnt":"3"},{"SIPrequest":"BYE","cnt":"1"}]
 +
                    [allsipresponses] => [{"SIPresponseNum":"401","SIPresponse":"401 Unauthorized"},{"SIPresponseNum":"100","SIPresponse":"100 Trying"},{"SIPresponseNum":"183","SIPresponse":"183 Session Progress"},{"SIPresponseNum":"200","SIPresponse":"200 Ok"}]
 +
                )
  
−
<code>testCode&0x3cbr&0x3eTestCode</code>
+
        )
 +
 
 +
    [success] => 1
 +
    [_vm_version] => 250008
 +
)
 +
</code>

Revision as of 14:31, 19 May 2023

Examples

zero results

curl -X POST -k --cookie "PHPSESSID-voipmonitor=2ffd2fb6bef76dfa6f2ff3630e86cca39c8b93ee4761b2a45f9f804e321d1736" "http://192.168.88.156/voipmonitor/php/model/sql.php?task=LISTING&module=CDR&fdatefrom=2023-05-13T10:00:00&fcaller=11"

{"total":0,"results":null,"success":true,"_vm_version":250008}

Results suppressed

curl -X POST -k --cookie "PHPSESSID-voipmonitor=00d61b82469a39a21c6ce7d5a1e4129af4f3777d3cdfa81d6f652e5e807baa49" "http://192.168.88.156/voipmonitor/php/model/sql.php?task=LISTING&module=CDR&fdatefrom=2013-05-08T00:00:00&fcaller=11&suppress_results=1"

{"total":"1","success":true,"_vm_version":250008}

One result

curl -X POST -k --cookie "PHPSESSID-voipmonitor=2ffd2fb6bef76dfa6f2ff3630e86cca39c8b93ee4761b2a45f9f804e321d1736" "http://192.168.88.156/voipmonitor/php/model/sql.php?task=LISTING&module=CDR&fdatefrom=2023-05-12T10:00:00&fcaller=11"

Because the response for single CDR is json string that contains over 16k of chars, here is result after passing the string to json_decode fce with use of var_dump for printing its contents splited by fields:


( 

   [total] => 1
   [deferTotal] =>
   [results] => Array
       (
           [0] => stdClass Object
               (
                   [ID] => 55
                   [calldate] => 2023-05-12 16:33:17
                   [callend] => 2023-05-12 16:50:12
                   [duration] => 16:55
                   [connect_duration] => 16:40
                   [progress_time] => 0
                   [first_rtp_time] => 0
                   [caller] => 11
                   [caller_domain] => 192.168.88.199
                   [caller_reverse] => 11
                   [callername] =>
                   [callername_reverse] =>
                   [called] => 34567654567865
                   [called_domain] => 192.168.88.199
                   [called_reverse] => 56876545676543
                   [sipcallerip] => 192.168.88.174
                   [sipcallerport] => 5060
                   [sipcalledip] => 192.168.88.199
                   [sipcalledport] => 5060
                   [whohanged] => callee
                   [bye] => 3
                   [lastSIPresponse_id] => 1
                   [lastSIPresponseNum] => 200
                   [reason_sip_cause] =>
                   [reason_sip_text_id] =>
                   [reason_q850_cause] =>
                   [reason_q850_text_id] =>
                   [sighup] => 0
                   [dscp] => 0
                   [a_index] => 0
                   [b_index] =>
                   [a_payload] => 8
                   [b_payload] =>
                   [a_saddr] => 192.168.88.174
                   [b_saddr] =>
                   [a_received] => 50725
                   [b_received] =>
                   [a_lost] => 0
                   [b_lost] =>
                   [a_ua_id] => 3
                   [b_ua_id] => 1
                   [a_avgjitter_mult10] => 4
                   [b_avgjitter_mult10] =>
                   [a_maxjitter] => 10
                   [b_maxjitter] =>
                   [a_sl1] => 0
                   [a_sl2] => 0
                   [a_sl3] => 0
                   [a_sl4] => 0
                   [a_sl5] => 0
                   [a_sl6] => 0
                   [a_sl7] => 0
                   [a_sl8] => 0
                   [a_sl9] => 0
                   [a_sl10] => 0
                   [a_d50] => 0
                   [a_d70] => 0
                   [a_d90] => 0
                   [a_d120] => 0
                   [a_d150] => 0
                   [a_d200] => 0
                   [a_d300] => 0
                   [b_sl1] =>
                   [b_sl2] =>
                   [b_sl3] =>
                   [b_sl4] =>
                   [b_sl5] =>
                   [b_sl6] =>
                   [b_sl7] =>
                   [b_sl8] =>
                   [b_sl9] =>
                   [b_sl10] =>
                   [b_d50] =>
                   [b_d70] =>
                   [b_d90] =>
                   [b_d120] =>
                   [b_d150] =>
                   [b_d200] =>
                   [b_d300] =>
                   [a_mos_lqo_mult10] =>
                   [b_mos_lqo_mult10] =>
                   [a_mos_f1_min_mult10] => 45
                   [a_mos_f2_min_mult10] => 45
                   [a_mos_adapt_min_mult10] => 39
                   [a_mos_xr_min_mult10] =>
                   [a_mos_silence_min_mult10] => 45
                   [b_mos_f1_min_mult10] =>
                   [b_mos_f2_min_mult10] =>
                   [b_mos_adapt_min_mult10] =>
                   [b_mos_xr_min_mult10] =>
                   [b_mos_silence_min_mult10] =>
                   [a_mos_f1_mult10] => 45
                   [a_mos_f2_mult10] => 45
                   [a_mos_adapt_mult10] => 45
                   [a_mos_xr_mult10] =>
                   [a_mos_silence_mult10] => 45
                   [b_mos_f1_mult10] =>
                   [b_mos_f2_mult10] =>
                   [b_mos_adapt_mult10] =>
                   [b_mos_xr_mult10] =>
                   [b_mos_silence_mult10] =>
                   [a_rtcp_loss] => 0
                   [a_rtcp_maxfr] => 0
                   [a_rtcp_avgfr_mult10] => 0
                   [a_rtcp_maxjitter] => 1
                   [a_rtcp_avgjitter_mult10] => 3
                   [a_rtcp_avgrtd_mult10] =>
                   [a_rtcp_maxrtd_mult10] =>
                   [a_rtcp_avgrtd_w] => 1
                   [a_rtcp_maxrtd_w] => 2
                   [b_rtcp_loss] =>
                   [b_rtcp_maxfr] =>
                   [b_rtcp_avgfr_mult10] =>
                   [b_rtcp_maxjitter] =>
                   [b_rtcp_avgjitter_mult10] =>
                   [b_rtcp_avgrtd_mult10] =>
                   [b_rtcp_maxrtd_mult10] =>
                   [b_rtcp_avgrtd_w] =>
                   [b_rtcp_maxrtd_w] =>
                   [a_last_rtp_from_end] => 0
                   [b_last_rtp_from_end] =>
                   [a_rtcp_fraclost_pktcount] => 0
                   [b_rtcp_fraclost_pktcount] =>
                   [a_rtp_ptime] => 20
                   [b_rtp_ptime] =>
                   [payload] => 8
                   [jitter_mult10] => 4
                   [mos_min_mult10] => 45
                   [a_mos_min_mult10] => 45
                   [b_mos_min_mult10] =>
                   [packet_loss_perc_mult1000] => 0
                   [a_packet_loss_perc_mult1000] => 0
                   [b_packet_loss_perc_mult1000] =>
                   [delay_sum] => 0
                   [a_delay_sum] => 0
                   [b_delay_sum] =>
                   [delay_avg_mult100] => 0
                   [a_delay_avg_mult100] => 0
                   [b_delay_avg_mult100] =>
                   [delay_cnt] => 0
                   [a_delay_cnt] => 0
                   [b_delay_cnt] =>
                   [rtcp_avgfr_mult10] => 0
                   [rtcp_avgjitter_mult10] => 3
                   [lost] => 0
                   [caller_clipping_div3] =>
                   [called_clipping_div3] =>
                   [caller_silence] =>
                   [called_silence] =>
                   [caller_silence_end] =>
                   [called_silence_end] =>
                   [response_time_100] => 28
                   [response_time_xxx] => 0
                   [max_retransmission_invite] =>
                   [flags] => 131072
                   [vlan] =>
                   [id_sensor] =>
                   [price_operator_currency_id] =>
                   [price_customer_currency_id] =>
                   [rtp_stream_used_in_another_call] => 0
                   [sensorname] =>
                   [lastSIPresponse] => 200 Ok
                   [a_ua] => Linphone Desktop/5.0.0 (BobisekNTB) Windows 10 Version 2009, Qt 5.15.2 LinphoneCore/5.2.0-2-g29c553987
                   [b_ua] => Asterisk PBX 16.28.0~dfsg-0+deb10u2
                   [cdr_ID] => 55
                   [custom_header1] =>
                   [fbasename] => xZZvFAX6YP
                   [digest_username] => 11
                   [match_header] =>
                   [GeoPosition] =>
                   [hold] =>
                   [spool_index] =>
                   [custom_header_1_1] =>
                   [custom_header_1_2] =>
                   [sipcallerip_country_code] =>
                   [sipcalledip_country_code] =>
                   [caller_number_country_code] =>
                   [called_number_country_code] =>
                   [sipcallerip_country] =>
                   [sipcalledip_country] =>
                   [caller_number_country] =>
                   [called_number_country] =>
                   [price_operator] =>
                   [price_customer] => 17000000
                   [a_avgjitter] => 0.4
                   [b_avgjitter] =>
                   [a_mos_lqo] =>
                   [b_mos_lqo] =>
                   [a_mos_f1_min] => 4.5
                   [a_mos_f2_min] => 4.5
                   [a_mos_adapt_min] => 3.9
                   [a_mos_xr_min] =>
                   [a_mos_silence_min] => 4.5
                   [b_mos_f1_min] =>
                   [b_mos_f2_min] =>
                   [b_mos_adapt_min] =>
                   [b_mos_xr_min] =>
                   [b_mos_silence_min] =>
                   [a_mos_f1] => 4.5
                   [a_mos_f2] => 4.5
                   [a_mos_adapt] => 4.5
                   [a_mos_xr] =>
                   [a_mos_silence] => 4.5
                   [b_mos_f1] =>
                   [b_mos_f2] =>
                   [b_mos_adapt] =>
                   [b_mos_xr] =>
                   [b_mos_silence] =>
                   [a_rtcp_avgfr] => 0
                   [a_rtcp_avgjitter] => 0.3
                   [a_rtcp_avgrtd] =>
                   [a_rtcp_maxrtd] =>
                   [b_rtcp_avgfr] =>
                   [b_rtcp_avgjitter] =>
                   [b_rtcp_avgrtd] =>
                   [b_rtcp_maxrtd] =>
                   [jitter] => 0.4
                   [mos_min] => 4.5
                   [a_mos_min] => 4.5
                   [b_mos_min] =>
                   [packet_loss_perc] => 0
                   [a_packet_loss_perc] => 0
                   [b_packet_loss_perc] =>
                   [delay_avg] => 0
                   [a_delay_avg] => 0
                   [b_delay_avg] =>
                   [rtcp_avgfr] => 0
                   [rtcp_avgjitter] => 0.3
                   [_duration] => 1015
                   [_connect_duration] => 1000
                   [_sql_calldate] => 2023-05-12 16:33:17
                   [calldate_userformat] => 2023-05-12 16:33:17
                   [calldate2] => 2023-05-12<br>16:33:17
                   [callend_userformat] => 2023-05-12 16:50:12
                   [calldate2e] => 2023-05-12<br>16:33:17<br>16:50:12

[duration2] =>

16:55&nbsp(0)<br>16:40
G.711a
                   [caller_icon_hanged] =>
                   [called_icon_hanged] => <img src="images/icon/hangup8.gif"/>
                   [lastresponse] => 200<br>200 Ok
                   [callerrtp] => 192.168.88.174
                   [sipcaller_host] =>
                   [sipcaller_host_color] =>
                   [sipcalled_host] =>
                   [sipcalled_host_color] =>
                   [callerrtp_host] =>
                   [callerrtp_host_color] =>
                   [caller_with_domain] => 11@192.168.88.199
                   [called_with_domain] => 34567654567865@192.168.88.199
                   [sipcalleripMenu] => 192.168.88.174
                   [sipcalledipMenu] => 192.168.88.199
                   [caller2] => 11@192.168.88.199<br>callername is empty (11)<br>192.168.88.174 : 5060
Linphone Desktop/5.0.0 (BobisekNTB) Windows 10 Version 2009, Qt 5.15.2 LinphoneCore/5.2.0-2-g29c553987
                   [called2] => 34567654567865@192.168.88.199<img src="images/icon/hangup8.gif"/><br>192.168.88.199 : 5060<br>Asterisk PBX 16.28.0~dfsg-0+deb10u2
                   [sipcallerip2] => 192.168.88.174<br>
                   [sipcalledip2] => 192.168.88.199<br>
                   [ringing_time] => 15
                   [sipresponse] => 200 Ok
                   [a_codec] => G.711a
                   [b_codec] =>
                   [fbasename_orig] => xZZvFAX6YP

[menu] =>

<a>PCAP</a>
<img src="images/icon/disk.png"/></div
<img src="images/icon/lock.png"/></div
<a>OGG</a> <a>WAV</a>
<img src="images/icon/sound.png"/></div
<img src="images/wav-player.png" width=80 height=10 cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doPlayWavPlayer(this.attributes.cdr_id.nodeValue,false,false,event);" onmouseover="this.style.cursor='pointer';">

[menu_pcap] =>

<a>PCAP</a>
<img src="images/icon/disk.png"/></div

[menu_wav] =>

<a>OGG</a> <a>WAV</a>
<img src="images/icon/sound.png"/></div

[embedplayer_indirect] =>

<img src="images/wav-player-expand.png" width=300 height=15 cdr_id=55 panel_id=__PANEL_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doPlayWavPlayer(this.attributes.cdr_id.nodeValue,true,false,event);" onmouseover="this.style.cursor='pointer';">
                   [callerrtp2] => 192.168.88.174
4.5|4.5|4.5|4.5|4.5
J:0.3 | no jitter
no packet loss
                   [calledrtp2] => N/A
                   [allrtpstreams] => [{"cdr_ID":"55","calldate":"2023-05-12 16:33:17","saddr":"192.168.88.174","sport":"7078","daddr":"192.168.88.199","dport":"14518","ssrc":"1744777213","received":"50725","loss":"0","firsttime":"0.806428","payload":"8","maxjitter_mult10":"90","index":"1","flags":"6","duration":"1014.23"}]
                   [orig_allrtpstreams] => [{"cdr_ID":"55","calldate":"2023-05-12 16:33:17","saddr":"192.168.88.174","sport":"7078","daddr":"192.168.88.199","dport":"14518","ssrc":"1744777213","received":"50725","loss":"0","firsttime":"0.806428","payload":"8","maxjitter_mult10":"90","index":"1","flags":"6","duration":"1014.23"}]
                   [allsiprequests] => [{"SIPrequest":"INVITE","cnt":"2"},{"SIPrequest":"ACK","cnt":"3"},{"SIPrequest":"BYE","cnt":"1"}]
                   [allsipresponses] => [{"SIPresponseNum":"401","SIPresponse":"401 Unauthorized"},{"SIPresponseNum":"100","SIPresponse":"100 Trying"},{"SIPresponseNum":"183","SIPresponse":"183 Session Progress"},{"SIPresponseNum":"200","SIPresponse":"200 Ok"}]
               )

       )

   [success] => 1
   [_vm_version] => 250008

)

Retrieved from "https://www.voipmonitor.org//doc/index.php?title=Output_of_the_API_LISTING_task&oldid=4402"