Subversion Repositories SmartDukaan

Rev

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

Rev 9997 Rev 10017
Line 6610... Line 6610...
6610
    print flipkart_orders 
6610
    print flipkart_orders 
6611
    if len(flipkart_orders)!=0:
6611
    if len(flipkart_orders)!=0:
6612
        for order in flipkart_orders:
6612
        for order in flipkart_orders:
6613
            print order.orderId 
6613
            print order.orderId 
6614
            orders.append(order.orderId)
6614
            orders.append(order.orderId)
6615
        items =session.query(LineItem.item_id,func.count(LineItem.quantity)).join((Order,LineItem.order_id==Order.id)).filter(Order.id.in_(tuple(orders))).filter(Order.status >=3).group_by(LineItem.item_id).all()
6615
        items =session.query(LineItem.item_id,func.count(LineItem.quantity)).join((Order,LineItem.order_id==Order.id)).filter(Order.id.in_(tuple(orders))).filter(Order.status >=3).filter(Order.shipping_timestamp==None).group_by(LineItem.item_id).all()    
6616
    else:
6616
    else:
6617
        return item_ordercount
6617
        return item_ordercount
6618
    print "items map after query"     
6618
    print "items map after query"     
6619
    print items
6619
    print items
6620
    for item in items:
6620
    for item in items: