/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 3542

Added by ben leinfelder about 17 years ago

add ability to retrieve response data using datamanager lib (note that this requires both the datamanager.jar and firstMetacatIntegration.jar from /eml and /first modules respectively...)
yes, this is more ajax...and still mostly Proof Of Concept-ish

     <%@page import="java.sql.ResultSet"%>
     <%@page import="edu.ucsb.nceas.first.metacat.client.AssessmentQuery"%>
     <%@page import="java.util.*"%>
     <%
     String[] docids = request.getParameterValues("docids");
     if (docids != null && docids.length > 0) {
     	List assessmentDocIds = Arrays.asList(docids);
     	//make a title
     	String tableTitle = "Showing data for ";
     	for (int i=0; i<docids.length; i++) {
     		tableTitle += docids[i];
     		tableTitle +=", ";
+    	}
     	tableTitle = tableTitle.substring(0, tableTitle.length()-2);
     	//AssessmentQuery.testEcogrid("edml.4.5");
     	ResultSet rs = AssessmentQuery.selectResponseData(assessmentDocIds);
     	int numColumns = rs.getMetaData().getColumnCount();
     %>
     <!-- <h3><%=tableTitle %></h3> -->
     <table>
     <!--
     <tr>
     	<th colspan="<%=numColumns %>"><%=tableTitle %></th>
     </tr>
     -->
     <tr>
     <% for (int i=1; i<=numColumns; i++) { %>
     	<th><%=rs.getMetaData().getColumnName(i) %></th>
     <% } %>
     </tr>
     <%
     while (rs.next()) {
     	//System.out.println("rs:" + rs.getInt(1));
     %>
     	<tr>
     <% for (int i=1; i<=numColumns; i++) { %>
     		<td><%=rs.getInt(i) %></td>
     <% } %>
     	</tr>
     <%
+    }
     %>
     </table>
     <%}//end if %>

     	<xsl:template match="/">
     		<script language="JavaScript">
               <![CDATA[
               submitform = function(action,form_ref) {
               submitform = function(action,docid,form_ref) {
                   form_ref.action.value=action;
                   form_ref.docid.value=docid;
                   form_ref.sessionid.value="]]><xsl:value-of select="$sessid" /><![CDATA[";
                   //form_ref.qformat.value="]]><xsl:value-of select="$qformat" /><![CDATA[";
                   form_ref.submit();
+              }
               setSelect = function(form_ref, checkBoxName, checked) {
                   var formElements = form_ref.elements;
                   for (var i=0; i<formElements.length; i++) {
                   	var myElement = formElements[i];
                   	if (myElement.name == checkBoxName) {
                   		myElement.checked = checked;
+                  	}
+                  }
+              }
               ]]>
             </script>
             <script type="text/javascript" language="Javascript">
     			<![CDATA[
     			getResponseData = function(docid, divId) {
     				var styleURL = "/knb/style/skins/first";
     				styleURL += "/assessmentQuery.jsp";
     				//alert("calling ajax: " + styleURL);
     				//alert("docid: " + docid);
     				var myUpdate = new Ajax.Updater(
     					divId,
     					styleURL,
     					{	method: 'post',
     						parameters: { docids: docid},
     						//parameters: $('responseDataSearch').serialize(true),
     						evalScripts: true,
     						//onSuccess: function(transport) {alert('success: ' + transport.status);},
     						onFailure: function(transport) {alert('failure making ajax call');}
     					 });
     				Element.show(divId);
     				//alert("done calling response ajax");
+    			}
     			getMergedResponseData = function(formId,divId) {
     				var styleURL = "/knb/style/skins/first";
     				styleURL += "/assessmentQuery.jsp";
     				//alert("calling ajax: " + styleURL);
     				//alert("docid: " + docid);
     				var myUpdate = new Ajax.Updater(
     					divId,
     					styleURL,
     					{	method: 'post',
     						//parameters: { docid: docid},
     						parameters: $(formId).serialize(true),
     						evalScripts: true,
     						//onSuccess: function(transport) {alert('success: ' + transport.status);},
     						onFailure: function(transport) {alert('failure making ajax call');}
     					 });
     				Element.show(divId);
     				//alert("done calling response ajax");
+    			}
     			hideDiv = function(divId) {
     				Element.hide(divId);
+    			}
     		 ]]>
     		</script>
     		<p class="emphasis"><xsl:number value="count(resultset/document)" /> found</p>
-...
     		<xsl:if test="count(resultset/document) &gt; 0">
     			<form action="/knb/metacat" method="POST" id="assessmentForm" name="assessmentForm">
     				<input type="hidden" name="qformat" value="first" />
     				<input type="hidden" name="sessionid" />
     				<input type="hidden" name="action" value="read" />
     				<input type="hidden" name="docid" />
     				<br/>
     				Select:
     				<a>
     					<xsl:attribute name="href">javascript:setSelect(document.assessmentForm, 'docids', true)</xsl:attribute>
     					<xsl:text>All</xsl:text>
     				</a>
+    				/
     				<a>
     					<xsl:attribute name="href">javascript:setSelect(document.assessmentForm, 'docids', false)</xsl:attribute>
     					<xsl:text>None</xsl:text>
     				</a>
     				<br/>
     				Actions:
     				<a>
     					<xsl:attribute name="href">javascript:getMergedResponseData('assessmentForm','mergedResponseData')</xsl:attribute>
     					<xsl:text>Merge Selected</xsl:text>
     				</a>
+    				/
     				<a>
     					<xsl:attribute name="href">javascript:hideDiv('mergedResponseData')</xsl:attribute>
     					<xsl:text>Hide</xsl:text>
     				</a>
     				<br/>
     				<div id="mergedResponseData"/>
     				<br/>
     			<table width="95%" align="left" border="0" cellpadding="0"
     				cellspacing="0">
     				<tr>
-...
     				<xsl:for-each select="resultset/document">
     					<xsl:sort select="./param[@name='assessment/@assessmentId']" />
     					<xsl:variable name="divId">
     						<xsl:text>ajaxDiv</xsl:text><xsl:value-of select="./docid" />
     					</xsl:variable>
     					<tr valign="top" class="subpanel">
     						<xsl:attribute name="class">
                    <xsl:choose>
                      <xsl:when test="position() mod 2 = 1">rowodd</xsl:when>
                      <xsl:when test="position() mod 2 = 0">roweven</xsl:when>
                    </xsl:choose>
                  </xsl:attribute>
     			               <xsl:choose>
     			                 <xsl:when test="position() mod 2 = 1">rowodd</xsl:when>
     			                 <xsl:when test="position() mod 2 = 0">roweven</xsl:when>
     			               </xsl:choose>
     			             </xsl:attribute>
     						<td class="text_plain">
     							<form action="/knb/metacat" method="POST">
     								<xsl:attribute name="name">
                        <xsl:value-of
     										select="translate(./docid, '()-.', '____')" />
                      </xsl:attribute>
     								<input type="hidden" name="qformat" value="first" />
     								<input type="hidden" name="sessionid" />
     								<xsl:if
     									test="$enableediting = 'true'">
     									<input type="hidden"
     										name="enableediting" value="{$enableediting}" />
     								</xsl:if>
     								<input type="hidden" name="action"
     									value="read" />
     								<input type="hidden" name="docid">
     									<xsl:attribute name="value">
                          <xsl:value-of select="./docid" />
                        </xsl:attribute>
     								</input>
     								<xsl:for-each select="./relation">
     									<input type="hidden" name="docid">
     										<xsl:attribute name="value">
                            <xsl:value-of select="./relationdoc" />
                          </xsl:attribute>
     									</input>
     								</xsl:for-each>
     								<a>
     									<xsl:attribute name="href">javascript:submitform('read',document.<xsl:value-of select="translate(./docid, '()-.', '____')" />)</xsl:attribute>
     									<xsl:text>&#187;&#160;</xsl:text>
     									<xsl:value-of select="./param[@name='assessment/@assessmentTitle']" />
     									<!-- <xsl:value-of select="./param[@name='assessment/@assessmentId']" />) -->
     								</a>
     								(<xsl:value-of select="./docid" />)
     							</form>
     							<a>
     								<xsl:attribute name="href">javascript:submitform('read','<xsl:value-of select="./docid" />',document.assessmentForm)</xsl:attribute>
     								<xsl:text>&#187;&#160;</xsl:text>
     								<xsl:value-of select="./param[@name='assessment/@assessmentTitle']" />
     								<!-- <xsl:value-of select="./param[@name='assessment/@assessmentId']" />) -->
     							</a>
     							(<xsl:value-of select="./docid" />)
     							<br />
     							Response Data...
     							<input type="checkbox" name="docids">
     								<xsl:attribute name="value">
     									<xsl:value-of select="./docid" />
     								</xsl:attribute>
     							</input>
     							<br/>
     							<a>
     								<xsl:attribute name="href">javascript:getResponseData('<xsl:value-of select="./docid" />', '<xsl:value-of select="$divId" />')</xsl:attribute>
     								<xsl:text>View</xsl:text>
     							</a>
+    							/
     							<a>
     								<xsl:attribute name="href">javascript:hideDiv('<xsl:value-of select="$divId" />')</xsl:attribute>
     								<xsl:text>Hide</xsl:text>
     							</a>
     							<!--
+    							/
     							<a>
     								<xsl:attribute name="href">javascript:getMergedResponseData('assessmentForm','mergedResponseData')</xsl:attribute>
     								<xsl:text>Merge Selected</xsl:text>
     							</a>
     							 -->
     							<div>
     								<xsl:attribute name="id">
     									<xsl:value-of select="$divId" />
     								</xsl:attribute>
     							</div>
     						</td>
     						<td class="text_plain">
-...
     					</tr>
     				</xsl:for-each>
     			</table>
     			</form>
     		</xsl:if>
     	</xsl:template>

Also available in: Unified diff

Project

General

Profile

Metacat

Revision 3542

Added by ben leinfelder about 17 years ago