def print_multi_add():
print '''<div class="fixed">'''
print '''<select class="multi_dist" id="multi_dist">'''
for dist in db.get_distributors():
print '''<option class="%d_dist_option" value="%d"> %s </option>''' % (dist.get_id(),dist.get_id(),dist)
print '''</select>'''
print '''<button type="button" onClick="multiAddDist()">Add Dist</button>'''
print '''<button type="button" onClick="multiRemoveDist()">Remove Dist</button>'''
print '''<select class="multi_category" id="multi_category">'''
for cat in db.get_categories():
print '''<option class="%d_cat_option" value="%d"> %s </option>''' % (cat.get_id(),cat.get_id(),cat)
print '''</select>'''
print '''<button type="button" onClick="multiAddCategory()">Add Category</button>'''
print '''<button type="button" onClick="multiRemoveCategory()">Remove Category</button>'''
print '''<select class="addTaxCat" id="multi_tax_category">'''
for taxcat in db.get_tax_categories():
print '''<option class="%d_taxcat_option" value="%d"> %s </option>''' % (taxcat.get_id(),taxcat.get_id(),taxcat)
print '''</select>'''
print '''<button type="button" onClick="multiSetTaxCategory()">Set TaxCat</button>'''
print '''<button type="button" onClick="uncheckAllMulti()">Uncheck All Items </button>'''
print '''</div>'''
</script>
</head>
'''
print '''<body>
<table border=0 cellspacing=2 cellpadding=0>
<thead><tr>
<th>Tax Category</th>
<th>Rate (%)</th>
<th>Update</th>
<th>Remove</th>
</thead>
<tbody id="taxcategories">
'''
for tax in db.get_tax_categories():
print '''<tr class="%d_taxcat_tr" id="%d_taxcat_tr"><td>%s</td>''' % (tax.get_id(), tax.get_id(),tax.get_name())
print '''<td><input type="text" id="%d_tax_rate" value="%.2f" size=5>''' % (tax.get_id(), tax.get_rate()*100)
print '''<td><input type="button" onClick="updateTaxCategory(%d,'%s')" value="update" /></td>''' % (tax.get_id(),tax.get_name())
print '''<td><input type="button" onClick="removeTaxCategory(%d,'%s')" value="remove" /></td>''' % (tax.get_id(),tax.get_name())
print '''</tr>'''
print '''</tbody></table>'''
print '''<br /><div id="new"><tr><td><input id='newTaxCatName' type="text" size="10" value="" /></td>
<td><input type="text" id="newTaxCatRate" size=5>
<td><input type="button" onClick="addTaxCategory()" value="add new" /></td>'''
print '''</div>'''
print '''</body></html>'''
if not db.is_tax_category(taxcatid):
raise Exception ('tax category not in database')
else:
taxcat = db.get_tax_category(taxcatid)
db.remove_tax_category(taxcat)
print ''
elif action == 'update':
taxcatid = int(form.getvalue('taxcatid'))
rate = float(form.getvalue('rate'))/ 100.0
if not db.is_tax_category(taxcatid):
raise Exception ('tax category not in database')
else:
taxcat = db.get_tax_category(taxcatid)
db.update_tax_category(taxcat, rate)
print '%s' % str(taxcat)
elif action == 'query':
taxcat_list = [str(taxcat.get_id()) +','+str(taxcat) for taxcat in db.get_tax_categories()]
print ';'.join(taxcat_list)
elif action == 'query-item':
itemid = int(form.getvalue('item_id'))
item = db.get_item(itemid)
print item.get_tax_category()
elif action == 'set-item':
itemid = int(form.getvalue('item_id'))
taxcatid = int(form.getvalue('taxcatid'))
item = db.get_item(itemid)
taxcat = db.get_tax_category(taxcatid)
db.update_item_tax_category(item, taxcat)
def print_tax_category_options(selected):
for taxcat in db.get_tax_categories():
if taxcat == selected:
print '<option value="%d" selected> %s </option>' % (taxcat.get_id(), taxcat)
else:
print '<option value="%d"> %s </option>' % (taxcat.get_id(), taxcat)
