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



        self.user.disposition=self.callDisposition
        self.user.modified = datetime.now()
        if self.callDisposition == 'technical_issue':
            self.callHistoryCrm.disposition_description='Technical issue at Profitmandi'
            utils.sendCrmProjectMail(self.userId,self.callHistoryCrm.disposition_description,self.callHistoryCrm.disposition_comments)
            a = CrmTicketDtr()
            a.addTicket(self.userId, self.callHistoryCrm.disposition_description, self.callHistoryCrm.disposition_comments)
        elif self.callDisposition == 'pricing_issue':
            self.callHistoryCrm.disposition_description='Pricing Issue(High)'
        elif self.callDisposition == 'shipping_issue':
            self.callHistoryCrm.disposition_description='Shipping charges related issue'
        elif self.callDisposition == 'internet_issue':

                    if userPresent.project_id==project_id:
                        if userPresent.modified.date()>=(datetime.now().date()-timedelta(days=30)):
                            continue
                        else:
                            pass    
                    elif userPresent.modified.date()>=(datetime.now().date()-timedelta(days=3)):
                        continue
                else:
                    continue     
            counter=counter+1
            userMasterData = UserCrmCallingData()

    userList=[]
    orderUserList=[]
    userMasterMap={}
    queryfilter = {"$and":
                   [
                    {'created':{"$gte":(to_java_date(datetime.now())-2*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')

                    {'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},
                    {"url":{"$regex" : "http://api.profittill.com/cartdetails"}}
                    ]
                   }
    itemIds = list(get_mongo_connection_dtr_data().User.browsinghistories.find(queryfilternew))
     
    for i in itemIds:
        if(userMasterMap.has_key(i.get('user_id'))):
            if userMasterMap.get(i.get('user_id')) > i.get('created'):
                userMasterMap[i.get('user_id')]=i.get('created')
        else:
            userMasterMap[i.get('user_id')]=i.get('created')
            
    d_sorted = sorted(zip(userMasterMap.values(), userMasterMap.keys()))
    addUserToTable(d_sorted,1)
 
def addUserToTable(userList,projectId):
    counter=0

            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)):
                        continue
                else:
                    continue     
            counter=counter+1
            userMasterData = UserCrmCallingData()

Rev 18713	Rev 18716
Line 1834...	Line 1834...
1834	`self.user.disposition=self.callDisposition`	1834	`self.user.disposition=self.callDisposition`
1835	`self.user.modified = datetime.now()`	1835	`self.user.modified = datetime.now()`
1836	`if self.callDisposition == 'technical_issue':`	1836	`if self.callDisposition == 'technical_issue':`
1837	`self.callHistoryCrm.disposition_description='Technical issue at Profitmandi'`	1837	`self.callHistoryCrm.disposition_description='Technical issue at Profitmandi'`
1838	`utils.sendCrmProjectMail(self.userId,self.callHistoryCrm.disposition_description,self.callHistoryCrm.disposition_comments)`	1838	`utils.sendCrmProjectMail(self.userId,self.callHistoryCrm.disposition_description,self.callHistoryCrm.disposition_comments)`
-		1839	`a = CrmTicketDtr()`
-		1840	`a.addTicket(self.userId, self.callHistoryCrm.disposition_description, self.callHistoryCrm.disposition_comments)`
1839	`elif self.callDisposition == 'pricing_issue':`	1841	`elif self.callDisposition == 'pricing_issue':`
1840	`self.callHistoryCrm.disposition_description='Pricing Issue(High)'`	1842	`self.callHistoryCrm.disposition_description='Pricing Issue(High)'`
1841	`elif self.callDisposition == 'shipping_issue':`	1843	`elif self.callDisposition == 'shipping_issue':`
1842	`self.callHistoryCrm.disposition_description='Shipping charges related issue'`	1844	`self.callHistoryCrm.disposition_description='Shipping charges related issue'`
1843	`elif self.callDisposition == 'internet_issue':`	1845	`elif self.callDisposition == 'internet_issue':`
Line 1963...	Line 1965...
1963	`if userPresent.project_id==project_id:`	1965	`if userPresent.project_id==project_id:`
1964	`if userPresent.modified.date()>=(datetime.now().date()-timedelta(days=30)):`	1966	`if userPresent.modified.date()>=(datetime.now().date()-timedelta(days=30)):`
1965	`continue`	1967	`continue`
1966	`else:`	1968	`else:`
1967	`pass`	1969	`pass`
1968	`elif userPresent.modified.date()>=(datetime.now().date()-timedelta(days=30)):`	1970	`elif userPresent.modified.date()>=(datetime.now().date()-timedelta(days=3)):`
1969	`continue`	1971	`continue`
1970	`else:`	1972	`else:`
1971	`continue`	1973	`continue`
1972	`counter=counter+1`	1974	`counter=counter+1`
1973	`userMasterData = UserCrmCallingData()`	1975	`userMasterData = UserCrmCallingData()`
Line 1993...	Line 1995...
1993	`userList=[]`	1995	`userList=[]`
1994	`orderUserList=[]`	1996	`orderUserList=[]`
1995	`userMasterMap={}`	1997	`userMasterMap={}`
1996	`queryfilter = {"$and":`	1998	`queryfilter = {"$and":`
1997	`[`	1999	`[`
1998	`{'created':{"$gte":(to_java_date(datetime.now())-3*86400000)}},`	2000	`{'created':{"$gte":(to_java_date(datetime.now())-2*86400000)}},`
1999	`{'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},`	2001	`{'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},`
2000	`{"url":{"$regex" : "http://api.profittill.com/cartdetails"}}`	2002	`{"url":{"$regex" : "http://api.profittill.com/cartdetails"}}`
2001	`]`	2003	`]`
2002	`}`	2004	`}`
2003	`result = get_mongo_connection_dtr_data().User.browsinghistories.find(queryfilter).distinct('user_id')`	2005	`result = get_mongo_connection_dtr_data().User.browsinghistories.find(queryfilter).distinct('user_id')`
Line 2019...	Line 2021...
2019	`{'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},`	2021	`{'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},`
2020	`{"url":{"$regex" : "http://api.profittill.com/cartdetails"}}`	2022	`{"url":{"$regex" : "http://api.profittill.com/cartdetails"}}`
2021	`]`	2023	`]`
2022	`}`	2024	`}`
2023	`itemIds = list(get_mongo_connection_dtr_data().User.browsinghistories.find(queryfilternew))`	2025	`itemIds = list(get_mongo_connection_dtr_data().User.browsinghistories.find(queryfilternew))`
2024		2026
2025	`for i in itemIds:`	2027	`for i in itemIds:`
2026	`if(userMasterMap.has_key(i.get('user_id'))):`	2028	`if(userMasterMap.has_key(i.get('user_id'))):`
2027	`if userMasterMap.get(i.get('user_id')) > i.get('created'):`	2029	`if userMasterMap.get(i.get('user_id')) > i.get('created'):`
2028	`userMasterMap[i.get('user_id')]=i.get('created')`	2030	`userMasterMap[i.get('user_id')]=i.get('created')`
2029	`else:`	2031	`else:`
2030	`userMasterMap[i.get('user_id')]=i.get('created')`	2032	`userMasterMap[i.get('user_id')]=i.get('created')`
2031		2033
2032	`d_sorted = sorted(zip(userMasterMap.values(), userMasterMap.keys()))`	2034	`d_sorted = sorted(zip(userMasterMap.values(), userMasterMap.keys()))`
2033	`addUserToTable(d_sorted,1)`	2035	`addUserToTable(d_sorted,1)`
2034		2036
2035	`def addUserToTable(userList,projectId):`	2037	`def addUserToTable(userList,projectId):`
2036	`counter=0`	2038	`counter=0`
Line 2042...	Line 2044...
2042	`userPresent = session.query(UserCrmCallingData).filter_by(user_id=userId).order_by(desc(UserCrmCallingData.modified)).first()`	2044	`userPresent = session.query(UserCrmCallingData).filter_by(user_id=userId).order_by(desc(UserCrmCallingData.modified)).first()`
2043	`if userPresent is not None:`	2045	`if userPresent is not None:`
2044	`if userPresent.user_available==1:`	2046	`if userPresent.user_available==1:`
2045	`if userPresent.project_id==projectId:`	2047	`if userPresent.project_id==projectId:`
2046	`continue`	2048	`continue`
2047	`elif userPresent.modified.date()>=(datetime.now().date()-timedelta(days=30)):`	2049	`elif userPresent.modified.date()>=(datetime.now().date()-timedelta(days=3)):`
2048	`continue`	2050	`continue`
2049	`else:`	2051	`else:`
2050	`continue`	2052	`continue`
2051	`counter=counter+1`	2053	`counter=counter+1`
2052	`userMasterData = UserCrmCallingData()`	2054	`userMasterData = UserCrmCallingData()`

Subversion Repositories SmartDukaan

(root)//trunk/PyDTR/src/dtr/api/Service.py – Rev 18713 → 18716