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)