Simple contact management system in PHP & MySQL
- or -
Post a project like this2898
$$
- Posted:
- Proposals: 13
- Remote
- #1127661
- Completed
Description
Experience Level: Intermediate
Estimated project duration: 1 - 2 weeks
General information for the website: Must be built in PHP
Database management system (DBMS): MySQL
Kind of development: New website from scratch
Description of requirements/features: We need a simple contact management system built that will allow our employees to track whom they've contacted. The system features must be as follows:
User management system - Must be secure. Allow user creation, delete, edit and user level (admin / standard) assignment.
The entire system will only be accessible to logged in users.
In terms of main functionality, system database consists of the following tables:
- Company
- Contact
- Contact History
- Industry
- Sector
- Country
- Languages
Country - Admins can add / delete / edit country names
Languages - Admins can add / delete / edit language names
Industry - Admins can add / delete / edit industry names
Sectors - Sectors are sub-sets of industry and each industry will have a number of sectors. Sectors shouldn't be duplicated across industries. All users can add sector names, but when users add sectors, they should be checked against duplication. Only admins can delete / edit sector names or place them under a different industry.
Company - Has a number of fields. Each company is linked to 1 country, multiple languages, 1 industry, multiple sectors. All users can add / edit companies. Only admins can delete a company. Each company can have 0 to multiple contacts. A company can have a direct contact history (in the case of 0 contacts) or contact history associated with each contact.
Contact - Each contact has a number of fields. Each contact may be linked to multiple companies, multiple sectors. All users can add / edit contacts. Only admins can delete a contact. Each contact can multiple contact histories associated with each company or as an individual.
Contact History - All users can add a contact history entry. Only admins and the user who added the entry can edit it. Only admins can delete a contact history entry. Each contact history entry is tied to a contact and/or company.
Reporting functionality:
1. Search for companies and contacts based on keywords. Filtering results by industry, sector, country and/or language. Users should be able to quickly export list of results to CSV
2. Admins should be able to run the following reports for each user:
(a) Contacts and companies added each month
(b) Number of contact history entries made each month. Filtering results by specific fields within the contact history
----------------------------------------------
To be fully hosted and installed on our servers. The system needs to sit on a blank template. We will then brand it for our corporate use. Corporate style guide will be provided for fonts and colours.
Extra notes: No up-front payment requests will be entertained. Please specify expected delivery times in your proposal. Using and adapting pre-existing frameworks is very highly recommended to keep costs as low as possible. Example, https://github.com/Repox/SimpleUsers or http://www.userfrosting.com/ for user management, and any contact management scripts such as LCM http://codecanyon.net/item/lcm-leads-contacts-manager/5225904
Database management system (DBMS): MySQL
Kind of development: New website from scratch
Description of requirements/features: We need a simple contact management system built that will allow our employees to track whom they've contacted. The system features must be as follows:
User management system - Must be secure. Allow user creation, delete, edit and user level (admin / standard) assignment.
The entire system will only be accessible to logged in users.
In terms of main functionality, system database consists of the following tables:
- Company
- Contact
- Contact History
- Industry
- Sector
- Country
- Languages
Country - Admins can add / delete / edit country names
Languages - Admins can add / delete / edit language names
Industry - Admins can add / delete / edit industry names
Sectors - Sectors are sub-sets of industry and each industry will have a number of sectors. Sectors shouldn't be duplicated across industries. All users can add sector names, but when users add sectors, they should be checked against duplication. Only admins can delete / edit sector names or place them under a different industry.
Company - Has a number of fields. Each company is linked to 1 country, multiple languages, 1 industry, multiple sectors. All users can add / edit companies. Only admins can delete a company. Each company can have 0 to multiple contacts. A company can have a direct contact history (in the case of 0 contacts) or contact history associated with each contact.
Contact - Each contact has a number of fields. Each contact may be linked to multiple companies, multiple sectors. All users can add / edit contacts. Only admins can delete a contact. Each contact can multiple contact histories associated with each company or as an individual.
Contact History - All users can add a contact history entry. Only admins and the user who added the entry can edit it. Only admins can delete a contact history entry. Each contact history entry is tied to a contact and/or company.
Reporting functionality:
1. Search for companies and contacts based on keywords. Filtering results by industry, sector, country and/or language. Users should be able to quickly export list of results to CSV
2. Admins should be able to run the following reports for each user:
(a) Contacts and companies added each month
(b) Number of contact history entries made each month. Filtering results by specific fields within the contact history
----------------------------------------------
To be fully hosted and installed on our servers. The system needs to sit on a blank template. We will then brand it for our corporate use. Corporate style guide will be provided for fonts and colours.
Extra notes: No up-front payment requests will be entertained. Please specify expected delivery times in your proposal. Using and adapting pre-existing frameworks is very highly recommended to keep costs as low as possible. Example, https://github.com/Repox/SimpleUsers or http://www.userfrosting.com/ for user management, and any contact management scripts such as LCM http://codecanyon.net/item/lcm-leads-contacts-manager/5225904
Projects Completed
28
Freelancers worked with
23
Projects awarded
75%
Last project
24 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies