@@ 745-760 (lines=16) @@ | ||
742 | self.amount = amount |
|
743 | self.item_id = item_id |
|
744 | self.quantity = quantity |
|
745 | self.wholesale = wholesale |
|
746 | ||
747 | def __getattr__(self, name): |
|
748 | if name == 'deleted': |
|
749 | return self.transaction.event.deleted |
|
750 | else: |
|
751 | raise AttributeError |
|
752 | ||
753 | @classmethod |
|
754 | @limitable_all |
|
755 | def all_item(cls, id): |
|
756 | return DBSession.query(cls)\ |
|
757 | .join(Transaction)\ |
|
758 | .join(event.Event)\ |
|
759 | .filter(cls.item_id == id)\ |
|
760 | .filter(event.Event.deleted==False)\ |
|
761 | .order_by(desc(event.Event.timestamp)) |
|
762 | ||
763 | @classmethod |
|
@@ 424-437 (lines=14) @@ | ||
421 | deadbeats = DBSession.query(user.User)\ |
|
422 | .filter(user.User.enabled==True)\ |
|
423 | .filter(user.User.archived==False)\ |
|
424 | .filter(user.User.balance <= -5)\ |
|
425 | .all() |
|
426 | ||
427 | # Only get users between 0 and -5 if they have been in debt for a week or |
|
428 | # more. |
|
429 | iffy_users = DBSession.query(user.User)\ |
|
430 | .filter(user.User.enabled==True)\ |
|
431 | .filter(user.User.archived==False)\ |
|
432 | .filter(user.User.balance < 0)\ |
|
433 | .filter(user.User.balance > -5)\ |
|
434 | .all() |
|
435 | for u in iffy_users: |
|
436 | days = Transaction.get_days_in_debt_for_user(u) |
|
437 | if days >= 7: |
|
438 | deadbeats.append(u) |
|
439 | ||
440 | return deadbeats |