Subversion Repositories SmartDukaan

Rev

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

Rev 13530 Rev 13531
Line 163... Line 163...
163 
def getAmazonOrderDataByItemId(startDate, endDate, offset, limit, item_id):
 163 
def getAmazonOrderDataByItemId(startDate, endDate, offset, limit, item_id):
164 
    fbaOrderData = []
 164 
    fbaOrderData = []
165 
    collection = get_mongo_connection().AmazonSaleSnapshot.AmazonSaleData
 165 
    collection = get_mongo_connection().AmazonSaleSnapshot.AmazonSaleData
166 
    list = []
 166 
    list = []
167 
    query = {}
 167 
    query = {}
168 
    list.append({"orderStatus":"Shipped"})
 - 
 
169 
    list.append({"item_id":item_id})
 168 
    list.append({"item_id":item_id})
170 
    query['$gte'] = to_java_date(startDate)
 169 
    query['$gte'] = to_java_date(startDate)
171 
    query['$lte'] = to_java_date(endDate)
 170 
    query['$lte'] = to_java_date(endDate)
172 
    list.append({"purchaseDate":query})
 171 
    list.append({"purchaseDate":query})
173 
    print list
 172 
    print list
Line 195... Line 194...
195 
    orderItemData = getAmazonOrderDataByItemId(startDate, endDate,None,None,16914)
 194 
    orderItemData = getAmazonOrderDataByItemId(startDate, endDate,None,None,16914)
196 
    priceSku = {}
 195 
    priceSku = {}
197 
    print len(orderItemData)
 196 
    print len(orderItemData)
198 
    count = 0
 197 
    count = 0
199 
    for x in orderItemData:
 198 
    for x in orderItemData:
200 
        if x.promotionDiscount > 0:
 199 
        if x.promotionDiscount > 0 or x.orderStatus == 'Cancelled':
201 
            count +=1
 200 
            count +=1
202 
            continue
 201 
            continue
203 
        print x.totalAmount
 202 
        print x.totalAmount
204 
        print x.quantity
 203 
        print x.quantity
205 
        print "*************"
 204 
        print "*************"