从数组Data生成表

  • 本文关键字:Data 数组 javascript
  • 更新时间 :
  • 英文 :


我有一些数据如下

 var data = [ [21, [1,2] ], [22, [1,2] ] ];
 var const = [-1 , 0 , 1];

我的要求是生成一个表与下面的结构

 21, 22 are main column headers
 1, 2 are nested columns under 21, 22

对于21,22中的每个1,2,我需要添加const值作为嵌套的列标头在上面的例子中
21、22是主列标头;1,2将在每个21,22下嵌套列Const值- 1,0,1将在21,22的每个1,2下嵌套列标头我写了下面的代码。但这并没有像预期的那样工作

function simplifyCols(obj) {
    var reform = {
        table : {}
    };
    for (var x = 0; x < obj.length; x++) {
        obj[x].push( const );
    }
    for(var i = 0, l = obj.length; i < l; i++){
        var key = obj[i];
        for (var j = 0, m = key.length; j < m; j++) {
            var colspan = 1;
            for (var k = j + 1; k < m; k++) {
                colspan *= key[k].length; 
            }
            reform.table[j] = reform.table[j] || [];
            reform.table[j].push({
                span : colspan,
                data : key[j]
            });
        }
    }
    return reform;
}
var cols = simplifyCols( data ).table;
var keys = Object.keys(cols).sort(function(a, b){
    return a - b;
});
var table = document.createElement('table');
document.body.appendChild(table);
for (var i = 0, l = keys.length; i < l; i++) {
    var keyData = cols[keys[i]], tr = document.createElement('tr');
    table.appendChild(tr);
    for (var j = 0, m = keyData.length; j < m; j++) {
        var eleData = keyData[j].data;
        if(eleData instanceof Array){
            for (var k = 0, n = eleData.length; k < n; k++) {
                var td = document.createElement('td');
                td.innerHTML = eleData[k];
                td.colSpan = keyData[j].span;
                tr.appendChild(td);
            }
        }else{
            var td = document.createElement('td');
            td.innerHTML = keyData[j].data;
            td.colSpan = keyData[j].span;
            tr.appendChild(td);
        }
    }
    table.appendChild(tr);
}
document.body.appendChild(table);

请帮助改进逻辑并使其工作。我被击中了,无法继续

这是我期望从上面的HTML

here提琴http://jsfiddle.net/4NS8d/

 <table>
    <tr> <td colspan="6">21</td> <td colspan="6">21</td> </tr>
    <tr> <td colspan="3">1</td> <td colspan="3">2</td> <td colspan="3">1</td> <td colspan="3">2</td> </tr>
    <tr> <td>-1</td> <td>0</td> <td>1</td><td>-1</td> <td>0</td> <td>1</td><td>-1</td> <td>0</td> <td>1</td><td>-1</td> <td>0</td> <td>1</td></tr>
 </table>

首先你不能命名var const

试试这个:

var const2 = [-1 , 0 , 1];
function simplifyCols(obj) {
    var reform = {
        table : {}
    };
    for (var x = 0; x < obj.length; x++) {
        obj[x].push( const2 );
    }
    for(var i = 0, l = obj.length; i < l; i++){
        var key = obj[i];
        for (var j = 0, m = key.length; j < m; j++) {
            var colspan = 1;
            for (var k = j + 1; k < m; k++) {
                colspan *= key[k].length; 
            }
            reform.table[j] = reform.table[j] || [];
            reform.table[j].push({
                span : colspan,
                data : key[j]
            });
        }
    }
    return reform;
}
var data = [ [21, [1,2] ], [22, [1,2] ] ];
var cols = simplifyCols(data).table;
var keys = Object.keys(cols).sort(function(a, b){
    return a - b;
});
var table = document.createElement('table');
document.body.appendChild(table);
for (var i = 0, l = keys.length; i < l; i++) {
    var keyData = cols[keys[i]], tr = document.createElement('tr');
    table.appendChild(tr);
    for (var j = 0, m = keyData.length; j < m; j++) {
        var eleData = keyData[j].data;
        if(eleData instanceof Array){
            for (var k = 0, n = eleData.length; k < n; k++) {
                var td = document.createElement('td');
                td.innerHTML = eleData[k];
                td.colSpan = keyData[j].span;
                tr.appendChild(td);
            }
        }else{
            var td = document.createElement('td');
            td.innerHTML = keyData[j].data;
            td.colSpan = keyData[j].span;
            tr.appendChild(td);
        }
    }
    table.appendChild(tr);
}
document.body.appendChild(table);
http://jsfiddle.net/zxvnp/

最新更新