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.
84 lines
2.4 KiB
PHP
84 lines
2.4 KiB
PHP
<?php
|
|
|
|
/* +********************************************************************************
|
|
* The content of this file is subject to the Reports 4 You license.
|
|
* ("License"); You may not use this file except in compliance with the License
|
|
* The Initial Developer of the Original Code is IT-Solutions4You s.r.o.
|
|
* Portions created by IT-Solutions4You s.r.o. are Copyright(C) IT-Solutions4You s.r.o.
|
|
* All Rights Reserved.
|
|
* ****************************************************************************** */
|
|
|
|
class ITS4YouReports_CronExport_Model extends Vtiger_Base_Model
|
|
{
|
|
protected static function getDb()
|
|
{
|
|
return PearDatabase::getInstance();
|
|
}
|
|
|
|
public static function saveRequest($reportId, $userId, $type)
|
|
{
|
|
$checkResult = self::getDb()->pquery(
|
|
'
|
|
SELECT id
|
|
FROM its4you_reports4you_cron_export
|
|
WHERE reportid = ?
|
|
AND userid=?
|
|
AND type=?
|
|
AND status=0
|
|
',
|
|
[
|
|
$reportId,
|
|
$userId,
|
|
$type
|
|
]
|
|
);
|
|
|
|
if (!self::getDb()->num_rows($checkResult)) {
|
|
self::getDb()->pquery(
|
|
'INSERT INTO its4you_reports4you_cron_export (reportid, userid, type)
|
|
VALUES (?,?,?)',
|
|
[
|
|
[$reportId, $userId, $type]
|
|
]
|
|
);
|
|
}
|
|
}
|
|
|
|
public static function updateStatusDone($reportId, $userId)
|
|
{
|
|
self::getDb()->pquery(
|
|
'UPDATE its4you_reports4you_cron_export
|
|
SET status=?
|
|
WHERE reportid=?
|
|
AND userid=?',
|
|
[
|
|
[1, $reportId, $userId]
|
|
]
|
|
);
|
|
}
|
|
|
|
public static function getAll()
|
|
{
|
|
$result = self::getDb()->pquery(
|
|
'
|
|
SELECT *
|
|
FROM its4you_reports4you_cron_export
|
|
WHERE status=?
|
|
ORDER BY userid, reportid
|
|
',
|
|
[
|
|
0
|
|
]
|
|
);
|
|
|
|
$reports = [];
|
|
while ($row = self::getDb()->fetchByAssoc($result)) {
|
|
if (!in_array($row['type'], $reports[$row['userid']][$row['reportid']])) {
|
|
$reports[$row['userid']][$row['reportid']][] = $row['type'];
|
|
}
|
|
}
|
|
|
|
return $reports;
|
|
}
|
|
}
|