Subversion Repositories SmartDukaan

Rev

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

Rev 4118 Rev 4133
Line 411... Line 411...
411 
        query = query.filter(Order.created_timestamp >from_date)
 411 
        query = query.filter(Order.created_timestamp >from_date)
412 
    if to_date:
 412 
    if to_date:
413 
        query = query.filter(Order.created_timestamp < to_date)
 413 
        query = query.filter(Order.created_timestamp < to_date)
414 
    return query.all()
 414 
    return query.all()
415 
 
 415 
 
- 
 
 416 
def get_orders_in_batch(statuses=[], offset=0, limit=0, warehouse_id=None):
- 
 
 417 
    if not warehouse_id:
- 
 
 418 
        raise TransactionServiceException(101, "bad warehouse id")
- 
 
 419 
    query = Order.query.filter(Order.warehouse_id == warehouse_id)
- 
 
 420 
    if statuses:
- 
 
 421 
        query = query.filter(Order.status.in_(statuses))
- 
 
 422 
    query = query.offset(offset)
- 
 
 423 
    if limit:
- 
 
 424 
        query = query.limit(limit)
- 
 
 425 
    return query.all()
- 
 
 426 
 
- 
 
 427 
def get_order_count(statuses=[], warehouse_id=None):
- 
 
 428 
    if not warehouse_id:
- 
 
 429 
        raise TransactionServiceException(101, "bad warehouse id")
- 
 
 430 
    query = session.query(func.count(Order.id)).filter(Order.warehouse_id == warehouse_id)
- 
 
 431 
    if statuses:
- 
 
 432 
        query = query.filter(Order.status.in_(statuses))
- 
 
 433 
    return query.scalar()
- 
 
 434 
 
416 
def get_returnable_orders_for_customer(customer_id, limit = None):
 435 
def get_returnable_orders_for_customer(customer_id, limit = None):
417 
    if not customer_id:
 436 
    if not customer_id:
418 
        raise TransactionServiceException(101, "bad customer id")
 437 
        raise TransactionServiceException(101, "bad customer id")
419
438
420 
    query = Order.query.filter(Order.customer_id == customer_id)
 439 
    query = Order.query.filter(Order.customer_id == customer_id)