Thank a lot Jim I will play a bit with your example... Pretty helpful... I would like to know more about the difference between grid and smartgrid... I just start to read the sqlhtml.py to understand better new grid and smartgrid...
Thanks again. Richard On Wed, Nov 9, 2011 at 4:07 PM, Jim Steil <[email protected]> wrote: > Here is a sample of one of my controllers. > > @auth.requires_permission('**select', db.priceTemplate) > def priceTemplates(): > response.view='list.html' > table = db.priceTemplate > response.title = '%s - %s' % (response.section, table['_plural']) > columns = ['priceTemplate.name', 'priceTemplate.plantId', > 'priceTemplate.iwhsPosition', > 'contactPriceTemplate.**contactId'] > > # Setup Permissions > editable = auth.has_permission('update', table) > create = auth.has_permission('create', table) > deletable = auth.has_permission('delete', table) > details = auth.has_permission('read', table) > > orderby = > dict(priceTemplate=[db.**priceTemplate.name<http://db.priceTemplate.name> > ]) > > db.contactPriceTemplate._**plural = 'Contacts' > > db.contactPriceTemplate.**priceTemplateId.writable = False > db.contactPriceTemplate.**priceTemplateId.readable = False > > grid = SQLFORM.smartgrid(db.**priceTemplate, columns=columns, > orderby=orderby, > create=create, details=details, > editable=editable, deletable=deletable, > csv=False, search_widget=None, > paginate=15, maxtextlength=45) > return dict(grid=grid) > > In it I'm setting read/write capabilities for one of the fields (notice > that it isn't a field in the primary table, but a related table. I'm also > using standard auth to test for permissions (thanks Anthony). I can > control sorting for primary table and related tables. In looking at the > method signature for SQLFORM.grid it appears that formstyle will work just > like it did for CRUD. From what little I know, it would appear to me that > the CSS styling is the same as CRUD so your CSS should work. > > SQLFORM.smartgrid is amazing. If you have your models setup properly you > can get highly sophisticated CRUD forms, with relationships with very > little boilerplate code. Thanks Massimo! > > -Jim > > > On 11/9/2011 2:55 PM, Richard wrote: > >> Hello, >> >> I would like to know I can control generated form with SQLFORM.grid... >> I use to do extensively : >> >> If user and group and permission and row field value: >> crud.table.field.readable =\ >> crud.table.field.writable =False >> form = crud.create, read or update(db.table) >> >> And I customize my form a bit with CSS (crud.settings.formstyle = >> 'divs') so I would like to know if I can recycle my CSS with >> SQLFORM.grid?? >> >> Thanks. >> >> Richard >> >
