<%@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>