Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen der Seite angezeigt.

--- links:gema [22/03/2026 10:57] – Eric Weber
+++ links:gema [05/04/2026 16:00] (aktuell) – Eric Weber
@@ Zeile 1: / Zeile 1: @@
 ====== GEMA-Pauschalvertrag ======
-;;#
-Stand: 22.03.26
-;;#
 ###
@@ Zeile 27: / Zeile 24: @@
   padding:20px;
 }
-/* Input */
 #gema-app input {
@@ Zeile 38: / Zeile 33: @@
   border-radius:6px;
 }
-/* Info */
 #gema-app #info {
   font-weight:bold;
   margin-bottom:15px;
+}
+#gema-app #lastUpdate {
+  margin-bottom:10px;
+  color:#555;
 }
@@ Zeile 185: / Zeile 183: @@
 <input type="text" id="searchInput" placeholder="🔍 Suche...">
+<div id="lastUpdate">Letzte Aktualisierung: lädt...</div>
 <div id="info"></div>
@@ Zeile 201: / Zeile 201: @@
 <tbody></tbody>
 </table>
+</div>
+<div style="text-align: right; margin-top: 16px; font-size: 0.75rem; color: #95a5a6;">
+  Made with <a href="https://claude.ai" target="_blank" style="color: #3498db; text-decoration: none;">claude.ai</a>
+  by <a href="https://www.ericweber.de" target="_blank" style="color: #3498db; text-decoration: none;">Eric Weber</a>
 </div>
@@ Zeile 206: / Zeile 211: @@
 <script>
-/* -------- Google Sheets -------- */
 const sheetURL = "https://docs.google.com/spreadsheets/d/e/2PACX-1vSwWpyG-nbRkwF_0InvmPsBRij8J11wELxBpuX0U_rSYi1e26YdDC8zy5giF_5XYOn7vz9feNopYrwZ/pub?output=csv";
@@ Zeile 213: / Zeile 216: @@
 Papa.parse(sheetURL, {
   download: true,
-  header: true,
+  skipEmptyLines: false,
-  skipEmptyLines: true,
   complete: function(results) {
+    const allRows = results.data;
+    // 👉 F2 = [1][5]
+    const lastUpdate = allRows[1]?.[5] || "kein Datum";
+    document.querySelector("#gema-app #lastUpdate").textContent =
+      "Letzte Aktualisierung: " + lastUpdate;
+    // 👉 Header + Daten trennen
+    const headers = allRows[0];
+    const dataRows = allRows.slice(1);
     const tbody = document.querySelector("#gema-app #schoolTable tbody");
-    results.data.forEach(row => {
+    dataRows.forEach(row => {
+      const rowObj = {};
+      headers.forEach((h, i) => rowObj[h] = row[i]);
       const tr = document.createElement("tr");
       tr.innerHTML = `
-        <td data-label="Schulname">${row.Schulname || ""}</td>
+        <td data-label="Schulname">${rowObj.Schulname || ""}</td>
-        <td data-label="Ort">${row.Ort || ""}</td>
+        <td data-label="Ort">${rowObj.Ort || ""}</td>
-        <td data-label="Schulträger">${row["Schulträger"] || ""}</td>
+        <td data-label="Schulträger">${rowObj["Schulträger"] || ""}</td>
-        <td data-label="GEMA">${getGemaIcon(row.GEMA)}</td>
+        <td data-label="GEMA">${getGemaIcon(rowObj.GEMA)}</td>
       `;
-      tr.dataset.search = Object.values(row).join(" ").toLowerCase();
+      tr.dataset.search = Object.values(rowObj).join(" ").toLowerCase();
       tbody.appendChild(tr);