I would need a way to display my updated rows in line... I just though that I could combine SQLTABLE and for each row of my rows query I could embeded a submit button of each of my forms that I could rename review... Putting all the form fields to hidden I could then make a onvalidation process that update the fields I want to set the records to reviewed... So the user has only to submit each row for review the whole SQLTABLE diplayed rows...
What do you think? Richard On Mon, Dec 12, 2011 at 4:12 PM, Richard Vézina <[email protected] > wrote: > Thanks Anthony... > > Here what I did so far... > > > ## CONTROLLER > def bunch_review_with_multi_form(): > > # Getting lot and test from args or vars... > rows = db((db.lotns_lot_number.id == request.args(1))&\ > (db.lotns_sample.lot_number_id == db.lotns_lot_number.id)&\ > (db[request.args(0)].sample_id == > db.lotns_sample.sample_id)).select\ > (db.lotns_lot_number.lot_number_computed, > db.lotns_sample.sample_code, \ > db[request.args(0)].ALL, orderby=db.lotns_sample.sample_code) > > forms = [] > flag = 0 > for i in rows: > forms.append(SQLFORM(db[request.args(0)], i[request.args(0)].id)) > forms[flag].process(detect_record_change=True) > if forms[flag].record_changed: > response.flash = T('form have changed between the time you > edited and submitted it, please have a look on the data again') > elif forms[flag].accepted: > session.flash = T('form accepted').capitalize() > > #redirect(URL(request.application,c=request.controller,f='read',args=(request.args[0],request.args[1]))) > else: > response.flash = T('please correct the form') > flag+=1 > return dict(forms=forms) > > ###VIEW > {{extend 'layout_form.html'}} > {{for i in range(0,len(forms)):}} > {{=forms[i]}} > {{pass}} > > > I am confuse and I am not sure if my controller can works independently > with each form embeded into forms the way I wrote my controller function... > What's the way you were telling me to do?? > > Thanks > > PS.: Is there any way I can make a multiple lines update with SQLFORM or > .grid or .smartgrid?? > > Richard > > On Mon, Dec 12, 2011 at 2:40 PM, Anthony <[email protected]> wrote: > >> web2py creates a hidden _formname field for each form. If there are >> multiple forms on the page, they must each have a unique _formname. By >> default, SQLFORM creates a _formname based on the table name and type of >> form (and possibly record number), but you can generate your own name via >> the 'formname' argument to form.accepts (or form.validate, or >> form.process). If you want to create update forms, though, you don't have >> to manually fill in the field values -- just pass the record as the second >> argument to SQLFORM. Also, in that case, you'll automatically get a unique >> _formname for each form because the record id becomes part of the >> _formname. See >> http://web2py.com/book/default/chapter/07#SQLFORM-and-insert/update/delete >> . >> >> Also, rather than having a new variable for each form (i.e., form0, >> form1, etc.), which makes the code rather messy, why not just make a list >> of forms? >> >> forms = [] >> forms.append(SQLFORM(...)) # add a new form to the list >> form[i] # to reference the i-th form >> >> You might also consider creating each form as an Ajax component, or at >> least submitting the forms via Ajax, so the whole page of forms doesn't >> have to get re-processed when just a single form is submitted. >> >> Anthony >> >> On Monday, December 12, 2011 1:43:05 PM UTC-5, Richard wrote: >>> >>> Hello, >>> >>> Is there a better way of doing this : >>> >>> def bunch_update_with_multi_form()**: >>> form0=None >>> form1=None >>> form3=None >>> form4=None >>> form5=None >>> form6=None >>> form7=None >>> form8=None >>> form9=None >>> form10=None >>> form11=None >>> form12=None >>> form13=None >>> form14=None >>> form15=None >>> form16=None >>> form17=None >>> form18=None >>> form19=None >>> form20=None >>> form21=None >>> form22=None >>> form23=None >>> form24=None >>> form25=None >>> form26=None >>> form27=None >>> form28=None >>> form29=None >>> form30=None >>> >>> form_num = 0 >>> for i in rows: >>> globals()['form%s'%form_num] = SQLFORM(db[request.args(0)]) >>> for f in db[request.args(0)].fields: >>> if globals()['form%s'%form_num] != None: >>> globals()['form%s'%form_num].**vars[f] = >>> i[request.args(0)][f] >>> if globals()['form%s'%form_num] != None: >>> if globals()['form%s'%form_num].**process().accepted: >>> response.flash = '...' >>> elif globals()['form%s'%form_num].**errors: >>> response.flash = 'form has errors' >>> form_num+=1 >>> return >>> dict(table=table,form0=form0,**form1=form1,form2=form2,form3=** >>> form3,form4=form4,form5=form5,**form6=form6,form7=form7,form8=** >>> form8,form9=form9,form10=**form10,form11=form11,form12=** >>> form12,form13=form13,form14=**form14) >>> >>> When using web2py shell I don't have any problem to execute my loops, >>> but in app I am getting only one correct form on 14... >>> >>> I read in the book that SQLFORM is creating it on unique form >>> identifier but there is no example about that... Should I user SQLFORM >>> in view (put my loop there) to make it works : >>> >>> Thanks >>> >>> Richard >>> >>> >
