| Line 993... |
Line 993... |
| 993 |
mappedWith = 'contact'
|
993 |
mappedWith = 'contact'
|
| 994 |
if user is not None:
|
994 |
if user is not None:
|
| 995 |
referrer = None if user.referrer is None else user.referrer.upper()
|
995 |
referrer = None if user.referrer is None else user.referrer.upper()
|
| 996 |
retailerLink = session.query(RetailerLinks).filter(or_(RetailerLinks.code==referrer, RetailerLinks.code==user.utm_campaign)).first()
|
996 |
retailerLink = session.query(RetailerLinks).filter(or_(RetailerLinks.code==referrer, RetailerLinks.code==user.utm_campaign)).first()
|
| 997 |
if retailerLink is None:
|
997 |
if retailerLink is None:
|
| - |
|
998 |
if user.mobile_number is not None:
|
| 998 |
retailerContact = session.query(RetailerContacts).filter_by(mobile_number=user.mobile_number).first()
|
999 |
retailerContact = session.query(RetailerContacts).filter_by(mobile_number=user.mobile_number).first()
|
| 999 |
if retailerContact is None:
|
1000 |
if retailerContact is None:
|
| 1000 |
retailer = session.query(Retailers).filter(Retailers.status.in_(['followup', 'fretry'])).filter(or_(Retailers.contact1==user.mobile_number,Retailers.contact2==user.mobile_number)).first()
|
1001 |
retailer = session.query(Retailers).filter(Retailers.status.in_(['followup', 'fretry'])).filter(or_(Retailers.contact1==user.mobile_number,Retailers.contact2==user.mobile_number)).first()
|
| 1001 |
else:
|
1002 |
else:
|
| 1002 |
retailer = session.query(Retailers).filter_by(id = retailerContact.retailer_id).first()
|
1003 |
retailer = session.query(Retailers).filter_by(id = retailerContact.retailer_id).first()
|
| 1003 |
else:
|
1004 |
else:
|
| 1004 |
retailer = session.query(Retailers).filter_by(id = retailerLink.retailer_id).first()
|
1005 |
retailer = session.query(Retailers).filter_by(id = retailerLink.retailer_id).first()
|
| 1005 |
mappedWith='code'
|
1006 |
mappedWith='code'
|
| 1006 |
if retailer is not None:
|
1007 |
if retailer is not None:
|
| 1007 |
retailerLink = session.query(RetailerLinks).filter_by(retailer_id=retailer.id).first()
|
1008 |
retailerLink = session.query(RetailerLinks).filter_by(retailer_id=retailer.id).first()
|