Subversion Repositories SmartDukaan

Rev

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

Rev 8303 Rev 8305
Line 1121... Line 1121...
1121 
    if limit:
 1121 
    if limit:
1122 
        query = query.limit(limit)
 1122 
        query = query.limit(limit)
1123 
    return query.all()
 1123 
    return query.all()
1124 
 
 1124 
 
1125 
def get_order_count(statuses=[], warehouse_id=None, source=0):
 1125 
def get_order_count(statuses=[], warehouse_id=None, source=0):
1126 
    if not warehouse_id:
 1126 
    #if not warehouse_id:
1127 
        raise TransactionServiceException(101, "bad warehouse id")
 1127 
    #    raise TransactionServiceException(101, "bad warehouse id")
- 
 
 1128 
    query = session.query(func.count(Order.id))
- 
 
 1129 
    if warehouseId is not None:
1128 
    query = session.query(func.count(Order.id)).filter(Order.warehouse_id == warehouse_id)
 1130 
        query = query.filter(Order.warehouse_id == warehouse_id)
1129 
    if source:
 1131 
    if source:
1130 
        query = query.filter(Order.source == source)
 1132 
        query = query.filter(Order.source == source)
1131 
    if statuses:
 1133 
    if statuses:
1132 
        query = query.filter(Order.status.in_(statuses))
 1134 
        query = query.filter(Order.status.in_(statuses))
1133 
    return query.scalar()
 1135 
    return query.scalar()