js写的合计（对一列，一行进行合计）

最新推荐文章于 2022-02-11 10:50:03 发布

原创最新推荐文章于 2022-02-11 10:50:03 发布 · 5.2k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#div #table #javascript #bean #class #border

此统计报告详细展示了北京市各税务机关下增值税小规模纳税人的户数情况，包括商业企业和工业企业的不同收入段分布及占比，旨在为税收政策制定提供数据支持。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<%@ page contentType="text/html;charset=GBK" pageEncoding="GBK"%>
<%@ page import="java.util.Calendar" %>
<%@ include file="../common.jsp" %>
<%@ page import="com.speed.web.hibernate.pojo.XtWsml" %>
<%@ page import="com.speed.web.common.util.CodeTransform" %>
<%int i=1; %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK" />

<title>增值税小规模纳税人户数情况统计</title>
<LINK href="<%=root%>/jsp/css/css.css" type=text/css rel=stylesheet>
<script language="JavaScript" src="<%=root%>/jsp/js/validation.js"></script>

  <SCRIPT language="JavaScript" src="<%=root%>/jsp/js/common.js"></SCRIPT>
  <script type="text/javascript" src="<%=root%>/jsp/js/card.js"></script>
       <script language="JavaScript" src="<%=root%>/jsp/js/common.js"></script>
       <script language="javascript" src="<%=root%>/jsp/js/print_preview.js"></script>
       <SCRIPT language="JavaScript" src="<%=root%>/jsp/js/tablesort.js"></SCRIPT>
<script type="text/javascript">
   function Print(){
//tableId.rows[0].cells[tableId.rows[0].cells.length - 1].
var obj = WorkArea;
var left = obj.offsetLeft,top = obj.offsetTop;
for(;(obj = obj.offsetParent)!= null;){
  left = left + obj.offsetLeft;
  top = top + obj.offsetTop;
}
TitleBar.style.display = "none";
MaskLayer.style.pixelWidth = WorkArea.clientWidth + 2;
MaskLayer.style.pixelHeight = tableId.clientHeight;
MaskLayer.style.pixelLeft = left;
MaskLayer.style.pixelTop = top-1 - TitleBar.clientHeight;
MaskLayer.style.display = "";
tableId.rows[tableId.rows.length - 1].style.display = "none";
ControlBar.style.display = "none";
window.print();
TitleBar.style.display = "";
tableId.rows[tableId.rows.length - 1].style.display = "";
ControlBar.style.display = "";
MaskLayer.style.display = "none";
}
function FormatNumber(num,decimalNum,bolLeadingZero,bolParens,bolCommas)
{
if (isNaN(parseInt(num))) return "NaN";

var tmpNum = num;
var iSign = num < 0 ? -1 : 1;

tmpNum *= Math.pow(10,decimalNum);
tmpNum = Math.round(Math.abs(tmpNum))
tmpNum /= Math.pow(10,decimalNum);
tmpNum *= iSign;
var tmpNumStr = new String(tmpNum);

if (!bolLeadingZero && num < 1 && num > -1 && num != 0)
if (num > 0)
tmpNumStr = tmpNumStr.substring(1,tmpNumStr.length);
else
tmpNumStr = "-" + tmpNumStr.substring(2,tmpNumStr.length);

if (bolCommas && (num >= 1000 || num <= -1000)) {
var iStart = tmpNumStr.indexOf(".");
if (iStart < 0)
iStart = tmpNumStr.length;

iStart -= 3;
while (iStart >= 1) {
tmpNumStr = tmpNumStr.substring(0,iStart) + "," + tmpNumStr.substring(iStart,tmpNumStr.length)
iStart -= 3;
}
}

if (bolParens && num < 0)
tmpNumStr = "(" + tmpNumStr.substring(1,tmpNumStr.length) + ")";

return tmpNumStr;
}

function init()
{
var table1=document.getElementById('table_body');

var rows=table1.rows;
  var zhs_hj =0;
  var nsrhs0_hj = 0;
  var nsrhs50_hj = 0;
  var nsrhs80_hj = 0;
  var nsrhs180_hj = 0;
  var nsrhsb0_hj = 0;
  var nsrhsb30_hj = 0;
  var nsrhsb50_hj = 0;
  var nsrhsb100_hj = 0;
  var xj_hj =0;
  var xj1_hj=0;
  var zb5_hj=0;
  var zb7_hj=0;
  var zb9_hj=0;
  var zb11_hj=0;
  var zb14_hj=0;
  var zb16_hj=0;
  var zb18_hj=0;
  var zb20_hj=0;
var zhs_hjv = document.getElementById("zhs_hj");
var xj_hjv = document.getElementById("xj_hj");
var xj1_hjv = document.getElementById("xj1_hj");
var nsrhs0_hjv = document.getElementById("nsrhs0_hj");
var nsrhs50_hjv = document.getElementById("nsrhs50_hj");
var nsrhs80_hjv = document.getElementById("nsrhs80_hj");
var nsrhs180_hjv = document.getElementById("nsrhs180_hj");
var nsrhsb0_hjv = document.getElementById("nsrhsb0_hj");
var nsrhsb30_hjv = document.getElementById("nsrhsb30_hj");
var nsrhsb50_hjv = document.getElementById("nsrhsb50_hj");
var nsrhsb100_hjv = document.getElementById("nsrhsb100_hj");
var zb5_hjv = document.getElementById("zb5_hj");
var zb7_hjv = document.getElementById("zb7_hj");
var zb9_hjv = document.getElementById("zb9_hj");
var zb11_hjv = document.getElementById("zb11_hj");
var zb14_hjv = document.getElementById("zb14_hj");
var zb16_hjv = document.getElementById("zb16_hj");
var zb18_hjv = document.getElementById("zb18_hj");
var zb20_hjv = document.getElementById("zb20_hj");

for(var i=0;i<rows.length;i++){
  var nsrhs0 = parseInt(document.getElementsByName("nsrhs0")[i].innerText);
  var nsrhs50 = parseInt(document.getElementsByName("nsrhs50")[i].innerText);
  var nsrhs80 = parseInt(document.getElementsByName("nsrhs80")[i].innerText);
  var nsrhs180 = parseInt(document.getElementsByName("nsrhs180")[i].innerText);
  var nsrhsb0 = parseInt(document.getElementsByName("nsrhsb0")[i].innerText);
  var nsrhsb30 = parseInt(document.getElementsByName("nsrhsb30")[i].innerText);
  var nsrhsb50 = parseInt(document.getElementsByName("nsrhsb50")[i].innerText);
  var nsrhsb100 = parseInt(document.getElementsByName("nsrhsb100")[i].innerText);
   var xj = nsrhs0+nsrhs50+nsrhs80+nsrhs180;
   var xj1= nsrhsb0+nsrhsb30+nsrhsb50+nsrhsb100;
   var zhsv = document.getElementsByName("zhs")[i];
   var zhs =parseInt(xj)+parseInt(xj1);
   var xjv = document.getElementsByName("xj")[i];
   var xj1v = document.getElementsByName("xj1")[i];
   var zb5v = document.getElementsByName("zb5")[i];
   var zb7v = document.getElementsByName("zb7")[i];
   var zb9v = document.getElementsByName("zb9")[i];
   var zb11v = document.getElementsByName("zb11")[i];
   var zb14v = document.getElementsByName("zb14")[i];
   var zb16v = document.getElementsByName("zb16")[i];
   var zb18v = document.getElementsByName("zb18")[i];
   var zb20v = document.getElementsByName("zb20")[i];

   var zb5 = Math.round(FormatNumber((nsrhs0/xj),3,true,false,true)*1000)/1000;
   var zb7 = Math.round(FormatNumber((nsrhs50/xj),3,true,false,true)*1000)/1000;
   var zb9 = Math.round(FormatNumber((nsrhs80/xj),3,true,false,true)*1000)/1000;
   var zb11 = Math.round(FormatNumber((nsrhs180/xj),3,true,false,true)*1000)/1000;
   var zb14 = Math.round(FormatNumber((nsrhsb0/xj),3,true,false,true)*1000)/1000;
   var zb16 = Math.round(FormatNumber((nsrhsb30/xj),3,true,false,true)*1000)/1000;
   var zb18 = Math.round(FormatNumber((nsrhsb50/xj),3,true,false,true)*1000)/1000;
   var zb20 = Math.round(FormatNumber((nsrhsb100/xj),3,true,false,true)*1000)/1000;

   zhs_hj +=zhs;

   xj_hj +=nsrhs0+nsrhs50+nsrhs80+nsrhs180;
   xj1_hj +=nsrhsb0+nsrhsb30+nsrhsb50+nsrhsb100;
   nsrhs0_hj += nsrhs0;
  nsrhs50_hj += nsrhs50;
  nsrhs80_hj += nsrhs80;
  nsrhs180_hj += nsrhs180;
  nsrhsb0_hj += nsrhsb0;
  nsrhsb30_hj += nsrhsb30;
  nsrhsb50_hj += nsrhsb50;
  nsrhsb100_hj += nsrhsb100;

   zb5v.innerText = zb5;
   zb7v.innerText = zb7;
   zb9v.innerText = zb9;
   zb11v.innerText = zb11;
   zb14v.innerText = zb14;
   zb16v.innerText = zb16;
   zb18v.innerText = zb18;
   zb20v.innerText = zb20;

   xjv.innerText =xj;
   xj1v.innerText =xj1;
   zhsv.innerText =zhs;

   zhs_hjv.innerText = zhs_hj;
   xj_hjv.innerText = xj_hj;
   xj1_hjv.innerText = xj1_hj;
   nsrhs0_hjv.innerText = nsrhs0_hj;
  nsrhs50_hjv.innerText = nsrhs50_hj;
  nsrhs80_hjv.innerText = nsrhs80_hj;
  nsrhs180_hjv.innerText = nsrhs180_hj;
  nsrhsb0_hjv.innerText = nsrhsb0_hj;
  nsrhsb30_hjv.innerText = nsrhsb30_hj;
  nsrhsb50_hjv.innerText = nsrhsb50_hj;
  nsrhsb100_hjv.innerText = nsrhsb100_hj;


   zb5_hj=FormatNumber(nsrhs0_hj/xj_hj,3,true,false,true);
   zb7_hj=FormatNumber(nsrhs50_hj/xj_hj,3,true,false,true);
   zb9_hj=FormatNumber(nsrhs80_hj/xj_hj,3,true,false,true);
   zb11_hj=FormatNumber(nsrhs180_hj/xj_hj,3,true,false,true);
   zb14_hj=FormatNumber(nsrhsb0_hj/xj1_hj,3,true,false,true);
   zb16_hj=FormatNumber(nsrhsb30_hj/xj1_hj,3,true,false,true);
   zb18_hj=FormatNumber(nsrhsb50_hj/xj1_hj,3,true,false,true);
   zb20_hj=FormatNumber(nsrhsb100_hj/xj1_hj,3,true,false,true);

   zb5_hjv.innerText = zb5_hj;
   zb7_hjv.innerText = zb7_hj;
   zb9_hjv.innerText = zb9_hj;
   zb11_hjv.innerText = zb11_hj;
   zb14_hjv.innerText = zb14_hj;
   zb16_hjv.innerText = zb16_hj;
   zb18_hjv.innerText = zb18_hj;
   zb20_hjv.innerText = zb20_hj;
   }

}
</script>
</head>

   <body style="margin-top:1px; margin-bottom:0px; margin-left:0px; margin-right:0px;" onload="init();">
<div id="MaskLayer" style="display:none; position:absolute; left:781px; top:151px; width:49px; height:155px; z-index:1; background-color: #f2f2f2; layer-background-color: #f2f2f2; border: 1px none #000000;"></div>
<br/>
<center>
<h4></h4>
<div id="table_all">
<div id="divH" style="overflow-x:hidden;width:90%; height="40" !important height=20" >
<table id="table_title" class="TableBill_Ws" width="1976" border="0" cellpadding="0" cellspacing="0" align="center" >
<col width="33" />
<col width="49" span="2" />
<col width="48" />
<col width="35" />
<col width="71" />
<col width="39" />
<col width="72" />
<col width="38" />
<col width="78" />
<col width="38" />
<col width="66" />
<col width="72" />
<col width="38" />
<col width="72" />
<col width="36" />
<col width="72" />
<col width="39" />
<col width="81" />
<col width="36" />
<thead>
<tr height="30" class="bg_column">
    <td colspan="21"><div align="center">北京市国家税务局增值税小规模纳税人户数情况统计表</div></td>
</tr>
<tr class="bg_column">
    <td colspan="18"><div align="center"> </div></td>
    <td colspan="3">单位：户</td>
</tr>
<tr class="bg_column">
    <td rowspan="3" width="48"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">序号</div>      <div align="center"></div></td>
    <td rowspan="2" width="250"><div align="center" title="单击标题排序!" type="String" onClick="sortColumn(event,document.getElementById('table_body'))">税务机关</div></td>
    <td rowspan="2" width="120"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">小规模纳税人总户数</div></td>
    <td colspan="9"><div align="center">商业企业（含工商兼营，以商业为主）</div></td>
    <td colspan="9"><div align="center">工业企业（含工商兼营，以工业为主）</div></td>
</tr>
<tr class="bg_column">
    <td width="84"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">小计</div></td>
    <td width="60"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">增值税应税销售收入=0</div></td>
    <td width="63"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">占比（%）</div></td>
    <td width="76"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">0＜增值税应税销售收入＜50万元</div></td>
    <td width="65"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">占比（%）</div></td>
    <td width="92"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">50≤增值税应税销售收入＜80万元</div></td>
    <td width="65"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">占比（%）</div></td>
    <td width="96"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">80≤增值税应税销售收入＜180万元</div></td>
    <td width="89"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">占比（%）</div></td>
    <td width="84"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">小计</div></td>
    <td width="63"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">增值税应税销售收入=0</div></td>
    <td width="101"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">占比（%）</div></td>
    <td width="78"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">0＜增值税应税销售收入＜30万元</div></td>
    <td width="93"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">占比（%）</div></td>
    <td width="122"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">30≤增值税应税销售收入＜50万元</div></td>
    <td width="87"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">占比（%）</div></td>
    <td width="133"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">50≤增值税应税销售收入＜100万元</div></td>
    <td width="105"><div align="center" title="单击标题排序!" type="Number" onClick="sortColumn(event,document.getElementById('table_body'))">占比（%）</div></td>
</tr>

<tr class="<%=classType%>" height="20">
<td width="47" align=middle><%=index.intValue()+1 %></td>
    <td width="249"><bean:write name="dolist" property="swjgmc" /></td>
    <td width="119" id="zhs"></td>
    <td width="84" id="xj"></td>
    <td width="60" id="nsrhs0"><bean:write name="dolist" property="nsrhs0" /></td>
    <td width="63" id="zb5"></td>
    <td width="76" id="nsrhs50"><bean:write name="dolist" property="nsrhs50" /></td>
    <td width="65" id="zb7"></td>
    <td width="92" id="nsrhs80">　<bean:write name="dolist" property="nsrhs80" /></td>
    <td width="65" id="zb9"></td>
    <td width="96" id="nsrhs180">　<bean:write name="dolist" property="nsrhs180" /></td>
    <td width="89" id="zb11"></td>
    <td width="84" id="xj1"></td>
    <td width="63" id="nsrhsb0">　<bean:write name="dolist" property="nsrhsb0" /></td>
    <td width="101" id="zb14"></td>
    <td width="78" id="nsrhsb30">　<bean:write name="dolist" property="nsrhsb30" /></td>
    <td width="93" id="zb16"></td>
    <td width="122" id="nsrhsb50">　<bean:write name="dolist" property="nsrhsb50" /></td>
    <td width="87" id="zb18"></td>
    <td width="133" id="nsrhsb100">　<bean:write name="dolist" property="nsrhsb100" /></td>
    <td width="105" id="zb20"></td>
</tr>
</logic:iterate>
    <tr class="TableBill_Ws">
<td width="47" align=middle>合计</td>
    <td width="249"> </td>
    <td width="119" id="zhs_hj"> </td>
    <td width="84" id="xj_hj"> </td>
    <td width="60" id="nsrhs0_hj"> </td>
    <td width="63" id="zb5_hj"> </td>
    <td width="76" id="nsrhs50_hj"> </td>
    <td width="65" id="zb7_hj"> </td>
    <td width="92" id="nsrhs80_hj"> </td>
    <td width="65" id="zb9_hj"> </td>
    <td width="96" id="nsrhs180_hj"> </td>
    <td width="89" id="zb11_hj"> </td>
    <td width="84" id="xj1_hj"> </td>
    <td width="63" id="nsrhsb0_hj"> </td>
    <td width="101" id="zb14_hj"> </td>
    <td width="78" id="nsrhsb30_hj"> </td>
    <td width="93" id="zb16_hj"> </td>
    <td width="122" id="nsrhsb50_hj"> </td>
    <td width="87" id="zb18_hj"> </td>
    <td width="133" id="nsrhsb100_hj"> </td>
    <td width="105" id="zb20_hj"> </td>
</tr>
</logic:present>
</tbody>
</table>
</td>
</tr>
</table>
</div>
</div>
</center>

<p align="center" id="ControlBar">
<img src="<%=root %>/jsp/images/button/dayin.gif" width="58" height="24" class="abstractlink" onClick="print_tjbb('增值税小规模纳税人户数情况统计',document.getElementById('table_title'),document.getElementById('table_body'))"/>  <img src="<%=root %>/jsp/images/button/daochu.gif" width="58" height="24" class="abstractlink" onClick="SaveToExcell(document.getElementById('table_all'))"/>  <img class="box" src="<%=root %>/jsp/images/button/fanhui.gif" style="cursor:pointer" onClick="javascript:history.back();" width="58" height="24" />
</p>

</body>
</html>