Subversion Repositories SmartDukaan

Rev

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

Rev 18361 Rev 18366
Line 1756... Line 1756...
1756
        elif self.callDisposition == 'placed_order':
1756
        elif self.callDisposition == 'placed_order':
1757
            self.callHistoryCrm.disposition_description='Placed Order from Different Account'    
1757
            self.callHistoryCrm.disposition_description='Placed Order from Different Account'    
1758
        elif self.callDisposition == 'place_order':
1758
        elif self.callDisposition == 'place_order':
1759
            self.callHistoryCrm.disposition_description='Will Place Order'            
1759
            self.callHistoryCrm.disposition_description='Will Place Order'            
1760
        session.commit()
1760
        session.commit()
1761
        lgr.info( "Disposition Id ----"  + str(self.callHistoryCrm.id))
-
 
1762
        jdata = self.inputs
1761
        jdata = self.inputs
1763
        jdata = json.loads(jdata)
1762
        jdata = json.loads(jdata)
1764
        lgr.info( "Input ----"  + str(jdata))
-
 
1765
        if jdata:
1763
        if jdata:
1766
            for d in jdata:
1764
            for d in jdata:
1767
                for key, value in d.iteritems():
1765
                for key, value in d.iteritems():
1768
                    productpricingInputs = ProductPricingInputs()
1766
                    productpricingInputs = ProductPricingInputs()
1769
                    productpricingInputs.user_id = self.callHistoryCrm.user_id
1767
                    productpricingInputs.user_id = self.callHistoryCrm.user_id
Line 1813... Line 1811...
1813
                self.user.status = 'failed'
1811
                self.user.status = 'failed'
1814
                self.user.user_available=1
1812
                self.user.user_available=1
1815
                self.callHistoryCrm.disposition_description = 'Call failed as all attempts exhausted'
1813
                self.callHistoryCrm.disposition_description = 'Call failed as all attempts exhausted'
1816
        self.user.disposition=self.callDisposition        
1814
        self.user.disposition=self.callDisposition        
1817
        session.commit()
1815
        session.commit()
1818
        lgr.info( "Disposition Id ----\n"  + str(self.callHistoryCrm.id))
-
 
1819
        jdata =self.inputs
1816
        jdata =self.inputs
1820
        jdata = json.loads(jdata)
1817
        jdata = json.loads(jdata)
1821
        lgr.info( "Input ----\n"  + str(jdata))
-
 
1822
        if jdata: 
1818
        if jdata: 
1823
            for d in jdata:
1819
            for d in jdata:
1824
                for key, value in d.iteritems():
1820
                for key, value in d.iteritems():
1825
                    productpricingInputs = ProductPricingInputs()
1821
                    productpricingInputs = ProductPricingInputs()
1826
                    productpricingInputs.user_id = self.callHistoryCrm.user_id
1822
                    productpricingInputs.user_id = self.callHistoryCrm.user_id
Line 1842... Line 1838...
1842
    userList=[]
1838
    userList=[]
1843
    orderUserList=[]
1839
    orderUserList=[]
1844
    userMasterMap={}
1840
    userMasterMap={}
1845
    queryfilter = {"$and":
1841
    queryfilter = {"$and":
1846
                   [
1842
                   [
1847
                    {'created':{"$gte":(to_java_date(datetime.now())-5*86400000)}},
1843
                    {'created':{"$gte":(to_java_date(datetime.now())-2*86400000)}},
1848
                    {'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},
1844
                    {'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},
1849
                    {"url":{"$regex" : "http://api.profittill.com/cartdetails"}}
1845
                    {"url":{"$regex" : "http://api.profittill.com/cartdetails"}}
1850
                    ]
1846
                    ]
1851
                   }
1847
                   }
1852
    result = get_mongo_connection_dtr_data().User.browsinghistories.find(queryfilter).distinct('user_id')
1848
    result = get_mongo_connection_dtr_data().User.browsinghistories.find(queryfilter).distinct('user_id')
Line 1862... Line 1858...
1862
    finalUserList  = list(set(userList) - set(orderUserList))
1858
    finalUserList  = list(set(userList) - set(orderUserList))
1863
    
1859
    
1864
    queryfilternew = {"$and":
1860
    queryfilternew = {"$and":
1865
                   [
1861
                   [
1866
                    {'user_id':{"$in":finalUserList}},
1862
                    {'user_id':{"$in":finalUserList}},
1867
                    {'created':{"$gte":(to_java_date(datetime.now())-5*86400000)}},
1863
                    {'created':{"$gte":(to_java_date(datetime.now())-2*86400000)}},
1868
                    {'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},
1864
                    {'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},
1869
                    {"url":{"$regex" : "http://api.profittill.com/cartdetails"}}
1865
                    {"url":{"$regex" : "http://api.profittill.com/cartdetails"}}
1870
                    ]
1866
                    ]
1871
                   }
1867
                   }
1872
    itemIds = list(get_mongo_connection_dtr_data().User.browsinghistories.find(queryfilternew))
1868
    itemIds = list(get_mongo_connection_dtr_data().User.browsinghistories.find(queryfilternew))
Line 2014... Line 2010...
2014
    
2010
    
2015
    details = session.query(Orders).filter_by(user_id = user.user_id).filter(~Orders.status.in_(['ORDER_NOT_CREATED_KNOWN','ORDER_NOT_CREATED_UNKNOWN', 'ORDER_ALREADY_CREATED_IGNORED'])).order_by(desc(Orders.created)).first()
2011
    details = session.query(Orders).filter_by(user_id = user.user_id).filter(~Orders.status.in_(['ORDER_NOT_CREATED_KNOWN','ORDER_NOT_CREATED_UNKNOWN', 'ORDER_ALREADY_CREATED_IGNORED'])).order_by(desc(Orders.created)).first()
2016
    if details is None:
2012
    if details is None:
2017
        obj.lastOrderTimestamp =None
2013
        obj.lastOrderTimestamp =None
2018
    else:
2014
    else:
2019
        obj.last_active =datetime.strftime(details.created, '%d/%m/%Y %H:%M:%S')
2015
        obj.lastOrderTimestamp =datetime.strftime(details.created, '%d/%m/%Y %H:%M:%S')
2020
    obj.totalOrders = session.query(Orders).filter_by(user_id = user.user_id).filter(~Orders.status.in_(['ORDER_NOT_CREATED_KNOWN','ORDER_NOT_CREATED_UNKNOWN', 'ORDER_ALREADY_CREATED_IGNORED'])).count()
2016
    obj.totalOrders = session.query(Orders).filter_by(user_id = user.user_id).filter(~Orders.status.in_(['ORDER_NOT_CREATED_KNOWN','ORDER_NOT_CREATED_UNKNOWN', 'ORDER_ALREADY_CREATED_IGNORED'])).count()
2021
 
2017
 
2022
    cartResult = fetchResult("select account_key from user_accounts where account_type ='cartId' and user_id=%d"%(user.user_id))
2018
    cartResult = fetchResult("select account_key from user_accounts where account_type ='cartId' and user_id=%d"%(user.user_id))
2023
    if cartResult == ():
2019
    if cartResult == ():
2024
        obj.lastActiveCartTime = None
2020
        obj.lastActiveCartTime = None