um-cseg / chez-betty

        return r.one().d or Decimal(0.0)

    # Get the total amount of fees people have paid for being in debt

    @classmethod

    def fees(cls, start=None, end=None):

        r = DBSession.query(func.sum((cls.amount / (1-cls.discount)) - cls.amount).label('f'))\

                        .join(event.Event)\

                        .filter(cls.discount < 0)\

                        .filter(event.Event.deleted==False)

        if start:

            r = r.filter(event.Event.timestamp>=start)

        if end:

            r = r.filter(event.Event.timestamp<end)

        return r.one().f or Decimal(0.0)

    # Returns an array of tuples where the first item is a millisecond timestamp,

    # the next is the total amount of debt, and the next is the total amount

    # Get the total amount of discounts people have received for keeping

    # money in their account

    @classmethod

    def discounts(cls, start=None, end=None):

        r = DBSession.query(func.sum((cls.amount / (1-cls.discount)) - cls.amount).label('d'))\

                        .join(event.Event)\

                        .filter(cls.discount > 0)\

                        .filter(event.Event.deleted==False)

        if start:

            r = r.filter(event.Event.timestamp>=start)

        if end:

            r = r.filter(event.Event.timestamp<end)

        return r.one().d or Decimal(0.0)

    # Get the total amount of fees people have paid for being in debt

    @classmethod

                     .join(Transaction)\

                     .join(event.Event)\

                     .filter(event.Event.deleted==False)\

                     .order_by(event.Event.timestamp)

        if start:

            r = r.filter(event.Event.timestamp>=start.replace(tzinfo=None))

        if end:

            r = r.filter(event.Event.timestamp<end.replace(tzinfo=None))

        return utility.group(r.all(), period)

    @classmethod

    def virtual_revenue_by_period(cls, period, start=None, end=None):

        r = DBSession.query(cls.amount.label('summable'), event.Event.timestamp)\

                     .join(Transaction)\

                     .join(event.Event)\

                     .filter(event.Event.deleted==False)\

                     .order_by(event.Event.timestamp)

        if start:

                            .filter(event.Event.deleted==False)\

                            .order_by(desc(event.Event.timestamp))

class PurchaseLineItem(SubTransaction):

    __mapper_args__ = {'polymorphic_identity': 'purchaselineitem'}

    price           = Column(Numeric)

    def __init__(self, transaction, amount, item, quantity, price, wholesale):

        SubTransaction.__init__(self, transaction, amount, item.id, quantity, wholesale)

        self.price = price

    @classmethod

    def quantity_by_period(cls, period, start=None, end=None):

        r = DBSession.query(cls.quantity.label('summable'), event.Event.timestamp)\

                     .join(Transaction)\

                     .join(event.Event)\

                     .filter(event.Event.deleted==False)\

                     .order_by(event.Event.timestamp)

        if start:

    @limitable_all

    def all(cls, trans_type=None):

        if not trans_type:

            return DBSession.query(cls)\

                            .join(Transaction)\

                            .join(event.Event)\

                            .filter(event.Event.deleted==False)\

                            .order_by(desc(event.Event.timestamp))

        else:

            return DBSession.query(cls)\

                            .join(Transaction)\

                            .join(event.Event)\

                            .filter(cls.type==trans_type)\

                            .filter(event.Event.deleted==False)\

                            .order_by(desc(event.Event.timestamp))

class PurchaseLineItem(SubTransaction):

    __mapper_args__ = {'polymorphic_identity': 'purchaselineitem'}

    if previous_cb_empty:

        q = q.filter(event.Event.timestamp >= previous_cb_empty.timestamp)

    return q.all()

event.EmptyCashBox.relevant_cash_deposits = __relevant_cash_deposits

################################################################################

## Related Classes

################################################################################

class Purchase(Transaction):

    __mapper_args__ = {'polymorphic_identity': 'purchase'}

    discount = Column(Numeric)

    def __init__(self, event, user, discount=None):

        chezbetty_v = account.get_virt_account("chezbetty")

        Transaction.__init__(self, event, user, chezbetty_v, None, None, Decimal(0.0))

        self.discount = discount

                            .filter(cls.type==trans_type)\

                            .filter(event.Event.deleted==False).one().c

    @classmethod

    def total(cls, start=None, end=None):

        r = DBSession.query(func.sum(cls.amount).label('a'))\

                        .join(event.Event)\

                        .filter(event.Event.deleted==False)

        if start:

            r = r.filter(event.Event.timestamp>=start)

        if end:

            r = r.filter(event.Event.timestamp<end)

        return r.one().a or Decimal(0.0)

    # Get the total amount of discounts people have received for keeping

    # money in their account