潘钊 / 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; }
	   
	   #forms > thead > tr> td >span{
	    width: 5px; 
		word-wrap: break-word; 
		letter-spacing: 20px; 
	  }
	  
	  #forms   > thead > tr> td >label{
	     word-break: keep-all;white-space:nowrap; 
	   }
</style>

<div class="page-head">
	<div class="page-title">
		<h1>调度日报汇总表</h1>
	</div>
</div>

<!-- <div class="row"> -->
	<div  class="col-md-12 portlet light porttlet-fit bordered" style="height:calc(100% - 56px)">
<!-- 		<div> -->
			<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="nature" id="nature"
							style="width: 180px;">
							<option value="0">全部线路</option>
							<option value="1" selected="selected">营运线路</option>
							<option value="2">非营运线路</option>
						</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;margin-left: 15px;">
                        <span class="item-label" style="width: 80px;">结束日期: </span>
                        <input class="form-control" type="text" id="date2" 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" id="tjrbBody" style="overflow:auto;height: calc(100% - 80px)">
				<div class="table-container"   style="margin-top: 10px;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="45"><label id="tjrq"></label> 调度日报汇总表</th>
							</tr>
							<tr>
								<td rowspan="3"><span >公司</span></td>
								<td rowspan="3"><span >分公司</span></td>
								<td colspan="22">全日营运里程（公里）</td>
								<td colspan="15">全日营运班次</td>
								<td colspan="9">大间隔情况</td>
							</tr>
							<tr>
								<td rowspan="2"><label>计划总<br/>公里</label></td>
								<td rowspan="2"><label>计划营</label><label>运公里</label></td>
								<td rowspan="2"><label>计划空</label><label>驶公里</label></td>
								<td rowspan="2"><label>实际</label><label>总公里</label></td>
								<td rowspan="2"><label>实际营</label><label>运公里</label></td>
								<td rowspan="2"><label>实际空</label><label>驶公里</label></td>
								<td rowspan="2"><span>少驶班次</span></td>
								<td rowspan="2"><span>少驶公里</span></td>
								<td colspan="12">少驶原因（公里）</td>
								<td colspan="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 rowspan="2">原因</td>
							</tr>
							<tr>
								<td><span>路阻</span></td>
								<td><span>吊慢</span></td>
								<td><span>故障</span></td>
								<td><span>纠纷</span></td>
								<td><span>肇事</span></td>
								<td><span>缺人</span></td>
								<td><span>缺车</span></td>
								<td><span>客稀</span></td>
								<td><span>气候</span></td>
								<td><span>援外</span></td>
								<td><span>路救抛锚</span></td>
								<td><span>其他</span></td>
								<td><span>营运</span></td>
								<td><span>空驶</span></td>
								<td><span>全日</span></td>
								<td><span>早高峰</span></td>
								<td><span>晚高峰</span></td>
								<td><span>全日</span></td>
								<td><span>早高峰</span></td>
								<td><span>晚高峰</span></td>
								<td><span>全日</span></td>
								<td><span>早高峰</span></td>
								<td><span>晚高峰</span></td>
								<td><span>全日</span></td>
								<td><span>早高峰</span></td>
								<td><span>晚高峰</span></td>
								<td><span>全日</span></td>
								<td><span>早高峰</span></td>
								<td><span>晚高峰</span></td>
								<td><span>全日</span></td>
								<td><span>早高峰</span></td>
								<td><span>晚高峰</span></td>
							</tr>
						</thead>
						<tbody class="dispatch_daily_sum">
							
						</tbody>
					</table>
				</div>
			</div>
		</div>

<script>
	$(function(){
// 		$('#export').attr('disabled', "true");
		
		// 关闭左侧栏
		if (!$('body').hasClass('page-sidebar-closed'))
			$('.menu-toggler.sidebar-toggler').click();
		var d = new Date();
		d.setTime(d.getTime() - 1*1000*60*60*24);
		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").val(dateTime);
		$("#date2").val(dateTime);
		$("#date").datetimepicker({
			format : 'YYYY-MM-DD',
			locale : 'zh-cn',
			maxDate : dateTime
		});
		$("#date2").datetimepicker({
			format : 'YYYY-MM-DD',
			locale : 'zh-cn',
			maxDate : dateTime
		});
		
		var date = "";
		var date2 = "";
		var nature="";
		var time1="";
		var time2="";
		$("#query").on("click",function(){
			if($("#date").val() == null || $("#date").val().trim().length == 0){
				layer.msg("请选择日期！");
				return;
			}
			if($("#date2").val() == null || $("#date2").val().trim().length == 0){
				layer.msg("请选择日期！");
				return;
			}
			date = $("#date").val();
			date2 = $("#date2").val();
			nature=$("#nature").val();
// 			time1 = Date.parse(new Date(date));
// 			time2 = Date.parse(new Date(date2));
// 			if(date==null || date =="" ||date2==null || date2 ==""){
// 				 layer.msg('请选择时间段.');
// 			}else if(time2<time1){
// 				layer.msg('结束日期不能小于开始日期.');
// 			}else{
// 				if((time2-time1)>2678400000){
// 					layer.msg('查询超过一个月请点击【统计查询】.');
// 				}else{
					var params = {};
					params['date'] = date;
					params['date2'] = date2;
					params['nature'] = nature;
					params['type'] = "query";
					var i = layer.load(2);
					$get('/realSchedule/dispatchDailySum',params,function(result){
						// 把数据填充到模版中
						var tbodyHtml = template('dispatch_daily_sum',{list:result});
						// 把渲染好的模版html文本追加到表格中
						$('#forms .dispatch_daily_sum').html(tbodyHtml);
						layer.close(i);
						
						if(date == date2){
							$("#tjrq").html(date);
							$("#rqxs").html(date);
						} else {
							$("#tjrq").html(date + "至" + date2);
							$("#rqxs").html(date + "至" + date2);
						}
						
						if(result.length == 0){
							$("#export").attr('disabled',"true");
						}else{
							$("#export").removeAttr("disabled");
						}
					});
// 				}
// 			}
		});
		
// 		$("#tjrbBody").height($(window).height()-100);
		$("#export").on("click",function(){
			if($("#date").val() == null || $("#date").val().trim().length == 0){
				layer.msg("请选择时间！");
				return;
			}
			date = $("#date").val();
			date2 = $("#date2").val();
			nature=$("#nature").val();
			var params = {};
			params['date'] = date;
			params['date2'] = date2;
			params['nature'] = nature;
			params['type'] = "export";
// 			if((time2-time1)>2678400000){
// 					layer.msg('查询超过一个月请点击【统计查询】.');
// 			}else{
				var i = layer.load(2);
				$get('/realSchedule/dispatchDailySum',params,function(result){
					var dateTime = "";
					if(date == date2){
						dateTime = moment(date).format("YYYYMMDD");
					} else {
						dateTime = moment(date).format("YYYYMMDD")
								+"-"+moment(date2).format("YYYYMMDD");
					}
					window.open("/downloadFile/download?fileName="
							+dateTime+"-调度日报汇总表");
					layer.close(i);
				});
// 			}
		});
		

	});
</script>
<script type="text/html" id="dispatch_daily_sum">
	{{each list as obj i}}
		<tr style='{{if obj.zt==1}}color: red;{{/if}}
					{{if obj.fgsName=='小计' || obj.gsName=='浦交'}}background-color: #b9d6fb;{{/if}}'>
			<td>{{obj.gsName}}</td>
			<td>{{obj.fgsName}}</td>
			<td>{{obj.jhzlc}}</td>
			<td>{{obj.jhlc}}</td>
			<td>{{obj.jcclc}}</td>
			<td>{{obj.sjzgl}}</td>
			<td>{{obj.sjgl}}</td>
			<td>{{obj.sjksgl}}</td>
			<td>{{obj.ssbc}}</td>
			<td>{{obj.ssgl}}</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_ljpm}}</td>
			<td>{{obj.ssgl_other}}</td>
			<td>{{obj.ljgl}}</td>
			<td>{{obj.ljks}}</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>&nbsp;</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="45"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>