<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.session.*,com.csc.library.report.*;"%>
<jsp:useBean id="WEL003" class="com.csc.library.system.Task" scope="page" />
<%
WEL003.setChannel(request, response);
HelpEntry screen = (HelpEntry) WEL003.process("HelpEntry","WEL003");
CheckNull chk=new CheckNull();
ReportUDF rf=new ReportUDF();
ThaiUtilities thail = new ThaiUtilities();
CscCalendar cs=new CscCalendar();
java.text.DecimalFormat df=new java.text.DecimalFormat("#,###,##0.00");
String condition=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__fixCon")));
String budyear=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__budyear"),cs.getThaiYYYY()));
String emp1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__employeeid1")));
String emp2=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__employeeid2")));
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")));
String filter_emp ="";
String filter_welid ="";
String filter_occur ="";
String filter_bud ="";
screen.inq.clearSubFilter();
if(budyear.length()>0){
filter_bud = " AND budyear = '"+budyear+"'";
}
if(emp1.length()>0){
filter_emp = "AND employeeid between '"+emp1+"' AND '"+emp2+"' ";
}
if(welid1.length()>0){
filter_welid = " AND welid between '"+welid1+"' AND '"+welid2+"' ";
}
if(stdate.length()>0 || endate.length()>0){
CscCalendar cs1=new CscCalendar(stdate);
CscCalendar cs2=new CscCalendar(endate);
stdate=cs1.getYYYYMMDD();
endate=cs2.getYYYYMMDD();
/*String spstdate[] =stdate.split("-");
String spendate[] =endate.split("-");
if(spstdate.length==3){
if(spstdate[0].length()==4)
stdate=spstdate[0]+"-"+spstdate[1]+"-"+spstdate[2];
else
stdate=spstdate[2]+"-"+spstdate[1]+"-"+spstdate[1];
}
if(spendate.length==3){
if(spendate[0].length()==4)
stdate=spendate[0]+"-"+spendate[1]+"-"+spendate[2];
else{
endate=spendate[2]+"-"+spendate[1]+"-"+spendate[1];
}
}*/
}
if(stdate.length()>0){
filter_occur = " AND occurdate between '"+stdate+"' and '"+endate+"' ";
}
screen.inq.setFilter("status='1' and approvestatus<>'2' "+filter_bud+filter_emp+filter_welid+filter_occur);
//out.print("<BR><BR><BR><BR><BR>"+screen.inq.getFilter());
//out.print("<br><br><br><br><br><br><br>"+screen.inq.getFilter());
screen.process();
stdate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__startdate")));
endate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__enddate")));
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >
<link href="../CSS/MENU.css" rel="stylesheet" type="text/css">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script language='javascript' src="../JS/VIEWCALENDAR.js"></script>
<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 language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="JavaScript" type="text/JavaScript">
<!--
function edelete(){
with(document.cscform){
bCon=confirm("เกินสิทธิ");
if (bCon==true) {
// setAction(__jspname.value,"delete");
__cmd.value="delete";
submit();
}
}
}
function postnew(page){
with(document.cscform){
open(page,"post","height=420,width=600");
}
}
function gotopage(page,idno){
with(document.cscform){
action=page;
__webid.value=idno;
__fixCon.value="webid='"+idno+"'";
__cmd.value="search";
__readposter.value="count";
submit();
}
}
function setFixCon(fixCon){
var _fix=(fixCon.length>0)?(fixCon+" and status='1' and approvestatus<>'2'") : ("status='1' and approvestatus<>'2'");
return _fix;
}
function GoSearch()
{
/*with(document.cscform)
{
if(__employeeid1.value==""&&__employeeid2.value==""&&__welid1.value=="" && __welid2.value=="" && __startdate.value=="" && __enddate.value=="")
{
__fixCon.value="";
}
else if(__employeeid1.value==""&&__employeeid2.value!=""||__employeeid1.value!=""&&__employeeid2.value=="" ||__welid1.value=="" && __welid2.value!="" || __welid1.value!="" && __welid2.value=="" || __startdate.value=="" && __enddate.value!="" || __startdate.value!="" && __enddate.value=="")
{
alert("Please Input Value.!!");
}
else if(__welid1.value==""&&__welid2.value==""&& __startdate.value=="" && __enddate.value=="")
{
if(__employeeid1.value>__employeeid2.value)
{
var tmp=__employeeid2.value;
__employeeid2.value=__employeeid1.value;
__employeeid1.value=tmp;
}
__fixCon.value="(EMPLOYEEID>='"+__employeeid1.value+"')and(EMPLOYEEID<='"+__employeeid2.value+"')";
}
else if(__employeeid1.value==""&&__employeeid2.value==""&& __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(__employeeid1.value==""&&__employeeid2.value==""&&__welid1.value=="" && __welid2.value=="")
{
var stdate="";
var endate="";
stdate=chkDateTime2(__startdate.value,"-");
endate=chkDateTime2(__enddate.value,"-");
__fixCon.value="(STARTDATE >='"+stdate+"')and(ENDDATE <='"+endate+"')";
}
else if( __startdate.value=="" && __enddate.value=="")
{
if(__welid1.value>__welid2.value)
{
var tmp=__welid2.value;
__welid2.value=__welid1.value;
__welid1.value=tmp;
}
if(__employeeid1.value>__employeeid2.value)
{
var tmp=__employeeid2.value;
__employeeid2.value=__employeeid1.value;
__employeeid1.value=tmp;
}
__fixCon.value="(WELID>='"+__welid1.value+"')and(WELID<='"+__welid2.value+"')and(EMPLOYEEID>='"+__employeeid1.value+"')and(EMPLOYEEID<='"+__employeeid2.value+"')";
}
else if(__welid1.value=="" && __welid2.value=="")
{
if(__employeeid1.value>__employeeid2.value)
{
var tmp=__employeeid2.value;
__employeeid2.value=__employeeid1.value;
__employeeid1.value=tmp;
}
var stdate="";
var endate="";
stdate=chkDateTime2(__startdate.value,"-");
endate=chkDateTime2(__enddate.value,"-");
__fixCon.value="(STARTDATE >='"+stdate+"')and(ENDDATE <='"+endate+"')and(EMPLOYEEID>='"+__employeeid1.value+"')and(EMPLOYEEID<='"+__employeeid2.value+"')";
}
else if(__employeeid1.value==""&&__employeeid2.value=="")
{
if(__welid1.value>__welid2.value)
{
var tmp=__welid2.value;
__welid2.value=__welid1.value;
__welid1.value=tmp;
}
var stdate="";
var endate="";
stdate=chkDateTime2(__startdate.value,"-");
endate=chkDateTime2(__enddate.value,"-");
__fixCon.value="(STARTDATE >='"+stdate+"')and(ENDDATE <='"+endate+"')and(WELID>='"+__welid1.value+"')and(WELID<='"+__welid2.value+"')";
}
else
{
var stdate="";
var endate="";
stdate=chkDateTime2(__startdate.value,"-");
endate=chkDateTime2(__enddate.value,"-");
if(__employeeid1.value>__employeeid2.value)
{
var tmp=__employeeid2.value;
__employeeid2.value=__employeeid1.value;
__employeeid1.value=tmp;
}
if(__welid1.value>__welid2.value)
{
var tmp=__welid2.value;
__welid2.value=__welid1.value;
__welid1.value=tmp;
}
__fixCon.value="(EMPLOYEEID>='"+__employeeid1.value+"')and(EMPLOYEEID<='"+__employeeid2.value+"')and(welid>='"+__welid1.value+"')and(welid<='"+__welid2.value+"')and(startdate>='"+stdate+"')and(enddate<='"+endate+"')";
}*/
//__fixCon.value=setFixCon(__fixCon.value);
document.cscform.__fixCon.value="";
search();
//}
}
function GoSave() {}
function GoDelete(){ }
function GoUpdate(){}
function goHelp(helpName,inputName){
var helpReturn;
var fixcon=document.cscform.__fixCon.value;
document.cscform.__fixCon.value="";
if(inputName=="__employeeid1" )
helpReturn="__employeeid1:EMPLOYEEID,MEMPLOYEE@EMPLOYEEID";
else if(inputName=="__employeeid2" )
helpReturn="__employeeid2:EMPLOYEEID,MEMPLOYEE@EMPLOYEEID";
else if(inputName=="__provinceid" )
helpReturn="__provinceid:provinceid,MPROVINCE@long_tname,MPROVINCE@long_ename";
else if(inputName=="__welid1" )
helpReturn="__welid1:WELID,MWELFARE@WELID";
else if(inputName=="__welid2" )
helpReturn="__welid2:WELID,MWELFARE@WELID";
linkHelp_Return(helpName,helpReturn);
document.cscform.__fixCon.value=fixcon;
}
function chkDateTime2(valueSearch,comm){ // 23/03/2004
var tmpval="";
with(document.cscform){
// tmpval=valueSearch.substring(2,3);
var valueSearch1=valueSearch.split(comm);
if(valueSearch1.length==3){
if(valueSearch1[1].length==1){
valueSearch1[1]="0"+valueSearch1[1];
}
if(valueSearch1[0].length==1){
valueSearch1[0]="0"+valueSearch1[0];
}
valueSearch1[2]=parseInt(valueSearch1[2]);
return valueSearch=valueSearch1[2]+"-"+valueSearch1[1]+"-"+valueSearch1[0];
}
}
}
function gotopage1(page,idno,no1,empid){
with(document.cscform){
action=page;
__complainid.value=idno;
__fixCon.value="complainid='"+idno+"' and caseid='"+no1+"' and employeeid='"+empid+"'";
__cmd.value="search";
submit();
}
}
function GoClean()
{
with(document.cscform)
{
__employeeid1.value="";
__employeeid2.value="";
__welid1.value="";
__welid2.value="";
__startdate.value="";
__enddate.value="";
}
}
//-->
</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 class="centered">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" action="WEL003.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__notNull" value="<%//=screen.getRequire()%>">
<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="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__lockPage" value="">
<input type="hidden" name="__calendar">
<input type="hidden" name="__screen" value="WEL003">
<input type="hidden" name="__webid">
<input type="hidden" name="__readposter">
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__employeeid" value="">
<input type="hidden" name="__docno" value="">
<input type="hidden" name="__formulaid" value="">
<input name="__fixCon" type="hidden" value="<%=condition%>">
<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input name="__complainid" type="hidden" value="">
<script language="JavaScript" src="../JS/HOTKEY.js"></script>
<script language="javascript">
var titlename=swap2String('History of welfare in budget this year');
document.write(Icons("WEL003,"+titlename));
</script>
<br> <div align="center">
<table cellpadding="0" cellspacing="0" class="largest">
<tr >
<td colspan="2" class="header" >WEL003, <script language="javascript">swapLang(titlename);</script> </td>
</tr>
<tr >
<td ><table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td colspan="12" class="blankspace">
<table width="638" border="0" align="center" cellpadding="0" cellspacing="1" class="inframe">
<tr>
<td colspan="2" class="blankspace"> </td>
</tr>
<tr class="maxsize">
<td width="15%">
<div align="right">
<script language="javascript">swapLang('Order By');</script>
</div></td>
<td><%=screen.getTagOrder()%></td>
</tr>
<tr>
<td class="columnlabel_baseline"><script language="javascript">swapLang('Year');</script>
</td>
<td><input name="__budyear" type="text" size="5" maxlength="5" value="<%=budyear%>" ONKEYPRESS="chkInteger()" ></td>
</tr>
<tr>
<td class="columnlabel_baseline"><script language="javascript">swapLang('Employeeid');</script>
</td>
<td width="538">
<input name="__employeeid1" type="text" size="15" value="<%=emp1%>">
<a href="javascript:goHelp('MEMPLOYEEHELP','__employeeid1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image3" width="20" border="0" align="absmiddle"></a> -
<input name="__employeeid2" type="text" size="15" value="<%=emp2%>">
<a href="javascript:goHelp('MEMPLOYEEHELP','__employeeid2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image31','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image31" width="20" border="0" align="absmiddle" id="Image31"></a></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="Image321"></a></td>
</tr>
<tr>
<td class="columnlabel_baseline"><script language="javascript">swapLang('Date Between');</script>
</td>
<td><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="Image121" onClick="viewCal('__enddate')"></a></td>
</tr>
<tr>
<td class="columnlabel_baseline"> </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"><%=screen.getPageTag()%></div></td>
</tr>
</table>
<table width="638" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#808080" class="inframe">
<tr class="title1">
<!--td width="6%" nowrap class="title1"> </td-->
<!--td width="8%" nowrap class="title1"><div align="center" ><%//=screen.getLabel("STARTDATE")%></div></td-->
<!--td width="6%" nowrap class="title1"><div align="center"><%//=screen.getLabel("ENDDATE")%></div></td-->
<td width="8%" nowrap class="row3"><div align="center"><%=screen.getLabel("BUDYEAR")%></div></td>
<td width="8%" nowrap class="row3"><div align="center"><%=screen.getLabel("COMPLAINID")%></div></td>
<td width="8%" nowrap class="row3"><div align="center"><%=screen.getLabel("CASEID")%></div></td>
<td width="10%" nowrap class="row3">
<div align="center"><%=screen.getLabel("OCCURDATE")%></div></td>
<td width="10%" nowrap class="row3">
<div align="center"><%=screen.getLabel("APPROVEDATE")%></div></td>
<td width="25%" nowrap class="row3"><div align="center"><%=screen.getLabel("CASEDESC")%></div></td>
<td width="15%" nowrap class="row3"><div align="center">
<script language="javascript">swapLang('Name-Surname');</script>
</div></td>
<td width="8%" nowrap class="row3"><div align="center"><%=screen.getLabel("REQCOST")%></div></td>
<td width="8%" nowrap class="row3"><div align="center"><%=screen.getLabel("COST")%></div></td>
<td width="9%" nowrap class="row3"><div align="center"><%=screen.getLabel("REFDOC")%></div></td>
<td width="9%" nowrap class="row3"><div align="center"><%=screen.getLabel("REFNO")%></div></td>
<td width="9%" nowrap class="row3"><div align="center"><%=screen.getLabel("PAYABLE")%></div></td>
</tr>
<%
int i=0;
double j=0,k=0,cost=0,quantity=0;
String webid="";
%>
<% while (screen.nextRec()) {
//if(screen.checkLinePage()){
if(screen.getString("APPROVESTATUS").equals("1")){
//((DbInquiry)screen.getInquiry().getCurrentDbRecord().getChild("MWELFARE")).getCurrentDbRecord().set("_empid",screen.getString("EMPLOYEEID"));
j+=Double.parseDouble(chk.chkNullString(String.valueOf(screen.getInquiry().getCurrentDbRecord().getDouble("REQCOST")),"0"));
k+=Double.parseDouble(chk.chkNullString(String.valueOf(screen.getInquiry().getCurrentDbRecord().getDouble("COST")),"0"));
}
quantity=Double.parseDouble(chk.chkNullString(String.valueOf(screen.getInquiry().getCurrentDbRecord().getDouble("REQCOST")),"0"));
cost=Double.parseDouble(chk.chkNullString(String.valueOf(screen.getInquiry().getCurrentDbRecord().getDouble("COST")),"0"));
if(screen.getString("webid").length()>0){
webid+="'"+screen.getString("webid")+"',";
}
%>
<tr>
<!--td nowrap><div align="center"><=screen.getString("STARTDATE")%></div></td>
<td nowrap>
<div align="center"> <=screen.getString("ENDDATE")%></div></td-->
<td><div align="center"><%=screen.getString("BUDYEAR")%></div></td>
<td nowrap><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("OCCURDATE")%></div></td>
<td><div align="center"><%=screen.getString("APPROVEDATE")%></div></td>
<td nowrap> <%=screen.getString("MWELFARE","TDESC")%><%if(screen.getString("sitewelid").length()>0){%>(<%=screen.getString("MSITEWEL","TDESC")%>)<%}%></td>
<td nowrap> <%=screen.getString("MEMPLOYEE","FNAME")%> <%=screen.getString("MEMPLOYEE","LNAME")%><%if(screen.getString("MEMPL_FAMILY","FNAMEID").length()>0){%><%="("+screen.getString("MEMPL_FAMILY","FNAMEID")%> <%=screen.getString("MEMPL_FAMILY","LNAME")+")"%><%}%></td>
<td><div align="right"><%=df.format(quantity)%> </div></td>
<td><div align="right"><%=df.format(cost)%> </div></td>
<td nowrap><div align="center"><%=screen.getString("REFDOC")%></div></td>
<td > <%=screen.getString("REFNO")%></td>
<td > <%=screen.getInquiry().getCurrentDbRecord().getSystemCode("PAYABLE")%></td>
</tr>
<%i++;%>
<%
// }
//if(screen.outLinePage()){ break; }
}
%>
<tr>
<!--td nowrap> </td>
<td nowrap> </td-->
<td colspan="7" align="center"><strong>
<script language="javascript">swapLang('total');</script></strong> [ <%=i%> ] <script language="javascript">swapLang('List');</script>
</td>
<td align="right"><%=df.format(j)%> </td>
<td align="right" nowrap><%=df.format(k)%> </td>
<td nowrap> </td>
<td nowrap> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="12" class="blankspace"></td>
</tr>
<!--tr>
<td 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 class="blankspace style1"><img src="../IMAGES/IEDIT.gif" width="16" height="16"> = <strong>
<script language="javascript">swapLang('Create new topic');</script>
</strong></td>
</tr-->
<tr>
<td class="blankspace style1"> </td>
</tr>
<tr>
<td colspan="12" class="bottom"></td>
</tr>
</table></td>
</tr>
</table>
<br>
</div>
</form>
</body>
</html>