<%@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,&nbsp;<script language="javascript">swapLang("Import Payroll Data");</script>&nbsp;</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>&nbsp;</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>&nbsp;
						<button type="button" class="btn btn-primary width100" swlang code="SW013181" onClick="checktype();">UPLOAD</button> &nbsp;&nbsp;&nbsp;<%=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>&nbsp;</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>
:&nbsp;</b></td>
                </tr>
                <tr name="trans">
                  <td class="columnData" >&nbsp;&nbsp;&nbsp;&nbsp;000001,100,F02,Y</td>
                </tr>
                <tr name="trans">
                  <td class="columnData">&nbsp;&nbsp;&nbsp;&nbsp;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>
:&nbsp;</b></td>
                  </tr>
                  <tr >
                    <td class="columnData">&nbsp;&nbsp;&nbsp;&nbsp;000001,100,13000,11000,2007-01-30,2007-02-01</td>
                  </tr>
                  <tr >
                    <td class="columnData">&nbsp;&nbsp;&nbsp;&nbsp;000002,100,15000,12000,2007-01-30,2007-02-01</td>
                  </tr>
                  <tr >
                    <td class="columnData" >&nbsp;&nbsp;&nbsp;&nbsp;000003,100,16000,12500,2007-01-30,2007-02-01</td>
                  </tr>
                  <tr>
                    <td class="columnData">&nbsp;&nbsp;&nbsp;&nbsp;000004,100,11000,95000,2007-01-30,2007-02-01</td>
                  </tr>

              </table></td>
            </tr>
          </table>
          </td>
      </tr>
 	    <tr>
    	<td class="blankspace">&nbsp;</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>