<!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> </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> <input type="text" id="MEMPLOYEE@FULLNAME" name="MEMPLOYEE@FULLNAME" value="<%=fullname%>" size="30"> </td> </tr> <tr> <td> </td> <td align="left"> <button type="button" class="btn btn-primary width100" swlang code="SW003537" onClick="search();">SEARCH</button> </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> </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>