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()
print '<H2>Details for %s: %s</H2>'%(mytype,description)
print '<p>Date: %s</p>'%tranDate
cursor.execute('SELECT manufacturer,brand,name,quantity,pricePerItem FROM TransItem LEFT JOIN Item USING (itemId) WHERE tranId = ?',
(tranId,))
print '<TABLE BORDER=1><TR><TH>Item</TH><TH>qty</TH><TH>unit price</TH><TH>tot price</TH>'
totalPrice = 0
for (manufacturer,brand,name,quantity,pricePerItem) in cursor:
itemsTotalPrice = (int(quantity)*int(pricePerItem))
totalPrice += itemsTotalPrice
print '<TR>'
print cell(getItemName(manufacturer,brand,name))
print cell(quantity)
print moneyCell(pricePerItem)
print moneyCell(itemsTotalPrice)
print '</TR>'
print "<TR><TD COLSPAN=3 ALIGN=RIGHT>Shipping:</TD>",moneyCell(shipping),"</TR>"
totalPrice += shipping
print "<TR><TD COLSPAN=3 ALIGN=RIGHT><b>Total:</b></TD>",moneyCell(totalPrice),"</TR>"
print "</TABLE>"
print "<FORM name=modTran ACTION=saleDetails.py>"
print "<INPUT TYPE=hidden NAME=tranId VALUE=%s>"%tranId
print "Actual shipping costs: <INPUT TYPE=TEXT CLASS=money NAME=actualShipping ID=actualShipping VALUE=%s SIZE=5 onBlur='moneyFormat(event.target)'/>"%centsToString(actualShipping)
print "Tracking number: <INPUT TYPE=TEXT NAME=tracking ID=tracking VALUE=%s SIZE=25/>"%tracking
print "<BR />"
print "<INPUT TYPE=submit VALUE=update />"
print "</FORM name=modTran>"