潘钊 / 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; 
	   }
	
	.table > thead > tr > td{
		min-width: 80px;
		text-align:center;
	}
	.table > tbody > tr > td{
		text-align:center;
	}
</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;margin-left: 15px;" id="gsbmDiv">
						<span class="item-label" style="width: 80px;">公司: </span>
						<select class="form-control" name="company" id="gsbm" style="width: 180px;"></select>
					</div>
					<div style="display: inline-block; margin-left: 9px;" id="fgsbmDiv">
						<span class="item-label" style="width: 80px;">分公司: </span>
						<select class="form-control" name="subCompany" id="fgsbm" style="width: 180px;"></select>
					</div>
					<div style="margin-top: 2px"></div>
                    <div style="display: inline-block;margin-left: 15px;">
                        <span class="item-label" style="width: 80px;">月份: </span>
                        <input class="form-control" type="text" id="month" style="width: 180px;"/>
                    </div>
					<div style="display: inline-block; margin-left: 23px;">
                        <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;">
						<span class="item-label" style="width: 80px;">线路性质: </span>
						 <select
							class="form-control" name="nature" id="nature" style="width: 180px;">
							<option value="0" selected="selected">全部线路</option>
							<option value="1">营运线路</option>
							<option value="2">非营运线路</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>
			<label><b id="currMonth"></b></label>
			<div class="portlet-body" id="tjrbBody" style="overflow:auto;height: calc(100% - 80px)">
				<div class="table-container"   style="margin-top: 10px;min-width: 906px">
					<table class="table table-bordered table-hover table-checkable" id="forms">
						<thead>
							<tr>
								<th colspan="35"><label id="tjrq"></label>陆家嘴旅游线路调查表</th>
							</tr>
							<tr>
								<td rowspan="2">序号</td>
								<td rowspan="2" style="min-width:90px">线路</td>
								<td rowspan="2" style="min-width:90px">权证配车数</td>
								<td rowspan="2">线路属性</td>
								<td rowspan="2">线路类型</td>
								<td rowspan="2">线路长度</td>
								<td rowspan="2">是否挂牌线路</td>
								<td rowspan="2">是否冷僻线路</td>
								<td rowspan="2" style="min-width:175px">首末班时间</td>
								
								<td colspan="2">调度方式</td>
								<td colspan="2">间隔时间</td>
								
								<td rowspan="2">是否衔接轨交末班</td>
								<td rowspan="2">日均里程</td>
								<td rowspan="2">日均班次</td>
								<td rowspan="2">日均人次</td>
								<td rowspan="2">日均单车人次</td>
								<td rowspan="2">每班次单车人次</td>
								
								<td colspan="3">里程</td>
								
								<td rowspan="2" style="min-width:104px">里程利用率%</td>
								<td rowspan="2" style="min-width:104px">百公里人次（载客公里）</td>
								<td rowspan="2">月人次（票务）</td>
								<td rowspan="2">月营收（票务）</td>
								<td rowspan="2">票价（元）</td>
								<td rowspan="2" style="min-width:104px">百公里营收（元）</td>
								
								<td colspan="3">线路特征</td>
								
								<td rowspan="2" style="min-width:400px">线路走向</td>
								<td rowspan="2" style="min-width:600px">线路站点</td>
								<td rowspan="2" style="min-width:160px">备注</td>
							</tr>
							<tr>
								<td rowspan="1" style="min-width:60px">常规</td>
								<td rowspan="1" style="min-width:60px">多样化</td>
								<td rowspan="1">高峰</td>
								<td rowspan="1">低谷</td>
								<td rowspan="1" style="min-width:104px">运营总公里（含空驶）</td>
								<td rowspan="1" style="min-width:104px">集调实际公里（含空驶）</td>
								<td rowspan="1" style="min-width:104px">集调营运公里（载客公里）</td>
								<td rowspan="1">途径轨交站</td>
								<td rowspan="1">途径三级医院</td>
								<td rowspan="1">唯一线</td>
							</tr>
						</thead>
						<tbody class="calcInvestigateMonth">
							
						</tbody>
					</table>
				</div>
			</div>
		</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() - 4*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;
		var initMonth = year + "-" + month;
		$("#month").datetimepicker({
			format : 'YYYY-MM',
			locale : 'zh-cn',
			maxDate : initMonth
		});
		$("#month").val(initMonth);
		
		
		var fage=false;
		var obj = [];
		var xlList;
		$.get('/report/lineList',function(result){
			xlList=result;
			$.get('/user/companyData', function(result){
				obj = result;
				var options = '<option value="">全部公司</option>';
				for(var i = 0; i < obj.length; i++){
					options += '<option value="'+obj[i].companyCode+'">'+obj[i].companyName+'</option>';
				}
				
				if(obj.length ==0){
					 $("#gsbmDiv").css('display','none');
				}else if(obj.length ==1){
					 $("#gsbmDiv").css('display','none');
					if(obj[0].children.length == 1  || obj[0].children.length ==0)
						$('#fgsbmDiv').css('display','none');
				}
				$('#gsbm').html(options);
				updateCompany();
			});
		})
		$("#gsbm").on("change",updateCompany);
		function updateCompany(){
			var company = $('#gsbm').val();
			var options = '<option value="">全部分公司</option>';
			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>';
					}
				}
			}
			$('#fgsbm').html(options);
// 			initXl();
		}
		
		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() == " "){
				$("#gsbm").attr("disabled", false);
				$("#fgsbm").attr("disabled", false);
			} else {
				var temp = tempData[$("#line").val()].split(":");
				$("#gsbm").val(temp[0]);
				updateCompany();
				$("#fgsbm").val(temp[1]);
				$("#gsbm").attr("disabled", true);
				$("#fgsbm").attr("disabled", true);
				$("#nature").val(0);
			}
		});
		

		var line ="";
		var xlName ="";
		var nature ="";
		var month = "";
		var gsbm = "";
		var fgsbm = "";
		$("#query").on("click",function(){
			if($("#month").val() == null || $("#month").val().trim().length == 0){
				layer.msg("请选择月份！");
				return;
			}
// 			$("#tjrbBody").height($(window).height()-100);
			line = $("#line").val();
			xlName = $("#select2-line-container").html();
			nature = $("#nature").val();
			month = $("#month").val();
			gsbm = $("#gsbm").val();
			fgsbm = $("#fgsbm").val();
			if(line=="请选择"){
				line="";
			}
			if(month==null || month ==""){
				 layer.msg('请选择月份！');
			}else{
// 				$("#tjrq").html(date+"至"+date2);
				var params = {};
				params['gsbm'] = gsbm;
				params['fgsbm'] = fgsbm;
				params['month'] = month;
				params['line'] = line;
				params['xlName'] = xlName;
				params['nature'] = nature;
				params['type'] = "query";
				$get('/calc_mix/calcInvestigateMonth',params,function(result){
					$("#currMonth").html("（"+month+"）");
					// 把数据填充到模版中
					var tbodyHtml = template('calcInvestigateMonth',{list:result});
					// 把渲染好的模版html文本追加到表格中
					$('#forms .calcInvestigateMonth').html(tbodyHtml);
					
					if(result.length == 0)
						$("#export").attr('disabled',"true");
					else
						$("#export").removeAttr("disabled");
				});
			}
			
		});
// 		$("#tjrbBody").height($(window).height()-100);
		$("#export").on("click",function(){
			var params = {};
			params['gsbm'] = gsbm;
			params['fgsbm'] = fgsbm;
			params['month'] = month;
			params['line'] = line;
			params['xlName'] = xlName;
			params['nature'] = nature;
			params['type'] = "export";
			$get('/calc_mix/calcInvestigateMonth',params,function(result){
				window.open("/downloadFile/download?fileName=陆家嘴旅游线路调查表"+moment(month).format("YYYY-MM"));
			});
		});

	});
</script>
<script type="text/html" id="calcInvestigateMonth">
	{{each list as obj i}}
		<tr>
			<td>{{i + 1}}</td>
			<td>{{obj.xlmc}}</td>
			<td>{{obj.qzpcs}}</td>
			<td>{{obj.xlsx}}</td>
			<td>{{obj.xllx}}</td>
			<td>{{obj.xlcd}}</td>
			<td>{{obj.sfgp}}</td>
			<td>{{obj.sflpxl}}</td>
			<td>{{obj.smbsj}}</td>
			<td>{{if obj.ddfs == '常规'}}√{{/if}}</td>
			<td>{{if obj.ddfs == '多样化'}}√{{/if}}</td>
			<td>{{obj.gfjgsj}}</td>
			<td>{{obj.dgjgsj}}</td>
			<td>{{obj.sfxjgj}}</td>
			<td>{{obj.rjlc}}</td>
			<td>{{obj.rjbc}}</td>
			<td>{{obj.rjrc}}</td>
			<td>{{obj.rjdcrc}}</td>
			<td>{{obj.mbcrc}}</td>
			<td>{{obj.jhzgl}}</td>
			<td>{{obj.sjzgl}}</td>
			<td>{{obj.sjyylc}}</td>
			<td>{{obj.lclyl}}</td>
			<td>{{obj.bglrc}}</td>
			<td>{{obj.yrc}}</td>
			<td>{{obj.yys}}</td>
			<td>{{obj.pj}}</td>
			<td>{{obj.bglys}}</td>
			<td>{{obj.tjgjz}}</td>
			<td>{{obj.tjsjyy}}</td>
			<td>{{obj.wyx}}</td>
			<td>{{obj.xlzx}}</td>
			<td>{{obj.xlzd}}</td>
			<td>{{obj.bz}}</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="34"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>