In Progress

Simple Customer Relationship Mngt System PHP / MYSQL

Looking for PHP / MYSQL guy to create a simple customer relationship mngt system.

*******__________________________________________*******

Following are the FEATURES I AM LOOKING FOR:

*******__________________________________________*******

- Login

- Add / Update / customers. Updating will require one tricky implementation for which i can provide you with the logic. Basically, the update on "field A" will update "field A" for all customers matching that criteria. Will work with you on that one. Simple where clause for the update statement needs a little logic. Total number of fields in this table is about 15. Name, address, phone, contact, etc. etc. Basic customer stuff.

- Search customers by 10 fields. Must bring back "wild card" search for multiple fields. If i search for "chi", it should pick up all rows containing "chi".

- Add / Update / customer groups (grouping of customers)

- Screen which will allow me to group my customers. Example: I setup a new GROUP "California Customers". I use a screen to filter for just California Customers and add them to the GROUP "California Customers" which i just created. I want the ability to keep updating GROUPS as new customers are added to the DB.

- Add (only) notes about contacts made to the customers using "sysdate". You cannot modify the notes once saved for security reasons.

*******__________________________________________*******

FOLLOWING ARE THE SCREENS -- How to group all this? Following is my idea:

- Screen name "Dashboard" which allows me to filter on a GROUP, see the customers for that GROUP, filter on customers and add notes to them. To add a note, i am fine if you want open a new window so people never lose sight of the "Dashboard" screen. I have an example of such a screen already.

- Screen name "Manage Group" will allow user to add / update GROUPS by filtering on customers who DO NOT belong to a group. Example: In my DB, i have Chicago, Miami and New York customers. I have already setup Miami GROUP. I want to now setup Chicago GROUP. I will use this screen to setup the GROUP and search for Chicago customers so i can group them all into the new GROUP created for Chicago. I want to be able to filter on 10 fields from the customer table filter the result-set.

******************* FILTERING ON THE CUSTOMER TABLE MUST USE "CONTAIN" AND SHOULD BE ON MULTIPLE FIELDS TO ALLOW SOMEONE TO LIMIT THE DATA RETURNED *************************

Regards,

Skills: AJAX, MySQL, PHP, Website Design

See more: simple customer php, simple customer customer php field add, customer relationship mysql php, customer relationship mysql, simple customer php mysql, window design group, website design miami, website design chicago, table customer, security logic, security for php website, miami data, matching logic, design miami, customer table, customer it, php relationship system, mngt, can i design a website using my phone, the php group, result system, relationship, php dashboard, people system, miami

About the Employer:
( 141 reviews ) Sanford, United States

Project ID: #1268808

Awarded to:

sriraj1233

I have strong experience in designing Efficient Websites over four [url removed, login to view] to be very interesting project. I was ready to start this project. we have developed recently website with user friendly CMS. website lin More

$100 USD in 2 days
(68 Reviews)
5.5

12 freelancers are bidding on average $169 for this job

toinnisfree

pls chk pmb

$330 USD in 5 days
(548 Reviews)
7.9
netxpertindia

NetXpertIndia is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. Our team can More

$150 USD in 5 days
(81 Reviews)
6.7
hunterboss

Let me help you Discuss with me now and we can start CRM expert here

$200 USD in 5 days
(80 Reviews)
6.4
hotranan

i can do this work

$200 USD in 7 days
(6 Reviews)
5.0
gutenmorgen11

Hi. I'm ready to start. Please check PM.

$150 USD in 5 days
(33 Reviews)
4.6
Abdulaziz01

I've been working as a web developer for more than 4years now ,and i've Proficiency in working with AJAX, PHP,MySQL,Javascript,HTML,CSS. please check pm for my sample works and more details.

$99 USD in 4 days
(5 Reviews)
3.8
kudretserin

Hi, Please see PM, Regards

$250 USD in 5 days
(30 Reviews)
3.8
kalypsose

Hello. I'm a software engineer. I am a Senior Developer with vast experience in LAMP. Please see my private message for justification of my bid. Thanks in advance and good luck with your project. Best Regards! More

$200 USD in 4 days
(3 Reviews)
2.6
krk85

I have understand your requirement. I have experience on PHP,Mysql Development. Please discuss.

$80 USD in 3 days
(0 Reviews)
0.0
pmukul

Hello, we are a team of experienced web designers/developers. Kindly check your inbox for details.

$30 USD in 15 days
(0 Reviews)
0.0
akrobin

Hi, I am Robin, working at "Softtech Limited" in bangladesh as a senior software engineer and web developer. I can complete your project with 100% accuracy within my given time. If you think that I have ability so pl More

$240 USD in 15 days
(0 Reviews)
0.0