<?php
/**
 * 芋头CMS
 * ============================================================================
 * 版权所有 2016-2028 沅陵县乌托邦网络服务有限公司，并保留所有权利。
 * 网站地址: http://www.yutoucms.cn
 * ----------------------------------------------------------------------------
 * 如果商业用途务必到官方购买正版授权, 以免引起不必要的法律纠纷.
 * ============================================================================
 * Author: 芋头 <mxgsf@qq.com>
 * Date: 2026-5-20
 */
if (!defined('ROOT_PATH')) { exit('Access Denied'); }
require_once __DIR__ . '/../_functions.php';

if (empty($channel) && !empty($id)) {
    $channel = $db->fetch("SELECT * FROM {$db->table('channel')} WHERE id = ? AND is_show = 1 LIMIT 1", [intval($id)]);
}
if (empty($channel)) {
    echo 'Channel not found';
    return;
}

$pageTitle = (string) ($channel['channel_name'] ?? '栏目列表');
$channelType = intval($channel['channel_type'] ?? 1);
$topChannel = intval($channel['parent_id'] ?? 0) > 0 ? k607_channel_by_id($db, intval($channel['parent_id'])) : $channel;
if (!$topChannel) {
    $topChannel = $channel;
}
$sideChannels = k607_sibling_channels($db, $channel);
if (empty($sideChannels)) {
    $sideChannels = $db->fetchAll("SELECT * FROM {$db->table('channel')} WHERE channel_type = ? AND is_show = 1 ORDER BY list_order ASC, id ASC", [$channelType]);
}
$heroImage = k607_channel_hero_image($topChannel, !empty($slides[0]['litpic']) ? $slides[0]['litpic'] : '');
$currentPage = max(1, intval($_GET['page'] ?? 1));
$filterChannelId = intval($_GET['channel_id'] ?? 0);
$targetChannelId = $filterChannelId > 0 ? $filterChannelId : intval($channel['id']);
$pageSize = in_array($channelType, [1, 5, 9], true) ? 8 : 9;
$baseUrl = getUrl('channel', intval($channel['id']), (string) ($channel['channel_dir'] ?? ''));
$items = [];
$total = 0;
$pageContent = '';

switch ($channelType) {
    case 1:
        $queryIds = [intval($targetChannelId)];
        $children = $db->fetchAll("SELECT id FROM {$db->table('channel')} WHERE parent_id = ? AND is_show = 1", [intval($targetChannelId)]);
        foreach ($children as $child) {
            $queryIds[] = intval($child['id']);
        }
        $queryIds = array_values(array_unique(array_filter($queryIds)));
        $ph = implode(',', array_fill(0, count($queryIds), '?'));
        $countRow = $db->fetch("SELECT COUNT(*) AS total FROM {$db->table('article')} WHERE status = 1 AND channel_id IN ({$ph})", $queryIds);
        $total = intval($countRow['total'] ?? 0);
        $offset = ($currentPage - 1) * $pageSize;
        $items = $db->fetchAll("SELECT a.*, c.channel_name FROM {$db->table('article')} a LEFT JOIN {$db->table('channel')} c ON a.channel_id = c.id WHERE a.status = 1 AND a.channel_id IN ({$ph}) ORDER BY a.create_time DESC LIMIT {$offset}, {$pageSize}", $queryIds);
        break;

    case 2:
        $queryIds = [intval($targetChannelId)];
        $children = $db->fetchAll("SELECT id FROM {$db->table('channel')} WHERE parent_id = ? AND is_show = 1", [intval($targetChannelId)]);
        foreach ($children as $child) {
            $queryIds[] = intval($child['id']);
        }
        $queryIds = array_values(array_unique(array_filter($queryIds)));
        $ph = implode(',', array_fill(0, count($queryIds), '?'));
        $countRow = $db->fetch("SELECT COUNT(*) AS total FROM {$db->table('product')} WHERE status = 1 AND channel_id IN ({$ph})", $queryIds);
        $total = intval($countRow['total'] ?? 0);
        $offset = ($currentPage - 1) * $pageSize;
        $items = $db->fetchAll("SELECT p.*, c.channel_name FROM {$db->table('product')} p LEFT JOIN {$db->table('channel')} c ON p.channel_id = c.id WHERE p.status = 1 AND p.channel_id IN ({$ph}) ORDER BY p.create_time DESC LIMIT {$offset}, {$pageSize}", $queryIds);
        break;

    case 3:
        $pageInfo = $db->fetch("SELECT * FROM {$db->table('page')} WHERE channel_id = ? ORDER BY id DESC LIMIT 1", [intval($channel['id'])]);
        $pageContent = (string) ($pageInfo['page_content'] ?? ($pageInfo['content'] ?? ''));
        break;

    case 4:
        $countRow = $db->fetch("SELECT COUNT(*) AS total FROM {$db->table('image')} WHERE status = 1 AND channel_id = ?", [intval($targetChannelId)]);
        $total = intval($countRow['total'] ?? 0);
        $offset = ($currentPage - 1) * $pageSize;
        $items = $db->fetchAll("SELECT * FROM {$db->table('image')} WHERE status = 1 AND channel_id = ? ORDER BY create_time DESC LIMIT {$offset}, {$pageSize}", [intval($targetChannelId)]);
        break;

    case 5:
        $countRow = $db->fetch("SELECT COUNT(*) AS total FROM {$db->table('download')} WHERE status = 1 AND channel_id = ?", [intval($targetChannelId)]);
        $total = intval($countRow['total'] ?? 0);
        $offset = ($currentPage - 1) * $pageSize;
        $items = $db->fetchAll("SELECT * FROM {$db->table('download')} WHERE status = 1 AND channel_id = ? ORDER BY create_time DESC LIMIT {$offset}, {$pageSize}", [intval($targetChannelId)]);
        break;

    case 7:
        $countRow = $db->fetch("SELECT COUNT(*) AS total FROM {$db->table('video')} WHERE status = 1 AND channel_id = ?", [intval($targetChannelId)]);
        $total = intval($countRow['total'] ?? 0);
        $offset = ($currentPage - 1) * $pageSize;
        $items = $db->fetchAll("SELECT * FROM {$db->table('video')} WHERE status = 1 AND channel_id = ? ORDER BY create_time DESC LIMIT {$offset}, {$pageSize}", [intval($targetChannelId)]);
        break;

    case 9:
        $countRow = $db->fetch("SELECT COUNT(*) AS total FROM {$db->table('recruit')} WHERE status = 1 AND channel_id = ?", [intval($targetChannelId)]);
        $total = intval($countRow['total'] ?? 0);
        $offset = ($currentPage - 1) * $pageSize;
        $items = $db->fetchAll("SELECT r.*, c.channel_name FROM {$db->table('recruit')} r LEFT JOIN {$db->table('channel')} c ON r.channel_id = c.id WHERE r.status = 1 AND r.channel_id = ? ORDER BY r.create_time DESC LIMIT {$offset}, {$pageSize}", [intval($targetChannelId)]);
        break;

    default:
        $countRow = $db->fetch("SELECT COUNT(*) AS total FROM {$db->table('article')} WHERE status = 1 AND channel_id = ?", [intval($targetChannelId)]);
        $total = intval($countRow['total'] ?? 0);
        $offset = ($currentPage - 1) * $pageSize;
        $items = $db->fetchAll("SELECT a.*, c.channel_name FROM {$db->table('article')} a LEFT JOIN {$db->table('channel')} c ON a.channel_id = c.id WHERE a.status = 1 AND a.channel_id = ? ORDER BY a.create_time DESC LIMIT {$offset}, {$pageSize}", [intval($targetChannelId)]);
        break;
}

$totalPages = max(1, (int) ceil($total / max($pageSize, 1)));

require_once __DIR__ . '/../_header.php';
?>

<section class="inner-hero">
    <div class="bg" style="background-image:url('<?php echo htmlspecialchars($heroImage !== '' ? $heroImage : 'https://picsum.photos/1600/560?random=701'); ?>');"></div>
    <div class="wrap">
        <span class="label"><?php echo htmlspecialchars(k607_plain_keyword($topChannel['channel_name'] ?? $pageTitle)); ?></span>
        <h1><?php echo htmlspecialchars($pageTitle); ?></h1>
        <p><?php echo htmlspecialchars($companyIntro !== '' ? k607_excerpt($companyIntro, 88) : ($siteDescription !== '' ? $siteDescription : '栏目内容由 CMS 后台自动输出。')); ?></p>
    </div>
</section>

<section class="inner-page">
    <div class="crumbs">当前位置：<a href="<?php echo getUrl('home'); ?>">首页</a> / <span><?php echo htmlspecialchars($pageTitle); ?></span></div>
    <div class="page-grid">
        <aside class="side-menu">
            <h3><?php echo htmlspecialchars($topChannel['channel_name'] ?? $pageTitle); ?></h3>
            <div class="links">
                <?php foreach ($sideChannels as $nav): ?>
                <?php
                $navUrl = getUrl('channel', intval($nav['id']), (string) ($nav['channel_dir'] ?? ''));
                $isActive = intval($nav['id']) === intval($channel['id']) || intval($nav['id']) === $filterChannelId;
                ?>
                <a href="<?php echo $navUrl; ?>" class="<?php echo $isActive ? 'active' : ''; ?>">
                    <span><?php echo htmlspecialchars($nav['channel_name']); ?></span>
                    <span>+</span>
                </a>
                <?php endforeach; ?>
            </div>
        </aside>

        <div class="content-panel">
            <?php if ($channelType === 3): ?>
            <div class="content-entry"><?php echo $pageContent !== '' ? $pageContent : '<div class="empty-box">暂无内容</div>'; ?></div>
            <?php elseif (in_array($channelType, [2, 4, 7], true)): ?>
                <?php if (!empty($items)): ?>
                <div class="card-grid">
                    <?php foreach ($items as $item): ?>
                    <?php
                    $detailType = $channelType === 2 ? 'product' : ($channelType === 4 ? 'image' : 'video');
                    $image = (string) ($item['litpic'] ?? ($item['video_cover'] ?? ''));
                    $metaText = $channelType === 2 && !empty($item['price']) ? '参考价：' . number_format((float) $item['price'], 2) : k607_format_date($item['create_time']);
                    ?>
                    <a class="list-card" href="<?php echo getUrl($detailType, intval($item['id'])); ?>">
                        <div class="img">
                            <img src="<?php echo htmlspecialchars($image !== '' ? $image : 'https://picsum.photos/800/600?random=' . intval($item['id'])); ?>" alt="<?php echo htmlspecialchars($item['title']); ?>">
                        </div>
                        <div class="info">
                            <div class="title"><?php echo htmlspecialchars($item['title']); ?></div>
                            <div class="desc"><?php echo htmlspecialchars(k607_excerpt(($item['summary'] ?? '') !== '' ? $item['summary'] : ($item['content'] ?? ''), 52)); ?></div>
                            <div class="meta"><?php echo htmlspecialchars($metaText); ?></div>
                        </div>
                    </a>
                    <?php endforeach; ?>
                </div>
                <?php else: ?>
                <div class="empty-box">暂无内容</div>
                <?php endif; ?>
            <?php elseif ($channelType === 5): ?>
                <?php if (!empty($items)): ?>
                <div class="news-rows">
                    <?php foreach ($items as $item): ?>
                    <div class="news-row">
                        <div class="img">
                            <img src="<?php echo htmlspecialchars(!empty($item['litpic']) ? $item['litpic'] : 'https://picsum.photos/800/520?random=' . intval($item['id'])); ?>" alt="<?php echo htmlspecialchars($item['title']); ?>">
                        </div>
                        <div class="text">
                            <div class="title"><a href="<?php echo getUrl('download', intval($item['id'])); ?>"><?php echo htmlspecialchars($item['title']); ?></a></div>
                            <div class="meta"><?php echo htmlspecialchars(k607_format_date($item['create_time'])); ?></div>
                            <div class="desc"><?php echo htmlspecialchars(k607_excerpt($item['content'] ?? '', 88)); ?></div>
                            <div class="detail-actions">
                                <a class="btn-primary" href="<?php echo getUrl('download', intval($item['id'])); ?>">查看详情</a>
                            </div>
                        </div>
                    </div>
                    <?php endforeach; ?>
                </div>
                <?php else: ?>
                <div class="empty-box">暂无下载内容</div>
                <?php endif; ?>
            <?php elseif ($channelType === 9): ?>
                <?php if (!empty($items)): ?>
                <div class="news-rows">
                    <?php foreach ($items as $item): ?>
                    <div class="recruit-card">
                        <div class="recruit-card-head">
                            <div>
                                <h3><a href="<?php echo getUrl('recruit', intval($item['id'])); ?>"><?php echo htmlspecialchars($item['title']); ?></a></h3>
                                <p><?php echo htmlspecialchars($item['channel_name'] ?? ($channel['channel_name'] ?? '招聘信息')); ?></p>
                            </div>
                            <div class="salary"><?php echo htmlspecialchars((string) ($item['salary'] ?? '面议')); ?></div>
                        </div>
                        <div class="recruit-card-meta">
                            <?php if (!empty($item['department'])): ?><span>部门：<?php echo htmlspecialchars($item['department']); ?></span><?php endif; ?>
                            <?php if (!empty($item['region'])): ?><span>地点：<?php echo htmlspecialchars($item['region']); ?></span><?php endif; ?>
                            <?php if (!empty($item['education'])): ?><span>学历：<?php echo htmlspecialchars($item['education']); ?></span><?php endif; ?>
                            <?php if (!empty($item['experience'])): ?><span>经验：<?php echo htmlspecialchars($item['experience']); ?></span><?php endif; ?>
                        </div>
                        <div class="recruit-card-desc"><?php echo htmlspecialchars(k607_excerpt($item['content'] ?? '', 96)); ?></div>
                        <div class="detail-actions">
                            <a class="btn-primary" href="<?php echo getUrl('recruit', intval($item['id'])); ?>">查看职位</a>
                            <a class="btn-secondary" href="<?php echo getUrl('guestbook'); ?>">在线咨询</a>
                        </div>
                    </div>
                    <?php endforeach; ?>
                </div>
                <?php else: ?>
                <div class="empty-box">暂无招聘信息</div>
                <?php endif; ?>
            <?php else: ?>
                <?php if (!empty($items)): ?>
                <div class="news-rows">
                    <?php foreach ($items as $item): ?>
                    <div class="news-row">
                        <div class="img">
                            <img src="<?php echo htmlspecialchars(!empty($item['litpic']) ? $item['litpic'] : 'https://picsum.photos/900/560?random=' . intval($item['id'])); ?>" alt="<?php echo htmlspecialchars($item['title']); ?>">
                        </div>
                        <div class="text">
                            <div class="title"><a href="<?php echo getUrl('article', intval($item['id'])); ?>"><?php echo htmlspecialchars($item['title']); ?></a></div>
                            <div class="meta"><?php echo htmlspecialchars(($item['channel_name'] ?? '') . ($item['channel_name'] ? ' / ' : '') . k607_format_date($item['create_time'])); ?></div>
                            <div class="desc"><?php echo htmlspecialchars(k607_excerpt(($item['summary'] ?? '') !== '' ? $item['summary'] : ($item['content'] ?? ''), 96)); ?></div>
                        </div>
                    </div>
                    <?php endforeach; ?>
                </div>
                <?php else: ?>
                <div class="empty-box">暂无内容</div>
                <?php endif; ?>
            <?php endif; ?>

            <?php if ($channelType !== 3 && $totalPages > 1): ?>
            <div class="pagination">
                <?php if ($currentPage > 1): ?>
                <a href="<?php echo htmlspecialchars(k607_url_with_query($baseUrl, ['channel_id' => $filterChannelId ?: null, 'page' => $currentPage - 1])); ?>">上一页</a>
                <?php endif; ?>
                <span><?php echo $currentPage; ?> / <?php echo $totalPages; ?></span>
                <?php if ($currentPage < $totalPages): ?>
                <a href="<?php echo htmlspecialchars(k607_url_with_query($baseUrl, ['channel_id' => $filterChannelId ?: null, 'page' => $currentPage + 1])); ?>">下一页</a>
                <?php endif; ?>
            </div>
            <?php endif; ?>
        </div>
    </div>
</section>

<?php require_once __DIR__ . '/../_footer.php'; ?>