<?php
define('DIR_NEU', __DIR__);
define('DIR_ALT', __DIR__ . '/_Alte_Version');
define('BASE_URL', 'https://pptlieder.feg-barmen.de/');

ini_set('display_errors', 1);
error_reporting(E_ALL);

session_start();

$liederbuecher = [
    'FJ1'  => 'Feiert Jesus 1',
    'FJ2'  => 'Feiert Jesus 2',
    'FJ3'  => 'Feiert Jesus 3',
    'FJ4'  => 'Feiert Jesus 4',
    'FJ5'  => 'Feiert Jesus 5',
    'FJ6'  => 'Feiert Jesus 6',
    'CTW'  => 'Come to worship',
    'DLB'  => 'Das Liederbuch',
    'EG'   => 'Evangelisches Gesangsbuch',
    'EG-PLUS'   => 'Evangelisches Gesangsbuch Plus',
    'FL'   => 'Feiern & Loben',
    'GL'   => 'Gemeindelieder',
    'IWDD' => 'Ich will Dir danken',
    'KAA'  => 'Kommt atmet auf',
    'SVJ1' => 'Singt von Jesus 1',
    'SVJ2' => 'Singt von Jesus 2',
    'SVJ3' => 'Singt von Jesus 3',
    'NGL' => 'Neue Gemeindelieder',
    'DBH1' => 'Du bist Herr 1',
    'DBH2' => 'Du bist Herr 2',
    'DBH3' => 'Du bist Herr 3',
    'DBH4' => 'Du bist Herr 4',
    'DBH5' => 'Du bist Herr 5',
    'MoLi' => 'Monatslied',
];

$umlaut_blacklist = [
    'neue','neuer', 'neuen', 'streu', 'streue','streuen', 'freue', 'lasst', 'feuer'
];

function decodeTitleGermanSmart($title, $umlaut_blacklist) {
    $map = [
        'Ae' => 'Ä', 'ae' => 'ä',
        'Oe' => 'Ö', 'oe' => 'ö',
        'Ue' => 'Ü', 'ue' => 'ü'
    ];
    $words = preg_split('/(\s+)/u', $title, -1, PREG_SPLIT_DELIM_CAPTURE);
    foreach ($words as &$word) {
        if (!in_array(mb_strtolower($word), $umlaut_blacklist, true)) {
            $word = strtr($word, $map);
        }
    }
    return implode('', $words);
}

function extractLanguages($title) {
    if(preg_match('/(.+?)(?:_([A-Z]{2}(?:_[A-Z]{2})*))?$/', $title, $m)) {
        $main = $m[1];
        $lang = [];
        if(isset($m[2]) && $m[2] !== '') $lang = explode('_', $m[2]);
        return [ $main, $lang ];
    }
    return [$title, []];
}

function parseNeu($file, $liederbuecher, $umlaut_blacklist) {
    $name = pathinfo($file, PATHINFO_FILENAME);
    $parts = explode('_', $name, 5);
    if($parts[0] !== 'N') return null;
    if($parts[1] === '000') {
        $rest = isset($parts[2]) ? implode('_', array_slice($parts,2)) : '';
        list($titel, $sprachen) = extractLanguages($rest);
        $liederbuch = '---';
        $nummer = '---';
    }
    elseif($parts[1] === 'Band' || $parts[1] === 'Singteam') {
        $rest = isset($parts[2]) ? implode('_', array_slice($parts,2)) : '';
        list($titel, $sprachen) = extractLanguages($rest);
        $liederbuch = $parts[1];
        $nummer = '---';
    }
    elseif($parts[1] === 'LB') {
        if(count($parts)>=5) {
            $lbParts = explode('_', $name, 5);
            $code   = $lbParts[2];
            $nummer = $lbParts[3];
            list($titel, $sprachen) = extractLanguages($lbParts[4]);
            $liederbuch = $liederbuecher[$code] ?? $code;
        } else {
            return null;
        }
    }
    elseif(isset($liederbuecher[$parts[1]]) && count($parts)>=4) {
        $code = $parts[1];
        $nummer = $parts[2];
        $rest = isset($parts[3]) ? implode('_', array_slice($parts,3)) : '';
        list($titel, $sprachen) = extractLanguages($rest);
        $liederbuch = $liederbuecher[$code];
    }
    else {
        $rest = isset($parts[2]) ? implode('_', array_slice($parts,2)) : '';
        list($titel, $sprachen) = extractLanguages($rest);
        $liederbuch = $parts[1];
        $nummer = '---';
    }
    $titel = str_replace('_', ' ', $titel);
    if(empty($sprachen)) $sprachen = ['DE'];
    if(in_array('DE', array_map('strtoupper',$sprachen))) {
        $titel = decodeTitleGermanSmart($titel, $umlaut_blacklist);
    }
    return [
        'filename'   => $file,
        'titel'      => $titel,
        'liederbuch' => $liederbuch,
        'nummer'     => $nummer ?? '---',
        'sprachen'   => $sprachen
    ];
}

function parseAlt($file, $liederbuecher, $umlaut_blacklist) {
    $name = pathinfo($file, PATHINFO_FILENAME);
    $parts = explode('_', $name, 5);
    if($parts[0] === 'AAA') {
        $rest = isset($parts[1]) ? implode('_', array_slice($parts,1)) : '';
        list($titel, $sprachen) = extractLanguages($rest);
        $liederbuch = '---';
        $nummer = '---';
    }
    elseif($parts[0] === 'Band' || $parts[0] === 'Singteam') {
        $rest = isset($parts[1]) ? implode('_', array_slice($parts,1)) : '';
        list($titel, $sprachen) = extractLanguages($rest);
        $liederbuch = $parts[0];
        $nummer = '---';
    }
    elseif($parts[0]==='LB' && count($parts)>=4) {
        $code   = $parts[1];
        $nummer = $parts[2];
        $rest   = $parts[3];
        if(count($parts)>4) $rest .= '_'.implode('_',array_slice($parts,4));
        list($titel,$sprachen) = extractLanguages($rest);
        $liederbuch = $liederbuecher[$code] ?? $code;
    }
    elseif(isset($liederbuecher[$parts[0]]) && count($parts)>=3) {
        $code = $parts[0];
        $nummer = $parts[1];
        $rest = implode('_',array_slice($parts,2));
        list($titel, $sprachen) = extractLanguages($rest);
        $liederbuch = $liederbuecher[$code];
    }
    else {
        $rest = isset($parts[1]) ? implode('_', array_slice($parts,1)) : '';
        list($titel, $sprachen) = extractLanguages($rest);
        $liederbuch = $parts[0];
        $nummer = '---';
    }
    $titel = str_replace('_', ' ', $titel);
    if(empty($sprachen)) $sprachen = ['DE'];
    if(in_array('DE', array_map('strtoupper',$sprachen))) {
        $titel = decodeTitleGermanSmart($titel, $umlaut_blacklist);
    }
    return [
        'filename'   => $file,
        'titel'      => $titel,
        'liederbuch' => $liederbuch,
        'nummer'     => $nummer ?? '---',
        'sprachen'   => $sprachen
    ];
}

function loadSongs($dir, $type, $liederbuecher, $umlaut_blacklist) {
    if(!is_dir($dir)) return [];
    $files = array_filter(scandir($dir), fn($f) => preg_match('/\.(pptx|ppt)$/i', $f));
    $songs = [];
    foreach($files as $file) {
        $parsed = ($type==="neu") ? parseNeu($file, $liederbuecher, $umlaut_blacklist) : parseAlt($file, $liederbuecher, $umlaut_blacklist);
        if($parsed) $songs[] = $parsed;
    }
    usort($songs, fn($a,$b)=>strcasecmp($a['titel'],$b['titel']));
    return $songs;
}

$songsNeu = loadSongs(DIR_NEU, 'neu', $liederbuecher, $umlaut_blacklist);
$songsAlt = loadSongs(DIR_ALT, 'alt', $liederbuecher, $umlaut_blacklist);

// ... ab hier ggf. weitere Filter, Statistik-Generierung, Download/PDF-Logik, $sprachen_stats, $liederbuch_stats usw. ...

?>

<!DOCTYPE html>
<html lang="de">
<head>
<meta charset="UTF-8">
<title>Liederübersicht</title>
<style>
body    { font-family: Arial,sans-serif; margin: 1rem; }
h1      { border-bottom: 1px solid #444; padding-bottom: 0.5rem; }
input[type=text].prefix-input {width:3em;padding:0.15em 0.3em;}
.red-label {color: red;}
table   { border-collapse:collapse; width:100%; }
tr      { border-bottom: 1px solid #f0f0f0; }
th,td   { border: none; text-align:left; padding:0.35rem 0.5rem; }
th.sortable { cursor:pointer; color:#227; text-decoration:underline; }
th.sorted-asc:after { content: " ▲"; }
th.sorted-desc:after { content: " ▼"; }
.hide   {display:none;}
hr      {margin:2rem 0;}
#alt-section {margin-top:2rem;}
button  {margin-bottom:1em; padding: 0.4em 0.9em;}
label {cursor:pointer;}
.prefix-col {width:60px;}
.checkbox-col {width:42px;}
.liederbuch-col {width:200px;}
.nummer-col {width:80px;}
.sprachen-col {width:160px;}
.titel-col {width:auto;}
.youtube-col {width:48px; text-align: center;}
.youtube-logo { display:inline-block; width:22px; height:16px; vertical-align:middle;}
.youtube-col a { display:inline-block; line-height:0; }
a { color: #177; text-decoration: underline;}
#fixed-header {
    position: sticky;
    top: 0;
    background: #fafbfc;
    z-index: 10;
    border-bottom: 2px solid #999;
    padding: 15px 0 12px 0;
    margin-bottom: 1.8em;
    box-shadow: 0 2px 5px rgba(180,180,180,0.10);
}
#liederbuch-filter, #sprach-filter {
    font-size: 1em;
    min-width: 200px;
    margin-right: 1em;
}
@media (max-width:600px) {
  table, tr, th, td {font-size:85%;}
  .sprachen-col {max-width:80px;}
}
</style>
<script>
// (Hier wäre dein gesamtes JavaScript für Suche, Filtern, Checkbox, Präfix usw.;
// z.B. toggleAllCheckboxesButton, sortTable, searchFilter, syncPrefixCheckbox, usw.)
</script>
</head>
<body>
<h1>Liederübersicht</h1>

<form method="post">
    <div id="fixed-header">
        <!-- Buttons „Alle auswählen“, Download, PDF usw. wie gehabt -->
        <button type="button" id="alle-auswahl-btn" onclick="toggleAllCheckboxesButton(this)">Alle auswählen</button>
        <button type="submit" name="download">Ausgewählte Lieder als ZIP herunterladen</button>
        <button type="submit" name="exportpdf" value="1">PDF-Übersicht erzeugen & herunterladen</button>
        <?php if(!empty($_SESSION['error'])): ?>
            <p style="color:red"><?=htmlspecialchars($_SESSION['error'])?></p>
            <?php unset($_SESSION['error']); ?>
        <?php endif;?>

        <!-- Filter-Dropdowns -->
        <select id="liederbuch-filter">
            <option value="ALL">Alle Liederbücher</option>
            <?php /* foreach($liederbuch_stats as $lb=>$anz): ?>
                <option value="<?=htmlspecialchars($lb)?>">
                    <?=htmlspecialchars($lb)?> (<?=$anz?>)
                </option>
            <?php endforeach; */ ?>
        </select>
        <select id="sprach-filter">
            <option value="ALL">Alle Sprachen</option>
            <?php /* foreach($sprachen_stats as $sp=>$anz): ?>
                <option value="<?=htmlspecialchars(strtolower($sp))?>">
                    <?=htmlspecialchars($sp)?> (<?=$anz?>)
                </option>
            <?php endforeach; */ ?>
        </select>

        <input type="text" id="search" placeholder="Liedtitel, Liederbuch oder Sprache suchen..." oninput="searchFilter()">
    </div>
    <!-- Tabelle: Neue Lieder -->
    <section>
        <?php if(count($songsNeu)==0): ?>
        <p>Keine neuen Lieder gefunden.</p>
        <?php else: ?>
        <table id="neu-table" data-sortcol="" data-sortdir="">
            <thead>
                <tr>
                    <th class="prefix-col">Präfix</th>
                    <th class="checkbox-col">Download</th>
                    <th class="titel-col sortable" onclick="sortTable('neu-table',2,'text')">Liedtitel</th>
                    <th class="liederbuch-col sortable" onclick="sortTable('neu-table',3,'text')">Liederbuch</th>
                    <th class="nummer-col sortable" onclick="sortTable('neu-table',4,'number')">Nummer</th>
                    <th class="sprachen-col sortable" onclick="sortTable('neu-table',5,'text')">Sprache</th>
                    <th class="youtube-col" title="YouTube-Suche">YT</th>
                </tr>
            </thead>
            <tbody>
                <?php foreach($songsNeu as $song): ?>
                <tr
                    data-search="<?=strtolower($song['titel'].' '.$song['liederbuch'].' '.($song['nummer']?:'').' '.implode(' ',$song['sprachen']))?>"
                    data-liederbuch="<?=htmlspecialchars($song['liederbuch'])?>"
                    data-sprachen="<?=strtolower(implode(',', array_map(function($sp){
                        $map = ['de'=>'deutsch','en'=>'englisch','fr'=>'französisch','la'=>'latein'];
                        $clean = strtolower($sp);
                        return $map[$clean] ?? $clean;
                    }, $song['sprachen'])))?>"
                >
                    <td>
                        <input class="prefix-input" type="text" name="prefix[<?=htmlspecialchars($song['filename'])?>]" placeholder="Nr." maxlength="12" title="Präfix für Dateiname">
                    </td>
                    <td>
                        <input type="checkbox" name="files[]" value="<?=htmlspecialchars($song['filename'])?>">
                    </td>
                    <td>
                        <a href="<?=htmlspecialchars($song['filename'])?>" target="_blank"><?=htmlspecialchars($song['titel'])?></a>
                    </td>
                    <td><?=htmlspecialchars($song['liederbuch'])?></td>
                    <td><?=htmlspecialchars($song['nummer'])?></td>
                    <td>
                        <?php
                        $sprachenLabel = [];
                        foreach ($song['sprachen'] as $sp) {
                            $clean = strtoupper($sp);
                            if ($clean=='DE') $sprachenLabel[] = 'Deutsch';
                            elseif ($clean=='EN') $sprachenLabel[] = 'Englisch';
                            elseif ($clean=='FR') $sprachenLabel[] = 'Französisch';
                            elseif ($clean=='LA') $sprachenLabel[] = 'Latein';
                            else $sprachenLabel[] = $clean;
                        }
                        echo htmlspecialchars(implode(', ',$sprachenLabel));
                        ?>
                    </td>
                    <td class="youtube-col">
                        <a href="https://www.youtube.com/results?search_query=<?=urlencode($song['titel'])?>" target="_blank" rel="noopener" title="YouTube-Suche">
                            <svg class="youtube-logo" viewBox="0 0 24 17" width="22" height="16">
                                <rect width="24" height="17" rx="3" fill="#FF0000"/>
                                <polygon points="9,4.5 18,8.5 9,12.5" fill="#FFF"/>
                            </svg>
                        </a>
                    </td>
                </tr>
                <?php endforeach;?>
            </tbody>
        </table>
        <?php endif; ?>
    </section>

    <!-- Umschalter für alte Versionen -->
    <label class="red-label"><input type="checkbox" id="toggle-alt" onclick="toggleAltSection()" /> Alte Versionen einblenden</label>
    <section id="alt-section" class="hide">
        <h2>Alte Versionen:</h2>
        <?php if(count($songsAlt)==0): ?>
        <p>Keine alten Lieder gefunden.</p>
        <?php else: ?>
        <table id="alt-table" data-sortcol="" data-sortdir="">
            <thead>
                <tr>
                    <th class="prefix-col">Präfix</th>
                    <th class="checkbox-col">Download</th>
                    <th class="titel-col sortable" onclick="sortTable('alt-table',2,'text')">Liedtitel</th>
                    <th class="liederbuch-col sortable" onclick="sortTable('alt-table',3,'text')">Liederbuch</th>
                    <th class="nummer-col sortable" onclick="sortTable('alt-table',4,'number')">Nummer</th>
                    <th class="sprachen-col sortable" onclick="sortTable('alt-table',5,'text')">Sprache</th>
                    <th class="youtube-col" title="YouTube-Suche">YT</th>
                </tr>
            </thead>
            <tbody>
                <?php foreach($songsAlt as $song): ?>
                <tr
                    data-search="<?=strtolower($song['titel'].' '.$song['liederbuch'].' '.($song['nummer']?:'').' '.implode(' ',$song['sprachen']))?>"
                    data-liederbuch="<?=htmlspecialchars($song['liederbuch'])?>"
                    data-sprachen="<?=strtolower(implode(',', array_map(function($sp){
                        $map = ['de'=>'deutsch','en'=>'englisch','fr'=>'französisch','la'=>'latein'];
                        $clean = strtolower($sp);
                        return $map[$clean] ?? $clean;
                    }, $song['sprachen'])))?>"
                >
                    <td>
                        <input class="prefix-input" type="text" name="prefix[<?=htmlspecialchars($song['filename'])?>]" placeholder="Nr." maxlength="12" title="Präfix für Dateiname">
                    </td>
                    <td>
                        <input type="checkbox" name="files[]" value="<?=htmlspecialchars($song['filename'])?>">
                    </td>
                    <td>
                        <a href="_Alte_Version/<?=htmlspecialchars($song['filename'])?>" target="_blank"><?=htmlspecialchars($song['titel'])?></a>
                    </td>
                    <td><?=htmlspecialchars($song['liederbuch'])?></td>
                    <td><?=htmlspecialchars($song['nummer'])?></td>
                    <td>
                        <?php
                        $sprachenLabel = [];
                        foreach ($song['sprachen'] as $sp) {
                            $clean = strtoupper($sp);
                            if ($clean=='DE') $sprachenLabel[] = 'Deutsch';
                            elseif ($clean=='EN') $sprachenLabel[] = 'Englisch';
                            elseif ($clean=='FR') $sprachenLabel[] = 'Französisch';
                            else $sprachenLabel[] = $clean;
                        }
                        echo htmlspecialchars(implode(', ',$sprachenLabel));
                        ?>
                    </td>
                    <td class="youtube-col">
                        <a href="https://www.youtube.com/results?search_query=<?=urlencode($song['titel'])?>" target="_blank" rel="noopener" title="YouTube-Suche">
                            <svg class="youtube-logo" viewBox="0 0 24 17" width="22" height="16">
                                <rect width="24" height="17" rx="3" fill="#FF0000"/>
                                <polygon points="9,4.5 18,8.5 9,12.5" fill="#FFF"/>
                            </svg>
                        </a>
                    </td>
                </tr>
                <?php endforeach;?>
            </tbody>
        </table>
        <?php endif;?>
    </section>
</form>
</body>
</html>