潘钊 / 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; }
</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">
							<span class="item-label" style="width: 80px;">公司: </span>
							<select class="form-control" name="company" id="gsdmEnergy" style="width: 180px;"></select>
						</div> 
						<div style="display: inline-block; margin-left: 38px;" id="fgsdmDiv">
							<span class="item-label" style="width: 80px;">分公司: </span>
							<select class="form-control" name="subCompany" id="fgsdmEnergy" style="width: 180px;"></select>
						</div>
						<div style="display: inline-block;margin-left: 33px;">
                    	    <span class="item-label" style="width: 80px;">线路: </span>
                            <select class="form-control" name="line" id="line" style="width: 180px;"></select>
                    	</div>
						<div style="margin-top: 10px">
                    </div>
					<div style="display: inline-block;margin-left: 33px;">
                    	    <span class="item-label" style="width: 80px;">类型: </span>
                            <select class="form-control"  style="width: 180px;" id="energy">
                                <option value="1">油汇总</option>
                            	<option value="2">电汇总</option>
                            </select>
                    </div>
					<div style="display: inline-block;">
                        <span class="item-label" style="width: 80px;margin-left: 24px;">时间: </span>
                        <input class="form-control" type="text" id="date" style="width: 180px;"/>
                    </div>
                    
                    <div class="form-group">
                    	<input type="hidden" id="id"/>
                        <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>
								<td>日期</td>
								<td>公司</td>
								<td>分公司</td>
								<td>线路</td>
								<td>自编号</td>
								<td>驾工号</td>
								<td>驾姓名</td>
								<td>售工号</td>
								<td>售姓名</td>
								<td>出场公里</td>
								<td>出场存油</td>
								<td>加油量</td>
								<td>进场公里</td>
								<td>进场存油</td>
								<td>油耗</td>
								<td>损耗油量</td>
								<td>损耗原因</td>
								<td>燃油类型</td>
								<td>尿素</td>
								<td>总里程</td>
								<td>百公里油耗</td>
								<td>行驶里程</td>
								<td>空驶里程</td>
							</tr>
						</thead>
						<tbody>
						</tbody>
					</table>
					
					<table class="table table-bordered table-hover table-checkable" style="display: none"  id="forms_d">
						<thead>
							<tr>
								<td>日期</td>
								<td>公司</td>
								<td>分公司</td>
								<td>线路</td>
								<td>自编号</td>
								<td>驾工号</td>
								<td>驾姓名</td>
								<td>售工号</td>
								<td>售姓名</td>
								<td>出场公里</td>
								<td>出场存电</td>
								<td>充电量</td>
								<td>进场公里</td>
								<td>进场存电</td>
								<td>耗电</td>
								<td>损耗电量</td>
								<td>损耗原因</td>
								<td>总里程</td>
								<td>百公里电耗</td>
								<td>行驶里程</td>
								<td>空驶里程</td>
							</tr>
						</thead>
						<tbody>
						</tbody>
					</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;
		$("#date").datetimepicker({
			format : 'YYYY-MM-DD',
			locale : 'zh-cn',
			maxDate : dateTime
		});
		
		$("#date").val(dateTime);
		
		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").css('display','none');
				}else if(obj.length ==1){
					 $("#gsdmDiv").css('display','none');
					if(obj[0].children.length == 1  || obj[0].children.length ==0)
						$('#fgsdmDiv').css('display','none');
				}
				$('#gsdmEnergy').html(options);
				
				updateCompany();
			});
		});

		$("#gsdmEnergy").on("change",updateCompany);
		function updateCompany(){
			var company = $('#gsdmEnergy').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>';
					}
				}
			}
			$('#fgsdmEnergy').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() == " "){
					$("#gsdmEnergy").attr("disabled", false);
					$("#fgsdmEnergy").attr("disabled", false);
				} else {
					var temp = tempData[$("#line").val()].split(":");
					$("#gsdmEnergy").val(temp[0]);
					updateCompany();
					$("#nature").val(0);
					$("#fgsdmEnergy").val(temp[1]);
					$("#gsdmEnergy").attr("disabled", true);
					$("#fgsdmEnergy").attr("disabled", true);
				}
			});

		$("#export").attr('disabled',"true");
		
		//查询
		$("#query").on('click',function(){
			var line = $("#line").val();
			var date = $("#date").val();
			var fgs=$('#fgsdmEnergy').val();
			var gs=$('#gsdmEnergy').val();
			var energy=$('#energy').val();
			var i = layer.load(2);
		    $get('/report/singleEnergy',{line:line,date:date,gs:gs,fgs:fgs,energy:energy,type:"query"},function(result){
			if(energy=="2"){
				var singleEnergy_d = template('singleEnergy_d',{list:result});
				$('#forms_d tbody').html(singleEnergy_d);
				$("#forms").hide();
				$("#forms_d").show();
			}else{
				var singleEnergy = template('singleEnergy',{list:result});
				$('#forms tbody').html(singleEnergy);
				$("#forms_d").hide();
				$("#forms").show();
			}
			layer.close(i);
			if(result.length == 0)
				$("#export").attr('disabled',"true");
			else
				$("#export").removeAttr("disabled");
			});   
		});
		
	
		$("#export").on("click",function(){
			var line = $("#line").val();
			var date = $("#date").val();
			var fgs=$('#fgsdmEnergy').val();
			var gs=$('#gsdmEnergy').val();
			var energy=$('#energy').val();
			var lineName = $('#line option:selected').text();
			if(lineName == "全部线路")
				lineName = $('#fgsdm option:selected').text();
			if(lineName=="全部分公司")
				lineName = $('#gsdm option:selected').text();

			var i = layer.load(2);
			$get('/report/singleEnergy',{line:line,date:date,gs:gs,fgs:fgs,energy:energy,type:"export",lineName:lineName},function(result){
				if(energy=="2"){
					window.open("/downloadFile/download?fileName="
							+date+"路单电量统计表");
				}else{
					window.open("/downloadFile/download?fileName="
							+date+"路单油量统计表");
				}
				
				layer.close(i);
			});
		});
		
		
		
	});
</script>
<script type="text/html" id="singleEnergy">
	{{each list as obj i}}
		<tr>
		<td>{{obj.date}}</td>
		<td>{{obj.gsName}}</td>
		<td>{{obj.fgsName}}</td>
		<td>{{obj.linename}}</td>
		<td>{{obj.nbbm}}</td>
		<td>{{obj.jsy}}</td>
		<td>{{obj.jname}}</td>
		<td>{{obj.sGh}}</td>
		<td>{{obj.sName}}</td>
		<td>{{obj.czlc}}</td>
		<td>{{obj.czyl}}</td>
		<td>{{obj.jzl}}</td>
		<td>{{obj.jzlc}}</td>
		<td>{{obj.jzyl}}</td>
		<td>{{obj.yh}}</td>
		<td>{{obj.sh}}</td>
		<td>{{obj.shyy}}</td>
		<td>{{obj.rylx}}</td>
		<td>{{obj.ns}}</td>
		<td>{{obj.zlc}}</td>
		<td>{{obj.bglyh}}</td>
		<td>{{obj.zlcAll}}</td>
		<td>{{obj.zksgl}}</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="23"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>

<script type="text/html" id="singleEnergy_d">
	{{each list as obj i}}
		<tr>
		<td>{{obj.date}}</td>
		<td>{{obj.gsName}}</td>
		<td>{{obj.fgsName}}</td>
		<td>{{obj.linename}}</td>
		<td>{{obj.nbbm}}</td>
		<td>{{obj.jsy}}</td>
		<td>{{obj.jname}}</td>
		<td>{{obj.sGh}}</td>
		<td>{{obj.sName}}</td>
		<td>{{obj.czlc}}</td>
		<td>{{obj.czcd}}</td>
		<td>{{obj.cdl}}</td>
		<td>{{obj.jzlc}}</td>
		<td>{{obj.jzcd}}</td>
		<td>{{obj.hd}}</td>
		<td>{{obj.sh}}</td>
		<td>{{obj.shyy}}</td>
		<td>{{obj.zlc}}</td>
		<td>{{obj.bglyh}}</td>
		<td>{{obj.zlcAll}}</td>
		<td>{{obj.zksgl}}</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="21"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>