/**
* Function starts applying schema changes
*/
public static function initialize()
{
global $adb;
$adb = PearDatabase::getInstance();
$adb->createTables("schema/DatabaseSchema.xml");
$defaultDataPopulator = new DefaultDataPopulator();
$defaultDataPopulator->create_tables();
self::createDefaultUsersAccess();
// create and populate combo tables
$combo = new PopulateComboValues();
$combo->create_tables();
$combo->create_nonpicklist_tables();
create_tab_data_file();
create_parenttab_data_file();
// default report population
vimport('~~modules/Reports/PopulateReports.php');
// default customview population
vimport('~~modules/CustomView/PopulateCustomView.php');
// ensure required sequences are created (adodb creates them as needed, but if
// creation occurs within a transaction we get problems
$adb->getUniqueID("vtiger_crmentity");
$adb->getUniqueID("vtiger_seactivityrel");
$adb->getUniqueID("vtiger_freetags");
$currencyName = $_SESSION['config_file_info']['currency_name'];
$currencyCode = $_SESSION['config_file_info']['currency_code'];
$currencySymbol = $_SESSION['config_file_info']['currency_symbol'];
$adb->pquery("INSERT INTO vtiger_currency_info VALUES (?,?,?,?,?,?,?,?)", array($adb->getUniqueID("vtiger_currency_info"), $currencyName, $currencyCode, $currencySymbol, 1, 'Active', '-11', '0'));
Install_InitSchema_Model::installDefaultEventsAndWorkflows();
}
public function Step7(Vtiger_Request $request)
{
// Set favourable error reporting
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
$moduleName = $request->getModule();
if ($_SESSION['config_file_info']['authentication_key'] != $request->get('auth_key')) {
die(vtranslate('ERR_NOT_AUTHORIZED_TO_PERFORM_THE_OPERATION', $moduleName));
}
// Create configuration file
$configParams = $_SESSION['config_file_info'];
$configFile = new Install_ConfigFileUtils_Model($configParams);
$configFile->createConfigFile();
global $adb;
$adb->resetSettings($configParams['db_type'], $configParams['db_hostname'], $configParams['db_name'], $configParams['db_username'], $configParams['db_password']);
$adb->query('SET NAMES utf8');
// Initialize and set up tables
Install_InitSchema_Model::initialize();
// Install all the available modules
Install_Utils_Model::installModules();
Install_InitSchema_Model::upgrade();
$viewer = $this->getViewer($request);
$viewer->assign('PASSWORD', $_SESSION['config_file_info']['password']);
$viewer->assign('APPUNIQUEKEY', $this->retrieveConfiguredAppUniqueKey());
$viewer->assign('CURRENT_VERSION', $_SESSION['vtiger_version']);
$viewer->assign('INDUSTRY', $request->get('industry'));
$viewer->view('Step7.tpl', $moduleName);
}
public function mStep3(Vtiger_Request $request)
{
$system = $request->get('system');
$source_directory = $request->get('source_directory');
$username = $request->get('username');
$password = $request->get('password');
$errorText = '';
$loginStatus = false;
$migrationURL = 'Install.php?mode=execute&ajax=true&system=' . $system . '&user='******'result']) {
include 'config/config.inc.php';
$adb = new PearDatabase($dbconfig['db_type'], $dbconfig['db_hostname'], $dbconfig['db_name'], $dbconfig['db_username'], $dbconfig['db_password']);
vglobal('adb', $adb);
$query = "SELECT crypt_type, user_name FROM vtiger_users WHERE user_name=?";
$result = $adb->requirePsSingleResult($query, array($username), true);
if ($adb->num_rows($result) > 0) {
$crypt_type = $adb->query_result($result, 0, 'crypt_type');
$salt = substr($username, 0, 2);
if ($crypt_type == 'MD5') {
$salt = '$1$' . $salt . '$';
} elseif ($crypt_type == 'BLOWFISH') {
$salt = '$2$' . $salt . '$';
} elseif ($crypt_type == 'PHP5.3MD5') {
$salt = '$1$' . str_pad($salt, 9, '0');
}
$encrypted_password = crypt($password, $salt);
$query = "SELECT 1 from vtiger_users where user_name=? AND user_password=? AND status = ?";
$result = $adb->requirePsSingleResult($query, array($username, $encrypted_password, 'Active'), true);
if ($adb->num_rows($result) > 0) {
$loginStatus = true;
}
}
if (!$loginStatus) {
$errorText = 'LBL_WRONG_USERNAME_OR_PASSWORD';
file_put_contents('config/config.inc.php', '');
}
} else {
$errorText = $createConfig['text'];
}
$viewer->setTemplateDir('install/tpl/');
$viewer->assign('LANG', $request->get('lang'));
$viewer->assign('MIGRATIONURL', $migrationURL);
$viewer->assign('ERRORTEXT', $errorText);
$viewer->assign('MIGRATIONRESULT', $migrationResult);
echo $viewer->fetch('mStep3.tpl');
if ($loginStatus) {
echo $viewer->fetch('mStep3Pre.tpl');
$migrationResult = Install_InitSchema_Model::executeMigrationSchema($system, $username, $source_directory);
echo $viewer->fetch('mStep3Post.tpl');
}
}
public function Step7(Vtiger_Request $request)
{
// Set favourable error reporting
version_compare(PHP_VERSION, '5.5.0') <= 0 ? error_reporting(E_WARNING & ~E_NOTICE & ~E_DEPRECATED) : error_reporting(E_WARNING & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT);
$moduleName = $request->getModule();
$webuiInstance = new Vtiger_WebUI();
$isInstalled = $webuiInstance->isInstalled();
if (!$isInstalled) {
if ($_SESSION['config_file_info']['authentication_key'] != $request->get('auth_key')) {
die(vtranslate('ERR_NOT_AUTHORIZED_TO_PERFORM_THE_OPERATION', $moduleName));
}
// Create configuration file
$configParams = $_SESSION['config_file_info'];
$configFile = new Install_ConfigFileUtils_Model($configParams);
$configFile->createConfigFile();
global $adb;
$adb->resetSettings($configParams['db_type'], $configParams['db_hostname'], $configParams['db_name'], $configParams['db_username'], $configParams['db_password']);
$adb->query('SET NAMES utf8');
// Initialize and set up tables
Install_InitSchema_Model::initialize();
// Install all the available modules
Install_Utils_Model::installModules();
Install_InitSchema_Model::upgrade();
$viewer = $this->getViewer($request);
$viewer->assign('PASSWORD', $_SESSION['config_file_info']['password']);
$viewer->assign('APPUNIQUEKEY', $this->retrieveConfiguredAppUniqueKey());
$viewer->assign('CURRENT_VERSION', $_SESSION['vtiger_version']);
$viewer->assign('INDUSTRY', $request->get('industry'));
$viewer->view('Step7.tpl', $moduleName);
} else {
$response = new Vtiger_Response();
$response->setResult(vtranslate('THIS_INSTANCE_IS_ALREADY_INSTALLED', $moduleName));
return $response;
}
}
public function addRecords()
{
global $log, $adb;
$log->debug("Entering VT620_to_YT::addRecords() method ...");
//include('config/config.inc.php');
global $dbconfig;
$assigned_user_id = $this->adminId;
$user = new Users();
$current_user = $user->retrieveCurrentUserInfoFromFile($assigned_user_id);
$moduleName = 'OSSMailTemplates';
vimport('~~modules/' . $moduleName . '/' . $moduleName . '.php');
$records = array();
$records[] = array(35, 'Notify Owner On Ticket Change', 'HelpDesk', '#t#LBL_NOTICE_MODIFICATION#tEnd# #a#155#aEnd#: #a#169#aEnd#', '<div>
<h3>#t#LBL_NOTICE_WELCOME#tEnd# <strong>YetiForce Sp. z o.o.</strong></h3>
#t#SINGLE_HelpDesk#tEnd# #a#155#aEnd# #t#LBL_NOTICE_UPDATED#tEnd# #a#168#aEnd#). #s#ChangesList#sEnd#
<hr /><h1><a href="%23s%23LinkToCRMRecord%23sEnd%23">#t#LBL_NOTICE_MODIFICATION#tEnd# #a#155#aEnd#: #a#169#aEnd#</a></h1>
<ul><li>#b#161#bEnd#: #a#161#aEnd#</li>
<li>#b#158#bEnd#: #a#158#aEnd#</li>
<li>#b#156#bEnd#: #a#156#aEnd#</li>
<li>#b#157#bEnd#: #a#157#aEnd#</li>
<li>#b#718#bEnd#: #a#718#aEnd#</li>
</ul><hr /> #b#170#bEnd#: #a#170#aEnd#
<hr /> #b#171#bEnd#: #a#171#aEnd#
<hr /><span><em>#t#LBL_NOTICE_FOOTER#tEnd#</em></span></div>', 'PLL_RECORD');
$records[] = array(36, 'Notify Account On Ticket Change', 'HelpDesk', '#t#LBL_NOTICE_MODIFICATION#tEnd# #a#155#aEnd#: #a#169#aEnd#', '<div>
<h3><span>#t#LBL_NOTICE_WELCOME#tEnd# <strong>YetiForce Sp. z o.o.</strong></span></h3>
#t#SINGLE_HelpDesk#tEnd# #a#155#aEnd# #t#LBL_NOTICE_UPDATED#tEnd# #a#168#aEnd#). #s#ChangesList#sEnd#
<hr /><h1><a href="%23s%23LinkToPortalRecord%23sEnd%23">#t#LBL_NOTICE_MODIFICATION#tEnd# #a#155#aEnd#: #a#169#aEnd#</a></h1>
<ul><li>#b#161#bEnd#: #a#161#aEnd#</li>
<li>#b#158#bEnd#: #a#158#aEnd#</li>
<li>#b#156#bEnd#: #a#156#aEnd#</li>
<li>#b#157#bEnd#: #a#157#aEnd#</li>
<li>#b#718#bEnd#: #a#718#aEnd#</li>
</ul><hr /> #b#170#bEnd#: #a#170#aEnd#
<hr /> #b#171#bEnd#: #a#171#aEnd#
<hr /><span><em>#t#LBL_NOTICE_FOOTER#tEnd#</em></span></div>', 'PLL_RECORD');
$records[] = array(37, 'Notify Contact On Ticket Closed', 'HelpDesk', '#t#LBL_NOTICE_CLOSE#tEnd# #a#155#aEnd#: #a#169#aEnd#', '<div>
<h3>#t#LBL_NOTICE_WELCOME#tEnd# <strong>YetiForce Sp. z o.o.</strong></h3>
#t#SINGLE_HelpDesk#tEnd# #a#155#aEnd# #t#LBL_NOTICE_CLOSED#tEnd# #a#168#aEnd#). #s#ChangesList#sEnd#
<hr /><h1><a href="%23s%23LinkToPortalRecord%23sEnd%23">#t#LBL_NOTICE_CLOSE#tEnd# #a#155#aEnd#: #a#169#aEnd#</a></h1>
<ul><li>#b#161#bEnd#: #a#161#aEnd#</li>
<li>#b#158#bEnd#: #a#158#aEnd#</li>
<li>#b#156#bEnd#: #a#156#aEnd#</li>
<li>#b#157#bEnd#: #a#157#aEnd#</li>
<li>#b#718#bEnd#: #a#718#aEnd#</li>
</ul><hr /> #b#170#bEnd#: #a#170#aEnd#
<hr /> #b#171#bEnd#: #a#171#aEnd#
<hr /><span><em>#t#LBL_NOTICE_FOOTER#tEnd#</em></span></div>', 'PLL_RECORD');
$records[] = array(38, 'Notify Account On Ticket Closed', 'HelpDesk', '#t#LBL_NOTICE_CLOSE#tEnd# #a#155#aEnd#: #a#169#aEnd#', '<div>
<h3>#t#LBL_NOTICE_WELCOME#tEnd# <strong>YetiForce Sp. z o.o.</strong></h3>
#t#SINGLE_HelpDesk#tEnd# #a#155#aEnd# #t#LBL_NOTICE_CLOSED#tEnd# #a#168#aEnd#). #s#ChangesList#sEnd#
<hr /><h1><a href="%23s%23LinkToPortalRecord%23sEnd%23">#t#LBL_NOTICE_CLOSE#tEnd# #a#155#aEnd#: #a#169#aEnd#</a></h1>
<ul><li>#b#161#bEnd#: #a#161#aEnd#</li>
<li>#b#158#bEnd#: #a#158#aEnd#</li>
<li>#b#156#bEnd#: #a#156#aEnd#</li>
<li>#b#157#bEnd#: #a#157#aEnd#</li>
<li>#b#718#bEnd#: #a#718#aEnd#</li>
</ul><hr /> #b#170#bEnd#: #a#170#aEnd#
<hr /> #b#171#bEnd#: #a#171#aEnd#
<hr /><span><em>#t#LBL_NOTICE_FOOTER#tEnd#</em></span></div>', 'PLL_RECORD');
$records[] = array(39, 'Notify Contact On Ticket Create', 'HelpDesk', '#t#LBL_NOTICE_CREATE#tEnd# #a#155#aEnd#: #a#169#aEnd#', '<div>
<h3>#t#LBL_NOTICE_WELCOME#tEnd# <strong>YetiForce Sp. z o.o.</strong></h3>
#t#SINGLE_HelpDesk#tEnd# #a#155#aEnd# #t#LBL_NOTICE_CREATED#tEnd# #a#168#aEnd#).
<hr /><h1><a href="%23s%23LinkToPortalRecord%23sEnd%23">#t#LBL_NOTICE_CREATE#tEnd# #a#155#aEnd#: #a#169#aEnd#</a></h1>
<ul><li>#b#161#bEnd#: #a#161#aEnd#</li>
<li>#b#158#bEnd#: #a#158#aEnd#</li>
<li>#b#156#bEnd#: #a#156#aEnd#</li>
<li>#b#157#bEnd#: #a#157#aEnd#</li>
<li>#b#718#bEnd#: #a#718#aEnd#</li>
</ul><hr /> #b#170#bEnd#: #a#170#aEnd#
<hr /><span><em>#t#LBL_NOTICE_FOOTER#tEnd#</em></span></div>', 'PLL_RECORD');
$records[] = array(40, 'Notify Account On Ticket Create', 'HelpDesk', '#t#LBL_NOTICE_CREATE#tEnd# #a#155#aEnd#: #a#169#aEnd#', '<div>
<h3>#t#LBL_NOTICE_WELCOME#tEnd# <strong>YetiForce Sp. z o.o.</strong></h3>
#t#SINGLE_HelpDesk#tEnd# #a#155#aEnd# #t#LBL_NOTICE_CREATED#tEnd# #a#168#aEnd#).
<hr /><h1><a href="%23s%23LinkToPortalRecord%23sEnd%23">#t#LBL_NOTICE_CREATE#tEnd# #a#155#aEnd#: #a#169#aEnd#</a></h1>
<ul><li>#b#161#bEnd#: #a#161#aEnd#</li>
<li>#b#158#bEnd#: #a#158#aEnd#</li>
<li>#b#156#bEnd#: #a#156#aEnd#</li>
<li>#b#157#bEnd#: #a#157#aEnd#</li>
<li>#b#718#bEnd#: #a#718#aEnd#</li>
</ul><hr /> #b#170#bEnd#: #a#170#aEnd#
<hr /><span><em>#t#LBL_NOTICE_FOOTER#tEnd#</em></span></div>', 'PLL_RECORD');
$records[] = array(41, 'Notify Contact On Ticket Change', 'HelpDesk', '#t#LBL_NOTICE_MODIFICATION#tEnd# #a#155#aEnd#: #a#169#aEnd#', '<div>
<h3><span>#t#LBL_NOTICE_WELCOME#tEnd# <strong>YetiForce Sp. z o.o.</strong></span></h3>
#t#SINGLE_HelpDesk#tEnd# #a#155#aEnd# #t#LBL_NOTICE_UPDATED#tEnd# #a#168#aEnd#). #s#ChangesList#sEnd#
<hr /><h1><a href="%23s%23LinkToPortalRecord%23sEnd%23">#t#LBL_NOTICE_MODIFICATION#tEnd# #a#155#aEnd#: #a#169#aEnd#</a></h1>
<ul><li>#b#161#bEnd#: #a#161#aEnd#</li>
<li>#b#158#bEnd#: #a#158#aEnd#</li>
<li>#b#156#bEnd#: #a#156#aEnd#</li>
<li>#b#157#bEnd#: #a#157#aEnd#</li>
<li>#b#718#bEnd#: #a#718#aEnd#</li>
</ul><hr /> #b#170#bEnd#: #a#170#aEnd#
<hr /> #b#171#bEnd#: #a#171#aEnd#
<hr /><span><em>#t#LBL_NOTICE_FOOTER#tEnd#</em></span></div>', 'PLL_RECORD');
$records[] = array(42, 'Notify Owner On Ticket Closed', 'HelpDesk', '#t#LBL_NOTICE_CLOSE#tEnd# #a#155#aEnd#: #a#169#aEnd#', '<div>
<h3><span>#t#LBL_NOTICE_WELCOME#tEnd# <strong>YetiForce Sp. z o.o.</strong></span></h3>
#t#SINGLE_HelpDesk#tEnd# #a#155#aEnd# #t#LBL_NOTICE_CLOSED#tEnd# #a#168#aEnd#). #s#ChangesList#sEnd#
<hr /><h1><a href="%23s%23LinkToCRMRecord%23sEnd%23">#t#LBL_NOTICE_CLOSE#tEnd# #a#155#aEnd#: #a#169#aEnd#</a></h1>
<ul><li>#b#161#bEnd#: #a#161#aEnd#</li>
<li>#b#158#bEnd#: #a#158#aEnd#</li>
<li>#b#156#bEnd#: #a#156#aEnd#</li>
<li>#b#157#bEnd#: #a#157#aEnd#</li>
<li>#b#718#bEnd#: #a#718#aEnd#</li>
</ul><hr /> #b#170#bEnd#: #a#170#aEnd#
<hr /> #b#171#bEnd#: #a#171#aEnd#
<hr /><span><em>#t#LBL_NOTICE_FOOTER#tEnd#</em></span></div>', 'PLL_RECORD');
$records[] = array(43, 'Notify Owner On Ticket Create', 'HelpDesk', '#t#LBL_NOTICE_CREATE#tEnd# #a#155#aEnd#: #a#169#aEnd#', '<div>
<h3>#t#LBL_NOTICE_WELCOME#tEnd# <strong>YetiForce Sp. z o.o.</strong></h3>
#t#SINGLE_HelpDesk#tEnd# #a#155#aEnd# #t#LBL_NOTICE_CREATED#tEnd# #a#168#aEnd#).
<hr /><h1><a href="%23s%23LinkToCRMRecord%23sEnd%23">#t#LBL_NOTICE_CREATE#tEnd# #a#155#aEnd#: #a#169#aEnd#</a></h1>
<ul><li>#b#161#bEnd#: #a#161#aEnd#</li>
<li>#b#158#bEnd#: #a#158#aEnd#</li>
<li>#b#156#bEnd#: #a#156#aEnd#</li>
<li>#b#157#bEnd#: #a#157#aEnd#</li>
<li>#b#718#bEnd#: #a#718#aEnd#</li>
</ul><hr /> #b#170#bEnd#: #a#170#aEnd#
<hr /><span><em>#t#LBL_NOTICE_FOOTER#tEnd#</em></span></div>', 'PLL_RECORD');
$records[] = array(44, 'Customer Portal Login Details', 'Contacts', 'Customer Portal Login Details', '<p>#s#LogoImage#sEnd# </p><p>Dear #a#67#aEnd# #a#70#aEnd#</p><p>Created for your account in the customer portal, below sending data access.</p><p>Login: #a#80#aEnd#<br />Password: #s#ContactsPortalPass#sEnd#</p><p>Regards</p>', 'PLL_RECORD');
$records[] = array(45, 'Send invitations', 'Events', '#a#267#aEnd#: #a#255#aEnd#', '<table border="0" cellpadding="8" cellspacing="0" style="width:100%;font-family:Arial, \'Sans-serif\';border:1px solid #ccc;border-width:1px 2px 2px 1px;background-color:#fff;" summary=""><tbody><tr><td style="background-color:#f6f6f6;color:#888;border-bottom:1px solid #ccc;font-family:Arial, \'Sans-serif\';font-size:11px;">
<h3 style="padding:0 0 6px 0;margin:0;font-family:Arial, \'Sans-serif\';font-size:16px;font-weight:bold;color:#222;"><span>#a#255#aEnd#</span></h3>
</td>
</tr><tr><td>
<div style="padding:2px;">
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="padding:0 1em 10px 0;font-family:Arial,\'Sans-serif\';font-size:13px;color:#888;white-space:nowrap;" valign="top">
<div><i style="font-style:normal;">#b#257#bEnd#</i></div>
</td>
<td style="padding-bottom:10px;font-family:Arial, \'Sans-serif\';font-size:13px;color:#222;" valign="top">#a#257#aEnd# #a#258#aEnd#</td>
</tr><tr><td style="padding:0 1em 10px 0;font-family:Arial, \'Sans-serif\';font-size:13px;color:#888;white-space:nowrap;" valign="top">
<div><i style="font-style:normal;">#b#259#bEnd#</i></div>
</td>
<td style="padding-bottom:10px;font-family:Arial, \'Sans-serif\';font-size:13px;color:#222;" valign="top">#a#259#aEnd# #a#260#aEnd#</td>
</tr><tr><td style="padding:0 1em 10px 0;font-family:Arial, \'Sans-serif\';font-size:13px;color:#888;white-space:nowrap;" valign="top">
<div><i style="font-style:normal;">#b#264#bEnd#</i></div>
</td>
<td style="padding-bottom:10px;font-family:Arial, \'Sans-serif\';font-size:13px;color:#222;" valign="top">#a#264#aEnd#</td>
</tr><tr><td style="padding:0 1em 10px 0;font-family:Arial, \'Sans-serif\';font-size:13px;color:#888;white-space:nowrap;" valign="top">
<div><i style="font-style:normal;">#b#277#bEnd#</i></div>
</td>
<td style="padding-bottom:10px;font-family:Arial, \'Sans-serif\';font-size:13px;color:#222;" valign="top">#a#277#aEnd#</td>
</tr><tr><td style="padding:0 1em 10px 0;font-family:Arial, \'Sans-serif\';font-size:13px;color:#888;white-space:nowrap;" valign="top">
<div><i style="font-style:normal;">#b#267#bEnd#</i></div>
</td>
<td style="padding-bottom:10px;font-family:Arial, \'Sans-serif\';font-size:13px;color:#222;" valign="top">#a#267#aEnd#</td>
</tr><tr><td style="padding:0 1em 10px 0;font-family:Arial, \'Sans-serif\';font-size:13px;color:#888;white-space:nowrap;" valign="top">
<div><i style="font-style:normal;">#b#271#bEnd#</i></div>
</td>
<td style="padding-bottom:10px;font-family:Arial, \'Sans-serif\';font-size:13px;color:#222;" valign="top">#a#271#aEnd#</td>
</tr><tr><td style="padding:0 1em 10px 0;font-family:Arial, \'Sans-serif\';font-size:13px;color:#888;white-space:nowrap;" valign="top">
<div><i style="font-style:normal;">#b#268#bEnd#</i></div>
</td>
<td style="padding-bottom:10px;font-family:Arial, \'Sans-serif\';font-size:13px;color:#222;" valign="top"><span><span>#a#268#aEnd#</span><span dir="ltr"> (<a href="https://maps.google.pl/maps?q=%23a%23268%23aEnd%23" style="color:#20c;white-space:nowrap;">mapa</a>)</span></span></td>
</tr><tr><td style="padding:0 1em 10px 0;font-family:Arial, \'Sans-serif\';font-size:13px;color:#888;white-space:nowrap;" valign="top">
<div><i style="font-style:normal;">#b#265#bEnd#</i></div>
</td>
<td style="padding-bottom:10px;font-family:Arial, \'Sans-serif\';font-size:13px;color:#222;" valign="top">#a#265#aEnd#</td>
</tr><tr><td style="padding:0 1em 10px 0;font-family:Arial, \'Sans-serif\';font-size:13px;color:#888;white-space:nowrap;" valign="top">
<div><i style="font-style:normal;">#b#275#bEnd#</i></div>
</td>
<td style="padding-bottom:10px;font-family:Arial, \'Sans-serif\';font-size:13px;color:#222;" valign="top">#a#275#aEnd#</td>
</tr><tr><td style="padding:0 1em 10px 0;font-family:Arial, \'Sans-serif\';font-size:13px;color:#888;white-space:nowrap;" valign="top">
<div><i style="font-style:normal;">#b#256#bEnd#</i></div>
</td>
<td style="padding-bottom:10px;font-family:Arial, \'Sans-serif\';font-size:13px;color:#222;" valign="top">#a#256#aEnd#</td>
</tr></tbody></table></div>
</td>
</tr><tr><td style="background-color:#f6f6f6;color:#888;border-top:1px solid #ccc;font-family:Arial, \'Sans-serif\';font-size:11px;">
<p>YetiForce CRM - Notification activities on the calendar</p>
</td>
</tr></tbody></table>', 'PLL_RECORD');
$records[] = array(46, 'Send Notification Email to Record Owner', 'Calendar', 'Task : #a#231#aEnd#', '#a#232#aEnd#<br /><br />Activity Notification Details:<br />Subject : #a#231#aEnd#<br />Start date and time : #a#233#aEnd# #a#234#aEnd#<br />End date and time : #a#235#aEnd# #a#236#aEnd#<br />Status : #a#239#aEnd#<br />Priority : #a#241#aEnd#<br />Related To : #a#237#aEnd#<br />Contacts List : #a#238#aEnd#<br />Location : #a#250#aEnd#<br />Description : #a#247#aEnd#', 'PLL_RECORD');
$records[] = array(93, 'Activity Reminder Notification', 'Calendar', 'Reminder: #a#231#aEnd#', 'This is a reminder notification for the Activity:<br />Subject: #a#231#aEnd#<br />Date & Time: #a#233#aEnd# #a#234#aEnd#<br /><span style=\\"color:rgb(43,43,43);font-family:\'Helvetica Neue\', Helvetica, Arial, sans-serif;line-height:20.7999992370605px;\\">Contact Name: </span>#a#238#aEnd#<br style=\\"color:rgb(43,43,43);font-family:\'Helvetica Neue\', Helvetica, Arial, sans-serif;line-height:20.7999992370605px;\\" /><span style=\\"color:rgb(43,43,43);font-family:\'Helvetica Neue\', Helvetica, Arial, sans-serif;line-height:20.7999992370605px;\\">Related To: </span>#a#237#aEnd#<br style=\\"color:rgb(43,43,43);font-family:\'Helvetica Neue\', Helvetica, Arial, sans-serif;line-height:20.7999992370605px;\\" /><span style=\\"color:rgb(43,43,43);font-family:\'Helvetica Neue\', Helvetica, Arial, sans-serif;line-height:20.7999992370605px;\\">Description: </span>#a#247#aEnd#', 'PLL_RECORD');
$records[] = array(94, 'Activity Reminder Notification', 'Events', 'Reminder: #a#255#aEnd#', '<span style=\\"line-height:20.7999992370605px;\\">This is a reminder notification for the Activity:</span><br style=\\"line-height:20.7999992370605px;\\" /><span style=\\"line-height:20.7999992370605px;\\">Subject:</span>#a#255#aEnd#<br style=\\"line-height:20.7999992370605px;\\" /><span style=\\"line-height:20.7999992370605px;\\">Date & Time: </span>#a#257#aEnd# #a#258#aEnd#<br style=\\"line-height:20.7999992370605px;\\" /><span style=\\"line-height:20.7999992370605px;color:rgb(43,43,43);font-family:\'Helvetica Neue\', Helvetica, Arial, sans-serif;\\">Contact Name: </span>#a#277#aEnd#<br style=\\"line-height:20.7999992370605px;color:rgb(43,43,43);font-family:\'Helvetica Neue\', Helvetica, Arial, sans-serif;\\" /><span style=\\"line-height:20.7999992370605px;color:rgb(43,43,43);font-family:\'Helvetica Neue\', Helvetica, Arial, sans-serif;\\">Related To: </span>#a#264#aEnd#<br style=\\"line-height:20.7999992370605px;color:rgb(43,43,43);font-family:\'Helvetica Neue\', Helvetica, Arial, sans-serif;\\" /><span style=\\"line-height:20.7999992370605px;color:rgb(43,43,43);font-family:\'Helvetica Neue\', Helvetica, Arial, sans-serif;\\">Description: </span>#a#275#aEnd#', 'PLL_RECORD');
$records[] = array(95, 'Test mail about the mail server configuration.', 'Users', 'Test mail about the mail server configuration.', '<span style=\\"color:rgb(0,0,0);font-family:arial, sans-serif;line-height:normal;\\">Dear </span>#a#478#aEnd# #a#479#aEnd#<span style=\\"color:rgb(0,0,0);font-family:arial, sans-serif;line-height:normal;\\">, </span><br style=\\"color:rgb(0,0,0);font-family:arial, sans-serif;line-height:normal;\\" /><br style=\\"color:rgb(0,0,0);font-family:arial, sans-serif;line-height:normal;\\" /><b style=\\"color:rgb(0,0,0);font-family:arial, sans-serif;line-height:normal;\\">This is a test mail sent to confirm if a mail is actually being sent through the smtp server that you have configured. </b><br style=\\"color:rgb(0,0,0);font-family:arial, sans-serif;line-height:normal;\\" /><span style=\\"color:rgb(0,0,0);font-family:arial, sans-serif;line-height:normal;\\">Feel free to delete this mail. </span><br style=\\"color:rgb(0,0,0);font-family:arial, sans-serif;line-height:normal;\\" /><br style=\\"color:rgb(0,0,0);font-family:arial, sans-serif;line-height:normal;\\" /><span style=\\"color:rgb(0,0,0);font-family:arial, sans-serif;line-height:normal;\\">Thanks and Regards,</span><br style=\\"color:rgb(0,0,0);font-family:arial, sans-serif;line-height:normal;\\" /><span style=\\"color:rgb(0,0,0);font-family:arial, sans-serif;line-height:normal;\\">Team YetiForce</span>', 'PLL_RECORD');
$records[] = array(103, 'ForgotPassword', 'Users', 'Request: ForgotPassword', 'Dear user,<br /><br />\\r\\nYou recently requested a password reset for your YetiForce CRM.<br />\\r\\nTo create a new password, click on the link #s#LinkToForgotPassword#sEnd#.<br /><br />\\r\\nThis request was made on #s#CurrentDateTime#sEnd# and will expire in next 24 hours.<br /><br />\\r\\nRegards,<br />\\r\\nYetiForce CRM Support Team.', 'PLL_RECORD');
$records[] = array(104, 'Customer Portal - ForgotPassword', 'Contacts', 'Request: ForgotPassword', 'Dear #a#67#aEnd# #a#70#aEnd#,<br /><br />
You recently requested a reminder of your access data for the YetiForce Portal.<br /><br />
You can login by entering the following data:<br /><br />
Your username: #a#80#aEnd#<br />
Your password: #s#ContactsPortalPass#sEnd#<br /><br /><br />
Regards,<br />
YetiForce CRM Support Team.', 'PLL_RECORD');
$records[] = array(105, 'New comment added to ticket from portal', 'ModComments', 'New comment added to ticket from portal', 'Dear User,<br />
A new comment has been added to the ticket.<br />
#b#597#bEnd# #a#597#aEnd#<br /><br />
', 'PLL_RECORD');
$records[] = array(106, 'New comment added to ticket', 'ModComments', 'New comment added to ticket', '<span class="value">Dear User,<br />
A new comment has been added to the ticket.<br />
#b#597#bEnd# #a#597#aEnd#</span>', 'PLL_RECORD');
$records[] = array(107, 'Security risk has been detected - Brute Force', 'Contacts', 'Security risk has been detected', '<span class="value">Dear user,<br />
Failed login attempts have been detected. </span>', 'PLL_MODULE');
$records[] = array(108, 'Backup has been made', 'Contacts', 'Backup has been made notification', 'Dear User,<br />
Backup has been made.', 'PLL_MODULE');
foreach ($records as $record) {
try {
$instance = new $moduleName();
$instance->column_fields['assigned_user_id'] = $assigned_user_id;
$instance->column_fields['name'] = $record[1];
$instance->column_fields['oss_module_list'] = $record[2];
$instance->column_fields['subject'] = $record[3];
$instance->column_fields['content'] = $record[4];
$instance->column_fields['ossmailtemplates_type'] = $record[5];
$save = $instance->save($moduleName);
if ($record[1] == 'Test mail about the mail server configuration.') {
self::changeOutgoingServerFile($instance->id);
}
if ($record[1] == 'ForgotPassword') {
self::updateForgotPassword($instance->id);
}
} catch (Exception $e) {
Install_InitSchema_Model::addMigrationLog('addRecords ' . $e->getMessage(), 'error');
}
}
//vtiger_osspdf
$moduleName = 'OSSPdf';
vimport('~~modules/' . $moduleName . '/' . $moduleName . '.php');
$records = array();
$records[] = array('Quotes PDF', '20', 'A4', 'Portrait', '<title></title>
<title></title>
<table align="left" border="0" cellpadding="1" cellspacing="1" style="width: 100%;">
<tbody>
<tr>
<td><span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>#company_organizationname#</strong><br />
#company_address#<br />
#company_code# #company_city#<br />
#company_country#<br />
tel.: #company_phone#<br />
fax: #company_fax#<br />
WWW: <a href="#company_website#"> #company_website#</a><br />
VAT: #company_vatid#</span></span></td>
<td> </td>
<td>
<div style="text-align: right;"><span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#company_city#, #special_function#CurrentDate#end_special_function#</span></span></div>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#Contacts_firstname# #Contacts_lastname#<br />
tel: #Contacts_phone#<br />
email: #Contacts_email#<br />
<br />
<strong>#Accounts_accountname#</strong><br />
#addresslevel8a# #buildingnumbera# #localnumbera#<br />
#addresslevel7a# #addresslevel5a#<br />
#Accounts_label_vat_id#: #Accounts_vat_id#</span></span></td>
</tr>
</tbody>
</table>
<p style="text-align: center;"><br />
<span style="font-size:14px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>Offer #quote_no#</strong></span></span></p>
<span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#description#</span></span><br />
<span>#special_function#replaceProductTable#end_special_function#</span><br />
<br />
<span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>#label_attention#: </strong>#attention#<br />
<strong>#label_currency_id#: </strong>#currency_id#<br />
<strong>#label_validtill#: </strong>#validtill#<br />
<strong>#label_shipping#: </strong>#shipping#<br />
<strong>#label_form_payment#: </strong>#form_payment#<br />
<strong>#label_terms_conditions#:</strong>#terms_conditions#</span></span><br />
<br />
<span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#Users_first_name# #Users_last_name#<br />
email: <a href="mailto:#Users_email1#">#Users_email1#</a><br />
<br />
<strong>#company_organizationname#</strong><br />
tel.: #company_phone#<br />
fax: #company_fax#<br />
WWW: <a href="#company_website#"> #company_website#</a></span></span>', '', '', '10', '10', '10', '10', 'No', 'No', '', '', 'No', '1', '1', '1', 'Lista |##| Podgląd');
$records[] = array('Sales Order PDF', '22', 'A4', 'Portrait', '<title></title>
<title></title>
<table align="left" border="0" cellpadding="1" cellspacing="1" style="width: 100%;">
<tbody>
<tr>
<td><span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>#company_organizationname#</strong><br />
#company_address#<br />
#company_code# #company_city#<br />
#company_country#<br />
tel.: #company_phone#<br />
fax: #company_fax#<br />
WWW: <a href="#company_website#"> #company_website#</a><br />
VAT: #company_vatid#</span></span></td>
<td> </td>
<td>
<div style="text-align: right;"><span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#company_city#, #special_function#CurrentDate#end_special_function#
</span></span></div>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#Contacts_firstname# #Contacts_lastname#<br />
tel: #Contacts_phone#<br />
email: #Contacts_email#<br />
<br />
<strong>#Accounts_accountname#</strong><br />
#addresslevel8a# #buildingnumbera# #localnumbera#<br />
#addresslevel7a# #addresslevel5a#<br />
#Accounts_label_vat_id#: #Accounts_vat_id#</span></span></td>
</tr>
</tbody>
</table>
<p style="text-align: center;"><br />
<span style="font-size:14px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>Sales Order #salesorder_no#</strong></span></span></p>
<span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#description#</span></span><br />
<span>#special_function#replaceProductTable#end_special_function#</span><br />
<br />
<span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>#label_attention#: </strong>#attention#<br />
<strong>#label_currency_id#: </strong>#currency_id#<br />
<strong>#label_duedate#: </strong>#duedate#<br />
<strong>#label_form_payment#: </strong>#form_payment#<br />
<strong>#Quotes_label_quote_no#: </strong>#Quotes_quote_no#<br />
<strong>#label_terms_conditions#:</strong>#terms_conditions#</span></span><br />
<br />
<span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#Users_first_name# #Users_last_name#<br />
email: <a href="mailto:#Users_email1#">#Users_email1#</a><br />
<br />
<strong>#company_organizationname#</strong><br />
tel.: #company_phone#<br />
fax: #company_fax#<br />
WWW: <a href="#company_website#"> #company_website#</a></span></span>', '', '', '10', '10', '10', '10', 'No', 'No', '', '', 'No', '1', '1', '1', 'Lista |##| Podgląd');
$records[] = array('Invoice PDF', '23', 'A4', 'Portrait', '<title></title>
<title></title>
<table align="left" border="0" cellpadding="1" cellspacing="1" style="width: 100%;">
<tbody>
<tr>
<td><span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>#company_organizationname#</strong><br />
#company_address#<br />
#company_code# #company_city#<br />
#company_country#<br />
tel.: #company_phone#<br />
fax: #company_fax#<br />
WWW: <a href="#company_website#"> #company_website#</a><br />
VAT: #company_vatid#</span></span></td>
<td> </td>
<td>
<div style="text-align: right;"><span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#label_invoicedate#: #invoicedate#
</span></span></div>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#Contacts_firstname# #Contacts_lastname#<br />
tel: #Contacts_phone#<br />
email: #Contacts_email#<br />
<br />
<strong>#Accounts_accountname#</strong><br />
#addresslevel8a# #buildingnumbera# #localnumbera#<br />
#addresslevel7a# #addresslevel5a#<br />
#Accounts_label_vat_id#: #Accounts_vat_id#</span></span></td>
</tr>
</tbody>
</table>
<p style="text-align: center;"><br />
<span style="font-size:14px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>Invoice #invoice_no#</strong></span></span></p>
<span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#description#</span></span><br />
<span>#special_function#replaceProductTable#end_special_function#</span><br />
<br />
<span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>#label_attention#: </strong>#attention#<br />
<strong>#label_currency_id#: </strong>#currency_id#<br />
<strong>#label_invoicedate#: </strong>#invoicedate#<br />
<strong>#label_duedate#: </strong>#duedate#<br />
<strong>#label_form_payment#: </strong>#form_payment#<br />
<strong>Sales Order: </strong>#SalesOrder_salesorder_no#<br />
<strong>#label_terms_conditions#:</strong>#terms_conditions#</span></span><br />
<br />
<span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#Users_first_name# #Users_last_name#<br />
email: <a href="mailto:#Users_email1#">#Users_email1#</a><br />
<br />
<strong>#company_organizationname#</strong><br />
tel.: #company_phone#<br />
fax: #company_fax#<br />
WWW: <a href="#company_website#"> #company_website#</a></span></span>', '', '', '10', '10', '10', '10', 'No', 'No', '', '', 'No', '1', '1', '1', 'Lista |##| Podgląd');
$records[] = array('Purchase Order PDF', '21', 'A4', 'Portrait', '<title></title>
<title></title>
<table align="left" border="0" cellpadding="1" cellspacing="1" style="width: 100%;">
<tbody>
<tr>
<td><span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>#company_organizationname#</strong><br />
#company_address#<br />
#company_code# #company_city#<br />
#company_country#<br />
tel.: #company_phone#<br />
fax: #company_fax#<br />
WWW: <a href="#company_website#"> #company_website#</a><br />
VAT: #company_vatid#</span></span></td>
<td> </td>
<td>
<div style="text-align: right;"><span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#company_city#, #special_function#CurrentDate#end_special_function# </span></span></div>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#Contacts_firstname# #Contacts_lastname#<br />
tel: #Contacts_phone#<br />
email: #Contacts_email#<br />
<br />
<strong>#Vendors_vendorname#</strong><br />
#addresslevel8a# #buildingnumbera# #localnumbera#<br />
#addresslevel7a# #addresslevel5a#<br />
#Vendors_label_vat_id#: #Vendors_vat_id#</span></span></td>
</tr>
</tbody>
</table>
<p style="text-align: center;"><br />
<span style="font-size:14px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>Order confirmation #purchaseorder_no#</strong></span></span></p>
<span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">Thank you for your order. Herewith we are pleased to confirm it as follows.<br />
#description#</span></span><br />
<span>#special_function#replaceProductTable#end_special_function#</span><br />
<br />
<span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;"><strong>#label_attention#: </strong>#attention#<br />
<strong>#label_currency_id#: </strong>#currency_id#<br />
<strong>#label_duedate#: </strong>#duedate#<br />
<strong>#label_terms_conditions#:</strong>#terms_conditions#</span></span><br />
<br />
<span style="font-size:9px;"><span style="font-family: tahoma,geneva,sans-serif;">#Users_first_name# #Users_last_name#<br />
email: <a href="mailto:#Users_email1#">#Users_email1#</a><br />
<br />
<strong>#company_organizationname#</strong><br />
tel.: #company_phone#<br />
fax: #company_fax#<br />
WWW: <a href="#company_website#"> #company_website#</a></span></span>', '', '', '10', '10', '10', '10', 'No', 'No', '', '', 'No', '1', '1', '1', 'Lista |##| Podgląd');
$records[] = array('Calculation PDF', '70', 'A4', 'Portrait', '', '', '', '10', '10', '10', '10', 'No', 'No', '', '<title></title>
<table width="537px">
<tbody>
<tr>
<td colspan="6" rowspan="2"><img src="#special_function#siteUrl#end_special_function#storage/Logo/logo_yetiforce.png" style="width: 200px;" width="200" /></td>
<td colspan="4"><span style="font-size:6px;">#company_organizationname# #company_address# #company_code# #company_city#. VAT:#company_vatid#</span></td>
</tr>
<tr>
<td colspan="5">
<table border="1">
<tbody>
<tr>
<td>
<table cellpadding="1">
<tbody>
<tr>
<td style="text-align: center;"><span style="font-size:9px;">Calculation confirmation: <strong>#calculations_no#</strong></span></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td>
<table cellpadding="1">
<tbody>
<tr>
<td style="text-align: center;"><span style="font-size:9px;">Date: #special_function#CreatedDateTime#end_special_function#</span></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td colspan="7"> </td>
<td colspan="5" rowspan="2">
<table border="1">
<tbody>
<tr>
<td>
<table cellpadding="5">
<tbody>
<tr>
<td>
<table cellpadding="0" style="font-size:8px;">
<tbody>
<tr>
<td colspan="2">Issued by:</td>
<td colspan="3">#Users_first_name# #Users_last_name#</td>
</tr>
<tr>
<td colspan="2">Email:</td>
<td colspan="3">#Users_email1#</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td colspan="3">
<table>
<tbody>
<tr>
<td><span style="font-size:10px;"> <span style="font-size:8px;">#Accounts_account_no#</span></span></td>
</tr>
<tr>
<td>
<table>
<tbody>
<tr>
<td>
<p><span style="font-size:10px;">#Accounts_accountname#<br />
<span style="font-size:8px;">#Accounts_addresslevel8b# #Accounts_buildingnumberb# #Accounts_localnumberb#<br />
#Accounts_addresslevel7b#, #Accounts_addresslevel5b#<br />
<span style="font-size:10px;">#Accounts_addresslevel1b#</span><br />
#Accounts_vat_id#<br />
#Contacts_email#</span></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
<td colspan="3"> </td>
</tr>
</tbody>
</table>
<table>
<tbody>
<tr>
<td> </td>
</tr>
<tr>
<td>#special_function#replaceProductTable#end_special_function#</td>
</tr>
</tbody>
</table>', 'No', '1', '1', '0', 'Lista |##| Podgląd');
foreach ($records as $record) {
try {
$instance = new $moduleName();
$instance->column_fields['assigned_user_id'] = $assigned_user_id;
$instance->column_fields['title'] = $record[0];
$instance->column_fields['moduleid'] = $record[1];
$instance->column_fields['osspdf_pdf_format'] = $record[2];
$instance->column_fields['osspdf_pdf_orientation'] = $record[3];
$instance->column_fields['content'] = $record[4];
$instance->column_fields['constraints'] = $record[5];
$instance->column_fields['filename'] = $record[6];
$instance->column_fields['left_margin'] = $record[7];
$instance->column_fields['right_margin'] = $record[8];
$instance->column_fields['top_margin'] = $record[9];
$instance->column_fields['bottom_margin'] = $record[10];
$instance->column_fields['osspdf_enable_footer'] = $record[11];
$instance->column_fields['osspdf_enable_header'] = $record[12];
$instance->column_fields['header_content'] = $record[13];
$instance->column_fields['footer_content'] = $record[14];
$instance->column_fields['osspdf_enable_numbering'] = $record[15];
$instance->column_fields['height_header'] = $record[16];
$instance->column_fields['height_footer'] = $record[17];
$instance->column_fields['selected'] = $record[18];
$instance->column_fields['osspdf_view'] = $record[19];
$saved = $instance->save($moduleName);
} catch (Exception $e) {
Install_InitSchema_Model::addMigrationLog('addRecords ' . $e->getMessage(), 'error');
}
}
// vtiger_picklist_dependency
$sql = "SELECT * FROM `vtiger_picklist_dependency_seq`;";
$result = $adb->query($sql);
$num = $adb->num_rows($result);
if (!$num) {
$adb->pquery('insert into `vtiger_picklist_dependency_seq`(`id`) values (?);', array(0));
}
$moduleName = 'Leads';
$dependencyMap['sourcefield'] = 'industry';
$dependencyMap['targetfield'] = 'subindustry';
$targetvalues = '["Ministry","Chancellery","Voivodeship Office","Marshal Office","Poviat","City\\/Township\\/District","Social Welfare Centre","Water and Sewerage Company","Voivodeship Job Centre","Poviat Job Centre","Court of justice","Attorney General\'s Office","Other"]';
$targetvalues = Zend_Json::decode($targetvalues);
$dependencyMap['valuemapping'][] = array('sourcevalue' => 'Administration', 'targetvalues' => $targetvalues);
$targetvalues = '["Other","Deweloperzy","Real Estate"]';
$targetvalues = Zend_Json::decode($targetvalues);
$dependencyMap['valuemapping'][] = array('sourcevalue' => 'Construction Industry', 'targetvalues' => $targetvalues);
$targetvalues = '["Other","Primary Schools","High Schools"]';
$targetvalues = Zend_Json::decode($targetvalues);
$dependencyMap['valuemapping'][] = array('sourcevalue' => 'Education', 'targetvalues' => $targetvalues);
$targetvalues = '[""]';
$targetvalues = Zend_Json::decode($targetvalues);
$dependencyMap['valuemapping'][] = array('sourcevalue' => 'Power Industry', 'targetvalues' => $targetvalues);
$targetvalues = '["Other","Banking","Capital Market","Financial Services","Investments","Insurance"]';
$targetvalues = Zend_Json::decode($targetvalues);
$dependencyMap['valuemapping'][] = array('sourcevalue' => 'Finance', 'targetvalues' => $targetvalues);
$targetvalues = '["Other","Retail","Wholesale","Resale"]';
$targetvalues = Zend_Json::decode($targetvalues);
$dependencyMap['valuemapping'][] = array('sourcevalue' => 'Trade', 'targetvalues' => $targetvalues);
$targetvalues = '[""]';
$targetvalues = Zend_Json::decode($targetvalues);
$dependencyMap['valuemapping'][] = array('sourcevalue' => 'Hotels and Restaurants', 'targetvalues' => $targetvalues);
$targetvalues = '[""]';
$targetvalues = Zend_Json::decode($targetvalues);
$dependencyMap['valuemapping'][] = array('sourcevalue' => 'Health Care', 'targetvalues' => $targetvalues);
$targetvalues = '["Other","Automotive","Plastics","Chamical","Raw material","Fuel","Wood and paper","Electromechanical","Pharmaceutical","Building Materials","Metal","Light","Food industry","Recycling"]';
$targetvalues = Zend_Json::decode($targetvalues);
$dependencyMap['valuemapping'][] = array('sourcevalue' => 'Industry / Manufacturing', 'targetvalues' => $targetvalues);
$targetvalues = '["Army","Police"]';
$targetvalues = Zend_Json::decode($targetvalues);
$dependencyMap['valuemapping'][] = array('sourcevalue' => 'Uniformed Services', 'targetvalues' => $targetvalues);
$targetvalues = '[""]';
$targetvalues = Zend_Json::decode($targetvalues);
$dependencyMap['valuemapping'][] = array('sourcevalue' => 'Transport & Logistics', 'targetvalues' => $targetvalues);
$targetvalues = '["Other","Information Technology","Telecommunication","Media"]';
$targetvalues = Zend_Json::decode($targetvalues);
$dependencyMap['valuemapping'][] = array('sourcevalue' => 'Technologies', 'targetvalues' => $targetvalues);
Vtiger_DependencyPicklist::savePickListDependencies($moduleName, $dependencyMap);
//info on migration
$adb->pquery("INSERT INTO yetiforce_updates (`time`, `user`, `name`, `from_version`, `to_version`, `result`) VALUES (?, ?, ?, ?, ?, ?)", array(date('Y-m-d H:i:s'), $this->adminId, 'migration', $this->name, 'Yetiforce CRM 1.0.0', 1));
$log->debug("Exiting VT620_to_YT::addRecords() method ...");
}
