<!DOCTYPE html>
<%@ page contentType="text/html; charset=UTF-8" language="java" %>
<%@page import="com.csc.library.entry.EmvHelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@ page import="com.csc.library.entry.*,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","MEMPL_ASSETHELP");
//EmvHelpEntry screen = (EmvHelpEntry) EMV.process("EmvHelpEntry","TRESERV_ASSETHELP");
String lang = screen.getUProfile().get("lang");
//screen.getInquiry().clearSubFilter();
String filter ="1=1";
filter += " and employeeid = '"+screen.getUProfile().get("employeeid").toString()+"'";
CheckNull chk=new CheckNull();
ThaiUtilities thail = new ThaiUtilities();
java.text.DecimalFormat df=new java.text.DecimalFormat("#,###,##0.00");
String condition=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__fixCon")));
String asset1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__asset1")));
String asset2=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__asset2")));
String stdate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__startdate")));
String endate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__enddate")));
if(asset1.trim().length()>0){
/*
((DbInquiry)screen.getInquiry().getChild("TRESERV_ASSET1")).setFilter("assetid",asset1,asset2,"between");
screen.getInquiry().setRequireFoundTable("TRESERV_ASSET1");
*/
((DbInquiry)screen.getInquiry().getChild("MEMPL_ASSET")).setFilter("assetid",asset1,asset2,"between");
screen.getInquiry().setRequireFoundTable("MEMPL_ASSET");
}
if(stdate.trim().length()>0 && endate.trim().length()>0){
String start_date = new CscCalendar(stdate).getYYYYMMDD();
String end_date = new CscCalendar(endate).getYYYYMMDD();
//filter += " and ( '"+start_date+"' >= START_DATE and '"+end_date+"' <= END_DATE or '"+start_date+"' < START_DATE and '"+end_date+"' > END_DATE or '"+end_date+"' > END_DATE and '"+start_date+"' >= START_DATE and '"+start_date+"' <= START_DATE or '"+end_date+"' >= START_DATE and '"+start_date+"' <= START_DATE )";
filter += " and ( '"+start_date+"' >= receivedate and '"+end_date+"' <= returndate or '"+start_date+"' < receivedate and '"+end_date+"' > returndate or '"+end_date+"' > returndate and '"+start_date+"' >= receivedate and '"+start_date+"' <= receivedate or '"+end_date+"' >= receivedate and '"+start_date+"' <= receivedate )";
}
screen.getInquiry().setFilter(filter);
screen.setMaxLine(15);
screen.process();
//screen.getInquiry().setOrderBy("RESERVEID desc");
%>
<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=TIS620" />
</head>
<body>
<div class="bg-com"></div>
<jsp:include page="EMV_HEADMENU.jsp" flush="true" />
<script>
setLang("<%=screen.getUProfile().get("lang")%>");
var swap = new swaplang();
var titlename = swap.swap2String("SW011255");
setPageTitle(titlename);
function goHelp(helpName,inputName){
var helpReturn;
var fcon="";
if(inputName=="__asset1" ){
helpReturn="__asset1:assetid";
}else if(inputName=="__asset2" ){
helpReturn="__asset2:assetid";
}
helpPageCon(helpName,helpReturn,fcon);
}
function GoSearch(){
search();
}
function goPages(page,complainid,caseid){
with(document.cscform){
action=page;
__complainid.value=complainid;
__caseid.value=caseid;
//__fixCon.value="complainid='"+complainid+"' and caseid='"+caseid+"'";
__cmd.value="search";
submit();
}
}
function GoClean1(){
with(document.cscform){
__asset1.value = "";
__asset2.value = "";
__startdate.value="";
__enddate.value= "";
__asset1.focus = true;
}
}
$(document).ready(function(){
$("select").addClass("form-control");
$("#listpage").removeClass("form-control");
//datepicker function
var myLang='<%=screen.getUProfile().get("lang")%>';
if (myLang=="tha"){
$.datepicker.setDefaults($.datepicker.regional['tha']);
}
$("input[name=__startdate]").hover(function(){
$("input[name=__startdate]").datepicker({
dateFormat:"dd-mm-yy",
maxDate:0,
defaultDate:-1,
changeMonth: true,
changeYear: true
});
$("input[name=__enddate]").datepicker("destroy");
});
$("input[name=__enddate]").change(function(){
if ($("input[name=__startdate]").val()>$("input[name=__enddate]").val()){
$("input[name=__startdate]").val($("input[name=__enddate]").val());
} else if ($("input[name=__startdate]").val()==""){
$("input[name=__startdate]").val($("input[name=__enddate]").val());
}
});
$("input[name=__enddate]").hover(function(){
$("input[name=__enddate]").datepicker({
minDate: new Date(ConvertDate($("input[name=__startdate]").val())),
dateFormat:"dd-mm-yy",
changeMonth: true,
changeYear: true
});
});
});
</script>
<section>
<div class="container csc-content">
<form name="cscform" class="form-horizontal" method="post" action="WEL_EMV00301.jsp">
<input name="__cmd" type="hidden" value="">
<input type="hidden" name="__calendar">
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__orderBy" value="">
<input type="hidden" name="__helpReturn" value="">
<input type="hidden" name="__helpName" value="">
<input type="hidden" name="__pageCall" value="">
<input type="hidden" name="__referPage" value="">
<input type="hidden" name="__lockPage" value="">
<input type="hidden" name="__complainid" value="">
<input type="hidden" name="__caseid" value="">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="__employeeid" value="<%=screen.getUProfile().get("employeeid")%>">
<input type="hidden" name="__fixCon" value="">
<input name="__screen" type="hidden" value="WEL_EMV00301">
<div class="csc-block">
<div class="center">
<h2 class="csc-block-head" swlang code='SW011255'>Borrowing the Asset</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"><%=screen.getLabel("masset","assetid")%></label>
</div>
<div class="col-md-2 col-sm-2 col-xs-3">
<div class="input-group">
<input class="form-control" name="__asset1" type="text" size="15" value="<%=asset1%>" />
<a class="input-group-addon" href="javascript:goHelp('MASSETHELP','__asset1');">
<i class="fa fa-search"></i>
</a>
</div>
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right" swlang code='SW005755'>To</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-3">
<div class="input-group">
<input class="form-control" name="__asset2" type="text" size="15" value="<%=asset2%>" />
<a class="input-group-addon" href="javascript:goHelp('MASSETHELP','__asset2');">
<i class="fa fa-search"></i>
</a>
</div>
</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='SW001033'>Date</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-3">
<input class="form-control" name="__startdate" type="text" size="10" maxlength="10" value="<%=stdate%>" onkeypress="chkInteger()" onkeyup="formatDate(this)" onblur="chkInputDate2(this,__enddate)" />
</div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right" swlang code='SW002095'>To</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-3">
<input class="form-control" name="__enddate" type="text" size="10" maxlength="10" value="<%=endate%>" onkeypress="chkInteger()" onkeyup="formatDate(this)" onblur="chkInputDate2(__startdate,this)" />
</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='SW002014'>Order by</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-3">
<%=screen.getTagOrder()%>
</div>
</div>
</div>
<div class="center">
<a class="btn btn-primary" href="javascript:GoSearch();" swlang code='SW003537'>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>
<div class="table-responsive">
<table class="table table-head table-hover table-bordered table-title-left table-content-center">
<thead>
<tr>
<th><%=screen.getLabel("assetid")%></th>
<th><%=screen.getLabel("masset","tdesc")%></th>
<th><%=screen.getLabel("masset","edesc")%></th>
<th><%=screen.getLabel("receivedate")%></th>
<th><%=screen.getLabel("returndate")%></th>
<th><%=screen.getLabel("remarks")%></th>
<th><%=screen.getLabel("treturndate")%></th>
</tr>
</thead>
<tbody>
<%
while (screen.nextRec()) {
%>
<tr>
<td><%=screen.getString("assetid")%></td>
<td><%=screen.getString("masset","tdesc")%></td>
<td><%=screen.getString("masset","edesc")%></td>
<td><%=screen.getString("receivedate")%></td>
<td><%=screen.getString("returndate")%></td>
<td><%=screen.getString("remarks")%></td>
<td><%=screen.getString("treturndate")%></td>
</tr>
<%
}
%>
</tbody>
</table>
</div>
</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>