"use client"; import { uploadCSVAction } from "./actions"; import { JSXElementConstructor, Key, ReactElement, ReactNode, ReactPortal, useEffect, useState } from "react"; import Card from "@/components/Card" import { Input } from "@/components/FormElements"; import { Screens } from "@/components/DatabaseOverview"; interface Songbook { id: number; title: string; language: string; } interface Song { song_id: number; songbook_id: number; song_number: string; title: string; } interface SongInfo { songbook_id: number; songbook_title: string; song_number: string; title: string; } export default function AdminPage() { const [songbooks, setSongbooks] = useState([]); const [selectedSongbookId, setSelectedSongbookId] = useState(""); const [number, setNumber] = useState(""); const [title, setTitle] = useState(""); const [newBookTitle, setNewBookTitle] = useState(""); const [newBookLanguage, setNewBookLanguage] = useState(""); const [uploadStatus, setUploadStatus] = useState(null); const [selectedSong, setSelectedSong] = useState(null); const [songInfos, setSongInfos] = useState([]) async function handleCSVUpload(formData: FormData) { setUploadStatus("Verarbeite..."); const result = await uploadCSVAction(formData); if (result.success) { setUploadStatus(`Erfolg: ${result.message}`); } else { setUploadStatus(`Fehler: ${result.error}`); } } useEffect(() => { if (!selectedSong) { setSongInfos([]); return; } async function fetchSongInfos() { try { const res = await fetch(`/api/songs/${selectedSong?.song_id}`); if (res.ok) { const data = await res.json(); setSongInfos(data); } } catch (error) { console.error("Fehler beim Laden der Songinfos:", error); } } fetchSongInfos(); }, [selectedSong]); useEffect(() => { async function loadSongbooks() { try { const res = await fetch("/api/songbooks"); if (res.ok) { const data = await res.json(); setSongbooks(data); } } catch (error) { console.error("Loading songbooks failed: ", error); } } loadSongbooks(); }, []); const addSong = async () => { if (!selectedSongbookId || !number || !title) { alert("Alle Felder ausfüllen!"); return; } try { // Create song const res1 = await fetch("/api/songs", { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify({ title: title }) }) if (res1.ok) { console.log("Lied erfolgreich erstellt!"); } else { console.log("Lied erstellen fehlgeschlagen!"); } // Attach song to songbook const data = await res1.json() const songId = data.song.id; const res2 = await fetch(`/api/songbooks/${Number(selectedSongbookId)}/songs/${songId}`, { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify({ number: number }) }) if (res2.ok) { console.log("Lied erfolgreich dem Liederbuch zugewiesen!"); } else { console.log("Fehler"); } } catch (error) { console.error("Failed sending current songID:", error); } }; const attachSong = async () => { if (!selectedSongbookId || !number || !selectedSong) { alert("Alle Felder ausfüllen!"); return; } try { const res2 = await fetch(`/api/songbooks/${Number(selectedSongbookId)}/songs/${selectedSong.song_id}`, { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify({ number: number }) }) if (res2.ok) { console.log("Lied erfolgreich dem Liederbuch zugewiesen!"); } else { console.log("Fehler"); } } catch (error) { console.error("Failed sending current songID:", error); } } const removeSong = async () => { if (!selectedSongbookId || !selectedSong) { alert("Alle Felder ausfüllen!"); return; } try { const res = await fetch("/api/songs/remove", { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify({ songbookId: selectedSongbookId, songId: selectedSong.song_id }) }); if (res.ok) { alert("Lied erfolgreich aus dem Liederbuch gelöscht!"); } else { alert("Fehler beim Senden."); } } catch (error) { console.error("Failed sending current songID:", error); } } const addSongbook = async () => { if (!newBookTitle) { alert("Der Title des Liederbuches darf nicht leer sein!"); return; } try { const res = await fetch("/api/songbooks", { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify({ title: newBookTitle, language: newBookLanguage }) }); if (res.ok) { const createdBook = await res.json(); setSongbooks([...songbooks, createdBook]); alert("Liederbuch erfolgreich erstellt!"); setNewBookTitle(""); setNewBookLanguage(""); } else { alert("Failed adding songbook!"); } } catch (error) { console.error("Error: ", error); } }; return (
{/* HEADER */}

Datenbank verwalten, neue Bücher erstellen und Lieder einpflegen

{/* DREISPALTIRES GRID */}
Name des Buchs setNewBookTitle(e.target.value)} />
Sprache (Optional) setNewBookLanguage(e.target.value)} />
Liederbuch erstellen
Liederbuch wählen setSelectedSongbookId(e.target.value)} > {songbooks.map((book) => ( ))}
Nummer setNumber(e.target.value)} />
Titel setTitle(e.target.value)} />
Lied speichern
Ziel-Liederbuch setSelectedSongbookId(e.target.value)} > {songbooks.map((book) => ( ))}
Datei auswählen (.csv)
Hochladen & Verarbeiten {uploadStatus && (

{uploadStatus}

)}
setSelectedSong(song)} className="" />

Lied-ID: {selectedSong?.song_id ?? "-"}

In Liederbüchern:

{songInfos.length > 0 ? (
    {songInfos.map((info) => (
  • {info.songbook_title} (Nr. {info.song_number})
  • ))}
) : (

Keine Daten geladen

)}
Ziel-Liederbuch setSelectedSongbookId(e.target.value)} > {songbooks.map((book) => ( ))}
Nummer setNumber(e.target.value)} />
Lied hinzufügen
Ziel-Liederbuch setSelectedSongbookId(e.target.value)} > {songInfos.length > 0 ? ( songInfos.map((info) => ( )) ): ""}
Lied aus Liederbuch löschen
); }