ul列表中包含input时line-height属性失效的解决办法

本文探讨了在IE6浏览器中<UL>列表包含<input>控件时出现的行高属性失效问题,并提供了解决方案。通过定义input标签的宽度、高度和边距,实现了与其他列表项相同的视觉效果。
为什么<UL>列表含<input>控件时,行高属性在IE6.0下失效?FF2.0下正常。这是一个不常见的问题,我们不提倡这样的布局方式,input元素尽可能的使用lable标签而不是包含于ul的li标签中。但在实际操作中,也可能存在这样的情况,我们就ul列表中包含input时line-height属性失效的问题作一些探讨。

  我们知道input标签是一个block元素,也就是一个块元素,而line-height只可以应用于inline行内元素。所以line-height属性的设置对input元素是无效的。我们看下面的代码:

 Source Code to Run [www.52css.com]

    [ 可先修改部分代码 再运行查看效果 ]

  CSS模板下载所在的li标签及input元素,行高明显的小于40px。因为input是block元素无line-height属性可言。我们只能通过变通的方法来解决问题。

  首先我们定义好input标签的外观,即他的宽度与高度。然后设置边距,使其达到与其它li列表项同样行高的视觉效果,而不是通过line-height属性来实现。

 Example Source Code [www.52css.com]
input {
    border:1px solid #666;
    width:120px;
    height:20px;
    margin:10px 0;
    vertical-align:middle;
    line-height:20px;
}

  我们定义input元素的边框为一象素的灰色实线。宽度与高度分别是120px与20px。我们定义的li列表项的行高为40px。要使input元素如其它列表项一样,则设置input元素的上下边距为10px。即达到了行距为40px的效果。但这样会造成“CSS模板下载”与input标签水平不对齐,我们设置vertical-align:middle。使得文字与输入框水平对齐。关于vertical-align:middle的相关知识,请参考本站相关文章。心细的你或许会发现,我们这里也设置了line-height属性,值是20px。这里的line-height属性设置是input输入文字的行高,我们这样设置,可以使输入文字在输入框垂直居中。
   通过此例,我们应该注意区分不同的属性所能作用的对象,line-height属性是inline元素所拥有的,对于block元素是不起作用的。我们看最终的运行效果:

 Source Code to Run [www.52css.com]

    [ 可先修改部分代码 再运行查看效果 ]
<!DOCTYPE html> <html lang="zh-CN"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>测试工具 - 图片生成器</title> <link href="../css/bootstrap.min.css" rel="stylesheet"> <link rel="stylesheet" href="../css/all.min.css"> <style> :root { --primary-color: #4e73df; --primary-light: #7a9ff5; --primary-dark: #3a5bcc; --secondary-color: #6c757d; --success-color: #1cc88a; --info-color: #36b9cc; --warning-color: #f6c23e; --danger-color: #e74a3b; --light-color: #f8f9fc; --dark-color: #2e3a59; --gray-100: #f8f9fa; --gray-200: #e9ecef; --gray-300: #dee2e6; --gray-400: #ced4da; --gray-500: #adb5bd; --gray-600: #6c757d; --gray-700: #495057; --gray-800: #343a40; --gray-900: #212529; --shadow-light: 0 2px 10px rgba(0, 0, 0, 0.08); --shadow-medium: 0 4px 20px rgba(0, 0, 0, 0.12); --shadow-hover: 0 0.5rem 1.5rem rgba(58, 59, 69, 0.2); --border-radius: 0.5rem; --border-radius-sm: 0.375rem; --border-radius-lg: 0.75rem; --transition: all 0.3s ease; } * { margin: 0; padding: 0; box-sizing: border-box; } body { font-family: 'Segoe UI', 'Arial', sans-serif; background-color: #f5f7fb; margin: 0; padding: 20px; line-height: 1.6; color: var(--gray-700); min-height: 100vh; } .container { max-width: 1400px; margin: 0 auto; height: 100%; display: flex; flex-direction: column; } .header { display: flex; justify-content: space-between; align-items: center; margin-bottom: 1.5rem; padding: 1rem 0; border-bottom: 1px solid var(--gray-200); } .header h1 { color: var(--dark-color); font-size: 1.8rem; font-weight: 600; margin: 0; display: flex; align-items: center; } .header h1 i { margin-right: 0.75rem; color: var(--primary-color); } .tools-container { display: flex; flex: 1; overflow: hidden; gap: 1.5rem; min-height: 600px; } .tools-sidebar { width: 250px; background: white; border-radius: var(--border-radius); box-shadow: var(--shadow-light); padding: 1.25rem; overflow-y: auto; flex-shrink: 0; } .tools-content { flex: 1; background: white; border-radius: var(--border-radius); box-shadow: var(--shadow-light); padding: 1.5rem; overflow-y: auto; display: flex; flex-direction: column; } .tool-card { background: white; border-radius: var(--border-radius); box-shadow: var(--shadow-light); margin-bottom: 1.5rem; border: none; transition: var(--transition); overflow: hidden; } .tool-card:hover { box-shadow: var(--shadow-hover); transform: translateY(-2px); } .tool-card-header { padding: 1rem 1.5rem; background: linear-gradient(135deg, #f8f9fc 0%, #e9ecef 100%); border-bottom: 1px solid var(--gray-200); border-radius: var(--border-radius) var(--border-radius) 0 0; } .tool-card-title { font-size: 1.25rem; font-weight: 600; color: var(--dark-color); margin: 0; } .tool-card-body { padding: 1.5rem; } .btn { border-radius: var(--border-radius-sm); padding: 0.5rem 1rem; font-weight: 500; transition: var(--transition); border: none; display: inline-flex; align-items: center; justify-content: center; } .btn i { margin-right: 0.5rem; } .btn-primary { background: linear-gradient(135deg, var(--primary-color) 0%, var(--primary-dark) 100%); border: none; } .btn-primary:hover { background: linear-gradient(135deg, var(--primary-light) 0%, var(--primary-color) 100%); transform: translateY(-1px); box-shadow: 0 4px 8px rgba(78, 115, 223, 0.3); } .btn-sm { padding: 0.375rem 0.75rem; font-size: 0.875rem; } .form-control, .form-select { border-radius: var(--border-radius-sm); border: 1px solid var(--gray-300); transition: var(--transition); padding: 0.75rem; } .form-control:focus, .form-select:focus { border-color: var(--primary-color); box-shadow: 0 0 0 0.2rem rgba(78, 115, 223, 0.25); } .alert { border-radius: var(--border-radius); padding: 1rem 1.5rem; margin-bottom: 1.5rem; border: none; box-shadow: var(--shadow-light); display: flex; align-items: center; } .alert-success { background-color: #d4edda; color: #155724; border-left: 4px solid var(--success-color); } .alert-danger { background-color: #f8d7da; color: #721c24; border-left: 4px solid var(--danger-color); } .alert-warning { background-color: #fff3cd; color: #856404; border-left: 4px solid var(--warning-color); } .alert-info { background-color: #d1ecf1; color: #0c5460; border-left: 4px solid var(--info-color); } .alert i { margin-right: 0.75rem; font-size: 1.25rem; } .tool-list { list-style: none; padding: 0; margin: 0; } .tool-item { padding: 0.75rem 1rem; margin-bottom: 0.5rem; border-radius: var(--border-radius-sm); cursor: pointer; transition: var(--transition); display: flex; align-items: center; } .tool-item:hover { background-color: rgba(78, 115, 223, 0.1); } .tool-item.active { background-color: rgba(78, 115, 223, 0.15); color: var(--primary-color); font-weight: 600; } .tool-item i { margin-right: 0.75rem; font-size: 1.1rem; width: 20px; text-align: center; } .progress { height: 8px; border-radius: 4px; margin-top: 0.5rem; } .result-container { margin-top: 1.5rem; padding: 1.5rem; background-color: var(--gray-100); border-radius: var(--border-radius); display: none; } .result-container.active { display: block; } .image-preview { max-width: 100%; max-height: 300px; border-radius: var(--border-radius); box-shadow: var(--shadow-light); margin: 1rem 0; } .file-info { background-color: white; padding: 1rem; border-radius: var(--border-radius); margin-top: 1rem; } .file-info p { margin-bottom: 0.5rem; } .loading { text-align: center; padding: 2rem; display: none; } .loading.active { display: block; } .spinner-border { width: 2rem; height: 2rem; color: var(--primary-color); } @media (max-width: 768px) { .tools-container { flex-direction: column; } .tools-sidebar { width: 100%; margin-bottom: 1rem; } .header h1 { font-size: 1.5rem; } .tool-card-body { padding: 1rem; } } </style> </head> <body> <div class="container"> <div class="header"> <h1><i class="fas fa-tools"></i>测试工具</h1> </div> <div class="tools-container"> <!-- 工具菜单侧边栏 --> <div class="tools-sidebar"> <h5 class="mb-3"><i class="fas fa-list"></i> 工具列表</h5> <ul class="tool-list"> <li class="tool-item active" data-tool="image-generator"> <i class="fas fa-image"></i> 图片生成器 </li> <li class="tool-item" data-tool="placeholder"> <i class="fas fa-cube"></i> 占位工具 </li> <li class="tool-item" data-tool="converter"> <i class="fas fa-exchange-alt"></i> 格式转换 </li> <li class="tool-item" data-tool="analyzer"> <i class="fas fa-chart-bar"></i> 数据分析 </li> <li class="tool-item" data-tool="validator"> <i class="fas fa-check-circle"></i> 数据验证 </li> </ul> </div> <!-- 工具内容区域 --> <div class="tools-content"> <!-- 图片生成器工具 --> <div class="tool-card" id="image-generator-tool"> <div class="tool-card-header"> <h3 class="tool-card-title"><i class="fas fa-image"></i> 图片生成器</h3> </div> <div class="tool-card-body"> <div class="alert alert-info"> <i class="fas fa-info-circle"></i> 此工具可以生成指定大小的图片文件,支持从0到10MB的大小范围。 </div> <form id="image-generator-form"> <div class="row mb-4"> <div class="col-md-6"> <label for="image-size" class="form-label">图片大小 (MB)</label> <input type="range" class="form-range" id="image-size" min="0" max="10" step="0.1" value="1"> <div class="d-flex justify-content-between"> <span>0 MB</span> <span id="size-value">1 MB</span> <span>10 MB</span> </div> </div> <div class="col-md-6"> <label for="image-format" class="form-label">图片格式</label> <select class="form-select" id="image-format"> <option value="png">PNG</option> <option value="jpg">JPG</option> <option value="gif">GIF</option> <option value="bmp">BMP</option> </select> </div> </div> <div class="row mb-4"> <div class="col-md-6"> <label for="image-width" class="form-label">图片宽度 (像素)</label> <input type="number" class="form-control" id="image-width" min="10" max="5000" value="800"> </div> <div class="col-md-6"> <label for="image-height" class="form-label">图片高度 (像素)</label> <input type="number" class="form-control" id="image-height" min="10" max="5000" value="600"> </div> </div> <div class="d-grid gap-2 d-md-flex justify-content-md-end"> <button type="button" class="btn btn-secondary" id="reset-btn"> <i class="fas fa-redo"></i> 重置 </button> <button type="submit" class="btn btn-primary" id="generate-btn"> <i class="fas fa-magic"></i> 生成图片 </button> </div> </form> <!-- 加载指示器 --> <div class="loading" id="loading-indicator"> <div class="spinner-border" role="status"> <span class="visually-hidden">生成中...</span> </div> <p class="mt-2">正在生成图片,请稍候...</p> </div> <!-- 结果展示区域 --> <div class="result-container" id="result-container"> <h4><i class="fas fa-check-circle text-success"></i> 图片生成成功!</h4> <div class="text-center"> </div> <div class="file-info"> <h5>文件信息</h5> <p><strong>文件大小:</strong> <span id="file-size">0 MB</span></p> <p><strong>文件格式:</strong> <span id="file-format">PNG</span></p> <p><strong>图片尺寸:</strong> <span id="image-dimensions">800x600</span> 像素</p> <p><strong>生成间:</strong> <span id="generation-time">-</span></p> </div> <div class="d-grid gap-2 d-md-flex justify-content-md-end mt-3"> <button type="button" class="btn btn-success" id="download-btn"> <i class="fas fa-download"></i> 下载图片 </button> </div> </div> </div> </div> <!-- 其他工具占位内容 --> <div class="tool-card" id="placeholder-tool" style="display: none;"> <div class="tool-card-header"> <h3 class="tool-card-title"><i class="fas fa-cube"></i> 占位工具</h3> </div> <div class="tool-card-body"> <div class="alert alert-warning"> <i class="fas fa-exclamation-triangle"></i> 此功能正在开发中,敬请期待! </div> </div> </div> <div class="tool-card" id="converter-tool" style="display: none;"> <div class="tool-card-header"> <h3 class="tool-card-title"><i class="fas fa-exchange-alt"></i> 格式转换</h3> </div> <div class="tool-card-body"> <div class="alert alert-warning"> <i class="fas fa-exclamation-triangle"></i> 此功能正在开发中,敬请期待! </div> </div> </div> <div class="tool-card" id="analyzer-tool" style="display: none;"> <div class="tool-card-header"> <h3 class="tool-card-title"><i class="fas fa-chart-bar"></i> 数据分析</h3> </div> <div class="tool-card-body"> <div class="alert alert-warning"> <i class="fas fa-exclamation-triangle"></i> 此功能正在开发中,敬请期待! </div> </div> </div> <div class="tool-card" id="validator-tool" style="display: none;"> <div class="tool-card-header"> <h3 class="tool-card-title"><i class="fas fa-check-circle"></i> 数据验证</h3> </div> <div class="tool-card-body"> <div class="alert alert-warning"> <i class="fas fa-exclamation-triangle"></i> 此功能正在开发中,敬请期待! </div> </div> </div> </div> </div> </div> <script src="./js/bootstrap.bundle.min.js"></script> <script> // 工具切换功能 document.addEventListener('DOMContentLoaded', function() { const toolItems = document.querySelectorAll('.tool-item'); const toolCards = document.querySelectorAll('.tool-card'); toolItems.forEach(item => { item.addEventListener('click', function() { // 移除所有活动状态 toolItems.forEach(i => i.classList.remove('active')); toolCards.forEach(c => c.style.display = 'none'); // 添加当前活动状态 this.classList.add('active'); const toolId = this.getAttribute('data-tool') + '-tool'; document.getElementById(toolId).style.display = 'block'; }); }); // 图片大小滑块显示 const sizeSlider = document.getElementById('image-size'); const sizeValue = document.getElementById('size-value'); sizeSlider.addEventListener('input', function() { sizeValue.textContent = this.value + ' MB'; }); // 表单提交事件 const imageForm = document.getElementById('image-generator-form'); const loadingIndicator = document.getElementById('loading-indicator'); const resultContainer = document.getElementById('result-container'); const fileSize = document.getElementById('file-size'); const fileFormat = document.getElementById('file-format'); const imageDimensions = document.getElementById('image-dimensions'); const generationTime = document.getElementById('generation-time'); const downloadBtn = document.getElementById('download-btn'); const generateBtn = document.getElementById('generate-btn'); imageForm.addEventListener('submit', function(e) { e.preventDefault(); // 获取表单数据 const sizeMB = parseFloat(sizeSlider.value); const format = document.getElementById('image-format').value; const width = parseInt(document.getElementById('image-width').value); const height = parseInt(document.getElementById('image-height').value); // 验证输入 if (width < 10 || width > 5000 || height < 10 || height > 5000) { alert('图片尺寸必须在10到5000像素之间'); return; } // 显示加载指示器 loadingIndicator.classList.add('active'); resultContainer.classList.remove('active'); generateBtn.disabled = true; generateBtn.innerHTML = '<i class="fas fa-spinner fa-spin"></i> 生成中...'; // 模拟生成过程 setTimeout(() => { // 生成图片数据(这里使用canvas模拟) const canvas = document.createElement('canvas'); canvas.width = width; canvas.height = height; const ctx = canvas.getContext('2d'); // 绘制背景 ctx.fillStyle = '#f0f0f0'; ctx.fillRect(0, 0, width, height); // 绘制网格 ctx.strokeStyle = '#ddd'; ctx.lineWidth = 1; for (let x = 0; x <= width; x += 50) { ctx.beginPath(); ctx.moveTo(x, 0); ctx.lineTo(x, height); ctx.stroke(); } for (let y = 0; y <= height; y += 50) { ctx.beginPath(); ctx.moveTo(0, y); ctx.lineTo(width, y); ctx.stroke(); } // 绘制尺寸信息 ctx.fillStyle = '#333'; ctx.font = 'bold 24px Arial'; ctx.textAlign = 'center'; ctx.textBaseline = 'middle'; ctx.fillText(`${width} × ${height}`, width/2, height/2); // 转换为数据URL const dataURL = canvas.toDataURL(`image/${format}`); // 更新结果区域 const imagePreview = document.getElementById('image-preview'); imagePreview.src = dataURL; fileSize.textContent = sizeMB.toFixed(1) + ' MB'; fileFormat.textContent = format.toUpperCase(); imageDimensions.textContent = `${width} × ${height}`; generationTime.textContent = new Date().toLocaleString('zh-CN'); // 设置下载按钮 downloadBtn.onclick = function() { const link = document.createElement('a'); link.download = `generated-image.${format}`; link.href = dataURL; link.click(); }; // 隐藏加载指示器,显示结果 loadingIndicator.classList.remove('active'); resultContainer.classList.add('active'); generateBtn.disabled = false; generateBtn.innerHTML = '<i class="fas fa-magic"></i> 生成图片'; }, 1500); }); // 重置按钮 document.getElementById('reset-btn').addEventListener('click', function() { sizeSlider.value = 1; sizeValue.textContent = '1 MB'; document.getElementById('image-format').value = 'png'; document.getElementById('image-width').value = '800'; document.getElementById('image-height').value = '600'; resultContainer.classList.remove('active'); generateBtn.disabled = false; generateBtn.innerHTML = '<i class="fas fa-magic"></i> 生成图片'; }); }); </script> </body> </html> 修复我的代码
11-20
<!DOCTYPE html> <html lang="zh-CN"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>用户登录 - 网站名称</title> <style> body { font-family: 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif; line-height: 1.6; color: #333; background-color: #f5f5f5; margin: 0; padding: 20px; display: flex; justify-content: center; align-items: center; min-height: 100vh; } .login-container { background: white; padding: 2rem; border-radius: 8px; box-shadow: 0 2px 10px rgba(0, 0, 0, 0.1); width: 100%; max-width: 400px; } h2 { margin-top: 0; color: #2c3e50; text-align: center; } .form-group { margin-bottom: 1.5rem; } label { display: block; margin-bottom: 0.5rem; font-weight: 500; } input[type="text"], input[type="password"] { width: 100%; padding: 0.75rem; border: 1px solid #ddd; border-radius: 4px; font-size: 1rem; transition: border-color 0.3s; } input[type="text"]:focus, input[type="password"]:focus { border-color: #3498db; outline: none; box-shadow: 0 0 0 2px rgba(52, 152, 219, 0.2); } .btn { display: block; width: 100%; padding: 0.75rem; background-color: #3498db; color: white; border: none; border-radius: 4px; font-size: 1rem; font-weight: 500; cursor: pointer; transition: background-color 0.3s; } .btn:hover { background-color: #2980b9; } .footer-links { margin-top: 1.5rem; text-align: center; } .footer-links a { color: #3498db; text-decoration: none; } .footer-links a:hover { text-decoration: underline; } .error-message { color: #e74c3c; font-size: 0.875rem; margin-top: 0.25rem; } </style> </head> <body> <div class="login-container"> <h2>用户登录</h2> <form method="post" novalidate> <input type="hidden" name="csrfmiddlewaretoken" value="xhocjmhFhEa5TOFmssbcaz0EY3daTEbTqidOfc8Wt5zP5IfucpocUGqHNoXl7SZw"> <div class="form-group"> <label for="id_username">用户名</label> <input type="text" id="id_username" name="username" required autofocus> </div> <div class="form-group"> <label for="id_password">密码</label> <input type="password" id="id_password" name="password" required> </div> <button type="submit" class="btn">登录</button> <div class="footer-links"> <p> <p>还没有账号?<a href="/register/">立即注册</a></p> <br> </p> </div> </form> </div> </body> </html>什么问题导致我切换了界面
06-07
改变原有代码的情况下使呈现效果如图 <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>用户留言</title> <link rel="stylesheet" href="../css/comm.css"> <style> a{ text-decoration: underline; color: black; } .breadcrumb{ margin-left: 355px; font-size: 12px; height: 10px; } label{ display: inline-block; width:100px; text-align: right; } form{ margin-top:20px; } form span{ color:darkred; } .msg{ display: block; text-indent:110px; text-decoration: line-through; } #btn{ text-align: center; } #btn input{ width:40px; margin-top:10px; margin-right:20px; } </style> <script> </script> </head> <body> <div id="container"> <div id="header"> <ul> <li><a href="../文具/index.html">首页</a></li> <li><a href="news.html">新闻动态</a></li> <li><a href="products.html">产品展示</a></li> <li><a href="liuyan.html">信息反馈</a></li> <li><a href="about.html">关于我们</a></li> </ul> <div id="logo"> <img src="images/logo.gif" alt=""> </div> </div> <div id="leftbar"> <ul> <li>查看留言</li> <li>写留言</li> <li>搜索留言</li> <li><a href="login.html">登陆管理</a> </li> </ul> </div> <div id="main"> <div class="breadcrumb"> <a href="index.html">首页</a> > <a href="login.html">信息反馈</a> > <a href="">写留言</a> </div> <h3>发表留言</h3> <form action=""> <p> <label for="username">您的称呼:</label> <input type="text" id="username"><span>**</span> </p> <p> <label for="email">电子邮件:</label> <input type="text" id="email"><span>**</span> </p> <p> <label for="title">标题:</label> <input type="text" id="title"><span>**</span> </p> <p> <label for="content">正文:</label> <textarea name="content" cols="30" rows="10"></textarea> <br> <span id="msg">留言内容能超过500字,**为必填</span> </p> <p> <label for="code">验证码:</label> <input type="text" id="code"><span>**</span> </p> <p> <input type="submit" value="提交" class="btn"> <input type="reset" value="重置" class="btn"> </p> </form> </div> <div id="footer"> <p> ©2006 简单文具有限公司设计与维护| 地址:广州市白云区沙太麒麟岗 |电话:020-6136xxxx</p> </div> </div> </body> </html>
最新发布
12-26
<!DOCTYPE HTML> <html> <head> <meta charset="utf-8"> <meta name="renderer" content="webkit|ie-comp|ie-stand"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no"/> <meta http-equiv="Cache-Control" content="no-siteapp"/> <!--[if lt IE 9]> <script type="text/javascript" src="../lib/html5shiv.js"></script> <script type="text/javascript" src="../lib/respond.min.js"></script> <![endif]--> <link rel="stylesheet" type="text/css" href="../static/h-ui/css/H-ui.min.css"/> <link rel="stylesheet" type="text/css" href="../static/h-ui.admin/css/H-ui.admin.css"/> <link rel="stylesheet" type="text/css" href="../lib/Hui-iconfont/1.0.8/iconfont.css"/> <link rel="stylesheet" type="text/css" href="../static/h-ui.admin/skin/default/skin.css" id="skin"/> <link rel="stylesheet" type="text/css" href="../static/h-ui.admin/css/style.css"/> <!--[if IE 6]> <script type="text/javascript" src="../lib/DD_belatedPNG_0.0.8a-min.js"></script> <script>DD_belatedPNG.fix('*');</script> <![endif]--> <title>销售明细查询(长春)</title> <style type="text/css"> /**tabs**/ /*.tabPanel ul{height:30px;border-bottom:1px solid #aaa;}*/ /*.tabPanel ul li{*/ /* float:left;margin:0 2px 0 0;border:1px solid #aaa;font-size:11px;height:29px;line-height:30px;width:111px;text-align:center;cursor:pointer;*/ /* text-shadow:0 1px 0 #fff;*/ /* border-radius:4px 4px 0 0;*/ /* box-shadow:inset 0 1px 0 rgba(255, 255, 255, 0.5);*/ /* background:#ddd;*/ /* background:-moz-linear-gradient(top, #eee, #ddd);*/ /* background:-webkit-gradient(linear, left top, left bottom, from(#eee), to(#ddd));*/ /*}*/ /*.tabPanel .hit{*/ /* border-bottom:1px solid #fff;cursor:pointer;color:black;text-shadow:0 1px 0 #fff;*/ /* background:#fff;*/ /* background:-webkit-gradient(linear, left top, left bottom, from(#e1e1e1), to(#fff));*/ /* background:-moz-linear-gradient(top, #e1e1e1, #fff);*/ /*}*/ /*.pane{border:1px solid #aaa;border-top:0;min-height:100px;background-color:#fff;display:none;}*/ /*.pane p{padding:15px 15px 0 10px;}*/ /*.pane h4{padding:15px 15px 0 10px;font-size:14px;font-weight:bold;}*/ td { text-align: center; } .overLoading { display: none; position: absolute; top: 0; left: 0; width: 100%; height: 100%; background-color: #f5f5f5; opacity: 0.5; z-index: 1000; } .layoutLoading { display: none; position: absolute; top: 40%; left: 40%; width: 20%; height: 20%; z-index: 1001; text-align: center; } </style> </head> <body> <!-- 新增加载提示元素(解决JS报错) --> <div class="overLoading" id="over"></div> <div class="layoutLoading" id="layout">加载中...</div> <nav class="breadcrumb"> <i class="Hui-iconfont"></i> 首页 <span class="c-gray en">></span>销售明细查询 <span class="c-gray en">></span>销售明细查询(长春) <a class="btn btn-success radius r" style="line-height:1.6em;margin-top:3px" href="javascript:location.replace(location.href);" title="刷新"><i class="Hui-iconfont"></i></a> </nav> <div class="page-container"> <div class="mt-20"> <div class="page-container" style="margin-top: 0px;padding-top: 0px;"> <div class="row cl"> <table style="margin-left: 50px;margin-top:0px;border-collapse:separate; border-spacing:0px 5px; width: calc(100% - 100px);"> <tr> <td colspan="2">下单日期: <input type="text" id="date1" onfocus="WdatePicker({ dateFmt:'yyyy-MM-dd',})" class="Wdate"/> - <input type="text" id="date2" onfocus="WdatePicker({ minDate:'#F{$dp.$D(\'date1\')}',maxDate:'2029-12-31', })" class="Wdate"/> </td> <td colspan="1"> <input id="date11" name="selectDate" type="radio" value="本年" onclick="selectDate1()"/>本年 <input id="date22" name="selectDate" checked type="radio" value="近3年" onclick="selectDate2()"/>近3年 <input id="date33" name="selectDate" type="radio" value="近10年" onclick="selectDate3()"/>近10年 </td> <td colspan="3" style="text-align: left;"> <button class="btn btn-secondary-outline radius" id="search" style="float: left" onclick="submit_order()"> <i class="Hui-iconfont"></i>检索 </button> </td> </tr> <tr> <!-- 发货客户编号 --> <td style="alignment: left">发货客户编号: <select id="fhkhbh"> <option value="0">所有</option> <option value="60009">60009</option> <option value="2000000108">2000000108</option> <option value="1000200000">1000200000</option> </select> </td> <!-- 领料单位 --> <td style="alignment: left">领料单位: <select id="lldw"> <option value="0">所有</option> <option value="中国铁路北京局集团有限公司">中国铁路北京局集团有限公司</option> <option value="北京动车段">北京动车段</option> <option value="北京北所">北京北所</option> <option value="北京南动车所">北京南动车所</option> <option value="朝阳所">朝阳所</option> <option value="石家庄动车所">石家庄动车所</option> <option value="雄安所">雄安所</option> <option value="北京东动车所">北京东动车所</option> <option value="中车长春轨道客车股份有限公司">中车长春轨道客车股份有限公司</option> <option value="北京西所">北京西所</option> </select> </td> <!-- 物料来源 --> <td style="alignment: left">物料来源: <select id="wlly"> <option value="0">所有</option> <option value="供应商寄售">供应商寄售</option> <option value="配件公司直采">配件公司直采</option> <option value="配件公司库存">配件公司库存</option> <option value="销售退货">销售退货</option> </select> </td> <!-- 库存地点 --> <td style="alignment: left">库存地点: <select id="kcdd"> <option value="0">所有</option> <option value="配件中心-北京动车段">配件中心-北京动车段</option> <option value="配件中心-北京北所">配件中心-北京北所</option> <option value="配件中心-北京中心库销货库">配件中心-北京中心库销货库</option> <option value="配件中心-北京动车段中心库">配件中心-北京动车段中心库</option> </select> </td> <!-- 开票状态 --> <td style="alignment: left">开票状态: <select id="kpzt"> <option value="0">所有</option> <option value="YES">YES</option> <option value="NO">NO</option> </select> </td> <td style="alignment: left"> <button class="btn btn-secondary-outline radius" id="huizong" onclick="downloadExl1()"> <i class="Hui-iconfont"></i>导出 </button> </td> </tr> <tr> <!-- 车型 --> <td style="alignment: left">车型: <select id="cx"> <option value="0">所有</option> <option value="CR400BF">CR400BF</option> <option value="CRH380B">CRH380B</option> <option value="CRH5A">CRH5A</option> <option value="CRH380CL">CRH380CL</option> <option value="CRH3A">CRH3A</option> <option value="CR400BF-G">CR400BF-G</option> <option value="CRH5G">CRH5G</option> <option value="CRH380BL">CRH380BL</option> <option value="CR400BF-C">CR400BF-C</option> <option value="CRH3">CRH3</option> <option value="CR400BF-A">CR400BF-A</option> <option value="CRH380BG">CRH380BG</option> <option value="CRH400BF">CRH400BF</option> <option value="CRH380B/BL">CRH380B/BL</option> <option value="CRH380BK">CRH380BK</option> <option value="CRH5">CRH5</option> <option value="CR400BF-Z">CR400BF-Z</option> <option value="CR400BF-GZ">CR400BF-GZ</option> </select> </td> <!-- 修程 --> <td style="alignment: left">修程: <select id="xc"> <option value="0">所有</option> <option value="CR03">CR03</option> <option value="A42">A42</option> <option value="L3">L3</option> <option value="A21">A21</option> <option value="CR00">CR00</option> <option value="CR01">CR01</option> <option value="CR02">CR02</option> <option value="A31">A31</option> <option value="A32">A32</option> <option value="A11">A11</option> <option value="CR04">CR04</option> </select> </td> <td colspan="4"></td> </tr> <!-- 复选框区域 --> <tr> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option1"> <span class="checkbox-icon"></span> <span class="checkbox-label">出库单号</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option2" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">出库单序号</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option3"> <span class="checkbox-icon"></span> <span class="checkbox-label">出库单状态</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option4"> <span class="checkbox-icon"></span> <span class="checkbox-label">创建间</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option5"> <span class="checkbox-icon"></span> <span class="checkbox-label">创建人</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option6" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">销售办公室</span> </label> </td> </tr> <tr> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option7"> <span class="checkbox-icon"></span> <span class="checkbox-label">发货客户编号</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option8"> <span class="checkbox-icon"></span> <span class="checkbox-label">客户名称</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option9"> <span class="checkbox-icon"></span> <span class="checkbox-label">领料单位</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option10"> <span class="checkbox-icon"></span> <span class="checkbox-label">领料人</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option11"> <span class="checkbox-icon"></span> <span class="checkbox-label">过账日期</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option12"> <span class="checkbox-icon"></span> <span class="checkbox-label">计划编号</span> </label> </td> </tr> <tr> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option13" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">计划行号</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option14" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">路局计划号</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option15" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">路局采购单号</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option16" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">SAP物料</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option17"> <span class="checkbox-icon"></span> <span class="checkbox-label">物料描述</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option18" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">基本计量单位</span> </label> </td> </tr> <tr> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option19" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">物资编码</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option20"> <span class="checkbox-icon"></span> <span class="checkbox-label">数量</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option21"> <span class="checkbox-icon"></span> <span class="checkbox-label">含税单价</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option22"> <span class="checkbox-icon"></span> <span class="checkbox-label">税率</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option23"> <span class="checkbox-icon"></span> <span class="checkbox-label">含税金额合计</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option24" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">价格来源</span> </label> </td> </tr> <tr> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option25" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">退货数量</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option26" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">应开票数量</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option27" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">应开票金额</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option28" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">已开票数量</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option29" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">已开票税前金额</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option30" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">已开票税后金额</span> </label> </td> </tr> <tr> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option31" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">未开票数量</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option32" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">未开票税前金额</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option33" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">未开票税后金额</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option34" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">批次</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option35"> <span class="checkbox-icon"></span> <span class="checkbox-label">物料来源</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option36"> <span class="checkbox-icon"></span> <span class="checkbox-label">库存地点</span> </label> </td> </tr> <tr> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option37"> <span class="checkbox-icon"></span> <span class="checkbox-label">开票状态</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option38"> <span class="checkbox-icon"></span> <span class="checkbox-label">车型</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option39" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">单价</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option40" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">车组号</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option41"> <span class="checkbox-icon"></span> <span class="checkbox-label">修程</span> </label> </td> <td style="alignment: left"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option42" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">货主</span> </label> </td> </tr> <tr> <td style="alignment: left" colspan="2"> <label class="checkbox-item"> <input type="checkbox" name="option" value="option43" checked> <span class="checkbox-icon"></span> <span class="checkbox-label">总价</span> </label> </td> <td colspan="4"></td> </tr> </table> </div> <div class="row cl" style="margin-top: 20px;"></div> <div id="testTable" style="margin: auto;"> <table class="table table-border table-bordered table-hover table-bg table-sort" id="testCheck" style="margin-top: 30px; width: auto; table-layout: auto; word-wrap: break-word; word-break: break-all;"> <thead id="title"> <tr class="text-c"> <th data-column="option1" style="text-align: center;">出库单号</th> <th data-column="option2" style="text-align: center;">出库单序号</th> <th data-column="option3" style="text-align: center;">出库单状态</th> <th data-column="option4" style="text-align: center;">创建间</th> <th data-column="option5" style="text-align: center;">创建人</th> <th data-column="option6" style="text-align: center;">销售办公室</th> <th data-column="option7" style="text-align: center;">发货客户编号</th> <th data-column="option8" style="text-align: center;">客户名称</th> <th data-column="option9" style="text-align: center;">领料单位</th> <th data-column="option10" style="text-align: center;">领料人</th> <th data-column="option11" style="text-align: center;">过账日期</th> <th data-column="option12" style="text-align: center;">计划编号</th> <th data-column="option13" style="text-align: center;">计划行号</th> <th data-column="option14" style="text-align: center;">路局计划号</th> <th data-column="option15" style="text-align: center;">路局采购单号</th> <th data-column="option16" style="text-align: center;">SAP物料</th> <th data-column="option17" style="text-align: center;">物料描述</th> <th data-column="option18" style="text-align: center;">基本计量单位</th> <th data-column="option19" style="text-align: center;">物资编码</th> <th data-column="option20" style="text-align: center;">数量</th> <th data-column="option21" style="text-align: center;">含税单价</th> <th data-column="option22" style="text-align: center;">税率</th> <th data-column="option23" style="text-align: center;">含税金额合计</th> <th data-column="option24" style="text-align: center;">价格来源</th> <th data-column="option25" style="text-align: center;">退货数量</th> <th data-column="option26" style="text-align: center;">应开票数量</th> <th data-column="option27" style="text-align: center;">应开票金额</th> <th data-column="option28" style="text-align: center;">已开票数量</th> <th data-column="option29" style="text-align: center;">已开票税前金额</th> <th data-column="option30" style="text-align: center;">已开票税后金额</th> <th data-column="option31" style="text-align: center;">未开票数量</th> <th data-column="option32" style="text-align: center;">未开票税前金额</th> <th data-column="option33" style="text-align: center;">未开票税后金额</th> <th data-column="option34" style="text-align: center;">批次</th> <th data-column="option35" style="text-align: center;">物料来源</th> <th data-column="option36" style="text-align: center;">库存地点</th> <th data-column="option37" style="text-align: center;">开票状态</th> <th data-column="option38" style="text-align: center;">车型</th> <th data-column="option39" style="text-align: center;">单价</th> <th data-column="option40" style="text-align: center;">车组号</th> <th data-column="option41" style="text-align: center;">修程</th> <th data-column="option42" style="text-align: center;">货主</th> <th data-column="option43" style="text-align: center;">总价</th> </tr> </thead> <tbody id="info"> </tbody> </table> </div> </div> </div> </div> <!--_footer 作为公共模版分离出去--> <script type="text/javascript" src="../lib/jquery/1.9.1/jquery.min.js"></script> <script type="text/javascript" src="../lib/layer/2.4/layer.js"></script> <script type="text/javascript" src="../static/h-ui/js/H-ui.min.js"></script> <script type="text/javascript" src="../static/h-ui.admin/js/H-ui.admin.js"></script> <script type="text/javascript" src="../js/apply.js"></script> <!--/_footer 作为公共模版分离出去--> <!--业务相关脚本--> <script type="text/javascript" src="../lib/hcharts/Highcharts/5.0.6/js/highcharts.js"></script> <script type="text/javascript" src="../lib/hcharts/Highcharts/5.0.6/js/modules/exporting.js"></script> <script type="text/javascript" src="../lib/My97DatePicker/4.8/WdatePicker.js"></script> <script type="text/javascript" src="../lib/datatables/1.10.0/jquery.dataTables.min.js"></script> <script type="text/javascript" src="../lib/laypage/1.2/laypage.js"></script> <script type="text/javascript" src="../js/xlsx.full.min.js"></script> <script type="text/javascript" src="../js/sheetJson.js"></script> <script type="text/javascript"> var baseurl = getURL(); $(function () { startCookie(); selectDate2(); // submit_order(); }); // 日期选择相关函数 function getThisYear() { var now = new Date(); var year = now.getFullYear(); return [year + "-01-01", year + "-12-31"]; } function getThreeYear() { var now = new Date(); var year = now.getFullYear(); return [(year - 2) + "-01-01", year + "-12-31"]; } function getTenYear() { var now = new Date(); var year = now.getFullYear(); return [(year - 9) + "-01-01", year + "-12-31"]; } function selectDate1() { var thisYear = getThisYear(); $("#date1").val(thisYear[0]); $("#date2").val(thisYear[1]); } function selectDate2() { var threeYear = getThreeYear(); $("#date1").val(threeYear[0]); $("#date2").val(threeYear[1]); } function selectDate3() { var tenYear = getTenYear(); $("#date1").val(tenYear[0]); $("#date2").val(tenYear[1]); } // 生成复选框选中状态数组 function generateOptionList() { const checkboxes = document.querySelectorAll('input[name="option"]'); return Array.from(checkboxes).map(checkbox => checkbox.checked ? 1 : 0); } // 复选框与表格列同步逻辑 document.addEventListener('DOMContentLoaded', function () { const checkboxes = document.querySelectorAll('input[name="option"]'); const tableHeaders = document.querySelectorAll('#testCheck th'); const tableRows = document.querySelectorAll('#testCheck tbody tr'); // 初始化表格列显示 updateTableColumns(); // 监听复选框变化 checkboxes.forEach(checkbox => { checkbox.addEventListener('change', updateTableColumns); }); // 更新表格列显示状态 function updateTableColumns() { const selectedColumns = Array.from(checkboxes) .filter(cb => cb.checked) .map(cb => cb.value); // 更新表头 tableHeaders.forEach(header => { const columnName = header.getAttribute('data-column'); header.style.display = selectedColumns.includes(columnName) ? 'table-cell' : 'none'; }); // 更新数据行 tableRows.forEach(row => { const cells = row.querySelectorAll('td'); cells.forEach((cell, index) => { cell.style.display = tableHeaders[index].style.display; }); }); } window.updateTableColumns = updateTableColumns; }); // 查询函数 var printCase = []; function submit_order() { var pkStr = ""; var date1 = $("#date1").val(); var date2 = $("#date2").val(); // 获取下拉框选中的文本内容 var fhkhbh = document.querySelector('#fhkhbh option:checked')?.textContent || ''; var lldw = document.querySelector('#lldw option:checked')?.textContent || ''; var wlly = document.querySelector('#wlly option:checked')?.textContent || ''; var kcdd = document.querySelector('#kcdd option:checked')?.textContent || ''; var kpzt = document.querySelector('#kpzt option:checked')?.textContent || ''; var cx = document.querySelector('#cx option:checked')?.textContent || ''; var xc = document.querySelector('#xc option:checked')?.textContent || ''; // 拼接日期条件 if (date1) pkStr += "cjsj>='" + date1 + "'&&"; if (date2) pkStr += "cjsj<='" + date2 + "'&&"; // 拼接下拉框条件(包含查询) if (fhkhbh !== "所有") pkStr += "fhkhbh conta'" + fhkhbh + "'&&"; if (lldw !== "所有") pkStr += "lldw conta'" + lldw + "'&&"; if (wlly !== "所有") pkStr += "wlly conta'" + wlly + "'&&"; if (kcdd !== "所有") pkStr += "kcdd conta'" + kcdd + "'&&"; if (kpzt !== "所有") pkStr += "kpzt conta'" + kpzt + "'&&"; if (cx !== "所有") pkStr += "cx conta'" + cx + "'&&"; if (xc !== "所有") pkStr += "xc conta'" + xc + "'&&"; // 处理末尾多余的&& if (pkStr.length >= 2 && pkStr.slice(-2) === "&&") { pkStr = pkStr.slice(0, -2); } console.log("查询条件:", pkStr); $.ajax( { type: "post", url: baseurl + "chazhao/", dataType: 'json', data: { tablename: "`jjmx(c)`", pk: pkStr, }, beforeSend: function () { $("#over").show(); $("#layout").show(); }, success: function (res) { console.log("查询结果:", res); var result = res.data || []; var newResult = []; for (var i = 0; i < result.length; i++) { if (result[i]) newResult.push(result[i]); } // 表格配置 // 处理空值 console.log("newResult:"); console.log(newResult); var ifLeft = 1; var ifTop = 1; var title = [ "出库单号", "出库单序号", "出库单状态", "创建间", "创建人", "销售办公室", "发货客户编号", "客户名称", "领料单位", "领料人", "过账日期", "计划编号", "计划行号", "路局计划号", "路局采购单号", "SAP物料", "物料描述", "基本计量单位", "物资编码", "数量", "含税单价", "税率", "含税金额合计", "价格来源", "退货数量", "应开票数量", "应开票金额", "已开票数量", "已开票税前金额", "已开票税后金额", "未开票数量", "未开票税前金额", "未开票税后金额", "批次", "物料来源", "库存地点", "开票状态", "车型", "单价", "车组号", "修程", "货主", "总价"] var titledisplay = generateOptionList(); var ifDetailInfo = ["0",]; var ifCheckBox = 0; var ifDetail = []; var operating = []; var rowArray = [ "ckdh", "ckdxh", "ckdzt", "cjsj", "cjr", "ssbgs", "fhkhbh", "khmc", "lldw", "llr", "gzrq", "jhbh", "jjhh", "ljjhh", "ljcgdh", "sapwl", "wpms", "jbjldw", "wzbm", "number", "bhsjg", "sl", "hsjehj", "jgly", "thsl", "ykpsl", "ykpje", "ykpsl-already", "ykpsqje", "ykpshje", "wkpsl", "wkpsqje", "wkpshje", "pc", "wlly", "kcdd", "kpzt", "cx", "dj", "czh", "xc", "hz", "zj"]; for (var i = 0; i < newResult.length; i++) { for (var j = 0; j < rowArray.length; j++) { if (newResult[i][rowArray[j]] === null || newResult[i][rowArray[j]] === "" || newResult[i][rowArray[j]] === undefined) { newResult[i][rowArray[j]] = ""; } } } console.log("newResult:"); console.log(newResult); var rowdisplay = titledisplay var allCon = showTable(ifLeft, ifTop, title, newResult, ifDetailInfo, ifCheckBox, ifDetail, operating, rowArray, titledisplay, rowdisplay); $("#testCheck").dataTable().fnDestroy();//彻底清空表格数据 $('#title').empty().append(allCon[0]); $('#info').empty().append(allCon[1]); $('.table-sort').dataTable({ "aaSorting": [ [0, "asc"] ], //从第0列开始,第1列倒序排序 "bStateSave": true, //状态保存 "bRetrieve": true, "aoColumnDefs": [ //{"bVisible": false, "aTargets": [ 3 ]} //控制列的隐藏显示 {"orderable": false} // 制定列参与排序 // { "orderable": false, "aTargets": [1] } // 制定列参与排序 ] }); }, complete: function () { // 可以在这里隐藏加载提示 } }); } // 导出Excel函数 function downloadExl1() { var pkStr = ""; var date1 = $("#date1").val(); var date2 = $("#date2").val(); // 获取下拉框选中的文本内容 var fhkhbh = document.querySelector('#fhkhbh option:checked')?.textContent || ''; var lldw = document.querySelector('#lldw option:checked')?.textContent || ''; var wlly = document.querySelector('#wlly option:checked')?.textContent || ''; var kcdd = document.querySelector('#kcdd option:checked')?.textContent || ''; var kpzt = document.querySelector('#kpzt option:checked')?.textContent || ''; var cx = document.querySelector('#cx option:checked')?.textContent || ''; var xc = document.querySelector('#xc option:checked')?.textContent || ''; // 拼接日期条件 if (date1) pkStr += "cjsj>='" + date1 + "'&&"; if (date2) pkStr += "cjsj<='" + date2 + "'&&"; // 拼接下拉框条件(包含查询) if (fhkhbh !== "所有") pkStr += "fhkhbh conta'" + fhkhbh + "'&&"; if (lldw !== "所有") pkStr += "lldw conta'" + lldw + "'&&"; if (wlly !== "所有") pkStr += "wlly conta'" + wlly + "'&&"; if (kcdd !== "所有") pkStr += "kcdd conta'" + kcdd + "'&&"; if (kpzt !== "所有") pkStr += "kpzt conta'" + kpzt + "'&&"; if (cx !== "所有") pkStr += "cx conta'" + cx + "'&&"; if (xc !== "所有") pkStr += "xc conta'" + xc + "'&&"; // 处理末尾多余的&& if (pkStr.length >= 2 && pkStr.slice(-2) === "&&") { pkStr = pkStr.slice(0, -2); } $.ajax({ type: "post", url: baseurl + "chazhao/", dataType: 'json', data: { tablename: "`jjmx(c)`", pk: pkStr, }, beforeSend: function () { $("#over").show(); $("#layout").show(); }, success: function (res) { var result = res.data || []; var newResult = []; for (var i = 0; i < result.length; i++) { if (result[i]) newResult.push(result[i]); } // 导出字段配置 var sheetNameMap = { "出库单号": "ckdh", "出库单序号": "ckdxh", "出库单状态": "ckdzt", "创建间": "cjsj", "创建人": "cjr", "销售办公室": "ssbgs", "发货客户编号": "fhkhbh", "客户名称": "khmc", "领料单位": "lldw", "领料人": "llr", "过账日期": "gzrq", "计划编号": "jhbh", "计划行号": "jjhh", "路局计划号": "ljjhh", "路局采购单号": "ljcgdh", "SAP物料": "sapwl", "物料描述": "wpms", "基本计量单位": "jbjldw", "物资编码": "wzbm", "数量": "number", "含税单价": "bhsjg", "税率": "sl", "含税金额合计": "hsjehj", "价格来源": "jgly", "退货数量": "thsl", "应开票数量": "ykpsl", "应开票金额": "ykpje", "已开票数量": "ykpsl-already", "已开票税前金额": "ykpsqje", "已开票税后金额": "ykpshje", "未开票数量": "wkpsl", "未开票税前金额": "wkpsqje", "未开票税后金额": "wkpshje", "批次": "pc", "物料来源": "wlly", "库存地点": "kcdd", "开票状态": "kpzt", "车型": "cx", "单价": "dj", "车组号": "czh", "修程": "xc", "货主": "hz", "总价": "zj" }; // 转换导出数据格式 var exportData = newResult.map(item => { var data = {}; Object.keys(sheetNameMap).forEach(key => { data[key] = item[sheetNameMap[key]] || ""; }); return data; }); // 导出Excel var workbook = sheetJson.toSheet({ sheetName: Object.keys(sheetNameMap), datas: exportData }); sheetJson.downloadExl(workbook, "销售明细查询(长春)汇总"); }, complete: function () { $("#over").hide(); $("#layout").hide(); }, error: function (err) { console.error("导出失败:", err); $("#over").hide(); $("#layout").hide(); } }); } </script> </body> </html>前端页面显示数据,我基金崩溃
11-28
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值