<%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%> <%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %> <%@page import="java.util.*,java.net.*,java.io.*,com.csc.upload.*,com.csc.library.cscimport.MyImport;"%> <jsp:useBean id="upload" class="com.csc.library.system.Task" scope="page"/> <jsp:useBean id="hmul" class="com.csc.upload.HttpMultiPartParser" scope="page"/> <% upload.setChannel(request,response); upload.checkProfile(); UProfile u=upload.getUProfile(); InitialEnvironment en = new InitialEnvironment("GLOBAL"); String filePath=en.getValue("dirimport-dir"); String tempdir = "."; request.setAttribute("dir", request.getParameter("dir")); String browser_name = request.getRequestURI(); String status=""; Hashtable ht=new Hashtable(); String dir=""; //String table = "ttimetemp"; String table=""; String xml=""; //out.print(filePath); if ((request.getContentType()!=null)&&(request.getContentType().toLowerCase().startsWith("multipart"))){ response.setContentType("text/html"); try{ int bstart = request.getContentType().lastIndexOf("oundary="); String bound = request.getContentType().substring(bstart+8); ht = hmul.processData(request.getInputStream(), bound, tempdir); hmul.uploadFiles(ht); u.set("upload","true"); dir=(String) ht.get("dir"); xml=(String) ht.get("__xml"); FileInfo f = (FileInfo) ht.get("myFile"); String fileFullPath = f.file.toString(); String fileName=""; StringTokenizer str = new StringTokenizer(fileFullPath, "\\"); while (str.hasMoreTokens()) { fileName = str.nextToken(); } response.sendRedirect("ViewData.jsp?datafile="+fileFullPath+"&__xmlType="+xml); } catch (Exception e){ e.printStackTrace(); } } %> <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet" type="text/css"> <script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script> <script type='text/javascript' src="../JS/bootstrap.js"></script> <script language="JavaScript" src="../JS/SCREEN.js"></script> <script type='text/javascript' src='/hr/dwr/interface/SearchDWR.js'></script> <script type='text/javascript' src='/hr/dwr/engine.js'></script> <script type='text/javascript' src='/hr/dwr/util.js'></script> <script type="text/javascript" src="/hr/dwr/interface/SystemCode.js"></script> <script type="text/javascript" src="/hr/dwr/interface/CscCalendar.js"></script> <script language="javascript">setLang('<%=upload.getUProfile().get("lang")%>');</script> <script language="JavaScript" > <!-- function checktype(){ var stdstr=""; with(document.cscform){ if(myFile.value.length>0){ stdstr=myFile.value.substring(myFile.value.lastIndexOf("\\")+1,myFile.value.length); if(stdstr.indexOf(".csv")>-1){ submit(); }else if(stdstr.indexOf(".CSV")>-1){ submit(); } else{ alert("กรุณาเลือกไฟล์ (.csv) เท่านั้น"); } } else if (myFile.value.length==0) alert("กรุณาเลือกไฟล์ก่อน"); } } var moddata; var isViewed = false; function getFieldData(code){ SystemCode.getValueDWR(new Array("FIELDTYPE",code,document.cscform.__language.value), { callback:function(data) { moddata= data ;}, async:false }); } function modify(x){ for(n=0;n<x.length;n++){ getFieldData(x[n][3]); x[n][3] = moddata; } return x; } function searchFixTab(){ var tab=""; var col=""; var orderby=""; if(document.cscform.__xml.options[document.cscform.__xml.selectedIndex].value=="mempl_amt"){ tab="mamounttab"; col="amounttabid,tdesc,edesc,amnt_type"; orderby="amounttabid"; } if(document.cscform.__xml.options[document.cscform.__xml.selectedIndex].value=="mempl_fix"){ tab="mfixtab"; col="fixtabid,tdesc,edesc,fixtab_type"; orderby="fixtabid"; } SearchDWR.searchAll(new Array(tab,col,"",orderby,"langon"),function(data) { if(data.length>0) { var i = 1; var datax = modify(data); var cellFuncs = [ function(data1) { return i++; }, function(data1) { return data1[0]; }, function(data1) { return data1[1]; }, function(data1) { return data1[3]; } ]; DWRUtil.addRows( "TRANSTAB",datax, cellFuncs, { cellCreator:function(options) { var td = document.createElement("td"); td.align="center"; return td; } }); } else DWRUtil.removeAllRows('TRANSTAB'); }); } function chkType(type,fromView){ if(fromView) isViewed=true; if(isViewed){ with( document.cscform ){ var a = document.getElementById("trans"); var b = document.getElementById("sal"); var c = document.getElementById("TRANSTAB"); var d = document.getElementById("head"); var e= document.getElementById("TRANSTAB0"); var f= document.getElementById("tr1"); if(type=="memployee"){ a.style.display="none"; b.style.display=""; c.style.display="none"; d.style.display=""; e.style.display="none"; f.style.display="none"; } else{ DWRUtil.removeAllRows('TRANSTAB'); searchFixTab(); a.style.display=""; b.style.display="none"; c.style.display=""; d.style.display=""; e.style.display=""; f.style.display=""; } } } } //--> </script> </head> <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <form name="cscform" enctype="multipart/form-data" method="POST" > <input type="hidden" name="__language" value="<%=upload.getUProfile().get("lang")%>"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <!--%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <br> <div align="center"> <table cellpadding="0" cellspacing="0"> <tr > <td class="header">PRU316, <script language="javascript">swapLang("Import Payroll Data");</script> </td> </tr> <tr > <td colspan="2"> <table width="630" border="0"> <tr> <td colspan="3"></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang("File");</script> </td> <td colspan="2"> <input type="hidden"name="__screen" value="upload"> <input type="hidden" name="dir" value="<%=filePath%>"> <input type="file" name="myFile"> </td> </tr> <tr> <td></td> <td colspan="2"><select name="__xml" onChange="javascript:chkType(this.options[this.selectedIndex].value,false);"> <option selected value="mempl_fix"> <script language="javascript">swapLang("Regular Transaction");</script> </option> <option value="mempl_amt"> <script language="javascript">swapLang("Irregular Transaction");</script> </option> <option value="memployee"> <script language="javascript">swapLang("Memployee Salary");</script> </option> </select></td> </tr> <tr> <td class="buttonline" colspan="7"><div align="center"> <button type="button" class="btn btn-primary width100" swlang code="SW013170" onClick="chkType(document.cscform.__xml.options[document.cscform.__xml.selectedIndex].value,true);">VIEW</button> <button type="button" class="btn btn-primary width100" swlang code="SW013181" onClick="checktype();">UPLOAD</button> <%=u.get("lang").equalsIgnoreCase("THA") ? "กรุณาใช้ชื่อไฟล์เป็นภาษาอังกฤษ" : "Please Use English File Name Only" %> </div> </td> </tr> <tr> <td colspan="3" class="blankspace" ></td> </tr> </table> </td> </tr> <tr id="head" style="display:none"> <td class="header"><script language="javascript">swapLang("Text File's Format Example");</script> </td> </tr> <tr id="trans" style="display:none"> <td align="center"> <table width="200" border="0" align="center" cellpadding="0" cellspacing="0" class="large"> <tr> <td><table width="200" border="0" cellpadding="0" cellspacing="0" class="inframe"> <tr> <td align="center"><b> <script language="javascript">swapLang("Regular and Irregular Transaction Text File's Format");</script> </b></td> </tr> <tr> <td class="row3"><script language="javascript">swapLang("employeeid,companyid,tabid,data");</script></td> </tr> <tr> <td><b> <script language="javascript">swapLang("Example");</script> : </b></td> </tr> <tr name="trans"> <td class="columnData" > 000001,100,F02,Y</td> </tr> <tr name="trans"> <td class="columnData"> 000002,100,F03,3000</td> </tr> </table></td> </tr> </table> </td> </tr> <tr id="sal" style="display:none"> <td align="center"> <table width="200" border="0" align="center" cellpadding="0" cellspacing="0" class="large"> <tr> <td><table width="200" border="0" cellpadding="0" cellspacing="0" class="inframe"> <tr> <td align="center"><b> <script language="javascript">swapLang("Memployee Salary Text File's Format");</script> </b></td> </tr> <tr> <td class="row3"><script language="javascript">swapLang("employeeid,companyid,current salary,old salary,fisrt current exchange date,first current salary date");</script></td> </tr> <tr> <td><b> <script language="javascript">swapLang("Example");</script> : </b></td> </tr> <tr > <td class="columnData"> 000001,100,13000,11000,2007-01-30,2007-02-01</td> </tr> <tr > <td class="columnData"> 000002,100,15000,12000,2007-01-30,2007-02-01</td> </tr> <tr > <td class="columnData" > 000003,100,16000,12500,2007-01-30,2007-02-01</td> </tr> <tr> <td class="columnData"> 000004,100,11000,95000,2007-01-30,2007-02-01</td> </tr> </table></td> </tr> </table> </td> </tr> <tr> <td class="blankspace"> </td> </tr> <tr id="tr1" style="display:none"> <td height="27" colspan="2"> <table border="0" cellpadding="0" cellspacing='1' bgcolor="#333333"> <tbody id="TRANSTAB0" style="display:none"> <tr> <td class="row3"><div align="center"><script language="javascript">swapLang("Seq");</script></div></td> <td class="row3"><div align="center"><script language="javascript">swapLang("Tab ID");</script></div></td> <td class="row3"><div align="center"><script language="javascript">swapLang("Description");</script></div></td> <td class="row3"><div align="center"><script language="javascript">swapLang("Data Type");</script></div></td> </tr> </tbody> <tbody id="TRANSTAB" style="display:none"></tbody> </table> </td> <script language="javascript">//searchFixTab();</script> </tr> <tr> <td class="bottom"></td> </tr> </table> </div> </form> </body> </html>