INNER JOIN BinItems using (binId) INNER JOIN Item USING (itemId) GROUP BY binId,itemId ''') binList = [] for binDetails in cursor: binList.append(binDetails) def nameToList(a): (binId,itemId,binName,itemMfr,itemBrand,itemName,qty) = a return binName.split() binList.sort(sortLists,nameToList) if len(binList) == 0: print "<H2>You don't have any stock</H2>" else: print "<TABLE BORDER=1 class='listthings sortable'>" print "<TR><TH>Bin</TH><TH>Item</TH><TH>Quantity</TH></TR>" for (binId,itemId,binName,manufacturer,brand,name,number) in binList: print "<TR>" print "<TD>%s</TD>"%binName print "<TD>%s</TD>"%getItemName(manufacturer,brand,name) print "<TD>%d</TD>"%(number,) print "<TD>",gotoButton('Move','moveStock.py?binId=%s&itemId=%s'%(binId,itemId)),"</TD>" print "</TR>" print "</TABLE>" printFooter()
print "<TABLE BORDER=1 class='listthings sortable'>" print "<TR><TH>Name</TH><TH>Qty</TH><TH>Contents</TH><TH></TH><TH></TH></TR>" for (kitId,name,quantity) in kits: print "<TR>" print "<TD VALIGN=TOP>%s</TD>"%name print "<TD VALIGN=TOP>%s</TD>"%quantity print "<TD>" for itemId in kitQty[kitId]: itemQty = kitQty[kitId][itemId] (name,qty) = itemDetails[itemId] print "%s %s<br />"%(itemQty,name) print "</TD>" print "<TD VALIGN=TOP><FORM><SELECT NAME=setQty>" for i in range(0,maxAvail[kitId]+1): if i == quantity: selected = 'SELECTED' else: selected = '' print "<OPTION %s>%d</OPTION>"%(selected,i) print "</SELECT>" print "<INPUT TYPE=HIDDEN NAME=setId VALUE=%s />"%kitId print "<INPUT TYPE=SUBMIT VALUE=upd></FORM></TD>" print "<TD VALIGN=TOP>",gotoButton('Delete','kits.py?delId=%s'%kitId),"</TD>" print "</TR>" print "</TABLE>" printFooter()
GROUP BY tranId ORDER BY tranDate DESC, tranid DESC LIMIT 200 ''') print "<H2>Last 200 sales:</H2>" print "<TABLE BORDER=1 class='listthings sortable'>" print "<TR><TH>Type</TH><TH>Date</TH><TH>Buyer</TH><TH>Total cost</TH><TH></TH></TR>" for (tranId,type,direction,tranDate,buyer,shipping,totalCost) in cursor: if type == 'REAL': if direction == 'ADD': typeDetail = 'Purchase' else: typeDetail = 'Sale' else: if direction == 'ADD': typeDetail = 'Reconcile<br />add' else: typeDetail = 'Reconcile<br />del' print "<TR>" print cell(typeDetail) print cell(tranDate) print cell(buyer) print moneyCell(int(shipping)+int(totalCost)) print "<TD>",gotoButton('See details','saleDetails.py?tranId=%s'%tranId),"</TD>" print "</TR>" print "</TABLE>" printFooter()
<TR> <TH>Mfr</TH> <TH>brand</TH> <TH>name</TH> <TH></TH> </TR> """ for (itemId, manufacturer, brand, name, number) in cursor: if not brand: brand = "-" print "<TR>" print "<TD>%s</TD>" % manufacturer print "<TD>%s</TD>" % brand print "<TD>%s</TD>" % name print "<TD>" print gotoButton("Edit", "editItem.py?itemId=%s" % itemId) if number: print gotoButton("Transactions", "singleItem.py?itemId=%s" % itemId) else: print gotoButton("Delete", "items.py?delete=%s" % itemId) print "</TD>" print "</TR>" print "</TABLE>" print "<SCRIPT LANGUAGE='javascript'>" print "var manufacturer = '%s';" % (addManufacturer or "") print "var brand = '%s';" % (addBrand or "") print """ mfgr = document.getElementById('addItemMfr');
cursor.execute(''' SELECT expenseId,expDate,description,amount FROM expense ORDER BY expDate ''') print ''' <TABLE BORDER=1 class='listthings sortable'> <TR> <TH>Date</TH> <TH>Description</TH> <TH>Amount</TH> <TH></TH> </TR> ''' for (expenseId,date,description,amount) in cursor: print '<TR>' print '<TD>%s</TD>'%date print '<TD>%s</TD>'%description print '<TD>%s</TD>'%centsToDollarString(amount) print '<TD>' print gotoButton('Edit','editExpense.py?expenseId=%s'%expenseId) print gotoButton('Delete','expenses.py?deleteId=%s'%expenseId) print '</TD>' print '</TR>' print '</TABLE>' printFooter()
return value def displayBuy(sl): value = "Buy:" tranId = int(sl.pop(0)) while len(sl) > 0: qty = int(sl.pop(0)) sl.pop(0) itemId = int(sl.pop(0)) sl.pop(0) binId = int(sl.pop(0)) thisBinName = getBinName(binId) value += "<br> · %d <b><i>%s</i></b> to <b><i>%s</i></b></b>"%(qty,itemName[itemId],thisBinName) return value if len(history) == 0: print "<H2>You don't have any history yet</H2>" else: print "<TABLE BORDER=1>" print "<TR><TH>Date/time</TH><TH>Description</TH><TD></TD></TR>" for (historyId,historyDate,body) in history: print "<TR><TD>%s</TD><TD>%s</TD><TD>%s</TD></TR>"%(historyDate,display(body),gotoButton('undo','history.py?undo=%s'%historyId)) print "</TABLE>" printFooter()
########################################################################### # Main program printHeader('Ebay Listings') ########################################################################### # Import data if form.has_key('import'): try: loadFromEbay() except Exception,e: c.rollback() print "<p class=error>Problem importing data:</p><pre>",sys.exc_info(),"</pre>" print gotoButton('Import listings from Ebay','ebaylisting.py?import=1') ########################################################################### # Add link if form.has_key('link'): itemid = form['itemid'].value title = urllib.unquote_plus(form['title'].value) print "<p>Linking <i>"+title+"<i> to item id "+itemid+"</p>" cursor.execute('INSERT INTO ebayList2Item (title,itemid) VALUES (?,?)',(title,itemid)) c.commit() ###################################### # Table cursor.execute(''' SELECT title,ebayList.quantity,ebayList.itemId,Item.manufacturer,Item.brand,Item.name,SUM(BinItems.quantity)
########################################################################### # Main program printHeader('Ebay Listings') ########################################################################### # Import data if form.has_key('import'): try: loadFromEbay() except Exception,e: c.rollback() print "<p class=error>Problem importing data:</p><pre>",sys.exc_info(),"</pre>" print gotoButton('Import listings from Ebay','ebayListing.py?import=1') ########################################################################### # Add link to item if form.has_key('linkToItem'): itemid = form['itemid'].value title = urllib.unquote_plus(form['title'].value) print "<p>Linking <i>"+title+"<i> to item id "+itemid+"</p>" cursor.execute('INSERT INTO ebayList2Item (title,itemid) VALUES (?,?)',(title,itemid)) c.commit() ########################################################################### # Add link to kit if form.has_key('linkToKit'): kitid = form['kitid'].value title = urllib.unquote_plus(form['title'].value)