Modify a free php script for a call centre
- or -
Post a project like this3231
£50(approx. $62)
- Posted:
- Proposals: 5
- Remote
- #785559
- Awarded
Description
Experience Level: Intermediate
Hi, I have downloaded and started customising a php script with sql db which I downloaded from google code (https://code.google.com/p/php-callcenter/downloads/list).
I have uploaded for quick reference the script to a test website
http://studiodiary.co.uk/callcenter/
user is admin and pass is 123456
I have already added new fields to the sql database's table ‘customers’ db and now need to:
1. From the dashboard --> select Customers link —> Edit Customer
I have added fields to the form which need to be connected to the database's new fields
2. In customers.php I also added a section of code from calls.php and search.php
The code is for call type, promotion type, call outcome (from db table ‘calls’ - fields are ‘type’, ‘web’ and ‘subject’) and also added code for setting a call back date with a calendar widget
These fields are not connected with the database - the developer needs to connect them to update the relevant tables
(see also directory inc/classes - I created a class for ‘county’ duplicating inc/classes/country.php)
3. It would be good to have a drop down with name title
(Mr, Mrs, Miss, Ms)
4. Search (search.php) - the search for customer name is only set up to query for name
It must also query by name + surname or surname only
5. This script was incomplete and users.php is missing so from the Dashboard I cannot create any new user (see [admin] link in the header)
The inc/classes/user.php is included so the developer only needs to create a users.php file to create users + passwords
6. I need to constantly upload CSV files like the sample attached to import new customers details. I already created fields to the table ‘customers’ db. The new customer will have ‘new customer to call’ as subject.
The fields I need to import are:
Nametitle
Namefirst
Namelast
Birthdate
Address1
Address2
Address3
Town
County
Postcode
Email
Phone
7. Must edit and change create.php - it needs to manually create a customer with all details currently displayed in the edit of customers.php
Once this is all done I want to delete the calls.php file because customers.php will do all I need.
I attach the folders and files for you to review. I can also provide all details for accessing the test website via FTP etc.
Many thanks
I have uploaded for quick reference the script to a test website
http://studiodiary.co.uk/callcenter/
user is admin and pass is 123456
I have already added new fields to the sql database's table ‘customers’ db and now need to:
1. From the dashboard --> select Customers link —> Edit Customer
I have added fields to the form which need to be connected to the database's new fields
2. In customers.php I also added a section of code from calls.php and search.php
The code is for call type, promotion type, call outcome (from db table ‘calls’ - fields are ‘type’, ‘web’ and ‘subject’) and also added code for setting a call back date with a calendar widget
These fields are not connected with the database - the developer needs to connect them to update the relevant tables
(see also directory inc/classes - I created a class for ‘county’ duplicating inc/classes/country.php)
3. It would be good to have a drop down with name title
(Mr, Mrs, Miss, Ms)
4. Search (search.php) - the search for customer name is only set up to query for name
It must also query by name + surname or surname only
5. This script was incomplete and users.php is missing so from the Dashboard I cannot create any new user (see [admin] link in the header)
The inc/classes/user.php is included so the developer only needs to create a users.php file to create users + passwords
6. I need to constantly upload CSV files like the sample attached to import new customers details. I already created fields to the table ‘customers’ db. The new customer will have ‘new customer to call’ as subject.
The fields I need to import are:
Nametitle
Namefirst
Namelast
Birthdate
Address1
Address2
Address3
Town
County
Postcode
Phone
7. Must edit and change create.php - it needs to manually create a customer with all details currently displayed in the edit of customers.php
Once this is all done I want to delete the calls.php file because customers.php will do all I need.
I attach the folders and files for you to review. I can also provide all details for accessing the test website via FTP etc.
Many thanks
Ivano C.
100% (17)Projects Completed
19
Freelancers worked with
12
Projects awarded
24%
Last project
15 May 2023
Malaysia
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