hat I need or require:
A web based (LAMP - PHP5) application to maintain (add, update, delete) data in a people information manager. The database schema already exists (18 tables). We are seeking an application that utilizes a simple clean looking front end design and which incorporates Web 2.0 technology to provide an intuitive and easy to use data manager for our internal staff.
What I already have versus what the expert will deliver:
We will provide the database schema (see attached files). The provider will deliver high quality working software program code (PHP5, javascript and HTML) free of any commercial licenses. Third party tools can be used (for example: javascript tools and PHP frameworks) as long as these tools fall under commonly used open-source licenses and do not require us to compensate the third party. The final product will need to run on our linux / apache 2.0 / MySQL 5.0 / PHP 5.0 environment. No development tools or development environments / servers will be provided to the programmer. The provider must either provide an environment accessible over the web on which we can test the results of their work or they must send the code to us for testing.
Other context/requirements that experts will need to know:
The application must allow us to maintain or populate each of the columns shown in the schema provided. Foreign keys in the schema provide some information regarding how the tables relate to each other and this should partially guide the provider in the design of the front end user interface. Further details about how the information stored in the tables are used will be provided by us. The data stored in this database is confidential and therefore this application code must meet the latest secure coding guidelines and practices.
Specific expertise/background that I am seeking:
The provider must have web software programming experience with PHP, javascript, and MySQL. They should have enough experience with Web2.0 technologies to be able to design and create a simple intuitive user interface for the application. Using a common PHP framework such as CodeIgniter or CakePHP is strongly encouraged but not required. Similarly, use of common javascript toolsets such as ExtJs is also encouraged but not required.
Timeframe for delivery:
We would prefer this work to be completed within 3-4 weeks of an accepted offer.