{"id":1449,"date":"2026-09-13T13:56:07","date_gmt":"2026-09-13T11:56:07","guid":{"rendered":"https:\/\/betterthansilence.de\/radio\/?p=1449"},"modified":"2026-11-01T19:52:04","modified_gmt":"2026-11-01T18:52:04","slug":"allesongs","status":"publish","type":"post","link":"https:\/\/betterthansilence.de\/radio\/allesongs\/","title":{"rendered":"ALLE SONGS AUF EINEN BLICK"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hier findet ihr alle Songs, die wir auf BETTER THAN SILENCE bisher gespielt haben.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ein KLICK auf den Spaltenkopf sortiert so, wie ihr es wollt&#8230;<\/p>\n\n\n\n<style>\n  .music-container {\n    font-family: inherit;\n    font-size: var(--wp--preset--font-size--small, 0.875rem);\n    margin: 20px 0;\n  }\n\n  .music-stats {\n    font-size: 1em;\n    font-weight: 600;\n    margin-bottom: 10px;\n    color: var(--wp--preset--color--primary, #222222);\n  }\n\n  .music-search {\n    width: 100%;\n    padding: 8px 12px;\n    margin-bottom: 12px;\n    border: 1px solid #ccc;\n    border-radius: 5px;\n    font-size: inherit;\n    box-sizing: border-box;\n  }\n\n  .music-table {\n    width: 100%;\n    border-collapse: collapse;\n    margin-top: 10px;\n    font-size: inherit;\n  }\n\n  .music-table th {\n    background-color: var(--wp--preset--color--primary, #222222);\n    color: var(--wp--preset--color--white, #ffffff);\n    padding: 8px 10px;\n    text-align: left;\n    cursor: pointer;\n    user-select: none;\n  }\n\n  .music-table th:hover {\n    opacity: 0.9;\n  }\n\n  .music-table th.sort-asc::after {\n    content: \" \u25b2\";\n    font-size: 0.8em;\n  }\n\n  .music-table th.sort-desc::after {\n    content: \" \u25bc\";\n    font-size: 0.8em;\n  }\n\n  .music-table td {\n    padding: 8px 10px;\n    border-bottom: 1px solid #e0e0e0;\n  }\n\n  .music-table tr:nth-child(even) {\n    background-color: #f9f9f9;\n  }\n\n  .col-center {\n    text-align: center;\n  }\n<\/style>\n\n<div class=\"music-container\">\n  <div id=\"musicStats\" class=\"music-stats\">Lade Statistik&#8230;<\/div>\n\n  <input type=\"text\" id=\"musicSearch\" class=\"music-search\" placeholder=\"\ud83d\udd0d Suche nach Interpret, Titel, Album...\" oninput=\"filterMusicTable()\">\n\n  <table class=\"music-table\">\n    <thead>\n      <tr>\n        <th onclick=\"sortTable('title')\" id=\"th-title\">Titel<\/th>\n        <th onclick=\"sortTable('artist')\" id=\"th-artist\">Interpret<\/th>\n        <th onclick=\"sortTable('album')\" id=\"th-album\">Album<\/th>\n        <th onclick=\"sortTable('playlist')\" id=\"th-playlist\" class=\"col-center\">Sendung<\/th>\n      <\/tr>\n    <\/thead>\n    <tbody id=\"musicTableBody\">\n      <tr><td colspan=\"4\">Lade Musikbibliothek&#8230;<\/td><\/tr>\n    <\/tbody>\n  <\/table>\n<\/div>\n\n<script>\n  const csvUrl =\n    'https:\/\/betterthansilence.de\/wp-content\/uploads\/csv\/MyDeezerLibrary.csv';\n\n  const ausnahmenUrl = new URL('ausnahmen.json', csvUrl).toString();\n\n  let globalData = [];\n  let sortExceptions = new Set();\n  let currentSortKey = '';\n  let currentSortAsc = true;\n\n  function loadPapaParse() {\n    return new Promise((resolve, reject) => {\n      if (window.Papa) {\n        resolve();\n        return;\n      }\n\n      const script = document.createElement('script');\n      script.src =\n        'https:\/\/cdn.jsdelivr.net\/npm\/papaparse@5.4.1\/papaparse.min.js';\n\n      script.onload = () => resolve();\n      script.onerror = () => {\n        reject(new Error('PapaParse konnte nicht geladen werden.'));\n      };\n\n      document.head.appendChild(script);\n    });\n  }\n\n  async function loadSortExceptions() {\n    try {\n      const response = await fetch(ausnahmenUrl);\n\n      if (!response.ok) {\n        throw new Error('HTTP Fehler: ' + response.status);\n      }\n\n      const names = await response.json();\n\n      if (!Array.isArray(names)) {\n        throw new Error('ausnahmen.json muss ein JSON-Array enthalten.');\n      }\n\n      return new Set(\n        names\n          .filter(name => typeof name === 'string')\n          .map(name =>\n            name.trim()\n              .replace(\/\\u00A0\/g, ' ')\n              .toLocaleLowerCase('de-DE')\n          )\n      );\n    } catch (error) {\n      console.warn(\n        'Ausnahmedatei konnte nicht geladen werden; es gelten keine Ausnahmen:',\n        error\n      );\n      return new Set();\n    }\n  }\n\n  function getValue(row, keys) {\n    for (const key of keys) {\n      if (row[key] !== undefined && row[key] !== null) {\n        return row[key];\n      }\n    }\n\n    return '';\n  }\n\n  function getTitle(row) {\n    return getValue(row, ['Track name', 'Titel', 'Title', 'Track']);\n  }\n\n  function getArtist(row) {\n    return getValue(row, ['Artist name', 'Interpret', 'Artist']);\n  }\n\n  function getAlbum(row) {\n    return getValue(row, ['Album', 'Album name']);\n  }\n\n  function getPlaylistValue(row) {\n    return getValue(row, [\n      'Playlist name',\n      'Playlist-Nummer',\n      'Sendung',\n      'Playlist'\n    ]);\n  }\n\n  function extractPlaylistNumber(value) {\n    if (!value) return '';\n\n    const match = String(value).match(\/(?:#|NI)?\\s*(\\d+)\/i);\n    return match ? parseInt(match[1], 10) : value;\n  }\n\n  function getArtistSortKey(artist) {\n  const name = String(artist || '')\n    .replace(\/^\\uFEFF\/, '') \/\/ entfernt gegebenenfalls ein unsichtbares BOM-Zeichen\n    .trim();\n\n  const normalizedName = name\n    .replace(\/\\s+\/gu, ' ')\n    .toLocaleLowerCase('de-DE');\n\n  if (sortExceptions.has(normalizedName)) {\n    return name;\n  }\n\n  \/\/ \\s+ erkennt verschiedene Leerzeichen und auch mehrere davon.\n  \/\/ Der Artikel wird weiterhin nur entfernt, wenn danach Leerraum folgt.\n  return name.replace(\/^(?:the|die|der|das|a)\\s+\/iu, '').trim();\n}\n\n\n  function updateStats() {\n    const sendungenSet = new Set();\n\n    globalData.forEach(row => {\n      const sendung = extractPlaylistNumber(getPlaylistValue(row));\n\n      if (sendung !== '') {\n        sendungenSet.add(sendung);\n      }\n    });\n\n    const statsElem = document.getElementById('musicStats');\n\n    if (globalData.length > 0) {\n      statsElem.innerHTML =\n        `\ud83c\udfb5 <strong>${globalData.length} Songs<\/strong> aus ` +\n        `<strong>${sendungenSet.size} Sendungen<\/strong>`;\n    } else {\n      statsElem.innerHTML = '';\n    }\n  }\n\n  function renderData(data) {\n    const tbody = document.getElementById('musicTableBody');\n    tbody.replaceChildren();\n\n    if (!data || data.length === 0) {\n      const tr = document.createElement('tr');\n      const td = document.createElement('td');\n      td.colSpan = 4;\n      td.textContent = 'Keine Daten gefunden.';\n      tr.appendChild(td);\n      tbody.appendChild(tr);\n      return;\n    }\n\n    data.forEach(row => {\n      const title = String(getTitle(row));\n      const artist = String(getArtist(row));\n      const album = String(getAlbum(row));\n      const playlistNum = extractPlaylistNumber(getPlaylistValue(row));\n\n      if (!title && !artist) return;\n\n      const tr = document.createElement('tr');\n\n      const titleCell = document.createElement('td');\n      const titleStrong = document.createElement('strong');\n      titleStrong.textContent = title;\n      titleCell.appendChild(titleStrong);\n\n      const artistCell = document.createElement('td');\n      artistCell.textContent = artist;\n\n      const albumCell = document.createElement('td');\n      albumCell.textContent = album;\n\n      const playlistCell = document.createElement('td');\n      playlistCell.className = 'col-center';\n      playlistCell.textContent = String(playlistNum);\n\n      tr.append(titleCell, artistCell, albumCell, playlistCell);\n      tbody.appendChild(tr);\n    });\n\n    filterMusicTable();\n  }\n\n  function sortTable(key) {\n    if (currentSortKey === key) {\n      currentSortAsc = !currentSortAsc;\n    } else {\n      currentSortKey = key;\n      currentSortAsc = true;\n    }\n\n    document.querySelectorAll('.music-table th').forEach(th => {\n      th.classList.remove('sort-asc', 'sort-desc');\n    });\n\n    const activeHeader = document.getElementById('th-' + key);\n\n    if (activeHeader) {\n      activeHeader.classList.add(\n        currentSortAsc ? 'sort-asc' : 'sort-desc'\n      );\n    }\n\n    globalData.sort((a, b) => {\n      let valA;\n      let valB;\n\n      if (key === 'artist') {\n        valA = getArtistSortKey(getArtist(a));\n        valB = getArtistSortKey(getArtist(b));\n      } else if (key === 'title') {\n        valA = getTitle(a);\n        valB = getTitle(b);\n      } else if (key === 'album') {\n        valA = getAlbum(a);\n        valB = getAlbum(b);\n      } else {\n        valA = extractPlaylistNumber(getPlaylistValue(a));\n        valB = extractPlaylistNumber(getPlaylistValue(b));\n\n        if (typeof valA === 'number' && typeof valB === 'number') {\n          return currentSortAsc ? valA - valB : valB - valA;\n        }\n      }\n\n      const comparison = String(valA).localeCompare(\n        String(valB),\n        'de',\n        { numeric: true, sensitivity: 'base' }\n      );\n\n      return currentSortAsc ? comparison : -comparison;\n    });\n\n    renderData(globalData);\n  }\n\n  function filterMusicTable() {\n    const filter = document\n      .getElementById('musicSearch')\n      .value\n      .toLowerCase()\n      .trim();\n\n    const rows = document.querySelectorAll('#musicTableBody tr');\n    let visibleCount = 0;\n\n    rows.forEach(row => {\n      const matches = row.innerText.toLowerCase().includes(filter);\n      row.style.display = matches ? '' : 'none';\n\n      if (matches) {\n        visibleCount++;\n      }\n    });\n\n    const statsElem = document.getElementById('musicStats');\n\n    if (filter !== '') {\n      statsElem.innerHTML =\n        `\ud83d\udd0d Zeige <strong>${visibleCount} von ${globalData.length} Songs<\/strong>`;\n    } else {\n      updateStats();\n    }\n  }\n\n  async function initMusicTable() {\n    try {\n      await loadPapaParse();\n      sortExceptions = await loadSortExceptions();\n\n      const response = await fetch(csvUrl);\n\n      if (!response.ok) {\n        throw new Error('HTTP Fehler: ' + response.status);\n      }\n\n      const csvText = await response.text();\n\n      Papa.parse(csvText, {\n        header: true,\n        skipEmptyLines: true,\n\n        complete: function(results) {\n          globalData = results.data.filter(row => {\n            return getTitle(row) || getArtist(row);\n          });\n\n          updateStats();\n          sortTable('artist');\n        },\n\n        error: function(error) {\n          console.error('CSV-Fehler:', error);\n          showLoadError();\n        }\n      });\n    } catch (error) {\n      console.error('Fehler beim Laden:', error);\n      showLoadError();\n    }\n  }\n\n  function showLoadError() {\n    const tbody = document.getElementById('musicTableBody');\n    const tr = document.createElement('tr');\n    const td = document.createElement('td');\n\n    td.colSpan = 4;\n    td.style.color = 'red';\n    td.textContent = 'Fehler beim Laden der CSV-Datei.';\n\n    tr.appendChild(td);\n    tbody.replaceChildren(tr);\n    document.getElementById('musicStats').textContent = '';\n  }\n\n  initMusicTable();\n<\/script>\n","protected":false},"excerpt":{"rendered":"<p>Hier findet ihr alle Songs, die wir auf BETTER THAN SILENCE bisher gespielt haben. Ein KLICK auf den Spaltenkopf sortiert so, wie ihr es wollt&#8230; Lade Statistik&#8230; Titel Interpret Album Sendung Lade Musikbibliothek&#8230;<\/p>\n","protected":false},"author":1,"featured_media":49,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-1449","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-beitrag"],"_links":{"self":[{"href":"https:\/\/betterthansilence.de\/radio\/wp-json\/wp\/v2\/posts\/1449","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/betterthansilence.de\/radio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/betterthansilence.de\/radio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/betterthansilence.de\/radio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/betterthansilence.de\/radio\/wp-json\/wp\/v2\/comments?post=1449"}],"version-history":[{"count":9,"href":"https:\/\/betterthansilence.de\/radio\/wp-json\/wp\/v2\/posts\/1449\/revisions"}],"predecessor-version":[{"id":1781,"href":"https:\/\/betterthansilence.de\/radio\/wp-json\/wp\/v2\/posts\/1449\/revisions\/1781"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/betterthansilence.de\/radio\/wp-json\/wp\/v2\/media\/49"}],"wp:attachment":[{"href":"https:\/\/betterthansilence.de\/radio\/wp-json\/wp\/v2\/media?parent=1449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/betterthansilence.de\/radio\/wp-json\/wp\/v2\/categories?post=1449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/betterthansilence.de\/radio\/wp-json\/wp\/v2\/tags?post=1449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}