Example #1
0
ExecuteQuery("ALTER TABLE vtiger_field CHANGE COLUMN selected defaultvalue TEXT default ''");
ExecuteQuery("UPDATE vtiger_field SET defaultvalue='' WHERE defaultvalue='0'");
// Scheduled Reports (Email)
ExecuteQuery("CREATE TABLE IF NOT EXISTS vtiger_scheduled_reports(reportid INT, recipients TEXT, schedule TEXT,\n\t\t\t\t\t\t\t\t\tformat VARCHAR(10), next_trigger_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(reportid))\n\t\t\t\tENGINE=InnoDB DEFAULT CHARSET=utf8;");
// Change Display of User Name from user_name to lastname firstname.
$usersQuery = "SELECT * FROM vtiger_users";
$usersResult = $adb->query($usersQuery);
$usersCount = $adb->num_rows($usersResult);
for ($i = 0; $i < $usersCount; ++$i) {
    $userId = $adb->query_result($usersResult, $i, 'id');
    $userName = $adb->query_result($usersResult, $i, 'user_name');
    $fullName = getFullNameFromQResult($usersResult, $i, 'Users');
    ExecutePQuery("UPDATE vtiger_cvadvfilter SET value=? WHERE columnname LIKE '%:assigned_user_id:%' AND value=?", array($fullName, $userName));
    ExecutePQuery("UPDATE vtiger_cvadvfilter SET value=? WHERE columnname LIKE '%:assigned_user_id1:%' AND value=?", array($fullName, $userName));
    ExecutePQuery("UPDATE vtiger_relcriteria SET value=? WHERE columnname LIKE 'vtiger_users%:user_name%' AND value=?", array($fullName, $userName));
    ExecutePQuery("UPDATE vtiger_cvadvfilter SET comparator='c'\n\t\t\t\t\t\tWHERE (columnname LIKE '%:assigned_user_id%:' OR columnname LIKE '%:assigned_user_id1%:' OR columnname LIKE '%:modifiedby%:')\n\t\t\t\t\t\t\t\tAND (comparator='s' OR comparator='ew')", array());
}
// Rename Yahoo Id field to Secondary Email field
function vt530_renameField($fieldInfo)
{
    global $adb;
    $moduleName = $fieldInfo['moduleName'];
    $tableName = $fieldInfo['tableName'];
    $fieldName = $fieldInfo['fieldName'];
    $fieldLabel = $fieldInfo['fieldLabel'];
    $fieldColumnName = $fieldInfo['columnName'];
    $newFieldName = $fieldInfo['newFieldName'];
    $newFieldLabel = $fieldInfo['newFieldLabel'];
    $newColumnName = $fieldInfo['newColumnName'];
    $columnType = $fieldInfo['columnType'];
    $tabId = getTabid($moduleName);
Example #2
0
            echo 'FAILED TO SETUP ' . $customWebserviceDetails['name'] . ' WEBSERVICE HALFWAY THOURGH';
            die;
        }
    }
}
VT520_webserviceMigrate();
$update_InvProductRel = "ALTER TABLE vtiger_inventoryproductrel MODIFY discount_amount decimal(25,3)";
ExecuteQuery($update_InvProductRel);
// Registering events for ON MODIFY in Workflows
$handlerId = $adb->getUniqueId('vtiger_eventhandlers');
$modifyevent = 'vtiger.entity.afterrestore';
$eventPath = 'modules/com_vtiger_workflow/VTEventHandler.inc';
$handlerClass = 'VTWorkflowEventHandler';
$modifyevent = $adb->pquery("insert into vtiger_eventhandlers(eventhandler_id, event_name, handler_path, handler_class,cond,is_active)\n\t\tvalues (?,?,?,?,?,1)", array($handlerId, $modifyevent, $eventPath, $handlerClass, ''));
//Create TaskTypes Table
ExecutePQuery("CREATE TABLE IF NOT EXISTS com_vtiger_workflow_tasktypes (\n\t\t\t\tid int(11) NOT NULL,\n\t\t\t\ttasktypename varchar(255) NOT NULL,\n\t\t\t\tlabel varchar(255),\n\t\t\t\tclassname varchar(255),\n\t\t\t\tclasspath varchar(255),\n\t\t\t\ttemplatepath varchar(255),\n\t\t\t\tmodules text(500),\n\t\t\t\tsourcemodule varchar(255)\n\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8", array());
require_once "modules/com_vtiger_workflow/include.inc";
require_once "modules/com_vtiger_workflow/tasks/VTEntityMethodTask.inc";
require_once "modules/com_vtiger_workflow/VTEntityMethodManager.inc";
// add default workflow types
$taskTypes = array();
$defaultModules = array('include' => array(), 'exclude' => array());
$taskTypes[] = array("name" => "VTEmailTask", "label" => "Send Mail", "classname" => "VTEmailTask", "classpath" => "modules/com_vtiger_workflow/tasks/VTEmailTask.inc", "templatepath" => "com_vtiger_workflow/taskforms/VTEmailTask.tpl", "modules" => $defaultModules, "sourcemodule" => '');
foreach ($taskTypes as $taskType) {
    VTTaskType::registerTaskType($taskType);
}
// Populate Default Workflows
populateDefaultWorkflows($adb);
function populateDefaultWorkflows($adb)
{
    require_once "modules/com_vtiger_workflow/include.inc";
Example #3
0
    $userName = $adb->query_result($usersResult, $i, 'user_name');
    $firstName = $adb->query_result($usersResult, $i, 'first_name');
    $lastName = $adb->query_result($usersResult, $i, 'last_name');
    $fullName = getFullNameFromQResult($usersResult, $i, 'Users');
    $oldFullName = $lastName . ' ' . $firstName;
    ExecutePQuery("UPDATE vtiger_cvadvfilter SET value=? WHERE columnname LIKE '%:assigned_user_id:%' AND value=?", array($fullName, $oldFullName));
    ExecutePQuery("UPDATE vtiger_cvadvfilter SET value=? WHERE columnname LIKE '%:modifiedby:%' AND value=?", array($fullName, $oldFullName));
    ExecutePQuery("UPDATE vtiger_cvadvfilter SET value=? WHERE columnname LIKE '%:assigned_user_id1:%' AND value=?", array($fullName, $oldFullName));
    ExecutePQuery("UPDATE vtiger_relcriteria SET value=? WHERE columnname LIKE 'vtiger_users%:user_name%' AND value=?", array($fullName, $oldFullName));
    ExecutePQuery("UPDATE vtiger_relcriteria SET value=? WHERE columnname LIKE '%:modifiedby:%' AND value=?", array($fullName, $oldFullName));
    ExecutePQuery("UPDATE vtiger_cvadvfilter SET comparator='c'\r\n\t\t\t\t\t\tWHERE (columnname LIKE '%:assigned_user_id%:' OR columnname LIKE '%:assigned_user_id1%:' OR columnname LIKE '%:modifiedby%:')\r\n\t\t\t\t\t\t\t\tAND (comparator='s' OR comparator='ew')", array());
    ExecutePQuery("UPDATE vtiger_relcriteria SET comparator='c'\r\n\t\t\t\t\t\tWHERE (columnname LIKE 'vtiger_users%:user_name%' OR columnname LIKE '%:modifiedby%:')\r\n\t\t\t\t\t\t\t\tAND (comparator='s' OR comparator='ew')", array());
}
$replaceReportColumnsList = array('vtiger_accountAccounts:accountname:Accounts_Member_Of:account_id:V' => 'vtiger_account:parentid:Accounts_Member_Of:account_id:V', 'vtiger_accountContacts:accountname:Contacts_Account_Name:account_id:V' => 'vtiger_contactdetails:accountid:Contacts_Account_Name:account_id:V', 'vtiger_contactdetailsContacts:lastname:Contacts_Reports_To:contact_id:V' => 'vtiger_contactdetails:reportsto:Contacts_Reports_To:contact_id:V', 'vtiger_productsCampaigns:productname:Campaigns_Product:product_id:V' => 'vtiger_campaign:product_id:Campaigns_Product:product_id:V', 'vtiger_productsFaq:productname:Faq_Product_Name:product_id:V' => 'vtiger_faq:product_id:Faq_Product_Name:product_id:V', 'vtiger_contactdetailsInvoice:lastname:Invoice_Contact_Name:contact_id:V' => 'vtiger_invoice:contactid:Invoice_Contact_Name:contact_id:V', 'vtiger_accountInvoice:accountname:Invoice_Account_Name:account_id:V' => 'vtiger_invoice:accountid:Invoice_Account_Name:account_id:V', 'vtiger_campaignPotentials:campaignname:Potentials_Campaign_Source:campaignid:V' => 'vtiger_potential:campaignid:Potentials_Campaign_Source:campaignid:V', 'vtiger_vendorRelProducts:vendorname:Products_Vendor_Name:vendor_id:V' => 'vtiger_products:vendor_id:Products_Vendor_Name:vendor_id:V', 'vtiger_vendorRelPurchaseOrder:vendorname:PurchaseOrder_Vendor_Name:vendor_id:V' => 'vtiger_purchaseorder:vendorid:PurchaseOrder_Vendor_Name:vendor_id:V', 'vtiger_contactdetailsPurchaseOrder:lastname:PurchaseOrder_Contact_Name:contact_id:V' => 'vtiger_purchaseorder:contactid:PurchaseOrder_Contact_Name:contact_id:V', 'vtiger_potentialRelQuotes:potentialname:Quotes_Potential_Name:potential_id:V' => 'vtiger_quotes:potentialid:Quotes_Potential_Name:potential_id:V', 'vtiger_contactdetailsQuotes:lastname:Quotes_Contact_Name:contact_id:V' => 'vtiger_quotes:contactid:Quotes_Contact_Name:contact_id:V', 'vtiger_accountQuotes:accountname:Quotes_Account_Name:account_id:V' => 'vtiger_quotes:accountid:Quotes_Account_Name:account_id:V', 'vtiger_quotesSalesOrder:subject:SalesOrder_Quote_Name:quote_id:V' => 'vtiger_salesorder:quoteid:SalesOrder_Quote_Name:quote_id:V', 'vtiger_contactdetailsSalesOrder:lastname:SalesOrder_Contact_Name:contact_id:V' => 'vtiger_salesorder:contactid:SalesOrder_Contact_Name:contact_id:V', 'vtiger_accountSalesOrder:accountname:SalesOrder_Account_Name:account_id:V' => 'vtiger_salesorder:accountid:SalesOrder_Account_Name:account_id:V', 'vtiger_crmentityRelHelpDesk:setype:HelpDesk_Related_To:parent_id:V' => 'vtiger_troubletickets:parent_id:HelpDesk_Related_To:parent_id:V', 'vtiger_productsRel:productname:HelpDesk_Product_Name:product_id:V' => 'vtiger_troubletickets:product_id:HelpDesk_Product_Name:product_id:V', 'vtiger_crmentityRelCalendar:setype:Calendar_Related_To:parent_id:V' => 'vtiger_seactivityrel:crmid:Calendar_Related_To:parent_id:V', 'vtiger_contactdetailsCalendar:lastname:Calendar_Contact_Name:contact_id:V' => 'vtiger_cntactivityrel:contactid:Calendar_Contact_Name:contact_id:V');
foreach ($replaceReportColumnsList as $oldName => $newName) {
    ExecutePQuery('UPDATE vtiger_selectcolumn SET columnname=? WHERE columnname=?', array($newName, $oldName));
    ExecutePQuery('UPDATE vtiger_relcriteria SET columnname=? WHERE columnname=?', array($newName, $oldName));
    ExecutePQuery('UPDATE vtiger_reportsortcol SET columnname=? WHERE columnname=?', array($newName, $oldName));
}
// Report Charts - tables creation
ExecutePQuery("CREATE TABLE if not exists vtiger_homereportchart (stuffid int(19) PRIMARY KEY, reportid int(19), reportcharttype varchar(100))", array());
ExecutePQuery("CREATE TABLE vtiger_reportgroupbycolumn(reportid int(19),sortid int(19),sortcolname varchar(250),dategroupbycriteria varchar(250))", array());
ExecutePQuery("ALTER TABLE vtiger_reportgroupbycolumn add constraint fk_1_vtiger_reportgroupbycolumn FOREIGN KEY (reportid) REFERENCES vtiger_report(reportid) ON DELETE CASCADE", array());
ExecutePQuery("insert into vtiger_reportgroupbycolumn (reportid, sortid, sortcolname, dategroupbycriteria) select reportid, sortcolid, columnname, 'None' from vtiger_reportsortcol where columnname like '%:D'", array());
ExecutePQuery("DELETE FROM vtiger_time_zone WHERE time_zone = 'Kwajalein'", array());
ExecutePQuery("UPDATE vtiger_users SET time_zone='UTC' WHERE time_zone='Kwajalein'", array());
$serviceContractsInstance = Vtiger_Module::getInstance('ServiceContracts');
$helpDeskInstance = Vtiger_Module::getInstance("HelpDesk");
$helpDeskInstance->setRelatedList($serviceContractsInstance, "Service Contracts", array('ADD', 'SELECT'));
ExecutePQuery("UPDATE vtiger_field SET uitype=11 WHERE fieldname IN ('phone_work', 'phone_mobile', 'phone_fax', 'phone_home', 'phone_other')\r\n\t\t\t\t\t\t\tAND tabid IN (SELECT tabid FROM vtiger_tab WHERE name='Users')", array());
$migrationlog->debug("\n\nDB Changes from 5.3.0 to 5.4.0RC -------- Ends \n\n");