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)
