Files
Fedor ac7467f0b4 Major CRM updates: AI Assistant, Court Status API, S3 integration improvements, and extensive file storage system
- 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.
2025-10-16 11:17:21 +03:00

76 lines
3.3 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
************************************************************************************/
class Settings_SPTips_ListRules_View extends Settings_Vtiger_Index_View {
const moduleRuleTable = 'sp_tips_module_rules';
const dependentFieldsTable = 'sp_tips_dependent_fields';
public function process(Vtiger_Request $request) {
$qualifiedModuleName = $request->getModule(false);
$providerModel = Settings_SPTips_Provider_Model::getInstanceById($request->get('selectedProvider'));
if($providerModel == null) {
throw new AppException(vtranslate('LBL_PERMISSION_DENIED'));
}
$viewer = $this->getViewer($request);
$viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName);
$viewer->assign('EXISTING_RULES', Settings_SPTips_Rule_Model::getAllProviderRules($providerModel->getId()));
$viewer->view('RulesTable.tpl',$qualifiedModuleName);
}
public function getAllDependentFieldsForCurrentModule($ruleId, $moduleName) {
$adb = PearDatabase::getInstance();
$sql = 'SELECT vtiger_field.fieldname, vtiger_field.fieldlabel FROM vtiger_field JOIN ';
$sql .= Settings_SPTips_ListRules_View::dependentFieldsTable . ' ON ';
$sql .= Settings_SPTips_ListRules_View::dependentFieldsTable . '.vtiger_fieldname = vtiger_field.fieldname WHERE ';
$sql .= Settings_SPTips_ListRules_View::dependentFieldsTable . '.rule_id = ? AND vtiger_field.tabid = ?';
$fieldsResult = $adb->pquery($sql, array($ruleId, getTabid($moduleName)));
$numOfRows = $adb->num_rows($fieldsResult);
$dependentFields = array();
if ($numOfRows) {
while($row = $adb->fetch_array($fieldsResult)) {
$dependentFields[$row['fieldname']] = $row['fieldlabel'];
}
}
return $dependentFields;
}
public function getLabelForCurrentField($fieldName, $moduleName) {
$adb = PearDatabase::getInstance();
$sql = 'SELECT fieldlabel FROM vtiger_field WHERE tabid = ? AND fieldname = ?';
$result = $adb->pquery($sql, array(getTabid($moduleName), $fieldName));
if ($result) {
return $adb->query_result($result, 0);
}
else {
return null;
}
}
public function getProviderFieldsForSelectedRule($ruleId) {
$adb = PearDatabase::getInstance();
$sql = 'SELECT vtiger_fieldname, provider_fieldname FROM ' . Settings_SPTips_ListRules_View::dependentFieldsTable . ' WHERE rule_id = ?';
$result = $adb->pquery($sql, array($ruleId));
$providerFields = array();
if ($result) {
while($row = $adb->fetch_array($result)) {
$providerFields[$row['vtiger_fieldname']] = $row['provider_fieldname'];
}
}
return $providerFields;
}
}