Subversion Repositories SmartDukaan

Rev

Rev 14914 | Rev 14917 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 14914 Rev 14916
Line 25... Line 25...
25
        self.mobile = userObj.mobile_number
25
        self.mobile = userObj.mobile_number
26
        self.customerName = userObj.first_name +' '+ userObj.last_name
26
        self.customerName = userObj.first_name +' '+ userObj.last_name
27
 
27
 
28
def getAllFeedbacks():
28
def getAllFeedbacks():
29
    global customerFeedbacks
29
    global customerFeedbacks
30
    feedbacksAndUsers = session.query(Feedbacks,Users).join((Feedbacks,Feedbacks.user_id==Users.id)).filter(Feedbacks.isTicketCreated==False).all()
30
    feedbacksAndUsers = session.query(Users,Feedbacks).join((Users,Users.id==Feedbacks.user_id)).filter(Feedbacks.isTicketCreated==False).all()
31
    for feedbackNUser in feedbacksAndUsers:
31
    for feedbackNUser in feedbacksAndUsers:
32
        feedback = feedbackNUser[0]
32
        feedback = feedbackNUser[1]
33
        user = feedbackNUser[1]
33
        user = feedbackNUser[0]
34
        feedbackInfo = __Feedback(feedback, user)
34
        feedbackInfo = __Feedback(feedback, user)
35
        customerFeedbacks.append(feedbackInfo)
35
        customerFeedbacks.append(feedbackInfo)
36
        
36
        
37
def createTicketsForCustomerQueries(customerFeedbacks):
37
def createTicketsForCustomerQueries(customerFeedbacks):
38
    crmServiceClient = CRMClient().get_client()
38
    crmServiceClient = CRMClient().get_client()
Line 90... Line 90...
90
        
90
        
91
        if ticketId >0:
91
        if ticketId >0:
92
            feedback = Feedbacks.get_by(id = customerFeedBack.id)
92
            feedback = Feedbacks.get_by(id = customerFeedBack.id)
93
            feedback.isTicketCreated = True
93
            feedback.isTicketCreated = True
94
            session.commit()
94
            session.commit()
-
 
95
        break
95
 
96
 
96
def main():
97
def main():
97
    try:
98
    try:
98
        getAllFeedbacks()
99
        getAllFeedbacks()
99
        createTicketsForCustomerQueries(customerFeedbacks)
100
        createTicketsForCustomerQueries(customerFeedbacks)