Ross, I am currently trying to build a time clock app as well but I'm new to web2py (and fairly new to programming in general), I would love to be able to ask some questions.
On Thursday, March 10, 2011 7:18:34 AM UTC-7, Ross Peoples wrote: > > Let's not forget about SQLFORM.factory either. This lets you create a > SQLFORM based on a virtual table that you create as an argument to > SQLFORM.factory. For example, I used this code to provide edit capabilities > when editing time clock entries for an app I'm writing. It includes form > validation, and I wrote a module that handles the actual db update. When > you see "timeclock.edit_entry(....)", this is just handing off the form > variables to the module, which performs extra validation on the data before > committing it to the db. NOTE: All of this code is inside my "def edit():" > function. > > def validate_form(form): > users = [auth.user.id] > for user in user_security.get_subordinates(auth.user): > users.append(user.auth_user.id) > > if int(form.vars.auth_user) not in users: > form.errors.adjusted_start = "You do not have permission to > modify this person's time clock." > > if not request.args(0): raise HTTP(400, 'Timeclock ID not found') > timeclock_id = request.args(0) > timeclock_entry = db(db.timeclock.id==timeclock_id).select().first() > if timeclock_entry is None: raise HTTP(400, 'Timeclock ID not found') > > form = SQLFORM.factory( > Field('adjusted_start', 'datetime', requires=IS_NOT_EMPTY()), > Field('adjusted_end', 'datetime'), > Field('reason', 'text', requires=IS_NOT_EMPTY()), > Field('auth_user', db.auth_user, readable=False, writable=False), > hidden = {'id': timeclock_id, 'auth_user': > timeclock_entry.auth_user.id} > ) > form.vars.auth_user = timeclock_entry.auth_user.id > form.vars.adjusted_start = timeclock_entry.adjusted_start > form.vars.adjusted_end = timeclock_entry.adjusted_end > if form.accepts(request.vars, session, keepvalues=True, > onvalidation=validate_form(form)): > row_id = timeclock.edit_entry(auth.user, timeclock_entry, > form.vars.reason, form.vars.adjusted_start, form.vars.adjusted_end) > if isinstance(row_id, str): > response.flash = row_id > else: > redirect(URL('index')) > > return dict(form=form, timeclock_entry=timeclock_entry, > history=history) > -- --- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.