web
/
FlaskProject


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260
							<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>文件管理系统</title>
    <script>
        // Fetch categories from the backend
        async function fetchCategories() {
            const response = await fetch('/categories'); // Backend endpoint to get categories
            const categories = await response.json();
            const categoryList = document.getElementById('category-list');

            // Populate the left-side list with categories
            categoryList.innerHTML = '';
            categories.forEach(category => {
                const listItem = document.createElement('li');
                listItem.textContent = category.categoryName;
                listItem.onclick = () => fetchTableData(category.categoryName);
                categoryList.appendChild(listItem);
            });
        }

        async function fetchTableData(tableName) {
    const response = await fetch(`/category-data?categoryName=${tableName}`);
    const tableData = await response.json();
    const tableBody = document.getElementById('table-body');

    // Populate the right-side table with data
    tableBody.innerHTML = '';
    tableData.forEach(row => {
        const tableRow = document.createElement('tr');

        // Display id and categoryName
        const cells = [row.id, row.categoryName];
        cells.forEach(value => {
            const cell = document.createElement('td');
            cell.textContent = value;
            tableRow.appendChild(cell);
        });

        // Add the download button in the last column
        const downloadCell = document.createElement('td');
        const downloadButton = document.createElement('button');
        downloadButton.textContent = 'Download';
        downloadButton.onclick = () => downloadFile(row.categoryName);
        downloadCell.appendChild(downloadButton);

        // Add the delete button in the last column
        const deleteCell = document.createElement('td');
        const deleteButton = document.createElement('button');
        deleteButton.textContent = 'Delete';
        deleteButton.onclick = () => deleteRow(tableName, row.id); // Pass the table name and row id
        deleteCell.appendChild(deleteButton);

        tableRow.appendChild(downloadCell);
        tableRow.appendChild(deleteCell);
        tableBody.appendChild(tableRow);
    });
}


        async function downloadFile(filename) {
            const response = await fetch(`/download/${filename}`, {
                method: 'GET',
                headers: {
                    'Content-Type': 'application/json'
                }
            });

            if (response.ok) {
                // Create a blob from the response
                const blob = await response.blob();

                // Create a link element
                const link = document.createElement('a');
                link.href = URL.createObjectURL(blob);
                link.download = filename;

                // Append the link to the body (it needs to be in the DOM to work)
                document.body.appendChild(link);

                // Programmatically trigger the download
                link.click();

                // Clean up the DOM
                document.body.removeChild(link);
            } else {
                console.error('Failed to download the file');
            }
        }

        // Function to handle file upload
        async function uploadFile() {
            const fileInput = document.getElementById('file-input');
            const file = fileInput.files[0]; // Get the selected file
            const formData = new FormData();
            formData.append('file', file);

            const response = await fetch('/upload', {
                method: 'POST',
                body: formData,
            });

            if (response.ok) {
                alert('File uploaded successfully!');
                fetchCategories(); // Reload categories after upload
            } else if (response.status === 409) {
                // 处理文件已存在的情况
                const data = await response.json();
                alert(data.message); // 显示 "File already exists, no need to insert again."
            } else {
                alert('Failed to upload file');
            }
        }

        // Function to handle file deletion
        // Function to handle delete
        async function deleteRow(tableName, rowId) {
            const confirmation = confirm('Are you sure you want to delete this row?');
            if (confirmation) {
                const response = await fetch(`/delete_files?tableName=${tableName}&rowId=${rowId}`, {
                    method: 'DELETE',
                });

                if (response.ok) {
                    alert('Row deleted successfully!');
                    fetchTableData(tableName); // Reload the table data after deletion
                } else {
                    alert('Failed to delete the row');
                }
            }
        }

        // Initial load
        document.addEventListener('DOMContentLoaded', fetchCategories);
    </script>
    <style>
        body {
            font-family: Arial, sans-serif;
            margin: 0;
            display: flex;
        }

        #sidebar {
            width: 20%;
            background-color: #f8f9fa;
            padding: 1em;
            border-right: 1px solid #ddd;
            display: flex;
            flex-direction: column;
            justify-content: flex-start;
            height: 100vh;
        }

        #content {
            flex-grow: 1;
            padding: 1em;
        }

        ul {
            list-style: none;
            padding: 0;
        }

        li {
            padding: 0.5em;
            cursor: pointer;
            border: 1px solid #ddd;
            margin-bottom: 0.5em;
            border-radius: 4px;
            text-align: center;
        }

        li:hover {
            background-color: #e9ecef;
        }

        table {
            width: 100%;
            border-collapse: collapse;
        }

        table, th, td {
            border: 1px solid #ddd;
        }

        th, td {
            padding: 0.5em;
            text-align: left;
        }

        th {
            background-color: #f1f1f1;
        }

        /* Styling the upload section to be at the bottom of the sidebar */
        #upload-section {
            margin-top: auto;
            padding: 10px;
            background-color: #fff;
            border: 1px solid #ddd;
            border-radius: 5px;
        }

        #upload-section input[type="file"] {
            width: calc(100% - 120px);
            margin-right: 10px;
            padding: 5px;
            font-size: 16px;
        }

        #upload-section button {
            padding: 8px 16px;
            font-size: 16px;
            background-color: #007bff;
            color: white;
            border: none;
            border-radius: 5px;
            cursor: pointer;
        }

        #upload-section button:hover {
            background-color: #0056b3;
        }
    </style>
</head>
<body>
    <div id="sidebar">
        <h2>分类</h2>
        <ul id="category-list">
            <!-- Categories will be dynamically loaded here -->
        </ul>

        <!-- File Upload Section (Now positioned at the bottom of the sidebar) -->
        <div id="upload-section">
            <h3>上传文件</h3>
            <input type="file" id="file-input">
            <button onclick="uploadFile()">上传</button>
        </div>
    </div>

    <div id="content">
        <h2>文件列表</h2>
        <table>
            <thead>
                <tr>
                    <th>ID</th>
                    <th>文件名</th>
                    <th>操作</th>
                    <th>删除</th> <!-- Added Delete column -->
                </tr>
            </thead>
            <tbody id="table-body">
                <!-- Data will be dynamically loaded here -->
            </tbody>
        </table>
    </div>
</body>
</html>