Blame view

WebRoot/WEB-INF/jsp/sunvote/homework/homework_report.jsp 16.5 KB
892c3766   =   1、增加练习报表页面
1
2
3
4
  <%@ page language="java" contentType="text/html; charset=UTF-8"
  	pageEncoding="UTF-8"%>
  <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
  <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
5361dc04   jack   1、小修改提交
5
  <%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn"%>
e7fce508   jack   1.修改练习报表(4)
6
  <%@ taglib prefix="myelfun" uri="/WEB-INF/tld/elfun.tld"%>
892c3766   =   1、增加练习报表页面
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
  <%
  	String path = request.getContextPath();
  	String basePath = request.getScheme() + "://"
  			+ request.getServerName() + ":" + request.getServerPort()
  			+ path + "/";
  %>
  
  <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  <html>
  <head>
  <base href="<%=basePath%>">
  
  <title>${info.CLASS_NAME}成绩报表</title>
  <base href="<%=basePath%>">
  <!-- 下拉框 -->
  <link rel="stylesheet" href="static/ace/css/chosen.css" />
    <link type="text/css" href="static/css/tablescroller.css" rel="stylesheet" />
3cc65186   =   1、修改练习报表页(1)
24
25
26
27
  
  <link
  	href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css"
  	rel="stylesheet">
892c3766   =   1、增加练习报表页面
28
29
30
31
32
  <!-- 日期框 -->
  <link rel="stylesheet" href="static/ace/css/datepicker.css" />
  <style>
  	.font span{    font-size: 12px;
      font-weight: initial;color:#000;}
1aab9692   =   1.修改练习报表页面(2)
33
34
      .search_btn{width:30px;}
      .btn{margin:0 5px;}
892c3766   =   1、增加练习报表页面
35
36
37
38
  	</style>
  </head>
  
  <body style="background:#fff;">
5361dc04   jack   1、小修改提交
39
40
41
42
43
44
45
46
  	
  	
  <div style="padding-top:3%;">
  
    <!-- Nav tabs -->
    <ul class="nav nav-tabs" role="tablist">
      
      
e7fce508   jack   1.修改练习报表(4)
47
48
      <c:forEach items="${pd.CLASSES}" var="var" varStatus="vs">
  		<li role="presentation" class="${vs.index==0?'active':''}"><a href="#${var.CLASS_ID}" aria-controls="${var.CLASS_ID}" role="tab" data-toggle="tab">${var.CLASS_NAME}</a></li>
5361dc04   jack   1、小修改提交
49
50
51
52
  	</c:forEach>
      
    </ul>
  
e7fce508   jack   1.修改练习报表(4)
53
  
5361dc04   jack   1、小修改提交
54
55
56
57
58
59
  			<div style="padding:20px 20px;">
  		<form action="report/report.do" method="post" name="Form" id="Form" style="margin-bottom:0;">
  			<input type="hidden" name="CLASSID" id="CLASSID" value="${var.ID}" />
  			<input type="hidden" name="ROLE" id="ROLE" value="${pd.ROLE}" />
  			<table style="margin-top:5px;margin-bottom:20px;">
  				<tr>
e7fce508   jack   1.修改练习报表(4)
60
61
  					<td><div style="width:150px;text-align:center;">课程统计: ${fn:length(pd.DATA.HOMEWORKS)}</div></td>
  					<td><div style="width:150px;text-align:center;">班级名册: ${myelfun:findClassName(pd.CLASS_ID)}</div></td>
1aab9692   =   1.修改练习报表页面(2)
62
  				
e7fce508   jack   1.修改练习报表(4)
63
  					<td><div style="width:150px;text-align:center;"><span>学生人数: ${fn:length(pd.DATA.STUDENTS)}</span></div></td>
5361dc04   jack   1、小修改提交
64
65
66
  					<td></td>
  					
  				
e7fce508   jack   1.修改练习报表(4)
67
  					
5361dc04   jack   1、小修改提交
68
69
70
  					<td style="padding-left:2px;">
  					<input
  						class="span10 date-picker" name="lastStart" id="lastStart"
e7fce508   jack   1.修改练习报表(4)
71
  						value="${pd.START_DATE}" type="text" data-date-format="yyyy-mm-dd"
5361dc04   jack   1、小修改提交
72
73
74
75
  						readonly="readonly" style="width:88px;" placeholder="开始日期"
  						title="开始日期" />
  						</td>
  					<td style="padding-left:2px;"><input
e7fce508   jack   1.修改练习报表(4)
76
  						class="span10 date-picker" name="lastEnd" id="lastEnd" value="${pd.END_DATE}"
5361dc04   jack   1、小修改提交
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
  						type="text" data-date-format="yyyy-mm-dd" readonly="readonly"
  						style="width:88px;" placeholder="结束日期" title="结束日期" /></td>
  					<td style="vertical-align:top;padding-left:2px"><a
  						class="btn btn-light btn-xs" onclick="tosearch();" title="检索"><img src="static/images/search.png" alt="" class="search_btn" /></a></td>
  					<td><li class="btn btn-default btn-sm">上一周</li></td>
  					<td><li class="btn btn-primary btn-sm">本周</li></td>
  					<td><li class="btn btn-default btn-sm">下一周</li></td>
  				</tr>
  			</table>
  			<hr />
  			<table id="simple-table"
  				class="table table-bordered table-hover"
  				style="margin-top:0px;margin-bottom:0px;">
  				<thead>
  					<tr>
  						<th class="center th_name"><div style="width:150px;">姓名</div></th>
  						<th class="center "><div style="width:150px;">课程平均得分率</div></th>
  						<th class="center"><div style="width:80px;">课程总分</div></th>
e7fce508   jack   1.修改练习报表(4)
95
  						<c:forEach items="${pd.DATA.HOMEWORKS}" var="var_h" varStatus="vs">
5361dc04   jack   1、小修改提交
96
  							<th class="center kc"><a
e7fce508   jack   1.修改练习报表(4)
97
  								 onclick="paper('${info.CLASS_ID}','${var.TESTPAPER_ID}');"><div style="width:180px;     margin: 0 auto;cursor:hand" class="font">${var_h.NAME}</br><span>${var_h.COMPLETE_DATE}</span></div></a></th>
5361dc04   jack   1、小修改提交
98
99
100
101
102
103
104
105
  						</c:forEach>
  					</tr>
  				</thead>
  				<tbody>
  					<tr>
  						<td class="center"><div style="width:150px;">班级课程总分</div></td>
  						<td class="center"><div style="width:150px;"></div></td>
  						<td class="center"><div style="width:80px;"></div></td>
e7fce508   jack   1.修改练习报表(4)
106
  						<c:forEach items="${pd.DATA.HOMEWORKS}" var="var_h" varStatus="vs">
5361dc04   jack   1、小修改提交
107
108
109
110
111
112
113
  							<td class="center"><div style="width:80px;margin:0 auto;">${var_h.ALL_SCORE}</div></td>
  						</c:forEach>
  					</tr>
  					<tr>
  						<td class="center"><div style="width:150px;">班级课程平均分</div></td>
  						<td class="center"><div style="width:150px;"></div></td>
  						<td class="center"><div style="width:80px;"></div></td>
e7fce508   jack   1.修改练习报表(4)
114
  						<c:forEach items="${pd.DATA.HOMEWORKS}" var="var_h" varStatus="vs">
2a880654   jack   1、登录界面添加记住密码功能
115
  							<td class="center"><div style="width:80px;margin:0 auto;">${var_h.GET_SCORE}</div></td>
5361dc04   jack   1、小修改提交
116
117
118
119
120
121
  						</c:forEach>
  					</tr>
  					<tr>
  						<td class="center"><div style="width:150px;">班级课程平均得分率</div></td>
  						<td class="center"><div style="width:150px;"></div></td>
  						<td class="center"><div style="width:80px;"></div></td>
e7fce508   jack   1.修改练习报表(4)
122
  						<c:forEach items="${pd.DATA.HOMEWORKS}" var="var_h" varStatus="vs">
2a880654   jack   1、登录界面添加记住密码功能
123
  							<td class="center"><div style="width:80px;margin:0 auto;">${var_h.GET_SCORE_PERSENT }</div></td>
5361dc04   jack   1、小修改提交
124
125
126
127
  						</c:forEach>
  					</tr>
  
  					<c:choose>
e7fce508   jack   1.修改练习报表(4)
128
129
  						<c:when test="${not empty pd.DATA.STUDENTS}">
  							<c:forEach items="${pd.DATA.STUDENTS}" var="var" varStatus="vs">
5361dc04   jack   1、小修改提交
130
131
132
133
134
135
136
137
138
139
  								<tr>
  									<%-- <td class="center"><a
  										href="report/student_report?studentid=${var.ID}&class_id=${info.CLASS_ID}">${var.NAME}</a>
  									</td> --%>
  									<td class="center"><div style="width:150px;cursor:hand"><a
  										 onclick="student('${info.CLASS_ID}','${var.STUDENT_ID}')">${var.NAME}</a></div>
  									</td>
  									<td class="center"><div style="width:150px;"><fmt:formatNumber type="number"
  											value="${var.TOTALSCORE == 0 ? 0: (var.GETSCORE / var.TOTALSCORE * 100)}"
  											maxFractionDigits="2" />%</div></td>
e7fce508   jack   1.修改练习报表(4)
140
141
  									<td class="center"><div style="width:80px;margin:0 auto;">${var.GET_SCORE_PERSENT }</div></td>
  									<c:forEach items="${pd.DATA.HOMEWORKS}" var="var1" varStatus="vs1">
5361dc04   jack   1、小修改提交
142
  										<td class="center"><div style="width:180px;margin:0 auto;"><c:set var="TEST_ID"
e7fce508   jack   1.修改练习报表(4)
143
  												value="${var1.HOMEWORK_ID}" /> ${var[TEST_ID] }</div></td>
5361dc04   jack   1、小修改提交
144
145
146
147
148
149
150
151
152
153
  									</c:forEach>
  								</tr>
  							</c:forEach>
  						</c:when>
  					</c:choose>
  				</tbody>
  			</table>
  			
  			<div id="scrollableTable"></div>
  		</form>
3cc65186   =   1、修改练习报表页(1)
154
  	</div>
5361dc04   jack   1、小修改提交
155
156
  			
  			
e7fce508   jack   1.修改练习报表(4)
157
  
5361dc04   jack   1、小修改提交
158
159
160
  
  </div>
  	
1aab9692   =   1.修改练习报表页面(2)
161
  	<hr />
892c3766   =   1、增加练习报表页面
162
163
164
165
166
167
168
169
170
171
172
  	<div style="padding:20px 20px;">
  		<form action="report/report.do" method="post" name="Form" id="Form" style="margin-bottom:0;">
  			<input type="hidden" name="CLASSID" id="CLASSID" value="${info.CLASS_ID}" />
  			<input type="hidden" name="ROLE" id="ROLE" value="${pd.ROLE}" />
  			<table style="margin-top:5px;margin-bottom:20px;">
  				<tr>
  					<td><div style="width:150px;text-align:center;">课程统计: ${info.testsize}</div></td>
  					<td><div style="width:150px;text-align:center;">班级名册: ${info.CLASS_NAME}</div></td>
  				
  					<td><div style="width:150px;text-align:center;"><span>学生人数: ${info.STUDENT_NUM}</span></div></td>
  					<td></td>
1aab9692   =   1.修改练习报表页面(2)
173
174
  					
  				
892c3766   =   1、增加练习报表页面
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
  					<c:if test="${not empty subjectInfos}">
  						<td>
  							<select class="chosen-select form-control" name="SUBJECT_ID" id="SUBJECT_ID" data-placeholder="这里输入所属学校">
  										<option value="">全部</option>
  										<c:forEach var="item" items="${subjectInfos}">
  											<option value="${item.SUBJECT_ID}" <c:if test="${pd.SUBJECT_ID == item.SUBJECT_ID }">selected = ture</c:if>>${item.SCNAME}</option>
  										</c:forEach>
  							</select>
  						</td>
  					</c:if>
  					<td style="padding-left:2px;">
  					<input
  						class="span10 date-picker" name="lastStart" id="lastStart"
  						value="${start_date}" type="text" data-date-format="yyyy-mm-dd"
  						readonly="readonly" style="width:88px;" placeholder="开始日期"
  						title="开始日期" />
  						</td>
  					<td style="padding-left:2px;"><input
  						class="span10 date-picker" name="lastEnd" id="lastEnd" value="${end_date}"
  						type="text" data-date-format="yyyy-mm-dd" readonly="readonly"
  						style="width:88px;" placeholder="结束日期" title="结束日期" /></td>
  					<td style="vertical-align:top;padding-left:2px"><a
1aab9692   =   1.修改练习报表页面(2)
197
198
  						class="btn btn-light btn-xs" onclick="tosearch();" title="检索"><img src="static/images/search.png" alt="" class="search_btn" /></a></td>
  					<td><li class="btn btn-default btn-sm">上一周</li></td>
d4647f91   =   1、修改练习报表页面(3)
199
  					<td><li class="btn btn-primary btn-sm">本周</li></td>
1aab9692   =   1.修改练习报表页面(2)
200
  					<td><li class="btn btn-default btn-sm">下一周</li></td>
892c3766   =   1、增加练习报表页面
201
202
  				</tr>
  			</table>
1aab9692   =   1.修改练习报表页面(2)
203
  			<hr />
892c3766   =   1、增加练习报表页面
204
  			<table id="simple-table"
3cc65186   =   1、修改练习报表页(1)
205
  				class="table table-bordered table-hover"
892c3766   =   1、增加练习报表页面
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
  				style="margin-top:0px;margin-bottom:0px;">
  				<thead>
  					<tr>
  						<th class="center th_name"><div style="width:150px;">姓名</div></th>
  						<th class="center "><div style="width:150px;">课程平均得分率</div></th>
  						<th class="center"><div style="width:80px;">课程总分</div></th>
  						<c:forEach items="${testpaperList}" var="var" varStatus="vs">
  							<th class="center kc"><a
  								 onclick="paper('${info.CLASS_ID}','${var.TESTPAPER_ID}');"><div style="width:180px;     margin: 0 auto;cursor:hand" class="font">${var.NAME}</br><span>${var.CREATE_DATE}</span></div></a></th>
  						</c:forEach>
  					</tr>
  				</thead>
  				<tbody>
  					<tr>
  						<td class="center"><div style="width:150px;">班级课程总分</div></td>
  						<td class="center"><div style="width:150px;"></div></td>
  						<td class="center"><div style="width:80px;"></div></td>
  						<c:forEach items="${testpaperList}" var="var" varStatus="vs">
  							<td class="center"><div style="width:80px;margin:0 auto;">${var.TOTAL_SCORE}</div></td>
  						</c:forEach>
  					</tr>
  					<tr>
  						<td class="center"><div style="width:150px;">班级课程平均分</div></td>
  						<td class="center"><div style="width:150px;"></div></td>
  						<td class="center"><div style="width:80px;"></div></td>
  						<c:forEach items="${testpaperList}" var="var" varStatus="vs">
  							<td class="center"><div style="width:80px;margin:0 auto;">${var.AVG_SCORE}</div></td>
  						</c:forEach>
  					</tr>
  					<tr>
  						<td class="center"><div style="width:150px;">班级课程平均得分率</div></td>
  						<td class="center"><div style="width:150px;"></div></td>
  						<td class="center"><div style="width:80px;"></div></td>
  						<c:forEach items="${testpaperList}" var="var" varStatus="vs">
  							<td class="center"><div style="width:80px;margin:0 auto;"><fmt:formatNumber type="number"
  									value="${var.TOTAL_SCORE == 0 ? 0: (var.AVG_SCORE / var.TOTAL_SCORE * 100)}"
  									maxFractionDigits="2" />%</div></td>
  						</c:forEach>
  					</tr>
  
  					<c:choose>
  						<c:when test="${not empty studentList}">
  							<c:forEach items="${studentList}" var="var" varStatus="vs">
  								<tr>
  									<%-- <td class="center"><a
  										href="report/student_report?studentid=${var.ID}&class_id=${info.CLASS_ID}">${var.NAME}</a>
  									</td> --%>
  									<td class="center"><div style="width:150px;cursor:hand"><a
  										 onclick="student('${info.CLASS_ID}','${var.STUDENT_ID}')">${var.NAME}</a></div>
  									</td>
  									<td class="center"><div style="width:150px;"><fmt:formatNumber type="number"
  											value="${var.TOTALSCORE == 0 ? 0: (var.GETSCORE / var.TOTALSCORE * 100)}"
  											maxFractionDigits="2" />%</div></td>
  									<td class="center"><div style="width:80px;margin:0 auto;">${var.GETSCORE }</div></td>
  									<c:forEach items="${testpaperList}" var="var1" varStatus="vs1">
  										<td class="center"><div style="width:180px;margin:0 auto;"><c:set var="TEST_ID"
  												value="${var1.TESTPAPER_ID}" /> ${var[TEST_ID] }</div></td>
  									</c:forEach>
  								</tr>
  							</c:forEach>
  						</c:when>
  					</c:choose>
  				</tbody>
  			</table>
fcd1fe57   孙向锦   报表数据
270
  			${pd }
892c3766   =   1、增加练习报表页面
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
  			<div id="scrollableTable"></div>
  		</form>
  	</div>
  
  	<%@ include file="../../system/index/foot.jsp"%>
  	<script src="static/ace/js/bootbox.js"></script>
  	<!-- ace scripts -->
  	<script src="static/ace/js/ace/ace.js"></script>
  	<!-- 下拉框 -->
  	<script src="static/ace/js/chosen.jquery.js"></script>
  	<!-- 日期框 -->
  	<script src="static/ace/js/date-time/bootstrap-datepicker.js"></script>
  	<!--提示框-->
  	<script type="text/javascript" src="static/js/jquery.tips.js"></script>
  
   	<script language="javascript" src="static/js/tablescroller.js"></script>
      <script language="javascript" src="static/js/tablescroller.jquery.js"></script>
      
    
      
  	<script type="text/javascript">
  		$(function() {
  			
  			//日期框
  			$('.date-picker').datepicker({
  				autoclose : true,
  				todayHighlight : true
  			});
  
  			//下拉框
  			if (!ace.vars['touch']) {
  				$('.chosen-select').chosen({
  					allow_single_deselect : true
  				});
  				$(window).off('resize.chosen').on('resize.chosen', function() {
  					$('.chosen-select').each(function() {
  						var $this = $(this);
  						$this.next().css({
  							'width' : $this.parent().width()
  						});
  					});
  				}).trigger('resize.chosen');
  				$(document).on('settings.ace.chosen',
  						function(e, event_name, event_val) {
  							if (event_name != 'sidebar_collapsed')
  								return;
  							$('.chosen-select').each(function() {
  								var $this = $(this);
  								$this.next().css({
  									'width' : $this.parent().width()
  								});
  							});
  						});
  				$('#chosen-multiple-style .btn').on(
  						'click',
  						function(e) {
  							var target = $(this).find('input[type=radio]');
  							var which = parseInt(target.val());
  							if (which == 2)
  								$('#form-field-select-4').addClass(
  										'tag-input-style');
  							else
  								$('#form-field-select-4').removeClass(
  										'tag-input-style');
  						});
  			}
  
  			//复选框全选控制
  			var active_class = 'active';
  			$('#simple-table > thead > tr > th input[type=checkbox]').eq(0).on(
  					'click',
  					function() {
  						var th_checked = this.checked;//checkbox inside "TH" table header
  						$(this).closest('table').find('tbody > tr').each(
  								function() {
  									var row = this;
  									if (th_checked)
  										$(row).addClass(active_class).find(
  												'input[type=checkbox]').eq(0)
  												.prop('checked', true);
  									else
  										$(row).removeClass(active_class).find(
  												'input[type=checkbox]').eq(0)
  												.prop('checked', false);
  								});
  					});
  		});
  		
  		var role = '${pd.ROLE}';
  		
  		function precent(avg,total){
  			if(total == 0){
  				return "0%"
  			}
  			return Math.round(avg / total * 100)/100 + '%' ;
  		}
  		
  		function tosearch(){
  			var url = "<%=basePath%>report/report.do?classid=${info.CLASS_ID}" ;
  			var startDate = $("#lastStart").val();
  			var endDate =  $("#lastEnd").val();
  			var subject_id =  $("#SUBJECT_ID").val();
  			url = url + "&start_date=" + startDate ;
  			if(endDate != null){
  				url = url + "&end_date=" + endDate;
  			}
  			if(subject_id != null){
  				url = url + "&SUBJECT_ID=" + subject_id;
  			}
  			if(role == "admin"){
  				url = url + "&ROLE=admin" ;
  			}
  			window.location.href = url;
  			window.top.loading.show();
  			/* $("#Form").sumbit(); */
  		}
  		
  		function student(classid,studentid){
  		
  			var url = "<%=basePath%>report/student_report?studentid=" + studentid + "&class_id=" + classid ;
  			var startDate = $("#lastStart").val();
  			var endDate =  $("#lastEnd").val();
  			url = url + "&start_date=" + startDate + "&end_date=" + endDate ;
  			var SUBJECT_ID = $("#SUBJECT_ID").val();
  			if(SUBJECT_ID != null && SUBJECT_ID != ''){
  				url = url + "&SUBJECT_ID="+ SUBJECT_ID ;
  			}
  			window.self.location.href = url;
  			window.top.loading.show();
  		}
  		
  		function paper(class_id,testpaper_id){
  			var url = "<%=basePath%>report/test_report?TestID=" + testpaper_id + "&class_id=" + class_id;
  			var startDate = $("#lastStart").val();
  			var endDate =  $("#lastEnd").val();
  			url = url + "&start_date=" + startDate + "&end_date=" + endDate ;
  			window.self.location.href = url;
  			window.top.loading.show();
  		}
  		
  		$(document).ready(function(){
  			window.top.loading.remove();
  			
  			 var sour = "${testpaperList}";
  			
  			 if(sour != null && sour.length > 3){
  				var _width = $('#mainFrame', parent.document).width()-40;
  				var _heigh = $('#mainFrame', parent.document).height()-100;
  				var options = {
  	            width: _width,
  	            height: _heigh,
  	            pinnedRows: 4,
  	            pinnedCols: 3,
  	            container: "#scrollableTable",
  	            removeOriginal: true
  	        	};
  				$("#simple-table").tablescroller(options);
  		        var name_height = $(".kc").last().parent().height()-18.5;
  		        console.log(name_height);
  		        $(".th_name").height(name_height);
  			} 
  				
  		});
  		
  	</script>
  
  </body>
  </html>