<%@ page contentType="text/html; charset=UTF-8" language="java" pageEncoding="UTF-8" %>
<%@ page import="com.csc.library.entry.EmvHelpEntry, com.csc.library.system.*, com.csc.library.utilities.CheckNull" %>
<%@ page import="com.csc.library.report.ReportUDF, java.util.*,com.csc.library.database.*,com.csc.library.session.*"%>
<%@ include file="../CHECKPROFILE.jsp" %>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="EMV" class="com.csc.library.system.Task" scope="page" />
<jsp:setProperty name="EMV" property="appname" value="EMPVIEW" />
<%
EMV.setChannel( request, response );
EmvHelpEntry screen = (EmvHelpEntry)EMV.process("EmvHelpEntry", "VW_REQUESTHELP");
if(screen==null){
return;
}
screen.setMaxLine(15);
CheckNull chk = new CheckNull();
String valueSearch = chk.chkNullString( request.getParameter("__valueSearch"));
String searchBy = chk.chkNullString( request.getParameter("__searchBy"));
String bu3 = chk.chkNullString( request.getParameter("__bu3"));
String position = chk.chkNullString( request.getParameter("__emp_position"));
String fname = chk.chkNullString( request.getParameter("__fname"));
String lname = chk.chkNullString( request.getParameter("__lname"));
/*
String newfilter = "requestid in (select requestid from mcommittee where EMPLOYEEID = '"+screen.getUProfile().get("employeeid")+"' AND PRIORITY='1')";
*/
String newfilter = "requestid in (select requestid from mcommittee where EMPLOYEEID = '"+screen.getUProfile().get("employeeid")+"')";
if( !valueSearch.equals("") ){
//screen.getInquiry().setFilter( searchBy,valueSearch);
//screen.getInquiry().setFilter( searchBy.substring(15), "%"+valueSearch +"%", "", "like" );
screen.getInquiry().setFilter( searchBy.substring(15)+ " LIKE '%"+valueSearch +"%' AND "+newfilter);
} else {
screen.getInquiry().setFilter( newfilter );
}
/*
if( !bu2.equals("") ){
screen.getInquiry().setFilter( "bu2", bu2, "", "=" );
}
if( !bu3.equals("") ){
screen.getInquiry().setFilter( "bu3", bu3, "", "=" );
}
if( !position.equals("") ){
screen.getInquiry().setFilter( "emp_position", position, "", "=" );
}
if( !fname.equals("") ){
screen.getInquiry().setFilter( "fname", "%"+fname +"%", "", "like" );
}
if( !lname.equals("") ){
screen.getInquiry().setFilter( "lname", "%"+lname +"%", "", "like" );
}
screen.getInquiry().setFilter("status", "Y", "", "!=");
*/
screen.process();
%>
<!DOCTYPE html>
<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 type="text/javascript">
setLang("<%=screen.getUProfile().get("lang")%>");
var swap = new swaplang();
var titlename = swap.swap2String("SW006674");
setPageTitle(titlename);
$(document).ready(function(){
$("select").addClass("form-control");
$("select[name=listpage]").removeClass("form-control");
$("input").addClass("form-control");
});
function goHelp(helpName,inputName) {
var helpReturn;
var fixCon = "";
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=="__emp_position" ) {
helpReturn="__emp_position:positionid,MPOSITION@TDESC";
} else if(inputName=="__subgroupid" ) {
fixCon = "employeeid='<%=screen.getUProfile().getEmvEmpId()%>'";
helpReturn="__subgroupid:groupid,MSUBORDINATE_GRP@TDESC";
}
linkHelp_Return(helpName,helpReturn, fixCon);
}
function GoSearch(){
search();
}
function linkSubordinate(requestid){
with(document.cscform){
__requestid.value=requestid;
action = "EMV_REC612.jsp";
submit();
}
}
function toolTip(){
}
</script>
<section>
<div class="container csc-content">
<form name="cscform" class="form-horizontal" method="post" action="?">
<%=screen.InitialVariable()%>
<input type="hidden" name="__screen" value="MG_SUBORDINATE">
<input type="hidden" name="__cmd" value="" />
<input type="hidden" name="__help" value="" />
<input type="hidden" name="__goPage" value="" />
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>" />
<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>" />
<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="__subordinateid" value="" />
<input type="hidden" name="__requestid" value="" />
<div class="csc-block">
<div class="center">
<h2 class="csc-block-head" swlang code='SW006674'>List of Candidate</h2>
</div>
<div class="form-horizontal">
<div class="row">
<div class="form-group">
<div class="col-md-1 col-sm-1 col-xs-1"></div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right" swlang code='SW002014'>Order By</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<%=screen.getTagOrder()%>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right" swlang code='SW000005'>Search By</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<%=screen.getTagSearchBy()%>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-1 col-sm-1 col-xs-1"></div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right" swlang code='SW000006'>Condition</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<%=screen.getTagConSearch()%>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right" swlang code='SW000007'>Key Value</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<%=screen.getTagValueSearch()%>
</div>
</div>
</div>
<div class="center">
<a class="btn btn-primary" swlang code='SW003537' href="javascript:GoSearch();">Search</a>
</div>
</div>
</div>
<span class="detail-table">
<span swlang code='SW001771'>Found Data</span> : <%= screen.getInquiry().recCount() %>
<span swlang code='SW001780'>records</span>
</span>
<span class="detail-table label-right">
<span swlang code='SW001120'>Page</span> : <%=screen.getPageTagNew()%>
</span>
<%
DbInquiry memployee = new InitialInquiry(screen.getUProfile()).getDbInquiry("memployee");
memployee.setColumn("employeeid,companyid,bu1,bu2,bu3,bu4,bu5");
memployee.refresh();
DbRecord mbu = memployee.getCurrentDbRecord();
%>
<div class="table-responsive">
<table class="table table-head table-hover table-bordered table-title-left">
<thead>
<tr>
<th swlang code='SW000193'>Seq</th>
<th><%=screen.getLabel("requestid")%></th>
<th><%=screen.getLabel("job")%></th>
<th><%=screen.getLabel("position")%></th>
<th><%=mbu.getField("bu1").getDescription()%></th>
<th><%=mbu.getField("bu2").getDescription()%></th>
<th><%=mbu.getField("bu3").getDescription()%></th>
</tr>
</thead>
<tbody>
<%
if(screen.getInquiry().recCount()>0) {
while(screen.nextRec()){
int beginRow=((Integer.parseInt(screen.goPage)-1)*screen.maxLine)+1;
%>
<tr>
<td><center><%=beginRow+screen.getInquiry().recNo()-1 %></center></td>
<td><center><a href="javascript:linkSubordinate('<%=screen.getString("requestid")%>');"><%=screen.getString("requestid")%></a></center></td>
<td><%=chk.chkNullString(screen.getString("job"), "-") %></td>
<td><%=chk.chkNullString(screen.getString("position"), "-") %></td>
<td><%=chk.chkNullString(screen.getString("bu1"), "-") %></td>
<td><%=chk.chkNullString(screen.getString("bu2"), "-") %></td>
<td><%=chk.chkNullString(screen.getString("bu3"), "-") %></td>
</tr>
<%
screen.referLangOff();
} // while
} else {
%>
<tr id="blank-row">
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<%
}
%>
</tbody>
</table>
</div>
<%=screen.endJSP()%>
</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>