<?php
// 数据库连接
$db = new mysqli('127.0.0.1', 'yilesup', 'kol@666@66GLS', 'yilesup', 3306);
if ($db->connect_error) {
    die("连接失败: " . $db->connect_error);
}

// 获取当前页码
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$perPage = 12;
$offset = ($page - 1) * $perPage;

// 获取总产品数
$totalResult = $db->query("SELECT COUNT(*) as total FROM goods");
$total = $totalResult->fetch_assoc()['total'];
$totalPages = ceil($total / $perPage);

// 获取产品列表
$result = $db->query("SELECT * FROM goods ORDER BY id DESC LIMIT $offset, $perPage");

// 获取网站配置
$config = $db->query("SELECT * FROM config WHERE id = 1")->fetch_assoc();

// 设置独立的样式
$siteName = $config['site_name'] ?? '产品展示';
$logo = $config['logo'] ?? '/static/images/logo.png';
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>产品展示 - <?php echo $siteName; ?></title>
    <link rel="stylesheet" href="/static/css/main.css">
    <style>
        /* 产品列表页面特定样式 */
        .product-container {
            max-width: 1200px;
            margin: 80px auto 0;
            padding: 20px;
        }
        
        .product-grid {
            display: grid;
            grid-template-columns: repeat(auto-fill, minmax(280px, 1fr));
            gap: 20px;
            margin-top: 20px;
        }
        
        .product-card {
            background: #fff;
            border-radius: 8px;
            overflow: hidden;
            box-shadow: 0 2px 8px rgba(0,0,0,0.1);
            transition: transform 0.3s ease;
        }
        
        .product-card:hover {
            transform: translateY(-5px);
        }
        
        .product-image {
            width: 100%;
            height: 200px;
            object-fit: cover;
        }
        
        .product-info {
            padding: 15px;
        }
        
        .product-title {
            font-size: 16px;
            font-weight: 600;
            margin-bottom: 10px;
            color: var(--primary-color);
        }
        
        .product-price {
            font-size: 18px;
            color: #ff4d4f;
            font-weight: bold;
            margin-bottom: 10px;
        }
        
        .product-description {
            color: var(--text-color);
            font-size: 14px;
            line-height: 1.5;
            margin-bottom: 15px;
        }
        
        .product-link {
            display: inline-block;
            padding: 8px 15px;
            background: var(--secondary-color);
            color: #fff;
            text-decoration: none;
            border-radius: 4px;
            transition: background 0.3s ease;
        }
        
        .product-link:hover {
            background: var(--primary-color);
        }
        
        .pagination {
            display: flex;
            justify-content: center;
            margin-top: 30px;
            gap: 10px;
        }
        
        .pagination a {
            display: inline-block;
            padding: 8px 15px;
            background: #fff;
            color: var(--primary-color);
            text-decoration: none;
            border-radius: 4px;
            border: 1px solid var(--border-color);
        }
        
        .pagination a.active {
            background: var(--secondary-color);
            color: #fff;
            border-color: var(--secondary-color);
        }
        
        .pagination a:hover:not(.active) {
            background: var(--light-gray);
        }

        /* 搜索框样式 */
        .search-container {
            max-width: 600px;
            margin: 20px auto;
            padding: 20px;
            background: #fff;
            border-radius: 8px;
            box-shadow: 0 2px 8px rgba(0,0,0,0.1);
        }

        .search-form {
            display: flex;
            gap: 10px;
        }

        .search-input {
            flex: 1;
            padding: 10px;
            border: 1px solid var(--border-color);
            border-radius: 4px;
            font-size: 16px;
        }

        .search-button {
            padding: 10px 20px;
            background: var(--secondary-color);
            color: #fff;
            border: none;
            border-radius: 4px;
            cursor: pointer;
        }

        .search-button:hover {
            background: var(--primary-color);
        }
    </style>
</head>
<body>
    <!-- 头部导航 -->
    <header class="main-header">
        <div class="header-container">
            <div class="logo">
                <a href="/"><img src="<?php echo $logo; ?>" alt="<?php echo $siteName; ?>"></a>
            </div>
            <nav class="main-nav">
                <ul>
                    <li><a href="/">首页</a></li>
                    <li><a href="/products/" class="active">产品展示</a></li>
                </ul>
            </nav>
        </div>
    </header>

    <!-- 搜索框 -->
    <div class="search-container">
        <form class="search-form" action="/products/search.php" method="get">
            <input type="text" name="q" class="search-input" placeholder="搜索产品...">
            <button type="submit" class="search-button">搜索</button>
        </form>
    </div>

    <!-- 产品列表 -->
    <main class="product-container">
        <div class="product-grid">
            <?php while($product = $result->fetch_assoc()): ?>
            <div class="product-card">
                <?php 
                $images = json_decode($product['image_urls'], true) ?: [];
                $mainImage = $images[0] ?? '/static/images/no-image.png';
                ?>
                <img src="<?php echo htmlspecialchars($mainImage); ?>" alt="<?php echo htmlspecialchars($product['name']); ?>" class="product-image">
                <div class="product-info">
                    <h2 class="product-title"><?php echo htmlspecialchars($product['name']); ?></h2>
                    <div class="product-price">¥<?php echo number_format($product['price'], 2); ?></div>
                    <div class="product-description">
                        <?php echo mb_substr(strip_tags($product['particulars']), 0, 100) . '...'; ?>
                    </div>
                    <a href="/details?id=<?php echo $product['id']; ?>" class="product-link">查看详情</a>
                </div>
            </div>
            <?php endwhile; ?>
        </div>

        <!-- 分页 -->
        <?php if($totalPages > 1): ?>
        <div class="pagination">
            <?php if($page > 1): ?>
                <a href="?page=<?php echo $page - 1; ?>">上一页</a>
            <?php endif; ?>
            
            <?php for($i = 1; $i <= $totalPages; $i++): ?>
                <a href="?page=<?php echo $i; ?>" <?php echo $i == $page ? 'class="active"' : ''; ?>>
                    <?php echo $i; ?>
                </a>
            <?php endfor; ?>
            
            <?php if($page < $totalPages): ?>
                <a href="?page=<?php echo $page + 1; ?>">下一页</a>
            <?php endif; ?>
        </div>
        <?php endif; ?>
    </main>

    <!-- 页脚 -->
    <footer class="main-footer">
        <div class="footer-container">
            <p>© <?php echo date('Y'); ?> <?php echo $siteName; ?>. All rights reserved.</p>
        </div>
    </footer>
</body>
</html> 