PHPForms functionality + modifications

**Full Customisation: **I updated the attached file to include the final visio flow or logic diagram saved as a webpage. Please ask me if you think anything is not clear enough or you think you might get it wrong. I'll attach the source code to the accepted bidder. Please make HTML separate from PHP code: Smarty or PHPLIB, whatever you feel comfortable using. Add ability to add regular expressions as a validation rule: you know there is a table for validation checks, this is just for adding validation rules using regular expressions. the application should then know how to deal with that. About XML: XML is to be used instead of quering the database as that would take time. XML files wil be created by the application and used by the application. NOTE: The detailed interface screen shots will be uploaded later, i am working on it now. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ** Previous Description:** This project is an advanced form generator, once data in the database is complete, the user should create a form based on predefined objects, be it a form, a page, or a field. At the start, if a question is not available in the databse, it should add it and associate it with fields. If fields are not there, they shuold be added. Note that forms and pages and fields are seperate entities associated together. A very similar application can be found in [[login to view URL]][1]. this site have all functionalities but it doesn't support questions. The modification should add a question entity in the database, and link fields to a question. it is like a group. When there is no more questions to be added. the user can add a page and then add a form and then choose questions to be included in the form. Questions are alrealdy linked with fields so the form should be generated automatically. We don't have very good programmers, and that is why i am posting this here because I trust in your talents and creativity. If we liked your work, i would pretty much assure you that we will have more and more projects on the way. I know i didn't provide enough information, but I would like to know for how much would you do the same application mentioned in the above URL so that we can have a minimum price and I can arrange budget if the price exceeds it. Once we have a base price, i'll give full documentations and instructions. you only need to code simply because everything is explained GUI and DB, I know how hard is it for programmers to think in coding and GUI becasue i used to be a programmer also. so dont worry you will be comfortable. * * *This broadcast message was sent to all bidders on Sunday Jun 19, 2005 9:38:18 AM: Please check the updated requirements. Read first: MS Visio webpage explaining the new required behaviour or scenario. then: MSWord for the detailed decription. Please update your bid accordingly Thank you * * *This broadcast message was sent to all bidders on Monday Jun 20, 2005 1:03:09 PM: Dear all, I am sorry I forgot to add one more requirement, which is "database independent". I am sure you can use classes available on the net that would do it, in addition to some modifications in the code. The point is that changing a database type should be in one config option. Now, whether this config option is stored in a file or a table in database is your choice. Please ask if you think anything is not explained properly. Regards, * * *This broadcast message was sent to all bidders on Tuesday Jun 21, 2005 12:55:18 PM: Dear all, After several brain storming sessions, I happened to find an approach that is better than the way used in PHPForms in terms of meeting business needs efficiently. It is the way lists are used, so the two predefined list tables will be removed and exchanged with another three tables. Anyway, I should've included all requirements first but unfortunately we are sqeezed in time. It is my mistake and it will never happen again. In return, I'll update the database structure and update the Visio diagram just to make it up for you. * * *This broadcast message was sent to all bidders on Tuesday Jul 5, 2005 4:06:12 PM: Please check the MS Visio diagram. It includes everything needed. If you need further info please ask me. * * *This broadcast message was sent to all bidders on Tuesday Jul 5, 2005 4:07:22 PM: Please use XML as the source of data instead of a database query. I suggested in the visio document that we use views. But I think that XML is much better in terms of improved performance and speed. The data needed to generate the form is in the database anyway, and it can be known by a query or a query to a view. Why don't we store the data as XML and manipulate it once the form is needed. Updates to the database are done within the applicaiton so we can update XML files once the database is updated. This applicaiton will be used within PHProjekt. So, we use the same login session. No need for a separate login page. I'll attach a sample page (if needed) that uses the previous login so you can understand. Mainly, you get the user from a variable in the session user_id, and then see whether the user is given the role of accessing the page or not by querying the role table. As mentioned in the visio diagram, the application can be viewed with different languages. So a language file is needed. Texts that appear on pages should not be hard coded, they should be variables stored in the lang file. Another page for data entry agents should also be created. The user can choose from a dropdown menu the form that the user can fill. As done in PHPForms, the form can be viewed in a page by its id. For example, "..../view?id=1234" will open the form with id 1234. When the user chooses the form "anyformname" from the dropdown, the form should be loaded if the user has access to fill this form. Another point is that when a form requires options and sub-options (everything is specified in the setting table), the sub-options should be displayed only when an option is chosen. Moreover, when it requires changing another list like dropdowns or listboxes depending on the selected option, it should be done on the client side. It is not complicated because all what you need is stored in the database. The complexity is in how best you use the data from the database. Thank you very very much for your time and patience. Again, please ask me if you need any kind of details. ## Platform Windows 2000 and mysql and oracle 8