Subversion Repositories SmartDukaan

Rev

Rev 15328 | Rev 15332 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 15328 Rev 15330
Line 560... Line 560...
560 
                status=self.callType
 560 
                status=self.callType
561 
                query = session.query(Retailers).filter(Retailers.status==status)
 561 
                query = session.query(Retailers).filter(Retailers.status==status)
562 
                if status=='fresh':
 562 
                if status=='fresh':
563 
                    query = query.filter_by(is_or=False, is_std=False).filter(or_(Retailers.agent_id==self.agentId, Retailers.agent_id==None)).order_by(Retailers.is_elavated.desc(), -Retailers.agent_id)
 563 
                    query = query.filter_by(is_or=False, is_std=False).filter(or_(Retailers.agent_id==self.agentId, Retailers.agent_id==None)).order_by(Retailers.is_elavated.desc(), -Retailers.agent_id)
564 
                else:
 564 
                else:
565 
                    query = query.filter(Retailers.next_call_time<=datetime.now())
 565 
                    query = query.filter(Retailers.next_call_time<=datetime.now()).order_by(Retailers.next_call_time)
566 
                retailer = query.with_lockmode("update").first()
 566 
                retailer = query.with_lockmode("update").first()
567 
                if retailer is not None:
 567 
                if retailer is not None:
568 
                    lgr.info( "retailer " +str(retailer.id))
 568 
                    lgr.info( "retailer " +str(retailer.id))
569 
                    if status=="fresh":
 569 
                    if status=="fresh":
570 
                        userquery = session.query(Users)
 570 
                        userquery = session.query(Users)