📄 yearreport.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="cn.com.aheadsoft.recordset.DetailRecordSet"%>
<%@ page import="cn.com.aheadsoft.recordset.FinTaskIncomeRecordSet"%>
<%@ page import="cn.com.aheadsoft.recordset.FinanceExpenseAccountRecordSet"%>
<%@ page import="cn.com.aheadsoft.recordset.FinProcessInfoRecordSet"%>
<%@ page import="java.text.SimpleDateFormat,java.text.DecimalFormat"%>
<%@ page import="cn.com.aheadsoft.util.StringFormat"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.util.List"%>
<%@ page import="cn.com.aheadsoft.recordset.FinIncomePastRecordSet" %>
<!--add by tang 2004.07.02增加查询条件begin-->
<%@ page import="cn.com.aheadsoft.business.PersonInfoBusiness, cn.com.aheadsoft.recordset.PersonInfoRecordSet,java.util.GregorianCalendar,java.util.Calendar,cn.com.aheadsoft.util.UserInfo,cn.com.aheadsoft.manage.UserPurviewManage"%>
<jsp:useBean id="userDeptManage" scope="page" class="cn.com.aheadsoft.manage.UserDeptManage" />
<%
String User_ID=(String)request.getAttribute("leader");
String deptIDShow=(String)request.getAttribute("deptSel");
String userID;
String userName;
//权限校验
UserInfo userInfo = (UserInfo)session.getAttribute("userinfo");
UserPurviewManage priority = new UserPurviewManage();
List userList=priority.getUserPurview(userInfo,"9","1","q");
if(userList==null){
response.sendRedirect("/krm/jsp/nologin.htm");
return;
}
String[][] userDept;
int deptNum=1;
String deptID[];
userID=userInfo.GetUserID();
userName=userInfo.GetRealName();
userDept=userDeptManage.serReset(userList);
//String userIDShow=null;
//String deptIDShow=null;
if(deptIDShow==null){
deptIDShow=userInfo.GetDeptID();
}
%>
<!--add by tang 2004.07.02增加查询条件end-->
<%
String thisDate=new SimpleDateFormat("yyyy-MM-dd").format(new Date());
String thisYear = thisDate.substring(0,4);
String sYear=(String) request.getAttribute("Year");
if(sYear==null) sYear=thisYear;
DetailRecordSet detailRs=(DetailRecordSet)request.getAttribute("Detail");
FinTaskIncomeRecordSet incomePreRs=(FinTaskIncomeRecordSet) request.getAttribute("PreMonthIn");
FinTaskIncomeRecordSet incomeRs=(FinTaskIncomeRecordSet) request.getAttribute("MonthIn");
FinanceExpenseAccountRecordSet outPreRs=(FinanceExpenseAccountRecordSet) request.getAttribute("PreMonthOut");
FinanceExpenseAccountRecordSet outRs=(FinanceExpenseAccountRecordSet) request.getAttribute("MonthOut");
FinProcessInfoRecordSet processRs=(FinProcessInfoRecordSet) request.getAttribute("Process");
FinProcessInfoRecordSet processPreRs=(FinProcessInfoRecordSet) request.getAttribute("ProcessPre");
FinIncomePastRecordSet pastRs=(FinIncomePastRecordSet) request.getAttribute("Past");
FinIncomePastRecordSet pastPreRs=(FinIncomePastRecordSet) request.getAttribute("PastPre");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link rel="stylesheet" type="text/css" href="/krm/jsp/css/css.css">
<script language="JavaScript">
function MonthAnalysis() {
document.finform.submit();
}
function changedept(){
document.finform.deptSel.disabled=!document.finform.cbdeptName.checked;
}
function changeleader(){
document.finform.leader.disabled=!document.finform.chleader.checked;
}
function useSet(){
isNav = (navigator.appName.indexOf("Netscape") != -1) ? true : false;
isIE = (navigator.appName.indexOf("Microsoft") != -1) ? true : false;
var deptID=document.finform.deptSel.value;
var deptUser=new Array();
var len=document.finform.leader.options.length;
<%
for(int i=0;i<userDept.length;i++){
out.println("deptUser["+i+"]=new Array();");
for(int j=0;j<4;j++){
/*
如果 userDept[i][2]为空，则不显示
userDept[i][2]存储的是系统所有用户的 userID，该用户被禁用，则不显示
修改：曾红立
时间：2004年3月2日
*/
if(null==userDept[i][2])
continue;
out.println("deptUser["+i+"]["+j+"]='"+userDept[i][j]+"'");
}
}
%>
for(var i=len;i>=0;i--){
document.finform.leader.remove(i);
}
for(i=0;i<deptUser.length;i++){
if(deptID==deptUser[i][0]){
if(isIE){
document.finform.leader.options.add(new Option(deptUser[i][3],deptUser[i][2]));
}else{
infoid=document.createElement("option");
infoid.value=deptUser[i][2];
infoid.text=deptUser[i][3];
document.finform.leader.appendChild(infoid);
}
}
}
}
</script>
<title>任务收支年报表</title>
<link href="/krm/jsp/css/css.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="useSet();">
<table width="100%" border="0" cellpadding="0" cellspacing="0" >
<tr height="8">
<td class="trA"> 您的位置：财务管理 >> 财务收支 >> <font class="fontcolor">任务收支年报表</font>
</td>
</tr>
<tr>
<td align="center" valign="top">
<table border="0" width="100%" height="100%" cellpadding="0" cellspacing="0">
<form name="finform" method="post" action="/krm/servlet/FinYearReportServlet?status=q">
<tr height="8">
<td></td>
</tr>
<tr>
<td align="center" valign="top"> <table border="0" width="96%" bordercolor="A1B7DB" class="collapse">
<tr>
<td height="20" class="common1" ><input type="checkbox" name="cbdeptName" value="" onClick="changedept();">负责部门 <select name="deptSel" disabled onChange="useSet();">
<%
String checked="";
if(deptIDShow!=null&&deptIDShow.equals(userDept[0][0])){
checked=" selected";
}
out.println("<option value=\""+userDept[0][0]+"\""+checked+">"+userDept[0][1]+"</option>");
for(int i=0;i<userDept.length-1;i++){
String temp[]=userDept[i];
String deptID1="";
checked="";
deptID1=userDept[i][0];
if(null==userDept[i+1][0])
continue;
if(deptIDShow.equals(userDept[i+1][0])){
checked=" selected";
}
if(!deptID1.equals(userDept[i+1][0])){
out.println("<option value=\""+userDept[i+1][0]+"\""+checked+">"+userDept[i+1][1]+"</option>");
}
}
%>
</select> <input type="checkbox" name="chleader" value="" onClick="changeleader()" >分管领导 <select name="leader" disabled>
</select> 年份 <select name="Year" style="font-size:9pt;font-color:#FFFFFF">
<%
for(int i=0;i<3;i++)
{
int year=Integer.parseInt(thisYear)-i;
%>
<option value="<%=year%>" <%=sYear.equals(String.valueOf(year))?"selected":""%>><%=year%>年</option>
<% }
%>
</select>
<input name="button" type="button" class="button1" onClick="javascript:MonthAnalysis();" onMouseOver="this.className='button2'" onMouseOut="this.className='button1'" value="查 询" >
</td>
</tr>
</table>
</td>
</tr> <input name="module" type="hidden" value="income">
</form> </table>
<table border="0" width="98%" align="center" bordercolor="A1B7DB" class="collapse">
<tr>
<td colspan="8" align="center" class="tdA">
<%=sYear%>年任务收支报表（万元）</td>
</tr>
<tr>
<td width="6%" rowspan="2" align="center" class="tdB">编号</td>
<td width="24%" rowspan="2" align="center" class="tdB">任务名称</td>
<td colspan="3" align="center" class="tdB">收入</td>
<td colspan="3" align="center" class="tdB">支出</td>
</tr>
<tr>
<td width="11%" align="center" class="tdB" nowrap>期初余额</td>
<td width="11%" align="center" class="tdB" nowrap>本年发生</td>
<td width="13%" align="center" class="tdB" nowrap>本年累计</td>
<td width="11%" align="center" class="tdB" nowrap>期初余额</td>
<td width="11%" align="center" class="tdB" nowrap>本年发生</td>
<td width="13%" align="center" class="tdB" nowrap>本年累计</td>
</tr>
<%
float sumfincomePre=0;
float sumfincomeMonth=0;
float sumincome=0;
float sumfpayoutPre=0;
float sumfpayoutMonth=0;
float sumpayout=0;
String year = sYear;
DecimalFormat df11 = new DecimalFormat("#####0.0");
int num=1;
if(detailRs!=null){
while(detailRs.next()){
String incomeMonth="0";
String incomePre="0";
if(incomeRs!=null){
incomeRs.beforefirst();
while(incomeRs.next()){
if((detailRs.getD_Serial()).equals(incomeRs.getTI_TaskID())){
incomeMonth=incomeRs.getTI_Money();
break;
}
}
}
if(incomePreRs!=null){
incomePreRs.beforefirst();
while(incomePreRs.next()){
if((detailRs.getD_Serial()).equals(incomePreRs.getTI_TaskID())){
incomePre=incomePreRs.getTI_Money();
break;
}
}
}
float fincomePre=Float.parseFloat(incomePre)/10000;
sumfincomePre=sumfincomePre+fincomePre;
float fincomeMonth=Float.parseFloat(incomeMonth)/10000;
sumfincomeMonth=sumfincomeMonth+fincomeMonth;
float income=fincomePre+fincomeMonth;
sumincome=sumincome+income;
String payoutPre="0";
String payoutMonth="0";//getMoneySum()
if(outPreRs!=null){
outPreRs.beforefirst();
while(outPreRs.next()){
if((detailRs.getD_Serial()).equals(outPreRs.getEI_ItemID())){
payoutPre=outPreRs.getMoneySum();
break;
}
}
}
if(outRs!=null){
outRs.beforefirst();
while(outRs.next()){
if((detailRs.getD_Serial()).equals(outRs.getEI_ItemID())){
payoutMonth=outRs.getMoneySum();
break;
}
}
}
String processPre="0";
String process="0";
if(processRs!=null){
processRs.beforefirst();
while(processRs.next()){
if((detailRs.getD_Serial()).equals(processRs.getPI_TaskID())){
process=processRs.getPI_Money();
break;
}
}
}
if(processPreRs!=null){
processPreRs.beforefirst();
while(processPreRs.next()){
if((detailRs.getD_Serial()).equals(processPreRs.getPI_TaskID())){
processPre=processPreRs.getPI_Money();
break;
}
}
}
String pastPre="0";
String past="0";
if(pastRs!=null){
pastRs.beforefirst();
while(pastRs.next()){
if((detailRs.getD_Serial()).equals(pastRs.getIP_TaskID())){
past=pastRs.getIP_Money();
break;
}
}
}
if(pastPreRs!=null){
pastPreRs.beforefirst();
while(pastPreRs.next()){
if((detailRs.getD_Serial()).equals(pastPreRs.getIP_TaskID())){
pastPre=pastPreRs.getIP_Money();
break;
}
}
}
float fpayoutPre=(Float.parseFloat(payoutPre)+Float.parseFloat(pastPre)+Float.parseFloat(processPre))/10000;
sumfpayoutPre=sumfpayoutPre+fpayoutPre;
float fpayoutMonth=(Float.parseFloat(payoutMonth)+Float.parseFloat(past)+Float.parseFloat(process))/10000;
sumfpayoutMonth=sumfpayoutMonth+fpayoutMonth;
float payout=fpayoutPre+fpayoutMonth;
sumpayout=sumpayout+payout;
%>
<tr<%
if(num%2==0){
%> class="bgcolor"<%}%>>
<td align="center" class="common"><%=StringFormat.changeHTMLTags(detailRs.getD_Num())%></td>
<td align="center" class="common"><%=StringFormat.changeHTMLTags(detailRs.getD_Topic())%></td>
<td align="center" class="common"><%=df11.format(fincomePre)%></td>
<td align="center" class="common"><a href="/krm/servlet/FinYearReportServlet?status=q&module=in&Year=<%=sYear%>&TaskID=<%=detailRs.getD_Serial()%>"><%=df11.format(fincomeMonth)%></a></td>
<td align="center" class="common"><%=df11.format(income)%></td>
<td align="center" class="common"><%=df11.format(fpayoutPre)%></td>
<td align="center" class="common"><a href="/krm/servlet/FinYearReportServlet?status=q&module=out&Year=<%=sYear%>&TaskID=<%=detailRs.getD_Serial()%>"><%=df11.format(fpayoutMonth)%></a></td>
<td align="center" class="common"><%=df11.format(payout)%></td>
</tr>
<%
num++;
}
}
%>
<tr class="common">
<td colspan="2" align="center">合计：</td>
<td align="center"><%=df11.format(sumfincomePre)%></td>
<td align="center"><%=df11.format(sumfincomeMonth)%></td>
<td align="center" ><%=df11.format(sumincome)%></td>
<td align="center"><%=df11.format(sumfpayoutPre)%></td>
<td align="center"><%=df11.format(sumfpayoutMonth)%></td>
<td align="center"><%=df11.format(sumpayout)%></td>
</tr>
<tr>
<td width="6%" rowspan="2" align="center" class="tdB">编号</td>
<td width="24%" rowspan="2" align="center" class="tdB">任务名称</td>
<td align="center" class="tdB">期初余额</td>
<td align="center" class="tdB">本年发生</td>
<td align="center" class="tdB">本年累计</td>
<td align="center" class="tdB">期初余额</td>
<td align="center" class="tdB">本年发生</td>
<td align="center" class="tdB">本年累计</td>
</tr>
<tr>
<td colspan="3" align="center" nowrap class="tdB">收入</td>
<td colspan="3" align="center" nowrap class="tdB">支出</td>
</tr>
<tr>
<td colspan="8" align="center" class="tdC">
<input type="button" onClick="javascript:history.back(1);" value="返 回" onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1" >
</td>
</tr>
</table>
<br>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -