| Line 11528... |
Line 11528... |
| 11528 |
|
11528 |
|
| 11529 |
return True if net_payable > 0 else False
|
11529 |
return True if net_payable > 0 else False
|
| 11530 |
|
11530 |
|
| 11531 |
def get_intransit_orders_on_date_by_item_id(closingDate, itemId):
|
11531 |
def get_intransit_orders_on_date_by_item_id(closingDate, itemId):
|
| 11532 |
closingDateInclusive = to_py_date(closingDate) + datetime.timedelta(days=1)
|
11532 |
closingDateInclusive = to_py_date(closingDate) + datetime.timedelta(days=1)
|
| 11533 |
orders = Order.query.filter(Order.lineitems.any(item_id=itemId)).filter(Order.billing_timestamp < closingDateInclusive).filter(or_(Order.refund_timestamp >= closingDateInclusive, Order.delivery_timestamp >= closingDateInclusive)).all()
|
11533 |
orders = Order.query.options(joinedload('lineitems')).filter(Order.lineitems.any(item_id=itemId)).filter(Order.billing_timestamp < closingDateInclusive).filter(or_(Order.refund_timestamp >= closingDateInclusive, Order.delivery_timestamp >= closingDateInclusive)).all()
|
| 11534 |
print len(orders)
|
11534 |
print len(orders)
|
| 11535 |
t_orders = []
|
11535 |
t_orders = []
|
| 11536 |
for order in orders:
|
11536 |
for order in orders:
|
| 11537 |
if order.lineitems[0].item_id==itemId:
|
11537 |
if order.lineitems[0].item_id==itemId:
|
| 11538 |
t_orders.append(to_t_order(order))
|
11538 |
t_orders.append(to_t_order(order))
|