table进行合并，求合计

来源：互联网发布：php发送短信编辑：程序博客网时间：2024/05/22 01:56
$.ajax({url: url,type: 'post',data: null,dataType: 'json',success:function(result){number = result.rows.length;$("#elec_sum_D_value_table").bootstrapTable({   data: result.rows,   method: 'post',   cache: false,   async: false,   pagination: false,   sortable: true,     sortOrder: "asc",   contentType: "application/x-www-form-urlencoded",//   queryParams: queryParams,//传递参数（*）params为对象   sidePagination: "server",   pageNumber:1,   pageSize: 10,   pageList: [35, 50, 100],   queryParamsType:'limit',   search: false,    strictSearch: true,   showColumns: false,   showRefresh: false,     minimumCountColumns: 2,   clickToSelect: true,   height: 400,    uniqueId: "dclId",   showToggle:false,    cardView: false,     detailView: false,   columns : [ {   field : 'dcsName',title : '发电站',sortable: true,align: 'center',valign: 'middle',},{   field : 'dclName',title : '回路',sortable: true,align: 'center',valign: 'middle',},{   field : 'dclInverter',title : '逆变器(KW)',sortable: true,align: 'center',valign: 'middle',},{   field : 'dclCapacity',title : '装机容量(KW)',sortable: true,align: 'center',valign: 'middle',}, {field : 'begelec',title : '开始发电量(kwh)', sortable: true, formatter : function(value, row, index) {return new Number((new Number(value+1).toFixed(3))- 1).toFixed(3); }}, {field : 'endelec',title : '终止发电量(kwh)', sortable: true, formatter : function(value, row, index) { return new Number((new Number(value+1).toFixed(3))- 1).toFixed(3); }}, {field : 'dvalue',title : '求差值(kwh)', sortable: true, formatter : function(value, row, index) {return new Number((new Number(value+1).toFixed(3))- 1).toFixed(3); }}, {field : '',title : '合计(kwh)',sortable: true,}],onLoadError: function () {console.log("加载表格失败......");}});var tb = document.getElementById("elec_sum_D_value_table");//获得当前表格var nextValue=""; var nowvalue=""; var nowpos=0; for(var j=1;j<=number;j++){ nowvalue = tb.rows[j].cells[0].innerText; if(nextValue == nowvalue){ tb.rows[j].deleteCell(7); tb.rows[j-nowpos].cells[7].rowSpan = tb.rows[j-nowpos].cells[7].rowSpan+1; nowpos++; }else if(nextValue == ""){nextValue = nowvalue; nowpos=1; }else{nextValue = nowvalue; nowpos=1; }} var lastValue=""; var value=""; var pos=0; for(var i=1;i<=number;i++){ value = tb.rows[i].cells[0].innerText; if(lastValue == value){ totalDvalue += parseFloat(tb.rows[i].cells[6].innerHTML);tb.rows[i-pos].cells[7].innerHTML = totalDvalue.toFixed(3); tb.rows[i].deleteCell(0); tb.rows[i-pos].cells[0].rowSpan = tb.rows[i-pos].cells[0].rowSpan+1; pos++; }else if(lastValue == ""){totalDvalue = parseFloat(tb.rows[i].cells[6].innerHTML);lastValue = value; pos=1; }else{if(pos==1){tb.rows[i-pos].cells[7].innerHTML = totalDvalue.toFixed(3); }totalDvalue = parseFloat(tb.rows[i].cells[6].innerHTML);lastValue = value; pos=1; }} var sumBgeinElec = result.sumBgeinElec.toFixed(3);var sumEndElec = result.sumEndElec.toFixed(3);var sumCapacity = result.sumCapacity.toFixed(3);var sumD = (sumEndElec - sumBgeinElec).toFixed(3);var tr = "<tr><td>合计</td><td></td><td></td><td>"+sumCapacity+"</td><td>"+sumBgeinElec+"</td><td>"+sumEndElec+"</td><td>"+sumD+"</td><td>"+sumD+"</td><tr>";$("#elec_sum_D_value_table").append(tr);}});
0 0