<%@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="WEL112_CPN" class="com.csc.library.system.Task" scope="page" />
<%
	WEL112_CPN.setChannel(request, response);
	HelpEntry screen = (HelpEntry) WEL112_CPN.process("HelpEntry","WEL112_CPN");
    screen.inq.setFilter("status='1' and approvestatus='1' and (batchid is not null and batchid!='')");		
	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 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("__approvedate1")));  
	String endate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__approvedate2"))); 
	String com1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__complainid1")));  
	String com2=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__complainid2")));  
	String refdoc1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__refdoc1")));  
	String refdoc2=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__refdoc2")));  
	String branch=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__branch")));  
	String batchid=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__batchid")));  
	String payments=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__payments"),"1"));  
	String mystatus=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__mystatus")));  
	String mystatuslist=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__mystatuslist")));  
	if(mystatuslist.length()>0&&mystatus.length()>0){
		try{
				DbRecord complain=new  InitialRecord(screen.getUProfile()).getDbRecord("mcomplain");
				complain.setColumn("complainid,companyid,payable,caseid,batchid");
				String[] mstatuslist=mystatuslist.split(",");
				String[] tm;
				for(int i=0;i<mstatuslist.length;i++){						
						tm=mstatuslist[i].split("\\|");
						//out.println("<br>-----"+mstatuslist[i]);
						if(tm.length==2){
							complain.set("complainid",tm[0]);
							complain.set("caseid",tm[1]);
							if(complain.search()==1){		
								if(mystatus.equals("2")){
									complain.set("batchid","");			
									complain.set("payable","0");	
								}else{
									complain.set("batchid",complain.getString("batchid"));			
									complain.set("payable",mystatus);									
								}
								//out.println("="+mystatus);			
								complain.save();
							}							
						}
				}
								
		}catch(Exception ex){
			out.print("ERROR");
		}
	}
	
	screen.inq.clearSubFilter();
	//screen.inq.setFilter("budyear",budyear,"","=");	
	if(batchid.length()>0){	
		screen.inq.setFilter("batchid",batchid,"","between");	
	}		
	if(branch.length()>0){	
		screen.inq.setFilter("branch",branch,"","between");	
	}	
	if(refdoc1.length()>0){	
		screen.inq.setFilter("refdoc",refdoc1,refdoc2,"between");	
	}	
	if(com1.length()>0){	
		screen.inq.setFilter("complainid",com1,com2,"between");	
	}	
	if(emp1.length()>0){	
		screen.inq.setFilter("employeeid",emp1,emp2,"between");	
	}
	if(welid1.length()>0){	
		screen.inq.setFilter("welid",welid1,welid2,"between");	
	}
	if(payments.length()>0){	
		screen.inq.setFilter("payable",payments,"","=");			
	}
	if(stdate.length()>0 || endate.length()>0){

		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){
		screen.inq.setFilter("approvedate",stdate,endate,"between");	
	}
	//screen.setMaxLine(3);
	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">
<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 GoSearch()
{
	document.cscform.__goPage.value="1";
	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=="__branch" ){
		 	helpReturn="__branch:branchid";
		}else if(inputName=="__batchid" ){
		 	helpReturn="__batchid:batchid";
		}else if(inputName=="__employeeid1" ){
		 	helpReturn="__employeeid1:employeeid";
		}else if(inputName=="__employeeid2" ){
		 	helpReturn="__employeeid2:employeeid";
		}else if(inputName=="__refdoc1" ){
		 	helpReturn="__refdoc1:refdoc";
		}else if(inputName=="__refdoc2" ){
		 	helpReturn="__refdoc2:refdoc";
		}else if(inputName=="__complainid1" ){
		 	helpReturn="__complainid1:complainid";
		}else if(inputName=="__complainid2" ){
		 	helpReturn="__complainid2:complainid";
		}else if(inputName=="__welid1" ){
		 	helpReturn="__welid1:welid";
		}else if(inputName=="__welid2" ){
		 	helpReturn="__welid2:welid";
		}


					
	     linkHelp_Return(helpName,helpReturn);
		 document.cscform.__fixCon.value=fixcon;
}

function GoClean()
{
			 clearText();
}


//-->
</script>
<script type="text/javascript" src="../JS/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="../JS/jquery/js/jquery-ui.js"></script>
<script type="text/javascript" src="../JS/jquery.blockUI.js"></script>
<link href="../JS/jquery/css/redmond/jquery-ui-1.7.1.custom.css" rel="stylesheet" type="text/css">
<script>		
			function showDate(mypicker){
				$(function() {
					$("#"+mypicker.id).datepicker({dateFormat: "dd-mm-yy",showAnim: "fadeIn",showOn: "focus",direction: 'up'});
				});
			}
			
			function clearText(){
						$(":input[type=text]").each(function () {
								this.value = "";
							});
			}
			
			function  saveStatus(objstatus){
				with(document.cscform){
						__mystatus.value=objstatus;
						var mystatuslist="";
						$(":input[type=checkbox]").each(function () {
								if(this.checked){
									mystatuslist+=this.value+',';
								}
							});
							__mystatuslist.value=mystatuslist;
						 submit();
				}
			}
			
			function  exportData(){
				with(document.cscform){
						 action="WEL113_CPN.jsp";	
						 submit();
				}
			}			
						
		</script>

<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif','../IMAGES/BUTTON/SWAP/SEARCH_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="WEL112_CPN.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="<%=chk.chkNullString(request.getParameter("__goPage"),"1")%>">
	<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="WEL112_CPN">
   <input type="hidden" name="__webid">
    <input type="hidden" name="__readposter">
  <script language="javascript">getInputFormatDate();</script>
  <input name="__fixCon" type="hidden" value="<%=condition%>">
	<input type="hidden" name="__employeeid" value="">
	<input type="hidden" name="__docno" value="">
	<input type="hidden" name="__formulaid" value="">
	<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="">
	<input name="__mystatus" type="hidden" value="">
	<input name="__mystatuslist" type="hidden" value="">

    <script language="JavaScript" src="../JS/HOTKEY.js"></script>
          <script language="javascript">
	 var titlename=swap2String('Payment to AS400');
	 document.write(Icons("WEL112_CPN,"+titlename));
	 </script>

	<br>
 <table cellpadding="0" cellspacing="0" class="largest">
      <tr >
        <td colspan="2" class="header" >WEL112_CPN, 
          <script language="javascript">swapLang(titlename);</script>&nbsp;</td>
      </tr>
      <tr >
        <td >
		<table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="1">
          <tr>
            <td >
              <table width="638" border="0" align="center" cellpadding="0" cellspacing="1" class="inframe">
                <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"><span>
                    <script language="javascript">swapLang("Approve date");</script>
                    &nbsp; </span></td>
                  <td><input type="text"  id="approvedate1" name="__approvedate1" size="10" maxlength="8"  onClick="showDate(this);" onFocus="showDate(this);"  onMouseDown="showDate(this);"  onKeyup = "formatDate(this)"  readonly  value="<%=stdate%>">
                      <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('__approvedate1')"></a> -
                    <input type="text"  id="approvedate2" name="__approvedate2" size="10" maxlength="8"  onClick="showDate(this);" onFocus="showDate(this);"  onMouseDown="showDate(this);"  onKeyup = "formatDate(this)"   onBlur = "chkInputDate2(__approvedate1,this)"  readonly  value="<%=endate%>">
                    <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image122','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image122" width="20"  border="0" align="absmiddle" id="Image122" onClick="viewCal('__approvedate2')"></a></td>
                </tr>
                <tr>
                  <td class="columnlabel"><script language="javascript">swapLang("Company");</script>
                    &nbsp;</td>
                  <td><input type="text" name="__branch"  size="15" readonly  value="<%=branch%>">
                    <a href="javascript:goHelp('MBRANCHHELP','__branch');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image316','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image316" width="20"  border="0" align="absmiddle" id="Image316"></a></td>
                </tr>
                <tr>
                  <td class="columnlabel"><script language="javascript">swapLang("Batchid");</script>
                    &nbsp;</td>
                  <td><input type="text" name="__batchid"  size="25" value="<%=batchid%>">
                    <a href="javascript:goHelp('MCOMPLAINHELP_CPN','__batchid');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image317','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image317" width="20"  border="0" align="absmiddle" id="Image317"></a></td>
                </tr>
                <tr>
                  <td class="columnlabel"><script language="javascript">swapLang("Employee Code");</script>
                    &nbsp;</td>
                  <td><input type="text" name="__employeeid1" size="15" readonly value="<%=emp1%>">
                      <a href="javascript:goHelp('MEMPLOYEEHELP','__employeeid1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image311','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image311" width="20"  border="0" align="absmiddle" id="Image311"></a>
                      <input type="text" name="__employeeid2"  size="15" readonly  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"><script language="javascript">swapLang("Doc No.");</script>
                    &nbsp;</td>
                  <td><input type="text" name="__refdoc1" value="<%=refdoc1%>" size="15" readonly >
                      <a href="javascript:goHelp('MCOMPLAINHELP_CPN','__refdoc1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image313','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image313" width="20"  border="0" align="absmiddle" id="Image313"></a>
                      <input type="text" name="__refdoc2" value="<%=refdoc2%>" size="15" readonly >
                    <a href="javascript:goHelp('MCOMPLAINHELP_CPN','__refdoc2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image312','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image312" width="20"  border="0" align="absmiddle" id="Image312"></a></td>
                </tr>
                <tr>
                  <td class="columnlabel"><script language="javascript">swapLang("Complain Code");</script>
                    &nbsp;</td>
                  <td><input type="text" name="__complainid1" value="<%=com1%>" size="15" readonly >
                      <a href="javascript:goHelp('MCOMPLAINHELP_CPN','__complainid1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image314','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image314" width="20"  border="0" align="absmiddle" id="Image314"></a>
                      <input type="text" name="__complainid2" value="<%=com2%>" size="15" readonly >
                    <a href="javascript:goHelp('MCOMPLAINHELP_CPN','__complainid2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image315','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image315" width="20"  border="0" align="absmiddle" id="Image315"></a></td>
                </tr>				
                <tr>
                  <td class="columnlabel"><script language="javascript">swapLang("Welfare Code");</script>
                    &nbsp;</td>
                  <td><input type="text" name="__welid1" value="<%=welid1%>" size="15" readonly >
                      <a href="javascript:goHelp('MWELFAREHELP','__welid1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image314','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image314" width="20"  border="0" align="absmiddle" id="Image314"></a>
                      <input type="text" name="__welid2" value="<%=welid2%>" size="15" readonly >
                    <a href="javascript:goHelp('MWELFAREHELP','__welid2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image315','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image315" width="20"  border="0" align="absmiddle" id="Image315"></a></td>
                </tr>				
                
                <tr>
                  <td class="columnlabel"><script language="javascript">swapLang("Payment");</script>
  &nbsp;</td>
                  <td>
				  <select name="__payments">
				  <option value="">...</option>
				  <%
				   String curetype[]=rf.getSystemCode("PAYSTATUS",screen.getUProfile().get("lang"));
				   String tmp[];
				   String tmpStr="";
				   for(int i=0;i<curetype.length-1;i++){
							tmp=curetype[i].split(",");
							if(!tmp[0].equals("2")){
								tmpStr+="<option value='"+tmp[0]+"'";
									if(chk.chkNullString(request.getParameter("__payments")).equals(tmp[0])){
											tmpStr+=" selected ";	
									}
								tmpStr+=">"+tmp[1]+"</option>";
							}
					}
				  %>
				  <%=tmpStr%>									
				  </select>
				  </td>
                </tr>
                <tr>
                  <td class="columnlabel_baseline"></td>
                  <td>
                    <a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif"  border="0"></a><a href="javascript:clearText()"><img src="../IMAGES/BUTTON/CLEAR.gif" width="73" height="23"  border="0"></a></td>
                </tr>
                <tr>
                  <td  class="columnlabel_baseline2"><div align="right"><script language="javascript">swapLang('Found Data');</script>&nbsp;&nbsp;<%=screen.getRecCount()%></div></td>
                <td  class="columnlabel_baseline2"><div align="right"> <%=screen.getPageTag()%></div></td>
				</tr>
              </table>
			  </td>
			  </tr>
			  <tr>
			  <td>
					   <table  border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#808080" class="inframe">
					  <tr class="title1">
						<td width="9%" nowrap class="row3"><div align="center"><script language="javascript">swapLang('Select');</script></div></td>
						<td width="21%" nowrap class="row3"><div align="center"><%=screen.getLabel("welid")%></div></td>
						<td width="18%" nowrap class="row3"><div align="center"><%=screen.getLabel("employeeid")%></div></td>
						<td width="9%" nowrap class="row3"><div align="center"><%=screen.getLabel("complainid")%></div></td>
						<td width="9%" nowrap class="row3"><div align="center"><%=screen.getLabel("caseid")%></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("cost")%></div></td>
						<td width="12%" nowrap class="row3"><div align="center"><%=screen.getLabel("occurdate")%> </div></td>
						<td width="13%" nowrap class="row3"><div align="center"><%=screen.getLabel("batchid")%></div></td>
					  </tr>
					  <% while (screen.nextRec()) {%>
					  <tr >
						<td width="9%" nowrap ><div align="center"><input type="checkbox" name="__docheck"  value="<%=screen.getString("complainid")+"|"+screen.getString("caseid")%>"></div></td>
						<td width="21%" nowrap ><%=screen.getString("mwelfare","tdesc")%></td>
						<td width="18%" nowrap ><%=screen.getString("employeeid")%>&nbsp;<%=screen.getString("memployee","fullname")%></td>
						<td width="9%" nowrap ><%=screen.getString("complainid")%></td>
						<td width="9%" nowrap ><%=screen.getString("caseid")%></td>
						<td width="9%" nowrap ><%=screen.getString("refdoc")%></td>
						<td width="9%" nowrap ><%=screen.getString("refno")%></td>
						<td width="9%" nowrap ><%=screen.getString("cost")%></td>
						<td width="12%" nowrap ><%=screen.getString("occurdate")%> </td>
						<td width="13%" nowrap ><%=screen.getString("batchid")%></td>
					  </tr>
					  <%}%>
					  <tr>
						<td colspan="10" class="blankspace"></td>
					  </tr>
					  <tr>
						<td class="blankspace style1" colspan="10"><div align="center"><a href="javascript:checkAll();"><img src="../IMAGES/BUTTON/SELECTALL.gif"   border="0" align="middle"></a>&nbsp; <a href="javascript:decheckAll();"><img src="../IMAGES/BUTTON/DESELECTALL.gif"   border="0" align="middle"></a>&nbsp;<a href="javascript:saveStatus('3')"><img src="../IMAGES/BUTTON/CONFIRM.gif" width="73" height="23"   border="0" align="middle"></a>&nbsp;<a href="javascript:saveStatus('2')"><img src="../IMAGES/BUTTON/REJECT.gif" width="73" height="23"   border="0" align="middle"></a>&nbsp;<a href="javascript:exportData()"><img src="../IMAGES/BUTTON/EXPORT.gif" width="73" height="23"   border="0" align="middle"></a></div></td>
						</tr>
					  <tr>
						<td colspan="10" class="bottom"></td>
					  </tr>
					</table>				
			</td>
      </tr>
    </table>
	</td>
	</tr>
	</table>
	<br>
</form>
</div>
</body>
</html>