潘钊 / 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="">
				 <div style="display: inline-block; margin-left: 33px;" id="gsdmDiv_sing">
						<span class="item-label" style="width: 80px;">公司: </span>
						<select class="form-control" name="company" id="gsdmSing" style="width: 140px;"></select>
					</div> 
					<div style="display: inline-block; margin-left: 10px;" id="fgsdmDiv_sing">
						<span class="item-label" style="width: 80px;">分公司: </span>
						<select class="form-control" name="subCompany" id="fgsdmSing" 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: 140px;"></select>
                    </div>
					<div style="display: inline-block;margin-left: 15px">
						<span class="item-label" style="width: 140px;">内部编码： </span>
						<select class="form-control" name="nbbm" id="nbbm" style="width: 140px;"></select>
						<input class="btn btn-default" type="button" id="czcl" value="X"/>
					</div>
					<div style="display: inline-block;margin-left: 33px;">
						<span class="item-label" style="width: 140px;">工号: </span>
						<input class="form-control" type="text" id="gh" style="width: 140px;"/>
					</div>
					<div style="margin-top: 10px"></div>
					<!-- <div style="display: inline-block; margin-left: 5px">
						<span class="item-label" style="width: 80px;">是否营运: </span>
						<select class="form-control" name="sfyy" id="sfyy" style="width: 140px;">
							<option value="0">全部线路</option>
							<option value="1" selected="selected">营运线路</option>
							<option value="2">非营运线路</option>
						</select>
					</div> -->
                    <div style="display: inline-block;margin-left: 33px;">
                        <span class="item-label" style="width: 140px;">时间: </span>
                        <input class="form-control" type="text" id="startDate" style="width: 140px;"/>
                    </div>
                    
                    <div style="display: inline-block;margin-left: 15px">
                        <span class="item-label" style="width: 150px;">统计: </span>
                        <select class="form-control" name="tjtype" id="tjtype" style="width: 140px;">
                        	<option value="jsy">驾驶员</option>
                        	<option value="spy">售票员</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>
			<div class="portlet-body">
				<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>序号</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>
								<th>非营业用油</th>
								<th>计划公里</th>
							</tr>
						</thead>
						<tbody>
							
						</tbody>
					</table>
				</div>
			</div>
		</div>
	</div>
</div>

<script>
	$(function(){
		// 关闭左侧栏
		if (!$('body').hasClass('page-sidebar-closed'))
			$('.menu-toggler.sidebar-toggler').click();
		
		$("#startDate,#endDate").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;
		$("#startDate").val(year + "-" + month + "-" + day);
		
		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_sing").css('display','none');
				}else if(obj.length ==1){
					 $("#gsdmDiv_sing").css('display','none');
					if(obj[0].children.length == 1  || obj[0].children.length ==0)
						$('#fgsdmDiv_sing').css('display','none');
				}
				$('#gsdmSing').html(options);
				updateCompany();
			});
		})
		$("#gsdmSing").on("change",updateCompany);
		function updateCompany(){
			var company = $('#gsdmSing').val();
// 			var options = '<option value="">全部分公司</option>';
			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>';
					}
				}
			}
			$('#fgsdmSing').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() == " "){
				$("#gsdmSing").attr("disabled", false);
				$("#fgsdmSing").attr("disabled", false);
			} else {
				var temp = tempData[$("#line").val()].split(":");
				$("#gsdmSing").val(temp[0]);
				updateCompany();
				$("#fgsdmSing").val(temp[1]);
// 				$("#fgsdmSing").val("");
				$("#gsdmSing").attr("disabled", true);
// 				$("#fgsdmSing").attr("disabled", true);
			}
		});
		
		
		$("#query").on("click",function(){
			if($("#startDate").val() == null || $("#startDate").val().trim().length == 0){
				layer.msg("请选择时间！");
				return;
			}
		    var sfyy = $("#sfyy").val();
		    var line = $("#line").val();
		    var startDate = $("#startDate").val();
		    var lpName = $("#lpName").val(); 
		    var gsdmSing = $("#gsdmSing").val();
		    var fgsdmSing = $("#fgsdmSing").val(); 
		    var tjtype=$("#tjtype").val();
			var nbbm=$("#nbbm").val();
			var gh=$("#gh").val();
		    var params = {};
		    var i = layer.load(2);
		    if(tjtype=='jsy'){
		    	$get("/mcy_forms/singledatatj",{sfyy:sfyy,gsdmSing:gsdmSing,fgsdmSing:fgsdmSing,line:line,startDate:startDate,lpName:lpName,tjtype:tjtype,nbbm:nbbm,gh:gh},function(result){
			   		layer.close(i);
			        var singledata = template('singledata',{list:result});
	                // 把渲染好的模版html文本追加到表格中
			        $('#forms tbody').html(singledata);
	                
			    }); 
		    }else{
		    	$get("/mcy_forms/singledatatj",{sfyy:sfyy,gsdmSing:gsdmSing,fgsdmSing:fgsdmSing,line:line,startDate:startDate,lpName:lpName,tjtype:tjtype,nbbm:nbbm,gh:gh},function(result){
			   		layer.close(i);
			        var singledata = template('singledata',{list:result});
	                // 把渲染好的模版html文本追加到表格中
			        $('#forms tbody').html(singledata);
	                
			    }); 
		    }
		   
		});
		
		$("#export").on("click",function(){
		    var sfyy = $("#sfyy").val();
			 var line = $("#line").val();
			    var startDate = $("#startDate").val();
			    var endDate = $("#endDate").val();
			    var lpName = $("#lpName").val(); 
			    var gsdmSing = $("#gsdmSing").val();
			    var fgsdmSing = $("#fgsdmSing").val(); 
			    var tjtype=$("#tjtype").val();
				var lineName = $('#line option:selected').text();
				if(lineName == "全部线路")
					lineName = $('#fgsdmSing option:selected').text();
				var nbbm=$("#nbbm").val();
				var gh=$("#gh").val();
		    	var i = layer.load(2);
// 			    if(tjtype=='jsy'){
			    	$get('/mcy_export/singledataExportTj',{sfyy:sfyy,gsdmSing:gsdmSing,fgsdmSing:fgsdmSing,line:line,startDate:startDate,endDate:endDate,tjtype:tjtype,type:'export',lineName:lineName,nbbm:nbbm,gh:gh},function(result){
						window.open("/downloadFile/download?fileName="
								+moment(startDate).format("YYYYMMDD")
								+"-"+lineName+"-路单数据");
						layer.close(i);
					});
// 			    }else{
// 			    	$get('/mcy_export/singledataExport',{gsdmSing:gsdmSing,fgsdmSing:fgsdmSing,line:line,startDate:startDate,endDate:endDate,tjtype:tjtype,type:'export'},function(result){
// 						window.open("/downloadFile/download?fileName=路单数据"+moment(startDate).format("YYYYMMDD"));
// 					});
// 			    }
			
		});
		$('#nbbm').select2({
			ajax: {
				url: '/realSchedule/sreachVehic',
				dataType: 'json',
				delay: 150,
				data: function(params){
					return{nbbm: params.term};
				},
				processResults: function (data) {
					return {
						results: data
					};
				},
				cache: true
			},
			templateResult: function(repo){
				if (repo.loading) return repo.text;
				var h = '<span>'+repo.text+'</span>';
				h += (repo.lineName?'&nbsp;<span class="select2-desc">'+repo.lineName+'</span>':'');
				return h;
			},
			escapeMarkup: function (markup) { return markup; },
			minimumInputLength: 1,
			templateSelection: function(repo){
				return repo.text;
			},
			language: {
				noResults: function(){
					return '<span style="color:red;font-size: 12px;">没有搜索到车辆！</span>';
				},
				inputTooShort : function(e) {
					return '<span style="color:gray;font-size: 12px;"><i class="fa fa-search"></i> 输入自编号搜索车辆</span>';
				},
				searching : function() {
					return '<span style="color:gray;font-size: 12px;"> 正在搜索车辆...</span>';
				}
			}
		});
		//重置
		$('#czcl').on('click', function () {
			$('#nbbm').val('').change();
		});
	});
</script>
<script type="text/html" id="singledata">
	{{each list as obj i}}
		<tr>
			<td>{{i+1}}</td>
			<td>{{obj.rQ}}</td>
			<td>{{obj.gS}}</td>
 			<td>{{obj.xlmc}}</td>
			<td>{{obj.clzbh}}</td>
			<td>{{obj.jsy}}</td>
			<td>{{obj.jName}}</td>
			<td>{{obj.sgh}}</td>
			<td>{{obj.sName}}</td>
			<td>{{obj.jhlc}}</td>
			<td>{{obj.emptMileage}}</td>
 			<td>{{obj.hyl}}</td>
			<td>{{obj.jzl}}</td>
			<td>{{obj.unyyyl}}</td>
			<td>{{obj.jhjl}}</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="16"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>
<script type="text/html" id="singledata2">
	{{each list as obj i}}
		<tr>
			<td>{{i+1}}</td>
			<td>{{obj.rQ}}</td>
			<td>{{obj.gS}}</td>
 			<td>{{obj.xlmc}}</td>
			<td>{{obj.clzbh}}</td>
			<td></td>
			<td></td>
			<td>{{obj.sgh}}</td>
			<td>{{obj.sName}}</td>
			<td>{{obj.jhlc}}</td>
			<td>{{obj.emptMileage}}</td>
 			<td></td>
			<td></td>
			<td></td>
			<td>{{obj.jhjl}}</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="16"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>