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
相关产品推荐
相关产品推荐

