<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.session.*,com.csc.library.utilities.*,com.csc.library.components.*;"%>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="PSU132" class="com.csc.library.system.Task" scope="page" /><%
PSU132.setChannel(request, response);
HelpEntry screen = (HelpEntry) PSU132.process("HelpEntry", "PSU132HELP");
if(screen==null){
return;
}
screen.setMaxLine(20);
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 employeeid1 = chk.chkNullString( request.getParameter("__employeeid1"));
String employeeid2 = chk.chkNullString( request.getParameter("__employeeid2"));
if( !bu1.equals("") ){
screen.getInquiry().setFilter( "bu1", bu1, "", "=" );
}
if( !bu2.equals("") ){
screen.getInquiry().setFilter( "bu2", bu2, "", "=" );
}
if( !bu3.equals("") ){
screen.getInquiry().setFilter( "bu3", bu3, "", "=" );
}
if( !bu4.equals("") ){
screen.getInquiry().setFilter( "bu4", bu4, "", "=" );
}
if( !bu5.equals("") ){
screen.getInquiry().setFilter( "bu5", bu5, "", "=" );
}
if( !position.equals("") ){
screen.getInquiry().setFilter( "emp_position", position, "", "=" );
}
if( !employeeid1.equals("") && !employeeid2.equals("") ) {
screen.getInquiry().setFilter( "employeeid", employeeid1, employeeid2, "between" );
} else if( !employeeid1.equals("") && employeeid2.equals("") ) {
screen.getInquiry().setFilter( "employeeid", employeeid1 , "", "=" );
} else if( employeeid1.equals("") && !employeeid2.equals("") ) {
screen.getInquiry().setFilter( "employeeid", employeeid2 , "", "=" );
}
String fixCompany = " and companyid='" +screen.getUProfile().get("companyid")+"' ";
StringBuilder filter = new StringBuilder();
filter.append("employeeid not in(select distinct employeeid from hadjposition where adj_type ='10' " +fixCompany +") ");
filter.append( " and status <> 'D' and (startdate = '1900-01-01' or nullif(startdate,'') is null or( nullif(startdate,'') is not null and nullif(startdate,resigndate) is not null ))" );
filter.append( fixCompany );
screen.getInquiry().setFixFilter(filter.toString() );
screen.process();
%>
<html ng-app="myHR">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<link href="../CSS/bootstrap.css" rel="stylesheet" type="text/css">
<link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
<script type='text/javascript' src="../JS/bootstrap.js"></script>
<script language="javascript" src="../JS/SCREEN.js"></script>
<script src="../JS/angular-1.3.15/angular.js" type="text/javascript"></script>
<script src="../JS/ANGULAR/SCREEN_ANGULAR.js" type="text/javascript"></script>
<script language="javascript" src="../JS/UTILITIES.js"></script>
<script language="javascript">setLang("<%=screen.getUProfile().get("lang")%>");</script>
<script language="Javascript" type="text/JavaScript">
var record_status = {
"eng": { "0": "Incomplete Data", "1":"Wait For Processing"} ,
"tha": { "0": "ข้อมูลไม่สมบูรณ์", "1":"รอประมวลผล"}
};
function GoSave(){}
function GoUpdate(){}
function GoDelete(){}
function GoSearch(){ search();}
function goHelp(helpName,inputName) {
var helpReturn;
var fixCon = "";
if(inputName=="__employeeid1" ) {
helpReturn="__employeeid1:employeeid";
} else if(inputName=="__employeeid2" ) {
helpReturn="__employeeid2:employeeid";
} else if(inputName=="__job" ) {
helpReturn="__job:jobcodeid,mjobcode@edesc";
} else 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=="__bu4" ) {
helpReturn="__bu4:bu4id,MBU4@TDESC";
} else if(inputName=="__bu5" ) {
helpReturn="__bu5:bu5id,MBU5@TDESC";
} else if(inputName=="__emp_position" ) {
helpReturn="__emp_position:positionid,MPOSITION@TDESC";
}
linkHelp_Return(helpName, helpReturn, fixCon);
}
function clearInput(obj) {
if(obj && obj.type && obj.type=="text") {
objj.value = "";
}
}
function editEmp(employeeid) {
// alert(":"+employeeid+":");
var url = "PSU133.jsp?__help=__employeeid$" +employeeid;
var win = PopupCenterTop( url, "child", 700, 600);
if(win) win.focus();
}
</script>
</head>
<body leftmargin="0" topmargin="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post">
<input type="hidden" name="__calendar">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="PSU132">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__helpReturn" value="">
<input type="hidden" name="__gorec" value="">
<input type="hidden" name="__ack" value="">
<input type="hidden" name="__orderBy" value="">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__pageCall" value="PSU132">
<input type="hidden" name="__emp_level" value="<%=screen.getDataLabel("emp_level")%>">
<script language="javascript">getInputFormatDate();</script>
<br>
<table width="640" border="0" align="center" cellpadding="0" cellspacing="0" class="largest" >
<tr >
<td height="20" class="header">PSU132,
<!-- <script language="javascript">document.write("รายชื่อพนักงานที่ไม่มีประวัติการปรับตำแหน่ง")</script> -->
<span swlang code="SW011953">รายชื่อพนักงานที่ไม่มีประวัติการปรับตำแหน่ง</span></td>
</tr>
<tr>
<td><table border="0" align="center" cellpadding="0" cellspacing="0" class="maxsize">
<tr>
<td class="blankspace"></td>
</tr>
<tr>
<td>
<table border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="150" class="columnlabel"><%=screen.getLabel("employeeid")%> </td>
<td>
<input type="text" name="__employeeid1" size="10" maxlength="15" value="<%=employeeid1 %>" /> <a href="javascript:goHelp('MEMPLOYEEHELP','__employeeid1')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image1" width="20" height="20" border="0" align="absmiddle" id="Image1" /></a> -
<input type="text" name="__employeeid2" size="10" maxlength="15" value="<%=employeeid2 %>" /> <a href="javascript:goHelp('MEMPLOYEEHELP','__employeeid2')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image2" width="20" height="20" border="0" align="absmiddle" id="Image2" /></a> </td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("bu1")%> </td>
<td><%=screen.getInput("bu1")%>
<input name="MBU1@TDESC" type="text" class="text" id="MBU1@TDESC" size="40" readonly="readonly" value="<%=chk.chkNullString(request.getParameter("MBU1@TDESC")) %>" /> </td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("bu2")%> </td>
<td><%=screen.getInput("bu2")%>
<input name="MBU2@TDESC" type="text" class="text" id="MBU2@TDESC" size="40" readonly="readonly" value="<%=chk.chkNullString(request.getParameter("MBU2@TDESC")) %>" /> </td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("bu3")%> </td>
<td><%=screen.getInput("bu3")%>
<input name="MBU3@TDESC" type="text" class="text" id="MBU3@TDESC" size="40" readonly="readonly" value="<%=chk.chkNullString(request.getParameter("MBU3@TDESC")) %>" /> </td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("bu4")%> </td>
<td><%=screen.getInput("bu4")%>
<input name="MBU4@TDESC" type="text" class="text" id="MBU4@TDESC" size="40" readonly="readonly" value="<%=chk.chkNullString(request.getParameter("MBU4@TDESC")) %>" /> </td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("bu5")%> </td>
<td><%=screen.getInput("bu5")%>
<input name="MBU5@TDESC" type="text" class="text" id="MBU5@TDESC" size="40" readonly="readonly" value="<%=chk.chkNullString(request.getParameter("MBU5@TDESC")) %>" /> </td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("emp_position")%> </td>
<td><%=screen.getInput("emp_position")%>
<input name="MPOSITION@TDESC" type="text" class="text" id="MPOSITION@TDESC" size="40" readonly="readonly" value="<%=chk.chkNullString(request.getParameter("MPOSITION@TDESC")) %>" /> </td>
</tr>
<tr>
<td class="buttonline" colspan="7"><div align="center">
<button type="button" class="btn btn-primary width100" swlang code="SW013168" onClick="GoSearch();">Search</button>
</div>
</td>
</tr>
</table>
</td>
<tr>
<td align="center">
<table border="0" cellpadding="0" cellspacing="0" class="largest">
<tr>
<td width="50%"><div>
<!-- <script language="JavaScript" type="text/javascript">swapLang("Found Data");</script> -->
<span swlang code="SW001771">Found Data</span> : <%=screen.getInquiry().recCount() %> </div></td>
<td width="50%" align="right"><div class="right"><%=screen.getPageTag()%> </div></td>
</tr>
</table>
<table border="0" align="center" cellpadding="0" cellspacing="1" class="largest tablewithborder">
<tr>
<td width="53" class="row3"><div align="center"><!-- <script type="text/javascript" language="JavaScript">swapLang("Seq")</script> -->
<span swlang code="SW000193">Seq</span></div></td>
<td width="92" class="row3"><div align="center"><%=screen.getLabel("employeeid")%></div></td>
<td width="180" class="row3"><div align="center"><%=screen.getLabel("fullname")%></div></td>
<td width="180" class="row3"><div align="center"><%=screen.getLabel("emp_position")%></div></td>
<td class="row3"><div align="center"><%=screen.getLabel("bu2")%></div></td>
<td width="120" nowrap class="row3"><div align="center"><!-- <script type="text/javascript" language="JavaScript">swapLang("Status")</script> -->
<span swlang code="SW000019">Status</span></div></td>
</tr>
<%
if(screen.getInquiry().recCount()>0) {
String record_status;
while(screen.nextRec()){
screen.referLangOn();
record_status = "1";
if( screen.getString("bu1").equalsIgnoreCase("") || screen.getString("bu1").equalsIgnoreCase("NONE") ||
screen.getString("emp_position").equalsIgnoreCase("") || screen.getString("emp_position").equalsIgnoreCase("NONE") ||
screen.getString("startdate").equalsIgnoreCase("") || screen.getString("startdate").equalsIgnoreCase("01-01-1900") ) {
record_status = "0";
}
%>
<tr>
<td class="column-text center" ><%=screen.getInquiry().recNo()%></td>
<td class="column-text" ><a href="javascript:editEmp('<%=screen.getString("employeeid")%>');"><%=screen.getString("employeeid")%></a></td>
<td class="column-text" ><%=chk.chkNullString(screen.getString("fullname"), "-") %></td>
<td class="column-text" ><%=chk.chkNullString(screen.getString("mposition","tdesc"), "-") %></td>
<td class="column-text center" ><%=chk.chkNullString(screen.getString("mbu2","tdesc"), "-") %></td>
<td class="column-text center" ><script language="JavaScript" type="text/javascript">document.write( record_status["<%=screen.getUProfile().get("lang")%>"]["<%=record_status %>"])</script></td>
</tr>
<%
screen.referLangOff();
}
}
%>
</table>
</td>
</tr>
</table></td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr>
<td class="bottom"></td>
</tr>
</table>
</form>
</body>
</html>