I need a system to track sales representative activities. Representatives must store their sales activities
I need it to be in php + mysql
The tables and functions must be like this
- Roles
ID
Admin
Country Manager
IT Manager
Sales Manager
Agent
* Roles maintenance (add, modify,delete) needed
- Users
ID
username
name
last name
email
telephone
mobile
password
* ( Roles maintenance add, modify,delete needed. Only admin users can add or delete users)
- Documents section
ID (numeric)
Title (text)
attachment (text) URL of the uploaded file
*Uploading of pdf, doc, pps, ppt files must be enabled
Only admin users can manage add, edit, modify records
*Uploaded documents must bee seen by all users
- Customer
ID
Representative (is the sale representative... must be an user form users table)
Name of business
Contact1
Contac2
FixedTelephoneline
Mobilephone 1
Mobilephone 2
Email
Alternativeemail
FacebookprofileURL
State
City
Country
skype
Farm1city
farm1state (numeric)
Farm2city
Farm2state (numeric)
Notes
* Users must be able to add customers (only admin users can get full details of customers, all representatives will be able to see customer list by name of business or contact1 or contact2... this is for let them know if a customer exists in order to avid adding a new customer)
* The sales Representative of one customer will be able to see thier customer's full details
* searching needed for customers with ajax pre-search feature. Only customer names as search results must be displayed
- Products
ID (numeric)
Name (text)
*Add, delete, modify function for this and only superadmin can manage this table
- Conversations
* only add function and listing of conversations features needed. All users can see conversations. Search feature by customer needed.
ID (numeric)
Agent (numeric)
Customer (numeric - only customers belonging tho wich the loged )
Date/time of converstion (datetime)
Detailsofconversation (text)
- Oportunities (Only SuperAdmin and Country Manager con post articles to this )
ID (numeric)
registered by (numeric from users table)
Customer (ajax search engine to serch in customer table)
Subject (text)
Description (text)
Product to sell (text) (products)
Quantity (numeric 4 digits)
Deadline (date)
OTHER FEATURES
Login feature to the system, password change, and password reset feature needed
You can set the name you prefer to the table fields
Language file needed to translate the script later
Communications must be by email and daily chat sessions by msn messenger between 04 AM and 02 PM (GMT).