<%@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.components.ListBox" %>
<%@page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.report.ReportUDF" %>
<jsp:useBean id="PRU168" class="com.csc.library.system.Task" scope="page"/>
<%
CheckNull chk=new CheckNull();
PRU168.setChannel(request,response);
HelpEntry screen = (HelpEntry) PRU168.process("HelpEntry","MJVTEMPLATEHELP");
ReportUDF reportUDF = new ReportUDF();

String templatefilter = chk.chkNullString(request.getParameter("__templatefilter"));
String templateorder = chk.chkNullString(request.getParameter("__templateorder"),"cast(sqnumber as integer) asc");
//out.println("templatefilter ==> "+templatefilter+"<BR>templateorder ==> "+templateorder);

screen.getInquiry().setFilter(templatefilter);
screen.getInquiry().setOrderBy(templateorder);
screen.getInquiry().refresh();

int recCount = screen.getInquiry().recCount();
int maxRec = 30;
int goPage = Integer.parseInt( chk.chkNullString(request.getParameter("__goPage"),"1") );
int maxPage = recCount / maxRec;
if(recCount%maxRec > 0){ maxPage++; }
int startRec = (maxRec * goPage) - maxRec;
screen.getInquiry().go(startRec);

//out.println("<BR>recCount ==> "+recCount+" , maxRec ==> "+maxRec+" , goPage ==> "+goPage+" , startRec ==> "+startRec+" , maxPage ==> "+maxPage);
%>
<html ng-app="myHR">
	<head>
		<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 type='text/javascript' src='../JS/SCREEN.js'></script>
		<script src="../JS/angular-1.3.15/angular.js" type="text/javascript"></script>
		<script src="../JS/ANGULAR/SCREEN_ANGULAR.js" type="text/javascript"></script>
		<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
		<script type='text/javascript' src='/hr/dwr/interface/Deletejvsetup.js'></script>
		<script type='text/javascript' src='/hr/dwr/engine.js'></script>
		<script src="../JS/jquery-2.1.3.min.js" type="text/javascript"></script>
		<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
		<script language="javascript">getTitleName();</script>
		<script language="javascript">
		function checkAll(){
			with(document.cscform){
				for(i=0;i<elements.length;i++){
					if(elements[i].type=="checkbox")
					elements[i].checked=true;
				}//end for
			}//end with
		}//end function

		function decheckAll(){
			with(document.cscform){
				for(i=0;i<elements.length;i++){
					if(elements[i].type=="checkbox")
					elements[i].checked=false;
				}//end for
			}//end with
		}//end function

		function childMulti(record){
			with(document.cscform){
				window.open(__childMulti.value+".jsp?"+__childKey.value+"="+record
				,"Expertise","width=600,height=300,left=150,top=20,width=700,height=700,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
			}
		}

		function addMulti(){
			with(document.cscform){
				window.open(__childMulti.value+".jsp","Expertise","width=600,height=300,left=150,top=20,width=700,height=700,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
			}
		}

		function deleteMulti(){
			with(document.cscform){
				bCon=confirm(MyCode[4]);
				if (bCon===true){
					var value = getCheckBox();
					Deletejvsetup.jvdelete("MJVTEMPLATE", "SQNUMBER", value, function(data){
						alert("Delete Complete.");
						submit();
					});
				}
			}
		}

		function getCheckBox(){
			var value = "";
			$(".del_list").each(function(){
				if($(this).prop("checked")){
					value = chkText(value);
					value += $(this).val();
				}
			});
			return value;
		}

		function chkText(str){
			if(str.length > 0){
				str += ",";
			}
			return str;
		}

		function GoSave(){
			confirmSave();
		}
		function GoUpdate(){
			update();
		}
		function GoDelete(){
			edelete();
		}
		function GoSearch(){
			search();
		}

		function goHelp(helpName,inputName){
			var helpReturn;
			if(inputName=="__fix_njvsq" ) {
				helpReturn="__fix_njvsq:sqcode,__mjvsequencenumber_sqname:sqname";
				linkHelp_Return(helpName,helpReturn);
			} else if (inputName=="__fix_mcostcode" ) {
				helpReturn="__fix_mcostcode:maincostcentercode,__mmaincostcenter_edesc:edesc";
				linkHelp_Return(helpName,helpReturn);
			} else if (inputName=="__fix_costcode" ) {
				helpReturn="__fix_costcode:costcenterid,__mcostcenter0_edesc:edesc";
				linkHelp_Return(helpName,helpReturn);
			} else if (inputName=="__fix_analcode" ) {
				helpReturn="__fix_analcode:analcode";
				linkHelp_Return(helpName,helpReturn);
			}
		}

		function linkHelp_Return(help,input, fixCon){
			with(document.cscform){
				var filter = fixCon || __fixCon.value;
				var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off";
				win = window.open(param,"Help","left=150,top=150,width=600,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
				if(window.focus){win.focus();}
			}
		}

		function searchtemplate(){
			with(document.cscform){
				__cmd.value = "searchtemplate";
				__goPage.value = "1";
				setFilter();
				setOrderBy();
				submit();
			}
		}

		function setFilter(){
			with(document.cscform){
				var filter = "";
				if(__fix_njvsq.value !== "") filter = chkLength(filter) + "njvsq='"+__fix_njvsq.value+"'";
				if(__fix_mcostcode.value !== "") filter = chkLength(filter) + "mcostcode='"+__fix_mcostcode.value+"'";
				if(__fix_costcode.value !== "") filter = chkLength(filter) + "costcode='"+__fix_costcode.value+"'";
				if(__fix_analcode.value !== "")
				filter = chkLength(filter) + "( upper(anal_t0) like upper('%"+__fix_analcode.value+"%') or upper(anal_t1) like upper('%"+__fix_analcode.value+"%') or upper(anal_t2) like upper('%"+__fix_analcode.value+"%') or upper(anal_t3) like upper('%"+__fix_analcode.value+"%') or upper(anal_t4) like upper('%"+__fix_analcode.value+"%') or upper(anal_t5) like upper('%"+__fix_analcode.value+"%') or upper(anal_t6) like upper('%"+__fix_analcode.value+"%') or upper(anal_t7) like upper('%"+__fix_analcode.value+"%') or upper(anal_t8) like upper('%"+__fix_analcode.value+"%') or upper(anal_t9) like upper('%"+__fix_analcode.value+"%') )";
				if(__fix_flag.value !== "") filter = chkLength(filter) + "flag='"+__fix_flag.value+"'";
				__templatefilter.value = filter;
			}
		}

		function setOrderBy(){
			with(document.cscform){
				var order = __fix_orderby.value;
				if(order === "SQNUMBER"){
					__templateorder.value = "CAST(sqnumber AS INTEGER) ASC";
				} else if(order !== ""){
					__templateorder.value = " "+order+" ASC";
				}
			}
		}

		function chkLength(str){
			if(str !== ""){
				str += " AND ";
			}
			return str;
		}

		$(function(){
			$('#onpage').change(function(){
				with(document.cscform){
					__cmd.value = "goPage";
					__goPage.value = $(this).val();
					submit();
				}
			});
		});
		</script>
	</head>
	<body  leftmargin="0" topmargin="0">
		<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
		<script language="javascript">initToolTips();</script>
		<form name="cscform" method="post" action="">


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

			<%=screen.InitialVariable()%>

			<!----------END CSC INITIAL ZONE -------------------------->

			<script language="javascript">getInputFormatDate();</script>
			<input type="hidden" name="__cmd" value=""/>
			<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"/>
			<input type="hidden" name="__screen" value="PRU168"/>
			<input type="hidden" name="__childMulti" value="PRU168_DETAIL"/>
			<input type="hidden" name="__childKey" value="__sqnumber"/>
			<input type="hidden" name="__helpReturn" value=""/>
			<input type="hidden" name="__help" value=""/>
			<input type="hidden" name="__helpName" value=""/>
			<input type="hidden" name="__pageCall" value=""/>
			<input type="hidden" name="__referPage" value=""/>
			<input type="hidden" name="__goPage" value=""/>
			<input type="hidden" name="__templatefilter" value="<%=templatefilter%>"/>
			<input type="hidden" name="__templateorder" value="<%=templateorder%>"/>
			<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"/>
			<input type="hidden" name="__fixCon" value="companyid='<%=screen.getUProfile().get("companyid")%>'"/>
			<input type="hidden" name="__referPage" value=""/>
			<input type="hidden" name="__user" value="<%=screen.getUProfile().getUserId()%>"/>
			<div align="center">
				<br/>
				<table cellpadding="0" cellspacing="0" style="width:900px">
					<tr >
						<td class="header" colspan="2">PRU168, <span swlang code="SW012724">Payroll Journal Voucher Template</span>&nbsp;</td>
					</tr>
					<tr>
						<td class="blankspace" colspan="2"></td>
					</tr>
					<tr>
						<td class="columnlabel"><%=screen.getLabel("NJVSQ")%>&nbsp;::&nbsp;</td>
						<td class="columnobject1">
							<input type="text" size="15" name="__fix_njvsq" value="<%=chk.chkNullString(request.getParameter("__fix_njvsq"))%>">
							<a onmouseover="MM_swapImage('__fix_njvsq_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MJVSEQUENCENUMBERHELP','__fix_njvsq');"><img name="__fix_njvsq_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a>
							<input name="__mjvsequencenumber_sqname" type="text" readonly="true" value="<%=chk.chkNullString(request.getParameter("__mjvsequencenumber_sqname"))%>" size="40">
						</td>
					</tr>
					<tr>
						<td class="columnlabel"><%=screen.getLabel("MCOSTCODE")%>&nbsp;::&nbsp;</td>
						<td class="columnobject1">
							<input type="text" size="15" name="__fix_mcostcode" value="<%=chk.chkNullString(request.getParameter("__fix_mcostcode"))%>">
							<a onmouseover="MM_swapImage('__fix_mcostcode_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MMAINCOSTCENTERHELP','__fix_mcostcode');"><img name="__fix_mcostcode_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a>
							<input name="__mmaincostcenter_edesc" type="text" readonly="true" value="<%=chk.chkNullString(request.getParameter("__mmaincostcenter_edesc"))%>" size="40">
						</td>
					</tr>
					<tr>
						<td class="columnlabel"><%=screen.getLabel("COSTCODE")%>&nbsp;::&nbsp;</td>
						<td class="columnobject1">
							<input type="text" size="15" name="__fix_costcode" value="<%=chk.chkNullString(request.getParameter("__fix_costcode"))%>">
							<a onmouseover="MM_swapImage('__fix_costcode_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MCOSTCENTER0HELP','__fix_costcode');"><img name="__fix_costcode_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a>
							<input name="__mcostcenter0_edesc" type="text" readonly="true" value="<%=chk.chkNullString(request.getParameter("__mcostcenter0_edesc"))%>" size="40">
						</td>
					</tr>
					<tr>
						<td class="columnlabel">Analysis Code&nbsp;::&nbsp;</td>
						<td class="columnobject1">
							<input type="text" size="15" name="__fix_analcode" value="<%=chk.chkNullString(request.getParameter("__fix_analcode"))%>">
							<a onmouseover="MM_swapImage('__fix_analcode_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MJVTEMPLATE_DISTINCTANALCODE','__fix_analcode');"><img name="__fix_analcode_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a>
						</td>
					</tr>
					<tr>
						<td class="columnlabel"><%=screen.getLabel("FLAG")%>&nbsp;::&nbsp;</td>
						<td class="columnobject1">
							<%
							ListBox listboxFlag = new ListBox();
							listboxFlag.setUProfile(screen.getUProfile());
							listboxFlag.setName("fix_flag"); //ชื่อ ListBox
							listboxFlag.setValidCode("JVFLAGTEMPLATE"); //tag Systemcode ที่เรียกใช้
							listboxFlag.setBlank(true);
							listboxFlag.setDisable("false");
							listboxFlag.setChecked(chk.chkNullString(request.getParameter("__fix_flag")));
							out.println(listboxFlag.process());
							%>
						</td>
					</tr>
					<tr>
						<td class="columnlabel"><span swlang code="SW000004">Order By</span>&nbsp;::&nbsp;</td>
						<td class="columnobject1">
							<%
							ListBox listboxOrderBy = new ListBox();
							listboxOrderBy.setUProfile(screen.getUProfile());
							listboxOrderBy.setName("fix_orderby"); //ชื่อ ListBox
							listboxOrderBy.setValidCode("JVTEMPLATE_ORDERBY"); //tag Systemcode ที่เรียกใช้
							listboxOrderBy.setBlank(true);
							listboxOrderBy.setDisable("false");
							listboxOrderBy.setChecked(chk.chkNullString(request.getParameter("__fix_orderby")));
							out.println(listboxOrderBy.process());
							%>
						</td>
					</tr>

					<tr>
						<td  class="buttonline" colspan="7"><div align="center">
							<button type="button" class="btn btn-primary width100" swlang code="SW003537" onClick="searchtemplate();">SEARCH</button>
						</div>
						</td>
					</tr>
					<tr>
						<td class="blankspace" colspan="2"></td>
					</tr>
					<tr>
						<td><div>&nbsp;&nbsp;<script language="javascript">swapLang("Found Data");</script>&nbsp;::&nbsp;<%=recCount%></div></td>
						<td>
							<div align="right">Page&nbsp;::&nbsp;
								<%if(maxPage != 1){ %>
								<select id="onpage" size="0">
									<% for(int i=1; i<=maxPage; i++){ %>
									<option value="<%=i%>" <%if(goPage == i){%>selected<%}%>><%=i%></option>
									<% } %>
								</select>
								<%} else { out.println(maxPage); }%>
								&nbsp;
							</div>
						</td>
					</tr>
					<tr>
						<td colspan="2" align="center"> <div align="center">
							<table cellpadding="0" cellspacing="0" style="width:900px" class="tablewithborder">
								<tr align="center" bgcolor="#CCCCCC">
									<td class="row3"> <script language='javascript'>swapLang('Del');</script> </td>
									<td class="row3"> <%=screen.getLabel("SQNUMBER")%> </td>
									<td class="row3"> <%=screen.getLabel("NJVSQ")%> </td>
									<td class="row3"> <%=screen.getLabel("ACCTCODE")%> </td>
									<td class="row3"> <%=screen.getLabel("ACCTNAME")%> </td>
									<td class="row3"> <%=screen.getLabel("ACCTTYPE")%> </td>
									<td class="row3"> <%=screen.getLabel("FLAG")%> </td>
									<td class="row3"> <%=screen.getLabel("MCOSTCODE")%> </td>
									<td class="row3"> <%=screen.getLabel("COSTCODE")%> </td>
								</tr>
								<%
								int round = 1;
								while (screen.nextRec()) {
									if(round <= maxRec){
										%>
										<tr>
											<td align="center" class="forborder"><input type="checkbox" class="del_list" value="<%=screen.getDataLabel("SQNUMBER")%>"></td>
											<td align="center" class="forborder"> <a href="javaScript:childMulti('<%=screen.getDataLabel("SQNUMBER")%>')"><%=screen.getDataLabel("SQNUMBER")%></a></td>
											<td align="center" class="forborder"> <%=screen.getDataLabel("NJVSQ")%> </td>
											<td align="left" class="forborder">&nbsp;&nbsp;  <%=screen.getDataLabel("ACCTCODE")%> </td>
											<td align="left" class="forborder">&nbsp;&nbsp;  <%=screen.getDataLabel("ACCTNAME")%> </td>
											<td align="center" class="forborder">  <%=reportUDF.getSystemCode("JVACCTYPE", screen.getUProfile().get("lang"), screen.getDataLabel("ACCTTYPE"))%> </td>
											<td align="left" class="forborder">&nbsp;&nbsp;  <%=reportUDF.getSystemCode("JVFLAG", screen.getUProfile().get("lang"), screen.getDataLabel("FLAG"))%> </td>
											<td align="center" class="forborder"> <%=screen.getDataLabel("MCOSTCODE")%> </td>
											<td align="center" class="forborder"> <%=screen.getDataLabel("COSTCODE")%> </td>
										</tr>
										<%
										round++;
									} else {
										break;
									}
								}
								%>

								<tr>
									<td  class="buttonline" colspan="10"><div align="center">
										<button type="button" class="btn btn-primary width100" swlang code="SW013163" onClick="checkAll();">Select All</button>&nbsp;
										<button type="button" class="btn btn-primary width100" swlang code="SW013164" onClick="decheckAll();">Deselect All</button>&nbsp;
										<button type="button" class="btn btn-primary width100" swlang code="SW013165" onClick="addMulti();">Add</button>&nbsp;
										<button type="button" class="btn btn-primary width100" swlang code="SW013166" onClick="deleteMulti();">Delete</button>
									</div>
									</td>
								</tr>

							</table>
						</td>
					</tr>
					<tr>
						<td class="bottom" colspan="2"></td>
					</tr>
				</table>
			</div>

			<!----------BEGIN CSC ENDING ZONE ------------------------>


			<!----------END CSC ENDING ZONE -------------------------->

		</form>
	</body>
</html>