Subversion Repositories SmartDukaan

Rev

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

Rev 18792 Rev 18818
Line 1964... Line 1964...
1964 
            session.close()
 1964 
            session.close()
1965 
 
 1965 
 
1966 
def getCartDetailsUser():
 1966 
def getCartDetailsUser():
1967 
    userList=[]
 1967 
    userList=[]
1968 
    orderUserList=[]
 1968 
    orderUserList=[]
1969 
    userMasterMap={}
 1969 
    #userMasterMap={}
1970 
    queryfilter = {"$and":
 1970 
    queryfilter = {"$and":
1971 
                   [
 1971 
                   [
1972 
                    {'created':{"$gte":(to_java_date(datetime.now())-3*86400000)}},
 1972 
                    {'created':{"$gte":(to_java_date(datetime.now())-3*86400000)}},
1973 
                    {'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},
 1973 
                    {'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},
1974 
                    {"url":{"$regex" : "http://api.profittill.com/cartdetails"}}
 1974 
                    {"url":{"$regex" : "http://api.profittill.com/cartdetails"}}
Line 1988... Line 1988...
1988
1988
1989 
    userCartIdMap={}
 1989 
    userCartIdMap={}
1990 
    fetchCartId = "select user_id,account_key from user_accounts where account_type='cartId' and user_id in (%s)" % ",".join(map(str,finalUserList))
 1990 
    fetchCartId = "select user_id,account_key from user_accounts where account_type='cartId' and user_id in (%s)" % ",".join(map(str,finalUserList))
1991 
    result = fetchResult(fetchCartId)
 1991 
    result = fetchResult(fetchCartId)
1992 
    for r in result:
 1992 
    for r in result:
1993 
        userCartIdMap[r[1]] = r[0]
 1993 
        userCartIdMap[long(r[1])] = long(r[0])
1994
- 
 
1995 
    client = CatalogClient().get_client()
 1994 
    client = CatalogClient().get_client()
1996 
    userMapReturned = client.getCartByValue(userCartIdMap.keys())
 1995 
    userMapReturned = client.getCartByValue(userCartIdMap.keys())
- 
 
 1996 
    userFinalList=[]
1997 
    print userMapReturned
 1997 
    for i in userMapReturned:
- 
 
 1998 
        userFinalList.append(userCartIdMap.get(i))
1998 
#     queryfilternew = {"$and":
 1999 
#     queryfilternew = {"$and":
1999 
#                    [
 2000 
#                    [
2000 
#                     {'user_id':{"$in":finalUserList}},
 2001 
#                     {'user_id':{"$in":finalUserList}},
2001 
#                     {'created':{"$gte":(to_java_date(datetime.now())-2*86400000)}},
 2002 
#                     {'created':{"$gte":(to_java_date(datetime.now())-2*86400000)}},
2002 
#                     {'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},
 2003 
#                     {'created':{"$lte":(to_java_date(datetime.now())- 43200000)}},
Line 2011... Line 2012...
2011 
#                 userMasterMap[i.get('user_id')]=i.get('created')
 2012 
#                 userMasterMap[i.get('user_id')]=i.get('created')
2012 
#         else:
 2013 
#         else:
2013 
#             userMasterMap[i.get('user_id')]=i.get('created')
 2014 
#             userMasterMap[i.get('user_id')]=i.get('created')
2014 
#
2015 
#
2015 
#     d_sorted = sorted(zip(userMasterMap.values(), userMasterMap.keys()))
 2016 
#     d_sorted = sorted(zip(userMasterMap.values(), userMasterMap.keys()))
2016 
#     addUserToTable(d_sorted,1)
 2017 
    addUserToTable(userFinalList,1)
2017 
 
 2018 
 
2018 
def addUserToTable(userList,projectId):
 2019 
def addUserToTable(userList,projectId):
2019 
    counter=0
 2020 
    counter=0
2020 
    for i in userList:
 2021 
    for i in userList:
2021 
        try:
 2022 
        try: