it seems can't handle compute for datetime diff between tables in database
side, i've found the clue on controller side :
*db.py*
db.define_table('check_out',
Field('check_in', 'reference check_in'),
Field('room', 'reference room'),
Field('guest', 'reference guest'),
Field('description', 'text'),
* Field('duration'),*
format='%(guest)s %(room)s')
*default.py*
def __onvalidation_check_out(form):
if form.vars.check_in:
rows = db(db.check_in.id==form.vars.check_in).select()
for row in rows:
form.vars.room = row.room
form.vars.guest = row.guest
* form.vars.duration = request.now - row.created_on*
else:
form.errors.check_in = 'cannot be empty'
def check_out():
query = db.check_out.is_active==True
grid=SQLFORM.grid(query, user_signature=False,
onvalidation=__onvalidation_check_out)
return locals()
*output result for duration :*
0:00:11.680686
7 days, 0:01:19.547619
best regards
--
---
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/groups/opt_out.
