Succefull Calls to list!

[GDelkos]

Hi there

i would like to know if there is a way to access the succefull calls for the current day(sales) from mysql!

thank you in advance!

[DomeDan]

Yes

Code: Select all

SELECT * FROM vicidial_list WHERE status = 'SALE' and DATE(last_local_call_time) = CURDATE()

But I would recommend you use the vicidial reports like "Export Calls Report" and "Export Leads Report"

[GDelkos]

i am trying to make a small program based on csharp so i can have everydays reports on the go!
thanks for the point!

[GDelkos]

yes that would return the lead number and some other stats but it wont return the agent that made the sale!
is there anyway to get the agent name that did the sale?
thank you in advance!

[DomeDan]

thats in the vicidial_log table, you should look around in the database there is lots of useful tables there

[GDelkos]

"SELECT * FROM vicidial_log WHERE status = 'SALE' and DATE( call_date) = CURDATE()";

i am trying to get something like that dosent seem to work though!
any help would be much loved!

thank you so much for your help!

[DomeDan]

if there was a SALE today then you would probably see it with that query.

use phpmyadmin to explore the database and debug when you are writing your reporting-programs