<%@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="WEL339" class="com.csc.library.system.Task" scope="page" />
<%
WEL339.setChannel(request, response);
HelpEntry screen = (HelpEntry) WEL339.process("HelpEntry","WEL339");
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"));
String filter="zipcode in(select z.zipcode from csczipcode z,mprovince p where z.province=p.provinceid )";
if(valuesearch.length()>0){
if(searchby.equals("long_tname")){
//DbInquiry db= (DbInquiry)screen.getInquiry().getChild("CSCZIPCODE").getChild("MPROVINCE");
if(consearch.trim().equalsIgnoreCase("like")){
filter="zipcode in(select z.zipcode from csczipcode z,mprovince p where z.province=p.provinceid and p.long_tname like '%"+valuesearch+"%')";
//db.setFilter("long_tname","%"+valuesearch+"%","",consearch);
}else{
filter="zipcode in(select z.zipcode from csczipcode z,mprovince p where z.province=p.provinceid and p.long_tname "+consearch+" '"+valuesearch+"')";
//db.setFilter("long_tname",valuesearch,"",consearch);
}
//screen.getInquiry().getChild("CSCZIPCODE").setRequireFoundTable("MPROVINCE");
}else{
if(consearch.trim().equalsIgnoreCase("like")){
filter+=" and "+searchby+" "+consearch+" '%"+valuesearch+"%'";
//screen.getInquiry().setFilter(searchby,"%"+valuesearch+"%","",consearch);
}else{
filter+=" and "+searchby+" "+consearch+" '"+valuesearch+"'";
//screen.getInquiry().setFilter(searchby,valuesearch,"",consearch);
}
}
}
screen.getInquiry().setFilter(filter);
//screen.getInquiry().setRequireFoundTable("CSCZIPCODE");
if((request.getParameter("__cmd")!=null &&request.getParameter("__cmd").equals("search"))||(request.getParameter("__goPage")!=null &&request.getParameter("__goPage").length()>0))
screen.process();
if( !chkNull.chkNullString(request.getParameter("__langOn")).equals("") && request.getParameter("__langOn").equalsIgnoreCase("true") ){
screen.referLangOn();
}else{
screen.referLangOff();
}
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<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 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=="__bu11" )
helpReturn="__bu11:bu1id";
else if(inputName=="__bu12" )
helpReturn="__bu12:bu1id";
else if(inputName=="__bu21" )
helpReturn="__bu21:bu2id";
else if(inputName=="__bu22" )
helpReturn="__bu22:bu2id";
else if(inputName=="__bu31" )
helpReturn="__bu31:bu3id";
else if(inputName=="__bu32" )
helpReturn="__bu32:bu3id";
else if(inputName=="__position1" )
helpReturn="__position1:positionid";
else if(inputName=="__position2" )
helpReturn="__position2:positionid";
linkHelp_Return(helpName,helpReturn);
document.cscform.__fixCon.value=fixcon;
}
function GoClean()
{
with(document.cscform)
{
__years1.value="";
__years2.value="";
}
}
function GoPage(years1,employeeid,group){
with(document.cscform){
__fixCon.value="years='"+years1+"'and employeeid='"+employeeid+"' and healthygid='"+group+"' ";
__cmd.value="search";
action="WEL331.jsp";
submit();
}
}
function emptyPop(pic){
var gen=window.open('','map','left=150,top=150,width=600,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes');
gen.document.write('<html><head><title>show map</title>');
gen.document.write('</head><body>');
gen.document.write('<img src='+pic+'>');
gen.document.write('</body></head><html>');
gen.document.close();
}
function showpic(pic) {
emptyPop(pic);
}
//-->
</script>
</head>
<body >
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" action="WEL339.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="WEL339">
<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('Welfare location');
</script>
<br> <div align="center">
<table cellpadding="0" cellspacing="0" class="largest">
<tr >
<td colspan="2" class="header" >WEL339, <script language="javascript">swapLang(titlename);</script> </td>
</tr>
<tr >
<td ><table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td colspan="12" class="blankspace"><table class="maxsize" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="4" class="blankspace" ></td>
</tr>
<tr>
<td width="15%"><div align="right">
<script language="javascript">swapLang('Order By');</script>
</div></td>
<td><%=screen.getTagOrder()%></td>
<td width="20%"><div align="right">
<script language="javascript">swapLang('Search By');</script>
</div></td>
<td> <%
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>
<td><div align="right">
<script language="javascript">swapLang('Condition');</script>
</div></td>
<td><%=screen.getTagConSearch()%></td>
<td><div align="right">
<script language="javascript">swapLang('Key Value');</script>
</div></td>
<td><%=screen.getTagValueSearch()%> <a href="javascript:search();"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" width="20" border="0" align="middle"></a></td>
</tr>
<tr>
<td colspan="4" class="blankspace" ></td>
</tr>
<tr>
<td colspan="2">
<script language="javascript">swapLang('Found Data');</script>
<%=screen.getRecCount()%></td>
<td colspan="2"><div align="right"><%=screen.getPageTag()%></div></td>
</tr>
</table>
<br>
<table width="638" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#808080" class="inframe">
<tr class="title1">
<td width="193" class="row3"><div align="center"><%=screen.getLabel("SITEWELID")%></div></td>
<td width="193" class="row3"><div align="center"><%=screen.getLabel("TDESC")%></div></td>
<td width="193" class="row3"><div align="center"><%=screen.getLabel("SITEWELTYPE")%></div></td>
<td width="334" class="row3"><div align="center"><script language="javascript">swapLang("Address");</script></div></td>
<td width="334" class="row3"><div align="center"><%=screen.getLabel("TEL")%></div></td>
<td width="54" class="row3"><div align="center"><%=screen.getLabel("SITEMAP")%></div></td>
</tr>
<%
while(screen.nextRec()){
if(screen.checkLinePage()){
%>
<tr>
<td><%=screen.getString("SITEWELID")%></td>
<td><%=screen.getString("TDESC")%></td>
<td ><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("SITEWELTYPE")%></td>
<td ><%=screen.getString("FULLADDRESS")%></td>
<td ><%=screen.getString("TEL")%></td>
<td ><%if(screen.getString("sitemap").length()>0){%><a href="javascript:showpic('./UPLOAD/MAP/<%=screen.getString("sitemap")%>');"><img src="../IMAGES/BUTTON/MAIN/UPOAD20.gif" border="0"></a><%}%></td>
</tr>
<%
}
if(screen.outLinePage()){ break; }
}
%>
<tr>
<td colspan="12" class="blankspace"></td>
</tr>
<tr>
<td colspan="12" class="bottom"></td>
</tr>
</table></td>
</tr>
</table>
<br>
</form>
</body>
</html>