File size: 3,382 Bytes
43317b5
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Edit CSV via Speech</title>
    <link rel="stylesheet" href="{{ url_for('static', filename='styles.css') }}">
</head>
<body>
    <h1>Edit CSV via Speech</h1>

    <form method="POST" enctype="multipart/form-data">
        <!-- Recording Button -->
        <div>
            <button type="submit" name="record">🎤 Record</button>
        </div>

        <!-- Display Transcription -->
        <div>
            <label for="transcription">Transcription:</label>
            <textarea id="transcription" name="transcription" rows="4" cols="50" readonly>{{ transcription }}</textarea>
        </div>

        <!-- Upload CSV File -->
        <div>
            <input type="file" name="csv_file" accept=".csv">
        </div>

        <!-- Process and Clear Buttons -->
        <div>
            <button type="submit" name="process">Process</button>
            <button type="submit" name="clear">Clear</button>
        </div>
    </form>

    <!-- Data Comparison Section -->
    {% if original_data and updated_data %}
    <div class="data-diff-section">
        <h2>Original vs Updated Data</h2>
        <div class="data-comparison">
            <!-- Original Data Table -->
            <div class="data-table">
                <h3>Original Data</h3>
                <table>
                    <thead>
                        <tr>
                            {% for col in original_data.columns %}
                                <th>{{ col }}</th>
                            {% endfor %}
                        </tr>
                    </thead>
                    <tbody>
                        {% for row in original_data.itertuples() %}
                        <tr>
                            {% for col in row[1:] %}
                                <td>{{ col }}</td>
                            {% endfor %}
                        </tr>
                        {% endfor %}
                    </tbody>
                </table>
            </div>

            <!-- Updated Data Table -->
            <div class="data-table">
                <h3>Updated Data</h3>
                <table>
                    <thead>
                        <tr>
                            {% for col in updated_data.columns %}
                                <th>{{ col }}</th>
                            {% endfor %}
                        </tr>
                    </thead>
                    <tbody>
                        {% for row in updated_data.itertuples() %}
                        <tr>
                            {% for col in row[1:] %}
                                <td>{{ col }}</td>
                            {% endfor %}
                        </tr>
                        {% endfor %}
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <!-- Download Buttons -->
    <div>
        <form method="GET" action="{{ url_for('download_csv', filename='original') }}">
            <button type="submit">Download Original CSV</button>
        </form>
        <form method="GET" action="{{ url_for('download_csv', filename='updated') }}">
            <button type="submit">Download Updated CSV</button>
        </form>
    </div>
    {% endif %}
</body>
</html>