<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.*,com.csc.library.utilities.*"%>
<%@page import="com.csc.library.session.*"%>

<%@page import="com.csc.library.utilities.CheckNull"%>

<%
String helpReturn="";
if( request.getParameter("__helpReturn") != null ){
	helpReturn=request.getParameter("__helpReturn");
}
String fieldSearch="";
if( request.getParameter("__fieldSearch")!=null ){
	fieldSearch=request.getParameter("__fieldSearch");
}
%>

<jsp:useBean id="BROWSE_HELP" class="com.csc.library.system.Task" scope="page"/>

<%
BROWSE_HELP.setChannel(request, response);
HelpEntry screen = (HelpEntry) BROWSE_HELP.process("HelpEntry",request.getParameter("__helpName"));
CheckNull chkNull = new CheckNull();
ThaiUtilities tu = new ThaiUtilities();
String searchby=chkNull.chkNullString(request.getParameter("__searchField"));
String valuesearch=chkNull.chkNullString(tu.ASCII2Unicode(request.getParameter("__valueSearch")));
String consearch=chkNull.chkNullString(request.getParameter("__conSearch"));

if(valuesearch.length()>0){
		if(searchby.equals("long_tname")){
				DbInquiry db=	(DbInquiry)screen.getInquiry().getChild("CSCZIPCODE").getChild("MPROVINCE");
				if(consearch.trim().equalsIgnoreCase("like")){
					db.setFilter("long_tname","%"+valuesearch+"%","",consearch);
					}else{
						db.setFilter("long_tname",valuesearch,"",consearch);
						}
				screen.getInquiry().getChild("CSCZIPCODE").setRequireFoundTable("MPROVINCE");
		}else{
				if(consearch.trim().equalsIgnoreCase("like")){
						screen.getInquiry().setFilter(searchby,"%"+valuesearch+"%","",consearch);
					}else{
						screen.getInquiry().setFilter(searchby,valuesearch,"",consearch);
					}
		}		
}


//screen.getInquiry().setFilter("siteweltype","1","","between");
screen.getInquiry().setRequireFoundTable("CSCZIPCODE");
screen.setMaxLine(30);
screen.process();
if( !chkNull.chkNullString(request.getParameter("__langOn")).equals("") && request.getParameter("__langOn").equalsIgnoreCase("true") ){
	screen.referLangOn();
}else{
	screen.referLangOff();
}
%>


<HTML>
	<HEAD>
		<TITLE>myNOTE : Business Process Management Service</TITLE>
		<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
		<LINK HREF="../CSS/MYNOTE.css" REL="stylesheet" TYPE="text/css">
		<SCRIPT TYPE='text/JavaScript' SRC='../JS/MYNOTE_SCREEN.js'></SCRIPT>
		<SCRIPT TYPE='text/JavaScript' SRC='../JS/SCREEN.js'></SCRIPT>
		<SCRIPT LANGUAGE="JavaScript">setLang('<%=screen.getUProfile().get("lang")%>');</SCRIPT>
		<SCRIPT LANGUAGE="JavaScript" TYPE="text/JavaScript">
		<!--
		-->
		</SCRIPT>
		<STYLE TYPE="text/css">
		<!--
			.style1 {
				color: #FFFFFF;
				font-weight: bold;
			}
		-->
		</STYLE>
	</HEAD>
	<BODY>
		<FORM NAME="cscform" METHOD="post" ACTION="BROWSE_SITEWELHELP.jsp">		
			<INPUT TYPE="hidden" NAME="__screen" VALUE="BROWSE_SITEWELHELP">
			<INPUT TYPE="hidden" NAME="__cmd" VALUE="">
			<INPUT TYPE="hidden" NAME="__help" VALUE="">
			<INPUT TYPE="hidden" NAME="__goPage" VALUE="">
			<INPUT TYPE="hidden" NAME="__orderBy" VALUE="<%=request.getParameter("__orderBy")%>">
			<INPUT TYPE="hidden" NAME="__helpReturn" VALUE="<%=helpReturn%>">
			<INPUT TYPE="hidden" NAME="__fieldSearch" VALUE="<%=fieldSearch%>"> 
			<INPUT TYPE="hidden" NAME="__helpName" VALUE="<%=request.getParameter("__helpName")%>">
			<INPUT TYPE="hidden" NAME="__pageCall" VALUE="<%=request.getParameter("__pageCall")%>">
			<INPUT TYPE="hidden" NAME="__fixCon" VALUE="<%=request.getParameter("__fixCon")%>">
			<INPUT TYPE="hidden" NAME="__langOn" VALUE="<%=chkNull.chkNullString(request.getParameter("__langOn"))%>">
			
			<BR>
			<TABLE WIDTH="500" BORDER="0" ALIGN="center" CELLPADDING="0" CELLSPACING="0">
  				<TR>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-T-L.gif" WIDTH="5" HEIGHT="5"></TD>
    				<TD HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/T.gif" WIDTH="100%" HEIGHT="5"></TD>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-T-R.gif" WIDTH="5" HEIGHT="5"></TD>
  				</TR>
  				<TR>
    				<TD WIDTH="5" BACKGROUND="../IMAGES/MYNOTE/L2.gif"><FONT COLOR="#FFFFFF"></FONT></TD>
    				<TD VALIGN="middle"><FONT FACE="MS Sans Serif" SIZE="1" COLOR="#FFFFFF">
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
        					<TR BGCOLOR="#FFFFFF"> </TR>
      					</TABLE>
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
        					<TR BGCOLOR="#FFFFFF"> </TR>
      					</TABLE>
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
        					<TR BGCOLOR="#FFFFFF">
          						<TD HEIGHT="15" COLSPAN="2" BGCOLOR="#0099CC"><SPAN CLASS="style1">&nbsp;<%=screen.getInquiry().getCurrentDbRecord().getDescription()%> : </SPAN></TD>
        					</TR>
      					</TABLE>
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
      					</TABLE>
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
							<TR BGCOLOR="#EFEFEF">
								<TD WIDTH="9%">
									<SCRIPT LANGUAGE="JavaScript">swapLang('Order By');</SCRIPT>
								</TD>
								<TD WIDTH="35%">
									<%=screen.getTagOrder()%>
								</TD>
								<TD WIDTH="10%">
									<SCRIPT LANGUAGE="JavaScript">swapLang('Search By');</SCRIPT>
								</TD>
								<TD WIDTH="46%">
									<%									
									String opsearch="<SELECT NAME='__searchField'  onKeyUp='sysIsEdit();' >"
																  + "<OPTION  VALUE='sitewelid'> "+screen.getLabel("sitewelid")+" </OPTION>"
																  + "<OPTION  VALUE='tdesc'>"+screen.getLabel("tdesc")+"</OPTION>"
																  + "<OPTION  VALUE='edesc'>"+screen.getLabel("edesc")+"</OPTION>"
																  + "<OPTION  VALUE='provinceid'>"+screen.getLabel("province")+"</OPTION>"
																  + "<OPTION  VALUE='long_tname'>"+screen.getLabel("mprovince","long_tname")+"</OPTION>";
																  
									%>
									<%=opsearch%>
								</TD>
							</TR>
							<TR BGCOLOR="#EFEFEF">
								<TD>
									<SCRIPT LANGUAGE="JavaScript">swapLang('Condition');</SCRIPT>
								</TD>
								<TD>
									<%=screen.getTagConSearch()%>
								</TD>
								<TD>
									<SCRIPT LANGUAGE="JavaScript">swapLang('Key Value');</SCRIPT>
								</TD>
								<TD>
									<%=screen.getTagValueSearch()%>
									<!--INPUT TYPE="text" Name="__valueSearch" SIZE='20' MAXLENGTH='30' VALUE="" onFocus="this.select();" CLASS="txt01"-->
								</TD>
							</TR>
							<TR BGCOLOR="#EFEFEF">
								<TD>&nbsp;</TD>
								<TD>&nbsp;</TD>
								<TD>&nbsp;</TD>
								<TD><DIV ALIGN="center"><A HREF="JavaScript:search();"><IMG SRC="../IMAGES/BUTTON/SEARCH.gif" WIDTH="73" HEIGHT="23" BORDER="0"></A></DIV></TD>
							</TR>
      					</TABLE>
    				</FONT></TD>
    				<TD WIDTH="5" BACKGROUND="../IMAGES/MYNOTE/R2.gif"><FONT COLOR="#FFFFFF"></FONT></TD>
  				</TR>
  				<TR>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-B-L.gif" WIDTH="5" HEIGHT="5"></TD>
    				<TD HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/B.gif" WIDTH="100%" HEIGHT="5"></TD>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-B-R.gif" WIDTH="5" HEIGHT="5"></TD>
  				</TR>
			</TABLE>			
			<BR>
			<TABLE WIDTH="500" BORDER="0" ALIGN="center" CELLPADDING="0" CELLSPACING="0">
  				<TR>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-T-L.gif" WIDTH="5" HEIGHT="5"></TD>
    				<TD HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/T.gif" WIDTH="100%" HEIGHT="5"></TD>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-T-R.gif" WIDTH="5" HEIGHT="5"></TD>
  				</TR>
  				<TR>
    				<TD WIDTH="5" BACKGROUND="../IMAGES/MYNOTE/L2.gif"><FONT COLOR="#FFFFFF"></FONT></TD>
    				<TD VALIGN="middle"><FONT FACE="MS Sans Serif" SIZE="1" COLOR="#FFFFFF">
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
        					<TR BGCOLOR="#FFFFFF"> </TR>
      					</TABLE>
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
        					<TR BGCOLOR="#FFFFFF"> </TR>
      					</TABLE>
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
        					<TR BGCOLOR="#FFFFFF">
          						<TD HEIGHT="15" COLSPAN="2" BGCOLOR="#0099CC"><SPAN CLASS="style1">&nbsp;<%=screen.getInquiry().getCurrentDbRecord().getDescription()%> : </SPAN></TD>
        					</TR>
      					</TABLE>
      					<TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="1" CLASS="txt01">
      					</TABLE>
      					<%=screen.printMynoteTableHTML()%>
    				</FONT></TD>
    				<TD WIDTH="5" BACKGROUND="../IMAGES/MYNOTE/R2.gif"><FONT COLOR="#FFFFFF"></FONT></TD>
  				</TR>
  				<TR>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-B-L.gif" WIDTH="5" HEIGHT="5"></TD>
    				<TD HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/B.gif" WIDTH="100%" HEIGHT="5"></TD>
    				<TD WIDTH="5" HEIGHT="5"><IMG SRC="../IMAGES/MYNOTE/C-B-R.gif" WIDTH="5" HEIGHT="5"></TD>
  				</TR>
			</TABLE>
		</FORM>
	</BODY>
</HTML>