<!DOCTYPE html>
<%@page contentType="text/html; charset=UTF-8"%>
<% request.setCharacterEncoding("UTF-8"); %>
<%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@page import="com.csc.library.utilities.CscCalendar,com.csc.library.entry.EmvHelpEntry,com.csc.library.system.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,java.text.*" %>
<%@ include file="../CHECKPROFILE.jsp" %>
<jsp:useBean id="EMV" class="com.csc.library.system.Task" scope="page" />
<%
EMV.setChannel(request, response);
EmvHelpEntry screen = (EmvHelpEntry) EMV.process("EmvHelpEntry", "EMV023HELP");
//screen.referLangOn();
DbInquiry inquiry = new InitialInquiry(screen.getUProfile()).getDbInquiry("memployee");
inquiry.setColumn("employeeid,endworkdate,emp_type");
CscCalendar cscDate = new CscCalendar();
screen.getInquiry().setFilter("expire_date >='"+cscDate.getYYYYMMDD()+"'");
screen.getInquiry().refresh();
inquiry.setFilter("endworkdate >='"+cscDate.getYYYYMMDD()+"'");
int total = 0;
total=inquiry.recCount();
DecimalFormat dc = new DecimalFormat();
dc.applyPattern("#,##0");
/*out.println(dc.format(total)+"<P>");
//EMP_TYPE
String[][] emptype = SystemCode.getContent("EMPTYPE");
for(int i = 0 ;i<emptype.length;i++){
inquiry.setFilter("ENDWORKDATE >='"+cscDate.getYYYYMMDD()+"' and emp_type='"+emptype[i][0]+"'");
total=inquiry.recCount();
if(screen.getUProfile().get("lang").equals("ENG"))
out.println((emptype[i][1].split(","))[0]+"-------"+dc.format(total));
else
out.println((emptype[i][1].split(","))[1]+"-------"+dc.format(total)+"<P>");
}
inquiry.initMyTable("mbu1", "expire_date >='"+cscDate.getYYYYMMDD()+"'", "");
inquiry.setColumn("bu1id,expire_date");
total=inquiry.recCount();
out.println("bu1-->"+dc.format(total)+"<P>");
inquiry.initMyTable("mbu2", "expire_date >='"+cscDate.getYYYYMMDD()+"'", "");
inquiry.setColumn("bu2id,expire_date");
total=inquiry.recCount();
out.println("bu2-->"+dc.format(total)+"<P>");
inquiry.initMyTable("mbu3", "expire_date >='"+cscDate.getYYYYMMDD()+"'", "");
inquiry.setColumn("bu3id,expire_date");
total=inquiry.recCount();
out.println("bu3-->"+dc.format(total)+"<P>");
inquiry.initMyTable("mjobcode", "", "");
inquiry.setColumn("jobcodeid");
total=inquiry.recCount();
out.println("jobcode-->"+dc.format(total)+"<P>");
inquiry.initMyTable("mposition", "", "");
inquiry.setColumn("positionid");
total=inquiry.recCount();
out.println("position-->"+dc.format(total)+"<P>");
int male,tomale=0 ,female,tofemale=0;
String oldbu1="";
for(;screen.getInquiry().next();){
if((screen.getInquiry().recNo()!=1)&&(!oldbu1.equals(screen.getInquiry().getString("PARENT")))){
out.println("totalmale-->"+dc.format(tomale)+"---totalfemale-->"+dc.format(tofemale)+"--total--"+dc.format(tomale+tofemale)+"<P>");
}
if((screen.getInquiry().recNo()==1)||(!oldbu1.equals(screen.getInquiry().getString("PARENT")))){
oldbu1=screen.getInquiry().getString("PARENT");
out.println("BU1--"+screen.getInquiry().getChild("mbu1").getString("tdesc")+"<P>");
tomale=tofemale=0;
}
out.println("BU2--"+screen.getInquiry().getString("tdesc"));
screen.getInquiry().getChild("memployee").setFilter("sex='1'");
male = screen.getInquiry().getChild("memployee").recCount();
screen.getInquiry().getChild("memployee").setFilter("sex='2'");
female = screen.getInquiry().getChild("memployee").recCount();
out.println("male-->"+dc.format(male)+"---female-->"+dc.format(female)+"--total--"+dc.format(male+female)+"<P>");
tomale+=male;
tofemale+=female;
}
out.println("totalmale-->"+dc.format(tomale)+"---totalfemale-->"+dc.format(tofemale)+"--total--"+dc.format(tomale+tofemale)+"<P>");
*/
%>
<html xmlns="http://www.w3.org/1999/xhtml" ng-app="myHR">
<head>
<title>Employee View</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
</head>
<body>
<div class="bg-com"></div>
<jsp:include page="EMV_HEADMENU.jsp" flush="true" />
<script>
setLang("<%=screen.getUProfile().get("lang")%>");
var swap = new swaplang();
var titlename = swap.swap2String("SW002045");
setPageTitle(titlename);
</script>
<section>
<div class="container csc-content">
<form name="cscform" class="form-horizontal" method="post" action="?">
<%=screen.InitialVariable()%>
<input type="hidden"name="__screen" value="EMV023">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__keyList" value="">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__language" value ="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<div class="csc-block-white">
<div class="container csc-content">
<div class="center">
<h2 swlang code="SW002045">Manpower Report</h2>
</div>
<%screen.referLangOff();%>
<div class="form-horizontal">
<legend class="legend-control" swlang code="SW002038">Emploment Type</legend>
<div class="row">
<div class="form-group">
<%
String[][] emptype = SystemCode.getContent("EMPTYPE");
for(int i = 0 ;i<emptype.length;i++){
inquiry.setFilter("endworkdate >='"+cscDate.getYYYYMMDD()+"' and emp_type='"+emptype[i][0]+"'");
Integer total1=inquiry.recCount();;
%>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label control-label-form label-right">
<%
UProfile up = (UProfile)session.getAttribute("userprofile");
if(up.get("lang").equals("eng")) {
out.print(emptype[i][1].split(",")[0] );
} else{
out.print(emptype[i][1].split(",")[1] );
}%>
</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label control-label-form "><%=dc.format(total1)%> <label swlang code="SW002049">Person</label></label>
</div>
<%
}
%>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label control-label-form label-right" swlang code="SW002057">Total Employee</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label control-label-form "><%=dc.format(total)%> <label swlang code="SW002049">Person</label></label>
</div>
</div>
</div>
</br>
<legend class="legend-control" swlang code="SW012125">Business Unit</legend>
<div class="row">
<div class="form-group">
<%
inquiry.initMyTable("mbu1", "expire_date >='"+cscDate.getYYYYMMDD()+"'", "");
inquiry.setColumn("bu1id,expire_date");
total=inquiry.recCount();
%>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label control-label-form label-right"><%=screen.getLabel("memployee","bu1")%></label>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label control-label-form "><%=dc.format(total)%> <label swlang code="SW012125">Business Unit</label></label>
</div>
<%
inquiry.initMyTable("mbu2", "expire_date >='"+cscDate.getYYYYMMDD()+"'", "");
inquiry.setColumn("bu2id,expire_date");
total=inquiry.recCount();
%>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label control-label-form label-right"><%=screen.getLabel("memployee","bu2")%></label>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label control-label-form "><%=dc.format(total)%> <label swlang code="SW012125">Business Unit</label></label>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<%
inquiry.initMyTable("mbu3", "expire_date >='"+cscDate.getYYYYMMDD()+"'", "");
inquiry.setColumn("bu3id,expire_date");
total=inquiry.recCount();
%>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label control-label-form label-right"><%=screen.getLabel("memployee","bu3")%></label>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label control-label-form "><%=dc.format(total)%> <label swlang code="SW012125">Business Unit</label></label>
</div>
<%
inquiry.initMyTable("mjobcode", "", "");
inquiry.setColumn("jobcodeid");
total=inquiry.recCount();
%>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label control-label-form label-right" swlang code="SW001681">Duty and Responsibility</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label control-label-form "><%=dc.format(total)%> <label swlang code="SW001696">Function</label></label>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<%
inquiry.initMyTable("mposition", "", "");
inquiry.setColumn("positionid");
total=inquiry.recCount();
%>
<div class="col-md-3 col-sm-3 col-xs-3">
<label class="control-label control-label-form label-right" swlang code="SW002050">Position Total</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label control-label-form "><%=dc.format(total)%> <label swlang code="SW000057">Position</label></label>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="table-responsive">
<table class="table table-head table-hover table-bordered table-title-left">
<thead>
<tr>
<th class="table-title " colspan=4 swlang code="SW002045">Manpower Report</th>
</tr>
<%
screen.referLangOff();
int male,tomale=0 ,female,tofemale=0;
String oldbu1="";
for(;screen.getInquiry().next();){
if((screen.getInquiry().recNo()!=1)&&(!oldbu1.equals(screen.getInquiry().getString("parent")))){
out.println("<tr>");
out.println("<td class=\"result-right\" swlang code=\"SW000024\">Total</td>");
out.println("<td class=\"result\">" +dc.format(tomale) +"</td>");
out.println("<td class=\"result\">" +dc.format(tofemale) +"</td>");
out.println("<td class=\"result\">" +dc.format(tomale+tofemale) +"</td>");
out.println("</tr>");
}
%>
<%
if((screen.getInquiry().recNo()==1)||(!oldbu1.equals(screen.getInquiry().getString("parent")))){
oldbu1=screen.getInquiry().getString("parent");
DbRecord mbu1 = new InitialRecord(screen.getUProfile()).getDbRecord("mbu1");
%>
<tr>
<th><%=mbu1.getDescription()%></th>
<th swlang code="SW002044">Male</th>
<th swlang code="SW002042">Female</th>
<th swlang code="SW000017">Amount</th>
</tr>
<tr>
<%screen.referLangOn();%>
<td class="table-title" colspan=4><%=screen.getInquiry().getChild("mbu1").getString("tdesc")%></td>
<%screen.referLangOff();%>
</tr>
<%
tomale=tofemale=0;
}
%>
</thead>
<tbody>
<tr>
<%screen.referLangOn();%>
<td><%=screen.getInquiry().getString("tdesc")%></td>
<%screen.referLangOff();%>
<%
screen.getInquiry().getChild("memployee").setFilter("sex='1'");
male = screen.getInquiry().getChild("memployee").recCount();
screen.getInquiry().getChild("memployee").setFilter("sex='2'");
female = screen.getInquiry().getChild("memployee").recCount();
%>
<td class="trash"><%=dc.format(male)%></td>
<td class="trash"><%=dc.format(female)%></td>
<td class="trash"><%=dc.format(male+female)%></td>
</tr>
<%
tomale+=male;
tofemale+=female;
} //end for
%>
<tr>
<td class="result-right" swlang code="SW000024">Total</td>
<td class="result-right"><%=dc.format(tomale)%></td>
<td class="result-right"><%=dc.format(tofemale)%></td>
<td class="result-right"><%=dc.format(tomale+tofemale)%></td>
</tr>
</tbody>
</table>
</div>
</form>
</div>
<a href="#top" id="top-button">
<i class="fa fa-angle-up"></i>
<div class="top-word">Back to top</div>
</a>
</section>
<jsp:include page="FOOTER.jsp" flush="true" />
</body>
</html>