Well, one of the issues is going to be that you are using 'date' for your
fields instead of 'datetime'. When using 'datetime', it becomes easy to do
something like this:
delta = row.employee_logout_date - row.employee_login_date
minutes = delta.minutes + (delta.hours * 60)
On Monday, February 27, 2012 11:54:56 AM UTC-5, Sanjeet Kumar wrote:
>
> I am going to develop the time management sheet for that i have the one
> table name employee table and i am allready taken the login and logout time
> and i want to substract the time when i substract the time it show me in
> nanoseconds when i convert this nanosecond to the minute it totally
> confused me so if any one have solution please help me following is my
> controller and database :-
> *
> Table:-*
>
> db.define_table('employee_detail',
> Field('employee_id'),
> Field('employee_name'),
> Field('employee_login_date','date'),
> Field('employee_logout_date','date'),
> Field('employee_login_time'),
> Field('employee_logout_time'),
> Field('total_time'))*
>
> Controller:-*
>
> def lgin(form):
> import datetime
> import time
> currentdate=datetime.date.today()
> now = time.localtime(time.time())
> session.sttime=time.time()
> currenttime = time.strftime("%H:%M:%S", now)
> session.time = currenttime
> #response.flash=currentdate
> for row in db(db.auth_user.email ==
> auth.user.email).select(db.auth_user.first_name):
> firstname=row.first_name
> db.employee_detail.insert(employee_id = auth.user.email,
> employee_name=firstname, employee_login_date=currentdate,
> employee_login_time=currenttime)
> return ''
>
> def lgout(usr):
> import datetime
> import time
> currentdate=datetime.date.today()
> now = time.localtime(time.time())
> ettime=time.time()
> duration = ettime-session.sttime
> du = str(duration / 60000000000)
> currenttime = time.strftime("%H:%M:%S", now)
> db((db.employee_detail.employee_id == auth.user.email) &
> (db.employee_detail.employee_login_date == currentdate) &
> (db.employee_detail.employee_login_time ==
> session.time)).update(employee_logout_date=currentdate,
> employee_logout_time=currenttime, total_time=du)
> return ''
>
>
>
On Monday, February 27, 2012 11:54:56 AM UTC-5, Sanjeet Kumar wrote:
>
> I am going to develop the time management sheet for that i have the one
> table name employee table and i am allready taken the login and logout time
> and i want to substract the time when i substract the time it show me in
> nanoseconds when i convert this nanosecond to the minute it totally
> confused me so if any one have solution please help me following is my
> controller and database :-
> *
> Table:-*
>
> db.define_table('employee_detail',
> Field('employee_id'),
> Field('employee_name'),
> Field('employee_login_date','date'),
> Field('employee_logout_date','date'),
> Field('employee_login_time'),
> Field('employee_logout_time'),
> Field('total_time'))*
>
> Controller:-*
>
> def lgin(form):
> import datetime
> import time
> currentdate=datetime.date.today()
> now = time.localtime(time.time())
> session.sttime=time.time()
> currenttime = time.strftime("%H:%M:%S", now)
> session.time = currenttime
> #response.flash=currentdate
> for row in db(db.auth_user.email ==
> auth.user.email).select(db.auth_user.first_name):
> firstname=row.first_name
> db.employee_detail.insert(employee_id = auth.user.email,
> employee_name=firstname, employee_login_date=currentdate,
> employee_login_time=currenttime)
> return ''
>
> def lgout(usr):
> import datetime
> import time
> currentdate=datetime.date.today()
> now = time.localtime(time.time())
> ettime=time.time()
> duration = ettime-session.sttime
> du = str(duration / 60000000000)
> currenttime = time.strftime("%H:%M:%S", now)
> db((db.employee_detail.employee_id == auth.user.email) &
> (db.employee_detail.employee_login_date == currentdate) &
> (db.employee_detail.employee_login_time ==
> session.time)).update(employee_logout_date=currentdate,
> employee_logout_time=currenttime, total_time=du)
> return ''
>
>
>
On Monday, February 27, 2012 11:54:56 AM UTC-5, Sanjeet Kumar wrote:
>
> I am going to develop the time management sheet for that i have the one
> table name employee table and i am allready taken the login and logout time
> and i want to substract the time when i substract the time it show me in
> nanoseconds when i convert this nanosecond to the minute it totally
> confused me so if any one have solution please help me following is my
> controller and database :-
> *
> Table:-*
>
> db.define_table('employee_detail',
> Field('employee_id'),
> Field('employee_name'),
> Field('employee_login_date','date'),
> Field('employee_logout_date','date'),
> Field('employee_login_time'),
> Field('employee_logout_time'),
> Field('total_time'))*
>
> Controller:-*
>
> def lgin(form):
> import datetime
> import time
> currentdate=datetime.date.today()
> now = time.localtime(time.time())
> session.sttime=time.time()
> currenttime = time.strftime("%H:%M:%S", now)
> session.time = currenttime
> #response.flash=currentdate
> for row in db(db.auth_user.email ==
> auth.user.email).select(db.auth_user.first_name):
> firstname=row.first_name
> db.employee_detail.insert(employee_id = auth.user.email,
> employee_name=firstname, employee_login_date=currentdate,
> employee_login_time=currenttime)
> return ''
>
> def lgout(usr):
> import datetime
> import time
> currentdate=datetime.date.today()
> now = time.localtime(time.time())
> ettime=time.time()
> duration = ettime-session.sttime
> du = str(duration / 60000000000)
> currenttime = time.strftime("%H:%M:%S", now)
> db((db.employee_detail.employee_id == auth.user.email) &
> (db.employee_detail.employee_login_date == currentdate) &
> (db.employee_detail.employee_login_time ==
> session.time)).update(employee_logout_date=currentdate,
> employee_logout_time=currenttime, total_time=du)
> return ''
>
>
>
On Monday, February 27, 2012 11:54:56 AM UTC-5, Sanjeet Kumar wrote:
>
> I am going to develop the time management sheet for that i have the one
> table name employee table and i am allready taken the login and logout time
> and i want to substract the time when i substract the time it show me in
> nanoseconds when i convert this nanosecond to the minute it totally
> confused me so if any one have solution please help me following is my
> controller and database :-
> *
> Table:-*
>
> db.define_table('employee_detail',
> Field('employee_id'),
> Field('employee_name'),
> Field('employee_login_date','date'),
> Field('employee_logout_date','date'),
> Field('employee_login_time'),
> Field('employee_logout_time'),
> Field('total_time'))*
>
> Controller:-*
>
> def lgin(form):
> import datetime
> import time
> currentdate=datetime.date.today()
> now = time.localtime(time.time())
> session.sttime=time.time()
> currenttime = time.strftime("%H:%M:%S", now)
> session.time = currenttime
> #response.flash=currentdate
> for row in db(db.auth_user.email ==
> auth.user.email).select(db.auth_user.first_name):
> firstname=row.first_name
> db.employee_detail.insert(employee_id = auth.user.email,
> employee_name=firstname, employee_login_date=currentdate,
> employee_login_time=currenttime)
> return ''
>
> def lgout(usr):
> import datetime
> import time
> currentdate=datetime.date.today()
> now = time.localtime(time.time())
> ettime=time.time()
> duration = ettime-session.sttime
> du = str(duration / 60000000000)
> currenttime = time.strftime("%H:%M:%S", now)
> db((db.employee_detail.employee_id == auth.user.email) &
> (db.employee_detail.employee_login_date == currentdate) &
> (db.employee_detail.employee_login_time ==
> session.time)).update(employee_logout_date=currentdate,
> employee_logout_time=currenttime, total_time=du)
> return ''
>
>
>
