<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.utilities.*"%>
<jsp:useBean id="WEL022_KKB" class="com.csc.library.system.Task" scope="page" />
<%
	WEL022_KKB.setChannel(request, response);
	HelpEntry screen = (HelpEntry) WEL022_KKB.process("HelpEntry","WEL022_KKB");
	screen.inq.setFilter("status<>'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/MENU.css" rel="stylesheet" type="text/css">
<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){
		with(document.cscform){
					action=page;
					submit();
		}
}

function gotopage2(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<>'1'  and employeeid='<%=screen.getUProfile().get("employeeid")%>' and approvestatus<>'3' ") : (" status<>'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,"");
}


function gotopage1(page,idno,caseid,docgid,empid,budid,whouse,edu){
		with(document.cscform){
					action=page;
					__complainid.value=idno;
					if(caseid!=""){
					__caseid.value=caseid;
					}
					__budid1.value=budid;
					__whouse1.value=whouse;
					__edu.value=edu;
					__help.value="__complainid#"+idno+",__caseid#"+caseid+",__docgid#"+docgid+"";				
					//__fixCon.value="complainid='"+idno+"' and caseid='"+caseid+"' and employeeid='"+empid+"'";
					__cmd.value="search";
					submit();
		}
}

//-->
</script>

<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body>
<div class="centered">
<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 -------------------------->

<input type="hidden" name="__calendar">
  <script language="javascript">getInputFormatDate();</script>
  <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
	<input type="hidden" name="__cmd" value="">
	<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="__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="__whouse1" value="">
	<input type="hidden" name="__budid1" value="">
		<input type="hidden" name="__caseid" value="">
	<input type="hidden" name="__fixCon" value="">
	<input type="hidden" name="__reader" value="">
	<input type="hidden" name="__edu" value="">
	<input name="__screen" type="hidden" value="WEL022_KKB">
          <script language="javascript">
	 var titlename=swap2String('Requisition of welfare');
	 document.write(Icons("WEL022_KKB,"+titlename));
	 </script>
  <div align="center">
  <table  class="largest" cellpadding="0" cellspacing="0">
<tr > 
        <td colspan="2" class="header" >WEL022, 
        <script language="javascript">swapLang('Requisition of welfare');</script>&nbsp;</td>
      </tr>
      <tr > 
        <td ><table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="1">
            <tr> 
              <td colspan="11" class="blankspace">
                <table width="638" border="0" align="center" cellpadding="0" cellspacing="1" class="inframe">
				   <tr>
                    <td colspan="2" class="columnlabel_baseline2"><div align="right"></div></td>
                  </tr>
				<tr> 
              <td colspan="2" class="row1"><span class="header">
                <script language="javascript">swapLang('Requisition of welfare');</script>
              </span></td>
            </tr>
                  <tr>
                    <td class="columnlabel_baseline">&nbsp;<strong>
                        <script language="javascript">swapLang('Order By');</script>
                      </strong></td>
                    <td nowrap class="maxsize"><%=screen.getTagOrder()%></td>
                  </tr>
                  <tr>
                    <td class="columnlabel_baseline"><strong>
                      <script language="javascript">swapLang('Welfare ID');</script>
                    &nbsp;</strong></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"><strong>
                      <script language="javascript">swapLang('Date Between');</script>
                    &nbsp;</strong></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"><strong>&nbsp;</strong></td>
                    <td><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="200" border="0" cellpadding="0" cellspacing="1" bgcolor="#808080" class="inframe">
            <tr class="title1">
              <td width="6%" nowrap class="title1"><div align="center"></div></td>
              <td width="8%" nowrap class="title1"><div align="center" ><strong><%=screen.getLabel("STARTDATE")%></strong></div></td>
              <td width="6%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("ENDDATE")%></strong></div></td>
              <td width="7%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("COMPLAINID")%></strong></div></td>
              <td width="6%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("CASEID")%></strong></div></td>
              <td width="8%" nowrap class="title1"> <div align="center"><strong><%=screen.getLabel("WELID")%></strong></div></td>
              <td width="23%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("CASEDESC")%></strong></div></td>
              <td width="7%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("MWELFARE","QUANTITY")%></strong></div></td>
              <td width="7%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("COST")%></strong></div></td>
              <td width="8%" nowrap class="title1"><div align="center"><strong><%=screen.getLabel("STATUS")%></strong></div></td>
            </tr>
			<%
			int i=0;
			double quantity=0,mquantity=0;
			double cost=0,mcost=0;
			while (screen.nextRec()) {
				if(screen.checkLinePage()){
			i++;
			mquantity=Double.parseDouble(chk.chkNullString(screen.getString("MWELFARE","QUANTITY"),"0"));
			quantity+=mquantity;
			mcost=Double.parseDouble(chk.chkNullString(screen.getString("COST"),"0"));
			cost+=mcost;
			%>
			
			<!--% int i=1,j=0,k=0%-->
            <tr>
              <td nowrap><div align="center"><span class="blankspace style1"><a href="javascript:gotopage1('WEL015_NSTDA.jsp','<%=screen.getString("COMPLAINID")%>','<%=screen.getString("CASEID")%>','<%=screen.getString("MWELFARE","DOCGID")%>','<%=screen.getString("EMPLOYEEID")%>','<%=screen.getString("MWELFARE","BUDID")%>','<%=screen.getString("MWELFARE","WHOUSE")%>','<%=screen.getString("MWELFARE","ISEDUCATION")%>');"><img src="../IMAGES/BUTTON/MAIN/NEW20.gif" alt="new case" width="16" height="16" border="0" ></a></span></div></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:gotopage2('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><div align="center"><%=df.format(mquantity)%></div></td>
              <td>
                <div align="right"><%=df.format(mcost)%></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"><div align="right"><strong>
                  <script language="javascript">swapLang('total');</script>
              </strong></div></td>
              <td><div align="right"><strong>
              </strong></div>                
                <div align="right"><%=i%>&nbsp;&nbsp;
		            <script language="javascript">swapLang('List');</script>
                </div></td>
			  <td align="center"><%=df.format(quantity)%></td>
			  <td align="center"><%=df.format(cost)%></td>
			  <td></td>
            </tr>
                </table>
</td>
            </tr>
			
			
			
			
            <tr> 
              <td colspan="11" class="blankspace"></td>
            </tr>
			<tr>
              <td colspan="11" class="blankspace"><div align="center"><a href="javascript:gotopage('WEL015_KKB.jsp')"><img src="../IMAGES/BUTTON/ADD.gif" alt="เพิ่มรายการใหม่"   border="0"></a></div></td>
            </tr>
            <tr>
              <td colspan="11" class="bottom"></td>
            </tr>
          </table>
          
        </td>
      </tr>
    </table>
   
  </div>
</form>
</body>
</html>