<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.session.*,com.csc.library.report.*;"%>
<jsp:useBean id="EXCELLIST" class="com.csc.library.system.Task" scope="page" />
<%
	EXCELLIST.setChannel(request, response);
	HelpEntry screen = (HelpEntry) EXCELLIST.process("HelpEntry","MTEMPLATEHELP");
    screen.inq.setFilter("(create_by='"+screen.getUProfile().get("employeeid")+"' or  templateid in (select templateid from mtemplate_file where isshare ='1'))");		
	CheckNull chk=new CheckNull();
	ReportUDF rf=new ReportUDF();
	ThaiUtilities thail = new ThaiUtilities();
	CscCalendar cs=new CscCalendar();
	java.text.DecimalFormat df=new java.text.DecimalFormat("#,###,##0.00");
	screen.process();

%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >
<link href="../CSS/MENU.css" rel="stylesheet" type="text/css">
<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/VIEWCALENDAR.js"></script>
<script  language="JavaScript" src="../JS/SCREEN.js"></script>
<script type='text/javascript' src="../JS/ICONSMENU.js"></script>
<script language='javascript' src="../JS/HOTKEY.js"></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="JavaScript" type="text/JavaScript">
<!--


function goUpload(page){
    with(document.cscform){
	           open(page,"header","height=600,width=800");
	}
}

function updateHeader(page,tid){
    with(document.cscform){
				var newwin=window.open(page+"?__help=__templateid$"+tid+"&__cmd=search","header","height=600,width=800");				
	}
}

function updateChild(page,tid,fname,module){
    with(document.cscform){
				var newwin=window.open(page+"?__help=__templateid$"+tid+"&__filename="+fname+"&__cmd=search&__ac=edit&__module="+module,"header","height=600,width=800");				
	}
}


function gotopage(page,idno){
		with(document.cscform){
					action=page;
					__webid.value=idno;
					__fixCon.value="webid='"+idno+"'";
					__cmd.value="search";
					__readposter.value="count";
					
					submit();
		}
}


function GoSearch(){search();}
function GoSave() {}
function GoDelete(){ }
function GoUpdate(){}


function goHelp(helpName,inputName){
	var helpReturn;
	var fixcon=document.cscform.__fixCon.value;
	document.cscform.__fixCon.value="";
		 if(inputName=="__employeeid1" )
		 	helpReturn="__employeeid1:EMPLOYEEID,MEMPLOYEE@EMPLOYEEID";
		else 		if(inputName=="__employeeid2" )
		 	helpReturn="__employeeid2:EMPLOYEEID,MEMPLOYEE@EMPLOYEEID";
		else 		 if(inputName=="__provinceid" )
		 	helpReturn="__provinceid:provinceid,MPROVINCE@long_tname,MPROVINCE@long_ename"; 		
		else 		if(inputName=="__welid1" )
		 	helpReturn="__welid1:WELID,MWELFARE@WELID";
		else 		if(inputName=="__welid2" )
		 	helpReturn="__welid2:WELID,MWELFARE@WELID";
					
	     linkHelp_Return(helpName,helpReturn);
		 document.cscform.__fixCon.value=fixcon;
}

function GoClean()
{
}

//-->
</script>

<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body>
<div class="centered">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" action="EXCELLIST.jsp">


<!----------BEGIN CSC INITIAL ZONE ------------------------>

<%=screen.InitialVariable()%>

<!----------END CSC INITIAL ZONE -------------------------->
	<input type="hidden" name="__cmd" value="">
	<input type="hidden" name="__help" value="">
	<input type="hidden" name="__goPage" value="">
	<input  type="hidden" name="__notNull" value="<%//=screen.getRequire()%>">
	<input type="hidden" name="__helpReturn" value="">
	<input type="hidden" name="__helpName" value="">
	<input type="hidden" name="__pageCall" value="">
	<input type="hidden" name="__referPage" value="">
	<input  type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
	<input type="hidden" name="__lockPage" value="">
  <input type="hidden" name="__calendar">
   <input type="hidden" name="__screen" value="EXCELLIST">
   <input type="hidden" name="__webid">
    <input type="hidden" name="__readposter">
  <script language="javascript">getInputFormatDate();</script>
	<input type="hidden" name="__employeeid" value="">
	<input type="hidden" name="__docno" value="">
	<input type="hidden" name="__formulaid" value="">
	<input name="__fixCon" type="hidden" value="">
	<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
  	<input type="hidden" name="__companyid"  value="<%=screen.getUProfile().get("companyid")%>">
	<input name="__complainid" type="hidden" value="">

    <script language="JavaScript" src="../JS/HOTKEY.js"></script>
          <script language="javascript">
	 var titlename=swap2String('export excel');
	 document.write(Icons("EXCELLIST,"+titlename));
	 </script>

	<br> 
 <table cellpadding="0" cellspacing="0" class="largest">
      <tr >
        <td colspan="2" class="header" >EXCELLIST, <script language="javascript">swapLang(titlename);</script>&nbsp;</td>
      </tr>
      <tr >
        <td ><table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="1">
          <tr>
            <td colspan="12" class="blankspace">
              <table width="638" border="0" align="center" cellpadding="0" cellspacing="1" class="inframe">
                <tr>
                  <td colspan="2" class="blankspace"> </td>
                </tr>
                <tr class="maxsize">
                  <td width="15%" class="columnlabel_baseline">&nbsp; <script language="javascript">swapLang('Order By');</script></td>
                  <td width="538">&nbsp;<%=screen.getTagOrder()%></td>
                </tr>
                <tr>
                  <td class="columnlabel_baseline">&nbsp;<script language="javascript">swapLang('Search By');</script></td>
                  <td>&nbsp;<%=screen.getTagSearchBy()%></td>
                </tr>
                <tr>
                  <td class="columnlabel_baseline">&nbsp; <script language="javascript">swapLang('Condition');</script></td>
                  <td>&nbsp;<%=screen.getTagConSearch()%></td>
                </tr>
                <tr>
                  <td class="columnlabel_baseline"><script language="javascript">swapLang('Key Value');</script></td>
                  <td>&nbsp;<%=screen.getTagValueSearch()%></td>
                </tr>
                <tr>
                  <td class="columnlabel_baseline">&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                  <td class="columnlabel_baseline">&nbsp;</td>
                  <td>
                    <button type="button" class="btn btn-primary width100" swlang code="SW013168" onClick="GoSearch();">SEARCH</button></td>
                </tr>
                <tr>
                  <td colspan="2" class="columnlabel_baseline2">&nbsp;</td>
                </tr>
              </table>
              <div align="right"><br>
                  <%=screen.getPageTag()%></div>
                  <table width="638" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#808080" class="inframe tablewithborder">
          <tr class="title1">
            <td width="20%" nowrap class="row3"><div align="center"><%=screen.getLabel("TNAME")%></div></td>
            <td width="20%" nowrap class="row3"><div align="center"><%=screen.getLabel("ENAME")%></div></td>
            <td width="5%" nowrap class="row3"><div align="center"><%=screen.getLabel("CREATE_BY")%></div></td>
            <td width="20%" nowrap class="row3"><div align="center"><%=screen.getLabel("CREATE_DATE")%></div></td>
            <td width="20%" nowrap class="row3"><div align="center"><%=screen.getLabel("CREATE_TIME")%></div></td>
            <td width="20%" nowrap class="row3"><div align="center"><%=screen.getLabel("MODULE")%></div></td>
            <td width="20%" nowrap class="row3"><div align="center"><script language="javascript">swapLang('Add file');</script></div></td>           
          </tr>
          <% 
		  DbInquiry dbChild=null;
		  while (screen.nextRec()) {
	%>
          <tr>
            <td colspan="6" ><a href="javascript:updateHeader('./EXCHEAD.jsp','<%=screen.getString("templateid")%>')"><%=screen.getString("TNAME")%></a>-<%=screen.getString("TDESC")%></td>
            <td><div align="center"><a href="javascript:goUpload('./EXCCHILD.jsp?__templateid=<%=screen.getString("templateid")%>&__module=<%=screen.getString("module")%>');"><img src="../IMAGES/BUTTON/MAIN/NEW20.gif" width="20" height="20" border="0"></a></div></td>           
          </tr>
		  <%
		  		dbChild=(DbInquiry)screen.getInquiry().getCurrentDbRecord().getChild("mtemplate_file");
				if(dbChild.recCount()>0){
				do{
				%>
				<tr >
				<td class="writeback">&nbsp;&nbsp;&nbsp;<a href="javascript:updateChild('./EXCCHILD.jsp','<%=screen.getString("templateid")%>','<%=dbChild.getString("FILENAME")%>','<%=screen.getString("MODULE")%>')"><%=dbChild.getString("TDESC")%></a></td>
				<td class="writeback"><%=dbChild.getString("EDESC")%></td>
				<td class="writeback" nowrap><%=dbChild.getChild("memployee").getString("fullname")%></td>
				<td class="writeback"><%=dbChild.getString("CREATE_DATE")%></td>
				<td class="writeback"><%=dbChild.getString("CREATE_TIME")%></td>
				<td class="writeback"><%=screen.getString("MODULE")%></td>
				<td class="writeback"><div align="center"><a href="<%=dbChild.getCurrentDbRecord().getViewUrl("FILENAME")%>"><img src="../IMAGES/BUTTON/MAIN/COPY20.gif" border="0"></a><a href="/hr/servlet/exportexcel/?__xlsname=<%=dbChild.getString("FILENAME")%>" target="_blank"><img src="../IMAGES/BUTTON/MAIN/PRINTER20.gif" border="0"></a><a href="javascript:goUpload('./EXPEXCEL.jsp?__xlsname=<%=dbChild.getString("FILENAME")%>')"><img src="../IMAGES/BUTTON/MAIN/PROCESS20.gif" border="0"></a></div></td>				
			  </tr>
          <% 
		      }while(dbChild.next());
			}
	 }
	 %>
		 
            <tr>
              <td  class="buttonline" colspan="7"><div align="center">
                <button type="button" class="btn btn-primary width100" swlang code="SW013165" onClick="goUpload('./EXCHEAD.jsp')();">ADD</button>
              </div>
              </td>
            </tr>
		  <tr>
            <td colspan="7" class="columnlabelG" align="center"><br><div align="right"><img src="../IMAGES/BUTTON/MAIN/COPY20.gif" border="0"> = copy template  <img src="../IMAGES/BUTTON/MAIN/PRINTER20.gif" border="0">= print report  <img src="../IMAGES/BUTTON/MAIN/PROCESS20.gif" border="0">= export report</div></td>
          </tr>

          <tr>
            <td colspan="7" class="bottom"></td>
          </tr>
        </table></td>
      </tr>
    </table>
	</td>
	</tr>
	</table>
	<br>
</form>
</body>
</html>