<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.utilities.*"%>
<jsp:useBean id="WEL028" class="com.csc.library.system.Task" scope="page" />
<%
WEL028.setChannel(request, response);
HelpEntry screen = (HelpEntry) WEL028.process("HelpEntry","WEL028");
screen.setMaxLine(20);
screen.inq.setFilter("status='0' and approvestatus<>'0' and approvestatus<>'1' and employeeid='"+screen.getUProfile().get("employeeid")+"' and approvestatus<>'3' ");
screen.process();
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 welid1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__welid1")));
String welid2=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__welid2")));
String stdate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__startdate")));
String endate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__enddate")));
String keyword=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__keyword")));
%>
<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 language='javascript' src="../JS/VIEWCALENDAR.js"></script>
<script language='javascript' src="../JS/ICONSMENU.js"></script>
<script language='javascript' src="../JS/HOTKEY.js"></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="JavaScript" type="text/JavaScript">
<!--
function postnew(page){
with(document.cscform){
open(page,"post","height=420,width=600");
}
}
function helpSearch(empid,docno,formula){
with(document.cscform){
//alert("empid="+empid+",docno="+docno+",formula="+formula);
__help.value="__employeeid#"+empid+",__docno#"+docno+",__formulaid#"+formula+",__companyid#"+__companyid.value;
__lockPage.value="true";
alert("__help="+__help.value);
action="PRU071.jsp";
submit();
}
}
function gotopage(page,idno){
with(document.cscform){
action=page;
__webid.value=idno;
__fixCon.value="webid='"+idno+"'";
__cmd.value="search";
__readposter.value="count";
submit();
}
}
function gotopage1(page,idno,caseid,empid){
with(document.cscform){
action=page;
__complainid.value=idno;
__fixCon.value="complainid='"+idno+"' and caseid='"+caseid+"' and employeeid='"+empid+"'";
__cmd.value="search";
submit();
}
}
function GoSave() {}
function GoDelete(){}
function setFixCon(fixCon){
var _fix=(fixCon.length>0)?(fixCon+" and status='0' and approvestatus<>'0' and approvestatus<>'1' and employeeid='<%=screen.getUProfile().get("employeeid")%>' and approvestatus<>'3' ") : ("status='0' and approvestatus<>'0' and approvestatus<>'1' and employeeid='<%=screen.getUProfile().get("employeeid")%>' and approvestatus<>'3' ");
return _fix;
}
function GoSearch()
{
with(document.cscform)
{
if(__welid1.value=="" && __welid2.value=="" && __startdate.value=="" && __enddate.value=="")
{
__fixCon.value="";
}
else if(__welid1.value=="" && __welid2.value!="" || __welid1.value!="" && __welid2.value=="" || __startdate.value=="" && __enddate.value!="" || __startdate.value!="" && __enddate.value=="")
{
alert("Invalid Input!!");
}
else if(__startdate.value=="" && __enddate.value=="")
{
if(__welid1.value>__welid2.value)
{
var tmp=__welid2.value;
__welid2.value=__welid1.value;
__welid1.value=tmp;
}
__fixCon.value="(welid>='"+__welid1.value+"') and (welid<='"+__welid2.value+"')";
}
else if(__welid1.value=="" && __welid2.value=="")
{
var stdate="";
var endate="";
stdate=chkDateTime2(__startdate.value,"-");
endate=chkDateTime2(__enddate.value,"-");
if(stdate>endate)
{
var tmp=endate;
endate=stdate;
stdate=tmp;
}
__fixCon.value="(STARTDATE >='"+stdate+"') and (ENDDATE <='"+endate+"')";
}
else
{
var stdate="";
var endate="";
stdate=chkDateTime2(__startdate.value,"-");
endate=chkDateTime2(__enddate.value,"-");
if(__welid1.value>__welid2.value)
{
var tmp=__welid2.value;
__welid2.value=__welid1.value;
__welid1.value=tmp;
}
if(stdate>endate)
{
var tmp=endate;
endate=stdate;
stdate=tmp;
}
__fixCon.value="(welid>='"+__welid1.value+"') and (welid<='"+__welid2.value+"') and (startdate>='"+stdate+"') and (enddate<='"+endate+"')";
}
__fixCon.value=setFixCon(__fixCon.value);
search();
}
}
function GoUpdate(){}
function goHelp(helpName,inputName){
var helpReturn;
if(inputName=="__welid1" )
helpReturn="__welid1:WELID,MWELFARE@WELID";
else if(inputName=="__welid2" )
helpReturn="__welid2:WELID,MWELFARE@WELID";
helpPageCon(helpName,helpReturn,"");
}
//-->
</script>
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif')">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<script language="JavaScript">getInputFormatDate();</script>
<input type="hidden" name="__calendar">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" 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="__orderBy" value="<%=request.getParameter("__orderBy")%>">
<input name="__language" type="hidden" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__lockPage" value="">
<input type="hidden" name="__employeeid" value="">
<input type="hidden" name="__docno" value="">
<input type="hidden" name="__formulaid" value="">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="__webid" value="">
<input type="hidden" name="__complainid" value="">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__reader" value="">
<input type="hidden" name="__readposter" value="">
<input name="__screen" type="hidden" value="WEL028">
<script language="javascript">
var titlename=swap2String('Webboard of requisition');
document.write(Icons("WEL028,"+titlename));
</script>
<br>
<br>
<div align="center">
<table class="large" cellpadding="0" cellspacing="0">
<tr ><td class="header" >WEL028, <script language="javascript">swapLang('Webboard of requisition');</script> </td></tr>
<tr > <td ><table class="inframe" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td colspan="11" class="blankspace">
<table border="0" align="center" cellpadding="0" cellspacing="1" class="inframe">
<tr class="maxsize">
<td nowrap class="columnlabel_baseline"> <strong>
<script language="javascript">swapLang('Order By');</script>
</strong></td>
<td nowrap><%=screen.getTagOrder()%></td>
</tr>
<tr>
<td class="columnlabel_baseline"><script language="javascript">swapLang('Welfare ID');</script> </td>
<td><input name="__welid1" type="text" size="15" value="<%=welid1%>">
<a href="javascript:goHelp('MWELFAREHELP','__welid1');" 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="__welid2" type="text" size="15" value="<%=welid2%>">
<a href="javascript:goHelp('MWELFAREHELP','__welid2');" 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 class="columnlabel_baseline"><script language="javascript">swapLang('Date Between');</script> </td>
<td><input name="__startdate" type="text" size="10" readonly value="<%=stdate%>">
<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" readonly value="<%=endate%>">
<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 class="columnlabel_baseline">Keyword </td>
<td><input name="__keyword" type="text" size="30" value="<%=keyword%>" >
<a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif" border="0"></a></td>
</tr>
<tr>
<td colspan="2" class="columnlabel_baseline2"><div align="right"></div></td>
</tr>
</table>
<div align="right"><%=screen.getPageTag()%>
<table border="0" cellpadding="0" cellspacing="1" bgcolor="#808080" class="inframe">
<tr class="title1">
<td width="4%" nowrap class="title1"> </td>
<td width="6%" nowrap class="title1"><div align="center" ><%=screen.getLabel("STARTDATE")%></div></td>
<td width="4%" nowrap class="title1"><div align="center"><%=screen.getLabel("ENDDATE")%></div></td>
<td width="5%" nowrap class="title1"><div align="center"><%=screen.getLabel("COMPLAINID")%></div></td>
<td width="4%" nowrap class="title1"><div align="center"><%=screen.getLabel("CASEID")%></div></td>
<td width="6%" nowrap class="title1">
<div align="center"><%=screen.getLabel("WELID")%></div></td>
<td width="19%" nowrap class="title1"><div align="center"><%=screen.getLabel("CASEDESC")%></div></td>
<td width="30%" nowrap class="title1"><div align="center"><%=screen.getLabel("MEMPLOYEE","FNAME")%><%=screen.getLabel("MEMPLOYEE","LNAME")%></div></td>
<td width="8%" nowrap class="title1"><div align="center"><%=screen.getLabel("MWELFARE","QUANTITY")%></div></td>
<td width="8%" nowrap class="title1"><div align="center"><%=screen.getLabel("COST")%></div></td>
<td width="8%" nowrap class="title1"><div align="center"><%=screen.getLabel("STATUS")%></div></td>
</tr>
<%
String webid="";
int n=0;
int i=0;
double j=0;
double quantity=0,qty=0;
double cost=0,cst=0;
%>
<%while (screen.nextRec()) {
if(screen.checkLinePage()){
if(screen.getString("webid").length()>0){
webid+="'"+screen.getString("webid")+"',";
}
i++;
quantity+=Double.parseDouble(chk.chkNullString(screen.getString("MWELFARE","QUANTITY"),"0"));
cost+=Double.parseDouble(chk.chkNullString(screen.getString("COST"),"0"));
qty=Double.parseDouble(chk.chkNullString(screen.getString("MWELFARE","QUANTITY"),"0"));
cst=Double.parseDouble(chk.chkNullString(screen.getString("COST"),"0"));
%>
<tr>
<td nowrap><span class="blankspace style1"><%if(screen.getString("webid").length()>0){%><a href="javascript:gotopage('WEL025.jsp','<%=screen.getString("webid")%>');"><img src="../IMAGES/IINDEX.gif" alt="อ่านกระทู้เฉพาะเรื่อง" width="16" height="16" border="0"></a><%}%></span></td>
<td nowrap><div align="center"><%=screen.getString("STARTDATE")%></div></td>
<td nowrap><div align="center"> <%=screen.getString("ENDDATE")%></div></td>
<td><div align="center"><a href="javascript:gotopage1('WEL017.jsp','<%=screen.getString("COMPLAINID")%>','<%=screen.getString("CASEID")%>','<%=screen.getString("EMPLOYEEID")%>');" ><%=screen.getString("COMPLAINID")%></a></div></td>
<td><div align="center"><%=screen.getString("CASEID")%></div></td>
<td><div align="center"><%=screen.getString("WELID")%></div></td>
<td><div align="center"><%=screen.getString("CASEDESC")%></div></td>
<td nowrap><div align="center"><%=screen.getString("MEMPLOYEE","fullname")%></div></td>
<td><div align="center"><%=df.format(qty)%></div></td>
<td><div align="right"><%=df.format(cst)%></div></td>
<td nowrap><div align="center"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("STATUS")%></div></td>
</tr>
<%
}
if(screen.outLinePage()){ break; }
}%>
<tr>
<td colspan="6" class="blankspace"></td>
<td><div align="center"><strong>
<script language="javascript">swapLang('total');</script>
</strong> <%=i%>
<script language="javascript">swapLang('List');</script>
</div></td>
<td align="center"><div align="right">
<script language="javascript">swapLang('Total');</script>
<script language="javascript">swapLang('Limit of welfare');</script>
<%//=j%>
</div></td>
<td align="center"><%=df.format(quantity)%></td>
<td align="right"><%=df.format(cost)%></td>
<td></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td colspan="11" class="blankspace"><span class="blankspace style1"><img src="../IMAGES/IINDEX.gif" alt="อ่านกระทู้เฉพาะเรื่อง" width="16" height="16"> = <strong>
<script language="javascript">swapLang('Read');</script>
</strong></span></td>
</tr>
<tr>
<td height="27" colspan="11" class="blankspace style1"><!--img src="../IMAGES/GBTIME.gif" width="20" height="17"--><img src="../IMAGES/LATEBOX.gif"> = <strong>
<script language="javascript">swapLang('Close at time');</script>
</strong></td>
</tr>
<tr>
<td colspan="11" class="blankspace"></td>
</tr>
</table></td>
</tr>
<tr><td>
<%
if(webid.length()>0){
webid=webid.substring(0,webid.length()-1);
%>
<jsp:useBean id="WEL026" class="com.csc.library.system.Task" scope="page" />
<%
WEL026.setChannel(request, response);
HelpEntry screen1 = (HelpEntry) WEL026.process("HelpEntry","WEL026");
screen1.getInquiry().setFilter("webid in("+webid+")");
screen1.setMaxLine(20);
screen1.process();
%>
<table class="inframe">
<tr>
<td class="headerleft" colspan="8"><img src="../IMAGES/WEBBOARD.gif" width="30%" height="40"><img src="../IMAGES/WEBBOARD-END.gif" width="69.99%" height="40"></td>
</tr>
<tr class="blankspace">
<td colspan="8" align="right"><%=screen1.getPageTag()%></td>
</tr>
<tr class="maxsize">
<td class="title1"><div align="center"><strong>
<script language="javascript">swapLang('Topic');</script>
</strong></div></td>
<td class="title1"><div align="center"><strong>
<script language="javascript">swapLang('Create new');</script>
</strong></div></td>
<td class="title1"><div align="center"><strong>
<script language="javascript">swapLang('By');</script>
</strong></div></td>
<td class="title1"><div align="center"><strong><%=screen.getLabel("COMPLAINID")%></strong></div></td>
<td class="title1"><div align="center"><strong><%=screen.getLabel("CASEID")%></strong></div></td>
<td class="title1"><div align="center"><strong><%=screen.getLabel("CASEDESC")%></strong></div></td>
<td class="title1"><div align="center"><strong>
<script language="javascript">swapLang('Read');</script>
</strong></div></td>
<td class="title1"><div align="center"><strong>
<script language="javascript">swapLang('Reply');</script>
</strong></div></td>
</tr>
<%
while(screen1.nextRec())
{if(screen1.checkLinePage()){
%>
<tr bgcolor="#E6E6E6" class="maxsize">
<td width="5%"><div align="center"><a href="javascript:gotopage('WEL025.jsp','<%=screen1.getString("webid")%>');" ><%=screen1.getString("webid")%></a></div></td>
<td width="18%" align="center"><%=screen1.getString("postdate")%></td>
<td width="10%" align="center"><%=screen1.getString("recordername")%></td>
<td width="10%" align="center"><%=screen1.getString("mcomplain","complainid")%></td>
<td width="15%" align="center"><%=screen.getString("mcomplain","caseid")%></td>
<td width="40%" align="center"><%=screen1.getString("webtopic")%></td>
<td width="4%" align="center"><%=screen1.getString("mwebboard","reader")%></td>
<td width="4%" align="center"><%=screen1.getString("writecounter")%></td>
</tr>
<%}
if(screen1.outLinePage()){ break; }
}%>
<%}%>
<tr>
<td class="bottom" colspan="8"> </td>
</tr>
</table></td>
</tr>
</table>
</td></tr>
</table>
</div>
</form>
</body>
</html>