Ahoy there. I have just bought this recipe from a seafaring man with one
leg that might solve this matter. I hope you don't find it fishy:
model
# Pretty close to your model aye?
db.define_table("department", Field("name"), format="%(name)s")
db.define_table("myrank", Field("name"), Field("department_id", "reference
department"), format="%(name)s")
db.define_table("seafaring", Field("name"), Field("myrank_id", "reference
myrank", label="Rank"), Field("department_id", "reference department", label
="Department"), format="%(name)s")
# dummy records creation
data = {"kitchen": ["cook", "chef", "assistant"], "deck": ["boatswain",
"maintopman", "sailmaker"]}
if db(db.department).count() <= 0:
for k, l in data.iteritems():
i = db.department.insert(name=k)
for v in l:
db.myrank.insert(department_id=i, name=v)
def department_widget(field, value):
widget = SQLFORM.widgets.options.widget(field, value)
widget.attributes["_onchange"] =
'updateMyRanks(jQuery("[name=department_id]").val());'
return widget
def myrank_widget(field, value):
_id="%s_%s" % (field._tablename, field.name)
script = SCRIPT("""
function updateMyRanks(departmentId){
// remove the ye olde options
jQuery("[name=%(fieldname)s]").html("");
// fish the new ones
web2py_component("%(url)s/myrank/" + departmentId, "%(_id)s");
}
""" % dict(fieldname=field.name, _id=_id,
url=URL(c="default", f="myrank", extension="load")))
return DIV(script, SQLFORM.widgets.options.widget(field, value))
db.seafaring.department_id.widget = department_widget
db.seafaring.myrank_id.widget = myrank_widget
This is the controller
def index():
# the seafaring men census form
form = SQLFORM(db.seafaring)
return dict(form=form)
def myrank():
""" This function returns the rank options for dynamic widget update"""
# write the field custom requisites
db.seafaring.myrank_id.requires = IS_IN_DB(db(db.myrank.department_id==
request.args(1)), 'myrank.id', "%(name)s")
# create a dummy form to extract the widget
form = SQLFORM(db.seafaring)
# here a bit of black magic to return the correct data when loaded as
component
text = "".join([t.xml() for t in form.custom.widget.myrank_id.elements(
"option")])
return text
For the index.html shipmate census form you only need a view like
{{extend "layout.html"}}
{{=form}}
Now, if you go a-rowing to <app>/default/index.html and select a
department, the options set should should change to those of the
appropriate department.
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
