Subversion Repositories SmartDukaan

class GetSaleDetail():

    def on_get(self,req,res,date_val):

        try:

                db = get_mongo_connection()

                sum=0

                count=0

                #print date_val, type(date_val)

                #cursor = db.Dtr.merchantOrder.find({'createdOnInt':{'$lt':long(date_val)},'subOrders':{'$exists':True}})

                cursor = db.merchantOrder.find({"$and": [ { "createdOnInt":{"$gt":long(date_val)} }, {"createdOnInt":{"$lt":long(date_val)+86401} } ],"subOrders":{"$exists":True}})

                for document in cursor:

                    for doc in document['subOrders']:

                        sum = sum + float(doc['amountPaid'])

                        count = count + int(doc['quantity'])

                data = {"amount":sum , "quantity":count}

                res.body= json.dumps(data,encoding='utf-8')

        finally:

                session.close()