CapitalExcelToDB.jsp 18.5 KB

Raw Blame History Permalink

<%@page import="java.util.Map.Entry"%>
<%@page import="org.json.JSONObject"%>
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%>

<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.docs.category.security.AclManager " %>
<%@ page import="weaver.docs.category.* " %>
<%@ page import="java.util.*"%>
<%@ page import="java.net.*"%>
<%@ page import="java.net.URLDecoder.*"%>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="CheckUserRight" class="weaver.systeminfo.systemright.CheckUserRight" scope="page" />
<jsp:useBean id="MainCategoryComInfo" class="weaver.docs.category.MainCategoryComInfo" scope="page" />
<jsp:useBean id="SecCategoryComInfo" class="weaver.docs.category.SecCategoryComInfo" scope="page" />
<jsp:useBean id="SecCategoryManager" class="weaver.docs.category.SecCategoryManager" scope="page" />
<jsp:useBean id="SubCategoryComInfo" class="weaver.docs.category.SubCategoryComInfo" scope="page" />
<jsp:useBean id="SecCategoryDocTypeComInfo" class="weaver.docs.category.SecCategoryDocTypeComInfo" scope="page" />
<jsp:useBean id="DepartmentComInfo" class="weaver.hrm.company.DepartmentComInfo" scope="page" />
<jsp:useBean id="MouldManager" class="weaver.docs.mouldfile.MouldManager" scope="page" />
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="ResourceComInfo" class="weaver.hrm.resource.ResourceComInfo" scope="page"/>
<jsp:useBean id="ProjectInfoComInfo" class="weaver.proj.Maint.ProjectInfoComInfo" scope="page" />
<jsp:useBean id="CustomerInfoComInfo" class="weaver.crm.Maint.CustomerInfoComInfo" scope="page" />
<jsp:useBean id="CptFieldComInfo" class="weaver.cpt.util.CptFieldComInfo" scope="page" />
<jsp:useBean id="CapitalExcelToDB" class="weaver.cpt.ExcelToDB.CapitalExcelToDB" scope="page" />
<%
String isclose = Util.null2String(request.getParameter("isclose"));
String isDialog = Util.null2String(request.getParameter("isdialog"));
String isFromTab=Util.null2String( request.getParameter("isFromTab"));
if(!"1".equals(isFromTab)){
	response.sendRedirect("/cpt/capital/CapitalExcelToDBTab.jsp?isdialog="+isDialog) ;
	return ;
}
%>


<HTML><HEAD>
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
<script LANGUAGE="JavaScript" SRC="/js/checkinput_wev8.js"></script>
<SCRIPT language="javascript" src="/js/weaver_wev8.js"></script>
<script type="text/javascript">
var parentWin = parent.parent.getParentWindow(parent.window);
if("<%=isclose%>"=="1"){
	parentWin.onBtnSearchClick();
	parentWin.closeDialog();
}
</script>
</head>
<%
if(!HrmUserVarify.checkUserRight("Capital:Maintenance",user)) {
	response.sendRedirect("/notice/noright.jsp") ;
	return ;
   }
String imagefilename = "/images/hdMaintenance_wev8.gif";
String titlename = SystemEnv.getHtmlLabelName(19320,user.getLanguage());
String needfav ="1";
String needhelp ="";

String isGeneratedTemplateFile=Util.null2String( request.getParameter("isGeneratedTemplateFile"));
if(!"1".equals(isGeneratedTemplateFile)){
	response.sendRedirect("/cpt/capital/CapitalExcelToDBOperation.jsp?generateTemplateFile=1&isdata=1&isdialog="+isDialog) ;
	return;
}
HashMap<String,JSONObject> fieldInfo=CapitalExcelToDB.getFieldInfo();
String nameQuery = Util.null2String(request.getParameter("nameQuery"));
%>
<BODY style="overflow-x:hidden;">
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>

<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<%
RCMenu += "{"+SystemEnv.getHtmlLabelName(615,user.getLanguage())+",javascript:onSave(this),_top} " ;
RCMenuHeight += RCMenuHeightStep ;
//RCMenu += "{"+SystemEnv.getHtmlLabelName(19314,user.getLanguage())+",CapitalExcelToDB1.jsp,_top} " ;
//RCMenuHeight += RCMenuHeightStep ;
%>
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>


<FORM id=cms name=cms action="CapitalExcelToDBOperation.jsp?isdata=1" method=post enctype="multipart/form-data">

<table id="topTitle" cellpadding="0" cellspacing="0">
	<tr>
		<td>
		</td>
		<td class="rightSearchSpan" style="text-align:right; width:500px!important">
			<input type="button" value="<%=SystemEnv.getHtmlLabelName( 615 ,user.getLanguage()) %>" class="e8_btn_top"  onclick="onSave(this)"/>
			<span id="advancedSearch" class="advancedSearch" style="display:none;"><%=SystemEnv.getHtmlLabelNames("347",user.getLanguage())%></span>
			<span title="<%=SystemEnv.getHtmlLabelNames("23036",user.getLanguage())%>" class="cornerMenu"></span>
		</td>
	</tr>
</table>
<div class="advancedSearchDiv" id="advancedSearchDiv" ></div>

<!-- listinfo -->
<wea:layout attributes="{'expandAllGroup':'true'}">
	<wea:group context='<%=SystemEnv.getHtmlLabelName(19320,user.getLanguage()) %>' attributes="{'groupDisplay':''}" >
		<wea:item><%=SystemEnv.getHtmlLabelName(16699,user.getLanguage())%></wea:item>
		<wea:item>
			<input class=InputStyle  type=file size=40 name="filename" id="filename">
		</wea:item>

<%
String msg=Util.null2String(request.getParameter("msg"));
String msgtype=Util.null2String(request.getParameter("msgType"));
int msgsize;
if (Util.null2String(request.getParameter("msgsize"))==""){
   msgsize=0;
}else{
msgsize=Integer.valueOf(Util.null2String(request.getParameter("msgsize"))).intValue();
}
if("success".equals(msg)||msgsize>0){
	%>
		<wea:item attributes="{'id':'msg','colspan':'full'}">
<font size="2" color="#FF0000">
<%


String msg1=Util.null2String((String)session.getAttribute("cptmsg1"));
String msg2=Util.null2String((String)session.getAttribute("cptmsg2"));
String msg3=Util.null2String((String)session.getAttribute("cptmsg3"));
int    dotindex=0;
int    cellindex=0;
int    detailindex = 0;

if("e1".equalsIgnoreCase(msgtype)){
	msg=SystemEnv.getHtmlLabelNames("24652",user.getLanguage());
}else if("e4".equalsIgnoreCase(msgtype)){
	msg=SystemEnv.getHtmlLabelNames("64,26161,563",user.getLanguage());
}else if (msg.equals("success")){
msg=SystemEnv.getHtmlLabelName(19326,user.getLanguage());
}else{
    int preRownum=0;
    for (int i=0;i<msgsize;i++){
        dotindex=msg1.indexOf(",");
        cellindex=msg2.indexOf(",");
        detailindex=msg3.indexOf("-");
        int rownum=Util.getIntValue( msg1.substring(0, dotindex),1);
        if(i==0){
            out.print(" "+ SystemEnv.getHtmlLabelName(19327, user.getLanguage())+" : ");
            preRownum=rownum;
        }
        if(preRownum!=rownum){
            out.print("<br>");
            out.print(" "+ SystemEnv.getHtmlLabelName(19327, user.getLanguage())+" : ");
            out.println();
            preRownum=rownum;
        }else if(i!=0){
            out.print("&nbsp;&nbsp;");
        }
        out.print("" + rownum + "&nbsp;" + SystemEnv.getHtmlLabelName(18620, user.getLanguage()) + "&nbsp;" + msg2.substring(0, cellindex) + "&nbsp;" + SystemEnv.getHtmlLabelName(18621, user.getLanguage()) + "&nbsp;" + msg3.substring(0, detailindex)+ "");

        msg1=msg1.substring(dotindex+1,msg1.length());
        msg2=msg2.substring(cellindex+1,msg2.length());
        msg3=msg3.substring(detailindex+1,msg3.length());
    }

}

out.println(msg);

if(session.getAttribute("cptexceltodb_totalCount")!=null&&session.getAttribute("cptexceltodb_successCount")!=null){
    double totalcount=Util.getDoubleValue((String) session.getAttribute("cptexceltodb_totalCount"),0);
    double successcount=Util.getDoubleValue((String) session.getAttribute("cptexceltodb_successCount"),0);
    if(successcount>totalcount){
        successcount=totalcount;
    }
    double failurecount=totalcount-successcount;

    if(totalcount>0){
        String s="<br>总记录数"+(int)totalcount+"条，成功导入"+(int)successcount+"条,失败"+(int)failurecount+"条。";
        if(user.getLanguage()==8){
            s="<br>The total number of records "+(int)totalcount+", into "+(int)successcount+", "+(int)failurecount+" failed.";
        }else if(user.getLanguage()==9){
            s="總記錄數"+(int)totalcount+"條，成功導入"+(int)successcount+"條，失敗"+(int)failurecount+"條。";
        }
        out.println(s);
    }
}
%></font>
		</wea:item>
	<%
}
%>

	</wea:group>

	<wea:group context='<%=SystemEnv.getHtmlLabelName(19010,user.getLanguage())%>'>
		<wea:item attributes="{'colspan':'full'}">
			<div>
				<br>
				<%=SystemEnv.getHtmlLabelName(28447,user.getLanguage())%><a style="color: #1d98f8;cursor: pointer;" href="CapitalExcelToDBnew.xls"><%=SystemEnv.getHtmlLabelName(28446,user.getLanguage())%></a>.
				<br><br>
				<%=SystemEnv.getHtmlLabelName(32986,user.getLanguage())%>.
				<br><br>
				<%=SystemEnv.getHtmlLabelName(32987,user.getLanguage())%>.
				<br><br>
				<%=SystemEnv.getHtmlLabelName(32988,user.getLanguage())%>.
				<br><br>
			</div>
		</wea:item>
	</wea:group>

	<wea:group context='<%=SystemEnv.getHtmlLabelNames("24962",user.getLanguage())%>'>
		<wea:item attributes="{'colspan':'full'}">
			<div>
				<br>
				<strong><%=SystemEnv.getHtmlLabelName(18617,user.getLanguage())%></strong>
				<br><br>
				<span style="color:#FF0000;">
					<%=SystemEnv.getHtmlLabelName(18019,user.getLanguage())%>:&nbsp;

					<%=SystemEnv.getHtmlLabelName(195,user.getLanguage())%>&nbsp;
					<%=SystemEnv.getHtmlLabelName(1507,user.getLanguage())%>&nbsp;
					<%=SystemEnv.getHtmlLabelName(1363,user.getLanguage())%>&nbsp;
                    <%=SystemEnv.getHtmlLabelName(703,user.getLanguage())%>&nbsp;
					<%=SystemEnv.getHtmlLabelName(831,user.getLanguage())%>&nbsp;
					<%=SystemEnv.getHtmlLabelName(705,user.getLanguage())%>&nbsp;
					<%=SystemEnv.getHtmlLabelName(406,user.getLanguage())%>&nbsp;
					<%=SystemEnv.getHtmlLabelName(19799,user.getLanguage())%>&nbsp;
					<%=SystemEnv.getHtmlLabelName(26451,user.getLanguage())%>&nbsp;

                    <%
                    if(fieldInfo.get("capitalspec").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(904,user.getLanguage())%>&nbsp;
                    <%
                    }
                    %>
                    <%
                    if(fieldInfo.get("capitallevel").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(603,user.getLanguage())%>&nbsp;
                    <%
                    }
                    %>
                    <%
                    if(fieldInfo.get("manufacturer").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(1364,user.getLanguage())%>&nbsp;
                    <%
                    }
                    %>
                    <%
                    if(fieldInfo.get("startprice").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelNames("191,726",user.getLanguage())%>&nbsp;
                    <%
                    }
                    %>
                    <%
                    if(fieldInfo.get("customerid").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(138,user.getLanguage())%>&nbsp;
                    <%
                    }
                    %>
                    <%
                    if(fieldInfo.get("attribute").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(713,user.getLanguage())%>&nbsp;
                    <%
                    }
                    %>
                    <%
                    if(fieldInfo.get("remark").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(454,user.getLanguage())%>&nbsp;
                    <%
                    }
                    %>
                    <%
                    if(fieldInfo.get("depreyear").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(19598, user.getLanguage())%>&nbsp;
                    <%
                    }
                    %>
                    <%
                    if(fieldInfo.get("replacecapitalid").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(1371, user.getLanguage())%>&nbsp;
                    <%
                    }
                    %>
                    <%
                    if(fieldInfo.get("version").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(567, user.getLanguage())%>&nbsp;
                    <%
                    }
                    %>
                    <%
                    if(fieldInfo.get("deprerate").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(1390, user.getLanguage())%>&nbsp;
                    <%
                    }
                    %>


				</span>


<%
TreeMap<String, JSONObject> mandfieldMap= CptFieldComInfo.getMandFieldMap();
if(mandfieldMap!=null && mandfieldMap.size()>0){
%>
				<span style="color:#FF0000;">
					<%=SystemEnv.getHtmlLabelName(17037,user.getLanguage())%>(&nbsp;

<%
	Iterator it=mandfieldMap.entrySet().iterator();
	while(it.hasNext()){
		Entry<String,JSONObject> entry=(Entry<String,JSONObject>)it.next();
		String k= entry.getKey();
		JSONObject v= entry.getValue();
%>
					<%=SystemEnv.getHtmlLabelName(v.getInt("fieldlabel"),user.getLanguage()) %>&nbsp;
<%
	}
	%>
				)</span>
	<%
}

%>


				<br><br>
				<span>
					<%=SystemEnv.getHtmlLabelName(375,user.getLanguage())%>:&nbsp;

                    <%=SystemEnv.getHtmlLabelName(19322,user.getLanguage())%>&nbsp;

                    <%
                        if(!fieldInfo.get("capitalspec").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(904,user.getLanguage())%>&nbsp;
                    <%
                        }
                    %>
                    <%
                        if(!fieldInfo.get("capitallevel").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(603,user.getLanguage())%>&nbsp;
                    <%
                        }
                    %>
                    <%
                        if(!fieldInfo.get("manufacturer").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(1364,user.getLanguage())%>&nbsp;
                    <%
                        }
                    %>
                    <%
                        if(!fieldInfo.get("startprice").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelNames("191,726",user.getLanguage())%>&nbsp;
                    <%
                        }
                    %>
                    <%
                        if(!fieldInfo.get("customerid").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(138,user.getLanguage())%>&nbsp;
                    <%
                        }
                    %>
                    <%
                        if(!fieldInfo.get("attribute").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(713,user.getLanguage())%>&nbsp;
                    <%
                        }
                    %>
                    <%
                        if(!fieldInfo.get("remark").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(454,user.getLanguage())%>&nbsp;
                    <%
                        }
                    %>
                    <%
                        if(!fieldInfo.get("depreyear").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(19598, user.getLanguage())%>&nbsp;
                    <%
                        }
                    %>
                    <%
                        if(!fieldInfo.get("replacecapitalid").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(1371, user.getLanguage())%>&nbsp;
                    <%
                        }
                    %>
                    <%
                        if(!fieldInfo.get("version").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(567, user.getLanguage())%>&nbsp;
                    <%
                        }
                    %>
                    <%
                        if(!fieldInfo.get("deprerate").getBoolean("ismand")){
                    %>
                    <%=SystemEnv.getHtmlLabelName(1390, user.getLanguage())%>&nbsp;
                    <%
                        }
                    %>

				</span>

<%
TreeMap<String, JSONObject> openfieldMap= CptFieldComInfo.getOpenFieldMap();
if(openfieldMap!=null && openfieldMap.size()>0&&mandfieldMap!=null&&openfieldMap.size()>mandfieldMap.size()){
%>
				<span >
					<%=SystemEnv.getHtmlLabelName(17037,user.getLanguage())%>(&nbsp;

<%
	Iterator it=openfieldMap.entrySet().iterator();
	while(it.hasNext()){
		Entry<String,JSONObject> entry=(Entry<String,JSONObject>)it.next();
		String k= entry.getKey();
		JSONObject v= entry.getValue();
		if(v.getInt("ismand")!=1){

%>
					<%=SystemEnv.getHtmlLabelName(v.getInt("fieldlabel"),user.getLanguage()) %>&nbsp;
<%
		}
	}
	%>
				)</span>
				<br><br>
	<%
}

%>


			</div>
		</wea:item>
	</wea:group>

</wea:layout>


<div id='_xTable' style='background:#FFFFFF;padding:3px;width:100%' valign='top'></div>

</FORM>
<script language="javascript">
function onSave(obj){
	if ($GetEle('filename').value=="" || $GetEle('filename').value.toLowerCase().indexOf(".xls")<0){
		Dialog.alert("<%=SystemEnv.getHtmlLabelName(18618,user.getLanguage())%>");
	}else{
        var showTableDiv  = document.getElementById('_xTable');
		var message_table_Div = document.createElement("div");
		message_table_Div.id="message_table_Div";
		message_table_Div.className="xTable_message";
		showTableDiv.appendChild(message_table_Div);
		var message_table_Div  = document.getElementById("message_table_Div");
		message_table_Div.style.display="inline";
		message_table_Div.innerHTML="<%=SystemEnv.getHtmlLabelName(19364,user.getLanguage())%>....";
		var pTop= document.body.offsetHeight/2-60;
		var pLeft= document.body.offsetWidth/2-100;
		message_table_Div.style.position="absolute";
		message_table_Div.style.top=pTop;
		message_table_Div.style.left=pLeft;

		$GetEle('cms').submit();
		obj.disabled = true;
    }
}
</script>
<%
if("1".equals( isDialog)){
	%>
<div id="zDialog_div_bottom" class="zDialog_div_bottom">
	<wea:layout needImportDefaultJsAndCss="false">
		<wea:group context=""  attributes="{\"groupDisplay\":\"none\"}">
			<wea:item type="toolbar">
		    	<input type="button" value="<%=SystemEnv.getHtmlLabelName(309,user.getLanguage())%>" id="zd_btn_cancle"  class="zd_btn_cancle" onclick="parentWin.closeDialog();">
			</wea:item>
		</wea:group>
	</wea:layout>
</div>
	<%
}
%>


</body>
</HTML>