WebSVN – SmartDukaan – Diff – //trunk/PyDTR/src/dtr/api/Service.py

         if self.callDisposition == 'product_availability':
             self.callHistoryCrm.disposition_description='Product Not available'
         elif self.callDisposition == 'return_replacement':
             self.callHistoryCrm.disposition_description='Return or replacement pending'
             utils.sendCrmProjectMail(self.userId,self.callHistoryCrm.disposition_description,self.callHistoryCrm.disposition_comments)
+            CrmTicketDtr.addTicket(self, self.userId, self.callHistoryCrm.disposition_description, self.callHistoryCrm.disposition_comments)
         elif self.callDisposition == 'already_purchased':
             self.callHistoryCrm.disposition_description='Already purchased required stock'
         elif self.callDisposition == 'product_quality_issue':
             self.callHistoryCrm.disposition_description='Product Quality issue'
             utils.sendCrmProjectMail(self.userId,self.callHistoryCrm.disposition_description,self.callHistoryCrm.disposition_comments)
     userList=[]
     orderUserList=[]
     userMasterMap={}
     queryfilter = {"$and":
+                   [
-                    {'created':{"$gte":(to_java_date(datetime.now())-2*86400000)}},
+                    {'created':{"$gte":(to_java_date(datetime.now())-3*86400000)}},
                     {'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},
                     {"url":{"$regex" : "http://api.profittill.com/cartdetails"}}
+                    ]
+                   }
     result = get_mongo_connection_dtr_data().User.browsinghistories.find(queryfilter).distinct('user_id')
             userPresent = session.query(UserCrmCallingData).filter_by(user_id=userId).order_by(desc(UserCrmCallingData.modified)).first()
             if userPresent is not None:
                 if userPresent.user_available==1:
                     if userPresent.project_id==projectId:
                         continue
-                    elif userPresent.modified.date()>=(datetime.now().date()-timedelta(days=3)):
+                    elif userPresent.modified.date()>=(datetime.now().date()-timedelta(days=30)):
                         continue
                 else:
                     continue
             counter=counter+1
             userMasterData = UserCrmCallingData()
             print result
             obj.lastActiveCartTime =datetime.strftime(result[0][0], '%d/%m/%Y %H:%M:%S')
         conn.close()
     return obj
+class CrmTicketDtr():
+    def on_post(self,req,resp):
+        customerFeedbackBackMap = {}
+        customerFeedbackBackMap['user_id']=req.get_param("user_id")
+        user = session.query(Users).filter_by(id=customerFeedbackBackMap.get('user_id')).first()
+        if user is not None:
+            customerFeedbackBackMap['email']=user.email
+            customerFeedbackBackMap['mobile_number']=user.mobile_number
+            customerFeedbackBackMap['customer_name']=user.first_name + ' ' + user.last_name
+            customerFeedbackBackMap['subject'] = req.get_param("subject")
+            customerFeedbackBackMap['message'] = req.get_param("message")
+            customerFeedbackBackMap['created'] = datetime.now()
+            if utils.generateCrmTicket(customerFeedbackBackMap):
+                resp.body={"result":"success"}
+            else:
+                resp.body={"result":"failure"}
+        else:
+            resp.body={"result":"failure"}
+    def addTicket(self,user_id,subject,message):
+        customerFeedbackBackMap = {}
+        customerFeedbackBackMap['user_id']=user_id
+        user = session.query(Users).filter_by(id=user_id).first()
+        if user is not None:
+            customerFeedbackBackMap['email']=user.email
+            customerFeedbackBackMap['mobile_number']=user.mobile_number
+            customerFeedbackBackMap['customer_name']=user.first_name + ' ' + user.last_name
+            customerFeedbackBackMap['subject'] = subject
+            customerFeedbackBackMap['message'] = message
+            customerFeedbackBackMap['created'] = datetime.now()
+            utils.generateCrmTicket(customerFeedbackBackMap)
+        else:
+            print 'User is not present'
 class UnitDeal():
     def on_get(self,req,resp, id):
         result = Mongo.getDealById(id)
         resp.body = dumps(result)
     a = RetailerDetail()
     retailer = a.getNotActiveRetailer()
     otherContacts = [r for r, in session.query(RetailerContacts.mobile_number).filter_by(retailer_id=retailer.id).order_by(RetailerContacts.contact_type).all()]
     print json.dumps(todict(getRetailerObj(retailer, otherContacts, 'fresh')), encoding='utf-8')
 #     a = GetUserCrmApplication()
-#     a.getUser("accs_active", 2)
+#     a.getUser("accs_cart", 1)
 if __name__ == '__main__':
     main()

Subversion Repositories SmartDukaan

(root)//trunk/PyDTR/src/dtr/api/Service.py – Rev 18671 → 18709