Subversion Repositories SmartDukaan

Rev

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

Rev 17304 Rev 17315
Line 1410... Line 1410...
1410 
                db = get_mongo_connection()
 1410 
                db = get_mongo_connection()
1411 
                sum=0
 1411 
                sum=0
1412 
                count=0
 1412 
                count=0
1413 
                #print date_val, type(date_val)
 1413 
                #print date_val, type(date_val)
1414 
                #cursor = db.Dtr.merchantOrder.find({'createdOnInt':{'$lt':long(date_val)},'subOrders':{'$exists':True}})
 1414 
                #cursor = db.Dtr.merchantOrder.find({'createdOnInt':{'$lt':long(date_val)},'subOrders':{'$exists':True}})
1415 
                cursor = db.merchantOrder.find({"$and": [ { "createdOnInt":{"$gt":long(date_val)} }, {"createdOnInt":{"$lt":long(date_val)+86401} } ],"subOrders":{"$exists":True}})
 1415 
                cursor = db.Dtr.merchantOrder.find({"$and": [ { "createdOnInt":{"$gt":long(date_val)} }, {"createdOnInt":{"$lt":long(date_val)+86401} } ],"subOrders":{"$exists":True}})
1416
1416
1417 
                for document in cursor:
 1417 
                for document in cursor:
1418 
                    for doc in document['subOrders']:
 1418 
                    for doc in document['subOrders']:
1419 
                        sum = sum + float(doc['amountPaid'])
 1419 
                        sum = sum + float(doc['amountPaid'])
1420 
                        count = count + int(doc['quantity'])
 1420 
                        count = count + int(doc['quantity'])