Thanks Massimo
On Tue, Feb 28, 2012 at 10:33 AM, Massimo Di Pierro <
massimo.dipie...@gmail.com> wrote:
> Delta has only days and seconds.
>
> On Feb 27, 9:55 pm, Sanjeet Kumar <sanjeet....@gmail.com> wrote:
> > showing AttributeError: 'datetime.timedelta' object has no attribute
> 'minutes'
> >
> >
> >
> >
> >
> >
> >
> > On Tuesday, February 28, 2012 1:47:40 AM UTC+5:30, Ross Peoples wrote:
> >
> > > 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 ''
>
