潘钊 / 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; }
</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="get">
				<div style="display: inline-block; margin-left: 33px;" id="gsdmDiv_shif">
						<span class="item-label" style="width: 80px;">公司: </span>
						<select class="form-control" name="company" id="gsdmShif" style="width: 140px;"></select>
					</div> 
					<div style="display: inline-block; margin-left: 24px;" id="fgsdmDiv_shif">
						<span class="item-label" style="width: 80px;">分公司: </span>
						<select class="form-control" name="subCompany" id="fgsdmShif" style="width: 140px;"></select>
					</div>  
					<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 style="display: none">
			<h3>数据显示</h3>
			<a>驾驶员   售票员   路牌</a>&nbsp;&nbsp;
			<a>售票员   路牌   车辆</a>&nbsp;&nbsp;
			<a>车辆   人员   车辆</a>&nbsp;&nbsp;
			<a>驾驶员</a>&nbsp;&nbsp;
			<a>售票员</a>&nbsp;&nbsp;
			<a>路牌</a>&nbsp;&nbsp;
			<a>车辆</a>&nbsp;&nbsp;
			</div>
			<div class="portlet-body" style="text-align:center">
				<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 class="jsypx" style="cursor:pointer ">驾驶员</th>
								<th>售票员</th>
								<th>路牌</th>
								<th class="zbhpx" style="cursor:pointer ">车辆</th>
								<th>计划里程</th>
								<th>实际计划里程</th>
								<th>运营里程</th>
								<th>空驶里程</th>
								<th>抽减里程</th>
								<th>增加里程</th>
								<th>总里程</th>
								<th>计划班次</th>
								<th>实际计划班次</th>
								<th>抽减班次</th>
								<th>增加班次</th>
								<th>实际班次</th>
							</tr>
						</thead>
						<tbody>
							
						</tbody>
					</table>
				</div>
			</div>
		</div>
	</div>
</div>

<script>
$(function(){
	var reqCodeMap = {"0xA1": '请求恢复运营', "0xA2": '申请调档', "0xA3": '出场请求', "0xA5": '进场请求', "0xA7": '加油请求', "0x50": '车辆故障', "0x70": '路阻报告', "0x60": '事故报告', "0x11": '扣证纠纷', "0x12" : '报警'};
	// 关闭左侧栏
	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 < 10)
		month = "0" + month;
	if(day < 10)
		day = "0" + day;
	$("#date").val(year + "-" + month + "-" + day);
	
	var fage=false;
	var obj = [];
	var xlList;
	 
	$.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_shif").css('display','none');
			 $('#fgsdmDiv_shif').css('display','none');
		}else if(obj.length ==1){
			 $("#gsdmDiv_shif").css('display','none');
			if(obj[0].children.length == 1  || obj[0].children.length ==0)
				$('#fgsdmDiv_shif').css('display','none');
		}
		$('#gsdmShif').html(options);
		updateCompany();
	});
	})
	$("#gsdmShif").on("change",updateCompany);
	function updateCompany(){
		var company = $('#gsdmShif').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>';
				}
			}
		}
		$('#fgsdmShif').html(options);
	}
	
	
// 	$.get('/basic/lineCode2Name',function(result){
// 		var data=[];
		
// 		for(var code in result){
// 			data.push({id: code, text: result[code]});
// 		}
// 		initPinYinSelect2('#line',data,'');
		
// 	})
	
	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() == " "){
				$("#gsdmShif").attr("disabled", false);
				$("#fgsdmShif").attr("disabled", false);
			} else {
				var temp = tempData[$("#line").val()].split(":");
				$("#gsdmShif").val(temp[0]);
				updateCompany();
				$("#fgsdmShif").val(temp[1]);
				$("#gsdmShif").attr("disabled", true);
				$("#fgsdmShif").attr("disabled", true);
			}
		});
		
		var type="desc";
		$(".jsypx").on("click",function(){
			var line = $("#line").val();
			var date = $("#date").val();
			var gsdmShif = $("#gsdmShif").val();
			var fgsdmShif = $("#fgsdmShif").val(); 
			  var params = {};
	            params.fgsdmShif =fgsdmShif;
	            params.date =date;
	            params.gsdmShif =gsdmShif;
	            params.line =line;
	            params.state="j_name";
	            params.type=type;
			if(date=="" || date ==null){
				layer.msg('请选择日期.');
			}else{
				var i = layer.load(2);
				$get('/mcy_forms/shifday',params,function(result){
					if(type=="desc"){
						type ="asc";
					}else{
						type ="desc";
					}
					 $.each(result, function(i, obj) {
						obj.requestType = reqCodeMap[obj.requestType];
	                }); 
					// 把数据填充到模版中
					var tbodyHtml = template('shifday',{list:result});
					// 把渲染好的模版html文本追加到表格中
					$('#forms tbody').html(tbodyHtml);
					layer.close(i);
				});
			}
		})
	
		$(".zbhpx").on("click",function(){
			var line = $("#line").val();
			var date = $("#date").val();
			var gsdmShif = $("#gsdmShif").val();
			var fgsdmShif = $("#fgsdmShif").val(); 
			  var params = {};
	            params.fgsdmShif =fgsdmShif;
	            params.date =date;
	            params.gsdmShif =gsdmShif;
	            params.line =line;
	            params.state="cl_zbh";
	            params.type=type;
			if(date=="" || date ==null){
				layer.msg('请选择日期.');
			}else{
				var i = layer.load(2);
				$get('/mcy_forms/shifday',params,function(result){
					if(type=="desc"){
						type ="asc";
					}else{
						type ="desc";
					}
					 $.each(result, function(i, obj) {
						obj.requestType = reqCodeMap[obj.requestType];
	                }); 
					// 把数据填充到模版中
					var tbodyHtml = template('shifday',{list:result});
					// 把渲染好的模版html文本追加到表格中
					$('#forms tbody').html(tbodyHtml);
					layer.close(i);
				});
			}
		})
	
		$("#query").on("click",function(){
		   		var line = $("#line").val();
				var date = $("#date").val();
				var gsdmShif = $("#gsdmShif").val();
				var fgsdmShif = $("#fgsdmShif").val(); 
				  var params = {};
				  if(line )
					  if(line ==" " || line ==""){
						    params.fgsdmShif =fgsdmShif;
					  }
		            params.date =date;
		            params.gsdmShif =gsdmShif;
		            params.line =line;
		            params.state="j_name";
		            params.type=type;
				if(date=="" || date ==null){
					layer.msg('请选择日期.');
				}else{
					var i = layer.load(2);
					$get('/mcy_forms/shifday',params,function(result){
						type ='asc';
						 $.each(result, function(i, obj) {
							obj.requestType = reqCodeMap[obj.requestType];
		                }); 
						// 把数据填充到模版中
						var tbodyHtml = template('shifday',{list:result});
						// 把渲染好的模版html文本追加到表格中
						$('#forms tbody').html(tbodyHtml);
						layer.close(i);
					});
				}
		});
	
	$("#export").on("click",function(){
		var line = $("#line").val();
		var date = $("#date").val();
		var gsdmShif = $("#gsdmShif").val();
		var fgsdmShif = $("#fgsdmShif").val();
		var lineName = $('#line option:selected').text();
		  var params = {};
		  if(line ==" " || line ==""){
			    params.fgsdmShif =fgsdmShif;
		  }            
		  params.date =date;
          params.gsdmShif =gsdmShif;
          params.line =line;
          params.type='export';
          params.lineName =lineName;
		$get('/mcy_export/shifdayExport',params,function(result){
			window.open("/downloadFile/download?fileName="
					+moment(date).format("YYYYMMDD")+
					"-"+lineName+"-班次车辆人员日报表");
		});
	});
});
</script>
<script type="text/html" id="shifday">
	{{each list as obj i}}
		<tr>
			{{if obj.jName == '汇总合计'}}
				<td colspan='4'>{{obj.jName}}</td>
			{{else}}
				<td>{{obj.jName}}</td>
				<td>{{obj.sName}}</td>
 				<td>{{obj.lpName}}</td>
				<td>{{obj.carPlate}}</td>
			{{/if}}
   			<td>{{obj.jhlc}}</td>
			<td>{{obj.sjjhlc}}</td>
			<td>{{obj.yygl}}</td>
			<td>{{obj.emptMileage}}</td>
			<td>{{obj.remMileage}}</td>
			<td>{{obj.addMileage}}</td>
			<td>{{obj.totalm}}</td>
			<td>{{obj.jhbc}}</td>
			<td>{{obj.sjjhbc}}</td>
			<td>{{obj.cjbc}}</td>
			<td>{{obj.ljbc}}</td>
			<td>{{obj.sjbc}}</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="16"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>
</script>