Esempio n. 1
0
def searchCompany():
    rawSearchterm = (request.args.get('name', ''))
    html = HTMLHEAD
    unquotedTerm = urllib.unquote(rawSearchterm).upper()
    liketerm = Company.sqlrepr('%%%s%%' % unquotedTerm)
    sqlquery = "company.name LIKE %s" % liketerm
    html += '<h2>Company Search results</h2><h3>searching for %s</h3><ul>' % sqlquery
    people = Company.select(sqlquery)
    for thisone in people:
        if not thisone.hidden:
            html += "<li><a href='%s/company/id/%s'>%s</a></li>" %(BASEURL, thisone.recordid, thisone.name)
    html += '</ul>'
    html += HTMLTAIL
    return html
Esempio n. 2
0
 def get(self, rawSearchterm = u''):
     if rawSearchterm is u'':
         arguments = parse_qs(self.request.query)
         rawSearchterm = arguments.get('name')[0] 
     html = HTMLHEAD
     unquotedTerm = urllib.unquote(rawSearchterm).upper()
     liketerm = Company.sqlrepr('%%%s%%' % unquotedTerm)
     sqlquery = "company.name LIKE %s" % liketerm
     html += '<h2>Company Search results</h2><h3>searching for %s</h3><ul>' % sqlquery
     people = Company.select(sqlquery)
     for thisone in people:
         if not thisone.hidden:
             html += "<li><a href='%s/company/id/%s'>%s</a></li>" %(BASEURL, thisone.recordid, thisone.name)
     html += '</ul>'
     html += HTMLTAIL
     self.write(html)
Esempio n. 3
0
 def get(self, rawSearchterm=u''):
     if rawSearchterm is u'':
         arguments = parse_qs(self.request.query)
         rawSearchterm = arguments.get('name')[0]
     html = HTMLHEAD
     unquotedTerm = urllib.unquote(rawSearchterm).upper()
     liketerm = Company.sqlrepr('%%%s%%' % unquotedTerm)
     sqlquery = "company.name LIKE %s" % liketerm
     html += '<h2>Company Search results</h2><h3>searching for %s</h3><ul>' % sqlquery
     people = Company.select(sqlquery)
     for thisone in people:
         if not thisone.hidden:
             html += "<li><a href='%s/company/id/%s'>%s</a></li>" % (
                 BASEURL, thisone.recordid, thisone.name)
     html += '</ul>'
     html += HTMLTAIL
     self.write(html)