PHP/MySQL app - Consumer Guide Generator

No PHP newbies, first project attemptors, or existing app "tweakers" please! GREAT communication skills required to complete this project - so if English is difficult for you, please do not bid. Project Introduction: This app will allow a client to create an account and have password protected access to the ability to generate Consumer Awareness Guides for their business/industry. We need the client to be able to be prompted by a series of interview questions via forms that will take the client's input and assemble a consumer guide based on the input or answers to the questions. The final output will be either a PDF that is printable or a printable html page with page breaks in all the right places so that when the client prints the guide on 8.5 x 11 inch paper, it can be assembled and folded into an 8.5 x 5.5 inch booklet with a few staples in the fold. The system will enable the client to create as many guides as they wish. Also, the client's customers will be able to visit a link provided by this system via email that will allow the client's customers to enter the system and add a testimonial. These testimonials will then be part of the process of a client generating a consumer guide where the last step will ask "would you like to add testimonials to your consumer guide? Then if yes, they will be presented with a list of all testimonials that they can read and select a checkbox for each that should be included at the end of the guide. System users: This is a complete app that will need an admin interface, a client interface, and a customer (customer of the system clients) interface. Example - Let's say John (the client) owns a carpet cleaning business and he wants to offer prosepctive customers a consumer guide to educate them on the pros and cons of hiring a good carpet cleaner. Then let's say John (the client) has a customer named Bob (the customer) - also, let's say John (the client) buys a Consumer Guide Generator service from xyz corp (the admin). That is the relationship of all the users of the system: admin = xyz corp client = John customer = Bob (John's customer) Make sense? If not, then the rest wont make sense... The following are the functions for each user group: Admin functions: ability to add, edit, remove and disable any client account and ability to add/edit/remove any client records and customer testimonials - also, ability to report on total existing accounts and total consumer guides created for each client account. Client functions: Ability to create their own account (we will implement a shopping cart step that will set a cookie upon successful payment that will take the client to the account creation page you code for us) if a client tries to visit the account creation page without the special cookie "we" set during the sales process, then they will be header redirected back to the order page. You do not need to worry with the order/sales part - just the backend system admin part. Now, once the client logs in, he or she can add new guides by going through an interview process, edit existing consumer guides, (by editing the previously completed interviews), and the removal of active consumer guides - **which should NOT be permanently deleted for 30 days** Deleted consumer guides should be sent to a "client recycle bin" where it can be restored by the client within 30 days of the original deletion time/date stamp. (each day that passes would show the client how many days left, such as "28 days left" or "14 days left" Upon the 7th day left, the system should send a warning email to the client letting them know that only 1 week remains before that consumer guide in the recycle bin will be permanently deleted) Also, need the ability to add customer names and email addresses into a form that sends out emails inviting customers to leave a testimonial. The system needs the ability to connect the testimonial back to the correct client with a simple url string like [login to view URL] Lastly, the client should be able to add, edit and delete testimonials at will. Also, the client will need to have the ability to edit the contents of the emails sent to their customers (i.e. the invitation for the testimonial and a thank you email sent back to the customer upon the successful completion of submitting a testimonial) Customer functions: As stated, customers of the clients will receive emails generated by the system with links that take them to a page where they can type a testimonial. Once they submit the testimonial, we want them to receive a thank you email plus we want to notify the client that a new testimonial was added to their account. The interview: The interview will be a 5 or 6 step process to go through that will save the data on each step completion so that the client can stop in the middle of an interview and resume at a later time and not have to start over. The system needs to show a status for each consumer guide - the status's are "Pending" and "Completed" As soon as a client creates a new consumer guide and names it - the status "Pending" needs to be assigned - then ONLY when they complete the entire interview through all 5 or 6 steps, then the guide will change to "Completed". If the client wishes to create a new guide - they need to have the ability to add a new one or to clone an existing one and edit it. Any time a client is editing an existing guide, the status must be set to "Pending" Each step in the interview process will ask questions and prompt the client with a series text input boxes, radio buttons, drop down boxes and textareas - perhaps 5 or 6 elements per step. Then, upon completion - there should be a "Preview" button that will take all their answers they provided and create the full text version of the consumer guide. Preview is only seen after the last step is saved. We will provide the details of how the answers to the interview get dumped into the guide - but this is fairly simple with headings and paragraphs throughout the document. The printing of a "Completed" consumer guide will be the tricky part. We want to either provide pdf output or enable then to print to 8.5 x 11 inch paper. Also, we want to generate a link to the guide for an online format that will be made up of simple css styling that we will provide. This link is intended to be framed into the client's site. We do not want you to style the backend. We will do that. We simply want the system to work and then we will dress it up and put a bow on it. A simple div wrapped around the system content with Verdana 12px set for text will be fine. I DO NOT want a css style sheet that I have to go in and fiugure out and remove. We will style all later. That is the basis for the project. Please do not waste either of our time if you are not a true PHP programmer or if you cannot communicate clearly in English. I also will want IM capability to communicate with you during your operating hours so that your questions can be answered quickly and the project isnt held up...