WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/dtr/reports/affiliatereco.py

 from dtr.storage import Mysql
 from dtr.storage.DataService import Users, Clicks
 from dtr.storage.Mysql import getOrdersAfterDate, getOrdersByTag
 from dtr.utils.utils import fromTimeStamp
 from elixir import *
+from sqlalchemy.sql.expression import func, func, or_
 from email import encoders
 from email.mime.base import MIMEBase
 from email.mime.multipart import MIMEMultipart
 from email.mime.text import MIMEText
 from pymongo.mongo_client import MongoClient
         userId = None
         subTagId = None
         email = None
         subTagId = order.get("subTagId")
         if subTagId:
-            (userId,) = session.query(Clicks.user_id).filter_by(tag=subTagId).first()
+            a = session.query(Clicks.user_id).filter_by(tag=subTagId).first()
-            if userId is not None:
+            if a is not None:
+                (userId,) = a
                 (email,) = session.query(Users.email).filter_by(id = userId).first()
         row3 += 1
         i=-1
         sh2.write(row3, inc(), userId)
     getUserOrders()
     sendmail(["amit.gupta@shop2020.in","rajneesh.arora@saholic.com"], "", "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME)
     sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "chaitnaya.vats@saholic.com", "manoj.kumar@saholic.com"], "", "All DTR Orders", XLS_O_FILENAME)
 if __name__ == '__main__':
-    info = lclient.Dtr.flipkartOrderAffiliateInfo.find()
+    #info = client.Dtr.flipkartOrderAffiliateInfo.find()
-    print info
+    #print info
-    #main()
+    main()

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/reports/affiliatereco.py – Rev 15432 → 15440