python-code
/
wqb-server


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563
							<!DOCTYPE html>
<html lang="zh">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Idea House - Data Field Analysis</title>
    <link rel="stylesheet" href="{{ url_for('static', filename='styles.css') }}">
    <style>
        .idea-house-container {
            max-width: 1200px;
            margin: 0 auto;
            padding: 20px;
        }

        .data-fields-section {
            background: rgba(255, 255, 255, 0.9);
            border-radius: 8px;
            padding: 20px;
            margin-bottom: 20px;
            box-shadow: 0 2px 4px rgba(0,0,0,0.1);
        }

        .api-config-section {
            background: rgba(240, 242, 255, 0.9);
            border-radius: 8px;
            padding: 20px;
            margin-bottom: 20px;
            box-shadow: 0 2px 4px rgba(0,0,0,0.1);
            border: 1px solid rgba(102, 126, 234, 0.2);
        }

        .data-fields-table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 20px;
        }

        .data-fields-table th,
        .data-fields-table td {
            padding: 12px;
            text-align: left;
            border-bottom: 1px solid #ddd;
        }

        .data-fields-table th {
            background-color: #f5f5f5;
            font-weight: bold;
            position: sticky;
            top: 0;
            z-index: 10;
        }

        .data-fields-table tr:hover {
            background-color: #f0f0f0;
            cursor: pointer;
        }

        .data-fields-table tr.selected {
            background-color: #e3f2fd;
        }

        .field-checkbox {
            width: 20px;
            height: 20px;
            cursor: pointer;
        }

        .selected-fields-section {
            background: rgba(255, 255, 255, 0.9);
            border-radius: 8px;
            padding: 20px;
            margin-bottom: 20px;
            box-shadow: 0 2px 4px rgba(0,0,0,0.1);
        }

        .selected-field-item {
            display: inline-block;
            background: #e3f2fd;
            padding: 5px 10px;
            margin: 5px;
            border-radius: 4px;
            font-size: 14px;
        }

        .results-section {
            background: rgba(255, 255, 255, 0.9);
            border-radius: 8px;
            padding: 20px;
            box-shadow: 0 2px 4px rgba(0,0,0,0.1);
        }

        .markdown-content {
            padding: 20px;
            background: #f9f9f9;
            border-radius: 4px;
            font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', 'Roboto', sans-serif;
            line-height: 1.6;
            overflow-x: auto;
        }

        .markdown-content h1 {
            color: #333;
            border-bottom: 2px solid #4caf50;
            padding-bottom: 10px;
            margin-bottom: 20px;
        }

        .markdown-content h2 {
            color: #555;
            margin-top: 25px;
            margin-bottom: 15px;
        }

        .markdown-content h3 {
            color: #666;
            margin-top: 20px;
            margin-bottom: 10px;
        }

        .markdown-content ul {
            margin: 10px 0;
            padding-left: 20px;
        }

        .markdown-content li {
            margin: 5px 0;
        }

        .markdown-content pre {
            background: #f0f0f0;
            padding: 15px;
            border-radius: 4px;
            overflow-x: auto;
            font-family: 'Courier New', monospace;
        }

        .markdown-content code {
            background: #f0f0f0;
            padding: 2px 6px;
            border-radius: 3px;
            font-family: 'Courier New', monospace;
        }

        .markdown-content strong {
            color: #333;
            font-weight: bold;
        }

        .loading-overlay {
            position: fixed;
            top: 0;
            left: 0;
            width: 100%;
            height: 100%;
            background: rgba(0, 0, 0, 0.5);
            display: none;
            justify-content: center;
            align-items: center;
            z-index: 1000;
        }

        .loading-content {
            background: white;
            padding: 30px;
            border-radius: 8px;
            text-align: center;
        }

        .params-section {
            margin: 20px 0;
            padding: 15px;
            background: #f5f5f5;
            border-radius: 4px;
        }

        .params-row {
            display: flex;
            gap: 15px;
            margin-bottom: 15px;
            flex-wrap: wrap;
        }

        .param-group {
            flex: 1;
            min-width: 200px;
        }

        .param-group label {
            display: block;
            margin-bottom: 5px;
            font-weight: bold;
        }

        .stats-info {
            margin: 10px 0;
            color: #666;
        }

        .table-container {
            max-height: 500px;
            overflow-y: auto;
            border: 1px solid #ddd;
            border-radius: 4px;
        }

        .toggle-btn {
            background: #f0f0f0;
            border: 1px solid #ddd;
            color: #333;
            cursor: pointer;
            transition: all 0.3s ease;
        }

        .toggle-btn:hover {
            background: #e0e0e0;
            border-color: #999;
        }

        /* 数据字段过滤样式 */
        .data-fields-controls {
            display: flex;
            align-items: center;
            gap: 20px;
            padding: 15px;
            background: #f8f9fa;
            border-bottom: 1px solid #dee2e6;
            border-radius: 4px 4px 0 0;
            flex-wrap: wrap;
        }

        .filter-label {
            font-weight: 600;
            color: #495057;
        }

        .filter-options {
            display: flex;
            gap: 15px;
            flex-wrap: wrap;
        }

        .filter-options label {
            display: flex;
            align-items: center;
            gap: 5px;
            cursor: pointer;
            font-size: 14px;
        }

        .filter-actions {
            display: flex;
            gap: 10px;
            margin-left: auto;
        }

        .data-fields-stats {
            padding: 10px 15px;
            background: #f8f9fa;
            border-bottom: 1px solid #dee2e6;
            font-size: 14px;
            color: #6c757d;
        }

        .data-fields-table {
            width: 100%;
            border-collapse: collapse;
            font-size: 14px;
        }

        .data-fields-table th,
        .data-fields-table td {
            padding: 8px 12px;
            text-align: left;
            border-bottom: 1px solid #dee2e6;
        }

        .data-fields-table th {
            background: #f8f9fa;
            font-weight: 600;
            color: #495057;
            position: sticky;
            top: 0;
            z-index: 10;
        }

        .header-row th {
            position: relative;
        }

        .sort-btn {
            background: none;
            border: none;
            cursor: pointer;
            margin-left: 5px;
            padding: 2px 4px;
            font-size: 12px;
            color: #6c757d;
            border-radius: 2px;
        }

        .sort-btn:hover {
            background: #dee2e6;
            color: #495057;
        }

        .sort-btn.asc {
            color: #28a745;
        }

        .sort-btn.desc {
            color: #dc3545;
        }

        .filter-row th {
            padding: 5px 8px;
            background: #ffffff;
        }

        .column-filter,
        .column-filter-min,
        .column-filter-max {
            width: 100%;
            padding: 4px 6px;
            border: 1px solid #ced4da;
            border-radius: 3px;
            font-size: 12px;
        }

        .column-filter.active,
        .column-filter-min.active,
        .column-filter-max.active {
            border-color: #4caf50;
            background-color: #f0f8f0;
        }

        .range-filter {
            display: flex;
            align-items: center;
            gap: 3px;
        }

        .range-filter input {
            flex: 1;
            min-width: 0;
        }

        .range-filter span {
            font-size: 12px;
            color: #6c757d;
        }

        .data-fields-table tbody tr {
            cursor: pointer;
            transition: background-color 0.2s;
        }

        .data-fields-table tbody tr:hover {
            background-color: #f8f9fa;
        }

        .data-fields-table tbody tr.selected {
            background-color: #e8f5e8;
            border-left: 3px solid #4caf50;
        }

        .field-checkbox {
            cursor: pointer;
        }

        .btn-small {
            padding: 5px 10px;
            font-size: 12px;
            border-radius: 3px;
        }
    </style>
</head>
<body>
    <div class="container">
        <header>
            <h1>创意之家</h1>
            <p class="subtitle">让数据大声发言</p>
            <a href="/" class="btn btn-outline">← 返回主页</a>
        </header>

        <div class="idea-house-container">
            <!-- Coze API 配置部分 -->
            <div class="api-config-section">
                <h2>Coze API 配置</h2>
                <div class="params-section">
                    <div class="params-row">
                        <div class="param-group" style="flex: 2;">
                            <label for="cozeApiTokenInput">
                                Coze API 令牌：
                                <button type="button" id="toggleApiTokenBtn" class="toggle-btn" style="margin-left: 10px; padding: 2px 8px; font-size: 12px;">显示</button>
                            </label>
                            <input type="password" id="cozeApiTokenInput" class="form-input" placeholder="输入您的 Coze API 令牌" value="pat_OCxUpnmL7hCvUxEWwcKL5XwUOdoiA3eWLzwY6L8W9sQVN1saJnoMrDNyhFhEn63l">
                        </div>
                        <div class="param-group">
                            <label for="workflowIdInput">工作流 ID：</label>
                            <input type="text" id="workflowIdInput" class="form-input" placeholder="输入工作流 ID" value="7522912027267956786">
                        </div>
                    </div>
                    <div class="info-message" style="margin-top: 10px; font-size: 14px; color: #666;">
                        <em>提供默认值。您可以用自己的 Coze API 凭证替换它们。</em>
                    </div>
                    <div style="margin-top: 15px;">
                        <button id="saveCozeConfigBtn" class="btn btn-secondary btn-small">保存配置</button>
                        <button id="clearCozeConfigBtn" class="btn btn-outline btn-small" style="margin-left: 10px;">重置为默认</button>
                        <span id="saveConfigMessage" style="margin-left: 10px; color: #4caf50; display: none;">配置已保存！</span>
                    </div>
                </div>
            </div>

            <!-- 数据字段加载部分 -->
            <div class="data-fields-section">
                <h2>从 BRAIN 加载数据字段</h2>
                <div class="params-section">
                    <div class="params-row">
                        <div class="param-group">
                            <label for="regionInput">区域：</label>
                            <input type="text" id="regionInput" class="form-input" value="美国">
                        </div>
                        <div class="param-group">
                            <label for="delayInput">延迟：</label>
                            <input type="number" id="delayInput" class="form-input" value="1">
                        </div>
                        <div class="param-group">
                            <label for="universeInput">宇宙：</label>
                            <input type="text" id="universeInput" class="form-input" value="前3000">
                        </div>
                        <div class="param-group">
                            <label for="datasetInput">数据集 ID：</label>
                            <input type="text" id="datasetInput" class="form-input" value="analyst10">
                        </div>
                    </div>
                    <button id="loadDataFieldsBtn" class="btn btn-primary">加载数据字段</button>
                </div>

                <div id="dataFieldsStats" class="stats-info"></div>

                <div class="table-container" id="tableContainer" style="display: none;">
                    <!-- 添加过滤控件 -->
                    <div class="data-fields-controls">
                        <div class="filter-label">
                            <span>快速过滤 👉</span>
                        </div>
                        <div class="filter-options">
                            <label>
                                <input type="checkbox" id="filterHighCoverage"> 高覆盖率 (>90%)
                            </label>
                            <label>
                                <input type="checkbox" id="filterPopular"> 流行 (>1000 用户)
                            </label>
                            <label>
                                <input type="checkbox" id="filterMatrixOnly"> 仅限矩阵类型
                            </label>
                        </div>
                        <div class="filter-actions">
                            <button id="selectAllFiltered" class="btn btn-small btn-secondary">选择所有过滤项</button>
                            <button id="clearAllSelected" class="btn btn-small btn-outline">清除所有</button>
                        </div>
                    </div>
                    <div class="data-fields-stats">
                        <span id="dataFieldsCount">已加载 0 个字段</span> |
                        <span id="filteredCount">已过滤 0 个</span> |
                        <span id="selectedFieldsCount">已选择 0 个</span>
                    </div>

                    <table class="data-fields-table" id="dataFieldsTable">
                        <thead>
                            <tr class="header-row">
                                <th style="width: 40px;">
                                    <input type="checkbox" id="selectAllCheckbox" title="选择/取消选择所有">
                                </th>
                                <th style="width: 200px; min-width: 150px;">
                                    字段 ID
                                    <button class="sort-btn" data-column="id" data-order="asc">↕</button>
                                </th>
                                <th style="min-width: 300px;">
                                    描述
                                    <button class="sort-btn" data-column="description" data-order="asc">↕</button>
                                </th>
                                <th style="width: 100px;">
                                    类型
                                    <button class="sort-btn" data-column="type" data-order="asc">↕</button>
                                </th>
                                <th style="width: 150px;">
                                    覆盖率
                                    <button class="sort-btn" data-column="coverage" data-order="asc">↕</button>
                                </th>
                                <th style="width: 100px;">
                                    用户数
                                    <button class="sort-btn" data-column="userCount" data-order="asc">↕</button>
                                </th>
                                <th style="width: 100px;">
                                    Alphas
                                    <button class="sort-btn" data-column="alphaCount" data-order="asc">↕</button>
                                </th>
                            </tr>
                            <tr class="filter-row">
                                <th></th>
                                <th>
                                    <input type="text" class="column-filter" data-column="id" placeholder="过滤 ID...">
                                </th>
                                <th>
                                    <input type="text" class="column-filter" data-column="description" placeholder="过滤描述...">
                                </th>
                                <th>
                                    <select class="column-filter" data-column="type" id="typeFilter">
                                        <option value="">所有类型</option>
                                    </select>
                                </th>
                                <th>
                                    <div class="range-filter">
                                        <input type="number" class="column-filter-min" data-column="coverage" placeholder="最小 %" min="0" max="100" step="0.1">
                                        <span>-</span>
                                        <input type="number" class="column-filter-max" data-column="coverage" placeholder="最大 %" min="0" max="100" step="0.1">
                                    </div>
                                </th>
                                <th>
                                    <input type="number" class="column-filter" data-column="userCount" placeholder="最小用户数" min="0">
                                </th>
                                <th>
                                    <input type="number" class="column-filter" data-column="alphaCount" placeholder="最小 Alphas" min="0">
                                </th>
                            </tr>
                        </thead>
                        <tbody id="dataFieldsTableBody">
                            <!-- 表格行将在这里填充 -->
                        </tbody>
                    </table>
                </div>
            </div>

            <!-- 选择的字段部分 -->
            <div class="selected-fields-section" id="selectedFieldsSection" style="display: none;">
                <h2>选择的字段</h2>
                <div id="selectedFieldsList"></div>
                <button id="clearSelectionBtn" class="btn btn-secondary">清除选择</button>
                <button id="processFieldsBtn" class="btn btn-primary">处理选择的字段</button>
            </div>

            <!-- 结果部分 -->
            <div class="results-section" id="resultsSection" style="display: none;">
                <h2>分析结果</h2>
                <div class="markdown-content" id="resultsContent">
                    <!-- 结果将在这里显示 -->
                </div>
            </div>
        </div>
    </div>

    <!-- 加载覆盖层 -->
    <div class="loading-overlay" id="loadingOverlay">
        <div class="loading-content">
            <h3>处理中...</h3>
            <p>请稍等，我们正在分析您选择的字段...</p>
        </div>
    </div>

    <script src="{{ url_for('static', filename='idea_house.js') }}"></script>
</body>
</html>