Subversion Repositories SmartDukaan

Rev

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

Rev 19002 Rev 19004
Line 1513... Line 1513...
1513 
        query = query.filter(Order.status.in_(statuses))
 1513 
        query = query.filter(Order.status.in_(statuses))
1514 
    query = query.offset(offset)
 1514 
    query = query.offset(offset)
1515 
    if limit:
 1515 
    if limit:
1516 
        query = query.limit(limit)
 1516 
        query = query.limit(limit)
1517 
    return query.all()
 1517 
    return query.all()
1518 
'''
 1518 
 
1519 
def get_orders_in_batch_as_promised_shipping(statuses=[], offset=0, limit=0, warehouse_id=None, source=0):
 1519 
def get_orders_in_batch_as_promised_shipping(statuses=[], offset=0, limit=0, warehouse_id=None, source=0):
1520 
    query = Order.query
 1520 
    query = Order.query
1521 
    if warehouse_id:
 1521 
    if warehouse_id:
1522 
        query = query.filter(Order.warehouse_id == warehouse_id)
 1522 
        query = query.filter(Order.warehouse_id == warehouse_id)
1523 
    if source:
 1523 
    if source:
1524 
        query = query.filter(Order.source == source)
 1524 
        query = query.filter(Order.source == source)
1525 
    if statuses:
 1525 
    if statuses:
1526 
        query = query.filter(Order.status.in_(statuses))
 1526 
        query = query.filter(Order.status.in_(statuses))
1527 
    query = query.order_by(Order.promised_shipping_time,Order.transaction_id)
 1527 
    query = query.order_by(Order.transaction_id)
1528 
    if limit>0:
 1528 
    if limit>0:
1529 
        query = query.limit(limit)
 1529 
        query = query.limit(limit)
1530 
    if offset>0 and limit>0:
1530 
    if offset>0 and limit>0:
1531 
        query = query.offset(offset)
 1531 
        query = query.offset(offset)
1532 
    return query.all()
 1532 
    return query.all()
1533 
'''
 1533 
 
1534 
 
 1534 
 
1535 
def get_order_count(statuses=[], warehouse_id=None, source=0):
 1535 
def get_order_count(statuses=[], warehouse_id=None, source=0):
1536 
    #if not warehouse_id:
 1536 
    #if not warehouse_id:
1537 
    #    raise TransactionServiceException(101, "bad warehouse id")
 1537 
    #    raise TransactionServiceException(101, "bad warehouse id")
1538 
    query = session.query(func.count(Order.id))
 1538 
    query = session.query(func.count(Order.id))