<!DOCTYPE html>
<html>
<head>
<title>JQueryFunction</title>
<script src="jquery-3.2.1.min.js"></script>
<script>
function test2() {
var jsonData = [{ '科目': "语文", '模块': "模块1", '分数': 78 },
{ '科目': "数学", '模块': "模块5", '分数': 78 },
{ '科目': "语文", '模块': "模块2", '分数': 65 },
{ '科目': "语文", '模块': "模块3", '分数': 98 },
{ '科目': "英语", '模块': "模块2", '分数': 68 },
{ '科目': "数学", '模块': "模块1", '分数': 66 },
{ '科目': "数学", '模块': "模块2", '分数': 89 },
{ '科目': "英语", '模块': "模块1", '分数': 77 },
{ '科目': "数学", '模块': "模块3", '分数': 90 },
{ '科目': "数学", '模块': '模块4', '分数': 78 }];
var jmap = {};
var result = [];
var sortResult = [];
jsonData.forEach(function (al) {
var key = al.科目;
if (typeof jmap[key] === 'undefined') {
jmap[key] = [];
}
jmap[key].push(al);
});
$.map(jmap, function (n, item) {
result.push(n.length);
sortResult.push(n.length);
});
sortResult.sort();
var maxLength = sortResult[sortResult.length - 1];
$("#thead").append("<tr><th>科目</th><th colspan='" + maxLength + "'>模块</th><th>分数</th></tr>");
$.each(jmap, function (k, v) {
$("#tbody").append("<tr id='" + k + "'><td>"+k+"</td></tr>");
var sumScore = 0;
var currentJsonLength = v.length;
$.each(v, function (i, n) {
if (n.科目) {
$("#" + k).append("<td>" + n.模块 + "</td>");
sumScore = sumScore + n.分数;
}
});
for (var i = 0; i < maxLength-currentJsonLength; i++) {
$("#" + k).append("<td></td>");
}
$("#" + k).append("<td>" + sumScore + "</td>");
});
}
$(function () {
test2();
});
</script>
</head>
<body>
<table id="tab" border="1">
<thead id="thead"></thead>
<tbody id="tbody"></tbody>
</table>
</body>
</html>
1349
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
