<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.database.*,com.csc.library.utilities.*,com.csc.library.components.*,com.csc.library.report.*,com.csc.library.session.*"%>
<jsp:useBean id="PSU142_GPF" class="com.csc.library.system.Task" scope="page" />
<%
PSU142_GPF.setChannel(request, response);
HelpEntry screen = (HelpEntry) PSU142_GPF.process("HelpEntry", "PSU142HELP_GPF");
CscCalendar currdate = new CscCalendar();
//out.println("Before Date:: " + currdate.getYYYYMMDD());
currdate.incDate(30);
//out.println("After Date:: " + currdate.getYYYYMMDD());
screen.setMaxLine(20);
ReportUDF ref = new ReportUDF();
InitialEnvironment ine = new InitialEnvironment("GLOBAL");
String email_from = ine.getValue("mailauth-username");;
String filter = "ENDDATE < '"+currdate.getYYYYMMDD()+"' and 1=1 ";
CheckNull chk2 = new CheckNull();
String bu1 =chk2.chkNullString(request.getParameter("__bu1"));
String bu2 =chk2.chkNullString(request.getParameter("__bu2"));
String bu3 =chk2.chkNullString(request.getParameter("__bu3"));
String bu4 =chk2.chkNullString(request.getParameter("__bu4"));
String bu5 =chk2.chkNullString(request.getParameter("__bu5"));
String emp_type =chk2.chkNullString(request.getParameter("__emp_type"));
String position = chk2.chkNullString(request.getParameter("__emp_position"));
String tran_status = chk2.chkNullString(request.getParameter("__tran_status"));
String start_date_approve = chk2.chkNullString(request.getParameter("__start_date_approve"));
String end_date_approve = chk2.chkNullString(request.getParameter("__end_date_approve"));
String employeeid = chk2.chkNullString(request.getParameter("__employeeid"));
String fname = chk2.chkNullString(request.getParameter("__fname"));
String lname = chk2.chkNullString(request.getParameter("__lname"));
String valueSearch_data = chk2.chkNullString(request.getParameter("__valueSearch_data"));
String searchBy = chk2.chkNullString(request.getParameter("__searchBy"));
//out.print("FNAME = "+fname);
if( !bu1.equals("") ){
filter += "and bu1= '"+bu1+"' ";
//screen.getInquiry().setFilter( "bu1", bu1, "", "=" );
}
if( !bu2.equals("") ){
filter += "and bu2 = '"+ bu2+ "' ";
}
if( !bu3.equals("") ){
filter += "and bu3 = '"+ bu3+ "' ";
}
if( !bu4.equals("") ){
filter += "and bu4 = '"+ bu4+ "' ";
}
if( !bu5.equals("") ){
filter += "and bu5 = '"+ bu5+ "' ";
}
if( !position.equals("") ){
filter += "and emp_position = '"+ position+ "' ";
}
if( !emp_type.equals("") ){
filter += "and emp_type = '"+ emp_type+ "' ";
}
if(!fname.equals("")){
filter += "and FNAME = '"+fname+"' ";
}
if(!valueSearch_data.equals("")){
filter += "and "+searchBy+" like '%"+valueSearch_data+"%' ";
}
if (!start_date_approve.equals("") && !end_date_approve.equals("")) {
CscCalendar start_date = new CscCalendar(start_date_approve);
CscCalendar end_date = new CscCalendar(end_date_approve);
filter += "and (ENDDATE between '"+start_date.getYYYYMMDD()+"' and '"+end_date.getYYYYMMDD()+"') ";
}
int beginRow=((Integer.parseInt(screen.goPage)-1)*screen.maxLine)+1;
int endRow=(Integer.parseInt(screen.goPage))*screen.maxLine;
//screen.getInquiry().setBetween(beginRow, endRow);
//screen.getInquiry().clearOldCondition();
//EMPLOYEEID in (select EMPLOYEEID from MEMPLOYEE where 1=1 )
//out.println("filter : = " + filter+"<br>");
//screen.getInquiry().setFilter("EMPLOYEEID in (select EMPLOYEEID from MEMPLOYEE where "+filter+" )");
//out.println("screen filter : = " + screen.getInquiry().getFilter());
screen.process();
//out.println("Recout : " + screen.getInquiry().recCount());
%>
<%!
private String getAppstatus(String apsassessy,String astid,UProfile screen,String field){
String result="";
try{
String sql="select * from tapstran where apsassessy = '"+apsassessy+"' and astid = '"+astid+"'";
String dbName = screen.getDbName();
String tableName = "tapstran";
DataSet ds = new DataSet(sql,dbName,tableName);
ds.setFetchAll(false);
ds.initConnection(screen);
while(ds.next()){
result = ds.getString(field);
}
}catch(Exception e){ }
return result;
}
private String getBossEmail(String empid,String field,UProfile screen){
String result="";
try{
String sql="select b1.employeeid employeeid,b2.employeeid bossid ,m.email email from mempl_box b1 left join mapprove_box box on b1.boxid = box.boxid left join mempl_box b2 on box.upper_boxid0 = b2.boxid left join memployee m on b2.employeeid = m.employeeid where b1.employeeid = '"+empid+"' ";
String dbName = screen.getDbName();
String tableName = "mempl_box";
DataSet ds = new DataSet(sql,dbName,tableName);
ds.setFetchAll(false);
ds.initConnection(screen);
while(ds.next()){
result = ds.getString(field);
}
}catch(Exception e){ }
return result;
}
%>
<html ng-app="myHR">
<head>
<title><%=screen.getInquiry().getCurrentDbRecord().getDescription()%></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<script language='javascript' src='./JS/SWAPLANG.js'></script>
<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>
<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 type="text/javascript" src="../JS/DATEINPUT.js"></script>
<script type="text/javascript" src="../JS/VIEWCALENDAR.js"></script>
<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="javascript">
function goHelp(helpName,inputName){
var helpReturn;
if(inputName=="__bu1" ){
helpReturn="__bu1:bu1id,__bu1_desc:tdesc";
}else if(inputName=="__bu2" ){
helpReturn="__bu2:bu2id,__bu2_desc:tdesc";
}else if(inputName=="__bu3" ){
helpReturn="__bu3:bu3id,__bu3_desc:tdesc";
}else if(inputName=="__bu4" ){
helpReturn="__bu4:bu4id,__bu4_desc:tdesc";
}else if(inputName=="__bu5" ){
helpReturn="__bu5:bu5id,__bu5_desc:tdesc";
}else if(inputName=="__emp_position"){
helpReturn="__emp_position:positionid,__position_desc:tdesc";
}
linkHelp_Return2(helpName, helpReturn, "");
}
function setFilter(){
with(document.cscform){
//alert(reqstatus.value);
if(reqstatus.value!=""){
__fixCon.value="req_status='"+reqstatus.value+"' "
}
else
__fixCon.value="";
__cmd.value="search";
submit();
}
}
function GoSearch(){
with(document.cscform){
__fixCon.value="";
search();
}
}
function goProcess(send_to,send_from,employee_req){
var pam="MPROBATION_02.jsp?__mail_to="+send_to+"&__mail_from="+send_from+"&__employee_req="+employee_req+"&__astid_req=AP90";
window.open(pam,"","left=200,top=150,width=1000,height=550,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
function viewPrintPage(employeeid,attorney,promise_type,promisedate,startdate,enddate,salary,promiseage,job){
with(document.cscform){
if(!promise_type==""){
window.open("./PRU192E_O.jsp?__employeeid="+employeeid+"&__attorneyid="+attorney+"&__promise_type="+promise_type+
"&__promisedate="+promisedate+"&__startdate="+startdate+"&__enddate="+enddate+"&__salary="+salary+"&__promiseage="+promiseage+"&__job="+job,"Help","left=150,top=150,width=700,height=240,toolbar=no,status=no,scrollbars=yes,resizable=yes");
}else{
alert("กรุณาเลือกประเภทสัญญาจ้าง");
}
}
}
</script>
</head>
<%
String helpReturn="";
if(request.getParameter("__helpReturn")!=null){
helpReturn=request.getParameter("__helpReturn");
}
%>
<body leftmargin="0" topmargin="0">
<form name="cscform" method="post" >
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="PSU142_GPF">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
<input type="hidden" name="__helpReturn" value="">
<input type="hidden" name="__helpName" value="">
<input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="__requestid" value="">
<input type="hidden" name="__calendar" value="">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<script language="javascript">getInputFormatDate();</script>
<br>
<div align="center">
<table height="" align="center" cellpadding="0" cellspacing="0" >
<tr bgcolor="#3366CC">
<td height="20" class="header">PSU142_GPF, <!-- <script language="javaScript">swapLang("Employment Requisition List GPF")</script> -->
<span swlang code="SW005479">Employment Requisition List GPF</span> </td>
</tr>
<tr bgcolor="#3366CC">
<td> <table class="maxsize" border="1" cellspacing="1" cellpadding="1">
<tr>
<td><table class="maxsize" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="4" class="blankspace" ></td>
</tr>
<tr>
<td width="15%"> <div align="right">
<!-- <script language="javascript">swapLang('Business Unit 1');</script> -->
<span swlang code="SW010728">Division</span> </div></td>
<td colspan="3"><input type="text" name="__bu1" size="10" value="">
<a href="javascript:goHelp('MBU1HELP','__bu1')"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a>
<input type="text" name="__bu1_desc" size="30" readonly > </td>
</tr>
<tr>
<td width="15%"> <div align="right">
<!-- <script language="javascript">swapLang('Business Unit 2');</script> -->
<span swlang code="SW002031">Department</span> </div></td>
<td colspan="3"><input type="text" name="__bu2" size="10" value="">
<a href="javascript:goHelp('MBU2HELP','__bu2')"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a>
<input type="text" name="__bu2_desc" size="30" readonly > </td>
</tr>
<tr>
<td width="15%"> <div align="right">
<!-- <script language="javascript">swapLang('Business Unit 3');</script> -->
<span swlang code="SW000052">Section</span> </div></td>
<td colspan="3"><input type="text" name="__bu3" size="10" value="">
<a href="javascript:goHelp('MBU3HELP','__bu3')"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a>
<input type="text" name="__bu3_desc" size="30" readonly > </td>
</tr>
<tr>
<td width="15%"> <div align="right">
<!-- <script language="javascript">swapLang('Business Unit 4');</script> -->
<span swlang code="SW011728">Sub Section #1</span> </div></td>
<td colspan="3"><input type="text" name="__bu4" size="10" value="">
<a href="javascript:goHelp('MBU4HELP','__bu4')"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a>
<input type="text" name="__bu4_desc" size="30" readonly > </td>
</tr>
<tr>
<td width="15%"> <div align="right">
<!-- <script language="javascript">swapLang('Business Unit 5');</script> -->
<span swlang code="SW011729">Sub Section #2</span> </div></td>
<td colspan="3"><input type="text" name="__bu5" size="10" value="">
<a href="javascript:goHelp('MBU5HELP','__bu5')"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a>
<input type="text" name="__bu5_desc" size="30" readonly > </td>
</tr>
<tr>
<td width="15%"> <div align="right">
<!-- <script language="javascript">swapLang('Position');</script> -->
<span swlang code="SW000308">Position</span> </div></td>
<td colspan="3"><input type="text" name="__emp_position" size="10" value="">
<a href="javascript:goHelp('MPOSITIONHELP','__emp_position')"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"/></a>
<input type="text" name="__position_desc" size="30" readonly > </td>
</tr>
<tr>
<td width="15%"> <div align="right">
<!-- <script language="javascript">swapLang('Date');</script> -->
<span swlang code="SW000002">Date</span> </div></td>
<td colspan="3">
<input type="text" name="__start_date_approve" size="10" maxlength="10" value="" onFocus="this.select();" onKeyUp="formatDate(this);" onBlur="" onKeyPress="chkIntegerOfDate(this.value);" />
<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image111','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('__start_date_approve')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image111" width="20" height="20" border="0" align="absmiddle" id="Image111"></a>-
<input type="text" name="__end_date_approve" size="10" maxlength="10" value="" onFocus="this.select();" onKeyUp="formatDate(this);" onBlur="" onKeyPress="chkIntegerOfDate(this.value);" />
<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image111','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('__end_date_approve')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image111" width="20" height="20" border="0" align="absmiddle" id="Image111"></a>
</td>
</tr>
<%
ListBox listbox_type = new ListBox();
listbox_type.setUProfile(screen.getUProfile());
listbox_type.setName("emp_type");
//listbox_type.setonChange("setDisableField('ta_no');clearText();");
listbox_type.setValidCode("EMPTYPE");
%>
<tr>
<td width="15%"> <div align="right">
<!-- <script language="javascript">swapLang('Employee Type');</script> -->
<span swlang code="SW000130">Employee Type</span> </div></td>
<td colspan="3"><%=listbox_type.process()%> </td>
</tr>
<%
ListBox listbox_status = new ListBox();
listbox_status.setUProfile(screen.getUProfile());
listbox_status.setName("tran_status");
//listbox_type.setonChange("setDisableField('ta_no');clearText();");
listbox_status.setValidCode("APPSTATUS_GPF");
%>
<tr>
<td width="15%"> <div align="right">
<!-- <script language="javaScript">swapLang('Status')</script> -->
<span swlang code="SW000019">Status</span> </div></td>
<td colspan="3"><%=listbox_status.process()%> </td>
</tr>
<tr>
<td width="15%"> <div align="right">
<!-- <script language="javascript">swapLang('Order By');</script> -->
<span swlang code="SW000004">Order By</span> </div></td>
<td><%=screen.getTagOrder()%></td>
</tr>
<tr>
<tr>
<td width="20%"> <div align="right">
<!-- <script language="javascript">swapLang('Search By');</script> -->
<span swlang code="SW000005">Search By</span> </div></td>
<td><%=screen.getTagSearchBy()%></td>
</tr>
<tr>
<td> <div align="right">
<!-- <script language="javascript">swapLang('Key Value');</script> -->
<span swlang code="SW000007">Key Value</span> </div></td>
<td><input type = "text" id = "__valueSearch_data" name="__valueSearch_data">
<button type="button" class="btn btn-primary width100" swlang code="SW013168" onClick="setSubmit();">SEARCH</button></td>
</tr>
<tr>
<td colspan="4"><div align="right"><%=screen.getPageTag()%></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td>
<br>
<table height="" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000" class="inframe">
<tr >
<td width="6%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Employee Code')</script> -->
<span swlang code="SW011939">Employee Code</span></div></td>
<td width="15%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Name_Surname')</script> -->
<span swlang code="SW007745">Name Surname</span></div></td>
<td width="12%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Business Unit 1')</script> -->
<span swlang code="SW010728">Division</span></div></td>
<td width="12%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Business Unit 2')</script> -->
<span swlang code="SW002031">Department</span></div></td>
<td width="12%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Business Unit 3')</script> -->
<span swlang code="SW000052">Section</span></div></td>
<td width="12%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Business Unit 4')</script> -->
<span swlang code="SW011728">Sub Section #1</span></div></td>
<td width="12%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Business Unit 5')</script> -->
<span swlang code="SW011729">Sub Section #2</span></div></td>
<td width="15%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Position')</script> -->
<span swlang code="SW000308">Position</span></div></td>
<td width="15%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Employee Type')</script> -->
<span swlang code="SW000130">Employee Type</span></div></td>
<td width="20%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Employee StartDate')</script> -->
<span swlang code="SW005472">Employee StartDate</span></div></td>
<td width="20%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Date Contract')</script> -->
<span swlang code="SW005476">Date Contract</span></div></td>
<td width="20%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('End Date Contract')</script> -->
<span swlang code="SW005477">End Date Contract</span></div></td>
<td width="20%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Service Year')</script> -->
<span swlang code="SW000230">Service Year</span></div></td>
<td width="20%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Status')</script> -->
<span swlang code="SW000019">Status</span></div></td>
<td width="9%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Approve Employee')</script> -->
<span swlang code="SW005475">Approve Employee</span></div></td>
<td width="9%" nowrap class="title1"><div align="center"><!-- <script language="javaScript">swapLang('Print Contract')</script> -->
<span swlang code="SW005478">Print Contract</span></div></td>
</tr>
<%
CheckNull chk = new CheckNull();
while(screen.nextRec()){
if(screen.checkLinePage()){
screen.referLangOn();
%>
<tr >
<td width="6%" nowrap class=""><div align="center"><%=screen.getString("employeeid")%></div></td>
<td width="15%" nowrap class=""><div align="center"><%=screen.getString("MEMPLOYEE","fullname")%></div></td>
<td width="12%" nowrap class=""><div align="center"><%=screen.getString("mbu1","tdesc")%></div></td>
<td width="12%" nowrap class=""><div align="center"><%=screen.getString("mbu2","tdesc")%></div></td>
<td width="12%" nowrap class=""><div align="center"><%=screen.getString("mbu3","tdesc")%></div></td>
<td width="12%" nowrap class=""><div align="center"><%=screen.getString("mbu4","tdesc")%></div></td>
<td width="12%" nowrap class=""><div align="center"><%=screen.getString("mbu5","tdesc")%></div></td>
<td width="15%" nowrap class=""><div align="center"><%=screen.getString("mposition","tdesc")%></div></td>
<td width="15%" nowrap class=""><div align="center"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("MEMPLOYEE","emp_type")%></div></td>
<td width="20%" nowrap class=""><div align="center"><%=screen.getString("MEMPLOYEE","startdate")%></div></td>
<td width="20%" nowrap class=""><div align="center"><%=screen.getString("STARTDATE")%></div></td>
<td width="20%" nowrap class=""><div align="center"><%=screen.getString("ENDDATE")%></div></td>
<!-- empworkages -->
<% String app_status = chk2.chkNullString(this.getAppstatus(screen.getString("employeeid"),"AP90",screen.getUProfile(),"apsappstatus1"));%>
<td width="20%" nowrap class=""><div align="center"><%=screen.getString("MEMPLOYEE","empworkages")%></div></td>
<td width="20%" nowrap class=""><div align="center"><%=ref.getSystemCode("APPSTATUS","",app_status)%></div></td>
<%
String apsassessor = chk2.chkNullString(this.getAppstatus(screen.getString("employeeid"),"AP90",screen.getUProfile(),"apsassessor"));
String apsid= chk2.chkNullString(this.getAppstatus(screen.getString("employeeid"),"AP90",screen.getUProfile(),"apsid"));
%>
<%if(apsid.equals("")){%>
<td width="9%" nowrap class=""><div align="center"><a href="javascript:goProcess('<%=this.getBossEmail(screen.getString("employeeid"),"email",screen.getUProfile())%>','<%=email_from%>','<%=screen.getString("employeeid")%>');"><img width="20" height="20" align="middle" src="../IMAGES/BUTTON/MAIN/EDIT20.gif" border="0"/></a></div></td>
<%}else{%>
<td width="9%" nowrap class=""><div align="center">-</div></td>
<%}%>
<%if(app_status.equals("A")){%>
<td width="20%" nowrap class=""><div align="center"><a href="javascript:viewPrintPage('<%=screen.getString("employeeid")%>','<%=screen.getString("ATTORNEY")%>','<%=screen.getString("PROMISE_TYPE")%>','<%=screen.getString("PROMISEDATE")%>','<%=screen.getString("STARTDATE")%>','<%=screen.getString("ENDDATE")%>','<%=screen.getString("SALARY")%>','<%=screen.getString("promiseage")%>','<%=screen.getString("JOB")%>');"><img src="../IMAGES/BUTTON/MAIN/PRINTER20.gif" border="0"></a></div></td>
<%}else{%>
<td width="20%" nowrap class=""><div align="center">-</div></td>
<%}%>
</tr>
<%
screen.referLangOff();
}
if(screen.outLinePage()){ break; }
}%>
</table>
</td>
</tr>
<tr><td >
</td></tr>
<tr><td class="bottom">
</td></tr>
</table>
</div>
</form>
</body>
</html>