| Line 1012... |
Line 1012... |
| 1012 |
lgr.info( "Request in Search----\n" + str(jsonReq))
|
1012 |
lgr.info( "Request in Search----\n" + str(jsonReq))
|
| 1013 |
contact=jsonReq.get('searchTerm')
|
1013 |
contact=jsonReq.get('searchTerm')
|
| 1014 |
if(searchType=="number"):
|
1014 |
if(searchType=="number"):
|
| 1015 |
anotherCondition = or_(Retailers.contact1==contact,Retailers.contact2==contact)
|
1015 |
anotherCondition = or_(Retailers.contact1==contact,Retailers.contact2==contact)
|
| 1016 |
elif(searchType=="counter"):
|
1016 |
elif(searchType=="counter"):
|
| 1017 |
retailer_ids = list(session.query(RetailerContacts.retailer_id).filter_by(mobile_number=contact).all()
|
1017 |
#retailer_ids = list(session.query(RetailerContacts.retailer_id).filter_by(mobile_number=contact).all())
|
| 1018 |
anotherCondition = Retailers.title.ilike('%%%s%%'%(contact))
|
1018 |
anotherCondition = Retailers.title.ilike('%%%s%%'%(contact))
|
| 1019 |
|
1019 |
|
| 1020 |
searchUser = session.query(Retailers).filter(Retailers.modified != None).filter(anotherCondition).all()
|
1020 |
searchUser = session.query(Retailers).filter(Retailers.modified != None).filter(anotherCondition).all()
|
| 1021 |
if searchUser is None:
|
1021 |
if searchUser is None:
|
| 1022 |
resp.body = json.dumps("{}")
|
1022 |
resp.body = json.dumps("{}")
|