def messages():
db = current.db
auth = current.auth
request = current.request
crud = Crud(db)
crud.settings.formstyle = 'table3cols'
crud.settings.keepvalues = True
crud.messages.submit_button = '送信'
crud.messages.delete_label = '削除する'
crud.messages.record_created = 'メッセージを作成しました'
crud.messages.record_updated = 'メッセージを更新しました'
crud.messages.record_deleted = '削除しました'
crud.messages.create_log = 'Message Record %(id)s created'
crud.messages.update_log = 'Message Record %(id)s updated'
crud.settings.create_next = URL('messages')
crud.settings.download_url = URL('download')
crud.settings.create_onaccept = give_create_message_permission
crud.settings.update_ondelete = remove_message_permission
button = A(BUTTON('リストへ戻る'), _href=URL('messages'))
db.messages.to_group.represent = show_to_group
db.messages.to_group.requires = IS_IN_SET(get_to_group_list(), zero=None)
db.messages.created_by.label = '作成者'
db.messages.created_by.readable = True
if (request.args(0) == 'read'):
crud.settings.auth = auth
if auth.has_permission('update', db.messages, request.args(1)):
button += A(BUTTON('編集する'),
_href=URL('messages/update', request.args(1)))
return dict(form=crud.read(db.messages, request.args(1)),
button=button)
if (request.args(0) == 'new'):
return dict(form=crud.create(db.messages), button=button)
if (request.args(0) == 'update'):
crud.settings.auth = auth
db.messages.to_group.writable = False
return dict(form=crud.update(db.messages,
request.args(1),
deletable=True),
button=button)
query = auth.accessible_query('read', db.messages, auth.user.id)
db.messages.title.represent = lambda title, row: A(
title, _href=URL(args=('read', row.id)))
db.messages.id.represent = lambda id, row: ''
form = crud.select(db.messages,
query=query,
fields=['title', 'created_by', 'modified_on', 'id'],
orderby=~db.messages.modified_on,
headers={
'messages.title': '件名',
'messages.created_by': db.messages.created_by.label,
'messages.modified_on': '更新時刻',
'messages.id': ''
})
return dict(form=form, button=A(BUTTON('新規作成'), _href=URL('messages/new')))
def autocomplet():
from gluon.tools import Crud
crud = Crud(db)
form = crud.create(db.product2, next=URL('autocomplet'),message=T("record created"))
persons = crud.select(db.product2, fields=['category'],headers={'product2.category': 'Tipo'})
return dict(form=form, persons=persons)
def people():
from gluon.tools import Crud
crud = Crud(db)
form = crud.create(db.client, next=URL('people'),message=T("record created"))
persons = crud.select(db.client, fields=['name'],headers={'client.name': 'Name'})
return dict(form=form, persons=persons)
def naoFinalizadas():
from gluon.tools import Crud
crud = Crud(db)
avaliacaoes = crud.select(db.AVAL_ANEXO_1,
db.AVAL_ANEXO_1.CIENTE_SERVIDOR == 'F',
fields=[
db.AVAL_ANEXO_1.id,
db.AVAL_ANEXO_1.ANO_EXERCICIO,
db.AVAL_ANEXO_1.SIAPE_SERVIDOR,
db.AVAL_ANEXO_1.SIAPE_CHEFIA
])
return dict(avaliacoes=avaliacaoes)
