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

36 lines
1.1 KiB
PHP

<?php
/**
* Created by JetBrains PhpStorm.
* User: Stefan Warnat <support@stefanwarnat.de>
* Date: 23.08.14 16:27
* You must not use this file without permission.
*/
namespace Workflow;
class Userqueue
{
public static function add($type, $queue_id, $subject, $parentKey, $settings) {
$adb = \PearDatabase::getInstance();
$sql = 'INSERT INTO vtiger_wf_userqueue SET type = ?, queue_id = ?, settings = ?, subject = ?, parentKey = ?';
$adb->pquery($sql, array($type, intval($queue_id), serialize($settings), $subject, $parentKey), true);
return \Workflow\VtUtils::LastDBInsertID();
}
public static function getById($queue_id) {
$adb = \PearDatabase::getInstance();
$sql = 'SELECT * FROM vtiger_wf_userqueue WHERE id = ?';
$result = $adb->pquery($sql, array($queue_id), true);
if($adb->num_rows($result) == 0) return false;
$userQueue = $adb->fetchByAssoc($result);
$userQueue['settings'] = unserialize(html_entity_decode($userQueue['settings'], ENT_QUOTES, 'UTF-8'));
return $userQueue;
}
}
?>