wholesale_price = float(form.getvalue("wholesale_price")) if "case_size" in form: case_size = float(form.getvalue("case_size")) if "case_unit" in form: case_unit = form.getvalue("case_unit") case_unitid = db.get_unit_byname(case_unit).get_id() db.update_distributor_item(d_i, ditemid, wholesale_price, case_size, case_unitid) item = db.get_item(itemid) each_cost = d_i.get_each_cost() op_price = item.get_price() tax = item.get_tax_value() if (op_price - tax) != 0: margin = (1.0 - each_cost / (op_price - tax)) * 100 else: margin = 100 item_price = db.get_price(item.get_price_id()) cost = item_price.get_unit_cost() if "categories" in form: cat_ids_list = form.getvalue("categories") cat_ids = filter(lambda x: x.isdigit(), cat_ids_list.split(",")) # only get valid digits for c_id in cat_ids: cat = db.get_category(c_id) db.add_category_item(item, cat) print "%d,%d,%d,%.2f,%.2f,%.2f,%d,%.2f,%s,%s" % ( itemid, item.get_price_id(), dist.get_id(), d_i.get_wholesale_price(), d_i.get_case_size(), each_cost, margin,
import cgi,sys import op_db_library as db def log_exception(*args): print 'Error: %s' % (args[1],) sys.excepthook = log_exception form = cgi.FieldStorage() print 'Content-type: text/plain\n' action = form.getvalue("action") if action == 'price': if "price_id" in form and "price" in form: price = db.get_price(int(form.getvalue("price_id"))) db.set_price(price, float(form.getvalue("price"))) else: raise Exception ('invalid arguments. need price_id and price. given %s' % form.keys()) elif action == 'group': if "price_id" in form and "item_id" in form: newid = form.getvalue('price_id') itemid = form.getvalue('item_id') if newid.isdigit() and itemid.isdigit(): newid = int(newid) itemid = int(itemid) if db.is_price(newid): item = db.get_item(itemid) old = item.get_price_id() db.set_item_price(item,newid) price = db.get_price(newid)