📄 shouzhifenxi.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="cn.com.aheadsoft.recordset.DetailRecordSet,cn.com.aheadsoft.recordset.YearAimRecordSet,
cn.com.aheadsoft.recordset.PersonInfoRecordSet,cn.com.aheadsoft.recordset.DeptInfoRecordSet,cn.com.aheadsoft.util.StringFormat" %>
<%@ page import="cn.com.aheadsoft.business.PersonInfoBusiness, cn.com.aheadsoft.recordset.PersonInfoRecordSet"%>
<%@ page import="java.util.GregorianCalendar,java.util.Calendar"%>
<%@ page import="cn.com.aheadsoft.business.FinApprovalStatInfoBusiness, cn.com.aheadsoft.recordset.FinanceExpenseAccountRecordSet"%>
<%@ page import="java.util.List,java.util.Iterator,java.text.DecimalFormat"%>
<%@ page import="cn.com.aheadsoft.recordset.FinIncomePastRecordSet" %>
<%@ page import="cn.com.aheadsoft.business.FinIncomePastBusiness" %>
<%@ page import="cn.com.aheadsoft.recordset.FinProcessInfoRecordSet" %>
<%@ page import="cn.com.aheadsoft.business.FinProcessInfoBusiness" %>
<%@ page import="java.util.HashMap,java.util.GregorianCalendar,java.util.Calendar"%>
<%
GregorianCalendar cal = new GregorianCalendar();
int nowyear = cal.get(Calendar.YEAR);
float[][] sa = (float[][])session.getAttribute("sa");
session.removeAttribute("sa");
DetailRecordSet set = (DetailRecordSet)request.getAttribute("result");
String orderby = request.getParameter("orderby");
float m1 = 0;
float m2 = 0;
float m3 = 0;
float m4 = 0;
float m5 = 0;
float m6 = 0;
float m7 = 0;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
<link rel="stylesheet" type="text/css" href="/krm/jsp/css/css.css">
<title>具体任务页</title></head>
<script language="JavaScript" type="text/JavaScript">
function MM_openBrWindow(theURL,winName,features) {
window.open(theURL,winName,features);
}
function Jumping(){
document.PageForm.submit();
return ;
}
function change(){
url="/krm/servlet/DetailServlet?module=detail&&status=q&&queryterm=queryshouzhifenxi&&orderby="+document.all.orderby.value;
window.location = url;
}
</script>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
<form method="post" name="all">
<table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
<tr height="8">
<td class="trA"> 您的位置：任务管理 >> <font class="fontcolor">收益分析</font></td>
</tr>
<tr height="8">
<td></td>
</tr>
<tr>
<td align="center" class="common1">
<div align="center" > 请选择排序方式：按
<select name="orderby" style="font-size:9pt;width=80 font-color:#FFFFFF" onChange="javascript:change();">
<option <%if(orderby.equals("yixiang")){%> selected<%}%> value="yixiang">意向</option>
<option <%if(orderby.equals("yuli")){%> selected<%}%> value="yuli">预支</option>
<option <%if(orderby.equals("hetong")){%> selected<%}%> value="hetong">合同</option>
<option <%if(orderby.equals("shouru")){%> selected<%}%> value="shouru">收入</option>
<option <%if(orderby.equals("zhichu")){%> selected<%}%> value="zhichu">支出</option>
<option <%if(orderby.equals("lirun")){%> selected<%}%> value="lirun">利润</option>
<option <%if(orderby.equals("yingshou")){%> selected<%}%> value="yingshou">应收</option>
</select>
排序</div>
<table border="0" width="98%" align="center" height="30%" class="collapse">
<tr >
<td colspan="24" align="center" class="tdA">
任务列表</td>
</tr>
<tr>
<td align="center" class="tdB" width=6% height="20" nowrap >
编号</td>
<td align="left" class="tdB" width="8%" nowrap >
分管</td>
<td align="left" class="tdB" width="8%" nowrap>
负责人</td>
<td align="center" class="tdB" width="17%" nowrap>
任务名称</td>
<td align="right" class="tdB" width="8%" nowrap>
意向</td>
<td align="right" class="tdB" width="8%" nowrap>
预支</td>
<td align="right" class="tdB" width="5%" nowrap>
合同</td>
<td align="right" class="tdB" width="8%" nowrap>
收入</td>
<td align="right" class="tdB" width="8%" nowrap>
支出</td>
<td align="right" class="tdB" width="8%" nowrap>
利润</td>
<td align="right" class="tdB" width="8%" nowrap>
应收</td>
</tr>
<%int i = 0;
if((!orderby.equals("lirun"))&&(!orderby.equals("zhichu"))){
if((null != set) && (set.size() > 0)){
set.beforefirst();
// int numb = 1;
while(set.next()){
%>
<tr<%
if(i%2==0){
%> class="bgcolor"<%}%>>
<td align="center" class="common" width="6%" > <%=set.getD_Num()%></td>
<td align="left" class="common" width="8%" >
<%if((null != set.getI_Name()) && (!set.getI_Name().trim().equals(""))){
out.println(StringFormat.changeHTMLTags(set.getI_Name()));
}else{
out.println("无");}%>
</td>
<td align="left" class="common" width="8%" >
<%if(null != set.getD_ManagerName())
out.println(StringFormat.changeHTMLTags(set.getD_ManagerName()));
%>
</td>
<td align="center" class="common" width="17%" ><%if(i<11){%> <font color="#FF0000"><%}%> <%=StringFormat.changeHTMLTags(set.getD_Topic())%></font></td>
<td align="right" class="common" width="8%" >
<%
float wantmoney = Float.parseFloat(set.getD_WantMoney());
m1 = m1 + wantmoney ;
DecimalFormat df51 = new DecimalFormat("#####0.0");
if((orderby.equals("yixiang"))&&(i<11)){%>
<font color="#FF0000">
<%}%>
<%=df51.format(wantmoney)%>
</font>
</td>
<td align="right" class="common" width="8%" >
<%
float PreMoney = Float.parseFloat(set.getD_PreMoney());
m2 = m2 + PreMoney ;
DecimalFormat df61 = new DecimalFormat("#####0.0");
if((orderby.equals("yuli"))&&(i<11)){%>
<font color="#FF0000">
<%}%>
<%=df61.format(PreMoney)%>
</font>
</td>
<td align="right" class="common" width="8%" >
<%
float ContactMoney = Float.parseFloat(set.getD_ContactMoney());
m3 = m3 + ContactMoney ;
DecimalFormat df71 = new DecimalFormat("#####0.0");
if((orderby.equals("hetong"))&&(i<11)){%>
<font color="#FF0000">
<%}%>
<%=df71.format(ContactMoney)%>
</font>
</td>
<td align="right" class="common" width="8%" >
<%
float D_Income = Float.parseFloat(set.getD_Income());
m4 = m4 + D_Income ;
DecimalFormat df11 = new DecimalFormat("#####0.0");
if((orderby.equals("shouru"))&&(i<11)){%>
<font color="#FF0000">
<%}%>
<%=df11.format(D_Income)%>
</font>
</td>
<%String moneysum="0";
FinApprovalStatInfoBusiness business = new FinApprovalStatInfoBusiness();
FinanceExpenseAccountRecordSet approvalStatRecordSet = new FinanceExpenseAccountRecordSet();
approvalStatRecordSet.setItemSum();
business.setFinanceExpenseAccountRecordSet(approvalStatRecordSet);
business.setQueryWhereDetails();
int num = business.execute("querystat");
FinanceExpenseAccountRecordSet Expenseset=business.getFinanceExpenseAccountRecordSet();
Expenseset.beforefirst();
while(Expenseset.next())
{
if(set.getD_Serial().equals(Expenseset.getEI_ItemID()))
{
moneysum=Expenseset.getMoneySum();
}
}
/*李光文2004-06-15任务支出登记*/
FinIncomePastRecordSet incomepastrs=new FinIncomePastRecordSet();
FinIncomePastBusiness incomepastbs=new FinIncomePastBusiness();
incomepastbs.setQueryWhereID(set.getD_Serial());
int pastnum = incomepastbs.execute("query");
incomepastrs =incomepastbs.getFinIncomePastRecordSet();
float inComeMoney=0;
incomepastrs.beforefirst();
while(incomepastrs.next()){
String pastMoney = incomepastrs.getIP_Money();
float inCome=(Float.parseFloat(pastMoney))/(Float.parseFloat("10000.0"));
inComeMoney=inCome+inComeMoney;
}
float MoneySum = Float.parseFloat(moneysum)/(Float.parseFloat("10000.0"));
MoneySum=MoneySum+inComeMoney;
inComeMoney=0 ;
/*李光文2004-06-15任务支出登记*/
/* haoliang 2004-06-26 单据处理的数据 begin*/
FinProcessInfoRecordSet processRs = new FinProcessInfoRecordSet();
FinProcessInfoBusiness processBu = new FinProcessInfoBusiness();
processBu.setQueryWhereTaskID(set.getD_Serial());
processBu.execute("query");
processRs=processBu.getFinProcessInfoRecordSet();
float processMoney=0;
while(processRs.next()){
processMoney=processMoney+Float.parseFloat(processRs.getPI_Money());
}
MoneySum=MoneySum+processMoney/10000;
/* haoliang 2004-06-26 单据处理的数据 end*/
// }
%>
<td align="right" class="common" width="8%" >
<%
m5 = m5 + MoneySum ;
DecimalFormat df = new DecimalFormat("#####0.0");
if((orderby.equals("zhichu"))&&(i<11)){%>
<font color="#FF0000">
<%}%>
<%=df.format(MoneySum)%>
</font>
</td>
<td align="right" class="common" width="8%" >
<%
float profit =D_Income-MoneySum;
m6 = m6 + profit ;
DecimalFormat df1 = new DecimalFormat("#####0.0");
if((orderby.equals("lirun"))&&(i<11)){%>
<font color="#FF0000">
<%}%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -