<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

require_once '/var/www/fastuser/data/www/crm.clientright.ru/config.inc.php';

$pdo = new PDO(
    "mysql:host={$dbconfig['db_server']};port=3306;dbname={$dbconfig['db_name']};charset=utf8",
    $dbconfig['db_username'],
    $dbconfig['db_password'],
    [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
);

$projectId = 371231;

// Получаем документы проекта
$sql = "SELECT 
    n.notesid,
    n.title,
    n.filename,
    n.filelocationtype,
    n.s3_bucket,
    n.s3_key,
    n.filesize
FROM vtiger_notes n
INNER JOIN vtiger_crmentity e ON e.crmid = n.notesid
INNER JOIN vtiger_senotesrel snr ON snr.notesid = n.notesid
WHERE snr.crmid = ? AND e.deleted = 0
ORDER BY e.createdtime DESC";

$stmt = $pdo->prepare($sql);
$stmt->execute([$projectId]);
$documents = $stmt->fetchAll(PDO::FETCH_ASSOC);

echo "Найдено документов: " . count($documents) . "\n\n";

foreach ($documents as $i => $doc) {
    $num = $i + 1;
    echo "$num. ID: {$doc['notesid']}\n";
    echo "   Название: " . ($doc['title'] ?? 'Нет') . "\n";
    echo "   Тип хранения: " . ($doc['filelocationtype'] ?? 'I') . "\n";
    
    if ($doc['filelocationtype'] == 'E') {
        echo "   S3 Bucket: " . ($doc['s3_bucket'] ?? 'нет') . "\n";
        echo "   S3 Key: " . ($doc['s3_key'] ?? 'нет') . "\n";
    } else {
        echo "   Filename: " . substr($doc['filename'] ?? 'нет', 0, 100) . "\n";
    }
    echo "\n";
}