I. Install Vtiver 6
- install database
yum install php-imap -y
CREATE DATABASE Vtiger6 CHARACTER SET utf8 COLLATE utf8_general_ci;
- preparing php.ini
nano /etc/php.ini
register_globals = Off
allow_call_time_pass_reference = on
error_reporting = E_WARNING & ~E_NOTICE
safe_mode = off
display_errors = on
file_uploads = on
max_execution_time = 0
memory_limit = 512M
log_errors = off
output_buffering = on
short_open_tag = On
memory_limit = 512M
- preparing source code
tar zxf vtigercrm6.4.0.tar.gz
mv vtigercrm crm
cd crm
chown -R root:root crm
chown root:root config.inc.php
chown root:root tabdata.php
chown root:root install.php
chown root:root parent_tabdata.php
chown root:root cache
chown root:root cache/images/
chown root:root cache/import/
chown root:root storage/
chown root:root install/
chown root:root user_privileges/
chown root:root smarty/cache/
chown root:root smarty/templates_c/
chown root:root modules/emails/templates/
chown root:root modules/
chown root:root cron/modules/
chown root:root test/vtlib/
chown root:root backup/
chown root:root smarty/templates/modules/
chown root:root test/wordtemplatedownload/
chown root:root test/product/
chown root:root test/user/
chown root:root test/contact/
chown root:root test/logo/
chown root:root logs/
chown root:root modules/webmails/tmp/
chown root:root includes/runtime/
chown root:root include/utils/
chown root:root test/vtlib/HTML
chown root:root include/utils/
chown root:root include/utils/
chown root:root include/utils/
chown root:root includes/runtime/
chown root:root test/templates_c/
chown root:root includes/runtime/
chown root:root test/
chown root:root vtlib/
chown root:root user_privileges/
chmod 777 libraries/htmlpurifier/library/HTMLPurifier/DefinitionCache/
chmod 777 includes/runtime/
chmod 777 test/
chmod 777 vtlib/
chmod 777 user_privileges/
chmod -R a+rw config.inc.php
chmod -R a+rw tabdata.php
chmod -R a+rw install.php
chmod -R a+rw parent_tabdata.php
chmod -R a+rw cache
chmod -R a+rw cache/images/
chmod -R a+rw cache/import/
chmod -R a+rw storage/
chmod -R a+rw install/
chmod -R a+rw user_privileges/
chmod -R a+rw Smarty/cache/
chmod -R a+rw Smarty/templates_c/
chmod -R a+rw modules/Emails/templates/
chmod -R a+rw modules/
chmod -R a+rw cron/modules/
chmod -R a+rw test/vtlib/
chmod -R a+rw backup/
chmod -R a+rw Smarty/templates/modules/
chmod -R a+rw test/wordtemplatedownload/
chmod -R a+rw test/product/
chmod -R a+rw test/user/
chmod -R a+rw test/contact/
chmod -R a+rw test/logo/
chmod -R a+rw logs/
chmod -R a+rw modules/Webmails/tmp/
- installing
http:// IP/crm
put all the values you need and install.
II. Integrating incoming call
- Table for incoming call
CREATE TABLE `income_call` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`phone_num` varchar(15) DEFAULT NULL,
`extension` varchar(10) DEFAULT NULL,
`date` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- Insert new incoming call
Copy “test_insert_new_call.php” to “var/www/html/crm/incoming/”
/var/www/html/crm/incoming/test_insert_new_call.php?phone_no=xxxxx&extension=1000
- Embed javascript on header of Vitger6 at the and of file
/var/www/html/crm/layouts/vlayout/modules/Vtiger/resources/Header.js
//Put this content at the end of file//
/**
* @author Chau Ngoc Huynnh | Realtime Solutions
* @Email chaungochuynh@realtime.vn
* @copyright 2016
*/
<script>
//===========.::Bussiness From Realtime Solutions 2016 – wwwrealtime.vn::.============
function newguys(url,ext){
var xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
var json = xmlhttp.responseText;
obj = JSON.parse(json);
var posts=obj.posts;
var post = posts[0].post;
var postext = post.phone_num;
//alert(JSON.stringify(post)); First Object
//alert(postext);
if(postext != null)
{
window.open(url + postext, “_blank”);
}
}
}
xmlhttp.open(“POST”,”incoming/webservice_incom.php?extension=” + ext + “&format=json”, true);
xmlhttp.send();
}
setInterval(function(){
newguys(‘incoming/Vtiger6_Open_URL.php?phone=’, ‘100’);
},3*1000);
//======.::END OF APPENDING::.==================================
</script>
- Put this files “Vtiger6_Open_URL.php” to “/var/www/html/crm/incoming”
This file will check if customer phone present in Vtiger DB and popup URL
When get new incoming phone number we need call from script put at header of Vtiger6
http://IP/crm/incoming/Vtiger6_Open_URL.php?phone=xxxxxxx
- Get extension from configuring
Result when ext: 1000 pick up the phone: (this is what we want to show 😉 ) just only 1000 show up this information when pickup
Next Click to call (c2c Vtiger 6.x)
integration Vtiger6 and asterisk 11 with click to call for sumary view, we have Call button for click call to Asterisk Server.
integration Vtiger6 and asterisk 11 with click to call for full view, we have Call button for click call to Asterisk Server.
See demo:
Mr Huynh.
Contact: sales@realtime.vn | chaungochuynh@realtime.vn
Hotline: 08 730 33888 | 0933119056
My skype: chaungochuynh15