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; $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"; $recruitList = $db->fetchAll($sql, $params); ?>

📌 部门： 📍 工作地点： 💼 工作性质：

📅 经验要求： 🎓 学历要求： 👥 招聘人数：人

暂无招聘信息