| Line 1011... |
Line 1011... |
| 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 |
if(searchType=="number"):
|
1015 |
if(searchType=="number"):
|
| 1016 |
searchUser = session.query(Retailers).filter(and_(or_(Retailers.contact1==contact,Retailers.contact2==contact),Retailers.modified is not None)).all()
|
1016 |
searchUser = session.query(Retailers).filter(or_(Retailers.contact1==contact,Retailers.contact2==contact)).filter(Retailers.modified is not None).all()
|
| 1017 |
elif(searchType=="counter"):
|
1017 |
elif(searchType=="counter"):
|
| - |
|
1018 |
contact = contact.lower()
|
| 1018 |
searchUser = session.query(Retailers).filter(and_(or_((func.lower(Retailers.address).like(contact)),(func.lower(Retailers.address_new).like(contact))),Retailers.modified is not None)).all()
|
1019 |
searchUser = session.query(Retailers).filter(or_(func.lower(Retailers.address).like(contact)),(func.lower(Retailers.address_new).like(contact))).filter(Retailers.modified is not None).all()
|
| 1019 |
if searchUser is None:
|
1020 |
if searchUser is None:
|
| 1020 |
resp.body = json.dumps("{}")
|
1021 |
resp.body = json.dumps("{}")
|
| 1021 |
else:
|
1022 |
else:
|
| 1022 |
resp.body = json.dumps({"Retailers":[todict(getRetailerObj(user)) for user in searchUser]}, encoding='utf-8')
|
1023 |
resp.body = json.dumps({"Retailers":[todict(getRetailerObj(user)) for user in searchUser]}, encoding='utf-8')
|
| 1023 |
finally:
|
1024 |
finally:
|