else: expenseId = form['expenseId'].value cursor.execute('SELECT expDate,description,amount FROM expense WHERE expenseId = ?',(expenseId,)) (expDate,description,amount) = cursor.fetchone() print ''' <div class=addthing> <FORM ACTION=expenses.py> <H2>Edit expense</H2> <table> <tr><td align=right>Date:</td><td><INPUT TYPE=TEXT NAME=date ID=date SIZE=20 VALUE="%s" /> Format: YYYY-MM-DD</td></tr> <tr><td align=right>Description:</td><td><INPUT TYPE=TEXT NAME=description ID=description SIZE=70 VALUE="%s" /></td></tr> <tr><td align=right>Amount:</td><td><INPUT TYPE=TEXT NAME=amount ID=amount VALUE="%s" SIZE=5 onBlur='moneyFormat(event.target)'/>Enter negative amount for a credit</td></tr> <INPUT TYPE=hidden NAME=edit VALUE=%s /> </table> <INPUT TYPE=SUBMIT VALUE='Submit changes' onClick='return validateForm();' /> </FORM> </div> <script language=javascript> function validateForm() { return ( checkField('date','Fill out the date') && checkField('description','Fill out the description') ); } </script> '''%(expDate,description,centsToString(amount),expenseId)
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>" printFooter()