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)