|
Description: |
Please make sure you read and understand this complete posting before you bid. Feel free to ask me more questions about it.
I need a PHP developer to build a subcomponent of a larger application that I am building with PHP and MySQL. While I am building the larger application, I am a new PHP developer so I need you to be the expert for this subcomponent. The subcomponent is basically a niche contact management system for tracking volunteers and donors. It must be able to allow users to enter, edit, and search for contacts based on certain criteria. I will be able to provide more detailed specs and mocks, but here is a detailed summary:
- No JavaScript or any client side scripting. Everything must run on the server in PHP with MySQL database.
- I will likely have to modify what you give me to fit into the larger application, so the project might have to include an hour or two of Q&A if I don't understand what you did. But it would be even better if you do a great job commenting your code so that I can understand what you did and why you did it. I can also share with you the methodology of the system built so far to make sure we are in better sync.
- I can do some nit-picky things to save you time, such as adding the form validations or other items that require basic PHP. But we have to agree on them first.
- Multi-tennant system. That is, the system is not just for one organization. It is for an infinite number of organizations, all with their own set of data (each contact must be mapped to the specific organization). The organization component is already programmed, and I can provide you with the necessary information.
- I can provide you with the database schema and naming conventions, but I would expect that you would also have input on the schema to make sure that what you develop is stored most efficiently in the database.
- The information to be stored is:
- General contact info (name, address, phone, etc).
- Volunteer job preferences (John Doe prefers to work Job A, Job B, and Job C). I will provide you with the information needed to map the actual jobs to the jobs stored for the organization in the system (the available jobs part is already programmed).
- Volunteer schedule availability (John Doe is available to do volunteer work on Monday and Wednesday mornings and Thursday evenings).
- Volunteer hours worked (John Doe worked 2 hours on February 1).
- Donations made (John Doe donated $50 on March 1. It is actually a bit more complicated than this since the system must track certain things for reporting and donation acknowledgment purposes).
- System must validate all data to make sure it is valid, to make sure required information is provided, and to make sure each data type appears correct (that is, a phone number looks like a phone number, an email address looks like an email address, etc.).
- Each set of information would be under its own tab/link on the screen. Each tab would have the appropriate form for the corresponding set of information, along with buttons for Save, Save & Add New, and Cancel. Before continue to a new tab/link, if the user makes changes but did not save, the system must be smart enough to stop and prompt them.
- Once an organization has contacts stored in the system, they can perform many different types of searches to access the information. For example, from a dropdown menu, the organization can select categories for searches. Categories might be Volunteers with certain parameters, donors with certain parameters, text search, etc. I will provide a more detailed list. But for example, the user might select "Volunteers" from the dropdown menu and the search panel refreshes to allow the user to perform searches based on volunteer job preferences, volunteer hours worked within certain dates, volunteers who have not yet been mailed a thank you, etc.
- When a user performs a search, the system returns results in an adjacent panel on the screen. From there, the user can click a specific contact to open another adjacent panel with the contact information forms (the tabs described above). Also, in the search results list, the user must be able to navigate across pages of returned information and to sort by such things as name, address, city, etc. User must also be able to toggle between showing names as [last name], [first name] or [first name] [last name].
Additional Info (Added 12/3/2008 at 0:11 EST)...Attached file: mocks.pdf
File info: This document will show you some mocks and provide examples so you can see exactly what is required.
Additional Info (Added 12/3/2008 at 0:14 EST)...UPDATE: Based on some feedback I have received, I will allow JavaScript to the extent that it helps with functionality. For example, if the user enters information but then clicks some random link without saving their changes, you can use JavaScript to stop them and alert them. However, I want all data validation to be done by the server as a security measure. Also, if JavaScript is used, I would also need you to program something that will check to see if the user has JavaScript turned off and, if so, stop them in their tracks until they turn it back on.
|
