Debts.jsp 8.34 KB

Raw Blame History Permalink

<%@ page import="weaver.general.Util,
                 weaver.hrm.resign.ResignProcess,
                 weaver.hrm.resign.DebtDetail" %>
<%@ page import="java.util.*" %>
<%@ page import="java.net.*" %>
<%@ page import="java.math.BigDecimal" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page"/>
<jsp:useBean id="ResourceComInfo" class="weaver.hrm.resource.ResourceComInfo" scope="page"/>
<jsp:useBean id="DepartmentComInfo" class="weaver.hrm.company.DepartmentComInfo" scope="page"/>
<jsp:useBean id="SubCompanyComInfo" class="weaver.hrm.company.SubCompanyComInfo" scope="page"/>
<jsp:useBean id="RequestComInfo" class="weaver.workflow.request.RequestComInfo" scope="page"/>


<%@ page language="java" contentType="text/html; charset=UTF-8" %> <%@ include file="/systeminfo/init_wev8.jsp" %>
<%
String id=Util.null2String(request.getParameter("id"));
//当前用户为记录本人或者其上级或者具有“离职审批”权限则可查看此页面
String userId = "" + user.getUID();
String managerId = ResourceComInfo.getManagerID(id);
if(!userId.equals(id) && !userId.equals(managerId) && !HrmUserVarify.checkUserRight("Resign:Main", user)){
	response.sendRedirect("/notice/noright.jsp");
	return;
}
%>
<HTML><HEAD>
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
</head>
<%
String imagefilename = "/images/hdDOC_wev8.gif";
String titlename = SystemEnv.getHtmlLabelName(17573,user.getLanguage());
String needfav ="1";
String needhelp ="";
%>
<BODY>
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>

<%


boolean hasNextPage=false;


int total=Util.getIntValue(Util.null2String(request.getParameter("total")),1);
int start=Util.getIntValue(Util.null2String(request.getParameter("start")),1);
int perpage=Util.getIntValue(Util.null2String(request.getParameter("perpage")),10);
ArrayList debts=ResignProcess.getDebtsDetail(id,start,perpage,user.getLanguage());
if(total>start*perpage){
	hasNextPage=true;
}


%>

<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>

	<table id="topTitle" cellpadding="0" cellspacing="0">
	<tr>
		<td>
		</td>
		<td class="rightSearchSpan" style="text-align:right;"><span title="<%=SystemEnv.getHtmlLabelName(23036,user.getLanguage())%>" class="cornerMenu"></span>
		</td>
	</tr>
</table>
<FORM id=weaver name=frmmain method=post action="Debts.jsp">
<input name=start type=hidden value="<%=start%>">
<input name=total type=hidden value="<%=total%>">
<input name=id type=hidden value="<%=id%>">
<input name=perpage type=hidden value="<%=perpage%>">
</form>
<!--
<TABLE class=ListStyle cellspacing=1>
  <TBODY>

  <TR class=Header>
  <th ><%=SystemEnv.getHtmlLabelName(15397,user.getLanguage())%></th>
  <th ><%=SystemEnv.getHtmlLabelName(15398,user.getLanguage())%></th>
  <th ><%=SystemEnv.getHtmlLabelName(874,user.getLanguage())%></th>
  <th ><%=SystemEnv.getHtmlLabelName(793,user.getLanguage())%></th>
  </tr>
  <TR class=Line><TD colspan=4 ></TD></TR>
  <%
boolean islight=true;
int totalline=1;

Iterator iter=debts.iterator();
while(iter.hasNext()){
        DebtDetail debt=(DebtDetail)iter.next();
	 String occurdate = debt.getDate();
         String amount = debt.getMoney();
         String credenceno = debt.getReceiptNo();
         String releatedid = debt.getReqid();
         String releatedname = debt.getRelatedReq();


%>
    <tr <%if(islight){%> class=DataLight <%} else {%> class=datadark <%}%>>
    <td ><%=occurdate%>
  </td>
  <td ><%=amount%>
  </td>
  <td ><%=credenceno%>
  </td>
  <td ><A
  href="/workflow/request/ViewRequest.jsp?requestid=<%=releatedid%>"><B><%=releatedname%></B></A>&nbsp;
  </td>


  </tr>


<%
	islight=!islight;
	if(hasNextPage){
		totalline+=1;
		if(totalline>perpage)	break;
	}
}
%>
  </tbody>
</table>
-->


<table class=ListStyle cellspacing=1 >
    <col width=15%>
    <col width=15%>
    <col width=30%>
    <col width=40%>
    <tr class=HeaderForXtalbe>
        <th><%=SystemEnv.getHtmlLabelName(15397,user.getLanguage())%></th>
        <th><%=SystemEnv.getHtmlLabelName(15398,user.getLanguage())%></th>
        <th><%=SystemEnv.getHtmlLabelName(874,user.getLanguage())%></th>
        <th><%=SystemEnv.getHtmlLabelName(793,user.getLanguage())%></th>
		</tr>
<%
    if( !id.equals("") ) {
		//"order by occurdate" added by lupeng 2004.05.13 for TD448.
        String sql="select * from fnaloaninfo where organizationtype=3 and organizationid="+id+" order by occurdate";

         islight=true;
        RecordSet.executeSql(sql);
        while(RecordSet.next()){
            String tmpid= Util.null2String( RecordSet.getString("id") ) ;
            String tmprequestid= Util.null2String( RecordSet.getString("requestid") ) ;
            String tmprequestname= Util.null2String( RequestComInfo.getRequestname(tmprequestid));
            String tmpamount= Util.null2String( RecordSet.getString("amount") ) ;
            String tmpoccurdate= Util.null2String( RecordSet.getString("occurdate") ) ;
            String tmpdebitremark= Util.null2String( RecordSet.getString("debitremark") ) ;
            String tmptype= Util.null2String( RecordSet.getString("loantype") ) ;
            String manager= Util.null2String( RecordSet.getString("processorid") ) ;

            if(!tmptype.equals("1")) tmpamount = ""+Util.getDoubleValue(tmpamount,0) ;
%>
    <tr <%if(islight){%> class=DataLight <%} else {%> class=DataLight<%}%>>
        <td><%=tmpoccurdate%></td>
        <td><%=tmpamount%></td>
        <td><A href="FnaPersonalReturnView.jsp?paraid=<%=tmpid%>">No:<%=tmpdebitremark%></A></td>
        <td>
        <%if(tmptype.equals("2")){%><%=SystemEnv.getHtmlLabelName(15399,user.getLanguage())%> (<%=SystemEnv.getHtmlLabelName(1047, user.getLanguage())%>:<%=Util.toScreen(ResourceComInfo.getResourcename(manager),user.getLanguage())%>)<%} else {%>
        <a href="/workflow/request/ViewRequest.jsp?requestid=<%=tmprequestid%>">
        <%=tmprequestname%></a>
        <%}%>
        </td>
    </tr>
<%
            islight=!islight;
        }

	    sql="select * from FnaBorrowInfo a where a.applicantid="+id+" order by createDate";
		RecordSet.executeSql(sql);
		while(RecordSet.next()){
			String tmprequestid= Util.null2String( RecordSet.getString("requestid") ) ;
			String tmprequestname= Util.null2String( RequestComInfo.getRequestname(tmprequestid));
			String tmpamount= Util.null2String( RecordSet.getString("amountBorrow") ) ;
			String tmpoccurdate= Util.null2String( RecordSet.getString("createDate") ) ;
			tmpamount = ""+Util.getDoubleValue(tmpamount,0) ;
		%>
		<tr <%if(islight){%> class=DataLight <%} else {%> class=DataLight<%}%>>
			<td><%=tmpoccurdate%></td>
			<td><%=tmpamount%></td>
			<td>&nbsp;</td>
			<td>
				<a href="/workflow/request/ViewRequest.jsp?requestid=<%=tmprequestid%>">
					<%=tmprequestname%></a>
			</td>
		</tr>
		<%
			islight=!islight;
		}

        String loanamount= "" ;
        RecordSet.executeSql("select sum(amount) as amount from fnaloaninfo where organizationtype=3 and organizationid="+id);
        if( RecordSet.next() ) loanamount= Util.null2String( RecordSet.getString("amount") );
		BigDecimal amount = new BigDecimal(Util.getDoubleValue(loanamount,0));
        RecordSet.executeSql("select sum(amountBorrow * borrowDirection) amt from FnaBorrowInfo a where a.applicantid=" + id);
        if( RecordSet.next() ) amount = amount.add(new BigDecimal(Util.getDoubleValue(Util.null2String( RecordSet.getString(1) ),0)));
%>
    <tr class=TOTAL style="FONT-WEIGHT: bold; COLOR: red">
        <td><%=SystemEnv.getHtmlLabelName(18801,user.getLanguage())%></td>
        <td><%=amount.setScale(2, BigDecimal.ROUND_HALF_UP).toString()%>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
    </tr>
<%  }   %>
</TABLE>


<table align=right>
   <tr>
   <td>&nbsp;</td>
   <td>
   <%if(start>1){%>
   <%

RCMenu += "{"+SystemEnv.getHtmlLabelName(1258,user.getLanguage())+",javascript:OnChangePage("+(start-1)+"),_self}" ;
RCMenuHeight += RCMenuHeightStep ;
%>
     <%}%>
 <td><%if(hasNextPage){%>
      <%

RCMenu += "{"+SystemEnv.getHtmlLabelName(1259,user.getLanguage())+",javascript:OnChangePage("+(start+1)+"),_self}" ;
RCMenuHeight += RCMenuHeightStep ;
%>     <%}
%>
 <td>&nbsp;</td>
   </tr>
	  </TABLE>

<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
<SCRIPT language="javascript">
function OnChangePage(start){
        document.frmmain.start.value = start;
		document.frmmain.submit();
}
function returnMain(){
        window.location="/hrm/resign/Resign.jsp?resourceid=<%=id%>";
}

</script>
</BODY></HTML>