| Line 1804... |
Line 1804... |
| 1804 |
print details.created
|
1804 |
print details.created
|
| 1805 |
obj.totalOrders = session.query(Orders).filter_by(user_id = user.user_id).filter(~Orders.status.in_(['ORDER_NOT_CREATED_KNOWN', 'ORDER_ALREADY_CREATED_IGNORED'])).count()
|
1805 |
obj.totalOrders = session.query(Orders).filter_by(user_id = user.user_id).filter(~Orders.status.in_(['ORDER_NOT_CREATED_KNOWN', 'ORDER_ALREADY_CREATED_IGNORED'])).count()
|
| 1806 |
|
1806 |
|
| 1807 |
cartResult = fetchResult("select * from user_accounts where account_type ='cartId' and user_id=%d"%(user.user_id))
|
1807 |
cartResult = fetchResult("select * from user_accounts where account_type ='cartId' and user_id=%d"%(user.user_id))
|
| 1808 |
if cartResult == ():
|
1808 |
if cartResult == ():
|
| 1809 |
obj.obj.lastActiveCartTime = None
|
1809 |
obj.lastActiveCartTime = None
|
| 1810 |
else:
|
1810 |
else:
|
| 1811 |
conn = MySQLdb.connect("192.168.190.114", "root","shop2020", "user")
|
1811 |
conn = MySQLdb.connect("192.168.190.114", "root","shop2020", "user")
|
| 1812 |
cursor = conn.cursor()
|
1812 |
cursor = conn.cursor()
|
| 1813 |
cursor.execute("select updated_on from cart where id=%s",(cartResult[0][1]))
|
1813 |
cursor.execute("select updated_on from cart where id=%s",(cartResult[0][1]))
|
| 1814 |
result = cursor.fetchall()
|
1814 |
result = cursor.fetchall()
|
| 1815 |
if result ==():
|
1815 |
if result ==():
|
| 1816 |
obj.obj.lastActiveCartTime = None
|
1816 |
obj.lastActiveCartTime = None
|
| 1817 |
else:
|
1817 |
else:
|
| 1818 |
print result
|
1818 |
print result
|
| 1819 |
obj.lastActiveCartTime =datetime.strftime(result[0][1], '%d/%m/%Y %H:%M:%S')
|
1819 |
obj.lastActiveCartTime =datetime.strftime(result[0][1], '%d/%m/%Y %H:%M:%S')
|
| 1820 |
conn.close()
|
1820 |
conn.close()
|
| 1821 |
return obj
|
1821 |
return obj
|