* Date: 2026-5-30
*/
if (!defined('ROOT_PATH')) { exit('Access Denied'); }
$pageTitle = '人才招聘';
$allChannels = $db->fetchAll("SELECT * FROM {$db->table('channel')} WHERE channel_type = 9 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 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";
$params = [];
if ($curChannelId > 0) { $sql .= " AND r.channel_id = ?"; $params[] = $curChannelId; }
$sql .= " ORDER BY r.create_time DESC LIMIT 100";
$recruitList = $db->fetchAll($sql, $params);
require_once __DIR__ . '/../_header.php';
?>