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