def print_item_history(item): print '''<br /> <b>30 day history for item %d (%s) </b><br />''' % (item.get_id(), item) total_sales,total_deliveries,total_slush,history = db.get_item_history(item.get_id(),30) print '<b>Total sales: %d <br />' % (total_sales,) print 'Total deliveries: %d <br />' % (total_deliveries,) print 'Total slushfunded: %d <br /></b>' % (total_slush,) print '''<table><thead><th>Date</th><th>+/-</th><th>Type</th></thead>''' for ttp in history: print '''<tr><td>%s</td><td>%.2f</td><td>%s</td></tr>''' % ttp print '''</table>'''
def main(): print_headers() print '''<body>''' print '''<form name="item" action="inventory_history.py" method="get">''' print '''Input an item SKU:''' print '''<input type="text" name="itemid" size="4" /> <input type="submit" value="Display" />''' print '''</form>''' form = cgi.FieldStorage() if "itemid" in form: itemid = int(form.getvalue("itemid")) item = db.get_item(itemid) print '''<br /> <b>30 day history for item %d (%s) </b><br />''' % (itemid, item) total_sales,total_deliveries,total_slush,history = db.get_item_history(itemid,30) print '<b>Total sales: %d <br />' % (total_sales,) print 'Total deliveries: %d <br />' % (total_deliveries,) print 'Total slushfunded: %d <br /></b>' % (total_slush,) print '''<table><thead><th>Date</th><th>+/-</th><th>Type</th></thead>''' for ttp in history: print '''<tr><td>%s</td><td>%.2f</td><td>%s</td></tr>''' % ttp print '''</table>''' print '''</body></html>'''