<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.utilities.*"%>
<jsp:useBean id="STP002" class="com.csc.library.system.Task" scope="page" />
<jsp:useBean id="HELP" class="com.csc.library.system.Task" scope="page" />
<%
HELP.setChannel( request, response );
HelpEntry helpScreen = (HelpEntry)HELP.process("HelpEntry", "STP002HELP");
if(helpScreen==null){
return;
}
CheckNull chk = new CheckNull();
String bu1 = chk.chkNullString( request.getParameter("__bu1"));
String bu2 = chk.chkNullString( request.getParameter("__bu2"));
String bu3 = chk.chkNullString( request.getParameter("__bu3"));
String bu4 = chk.chkNullString( request.getParameter("__bu4"));
String bu5 = chk.chkNullString( request.getParameter("__bu5"));
String position = chk.chkNullString( request.getParameter("__emp_position"));
String employeeid = chk.chkNullString( request.getParameter("__employeeid"));
String fname = chk.chkNullString( request.getParameter("__fname"));
String lname = chk.chkNullString( request.getParameter("__lname"));
String emplists = chk.chkNullString(request.getParameter("__condition$emplists"));
if( request.getParameter("__condition$emplists")==null ) {
emplists = ",";
} else if( "search".equalsIgnoreCase(request.getParameter("__cmd")) || "save".equalsIgnoreCase(request.getParameter("__cmd"))) {
emplists = ",";
}
if( !bu1.equals("") ){
helpScreen.getInquiry().setFilter( "bu1", bu1, "", "=" );
}
if( !bu2.equals("") ){
helpScreen.getInquiry().setFilter( "bu2", bu2, "", "=" );
}
if( !bu3.equals("") ){
helpScreen.getInquiry().setFilter( "bu3", bu3, "", "=" );
}
if( !bu4.equals("") ){
helpScreen.getInquiry().setFilter( "bu4", bu4, "", "=" );
}
if( !bu5.equals("") ){
helpScreen.getInquiry().setFilter( "bu5", bu5, "", "=" );
}
if( !position.equals("") ){
helpScreen.getInquiry().setFilter( "emp_position", position, "", "=" );
}
if( !employeeid.equals("") ){
helpScreen.getInquiry().setFilter( "employeeid", "%"+employeeid +"%", "", "like" );
}
if( !fname.equals("") ){
helpScreen.getInquiry().setFilter( "fname", "%"+fname +"%", "", "like" );
}
if( !lname.equals("") ){
helpScreen.getInquiry().setFilter( "lname", "%"+lname +"%", "", "like" );
}
String date = request.getParameter("__condition$edit_date") ;
CscCalendar edit_date = new CscCalendar().decDate();
if( date != null && !date.equalsIgnoreCase("")) {
edit_date = new CscCalendar(date);
}
String dateStr = edit_date.getYYYYMMDD();
StringBuffer filterBuffer = new StringBuffer();
filterBuffer.append("SELECT empcod AS employeeid FROM vw_mhmemp00 WHERE edit_date >= '").append(dateStr).append("' ");
filterBuffer.append("UNION SELECT psncod AS employeeid FROM vw_mhmpsn00 WHERE edit_date >= '").append(dateStr).append("' ");
filterBuffer.append("UNION SELECT famcod AS employeeid FROM vw_mhmfam00 WHERE edit_date >= '").append(dateStr).append("' ");
filterBuffer.append("UNION SELECT repcod AS Employeeid FROM vw_mhmrep00 WHERE edit_date >= '").append(dateStr).append("' ");
helpScreen.getInquiry().setFilter("employeeid", filterBuffer.toString(), "", "in");
helpScreen.setMaxLine(15);
helpScreen.getInquiry().clearOldCondition();
helpScreen.process();
if( "save".equalsIgnoreCase(request.getParameter("__cmd")) ) {
STP002.setChannel(request, response);
ProcessEntry screen=(ProcessEntry)STP002.process("ProcessEntry","Process");
screen.process();
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link type="text/css" rel="stylesheet" href="../CSS/TISCO.css" >
<script language="JavaScript" src="../JS/SCREEN.js"></script>
<script language="javascript">setLang("<%=helpScreen.getUProfile().get("lang")%>");</script>
<script language="javascript">getTitleName();</script>
<script language="javascript">
function goHelp(helpName,inputName) {
var helpReturn;
var fixCon = "";
if(inputName=="__bu1" ) {
helpReturn="__bu1:bu1id,MBU1@TDESC";
} else if(inputName=="__bu2" ) {
helpReturn="__bu2:bu2id,MBU2@TDESC";
} else if(inputName=="__bu3" ) {
helpReturn="__bu3:bu3id,MBU3@TDESC";
} else if(inputName=="__emp_position" ) {
helpReturn="__emp_position:positionid,MPOSITION@TDESC";
}
linkHelp_Return(helpName,helpReturn, fixCon);
}
function GoSearch(){
search();
}
function goProcess() {
with(document.cscform){
bCon=confirm("Export data to AS/400");
if (bCon==true) {
__cmd .value = "save";
submit();
}
}
}
function goPreview() {
with(document.cscform){
__cmd.value="search";
submit();
}
}
function removeEmployee(str) {
with(document.cscform) {
var emplists = __condition$emplists.value || ",";
var exp = new RegExp(","+str+",","g");
__condition$emplists.value = emplists.replace(exp, ",");
}
}
function addEmployee(str) {
with(document.cscform) {
var emplists = __condition$emplists.value || ",";
if( !isExists(emplists, str) ) {
__condition$emplists.value = emplists +str +"," ;
}
}
}
function checkBoxClick(obj) {
if(obj && obj.type==="checkbox") {
if(obj.checked) {
alert("add :"+obj.value )
addEmployee(obj.value);
} else {
alert("remove :"+obj.value )
removeEmployee(obj.value);
}
}
}
function isExists(emplists, str) {
return emplists.indexOf(","+str+",") !=-1;
}
function checkAll() {
var elements = document.getElementsByName("checkbox");
for(var i=0; i<elements.length; i++) {
var obj = elements[i];
if(obj && obj.type==="checkbox") {
addEmployee(obj.value);
obj.checked = true;
}
}
}
function decheckAll() {
var elements = document.getElementsByName("checkbox");
for(var i=0; i<elements.length; i++) {
var obj = elements[i];
if(obj && obj.type==="checkbox") {
removeEmployee(obj.value);
obj.checked = false;
}
}
}
</script>
</head>
<body leftmargin="0" topmargin="0">
<div align="center">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<form name="cscform" method="post" action="?">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="STP002">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__companyid" value="<%=helpScreen.getUProfile().get("companyid")%>">
<input type="hidden" name="__notNull" value="">
<input type="hidden"name="__fixCon" value="">
<input type="hidden" name="__referPage" value="">
<input type="hidden" name="__process" value="">
<input type="hidden" name="__tname" value="ส่งข้อมูลออกไปยัง AS/400">
<input type="hidden" name="__ename" value="Export data to AS/400">
<input type="hidden" name="__ptype" value="">
<input type="hidden" name="__prclass" value="ExportAs400Process">
<input type="hidden" name="__goPage" value="" />
<input type="hidden" name="__language" value="<%=helpScreen.getUProfile().get("lang")%>" />
<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>" />
<input type="hidden" name="__condition$emplists" value="<%=emplists %>" />
<br>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td class="header">STP002, <script language="JavaScript">swapLang("Export data to AS/400");</script> </td>
</tr>
<tr>
<td align="center">
<table align="center" cellpadding="0" cellspacing="0" class="inframe">
<tr>
<td colspan="2" class="blankspace"></td>
</tr>
<tr>
<td width="150" class="columnlabel"><script language="JavaScript">swapLang("Edit date");</script> </td>
<td><input name="__condition$edit_date" value="<%=edit_date.getDDMMYYYY()%>" onMouseOut="toolTip()" onKeyUp="formatDate(this);" onKeyPress="chkInteger(event);" onFocus="this.select();" onBlur="formatDate(this);" type="text" size="10" maxlength="10" alt="วันที่มีผล" onMouseOver="toolTip('วันที่มีผล')" />
<a onMouseOver="MM_swapImage('edit_date','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onMouseOut="MM_swapImgRestore()" onClick="viewCal('__condition$edit_date');" href="javascript:;"><img border="0" name="edit_date" alt="Calendar" align="absMiddle" src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" width="20" height="20"></a> </td>
</tr>
<tr>
<td class="columnlabel"><script language="javascript" type="text/javascript">swapLang("Word in Employee Code")</script> </td>
<td><input name="__employeeid" type="text" size="15" value="<%=chk.chkNullString(request.getParameter("__employeeid")) %>" /></td>
</tr>
<tr>
<td class="columnlabel"><script language="javascript" type="text/javascript">swapLang("Word in Name")</script> </td>
<td><input name="__fname" type="text" size="25" value="<%=chk.chkNullString(request.getParameter("__fname")) %>" /></td>
</tr>
<tr>
<td class="columnlabel"><script language="javascript" type="text/javascript">swapLang("Word in Surname")</script> </td>
<td><input name="__lname" type="text" size="25" value="<%=chk.chkNullString(request.getParameter("__lname")) %>" /></td>
</tr>
<tr>
<td class="columnlabel" ><%=helpScreen.getLabel("emp_position")%> </td>
<td ><%=helpScreen.getInput("emp_position")%>
<input name="MPOSITION@TDESC" type="text" class="text" id="MPOSITION@TDESC" size="40" readonly="readonly" value="<% if(!position.equals("")) out.print(chk.chkNullString(request.getParameter("MPOSITION@TDESC"))); %>" /></td>
</tr>
<tr>
<td class="columnlabel" ><%=helpScreen.getLabel("bu1")%> </td>
<td ><%=helpScreen.getInput("bu1")%>
<input name="MBU1@TDESC" type="text" class="text" id="MBU1@TDESC" size="40" readonly="readonly" value="<% if(!bu1.equals("")) out.print(chk.chkNullString(request.getParameter("MBU1@TDESC"))); %>" /></td>
</tr>
<tr>
<td class="columnlabel" ><%=helpScreen.getLabel("bu2")%> </td>
<td ><%=helpScreen.getInput("bu2")%>
<input name="MBU2@TDESC" type="text" class="text" id="MBU2@TDESC" size="40" readonly="readonly" value="<% if(!bu2.equals("")) out.print(chk.chkNullString(request.getParameter("MBU2@TDESC"))); %>" /></td>
</tr>
<tr>
<td class="columnlabel" ><%=helpScreen.getLabel("bu3")%> </td>
<td ><%=helpScreen.getInput("bu3")%>
<input name="MBU3@TDESC" type="text" class="text" id="MBU3@TDESC" size="40" readonly="readonly" value="<% if(!bu3.equals("")) out.print(chk.chkNullString(request.getParameter("MBU3@TDESC"))); %>" /></td>
</tr>
<tr>
<td class="columnlabel" ><%=helpScreen.getLabel("bu4")%> </td>
<td ><%=helpScreen.getInput("bu4")%>
<input name="MBU4@TDESC" type="text" class="text" id="MBU4@TDESC" size="40" readonly="readonly" value="<% if(!bu4.equals("")) out.print(chk.chkNullString(request.getParameter("MBU4@TDESC"))); %>" /></td>
</tr>
<tr>
<td class="columnlabel" ><%=helpScreen.getLabel("bu5")%> </td>
<td ><%=helpScreen.getInput("bu5")%>
<input name="MBU5@TDESC" type="text" class="text" id="MBU5@TDESC" size="40" readonly="readonly" value="<% if(!bu5.equals("")) out.print(chk.chkNullString(request.getParameter("MBU5@TDESC"))); %>" /></td>
</tr>
<tr>
<td colspan="2" class="blankspace" > </td>
</tr>
<tr>
<td> </td>
<td><a href="javaScript:goPreview();"><img src="../IMAGES/BUTTON/VIEW.gif" width="73" height="23" border="0" align="absmiddle"></a></td>
</tr>
<% if( !"save".equalsIgnoreCase(request.getParameter("__cmd")) ) { %>
<tr>
<td colspan="2" class="blankspace" > </td>
</tr>
<tr>
<td colspan="2" >
<table border="0" align="center" cellpadding="0" cellspacing="0"class="large">
<tr>
<td width="50%" nowrap>
<script language="JavaScript" type="text/javascript">swapLang("Found Data");</script> : <%=helpScreen.getInquiry().recCount() %> <script language="JavaScript" type="text/javascript">swapLang("record(s)");</script></td>
<td width="50%" align="right" nowrap><%=helpScreen.getPageTag()%> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" align="center" >
<table border="0" align="center" cellpadding="0" cellspacing="1"class="large">
<tr class="title1">
<td width="14%" class="title1"><div align="center"><script language="javascript">swapLang("Select");</script></div></td>
<td width="16%" class="title1"><div align="center"><script language="javascript">swapLang("Employee Code");</script></div></td>
<td width="70%" class="title1"><div align="center"><script language="javascript">swapLang('Name-Surname');</script></div></td>
</tr>
<%
while(helpScreen.nextRec()) {
helpScreen.getInquiry().referLangOn();
String empCode = helpScreen.getInquiry().getString("employeeid");
%>
<tr >
<td align="center" ><input name="checkbox" type="checkbox" value="<%=empCode %>" <% if(emplists.indexOf("," +empCode+",")!=-1) out.print(" checked");%> onClick="checkBoxClick(this)"></td>
<td align="center"><%=empCode %></td>
<td><%=helpScreen.getInquiry().getString("fullname")%></td>
</tr>
<%
helpScreen.getInquiry().referLangOff();
}
%>
</table></td>
</tr>
<tr>
<td colspan="2" class="blankspace" > </td>
</tr>
<tr>
<td> </td>
<td>
<a href="javascript:;" onClick="checkAll()"><img src="../IMAGES/BUTTON/SELECTALL.gif" width="73" height="23" border="0" align="absmiddle"></a>
<a href="javascript:;" onClick="decheckAll()"><img src="../IMAGES/BUTTON/DESELECTALL.gif" width="73" height="23" border="0" align="absmiddle"></a>
<a href="javaScript:;" onClick="goProcess();"><img src="../IMAGES/BUTTON/PROCESS.gif" width="73" height="23" border="0" align="absmiddle"></a></td>
</tr>
<% } %>
<tr>
<td colspan="2" class="blankspace"></td>
</tr>
</table>
</td>
</tr>
<tr >
<td class="bottom" >
</td>
</tr>
</table>
</form>
</div>
</body>
</html>