| Line 627... |
Line 627... |
| 627 |
while(retry):
|
627 |
while(retry):
|
| 628 |
lgr.info( "Calltype " + self.callType)
|
628 |
lgr.info( "Calltype " + self.callType)
|
| 629 |
status=self.callType
|
629 |
status=self.callType
|
| 630 |
query = session.query(Retailers).filter(Retailers.status==status).filter(or_(Retailers.agent_id==self.agentId, Retailers.agent_id==None))
|
630 |
query = session.query(Retailers).filter(Retailers.status==status).filter(or_(Retailers.agent_id==self.agentId, Retailers.agent_id==None))
|
| 631 |
if status=='fresh':
|
631 |
if status=='fresh':
|
| 632 |
query = query.filter_by(is_or=False, is_std=False).filter(Retailers.pin==Pincodeavailability.code).filter(Pincodeavailability.amount > 19999).order_by(Retailers.is_elavated.desc(), Retailers.agent_id.desc())
|
632 |
query = query.filter_by(is_or=False, is_std=False).filter(Retailers.cod_limit > 19999).order_by(Retailers.is_elavated.desc(), Retailers.agent_id.desc())
|
| 633 |
elif status=='followup':
|
633 |
elif status=='followup':
|
| 634 |
query = query.filter(Retailers.next_call_time<=datetime.now()).order_by(Retailers.agent_id.desc(),Retailers.next_call_time)
|
634 |
query = query.filter(Retailers.next_call_time<=datetime.now()).order_by(Retailers.agent_id.desc(),Retailers.next_call_time)
|
| 635 |
else:
|
635 |
else:
|
| 636 |
query = query.filter(Retailers.modified<=datetime.now()).order_by(Retailers.agent_id.desc(), Retailers.modified)
|
636 |
query = query.filter(Retailers.modified<=datetime.now()).order_by(Retailers.agent_id.desc(), Retailers.modified)
|
| 637 |
|
637 |
|