I found a way
I made a hard edit in the /gluon/tools.py
I'm trying now to find a way to override that in the Controller
and translate the texts/ change the HTML that renders
will great if there is an API to do this
{{ }}' s
---
def get_query(self, field, op, value, refsearch=False):
try:
if refsearch: format = self.get_format(field)
if op == 'equals':
return field == value if not refsearch else \
lambda row: row[field.name][format] == value
elif op == 'not equal':
return field != value if not refsearch else \
lambda row: row[field.name][format] != value
elif op == 'greater than':
return field > value if not refsearch else \
lambda row: row[field.name][format] > value
elif op == 'less than':
return field < value if not refsearch else \
lambda row: row[field.name][format] < value
elif op == 'starts with':
return field.like(value+'%') if not refsearch else \
lambda row: str(row[field.name]
[format]).startswith(value)
elif op == 'ends with':
return field.like('%'+value) if not refsearch else \
lambda row: str(row[field.name]
[format]).endswith(value)
elif op == 'contains':
return field.like('%'+value+'%') if not refsearch else
\
lambda row: value in row[field.name]
[format]
except:
return None
def search(self, *tables, **args):
table=tables[0]
fields=args.get('fields',None)
request = self.environment.request
db = self.db
if not (isinstance(table, db.Table) or table in db.tables):
raise HTTP(404)
tbl = TABLE()
selected = []; refsearch = []; results = []
ops = ['', 'equals', 'not equal', 'greater than', 'less than',
'starts with', 'ends with', 'contains']
query = table.id > 0
for fieldname in fields or table.fields:
field = table[fieldname]
chkval = request.vars.get('chk' + fieldname, None)
txtval = request.vars.get('txt' + fieldname, None)
opval = request.vars.get('op' + fieldname, None)
row = TR(TD(INPUT(_type = "checkbox", _name = "chk" +
fieldname,
value = chkval == 'on')),
TD(field),TD(SELECT(ops, _name = "op" +
fieldname,
value = opval)),
TD(INPUT(_type = "text", _name = "txt" +
fieldname,
_value = txtval, _id='txt' + fieldname,
_class = str(field.type))))
tbl.append(row)
if chkval:
if txtval and opval != '':
if field.type[0:10] == 'reference ':
refsearch.append(self.get_query(field,
opval, txtval, refsearch=True))
else:
value, error = field.validate(txtval)
if not error:
### TODO deal with 'starts with', 'ends
with', 'contains' on GAE
query &= self.get_query(field, opval,
value)
else:
row[3].append(DIV(error,_class='error'))
selected.append(field)
form = FORM(tbl,INPUT(_type="submit"))
if selected:
try:
results = db(query).select(*selected, **args)
for r in refsearch:
results = results.find(r)
except: # hmmm, we should do bettere here
results = None
return form, results
On Jun 17, 8:41 pm, "mr.freeze" <nat...@freezable.com> wrote:
> I will make a patch to enable this.
>
> On Jun 17, 4:24 pm, rochacbruno <rochacbr...@gmail.com> wrote:
>
>
>
> > Sorry, I answered only to the author..
>
> > This code:
> > def crudsearch():
> > form=crud.search(db.posts)
> > return dict(form=form)
>
> > returns a form like that:http://twitpic.com/1xmrao/full
>
> > I know how to deal with the forms that way, but I'm talking about the
> > search controls that holds operators ( greater, equals, starts.. etc)
> > is there any way to access and modify these controls, just as we do
> > with form controls?
>
> > tks
>
> > {{ }}'s
>
> > On Jun 17, 12:30 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > crud.settings.formstyle='table2cols' or 'table3cols' or 'divs' or 'ul'
>
> > > and for every field you have
>
> > > db.table.field.label='...'
> > > db.table.field.comment='...'
> > > db.table.field.wdiget=....
>
> > > On Jun 17, 8:35 am, rochacbruno <rochacbr...@gmail.com> wrote:
>
> > > > hello I did not find any documentation or example explaining how to
> > > > customize a form created with crud.search()
> > > > I would like to change the text displayed on the operators (dropdown)
> > > > and change layout that other controls are displayed
>
> > > > I can do that with Jquery and CSS, but I want to know which options I
> > > > have in Action level,
>
> > > > I tried consulting the crud.search on shell, some properties are
> > > > displayed and I will play a lot with them, before doing that, I want
> > > > to know if someone has any example or a resource link.
>
> > > > anybody does?
>
> > > > Thanks
>
> > > > { }'s
> > > > --http://rochacbruno.com.br
