um-cseg / chez-betty

    @classmethod

    @limitable_all

    def all_item_purchases(cls, id):

        return DBSession.query(cls)\

                        .join(Transaction)\

                        .join(event.Event)\

                        .filter(cls.item_id == id)\

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

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

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

    @classmethod

    @limitable_all

    def all_item_events(cls, id):

        return DBSession.query(cls)\

                        .join(Transaction)\

                        .join(event.Event)\

                        .filter(cls.item_id == id)\

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

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

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

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