潘钊 / bsth_control · Files

<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 class="form-group">
                        <input class="btn btn-default" type="button" id="query" value="查询"/>
<!--                         <input class="btn btn-default" type="button" id="month" value="按月查询"/> -->
                        <input class="btn btn-default" type="button" id="export" value="导出"/>
                    </div>
				</form>
			</div>
			<div class="portlet-body" id="ddrbExport">
				<div class="table-container" id="ddrbBody" style="margin-top: 10px;overflow:auto;min-width: 906px">
					<label>日期：<span id="rqxs"></span>&nbsp;&nbsp;&nbsp;&nbsp;早高峰:6:31~8:30&nbsp;&nbsp;&nbsp;&nbsp;晚高峰:16:01~18:00</label>
					<table class="table table-bordered table-hover table-checkable" id="forms">
						<thead>
							<tr>
								<th colspan="40">线路调度日报</th>
							</tr>
							<tr>
								<td rowspan="3">路线别</td>
								<td colspan="16"><c>全日</c>营运里程（公里）</td>
								<td colspan="15"><c>全日</c>营运班次</td>
								<td colspan="9">大间隔情况</td>
							</tr>
							<tr>
								<td rowspan="2">计划</td>
								<td rowspan="2">实驶</td>
								<td rowspan="2">少驶公里</td>
								<td rowspan="2">少驶班次</td>
								<td colspan="11">少驶原因（公里）</td>
								<td rowspan="2">临加公里</td>
								<td colspan="3">计划班次</td>
								<td colspan="3">实际班次</td>
								<td colspan="3">临加班次</td>
								<td colspan="3">放站班次</td>
								<td colspan="3">调头班次</td>
								<td colspan="3">发生次数</td>
								<td rowspan="2">最大间隔时间（分）</td>
								<td colspan="5" rowspan="2">原因</td>
							</tr>
							<tr>
								<td>路阻</td>
								<td>借调</td>
								<td>故障</td>
								<td>纠纷</td>
								<td>事故</td>
								<td>缺人</td>
								<td>验车</td>
								<td>保养</td>
								<td>天气</td>
								<td>支援</td>
								<td>其他</td>
								<td><c>全日</c></td>
								<td>早高峰</td>
								<td>晚高峰</td>
								<td><c>全日</c></td>
								<td>早高峰</td>
								<td>晚高峰</td>
								<td><c>全日</c></td>
								<td>早高峰</td>
								<td>晚高峰</td>
								<td><c>全日</c></td>
								<td>早高峰</td>
								<td>晚高峰</td>
								<td><c>全日</c></td>
								<td>早高峰</td>
								<td>晚高峰</td>
								<td><c>全日</c></td>
								<td>早高峰</td>
								<td>晚高峰</td>
							</tr>
						</thead>
						
						<tbody class="scheduleDaily_1">
							
						</tbody>
						<tr>
							<td colspan="40">&nbsp;</td>
						</tr>
						<tr>
							<td colspan="2">路牌</td>
							<td colspan="2">车号</td>
							<td>司早</td>
							<td>售早</td>
							<td>司晚</td>
							<td>售晚</td>
							<td colspan="2">路牌</td>
							<td colspan="2">车号</td>
							<td>司早</td>
							<td>售早</td>
							<td>司晚</td>
							<td>售晚</td>
							<td colspan="2">路牌</td>
							<td colspan="2">车号</td>
							<td>司早</td>
							<td>售早</td>
							<td>司晚</td>
							<td>售晚</td>
							<td colspan="2">路牌</td>
							<td colspan="2">车号</td>
							<td>司早</td>
							<td>售早</td>
							<td>司晚</td>
							<td>售晚</td>
							<td colspan="2">路牌</td>
							<td colspan="2">车号</td>
							<td>司早</td>
							<td>售早</td>
							<td>司晚</td>
							<td>售晚</td>
						</tr>
						<tbody class="scheduleDaily_2">
							
						</tbody>
						<tr>
							<td colspan="40">&nbsp;</td>
						</tr>
						<tr>
							<td rowspan="2">路牌</td>
							<td colspan="2" rowspan="2">起点站</td>
							<td colspan="4">到达时间</td>
							<td colspan="4">发车时间</td>
							<td colspan="2" rowspan="2">备注</td>
							<td rowspan="2">路牌</td>
							<td colspan="2" rowspan="2">起点站</td>
							<td colspan="4">到达时间</td>
							<td colspan="4">发车时间</td>
							<td colspan="2" rowspan="2">备注</td>
							<td rowspan="2">路牌</td>
							<td colspan="2" rowspan="2">起点站</td>
							<td colspan="4">到达时间</td>
							<td colspan="4">发车时间</td>
							<td colspan="2" rowspan="2">备注</td>
							<td>&nbsp;</td>
						</tr>
						<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>
							<td>应到</td>
							<td>实到</td>
							<td>快</td>
							<td>慢</td>
							<td>应发</td>
							<td>实发</td>
							<td>快</td>
							<td>慢</td>
							<td>&nbsp;</td>
						</tr>
						<tbody class="scheduleDaily_3">
							
						</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();
		
		$("#date").datetimepicker({
			format : 'YYYY-MM-DD',
			locale : 'zh-cn'
		});
		

		$("#ddrbBody").height($(window).height()-300);
		$.get('/basic/lineCode2Name',function(result){
			var data=[];
			
			for(var code in result){
				data.push({id: code, text: result[code]});
			}
			initPinYinSelect2('#line',data,'');
			
		})
		
		$('#export').attr('disabled', "true");
		
		var line = $("#line").val();
		var xlName = $("#select2-line-container").html();
		var date = $("#date").val();
		
		function getTime(list){
            $.each(list, function(i, obj) {
                if(obj.zdsj != null && obj.zdsjActual != null ){
                    var zdsjActual = (obj.zdsjActual).split(":");
                    var zdsj = (obj.zdsj).split(":");
                    if(zdsjActual[0]*60+Number(zdsjActual[1]) > zdsj[0]*60+Number(zdsj[1])){
                        obj["slow"] = (zdsjActual[0]*60+Number(zdsjActual[1])) - (zdsj[0]*60+Number(zdsj[1]));
                    }
                    else if(zdsjActual[0]*60+Number(zdsjActual[1]) < zdsj[0]*60+Number(zdsj[1])){
                        obj["fast"] = (zdsj[0]*60+Number(zdsj[1])) - (zdsjActual[0]*60+Number(zdsjActual[1]));
                    }
                }
                	
                if(obj.fcsj != null && obj.fcsjActual != null ){
                    var fcsjActual = (obj.fcsjActual).split(":");
                    var fcsj = (obj.fcsj).split(":");
                    if(fcsjActual[0]*60+Number(fcsjActual[1]) > fcsj[0]*60+Number(fcsj[1])){
                        obj["slow0"] = (fcsjActual[0]*60+Number(fcsjActual[1])) - (fcsj[0]*60+Number(fcsj[1]));
                    }
                    else if(fcsjActual[0]*60+Number(fcsjActual[1]) < fcsj[0]*60+Number(fcsj[1])){
                        obj["fast0"] = (fcsj[0]*60+Number(fcsj[1])) - (fcsjActual[0]*60+Number(fcsjActual[1]));
                    }
                }
            }); 
		}
		//查询
		$("#query").on('click',function(){
			line = $("#line").val();
			xlName = $("#select2-line-container").html();
			date = $("#date").val();
			$("#rqxs").html(date);
			if(date == null || date.length == 0){
				layer.msg("请选择时间");
				return;
			}
			$("c").html("全日");
			$("#export").removeAttr("disabled");
			$get('/realSchedule/statisticsDaily',{line:line,date:date,xlName:xlName,type:"query"},function(result){
				var scheduleDaily_1 = template('scheduleDaily_1',{list:result});
				$('#forms .scheduleDaily_1').html(scheduleDaily_1);
			});
			$.get('/realSchedule/queryUserInfo',{line:line,date:date,state:2,type:"query"},function(result){
				console.log(result);
				var scheduleDaily_2 = template('scheduleDaily_2',{list:result});
				$('#forms .scheduleDaily_2').html(scheduleDaily_2);
			});
			$.get('/realSchedule/realScheduleListQp',{line:line,date:date,type:"query"},function(result){
				getTime(result);
				var scheduleDaily_3 = template('scheduleDaily_3',{list:result});
				$('#forms .scheduleDaily_3').html(scheduleDaily_3);
			});
			
		});

		//按月查询
		$("#month").on('click',function(){
			line = $("#line").val();
			xlName = $("#select2-line-container").html();
			date = $("#date").val();
			if(date == null || date.length == 0){
				layer.msg("请选择时间");
				return;
			}
			date = date.substring(0, 7);
			$("c").html("全月");
			$("#export").removeAttr("disabled");
			$get('/realSchedule/statisticsDaily',{line:line,date:date,xlName:xlName,type:"query"},function(result){
				var scheduleDaily_1 = template('scheduleDaily_1',{list:result});
				$('#forms .scheduleDaily_1').html(scheduleDaily_1);
			});
			$('#forms .scheduleDaily_2').html("");
			$('#forms .scheduleDaily_3').html("");
			
		});
		
		$("#export").on("click",function(){
			var params = {};
			if(date == null || date.length == 0){
				layer.msg("请选择时间");
				return;
			}
			/* $("#ddrbExport").table2excel({
				// 不被导出的表格行的CSS class类
				exclude: ".noExl",
				// 导出的Excel文档的名称，（没看到作用）
				name: "Excel Document Name.xlsx",
				// Excel文件的名称
				filename: date+"调度日报"
			}); */
			var lineName = $('#line option:selected').text();
			params['line'] = line;
			params['lineName'] = lineName;
			params['date'] = date;
			params['xlName'] = xlName;
			params['type'] = "export";
			params['state'] = '2';
			params['genre'] = 'qp';
			$get('/realSchedule/scheduleDailyExport', params, function(result){
				if(date.length == 10)
					window.open("/downloadFile/download?fileName="+moment(date).format("YYYYMMDD")+"-"+lineName+"-调度日报");
				else
					window.open("/downloadFile/download?fileName="+moment(date).format("YYYYMMDD")+"-"+lineName+"-调度日报");
			}); 
		});
		
	});
</script>
<script type="text/html" id="scheduleDaily_1">
	{{each list as obj i}}
		<tr>
			<td>{{obj.xlName}}</td>
			<td>{{obj.jhlc}}</td>
			<td>{{obj.sjgl}}</td>
			<td>{{obj.ssgl}}</td>
			<td>{{obj.ssbc}}</td>
			<td>{{obj.ssgl_lz}}</td>
			<td>{{obj.ssgl_dm}}</td>
			<td>{{obj.ssgl_gz}}</td>
			<td>{{obj.ssgl_jf}}</td>
			<td>{{obj.ssgl_zs}}</td>
			<td>{{obj.ssgl_qr}}</td>
			<td>{{obj.ssgl_qc}}</td>
			<td>{{obj.ssgl_kx}}</td>
			<td>{{obj.ssgl_qh}}</td>
			<td>{{obj.ssgl_yw}}</td>
			<td>{{obj.ssgl_other}}</td>
			<td>{{obj.ljgl}}</td>
			<td>{{obj.jhbc}}</td>
			<td>{{obj.jhbc_m}}</td>
			<td>{{obj.jhbc_a}}</td>
			<td>{{obj.sjbc}}</td>
			<td>{{obj.sjbc_m}}</td>
			<td>{{obj.sjbc_a}}</td>
			<td>{{obj.ljbc}}</td>
			<td>{{obj.ljbc_m}}</td>
			<td>{{obj.ljbc_a}}</td>
			<td>{{obj.fzbc}}</td>
			<td>{{obj.fzbc_m}}</td>
			<td>{{obj.fzbc_a}}</td>
			<td>{{obj.dtbc}}</td>
			<td>{{obj.dtbc_m}}</td>
			<td>{{obj.dtbc_a}}</td>
			<td>{{obj.djg}}</td>
			<td>{{obj.djg_m}}</td>
			<td>{{obj.djg_a}}</td>
			<td>{{obj.djg_time}}</td>
			<td colspan="5">&nbsp;</td>	
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="40"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>
<script type="text/html" id="scheduleDaily_2">
	{{each list as obj i}}
		{{if i%5 == 0}}
			<tr>
		{{/if}}
				<td colspan="2">{{obj[3]}}</td>
				<td colspan="2">{{obj[2]}}</td>
				<td>{{obj[1]}}/{{obj[4]}}</td>
				<td>{{if obj[5] !=null}}
				{{obj[5]}}/
				{{obj[6]}}

					{{/if}}
				</td>
				<td>&nbsp;</td>
				<td>&nbsp;</td>
		{{if (i+1)%5 == 0}}
			</tr>
		{{/if}}
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="40"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>
<script type="text/html" id="scheduleDaily_3">
	{{each list as obj i}}
		{{if i%3 == 0}}
			<tr>
		{{/if}}
				<td>{{obj.lpName}}</td>
				<td colspan="2">{{obj.qdzName}}</td>
				<td>{{obj.zdsj}}</td>
				<td>{{obj.zdsjActual}}</td>
				<td>{{obj.fast}}</td>
				<td>{{obj.slow}}</td>
				<td>{{obj.fcsj}}</td>
				<td>{{obj.fcsjActual}}</td>
				<td>{{obj.fast0}}</td>
				<td>{{obj.slow0}}</td>
				<td colspan="2">{{obj.remarks}}</td>
		{{if (i+1)%3 == 0}}
				<td>&nbsp;</td>
			</tr>
		{{/if}}
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="40"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>