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")
def ver_todos_projetos():
db.servicos.id.readable = False
query = ((db.servicos.id > 0))
trabalhos = db(db.servicos.contrat_fim == None).select()
for r in trabalhos:
db(db.servicos.id == r.id).update(tempo_ctr = (contrat-fim -
contrat_ini).date)
fields = (db.servicos.id, db.servicos.empresa,
db.servicos.contrato, db.servicos.cliente, db.servicos.bacia,
db.servicos.contrat_ini, db.servicos.contrat_fim, db.servicos.tempo_ctr)
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(query=query, fields=fields, headers=headers,
maxtextlength=64, paginate=25, deletable= False, user_signature = False)
return dict(grid=grid)
Que estou fazendo errado?????
Alguma ajuda?
--
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.
