<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.session.*,com.csc.library.utilities.*,java.util.StringTokenizer,com.csc.library.database.*"%>
<jsp:useBean id="CS021" class="com.csc.library.system.Task" scope="page" />
<%//CS021.setChannel(request, response);%>
<%//HelpEntry screen = (HelpEntry) CS021.process("HelpEntry", request.getParameter("__helpName"));%>
<%//screen.process();%>
<%
	UProfile uf=(UProfile)session.getAttribute("userprofile");
	DbInquiry inq = new InitialInquiry(uf).getDbInquiry();
	inq.setSchemaName(uf.getSchemaName());
	inq.initMyTable(request.getParameter("__tablename"),request.getParameter("__fixCon"),"");	
	inq.setColumn("*");
	inq.setVerifyOff();
	inq.refresh();
	inq.next();		
%>
<html>
<head>
<title>Refer Data to Verify</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">setLang('<%=screen.getUProfile().get("lang")%>');</script>
 
<script language="JavaScript">setLang('<%=uf.get("lang")%>');</script>
<script language="JavaScript" type="text/JavaScript">
<!--
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_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_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 MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
function closeWin(){
	window.close();
}

//-->
</script>


</head>

<body leftmargin="0" topmargin="0">
<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="__companyid" value='<%=screen.getUProfile().get("companyid")%>'> 
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__screen" value="CS021">
  <input type="hidden" name="__notNull" value="<%=screen.getRequire()%>">
  <input type="hidden" name="__language" value ="<%=screen.getUProfile().get("lang")%>"> 
  <table width="640"height="20" cellpadding="0" cellspacing="0" align="center">
    <tr bgcolor="#3366CC">
      <td  height="20" class="header"><div align="right"><strong>CS021, <script language="JavaScript">swapLang('Refer Data to Verify');</script>&nbsp;</strong></div></td>
  </tr>
   <tr bgcolor="#3366CC">
      <td  height="20" class="row1">
            <table class="largest" border="0" cellspacing="1" cellpadding="3">
              <tr>
                <td><div align="right"><a href="javascript:save();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image8','','../IMAGES/BUTTON/SWAP/NEW_SWAP24.gif',1)"><img src="../IMAGES/BUTTON/MAIN/NEW24.gif" alt="ADD" name="Image8" width="24" height="24" border="0" align="absmiddle"></a> 
                    <a href="javascript:update();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image9','','../IMAGES/BUTTON/SWAP/EDIT_SWAP24.gif',1)"><img src="../IMAGES/BUTTON/MAIN/EDIT24.gif" alt="EDIT" name="Image9" width="24" height="24" border="0" align="absmiddle"></a> 
                    <a href="javascript:edelete();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image10','','../IMAGES/BUTTON/SWAP/DEL_SWAP24.gif',1)"><img src="../IMAGES/BUTTON/MAIN/DEL24.gif" alt="DELETE" name="Image10" width="24" height="24" border="0" align="absmiddle"></a> 
                    <a href="javascript:search();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image11','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP24.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH24.gif" alt="SEARCH" name="Image11" width="24" height="24" border="0" align="absmiddle"></a> 
                    <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image12','','../IMAGES/BUTTON/SWAP/PROCESS_SWAP24.gif',1)"><img src="../IMAGES/BUTTON/MAIN/PROCESS24.gif" alt="PROCESS LOG" name="Image12" width="24" height="24" border="0" align="absmiddle"></a> 
                    <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image13','','../IMAGES/BUTTON/SWAP/HELP_SWAP24.gif',1)"><img src="../IMAGES/BUTTON/MAIN/HELP24.gif" name="Image13" width="24" height="24" border="0" align="absmiddle"></a> 
                    <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image14','','../IMAGES/BUTTON/SWAP/EXIT_SWAP24.gif',1)"><img src="../IMAGES/BUTTON/MAIN/EXIT24.gif" alt="EXIT" name="Image14" width="24" height="24" border="0" align="absmiddle"></a></div></td>
              </tr>
            </table>	  
	  <table cellpadding="0" cellspacing="0">
          <tr> 
            <td class="blankspace" ></td>
          </tr>          
          <tr> 
            <td>
				<table border="0" cellpadding="0" cellspacing="0">
                <tr> 
                  <td width="62"></td>
                  <td width="254"><div align="left"><strong><u><script language="JavaScript">swapLang('Field Name');</script> : &nbsp;</u></strong></div></td>
                  <td width="262"><div align="left"><strong><u><script language="JavaScript">swapLang('Field Value');</script> : &nbsp;</u></strong></div></td>
                  <td width="62"></td>
                </tr>
                <%
          			//สร้าง Hash เก็บ field ที่ไม่ต้องการ เช่น edit verify
					MyHashMap hm = new MyHashMap();
						hm.put("edit_by","edit_by");
						hm.put("edit_date","edit_date");
						hm.put("edit_time","edit_time");
						hm.put("verified","verified");
						hm.put("approve","approve");						
						hm.put("runno","runno");
						hm.put("companyid","companyid");
				%>
				<%
						DbRecord dbRec = inq.getCurrentDbRecord();
						// keyField ใน Table
						MyHashMap hKey = new MyHashMap();
						StringTokenizer stKey = new StringTokenizer(dbRec.getListKey(),",");
						while (stKey.hasMoreTokens()){
							String KeyName = stKey.nextToken().toLowerCase();	
							if (hm.get(KeyName)==null){		
								hKey.put(KeyName,KeyName);
				%>
				<tr> 
                  <td></td>
                  <td><strong><%=inq.getCurrentDbRecord().getField(KeyName).getDescription() %> *</strong></td>
                  <td><input type="text" value="<%=inq.getString(KeyName)%>"></td>
                  <td></td>
                </tr>
				<% } } %>				
				<%		    
					// Field ต่าง ๆ ใน Table      		
        		  	StringTokenizer st = new StringTokenizer(dbRec.getFieldList(),",");
					while (st.hasMoreTokens()){
						String fieldName = st.nextToken().toLowerCase();	
						//เช็กว่า fieldname ต้องไม่อยู่ ใน Hash
						if ((hm.get(fieldName)==null)&&(hKey.get(fieldName)==null)){						
        		  %>
                <tr> 
                  <td></td>
                  <td><%=inq.getCurrentDbRecord().getField(fieldName).getDescription() %></td>
                  <td><input type="text" value="<%=inq.getString(fieldName)%>"></td>
                  <td></td>
                </tr>                	
                <% } } %>
              </table>
			</td>
          </tr>        
          <tr> 
           <td class="blankspace" ></td>
          </tr>
        </table>
	  </td>
  </tr>
</table>  
</form>
</body>
</html>