Additional search interface for an existing web app

This project is about adding new search functionality to an existing web site. Completion is required within four weeks, or 160 hours, of beginning working on it, whichever comes first.

This fairly advanced, TurboGears 2.1-based web application already offers search interfaces for both charities and funding sources. It uses SQLAlchemy with a PostgreSQL database and a pair of PL/Python stored procedures that provide Xapian full-text search.

This project requires a senior Python web developer with good database modeling skills (including familiarity with data cubes) and is comfortable with extending a jQuery, AJAX-y front-end. Source control is performed with git. Decent English communication skills, both written and spoken, are needed. Bonus points if you speak French too.

A good amount of existing code can be re-used and/or extended, as this additional search interface resembles an existing one (funders search) and also re-uses its data.

Here are the details:

A. From the "Search for People" tab, a user can enter a name in the text search box to try and find that person and the foundation they are associated with.

- the text search only indexes board members of foundations (not charities).

- search results should return both current and past board members

- only return a given name once per foundation. Ex. Margaret Cochrane si listed as being on the board of the Evergreen foundation in 2010,2009,2006 and on the board of the Greenbelt Foundation in 2003,2004. We don't know if it's the same person on both boards, so in the results we return Margaret Cochrane once for the Evergreen foundation (listing her 2010 position) and once for the Greenbelt foundation (listing her her 2004 position)

B. From the "Search for People" tab, a user can select different elements from the browsing widget and see the people who are associated with the foundation corresponding to the selected criteria.

- The browsing widget is the same as the one used on the "Search for Funders" tab, i.e. it has the same categories and functions the same.

- Instead of returning a list of foundations that match the selected criteria, it returns current and past board members of those same foundation.

- Only return the a given name once per foundation. Ex: Daniel Drouet was Treasurer of Mega Foundation in 2010, Secretary in 2009 and Member in 2008. In the results only return "Daniel Drouet" once, using his most recent position (Treasurer) and indicate his status ("Current" if he is listed as a board member in the most recent T-3010 for that foundation).

- See attached mockup "[url removed, login to view]" for details

C. A user can also select some criteria from the browsing widget and enter a name to search. In this case the text search operates only on the board members of the foundations matching the criteria selected.

- See attached mockup "search for [url removed, login to view]"

D. Each result returned contains, a person's name, the foundation they are associated with, the city and province that foundation is located in and the tags associated with the foundation. Clciking on the person's name takes you to their profile page. Clicking on the foundation's name, takes you to the foundation's profile page.

- see attached mockup "[url removed, login to view]" for details.

FULL DISCLOSURE

As can be deduced from the hourly rate budget of this project, we're looking for a developer from places like the Philippines, Eastern Europe, India, etc. We're a young company that hasn't got (yet) the bigger budgets that older companies can afford. We're nevertheless open to negotiation if you've got the right experience.

This particular project is also a test project. We'd like to hire for the long term the developer who will have demonstrated his/her skills through this contract.

HTML jQuery / Prototype Linux Python SQL

Nº del proyecto: #1352233

Sobre el proyecto