<%@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="WEL050" class="com.csc.library.system.Task" scope="page" />
<%
	WEL050.setChannel(request, response);
	HelpEntry screen = (HelpEntry) WEL050.process("HelpEntry","WEL050");
	screen.getInquiry().clearSubFilter();
	screen.inq.setFilter("status='1'  and approvestatus<>'2' and  employeeid='"+screen.getUProfile().get("employeeid")+"'");   
	CheckNull chk=new CheckNull();
	ReportUDF rf=new ReportUDF();
	ThaiUtilities thail = new ThaiUtilities();
	CscCalendar cs=new CscCalendar();
	cs.decYear(1);
	java.text.DecimalFormat df=new java.text.DecimalFormat("#,###,##0.00");
	String condition=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__fixCon")));  
	String years1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__year"),String.valueOf(cs.getYear())));  
	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")));  
	
	DbInquiry dbi=(DbInquiry)screen.getInquiry();
	if(years1.trim().length()>0){
		dbi.setFilter("budyear",years1,"","between");
	}
	if(welid1.trim().length()>0){
		dbi.setFilter("welid",welid1,welid1,"between");
	}
	if(stdate.trim().length()>0){
		dbi.setFilter("approvedate",stdate,endate,"between");
	}

	screen.process();
%>
<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">
<link href="../CSS/bootstrap.css" rel="stylesheet"  type="text/css">
<link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet"  type="text/css">
<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
<script type='text/javascript' src="../JS/bootstrap.js"></script>
<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 MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
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);								
									search();						
			}
}

function goHelp(helpName,inputName){
	var helpReturn;
		 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);
}

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="">


<!----------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 name="__notNull" type="hidden" 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">
   <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  type="hidden" name="__fixCon" value="<%=condition%>">
	<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
  	<input type="hidden" name="__companyid"  value="<%=screen.getUProfile().get("companyid")%>">
	<input type="hidden" name="__complainid"  value="">

    <script language="JavaScript" src="../JS/HOTKEY.js"></script>
          <script language="javascript">
	 var titlename=swap2String('History of welfare in budget year ago');
	 document.write(Icons("WEL050,"+titlename));
	 </script>
	<br> <div align="center">
 <table cellpadding="0" cellspacing="0" class="largest">
      <tr >
        <td colspan="2" class="header" >WEL050, <script language="javascript">swapLang('History of welfare in budget year ago');</script>&nbsp;</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>
&nbsp; </div></td>
                  <td width="538"><%=screen.getTagOrder()%></td>
                </tr>
                <tr>
                  <td class="columnlabel_baseline"><script language="javascript">swapLang('Budget Year');</script>
                  </td>
                  <td><input name="__year" type="text" size="7"  maxlength="4" value="<%=years1%>">
                  </td>
                </tr>
                <tr>
                  <td class="columnlabel_baseline"><script language="javascript">swapLang('Welfare ID');</script>
&nbsp;</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>
&nbsp;</td>
                  <td>
				  <input name="__startdate" type="text" size="10"  maxlength="8" 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="8" 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 class="columnlabel_baseline">&nbsp;</td>
                  <td><!--input name="__keyword" type="text" size="30" value="<=keyword%>" -->
                    <button type="button" class="btn btn-primary width100" swlang code="SW013174" onClick="GoSearch();">SEARCH</button></td>
                </tr>
                <tr>
                  <td colspan="2" class="columnlabel_baseline2"><div align="right"></div></td>
                </tr>
              </table>
              <div align="right"><br>
                  <%=screen.getPageTag()%></div>
                  <table width="638" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#808080" class="inframe tablewithborder">
          <tr class="title1">
              <td width="6%" nowrap class="title1"><div align="center" ><%=screen.getLabel("approvedate")%></div></td>
              <td width="8%"  nowrap class="title1"><div align="center" ><%=screen.getLabel("budyear")%></div></td>
            <td nowrap class="title1"><div align="center"><%=screen.getLabel("COMPLAINID")%></div></td>
            <td nowrap class="title1"><div align="center"><%=screen.getLabel("CASEID")%></div></td>
            <td nowrap class="title1">
              <div align="center"><%=screen.getLabel("WELID")%></div></td>
            <td nowrap class="title1"><div align="center"><%=screen.getLabel("CASEDESC")%></div></td>
            <td nowrap class="title1"><div align="center">
                <script language="javascript">swapLang('Name-Surname');</script>
            </div></td>
            <td nowrap class="title1"><div align="center"><%=screen.getLabel("MWELFARE","QUANTITY")%></div></td>
            <td nowrap class="title1"><div align="center"><%=screen.getLabel("COST")%></div></td>
            <td nowrap class="title1"><div align="center"><%=screen.getLabel("STATUS")%></div></td>
            <td nowrap class="title1"><div align="center"><%=screen.getLabel("APPROVESTATUS")%></div></td>
            <td width="8%" nowrap class="title1"><div align="center"><%=screen.getLabel("REFDOC")%></div></td>			
          </tr>
          <% double i=0,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(screen.getString("MWELFARE","WELQTY"),"0"));
	k+=Double.parseDouble(chk.chkNullString(screen.getString("COST"),"0"));
       } 
	quantity=Double.parseDouble(chk.chkNullString(screen.getString("MWELFARE","WELQTY"),"0"));
	cost=Double.parseDouble(chk.chkNullString(screen.getString("COST"),"0"));
               if(screen.getString("webid").length()>0){
              webid+="'"+screen.getString("webid")+"',";
               }
	%>
          <tr>
              <td nowrap><div align="center"><%=screen.getString("approvedate")%></div></td>
              <td nowrap><div align="center"><%=screen.getString("budyear")%></div></td>		  
            <td width="7%" nowrap><div align="center"><a href="javascript:gotopage1('WEL042.jsp','<%=screen.getString("COMPLAINID")%>','<%=screen.getString("CASEID")%>','<%=screen.getString("EMPLOYEEID")%>');"><%=screen.getString("COMPLAINID")%></a></div></td>
            <td width="6%"><div align="center"><%=screen.getString("CASEID")%></div></td>
            <td width="8%"><div align="center"><%=screen.getString("WELID")%></div></td>
            <td width="23%"><%=screen.getString("MWELFARE","TDESC")%>(<%=screen.getString("MSITEWEL","TDESC")%>)</td>
            <td width="14%" nowrap><%=screen.getString("MEMPLOYEE","FNAME")%>&nbsp;<%=screen.getString("MEMPLOYEE","LNAME")%></td>
            <td width="7%"><div align="right"><%=df.format(quantity)%></div></td>
            <td width="7%"><div align="right"><%=df.format(cost)%></div></td>
            <td width="8%" nowrap><div align="center"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("STATUS")%></div></td>
            <td width="8%" nowrap><div align="center"><%=rf.getSystemCode("APPROVE_STATUS",screen.getUProfile().get("lang"),screen.getString("APPROVESTATUS"))%></div></td>
            <td><div align="center"><%=screen.getString("REFDOC")%></div></tr>
          <%i++;%>
          <% 
					 }
					 if(screen.outLinePage()){ break; }	 
	 }
	 %>
          <tr>
            <td colspan="5"><div align="right"><strong>
              <script language="javascript">swapLang('total');</script>
            </strong></div></td>
            <td nowrap><div align="right"> <%=i%>&nbsp;&nbsp; </div></td>
            <td><div align="right">
                <script language="javascript">swapLang('List');</script>
            </div></td>
            <td nowrap><%=df.format(j)%></td>
            <td nowrap><%=df.format(k)%></td>
            <td nowrap>&nbsp;</td>
            <td nowrap></td>
            <td nowrap></td>
			</tr>
				  </table>				  
			  </td>
          </tr>

          <tr>
            <td colspan="12" class="blankspace"></td>
          </tr>
          <tr>
            <td colspan="12" class="bottom"></td>
          </tr>
        </table></td>
      </tr>
    </table>
	<br>
	</div>
</form>
</body>
</html>