<!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.session.*,com.csc.library.utilities.*"%>
<jsp:useBean id="PSP001" class="com.csc.library.system.Task" scope="page" />
<%
CheckNull chk = new CheckNull();
PSP001.setChannel(request ,response);
ProcessEntry screen=(ProcessEntry)PSP001.process("ProcessEntry","Process");
screen.process();
String choose_employee = chk.chkNullString(request.getParameter("__condition$choose_employeeid"));
%>
<html ng-app="myHR">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link type="text/css" rel="stylesheet" href="../CSS/TISCO.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>
<link href="../CSS/CSC_UI.css" rel="stylesheet" type="text/css">
<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 src="../JS/jquery-2.1.3.min.js" type="text/javascript"></script>
<script language="javascript">setLang("<%=screen.getUProfile().get("lang")%>");</script>
<script language="javascript">getTitleName();</script>
<script language="javascript">
function process() {
with(document.cscform){
if(setSelectEmployee()){
bCon=confirm("Generate New Employee Movement History");
if (bCon===true){
__cmd .value = "save";
submit();
}
} else {
var msg = (getLang()==="tha")? "กรุณาเลือกพนักงาน.": "Please select employee.";
alert(msg);
}
}
}
function setSelectEmployee(){
var chk = false;
var choose_employeeid = "";
$(".selectemployee").each(function(){
if( $(this).prop('checked') ){
choose_employeeid = chkStr(choose_employeeid) +"'"+ $(this).val() +"'";
chk = true;
}
});
$("input[name='__condition$choose_employeeid']").val(choose_employeeid);
return chk;
}
function chkStr(str){
if(str.length > 0){
str += ",";
}
return str;
}
function setcheck(){
if($("#maincheckbox").prop('checked')){
checkAll();
} else {
decheckAll();
}
}
function setmaincheckbox(){
$("#maincheckbox").prop('checked', false);
}
</script>
</head>
<body leftmargin="0" topmargin="0" >
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" action="?">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="PSP001">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__companyid" value="<%=screen.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="__condition$choose_employeeid" value="<%=choose_employee%>">
<input type="hidden" name="__tname" value="ประมวลผลพนักงานเข้าใหม่">
<input type="hidden" name="__ename" value="Generate New Employee Movement History">
<input type="hidden" name="__ptype" value="">
<input type="hidden" name="__prclass" value="GenerateNewEmpMovementHistory">
<%=screen.getTagConfirm()%>
<br>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" id="tableWrapper" style="width:1000px">
<tr>
<td class="header" colspan="2" >PSP001, <!-- <script language="JavaScript">swapLang("Generate New Employee Movement History");</script> -->
<span swlang code="SW005201">Generate New Employee Movement History</span> </td>
</tr>
<tr>
<td>
<table border="0" cellpadding="10" cellspacing="0" class="tableContainer" style="width:1000px">
<tr>
<td>
<!-------------------------------------------------------------------------------------------------------->
<%
//if( request.getParameter("__cmd") == null || !("save").equalsIgnoreCase(request.getParameter("__cmd") )) {
DbInquiry memployee = new InitialInquiry(screen.getUProfile()).getDbInquiry("memployee");
try {
DbRecord mbu1 = new InitialRecord(screen.getUProfile()).getDbRecord("mbu1", false);
DbRecord mbu2 = new InitialRecord(screen.getUProfile()).getDbRecord("mbu2", false);
DbRecord mbu3 = new InitialRecord(screen.getUProfile()).getDbRecord("mbu3", false);
DbRecord mbu4 = new InitialRecord(screen.getUProfile()).getDbRecord("mbu4", false);
DbRecord mbu5 = new InitialRecord(screen.getUProfile()).getDbRecord("mbu5", false);
DbRecord mposition = new InitialRecord(screen.getUProfile()).getDbRecord("mposition", false);
memployee.setColumn("employeeid,companyid,emp_prefix,fname,lname,efname,elname,status,emp_level,job,emp_position,bu1,bu2,bu3,bu4,bu5");
mbu1.setColumn("bu1id,edesc,tdesc");
mbu2.setColumn("bu2id,edesc,tdesc");
mbu3.setColumn("bu3id,edesc,tdesc");
mbu4.setColumn("bu4id,edesc,tdesc");
mbu5.setColumn("bu5id,edesc,tdesc");
mposition.setColumn("positionid,edesc,tdesc");
memployee.setOrderBy("employeeid,startdate");
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("employeeid not in(select distinct hadj.employeeid from hadjposition as hadj INNER JOIN memployee as emp on hadj.employeeid = emp.employeeid and hadj.eff_date >= emp.startdate where hadj.adj_type ='10' and hadj.companyid='" +screen.getUProfile().get("companyid")+"') ");
filter.append("and nullif(bu1,'') is not null and bu1 <> 'NONE' ");
filter.append("and nullif(emp_position,'') is not null and emp_position <> 'NONE' ");
filter.append("and nullif(startdate,'') is not null and startdate <> '1900-01-01' ");
filter.append("and status <> 'D' and nullif(startdate,resigndate) is not null ");
filter.append( fixCompany );
if(!choose_employee.equals("")){
filter.append("and employeeid not in ("+choose_employee+") ");
}
memployee.setFilter( filter.toString());
memployee.putChild(mbu1);
memployee.putChild(mbu2);
memployee.putChild(mbu3);
memployee.putChild(mbu4);
memployee.putChild(mbu5);
memployee.putChild(mposition);
memployee.refresh();
} catch (Exception e) {
MyLog.error(this, e);
}
%>
<table border="0" cellpadding="10" cellspacing="0" class="maxsize">
<tr>
<td width="50%"><div><!-- <script language="JavaScript" type="text/javascript">swapLang("Found Data");</script> -->
<span swlang code="SW000927">Found Data</span> : <%=memployee.recCount() %> </div></td>
<td width="50%"> </td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="1" class=" tableContent maxsize tablewithborder">
<tr>
<% DbRecord empRec = memployee.getCurrentDbRecord(); %>
<td width="60" class="row3"><div class="center nowrap"><INPUT type="checkbox" id="maincheckbox" onchange="setcheck()">
<span swlang code="SW000193">Seq</span></div></td>
<td width="70" class="row3"><div class="center nowrap"><%=empRec.getField("employeeid").getDescription() %></div></td>
<td width="150" class="row3"><div class="center nowrap"><%=empRec.getField("fullname").getDescription() %></div></td>
<td width="100" class="row3"><div class="center nowrap"><%=empRec.getField("emp_position").getDescription() %></div></td>
<td width="100" class="row3"><div class="center nowrap"><%=empRec.getField("bu1").getDescription() %></div></td>
<td width="100" class="row3"><div class="center nowrap"><%=empRec.getField("bu2").getDescription() %></div></td>
<td width="100" class="row3"><div class="center nowrap"><%=empRec.getField("bu3").getDescription() %></div></td>
<td width="100" class="row3"><div class="center nowrap"><%=empRec.getField("bu4").getDescription() %></div></td>
<td width="100" class="row3"><div class="center nowrap"><%=empRec.getField("bu5").getDescription() %></div></td>
</tr>
<%
while(memployee.next()) {
memployee.referLangOn();
%>
<tr>
<td class="column-text center" ><input type="checkbox" value="<%=memployee.getString("employeeid")%>" onchange="setmaincheckbox()" class="selectemployee"> <%=memployee.recNo()%></td>
<td class="column-text" > <%=memployee.getString("employeeid")%></a></td>
<td class="column-text" ><%=chk.chkNullString(memployee.getString("fullname"), "-") %></td>
<td class="column-text" ><%=chk.chkNullString(memployee.getString("mposition","tdesc"), "-") %></td>
<td class="column-text" ><%=chk.chkNullString(memployee.getString("mbu1","tdesc"), "-") %></td>
<td class="column-text " ><%=chk.chkNullString(memployee.getString("mbu2","tdesc"), "-") %></td>
<td class="column-text " ><%=chk.chkNullString(memployee.getString("mbu3","tdesc"), "-") %></td>
<td class="column-text " ><%=chk.chkNullString(memployee.getString("mbu4","tdesc"), "-") %></td>
<td class="column-text " ><%=chk.chkNullString(memployee.getString("mbu5","tdesc"), "-") %></td>
</tr>
<%
memployee.referLangOff();
}
%>
</table>
<%
if(memployee.recCount()>0) {
%>
<%
}
//} else {
%>
<!--div style="margin:20px auto; text-align:center;">ไม่มีข้อมูล</div-->
<% //}%>
</td>
</tr>
<tr>
<td class="buttonline" colspan="7"><div align="center">
<button type="button" class="btn btn-primary width100" swlang code="SW013173" onClick="javaScript:process();">process</button>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr >
<td class="bottom" >
</td>
</tr>
</table></div>
<script language="JavaScript">checkConfirm();</script>
</form>
</body>
</html>