migrate_from_vt60.php

<?php
/*************************************************************************************************
 * Copyright 2015 JPL TSolucio, S.L. -- This file is a part of TSOLUCIO coreBOS Customizations.
 * Licensed under the vtiger CRM Public License Version 1.1 (the "License"); you may not use this
 * file except in compliance with the License. You can redistribute it and/or modify it
 * under the terms of the License. JPL TSolucio, S.L. reserves all rights not expressly
 * granted by the License. coreBOS distributed by JPL TSolucio S.L. is distributed in
 * the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied
 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Unless required by
 * applicable law or agreed to in writing, software distributed under the License is
 * distributed on an "AS IS" BASIS, WITHOUT ANY WARRANTIES OR CONDITIONS OF ANY KIND,
 * either express or implied. See the License for the specific language governing
 * permissions and limitations under the License. You may obtain a copy of the License
 * at <http://corebos.org/documentation/doku.php?id=en:devel:vpl11>
 *************************************************************************************************
 *  Migrate from vtiger CRM 6.0 to coreBOS
 *  Version      : 1.0
 *  Author       : JPL TSolucio, S. L.
 *************************************************************************************************/
$delfields = array(
	'Users.calendarsharedtype', 'Users.callduration', 'Users.dayoftheweek', 'Users.default_record_view',
	'Users.leftpanelhide', 'Users.no_of_currency_decimals', 'Users.othereventduration', 'Users.rowheight',
	'Users.truncate_trailing_zeros','ModComments.reasontoedit'
);

foreach ($delfields as $fqfn) {
	list($module,$field) = explode('.', $fqfn);
	$mod = Vtiger_Module::getInstance($module);
	$fld = Vtiger_Field::getInstance($field,$mod);
	if ($fld) {
		$fld->delete();
		ExecuteQuery('ALTER TABLE '.$mod->basetable.' DROP '.$field);
	}
}

$dropflds = array(
		'vtiger_accounttype.sortorderid', 'vtiger_activitytype.sortorderid',
		'vtiger_assetstatus.sortorderid', 'vtiger_campaignstatus.sortorderid',
		'vtiger_campaigntype.sortorderid', 'vtiger_carrier.sortorderid',
		'vtiger_contract_priority.sortorderid', 'vtiger_contract_status.sortorderid',
		'vtiger_contract_type.sortorderid', 'vtiger_eventstatus.sortorderid',
		'vtiger_expectedresponse.sortorderid', 'vtiger_faqcategories.sortorderid',
		'vtiger_faqstatus.sortorderid', 'vtiger_glacct.sortorderid',
		'vtiger_industry.sortorderid', 'vtiger_invoicestatus.sortorderid',
		'vtiger_leadsource.sortorderid', 'vtiger_leadstatus.sortorderid',
		'vtiger_manufacturer.sortorderid', 'vtiger_opportunity_type.sortorderid',
		'vtiger_postatus.sortorderid', 'vtiger_productcategory.sortorderid',
		'vtiger_progress.sortorderid', 'vtiger_projectmilestonetype.sortorderid',
		'vtiger_projectpriority.sortorderid', 'vtiger_projectstatus.sortorderid',
		'vtiger_projecttaskpriority.sortorderid', 'vtiger_projecttaskprogress.sortorderid',
		'vtiger_projecttasktype.sortorderid', 'vtiger_projecttype.sortorderid',
		'vtiger_quotestage.sortorderid', 'vtiger_rating.sortorderid',
		'vtiger_sales_stage.sortorderid', 'vtiger_salutationtype.sortorderid',
		'vtiger_servicecategory.sortorderid', 'vtiger_service_usageunit.sortorderid',
		'vtiger_sostatus.sortorderid', 'vtiger_taskpriority.sortorderid',
		'vtiger_taskstatus.sortorderid', 'vtiger_ticketcategories.sortorderid',
		'vtiger_ticketpriorities.sortorderid', 'vtiger_ticketseverities.sortorderid',
		'vtiger_ticketstatus.sortorderid', 'vtiger_tracking_unit.sortorderid',
		'vtiger_usageunit.sortorderid','vtiger_crmentity.label','vtiger_field.summaryfield',
		'vtiger_profile.directly_related_to_role','vtiger_role.allowassignedrecordsto',
		'vtiger_settings_field.pinned',	'vtiger_users.calendarsharedtype', 'vtiger_users.callduration',
		'vtiger_users.dayoftheweek', 'vtiger_users.default_record_view', 'vtiger_users.leftpanelhide',
		'vtiger_users.no_of_currency_decimals', 'vtiger_users.othereventduration', 'vtiger_users.rowheight',
		'vtiger_users.truncate_trailing_zeros','vtiger_projecttaskstatus.sortorderid',
		'com_vtiger_workflows.filtersavedinnew','com_vtiger_workflowtask_queue.task_contents'
);

foreach ($dropflds as $fqfn) {
	list($table,$field) = explode('.', $fqfn);
	ExecuteQuery("ALTER TABLE $table DROP $field");
}

$picklistResult = $adb->pquery('SELECT distinct fieldname FROM vtiger_field WHERE uitype IN (15,33)', array());
$numRows = $adb->num_rows($picklistResult);
for($i=0; $i<$numRows; $i++) {
	$fieldName = $adb->query_result($picklistResult,$i,'fieldname');
	$cninv=$adb->getColumnNames('vtiger_'.$fieldName);
	if (!in_array('sortorderid', $cninv)) continue;
	ExecuteQuery('ALTER TABLE vtiger_'.$fieldName.' DROP sortorderid');
}
//Convert picklist custom fields from vtiger 6 with uitype 16 to uitype 15 for to be possible to edit.
$result = $adb->pquery("SELECT * FROM vtiger_field WHERE uitype = '16' AND columnname LIKE 'cf_%'",array());

while ($row = $adb->getNextRow($result,false)) {
	
	$fieldname = $row['fieldname'];
	//Convert to uitype 15
	$adb->pquery("UPDATE vtiger_field SET uitype = 15 WHERE fieldname = ?",array($fieldname));
	
	$table_name = 'vtiger_'.$fieldname;
	$adb->query("ALTER TABLE ".$table_name." DROP sortorderid");
	$adb->query("ALTER TABLE ".$table_name." ADD picklist_valueid INT( 19 ) NOT NULL DEFAULT '0' AFTER presence");
	$res_picklist = $adb->pquery("SELECT * FROM ".$table_name,array());
	
	$new_picklistid = $adb->getUniqueID('vtiger_picklist');
	$adb->pquery("INSERT INTO vtiger_picklist (picklistid,name) VALUES(?,?)",Array($new_picklistid, $fieldname));
	
	// Add value to picklist now
	$sortid = 0;
	while ($row_picklist = $adb->getNextRow($res_picklist,false)) {
		
		$value = $row_picklist[$fieldname];
		$new_picklistvalueid = $adb->getUniqueID('vtiger_picklistvalues');
		$adb->pquery("UPDATE ".$table_name." SET picklist_valueid = ? WHERE ".$fieldname." = ?", array($new_picklistvalueid,$value));
		
		++$sortid;

		// Associate picklist values to all the role
		$adb->pquery("INSERT INTO vtiger_role2picklist(roleid, picklistvalueid, picklistid, sortid) SELECT roleid,
			$new_picklistvalueid, $new_picklistid, $sortid FROM vtiger_role", array());
	}
	
}

$modname = 'Users';
$module = Vtiger_Module::getInstance($modname);
$field = Vtiger_Field::getInstance('hour_format',$module);
$field->delete();
$field = Vtiger_Field::getInstance('start_hour',$module);
$field->delete();

$droptable = array(
	'vtiger_calendarsharedtype', 'vtiger_dayoftheweek', 'vtiger_hour_format', 'vtiger_start_hour',
	'vtiger_callduration', 'vtiger_crmsetup', 'vtiger_default_record_view', 'vtiger_module_dashboard_widgets',
	'vtiger_shorturls', 'vtiger_rowheight', 'vtiger_sqltimelog', 'vtiger_modtracker_relations', 'vtiger_othereventduration',
	'vtiger_no_of_currency_decimals','vtiger_customerportal_fields'
);

foreach ($droptable as $table) {
	ExecuteQuery("DROP TABLE $table");
}

ExecuteQuery('ALTER TABLE `vtiger_troubletickets` ADD `from_portal` VARCHAR(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;');
ExecuteQuery('UPDATE `vtiger_troubletickets`
		INNER JOIN `vtiger_ticketcf` ON `vtiger_ticketcf`.ticketid=`vtiger_troubletickets`.ticketid
		SET `vtiger_troubletickets`.`from_portal`=`vtiger_ticketcf`.`from_portal`');
ExecuteQuery('ALTER TABLE `vtiger_ticketcf` DROP `from_portal`');

// Migrate FAQ Comments
ExecuteQuery("INSERT INTO `vtiger_faqcomments`(`commentid`, `faqid`, `comments`, `createdtime`) 
		SELECT `modcommentsid`, `related_to`, `commentcontent`, CURDATE()
		FROM vtiger_modcomments
		INNER JOIN vtiger_crmentity ON crmid = related_to
		WHERE deleted = 0 and setype='FAQ'");
// Migrate Ticket Comments
ExecuteQuery("INSERT INTO `vtiger_ticketcomments`(`commentid`, `ticketid`, `comments`, `ownerid`, `ownertype`, `createdtime`)
		SELECT `modcommentsid`, `related_to`, `commentcontent`, 
				CASE WHEN customer = '' THEN userid ELSE customer END, 
				CASE WHEN customer = '' THEN 'user' ELSE 'customer' END, CURDATE()
		FROM vtiger_modcomments
		INNER JOIN vtiger_crmentity ON crmid = related_to
		WHERE deleted = 0 and setype='HelpDesk'");

// Recover chat functionality
ExecuteQuery("CREATE TABLE `vtiger_chat_users` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `nick` varchar(50) NOT NULL,
  `session` varchar(50) NOT NULL,
  `ip` varchar(20) NOT NULL DEFAULT '000.000.000.000',
  `ping` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `chat_users_nick_idx` (`nick`),
  KEY `chat_users_session_idx` (`session`),
  KEY `chat_users_ping_idx` (`ping`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8");

ExecuteQuery("CREATE TABLE `vtiger_chat_msg` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`chat_from` int(20) NOT NULL DEFAULT '0',
`chat_to` int(20) NOT NULL DEFAULT '0',
`born` datetime DEFAULT NULL,
`msg` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `chat_msg_chat_from_idx` (`chat_from`),
KEY `chat_msg_chat_to_idx` (`chat_to`),
KEY `chat_msg_born_idx` (`born`),
CONSTRAINT `fk_1_vtiger_chat_msg` FOREIGN KEY (`chat_from`) REFERENCES `vtiger_chat_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8");

ExecuteQuery("CREATE TABLE `vtiger_chat_pvchat` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `msg` int(20) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `chat_pvchat_msg_idx` (`msg`),
  CONSTRAINT `fk_1_vtiger_chat_pvchat` FOREIGN KEY (`msg`) REFERENCES `vtiger_chat_msg` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8");

ExecuteQuery("CREATE TABLE `vtiger_chat_pchat` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `msg` int(20) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `chat_pchat_msg_idx` (`msg`),
  CONSTRAINT `fk_1_vtiger_chat_pchat` FOREIGN KEY (`msg`) REFERENCES `vtiger_chat_msg` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8");

ExecuteQuery("CREATE TABLE `vtiger_ownernotify` (
`crmid` int(19) DEFAULT NULL,
`smownerid` int(19) DEFAULT NULL,
`flag` int(3) DEFAULT NULL,
KEY `ownernotify_crmid_flag_idx` (`crmid`,`flag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8");

ExecuteQuery('ALTER TABLE vtiger_inventoryproductrel MODIFY comment text', array());

// Meta information cleanup

$inventoryModules = array('Invoice','SalesOrder','PurchaseOrder','Quotes');
$actions = array('Import','Export');
for($i = 0; $i < count($inventoryModules); $i++) {
	$moduleName = $inventoryModules[$i];
	$moduleInstance = Vtiger_Module::getInstance($moduleName);
	foreach ($actions as $actionName) {
		Vtiger_Access::updateTool($moduleInstance, $actionName, false, '');
	}
}

$delws = array('LineItem','ProductTaxes','Tax');
foreach ($delws as $ws) {
	$wsrs = $adb->query("select id from vtiger_ws_entity where name='$ws'");
	$wsid = $adb->query_result($wsrs,0,0);
	ExecuteQuery("delete from vtiger_ws_entity_tables where webservice_entity_id=$wsid");
	ExecuteQuery("delete from vtiger_ws_entity where id=$wsid");
}
$wsfrs = $adb->query("SELECT fieldtypeid FROM `vtiger_ws_entity_fieldtype` WHERE `table_name` in ('vtiger_inventoryproductrel','vtiger_producttaxrel')");
while ($wse = $adb->fetch_array($wsfrs)) {
	$wseid = $wse['fieldtypeid'];
	ExecuteQuery("delete from vtiger_ws_entity_referencetype where fieldtypeid=$wseid");
	ExecuteQuery("delete from vtiger_ws_entity_fieldtype where fieldtypeid=$wseid");
}

$wsoprs = $adb->query("select operationid from vtiger_ws_operation where name='retrieve_inventory'");
$wsopid = $adb->query_result($wsoprs,0,0);
ExecuteQuery("delete from vtiger_ws_operation_parameters where operationid=$wsopid");
ExecuteQuery("delete from vtiger_ws_operation where operationid=$wsopid");
ExecuteQuery("UPDATE vtiger_ws_entity SET handler_path='include/Webservices/VtigerModuleOperation.php',handler_class='VtigerModuleOperation' where name in ('Invoice','Quotes','PurchaseOrder','SalesOrder');");
ExecuteQuery("delete from com_vtiger_workflowtasks_entitymethod where module_name='ModComments'");
ExecuteQuery("delete from vtiger_eventhandlers where handler_class='ModCommentsHandler' and handler_path='modules/ModComments/ModCommentsHandler.php'");
ExecuteQuery("delete from vtiger_eventhandlers where handler_class='Vtiger_RecordLabelUpdater_Handler' and handler_path='modules/Vtiger/handlers/RecordLabelUpdater.php'");
ExecuteQuery("DELETE FROM vtiger_eventhandler_module WHERE handler_class='Vtiger_RecordLabelUpdater_Handler'");
ExecuteQuery("delete from vtiger_eventhandlers where handler_class='InvoiceHandler' and handler_path='modules/Invoice/InvoiceHandler.php'");
ExecuteQuery("delete from vtiger_eventhandlers where handler_class='PurchaseOrderHandler' and handler_path='modules/PurchaseOrder/PurchaseOrderHandler.php'");
ExecuteQuery("delete from vtiger_links where linktype in ('DASHBOARDWIDGET','DETAILVIEWSIDEBARWIDGET','LISTVIEWSIDEBARWIDGET')");
ExecuteQuery("delete from vtiger_eventhandlers where handler_class='PickListHandler' and handler_path='modules/Settings/Picklist/handlers/PickListHandler.php'");
ExecuteQuery("update vtiger_blocks set blocklabel='' where blocklabel like 'Emails_Block%'");

ExecuteQuery("UPDATE vtiger_links SET handler = null, handler_class = null, handler_path = null WHERE handler = 'isLinkPermitted'");

ExecuteQuery("delete from vtiger_settings_field where name='LBL_EDIT_FIELDS'");
$fieldId = $adb->getUniqueID('vtiger_settings_field');
$query = "INSERT INTO vtiger_settings_field (fieldid, blockid, name, iconpath, description, linkto, sequence) ".
		"VALUES ($fieldId,4,'EMAILTEMPLATES','ViewTemplate.gif','LBL_EMAIL_TEMPLATE_DESCRIPTION','index.php?module=Settings&action=listemailtemplates&parenttab=Settings',4)";
ExecuteQuery($query);
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Administration&action=index&parenttab=Settings' where name = 'LBL_USERS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=listroles&parenttab=Settings' where name = 'LBL_ROLES'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=ListProfiles&parenttab=Settings' where name = 'LBL_PROFILES'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=listgroups&parenttab=Settings' where name = 'USERGROUPLIST'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=OrgSharingDetailView&parenttab=Settings' where name = 'LBL_SHARING_ACCESS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=DefaultFieldPermissions&parenttab=Settings' where name = 'LBL_FIELDS_ACCESS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=AuditTrailList&parenttab=Settings' where name = 'LBL_AUDIT_TRAIL'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=ListLoginHistory&parenttab=Settings' where name = 'LBL_LOGIN_HISTORY_DETAILS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=ModuleManager&parenttab=Settings' where name = 'VTLIB_LBL_MODULE_MANAGER'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=PickList&action=PickList&parenttab=Settings' where name = 'LBL_PICKLIST_EDITOR'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=PickList&action=PickListDependencySetup&parenttab=Settings' where name = 'LBL_PICKLIST_DEPENDENCY_SETUP'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=listwordtemplates&parenttab=Settings' where name = 'LBL_MAIL_MERGE'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=listnotificationschedulers&parenttab=Settings' where name = 'NOTIFICATIONSCHEDULERS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=listinventorynotifications&parenttab=Settings' where name = 'INVENTORYNOTIFICATION'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=OrganizationConfig&parenttab=Settings' where name = 'LBL_COMPANY_DETAILS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=EmailConfig&parenttab=Settings' where name = 'LBL_MAIL_SERVER_SETTINGS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=BackupServerConfig&parenttab=Settings' where name = 'LBL_BACKUP_SERVER_SETTINGS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=CurrencyListView&parenttab=Settings' where name = 'LBL_CURRENCY_SETTINGS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=TaxConfig&parenttab=Settings' where name = 'LBL_TAX_SETTINGS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=System&action=listsysconfig&parenttab=Settings' where name = 'LBL_SYSTEM_INFO'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=ProxyServerConfig&parenttab=Settings' where name = 'LBL_PROXY_SETTINGS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=Announcements&parenttab=Settings' where name = 'LBL_ANNOUNCEMENT'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=DefModuleView&parenttab=Settings' where name = 'LBL_DEFAULT_MODULE_VIEW'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=OrganizationTermsandConditions&parenttab=Settings' where name = 'INVENTORYTERMSANDCONDITIONS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=CustomModEntityNo&parenttab=Settings' where name = 'LBL_CUSTOMIZE_MODENT_NUMBER'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=MailScanner&parenttab=Settings' where name = 'LBL_MAIL_SCANNER'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=com_vtiger_workflow&action=workflowlist&parenttab=Settings' where name = 'LBL_LIST_WORKFLOWS'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Settings&action=MenuEditor&parenttab=Settings' where name = 'LBL_MENU_EDITOR'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=com_vtiger_workflow&action=workflowlist' where name = 'LBL_WORKFLOW_LIST'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=ConfigEditor&action=index', description='Update configuration file of the application' where name = 'Configuration Editor' or name = 'LBL_CONFIG_EDITOR'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=ModTracker&action=BasicSettings&parenttab=Settings&formodule=ModTracker' where name = 'ModTracker'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=CustomerPortal&action=index&parenttab=Settings' where name = 'LBL_CUSTOMER_PORTAL'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Webforms&action=index&parenttab=Settings', description='Allows you to manage Webforms' where name = 'Webforms'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=CronTasks&action=ListCronJobs&parenttab=Settings', description='Allows you to Configure Cron Task' where name = 'Scheduler'");
ExecuteQuery("UPDATE `vtiger_settings_field` set `linkto` = 'index.php?module=Tooltip&action=QuickView&parenttab=Settings' where name = 'LBL_TOOLTIP_MANAGEMENT'");

//Delete new Blocks in Calendar
ExecuteQuery("UPDATE vtiger_blocks SET blocklabel = '' WHERE blocklabel = 'LBL_DESCRIPTION_INFORMATION' AND tabid = '9'");
ExecuteQuery("UPDATE vtiger_blocks SET blocklabel = '' WHERE blocklabel = 'LBL_DESCRIPTION_INFORMATION' AND tabid = '16'");
ExecuteQuery("UPDATE vtiger_blocks SET blocklabel = '' WHERE blocklabel = 'LBL_REMINDER_INFORMATION' AND tabid = 16");
ExecuteQuery("UPDATE vtiger_field SET block = '41' WHERE tabid = '16' and fieldname NOT IN('reminder_time','contact_id')");
ExecuteQuery("UPDATE vtiger_field SET block = '19' WHERE tabid = '16' and fieldname = 'contact_id'");

// Change HelpDesk Workflows
global $adb;
$workflowManager = new VTWorkflowManager($adb);
$taskManager = new VTTaskManager($adb);
$wfrs = $adb->query("SELECT workflow_id,summary FROM com_vtiger_workflows WHERE module_name='HelpDesk'");
while ($wfid = $adb->fetch_array($wfrs)) {
	deleteWorkflow($wfid['workflow_id']);
	putMsg('Workflow "'.$wfid['summary'].'" deleted!');
}

// Trouble Tickets workflow on creation from Customer Portal
$helpDeskWorkflow = $workflowManager->newWorkFlow("HelpDesk");
$helpDeskWorkflow->test = '[{"fieldname":"from_portal","operation":"is","value":"true:boolean"}]';
$helpDeskWorkflow->description = "Workflow for Ticket Created from Portal";
$helpDeskWorkflow->executionCondition = VTWorkflowManager::$ON_FIRST_SAVE;
$helpDeskWorkflow->defaultworkflow = 1;
$workflowManager->save($helpDeskWorkflow);

$task = $taskManager->createTask('VTEntityMethodTask', $helpDeskWorkflow->id);
$task->active = true;
$task->summary = 'Notify Record Owner and the Related Contact when Ticket is created from Portal';
$task->methodName = "NotifyOnPortalTicketCreation";
$taskManager->saveTask($task);
putMsg('Workflow "'.$helpDeskWorkflow->description.'" created!');

// Trouble Tickets workflow on ticket update from Customer Portal
$helpDeskWorkflow = $workflowManager->newWorkFlow("HelpDesk");
$helpDeskWorkflow->test = '[{"fieldname":"from_portal","operation":"is","value":"true:boolean"}]';
$helpDeskWorkflow->description = "Workflow for Ticket Updated from Portal";
$helpDeskWorkflow->executionCondition = VTWorkflowManager::$ON_MODIFY;
$helpDeskWorkflow->defaultworkflow = 1;
$workflowManager->save($helpDeskWorkflow);

$task = $taskManager->createTask('VTEntityMethodTask', $helpDeskWorkflow->id);
$task->active = true;
$task->summary = 'Notify Record Owner when Comment is added to a Ticket from Customer Portal';
$task->methodName = "NotifyOnPortalTicketComment";
$taskManager->saveTask($task);
putMsg('Workflow "'.$helpDeskWorkflow->description.'" created!');

// Trouble Tickets workflow on ticket change, which is not from Customer Portal - Both Record Owner and Related Customer
$helpDeskWorkflow = $workflowManager->newWorkFlow("HelpDesk");
$helpDeskWorkflow->test = '[{"fieldname":"from_portal","operation":"is","value":"false:boolean"}]';
$helpDeskWorkflow->description = "Workflow for Ticket Change, not from the Portal";
$helpDeskWorkflow->executionCondition = VTWorkflowManager::$ON_EVERY_SAVE;
$helpDeskWorkflow->defaultworkflow = 1;
$workflowManager->save($helpDeskWorkflow);

$task = $taskManager->createTask('VTEntityMethodTask', $helpDeskWorkflow->id);
$task->active = true;
$task->summary = 'Notify Record Owner on Ticket Change, which is not done from Portal';
$task->methodName = "NotifyOwnerOnTicketChange";
$taskManager->saveTask($task);

$task = $taskManager->createTask('VTEntityMethodTask', $helpDeskWorkflow->id);
$task->active = true;
$task->summary = 'Notify Related Customer on Ticket Change, which is not done from Portal';
$task->methodName = "NotifyParentOnTicketChange";
$taskManager->saveTask($task);
putMsg('Workflow "'.$helpDeskWorkflow->description.'" created!');

$delmods = array(
	'EmailTemplates','Google','ExtensionStore'
);

foreach ($delmods as $module) {
	$mod = Vtiger_Module::getInstance($module);
	if ($mod) {
		$mod->deleteRelatedLists();
		$mod->deleteLinks();
		$mod->deinitWebservice();
		$mod->delete();
		echo "<b>Module $module EXTERMINATED!</b><br>";
	}
}

$delmods = array(
	'ar_ae', 'sv_se','tr_tr','pl_pl','ro_ro','ru_ru',
);
require_once('vtlib/Vtiger/Language.php');
foreach ($delmods as $prefix) {
	$languagePack = new Vtiger_Language();
	@$languagePack->deregister($prefix);
}

$insmods = array(
	'CronTasks', 'ConfigEditor','PBXManager','cbupdater'
);
foreach ($insmods as $module) {
	$package = new Vtiger_Package();
	$rdo = $package->importManifest("modules/$module/manifest.xml");
}

$mod = Vtiger_Module::getInstance('ModTracker');
$mod->addLink('HEADERSCRIPT', 'ModTrackerCommon_JS', 'modules/ModTracker/ModTrackerCommon.js');
?>