realDaily.html 10.5 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;">线路: </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 style="display: inline-block;">
                        <span class="item-label" style="width: 80px;">数据显示: </span>
                        <select class="form-control" name="dataShow" id="dataShow" style="width: 180px;">
                        	<option value="1">驾驶员、路牌、车辆</option>
                        	<option value="2">车辆、人员、路牌</option>
                        	<option value="3">路牌、人员、车辆</option>
                        	<option value="4">驾驶员</option>
                        	<option value="5">车辆</option>
                        	<option value="6">路牌</option>
                        </select>
                    </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>
								<th colspan="16">班次车辆人员日统计</th>
							</tr>
						</thead>
						<tbody class="realDaily">
							
						</tbody>
					</table>
				</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'
		});
		
		$('#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>';
               }
            }
        });
		
		var line;
		var date;
		$("#query").on("click",function(){
			line = $("#line").val();
			date = $("#date").val();
			var dataShow = $("#dataShow").val();
			$get('/realSchedule/queryUserInfo',{line:line,date:date},function(result){               
				// 把数据填充到模版中
				var tbodyHtml = template('realDaily_'+dataShow,{list:result});
				// 把渲染好的模版html文本追加到表格中
				$('#forms .realDaily').html(tbodyHtml);
			});
		});
		$("#export").on("click",function(){
			$get('/realSchedule/dailyInfo',{line:line,date:date},function(result){
				window.open("/downloadFile/download?fileName=实际计划日报表"+moment(date).format("YYYYMMDD"));
			});
		});
	});
</script>
<script type="text/html" id="realDaily_1">
	<tr>
		<td>驾驶员</td>
		<td>售票员</td>
		<td>路牌</td>
		<td>车辆</td>
		<td>计划里程</td>
		<td>实际计划里程</td>
		<td>营运里程</td>
		<td>空驶里程</td>
		<td>抽减里程</td>
		<td>增加里程</td>
		<td>总里程</td>
		<td>计划班次</td>
		<td>实际计划班次</td>
		<td>抽减班次</td>
		<td>增加班次</td>
		<td>实际班次</td>
	</tr>
	{{each list as obj i}}
		<tr>
			<td>{{obj.jName}}</td>
			<td>{{obj.sName}}</td>
			<td>{{obj.lpName}}</td>
			<td>{{obj.clZbh}}</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="16"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>
<script type="text/html" id="realDaily_2">
	<tr>
		<td>车辆</td>
		<td>驾驶员</td>
		<td>售票员</td>
		<td>路牌</td>
		<td>计划里程</td>
		<td>实际计划里程</td>
		<td>营运里程</td>
		<td>空驶里程</td>
		<td>抽减里程</td>
		<td>增加里程</td>
		<td>总里程</td>
		<td>计划班次</td>
		<td>实际计划班次</td>
		<td>抽减班次</td>
		<td>增加班次</td>
		<td>实际班次</td>
	</tr>
	{{each list as obj i}}
		<tr>
			<td>{{obj.clZbh}}</td>
			<td>{{obj.jName}}</td>
			<td>{{obj.sName}}</td>
			<td>{{obj.lpName}}</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="16"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>
<script type="text/html" id="realDaily_3">
	<tr>
		<td>路牌</td>
		<td>车辆</td>
		<td>驾驶员</td>
		<td>售票员</td>
		<td>计划里程</td>
		<td>实际计划里程</td>
		<td>营运里程</td>
		<td>空驶里程</td>
		<td>抽减里程</td>
		<td>增加里程</td>
		<td>总里程</td>
		<td>计划班次</td>
		<td>实际计划班次</td>
		<td>抽减班次</td>
		<td>增加班次</td>
		<td>实际班次</td>
	</tr>
	{{each list as obj i}}
		<tr>
			<td>{{obj.lpName}}</td>
			<td>{{obj.clZbh}}</td>
			<td>{{obj.jName}}</td>
			<td>{{obj.sName}}</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="16"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>
<script type="text/html" id="realDaily_4">
	<tr>
		<td>驾驶员</td>
		<td>计划里程</td>
		<td>实际计划里程</td>
		<td>营运里程</td>
		<td>空驶里程</td>
		<td>抽减里程</td>
		<td>增加里程</td>
		<td>总里程</td>
		<td>计划班次</td>
		<td>实际计划班次</td>
		<td>抽减班次</td>
		<td>增加班次</td>
		<td>实际班次</td>
	</tr>
	{{each list as obj i}}
		<tr>
			<td>{{obj.jName}}</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="13"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>
<script type="text/html" id="realDaily_5">
	<tr>
		<td>车辆</td>
		<td>计划里程</td>
		<td>实际计划里程</td>
		<td>营运里程</td>
		<td>空驶里程</td>
		<td>抽减里程</td>
		<td>增加里程</td>
		<td>总里程</td>
		<td>计划班次</td>
		<td>实际计划班次</td>
		<td>抽减班次</td>
		<td>增加班次</td>
		<td>实际班次</td>
	</tr>
	{{each list as obj i}}
		<tr>
			<td>{{obj.clZbh}}</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="13"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>
<script type="text/html" id="realDaily_6">
	<tr>
		<td>路牌</td>
		<td>计划里程</td>
		<td>实际计划里程</td>
		<td>营运里程</td>
		<td>空驶里程</td>
		<td>抽减里程</td>
		<td>增加里程</td>
		<td>总里程</td>
		<td>计划班次</td>
		<td>实际计划班次</td>
		<td>抽减班次</td>
		<td>增加班次</td>
		<td>实际班次</td>
	</tr>
	{{each list as obj i}}
		<tr>
			<td>{{obj.lpName}}</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
			<td>&nbsp;</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="13"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>