We are looking to build a simple cooperative companies database for our very small company and be able to search any word in it, the process we need is as per the following:
1- Back-end page that 100% supports iPhone & Computer to input the company name, province & city (drop down menu), upload photos & a video, 2 business cards & PDF Catalog, 5 KEYWORDS*, delivery time, Contact details, Opinions, year established, a tab to show whether company was visited or not (Verified / Unverified) & some other information, another pop-up page that creates a table at the end to be added "when needed", the page includes product name & photo, and then the table to write size & price.... the most important is the entry dates & information collection date... and when clicking on submit button it automatically sends an email with the front-end HTML Page to the email including attachments.
2- Front-end page that can show all the entries we had inputted from the back-end page in a very good design, this page would be called company profile where we can see photos (all), see name card, download the PDF catalogue, see keywords & the prices table that includes the photo & prices etc, in this page also would generate an automatic bar-code & Code (S0001) for this supplier
3- Search page results that shows the queries, the search can be done by KEYWORD* & company name (Any name).... The search results can be filtered by province, submission date, verified & City.
4- Keywords are 5 different forms that we fill inside it the products names, the 1st keyword form has the very main item that this company has and marked by green, the 2nd form has the second important item with yellow, the 3rd form is the 3rd important item marked with orange and so on other different colors, when in the search field we input Mobile, the result shows the companies with word Mobile in their first field with green small logo as priority, and then shows company's with Mobile in the second keyword in yellow, and so on till it arrives to red.
5- Search results shows company name, 3 products photos, established date, year visited, Province & city and ALL Keywords (Products).
6- Back-end page can be accessed by a username & password.
Attached are the main ideas photos for your reference, we need similar (if not better) than it... Please bid ONLY after you fully understand the above.