it looks like you are trying to have places (facilities) which accept reservations (by being listed as available for scheduling - you are trying to do this by listing them in a widget??)...
Is this about right? On Tue, Jun 30, 2009 at 8:29 AM, annet <[email protected]> wrote: > > I have two tables which read like: > > db.define_table('facility', > db.Field > ('facility',length=42,default='',notnull=True,unique=True), > db.Field('in_widget',type='boolean',default=False,notnull=True), > migrate='facility.table') > > > db.define_table('facilitytime', > db.Field > ('company',db.company,default='',notnull=True,ondelete='CASCADE'), > db.Field('facility',length=42,default='',notnull=True), > db.Field > ('day',db.dag,default='',notnull=True,ondelete='RESTRICT'), > db.Field('from_time',type='time',default='',notnull=True), > db.Field('to_time',type='time',default='',notnull=True), > db.Field('created_on',type='datetime'), > db.Field('modified_on',type='datetime'), > migrate='facilitytime.table') > > > Field facility in table facilitytime should be a options widget based > on the facility field in table facility. The facility should only be > contained in the widget when in_widget is True and key and value > should read the same. > > I searched the group for an example but I couldn't find one I > completely understand. > > I suppose in the model I need something like: > > db.facilitytime.facility.widget=lambda f,v: facilitywidget(f,v,...) > > > the ... should be replaced with the facilities from this SQLRows > object: > > facilityrows=db(db.faciliteit.in_widget==True).select > (db.faciliteit.faciliteit) > > > The widget should go in a module: > > def facilitywidget(field,value,options): > id='%s_%s' % (field._tablename,field.name) > else: raise SyntaxError, "widget cannot determine options" > opts+=[OPTION(v,_value=k) for k,v in options] > return SELECT(*opts,**dict > (_id=id,_class=field.type,_name=field.name > ,value=value,requires=field.requires)) > > > I hope one of you knows how to build this widget. > > > Kind regards, > > Annet. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
