Subversion Repositories SmartDukaan

Rev

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

Rev 15295 Rev 15296
Line 1010... Line 1010...
1010
    def on_post(self, req, resp, agentId, searchType):
1010
    def on_post(self, req, resp, agentId, searchType):
1011
        try:
1011
        try:
1012
            jsonReq = json.loads(req.stream.read(), encoding='utf-8')
1012
            jsonReq = json.loads(req.stream.read(), encoding='utf-8')
1013
            lgr.info( "Request in Search----\n"  + str(jsonReq))
1013
            lgr.info( "Request in Search----\n"  + str(jsonReq))
1014
            contact=jsonReq.get('searchTerm')
1014
            contact=jsonReq.get('searchTerm')
-
 
1015
            retailerModifedCondition = and_(Retailers.modified is not None)
1015
            if(searchType=="number"):
1016
            if(searchType=="number"):
1016
                retailerModifedCondition = and_(Retailers.modified is not None)
-
 
1017
                searchUser = session.query(Retailers).filter(or_(Retailers.contact1==contact,Retailers.contact2==contact), retailerModifedCondition).all()
1017
                searchUser = session.query(Retailers).filter(or_(Retailers.contact1==contact,Retailers.contact2==contact), retailerModifedCondition).all()
1018
            elif(searchType=="counter"):    
1018
            elif(searchType=="counter"):    
1019
                contact = contact.lower()
1019
                contact = contact.lower()
1020
                searchUser = session.query(Retailers).filter(or_(func.lower(Retailers.address).like(contact)),(func.lower(Retailers.address_new).like(contact)), retailerModifedCondition).all()
1020
                searchUser = session.query(Retailers).filter(or_(func.lower(Retailers.address).like(contact)),(func.lower(Retailers.address_new).like(contact)), retailerModifedCondition).all()
1021
            if searchUser is None:
1021
            if searchUser is None: