* Date: 2026-5-30
*/
if (!defined('ROOT_PATH')) { exit('Access Denied'); }
$pageTitle = $channel['channel_name'] ?? '新闻资讯';
require_once __DIR__ . '/../_header.php';
$allChannels = $db->fetchAll("SELECT * FROM {$db->table('channel')} WHERE parent_id = 23 AND channel_type = 1 AND is_show = 1 ORDER BY list_order ASC, id ASC");
$curChannelId = isset($_GET['channel_id']) ? intval($_GET['channel_id']) : 0;
$currentNavId = $curChannelId ?: intval($channel['id'] ?? 0);
$sql = "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";
$params = [];
if ($curChannelId > 0) {
$sql .= " AND a.channel_id = ?";
$params[] = $curChannelId;
}
$sql .= " ORDER BY a.create_time DESC LIMIT 100";
$allArticles = $db->fetchAll($sql, $params);
?>