Changeset 152

Timestamp:

04/20/08 21:26:48 (3 months ago)

Author:

njriley

Message:

display total spent by user

Files:

• sucrose/trunk/python/api/sucrose.py (modified) (1 diff)
• sucrose/trunk/python/keypad_tk.py (modified) (1 diff)

sucrose/trunk/python/api/sucrose.py

@@ -36 +36 @@
-
-        def recent_purchases_for_user(self, user):
-_id=user.uid
+=user
-                                           order_by(self.db.Transaction.transaction_id.desc()).\
-                                           limit(5).all()
-
-                return [(t.item_name, t.cost) for t in transactions]
+
+        def total_spent_by_user(self, user):
+                return self.transactions.filter_by(user=user).\
+                           sum(self.db.Transaction.cost)
-
-        def vend(self, tray, uin):

sucrose/trunk/python/keypad_tk.py

@@ -167 +167 @@
-
-                offset = row + 3
-for row, (name, price) in enumerate(purchases
-('helvetica', 13)
-anchor=Tkinter.W, justify=Tkinter.LEFT, wraplength=200,
-bg='white').
-                       
-('helvetica', 13)
+def price_row(row, name, price, font=('helvetica', 13)
+font, anchor=Tkinter.W
+justify=Tkinter.LEFT, wraplength=200, bg='white').\
+
+
+font
-                                                  anchor=Tkinter.NE, justify=Tkinter.RIGHT,
-                                                  bg='white').grid(row=offset + row, column=3,
-                                                                                   sticky=Tkinter.NSEW)
+
+                for row, (name, price) in enumerate(purchases):
+                        price_row(row, name, price)
+                price_row(row + 1, 'Total Spent',
+                                  self.sucrose.total_spent_by_user(self.user),
+                                  font=('helvetica', 13, 'bold'))
+
-                # } END statistics GUI
-