ac7467f0b4
- Added comprehensive AI Assistant system (aiassist/ directory): * Vector search and embedding capabilities * Typebot proxy integration * Elastic search functionality * Message classification and chat history * MCP proxy for external integrations - Implemented Court Status API (GetCourtStatus.php): * Real-time court document status checking * Integration with external court systems * Comprehensive error handling and logging - Enhanced S3 integration: * Improved file backup system with metadata * Batch processing capabilities * Enhanced error logging and recovery * Copy operations with URL fixing - Added Telegram contact creation API - Improved error logging across all modules - Enhanced callback system for AI responses - Extensive backup file storage with timestamps - Updated documentation and README files - File storage improvements: * Thousands of backup files with proper metadata * Fix operations for broken file references * Project-specific backup and recovery systems * Comprehensive file integrity checking Total: 26,461+ files added/modified including AWS SDK, vendor dependencies, and extensive backup system.
602 lines
23 KiB
PHP
602 lines
23 KiB
PHP
<?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.
|
|
* *********************************************************************************** */
|
|
|
|
class Install_Utils_Model {
|
|
|
|
/**
|
|
* variable has all the files and folder that should be writable
|
|
* @var <Array>
|
|
*/
|
|
public static $writableFilesAndFolders = array (
|
|
'Configuration File' => './config.inc.php',
|
|
'Tabdata File' => './tabdata.php',
|
|
'Parent Tabdata File' => './parent_tabdata.php',
|
|
'Cache Directory' => './cache/',
|
|
'Image Cache Directory' => './cache/images/',
|
|
'Import Cache Directory' => './cache/import/',
|
|
'Storage Directory' => './storage/',
|
|
'User Privileges Directory' => './user_privileges/',
|
|
'Modules Directory' => './modules/',
|
|
'Cron Modules Directory' => './cron/modules/',
|
|
'Vtlib Test Directory' => './test/vtlib/',
|
|
//SalesPlatform.ru begin #5732
|
|
// 'Vtlib Test HTML Directory' => './test/vtlib/HTML',
|
|
'Vtlib Test HTML Directory' => './test/vtlib/HTML/',
|
|
//SalesPlatform.ru end
|
|
'Mail Merge Template Directory' => './test/wordtemplatedownload/',
|
|
'Product Image Directory' => './test/product/',
|
|
'User Image Directory' => './test/user/',
|
|
'Contact Image Directory' => './test/contact/',
|
|
'Logo Directory' => './test/logo/',
|
|
'Logs Directory' => './logs/',
|
|
);
|
|
|
|
/**
|
|
* Function returns all the files and folder that are not writable
|
|
* @return <Array>
|
|
*/
|
|
public static function getFailedPermissionsFiles() {
|
|
$writableFilesAndFolders = self::$writableFilesAndFolders;
|
|
$failedPermissions = array();
|
|
require_once ('include/utils/VtlibUtils.php');
|
|
foreach ($writableFilesAndFolders as $index => $value) {
|
|
if (!vtlib_isWriteable($value)) {
|
|
$failedPermissions[$index] = $value;
|
|
}
|
|
}
|
|
return $failedPermissions;
|
|
}
|
|
|
|
/**
|
|
* Function returns the php.ini file settings required for installing vtigerCRM
|
|
* @return <Array>
|
|
*/
|
|
static function getCurrentDirectiveValue() {
|
|
$directiveValues = array();
|
|
if (ini_get('safe_mode') == '1' || stripos(ini_get('safe_mode'), 'On') > -1)
|
|
$directiveValues['safe_mode'] = 'On';
|
|
/* if (ini_get('display_errors') != '1' || stripos(ini_get('display_errors'), 'Off') > -1)
|
|
$directiveValues['display_errors'] = 'Off'; */
|
|
if (ini_get('display_errors') == '1' || stripos(ini_get('display_errors'), 'On') > -1)
|
|
$directiveValues['display_errors'] = 'On';
|
|
// SalesPlatform.ru begin
|
|
if (ini_get('max_input_vars') < 100000)
|
|
$directiveValues['max_input_vars'] = ini_get('max_input_vars');
|
|
// SalesPlatform.ru end
|
|
if (ini_get('file_uploads') != '1' || stripos(ini_get('file_uploads'), 'Off') > -1)
|
|
$directiveValues['file_uploads'] = 'Off';
|
|
if (ini_get('register_globals') == '1' || stripos(ini_get('register_globals'), 'On') > -1)
|
|
$directiveValues['register_globals'] = 'On';
|
|
if (ini_get(('output_buffering') < '4096' && ini_get('output_buffering') != '0') || stripos(ini_get('output_buffering'), 'Off') > -1)
|
|
$directiveValues['output_buffering'] = 'Off';
|
|
if (ini_get('max_execution_time') != 0)
|
|
$directiveValues['max_execution_time'] = ini_get('max_execution_time');
|
|
if (ini_get('memory_limit') < 32)
|
|
$directiveValues['memory_limit'] = ini_get('memory_limit');
|
|
// SalesPlatform.ru begin
|
|
$errorReportingValue = E_ALL & ~E_NOTICE;
|
|
//$errorReportingValue = E_WARNING & ~E_NOTICE;
|
|
// SalesPlatform.ru end
|
|
if(version_compare(PHP_VERSION, '5.3.0') >= 0){
|
|
// SalesPlatform.ru begin
|
|
$errorReportingValue = E_ALL & ~E_NOTICE & ~E_DEPRECATED;
|
|
//$errorReportingValue = E_WARNING & ~E_NOTICE & ~E_DEPRECATED;
|
|
// SalesPlatform.ru end
|
|
}
|
|
// SalesPlatform.ru begin
|
|
if(version_compare(PHP_VERSION, '5.4.0') >= 0) {
|
|
$errorReportingValue = E_ALL & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT;
|
|
}
|
|
// SalesPlatform.ru end
|
|
if (ini_get('error_reporting') != $errorReportingValue)
|
|
$directiveValues['error_reporting'] = 'NOT RECOMMENDED';
|
|
// SalesPlatform.ru begin
|
|
if(version_compare(PHP_VERSION, '5.4.0') < 0) {
|
|
// SalesPlatform.ru end
|
|
if (ini_get('allow_call_time_pass_reference') != '1' || stripos(ini_get('allow_call_time_pass_reference'), 'Off') > -1)
|
|
$directiveValues['allow_call_time_pass_reference'] = 'Off';
|
|
// SalesPlatform.ru begin
|
|
}
|
|
if (ini_get('log_errors') != '1' || stripos(ini_get('log_errors'), 'Off') > -1)
|
|
$directiveValues['log_errors'] = 'Off';
|
|
//if (ini_get('log_errors') == '1' || stripos(ini_get('log_errors'), 'On') > -1)
|
|
// $directiveValues['log_errors'] = 'On';
|
|
// SalesPlatform.ru end
|
|
if (ini_get('short_open_tag') == '1' || stripos(ini_get('short_open_tag'), 'On') > -1)
|
|
$directiveValues['short_open_tag'] = 'On';
|
|
|
|
return $directiveValues;
|
|
}
|
|
|
|
/**
|
|
* Variable has the recommended php settings for smooth running of vtigerCRM
|
|
* @var <Array>
|
|
*/
|
|
public static $recommendedDirectives = array (
|
|
'safe_mode' => 'Off',
|
|
'display_errors' => 'Off',
|
|
// SalesPlatform.ru begin
|
|
'max_input_vars' => '100000',
|
|
// SalesPlatform.ru end
|
|
'file_uploads' => 'On',
|
|
'register_globals' => 'On',
|
|
'output_buffering' => 'On',
|
|
'max_execution_time' => '0',
|
|
// SalesPlatform.ru begin
|
|
'memory_limit' => '128',
|
|
'error_reporting' => 'E_ALL & ~E_NOTICE',
|
|
'log_errors' => 'On',
|
|
//'memory_limit' => '32',
|
|
//'error_reporting' => 'E_WARNING & ~E_NOTICE',
|
|
//'log_errors' => 'Off',
|
|
// SalesPlatform.ru end
|
|
'short_open_tag' => 'Off'
|
|
);
|
|
|
|
/**
|
|
* Returns the recommended php settings for vtigerCRM
|
|
* @return type
|
|
*/
|
|
public static function getRecommendedDirectives(){
|
|
if(version_compare(PHP_VERSION, '5.5.0') >= 0){
|
|
// SalesPlatform.ru begin
|
|
self::$recommendedDirectives['error_reporting'] = 'E_ALL & ~E_NOTICE & ~E_DEPRECATED';
|
|
//self::$recommendedDirectives['error_reporting'] = 'E_WARNING & ~E_NOTICE & ~E_DEPRECATED';
|
|
// SalesPlatform.ru end
|
|
}
|
|
// SalesPlatform.ru begin
|
|
if(version_compare(PHP_VERSION, '5.4.0') >= 0) {
|
|
self::$recommendedDirectives['error_reporting'] = 'E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE';
|
|
}
|
|
// SalesPlatform.ru end
|
|
else if(version_compare(PHP_VERSION, '5.3.0') >= 0) {
|
|
// SalesPlatform.ru begin
|
|
self::$recommendedDirectives['error_reporting'] = 'E_ALL & ~E_NOTICE & ~E_DEPRECATED';
|
|
//self::$recommendedDirectives['error_reporting'] = 'E_WARNING & ~E_NOTICE & ~E_DEPRECATED';
|
|
// SalesPlatform.ru end
|
|
}
|
|
return self::$recommendedDirectives;
|
|
}
|
|
|
|
/**
|
|
* Function checks for vtigerCRM installation prerequisites
|
|
* @return <Array>
|
|
*/
|
|
public static function getSystemPreInstallParameters() {
|
|
$preInstallConfig = array();
|
|
// Name => array( System Value, Recommended value, supported or not(true/false) );
|
|
$preInstallConfig['LBL_PHP_VERSION'] = array(phpversion(), '5.4.0+, 7.0', (version_compare(phpversion(), '5.4.0', '>=')));
|
|
//$preInstallConfig['LBL_IMAP_SUPPORT'] = array(function_exists('imap_open'), true, (function_exists('imap_open') == true));
|
|
$preInstallConfig['LBL_ZLIB_SUPPORT'] = array(function_exists('gzinflate'), true, (function_exists('gzinflate') == true));
|
|
// SalesPlatform.ru begin
|
|
$preInstallConfig['LBL_EXIF_SUPPORT'] = array(function_exists('exif_read_data'), true, (function_exists('exif_read_data') == true));
|
|
// SalesPlatform.ru end
|
|
|
|
if ($preInstallConfig['LBL_PHP_VERSION'] >= '5.5.0') {
|
|
$preInstallConfig['LBL_MYSQLI_CONNECT_SUPPORT'] = array(extension_loaded('mysqli'), true, extension_loaded('mysqli'));
|
|
}
|
|
|
|
$preInstallConfig['LBL_OPEN_SSL'] = array(extension_loaded('openssl'), true, extension_loaded('openssl'));
|
|
$preInstallConfig['LBL_CURL'] = array(extension_loaded('curl'), true, extension_loaded('curl'));
|
|
$preInstallConfig['LBL_IMAP_SUPPORT'] = array(extension_loaded('imap'), true, (extension_loaded('imap') == true));
|
|
$preInstallConfig['LBL_MB_STRING'] = array(extension_loaded('mbstring'), true, (extension_loaded('mbstring') == true));
|
|
|
|
$gnInstalled = false;
|
|
if(!function_exists('gd_info')) {
|
|
eval(self::$gdInfoAlternate);
|
|
}
|
|
|
|
$gd_info = gd_info();
|
|
if (isset($gd_info['GD Version'])) {
|
|
$gnInstalled = true;
|
|
}
|
|
|
|
$preInstallConfig['LBL_GD_LIBRARY'] = array((extension_loaded('gd') || $gnInstalled), true, (extension_loaded('gd') || $gnInstalled));
|
|
$preInstallConfig['LBL_ZLIB_SUPPORT'] = array(function_exists('gzinflate'), true, (function_exists('gzinflate') == true));
|
|
$preInstallConfig['LBL_SIMPLEXML'] = array(function_exists('simplexml_load_file'), true, (function_exists('simplexml_load_file')));
|
|
|
|
return $preInstallConfig;
|
|
}
|
|
|
|
/**
|
|
* Function that provides default configuration based on installer setup
|
|
* @return <Array>
|
|
*/
|
|
public static function getDefaultPreInstallParameters() {
|
|
include 'config.db.php';
|
|
|
|
$parameters = array(
|
|
'db_hostname' => '',
|
|
'db_username' => '',
|
|
'db_password' => '',
|
|
'db_name' => '',
|
|
'admin_name' => 'admin',
|
|
'admin_lastname'=> 'Администратор',
|
|
'admin_password'=>'',
|
|
'admin_email' => '',
|
|
);
|
|
|
|
if (isset($dbconfig) && isset($vtconfig)) {
|
|
if (isset($dbconfig['db_server']) && $dbconfig['db_server'] != '_DBC_SERVER_') {
|
|
$parameters['db_hostname'] = $dbconfig['db_server'] . ':' . $dbconfig['db_port'];
|
|
$parameters['db_username'] = $dbconfig['db_username'];
|
|
$parameters['db_password'] = $dbconfig['db_password'];
|
|
$parameters['db_name'] = $dbconfig['db_name'];
|
|
|
|
$parameters['admin_password'] = $vtconfig['adminPwd'];
|
|
$parameters['admin_email'] = $vtconfig['adminEmail'];
|
|
}
|
|
}
|
|
|
|
return $parameters;
|
|
}
|
|
|
|
/**
|
|
* Function returns gd library information
|
|
* @var type
|
|
*/
|
|
public static $gdInfoAlternate = 'function gd_info() {
|
|
$array = Array(
|
|
"GD Version" => "",
|
|
"FreeType Support" => 0,
|
|
"FreeType Support" => 0,
|
|
"FreeType Linkage" => "",
|
|
"T1Lib Support" => 0,
|
|
"GIF Read Support" => 0,
|
|
"GIF Create Support" => 0,
|
|
"JPG Support" => 0,
|
|
"PNG Support" => 0,
|
|
"WBMP Support" => 0,
|
|
"XBM Support" => 0
|
|
);
|
|
$gif_support = 0;
|
|
|
|
ob_start();
|
|
eval("phpinfo();");
|
|
$info = ob_get_contents();
|
|
ob_end_clean();
|
|
|
|
foreach(explode("\n", $info) as $line) {
|
|
if(strpos($line, "GD Version")!==false)
|
|
$array["GD Version"] = trim(str_replace("GD Version", "", strip_tags($line)));
|
|
if(strpos($line, "FreeType Support")!==false)
|
|
$array["FreeType Support"] = trim(str_replace("FreeType Support", "", strip_tags($line)));
|
|
if(strpos($line, "FreeType Linkage")!==false)
|
|
$array["FreeType Linkage"] = trim(str_replace("FreeType Linkage", "", strip_tags($line)));
|
|
if(strpos($line, "T1Lib Support")!==false)
|
|
$array["T1Lib Support"] = trim(str_replace("T1Lib Support", "", strip_tags($line)));
|
|
if(strpos($line, "GIF Read Support")!==false)
|
|
$array["GIF Read Support"] = trim(str_replace("GIF Read Support", "", strip_tags($line)));
|
|
if(strpos($line, "GIF Create Support")!==false)
|
|
$array["GIF Create Support"] = trim(str_replace("GIF Create Support", "", strip_tags($line)));
|
|
if(strpos($line, "GIF Support")!==false)
|
|
$gif_support = trim(str_replace("GIF Support", "", strip_tags($line)));
|
|
if(strpos($line, "JPG Support")!==false)
|
|
$array["JPG Support"] = trim(str_replace("JPG Support", "", strip_tags($line)));
|
|
if(strpos($line, "PNG Support")!==false)
|
|
$array["PNG Support"] = trim(str_replace("PNG Support", "", strip_tags($line)));
|
|
if(strpos($line, "WBMP Support")!==false)
|
|
$array["WBMP Support"] = trim(str_replace("WBMP Support", "", strip_tags($line)));
|
|
if(strpos($line, "XBM Support")!==false)
|
|
$array["XBM Support"] = trim(str_replace("XBM Support", "", strip_tags($line)));
|
|
}
|
|
|
|
if($gif_support==="enabled") {
|
|
$array["GIF Read Support"] = 1;
|
|
$array["GIF Create Support"] = 1;
|
|
}
|
|
|
|
if($array["FreeType Support"]==="enabled"){
|
|
$array["FreeType Support"] = 1; }
|
|
|
|
if($array["T1Lib Support"]==="enabled")
|
|
$array["T1Lib Support"] = 1;
|
|
|
|
if($array["GIF Read Support"]==="enabled"){
|
|
$array["GIF Read Support"] = 1; }
|
|
|
|
if($array["GIF Create Support"]==="enabled")
|
|
$array["GIF Create Support"] = 1;
|
|
|
|
if($array["JPG Support"]==="enabled")
|
|
$array["JPG Support"] = 1;
|
|
|
|
if($array["PNG Support"]==="enabled")
|
|
$array["PNG Support"] = 1;
|
|
|
|
if($array["WBMP Support"]==="enabled")
|
|
$array["WBMP Support"] = 1;
|
|
|
|
if($array["XBM Support"]==="enabled")
|
|
$array["XBM Support"] = 1;
|
|
|
|
return $array;
|
|
|
|
}';
|
|
|
|
/**
|
|
* Returns list of currencies
|
|
* @return <Array>
|
|
*/
|
|
public static function getCurrencyList() {
|
|
require_once 'modules/Utilities/Currencies.php';
|
|
return $currencies;
|
|
}
|
|
|
|
|
|
/**
|
|
* Returns an array with the list of languages which are available in source
|
|
* Note: the DB has not been initialized at this point, so we have to look at
|
|
* the contents of the `languages/` directory.
|
|
* @return <Array>
|
|
*/
|
|
public static function getLanguageList() {
|
|
$languageFolder = 'languages/';
|
|
$handle = opendir($languageFolder);
|
|
$language_list = array();
|
|
while ($prefix = readdir($handle)) {
|
|
if (substr($prefix, 0, 1) === '.' || $prefix === 'Settings') {
|
|
continue;
|
|
}
|
|
if (is_dir('languages/' . $prefix) && is_file('languages/' . $prefix . '/Install.php')) {
|
|
$language_list[$prefix] = $prefix;
|
|
}
|
|
}
|
|
|
|
ksort($language_list);
|
|
|
|
return $language_list;
|
|
}
|
|
|
|
|
|
|
|
/**
|
|
* Function checks if its mysql type
|
|
* @param type $dbType
|
|
* @return type
|
|
*/
|
|
static function isMySQL($dbType) {
|
|
return (stripos($dbType ,'mysql') === 0);
|
|
}
|
|
|
|
/**
|
|
* Function returns mysql version
|
|
* @param type $serverInfo
|
|
* @return type
|
|
*/
|
|
public static function getMySQLVersion($serverInfo) {
|
|
if(!is_array($serverInfo)) {
|
|
$version = explode('-',$serverInfo);
|
|
$mysql_server_version=$version[0];
|
|
} else {
|
|
$mysql_server_version = $serverInfo['version'];
|
|
}
|
|
return $mysql_server_version;
|
|
}
|
|
|
|
/**
|
|
* Function to check sql_mode configuration
|
|
* @param DbConnection $conn
|
|
* @return boolean
|
|
*/
|
|
public static function isMySQLSqlModeFriendly($conn) {
|
|
$rs = $conn->Execute("SHOW VARIABLES LIKE 'sql_mode'");
|
|
if ($rs && ($row = $rs->fetchRow())) {
|
|
$values = explode(',', strtoupper($row['Value']));
|
|
$unsupported = array('ONLY_FULL_GROUP_BY', 'STRICT_TRANS_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE');
|
|
foreach ($unsupported as $check) {
|
|
if (in_array($check, $values)) {
|
|
return false;
|
|
}
|
|
}
|
|
}
|
|
return true;
|
|
}
|
|
|
|
/**
|
|
* Function checks the database connection
|
|
* @param <String> $db_type
|
|
* @param <String> $db_hostname
|
|
* @param <String> $db_username
|
|
* @param <String> $db_password
|
|
* @param <String> $db_name
|
|
* @param <String> $create_db
|
|
* @param <String> $create_utf8_db
|
|
* @param <String> $root_user
|
|
* @param <String> $root_password
|
|
* @return <Array>
|
|
*/
|
|
public static function checkDbConnection($db_type, $db_hostname, $db_username, $db_password, $db_name, $create_db=false, $create_utf8_db=true, $root_user='', $root_password='') {
|
|
$dbCheckResult = array();
|
|
|
|
$db_type_status = false; // is there a db type?
|
|
$db_server_status = false; // does the db server connection exist?
|
|
$db_creation_failed = false; // did we try to create a database and fail?
|
|
$db_exist_status = false; // does the database exist?
|
|
$db_utf8_support = false; // does the database support utf8?
|
|
$db_sqlmode_support = false; // does the database having friendly sql_mode?
|
|
|
|
//Checking for database connection parameters
|
|
if($db_type) {
|
|
$conn = NewADOConnection($db_type);
|
|
$db_type_status = true;
|
|
if(@$conn->Connect($db_hostname,$db_username,$db_password)) {
|
|
$db_server_status = true;
|
|
$serverInfo = $conn->ServerInfo();
|
|
if(self::isMySQL($db_type)) {
|
|
$mysql_server_version = self::getMySQLVersion($serverInfo);
|
|
}
|
|
$db_sqlmode_support = self::isMySQLSqlModeFriendly($conn);
|
|
if($create_db && $db_sqlmode_support) {
|
|
// drop the current database if it exists
|
|
$dropdb_conn = NewADOConnection($db_type);
|
|
if(@$dropdb_conn->Connect($db_hostname, $root_user, $root_password, $db_name)) {
|
|
$query = "DROP DATABASE ".$db_name;
|
|
$dropdb_conn->Execute($query);
|
|
$dropdb_conn->Close();
|
|
}
|
|
|
|
// create the new database
|
|
$db_creation_failed = true;
|
|
$createdb_conn = NewADOConnection($db_type);
|
|
if(@$createdb_conn->Connect($db_hostname, $root_user, $root_password)) {
|
|
$query = "CREATE DATABASE ".$db_name;
|
|
if($create_utf8_db == 'true') {
|
|
if(self::isMySQL($db_type))
|
|
$query .= " DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci";
|
|
$db_utf8_support = true;
|
|
}
|
|
if($createdb_conn->Execute($query)) {
|
|
$db_creation_failed = false;
|
|
}
|
|
|
|
// SalesPlatform.ru begin
|
|
if(self::isMySQL($db_type)) {
|
|
$query = "grant all on $db_name.* to $db_username";
|
|
|
|
if(!$createdb_conn->Execute($query)) {
|
|
$db_creation_failed = true;
|
|
}
|
|
}
|
|
// SalesPlatform.ru end
|
|
|
|
$createdb_conn->Close();
|
|
}
|
|
}
|
|
|
|
if(@$conn->Connect($db_hostname, $db_username, $db_password, $db_name)) {
|
|
$db_exist_status = true;
|
|
if(!$db_utf8_support) {
|
|
$db_utf8_support = Vtiger_Util_Helper::checkDbUTF8Support($conn);
|
|
|
|
//SalesPlatform.ru begin
|
|
if(!$db_utf8_support || !Vtiger_Util_Helper::checkCollation($conn)) {
|
|
if(!$conn->Execute("ALTER DATABASE " . $db_name . " DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci")) {
|
|
$dbCheckResult['flag'] = false;
|
|
$dbCheckResult['error_msg'] = getTranslatedString('ERR_NO_UTF8_OR_NO_ALTER_RIGHTS', 'Install');
|
|
$dbCheckResult['error_msg_info'] = '';
|
|
$dbCheckResult['db_utf8_support'] = $db_utf8_support;
|
|
|
|
return $dbCheckResult;
|
|
}
|
|
$db_utf8_support = true;
|
|
}
|
|
//SalesPlatform.ru end
|
|
}
|
|
}
|
|
$conn->Close();
|
|
}
|
|
}
|
|
$dbCheckResult['db_utf8_support'] = $db_utf8_support;
|
|
|
|
$error_msg = '';
|
|
$error_msg_info = '';
|
|
|
|
if(!$db_type_status || !$db_server_status) {
|
|
$error_msg = getTranslatedString('ERR_DATABASE_CONNECTION_FAILED', 'Install').'. '.getTranslatedString('ERR_INVALID_MYSQL_PARAMETERS', 'Install');
|
|
$error_msg_info = getTranslatedString('MSG_LIST_REASONS', 'Install').':<br>
|
|
- '.getTranslatedString('MSG_DB_PARAMETERS_INVALID', 'Install').'
|
|
- '.getTranslatedString('MSG_DB_USER_NOT_AUTHORIZED', 'Install');
|
|
} elseif(self::isMySQL($db_type) && $mysql_server_version < 4.1) {
|
|
$error_msg = $mysql_server_version.' -> '.getTranslatedString('ERR_INVALID_MYSQL_VERSION', 'Install');
|
|
} elseif(!$db_sqlmode_support) {
|
|
$error_msg = getTranslatedString('ERR_DB_SQLMODE_NOTFRIENDLY', 'Install');
|
|
} elseif($db_creation_failed) {
|
|
$error_msg = getTranslatedString('ERR_UNABLE_CREATE_DATABASE', 'Install').' '.$db_name;
|
|
$error_msg_info = getTranslatedString('MSG_DB_ROOT_USER_NOT_AUTHORIZED', 'Install');
|
|
} elseif(!$db_exist_status) {
|
|
$error_msg = $db_name.' -> '.getTranslatedString('ERR_DB_NOT_FOUND', 'Install');
|
|
} elseif(!$db_utf8_support) {
|
|
$error_msg = $db_name.' -> '.getTranslatedString('ERR_DB_NOT_UTF8', 'Install');
|
|
} else {
|
|
$dbCheckResult['flag'] = true;
|
|
return $dbCheckResult;
|
|
}
|
|
$dbCheckResult['flag'] = false;
|
|
$dbCheckResult['error_msg'] = $error_msg;
|
|
$dbCheckResult['error_msg_info'] = $error_msg_info;
|
|
return $dbCheckResult;
|
|
}
|
|
|
|
/**
|
|
* Function installs all the available modules
|
|
*/
|
|
public static function installModules() {
|
|
require_once('vtlib/Vtiger/Package.php');
|
|
require_once('vtlib/Vtiger/Module.php');
|
|
require_once('include/utils/utils.php');
|
|
|
|
$moduleFolders = array('packages/vtiger/mandatory', 'packages/vtiger/optional', 'packages/vtiger/marketplace');
|
|
foreach($moduleFolders as $moduleFolder) {
|
|
if ($handle = opendir($moduleFolder)) {
|
|
while (false !== ($file = readdir($handle))) {
|
|
$packageNameParts = explode(".",$file);
|
|
if($packageNameParts[count($packageNameParts)-1] != 'zip'){
|
|
continue;
|
|
}
|
|
array_pop($packageNameParts);
|
|
$packageName = implode("",$packageNameParts);
|
|
if (!empty($packageName)) {
|
|
$packagepath = "$moduleFolder/$file";
|
|
$package = new Vtiger_Package();
|
|
$module = $package->getModuleNameFromZip($packagepath);
|
|
if($module != null) {
|
|
$moduleInstance = Vtiger_Module::getInstance($module);
|
|
if($moduleInstance) {
|
|
updateVtlibModule($module, $packagepath);
|
|
} else {
|
|
installVtlibModule($module, $packagepath);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
closedir($handle);
|
|
}
|
|
}
|
|
}
|
|
|
|
//SalesPlatform.ru begin
|
|
public static function getVTWSInventoryFieldTypeId() {
|
|
$db = PearDatabase::getInstance();
|
|
$result = $db->pquery("SELECT fieldtypeid FROM vtiger_ws_entity_fieldtype WHERE table_name=? AND field_name=? AND fieldtype=?",
|
|
array('vtiger_inventoryproductrel', 'id', 'reference'));
|
|
if ($result && $resultRow = $db->fetchByAssoc($result)) {
|
|
return $resultRow['fieldtypeid'];
|
|
}
|
|
return false;
|
|
}
|
|
|
|
public static function checkVTWSReferenceType($fieldTypeId, $moduleName){
|
|
$db = PearDatabase::getInstance();
|
|
|
|
$result = $db->pquery("SELECT 1 FROM vtiger_ws_entity_referencetype WHERE fieldtypeid=? AND type=?",
|
|
array($fieldTypeId, $moduleName));
|
|
if ($db->num_rows($result)) {
|
|
return true;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
public static function checkHeaderColumn() {
|
|
$db = PearDatabase::getInstance();
|
|
$result = $db->pquery("SHOW COLUMNS FROM vtiger_field LIKE 'headerfield'");
|
|
return ($db->num_rows($result) > 0);
|
|
}
|
|
|
|
public static function isFieldExists($tabId, $fieldName) {
|
|
$db = PearDatabase::getInstance();
|
|
|
|
$result = $db->pquery("SELECT fieldid FROM vtiger_field WHERE tabid=? AND fieldname=?",
|
|
array($tabId, $fieldName));
|
|
return $db->num_rows($result);
|
|
}
|
|
//SalesPlatform.ru end
|
|
}
|