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

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

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

    @classmethod

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

        r = DBSession.query(func.sum(cls.amount-(cls.wholesale*cls.quantity)).label('p'))\

                        .join(Transaction)\

                        .join(event.Event)\

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

        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 r.one().p or Decimal(0.0)

    @classmethod

    def item_sale_quantities(cls, item_id):

            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:

            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 profit_on_sales(cls, start=None, end=None):

        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:

            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):

class Deposit(Transaction):

    __mapper_args__ = {'polymorphic_identity': 'deposit'}

    @classmethod

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

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

                     .join(event.Event)\

                     .order_by(event.Event.timestamp)\

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

        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)

class CashDeposit(Deposit):