|
发表于 2019-10-22 21:25
来自手机
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
大嘴鱼5 发表于 2019-10-22 14:59
谢谢各位老师。
做了一个web版本
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<style>
tr:hover {
background-color:yellow;
}
#wrap {
/*
width:100%;
*/
}
#wrap table{
/*
width:95%;
*/
}
#wrap table td{
}
#wrap table .checkbox{
//width:60px;
}
</style>
<title>filter</title>
</head>
<body >
欢迎您<b>user2</b> <a href="?logout=1">登出</a>
<input type="button" value="筛选" onclick="filter()">
<div id="wrap">
</div>
</body>
<script>all_rows=[{"学号":"1","姓名":"王一","语文":"88","英语":"88","数学":"88","体育":"88"},{"学号":"2","姓名":"张二","语文":"56","英语":"55","数学":"55","体育":"44"},{"学号":"3","姓名":"李三","语文":"43","英语":"45","数学":"44","体育":"44"},{"学号":"4","姓名":"刘四","语文":"62","英语":"78","数学":"46","体育":"79"},{"学号":"5","姓名":"赵五","语文":"90","英语":"99","数学":"93","体育":"94"}];
//alert(result[0]["姓名"]);
</script><script>
function display(result,nocheck){
//打印表头
a=result[0];
headers = Object.keys(a);
//alert(headers[0]);
html= "<table border=1 cellpadding=10 cellspacing=0 id=cartTable ><tr>";
for(j=0; j<headers.length; j++)
{
html+="<th>";
html+=headers[j];
html+="</th>";
}
if(nocheck!=1){
html+="<th>";
html+="选择";
html+="</th>";
}
html+= "</tr>\n";
//html+= "<tbody id=\"rows\">\n";
//表体
for(j=0; j<result.length; j++)
{
html+= "<tr>";
for(z=0; z<headers.length; z++)
{
html+="<td>";
html+=result[j][headers[z]];
html+="</td>";
}
if(nocheck!=1){
html+="<td>";
html+="<input class=\"check\" type=\"checkbox\" value=\""+j+"\"/>";
html+="</td>";
html+= "</tr>\n";
}//nocheck
}
//html+= "</tbody>\n";
html+="</table>";
//alert(html)
document.getElementById("wrap").innerHTML=html;
}
display(all_rows);
</script>
<script>
//alert(arr[0]);
function filter(){
var table=document.getElementById("cartTable");
var arr_checks=document.querySelectorAll("#cartTable .check");
var j=0;
var arr=new Array;
for(j=0; j<arr_checks.length; j++)
{
if(arr_checks[j].checked){
//alert(arr_checks[j].value);
arr.push(all_rows[parseInt(arr_checks[j].value)]);
}
}
console.log(JSON.stringify(arr));
display(arr,1);
}
//filter();
</script>
</html>
|
-
|