// SalesPlatform.ru end
//Handle migration for http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7552--senotesrel
$seDeleteQuery = "DELETE from vtiger_senotesrel WHERE crmid NOT IN(select crmid from vtiger_crmentity)";
Migration_Index_View::ExecuteQuery($seDeleteQuery, array());
$seNotesSql = "ALTER TABLE vtiger_senotesrel ADD CONSTRAINT fk1_crmid FOREIGN KEY(crmid) REFERENCES vtiger_crmentity(crmid) ON DELETE CASCADE";
Migration_Index_View::ExecuteQuery($seNotesSql, array());
//Update uitype of created_user_id field of vtiger_field from 53 to 52
$updateQuery = "UPDATE vtiger_field SET uitype = 52 WHERE fieldname = 'created_user_id'";
Migration_Index_View::ExecuteQuery($updateQuery, array());
/*141*/
//registering handlers for Google sync
require_once 'includes/main/WebUI.php';
require_once 'modules/WSAPP/Utils.php';
require_once 'modules/Google/connectors/Config.php';
wsapp_RegisterHandler('Google_vtigerHandler', 'Google_Vtiger_Handler', 'modules/Google/handlers/Vtiger.php');
wsapp_RegisterHandler('Google_vtigerSyncHandler', 'Google_VtigerSync_Handler', 'modules/Google/handlers/VtigerSync.php');
//updating Google Sync Handler names
$db = PearDatabase::getInstance();
$names = array('Vtiger_GoogleContacts', 'Vtiger_GoogleCalendar');
$result = $db->pquery("SELECT stateencodedvalues FROM vtiger_wsapp_sync_state WHERE name IN (" . generateQuestionMarks($names) . ")", array($names));
$resultRows = $db->num_rows($result);
$appKey = array();
for ($i = 0; $i < $resultRows; $i++) {
$stateValuesJson = $db->query_result($result, $i, 'stateencodedvalues');
$stateValues = Zend_Json::decode(decode_html($stateValuesJson));
$appKey[] = $stateValues['synctrackerid'];
}
if (!empty($appKey)) {
$sql = 'UPDATE vtiger_wsapp SET name = ? WHERE appkey IN (' . generateQuestionMarks($appKey) . ')';
$res = Migration_Index_View::ExecuteQuery($sql, array('Google_vtigerSyncHandler', $appKey));
}
function registerSynclibEventHandler()
{
$className = 'WSAPP_VtigerSyncEventHandler';
$path = 'modules/WSAPP/synclib/handlers/VtigerSyncEventHandler.php';
$type = 'vtigerSyncLib';
wsapp_RegisterHandler($type, $className, $path);
}
