| 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
|