<?php
require_once('config.php');
global $adb;

// Проверим все поля модуля Project, включая кириллические
$query = "SELECT fieldname, fieldlabel FROM vtiger_field WHERE tabid = (SELECT tabid FROM vtiger_tab WHERE name = 'Project') ORDER BY fieldname";
$result = $adb->pquery($query, array());

echo "All fields for Project module:\n";
while ($row = $adb->fetch_array($result)) {
    $fieldname = $row['fieldname'];
    $fieldlabel = $row['fieldlabel'];
    
    // Ищем поля, которые могут быть связаны с заявителем
    if (stripos($fieldlabel, 'заявитель') !== false || 
        stripos($fieldlabel, 'applicant') !== false ||
        stripos($fieldlabel, 'заяв') !== false ||
        stripos($fieldname, 'cf_1994') !== false ||
        stripos($fieldname, 'сf_1994') !== false) { // кириллическая с
        echo "*** $fieldname - $fieldlabel ***\n";
    }
}

// Также проверим структуру таблицы vtiger_project
echo "\nChecking vtiger_project table structure:\n";
$query2 = "SHOW COLUMNS FROM vtiger_project";
$result2 = $adb->pquery($query2, array());

while ($row2 = $adb->fetch_array($result2)) {
    $field = $row2['Field'];
    if (stripos($field, 'cf_1994') !== false || 
        stripos($field, 'сf_1994') !== false ||
        stripos($field, 'applicant') !== false ||
        stripos($field, 'заяв') !== false) {
        echo "*** $field - " . $row2['Type'] . " ***\n";
    }
}
?>