btnmw-was-app/Apps/MWUI/jsp/rekon/dataQuery_list.jsp

<%@ include file="../common/header.jsp"%>
<%
	if (seq==0){
		seq = (Integer) request.getAttribute("dataQuery_start");  
	}
%>
      
<script type="text/javascript" language="javascript">
<!--
		function page(start, count){
			document.forms.dataQuery.start.value=start;
			document.forms.dataQuery.count.value=count;

			document.forms.dataQuery.action.value="list";
			document.forms.dataQuery.submit();
			doDisable(document.forms.dataQuery, "button");
		}


		function doChangePage(count){
			document.forms.dataQuery.start.value= (document.forms.dataQuery.startx.value-1)*20;
			if(document.forms.dataQuery.start.value=="NaN") document.forms.dataQuery.start.value = 0;
			document.forms.dataQuery.count.value=count;

			document.forms.dataQuery.action.value="list";
			document.forms.dataQuery.submit();
			doDisable(document.forms.dataQuery, "button");
		}

		function doCreate(){
			document.forms.dataQuery.action.value="create";
			document.forms.dataQuery.submit();
			doDisable(document.forms.dataQuery, "button");
		}

		function fillIndex(val){
			document.forms.dataQuery.startx.value = val.value;
		}
	

		function doDetail(dataqueryPk){
			document.forms.dataQuery.dataqueryPk.value=dataqueryPk;
			document.forms.dataQuery.action.value="detail";
			document.forms.dataQuery.submit();
		}

		function doFilter(){
			document.forms.dataQuery.action.value="list";
			document.forms.dataQuery.submit();
			doDisable(document.forms.dataQuery, "button");
		}

		function doReset(){
			document.forms.dataQuery.dataQuery_dbconnectionFk_filter.value="";
			document.forms.dataQuery.dataQuery_queryCode_filter.value="";
			
			document.forms.dataQuery.clear.value="true";
			document.forms.dataQuery.action.value="list";
			document.forms.dataQuery.submit();
			doDisable(document.forms.dataQuery, "button");
		}

		function doOrder(field, type){
			document.forms.dataQuery.dataQuery_fieldOrder.value=field;
			document.forms.dataQuery.dataQuery_orderType.value=type;

			document.forms.dataQuery.action.value="list";
			document.forms.dataQuery.submit();
			doDisable(document.forms.status, "button");
		}
	-->
</script>
<!-- CONTENT -->
<form name="dataQuery" method="post" action="dataQuery.do">
<input type="hidden" name="start" value="">
<input type="hidden" name="startx" value="">
<input type="hidden" name="action" value="">
<input type="hidden" name="count" value="">
<input type="hidden" name="clear" value="">
<input type="hidden" name="dataqueryPk" value="">
<input type="hidden" name="dataQuery_fieldOrder" value="<bean:write name="dataQuery_fieldOrder"/>">
<input type="hidden" name="dataQuery_orderType" 	value="<bean:write name="dataQuery_orderType"/>">
<input type="hidden" name="focus_field" value=""/>

<!--td width="80%" valign="top"-->
	<table width="100%" border="0" align="center" cellpadding="2" cellspacing="4"> 
	  <tr>
		<td class="titleHeader"><bean:message key="project.dataQuery.key"/> - LIST</td>
	  </tr>
	  <tr>
		<td><%@ include file="../common/paging.jsp"%> 
		</td> 
	</tr> 
	</table> 
 	<table width="100%" border="0" cellspacing="1" cellpadding="1"> 
		<tr>
			<td width="5%" class="titleField"><div align="center">#</div></td>
			<td align="left" height="10" valign="top" class="titleField"><bean:message key="dataQuery.querycode.key" /> 
				<logic:equal name="dataQuery_fieldOrder" value="queryCode">
					<logic:equal name="dataQuery_orderType" value="ASC">
						<a href="#" onclick="doOrder('queryCode', 'DESC');"><img src="./images/arrow_down.gif" border="0"></a>
					</logic:equal>
					<logic:equal name="dataQuery_orderType" value="DESC">
						<a href="#" onclick="doOrder('queryCode', 'ASC');"><img src="./images/arrow_up.gif" border="0"></a>
					</logic:equal>
				</logic:equal> 
				<logic:notEqual name="dataQuery_fieldOrder" value="queryCode">
					<a href="#" onclick="doOrder('queryCode', 'ASC');"><img src="./images/arrow.gif" border="0"></a>
				</logic:notEqual>
			</td>
			<td align="left" height="10" valign="top" class="titleField"><bean:message key="dataQuery.dbconnectionFk.key" /> 
				<logic:equal name="dataQuery_fieldOrder" value="dbconnectionFk.dsn">
					<logic:equal name="dataQuery_orderType" value="ASC">
						<a href="#" onclick="doOrder('dbconnectionFk.dsn', 'DESC');"><img src="./images/arrow_down.gif" border="0"></a>
					</logic:equal>
					<logic:equal name="dataQuery_orderType" value="DESC">
						<a href="#" onclick="doOrder('dbconnectionFk.dsn', 'ASC');"><img src="./images/arrow_up.gif" border="0"></a>
					</logic:equal>
				</logic:equal> 
				<logic:notEqual name="dataQuery_fieldOrder" value="dbconnectionFk.dsn">
					<a href="#" onclick="doOrder('dbconnectionFk.dsn', 'ASC');"><img src="./images/arrow.gif" border="0"></a>
				</logic:notEqual>
			<td width="5%" class="titleField">&nbsp;</td>
		</tr>	
		<logic:notEmpty name="dataQueryList">
			<logic:iterate id="element" name="dataQueryList" scope="request" indexId="index">
			<% 
				sequence++;
				String bgcolor = "FFFFFF";
				if(sequence%2 == 0){
					bgcolor = "EDEDE8";
				}
			%>
				<tr bgcolor="<% out.print(bgcolor); %>" onmouseover="mOvr(this);"  onmouseout="mOut(this, '<% out.print(bgcolor); %>');">
				<td align="center" class="celBorder"><%=++seq%>&nbsp;</td>
					<td align="left" class="celBorder">
						&nbsp;<bean:write name="element" property="dataqueryPk"/>
					</td>
					<td align="left" class="celBorder">
						&nbsp;<bean:write name="element" property="dbconnectionFk.dsn"/>
					</td>
					<td align="center" class="celBorder" ><a href="#" ><img src="./images/detail.gif" border="0" onclick="doDetail('<bean:write name="element" property="dataqueryPk"/>');" alt="see detail"/></a>
				</td>
				</tr>
			</logic:iterate>
		</logic:notEmpty>
	</TABLE> 
	
   	<table width="100%" border="0" align="center" cellpadding="2" cellspacing="4"> 
		<tr> 
			<td class="search"><bean:message key="project.search.key" /></td>
        </tr> 
    </table>
    <table width="100%" border="0" cellspacing="1" cellpadding="2">
		<tr>
			<td width="20%"><b><bean:message key="dataQuery.querycode.key"/></b></td>
			<td width="1%">:</td>
			<td width="29%">
			<label> 
				<input type="text" name="dataQuery_queryCode_filter" value="<logic:notEmpty name="dataQuery_queryCode_filter"><bean:write name="dataQuery_queryCode_filter"/></logic:notEmpty>">
			</label>
			</td>
		</tr>
		<tr>
			<td width="20%"><b><bean:message key="dataQuery.dbconnectionFk.key"/></b></td>
			<td width="1%">:</td>
			<td width="29%">
			<label> 
				<select name="dataQuery_dbconnectionFk_filter">
						<option value="">--- Select Connection ---</option>
						<logic:notEmpty name="dbconnectionFkList">
						<logic:iterate id="dbconnectionFkElement" name="dbconnectionFkList">
							<option value="<bean:write name="dbconnectionFkElement" property="dbconnectionPk"/>" 
								<logic:equal name="dbconnectionFkElement" property="dbconnectionPk" value="${dataQuery_dbconnectionFk_filter}">
									SELECTED
								</logic:equal>
							>
							<bean:write name="dbconnectionFkElement" property="dsn"/></option>
						</logic:iterate>
						</logic:notEmpty>
				</select>				
			</label>
			</td>
		</tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td colspan="3" align="left">
			<input type="button" size="50" maxlength="25" value="<bean:message key="button.reset"/>" onclick="doReset();"/>
			&nbsp;&nbsp;
			<input type="button" value="<bean:message key="button.search"/>" onclick="doFilter();"/>
		  </td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>	  
    </table>
 </td>
 </form>
<!-- END CONTENT -->   
<logic:notEmpty name="focus"><bean:write name="focus" filter="false" /></logic:notEmpty> 
<%@ include file="../common/footer.jsp"%>