<%@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"> <%=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> </TD> <TD> </TD> <TD> </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"> <%=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>