| Line 87... |
Line 87... |
| 87 |
curDate = (PREVIOUS_DATE + timedelta(days=1)).date()
|
87 |
curDate = (PREVIOUS_DATE + timedelta(days=1)).date()
|
| 88 |
return '''select date(created), call_disposition, count(1) from (
|
88 |
return '''select date(created), call_disposition, count(1) from (
|
| 89 |
(select id, created, call_disposition from (select * from callhistory where created between '%s' and '%s' and call_type ='%s' order by created desc) as a group by retailer_id)
|
89 |
(select id, created, call_disposition from (select * from callhistory where created between '%s' and '%s' and call_type ='%s' order by created desc) as a group by retailer_id)
|
| 90 |
union
|
90 |
union
|
| 91 |
(select id, created, 'converted' from (select h.* from retailers r join callhistory h on h.retailer_id=r.id where r.status in ('onboarded', 'onboarding') and h.call_disposition='verified_link_sent' and h.call_type='%s' and h.created between '%s' and '%s' order by h.created desc) as b1 group by retailer_id)
|
91 |
(select id, created, 'converted' from (select h.* from retailers r join callhistory h on h.retailer_id=r.id where r.status in ('onboarded', 'onboarding') and h.call_disposition='verified_link_sent' and h.call_type='%s' and h.created between '%s' and '%s' order by h.created desc) as b1 group by retailer_id)
|
| 92 |
)a group by date(created), call_disposition with rollup'''%(fourDaysBefore,curDate,type,fourDaysBefore,curDate,type )
|
92 |
)a group by date(created), call_disposition with rollup'''%(fourDaysBefore,curDate,type,type,fourDaysBefore,curDate )
|
| 93 |
#union select date(created) dc, agent_i
|
93 |
#union select date(created) dc, agent_i
|
| 94 |
|
94 |
|
| 95 |
def getMDTQuery(type='fresh'):
|
95 |
def getMDTQuery(type='fresh'):
|
| 96 |
return '''select a.dc, a.call_disposition, count(1) from
|
96 |
return '''select a.dc, a.call_disposition, count(1) from
|
| 97 |
(select 'MTD' as dc, call_disposition from (select * from callhistory where month(created)=%s and call_type ='%s' order by created desc) as a group by retailer_id
|
97 |
(select 'MTD' as dc, call_disposition from (select * from callhistory where month(created)=%s and call_type ='%s' order by created desc) as a group by retailer_id
|