<!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.utilities.*,com.csc.library.database.*"%>
<%@page import="com.csc.library.session.*"%>
<%@page import="com.csc.library.components.*"%>
<jsp:useBean id="PRU091" class="com.csc.library.system.Task" scope="page" />
<jsp:useBean id="task" class="com.csc.library.system.Task" scope="session" />
<%
task.setChannel(request, response);
UIManager screensave = (UIManager) task.process("SingleEntry", "PRU091");
PRU091.setChannel(request, response);
HelpEntry screen = (HelpEntry) PRU091.process("HelpEntry", "TREQ_CERTIFICATEHELP");
screen.setMaxLine(-1);

CheckNull chk = new CheckNull();
String[][] certtype = SystemCode.getContent("cert_type");
String[][] isprint = SystemCode.getContent("isprint");
CscCalendar csc = new CscCalendar();
String reqDate = chk.chkNullString(request.getParameter("req_date"), "all");
String empid = chk.chkNullString(request.getParameter("empid"));
String fullname = chk.chkNullString(request.getParameter("MEMPLOYEE@FULLNAME"));

String is_print = "0";

String cmd = chk.chkNullString( request.getParameter("__cmd"));
String rowRec = chk.chkNullString( request.getParameter("__rowRec"));

if(cmd.equals("delete")){
	String[] row = rowRec.split(",");
	DbRecord db = new InitialRecord(screen.getUProfile()).getDbRecord("treq_certificate");
	db.setColumn("employeeid,companyid,req_id,isprint");
	for(int i=0 ; i<row.length ; i++){
		String req_id = row[i].split("#")[0];
		String emp_id = row[i].split("#")[1];
		try{

			db.set("employeeid", emp_id);
			db.set("companyid", screen.getUProfile().get("companyid").toString());
			db.set("req_id", req_id);

			if(db.search() == 1){
				db.set("isprint", "1");
				db.save();

			}
		} catch (Exception ex) {

		}
	}
}

String filter = "";
if (!reqDate.equals("all")) {
	filter += " and create_date like '" + reqDate + "-%'";
}
if (!empid.equals("")) {
	filter += " and employeeid = '" + empid + "'";
}
/*******************************************************/
//			Add Security 
String sql_security = "";
try {
	DbRecord rec_emp = new InitialRecord(screen.getUProfile()).getDbRecord("memployee");
	rec_emp.setColumn("*");
	rec_emp.set("employeeid", screen.getUProfile().get("employeeid"));
	rec_emp.set("companyid", screen.getUProfile().get("companyid"));
	rec_emp.search();
	RSecurityManager rm = rec_emp.getSecurity();
	sql_security = rm.inquiryBefor(rec_emp);
} catch (Exception e) {}
if (sql_security.length()>0) {
	sql_security = " and employeeid in (select employeeid from memployee where "+sql_security+" ) ";
}
/*******************************************************/
screen.getInquiry().setFilter("isprint = '" + is_print + "'" + filter + sql_security);
screen.process();
%>

<%!
public String getFullname(String employeeid,UProfile screen){
	String data="";


	try{
//
		String lang = screen.get("lang");
		String sql;

		if (lang.equalsIgnoreCase("Tha")){
			sql="SELECT mprefix.tdesc,memployee.fname,memployee.lname FROM memployee INNER JOIN mprefix ON memployee.emp_prefix=mprefix.prefixid where employeeid='"+employeeid+"'";

			String dbName = screen.getDbName();
			String tableName = "memployee";
			DataSet ds = new DataSet(sql,dbName,tableName);
			ds.setFetchAll(false);
			ds.initConnection(screen);

			while(ds.next()){
				data = ds.getString("tdesc");
				data = data+""+ds.getString("fname");
				data = data+"  "+ds.getString("lname");
			}

 		}
		else {
			sql="SELECT mprefix.edesc,memployee.efname,memployee.elname FROM memployee INNER JOIN mprefix ON memployee.emp_prefix=mprefix.prefixid where employeeid='"+employeeid+"'";

			String dbName = screen.getDbName();
			String tableName = "memployee";
			DataSet ds = new DataSet(sql,dbName,tableName);
			ds.setFetchAll(false);
			ds.initConnection(screen);

			while(ds.next()){
				data = ds.getString("edesc");
				data = data+""+ds.getString("efname");
				data = data+"  "+ds.getString("elname");
			}

		}




//		if (lang.equalsIgnoreCase("eng")){
//			 sql="SELECT mprefix.tdesc,memployee.fname,memployee.lname FROM memployee INNER JOIN mprefix ON memployee.emp_prefix=mprefix.prefixid where employeeid='"+employeeid+"'";
//		}
//		else {
//			 sql="SELECT mprefix.edesc,memployee.efname,memployee.elname FROM memployee INNER JOIN mprefix ON memployee.emp_prefix=mprefix.prefixid where employeeid='"+employeeid+"'";
//
//		}

////		String sql="SELECT mprefix.tdesc,memployee.fname,memployee.lname FROM memployee INNER JOIN mprefix ON memployee.emp_prefix=mprefix.prefixid where employeeid='"+employeeid+"'";
//		String dbName = screen.getDbName();
//		String tableName = "memployee";
//		DataSet ds = new DataSet(sql,dbName,tableName);
//		ds.setFetchAll(false);
//		ds.initConnection(screen);
//
//		while(ds.next()){
//
//			if (lang.equalsIgnoreCase("eng")){
//				data = ds.getString("edesc");
//				data = data+""+ds.getString("efname");
//				data = data+"  "+ds.getString("elname");
//			}
//			else {
//				data = ds.getString("tdesc");
//				data = data+""+ds.getString("fname");
//				data = data+"  "+ds.getString("lname");
//			}
////			data = ds.getString("tdesc");
////			data = data+""+ds.getString("fname");
////			data = data+"  "+ds.getString("lname");
//		}
	}catch(Exception e){
		return "";
	}
	return data;
}
%>
<html ng-app="myHR">
	<head>
		<title><%=screen.getInquiry().getCurrentDbRecord().getDescription()%></title>
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
		<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"/>
		<script  language="JavaScript" src="../JS/SCREEN.js"></script>
		<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 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/MYNOTE_SCREEN.js'></SCRIPT>
		<script src="../JS/VIEWCALENDAR.js"></script>
		<script type='text/javascript' src='/hr/dwr/interface/WordExportFile.js'></script>
		<script type='text/javascript' src='/hr/dwr/engine.js'></script>
		<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
		<script language="JavaScript" type="text/JavaScript">

		function GoSearch() {
			search();
		}

		function goHelp(helpName,inputName) {
			var helpReturn;
			var fixCon = "";
			if (inputName == "empid") {
				helpReturn = "empid:employeeid,MEMPLOYEE@FULLNAME";
				fixCon = "employeeid in(select employeeid from TREQ_CERTIFICATE where isprint='0')";
			}
			linkHelp_Return(helpName, helpReturn, fixCon);
		}

		function GoSave(){
			alert(MyCode[150]);
		}

		function GoDelete(){
			alert(MyCode[150]);
		}

		function deleteRow(){
			with(document.cscform){
				//		alert(555);
				if (confirm('ต้องการลบข้อมูลหรือไม่')) {
					setData();
					submit();
				}
			}
		}

		function setData(){
			with(document.cscform){
				var rowRec = "";
				for(i=0;i<elements.length;i++){
					if(elements[i].type=="checkbox"){
						if(elements[i].checked==true){
							rowRec+= elements[i].value+",";
						}
					}
				}
				//alert("rowRec : "+rowRec);
				__cmd.value = "delete";
				__rowRec.value = rowRec;
			}
		}

		function prePrintWord(empid, templatefile, cert_type, templatelang, req_id) {
			if (templatefile !== ' ') {
				var param="PRU091_PEX.jsp?__employeeid="+empid+"&__cert_type="+cert_type+"&__templatelang="+templatelang+"&__req_id="+req_id;
				window.open(param,"Help","left=150,top=150,width=680,height=200,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
			} else {
				var msg = getLang() === "THA" ? "กรุณาเพิ่มไฟล์แม่แบบในระบบ" : "Please Add Template File.";
				alert(msg);
			}
		}

		function printWord(templatefile, udf1, udf2, filter_dbxml) {
			var dbxml = "WORDPARAMHELP";
			WordExportFile.getWordFile(new Array(templatefile, udf1, udf2, dbxml, filter_dbxml),function(data){
				if(data !== ""){
					window.open(data);
				} else {
					var msg = getLang() === "THA" ? "ไม่มีไฟล์แม่แบบในระบบ" : "No Template File.";
					alert(msg);
				}
			});
		}
		</script>
	</head>
	<%
	String helpReturn="";
	if(request.getParameter("__helpReturn")!=null){
		helpReturn=request.getParameter("__helpReturn");
	}
	%>
	<body leftmargin="0" topmargin="0">
		<form name="cscform" method="post" action="PRU091.jsp" >
			<!----------BEGIN CSC INITIAL ZONE ------------------------>

			<%=screensave.InitialVariable()%>

			<!----------END CSC INITIAL ZONE -------------------------->
			<input type="hidden" name="__cmd" value=""/>
			<input type="hidden" name="__help" value=""/>
			<input type="hidden" name="__notNull" value="<%=screensave.getRequire()%>"/>
			<input type="hidden" name="__pageCall" value=""/>
			<input type="hidden" name="__referPage" value=""/>
			<input type="hidden" name="__language" value='<%=screen.getUProfile().get("lang")%>'/>
			<input type="hidden" name="__calendar"/>
			<input type="hidden" name="__screen" value="PRU091"/>
			<script language="javascript">getInputFormatDate();</script>
			<input type="hidden" name="__fixCon"  value=""/>
			<input type="hidden" name="__user" value="<%=screen.getUProfile().getUserId()%>"/>
			<input type="hidden" name="__gorec" value='<%=chk.chkNullString(request.getParameter("__gorec"))%>'/>
			<input type="hidden" name="__companyid" value='<%=screen.getUProfile().get("companyid")%>'/>
			<input type="hidden" name="__ack" value=""/>
			<input type="hidden" name="__isprint" value="0"/>
			<input type="hidden" name="__rowRec" value=""/>

			<br/>
			<table height="" align="center" cellpadding="0" cellspacing="0" border="0" class="large">
				<tr bgcolor="#3366CC">
					<td height="20" class="header">PRU091, <span swlang code="SW005456">Certificate printing</span>&nbsp;</td>
				</tr>
				<tr>
					<td colspan="2">
						<div align="center">
							<table class="inframe">
								<tr>
									<td align="right" style="width: 30%;"><%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"ค้นหาตามปีที่ออกรายงาน":"Report Year"%></td>
									<td align="left">
										<select id="req_date" name="req_date">
											<option value="all"><%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"ทั้งหมด":"All"%></option>
											<%
											int year = new CscCalendar().getYear();
											for (byte i = -4; i <= 0; i++) {
												out.print("<option value=\"" + (year + i) + "\">" + (year + i) + "</option>");
											}
											%>
										</select>
									</td>
								</tr>
								<tr>
									<td align="right"><%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"ค้นหาตามรหัสพนักงาน":"Employee ID"%></td>
									<td align="left">
										<input type="text" id="empid" name="empid" value="<%=empid%>" size="15"/>
										<a href="javascript:goHelp('MEMPLOYEEHELP','empid');" 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>
										&nbsp;
										<input type="text" id="MEMPLOYEE@FULLNAME" name="MEMPLOYEE@FULLNAME" value="<%=fullname%>" size="30">
									</td>
								</tr>
								<tr>
									<td>&nbsp;</td>
									<td align="left">
										<button type="button" class="btn btn-primary width100" swlang code="SW003537" onClick="search();">SEARCH</button>&nbsp;
									</td>
								</tr>
							</table>
							<table height="" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000" class="inframe" >
								<tr bgcolor="#3366CC">
									<td width="36" class="row3" rowspan="2">
										<div align="center">
											<lable swlang code ="SW000289">Del</lable>
										</div>
									</td>
									<td class="row3" rowspan="2">
										<div align="center">
											<lable swlang code ="SW000011">Code</lable>
										</div>
									</td>
									<td class="row3" rowspan="2">
										<div align="center">
											<%=screen.getUProfile().get("lang").equalsIgnoreCase("THA") ? "ชื่อ - นามสกุล" : "Name - SurName" %>
										</div>
									</td>
									<td class="row3" rowspan="2">
										<div align="center">
											<lable swlang code = "SW000352">Doc Type</lable>
										</div>
									</td>
									<td class="row3" rowspan="2">
										<div align="center">
											<lable swlang code = "SW003359">Request Date</lable>
										</div>
									</td>
									<td class="row3" colspan="4" width="80">
										<div align="center">
											<lable swlang code ="SW005495"></lable>
										</div>
									</td>
									<td class="row3" rowspan="2">
										<div align="center">
											<lable swlang code = "SW005494">Request Reason</lable>
										</div>
									</td>
								</tr>
								<tr bgcolor="#3366CC">
									<td width="36" class="row3">
										<div align="center">
											<lable swlang code ="SW000840">Thai</lable>
										</div>
									</td>
									<td width="36" class="row3">
										<div align="center">
											<lable swlang code ="SW013180">Print</lable>
										</div>
									</td>
									<td width="36" class="row3">
										<div align="center">
											<lable swlang code ="SW002129">English</lable>
										</div>
									</td>
									<td width="36" class="row3">
										<div align="center">
											<lable swlang code ="SW013180">Print</lable>
										</div>
									</td>
								</tr>
								<%
								int i = 1;
								while(screen.nextRec()){
									if(screen.checkLinePage()){
										screen.referLangOff();
										%>
										<tr>
											<td nowrap class="forborder2">
												<div align="center"><input type="checkbox" name="chkbox$<%=i%>" value='<%=screen.getString("REQ_ID")+"#"+screen.getString("EMPLOYEEID")%>'></div>
											</td>
											<td nowrap class="forborder2">
												<div align="center"><%=screen.getString("REQ_ID")%></div>
											</td>
											<td nowrap class="forborder2">
												<div align="center"><%=getFullname(screen.getString("EMPLOYEEID"), screen.getUProfile())%></div>
											</td>
											<td nowrap class="forborder2">
												<div align="center">
													<%=screen.getInquiry().getCurrentDbRecord().getSystemCode("CERT_TYPE")%>
													<%
													if (screen.getString("CERT_TYPE").equals("3") || screen.getString("CERT_TYPE").equals("4") || screen.getString("CERT_TYPE").equals("5")) {
														out.print(screen.getString("CERTIFICATE_DESC" + screen.getString("CERT_TYPE")));
													}
													%>
												</div>
											</td>
											<td nowrap class="forborder2">
												<div align="center"><%=screen.getString("CREATE_DATE")%></div>
											</td>
											<td nowrap class="forborder2">
												<div align="center"><%=screen.getString("TRES1")%></div>
											</td>
											<td nowrap class="forborder2">
												<div align="center">
													<%if (!screen.getString("TRES1").equals("0")) {%>
													<a href="javascript:prePrintWord('<%=screen.getString("EMPLOYEEID")%>','<%=screen.getString("TREQ_CERTIFICATE_TEMPLATE","TEMPLATE_THA")%>','<%=screen.getString("TREQ_CERTIFICATE_TEMPLATE","CERT_TYPE")%>','THA','<%=screen.getString("REQ_ID")%>');"><img src="../IMAGES/BUTTON/MAIN/PRINTER24.gif" border="0"/></a>
													<%}%>
												</div>
											</td>
											<td nowrap class="forborder2">
												<div align="center"><%=screen.getString("ERES0")%></div>
											</td>
											<td nowrap class="forborder2">
												<div align="center">
													<%if (!screen.getString("ERES0").equals("0")) {%>
													<a href="javascript:prePrintWord('<%=screen.getString("EMPLOYEEID")%>','<%=screen.getString("TREQ_CERTIFICATE_TEMPLATE","TEMPLATE_ENG")%>','<%=screen.getString("TREQ_CERTIFICATE_TEMPLATE","CERT_TYPE")%>','ENG','<%=screen.getString("REQ_ID")%>');"><img src="../IMAGES/BUTTON/MAIN/PRINTER24.gif" border="0"></a>
													<%}%>
												</div>
											</td>
											<td nowrap class="forborder2">
												<div align="center"><%=screen.getString("REASON")%></div>
											</td>
										</tr>
										<%
										i++;
									}
									if (screen.outLinePage()) {
										break;
									}
								}
								%>
								<input type="hidden" name="rowRecord" value="<%=i%>"/>
							</table>
						</div>
					</td>
				</tr>
				<tr>
					<td class="blankspace"></td>
				</tr>
				<tr bordercolor="0069B3">
					<td class="blankspace">
						<div align="center">
							<button type="button" class="btn btn-primary width100" swlang code="SW000123" onClick="deleteRow();">DELETE</button>&nbsp;
						</div>
					</td>
				</tr>
				<tr>
					<td class="blankspace"></td>
				</tr>
				<tr>
					<td class="bottom"></td>
				</tr>
				<script language="javascript">
				setValue('__certtype','<%=chk.chkNullString(request.getParameter("__certtype"))%>');
				setValue('__isprint','<%=chk.chkNullString(request.getParameter("__isprint"))%>');
				</script>
			</table>

			<!----------BEGIN CSC ENDING ZONE ------------------------>

			<%=screensave.endJSP()%>

			<!----------END CSC ENDING ZONE -------------------------->

			<script src="../JS/jquery-1.11.3.min.js"></script>
			<script>
			$(function () {
				$('select#req_date').val('<%=reqDate%>');
			});
			</script>
		</form>
	</body>
</html>