subjectUserList.html 4.92 KB
<style type="text/css">
	.table-bordered {
	  border: 1px solid; }
	  .table-bordered > thead > tr > th,
	  .table-bordered > thead > tr > td,
	  .table-bordered > tbody > tr > th,
	  .table-bordered > tbody > tr > td,
	  .table-bordered > tfoot > tr > th,
	  .table-bordered > tfoot > tr > td {
	    border: 1px solid; }
	  .table-bordered > thead > tr > th,
	  .table-bordered > thead > tr > td {
	    border-bottom-width: 2px; }
	 
	 .table > tbody + tbody {
	   border-top: 1px solid; }
</style>

<div class="page-head">
	<div class="page-title">
		<h1>成绩查询</h1>
	</div>
</div>

<div class="row">
	<div class="col-md-12">
		<div class="portlet light porttlet-fit bordered">
			<div class="portlet-title">
				<form class="form-inline" action="">
					<div style="display: inline-block;">
                        <span class="item-label" style="width: 80px;margin-left: 6px;">开始时间: </span>
                        <input class="form-control" type="text" id="date" style="width: 160px;"/>
                    </div>
					<div style="display: inline-block;margin-left: 15px;">
						<span class="item-label" style="width: 80px;">学号: </span>
						<select class="form-control" name="userName" id="userName" style="width: 180px;"></select>
					</div>
					<div style="display: inline-block;margin-left: 15px;">
						<span class="item-label" style="width: 80px;">班级: </span>
						<select class="form-control" name="className" id="className" style="width: 180px;"></select>
					</div>
                    <div class="form-group">
                        <input class="btn btn-default" type="button" id="query" value="查询" style="margin-left: 2px;"/>
                    </div>
				</form>
			</div>
			
			<div class="portlet-body">
				<div class="table-container" style="margin-top: 10px;overflow:auto;min-width: 906px">
					<table class="table table-bordered table-hover table-checkable" id="forms">
						<thead>
							<tr>
								<td>序号</td>
								<td>学号</td>
								<td>姓名</td>
								<td>日期</td>
								<td>总题数</td>
								<td>正确</td>
								<td>错误</td>
								<td>未答</td>
								<td>成绩</td>
								<td>查看</td>
							</tr>
						</thead>
						<tbody>
						</tbody>
					</table>
				</div>
			</div>
		</div>
	</div>
</div>
<script src="/pages/mforms/singledatas/jquery.table2excel.min.js"></script>
<script>
	$(function(){
		// 关闭左侧栏
		if (!$('body').hasClass('page-sidebar-closed'))
			$('.menu-toggler.sidebar-toggler').click();
		
		var d = new Date();
		d.setTime(d.getTime());
		var year = d.getFullYear();
		var month = d.getMonth() + 1;
		var day = d.getDate();
		if(month < 10)
			month = "0"+month;
		if(day < 10)
			day = "0"+day;
		var dateTime = year + "-" + month + "-" + day;
		$("#date").datetimepicker({
			format : 'YYYY-MM-DD',
			locale : 'zh-cn',
			maxDate : dateTime
		});
		$("#date").val(dateTime);

		$.get('/user/userNameList',function(result){
			var data=[];
			data.push({id: "", text:"请选择"});
			for(var code in result){
				data.push({id: result[code].userName, text: result[code].userName});
			}
			initPinYinSelect2('#userName',data,'');
		})
		//查询
		$("#query").on('click',function(){
			var date = $("#date").val();
			var userName = $("#userName").val()=='请选择'?'':$("#userName").val();
			var className = $("#className").val()=='请选择'?'':$("#className").val();
		    $get('/subjectUser/subjectUserList',{date:date,userName:userName,className:className,type:'query'},function(result){
				var subjectUserList = template('subjectUserList',{list:result});
				$('#forms tbody').html(subjectUserList);
				$('.btn-subjectUserList').on('click', openSubjectUserList);
			});   
		});

		function openSubjectUserList(){
			var id = $(this).data('id');
			id += ","+$(this).data('rq');
			$.get('/pages/subjectUser/subjectUserDetailList.html', function (content) {
				layer.open({
					type: 1,
					area: ['1300px', '600px'],
					content: content,
					title: '考生答题详细',
					shift: 5,
					scrollbar: false,
					success: function () {
						$('#subjectUserDetailList').trigger('init', id);
					}
				});
			});
		}

		$.get('/user/classList',function(result){
			var data=[];
			data.push({id: "请选择", text:"请选择"});
			for(var code in result){
				data.push({id: result[code], text: result[code]});
			}
			initPinYinSelect2('#className',data,'');
		})
	});
</script>
<script type="text/html" id="subjectUserList">
	{{each list as obj i}}
		<tr>
		<td>{{i+1}}</td>
		<td>{{obj.userName}}</td>
		<td>{{obj.name}}</td>
		<td>{{obj.rq}}</td>
		<td>{{obj.sum}}</td>``
		<td>{{obj.t}}</td>
		<td>{{obj.f}}</td>
		<td>{{obj.na}}</td>
		<td>{{obj.fraction}}</td>
		<td>
			<button type="button" class="btn btn-sm blue btn-subjectUserList" 
			data-id="{{obj.userId}}" data-rq="{{obj.rq}}">查看</button>
		</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="13"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>