I have a table of companies that offer variable services, what i want is to
enable my users to search for companies that offer a desired service *(which
i have been able to achieve)* and then from that very list of companies
displayed in that page be able to filter through them and search for
companies in a desired location offering that very same service *(this is
where i am facing a problem)* how do i achieve this because?? In terms of
searching I can only search for companies in a desired location but can not
combine my search to only display those of the searched service!
*MODEL*:
db.define_table('locations',
Field('name'),
format='%(name)s')
def name_of(location): return '%(name)s' % location
db.define_table('business',
Field('logo', 'upload'),
Field('company_name', requires=IS_NOT_EMPTY()),
Field('services', 'reference services'),
#Field('tlamelo', 'reference tlamelo'),
Field('product', 'reference product'),
Field('tel', requires=IS_NOT_EMPTY()),
Field('email', requires=IS_NOT_EMPTY()),
Field('fax', requires=IS_NOT_EMPTY()),
Field('cell', requires=IS_NOT_EMPTY()),
Field('facebook', requires=IS_NOT_EMPTY()),
Field('twitter', requires=IS_NOT_EMPTY()),
Field('website', requires=IS_NOT_EMPTY()),
Field('postal_address', requires=IS_NOT_EMPTY()),
Field('place', 'reference locations'),
Field('located_at', requires=IS_NOT_EMPTY()))
*CONTROLLER*:
def companies():
results=db.services(request.args(0))
rslts=db(db.business.services==results.id).select(db.business.ALL,
orderby=db.business.company_name)
services=len(rslts)
form=SQLFORM.factory(Field('query', requires=IS_NOT_EMPTY(), label=SPAN(
'', _style="font-weight: bold;"), widget = lambda field, value: SQLFORM.
widgets.string.widget(field, value, _class='my-string', _id='searching',
_placeholder='LOCATION')))
searchBtn=form.element('input',_type='submit')
searchBtn['_style'] = 'display:none;'
if form.accepts(request):
tokens=form.vars.query.split()
query=reduce(lambda a,b:a&b, [db.locations.name.contains(k) for k in
tokens])
location=db(query).select(orderby=db.locations.name)
else:
location=[]
return locals()
def Results():
results=db.locations(request.args(0))
results2=db.services(request.args(0))
#THIS IS WHERE I AM ATTEMPTING TO SELECT SERVICE PROVIDERS OF THE DESIRED
SERVICE IN A DESIRED LOCATION BUT THE ALGORITHM IS WRONG WHERE IT IS MARKED
IN RED, HOW CAN I SELECT BOTH THE SERVICE AND LOCATION TO BE DISPLAYED IN
THE OTHER PAGE???
rslts=db(db.business.place==results.id).select(db.business.services==
results2.id)
services=len(rslts)
return locals()
*VIEW*
{{extend 'layout.html'}}
{{for company in rslts:}}
{{=company.company_name}}<br />
{{pass}}
I hope my question is clear.
Please help me, anyone???* (sad emojis)*
Mostwanted
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
