def billing_item(self, id="", **kw):
billing_item_fields = BillingItemFields()
widgets = billing_item_fields.declared_widgets
data = {}
if id != "":
flash("editing item number " + str(id))
item = BillingItem.get(int(id))
widgets[6].attrs = dict(value=item.id)
widgets[0].attrs = dict(value=item.ItemCode)
widgets[1].default = item.ItemDescription
widgets[2].attrs = dict(value=item.ItemUnitCost)
widgets[3].attrs = dict(value=item.ItemType)
widgets[4].attrs = dict(value=item.ItemDiscountMaxAllowed)
widgets[5].attrs = dict(value=item.ItemStatus)
widgets[7].attrs = dict(value=item.ModifyTime)
widgets[8].attrs = dict(value=item.ModifyId)
widgets[9].attrs = dict(value=item.CreateTime)
widgets[10].attrs = dict(value=item.CreateId)
widgets[11].attrs = dict(value="False")
else:
widgets[6].attrs = dict(value="")
widgets[0].attrs = dict(value="")
widgets[1].attrs = dict(text="")
widgets[2].attrs = dict(value="")
widgets[3].attrs = dict(value="")
widgets[4].attrs = dict(value="")
widgets[5].attrs = dict(value="")
widgets[7].attrs = dict(value="")
widgets[8].attrs = dict(value="")
widgets[9].attrs = dict(value="")
widgets[10].attrs = dict(value="")
widgets[11].attrs = dict(value="True")
form_billing_item = turbogears.widgets.TableForm(fields=billing_item_fields, submit_text="OK")
return dict(form=form_billing_item, action="billing_item")
def save_item(self, **kw):
cur_datetime = date.today()
if kw["createtime"] == "":
kw["createtime"] = cur_datetime
hub.begin()
if kw["new"]:
item = BillingItem(
ItemCode=kw["itemcode"],
ItemDescription=kw["itemdescription"],
ItemUnitCost=kw["itemunitcost"],
ItemType=kw["itemtype"],
ItemDiscountMaxAllowed=kw["itemdiscountmaxallowed"],
ItemStatus=kw["itemstatus"],
ModifyTime=cur_datetime,
ModifyId="wesley",
CreateTime=cur_datetime,
CreateId="wesley",
)
else:
if kw["createtime"] == "":
createtime = cur_time
else:
time_strct = time.strptime(keywords["createtime"], "%Y-%m-%d %H:%M:%S")
createtime = datetime(
time_strct.tm_year,
time_strct.tm_mon,
time_strct.tm_mday,
time_strct.tm_hour,
time_strct.tm_min,
time_strct.tm_sec,
)
item = BillingItem.get(kw["id"])
item.ItemDescription = kw["itemdescription"]
item.ItemUnitCost = kw["itemunitcost"]
item.ItemType = kw["itemtype"]
item.ItemDiscountMaxAllowed = kw["itemdiscountmaxallowed"]
item.ItemStatus = kw["itemstatus"]
item.ModifyTime = cur_datetime
item.ModifyId = "wesley"
item.CreateTime = kw["createtime"]
item.CreateId = kw["createid"]
hub.commit()
hub.end()
turbogears.flash("Changes saved!")
raise cherrypy.HTTPRedirect(turbogears.url("/billing/edit_item?id=" + str(item.id)))