Everton a maneira mais fácil de fazeres isto é com um campo computado
# Modelo
db.define_table("servicos",
Field('empresa', 'reference empresa', label='Empresa'),
Field('cliente', 'reference cliente', label='cliente'),
Field("contrat_ini","date",label='Inicio do Contrato'),
Field("contrat_fim","date", label='Fim do Contrato'),
Field("tempo_ctr","integer", writable=False, compute=
lambda row: (row.contrat_fim - row.contrat_ini).days)
)
# Controlador
def ver_todos_projetos():
db.servicos.id.readable = False
headers = {'servicos.id': 'ID',
'servicos.empresa': 'Empresa',
'servicos.cliente': 'Cliente',
'servicos.contrato': 'Contrato',
'servicos.bacia': 'Bacia',
'servicos.contrat_ini': 'Data Início Contrato',
'servicos.contrat_fim': 'Data do Fim do Contrato',
'servicos.tempo_ctr': 'Tempo em Dias'}
grid = SQLFORM.grid(db.servicos, headers=headers, maxtextlength=64,
paginate=25, deletable= False, user_signature = False)
return dict(grid=grid)
Everton next time please speak english as this is an international board,
if your english is bad that's okay, bad english is the most spoken language
in the world.
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
