I have a PostreSQL database that functions as a person search. The search form can be viewed here:
anybirthday.info
The domain used will reside on the same server as the database but will not be anybirthday. I will provide the domain to interested persons.
I need a membership site built with the same search functionality as is found at the current search form on anybirthday. There will be two levels of free access and three levels of paid access. Free and unregistered users can make up to three queries per day and free registered users can make up to ten queries per day. Free users can elect to pay for individual records or upgrade to a monthly subscription.
There needs to be an admin section that enables admin to select what fields each user classification can view and query by. For example a free site visitor may only be allowed to search by first and last name where a paid user could query the data by additional selects and yet a higher level of paid user could search using even more selects or even wild cards depending on the user access level.
Admin needs the ability to change price or offer limited time trial offers. There must be a limit on how many times an IP address can query within a minute. Any paid users account can only be accessed by one user (one IP) at a time.
The search query results should combine any records where the last name, first two letters of the first name and complete date of birth match and present these results as one record that must be clicked on to view. The initial preview will only show the name, year of birth and city and state. The complete date of birth, middle initial or address must be reserved for paid users only. When the information is in the database the initial results will show if we have the information.
Paid members will be allowed to run 1,000 queries a month but can only open as many records as are included in their billing plan. If they want more than the set amount they must upgrade to a higher plan. Every record that is selected and opened must be stored in the users membership section showing the date, time, what was queried and what was opened. This is for audit and tracking purposes.
Visitors can opt out and have their information removed from the database for a fee. This needs to be built in to the system and they must agree to the monthly fee for us to have the script automatically search the database for any records that match their last name, full date of birth and first two letters of the first name. These records are suppressed. They are not deleted but do not appear to other users. There is an exception to this as a few users will have access to these but those are limited to law enforcement or our internal staff.
If there is a reason for doing so these system requirements can be modified upon agreement by both of us. I can be flexible on this but this is a general idea of how I need the system to function.
If you are awarded this project and more than one week passes without communication I will assume you are no longer working on the project and cancel it. Please be specific in your time line and assure you work within it.
Thank you for your consideration.
