<%@ page contentType="text/html; charset=UTF-8" language="java" %>
<%@ page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*"  %>
<%@ page import="java.util.*"%>
<%@ include file="../CHECKPROFILE.jsp" %>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="EMP_PROMOTION" class="com.csc.library.system.Task" scope="page" />
<jsp:setProperty name="EMP_PROMOTION" property="appname" value="empview" />
<%
	EMP_PROMOTION.setChannel(request, response);
	response.setDateHeader("Expires", -1);
	response.setHeader("Cache-Control", "no-store, no-cache, must-revalidate");
	response.addHeader("Cache-Control", "post-check=0, pre-check=0");
	response.setHeader("Pragma", "no-cache");

	HelpEntry screen_promotion = (HelpEntry) EMP_PROMOTION.process("HelpEntry", "EMP_PROMOTION");
	if(screen_promotion==null){
		return;
	}
	CscCalendar cal = new CscCalendar();
	CscCalendar ca = null;

	String now_month=cal.getMM();
	String now_date=cal.getDD();
	String now_year=cal.getEngYYYY();

	String filter = "ADJ_TYPE in ('21','22','23','25','26','27','53') AND (SUBSTRING(EFF_DATE,0,8) = '"+now_year+"-"+now_month +"')";
	screen_promotion.getInquiry().setFilter(filter);
	screen_promotion.getInquiry().setOrderBy("SUBSTRING(EFF_DATE,9,2),EMPLOYEEID");
	screen_promotion.getInquiry().refresh();

	String langs = screen_promotion.getUProfile().get("lang");
  InitialEnvironment inv = new InitialEnvironment("GLOBAL");
	String path = inv.getValue("PERSONAL_UPLOAD-dir");
	CheckNull chk = new CheckNull();
	//out.print(filter);
%>
<!DOCTYPE HTML>
<html ng-app="myHR">
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

		<style>
			.emp-supdetail{
				display:block;
				margin-bottom:10px;
			}
			.clients-comments{
				margin-bottom:0px !important;
			}
			.wow{
				min-height: 433px !important;
			}
		</style>
	</head>
	<body>
		<jsp:include page="EMV_HEADMENU.jsp" flush="true" />

		<script type="text/javascript">
			setLang("<%=screen_promotion.getUProfile().get("lang")%>");
			var swap = new swaplang();
			var titlename = swap.swap2String("SW012301");
			setPageTitle(titlename);

           function setSrcimagefile(srcid,urlimg){
				document.getElementById(srcid).src=urlimg;
			}
		</script>

		<section id="Promotion" class="emp">
			<div class="container">
				<div class="center fadeInDown">
					<h2 swlang code="SW012301">Promotion</h2>
				</div>

				<div class="row">
					<%
						DbRecord dbrec = new InitialRecord(screen_promotion.getUProfile()).getDbRecord("memployee");

						String img_default="../UPLOAD/PERSONAL/PICTURE/JCDNNGTF4.png";
						int k=0;
						if(screen_promotion.getInquiry().recCount()>0) {
							String pathfile = "../UPLOAD/PERSONAL/PICTURE/";

							while(screen_promotion.nextRec()){
								k++;
								screen_promotion.referLangOn();
								DbRecord empPic = new InitialRecord(screen_promotion.getUProfile()).getDbRecord("memployee");
								empPic.setColumn("employeeid,picture");
								empPic.set("employeeid", screen_promotion.getString("employeeid"));
								empPic.search();

								// chk เงื่อนไขที่ adj_type == 53 และมีการเปลี่ยน empID ทำให้ออกข้อมูลซ้ำเพราะมีการบรรทึก base ทั้ง empid เก่า และใหม่
								if(screen_promotion.getString("ADJ_TYPE").equals("53")) {
									if(screen_promotion.getString("newemployeeid").equals("") || screen_promotion.getString("employeeid").equals(screen_promotion.getString("newemployeeid"))){
					%>
					<div class="col-md-3 wow fadeInDown">
						<div class="clients-comments text-center">
							<img id="newemp_img<%=screen_promotion.getString("employeeid")%>" src="" class="img-square" alt=""/>
							<h3><%=screen_promotion.getString("memployee","fullname_nopre")%> </h3>
							<div class="emp-detail">
								<%
									if(!screen_promotion.getString("emp_position").equalsIgnoreCase(screen_promotion.getString("old_emp_position"))){
								%>
								<div class="emp-supdetail">
									<p class="detail"><span class="td-bold" swlang code='SW002675'>Old position</span>: <%=screen_promotion.getString("v1mposition","tdesc") %></p>
									<p class="detail"><span class="td-bold" swlang code='SW002676'>New position</span>: <%=screen_promotion.getString("mposition","tdesc") %></p>
								</div>
								<%
									}else if(!screen_promotion.getString("bu5").equalsIgnoreCase(screen_promotion.getString("old_bu5"))){
								%>
								<div class="emp-supdetail">
									<p class="detail"><span class="td-bold"><%=dbrec.getField("bu5").getDescription()%></span><span class="td-bold" swlang code='SW005174'>Old</span>: <%=screen_promotion.getString("v1mbu5","tdesc") %></p>
									<p class="detail"><span class="td-bold"><%=dbrec.getField("bu5").getDescription()%></span><span class="td-bold" swlang code='SW001787'>New</span>: <%=screen_promotion.getString("mbu5","tdesc") %></p>
								</div>
								<%
									}else if(!screen_promotion.getString("workarea").equalsIgnoreCase(screen_promotion.getString("old_workarea"))){
								%>
								<div class="emp-supdetail">
									<p class="detail"><span class="td-bold" swlang code='SW005030'>Old WorkArea</span>: <%=screen_promotion.getString("v1mworkarea","tdesc") %></p>
									<p class="detail"><span class="td-bold" swlang code='SW005035'>New WorkArea</span>: <%=screen_promotion.getString("mworkarea","tdesc") %></p>
								</div>
								<%
									}
								%>
							</div>
						</div>
					</div>
					<script type="text/javascript">
						setTimeout(function(){
							setSrcimagefile('newemp_img<%=screen_promotion.getString("employeeid")%>','<%=empPic.getViewUrl("picture")%>');
						},<%=k*250%>)
					</script>
					<%
									}
								}else{
					%>
					<div class="col-md-3 wow fadeInDown">
						<div class="clients-comments text-center">
							<img id="newemp_img<%=screen_promotion.getString("employeeid")%>" src="" class="img-square" alt=""/>
							<h3><%=screen_promotion.getString("memployee","fullname_nopre")%> </h3>
							<div class="emp-detail">
								<%
									if(!screen_promotion.getString("emp_position").equalsIgnoreCase(screen_promotion.getString("old_emp_position"))){
								%>
								<div class="emp-supdetail">
									<p class="detail"><span class="td-bold" swlang code='SW002675'>Old position</span>: <%=screen_promotion.getString("v1mposition","tdesc") %></p>
									<p class="detail"><span class="td-bold" swlang code='SW002676'>New position</span>: <%=screen_promotion.getString("mposition","tdesc") %></p>
								</div>
								<%
									}else if(!screen_promotion.getString("bu5").equalsIgnoreCase(screen_promotion.getString("old_bu5"))){
								%>
								<div class="emp-supdetail">
									<p class="detail"><span class="td-bold"><%=dbrec.getField("bu5").getDescription()%></span><span class="td-bold" swlang code='SW005174'>Old</span>: <%=screen_promotion.getString("v1mbu5","tdesc") %></p>
									<p class="detail"><span class="td-bold"><%=dbrec.getField("bu5").getDescription()%></span><span class="td-bold" swlang code='SW001787'>New</span>: <%=screen_promotion.getString("mbu5","tdesc") %></p>
								</div>
								<%
									}else if(!screen_promotion.getString("workarea").equalsIgnoreCase(screen_promotion.getString("old_workarea"))){
								%>
								<div class="emp-supdetail">
									<p class="detail"><span class="td-bold" swlang code='SW005030'>Old WorkArea</span>: <%=screen_promotion.getString("v1mworkarea","tdesc") %></p>
									<p class="detail"><span class="td-bold" swlang code='SW005035'>New WorkArea</span>: <%=screen_promotion.getString("mworkarea","tdesc") %></p>
								</div>
								<%
									}
								%>
							</div>
						</div>
					</div>
					<script type="text/javascript">
						setTimeout(function(){
							setSrcimagefile('newemp_img<%=screen_promotion.getString("employeeid")%>','<%=empPic.getViewUrl("picture")%>');
						},<%=k*250%>)
					</script>
					<%
								}
							}
						}
					%>
				</div>
			</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>