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: