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.
54 lines
1.9 KiB
PHP
54 lines
1.9 KiB
PHP
<?php
|
|
global $root_directory;
|
|
require_once($root_directory."/modules/Workflow2/autoload_wf.php");
|
|
|
|
class Settings_Workflow2_ConditionPopupCalculator_Action extends Settings_Vtiger_Basic_Action {
|
|
|
|
public function process(Vtiger_Request $request) {
|
|
$adb = PearDatabase::getInstance();
|
|
|
|
$task = $request->get('task');
|
|
|
|
$preset = new \Workflow\Preset\Condition('condition', null, array(
|
|
'fromModule' => $request->get('fromModule'),
|
|
'toModule' => $request->get('toModule'),
|
|
'enableHasChanged' => false,
|
|
'container' => 'conditionalPopupContainer',
|
|
));
|
|
|
|
$condition = $preset->beforeSave($task);
|
|
|
|
$moduleName = $task['module'];
|
|
$main_module = \CRMEntity::getInstance($moduleName);
|
|
|
|
if(!empty($condition)) {
|
|
$objMySQL = new \Workflow\ConditionMysql($condition['module'], \Workflow\VTEntity::getDummy());
|
|
$objMySQL->setLogger(false);
|
|
|
|
$sqlCondition = $objMySQL->parse($condition['condition']);
|
|
|
|
$sqlTables = $objMySQL->generateTables();
|
|
} else {
|
|
$sqlTables = "FROM ".$main_module->table_name.' INNER JOIN vtiger_crmentity ON (crmid = `'.$main_module->table_name.'`.`'.$main_module->table_index.'` AND deleted = 0)';
|
|
$sqlCondition = '';
|
|
}
|
|
|
|
if(strlen($sqlCondition) > 3) {
|
|
$sqlCondition .= " AND vtiger_crmentity.deleted = 0";
|
|
} else {
|
|
$sqlCondition .= " vtiger_crmentity.deleted = 0";
|
|
}
|
|
|
|
$idColumn = $main_module->table_name.".".$main_module->table_index;
|
|
$sqlQuery = "SELECT COUNT(*) as num ".$sqlTables." WHERE ".(strlen($sqlCondition) > 3?$sqlCondition:"");
|
|
//$sqlQuery .= ' GROUP BY crmid ';
|
|
//echo $sqlQuery;
|
|
$result2 = $adb->query($sqlQuery, true);
|
|
|
|
echo $adb->query_result($result2, 0, 'num');
|
|
|
|
exit();
|
|
}
|
|
}
|
|
|