um-cseg / chez-betty

    def __init__(self, event, amount, reimbursee):

        Transaction.__init__(self, event, None, None, reimbursee, None, amount)

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

## SUB TRANSACTIONS

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

class SubTransaction(Base):

    __tablename__   = "subtransactions"

    id              = Column(Integer, primary_key=True, nullable=False)

    transaction_id  = Column(Integer, ForeignKey("transactions.id"), nullable=False)

    amount          = Column(Numeric, nullable=False)

    type            = Column(Enum("purchaselineitem", "restocklineitem",

                                  "restocklinebox", "inventorylineitem",

                                  name="subtransaction_type"), nullable=False)

    item_id         = Column(Integer, ForeignKey("items.id"), nullable=True)

        Transaction.__init__(self, event, None, chezbetty_v, donator, chezbetty_c, amount)

class Withdrawal(Transaction):

    __mapper_args__ = {'polymorphic_identity': 'withdrawal'}

    def __init__(self, event, amount, reimbursee):

        chezbetty_v = account.get_virt_account("chezbetty")

        chezbetty_c = account.get_cash_account("chezbetty")

        Transaction.__init__(self, event, chezbetty_v, None, chezbetty_c, reimbursee, amount)

class Reimbursement(Transaction):

    __mapper_args__ = {'polymorphic_identity': 'reimbursement'}

    def __init__(self, event, amount, reimbursee):

        Transaction.__init__(self, event, None, None, reimbursee, None, amount)

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

class Found(Transaction):

    __mapper_args__ = {'polymorphic_identity': 'found'}

    def __init__(self, event, dest_acct, amount):

        Transaction.__init__(self, event, None, None, None, dest_acct, amount)

class Donation(Transaction):

    __mapper_args__ = {'polymorphic_identity': 'donation'}

    def __init__(self, event, amount, donator=None):

        chezbetty_v = account.get_virt_account("chezbetty")

        chezbetty_c = account.get_cash_account("chezbetty")

        Transaction.__init__(self, event, None, chezbetty_v, donator, chezbetty_c, amount)

class Withdrawal(Transaction):

    __mapper_args__ = {'polymorphic_identity': 'withdrawal'}

            .filter(or_(

                      Transaction.to_account_cash_id == account_id,

                      Transaction.fr_account_cash_id == account_id))\

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

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

    return q

event.Event.get_events_by_cashaccount = __get_events_by_cashaccount

# This is in a stupid place due to circular input problems

@classmethod

def __get_deadbeats(cls):

    deadbeats = DBSession.query(user.User)\

            .filter(user.User.enabled==True)\

            .filter(user.User.archived==False)\

            .filter(user.User.balance <= -5)\

            .all()

    # Only get users between 0 and -5 if they have been in debt for a week or