<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset=UTF-8"%>
<%@ page import="com.csc.library.entry.*" %>
<%@ page import="com.csc.library.utilities.*" %>
<%@ page import="com.csc.library.session.*" %>
<%@ page import="java.text.SimpleDateFormat" %>
<%@ page import="java.util.Locale" %>
<%@ page import="java.util.Date" %>
<%@ page import="java.util.GregorianCalendar" %>
<%@ page import="java.text.DecimalFormat" %>
<jsp:useBean id="ASR001_STD" scope="page" class="com.csc.library.system.Task" />
<html ng-app="myHR">
	<%
	ASR001_STD.setChannel(request ,response);
	ReportEntry screen=(ReportEntry)ASR001_STD.process("ReportEntry",request.getParameter("__screen"));
	UProfile uf=screen.getUProfile();
	screen.process();
	ThaiUtilities th=new ThaiUtilities();
	CheckNull chk = new CheckNull();
	CscCalendar calendar = new CscCalendar();
	DecimalFormat dfdate = new DecimalFormat("00");
	String filter_date= calendar.getEngYYYY()+"-"+dfdate.format(calendar.getMonth());
	SimpleDateFormat df = new SimpleDateFormat("hh:mm a", Locale.ENGLISH);
	GregorianCalendar gc= new GregorianCalendar();
	String cmd = chk.chkNullString(request.getParameter("__cmd"));
	String screenname = chk.chkNullString(request.getParameter("__screen"));
	String conf = chk.chkNullString(request.getParameter("__confirm"));
	String conditionid = "";
	String conditiondesc ="";
	String condition="";
	String orderby="";
	String groupby="";
	String pagebreak="";
	String language="";
	String template="";
	String defaultreport="";
	String defaultcon="0";
	String norelationreport="0";
	if(cmd.equals("search") || cmd.equals("saveconstd")){
		conditionid=chk.chkNullString(request.getParameter("__conditionid"));
		DbInquiry coninq = new InitialInquiry(screen.getUProfile()).getDbInquiry("lreport_condition");
		coninq.setColumn("*");
		coninq.setFilter("conditionid = '"+conditionid+"' and screen_name='"+screenname+"' and userreport='"+screen.getUProfile().get("employeeid")+"'");
		coninq.refresh();
		if(coninq.next()){
			condition=coninq.getString("condition_value");
			orderby=coninq.getString("orderby_value");
			groupby=coninq.getString("groupby_value");
			pagebreak=chk.chkNullString(coninq.getString("pagebreak"),"0");
			defaultreport=chk.chkNullString(coninq.getString("defaultreport"),"0");
			norelationreport=chk.chkNullString(coninq.getString("norelationreport"),"0");
			language=coninq.getString("report_language");
			template=coninq.getString("template");
		}
		coninq.closeConnection();
	}else{
		DbInquiry coninq = new InitialInquiry(screen.getUProfile()).getDbInquiry("lreport_condition");
		coninq.setColumn("*");
		coninq.setFilter("screen_name='"+screenname+"' and userreport='"+screen.getUProfile().get("employeeid")+"' and  defaultreport='1'");
		coninq.refresh();
		if(coninq.next()){
			conditionid=coninq.getString("conditionid");
			conditiondesc=coninq.getString("condition_desc");
			condition=coninq.getString("condition_value");
			orderby=coninq.getString("orderby_value");
			groupby=coninq.getString("groupby_value");
			pagebreak=chk.chkNullString(coninq.getString("pagebreak"),"0");
			defaultreport=chk.chkNullString(coninq.getString("defaultreport"),"0");
			norelationreport=chk.chkNullString(coninq.getString("norelationreport"),"0");
			language=coninq.getString("report_language");
			template=coninq.getString("template");
			defaultcon="1";
		}
		coninq.closeConnection();
	}

	DbInquiry conbu  = new InitialInquiry(screen.getUProfile()).getDbInquiry("config_gohelp");
	conbu.setColumn("last_bu");
	conbu.refresh();
	conbu.next();
	%>

	<head>
		<title>Report Condition</title>
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
		<link rel="stylesheet" href="JS/QueryBuilder/dist/css/query-builder.default.min.css"/>
		<link rel="stylesheet" href="JS/QueryBuilder/bootstrap-3.3.5/css/bootstrap.min.css"/>
		<link rel="stylesheet" href="JS/QueryBuilder/bootstrap-3.3.5/css/bootstrap-theme.min.css"/>
		<link rel="stylesheet" href="JS/QueryBuilder/dist/css/custom.css"/>
		<link rel="stylesheet" href="JS/jquery-ui-1.11.4.custom/jquery-ui.css"/>
		<style type="text/css">
		.no-close .ui-dialog-titlebar-close {
			display: none;
		}
		.ui-widget-header{
			background: #3173AD;
			color: #FFFFFF;
		}
		.padding0{
			padding: 1px;
		}
		.btn-disable{
			-moz-filter: grayscale(99%);
			-webkit-filter: grayscale(99%);
			filter: gray;
			filter: grayscale(99%);
		}
		</style>
		<script type='text/javascript' src='JS/SCREEN.js'></script>
		<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
		<script src="JS/VIEWCALENDAR.js"></script>
		<script src="JS/ANGULAR/angular.js"></script>
		<script type='text/JavaScript' SRC='JS/ANGULAR/SCREEN_ANGULAR.js'></script>
	</head>
	<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="">

		<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
		<script language="javascript">initToolTips();</script>
		<form name="cscform" method="post" action="ASR001_STD.jsp">
			<input style="display:none" type="text" name="fakeusernameremembered"/>
			<input style="display:none" type="password" name="fakepasswordremembered"/>
			<input type="hidden" name="__groupText">
			<!----------BEGIN CSC INITIAL ZONE ------------------------>

			<%-- <%//=screen.InitialVariable()%> --%>

			<!----------END CSC INITIAL ZONE -------------------------->
			<br/>
			<table width="80%" align="center">
				<tr>
					<td>
						<div align="center" class="panel panel-primary">
							<div class="panel-heading">
								<h3 class="panel-title" align="right">ASR001, <%=screen.getTagReportHeaderValue()%>&nbsp</h3>
							</div>
							<table width="100%" bgcolor="red">
								<tr>
									<td colspan="6">&nbsp;</td>
								</tr>
								<tr>
									<td colspan="6" class="rowtable1">&nbsp;<span swlang code="SW012471">Condition id</span> *&nbsp;<input type="text" id="__conditionid" name="__conditionid" size="8" maxlength="8" value="<%=chk.chkNullString(request.getParameter("__conditionid"),conditionid)%>">&nbsp;
									<a href="javascript:goHelp('LREPORT_CONDITIONHELP','__conditionid')" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image6" width="20" height="20" border="0" align="absmiddle"></a>
									&nbsp;<input type="text" id="__conditiondesc" name="__conditiondesc" size="20" maxlength="20" value="<%=chk.chkNullString(request.getParameter("__conditiondesc"),conditiondesc)%>">&nbsp;
									<input type="checkbox" id="__default" name="__default" value="1" >&nbsp;<span swlang code="SW012472">default</span>
									&nbsp;<button type="button" class="btn btn-sm btn-primary" onclick="goSavecon();"swlang code="SW000117">Save</button>
									&nbsp;<button type="button" class="btn btn-sm btn-danger" onclick="goDelcon();"swlang code="SW000123">Delete</button>
									&nbsp;<button type="button" class="btn btn-sm btn-success" onclick="goClearcon();"swlang code="SW013047">Clear</button>
									<span swlang code="SW012473">Page Break</span>&nbsp;<input type="checkbox" id="__pagebreak" name="__pagebreak" value="1"></td>

								</tr>
								<tr>
									<td colspan="6">&nbsp;</td>
								</tr>
								<tr>
									<td class="rowtable1">&nbsp;<span swlang code="SW000004">Order By</span></td>
									<td class="rowtable1">&nbsp;<%=screen.getTagOrderBySTD()%></td>
									<td class="rowtable1" colspan="3">&nbsp;<input type="text" disabled size="40" name="__orderText" id="__orderText"></td>
									<td>
										<font size="2" face="microsoft Sans Serif">
											[ <a href="#" onClick="javascript:reduorder();" swlang code='SW000123'>Delete</a> ]
											[ <a href="#" onClick="javascript:dellOrderBy();" swlang code='SW000124'>Delete All</a> ]
										</font>
									</td>
								</tr>
								<tr>
									<td class="rowtable1">&nbsp;<span swlang code="SW000122">Group By</span></td>
									<td class="rowtable1">&nbsp;<%=screen.getTagGroupBySTD()%></td>
									<td class="rowtable1" colspan="4">&nbsp;</td>
								</tr>
								<tr>
									<td class="rowtable1">&nbsp;<span swlang code="SW000126">Language</span></td>
									<td class="rowtable1">&nbsp;<%=screen.getTagLanguageSTD()%></td>
									<td class="rowtable1">&nbsp;<span swlang code="SW000127">Template</span></td>
									<td class="rowtable1">&nbsp;<%=screen.getTagTemplate()%></td>
									<td class="rowtable1">&nbsp;</td>
									<td>
										<font size="2" face="microsoft Sans Serif">
											<input type="checkbox" id="chkNoRelation" name="__chknorelation" value="NORELATION">&nbsp; <span swlang code="SW013249">NO RELATION</span>
										</font>
									</td>
								</tr>
								<tr>
									<td colspan="5">&nbsp;&nbsp;<div id="builder"></div></td>
									<td valign="center" align="center">
										<br/>&nbsp;&nbsp;
										<div class="btn-group-vertical" role="group" aria-label="...">
											<button id="option" type="button" class="btn btn-sm btn-success" onclick="goOption();"swlang code="SW011314">Option</button>
											<button id="print" type="button" class="btn btn-sm btn-primary" onclick="goPreview();"swlang code="SW005455">Print</button>
											<button type="button" class="btn btn-sm btn-info" onclick="goSubmit();"swlang code="SW013178">Export</button>
											<%if(screen.getAddCondition().equals("true")){%>
											<button type="button" class="btn btn-sm btn-warning" onclick="GoCondition();">&nbsp;&nbsp;Condition&nbsp;&nbsp;</button>
											<%}%>
										</div>
									</td>
								</tr>
								<tr>
									<td colspan="5">&nbsp;&nbsp;<textarea class="form-control" id="__condition" name="__condition" rows="10"></textarea></td>
									<td>&nbsp;</td>
								</tr>
								<tr>
									<td colspan="6">&nbsp;</td>
								</tr>
							</table>
						</div>
					</td>
				</tr>
			</table>
			<%
			String table=screen.getMainTable();
			//out.print(screen.getFieldTable(table));
			%>
			<input type="hidden" name="__resultSet" value=""/>
			<input type="hidden" name="__calendar"/>
			<input type="hidden" name="mem" value=""/>
			<INPUT TYPE="hidden" name="__reportname" VALUE="<%=screen.getEngHeaderValue()%>"/>
			<INPUT TYPE="hidden" name="__screen" id="__screen" VALUE="<%=request.getParameter("__screen")%>"/>
			<input type="hidden" name="__cmd" ID="__cmd" value="<%=chk.chkNullString(cmd)%>"/>
			<input type="hidden" name="__data"  value=""/>
			<input type="hidden" name="__filtercon"  value=""/>
			<input type="hidden" name="helpParam" value=""/>
			<input type="hidden" name="__fixCon" value=""/>
			<input type="hidden" name="helpName" value="<%=screen.getMainHelp()%>"/>
			<input type="hidden" name="mainHelp" value="<%=screen.getMainHelp()%>"/>
			<input type="hidden" name="__thaiHeader" value="<%=screen.getThaiHeaderValue()%>"/>
			<input type="hidden" name="__engHeader" value="<%=screen.getEngHeaderValue()%>"/>
			<input type="hidden" name="__startPage" value="1"/>
			<input type="hidden" name="__classname" value="ReportExport"/>
			<input type="hidden" name="__reportstd" value="true"/>
			<input type="hidden" name="__confirm" id="__confirm" value=""/>
			<input type="hidden" name="__lang" id="__lang" value="<%=screen.getUProfile().get("lang")%>"/>

			<%=screen.getTagComponentHidden()%>
			<%=screen.getTagFixFilterHiddenSTD()%>
			<%=screen.getTagChildChkHidden()%>

			<input type="hidden" name="com_tname" value="<%=screen.getUProfile().get("com_tname")%>"/>
			<input type="hidden" name="com_ename" value="<%=screen.getUProfile().get("com_ename")%>"/>
			<INPUT TYPE="hidden" NAME="company" VALUE="<%=screen.getUProfile().get("companyname")%>"/>
			<INPUT TYPE="hidden" NAME="__COMPANY" VALUE="<%=screen.getUProfile().get("companyname")%>"/>
			<input type="hidden" name="__COMPANY_THA" value="<%=screen.getUProfile().get("com_tname")%>"/>
			<input type="hidden" name="__COMPANY_ENG" value="<%=screen.getUProfile().get("com_ename")%>"/>
			<INPUT TYPE="hidden" NAME="__mmxml" VALUE="<%=request.getParameter("__mmxml")%>"/>
			<INPUT TYPE="hidden" NAME="__expxml" VALUE="<%=request.getParameter("__expxml")%>"/>
			<input type="hidden" name="__export_type" value="EXPORT_PDF"/>
			<input type="hidden" name="__file_type" value="pdf"/>
			<input type="hidden" name="__pageprinting" value="PAGEPRINTINGSTD.jsp"/>
			<input type="hidden" name="__reportHeader" id="__reportHeader" value="<%=screen.getTagReportHeaderValue()%>"/>
			<input type="hidden" name="fieldtable" id="fieldtable" value="<%=screen.getFieldTableSTD(table)%>"/>

			<input type="hidden" name="condition" id="condition" value="<%=chk.chkNullString(condition)%>"/>
			<input type="hidden" name="orderby2" id="orderby2" value="<%=chk.chkNullString(orderby)%>"/>
			<input type="hidden" name="groupby2" id="groupby2" value="<%=chk.chkNullString(groupby)%>"/>
			<input type="hidden" name="pagebreak2" id="pagebreak2" value="<%=pagebreak%>"/>
			<input type="hidden" name="language2" id="language2" value="<%=chk.chkNullString(language)%>"/>
			<input type="hidden" name="template2" id="template2" value="<%=chk.chkNullString(template)%>"/>
			<input type="hidden" name="defaultreport" id="defaultreport" value="<%=defaultreport%>"/>
			<input type="hidden" name="norelationreport" id="norelationreport" value="<%=norelationreport%>"/>

			<input type="hidden" name="searchstatus" id="searchstatus" value="0"/>
			<input type="hidden" name="inputname" id="inputname" value="0"/>
			<input type="hidden" name="defaultcon" id="defaultcon" value="<%=defaultcon%>"/>
			<input type="hidden" name="user" id="user" value="<%=chk.chkNullString(screen.getUProfile().get("employeeid"))%>"/>
			<input type="hidden" name="__module" id="__module" value=""/>
			<input type="hidden" name="__ACTORID" value="<%=uf.get("actorid")%>"/>
			<input type="hidden" name="__ACTORNAME" value="<%=uf.get("fullname")%>"/>
			<input type="hidden" name="__ACTORNAME_THA" value="<%=uf.get("tfullname")%>"/>
			<input type="hidden" name="__ACTORNAME_ENG" value="<%=uf.get("efullname")%>"/>
			<input type="hidden" name="__datethai" value="<%="วัน"+calendar.getLongThiDOW()+"ที่ "+calendar.getDate()+ " " + calendar.getThaiLongMonth() + " พ.ศ. "+ calendar.getThaiYYYY() +
			" " +calendar.getHHMM() + " น."%>"/>
			<input type="hidden" name="__dateeng" value="<%=calendar.getEngFull()+ " " + df.format((Date)gc.getTime())%>"/>
			<input type="hidden" name="__languagereport" value="<%=screen.getUProfile().get("lang")%>"/>
			<input type="hidden" name="__dateformat" value="YYYY-MM-DD"/>
			<input type="hidden" name="__groupbydesc" id="__groupbydesc" value=""/>
			<input type="hidden" name="__orderby" id="__orderby" value="0"/>
			<input type="hidden" name="__extraorderby" id="__extraorderby" value=""/>
			<input type="hidden" name="__norelation" id="__norelation" value=""/>
			<input type="hidden" name="__groupby" id="__groupby" value="0"/>
			<input type="hidden" name="OptionRequire" id="OptionRequire" value="<%=screen.getOptionRequireSTD()%>"/>
			<input type="hidden" name="__pdfpassword" id="__pdfpassword" value="false"/>
			<input type="hidden" name="__passwordtext" id="__passwordtext" value=""/>
			<input type="hidden" name="__addcondition" id="__addcondition" value="<%=screen.getAddCondition()%>"/>
			<input type="hidden" name="__addconditionfilter" id="__addconditionfilter" value="status in ('A','V') or employeeid in (select employeeid from memployee where status='Y' and resigndate like '%<%=filter_date%>%')"/>
			<input type="hidden" name="__lastbu" value="<%=conbu.getString("last_bu")%>"/>
			<%=screen.getConditionHidden(10)%>

			<%
			String setlang = screen.getUProfile().get("lang");
			String fieldswaplang = "";
			if(screen.getUProfile().get("lang").equalsIgnoreCase("tha")){
				fieldswaplang = "thai";
			}else{
				fieldswaplang = "eng";
			}
			DbInquiry swaplang = new InitialInquiry(screen.getUProfile()).getDbInquiry("swaplang_detail");
			swaplang.setColumn("codeid,thai,eng");
			swaplang.setFilter("codeid in ('BU1','BU2','BU3','BU4','BU5')");
			swaplang.refresh();

			while(swaplang.next())	{
				%>

				<input type="hidden" name="<%="__"+swaplang.getString("codeid")%>" value="<%=swaplang.getString(fieldswaplang)%>">
				<input type="hidden" name="<%="__"+swaplang.getString("codeid")+"_THA"%>" value="<%=swaplang.getString("thai")%>">
				<input type="hidden" name="<%="__"+swaplang.getString("codeid")+"_ENG"%>" value="<%=swaplang.getString("eng")%>">

				<%
			}
			conbu.closeConnection();
			%>


			<div id="dialog" style="display: none;">
				<br/>
				<input type="password" id="inputpassword" name="inputpassword" size="46" maxlength="40"/>
				<br/>
			</div>
		</form>

		<script type='text/javascript' src='JS/jquery-1.11.3.min.js'></script>
		<script type='text/javascript' src="JS/jquery-ui-1.11.4.custom/jquery-ui.js"></script>
		<script type='text/javascript' src='JS/QueryBuilder/bootstrap-3.3.5/js/bootstrap.min.js'></script>
		<script type='text/javascript' src='JS/QueryBuilder/dist/js/query-builder.standalone-mod.js'></script>
		<script type='text/javascript' src='JS/QueryBuilder/dist/js/sql-parser.js'></script>
		<script type='text/javascript' src='JS/QueryBuilder/dist/js/moment.js'></script>
		<script type='text/javascript' src='JS/VIEWCALENDAR.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/GetPasswordFromMuser.js"></script>

		<script language="JavaScript" type="text/JavaScript">
			var newpageIndex=1;
			var groupLength=0;
			var orderLength=0;
			var orderArray = new Array(50);
			var groupArray = new Array(50);

			function goHelp(helpName,inputName,linkhelp) {
				var helpReturn;
				var fixcon;
				var screen=document.getElementById("__screen").value;
				var user=document.getElementById("user").value;
				if (inputName=="__conditionid" ) {
					helpReturn="__conditionid:conditionid,__conditiondesc:condition_desc";
					fixcon="screen_name='"+screen+"' and userreport='"+user+"'";
					document.getElementById("searchstatus").value="0";
				}else if( inputName.indexOf("builder_rule_") > -1 ){
					helpReturn=inputName+":"+linkhelp;
					document.getElementById("searchstatus").value="1";
					document.getElementById("inputname").value=inputName;
				}
				linkHelp_Return(helpName,helpReturn,fixcon);
			}


			function sysHelp(input,data) {
				with(document.cscform){
					var param="SYSHELP_STD.jsp?__input="+input+"&__helpName="+data;
					window.open(param,"Help","left=150,top=150,width=600,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
				}
			}

			function postReturn(){
				with(document.cscform){
					if(searchstatus.value=="0"){
						__cmd.value="search";
						target = "";
						action="";
						submit();
					}else{
						$.setcondition('1');
					}
				}
			}

			function postCalendarSTD(data){
				with(document.cscform){
					document.getElementById("inputname").value=data;
					$.setcondition('1');
				}
			}

			function goSubmit(){
				with(document.cscform){
					var orequire = OptionRequire.value;
					var pass = __pdfpassword.value;
					if(orequire!='true'){
						if(pass!='true'){
							showexport();
						}else{
							$.showdialog("export");
						}

					}else{
						alert(MyCode[224]);
					}
				}
			}

			function showexport(){
				with(document.cscform){
					action = "ASR003_STD.jsp";
					window.open("","save","left=150,top=150,width=700,height=200,toolbar=no,status=yes,scrollbars=yes");
					target="save";
					submit();
				}
			}

			function goSavecon(){
				with(document.cscform){
					var conditionid=__conditionid.value;
					if(!conditionid=="" || !conditionid==null){
						var bCon=confirm(MyCode[1]);
						if (bCon==true){
							__cmd.value="saveconstd";
							action="";
							target = "";
							submit();
						}
					}else{
						alert(MyCode[0]);
					}
				}
			}

			function goDelcon(){
				with(document.cscform){
					var bCon=confirm(MyCode[4]);
					if (bCon==true){
						__cmd.value="delconstd";
						action="";
						target = "";
						submit();
					}
				}
			}

			function goClearcon(){
				with(document.cscform){
					var lang = __lang.value;
					__conditionid.value="";
					__conditiondesc.value="";
					__default.checked=false;
					__chknorelation.checked=false;
					__pagebreak.checked=false;
					__orderbystd.selectedIndex=0;
					__groupbystd.selectedIndex=0;
					__template.selectedIndex=0;
					__language.value=lang.toUpperCase();
					$.reset();
				}
			}

			function goPreview(){
				with(document.cscform){
					var orequire = OptionRequire.value;
					var pass = __pdfpassword.value;
					if(orequire!='true'){
						bCon=confirm(MyCode[10]);
						if (bCon==true)	{
							if(pass!='true'){
								showpreview();
							}else{
								$.showdialog("print");
							}
						}

					}else{
						alert(MyCode[224]);
					}
				}
			}

			function checkpassword(type){
				with(document.cscform){
					var password = __passwordtext.value;
					if (password != null && password!="") {
						if(type=="print"){
							GetPasswordFromMuser.ComparePassword(new Array(password), callpass);
						}else{
							GetPasswordFromMuser.ComparePassword(new Array(password), callpassexport);
						}
					}
				}
			}

			function showpreview(){
				with(document.cscform){
					var a="/hr/servlet/reportservletstd/?";
					action = a;
					target = "_blank";
					method="post";
					submit();
				}
			}

			function callpass(data){
				with(document.cscform){
					if(data==true){
						showpreview();
					}else{
						alert(MyCode[226]);
						$.showdialog("print");
					}
				}
			}

			function callpassexport(data){
				with(document.cscform){
					if(data==true){
						showexport();
					}else{
						alert(MyCode[226]);
						$.showdialog("export");
					}
				}
			}

			function goOption(){
				with(document.cscform){
					OptionRequire.value="false";
					window.open("<%=screen.getComponentPageSTD("ASR002")%>.jsp?__screen="+__screen.value);
				}
			}

			function setcon(input,e){
				with(document.cscform){
					if (e.keyCode == 13) {
						inputname.value=input.name;
						$.setcondition(1);
					}
				}
			}

			function setNewPage(value,text,first){
				//alert(first);
				with(document.cscform){
					if(first==true){
						newpageIndex=1;
						__onnewpage.options.length=1;
					}
					__onnewpage.options[newpageIndex++]=new Option(text,value,false);
				}
			}

			function setBU(){
				var strbu = ['BU1','BU2','BU3','BU4','BU5','ACTORNAME','COMPANY'];
				var lang = $('#__language').val();

				for (i=0; i<strbu.length; i++){
					var name = "__"+strbu[i];
					$('input[name='+name+']').val( $('input[name='+(name+"_"+lang)+']').val() );
				}
			}

			function changeHeader(){
				setBU();
			}

			function GoCondition(){
				with(document.cscform){
					window.open("ASR002_STD.jsp?__screen="+__screen.value);
				}
			}

			function reduorder(){
				with(document.cscform){
					if(orderLength>0){
						orderArray[--orderLength]="  ";
						setOrderText();
						__orderby.value = __orderText.value;
						if(__orderby.value == ""){
							__orderby.value = "0";
						}
					}
				}
			}

			function setOrderText(){
				with(document.cscform){
					b="";
					for( i=0;i<orderLength;i++){
						b=b+orderArray[i];
					}
					__orderText.value=b;
				}
			}

			function insertOrderBy(){
				var i=0;
				var isdup=false;
				with(document.cscform){
					if(__orderbystd.value !=0){
						for(i=0;i<=orderLength;i++){
							//alert(__orderby.value+"  "+ orderArray[i]);
							if((__orderbystd.value==orderArray[i])||(","+__orderbystd.value==orderArray[i])){
								alert(__orderbystd.value+"  "+ MyCode[11]);
								isdup=true;
							}
						}
						if(isdup==false){
							if(orderLength != 0)
							orderArray[orderLength++]=","+__orderbystd.value;
							else orderArray[orderLength++]=__orderbystd.value;
						}
						setOrderText();

					}
					__orderbystd.options[0].selected= true;
				}
			}

			function dellOrderBy(){
				with(document.cscform){
					for( i=0;i<orderLength;i++){
						orderArray[i]="  ";
					}
					orderLength=0;
					setOrderText();
					__orderby.value = __orderText.value;
					if(__orderby.value == ""){
						__orderby.value = "0";
					}
				}
			}

			function redugroup(){
				with(document.cscform){
					if(groupLength>0){
						groupArray[--groupLength]="  ";
						setGroupText();
					}
				}
			}

			function setGroupText(){
				with(document.cscform){
					b="";
					for( i=0;i<groupLength;i++){
						b=b+groupArray[i];
					}
					__groupText.value=b;
				}
			}

			function dellGroupBy(){
				with(document.cscform){
					for( i=0;i<groupLength;i++){
						groupArray[i]="  ";
					}
					groupLength=0;
					setGroupText();
					//__onnewpage.options.length=1;
					//newpageIndex=1;
				}
			}

		</script>

		<script>
			var options = {
				filters: []
			}

			$.reset = function(){
				$('#builder').queryBuilder('reset');
				$('#__condition').val('');
			}

			$.setOption = function(){
				var module=$("#__module").val();
				var field=$("#fieldtable").val();
				var data = field.split(",");

				for(var i=0;i<data.length;i++){
					var field = data[i].split("@");
					var fieldid = field[0].split(":");
					var id = (field[5] === undefined) ? fieldid[0] : field[5]
					var exfilter = (field[6] === undefined) ? "" : field[6]
					var encrypt = (field[7] === undefined) ? "" : field[7]
					var dbtype = (field[8] === undefined) ? "" : field[8]
					if(field[4]==="date"){
						options.filters.push({id: id,label: fieldid[0]+" : "+fieldid[1],type: field[4] , operators: ['equal', 'not_equal','less','less_or_equal','greater','greater_or_equal','contains','is_null', 'is_not_null'],exfilter:exfilter,encrypt:encrypt,dbtype:dbtype,validation:{format: 'yyyy-mm-dd'},module:module})
					}else if(field[4]==="double"){
						options.filters.push({id: id,label: fieldid[0]+" : "+fieldid[1],type: field[4] , operators: ['equal', 'not_equal','less','less_or_equal','greater','greater_or_equal','contains','is_null', 'is_not_null'],exfilter:exfilter,encrypt:encrypt,dbtype:dbtype})
					}else{
						options.filters.push({id: id,label: fieldid[0]+" : "+fieldid[1],type: field[4] , operators: ['equal', 'not_equal','less','less_or_equal','greater','greater_or_equal','contains','is_null', 'is_not_null'],exfilter:exfilter,encrypt:encrypt,dbtype:dbtype,help:field[1],linkhelp:field[2],validcode:field[3]})
					}
				}
				var lang = $("#__lang").val();
				if(lang=="tha"){
					options.lang_code='th';
				}else{
					options.lang_code='en';
				}
			}

			$.setSearch = function(){
				var cmd = $('#__cmd').val();
				var defaultcon = $('#defaultcon').val();
				if((cmd=='search') || (cmd=='saveconstd') || (defaultcon=='1') || (cmd=='delconstd')){
					if(cmd=='delconstd'){
						__conditionid.value="";
						__conditiondesc.value="";
					}

					$('#__condition').val($('#condition').val());

					$("#__orderbystd option[value='" + $('#orderby2').val() + "']").prop("selected",true);
					$("#__groupbystd option[value='" + $('#groupby2').val() + "']").prop("selected",true);

					$('#__orderby').val($('#orderby2').val());
					$('#__groupby').val($('#groupby2').val());

					if($('#pagebreak2').val()=="1"){
						$('#__pagebreak').prop('checked', true);
					}

					if($('#defaultreport').val()=="1"){
						$('#__default').prop('checked', true);
					}

					if($('#norelationreport').val()=="NORELATION"){
						$('#chkNoRelation').prop('checked', true);
					}

					$("#__language option[value='" + $('#language2').val() + "']").prop("selected",true);
					$("#__template option[value='" + $('#template2').val() + "']").prop("selected",true);

					$('#builder').queryBuilder('setRulesFromSQL', $('#condition').val());
				}
			}

			$.setcondition = function(data){
				if(data=='1'){
					var input = $('#inputname').val();
					$('input[name="'+input+'"]').change();
				}
				var sql=$('#builder').queryBuilder('getSQL',false, false).sql;
				$('#__condition').val(sql);
			}


			$.checkstatus=function(){
				var cmd = $('#__cmd').val();
				if(cmd=='saveconstd'){
					alert(MyCode[18]);
				}else if(cmd=='delconstd'){
					alert(MyCode[19]);
				}
			}

			$.setmodule=function (){
				var path = window.parent.location.pathname;
				var module = path.split("/");
				$('#__module').val(module[2]);
			}

			$.showdialog=function(type){
				$( "#dialog" ).dialog({
					dialogClass: "no-close",
					title: MyCode[225],
					width: 400,
					buttons: [
						{
							text: "OK",
							click: function() {
								$("#__passwordtext").val($("#inputpassword").val())
								checkpassword(type);
								$(this).dialog( "close" );
							}
						},{
							text: "CANCEL",
							click: function() {
								$(this).dialog( "close" );
							}
						}
					]
				});
			}

			$(function(){
				$.setmodule();
				$.setOption();
				$('#builder').queryBuilder(options);
				$.checkstatus();
				$.setSearch();
				$('#builder').on('afterDeleteRule.queryBuilder', function(e, rule, error, value) {
					$.setcondition('0');
				});

				$('#builder').on('afterDeleteGroup.queryBuilder', function(e, rule, error, value) {
					$.setcondition('0');
				});

				$('#builder').on('afterUpdateRuleOperator.queryBuilder', function(e, rule, error, value) {
					$.setcondition('0');
				});

				$('#builder').on('afterUpdateGroupCondition.queryBuilder', function(e, rule, error, value) {
					$.setcondition('0');
				});

				$('#__orderbystd').on('change', function() {
					$('#__orderby').val($('#__orderText').val());
					//$('#__orderText').val($(this).val());
				});

				$('#__groupbystd').on('change', function() {
					$('#__groupby').val($(this).val());
					$('#__extraorderby').val("");
					//$('#__groupText').val($(this).val());
				});

				$('#chkNoRelation').on('change', function() {
					var value = "";
					if($(this).prop('checked')){
						value = $(this).val();
					}
					$('#__norelation').val(value);
				})
			})
			$(document).ready(function(){
				var linkpage = <%=screen.hasLinkPage()%> ;
				if(linkpage === false){
					$("button[id=option]").addClass("btn-disable disabled");
					$("button[id=option]").attr("onclick","");
				}
			});
		</script>

	</body>
</html>