ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / letacommog / crmleta / modules / Migration / schema

<?php
/*+********************************************************************************
 * The contents of this file are subject to the vtiger CRM Public License Version 1.0
 * ("License"); You may not use this file except in compliance with the License
 * The Original Code is: vtiger CRM Open Source
 * The Initial Developer of the Original Code is vtiger.
 * Portions created by vtiger are Copyright (C) vtiger.
 * All Rights Reserved.
 *********************************************************************************/

if(defined('VTIGER_UPGRADE')) {

//Start add new currency - 'CFP Franc or Pacific Franc' 
global $adb;

$query = 'UPDATE vtiger_currencies_seq SET id = (SELECT currencyid FROM vtiger_currencies ORDER BY currencyid DESC LIMIT 1)';
$adb->pquery($query, array());

$uniqId = $adb->getUniqueID('vtiger_currencies'); 
$result = $adb->pquery('SELECT 1 FROM vtiger_currencies WHERE currency_name = ?',array('CFP Franc')); 
 
if($adb->num_rows($result)<=0){ 
Migration_Index_View::ExecuteQuery('INSERT INTO vtiger_currencies VALUES (?,?,?,?)', array($uniqId, 'CFP Franc', 'XPF', 'F')); 
}

//Adding new timezone (GMT+11:00) New Caledonia 
 $sortOrderResult = $adb->pquery("SELECT sortorderid FROM vtiger_time_zone WHERE time_zone = ?", array('Asia/Yakutsk'));
 if ($adb->num_rows($sortOrderResult)) {
 $sortOrderId = $adb->query_result($sortOrderResult, 0, 'sortorderid');
 $adb->pquery("UPDATE vtiger_time_zone SET sortorderid = (sortorderid + 1) WHERE sortorderid > ?", array($sortOrderId));
 Migration_Index_View::ExecuteQuery('INSERT INTO vtiger_time_zone (time_zone, sortorderid, presence) VALUES (?, ?, ?)', array('Etc/GMT-11', ($sortOrderId + 1), 1));
 echo "New timezone (GMT+11:00) New Caledonia added. ";
 }

//updating the config file to support multiple layout
$filename = 'config.inc.php';
if (file_exists($filename)) {
 $contents = file_get_contents($filename);
 if (empty($contents)) {
 echo '<tr><td width="80%">Your Configuration file couldnot able to edit, Please asdd it manually</td><td style="color:red">Unsuccess</td></tr>';
 } else {
 $config_content = explode('?>', $contents);
 if (strpos($config_content[0], '$default_layout') == false) {
 $config_code = "// Set the default layout 
\$default_layout = 'vlayout';

include_once 'config.security.php';
?>";
 $contents = $config_content[0] . $config_code;
 }
 file_put_contents($filename, $contents);
 echo '<tr><td width="80%">Configuration file Updated</td><td style="color:green">Success</td></tr>';
 }
}
}
?>

[+] ..
[-] CONVENTION.md [edit]
[-] 620_to_630.php [edit]
[-] 600RC_to_600.php [edit]
[-] 701_to_710.php [edit]
[-] 630_to_640.php [edit]
[-] 610_to_620.php [edit]
[-] 640_to_650.php [edit]
[-] 650_to_660.php [edit]
[-] 660_to_700.php [edit]
[-] 600_to_610.php [edit]
[-] 540_to_600RC.php [edit]
[-] 700_to_701.php [edit]