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.
58 lines
1.8 KiB
PHP
58 lines
1.8 KiB
PHP
<?php
|
|
/**
|
|
* Created by PhpStorm.
|
|
* User: Stefan
|
|
* Date: 13.08.2016
|
|
* Time: 12:26
|
|
*/
|
|
|
|
namespace Workflow;
|
|
|
|
class Options
|
|
{
|
|
public static function has($workflowId, $key) {
|
|
$adb = \PearDatabase::getInstance();
|
|
|
|
$sql = 'SELECT workflow_id FROM vtiger_wf_options WHERE workflow_id = ? AND `key` = ?';
|
|
$result = $adb->pquery($sql, array($workflowId, $key));
|
|
|
|
return $adb->num_rows($result) > 0;
|
|
}
|
|
|
|
public static function get($workflowId, $key = '', $defaultValue = null) {
|
|
if(!is_numeric($workflowId)) {
|
|
$key = $workflowId;
|
|
$workflowId = 0;
|
|
}
|
|
$adb = \PearDatabase::getInstance();
|
|
|
|
$sql = 'SELECT value FROM vtiger_wf_options WHERE workflow_id = ? AND `key` = ?';
|
|
$result = $adb->pquery($sql, array($workflowId, $key));
|
|
|
|
if($adb->num_rows($result) == 0) {
|
|
return $defaultValue;
|
|
}
|
|
|
|
return unserialize(html_entity_decode($adb->query_result($result, 0, 'value')));
|
|
}
|
|
|
|
public static function set($workflowId, $key, $value) {
|
|
$adb = \PearDatabase::getInstance();
|
|
|
|
if(self::has($workflowId, $key)) {
|
|
$sql = 'UPDATE vtiger_wf_options SET value = ? WHERE workflow_id = ? AND `key` = ?';
|
|
$adb->pquery($sql, array(serialize($value), $workflowId, $key), true);
|
|
} else {
|
|
$sql = 'INSERT INTO vtiger_wf_options SET `value` = ?, `workflow_id` = ?, `key` = ?';
|
|
$adb->pquery($sql, array(serialize($value), $workflowId, $key), true);
|
|
}
|
|
}
|
|
|
|
public static function remove($workflow_id, $key) {
|
|
$adb = \PearDatabase::getInstance();
|
|
|
|
$sql = 'DELETE FROM vtiger_wf_options WHERE workflow_id = ? AND `key` = ?';
|
|
$adb->pquery($sql, array($workflow_id, $key));
|
|
}
|
|
|
|
} |