How to know which trunk is used in real time reports?

Discussions about development of VICIDIAL and astGUIclient

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

How to know which trunk is used in real time reports?

Postby DarknessBBB » Fri Jun 08, 2012 5:54 am

Hello there!
I would like to add a column in the real time reports that show which trunk is used for that call, (the same info that the agents view on their screen near the logout button). Is this info featchable in any db table?
DarknessBBB
 
Posts: 328
Joined: Mon Jul 16, 2007 10:14 am

Re: How to know which trunk is used in real time reports?

Postby mflorell » Fri Jun 08, 2012 8:32 am

vicidial_auto_calls
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: How to know which trunk is used in real time reports?

Postby DarknessBBB » Fri Jun 08, 2012 9:24 am

Thank you very much matt, hopefully I'll post the patch in the tracker asap
DarknessBBB
 
Posts: 328
Joined: Mon Jul 16, 2007 10:14 am

Re: How to know which trunk is used in real time reports?

Postby DarknessBBB » Tue Jun 12, 2012 5:23 am

I've written down a little bit of code, this is the result:

Image

I'm wondering how to show the channels used by the agents that make manual calls (callbacks,etc). I can't find a way to select the field "channel" from vicidial_auto_calls modifying this query:
Code: Select all
select
vicidial_live_agents.extension,
vicidial_live_agents.user,
conf_exten,
vicidial_live_agents.status,
vicidial_live_agents.server_ip,
UNIX_TIMESTAMP(last_call_time),
UNIX_TIMESTAMP(last_call_finish),
call_server_ip,
vicidial_live_agents.campaign_id,
vicidial_users.user_group,
vicidial_users.full_name,
vicidial_live_agents.comments,
vicidial_live_agents.calls_today,
vicidial_live_agents.callerid,
vicidial_live_agents.lead_id,
UNIX_TIMESTAMP(last_state_change),
on_hook_agent,
ring_callerid,
agent_log_id,
vicidial_auto_calls.channel
from vicidial_live_agents,vicidial_users,vicidial_auto_calls
where vicidial_live_agents.user=vicidial_users.user and
vicidial_auto_calls.lead_id = vicidial_live_agents.lead_id and
vicidial_live_agents.campaign_id IN('201','301','501','801','911','') // "just my campaigns"
order by vicidial_live_agents.status,last_call_time
DarknessBBB
 
Posts: 328
Joined: Mon Jul 16, 2007 10:14 am

Re: How to know which trunk is used in real time reports?

Postby DarknessBBB » Wed Jun 13, 2012 4:39 am

SOLVED! Here is the patch
Code: Select all
--- AST_timeonVDADall.php   2011-11-30 11:32:33.000000000 +0100
+++ AST_timeonVDADall.php   2012-06-12 15:41:42.000000000 +0200
@@ -2107,8 +2107,10 @@
 $HTcalls =         " CALLS |";
 $HDpause =   '';
 $HTpause =   '';
-$HDigcall =         "------+------------------";
-$HTigcall =         " HOLD | IN-GROUP ";
+$HDigcall =         "------+------------------+";
+$HTigcall =         " HOLD | IN-GROUP         |";
+$HDchannel =      "-----------+";
+$HTchannel =       "  CHANNEL  |";
 
 if (!ereg("N",$agent_pause_codes_active))
    {
@@ -2153,13 +2155,13 @@
 
 if ($realtime_block_user_info > 0)
    {
-   $Aline  = "$HDbegin$HDusergroup$HDsessionid$HDbarge$HDstatus$HDpause$HDcustphone$HDserver_ip$HDcall_server_ip$HDtime$HDcampaign$HDcalls$HDigcall\n";
-   $Bline  = "$HTbegin$HTusergroup$HTsessionid$HTbarge$HTstatus$HTpause$HTcustphone$HTserver_ip$HTcall_server_ip$HTtime$HTcampaign$HTcalls$HTigcall\n";
+   $Aline  = "$HDbegin$HDusergroup$HDsessionid$HDbarge$HDstatus$HDpause$HDcustphone$HDserver_ip$HDcall_server_ip$HDtime$HDcampaign$HDcalls$HDigcall$HDchannel\n";
+   $Bline  = "$HTbegin$HTusergroup$HTsessionid$HTbarge$HTstatus$HTpause$HTcustphone$HTserver_ip$HTcall_server_ip$HTtime$HTcampaign$HTcalls$HTigcall$HTchannel\n";
    }
 else
    {
-   $Aline  = "$HDbegin$HDstation$HDphone$HDuser$HDusergroup$HDsessionid$HDbarge$HDstatus$HDpause$HDcustphone$HDserver_ip$HDcall_server_ip$HDtime$HDcampaign$HDcalls$HDigcall\n";
-   $Bline  = "$HTbegin$HTstation$HTphone$HTuser$HTusergroup$HTsessionid$HTbarge$HTstatus$HTpause$HTcustphone$HTserver_ip$HTcall_server_ip$HTtime$HTcampaign$HTcalls$HTigcall\n";
+   $Aline  = "$HDbegin$HDstation$HDphone$HDuser$HDusergroup$HDsessionid$HDbarge$HDstatus$HDpause$HDcustphone$HDserver_ip$HDcall_server_ip$HDtime$HDcampaign$HDcalls$HDigcall$HDchannel\n";
+   $Bline  = "$HTbegin$HTstation$HTphone$HTuser$HTusergroup$HTsessionid$HTbarge$HTstatus$HTpause$HTcustphone$HTserver_ip$HTcall_server_ip$HTtime$HTcampaign$HTcalls$HTigcall$HTchannel\n";
    }
 $Aecho .= "$Aline";
 $Aecho .= "$Bline";
@@ -2190,7 +2192,7 @@
 else {$usergroupSQL = " and user_group='" . mysql_real_escape_string($usergroup) . "'";}
 
 $ring_agents=0;
-$stmt="select extension,vicidial_live_agents.user,conf_exten,vicidial_live_agents.status,vicidial_live_agents.server_ip,UNIX_TIMESTAMP(last_call_time),UNIX_TIMESTAMP(last_call_finish),call_server_ip,vicidial_live_agents.campaign_id,vicidial_users.user_group,vicidial_users.full_name,vicidial_live_agents.comments,vicidial_live_agents.calls_today,vicidial_live_agents.callerid,lead_id,UNIX_TIMESTAMP(last_state_change),on_hook_agent,ring_callerid,agent_log_id from vicidial_live_agents,vicidial_users where vicidial_live_agents.user=vicidial_users.user $UgroupSQL $usergroupSQL order by $orderSQL;";
+$stmt="select extension,vicidial_live_agents.user,conf_exten,vicidial_live_agents.status,vicidial_live_agents.server_ip,UNIX_TIMESTAMP(last_call_time),UNIX_TIMESTAMP(last_call_finish),call_server_ip,vicidial_live_agents.campaign_id,vicidial_users.user_group,vicidial_users.full_name,vicidial_live_agents.comments,vicidial_live_agents.calls_today,vicidial_live_agents.callerid,lead_id,UNIX_TIMESTAMP(last_state_change),on_hook_agent,ring_callerid,agent_log_id, channel from vicidial_live_agents,vicidial_users where vicidial_live_agents.user=vicidial_users.user $UgroupSQL $usergroupSQL order by $orderSQL;";
 $rslt=mysql_query($stmt, $link);
 if ($DB) {echo "$stmt\n";}
 $talking_to_print = mysql_num_rows($rslt);
@@ -2220,6 +2222,17 @@
       $Aon_hook_agent[$i] =   $row[16];
       $Aring_callerid[$i] =   $row[17];
       $Aagent_log_id[$i] =   $row[18];
+      $Acall_channel[$i] =    $row[19];
+      
+      if ($Alead_id[$i] <> '0')
+      {
+         $sql_channel = "SELECT `channel` FROM `vicidial_auto_calls` WHERE `lead_id` = '" . $Alead_id[$i] . "';";
+         if ($DB) {echo "$sql_channel\n";}
+         $rslt_channel=mysql_query($sql_channel, $link);
+         $row_channel=mysql_fetch_row($rslt_channel);
+         $Acall_channel[$i] =   $row_channel[0];
+      }
+      
       $Aring_note[$i] =      ' ';
 
       if ($Aon_hook_agent[$i] == 'Y')
@@ -2409,6 +2422,7 @@
       $campaign_id =   sprintf("%-10s", $Acampaign_id[$i]);
       $comments=      $Acomments[$i];
       $calls_today =   sprintf("%-5s", $Acalls_today[$i]);
+      $call_channel  = substr($Acall_channel[$i],0,strpos($Acall_channel[$i],"-"));
 
       if (!ereg("N",$agent_pause_codes_active))
          {$pausecode='       ';}
@@ -2610,16 +2624,20 @@
 
          $INGRP = " $G$vac_stage$EG | $G$vac_campaign$EG ";
          }
+      else
+         {
+         $INGRP = "                        ";
+         }
 
       $agentcount++;
 
       if ($realtime_block_user_info > 0)
          {
-         $Aecho .= "|$UGD $G$sessionid$EG$L$R$Aring_note[$i]| $G$status$EG $CM $pausecode|$CP$SVD$G$call_time_MS$EG | $G$campaign_id$EG | $G$calls_today$EG |$INGRP\n";
+         $Aecho .= "|$UGD $G$sessionid$EG$L$R$Aring_note[$i]| $G$status$EG $CM $pausecode|$CP$SVD$G$call_time_MS$EG | $G$campaign_id$EG | $G$calls_today$EG |$INGRP | $G$call_channel$EG\n";
          }
       if ($realtime_block_user_info < 1)
          {
-         $Aecho .= "| $G$extension$EG$Aring_note[$i]|$phoneD<a href=\"./user_status.php?user=$Luser\" target=\"_blank\">$G$user$EG</a> <a href=\"javascript:ingroup_info('$Luser','$j');\">+</a> |$UGD $G$sessionid$EG$L$R | $G$status$EG $CM $pausecode|$CP$SVD$G$call_time_MS$EG | $G$campaign_id$EG | $G$calls_today$EG |$INGRP\n";
+         $Aecho .= "| $G$extension$EG$Aring_note[$i]|$phoneD<a href=\"./user_status.php?user=$Luser\" target=\"_blank\">$G$user$EG</a> <a href=\"javascript:ingroup_info('$Luser','$j');\">+</a> |$UGD $G$sessionid$EG$L$R | $G$status$EG $CM $pausecode|$CP$SVD$G$call_time_MS$EG | $G$campaign_id$EG | $G$calls_today$EG |$INGRP | $G$call_channel$EG\n";
          }
       $j++;
       }



Can, please, anyone test it?
Last edited by DarknessBBB on Wed Jun 13, 2012 6:25 am, edited 2 times in total.
DarknessBBB
 
Posts: 328
Joined: Mon Jul 16, 2007 10:14 am

Re: How to know which trunk is used in real time reports?

Postby DomeDan » Wed Jun 13, 2012 6:16 am

Testing:
Code: Select all
patching file AST_timeonVDADall.php
Hunk #1 FAILED at 2107.
Hunk #2 FAILED at 2153.
Hunk #3 FAILED at 2190.
Hunk #4 FAILED at 2220.
Hunk #5 FAILED at 2409.
Hunk #6 FAILED at 2610.
6 out of 6 hunks FAILED -- saving rejects to file AST_timeonVDADall.php.rej


tried to patch:
$version = '2.4-67';
$build = '120223-1934';

make a patch using "diff -u" instead and write down the build of your AST_timeonVDADall.php
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: How to know which trunk is used in real time reports?

Postby DarknessBBB » Wed Jun 13, 2012 6:26 am

I've edited the post with the patch.
$version = '2.4-66';
$build = '111103-1220';
DarknessBBB
 
Posts: 328
Joined: Mon Jul 16, 2007 10:14 am

Re: How to know which trunk is used in real time reports?

Postby DomeDan » Wed Jun 13, 2012 7:02 am

$version = '2.4-66';
$build = '111103-1220';
Failed.
but now i know why,
its because tab is used in the code, and that is converted to space, you need to upload it as a file to keep the tabs
use the issue tracker

I recommend you download the latest trunk and work with that instead too
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: How to know which trunk is used in real time reports?

Postby DarknessBBB » Wed Jun 13, 2012 7:08 am

My fault, here is the file

https://docs.google.com/open?id=0BzL_tQ ... zRuT3pabFk

Right now I cannot use the latest trunk (it's a production server), I hope to do the upgrade this weekend.
DarknessBBB
 
Posts: 328
Joined: Mon Jul 16, 2007 10:14 am

Re: How to know which trunk is used in real time reports?

Postby DomeDan » Wed Jun 13, 2012 7:44 am

I could even patch $build = '120223-1934';

patching file AST_timeonVDADall.php
Hunk #1 succeeded at 2254 (offset 147 lines).
Hunk #2 succeeded at 2302 (offset 147 lines).
Hunk #3 FAILED at 2192.
Hunk #4 succeeded at 2372 (offset 150 lines).
Hunk #5 succeeded at 2572 (offset 150 lines).
Hunk #6 succeeded at 2774 (offset 150 lines).
1 out of 6 hunks FAILED -- saving rejects to file AST_timeonVDADall.php.rej

if i change this in the patch by hand:
Code: Select all
-$stmt="select extension,vicidial_live_agents.user,conf_exten,vicidial_live_agents.status,vicidial_live_agents.server_ip,UNIX_TIMESTAMP(last_call_time),UNIX_TIMESTAMP(last_call_finish),call_server_ip,vicidial_live_agents.campaign_id,vicidial_users.user_group,vicidial_users.full_name,vicidial_live_agents.comments,vicidial_live_agents.calls_today,vicidial_live_agents.callerid,lead_id,UNIX_TIMESTAMP(last_state_change),on_hook_agent,ring_callerid,agent_log_id from vicidial_live_agents,vicidial_users where vicidial_live_agents.user=vicidial_users.user $UgroupSQL $usergroupSQL order by $orderSQL;";

-$stmt="select extension,vicidial_live_agents.user,conf_exten,vicidial_live_agents.status,vicidial_live_agents.server_ip,UNIX_TIMESTAMP(last_call_time),UNIX_TIMESTAMP(last_call_finish),call_server_ip,vicidial_live_agents.campaign_id,vicidial_users.user_group,vicidial_users.full_name,vicidial_live_agents.comments,vicidial_live_agents.calls_today,vicidial_live_agents.callerid,lead_id,UNIX_TIMESTAMP(last_state_change),on_hook_agent,ring_callerid,agent_log_id from vicidial_live_agents,vicidial_users where vicidial_live_agents.user=vicidial_users.user $UgroupSQL $usergroupSQL $user_group_filter_SQL order by $orderSQL;";


patching file AST_timeonVDADall.php
Hunk #1 succeeded at 2254 (offset 147 lines).
Hunk #2 succeeded at 2302 (offset 147 lines).
Hunk #3 succeeded at 2342 with fuzz 1 (offset 150 lines).
Hunk #4 succeeded at 2372 (offset 150 lines).
Hunk #5 succeeded at 2572 (offset 150 lines).
Hunk #6 succeeded at 2774 (offset 150 lines).

doesn't look so good but yeah sure it works, both manual and auto
Code: Select all
VICIDIAL: Agents Time On Calls Campaign: |ALL-ACTIVE|            2012-06-13 14:35:42
+----------------+------------------------+-----------+----------+---------+------------+-------+------+------------------+-----------+
| STATION        | USER  SHOW ID     INFO | SESSIONID | STATUS   | MM:SS   | CAMPAIGN   | CALLS | HOLD | IN-GROUP         |  CHANNEL  |
+----------------+------------------------+-----------+----------+---------+------------+-------+------+------------------+-----------+
| SIP/151a       | asdf asd             + | 8600052   | READY    |    0:49 | as_dfgh    | 166   |                         |
| SIP/152a       | asdfghjk asdfgh      + | 8600051   | INCALL A |    2:19 | as_dfgh    | 136   |                         | SIP/asdfghjklzxc
| SIP/201e       | asdf g               + | 8600053   | PAUSED   |    5:44 | as_df      | 0     |                         |
+----------------+------------------------+-----------+----------+---------+------------+-------+------+------------------+-----------+
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: How to know which trunk is used in real time reports?

Postby sofcall » Sat Jun 23, 2012 7:40 pm

hi.
Need this patch.can you show us how to patch it(to use it?)(for a a newbie)
Thank you.
Goautodial CE 2.1/Vicidial version 2.4-309a
build:110430-1642/asterisk 1.4.39.1
Single server (IBM E-SERVER - 2 Cpu /Intel Xeon 2.6 GHz quad core(Processors:4)
Ram 4 Go DDR SDRAM - ECC
3 Mega upload and download
no extra hardware.
Webmin as an addons.
sofcall
 
Posts: 110
Joined: Wed Feb 02, 2011 4:49 am
Location: Morocco


Return to Development

Who is online

Users browsing this forum: No registered users and 32 guests