JQuery 计算

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page contentType="text/html;charset=GB2312" %>
<%@page import="utils.system"%>
<%@page import="java.text.*"%>

<%@taglib uri="http://struts.apache.org/tags-logic" prefix="logic"%>
<%@taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<%@taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<%@taglib uri="http://struts.apache.org/tags-tiles" prefix="tiles"%>
<%@ page import="gov.chinatax.skskj.uservalidate.SkskjLogon"%>
<%@ page import="com.citichy.gbf.*"%>
<%@ page import="java.text.SimpleDateFormat" %>

<jsp:useBean id="login" scope="session"
class="gov.chinatax.skskj.uservalidate.SkskjLogon" />

<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
   + request.getServerName() + ":" + request.getServerPort()
   + path + "/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <base href="<%=basePath%>">

  <title>工本费数据分析</title>
  <meta http-equiv="pragma" content="no-cache">
  <meta http-equiv="cache-control" content="no-cache">
  <meta http-equiv="expires" content="0">
  <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  <meta http-equiv="description" content="This is my page">
  <link rel="stylesheet" href="../common/f1.css" type="text/css">
  <link href="/css/gbf_style.css" rel="stylesheet" type="text/css" />
  <style type="text/css"></style>
  <script type="text/javascript" src="js/jquery.js" > </script>
  <script type="text/javascript">
   $(function(){

    //求出行数
    var trContStr = $('#tab tr').size();
    var trContInt =parseInt(trContStr-2);

    var tdCountStr= $('#tr_0 td').size();
    var tdCountInt =(parseInt(tdCountStr)-5)/2; //在设置占比值时，最后预计那四列不用求，我Java代码求完了。
    //alert('行数：' + trContInt);
    //alert('列数：' + tdCountInt);

    for( x=0 ; x < tdCountInt ; x++){ // 一共有多少列，就循环多少次
     //1.求一列的和，保存在sumClounVal,循环时，有多少横行就循环多少次
     var sumClounVal = 0 ;
     var clounVal =0;
     var avaVal = 0 ;
     for( z = 0 ; z < trContInt ; z++){
      //行坐标_纵坐标
      clounVal = $('#data_c_'+z+'_'+x).text();
      //alert('列值:'+ clounVal);
      sumClounVal += parseFloat(clounVal );
      sumClounVal =Math.round(sumClounVal*100)/100   ;
      //alert(sumClounVal);
     }

     //2.求这列的平均数,并且把平均值，放置到占比上
     for( z = 0 ; z < tdCountInt ; z++){
       clounVal = $('#data_c_'+z+'_'+x).text();
       avaVal = parseFloat(clounVal );
       $('#data_e_'+z+'_'+x).text( Math.round((avaVal/sumClounVal)*100)/100 );

     }

    }

});
</script>
</head>
<%

System.out.println("the page loading ... ...");
List list = (List)request.getAttribute("rsList");
int maxYear =Integer.parseInt((String)request.getAttribute("endYear"));
int minYear =Integer.parseInt((String)request.getAttribute("startYear"));
int columCont =maxYear -minYear +1 ;
%>

<div style="width: 920px;height: 466px;overflow: auto;">
   <center>
     <table width="700" border="0" cellspacing="0" cellpadding="0" bordercolordark=#ffffff bordercolorlight=#cccccc class="unnamed1">
       <tr>
        <td colspan="10" align="center"><font class="font14">数据分析及预测</font></td>
       </tr>
      </table>
    <table id="tab" width="1200" border="1" cellspacing="0" cellpadding="0" bordercolordark=#ffffff bordercolorlight=#cccccc class="unnamed1">
       <tr align="center">
         <td width="79" rowspan="2"> <div align="center">行业 </div></td>
       <%for (int i =0 ; i <columCont+1 ; i++) {%>
          <td colspan="4" ><div align="center"><%=minYear++ %>年</div></td>
          <% }%>
       </tr>
       <tr>
       <%for (int j =0 ; j <columCont +1; j++) {%>
           <td ><div align="center">份数 </div></td>
           <td ><div align="center">占比</div></td>
           <td ><div align="center">金额</div></td>
           <td ><div align="center">占比</div></td>
        <% }%>

       </tr>

       <% for (int z =0 ; z <list.size() ;z++ ){ %>
      <tr id="tr_<%=z%>">

       <%
        ServiceVo vos=(ServiceVo)list.get(z);
       %>
         
         <td><div align="center"><%=vos.getName() %></div></td>
       <%
         List listvo=vos.getDatas();
         DecimalFormat df = new DecimalFormat("0.00");
         double count = 0 ;
         double sumFS =0;
         double sumJE = 0;
         //改for循环，能把一横行数量和金额值填充上并且把预计的部分给填，当本次for 循环结束之后，外层的 for (int z)会重新定义上边这个几个变量
         //占比部分，我用jquery来求
         for(int a= 0 ; a<listvo.size() ;a++){
          count++ ;
          if (a%2 == 0) {
           sumFS += Double.parseDouble( (String)listvo.get(a) );
          }else {
           sumJE += Double.parseDouble( (String)listvo.get(a) );
          }

       %>
           
           
          <td id ="data_c_<%=z %>_<%=a %>" ><div align="center"><%=listvo.get(a) %></div></td>
          <td id ="data_d_<%=z %>_<%=a %>" ><div id ="data_e_<%=z %>_<%=a %>" align="center"></div></td>
       <%
         }
        %>
          
         <td id="yc_fs_<%=z%>"> <div align="center"><%=df.format(sumJE==0.0?0.0:(sumFS/(count/2) )) %></div></td>
         <td id="yc_fs_zb_<%=z%>"><div align="center"><%=df.format(sumJE==0.0?0.0:( (sumFS/(count/2))/(sumFS) ))%></div></td>
         <td id="yc_je_<%=z%>"><div align="center"><%=df.format(sumJE==0.0?0.0:( sumJE/(count/2))) %></div></td>
         <td id="yc_je_zb_<%=z%>"><div align="center"><%= df.format(sumJE==0.0?0.0:((sumJE/(count/2))/(sumJE))) %></div></td>
      </tr>
      <%} %>

     </table>

</center>
   </div>
  </td>

       <td width="3" valign="top" background="/chinataxskskj/images/index_r2_c1.jpg"> </td>
  </tr>
  <tr>
    <td height="17" background="/chinataxskskj/images/index_r3_c1.jpg" width="240" height="17">y</td>
    <td colspan="2" background="/chinataxskskj/images/index_r5_c4.jpg"><br>
  </tr>
</table> 
  <%@ include file="../common/banquan.jsp" %>

</body>
</html>

posted on 2013-12-03 14:18 fantiejun0436 阅读(259) 评论(0) 收藏举报

刷新页面返回顶部

fantiejun0436

JQuery 计算

导航

公告