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.
225 lines
10 KiB
PHP
225 lines
10 KiB
PHP
<?php
|
|
/*+**********************************************************************************
|
|
* The contents of this file are subject to the vtiger CRM Public License Version 1.1
|
|
* ("License"); You may not use this file except in compliance with the License
|
|
* The Original Code is: SalesPlatform Ltd
|
|
* The Initial Developer of the Original Code is SalesPlatform Ltd.
|
|
* All Rights Reserved.
|
|
* If you have any questions or comments, please email: devel@salesplatform.ru
|
|
************************************************************************************/
|
|
include_once 'include/Zend/Json.php';
|
|
require_once('data/CRMEntity.php');
|
|
require_once('data/Tracker.php');
|
|
|
|
class SPCMLConnector {
|
|
/**
|
|
* Invoked when special actions are performed on the module.
|
|
* @param String Module name
|
|
* @param String Event Type (module.postinstall, module.disabled, module.enabled, module.preuninstall)
|
|
*/
|
|
function vtlib_handler($modulename, $event_type) {
|
|
global $adb;
|
|
|
|
//adding new fields into linked tables
|
|
if($event_type == 'module.postinstall') {
|
|
$module = Vtiger_Module_Model::getInstance('Accounts');
|
|
if(!$this->isFieldExists('one_s_id', $module)) {
|
|
$blockInstance = Vtiger_Block::getInstance('LBL_ACCOUNT_INFORMATION', $module);
|
|
|
|
$fieldInstance = new Vtiger_Field();
|
|
$fieldInstance->label = '1C ID';
|
|
$fieldInstance->name = 'one_s_id';
|
|
$fieldInstance->table = 'vtiger_account';
|
|
$fieldInstance->column = 'one_s_id';
|
|
$fieldInstance->columntype = 'varchar';
|
|
$fieldInstance->uitype = 1;
|
|
$fieldInstance->displaytype = 3;
|
|
$fieldInstance->typeofdata = 'V~O';
|
|
$blockInstance->addField($fieldInstance);
|
|
}
|
|
|
|
|
|
$sql = "ALTER TABLE `vtiger_account` ADD COLUMN `one_s_id` VARCHAR(255) NULL ;";
|
|
$params = array();
|
|
$adb->pquery($sql, $params);
|
|
|
|
|
|
/*********************************************************************************/
|
|
|
|
$module = Vtiger_Module_Model::getInstance('PriceBooks');
|
|
if(!$this->isFieldExists('one_s_id', $module)) {
|
|
$blockInstance = Vtiger_Block::getInstance('LBL_PRICEBOOK_INFORMATION', $module);
|
|
|
|
$fieldInstance = new Vtiger_Field();
|
|
$fieldInstance->label = '1C ID';
|
|
$fieldInstance->name = 'one_s_id';
|
|
$fieldInstance->table = 'vtiger_pricebook';
|
|
$fieldInstance->column = 'one_s_id';
|
|
$fieldInstance->columntype = 'varchar';
|
|
$fieldInstance->uitype = 1;
|
|
$fieldInstance->displaytype = 3;
|
|
$fieldInstance->typeofdata = 'V~O';
|
|
$blockInstance->addField($fieldInstance);
|
|
}
|
|
|
|
|
|
$sql = "ALTER TABLE `vtiger_pricebook` ADD COLUMN `one_s_id` VARCHAR(255) NULL ;";
|
|
$params = array();
|
|
$adb->pquery($sql, $params);
|
|
|
|
/*********************************************************************************/
|
|
|
|
$module = Vtiger_Module_Model::getInstance('Products');
|
|
if(!$this->isFieldExists('one_s_id', $module)) {
|
|
$blockInstance = Vtiger_Block::getInstance('LBL_PRODUCT_INFORMATION', $module);
|
|
|
|
$fieldInstance = new Vtiger_Field();
|
|
$fieldInstance->label = '1C ID';
|
|
$fieldInstance->name = 'one_s_id';
|
|
$fieldInstance->table = 'vtiger_products';
|
|
$fieldInstance->column = 'one_s_id';
|
|
$fieldInstance->columntype = 'varchar';
|
|
$fieldInstance->uitype = 1;
|
|
$fieldInstance->displaytype = 3;
|
|
$fieldInstance->typeofdata = 'V~O';
|
|
$blockInstance->addField($fieldInstance);
|
|
}
|
|
|
|
|
|
$sql = "ALTER TABLE `vtiger_products` ADD COLUMN `one_s_id` VARCHAR(255) NULL ;";
|
|
$params = array();
|
|
$adb->pquery($sql, $params);
|
|
|
|
/*********************************************************************************/
|
|
|
|
$module = Vtiger_Module_Model::getInstance('SalesOrder');
|
|
if(!$this->isFieldExists('one_s_id', $module)) {
|
|
$blockInstance = Vtiger_Block::getInstance('LBL_SO_INFORMATION', $module);
|
|
|
|
$fieldInstance = new Vtiger_Field();
|
|
$fieldInstance->label = '1C ID';
|
|
$fieldInstance->name = 'one_s_id';
|
|
$fieldInstance->table = 'vtiger_salesorder';
|
|
$fieldInstance->column = 'one_s_id';
|
|
$fieldInstance->columntype = 'varchar';
|
|
$fieldInstance->uitype = 1;
|
|
$fieldInstance->displaytype = 3;
|
|
$fieldInstance->typeofdata = 'V~O';
|
|
$blockInstance->addField($fieldInstance);
|
|
}
|
|
|
|
$sql = "ALTER TABLE `vtiger_salesorder` ADD COLUMN `one_s_id` VARCHAR(255) NULL ;";
|
|
$params = array();
|
|
$adb->pquery($sql, $params);
|
|
|
|
|
|
/*********************************************************************************/
|
|
if(!$this->isFieldExists('fromsite', $module)) {
|
|
$fieldInstance = new Vtiger_Field();
|
|
$fieldInstance->label = 'fromsite';
|
|
$fieldInstance->name = 'fromsite';
|
|
$fieldInstance->table = 'vtiger_salesorder';
|
|
$fieldInstance->column = 'fromsite';
|
|
$fieldInstance->columntype = 'int';
|
|
$fieldInstance->uitype = 1;
|
|
$fieldInstance->displaytype = 3;
|
|
$fieldInstance->typeofdata = 'V~O';
|
|
$blockInstance->addField($fieldInstance);
|
|
}
|
|
|
|
$sql = "ALTER TABLE `vtiger_salesorder` ADD COLUMN `fromsite` int(20) NULL ;";
|
|
$params = array();
|
|
$adb->pquery($sql, $params);
|
|
|
|
/*********************************************************************************/
|
|
|
|
$module = Vtiger_Module_Model::getInstance('Services');
|
|
if(!$this->isFieldExists('one_s_id', $module)) {
|
|
$blockInstance = Vtiger_Block::getInstance('LBL_SERVICE_INFORMATION', $module);
|
|
|
|
$fieldInstance = new Vtiger_Field();
|
|
$fieldInstance->label = '1C ID';
|
|
$fieldInstance->name = 'one_s_id';
|
|
$fieldInstance->table = 'vtiger_service';
|
|
$fieldInstance->column = 'one_s_id';
|
|
$fieldInstance->columntype = 'varchar';
|
|
$fieldInstance->uitype = 1;
|
|
$fieldInstance->displaytype = 3;
|
|
$fieldInstance->typeofdata = 'V~O';
|
|
$blockInstance->addField($fieldInstance);
|
|
}
|
|
|
|
$sql = "ALTER TABLE `vtiger_service` ADD COLUMN `one_s_id` VARCHAR(255) NULL ;";
|
|
$params = array();
|
|
$adb->pquery($sql, $params);
|
|
|
|
/* Initilizate cml_settings */
|
|
$sql = "INSERT INTO `sp_cml_site_settings` VALUES
|
|
(1,'siteParam','adminLogin','admin'),
|
|
(2,'siteParam','adminPassword','admin'),
|
|
(3,'siteParam','siteUrl','http://localhost/1c_exchange.php'),
|
|
(4,'siteParam','assignedUser','admin'),
|
|
(5,'statusParam','Created','Принят');";
|
|
$adb->pquery($sql,array());
|
|
|
|
/* Create field in module settings */
|
|
$sql = "set @lastfieldid = (select `id` from `vtiger_settings_field_seq`);";
|
|
$adb->pquery($sql,array());
|
|
$sql = "set @blockid = (select `blockid` from `vtiger_settings_blocks` where `label` = 'LBL_INTEGRATION');";
|
|
$adb->pquery($sql,array());
|
|
$sql = "set @maxseq = (select max(`sequence`) from `vtiger_settings_field` where `blockid` = @blockid);";
|
|
$adb->pquery($sql,array());
|
|
$sql = "INSERT INTO `vtiger_settings_field` (`fieldid`, `blockid`, `name`, `iconpath`, `description`, `linkto`, `sequence`, `active`) "
|
|
. " VALUES (@lastfieldid+1, @blockid, 'LBL_CML_SETTINGS', 'cml_settings.png', 'LBL_CML_SETTINGS_DESCRIPTION', 'index.php?module=SPCMLConnector&view=Index&parent=Settings', @maxseq+1, 0);";
|
|
$adb->pquery($sql,array());
|
|
$sql = "UPDATE `vtiger_settings_field_seq` SET `id` = @lastfieldid+1;";
|
|
$adb->pquery($sql,array());
|
|
|
|
} else if($event_type == 'module.disabled') {
|
|
$this->disableModule();
|
|
} else if($event_type == 'module.enabled') {
|
|
$this->enableModule();
|
|
} else if($event_type == 'module.preuninstall') {
|
|
// TODO Handle actions when this module is about to be deleted.
|
|
} else if($event_type == 'module.preupdate') {
|
|
// TODO Handle actions before this module is updated.
|
|
} else if($event_type == 'module.postupdate') {
|
|
// TODO Handle actions after this module is updated.
|
|
}
|
|
|
|
}
|
|
|
|
/**
|
|
* Disable one_s_id field on module disable
|
|
*/
|
|
private function disableModule() {
|
|
$db = PearDatabase::getInstance();
|
|
$db->query("UPDATE vtiger_field SET presence=1 WHERE fieldname='one_s_id' AND "
|
|
. "tablename IN('vtiger_account','vtiger_pricebook','vtiger_products','vtiger_salesorder','vtiger_service')");
|
|
|
|
$db->query("UPDATE vtiger_cron_task SET status=0 WHERE module='SPCMLConnector'");
|
|
}
|
|
|
|
/**
|
|
* Enable one_s_id field on module enable
|
|
*/
|
|
private function enableModule() {
|
|
$db = PearDatabase::getInstance();
|
|
$db->query("UPDATE vtiger_field SET presence=2 WHERE fieldname='one_s_id' AND "
|
|
. "tablename IN('vtiger_account','vtiger_pricebook','vtiger_products','vtiger_salesorder','vtiger_service')");
|
|
}
|
|
|
|
/**
|
|
*
|
|
* @param string $fieldName
|
|
* @param Vtiger_Module_Model $moduleModel
|
|
*/
|
|
private function isFieldExists($fieldName, $moduleModel) {
|
|
$fieldModel = $moduleModel->getField($fieldName);
|
|
|
|
return $fieldModel !== false;
|
|
}
|
|
}
|
|
|
|
?>
|