潘钊 / 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 id="history" class="form-inline" action="">
					<div style="display: inline-block;margin-left: 38px;" id="company1">
						<span class="item-label" style="width: 80px;">公司: </span>
						<select class="form-control" name="company" id="company" style="width: 160px;"></select>
					</div>
					<div style="display: inline-block;margin-left: 24px;" id="subCompany1">
						<span class="item-label" style="width: 80px;">分公司: </span>
						<select class="form-control" name="subCompany" id="subCompany" style="width: 160px;"></select>
					</div>
					<div style="display: inline-block;margin-left: 38px;">
						<span class="item-label" style="width: 80px;">线路: </span>
						<select class="form-control" name="line" id="line" style="width: 160px;"></select>
					</div>
					<div style="margin-top: 10px"></div>
					<div style="display: inline-block;margin-left: 10px;">
						<span class="item-label" style="width: 80px;">开始时间: </span>
						<input class="form-control" type="text" id="startDate" style="width: 160px;"/>
					</div>
					<div style="display: inline-block;margin-left: 10px;">
						<span class="item-label" style="width: 80px;">结束时间: </span>
						<input class="form-control" type="text" id="endDate" style="width: 160px;"/>
					</div>
					<div style="display: inline-block;margin-left: 10px;">
						<span class="item-label" style="width: 80px;">模板类型: </span>
						<select class="form-control" name="model" id="model" style="width: 160px;">
							<option value="">请选择...</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 class="hidden">
								<th style="display: none;"></th>
								<th width="8%">公司</th>
								<th width="8%">分公司</th>
								<th width="8%">线路</th>
								<th width="8%">起点站名</th>
								<th width="6%">计发时间</th>
								<th width="6%">计划运送时间(分)</th>
								<th width="6%">计划完成次数</th>
								<th width="6%">完成次数</th>
								<th width="6%">最早发车时间</th>
								<th width="6%">最晚发车时间</th>
								<th width="6%">平均发车时间</th>
								<th width="6%">最慢运送时间(分)</th>
								<th width="6%">最快运送时间(分)</th>
								<th width="6%">平均运送时间(分)</th>
							</tr>
						</thead>
						<tbody>
							
						</tbody>
					</table>
					<div style="text-align: right;">
						<ul id="pagination" class="pagination"></ul>
					</div>
				</div>
			</div>
		</div>
	</div>
</div>

<script>
	$(function(){
		var page = 0, initPagination;
		$('#export').attr('disabled', "true");
		
		// 关闭左侧栏
		if (!$('body').hasClass('page-sidebar-closed'))
			$('.menu-toggler.sidebar-toggler').click();
		
		$("#startDate").datetimepicker({
			format : 'YYYY-MM-DD',
			locale : 'zh-cn'
		});
		
		$("#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);
		$("#endDate").val(year + "-" + month + "-" + day);
		
		$.get('/basic/lineCode2Name',function(result){
			var data=[];
			
			data.push({id:" ", text: "全部线路"});
			for(var code in result){
				data.push({id: code, text: result[code]});
			}
			console.log(data);
			initPinYinSelect2('#line',data,'');

			line = "";
			updateModel();
		});
		
		var obj = [];
		$.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 == 1){
				$('#company1').hide();
				if(obj[0].children.length == 1)
					$('#subCompany1').hide();
			}
			$('#company').html(options);
			updateCompany();
		});
		$("#company").on("change",updateCompany);
		function updateCompany(){
			var company = $('#company').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>';
					}
				}
			}
			$('#subCompany').html(options);
		}
		
		
		$("#query").on("click", function(){
			page = 0;
			jsDoQuery(true);
		});
		
		var line = $("#line").val();
		var startDate = $("#startDate").val();
		var endDate = $("#endDate").val();
		var model = $("#model").val();
		var company = $("#company").val();
		var subCompany = $("#subCompany").val();
		function jsDoQuery(pagination){
			var params = {};
// 			line = $("#line").val();
			startDate = $("#startDate").val();
			endDate = $("#endDate").val();
			model = $("#model").val();
			company = $("#company").val();
			subCompany = $("#subCompany").val();
			params['page'] = page;
			params['line'] = line;
			params['startDate'] = startDate;
			params['endDate'] = endDate;
			params['model'] = model;
			params['company'] = company;
			params['subCompany'] = subCompany;
			params['type'] = "query";
			$(".hidden").removeClass("hidden");
			$get('/pcpc/scheduleAnaly', params, function(result){
				// 把数据填充到模版中
				var tbodyHtml = template('list_scheduleAnaly',{list:result.dataList});
				// 把渲染好的模版html文本追加到表格中
				$('#forms tbody').html(tbodyHtml);

				if(result.dataList.length == 0)
					$("#export").attr('disabled',"true");
				else
					$("#export").removeAttr("disabled");
				
				if(pagination && result.dataList.length > 0){
					//重新分页
					initPagination = true;
					showPagination(result);
					
					$('#pagination').show();
				} else if(result.dataList.length == 0){
					$('#pagination').hide();
				}
			});
		}
		
		$("#export").on("click",function(){
			var params = {};
			params['page'] = page;
			params['line'] = line;
			params['startDate'] = startDate;
			params['endDate'] = endDate;
			params['model'] = model;
			params['company'] = company;
			params['subCompany'] = subCompany;
			params['type'] = "export";
			$get('/pcpc/scheduleAnaly', params, function(result){
				window.open("/downloadFile/download?fileName=时刻表分析"+moment(startDate).format("YYYYMMDD")+"-"+moment(endDate).format("YYYYMMDD"));
			});
		});


		$("#line").on("change", function(){
			line = $("#line").val();
			if(line == " ")
				line = "";
			updateModel();
		});
		$('#startDate').on("blur", function(){
			startDate = $("#startDate").val();
			endDate = $("#endDate").val();
			updateModel();
		});
		$('#endDate').on("blur", function(){
			startDate = $("#startDate").val();
			endDate = $("#endDate").val();
			updateModel();
		});
		
		var flag = 0;
		function updateModel(){
			if(flag == 1)
				return;
			flag = 1;
			var treeData = [];
			var params = {};
			params['line'] = line;
			params['startDate'] = startDate;
			params['endDate'] = endDate;
			$get('/pcpc/getModel', params, function(result){
				treeData = createTreeData(result);
				var options = '<option value="">请选择...</option>';
				var size = 0;
				$.each(treeData, function(i, g){
					options += '<option value="'+g.id+'">'+g.name+'</option>';
					size++;
				});
				$('#model').html(options)/* .select2() */;
				flag = 0;
			});
		}
		
		
		function showPagination(data){
			//分页
			$('#pagination').jqPaginator({
			    totalPages: data.totalPage,
			    visiblePages: 6,
			    currentPage: page + 1,
			    first: '<li class="first"><a href="javascript:void(0);">首页<\/a><\/li>',
	            prev: '<li class="prev"><a href="javascript:void(0);">上一页<\/a><\/li>',
	            next: '<li class="next"><a href="javascript:void(0);">下一页<\/a><\/li>',
	            last: '<li class="last"><a href="javascript:void(0);">尾页<\/a><\/li>',
	            page: '<li class="page"><a href="javascript:void(0);">{{page}}<\/a><\/li>',
			    onPageChange: function (num, type) {
			    	if(initPagination){
			    		initPagination = false;
			    		return;
			    	}
			    	page = num - 1;
			    	jsDoQuery(false);
			    }
			});
		}
		
		
	});
	
</script>
<script type="text/html" id="list_scheduleAnaly">
	{{each list as obj i}}
		<tr>
			<th style="display: none;"></th>
			<td>{{obj.company}}</td>
			<td>{{obj.subCompany}}</td>
			<td>{{obj.line}}</td>
			<td>{{obj.qdz}}</td>
			<td>{{obj.jhfc}}</td>
			<td>{{obj.bcsj}}</td>
			<td>{{obj.jhbc}}</td>
			<td>{{obj.sjbc}}</td>
			<td>{{obj.zzfc}}</td>
			<td>{{obj.zwfc}}</td>
			<td>{{obj.pjfc}}</td>
			<td>{{obj.zmys}}</td>
			<td>{{obj.zkys}}</td>
			<td>{{obj.pjys}}</td>
		</tr>
	{{/each}}
	{{if list.length == 0}}
		<tr>
			<td colspan="14"><h6 class="muted">没有找到相关数据</h6></td>
		</tr>
	{{/if}}
</script>