📄 account_stat.jsp
字号:
if(lx.equals("E")||lx.equals("")){%>
<td class="body_td" align="left" width="5%" nowrap><a href="Account_list.jsp?state=E&_state=N&relationproduct=<%=relationproduct%>&areacode=<%=dataTable.getRow(i).getString("areacode")%>&year=<%=year%>&quarter=<%=quarter%>&month=<%=month%>&xun=<%=xun%>&week=<%=week%>&rq=<%=rq%>&start=<%=start%>&end=<%=end%>"><u><%=dataTable.getRow(i).getString("ne_cnt")%></u></a></td>
<td class="body_td" align="left" width="5%" nowrap><a href="Account_list.jsp?state=E&_state=A&relationproduct=<%=relationproduct%>&areacode=<%=dataTable.getRow(i).getString("areacode")%>&year=<%=year%>&quarter=<%=quarter%>&month=<%=month%>&xun=<%=xun%>&week=<%=week%>&rq=<%=rq%>&start=<%=start%>&end=<%=end%>"><u><%=dataTable.getRow(i).getString("ae_cnt")%></u></a></td>
<!--<td class="body_td" align="left" width="5%" nowrap><a href="Account_list.jsp?state=E&_state=L&relationproduct=<%=relationproduct%>&areacode=<%=dataTable.getRow(i).getString("areacode")%>&year=<%=year%>&quarter=<%=quarter%>&month=<%=month%>&xun=<%=xun%>&week=<%=week%>&rq=<%=rq%>&start=<%=start%>&end=<%=end%>"><u><%=dataTable.getRow(i).getString("fl_cnt")%></u></a></td>-->
<%}
if(lx.equals("D")||lx.equals("")){%>
<td class="body_td" align="left" width="5%" nowrap><a href="Account_list.jsp?state=D&_state=N&relationproduct=<%=relationproduct%>&areacode=<%=dataTable.getRow(i).getString("areacode")%>&year=<%=year%>&quarter=<%=quarter%>&month=<%=month%>&xun=<%=xun%>&week=<%=week%>&rq=<%=rq%>&start=<%=start%>&end=<%=end%>"><u><%=dataTable.getRow(i).getString("nd_cnt")%></u></a></td>
<td class="body_td" align="left" width="5%" nowrap><a href="Account_list.jsp?state=D&_state=A&relationproduct=<%=relationproduct%>&areacode=<%=dataTable.getRow(i).getString("areacode")%>&year=<%=year%>&quarter=<%=quarter%>&month=<%=month%>&xun=<%=xun%>&week=<%=week%>&rq=<%=rq%>&start=<%=start%>&end=<%=end%>"><u><%=dataTable.getRow(i).getString("ad_cnt")%></u></a></td>
<td class="body_td" align="left" width="5%" nowrap><a href="Account_list.jsp?state=D&_state=L&relationproduct=<%=relationproduct%>&areacode=<%=dataTable.getRow(i).getString("areacode")%>&year=<%=year%>&quarter=<%=quarter%>&month=<%=month%>&xun=<%=xun%>&week=<%=week%>&rq=<%=rq%>&start=<%=start%>&end=<%=end%>"><u><%=dataTable.getRow(i).getString("gl_cnt")%></u></a></td>
<% }
}%>
</tr>
<%
}}else{
%>
<tr>
<td class="body_td" align="left" width="5%" nowrap>无相应数据</td>
</tr>
<%}%>
<tr class="InnerMain" style="color: black" >
<%if(auth.getCityCode()==null || auth.getCityCode().equals("")){%>
<td class="body_td" align="left" width="5%" nowrap>合计</td>
<%}else{%>
<td class="body_td" align="left" width="5%" nowrap>合计</td>
<%}%>
<%if(lx.equals("E")){%>
<td class="body_td" align="left" width="5%" nowrap><%
int countE=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countE+=(int)Integer.parseInt(dataTable.getRow(i).getString("ne_cnt"))+(int)Integer.parseInt(dataTable.getRow(i).getString("ae_cnt"))+(int)Integer.parseInt(dataTable.getRow(i).getString("fl_cnt"));
}
out.print(countE);
%></td>
<td class="body_td" align="left" width="5%" nowrap><%
int countEN=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countEN+=(int)Integer.parseInt(dataTable.getRow(i).getString("ne_cnt"));
}
out.print(countEN);
%></td>
<td class="body_td" align="left" width="5%" nowrap><%
int countEA=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countEA+=(int)Integer.parseInt(dataTable.getRow(i).getString("ae_cnt"));
}
out.print(countEA);
%></td>
<!--
<td class="body_td" align="left" width="5%" nowrap><%
int countEL=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countEL+=(int)Integer.parseInt(dataTable.getRow(i).getString("fl_cnt"));
}
out.print(countEL);
%></td>
-->
<%}%>
<%if(lx.equals("D")){%>
<td class="body_td" align="left" width="5%" nowrap><%
int countD=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countD+=(int)Integer.parseInt(dataTable.getRow(i).getString("nd_cnt"))+(int)Integer.parseInt(dataTable.getRow(i).getString("ad_cnt"))+(int)Integer.parseInt(dataTable.getRow(i).getString("gl_cnt"));
}
out.print(countD);
%></td>
<td class="body_td" align="left" width="5%" nowrap><%
int countDN=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countDN+=(int)Integer.parseInt(dataTable.getRow(i).getString("nd_cnt"));
}
out.print(countDN);
%></td>
<td class="body_td" align="left" width="5%" nowrap><%
int countDA=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countDA+=(int)Integer.parseInt(dataTable.getRow(i).getString("ad_cnt"));
}
out.print(countDA);
%></td>
<td class="body_td" align="left" width="5%" nowrap><%
int countDL=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countDL+=(int)Integer.parseInt(dataTable.getRow(i).getString("gl_cnt"));
}
out.print(countDL);
%></td>
<%}%>
<%if(lx.equals("")){%>
<td class="body_td" align="left" width="5%" nowrap><%
int count=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
count+=(int)Integer.parseInt(dataTable.getRow(i).getString("ae_cnt"))+(int)Integer.parseInt(dataTable.getRow(i).getString("ne_cnt"))+(int)Integer.parseInt(dataTable.getRow(i).getString("nd_cnt"))+(int)Integer.parseInt(dataTable.getRow(i).getString("ad_cnt"))+(int)Integer.parseInt(dataTable.getRow(i).getString("fl_cnt"))+(int)Integer.parseInt(dataTable.getRow(i).getString("gl_cnt"));
}
out.print(count);
%></td>
<td class="body_td" align="left" width="5%" nowrap>
<%
int countEN=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countEN+=(int)Integer.parseInt(dataTable.getRow(i).getString("ne_cnt"));
}
out.print(countEN);
%></td>
<td class="body_td" align="left" width="5%" nowrap>
<%
int countEA=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countEA+=(int)Integer.parseInt(dataTable.getRow(i).getString("ae_cnt"));
}
out.print(countEA);
%></td>
<!--<td class="body_td" align="left" width="5%" nowrap>
<%
int countEL=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countEL+=(int)Integer.parseInt(dataTable.getRow(i).getString("fl_cnt"));
}
out.print(countEL);
%></td>-->
<td class="body_td" align="left" width="5%" nowrap>
<%
int countDN=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countDN+=(int)Integer.parseInt(dataTable.getRow(i).getString("nd_cnt"));
}
out.print(countDN);
%></td>
<td class="body_td" align="left" width="5%" nowrap>
<%
int countDA=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countDA+=(int)Integer.parseInt(dataTable.getRow(i).getString("ad_cnt"));
}
out.print(countDA);
%></td>
<td class="body_td" align="left" width="5%" nowrap>
<%
int countDL=0;
for(int i=0;i<dataTable.getRows().getCount();i++){
countDL+=(int)Integer.parseInt(dataTable.getRow(i).getString("gl_cnt"));
}
out.print(countDL);
%></td>
<%}%>
</tr>
</table>
<table cellpadding="0" cellspacing="0" border="0" width="100%" class="OuterTable">
<tr class="OuterFoot">
<td align="right" class="foot_td" nowrap height="15">
</td>
</tr>
</table>
<div id="succ_five" style="display:none">
<table cellpadding="0" cellspacing="0" border="0" width="100%" class="OuterTable">
<tr class="OuterFoot">
<td align="left" class="foot_td" nowrap width="19%">请选择日期:</td>
<td align="left" class="foot_td" nowrap width="29%">
<div id=popCal style="BORDER-RIGHT: 2px ridge; BORDER-TOP: 2px ridge; Z-INDEX: 100; VISIBILITY: hidden; BORDER-LEFT: 2px ridge; BORDER-BOTTOM: 2px ridge; POSITION: absolute">
<iframe name=popFrame src="PopCalendar.htm" frameborder=0 width=380 scrolling=no height=188></iframe>
</div>
<input name="rq" type="text" id="rq" readonly="true">
<input onClick="popFrame.fPopCalendar(rq,rq,popCal);return false" type=button value=日期 name=sbtnw class="BUTTN-FIX1">
</td>
</tr>
</table>
</div>
</body>
</html>
<SCRIPT LANGUAGE="JavaScript" >
function change(){
if(document.all("time_style").value=="1"){
document.all("succ_one").style.display ="";
document.all("succ_two").style.display ="none";
document.all("succ_three").style.display ="none";
document.all("succ_six").style.display ="none";
document.all("succ_four").style.display ="none";
document.all("succ_five").style.display ="none";
document.all("succ_serven").style.display ="none";
}
else if(document.all("time_style").value=="2"){
document.all("succ_two").style.display ="";
document.all("succ_one").style.display ="none";
document.all("succ_three").style.display ="none";
document.all("succ_six").style.display ="none";
document.all("succ_four").style.display ="none";
document.all("succ_five").style.display ="none";
document.all("succ_serven").style.display ="none";
}
else if(document.all("time_style").value=="3"){
document.all("succ_three").style.display ="";
document.all("succ_one").style.display ="none";
document.all("succ_two").style.display ="none";
document.all("succ_six").style.display ="none";
document.all("succ_four").style.display ="none";
document.all("succ_five").style.display ="none";
document.all("succ_serven").style.display ="none";
}
else if(document.all("time_style").value=="4"){
document.all("succ_four").style.display ="";
document.all("succ_one").style.display ="none";
document.all("succ_two").style.display ="none";
document.all("succ_six").style.display ="none";
document.all("succ_three").style.display ="none";
document.all("succ_five").style.display ="none";
document.all("succ_serven").style.display ="none";
}
else if(document.all("time_style").value=="5"){
document.all("succ_five").style.display ="";
document.all("succ_four").style.display ="none";
document.all("succ_one").style.display ="none";
document.all("succ_two").style.display ="none";
document.all("succ_six").style.display ="none";
document.all("succ_serven").style.display ="none";
document.all("succ_three").style.display ="none";
}
else if(document.all("time_style").value=="6"){
document.all("succ_six").style.display ="";
document.all("succ_one").style.display ="none";
document.all("succ_two").style.display ="none";
document.all("succ_three").style.display ="none";
document.all("succ_four").style.display ="none";
document.all("succ_five").style.display ="none";
document.all("succ_serven").style.display ="none";
}
else if(document.all("time_style").value=="7"){
document.all("succ_serven").style.display ="";
document.all("succ_one").style.display ="none";
document.all("succ_two").style.display ="none";
document.all("succ_three").style.display ="none";
document.all("succ_four").style.display ="none";
document.all("succ_five").style.display ="none";
document.all("succ_six").style.display ="none";
}
else{
document.all("succ_one").style.display ="none";
document.all("succ_two").style.display ="none";
document.all("succ_three").style.display ="none";
document.all("succ_four").style.display ="none";
document.all("succ_six").style.display ="none";
document.all("succ_five").style.display ="none";
document.all("succ_serven").style.display ="none";
}
}
function e()
{
var sURL = "Account_excel.jsp?&lx=<%=lx%>&relationproduct=<%=relationproduct%>&citycode=<%=city%>&areacode=<%=area%>&year=<%=year%>&quarter=<%=quarter%>&month=<%=month%>&xun=<%=xun%>&week=<%=week%>&rq=<%=rq%>&start=<%=start%>&end=<%=end%>";
window.open(sURL,'windowRef','width=800,height=600,top=20,left=60,screenX=10,screenY=20,status=yes',scrollbar='yes');
}
</SCRIPT>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -