vt_list_selector.py

# -*- coding: utf-8 -*-
""" list_selector (virtaul table)

"""
FORMATS = ['bib', 'html', 'odt', 'pdf', 'tex']

#-------------------------------------------------------------------------------
#
# DEFINITION
#
#-------------------------------------------------------------------------------
virtdb.define_table('list_selector',
    Field('year_start', 'integer', default=year),
    Field('year_end', 'integer'),
    Field('id_teams', 'reference teams', label='Team'),
    Field('id_projects', 'reference projects', label='Project'),
    Field('id_categories', 'reference categories', label='Category'),
    Field('author', 'string'),
    Field('id_authors_roles', 'reference authors_roles', label='Role'),
    Field('id_lists', 'reference lists', label='List'),
    Field('format', 'string', default='html'))

virtdb.list_selector.id_authors_roles.requires = IS_IN_DB(db, 'authors_roles.role')
virtdb.list_selector.id_categories.requires = IS_IN_DB(db, 'categories.code')
virtdb.list_selector.id_lists.requires = IS_IN_DB(db, 'lists.list')
virtdb.list_selector.id_projects.requires = IS_IN_DB(db, 'projects.project')
virtdb.list_selector.id_teams.requires = IS_IN_DB(db, 'teams.team')
virtdb.list_selector.format.requires = IS_IN_SET(FORMATS)

#-------------------------------------------------------------------------------
#
# FIELDS CONFIGURATiON
#
#-------------------------------------------------------------------------------
fieldsModifier = dbui.FieldsModifier('list_selector')
fieldsModifier.configure_field('year_start', flex=1)
fieldsModifier.configure_field('year_end', flex=1)
fieldsModifier.merge_fields('year_start', 'year_end', fieldLabel=T('Year'))

fieldsModifier.configure_field('id_lists', selectFirst=True)

fieldsModifier.configure_field('id_authors_roles', emptyText=T('select...'), xtype='xcomboboxuserreset')
fieldsModifier.configure_field('id_categories', emptyText=T('select...'), xtype='xcomboboxuserreset')
fieldsModifier.configure_field('id_projects', emptyText=T('select...'), xtype='xcomboboxuserreset')
fieldsModifier.configure_field('id_teams', emptyText=T('select...'), xtype='xcomboboxuserreset')

#-------------------------------------------------------------------------------
#
# FORM CONFIGURATiON
#
#-------------------------------------------------------------------------------

#-------------------------------------------------------------------------------
#
# GRID CONFIGURATiON
#
#-------------------------------------------------------------------------------

#-------------------------------------------------------------------------------
#
# STORE CONFIGURATiON
#
#-------------------------------------------------------------------------------