<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,java.util.StringTokenizer"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.utilities.*" %>
<jsp:useBean id="PRU123" class="com.csc.library.system.Task" scope="page" />
<jsp:useBean id="PRU123_single" class="com.csc.library.system.Task" scope="session"/>
<%
PRU123_single.setChannel(request,response);
UIManager screen_single = (UIManager) PRU123_single.process("SingleEntry","PRU123");
PRU123.setChannel(request,response);
HelpEntry screen = (HelpEntry) PRU123.process("HelpEntry","PRU123HELP");
screen.getInquiry().setFilter("VERIFY_STATUS=' ' AND EDIT_BY<>'"+screen.getUProfile().getUserId()+"'");
screen.setMaxLine(15);
screen.verifyOff();
screen.process();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script type='text/javascript' src='../JS/SCREEN.js'></script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script language='javascript'>setLang('<%=PRU123.getUProfile().get("lang")%>');</script>
<script src="../JS/VIEWCALENDAR.js"></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 checkAll(){
with(document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox"){
elements[i].checked=true;
//alert(elements[i].value);
}
}//end for
}//end with
}//end function
function decheckAll(){
with(document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox"){
elements[i].checked=false;
//alert(elements[i].value);
}
}//end for
}//end with
}//end function
//-->
function goConfirm(){
var str;
bCon=confirm("ต้องการ Verify ข้อมูลหรือไม่ ?");
if (bCon==true) {
for (var i=0;i<document.forms[0].length;i++){
current = document.forms[0].elements[i];
if(current.name.indexOf("checkbox")>=0){
current.value="s>--<"+current.value;
str = eval("document.cscform.__remark_"+current.name.substring(11,current.name.length)+".value");
current.value=current.value+">--<"+str;
//alert("current="+current+",current.name="+current.name+",value="+current.value);
//alert(current.value);
}
}
save();
}
}
function goCancle(){
bCon=confirm("ต้องการยกเลิกการ Verify ข้อมูล ?");
if (bCon==true) {
for (var i=0;i<document.forms[0].length;i++){
current = document.forms[0].elements[i];
if(current.name.indexOf("checkbox")>=0){
current.value="c>--<"+current.value;
str = eval("document.cscform.__remark_"+current.name.substring(11,current.name.length)+".value");
current.value=current.value+">--<"+str;
//alert("current="+current+",current.name="+current.name+",value="+current.value);
}
}
save();
}
}
function linkRefer(tablename,fixcon){
with(document.cscform){
var param="CS021.jsp?__tablename="+tablename+"&__fixCon="+eval(fixcon+".value");
window.open(param,"Help","left=150,top=150,width=500,height=200,toolbar=no,status=yes,scrollbars=yes");
}
}
</script>
</head>
<body leftmargin="0" topmargin="0" onLoad="MM_preloadImages('IMAGES/BUTTON/SWAP/SEARCH_SWAP24.gif','IMAGES/BUTTON/SWAP/EXIT_SWAP24.gif','IMAGES/BUTTON/SWAP/HELP_SWAP24.gif','IMAGES/BUTTON/SWAP/NEW_SWAP24.gif','IMAGES/BUTTON/SWAP/EDIT_SWAP24.gif','IMAGES/BUTTON/SWAP/DEL_SWAP24.gif','IMAGES/BUTTON/SWAP/PROCESS_SWAP24.gif')">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<div class="centered">
<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="__screen" value="PRU123">
<input type="hidden" name="__confirm" value="">
<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__referPage" value="">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__language" value="<%=PRU123.getUProfile().get("lang")%>">
<input type="hidden" name="__user" value="<%=PRU123.getUProfile().getUserId()%>">
<input type="hidden" name="__companyid"value='<%=PRU123.getUProfile().get("companyid")%>'>
<br>
<div align="center">
<table width="645" cellpadding="0" cellspacing="0">
<tr>
<td width="643" colspan="2" class="header">PRU123, <script language="JavaScript">swapLang('Confirm Data Adjustment');</script> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" class="blankspace"></td>
</tr>
<tr>
<td width="85" align="right"><script language="javascript">swapLang('Order By');</script> </td>
<td width="374">
<SELECT NAME='__listOrder' SIZE='' onClick="" onChange="javascript:setOrderby();" onMouseOver="" onMouseOut="" >
<OPTION VALUE="LVERIFYMASTER.VERIFYID" <% if((request.getParameter("__orderBy")!=null)&&request.getParameter("__orderBy").equals("LVERIFYMASTER.VERIFYID")){ out.print(" selected "); }%>> VERIFYID </OPTION>
<OPTION VALUE="LVERIFYMASTER.TABLE_NAME,LVERIFYMASTER.FIELD_NAME" <% if((request.getParameter("__orderBy")!=null)&&request.getParameter("__orderBy").equals("LVERIFYMASTER.TABLE_NAME,LVERIFYMASTER.FIELD_NAME")){ out.print(" selected "); }%>> TABLE_NAME </OPTION>
<OPTION VALUE="LVERIFYMASTER.FIELD_NAME" <% if((request.getParameter("__orderBy")!=null)&&request.getParameter("__orderBy").equals("LVERIFYMASTER.FIELD_NAME")){ out.print(" selected "); }%>> FIELD_NAME </OPTION>
<OPTION VALUE="LVERIFYMASTER.EDIT_BY" <% if((request.getParameter("__orderBy")!=null)&&request.getParameter("__orderBy").equals("LVERIFYMASTER.EDIT_BY")){ out.print(" selected "); }%>> EDIT_BY </OPTION>
</SELECT>
</td>
<td width="37"></td>
<td width="112"><div align="center"><font color="#6666CC"><%=screen.getPageTag()%></font></div></td>
<td width="32"></td>
</tr>
<tr>
<td colspan="5">
<% int i=0;
DbRecord rec;
String tableName,fieldName,refer,keyName;
StringTokenizer st;
FieldManager fm,f;
String con="";
String referDesc="";
while(screen.nextRec()){
if(screen.checkLinePage()){
rec= new InitialRecord(screen.getUProfile()).getDbRecord(screen.getString("table_name"));
rec.setProperties(true);
tableName = rec.getDescription();
refer = screen.getString("refer");
con = screen.getString("key_group");
referDesc=screen.getString("VERIFY_DESC");
referDesc=referDesc.replace("\"".charAt(0),' ');
refer = refer.replace("\"".charAt(0),' ');
st = new StringTokenizer(rec.getListKey(),",");
while (st.hasMoreTokens()){
keyName = st.nextToken();
fm = rec.getField(keyName);
FileString fStr = new FileString();
fStr.setData(refer);
fStr.replaceAll(keyName,fm.getDescription());
fStr.replaceAll("AND",",");
refer = fStr.getData();
FileString fStr2 = new FileString();
fStr2.setData(con);
fStr2.replaceAll("=","$");
con = fStr2.getData();
}
%>
<table width="640" height="" border="0" cellpadding="0" cellspacing="0" class="inner">
<tr>
<td colspan="7" class="blankspace"></td>
</tr>
<%
String referValue = screen.getString("refer");
referValue = referValue.replace((char)34,(char)39);
String valueData="";
if (screen.getString("new_value").equals("")||screen.getString("new_value")==null){
valueData = "newdataisempty";
} else valueData=screen.getString("new_value").trim();
%>
<tr>
<td height="20" class="row3" width ="20"><div align="right">
<input type="checkbox" name="__checkbox_<%=i%>" value="<%=screen.getString("verifyid")%>>--<<%=screen.getString("status")%>>--<<%=screen.getString("verify_group")%>>--<<%=screen.getString("table_name")%>>--<<%=screen.getString("field_name")%>>--<<%=valueData%>>--<<%=referValue%>>--<<%=screen.getString("screenname")%>>--<<%=screen.getString("companyid")%>>--<<%=screen.getString("refer")%>>--<<%=screen.getString("key_group")%>>--<<%=screen.getString("edit_by")%>">
</div></td>
<td width="112" height="20" class="row3"><div align="right"><script language="JavaScript">swapLang('Table Name');</script> : </div></td>
<td width="111" height="20" class="row3"> <div align="left">
<input name="__table_name_<%=i%>" type="text" size="15" maxlength="15" disabled value="<%=tableName%>">
</div></td>
<td width="87" class="row3"><div align="right"><script language="JavaScript">swapLang('Field Name');</script> : </div></td>
<td class="row3" width="123"><div align="left">
<%
if (screen.getString("status").equalsIgnoreCase("U")){
f = rec.getField(screen.getString("field_name"));
fieldName = f.getDescription();
} else fieldName = screen.getString("field_name");
%>
<input name="__field_name_<%=i%>" type="text" size="15" maxlength="15" disabled value="<%=fieldName%>">
</div></td>
<td class="row3" width="83"> <input type="hidden" value="<%=screen.getString("refer")%>" name="refer_<%=i%>"></td>
<td class="row3" width="104">
<div align="center"><a href ="<%=screen.getString("screenname")%>.jsp?__help=__<%=con%>&__referPage=true&__recVerify=true&__editBy=<%=screen.getString("edit_by")%>" target="__blank"><img src="IMAGES/BUTTON/REFER.gif" height="20" border="0"></a></div>
</td>
</tr>
<tr>
<td class="row3"></td>
<td class="row3"><div align="right"><script language="JavaScript">swapLang('Key Field');</script> : </div></td>
<td class="row3" colspan="3"><div align="left" >
<input name="__refer_<%=i%>" type="text" size="45" disabled value="<%=referDesc%>">
</div></td>
<td class="row3"> </td>
<td class="row3"> </td>
</tr>
<tr>
<td class="row3"></td>
<td class="row3"><div align="right"><script language="JavaScript">swapLang('Status');</script> : </div></td>
<td class="row3" colspan="3"><div align="left" >
<%
String rec_Status="";
if (screen.getString("status").equalsIgnoreCase("I")){
if (screen.getUProfile().get("lang").equalsIgnoreCase("ENG"))
rec_Status="Insert";
else rec_Status="บันทึกข้อมูล";
} else if (screen.getString("status").equalsIgnoreCase("U")){
if (screen.getUProfile().get("lang").equalsIgnoreCase("ENG"))
rec_Status="Update";
else rec_Status="แก้ไขข้อมูล";
} else if (screen.getString("status").equalsIgnoreCase("D")){
if (screen.getUProfile().get("lang").equalsIgnoreCase("ENG"))
rec_Status="Delete";
else rec_Status="ลบข้อมูล";
}
%>
<input name="__status_<%=i%>" type="text" size="45" disabled value="<%=rec_Status%>">
</div></td>
<td class="row3"> </td>
<td class="row3"> </td>
</tr>
<tr>
<td class="row3"></td>
<td class="row3"><div align="right"><script language="JavaScript">swapLang('Modify By');</script> : </div></td>
<td class="row3"><div align="left" >
<input name="__edit_by_<%=i%>" type="text" size="15" maxlength="15" disabled value="<%=screen.getString("edit_by")%>">
</div></td>
<td class="row3"><div align="right"><script language="JavaScript">swapLang('Date Time');</script> : </div></td>
<td class="row3"><div align="left">
<input name="__edit_date_<%=i%>" type="text" size="15" maxlength="15" disabled value="<%=screen.getString("edit_date")%> <%=screen.getString("edit_time")%>">
</div></td>
<td class="row3"> </td>
<td class="row3"> </td>
</tr>
<%if (screen.getString("status").equalsIgnoreCase("U")){%>
<tr>
<td class="row3"> </td>
<td class="row3"><div align="right"><script language="JavaScript">swapLang('Old Value');</script> : </div></td>
<td class="row3" colspan="3"><input name="__old_value_<%=i%>" type="text" size="30" disabled value="<%=screen.getString("old_value")%>"></td>
<td class="row3"> </td>
<td class="row3"> </td>
</tr>
<tr>
<td class="row3"> </td>
<td class="row3"><div align="right"><script language="JavaScript">swapLang('New Value');</script> : </div></td>
<td class="row3" colspan="3"><input name="__new_value_<%=i%>" type="text" size="30" disabled value="<%=screen.getString("new_value")%>"></td>
<td class="row3"> </td>
<td class="row3"> </td>
</tr>
<%}%>
<tr>
<td class="row3"> </td>
<td class="row3"><div align="right"><script language="JavaScript">swapLang('Remark');</script> : </div></td>
<td class="row3" colspan="3"><input name="__remark_<%=i%>" type="text" size="50" maxlength="50">
<%//=screen_single.getInput("remark")%>
</td>
<td class="row3"> </td>
<td class="row3"> </td>
</tr>
</table>
<% i++;%>
<%
}//end if
if(screen.outLinePage()){ break; }
} //end while%>
</td>
</tr>
<tr>
<td colspan="5" class="blankspace"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="5" class="blankspace"></td>
</tr>
<tr>
<td colspan="5">
<div align="center">
<a href="#" onClick="checkAll()"><img src="IMAGES/BUTTON/SELECTALL.gif" height="20" border="0" align="middle"></a>
<a href="#" onClick="decheckAll()"><img src="IMAGES/BUTTON/DESELECTALL.gif" height="20" border="0" align="middle"></a>
<a href="javascript:goConfirm();"><img src="IMAGES/BUTTON/CONFIRM.gif" height="20" border="0" align="middle"></a>
<a href="javascript:goCancle();"><img src="IMAGES/BUTTON/CANCEL.gif" height="20" border="0" align="middle"></a>
</div>
</td>
</tr>
<tr>
<td colspan="5" class="blankspace"></td>
</tr>
</table> </td>
</tr>
<tr>
<td class="bottom" >
</td>
</tr>
</table>
</div>
</form>
</div></body>
</html>