Corporate Address Book
The first component of a complete new intranet system. We have around 20 modules very specialised to be written. (very specialised but impossible to develop)
This project is the first component/module.
DO NOT BID if you don't have experience with bigger projects.
DO NOT BID if you don't want to make the other modules in the future
General rules
- LAMP
- With logins (session based, multiple levels of users)
--> as the address is the first module of our new intranet system, the login handler should be in a new 'shell' application.
- users will be added manually in phpmyadmin
- Needs to be optimized for Firefox +3 only
- Security is a big issue, mysql vulnerability, session control, security, security
Address Book Module details:
- Smart usage of Ajax and other javascript
- Cool and modern usage of html, forms and css
- We should be able to add fields in the database and screen (by config file for example)
- All actions should be logged (logins, views, search queries, adds, changes, etc)
- Limit in views (on level of amount of records dumped on the screen, amount of records a user can view per day)
- a wide range of search capabilities, should be easily (although hardcoded) updated
- easy form for first time filling the database
- search results should be showed in a sortable gridview
Example of a record:
---------------------------------------------------------------------------------
[INTERNAL ID NUMBER]
[COMPANY] [COMPANY_TYPE]
[STREET 1]
[STREET 2]
[STREET 3]
[POSTAL CODE] [TOWN]
[CITY] [PROVINCE] [COUNTRY]
TAGS
----
(+) to add new tag
ACCOUNT MANAGER : [NAME]
CONTRACT
---------
[PRODUCT] [START] [STOP] [SIZE] [TYPE] [PRICE] [ACCOUNT MANAGER]
(+) to add a contract + details
CONTACT
-------
[INTERNAL ID NUMBER] [FIRST NAME] [LAST NAME] [TITLE] [POSITION] [TEL] [TEL2] [TEL3] [TEL4] [FAX] [EMAIL1] [EMAIL2] [SINCE] [TILL] [COMMENT]
[+] to add new contact
DETAILS
-------
(Y)ES (N)O (L)APSED (P)ROSPECT
CUSTOMER Y N L P
SUPPLIER Y N L P
DISTRI Y N L P
STAFF Y N L P
FRIEND Y N L P
HISTORY
-------
2009-09-30 [STAFFNAME] [IN/OUTBOUND] [comment]
(+) to add a history event
[COMMENT]
---------------------------------------------------------------------------------