273896 PHP/MySQL/Ajax/Flash Script

I have a PHP/MySQL script that is to be revamped. I need YOU to finish what they started: build a web application that uses information given in a URL or email and parses data from a MySQL database into a predefined web template. The application makes / will make extensive use of the following technologies: PHP 4.X OR PHP 5 Asynchronous Javascript and XML (AJAX) MySQL 4.X OR MySQL 5 [login to view URL] (Ajax library & framework) [login to view URL] (Graphing utility) [login to view URL] (Heatmap reporting utility) [login to view URL] (Email application) [login to view URL] (WYSIWYG Web-based editor) Modrewrite and htaccess files [login to view URL],en/ (survey tool) [login to view URL] (PHP PDF creation tool) [login to view URL] (Ad hoc free form solutions) Data mapping XML and CSV importer Google analytics How it all works together and what “good” looks like - a demo story: 1. I have a list of names and addresses and other information that I want to upload into an online database. The list is formatted as either XML or CSV. I login to the system, create a database “shell”, map and import the data into the application. 2. I want to send out emails to my customer list that I just uploaded. These emails are extensively personalized using data elements from the contact list. I create an email template: one in text, one in HTML. I insert elements into the email template so that “Hello {first_name}…” becomes “Hello John”, “Hello Suzy” etc… The number of personalization elements in the email template can be unlimited, and is conditional on the database that I upload to the system. (PHPLIST & TinyMCE) 3. I also want to have a webpage that looks like the HTML template that I created for the emails. Now, when John or Suzy read their email, they notice they can visit a webpage that is personalized for them. The URL that they are prompted to visit looks something like [login to view URL] OR John_Doe.MyDomain.com. (TinyMCE) 4. In fact, I can create an UNLIMITED number of webpage templates, and have them randomly or sequentially assigned to people in my contact list. This is so that I can perform AB Split testing on the various templates. 5. The first time that John visits his webpage, I get an email alert telling me that he is visiting the site for the very first time. 6. Now that John is on the webpage, he can complete a survey. (LimeSurvey and/or FreeFormSolutions) He is not required to login to anything (necessarily – this CAN be an option, though). Rather, the application knows it is him because he is visiting his unique URL. (htaccess & modrewrite) The system will show John his survey, and in fact even populate the survey fields with information that is already known about him. If John makes the effort to finish the survey, he will get some kind of reward from us. 7. At the end of the campaign, I can login to the system and see all kinds of reports. Clicking on a couple of different links give me various options of presenting the data: bar, line, pie, funnel… all charts are offered. (FusionCharts) I choose which one looks best and print them, along with data details into a PDF file (FPDF). 8. I can also get a visual representation of where people are clicking on the web pages (Clickheat). 9. The application also has three levels of permissioning so that I can have people that are Super Administrators, Administrators and just users. Super admins can rwx everything and grant access to the system. Administrators can rwx most everything, and can only grant access to users. Users can just rwx their own stuff. Super Administrators also have reporting AND heatmap access. 10. Ideally, the application will have a menu for access and permission where users privileges can be turned on or off anytime. 11. Lost password uses email to send a password if lost 12. Install and config application to help on initial use of app, given basic details like server, mysql data, etc. I have an alpha and a beta version of the application. Admittedly, it seems like the alpha works better than the beta right now – so I might be just starting over from scratch. Give me an idea of what it would take to build and integrate all these elements, and let's get started! Full requirements documents, source code from alpha and beta app, and access to previous project board documentation available for review upon shortlisting. You will also be allowed to revise your quote upon review of files. 100% serious job and all money in escrow upon project award. Possible bonus as well, depending on how well you stick to the schedule. We are looking to establish a long term relationship with a programming team to work with this particular application. Continuous work in the form of updates will be available beyond the completion of this current project. ** Please note the required pre-conditions before applying ** - Knowledge of English - You must maintain a strong command of the English language both reading and writing. - Availability by IM and email during the 08:00 Pacific to 24:00 Pacific time frame. - You may need a team of multiple programmers (more than one) to work full time on this project. - Your team needs prior experience completing large projects. - Interested parties need the ability to work with others as part of a "virtual team" Required Skills: - PHP framework such as CakePHP, Zend, Ioncube or similar. No proprietary frameworks. - PHP4 / MySQL / Ajax / Javascript / Linux - Provide quality, AND WELL DOCUMENTED code - Estimate, set deadlines, and most importantly MEET them - Communicate status accurately and daily Helpful Skills: - Knowledge of Personalization tools, Opensource Integration - Ability to be proactive and make recommendations that will improve the outcome. i.e.: Don't want a robot that just codes what is said if you think there might be a better way. Payment and Terms: - Both parties will agree to the time and costs of all projects before commencement. - We will mutually agree upon approximately 20 milestones as steps to completing the whole project. - You will get paid promptly upon completion of each small pre-agreed milestone. Completion is defined as fully completing the specs, all bugs fixed, and working on our servers. - Payment will be in USD using Scriptlance escrow. This is your guarantee of payment and my guarantee of quality product. - Because we require full intellectual property rights, work completed must be your own unless otherwise approved in advance. i.e.: All deliverables considered "work made for hire" under U.S. Copyright law. I will receive exclusive and complete copyrights to all work performed under this engagement. You will not have permission to re-use the code in future development engagements or to resell the developed code as your own. Important notes: No money will released from escrow until I see something that is workable. I will not pay for buggy code or just because you need money. For additional reference, please see following Scriptlance projects: ID # 1201678874 (latest effort - and the one you will be fixing) ID # 1193293244 (first effort - good job but programmer got too busy)