statisticsDaily .html 6.74 KB
<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>$$$$$${txt-2447}</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;">
                        <span class="item-label" style="width: 80px;">$$$$$${txt-3815}: </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;">$$$$$${txt-4004}: </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="$$$$$${txt-3841}"/>
                        <input class="btn btn-default" type="button" id="export" value="$$$$$${txt-4163}"/>
                    </div>
				</form>
			</div>
			<div class="portlet-body">
				<div class="table-container" style="margin-top: 10px;overflow:auto;min-width: 906px">
					<label>$$$$$${txt-3420}:6:31~8:30&nbsp;&nbsp;&nbsp;&nbsp;$$$$$${txt-3421}:16:01~18:00</label>
					<table class="table table-bordered table-hover table-checkable" id="forms">
						<thead>
							<tr>
								<th colspan="36">$$$$$${txt-429}</th>
							</tr>
							<tr>
								<td rowspan="3">$$$$$${txt-3529}</td>
								<td colspan="15">$$$$$${txt-787}</td>
								<td colspan="15">$$$$$${txt-1535}</td>
								<td colspan="5">$$$$$${txt-2026}</td>
							</tr>
							<tr>
								<td rowspan="2">$$$$$${txt-3972}</td>
								<td rowspan="2">$$$$$${txt-3970}</td>
								<td rowspan="2">$$$$$${txt-3883}</td>
								<td colspan="11">$$$$$${txt-788}</td>
								<td rowspan="2">$$$$$${txt-2781}</td>
								<td colspan="3">$$$$$${txt-3186}</td>
								<td colspan="3">$$$$$${txt-3067}</td>
								<td colspan="3">$$$$$${txt-2705}</td>
								<td colspan="3">$$$$$${txt-2929}</td>
								<td colspan="3">$$$$$${txt-2780}</td>
								<td colspan="3">$$$$$${txt-2782}</td>
								<td rowspan="2">$$$$$${txt-593}</td>
								<td rowspan="2">$$$$$${txt-3920}</td>
							</tr>
							<tr>
								<td width="31px">$$$$$${txt-3961}</td>
								<td>$$$$$${txt-3963}</td>
								<td>$$$$$${txt-3840}</td>
								<td>$$$$$${txt-3838}</td>
								<td>$$$$$${txt-3837}</td>
								<td>$$$$$${txt-3957}</td>
								<td>$$$$$${txt-3958}</td>
								<td>$$$$$${txt-3962}</td>
								<td>$$$$$${txt-3960}</td>
								<td>$$$$$${txt-3956}</td>
								<td>$$$$$${txt-4197}</td>
								<td>$$$$$${txt-3959}</td>
								<td>$$$$$${txt-3420}</td>
								<td>$$$$$${txt-3421}</td>
								<td>$$$$$${txt-3959}</td>
								<td>$$$$$${txt-3420}</td>
								<td>$$$$$${txt-3421}</td>
								<td>$$$$$${txt-3959}</td>
								<td>$$$$$${txt-3420}</td>
								<td>$$$$$${txt-3421}</td>
								<td>$$$$$${txt-3959}</td>
								<td>$$$$$${txt-3420}</td>
								<td>$$$$$${txt-3421}</td>
								<td>$$$$$${txt-3959}</td>
								<td>$$$$$${txt-3420}</td>
								<td>$$$$$${txt-3421}</td>
								<td>$$$$$${txt-3959}</td>
								<td>$$$$$${txt-3420}</td>
								<td>$$$$$${txt-3421}</td>
							</tr>
						</thead>
						<tbody class="statisticsDaily">
							
						</tbody>
					</table>
				</div>
			</div>
		</div>
	</div>
</div>

<script>
	$(function(){
		$('#export').attr('disabled', "true");
		
		// 关闭左侧栏
		if (!$('body').hasClass('page-sidebar-closed'))
			$('.menu-toggler.sidebar-toggler').click();
		
		$("#date").datetimepicker({
			format : 'YYYY-MM-DD',
			locale : 'zh-cn'
		});
		$.get('/basic/lineCode2Name',function(result){
			var data=[];
			
			data.push({id: "", text:"$$$$$${txt-3432}"});
			for(var code in result){
				data.push({id: code, text: result[code]});
			}
			initPinYinSelect2('#line',data,'');
			
		})
		

		var line ="";
		var xlName ="";
		var date = "";
		$("#query").on("click",function(){
			line = $("#line").val();
			xlName = $("#select2-line-container").html();
			date = $("#date").val();
			if(line=="$$$$$${txt-3432}"){
				line="";
			}
			$get('/realSchedule/statisticsDaily',{line:line,date:date,xlName:xlName,type:"query"},function(result){
				// 把数据填充到模版中
				var tbodyHtml = template('statisticsDaily',{list:result});
				// 把渲染好的模版html文本追加到表格中
				$('#forms .statisticsDaily').html(tbodyHtml);
				
				if(result.length == 0)
					$("#export").attr('disabled',"true");
				else
					$("#export").removeAttr("disabled");
			});
		});

		$("#export").on("click",function(){
			$get('/realSchedule/statisticsDaily',{line:line,date:date,xlName:xlName,type:"export"},function(result){
				window.open("/downloadFile/download?fileName=$$$$$${txt-2447}"+moment(date).format("YYYYMMDD"));
			});
		});

	});
</script>
<script type="text/html" id="statisticsDaily">
	{{each list as obj i}}
		<tr>
			<td>{{obj.xlName}}</td>
			<td>{{obj.jhlc}}</td>
			<td>{{obj.sjgl}}</td>
			<td>{{obj.ssgl}}</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="36"><h6 class="muted">$$$$$${txt-750}</h6></td>
		</tr>
	{{/if}}
</script>