Flash Survey with Data to SQL

- This job requires expertise in Flash and PHP. Also good and frequent communication and willingness to show wok in progress. This is a Flash movie that will ultimately be converted to a runtime movie using Adboe AIR. The movie consists of a 60 question survey, followed by the assembly and printing of two 1-page documents using data from the survey. In addition, there will be some administrative screens for administrative users to set up the movie when it is first launched (other users will use it after it is set up). Data collected by the survey, along with some environmental and usage data will be saved to a MySQL database (using PHP) and to the local hard disk (using AIR). THE JOB POSTED NOW IS JUST FOR PROGRAMMING THE SURVEY PORTION, with survey data being saved to the SQL database. The other programming (administrative screens/functions, assembly/printing of documents, local data saving) will be future job(s). === END PRODUCT === The end product is a native Flash file(s) and any graphics (not just the final SWFs) and a set of text-readable PHP files (not compiled or protected in any way). The SQL database is already created and I will provide you a copy of it to install on your development server. === SPECS === * Specs below are not final, but they are indicative of this job. Final specs and content will be provided when the job is awarded.) * The PDF included with the job posting shows the screens and logic for flow. Flash version CS3 or older. PHP version 5. (MySQL is version 5.) Flash file size 900 wide by 600 high. 60 questions plus a couple of informational screens at the start and end of the survey. Survey contains multiple “skips” where the response selected in the current question plus data from previously answered questions determine the next questions to be displayed. Most of the survey questions follow the same layout/format, BUT we need to preserve the ability to make the layout of each question unique in the future. Therefore, each question should be its own frame, not fewer frames with question and responses populated from ActionScript. If you have an alternative suggestion you can propose it in your bid. Survey response data should me maintained in a clear internal array that is dumped as-is to a field in SQL database at multiple times while the survey is used AND parsed out into specific fields in the SQL database (one field for each survey question plus a few more) at the end of the survey. The writing of data to the array and subsequent movement to the next question should all be handled using a single function called by the response objects (so that the complete survey logic can be viewed in a single script). Obviously you’ll have leeway with this, but the point is that I don’t want the core logic code spread out too much. This MUST be very well documented. Build in time to do that. === USING ADD-ONS === When I open the Flash file(s) on my computer which has a default Flash CS3 install, the file should be fully editable with what I’ve got. In other words, you can not use any third-party apps or classes that must be installed for me to revise the document. If you must use something beyond default Flash tools, they must be open source and you must provide them with the Flash file -- AND YOU NEED TO EXPLAIN THEM IN YOUR BID or else I’ll assume you’re using none. The PHP files can call whatever PHP classes you want, as long as you provide them. Beyond PHP classes, the PHP files can not require any additions to the server (just PHP 5 and MySQL 5). === BUDGET === An appropriate bid will be between 750 and 1,000. You could do a quick-and-dirty survey in a few hours by borrowing from past work, but I set the budget high because I want a very thorough, well-documented job. I also expect this to be a custom job (if you re-use code, make sure it is yours or open-source; that it is clean and appropriate for this job; with variable names, function names, and documentation specific to this job; and with no extra unused code included). == THANKS! -