WebRoot/WEB-INF/jsp/sunvote/teacher/teacher_report_1.jsp

<%@ 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"%>
<%
	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" />
<!-- jsp文件头和头部 -->
<%@ include file="../../system/index/top.jsp"%>
<!-- 日期框 -->
<link rel="stylesheet" href="static/ace/css/datepicker.css" />
<style>
	.font span{    font-size: 12px;
    font-weight: initial;color:#000;}
    .date-picker{
    		height:30px;
    		line-height:30px;
    	}
   	.search_btn{
   		width:30px;
   		display:inline-block;
   		vertical-align:bottom;
   	}
</style>
</head>
<body style="background:#fff;">
	<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:250px;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>
					<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="padding-left:10px">
					<a href="#" class="search_btn" onclick="tosearch();"><img
					width="30px" src="static/images/search.png" /></a>
					<!-- <a style="height:30px;"
						class="btn btn-light btn-xs" onclick="tosearch();" title="检索"><i
							id="nav-search-icon" style="line-height:20px"
							class="ace-icon fa fa-search bigger-110 nav-search-icon blue"></i></a> --></td>
					<td style="padding-left:10px">
						<a style="height:30px;width:3em;padding:0;border:0;line-height:30px;border-radius:3px;"
						class="btn btn-primary btn-xs" onclick="export2();" title="导出">导出</a>
						
					</td>
				</tr>
			</table>
			<table id="simple-table"
				class="table table-striped 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;" title="个人平均得分率=个人总分/参考试卷总分">个人平均得分率<img src="static/images/tip.png" style="width:16px"></div></th>
						<th class="center"><div style="width:80px;" title="得分汇总=学生历史考试得分之和">得分汇总<img src="static/images/tip.png" style="width:16px"></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"><div style="width:100%;overflow:hidden;text-overflow:ellipsis;white-space: nowrap;">${var.NAME}</div><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==""?"--":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;">
									<%-- <a onclick="student('${info.CLASS_ID}','${var.STUDENT_ID}')">${var.NAME}</a> --%>
										 ${var.NAME}
										 </div>
									</td>
									<td class="center"><div style="width:150px;">
									<c:if test="${not empty var.GETSCORE}">
									<fmt:formatNumber type="number"
											value="${var.TOTALSCORE == 0 ? 0: (var.GETSCORE / var.TOTALSCORE * 100)}"
											maxFractionDigits="2" />%
									</c:if>
									<c:if test="${empty var.GETSCORE }">--</c:if>
											</div></td>
									<td class="center"><div style="width:80px;margin:0 auto;">
									<c:if test="${not empty var.GETSCORE}">
									${var.GETSCORE}
									</c:if>
									<c:if test="${empty var.GETSCORE}">
									--
									</c:if>
									</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}" /> 
												
									${empty var[TEST_ID]?"--":var[TEST_ID]}
									
												</div></td>
									</c:forEach>
								</tr>
							</c:forEach>
						</c:when>
					</c:choose>
				</tbody>
			</table>
			<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 temp="";
			var sd =  parseInt(startDate.replace(/-/g,""));
			var ed =  parseInt(endDate.replace(/-/g,""));
			if(sd>ed){
				temp = startDate;
				startDate = endDate;
				endDate = temp;
			}
			$("#lastStart").val(startDate);
			$("#lastEnd").val(endDate);
			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();
		}
		function export2(){
			window.open("<%=basePath%>report/export2?CLASSID=${info.CLASS_ID}&ROLE=${pd.ROLE}","_blank");
		}
		
		$(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);
		        $(".corner-frame").width($(".scrollable-rows-frame").width()-1);
			} 
				
		});
		
	</script>
</body>
</html>