<?php
/**
 * app/modules/floor_infrastructure/list.php
 *
 * Übersicht über Patchpanels und Netzwerkbuchsen auf Stockwerken.
 */

$floorId = (int)($_GET['floor_id'] ?? 0);

$floors = $sql->get(
    "SELECT id, name, svg_path
     FROM floors
     ORDER BY name",
    "",
    []
);

$where = '';
$types = '';
$params = [];

if ($floorId > 0) {
    $where = "WHERE p.floor_id = ?";
    $types = 'i';
    $params[] = $floorId;
}

$patchPanels = $sql->get(
    "SELECT p.*, f.name AS floor_name
     FROM floor_patchpanels p
     LEFT JOIN floors f ON f.id = p.floor_id
     $where
     ORDER BY f.name, p.name",
    $types,
    $params
);

$networkOutlets = $sql->get(
    "SELECT o.id, o.room_id, o.name, o.x, o.y, o.comment,
            r.name AS room_name, r.number AS room_number,
            f.name AS floor_name, f.id AS floor_id,
            GROUP_CONCAT(nop.name ORDER BY nop.name SEPARATOR ', ') AS port_names
     FROM network_outlets o
     LEFT JOIN rooms r ON r.id = o.room_id
     LEFT JOIN floors f ON f.id = r.floor_id
     LEFT JOIN network_outlet_ports nop ON nop.outlet_id = o.id
     GROUP BY o.id
     ORDER BY f.name, r.name, o.name",
    "",
    []
);

$floorMap = [];
foreach ($floors as $floor) {
    $id = (int)$floor['id'];
    $svgPath = trim((string)($floor['svg_path'] ?? ''));
    $floorMap[$id] = [
        'id' => $id,
        'name' => (string)($floor['name'] ?? ''),
        'svg_url' => $svgPath !== '' ? '/' . ltrim($svgPath, '/\\') : ''
    ];
}

$editorFloor = ($floorId > 0 && isset($floorMap[$floorId])) ? $floorMap[$floorId] : null;
$editorPatchPanels = [];
$editorOutlets = [];
$editorRooms = [];
$editorLinks = [];

if ($editorFloor) {
    foreach ($patchPanels as $panel) {
        if ((int)$panel['floor_id'] !== $floorId) {
            continue;
        }
        $editorPatchPanels[] = [
            'id' => (int)$panel['id'],
            'name' => (string)$panel['name'],
            'x' => (int)$panel['pos_x'],
            'y' => (int)$panel['pos_y'],
            'width' => max(1, (int)$panel['width']),
            'height' => max(1, (int)$panel['height']),
            'port_count' => (int)$panel['port_count'],
            'comment' => (string)($panel['comment'] ?? '')
        ];
    }

    foreach ($networkOutlets as $outlet) {
        if ((int)$outlet['floor_id'] !== $floorId) {
            continue;
        }
        $editorOutlets[] = [
            'id' => (int)$outlet['id'],
            'name' => (string)$outlet['name'],
            'x' => (int)$outlet['x'],
            'y' => (int)$outlet['y'],
            'room_name' => (string)($outlet['room_name'] ?? ''),
            'room_number' => (string)($outlet['room_number'] ?? ''),
            'port_names' => (string)($outlet['port_names'] ?? ''),
            'comment' => (string)($outlet['comment'] ?? '')
        ];
    }

    foreach ($sql->get(
        "SELECT id, name, number, x, y, width, height, polygon_points
         FROM rooms
         WHERE floor_id = ?
         ORDER BY name",
        "i",
        [$floorId]
    ) as $room) {
        $editorRooms[] = [
            'id' => (int)($room['id'] ?? 0),
            'name' => (string)($room['name'] ?? ''),
            'number' => (string)($room['number'] ?? ''),
            'x' => (int)($room['x'] ?? 0),
            'y' => (int)($room['y'] ?? 0),
            'width' => (int)($room['width'] ?? 0),
            'height' => (int)($room['height'] ?? 0),
            'polygon_points' => (string)($room['polygon_points'] ?? ''),
        ];
    }

    $outletIdByPort = [];
    foreach ($sql->get(
        "SELECT nop.id AS port_id, nop.outlet_id
         FROM network_outlet_ports nop
         JOIN network_outlets o ON o.id = nop.outlet_id
         JOIN rooms r ON r.id = o.room_id
         WHERE r.floor_id = ?",
        "i",
        [$floorId]
    ) as $row) {
        $portId = (int)($row['port_id'] ?? 0);
        $outletId = (int)($row['outlet_id'] ?? 0);
        if ($portId > 0 && $outletId > 0) {
            $outletIdByPort[$portId] = $outletId;
        }
    }

    $patchPanelIdByPort = [];
    foreach ($sql->get(
        "SELECT fpp.id AS port_id, fpp.patchpanel_id
         FROM floor_patchpanel_ports fpp
         JOIN floor_patchpanels fp ON fp.id = fpp.patchpanel_id
         WHERE fp.floor_id = ?",
        "i",
        [$floorId]
    ) as $row) {
        $portId = (int)($row['port_id'] ?? 0);
        $patchPanelId = (int)($row['patchpanel_id'] ?? 0);
        if ($portId > 0 && $patchPanelId > 0) {
            $patchPanelIdByPort[$portId] = $patchPanelId;
        }
    }

    $resolveNodeKey = static function (string $endpointType, int $endpointId) use ($outletIdByPort, $patchPanelIdByPort): ?string {
        if ($endpointId <= 0) {
            return null;
        }
        $type = strtolower(trim($endpointType));
        if ($type === 'outlet' || $type === 'network_outlet_ports') {
            $outletId = (int)($outletIdByPort[$endpointId] ?? 0);
            return $outletId > 0 ? ('outlet:' . $outletId) : null;
        }
        if ($type === 'patchpanel' || $type === 'floor_patchpanel_ports') {
            $patchPanelId = (int)($patchPanelIdByPort[$endpointId] ?? 0);
            return $patchPanelId > 0 ? ('patchpanel:' . $patchPanelId) : null;
        }
        return null;
    };

    $linksByKey = [];
    foreach ($sql->get(
        "SELECT id, port_a_type, port_a_id, port_b_type, port_b_id
         FROM connections",
        "",
        []
    ) as $row) {
        $fromKey = $resolveNodeKey((string)($row['port_a_type'] ?? ''), (int)($row['port_a_id'] ?? 0));
        $toKey = $resolveNodeKey((string)($row['port_b_type'] ?? ''), (int)($row['port_b_id'] ?? 0));
        if ($fromKey === null || $toKey === null || $fromKey === $toKey) {
            continue;
        }

        $edgeKey = ($fromKey < $toKey) ? ($fromKey . '|' . $toKey) : ($toKey . '|' . $fromKey);
        if (!isset($linksByKey[$edgeKey])) {
            $linksByKey[$edgeKey] = [
                'from_key' => $fromKey,
                'to_key' => $toKey,
                'count' => 0,
                'sample_connection_id' => (int)($row['id'] ?? 0)
            ];
        }
        $linksByKey[$edgeKey]['count']++;
    }
    $editorLinks = array_values($linksByKey);
}
?>

<div class="floor-infra">
    <link rel="stylesheet" href="/assets/css/floor-infrastructure-list.css">
    <script src="/assets/js/floor-infrastructure-list.js" defer></script>

    <h1>Stockwerksinfrastruktur</h1>

    <div class="toolbar">
        <a href="?module=floor_infrastructure&action=edit&type=patchpanel" class="button button-primary">
            + Patchpanel hinzufügen
        </a>
        <a href="?module=floor_infrastructure&action=edit&type=outlet" class="button">
            + Wandbuchse hinzufügen
        </a>
    </div>

    <form method="get" class="filter-form" id="infra-filter-form">
        <input type="hidden" name="module" value="floor_infrastructure">
        <input type="hidden" name="action" value="list">

        <select name="floor_id" id="infra-floor-select">
            <option value="">- Stockwerk wählen -</option>
            <?php foreach ($floors as $floor): ?>
                <option value="<?php echo (int)$floor['id']; ?>" <?php echo ((int)$floor['id'] === $floorId) ? 'selected' : ''; ?>>
                    <?php echo htmlspecialchars((string)$floor['name']); ?>
                </option>
            <?php endforeach; ?>
        </select>

        <button class="button" type="submit">Filter</button>
        <a href="?module=floor_infrastructure&action=list" class="button">Zurücksetzen</a>
    </form>

    <section class="infra-plan">
            <div class="infra-plan-header">
            <h2>Stockwerkskarte</h2>
            <div class="infra-plan-tools">
                <button type="button" class="button button-small" data-infra-toggle="rooms">Räume</button>
                <button type="button" class="button button-small" data-infra-toggle="connections">Kabel</button>
                <button type="button" class="button button-small" data-infra-download="png">PNG</button>
                <button type="button" class="button button-small" data-infra-zoom="in">+</button>
                <button type="button" class="button button-small" data-infra-zoom="out">-</button>
                <button type="button" class="button button-small" data-infra-zoom="reset">Reset</button>
            </div>
        </div>
        <?php if ($floorId <= 0): ?>
            <p class="empty-state">Bitte ein Stockwerk auswählen, um die Karte anzuzeigen.</p>
        <?php elseif (!$editorFloor): ?>
            <p class="empty-state">Gewähltes Stockwerk wurde nicht gefunden.</p>
        <?php elseif (($editorFloor['svg_url'] ?? '') === ''): ?>
            <p class="empty-state">Das gewählte Stockwerk hat keinen SVG-Plan hinterlegt.</p>
        <?php else: ?>
            <p>
                Read-only Vorschau für <strong><?php echo htmlspecialchars((string)$editorFloor['name']); ?></strong>.
                Alle Objekte werden angezeigt; Hover zeigt Details.
            </p>
            <div id="infra-floor-canvas"
                 class="infra-floor-canvas"
                 data-patchpanels="<?php echo htmlspecialchars(json_encode($editorPatchPanels, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES), ENT_QUOTES, 'UTF-8'); ?>"
                 data-outlets="<?php echo htmlspecialchars(json_encode($editorOutlets, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES), ENT_QUOTES, 'UTF-8'); ?>"
                 data-rooms="<?php echo htmlspecialchars(json_encode($editorRooms, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES), ENT_QUOTES, 'UTF-8'); ?>"
                 data-links="<?php echo htmlspecialchars(json_encode($editorLinks, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES), ENT_QUOTES, 'UTF-8'); ?>">
                <div class="infra-floor-scene" id="infra-floor-scene">
                    <img src="<?php echo htmlspecialchars((string)$editorFloor['svg_url']); ?>" class="infra-floor-svg" alt="Stockwerksplan">
                    <svg id="infra-floor-overlay" class="infra-floor-overlay" viewBox="0 0 1 1" preserveAspectRatio="xMidYMid meet" aria-hidden="true"></svg>
                </div>
            </div>
            <p class="floor-plan-hint">Blau: Patchpanel | Grün: Wandbuchse. Knoten sind greifbar und verschiebbar. Räume und Kabel lassen sich ein-/ausblenden.</p>
        <?php endif; ?>
    </section>

    <section class="infra-section">
        <h2>Patchpanels</h2>
        <?php if (!empty($patchPanels)): ?>
            <table class="infra-table">
                <thead>
                    <tr>
                        <th>Name</th>
                        <th>Stockwerk</th>
                        <th>Position</th>
                        <th>Größe</th>
                        <th>Ports</th>
                        <th>Aktionen</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($patchPanels as $panel): ?>
                        <tr>
                            <td><?php echo htmlspecialchars((string)$panel['name']); ?></td>
                            <td><?php echo htmlspecialchars((string)($panel['floor_name'] ?? '-')); ?></td>
                            <td><?php echo (int)$panel['pos_x'] . ' x ' . (int)$panel['pos_y']; ?></td>
                            <td><?php echo (int)$panel['width'] . ' x ' . (int)$panel['height']; ?></td>
                            <td><?php echo (int)$panel['port_count']; ?></td>
                            <td class="actions">
                                <a href="?module=floor_infrastructure&action=edit&type=patchpanel&id=<?php echo (int)$panel['id']; ?>" class="button button-small">Bearbeiten</a>
                                <button
                                    type="button"
                                    class="button button-small button-danger js-floor-infra-delete"
                                    data-delete-id="<?php echo (int)$panel['id']; ?>"
                                    data-delete-type="patchpanel"
                                    data-delete-label="<?php echo htmlspecialchars((string)$panel['name'], ENT_QUOTES, 'UTF-8'); ?>">
                                    Löschen
                                </button>
                            </td>
                        </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        <?php else: ?>
            <p class="empty-state">Noch keine Patchpanels definiert.</p>
        <?php endif; ?>
    </section>

    <section class="infra-section">
        <h2>Wandbuchsen</h2>
        <?php if (!empty($networkOutlets)): ?>
            <table class="infra-table">
                <thead>
                    <tr>
                        <th>Name</th>
                        <th>Stockwerk</th>
                        <th>Raum</th>
                        <th>Koordinaten</th>
                        <th>Ports</th>
                        <th>Kommentar</th>
                        <th>Aktionen</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($networkOutlets as $outlet): ?>
                        <tr>
                            <td><?php echo htmlspecialchars((string)$outlet['name']); ?></td>
                            <td><?php echo htmlspecialchars((string)($outlet['floor_name'] ?? '-')); ?></td>
                            <td>
                                <?php
                                    $roomLabel = (string)($outlet['room_name'] ?? '-');
                                    $roomNumber = trim((string)($outlet['room_number'] ?? ''));
                                    if ($roomNumber !== '') {
                                        $roomLabel .= ' (' . $roomNumber . ')';
                                    }
                                    echo htmlspecialchars($roomLabel);
                                ?>
                            </td>
                            <td><?php echo (int)$outlet['x'] . ' x ' . (int)$outlet['y']; ?></td>
                            <td><?php echo htmlspecialchars((string)($outlet['port_names'] ?? '-')); ?></td>
                            <td><?php echo htmlspecialchars((string)($outlet['comment'] ?? '')); ?></td>
                            <td class="actions">
                                <a href="?module=floor_infrastructure&action=edit&type=outlet&id=<?php echo (int)$outlet['id']; ?>" class="button button-small">Bearbeiten</a>
                                <button
                                    type="button"
                                    class="button button-small button-danger js-floor-infra-delete"
                                    data-delete-id="<?php echo (int)$outlet['id']; ?>"
                                    data-delete-type="outlet"
                                    data-delete-label="<?php echo htmlspecialchars((string)$outlet['name'], ENT_QUOTES, 'UTF-8'); ?>">
                                    Löschen
                                </button>
                            </td>
                        </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        <?php else: ?>
            <p class="empty-state">Noch keine Wandbuchsen angelegt.</p>
        <?php endif; ?>
    </section>
</div>

<script>
document.addEventListener('DOMContentLoaded', () => {
    document.querySelectorAll('.js-floor-infra-delete').forEach((button) => {
        button.addEventListener('click', () => {
            const id = Number(button.dataset.deleteId || '0');
            const type = (button.dataset.deleteType || '').trim();
            const label = button.dataset.deleteLabel || 'Objekt';
            if (id <= 0 || (type !== 'patchpanel' && type !== 'outlet')) {
                return;
            }

            const entityLabel = type === 'patchpanel' ? 'Patchpanel' : 'Wandbuchse';
            if (!confirm(entityLabel + ' "' + label + '" wirklich löschen?')) {
                return;
            }

            fetch('?module=floor_infrastructure&action=delete', {
                method: 'POST',
                headers: { 'Content-Type': 'application/x-www-form-urlencoded; charset=UTF-8' },
                body: 'id=' + encodeURIComponent(id) + '&type=' + encodeURIComponent(type)
            })
                .then((response) => response.json())
                .then((data) => {
                    if (data && data.success) {
                        window.location.reload();
                        return;
                    }
                    alert((data && data.message) ? data.message : 'Löschen fehlgeschlagen');
                })
                .catch(() => alert('Löschen fehlgeschlagen'));
        });
    });
});
</script>