潘钊 / 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; 
	   }
</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; " id="gsdmDiv">
						<span class="item-label" style="width: 80px;">鍏徃: </span>
						<select class="form-control" name="company" id="gsdm" style="width: 180px;"></select>
					</div> 
					<div style="display: inline-block; margin-left: 29px;" id="fgsdmDiv">
						<span class="item-label" style="width: 80px;">鍒嗗叕鍙�: </span>
						<select class="form-control" name="subCompany" id="fgsdm" style="width: 180px;"></select>
					</div>
					<div style="margin-top: 2px"></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 style="display: inline-block;margin-left: 15px;">
                        <span class="item-label" style="width: 80px;">缁撴潫鏃堕棿: </span>
                        <input class="form-control" type="text" id="date2" 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 class="portlet-body" id="tjrbBody" style="overflow:auto;height: calc(100% - 80px)">
				<div class="table-container"   style="margin-top: 10px;min-width: 906px">
					<label>鏃╅珮宄�:6:31~8:30&nbsp;&nbsp;&nbsp;&nbsp;鏅氶珮宄�:16:01~18:00</label>
					<table class="table table-bordered table-hover table-checkable" id="forms">
						<thead>
							<tr>
								<th colspan="44"><label id="tjrq"></label> 绾胯矾缁熻鏃ユ姤</th>
							</tr>
							<tr>
								<td rowspan="3"><span >璺嚎鍚�</span></td>
								<td colspan="20">鍏ㄦ棩钀ヨ繍閲岀▼锛堝叕閲岋級</td>
								<td colspan="15">鍏ㄦ棩钀ヨ繍鐝</td>
								<td colspan="9">澶ч棿闅旀儏鍐�</td>
							</tr>
							<tr>
								<td rowspan="2"><label>璁″垝鎬�</label>
													<label>鍏噷&nbsp;&nbsp;&nbsp;</label></td>
								<td rowspan="2"><label>璁″垝钀�</label><label>杩愬叕閲�</label></td>
								<td rowspan="2"><label>璁″垝绌�</label><label>椹跺叕閲�</label></td>
								<td rowspan="2"><label>瀹為檯</label><label>鎬诲叕閲�</label></td>
								<td rowspan="2"><label>瀹為檯钀�</label><label>杩愬叕閲�</label></td>
								<td rowspan="2"><label>瀹為檯绌�</label><label>椹跺叕閲�</label></td>
								<td rowspan="2"><span>灏戦┒鍏噷</span></td>
								<td rowspan="2"><span>灏戦┒鐝</span></td>
								<td colspan="11">灏戦┒鍘熷洜锛堝叕閲岋級</td>
								<td rowspan="2"><span >涓村姞鍏噷</span></td>
								<td colspan="3">璁″垝鐝</td>
								<td colspan="3">瀹為檯鐝</td>
								<td colspan="3">涓村姞鐝</td>
								<td colspan="3">鏀剧珯鐝</td>
								<td colspan="3">璋冨ご鐝</td>
								<td colspan="3">鍙戠敓娆℃暟</td>
								<td rowspan="2">鏈�澶ч棿闅旀椂闂达紙鍒嗭級</td>
								<td  rowspan="2">鍘熷洜</td>
							</tr>
							<tr>
								<td><span >璺樆</span></td>
								<td><span>鍚婃參</span></td>
								<td><span >鏁呴殰</span></td>
								<td><span >绾犵悍</span></td>
								<td><span >鑲囦簨</span></td>
								<td><span>缂轰汉</span></td>
								<td><span>缂鸿溅</span></td>
								<td><span >瀹㈢█</span></td>
								<td><span>姘斿��</span></td>
								<td><span>鎻村</span></td>
								<td><span>鍏朵粬</span></td>
								<td><span>鍏ㄦ棩</span></td>
								<td><span>鏃╅珮宄�</span></td>
								<td><span>鏅氶珮宄�</span></td>
								<td><span>鍏ㄦ棩</span></td>
								<td><span>鏃╅珮宄�</span></td>
								<td><span>鏅氶珮宄�</span></td>
								<td><span>鍏ㄦ棩</span></td>
								<td><span>鏃╅珮宄�</span></td>
								<td><span>鏅氶珮宄�</span></td>
								<td><span>鍏ㄦ棩</span></td>
								<td><span>鏃╅珮宄�</span></td>
								<td><span>鏅氶珮宄�</span></td>
								<td><span>鍏ㄦ棩</span></td>
								<td><span>鏃╅珮宄�</span></td>
								<td><span>鏅氶珮宄�</span></td>
								<td><span>鍏ㄦ棩</span></td>
								<td><span>鏃╅珮宄�</span></td>
								<td><span>鏅氶珮宄�</span></td>
							</tr>
						</thead>
						<tbody class="statisticsDailyCalc">
							
						</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;
		$("#date").datetimepicker({
			format : 'YYYY-MM-DD',
			locale : 'zh-cn',
			maxDate : dateTime
		});
		$("#date2").datetimepicker({
			format : 'YYYY-MM-DD',
			locale : 'zh-cn',
			maxDate : dateTime
		});
		$("#date").val(dateTime);
		$("#date2").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');
				}
				$('#gsdm').html(options);
				updateCompany();
			});
		})
		$("#gsdm").on("change",updateCompany);
		function updateCompany(){
			var company = $('#gsdm').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>';
					}
				}
			}
			$('#fgsdm').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() == " "){
				$("#gsdm").attr("disabled", false);
				$("#fgsdm").attr("disabled", false);
			} else {
				var temp = tempData[$("#line").val()].split(":");
				$("#gsdm").val(temp[0]);
				updateCompany();
				$("#fgsdm").val(temp[1]);
				$("#gsdm").attr("disabled", true);
				$("#fgsdm").attr("disabled", true);
			}
		});
		

		var line ="";
		var xlName ="";
		var date = "";
		var date2 ="";
		var gsdm="";
		var fgsdm="";
		$("#query").on("click",function(){
			if($("#date").val() == null || $("#date").val().trim().length == 0){
				layer.msg("璇烽�夋嫨鏃堕棿鑼冨洿锛�");
				return;
			}
			if($("#date2").val() == null || $("#date2").val().trim().length == 0){
				layer.msg("璇烽�夋嫨鏃堕棿鑼冨洿锛�");
				return;
			}
// 			$("#tjrbBody").height($(window).height()-100);
			line = $("#line").val();
			date = $("#date").val();
			date2 =$("#date2").val();
			gsdm =$("#gsdm").val();
			fgsdm=$("#fgsdm").val();
			xlName = $("#select2-line-container").html();
			if(xlName == "鍏ㄩ儴绾胯矾")
				xlName = $('#fgsdm option:selected').text();
			if(line=="璇烽�夋嫨"){
				line="";
			}
			if(date==null || date =="" ||date2==null || date2 ==""){
				 layer.msg('璇烽�夋嫨鏃堕棿娈�.');
			}else{
				$("#tjrq").html(date+"鑷�"+date2);
				 var params = {};
				 params['gsdm'] = gsdm;
				 params['fgsdm'] =fgsdm ;
				 params['line'] = line;
				 params['date'] = date;
				 params['date2'] = date2;
				 params['xlName'] = xlName;
				 params['type'] = "query";
				var i = layer.load(2);
// 				$get('/realSchedule/statisticsDailyTj',params,function(result){
				$get('/calcWaybill/statisticsDailyTj',params,function(result){
					// 鎶婃暟鎹～鍏呭埌妯＄増涓�
					var tbodyHtml = template('statisticsDailyCalc',{list:result});
					// 鎶婃覆鏌撳ソ鐨勬ā鐗坔tml鏂囨湰杩藉姞鍒拌〃鏍间腑
					$('#forms .statisticsDailyCalc').html(tbodyHtml);
					layer.close(i);
					
					if(result.length == 0)
						$("#export").attr('disabled',"true");
					else
						$("#export").removeAttr("disabled");
				});
			}
			
		});
// 		$("#tjrbBody").height($(window).height()-100);
		$("#export").on("click",function(){
			 var params = {};
			 params['gsdm'] = gsdm;
			 params['fgsdm'] =fgsdm ;
			 params['line'] = line;
			 params['date'] = date;
			 params['date2'] = date2;
			 params['xlName'] = xlName;
			 params['type'] = "export";
			var i = layer.load(2);
// 			$get('/realSchedule/statisticsDailyTj',params,function(result){
			$get('/calcWaybill/statisticsDailyTj',params,function(result){
				var dateTime = "";
				if(date == date2){
					dateTime = moment(date).format("YYYYMMDD");
				} else {
					dateTime = moment(date).format("YYYYMMDD")
							+"-"+moment(date2).format("YYYYMMDD");
				}
				window.open("/downloadFile/download?fileName="
						+dateTime+"-"+xlName+"-缁熻鏃ユ姤");
				layer.close(i);
			});
		});

	});
</script>
<script type="text/html" id="statisticsDailyCalc">
	{{each list as obj i}}
		<tr {{if obj.zt==1}}style='color: red'{{/if}}>
			<td>{{obj.xlName}}</td>
			<td>{{obj.jhzlc}}</td>
			<td>{{obj.jhlc}}</td>
			<td>{{obj.jcclc}}</td>
			<td>{{obj.sjzgl}}</td>
			<td>{{obj.sjgl}}</td>
			<td>{{obj.sjksgl}}</td>
			<td>{{obj.ssgl}}</td>
			<td>{{obj.ssbc}}</td>
			<td>{{obj.ssgl_lz}}</td>
			<td>{{obj.ssgl_dm}}</td>
			<td>{{obj.ssgl_gz}}</td>
			<td>{{obj.ssgl_jf}}</td>
			<td>{{obj.ssgl_zs}}</td>
			<td>{{obj.ssgl_qr}}</td>
			<td>{{obj.ssgl_qc}}</td>
			<td>{{obj.ssgl_kx}}</td>
			<td>{{obj.ssgl_qh}}</td>
			<td>{{obj.ssgl_yw}}</td>
			<td>{{obj.ssgl_other}}</td>
			<td>{{obj.ljgl}}</td>
			<td>{{obj.jhbc}}</td>
			<td>{{obj.jhbc_m}}</td>
			<td>{{obj.jhbc_a}}</td>
			<td>{{obj.sjbc}}</td>
			<td>{{obj.sjbc_m}}</td>
			<td>{{obj.sjbc_a}}</td>
			<td>{{obj.ljbc}}</td>
			<td>{{obj.ljbc_m}}</td>
			<td>{{obj.ljbc_a}}</td>
			<td>{{obj.fzbc}}</td>
			<td>{{obj.fzbc_m}}</td>
			<td>{{obj.fzbc_a}}</td>
			<td>{{obj.dtbc}}</td>
			<td>{{obj.dtbc_m}}</td>
			<td>{{obj.dtbc_a}}</td>
			<td>{{obj.djg}}</td>
			<td>{{obj.djg_m}}</td>
			<td>{{obj.djg_a}}</td>
			<td>{{obj.djg_time}}</td>
			<td>&nbsp;</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="44"><h6 class="muted">娌℃湁鎵惧埌鐩稿叧鏁版嵁</h6></td>
		</tr>
	{{/if}}
</script>