escapeIdentifier($field['field_name']) * * @changelog: * - 1.0.0 ('git' is not recognized as an internal or external command, operable program or batch file.): Initial version */ require_once 'includes/autoload.php'; use App\Database; // 初始化应用程序 if (!initializeApplication()) { die("系统初始化失败"); } $db = Database::getInstance(); // 获取系统配置 - 优化查询，一次性获取所有需要的配置 $configKeys = ['site_title', 'theme_color', 'theme_style', 'site_footer', 'default_page_size']; $placeholders = array_fill(0, count($configKeys), '?'); $configs = $db->fetchAll( "SELECT config_key, config_value FROM sys_configs WHERE config_key IN (" . implode(',', $placeholders) . ")", $configKeys ); // 构建配置映射 $siteConfig = []; foreach ($configs as $config) { $siteConfig[$config['config_key']] = $config['config_value']; } // 设置默认值 $siteTitle = $siteConfig['site_title'] ?? '通用查询系统'; $themeColor = $siteConfig['theme_color'] ?? '#667eea'; $themeStyle = $siteConfig['theme_style'] ?? 'gradient'; $siteFooter = $siteConfig['site_footer'] ?? '© 2025 通用查询系统 All Rights Reserved'; $pageSize = intval($siteConfig['default_page_size'] ?? 10); // 生成渐变色（如果是渐变风格） $gradientColor2 = '#764ba2'; // 默认渐变色 if ($themeStyle === 'gradient') { // 根据主题色生成渐变色 $rgb = sscanf($themeColor, "#%02x%02x%02x"); if ($rgb) { $r = max(0, min(255, $rgb[0] + 20)); $g = max(0, min(255, $rgb[1] - 20)); $b = max(0, min(255, $rgb[2] + 30)); $gradientColor2 = sprintf("#%02x%02x%02x", $r, $g, $b); } } // 获取可用的数据表 - 优化查询，使用JOIN一次性获取所有信息 $tables = $db->fetchAll(" SELECT t.id, t.table_name, t.table_title, t.table_description, COUNT(f.id) as field_count FROM data_tables t LEFT JOIN data_fields f ON t.id = f.table_id WHERE t.show_in_homepage = 1 AND t.is_active = 1 GROUP BY t.id ORDER BY t.sort_order ASC, t.created_at DESC "); // 处理查询请求 $searchResults = []; $searchTableId = 0; $searchTableInfo = null; $searchFields = []; $totalRecords = 0; $currentPage = 1; if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['search_table_id'])) { $searchTableId = intval($_POST['search_table_id']); // 获取表信息和字段配置 - 优化：使用一次查询获取所有需要的信息 $tableData = $db->fetchAll(" SELECT t.id as table_id, t.table_name, t.table_title, t.table_description, f.id as field_id, f.field_name, f.field_title, f.field_type, f.field_length, f.is_searchable, f.is_displayable, f.sort_order, f.validation_rules, f.placeholder_text, f.help_text, f.input_type, f.is_required, f.options FROM data_tables t LEFT JOIN data_fields f ON t.id = f.table_id WHERE t.id = ? AND t.show_in_homepage = 1 AND t.is_active = 1 ORDER BY f.sort_order, f.id ", [$searchTableId]); if (!empty($tableData)) { // 提取表信息 $searchTableInfo = [ 'id' => $tableData[0]['table_id'], 'table_name' => $tableData[0]['table_name'], 'table_title' => $tableData[0]['table_title'], 'table_description' => $tableData[0]['table_description'] ]; // 提取字段信息 $tableFields = []; foreach ($tableData as $row) { if ($row['field_id']) { $tableFields[] = [ 'id' => $row['field_id'], 'field_name' => $row['field_name'], 'field_title' => $row['field_title'], 'field_type' => $row['field_type'], 'field_length' => $row['field_length'], 'is_searchable' => $row['is_searchable'], 'is_displayable' => $row['is_displayable'], 'sort_order' => $row['sort_order'], 'validation_rules' => $row['validation_rules'], 'placeholder_text' => $row['placeholder_text'], 'help_text' => $row['help_text'], 'input_type' => $row['input_type'], 'is_required' => $row['is_required'], 'options' => $row['options'] ]; } } $searchTable = $searchTableInfo['table_name']; // 构建查询条件 $whereConditions = []; $params = []; $hasValidSearch = false; // 清除之前的验证错误 unset($_SESSION['validation_errors']); foreach ($tableFields as $field) { if ($field['is_searchable'] && !empty($_POST[$field['field_name']])) { $value = cleanInput($_POST[$field['field_name']]); // 后端数据验证 $isValid = true; $errorMsg = ''; // 类型验证 switch ($field['field_type']) { case 'int': case 'integer': case 'bigint': case 'tinyint': case 'smallint': case 'mediumint': if (!is_numeric($value)) { $isValid = false; $errorMsg = $field['field_title'] . ' 必须是数字'; } break; case 'float': case 'double': case 'decimal': if (!is_numeric($value)) { $isValid = false; $errorMsg = $field['field_title'] . ' 必须是数字'; } break; case 'varchar': case 'char': if ($field['field_length'] && mb_strlen($value) > $field['field_length']) { $isValid = false; $errorMsg = $field['field_title'] . ' 长度不能超过 ' . $field['field_length'] . ' 个字符'; } break; } if (!$isValid) { // 记录验证错误 if (!isset($_SESSION['validation_errors'])) { $_SESSION['validation_errors'] = []; } $_SESSION['validation_errors'][$field['field_name']] = $errorMsg; continue; } // 精确查询 $whereConditions[] = $db->escapeIdentifier($field['field_name']) . " = ?"; $params[] = $value; $hasValidSearch = true; } } if ($hasValidSearch && !empty($whereConditions)) { // 获取显示字段 $displayFields = array_filter($tableFields, function($field) { return $field['is_displayable']; }); // 构建查询字段列表 $selectFields = array_map(function($field) use ($db) { return $db->escapeIdentifier($field['field_name']); }, $displayFields); // 如果没有显示字段，至少显示主键 if (empty($selectFields)) { $selectFields = ['*']; } else { $selectSql = implode(', ', $selectFields); } $whereSql = implode(' AND ', $whereConditions); // 分页处理 - 使用优化的分页服务 $currentPage = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1; // 使用查询构建器优化查询 $queryBuilder = $db->createQueryBuilder($searchTable); // 添加查询条件 foreach ($tableFields as $field) { if ($field['is_searchable'] && !empty($_POST[$field['field_name']])) { $value = cleanInput($_POST[$field['field_name']]); if (!isset($_SESSION['validation_errors'][$field['field_name']])) { $queryBuilder->where($field['field_name'], '=', $value); } } } // 设置查询字段 if (!empty($selectFields) && $selectFields[0] !== '*') { $queryBuilder->select(array_map(function($field) { return $field['field_name']; }, $displayFields)); } // 使用高性能分页查询 $paginationResult = $queryBuilder->paginate($currentPage, $pageSize, 'auto'); $searchResults = $paginationResult['data']; $totalRecords = $paginationResult['pagination']['total']; $searchFields = $displayFields; // 验证实际结果数量，确保统计准确性 if (!empty($searchResults)) { $actualCount = count($searchResults); // 如果是第一页且结果数量与总数不符，重新计算总数 if ($currentPage == 1 && $actualCount > 0) { // 构建相同的查询条件来重新计算总数 $countQuery = "SELECT COUNT(*) as total FROM `{$searchTable}` WHERE {$whereSql}"; $countResult = $db->fetchOne($countQuery, $params); if ($countResult && $countResult['total'] != $totalRecords) { $totalRecords = $countResult['total']; } } } // 记录查询日志 $db->logAction('FRONTEND_SEARCH', $searchTable, "前台查询表: {$searchTable}, 找到 {$totalRecords} 条记录"); } } } // 获取搜索字段 - 优化：缓存查询结果 $searchableFields = []; if ($searchTableId > 0) { // 使用之前查询的数据，避免重复查询 if (!empty($tableFields)) { $searchableFields = array_filter($tableFields, function($field) { return $field['is_searchable']; }); } else { // 如果没有POST请求，才需要查询 $searchableFields = $db->fetchAll(" SELECT f.* FROM data_fields f INNER JOIN data_tables t ON f.table_id = t.id WHERE f.table_id = ? AND f.is_searchable = 1 AND t.show_in_homepage = 1 AND t.is_active = 1 ORDER BY f.sort_order ", [$searchTableId]); } } // 获取验证错误 $validationErrors = $_SESSION['validation_errors'] ?? []; unset($_SESSION['validation_errors']); ?> <?= htmlspecialchars($siteTitle) ?>
查询条件
style="display: none;">
字段
暂无可用的查询表
使用精确查询，请输入完整信息
data-field-type="" data-field-length=""> > data-field-type="" data-field-length="">
查询结果
共找到 条记录 | 第 / 页
$row): ?>
记录 #
：
1): require_once 'classes/Components/PaginationComponent.php'; $paginationComponent = new \App\Components\PaginationComponent( $paginationResult['pagination'], $_SERVER['REQUEST_URI'], $_GET ); echo '
'; echo $paginationComponent->render([ 'show_info' => true, 'show_jump' => true, 'show_size_selector' => true, 'range' => 2 ]); echo '
'; endif; ?>
未找到符合条件的记录，请检查输入信息是否准确

请先选择查询表并输入查询条件

系统中暂无可用的查询表，请联系管理员配置