by omarrodriguezt » Tue Mar 19, 2013 12:00 pm
Hello,
How can we avoid that the inbound calls alters the vicidial_list table and change the disposition to a complete lead?
This is the scenario:
1st - We call the customer at 1pm, he was not able to pickup the call. The dialer set the disposition as NA (No answer), so, we can call again the lead. We are recycling NA status
2nd - We call the customer at 6 pm, he pickup the phone and we made the sale. The dialer set the disposition as SALE. We can not call again the customer, because we are not recycling the status SALE
3rd - At 8pm, same day. the customer saw a missed call from 1pm, he call back to our inbound number, but nobody is available to take his call, and the dialer change the disposition from SALE to DROP. (DROP is a disposition that we are recycling, so the dialer will call it back again)
4th - At 8.30 pm, same day. the dialer call back the customer and another agent try to sell the same product to the customer, because drop calls are being recycled.
We don't want that the dialer changes the disposition to DROP to any record that is already completed.
We tried altering agi-VDAD_ALL_inbound.agi and changing the query to:
$stmtA = "UPDATE vicidial_list set status='$DRstatus' where lead_id = '$insert_lead_id' and status not in (select status from vicidial_statuses where completed='Y' union all select status from vicidial_campaign_statuses where completed='Y' union select 'SALE' union select 'DNC');";
but nothing happened.
Any idea will be appreciated.
Thank you!
http://www.ITContinental.comDedicated USA Servers - Vicibox - Vicidial - Limesurvey - Vtiger CRM - More than 15 years experience - Hablamos Español