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)
