InputReportDataConfirm.jsp 6.26 KB

Raw Blame History Permalink

<%@ page import="weaver.general.Util" %>
<%@ page language="java" contentType="text/html; charset=GBK" %> <%@ include file="/systeminfo/init.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs1" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs2" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs4" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="CustomerInfoComInfo" class="weaver.crm.Maint.CustomerInfoComInfo" scope="page" />
<%@ include file="/datacenter/maintenance/inputreport/InputReportHrmInclude.jsp" %>

<HTML><HEAD>
<LINK href="/css/Weaver.css" type=text/css rel=STYLESHEET>
<SCRIPT language="javascript" src="/js/weaver.js"></script>
</head>
<%
String inputid = Util.null2String(request.getParameter("inputid"));
String inprepid = Util.null2String(request.getParameter("inprepid"));
/*******Add by Yeriwei! ************/
this.rs=rs;
this.req=request;
Map crmMap=this.getHrmSecurityInfoByUserId(user.getUID(),Integer.parseInt(inprepid));
List fieldsList=(List)crmMap.get("fields");
/**************************/

String thetable = Util.null2String(request.getParameter("thetable"));
String inprepbudget = Util.null2String(request.getParameter("inprepbudget"));
String inprepname = Util.null2String(request.getParameter("inprepname"));

String crmid = "" ;
String dspdate = "" ;
String inputmodid = "";
String reportdate = "" ;


String sql =  "select * from "+ thetable +
				  " where inputid ="+inputid ;

rs2.executeSql(sql) ;
rs2.next() ;
reportdate = rs2.getString("reportdate") ;
crmid = rs2.getString("crmid") ;
dspdate = Util.toScreen(rs2.getString("inprepdspdate"),user.getLanguage()) ;

sql = "select * from "+ thetable +
				  " where reportdate = '"+reportdate+"' and crmid ="+crmid +" and modtype='1' " ;

rs4.executeSql(sql) ;
rs4.next() ;
inputmodid =  Util.null2String(rs4.getString("inputid")) ;


String imagefilename = "/images/hdHRMCard.gif";
String titlename = Util.toScreen("确认输入报表",user.getLanguage(),"0") + inprepname;
String needfav ="1";
String needhelp ="";
%>
<BODY>
<%@ include file="/systeminfo/TopTitle.jsp" %>

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

<%
RCMenu += "{"+SystemEnv.getHtmlLabelName(1290,user.getLanguage())+",DataCenterInput.jsp,_self} " ;
RCMenuHeight += RCMenuHeightStep;
%>


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

<table width=100% height=100% border="0" cellspacing="0" cellpadding="0">
<colgroup>
<col width="10">
<col width="">
<col width="10">
<tr>
	<td height="10" colspan="3"></td>
</tr>
<tr>
	<td ></td>
	<td valign="top">
		<TABLE class=Shadow>
		<tr>
		<td valign="top">

<table class=liststyle cellspacing=1 >
  <COLGROUP>
  <COL width="15%">
  <COL width="40%">
  <COL width="40%">
    <tbody>
    <tr class=header>
      <td colspan=2><nobr><b><%=inprepname%> : <font color=blue><%=Util.toScreen(CustomerInfoComInfo.getCustomerInfoname(crmid),user.getLanguage())%> &nbsp; <%=dspdate%></font></b></td>
      <td align=right></td>
    </tr>
	<%
	rs.executeProc("T_IRItemtype_SelectByInprepid",""+inprepid);
	while(rs.next()) {
		String itemtypeid = Util.null2String(rs.getString("itemtypeid")) ;
		String itemtypename = Util.toScreen(rs.getString("itemtypename"),user.getLanguage()) ;
	%>
	<tr class=header>
      <td colspan=3><%=itemtypename%></td>
    </tr>
    <tr class=line>
      <td  colspan=3></td>
    </tr>
    <%
	int i = 0 ;
	rs1.executeProc("T_IRItem_SelectByItemtypeid",""+itemtypeid);
	while(rs1.next()) {
		String itemid = Util.null2String(rs1.getString("itemid")) ;
		if(!fieldsList.contains(itemid))continue;//跳过不存在的字段.
		String itemdspname = Util.toScreen(rs1.getString("itemdspname"),user.getLanguage()) ;
		String itemfieldname = Util.null2String(rs1.getString("itemfieldname")) ;
		String itemfieldtype = Util.null2String(rs1.getString("itemfieldtype")) ;
		String itemfieldscale = Util.null2String(rs1.getString("itemfieldscale")) ;
		String itemexcelsheet = Util.toScreen(rs1.getString("itemexcelsheet"),user.getLanguage()) ;
		String itemexcelrow = Util.null2String(rs1.getString("itemexcelrow")) ;
		String itemexcelcolumn = Util.null2String(rs1.getString("itemexcelcolumn")) ;
        String itemfieldunit = Util.toScreen(rs1.getString("itemfieldunit"),user.getLanguage()) ;
        String inputablefact = Util.null2String(rs1.getString("inputablefact")) ; // 实际是否可输入
        String inputablebudg = Util.null2String(rs1.getString("inputablebudg")) ; // 预算是否可输入
        String inputablefore = Util.null2String(rs1.getString("inputablefore")) ; // 预测是否可输入
        String inputable = inputablefact ;
        if(inprepbudget.equals("1")) inputable = inputablebudg ;
        else if(inprepbudget.equals("2")) inputable = inputablefore ;

        if(!inputable.equals("1")&&!itemfieldtype.equals("5")) continue ;

  	if(i==0){
  		i=1;
  	%>
    <tr class=datalight>
      <%}else{
  		i=0;
  	%>
    <tr class=datadark>
    <% }%>
      <td>
        <% if(itemfieldtype.equals("5") && !inputable.equals("1")) {%><b><%}%>
        <%=itemdspname%>
        <% if(itemfieldtype.equals("5") && !inputable.equals("1")) {%></b><%}%>
      </td>
	  <td align=right>
        <% if((itemfieldtype.equals("2") || itemfieldtype.equals("3") || (itemfieldtype.equals("5")&&inputable.equals("1")) ) && Util.getDoubleValue(rs2.getString(itemfieldname),0) != 0 ) {%> <%=Util.getFloatStr(Util.toScreen(rs2.getString(itemfieldname),user.getLanguage()),3)%><%=itemfieldunit%>
       <%} else {%>
        <% if(itemfieldtype.equals("5") && !inputable.equals("1")) {%><b> <%=Util.getFloatStr(Util.toScreen(rs2.getString(itemfieldname),user.getLanguage()),3)%><%=itemfieldunit%></b><%} else {%> <%=Util.toScreen(rs2.getString(itemfieldname),user.getLanguage())%><%=itemfieldunit%><%}%>
       <%}%>
      </td>
     <% if(itemfieldtype.equals("2") || itemfieldtype.equals("3") || itemfieldtype.equals("5") ) {%>
         <td align=right>
            <% if(Util.getDoubleValue(rs4.getString(itemfieldname),0) != 0 ) {%> <%=Util.getFloatStr(Util.null2String(rs4.getString(itemfieldname)),3)%><%=itemfieldunit%>
            <%}%>
          </td>
    <%} else {%>
        <td>&nbsp;</td>
    <%}%>
    </tr>
	<%}}%>
    </tbody>
  </table>

		</td>
		</tr>
		</TABLE>
	</td>
	<td></td>
</tr>
<tr>
	<td height="10" colspan="3"></td>
</tr>
</table>
</BODY></HTML>