Project

General

Profile

« Previous | Next » 

Revision 3669

Added by ben leinfelder almost 17 years ago

add support for selecting records for only one question from a set of one or more assessment response data files

View differences:

lib/style/skins/first/assessmentQuery.jsp
6 6 
import="java.io.*"%><%
7 7 

  		




  8
  8
  
    
String[] docids = request.getParameterValues("docids");


  		




  
  9
  
    
String questionId = request.getParameter("questionId");


  		




  9
  10
  
    
String qformat = request.getParameter("qformat");


  		




  10
  11
  
    

  		




  11
  12
  
    
if (docids != null && docids.length > 0) {


  		




  ......




  25
  26
  
    
	fileName += ".csv";


  		




  26
  27
  
    
	


  		




  27
  28
  
    
	//AssessmentQuery.testEcogrid("edml.4.5");


  		




  28
  
  
    
	ResultSet rs = AssessmentQuery.selectResponseData(assessmentDocIds);


  		




  
  29
  
    
	ResultSet rs = AssessmentQuery.selectResponseData(assessmentDocIds, questionId, "=", new Integer(1));


  		




  29
  30
  
    
	


  		




  30
  31
  
    
	if (rs == null) {


  		




  31
  32
  
    
		return;


  		




  ......




  40
  41
  
    
		Writer writer = new OutputStreamWriter(response.getOutputStream());


  		




  41
  42
  
    
		CSVWriter csv = new CSVWriter(writer, CSVWriter.DEFAULT_SEPARATOR, CSVWriter.NO_QUOTE_CHARACTER);


  		




  42
  43
  
    
		csv.writeAll(rs, true);


  		




  
  44
  
    
		csv.flush();


  		




  43
  45
  
    
		


  		




  44
  46
  
    
		response.flushBuffer();


  		




  45
  47
  
    
		


  		












  

    
      lib/style/skins/first/first-assessment-resultset.xsl
    
  





  63
  63
  
    
				styleURL += "/assessmentQuery.jsp";


  		




  64
  64
  
    
				return styleURL;


  		




  65
  65
  
    
			}	


  		




  66
  
  
    
			getResponseData = function(docid, divId) {


  		




  
  66
  
    
			getResponseData = function(docid, divId, questionId) {


  		




  67
  67
  
    
				var styleURL = getResponseDataURL();


  		




  68
  68
  
    
																				


  		




  69
  69
  
    
				//alert("calling ajax: " + styleURL);


  		




  70
  70
  
    
				//alert("docid: " + docid);


  		




  
  71
  
    
				//alert("questionId: " + questionId);


  		




  71
  72
  
    
				


  		




  72
  73
  
    
				var myUpdate = new Ajax.Updater(


  		




  73
  74
  
    
					divId,


  		




  74
  75
  
    
					styleURL,


  		




  75
  76
  
    
					{	method: 'post',


  		




  76
  
  
    
						parameters: { docids: docid},


  		




  
  77
  
    
						parameters: { docids: docid, questionId: questionId },


  		




  77
  78
  
    
						//parameters: $('responseDataSearch').serialize(true),


  		




  78
  79
  
    
						evalScripts: true, 


  		




  79
  80
  
    
						//onSuccess: function(transport) {alert('success: ' + transport.status);},


  		




  ......




  93
  94
  
    
				//alert("calling ajax: " + styleURL);


  		




  94
  95
  
    
				//alert("docid: " + docid);


  		




  95
  96
  
    
				


  		




  
  97
  
    
				//transfer the assessmentItemId to this form


  		




  
  98
  
    
				document.getElementById("questionId").value = document.getElementById("assessmentItemId").value;


  		




  
  99
  
    
				//alert("questionId: " + document.getElementById("questionId").value);


  		




  
  100
  
    
				


  		




  96
  101
  
    
				var myUpdate = new Ajax.Updater(


  		




  97
  102
  
    
					divId,


  		




  98
  103
  
    
					styleURL,


  		




  ......




  116
  121
  
    
				


  		




  117
  122
  
    
				var styleURL = getResponseDataURL();


  		




  118
  123
  
    
				


  		




  
  124
  
    
				//transfer the assessmentItemId to this form


  		




  
  125
  
    
				document.getElementById("questionId").value = document.getElementById("assessmentItemId").value;


  		




  
  126
  
    
				//alert("questionId: " + document.getElementById("questionId").value);


  		




  
  127
  
    
				


  		




  119
  128
  
    
				var submitFormObj = document.getElementById(formId);


  		




  120
  129
  
    
				submitFormObj.qformat.value = 'csv';


  		




  121
  130
  
    
				submitFormObj.action = styleURL;


  		




  ......




  150
  159
  
    

  		




  151
  160
  
    
		<xsl:if test="count(resultset/document) &gt; 0">


  		




  152
  161
  
    

  		




  153
  
  
    
			<form action="/knb/metacat" method="POST" id="assessmentForm" name="assessmentForm">


  		




  
  162
  
    
			<form action="/knb/metacat" method="POST" id="assessmentForm" name="assessmentForm" >


  		




  154
  163
  
    
				<input type="hidden" name="qformat" value="first" />


  		




  155
  164
  
    
				<input type="hidden" name="sessionid" />


  		




  156
  165
  
    
				<input type="hidden" name="action" value="read" />


  		




  157
  166
  
    
				<input type="hidden" name="docid" />


  		




  
  167
  
    
				<xsl:element name="input">


  		




  
  168
  
    
					<xsl:attribute name="type">hidden</xsl:attribute>


  		




  
  169
  
    
					<xsl:attribute name="id">questionId</xsl:attribute>


  		




  
  170
  
    
					<xsl:attribute name="name">questionId</xsl:attribute>


  		




  
  171
  
    
					<xsl:attribute name="value"></xsl:attribute>


  		




  
  172
  
    
				</xsl:element>


  		




  158
  173
  
    
				


  		




  159
  174
  
    
				<br/>


  		




  160
  175
  
    
				Select:


  		




  ......




  245
  260
  
    
							</input>


  		




  246
  261
  
    
							<br/>


  		




  247
  262
  
    
							<a>


  		




  248
  
  
    
								<xsl:attribute name="href">javascript:getResponseData('<xsl:value-of select="./docid" />', '<xsl:value-of select="$divId" />')</xsl:attribute>


  		




  
  263
  
    
								<xsl:attribute name="href">javascript:getResponseData('<xsl:value-of select="./docid" />', '<xsl:value-of select="$divId" />', document.getElementById("assessmentItemId").value )</xsl:attribute>


  		




  249
  264
  
    
								<xsl:text>View</xsl:text>


  		




  250
  265
  
    
							</a>


  		




  251
  266
  
    
							/


  		












Also available in:  Unified diff