<%@page contentType="text/html; charset=UTF-8" language="java" %>
<%@page import="com.csc.library.entry.EmvHelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.components.*"%>
<%@page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="PRU209_HELP" class="com.csc.library.system.Task" scope="page"/>
<jsp:setProperty name="PRU209_HELP" property="appname" value="setting" />
<%
PRU209_HELP.setChannel(request, response);
HelpEntry screen = (HelpEntry) PRU209_HELP.process("HelpEntry", "PRU209_HELP");
CheckNull chk = new CheckNull();
String invalue = chk.chkNullString(request.getParameter("invalue"));
String job = chk.chkNullString(request.getParameter("__job"));
String job_desc = chk.chkNullString(request.getParameter("MJOBCODE@TDESC"));
String jobcode_level = chk.chkNullString(request.getParameter("__jobcode_level"));
String jobcode_level_desc = chk.chkNullString(request.getParameter("MJOBCODE_LEVEL@TDESC"));
String salarycon = chk.chkNullString(request.getParameter("__salarycon"));
String salary = chk.chkNullString(request.getParameter("__salary"));
String eff_job = chk.chkNullString(request.getParameter("__eff_job"));
String startdate = chk.chkNullString(request.getParameter("__startdate"));
int employeehave = 0;
String filter = "";
if(!invalue.equals("")){
filter = chkFilter(filter) + "employeeid not in ('"+invalue+"')";
employeehave = invalue.split("','").length;
}
if(!job.equals("")){
filter = chkFilter(filter) + "job = '"+job+"'";
} else {
job_desc = "";
}
if(!jobcode_level.equals("")){
filter = chkFilter(filter) + "job in (select jobcodeid from mjobcode where jobcode_level = '"+jobcode_level+"')";
} else {
jobcode_level_desc = "";
}
if(!salary.equals("")){
String decoder = "";
if(screen.getUProfile().getDbType().equalsIgnoreCase("PGSQL")){
decoder = "Base64Decoder";
} else {
decoder = "dbo.Base64Decoder";
}
filter = chkFilter(filter) + decoder + "(salary) "+salarycon+" '"+salary+"'";
}
if(!eff_job.equals("")){
filter = chkFilter(filter) + "eff_job = '"+new CscCalendar(eff_job).getYYYYMMDD()+"'";
}
if(!startdate.equals("")){
filter = chkFilter(filter) + "startdate = '"+new CscCalendar(startdate).getYYYYMMDD()+"'";
}
screen.setMaxLine(20);
screen.inq.setFilter(filter);
screen.inq.setOrderBy("employeeid asc");
screen.process();
screen.referLangOn();
%>
<%!
public String chkFilter(String str){
if(!str.equals("")){
str += " and ";
}
return str;
}
%>
<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 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 src='../JS/VIEWCALENDAR.js'></script>
<script src="../JS/jquery-1.11.2.js" type="text/javascript"></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="JavaScript" type="text/JavaScript">
//---------------------------------- Set myArray----------------------
function addlist(){
var datalist = "";
$(".selectchkbox:checked").each(function(){
datalist = chkdata(datalist) + $(this).val();
});
return datalist;
}
function chkdata(str){
if(str !== ""){
str += ",";
}
return str;
}
function addParen(){
var table = '<%=request.getParameter("table")%>';
var datalist = addlist();
if(datalist === ""){
var msg = getLang() === "tha"?"กรุณาเลือกพนักงาน":"Please Select Employee";
alert(msg);
}else{
window.opener.addPeerInformat(datalist,table);
window.close();
}
}
//-----------------------------------------------------------------
function Close(){ //button close
window.close();
}
function SelectAll(){ //button selectall
with(document.forms[0]){
for(i=0;i<_selectit.length;i++){
if(i === 5){
break;
} else {
_selectit[i].checked = true;
}
}
}
}
function DeselectAll(){ //button deselect
with(document.forms[0]){
for(i=0;i<_selectit.length;i++){
_selectit[i].checked = false;
}
}
}
function Search(){
with(document.cscform){
submit();
}
}
function ClearSearch(){
document.getElementById("job").value = "";
document.getElementById("job_desc").value = "";
document.getElementById("jobcode_level").value = "";
document.getElementById("jobcode_level_desc").value = "";
document.getElementById("salary").value = "";
document.getElementById("eff_job").value = "";
document.getElementById("startdate").value = "";
}
function goHelp(helpName,inputName){
with(document.cscform){
var helpReturn;
if(inputName==="__job" ){
helpReturn="__job:jobcodeid,MJOBCODE@TDESC";
}else if(inputName==="__jobcode_level" ){
helpReturn="__jobcode_level:levelid,MJOBCODE_LEVEL@TDESC";
}
linkHelp_Return(helpName,helpReturn);
}
}
function chkmaxbox(obj){
with(document.cscform){
var have = __employeehave.value;
var max = __employeemax.value;
var i = 0;
$(".selectchkbox:checked").each(function(){ i++; });
var now = i+parseInt(have);
if(now > max){
var msg = getLang() === "tha"?"ไม่สามารถเลือกเกิน "+max+" คน":"Can't select more than "+max+" person(s)";
alert(msg);
obj.checked = false;
}
}
}
//-->
</script>
</head>
<%
String helpReturn="";
if(request.getParameter("__helpReturn")!=null){
helpReturn=request.getParameter("__helpReturn");
}
String fieldSearch="";
if(request.getParameter("__fieldSearch")!=null){
fieldSearch=request.getParameter("__fieldSearch");
}
%>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('./images/button/swap/search_swap20.gif')">
<form name="cscform" method="post" action="#">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__screen" value="<%=request.getParameter("__helpName")%>">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__calendar" value="">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<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("__screen")%>">
<input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>">
<input type="hidden" name="__field" value="<%=request.getParameter("__fixCon")%>">
<input type="hidden" name="__employeehave" value="<%=employeehave%>">
<input type="hidden" name="__employeenow" value="0">
<input type="hidden" name="__employeemax" value="5">
<script language="javascript">getInputFormatDate();</script>
<br>
<div align="center">
<table cellpadding="0" cellspacing="0" style="width:1160px">
<tr>
<td class="header">PRU209_HELP, <span swlang code="SW012551">Staff Movement & Payroll Advice Form</span> </td>
</tr>
<tr>
<td colspan="2">
<table cellpadding="0" cellspacing="0" class="maxsize">
<tr>
<td colspan="2">
<table border="0" cellpadding="0" cellspacing="1" align="center" class="maxsize">
<tr>
<td class="columnlabel" style="width:35%"><%=screen.getLabel("job") %> </td>
<td>
<input name="__job" id="job" size="15" value="<%=job%>">
<a href="javascript:goHelp('MJOBCODEHELP','__job');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__job_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__job_image" width="20" height="20" border="0" align="absmiddle"></a>
<input name="MJOBCODE@TDESC" id="job_desc" type="text" readonly value="<%=job_desc%>" size="40">
</td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("mjobcode","jobcode_level") %> </td>
<td>
<input name="__jobcode_level" id="jobcode_level" size="15" value="<%=jobcode_level%>">
<a href="javascript:goHelp('MJOBCODE_LEVELHELP','__jobcode_level');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__jobcode_level_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__jobcode_level_image" width="20" height="20" border="0" align="absmiddle"></a>
<input name="MJOBCODE_LEVEL@TDESC" id="jobcode_level_desc" type="text" readonly value="<%=jobcode_level_desc%>" size="40">
</td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("salary") %> </td>
<td>
<%
ListBox listboxcon = new ListBox();
listboxcon.setUProfile(screen.getUProfile());
listboxcon.setName("salarycon");
listboxcon.setValidCode("SMM_HELP_OPARATER");
listboxcon.setChecked(salarycon);
listboxcon.setDisable("false");
out.println(listboxcon.process());
%>
<input class="numeric" name="__salary" id="salary" size="15" value="<%=salary%>">
</td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getUProfile().get("lang").equalsIgnoreCase("tha")?"วันที่รับตำแหน่ง":"Date To" %> </td>
<td>
<input name="__eff_job" id="eff_job" size="15" maxlength="10" value="<%=eff_job%>" onkeypress="chkInteger(event);" onkeyup="sysIsEdit();formatDate(this);" onblur="trimValue(this);chkInputDate(this);" onfocus="this.select();">
<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('__eff_job_Image14','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('__eff_job')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="__eff_job_Image14" width="20" height="20" border="0" align="absmiddle" id="__eff_job_Image14"></a>
</td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getUProfile().get("lang").equalsIgnoreCase("tha")?"วันที่เริ่มงาน":"Date Join" %> </td>
<td>
<input name="__startdate" id="startdate" size="15" maxlength="10" value="<%=startdate%>" onkeypress="chkInteger(event);" onkeyup="sysIsEdit();formatDate(this);" onblur="trimValue(this);chkInputDate(this);" onfocus="this.select();">
<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('__startdate_Image14','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('__startdate')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="__startdate_Image14" width="20" height="20" border="0" align="absmiddle" id="__startdate_Image14"></a>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<a href="javascript:Search();"><img src="../IMAGES/BUTTON/SEARCH.gif" border="0"></a>
<a href="javascript:ClearSearch();"><img src="../IMAGES/BUTTON/CLEAR.gif" border="0"></a>
</td>
</tr>
</table>
</td>
<tr>
<tr>
<td colspan="2" class="blankspace"></td>
</tr>
<tr>
<td width="200">
<span id="recordfound"><script language="JavaScript" type="text/javascript">swapLang("Found Data");</script> : <%=screen.getInquiry().recCount()%> <script language="JavaScript" type="text/javascript">swapLang("record(s)");</script></span>
</td>
<td align="right">
<span id="pagetag" align="right"><script language="JavaScript" type="text/javascript">swapLang("Page");</script> : <%=screen.getPageTag()%></span>
</td>
</tr>
<tr >
<td colspan="2" bgcolor="#FFFFFF" class="columnlabel">
<table border="0" cellpadding="3" cellspacing="1" bgcolor="#666666" class="maxsize">
<tr>
<td class="title1" width="84" align="center"><script language="javascript">swapLang('Select');</script></td>
<td class="title1" width="84" align="center"><%=screen.getLabel("employeeid") %></td>
<td class="title1" width="485" align="center"><%=screen.getLabel("emp_prefix") %></td>
<td class="title1" width="485" align="center"><%=screen.getLabel("fname") %></td>
<td class="title1" width="485" align="center"><%=screen.getLabel("lname") %></td>
<td class="title1" width="485" align="center"><%=screen.getLabel("job") %></td>
<td class="title1" width="485" align="center"><%=screen.getLabel("mjobcode","jobcode_level") %></td>
<td class="title1" width="485" align="center"><%=screen.getLabel("salary") %></td>
<td class="title1" width="485" align="center"><%=screen.getLabel("empworkages_short") %></td>
<td class="title1" width="485" align="center"><%=screen.getUProfile().get("lang").equalsIgnoreCase("tha")?"วันที่รับตำแหน่ง":"Date To" %></td>
<td class="title1" width="485" align="center"><%=screen.getUProfile().get("lang").equalsIgnoreCase("tha")?"วันที่เริ่มงาน":"Date Join" %></td>
</tr>
<% while(screen.nextRec()){ %>
<tr>
<td align="center"><input name="_selectit" type="checkbox" class="selectchkbox" onchange="chkmaxbox(this)" value="<%=screen.getString("employeeid")%>" ></td>
<td align="right"> <%=screen.getString("employeeid")%> </td>
<td> <%=screen.getString("mprefix","tdesc")%> </td>
<td> <%=screen.getString("fname")%> </td>
<td> <%=screen.getString("lname")%> </td>
<td> <%=screen.getString("jobname")%> </td>
<td align="center"><%=screen.getString("mjobcode","jobcode_level")%></td>
<td align="right"> <%=screen.getString("salary")%> </td>
<td align="center"><%=screen.getString("empworkages_short")%></td>
<td align="center"><%=new CscCalendar(screen.getString("eff_job")).getDDMMYYYY()%></td>
<td align="center"><%=new CscCalendar(screen.getString("startdate")).getDDMMYYYY()%></td>
</tr>
<% } %>
</table>
</td>
</tr>
<tr>
<td colspan="2" class="blankspace"> </td>
</tr>
<tr>
<td colspan="2" class="blankspace">
<div align="center">
<a href="javascript:SelectAll();"><img src="../IMAGES/BUTTON/SELECTALL.gif" border="0" width="73" height="23"></a>
<a href="javascript:DeselectAll();"><img src="../IMAGES/BUTTON/DESELECTALL.gif" border="0" width="73" height="23"></a>
<a href="javascript:addParen();"><img src="../IMAGES/BUTTON/ADD.gif" width="73" height="23" border="0"></a>
<a href="javascript:Close();"><img src="../IMAGES/BUTTON/CANCEL.gif" width="73" height="23" border="0"></a>
</div>
</td>
</tr>
<tr>
<td colspan="2" class="blankspace"> </td>
</tr>
</table>
</td>
</tr>
<tr bordercolor="0069B3">
<td class="bottom"></td>
</tr>
</table>
</div>
</form>
</body>
</html>