<?php
/**
 * Проверка тестовых записей в базе данных
 */

// Подключаем vTiger
chdir(dirname(__FILE__));
include_once('vtlib/Vtiger/Module.php');
include_once('includes/main/WebUI.php');

echo "=== ПРОВЕРКА ТЕСТОВЫХ ЗАПИСЕЙ ===\n\n";

global $adb;

// Проверяем vtiger_notes
echo "1. Проверка vtiger_notes:\n";
$query = "SELECT notesid, filename, filesize, filelocationtype FROM vtiger_notes WHERE notesid >= 393319 ORDER BY notesid DESC LIMIT 5";
$result = $adb->pquery($query, array());

if ($adb->num_rows($result) > 0) {
    while ($row = $adb->fetchByAssoc($result)) {
        echo "   ID: " . $row['notesid'] . 
             ", filename: " . $row['filename'] . 
             ", size: " . $row['filesize'] . 
             ", location: " . $row['filelocationtype'] . "\n";
    }
} else {
    echo "   Записи не найдены\n";
}

echo "\n2. Проверка vtiger_attachments:\n";
$query2 = "SELECT attachmentsid, name, type, path FROM vtiger_attachments WHERE attachmentsid >= 393319 ORDER BY attachmentsid DESC LIMIT 5";
$result2 = $adb->pquery($query2, array());

if ($adb->num_rows($result2) > 0) {
    while ($row = $adb->fetchByAssoc($result2)) {
        echo "   ID: " . $row['attachmentsid'] . 
             ", name: " . $row['name'] . 
             ", type: " . $row['type'] . 
             ", path: " . $row['path'] . "\n";
    }
} else {
    echo "   Записи не найдены\n";
}

echo "\n3. Проверка vtiger_crmentity:\n";
$query3 = "SELECT crmid, setype, createdtime FROM vtiger_crmentity WHERE crmid >= 393319 ORDER BY crmid DESC LIMIT 5";
$result3 = $adb->pquery($query3, array());

if ($adb->num_rows($result3) > 0) {
    while ($row = $adb->fetchByAssoc($result3)) {
        echo "   ID: " . $row['crmid'] . 
             ", type: " . $row['setype'] . 
             ", created: " . $row['createdtime'] . "\n";
    }
} else {
    echo "   Записи не найдены\n";
}

echo "\n=== ПРОВЕРКА ЗАВЕРШЕНА ===\n";
?>