/** * 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 ..."); }