Summary: Create search facility that looks through separate databases extracting collated search results with links. Added functionality of creating statistical information is needed, as is auditing of admin. Formatting of display not required, just raw data output. I’ll add formatting, graphics, etc. to keep down costs as much as possible, being part of a start-up project. Component 1: Simple Admin Control Panel (ACP) SECURITY is the most important consideration here! The final application will run from a secure server, and details of database connection information must not be intercepted in any way. Any scripts MUST NOT be able to run externally. Function - Provide secure access to admin area for entering in details into a secure database. Admin actions must be recorded in audit trail. Master ACP access: - Create/Administer users - Perform data backup & restore Normal ACP access: - Create/Edit/Delete search-records - View/Print/Export search-statistics Search-records information stored in the secure database: MySQL: - hostname, database name, username, password Additional - Shop description, Shop URL, Shop Logo (.JPG/.GIF), Shop keywords Component 2 - Search Facility Function - Allow search through multiple shop databases (using stored database connection data), giving list of products matching search criteria/ suggestions to like products if criteria isn’t met. Search should include products titles & descriptions, Categories should also be searched. The results list should give: - Product/Category Name with URL links - Product Price (not if category) - Shop Logo/Shop name Search keywords should be recorded for admin stats analysis Component 3 - Shop Listing Function - List shops by type (keywords) to aid search engines in finding shops. Shops listed 2 ways - keyword & shop name. Output: - Shop logo & Name (With URL links), description, keywords
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
The system will be running on a Linux platform apache server with php/MySQL.