<%@ 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.*" %>
<% 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","TRESERV_ASSETHELP");
String lang = screen.getUProfile().get("lang");
screen.getInquiry().clearSubFilter();
//screen.getInquiry().setFilter("owner_treserve",screen.getUProfile().get("employeeid").toString(),"","between");
CscCalendar c = new CscCalendar();
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")));
String status = thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__lst_status")));
//out.println("<br><br>status" + request.getParameter("__lst_status"));
String filter ="1=1";
if(!status.equals("3") && !status.equals("")){
filter += "and status='"+status+"'";
screen.getInquiry().setFilter(filter);
}
if(asset1.trim().length()>0){
((DbInquiry)screen.getInquiry().getChild("TRESERV_ASSET1")).setFilter("assetid",asset1,asset2,"between");
screen.getInquiry().setRequireFoundTable("TRESERV_ASSET1");
}
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 )";
screen.getInquiry().setFilter(filter);
}
screen.setMaxLine(15);
screen.process();
%>
<html>
<head>
<title></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>
<script type='text/javascript' src="../JS/ICONSMENU.js"></script>
<script language='javascript' src="../JS/HOTKEY.js"></script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="JavaScript" type="text/JavaScript">
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 goPageDetail(reservid){
with(document.cscform){
var pageDtetail = "WEL_EMV003011";
window.open(pageDtetail+".jsp?__reserveid="+reservid+"&__employeeid="+__employeeid.value,"Child","left=150,top=20,width=800,height=500,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
function GoClean1(){
with(document.cscform){
__asset1.value = "";
__asset2.value = "";
__startdate.value="";
__enddate.value= "";
__lst_status.value = "3";
__asset1.focus = true;
}
}
function GoPageAsset(reservid,companyid){
with(document.cscform){
action = "WEL31601.jsp";
__help.value = "__reservid#"+reservid+";__companyid#"+companyid+";";
__reservid.value = reservid;
__companyid_reserv.value = companyid;
//alert(__help.value);
__cmd.value = "search";
submit();
}
//alert(reservid + " : " + companyid);
}
function GoClean(){
GoClean1();
}
function setLstStatus(mode){
with(document.cscform){
if(mode == "1"){
__lst_status.value = __status_s.value;
}else{
__lst_status.value = "3";
}
}
}
function updateRec(rec){
document.getElementById("rec_count").innerHTML = rec;
}
function GoSave(){}
function GoDelete(){}
</script>
</head>
<body onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')" >
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" action="WEL31701.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<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 type="hidden" name="__calendar" value="">
<input name="__screen" type="hidden" value="WEL31701">
<input type="hidden" name="__status_s" value="<%=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__lst_status")))%>">
<input type="hidden" name="__reservid" value="">
<input type="hidden" name="__companyid_reserv" value ="">
<script language="JavaScript" src="../JS/HOTKEY.js"></script>
<script language="javascript">
var titlename=swap2String('Borrow of asset');
document.write(Icons("WEL31701,"+titlename));
</script>
<br>
<table class="maxsize"cellpadding="0" cellspacing="0" class="largest">
<tr >
<td colspan="4" class="header" >WEL31701,
<script language="javascript">swapLang(titlename);</script>
</td>
</tr>
<tr>
<td width="645" class="blankspace"></td>
</tr>
<tr>
<td><table width="638" border="0" align="center" cellpadding="0" cellspacing="1" class="inframe">
<tr>
<td colspan="2" class="blankspace"></td>
</tr>
<tr>
<td width="157" class="columnlabel"><%=screen.getLabel("masset","assetid")%></td>
<td width="1029"><input name="__asset1" type="text" size="15" value="<%=asset1%>" />
<a href="javascript:goHelp('MASSETHELP','__asset1');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image32','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image32" width="20" border="0" align="absmiddle" id="Image32" /></a> -
<input name="__asset2" type="text" size="15" value="<%=asset2%>" />
<a href="javascript:goHelp('MASSETHELP','__asset2');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image321','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image321" width="20" border="0" align="absmiddle" id="Image32" /></a></td>
</tr>
<tr>
<td width="157" class="columnlabel"><script language="javascript">swapLang('Date Between');</script></td>
<td width="1029"><input name="__startdate" type="text" size="10" maxlength="10" value="<%=stdate%>" onkeypress="chkInteger()" onkeyup="formatDate(this)" onblur="chkInputDate2(this,__enddate)" />
<a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image12','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image12" width="20" border="0" align="absmiddle" id="Image12" onclick="viewCal('__startdate')" /></a> -
<input name="__enddate" type="text" size="10" maxlength="10" value="<%=endate%>" onkeypress="chkInteger()" onkeyup="formatDate(this)" onblur="chkInputDate2(__startdate,this)" />
<a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image121','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image121" width="20" border="0" align="absmiddle" id="Image12" onclick="viewCal('__enddate')" /></a></td>
</tr>
<tr>
<td width="157" class="columnlabel"><script language="javascript">swapLang('Order By');</script></td>
<td width="1029"><%=screen.getTagOrder()%></td>
</tr>
<tr>
<td width="157" class="columnlabel"><script language="javascript">swapLang('Status');</script></td>
<td width="1029"><select name="__lst_status">
<option value="3"><script language="javascript">swapLang('Show_All');</script></option>
<option value="0"><script language="javascript">swapLang('Borrow');</script></option>
<option value="1"><script language="javascript">swapLang('Return_Asset');</script></option>
<option value="2"><script language="javascript">swapLang('Cancel_Asset');</script></option>
</select></td>
</tr>
<tr>
<td width="157" class="columnlabel"> </td>
<td width="1029"><a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif" alt="Search" width="73" height="23" border="0" align="absmiddle" /></a> <a href="javascript:GoClean1();"><img src="../IMAGES/BUTTON/CLEAR.gif" alt="Search" width="73" height="23" border="0" align="absmiddle" /></a></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table></td>
</tr>
<tr>
<td>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" class="inframe">
<tr>
<td><script language="JavaScript" type="text/javascript">swapLang("Found Data");</script> : <span id="rec_count"></span> <script language="JavaScript" type="text/javascript">swapLang("record(s)");</script></td>
<td><div align="right"><script language="JavaScript" type="text/javascript">swapLang("Page");</script> : <%=screen.getPageTag()%></div></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="11" colspan="4" class="blankspace">
<table width="638" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#808080" class="inframe">
<tr class="title1">
<td width="100" nowrap class="row3" align="center"><%=screen.getLabel("reserveid")%></td>
<td width="80" nowrap class="row3" align="center"><%=screen.getLabel("start_date")%></td>
<td width="50" nowrap class="row3" align="center"><%=screen.getLabel("start_time")%></td>
<td width="80" nowrap class="row3" align="center"><%=screen.getLabel("end_date")%></td>
<td width="50" nowrap class="row3" align="center"><%=screen.getLabel("end_time")%></td>
<td width="30" nowrap class="row3" align="center"><%=screen.getLabel("status")%></td>
<td width="50" nowrap class="row3" align="center"><%=screen.getLabel("treserv_assettype")%></td>
<td width="120" nowrap class="row3" align="center"><%=screen.getLabel("reference_asset")%></td>
</tr>
<%
int inc=0;
while (screen.nextRec()) {
inc++; %>
<tr>
<td align="center"><a href="javascript:GoPageAsset('<%=screen.getString("reserveid")%>','<%=screen.getString("companyid")%>');"><%=screen.getString("reserveid")%></a></td>
<td align="center"><%=screen.getString("start_date")%></td>
<td align="center"><%=screen.getString("start_time")%></td>
<td align="center"><%=screen.getString("end_date")%></td>
<td align="center"><%=screen.getString("end_time")%></td>
<td align="center"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("status")%></td>
<td align="center"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("treserv_assettype")%></td>
<td align="center"><%=screen.getString("reference_asset")%></td>
</tr>
<%
}
%>
</table></td>
</tr>
<tr>
<td colspan="4"> </td>
</tr>
<tr>
<td colspan="4" class="bottom"></td>
</tr>
</table>
<br>
<script language="JavaScript" type="text/javascript">updateRec('<%=inc%>');</script>
<%if(request.getParameter("__cmd") == null){ %>
<script language="JavaScript" type="text/javascript">setLstStatus('2');</script>
<%}else{%>
<script language="JavaScript" type="text/javascript">setLstStatus('1');</script>
<%}%>
</form>
</body>
</html>