To answer your question, happen_time is a column of cash_journal. The point of this call, is we allow people to cancel the site within 72 hours so any money they have made in that time if they cancel they do not get. IE: payback_types = ['s','p'], s = sponsor bonus, p = product bonus
We use seconds to be more accurate so if you join at 5pm we count the 72 hours from 5pm now the full day etc.. On Thu, Feb 9, 2012 at 6:40 AM, Bruce Wade <[email protected]> wrote: > Sorry I just seen this message now, I ended up deleting it by accident and > wondering why no-one responded. > > I will try this today. I didn't know there was a seconds() method attached > to the date. Will respond back in a couple of hours when I get to work. > > -- > Thanks, > Bruce > > > On Mon, Feb 6, 2012 at 4:51 AM, Niphlod <[email protected]> wrote: > >> hum.... happen_time is a column of db.cash_journal ? >> and you want only the records that satisfy the conditions on the >> query, and in addition, that the difference in seconds between >> happen_time and now is less than "seconds" (259200) ? >> >> Without a test db I can't confirm, but can you try something along the >> way of (db.cash_journal.happen_time.seconds() < >> time.mktime(now.timetuple()) - seconds) >> >> ? > > > > > -- > -- > Regards, > Bruce Wade > http://ca.linkedin.com/in/brucelwade > http://www.wadecybertech.com > http://www.warplydesigned.com > http://www.fitnessfriendsfinder.com > -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.warplydesigned.com http://www.fitnessfriendsfinder.com
