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
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)
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)
def get(self, companyid=u''): companyid = getarg(companyid, 'id') try: companyid = int(companyid) record = Company.byRecordid(companyid) except (ValueError, SQLObjectNotFound): self.quitWithMsg('No company with ID %s' % companyid) return if record.hidden: self.quitWithMsg('Company %s is not currently available' % companyid) return subscribers = record.subscribers directors = record.directors html = '<h1>%s</h1>' % record.name companyurl = 'https://www.registro-publico.gob.pa/scripts/nwwisapi.dll/conweb/MESAMENU?TODO=SHOW&ID=%s' % record.recordid html += '<h3><a href="%s">Full Details</a></h3>' % companyurl html += '<h2>Directors</h2><ul>' for director in directors: if not director.hidden: html += '<li><a href="%s/person/%s">%s</a> %s </li>' % ( BASEURL, director.name, director.name, google( director.name)) html += '</ul>' html += '<h2>Subscribers</h2><ul>' for subscriber in subscribers: if not subscriber.hidden: html += '<li><a href="%s/person/%s">%s</a></li>' % ( BASEURL, subscriber.name, subscriber.name) html += '</ul>' agentlist = record.agent if len(agentlist): agent = agentlist[0] if not agent.hidden: html += '<h2>Agent</h2>' html += '<ul><li><a href="%s/person/%s">%s</a></li></ul>' % ( BASEURL, agent.name, agent.name) if record.registerdate: html += '<h3>Date Registered</h3>' html += record.registerdate.strftime('%F') html += '<h3><a href="https://www.registro-publico.gob.pa/RediWeb/default.asp">Look up complete file</a></h3> </br>' html += '(search for %s as "Numero de Ficha")' % record.recordid self.write(html)
def get(self, companyid=u''): companyid = getarg(companyid, 'id') try: companyid = int(companyid) record = Company.byRecordid(companyid) except (ValueError, SQLObjectNotFound): self.quitWithMsg('No company with ID %s' % companyid) return if record.hidden: self.quitWithMsg('Company %s is not currently available' % companyid) return subscribers = record.subscribers directors = record.directors html = '<h1>%s</h1>' % record.name companyurl = 'https://www.registro-publico.gob.pa/scripts/nwwisapi.dll/conweb/MESAMENU?TODO=SHOW&ID=%s' % record.recordid html += '<h3><a href="%s">Full Details</a></h3>' % companyurl html += '<h2>Directors</h2><ul>' for director in directors: if not director.hidden: html += '<li><a href="%s/person/%s">%s</a> %s </li>' % (BASEURL, director.name, director.name, google(director.name)) html += '</ul>' html += '<h2>Subscribers</h2><ul>' for subscriber in subscribers: if not subscriber.hidden: html += '<li><a href="%s/person/%s">%s</a></li>' % (BASEURL, subscriber.name, subscriber.name) html += '</ul>' agentlist = record.agent if len(agentlist): agent = agentlist[0] if not agent.hidden: html += '<h2>Agent</h2>' html += '<ul><li><a href="%s/person/%s">%s</a></li></ul>' % (BASEURL, agent.name, agent.name) if record.registerdate: html += '<h3>Date Registered</h3>' html += record.registerdate.strftime('%F') html += '<h3><a href="https://www.registro-publico.gob.pa/RediWeb/default.asp">Look up complete file</a></h3> </br>' html += '(search for %s as "Numero de Ficha")' % record.recordid self.write(html)