rote_db.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Rote Search</title>
    <style>
        body {
            font-family: Arial, sans-serif;
            margin: 20px;
        }
        table {
            border-collapse: collapse;
            margin: 25px 0;
            font-size: 0.9em;
            font-family: sans-serif;
            /*table-layout: fixed;*/
            width: 100%;
            box-shadow: 0 0 20px rgba(0, 0, 0, 0.15);
        }
        tbody {
            width: 100%;
            /*overflow: auto;*/
            height: 1000px;
        }
        thead tr {
            background-color: #0076e4;
            color: #ffffff;
            text-align: left;
            width: auto;
        }
        th {
            position: -webkit-sticky;
            position: sticky;
        }
        th, td {
            padding: 12px 15px;
            width: auto;
        }
        th:first-child {
            width: 100px;
        }
        th:last-child {
            width: 100%;
        }
        td:first-child {
            width: 100px;
        }
        td:last-child {
            width: 100%;
        }
        /*
        .rote-name th td {
            max-width: 100px;
        }
        .sphere th td {
            max-width: 10px;
        }
        .rote-desc th td {
            max-width: 100%;
        }
        */
        tbody tr {
            border-bottom: 1px solid #dddddd;
        }
        tbody tr:nth-of-type(even) {
            background-color: #f3f3f3;
        }
        tbody tr:last-of-type {
            border-bottom: 2px solid #0076e4;
        }
        tbody tr.active-row {
            font-weight: bold;
            color: #0076e4;
        }
        input, button {
            padding: 8px;
        }
    </style>
</head>
<body>
    <h2>Filters</h2>
    <form id="filterForm">
        <!-- <input type="text" placeholder="Rote" name="rote"> -->
        C <input type="text" placeholder="Correspondence" name="Correspondence">
        E <input type="text" placeholder="Entropy" name="Entropy">
        F <input type="text" placeholder="Forces" name="Forces">
        L <input type="text" placeholder="Life" name="Life">
        Ma <input type="text" placeholder="Matter" name="Matter">
        Mi <input type="text" placeholder="Mind" name="Mind">
        P <input type="text" placeholder="Prime" name="Prime">
        S <input type="text" placeholder="Spirit" name="Spirit">
        T <input type="text" placeholder="Time" name="Time">
        <!-- Add other fields as necessary -->
        <button type="button" id="filterButton">Apply Filter</button>
        <button type="button" id="clearButton">Clear Filter</button>
        <button type="button" id="zeroOut">Zero Out</button>
    </form>

    <h2>Rote Table</h2>
    <table>
        <thead>
            <tr>
                <th class="rote-name">Rote</th>
                <th class="sphere">C</th>
                <th class="sphere">E</th>
                <th class="sphere">F</th>
                <th class="sphere">L</th>
                <th class="sphere">Ma</th>
                <th class="sphere">Mi</th>
                <th class="sphere">P</th>
                <th class="sphere">S</th>
                <th class="sphere">T</th>
                <th class="rote-desc">Description</th>
            </tr>
        </thead>
        <tbody id="dataTable">
            <!-- Data rows will go here -->
        </tbody>
    </table>

    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script>
        $(document).ready(function() {
         
            function populateTable(data) {
                const tableBody = $('#dataTable');
                tableBody.empty(); // Clear previous rows
                data.forEach(item => {
                    let row = `<tr>`;
                    row += `<td class="rote-name">${item.rote || ''}</td>`;
                    row += `<td class="sphere">${item.Correspondence || 0}</td>`;
                    row += `<td class="sphere">${item.Entropy || 0}</td>`;
                    row += `<td class="sphere">${item.Forces || 0}</td>`;
                    row += `<td class="sphere">${item.Life || 0}</td>`;
                    row += `<td class="sphere">${item.Matter || 0}</td>`;
                    row += `<td class="sphere">${item.Mind || 0}</td>`;
                    row += `<td class="sphere">${item.Prime || 0}</td>`;
                    row += `<td class="sphere">${item.Spirit || 0}</td>`;
                    row += `<td class="sphere">${item.Time || 0}</td>`;
                    row += `<td class="rote-desc">${item.description || ''}</td>`;
                    row += `</tr>`;
                    tableBody.append(row);
                });
            }

            // This needs to be fixed to allow searching with rote name and description
            function filterTable() {
                const formValues = {};
                $('#filterForm').serializeArray().forEach(input => {
                    if (input.value !== "") {
                        formValues[input.name] = parseInt(input.value.toLowerCase());
                    }
                });
                console.log(formValues);
                const filteredData = jsonData.filter(item => {
                    return Object.entries(formValues).every(([key, value]) =>
                        key in item && (parseInt(item[key].toString().toLowerCase()) <= value));
                });
                populateTable(filteredData);
            }

            var jsonData;
            fetch('rotes.json')
                .then(res => res.json())
                .then(data => {
                    jsonData = data;
                })
                .then(() => {
                    populateTable(jsonData); // Initial population of the table
                });

            $("#filterButton").click(filterTable);
            $("#clearButton").click(function (e) {
                e.preventDefault();
                $("#filterForm")[0].reset();
                populateTable(jsonData);
            });
            $("#zeroOut").click(function (e) {
                e.preventDefault();
                $(':input').val(0);
            });
        });
    </script>
</body>
</html>