Hi All,
I'm trying to create a management interface for the following tables, but i
cannot get it to work the way i want.
i'm trying to manage the auth_user table and another table containing a
reference to auth_user. but i cannot get them to show as i'm unsure the
best way to construct the query my code below:
Models
#########player_stats.py#################
db.define_table('player_stats', Field('player', 'reference auth_user'),
Field('events_attended','integer',
default=0),
Field('player_kills','integer', default=0),
Field('player_deaths','integer', default=0)
)
db.player_stats._singular = "Player Stats"
db.player_stats._plural = "Player Stats"
######auth_user extra fields#####
auth.settings.extra_fields['auth_user']= [
Field('IOA_number', writable=False, unique=True, default=IOA_GEN(5,True)),
Field('user_status', default='Active',
requires=IS_IN_SET(['Active','Suspended','Banned'])),
Field('nickname', 'string'),
Field('date_of_birth', 'date', requires=IS_NOT_EMPTY()),
Field('mobile', 'string', requires=IS_NOT_EMPTY()),
Field('phone','string', requires=IS_NOT_EMPTY()),
Field('address_line_1', 'string', requires=IS_NOT_EMPTY()),
Field('address_line_2', 'string'),
Field('address_line_3', 'string'),
Field('city','string', requires=IS_NOT_EMPTY()),
Field('post_code', 'string', requires=IS_NOT_EMPTY()),
Field('county', 'string', requires=IS_NOT_EMPTY()),
Field('country','string', requires=IS_NOT_EMPTY()),
Field('medical_conditions', 'text'),
#########################Manage.py ####################################
db.auth_user.id.readable=False
#Define the fields to show on grid.
fields = (db.auth_user.IOA_number, db.auth_user.first_name,
db.auth_user.last_name, db.auth_user.ioa_team_pref)
#Define headers as tuples/dictionaries
headers = {'auth_user.IOA_number': 'IOA ID',
'auth_user.first_name': 'First Name',
'auth_user.last_name': 'Last Name',
'auth_user.last_name': 'Last Name',
'ioa_team_pref': 'Team Preference',
}
#Default sort order in grid
default_sort_order=[db.auth_user.IOA_number]
#query to select the user profile and player stats
query = (db.auth_user)
form = SQLFORM.grid(query=query, fields=fields, headers=headers,
orderby=default_sort_order,
create=auth.has_membership('Staff'),
deletable=auth.has_membership('Staff'),
editable=auth.has_membership('Staff'), maxtextlength=64, paginate=25)
return dict(form=form)
what i am aftef, when i click on the view/edit buttons i would like to show
field from both auth_user and player_stats. would i need to creating a
custom view file.
Thanks in Advance,
Simon
--
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.
