Subversion Repositories SmartDukaan

    return order

    return order

def get_all_orders(statuses, from_date, to_date, warehouse_id):

def get_all_orders(statuses, from_date, to_date, warehouse_id):

    query = Order.query

    query = Order.query

    if not len(statuses):

    if not len(statuses):

    else:

    else:

        query = query.filter(Order.status.in_(statuses))

        query = query.filter(Order.status.in_(statuses))

    if warehouse_id:

    if warehouse_id:

        query = query.filter(Order.warehouse_id == warehouse_id)

        query = query.filter(Order.warehouse_id == warehouse_id)

        #raise TransactionServiceException(101, "bad warehouse id")

        #raise TransactionServiceException(101, "bad warehouse id")

#Buyer can be anyone based on logic

#Buyer can be anyone based on logic

def __get_buyer(warehouse_id):

def __get_buyer(warehouse_id):

        #As of now we have hardcoded the company and 

        #As of now we have hardcoded the company and 

        #seller would be returned on basis warehouse and company

        #seller would be returned on basis warehouse and company

        buyerId=None

        buyerId=None

        result = session.query(Seller.id).join((SellerWarehouse, Seller.id==SellerWarehouse.seller_id)).filter(Seller.organisation_id==orgId).filter(SellerWarehouse.warehouse_id==warehouse_id).first()

        result = session.query(Seller.id).join((SellerWarehouse, Seller.id==SellerWarehouse.seller_id)).filter(Seller.organisation_id==orgId).filter(SellerWarehouse.warehouse_id==warehouse_id).first()

        if result:

        if result:

            buyerId = result[0]

            buyerId = result[0]

        return buyerId

        return buyerId