Finish web based quote system

1. General Description: The task is to create a web based CRM system, using MySQL database and PHP. Suggested MVC framework are Codeignitor. Please note that the job is partially finished (about 70%). (Goto [login to view URL], log in as ABL with no password, you can see what’s finished). Below section describe the overall website function and structure. The detailed list of unfinished work are listed in the 2nd section “Unfinished work” in the file "Pages [login to view URL]". Please mention “UW” in your bid reply. Otherwise your bid will not be considered. Or sky p e arthurbinlu if any question. There are five main database tables (Company, Contact, Project, and Quote, handled by two tables), and 5 corresponding pages (Company, contact, project, view quote/invoice, and edit / new quote/invoice page). Please see attached excel file showing the 5 pages, and the four main database tables, and some other small tables (mainly used to provide drop down combo list source list.). Pages: (page layout see attachement) 1. Project page 2. Company page 3. Contact page 4. Quote / invoice View page 5. New / Edit Quote / invoice page Main database tables: 1. Project (list of project that has multiple companies and contact involved) 2. Company 3. Contact (list of contact person in a company) 4. Quote (list of quote for project. Only contain general quote information, detailed product info is stored in the quotelines table. 5. Quotelines (List of number of different product for each quote) Small tables: (mainly used for pull down selections) 1. Colors 2. Type (company type) 3. Diameter (diameter of the product) 4. Model (model of the product) 5. Pricelist (price list for different product) 6. Region 7. Shape (shape of the product) 8. Source (project lead source) 9. Stage (Project stage) 10. Suspension (product accessory type) 11. Userright (User access control table) 12. Users (User information) Layout: (see first 3 tabs of “[login to view URL]”) 1. First 3 pages have search section at top. Multiple search criteria allowed. Partial match allowed. Click on each search criteria title result in sort based on that field. 2. Underneath the search section is the result display section. 3. When “Add new” button pressed, The first line item become empty, used to add new record. (another option is to leave the first line always empty for new record, if this is too time consuming to implement.) All existing records needs to be able to accept inline editing. However, all data are not stored to database table until “Save” button is pressed. 4. Page 4 and 5 (tab 4 and 5 in the excel file) are almost identical, (page 4 for view only, 5 for edit / new), other than page 5 has extra control and data entry field. Both page has all fields populated from record or user input, and can be modified. But only page 5 has the capacity to save to database table, and calculate results. Users 1. User account has user name and password protection. One user can only access record created by himself or by his employees (listed in table “UserRight”, that he has right to, in the example, user ID 2 “ABL” has right to User ID 1 and 5, so ABL can access all information belongs to all three users). 2. When a user searches anything (company, contact, project, quote, etc.) only record that has his own user ID, or the record with user ID that he has user right to access, will show up in result. (This includes the initial full list, too). Detail about functionality, unfinished work, please read the attached word doc. Explenation of attached files: [login to view URL] Main page views, database table list Pages [login to view URL] description text (most content are listed above already) 0-QSA13xxxxx [login to view URL] Current excel based quote generating file (can be used to understand the quote calculation process) [login to view URL] Partially finished CodeIgnitor source code. (Not posted here. Please request this file)