<!DOCTYPE html>
<%@page import="com.csc.library.utility.DHMConvert"%>
<%@page import="com.csc.library.session.InitialInquiry"%>
<%@page import="com.csc.library.session.DbInquiry"%>
<%@page import="com.csc.library.entry.HelpEntry"%>
<%@page import="com.csc.library.utilities.*"%>
<%@page import="com.csc.library.database.*"%>
<%@page contentType="text/html; charset=UTF-8"%>
<jsp:useBean id="RCR019" class="com.csc.library.system.Task" scope="page"/>
<%
RCR019.setChannel(request,response);
RCR019.checkProfile();
HelpEntry screen = (HelpEntry) RCR019.process("HelpEntry","MEMPLOYEEHELP");
screen.referLangOff();
String lang = screen.getUProfile().get("lang");
CheckNull chk = new CheckNull();
CscCalendar cc = new CscCalendar();
screen.setMaxLine(-1);
String view = chk.chkNullString(request.getParameter("__view"));
UProfile uprofile = screen.getUProfile();
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 bu1Desc = chk.chkNullString(request.getParameter("MBU1@TDESC"));
String bu2Desc = chk.chkNullString(request.getParameter("MBU2@TDESC"));
String bu3Desc = chk.chkNullString(request.getParameter("MBU3@TDESC"));
String bu4Desc = chk.chkNullString(request.getParameter("MBU4@TDESC"));
String bu5Desc = chk.chkNullString(request.getParameter("MBU5@TDESC"));
String startMonth = chk.chkNullString(request.getParameter("startMonth"));
String startYear = chk.chkNullString(request.getParameter("startYear"));
String endMonth = chk.chkNullString(request.getParameter("endMonth"));
String endYear = chk.chkNullString(request.getParameter("endYear"));
String filter = chk.chkNullString(request.getParameter("__filter"),"1=1");
if(!bu1.equals("")){
filter += " and me.bu1='"+bu1+"'";
}
if(!bu2.equals("")){
filter += " and me.bu2='"+bu2+"'";
}
if(!bu3.equals("")){
filter += " and me.bu3='"+bu3+"'";
}
if(!bu4.equals("")){
filter += " and me.bu4='"+bu4+"'";
}
if(!bu5.equals("")){
filter += " and me.bu5='"+bu5+"'";
}
%>
<%!
private String getEmp(String date,String bu4,UProfile up) {
String emp = "";
CscCalendar csc = new CscCalendar(date);
String month = csc.getYear()+"-"+csc.getMM();
String sql = "select COUNT(1) as emp from MEMPLOYEE where RESIGNDATE > '"+month+"-31' and BU4 = '"+bu4+"' ";
try{
DataSet ds = new DataSet(sql,up.get("dbname"),"Memployee");
ds.initConnection(up);
while (ds.next()) {
emp = ds.getString("emp");
}
ds.closeConnection();
}catch(Exception e) {
e.printStackTrace();
}
return emp;
}
private String getOut(String date,String bu4,UProfile up) {
String emp = "";
CscCalendar csc = new CscCalendar(date);
String month = csc.getYear()+"-"+csc.getMM();
String sql = "select COUNT(1) as emp from MEMPLOYEE where RESIGNDATE > '"+month+"-01' and RESIGNDATE <='"+month+"-31' and BU4 = '"+bu4+"' ";
try{
DataSet ds = new DataSet(sql,up.get("dbname"),"Memployee");
ds.initConnection(up);
while (ds.next()) {
emp = ds.getString("emp");
}
ds.closeConnection();
}catch(Exception e) {
e.printStackTrace();
}
return emp;
}
%>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<title></title>
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<!-- Bootstrap -->
<link href="../CSS/bootstrap.css" rel="stylesheet">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="js/html5shiv.min.js"></script>
<script src="js/respond.min.js"></script>
<![endif]-->
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="../JS/jquery-1.11.3.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="../JS/bootstrap.min.js"></script>
<script src='../JS/SCREEN.js'></script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script>setLang('<%=lang%>');</script>
<script src="../JS/SWAPLANG_FREEDOM.js"></script>
<script>setLangSwapLang('<%=lang%>');</script>
<script language="JavaScript" type="text/JavaScript">
function goHelp(helpName,inputName,condition){
with( document.cscform ){
var helpReturn;
var temp;
if( inputName == "bu1" ){
temp = __fixCon.value;
helpReturn = inputName+":bu1id,MBU1@TDESC";
linkHelp_Return(helpName,helpReturn);
__fixCon.value=temp;
}else if( inputName == "bu2" ){
temp = __fixCon.value;
helpReturn = inputName+":bu2id,MBU2@TDESC";
linkHelp_Return(helpName,helpReturn);
__fixCon.value=temp;
}else if( inputName == "bu3" ){
temp = __fixCon.value;
helpReturn = inputName+":bu3id,MBU3@TDESC";
linkHelp_Return(helpName,helpReturn);
__fixCon.value=temp;
}else if( inputName == "bu4" ){
temp = __fixCon.value;
helpReturn = inputName+":bu4id,MBU4@TDESC";
linkHelp_Return(helpName,helpReturn);
__fixCon.value=temp;
}else if( inputName == "bu5" ){
temp = __fixCon.value;
helpReturn = inputName+":bu5id,MBU5@TDESC";
linkHelp_Return(helpName,helpReturn);
__fixCon.value=temp;
}
}
}
function GoExport(){
with(document.cscform){
//alert(__filter.value);
var param = "TAR1121_EXP.jsp";
window.open(param);
}
}
function GoPrint(){
with(document.cscform){
var param = "RCR019_PDF.jsp";
window.open(param);
submit();
}
}
function GoView(){
with(document.cscform){
var st = new Date(startYear.value,(startMonth.value)-1);
var en = new Date(endYear.value,(endMonth.value)-1);
if(st<=en){
__view.value = "1"
submit();
}else{
alert("กรุณาเลือกเดือนเริ่มต้นน้อยกว่าเดือนสิ้นสุด")
}
}
}
$(function() {
$('#export').click(function() {
GoExport();
});
$('#preview').click(function() {
GoView();
});
$('#print').click(function() {
GoPrint();
});
});
</script>
<style>
.table-condensed > tbody > tr > td {
padding: 4px;
border: 0px solid #ddd;
}
img[height="20"] {
padding: 0px;
}
.table-bordered th {
color: #ffffff;
text-align: center;
vertical-align: middle;
background-color: #336699;
}
.eiei {
overflow: scroll;
height: 100%;
}
</style>
</head>
<body>
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script>initToolTips();</script>
<form role="form" class="form-horizontal" id="cscform" name="cscform" method="post" action="RCR019.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__screen" value="RCR019">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__calendar" 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="__user" value="<%=screen.getUProfile().getUserId()%>">
<input type="hidden" name="__referPage" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__view" value="">
<input type="hidden" name="__filter" value="">
<input type="hidden" id="statusFirst" name="statusFirst" value="<%//=statusFirst%>">
<script>getInputFormatDate();</script>
<div class="">
<div class="">
<table class="table table-condensed maxsize">
<tbody>
<tr>
<td colspan="2" class="header">ข้อมูลเบอร์โทรติดต่อพนักงาน </td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td align="right" width="40%">หน่วยงานระดับ1: </td>
<td align="left" width="60%">
<input type="text" id="bu1" name="bu1" value="<%=bu1%>" size="10">
<a href ="javascript:goHelp('MBU1HELP','bu1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('emp_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" ALT="SEARCH" name="emp_image" width="20" height="20" border="0" style="vertical-align: middle"></a>
<input type="text" id="MBU1@TDESC" name="MBU1@TDESC" value="<%=bu1Desc%>" size="35">
</td>
</tr>
<tr>
<td align="right" width="40%">หน่วยงานระดับ2: </td>
<td align="left" width="60%">
<input type="text" id="bu2" name="bu2" value="<%=bu2%>" size="10">
<a href ="javascript:goHelp('MBU2HELP','bu2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('emp_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" ALT="SEARCH" name="emp_image" width="20" height="20" border="0" style="vertical-align: middle"></a>
<input type="text" id="MBU2@TDESC" name="MBU2@TDESC" value="<%=bu2Desc%>" size="35">
</td>
</tr>
<tr>
<td align="right" width="40%">หน่วยงานระดับ3: </td>
<td align="left" width="60%">
<input type="text" id="bu3" name="bu3" value="<%=bu3%>" size="10">
<a href ="javascript:goHelp('MBU3HELP','bu3');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('emp_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" ALT="SEARCH" name="emp_image" width="20" height="20" border="0" style="vertical-align: middle"></a>
<input type="text" id="MBU3@TDESC" name="MBU3@TDESC" value="<%=bu3Desc%>" size="35">
</td>
</tr>
<tr>
<td align="right" width="40%">หน่วยงานระดับ4: </td>
<td align="left" width="60%">
<input type="text" id="bu4" name="bu4" value="<%=bu1%>" size="10">
<a href ="javascript:goHelp('MBU4HELP','bu4');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('emp_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" ALT="SEARCH" name="emp_image" width="20" height="20" border="0" style="vertical-align: middle"></a>
<input type="text" id="MBU4@TDESC" name="MBU4@TDESC" value="<%=bu4Desc%>" size="35">
</td>
</tr>
<tr>
<td align="right" width="40%">หน่วยงานระดับ5: </td>
<td align="left" width="60%">
<input type="text" id="bu5" name="bu5" value="<%=bu1%>" size="10">
<a href ="javascript:goHelp('MBU5HELP','bu5');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('emp_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" ALT="SEARCH" name="emp_image" width="20" height="20" border="0" style="vertical-align: middle"></a>
<input type="text" id="MBU5@TDESC" name="MBU5@TDESC" value="<%=bu5Desc%>" size="35">
</td>
</tr>
<tr>
<td align="right" width="40%">ช่วงเดือน: </td>
<td align="left" width="60%">
<select name="startMonth" id="startMonth">
<option value="01"><script language="javascript">swapLang('JANUARY')</script></option>
<option value="02"><script language="javascript">swapLang('FEBRUARY')</script></option>
<option value="03"><script language="javascript">swapLang('MARCH')</script></option>
<option value="04"><script language="javascript">swapLang('APRIL')</script></option>
<option value="05"><script language="javascript">swapLang('MAY')</script></option>
<option value="06"><script language="javascript">swapLang('JUNE')</script></option>
<option value="07"><script language="javascript">swapLang('JULY')</script></option>
<option value="08"><script language="javascript">swapLang('AUGUST')</script></option>
<option value="09"><script language="javascript">swapLang('SEPTEMBER')</script></option>
<option value="10"><script language="javascript">swapLang('OCTOBER')</script></option>
<option value="11"><script language="javascript">swapLang('NOVEMBER')</script></option>
<option value="12"><script language="javascript">swapLang('DECEMBER')</script></option>
</select>
<select name="startYear" id="startYear">
<%
CscCalendar now = new CscCalendar();
CscCalendar stYear = new CscCalendar();
CscCalendar endYear1 = new CscCalendar();
int startY = stYear.decYear(20).getYear();
int endY = endYear1.getYear();
for(int y1=startY;y1<=endY;y1++){
%>
<option value="<%=y1%>" <%if(y1==now.getYear()){out.print("selected");}%>><%=y1%></option>
<%}%>
</select>
-
<select name="endMonth" id="endMonth">
<option value="01"><script language="javascript">swapLang('JANUARY')</script></option>
<option value="02"><script language="javascript">swapLang('FEBRUARY')</script></option>
<option value="03"><script language="javascript">swapLang('MARCH')</script></option>
<option value="04"><script language="javascript">swapLang('APRIL')</script></option>
<option value="05"><script language="javascript">swapLang('MAY')</script></option>
<option value="06"><script language="javascript">swapLang('JUNE')</script></option>
<option value="07"><script language="javascript">swapLang('JULY')</script></option>
<option value="08"><script language="javascript">swapLang('AUGUST')</script></option>
<option value="09"><script language="javascript">swapLang('SEPTEMBER')</script></option>
<option value="10"><script language="javascript">swapLang('OCTOBER')</script></option>
<option value="11"><script language="javascript">swapLang('NOVEMBER')</script></option>
<option value="12"><script language="javascript">swapLang('DECEMBER')</script></option>
</select>
<select name="endYear" id="endYear">
<%
CscCalendar now2 = new CscCalendar();
CscCalendar stYear2 = new CscCalendar();
CscCalendar endYear2 = new CscCalendar();
int startY2 = stYear2.decYear(20).getYear();
int endY2 = endYear2.getYear();
for(int y2=startY2;y2<=endY2;y2++){
%>
<option value="<%=y2%>" <%if(y2==now2.getYear()){out.print("selected");}%>><%=y2%></option>
<%}%>
</select>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</tr>
<td colspan="2" style="text-align: center;">
<div id="print" class="btn btn-primary btn-sm" style="padding-top: 2px;">
<span class="glyphicon glyphicon-print"></span> Print
</div>
<div id="preview" class="btn btn-primary btn-sm" style="padding-top: 2px;">
<span class="glyphicon glyphicon-triangle-right"></span> Preview
</div>
</td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr>
<td colspan="2" class="bottom" style="padding-top: 0px; padding-bottom: 0px;"> </td>
</tr>
</tbody>
</table>
</div>
<div class="clearfix"></div>
<!-- <div class="col-sm-12 pre-scrollable"> -->
<div class="">
<%if (view.equals("1")){ %>
<img src="../IMAGES/loading2.gif" id="loading" style="margin-left: 40%">
<table class="table table-bordered maxsize">
<thead>
<%
String stDate = "01-"+startMonth+"-"+startYear;
String enDate = "01-"+endMonth+"-"+endYear;
CscCalendar st = new CscCalendar(stDate);
CscCalendar en = new CscCalendar(enDate);
%>
<tr>
<td align="center" class="row1"><div style="width: 150px;">แผนก</div></td>
<td align="center" class="row1"><div style="width: 230px;">จำนวนพนักงาน(คน)</div></td>
<%
while(st.beforeEquals(en)){
%>
<td align="center" class="row1"><div style="width: 50px;"><%=st.getEngShortMonth()+"-"+st.getEngYY()%></div></td>
<%
st.incMonth(1);
}
%>
<td align="center" class="row1"><div style="width: 50px;">Total</div></td>
</tr>
</thead>
<tbody>
<%
try{
String sql="select me.bu4 as bu4id,b4.TDESC as bu4 from MEMPLOYEE me left join MBU4 b4 on me.BU4=b4.BU4ID where "+filter+" group by me.bu4,b4.TDESC";
//out.print(sql);
DataSet ds = new DataSet(sql.toString(),screen.getUProfile().get("dbname"),"Memployee");
ds.initConnection(screen.getUProfile());
while (ds.next()) {
String stDate2 = "01-"+startMonth+"-"+startYear;
String enDate2 = "01-"+endMonth+"-"+endYear;
CscCalendar st2 = new CscCalendar(stDate2);
CscCalendar en2 = new CscCalendar(enDate2);
%>
<tr>
<td align="left"><%= chk.chkNullString(ds.getString("bu4"))%></td>
<td align="left">
จำนวนพนักงานตามแผนกำลัง(คน)<br>
จำนวนพนักงานลาออก(คน)<br>
Tumover rate(%)
</td>
<%while(st2.beforeEquals(en2)){%>
<td align="center">
<%=getEmp(String.valueOf(st2.getYYYYMMDD()),chk.chkNullString(ds.getString("bu4id")),uprofile)%><br>
<%=getOut(String.valueOf(st2.getYYYYMMDD()),chk.chkNullString(ds.getString("bu4id")),uprofile)%><br>
</td>
<%
st2.incMonth(1);
}%>
<td align="left"></td>
</tr>
<%
}
ds.closeConnection();
}catch(Exception e) {
e.printStackTrace();
}
%>
</tbody>
</table>
</div>
<%}%>
<script>$('#loading').hide();</script>
</div>
</form>
</body>
</html>