I want to start using a smartgrid to browse a couple of tables as an admin
tool.
There are a couple of companies using the same database.
When an admin edits an 'Offer' I want them to be able to change the
user_id. Effectively assigning the offer to a different staff member in the
event of staff changes or holidays etc.
The problem is the drop down menu shows all users in the database, not just
the users which belong to the company in question.
db.define_table(
'offer',
Field('offer_number', 'integer', unique=True, label = T('Offer Number'
)),
Field('user_id','reference auth_user', label = T('Created By'),
ondelete = 'SET NULL'),
Field('customer_id','reference customer', requires=IS_NOT_EMPTY(),
label = T('Customer Name')),
Field('reseller_id','reference reseller', requires=IS_NOT_EMPTY(),
label = T('Business Name')),
Field('created_on', 'datetime', default=request.now, writable=False,
label=T('Created On')),
Field('updated_on', 'datetime', default=request.now, writable=False,
label=T('Updated On')),
singular = T('Offer'),
plural = T('Offers'),
)
db.define_table(
'remarks',
Field('offer_id', 'reference offer', requires=IS_NOT_EMPTY()),
Field('remorder', 'integer', label=T('Postion')),
Field('remark', 'text', label=T('Remarks')),
singluar = T('Remark'),
plural = T('Remarks'),
)
and the grid:
@auth.requires_membership('business leader')
def offers():
pagetitle = 'offers'
buttongroup = []
db.offer.offer_number.writable = False
db.offer.reseller_id.writable = False
db.offer.reseller_id.readable = False
# db.offer.user_id.writable = False
pagecontent = SQLFORM.smartgrid(
db.offer,
details = False,
constraints = {
'offer' : db.offer.reseller_id == session.auth.user.reseller_id,
},
linked_tables = [
'offer',
'remarks',
],
fields = {
'offer' : [
db.offer.offer_number,
db.offer.user_id,
db.offer.customer_id,
db.offer.created_on,
db.offer.updated_on,
],
},
)
response.view = 'tooladmin_core.html'
return dict(
pagetitle = pagetitle,
buttongroup = buttongroup,
pagecontent = pagecontent,
)
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
