Subversion Repositories SmartDukaan

Rev

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

Rev 15501 Rev 15528
Line 558... Line 558...
558
            while(retry):
558
            while(retry):
559
                lgr.info( "Calltype " + self.callType)
559
                lgr.info( "Calltype " + self.callType)
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, cod_limit=None).filter(or_(Retailers.agent_id==self.agentId, Retailers.agent_id==None)).order_by(Retailers.is_elavated.desc(), -Retailers.agent_id)
564
                elif status=='followup':
564
                elif status=='followup':
565
                    query = query.filter(Retailers.next_call_time<=datetime.now()).order_by(Retailers.next_call_time)
565
                    query = query.filter(Retailers.next_call_time<=datetime.now()).order_by(Retailers.next_call_time)
566
                else:
566
                else:
567
                    query = query.filter(Retailers.modified<=datetime.now()).order_by(Retailers.modified)
567
                    query = query.filter(Retailers.modified<=datetime.now()).order_by(Retailers.modified)
568
                    
568