um-cseg / chez-betty

                        .filter(or_(event.Event.type=="inventory", event.Event.type =="restock"))\

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

    @classmethod

    @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'}

user.User.get_deadbeats = __get_deadbeats

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

@property

def __days_since_last_purchase(self):

    last_purchase = object_session(self).query(event.Event)\

            .join(Transaction)\

            .filter(Transaction.fr_account_virt_id == self.id)\

            .filter(event.Event.type == 'purchase')\

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

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

    if last_purchase:

        diff = arrow.now() - last_purchase.timestamp

        return diff.days

    else:

        return None

user.User.days_since_last_purchase = __days_since_last_purchase

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