Contribution - Vicidial Outbound Report v2.0

Discussions about development of VICIDIAL and astGUIclient

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

Contribution - Vicidial Outbound Report v2.0

Postby chrism » Sun May 15, 2011 2:47 am

Hi All,

I've been a huge fan of open source for many years now and have been using Vicidial for a couple of years. We needed a report that would give the leads that had 'ASETs' but showed the call pattern of how each caller would make calls. I'm just hoping this can help others as much as it has helped us get a better grasp of how our callers are making calls from day-to-day (and even week-to-week).

This is version 2.0 because version 1.0 was used for the last 3 months in-house to be customized to our own needs. Therefore, it has been pretty well tested already. However, any suggestions or contributions are always appreciated.

Screenshot:

Image

>>Link to Download<<

Like to have:

For those of you that like to dabble with the code a bit, you'll notice that I was trying to put in some 'hover' code in the tables to allow more data to be presented to the user on each of the cells. After debugging it for several hours, I couldn't get it to work, so I just commented out the code. I'd love to see if anyone can modify this current report to allow a mouse-over to quickly show statistics for each call directly inside of the table that gives a quick context of what is going on. Perhaps even some unique symbols or something.

Please post any questions or suggestions on this thread. Thanks!
chrism
 
Posts: 93
Joined: Mon Jan 26, 2009 10:02 am

Postby mflorell » Sun May 15, 2011 8:27 am

Wow, that's pretty cool!

I do have some suggestions if you are open to them:
- Make "ASET" a variable you could configure
- Change $vicidial_url be an optional variable(since you can get the admin path from the system_settings)
- You use standard HTTP authentication, but your comments say cookies are required, and I couldn't find anywhere cookies are being set?
- You should put a copyright notice and an email address for yourself
- I ran against some sample data and got the following two warnings:

Warning: Invalid argument supplied for foreach() in /usr/local/apache2/htdocs/vicidial/vicidial_outbound_report.php on line 692

Warning: Invalid argument supplied for foreach() in /usr/local/apache2/htdocs/vicidial/vicidial_outbound_report.php on line 720


Thanks again for posting this!
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

thanks

Postby brett05 » Sun May 15, 2011 12:29 pm

can you please explain me the color in call patern ?
Jasperreports & Queuemetrics & SugarCRM integration - Customization and Add-ons
Freepbx||Billing||Centos||Opensuse||Debian||Centos||Fedora||Sangoma||Diguim
brett05
 
Posts: 571
Joined: Sun May 24, 2009 5:48 pm
Location: tunisia

Postby chrism » Sun May 15, 2011 10:29 pm

Under 10 calls = red
between 11 and 20 calls = orange
21+ calls = blue

I'm open for suggestions on alternative implementations. The colors just make it easier to visualize the calls per hour.
chrism
 
Posts: 93
Joined: Mon Jan 26, 2009 10:02 am

Postby KDell » Wed May 18, 2011 10:36 am

Is it possible to expand this to also show disposition codes per hour? That would rock!
Multi Server Set Up (3 Asterisk/1 SQL) | VERSION: 2.4-290 | BUILD: 101127-2232 | Asterisk - 1.4.21.2-vici | Ubuntu 8.04 LTS | No Digium/Sangoma Hardware | No Extra Software After Installation
G729 via Digium | 80 seats
KDell
 
Posts: 129
Joined: Tue Sep 21, 2010 6:16 pm

Postby chrism » Wed May 18, 2011 4:41 pm

Yeah, shouldn't be a problem. Just need some help with the javascript 'hover' code on the cells to provide those kind of details. I haven't really had a chance to dive into it yet.
chrism
 
Posts: 93
Joined: Mon Jan 26, 2009 10:02 am

Postby KDell » Thu May 19, 2011 10:11 am

This is super awesome! I'm excited to see what this can do fully up and runing!
Multi Server Set Up (3 Asterisk/1 SQL) | VERSION: 2.4-290 | BUILD: 101127-2232 | Asterisk - 1.4.21.2-vici | Ubuntu 8.04 LTS | No Digium/Sangoma Hardware | No Extra Software After Installation
G729 via Digium | 80 seats
KDell
 
Posts: 129
Joined: Tue Sep 21, 2010 6:16 pm

Postby chrism » Thu May 19, 2011 7:16 pm

Would love to hear if anyone is using it and able to successfully install.
chrism
 
Posts: 93
Joined: Mon Jan 26, 2009 10:02 am

Postby KDell » Fri May 20, 2011 9:48 am

We've added it in, it throws up a couple of little errors:

Warning: Invalid argument supplied for foreach() in /var/www/vicidial/vicidial_outbound_report.php on line 692

Warning: Invalid argument supplied for foreach() in /var/www/vicidial/vicidial_outbound_report.php on line 720
Multi Server Set Up (3 Asterisk/1 SQL) | VERSION: 2.4-290 | BUILD: 101127-2232 | Asterisk - 1.4.21.2-vici | Ubuntu 8.04 LTS | No Digium/Sangoma Hardware | No Extra Software After Installation
G729 via Digium | 80 seats
KDell
 
Posts: 129
Joined: Tue Sep 21, 2010 6:16 pm

Postby chrism » Fri May 20, 2011 1:02 pm

hrmmm...

Line 692:

Code: Select all
foreach($display_campaigns[$user_key_id]['call_times'] as $call_time){


That is a loop to iterate through all of the call times for that particular user. Do you have a user that did calls, but didn't actually register any?

Hrmm... without actually seeing the error running and having the data to debug it with, I'm not sure what else to say.
chrism
 
Posts: 93
Joined: Mon Jan 26, 2009 10:02 am

Postby KDell » Fri May 20, 2011 3:14 pm

Could it have anything to do with manual calls or even monitoring? If so, was probably me - otherwise I can do a little research on it tonight - we've got about 65 agents running today.

The error does not show up after selecting variables in the meu at the top - if I select a random user or a new date range, this goes away.
Multi Server Set Up (3 Asterisk/1 SQL) | VERSION: 2.4-290 | BUILD: 101127-2232 | Asterisk - 1.4.21.2-vici | Ubuntu 8.04 LTS | No Digium/Sangoma Hardware | No Extra Software After Installation
G729 via Digium | 80 seats
KDell
 
Posts: 129
Joined: Tue Sep 21, 2010 6:16 pm


Return to Development

Who is online

Users browsing this forum: No registered users and 172 guests