firstAndLastBus.html 5.9 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 id="history" class="form-inline" action="">
					<div style="display: inline-block;">
						<span class="item-label" style="width: 80px;">线路: </span>
						<select class="form-control" name="line" id="line" style="width: 180px;"></select>
					</div>
					<div style="display: inline-block;margin-left: 15px;">
						<span class="item-label" style="width: 80px;">时间: </span>
						<input class="form-control" type="text" id="date" style="width: 180px;"/>
					</div>
					<div class="form-group">
						<input class="btn btn-default" type="button" id="query" value="筛选"/>
						<input class="btn btn-default" type="button" id="export" value="导出"/>
					</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 class="hidden">
								<th width="100px" rowspan="2">日期</th>
								<th width="100px" rowspan="2">线路</th>
								<th colspan="4">上行首发</th>
								<th colspan="4">上行末发</th>
								<th colspan="4">下行首发</th>
								<th colspan="4">下行末发</th>
							</tr>
							<tr class="hidden">
								<th width="100px">站点</th>
								<th>计发</th>
								<th>实发</th>
								<th>快慢</th>
								<th width="100px">站点</th>
								<th>计发</th>
								<th>实发</th>
								<th>快慢</th>
								<th width="100px">站点</th>
								<th>计发</th>
								<th>实发</th>
								<th>快慢</th>
								<th width="100px">站点</th>
								<th>计发</th>
								<th>实发</th>
								<th>快慢</th>
							</tr>
						</thead>
						<tbody>
							
						</tbody>
					</table>
					<div style="text-align: right;">
						<ul id="pagination" class="pagination"></ul>
					</div>
				</div>
			</div>
		</div>
	</div>
</div>

<script>
	$(function(){
		
		// 关闭左侧栏
		if (!$('body').hasClass('page-sidebar-closed'))
			$('.menu-toggler.sidebar-toggler').click();
		
		$("#date").datetimepicker({
			format : 'YYYY-MM-DD',
			locale : 'zh-cn'
		});
		
		var d = new Date();
		var year = d.getFullYear();
		var month = d.getMonth() + 1;
		var day = d.getDate();
		if(month > 9){
			$("#date").val(year + "-" + month + "-" + day);
		} else {
			$("#date").val(year + "-0" + month + "-" + day);
		}
		
		$('#line').select2({
			ajax: {
				url: '/realSchedule/findLine',
				type: 'post',
				dataType: 'json',
				delay: 150,
				data: function(params){
					return{line: params.term};
				},
			    processResults: function (data) {
			      return {
			        results: data
			      };
			    },
				cache: true
			},
			templateResult: function(repo){
				if (repo.loading) return repo.text;
				var h = '<span>'+repo.text+'</span>';
				return h;
			},
			escapeMarkup: function (markup) { return markup; },
			minimumInputLength: 1,
			templateSelection: function(repo){
				return repo.text;
			},
			language: {
		       noResults: function(){
		           return '<span style="color:red;font-size: 12px;">没有搜索到线路!</span>';
		       },
		       inputTooShort : function(e) {
					return '<span style="color:gray;font-size: 12px;"><i class="fa fa-search"></i> 输入线路搜索线路</span>';
			   },
		       searching : function() {
					return '<span style="color:gray;font-size: 12px;"> 正在搜索线路...</span>';
			   }
			}
		});
		
		$("#query").on("click",jsDoQuery);
		
		var line = $("#line").val();
		var date = $("#date").val();
		function jsDoQuery(pagination){
			var params = {};
			line = $("#line").val();
			date = $("#date").val();
			params['line'] = line;
			params['date'] = date;
			params['type'] = "query";
			$(".hidden").removeClass("hidden");
			$get('/pcpc/firstAndLastBus', params, function(result){
				// 把数据填充到模版中
				var tbodyHtml = template('list_firstAndLastBus',{list:result});
				// 把渲染好的模版html文本追加到表格中
				$('#forms tbody').html(tbodyHtml);

			});
		}
		
		$("#export").on("click",function(){
			$get('/pcpc/firstAndLastBus',{line:line,date:date,type:'export'},function(result){
				window.open("/downloadFile/download?fileName=线路首末班"+moment(date).format("YYYYMMDD"));
			});
		});
		
		
	});
	
</script>
<script type="text/html" id="list_firstAndLastBus">
	{{each list as obj i}}
		<tr>
			<td>{{obj.date}}</td>
			<td>{{obj.line}}</td>
			<td>{{obj.qdzFirst0}}</td>
			<td>{{obj.jhfcFirst0}}</td>
			<td>{{obj.sjfcFirst0}}</td>
			<td>{{obj.delayFirst0}}</td>
			<td>{{obj.qdzLast0}}</td>
			<td>{{obj.jhfcLast0}}</td>
			<td>{{obj.sjfcLast0}}</td>
			<td>{{obj.delayLast0}}</td>
			<td>{{obj.qdzFirst1}}</td>
			<td>{{obj.jhfcFirst1}}</td>
			<td>{{obj.sjfcFirst1}}</td>
			<td>{{obj.delayFirst1}}</td>
			<td>{{obj.qdzLast1}}</td>
			<td>{{obj.jhfcLast1}}</td>
			<td>{{obj.sjfcLast1}}</td>
			<td>{{obj.delayLast1}}</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="18"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>