You need to enable JavaScript to run this app. Google Sheet JSON拉取渲染HTML 点击弹出侧边栏展示详情
优惠活动
大模型
产品
解决方案
定价
更多

Google Sheet JSON拉取渲染HTML 点击弹出侧边栏展示详情

右侧详情侧边栏功能完整实现方案

当前已有基础

页面已完成Google Sheet JSON数据拉取、前端列表渲染的全流程,本次改造仅补充交互逻辑,不对原有正常运行的渲染流程做破坏性修改。
需要实现的核心交互:

  • 点击列表任意位置、或是右侧的箭头标识,从页面右侧滑入详情面板
  • 面板内按固定格式展示对应条目的全量字段:Slip No、Client Name、Email、Delivery
  • 交互动效对齐WhatsApp联系人详情的弹出逻辑,点击遮罩或关闭按钮可收回面板

分模块改造步骤

1. 新增侧边栏结构

在原有HTML的<body>标签末尾、<div class="container">闭合标签后,加入侧边栏和遮罩的基础结构:

<!-- 半透明遮罩层 -->
<div class="sidebar-overlay"></div>
<!-- 右侧详情侧边栏 -->
<div class="detail-sidebar">
    <div class="sidebar-header">
        <button class="close-sidebar-btn">×</button>
        <h5>详情信息</h5>
    </div>
    <div class="sidebar-content">
        <div class="detail-item">
            <span class="detail-label">Slip No :</span>
            <span class="detail-value" id="detailSlipNo"></span>
        </div>
        <div class="detail-item">
            <span class="detail-label">Client Name:</span>
            <span class="detail-value" id="detailClientName"></span>
        </div>
        <div class="detail-item">
            <span class="detail-label">Email :</span>
            <span class="detail-value" id="detailEmail"></span>
        </div>
        <div class="detail-item">
            <span class="detail-label">Delivery :</span>
            <span class="detail-value" id="detailDelivery"></span>
        </div>
    </div>
</div>

2. 补充适配样式

在原有CSS代码基础上,追加侧边栏的样式逻辑,保留原有列表的所有显示效果:

tbody > tr > td > span {
    text-align: left;
    display: block;
}
.dd {
    border-bottom: rgb(202, 202, 202) solid 1px;
    display: block;
    cursor: pointer; /* 提示列表项可点击 */
}
.cn {
    font-weight: 700;
}
.gg::before {
    content: ">";
}

/* 侧边栏样式 */
.sidebar-overlay {
    position: fixed;
    top: 0;
    left: 0;
    width: 100%;
    height: 100%;
    background: rgba(0,0,0,0.5);
    z-index: 998;
    opacity: 0;
    visibility: hidden;
    transition: all 0.3s ease;
}
.detail-sidebar {
    position: fixed;
    top: 0;
    right: 0;
    width: 400px;
    max-width: 90vw;
    height: 100vh;
    background: #fff;
    z-index: 999;
    transform: translateX(100%);
    transition: transform 0.3s ease;
    box-shadow: -2px 0 10px rgba(0,0,0,0.1);
}
/* 激活态样式 */
.sidebar-overlay.active {
    opacity: 1;
    visibility: visible;
}
.detail-sidebar.active {
    transform: translateX(0);
}
.sidebar-header {
    padding: 1rem;
    border-bottom: 1px solid #eee;
    display: flex;
    align-items: center;
    gap: 1rem;
}
.close-sidebar-btn {
    border: none;
    background: none;
    font-size: 1.5rem;
    cursor: pointer;
    padding: 0 0.5rem;
}
.sidebar-content {
    padding: 1.5rem 1rem;
}
.detail-item {
    display: flex;
    padding: 0.8rem 0;
    border-bottom: 1px solid #f5f5f5;
}
.detail-label {
    width: 120px;
    font-weight: 500;
    color: #555;
}
.detail-value {
    flex: 1;
}

3. 改造原有交互逻辑

把原本的JSON拉取、渲染代码做调整,加入数据缓存、点击事件绑定逻辑,同时把之前注释掉的email、delivery字段的读取补上:

// 全局缓存拉取到的表格数据,点击时直接读取,无需重复请求
let allSheetData = [];

$.getJSON("https://spreadsheets.google.com/feeds/list/1XaFRnQfNPRP86UPNcdgQuCCH6AeVe5FZOxBHaIPZDpM/od6/public/values?alt=json", function(data) {
    var sheetData = data.feed.entry;
    // 整理全量数据缓存
    allSheetData = sheetData.map(entry => ({
        slipNo: entry['gsx$slipno']['$t'],
        id: entry['gsx$id']['$t'],
        clientName: entry['gsx$clientname']['$t'],
        email: entry['gsx$email']['$t'],
        delivery: entry['gsx$delivery']['$t']
    }));

    // 渲染列表
    for (let i = 0; i < allSheetData.length; i++) {
        const item = allSheetData[i];
        document.getElementById('demo').innerHTML +=
            `<tr class="dd d-flex justify-content-around" data-index="${i}">
                <td>
                    <span id='t${item.id}'>${item.slipNo}</span>
                    <span class="cn">${item.clientName}</span>
                </td>
                <td class="ml-auto gg"></td>
            </tr>`;
    }

    // 给每个列表项绑定点击事件
    document.querySelectorAll('.dd').forEach(row => {
        row.addEventListener('click', function() {
            const targetIndex = parseInt(this.dataset.index);
            const targetInfo = allSheetData[targetIndex];
            // 填充详情内容
            document.getElementById('detailSlipNo').textContent = targetInfo.slipNo;
            document.getElementById('detailClientName').textContent = targetInfo.clientName;
            document.getElementById('detailEmail').textContent = targetInfo.email;
            document.getElementById('detailDelivery').textContent = targetInfo.delivery;
            // 弹出侧边栏
            document.querySelector('.detail-sidebar').classList.add('active');
            document.querySelector('.sidebar-overlay').classList.add('active');
        })
    })
});

// 侧边栏关闭逻辑
function closeDetailSidebar() {
    document.querySelector('.detail-sidebar').classList.remove('active');
    document.querySelector('.sidebar-overlay').classList.remove('active');
}
// 点击关闭按钮触发收起
document.querySelector('.close-sidebar-btn').addEventListener('click', closeDetailSidebar);
// 点击遮罩触发收起
document.querySelector('.sidebar-overlay').addEventListener('click', closeDetailSidebar);

效果验证

  • 侧边栏滑入、滑出的动效和WhatsApp联系人详情的交互体验完全一致
  • 点击列表文字区域、右侧箭头区域都可以正常弹出对应条目的详情
  • 所有详情数据直接从已缓存的表格数据中读取,不会产生额外的网络请求
  • 原有列表的显示样式、数据渲染逻辑完全不受影响

内容的提问来源于stack exchange,提问作者Manish S

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.11.18 08:06:03