潘钊 / 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; 
	        text-align: center;}
	 
	 .table > tbody + tbody {
	   border-top: 1px solid; }
	 .table>tbody>tr>td, .table>tbody>tr>th, .table>tfoot>tr>td, .table>tfoot>tr>th, .table>thead>tr>td, .table>thead>tr>th{ text-align: center; }
.table-checkable tr > th:first-child, .table-checkable tr > td:first-child {
    text-align: center;
    max-width: initial;
    min-width: 40px;
    padding-left: 0;
    padding-right: 0;
}

</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="" method="post">
				 <div style="display: inline-block; margin-left: 20px;" id="gsdmDiv_turn">
						<span class="item-label" style="width: 80px;">公司: </span>
						<select class="form-control" name="company" id="gsdmTurn" style="width: 140px;"></select>
					</div> 
					<div style="display: inline-block; margin-left: 20px;" id="fgsdmDiv_turn">
						<span class="item-label" style="width: 80px;">分公司: </span>
						<select class="form-control" name="subCompany" id="fgsdmTurn" style="width: 140px;"></select>
					</div>  
				<div style="display: inline-block; margin-left: 15px;">
                        <span class="item-label" style="width: 80px;">线路: </span>
                        <select class="form-control" name="line" id="line" style="width: 120px;"></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="startDate" style="width: 120px;"/>
                    </div>
                    <div style="display: inline-block;margin-left: 15px;">
                        <span class="item-label" style="width: 80px;">结束时间: </span>
                        <input class="form-control" type="text" id="endDate" style="width: 120px;"/>
                    </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: 20px;overflow:auto;min-width: 1000px">
					<table class="table table-bordered table-hover table-checkable" id="forms1">
						<thead>
							<tr>
								<th colspan="15">营运线路出车率统计表</th>
							</tr>
							<tr>
								<td  rowspan="2" style=" padding-top: 20px;">日期</td> 
								<td rowspan="2" style=" padding-top: 20px;">公司</td>
								<td rowspan="2" style=" padding-top: 20px;">直属公司</td>
								<td rowspan="2" style=" padding-top: 20px;">线路条数</td>
								<td colspan="3">出车数</td>
								<td rowspan="2" >出车率</td>
								<td colspan="2" >班次数</td>
								<td rowspan="2" style=" padding-top: 20px;">班次执行率</td>
								<td rowspan="2" style=" padding-top: 20px;">说明</td>
							</tr>
							<tr>
								<td>计划</td>
								<td>实际</td>
								<td>权证</td>
							    <td>计划</td>
								<td>实际</td>
							</tr>
						</thead>
						<tbody id="tbody">
							
						</tbody>
<!-- 						<tr> -->
<!-- 							<td colspan="1">分类汇总</td> -->
<!-- 							<td><span id="total_gs">&nbsp;</span></td> -->
<!-- 							<td><span id="total_zhgs">&nbsp;</span></td> -->
<!-- 							<td><span id="total_xlts">&nbsp;</span></td> -->
<!-- 							<td><span id="total_jh">&nbsp;</span></td> -->
<!-- 							<td><span id="total_sj">&nbsp;</span></td> -->
<!-- 							<td><span id="total_qz">&nbsp;</span></td> -->
<!-- 							<td><span id="total_ccl">&nbsp;</span></td> -->
<!-- 							<td><span id="total_bcjh">&nbsp;</span></td> -->
<!-- 							<td><span id="total_bcsj">&nbsp;</span></td> -->
<!-- 							<td><span id="total_bczxl">&nbsp;</span></td> -->
<!-- 							<td><span id="total_sm">&nbsp;</span></td> -->
<!-- 						</tr> -->
					</table>
				</div>
			</div>
		</div>
	</div>
</div>

<script>
	$(function(){
		// 关闭左侧栏
		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;
		$("#startDate,#endDate").datetimepicker({
			format : 'YYYY-MM-DD',
			locale : 'zh-cn',
			maxDate : dateTime
		});
		$("#startDate").val(dateTime);
		$("#endDate").val(dateTime);
		
		var fage=false;
		var xlList;
		var obj = [];
		
		$.get('/report/lineList',function(result){
			xlList=result;
			$.get('/user/companyData', function(result){
				obj = result;
				var options = '';
				for(var i = 0; i < obj.length; i++){
					options += '<option value="'+obj[i].companyCode+'">'+obj[i].companyName+'</option>';
				}
				
				if(obj.length ==0){
					 $("#gsdmDiv_turn").css('display','none');
				}else if(obj.length ==1){
					 $("#gsdmDiv_turn").css('display','none');
					if(obj[0].children.length == 1  || obj[0].children.length ==0)
						$('#fgsdmDiv_turn').css('display','none');
				}
				$('#gsdmTurn').html(options);
				updateCompany();
			});
		})
		$("#gsdmTurn").on("change",updateCompany);
		function updateCompany(){
			var company = $('#gsdmTurn').val();
			var options = '';
			for(var i = 0; i < obj.length; i++){
				if(obj[i].companyCode == company){
					var children = obj[i].children;
					for(var j = 0; j < children.length; j++){
						options += '<option value="'+children[j].code+'">'+children[j].name+'</option>';
					}
				}
			}
			$('#fgsdmTurn').html(options);
		}
		  
		var tempData = {};
		$.get('/report/lineList',function(xlList){
			var data = [];
			data.push({id: " ", text: "全部线路"});
			$.get('/user/companyData', function(result){
				for(var i = 0; i < result.length; i++){
					var companyCode = result[i].companyCode;
					var children = result[i].children;
					for(var j = 0; j < children.length; j++){
						var code = children[j].code;
						for(var k=0;k < xlList.length;k++ ){
							if(xlList[k]["fgsbm"]==code && xlList[k]["gsbm"]==companyCode){
								data.push({id: xlList[k]["xlbm"], text: xlList[k]["xlname"]});
								tempData[xlList[k]["xlbm"]] = companyCode+":"+code;
							}
						}
					}
				}
				initPinYinSelect2('#line',data,'');
				
			});
		});
		
		$("#line").on("change", function(){
			if($("#line").val() == " "){
				$("#gsdmTurn").attr("disabled", false);
				$("#fgsdmTurn").attr("disabled", false);
			} else {
				var temp = tempData[$("#line").val()].split(":");
				$("#gsdmTurn").val(temp[0]);
				updateCompany();
				$("#fgsdmTurn").val(temp[1]);
				$("#gsdmTurn").attr("disabled", true);
				$("#fgsdmTurn").attr("disabled", true);
			}
		});
		
		 var line;
		 var startDate;
		 var endDate;
		 var gsdmTurn;
		 var fgsdmTurn;
		$("#query").on("click",function(){
		  
		  line = $("#line").val();
		  startDate=$("#startDate").val();
		  endDate=$("#endDate").val();
	   	  gsdmTurn=$("#gsdmTurn").val();
	   	  fgsdmTurn=$("#fgsdmTurn").val();
			 if(startDate!=''&&endDate!=''){
				var i = layer.load(2);
				$post('/mcy_forms/turnoutrate',
					{ gsdmTurn:gsdmTurn,fgsdmTurn:fgsdmTurn, line:line,startDate:startDate,endDate:endDate,type:'query'},function(result){
// 						var result=[];
					 // 把数据填充到模版中
						var tbodyHtml = template('turnoutrate',{list:result});
						// 把渲染好的模版html文本追加到表格中
						$('#tbody').html(tbodyHtml);
						layer.close(i);
						
						line = $("#line").val();
						startDate = $("#startDate").val();
						endDate = $("#endDate").val();
						$("#sDate").text(startDate);
						$("#eDate").text(endDate);
				        
// 				        var total_xlts = 0,total_jh = 0;
// 				        var total_sj = 0,total_qz = 0,total_ccl = 0,total_bcjh = 0;
// 				        var total_bcjh = 0,total_bcsj = 0,total_bczxl = 0;
// 				   		var total_gs=0; 
// 				        var total_zhgs=0;
// 				        $.each(result, function(i, obj) {
// 					    	total_gs +=Number(obj.gsgs);
// 					    	total_zhgs +=Number(obj.fgsgs);
// 					    	total_xlts += Number(obj.xl);
// 					    	total_jh = Number(obj.cchjh)+Number(total_jh);
// 					    	total_sj = Number(obj.cchsj)+Number(total_sj);
// 					    	total_qz = Number(obj.cchqz)+Number(total_qz);
					    	
// 					    	total_ccl =(Number(total_sj)/Number(total_jh))*100;
// 					    	total_bcjh = Number(obj.bcjh)+Number(total_bcjh);
// 					    	total_bcsj = Number(obj.bcsj)+Number(total_bcsj);
// 					    	total_bczxl = (Number(total_bcsj)/Number(total_bcjh))*100;
					    	 
// 		                });
// 		                $("#total_gs").text(total_gs);
// 		                $("#total_zhgs").text(total_zhgs);
// 		                $("#total_xlts").text(total_xlts);
// 		                $("#total_jh").text(total_jh);
// 		                $("#total_sj").text(total_sj);
// 		                $("#total_qz").text(total_qz);
// 		                $("#total_ccl").text(total_ccl.toFixed(2)+'%');
// 		                $("#total_bcjh").text(total_bcjh);
// 		                $("#total_bcsj").text(total_bcsj);
// 		                $("#total_bczxl").text(total_bczxl.toFixed(2)+'%');
				         
				        var temp = {};
				        var today_account = 0;
				        
				        temp["line"] = $("#line").text(); 	        
				        $.each(result, function(i, obj) {
				            if(moment(obj.schedule_date_str).format("YYYY-MM-DD") == moment(obj.startDate).format("YYYY-MM-DD")){
				                today_account++;
				            } 
			                obj.updateDate = moment(obj.startDate).format("YYYY-MM-DD HH:mm:ss");
			            });  
						
					});
		
			 }else{
				 layer.msg("请选择时间范围!");
			 } 
	});
		 
	$("#export").on("click",function(){
		line = $("#line").val();
		  startDate=$("#startDate").val();
	   	  endDate=$("#endDate").val();
	   	  gsdmTurn=$("#gsdmTurn").val();
	   	  fgsdmTurn=$("#fgsdmTurn").val();
		var lineName = $('#line option:selected').text();
		if(lineName == "全部线路")
			lineName = $('#fgsdmTurn option:selected').text();
		var i = layer.load(2);
		$post('/mcy_export/turnoutrateExport',{gsdmTurn:gsdmTurn,fgsdmTurn:fgsdmTurn,line:line,startDate:startDate,endDate:endDate,type:'export',lineName:lineName},function(result){
			var dateTime = "";
			if(startDate == endDate){
				dateTime = moment(startDate).format("YYYYMMDD");
			} else {
				dateTime = moment(startDate).format("YYYYMMDD")
						+"-"+moment(endDate).format("YYYYMMDD");
			}
			window.open("/downloadFile/download?fileName="
					+dateTime+"-"+lineName+"-营运线路出车率统计表");
			layer.close(i);
		});
	});
	});
</script>
<script type="text/html" id="turnoutrate">
	{{each list as obj i}}
		<tr>
			{{if obj.rq == '分类汇总'}}
				<td colspan='3'>{{obj.rq}}</td>
			{{/if}}
			{{if obj.rq != '分类汇总'}}
				<td>{{obj.rq}}</td>
				<td>{{obj.gsName}}</td>
				<td>{{obj.fgsName}}</td>
			{{/if}}
			<td>{{obj.line}}</td>
			<td>{{obj.jhcc}}</td>
			<td>{{obj.sjcc}}</td>
			<td>{{obj.qz}}</td>
			<td>{{obj.ccl}}</td>
			<td>{{obj.jhbc}}</td>
			<td>{{obj.sjbc}}</td>
			<td>{{obj.zxl}}</td>
			<td>{{obj.sm}}</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="12"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>