dianwang
/
dianwangAdm


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337
							<!DOCTYPE html>
<html>

<head>
    <meta charset="utf-8">
    <title>数据仓库</title>
    <script src="../../js/min-loader-next.js"></script>
</head>
<body class="content">
	<div class="order-body">
		<div class="order-tiaojian back-gray">
			<div class="tiaojian-part1" id = "conditions">
				<div class="fl f12-gray4-op">所选条件：</div>
			</div>
			<div class="tiaojian-part2 fr  demoTable">
				<button class="order-bnt1 layui-btn" onclick="reloadSearch()" >查询</button>
				<button class="layui-btn order-bnt2" onclick="reset()">重置</button>
				<button class="order-bnt2 layui-btn" onclick="uploadExcel()">导入</button>
				<button class="order-bnt2 layui-btn" onclick="downLoadExcel()">导出</button>
				<a href="#" id="toggle" class="top">收起</a>
			</div>
		</div>
		<form class="layui-form" action="" id = "formRole">
			<div class="order-select back-border" id="content">
				<div class="d-dashed" style="margin: 10px 0;"></div>
				<div class="layui-inline">
					<label class="f12-gray4">上传日期:</label>
					<div class="layui-input-inline" style="position: relative;">
						<input type="text" class="layui-input" id="date" placeholder="请选择日期" readOnly/>
					</div>
				</div>
				<div class="layui-inline">
					<label class="f12-gray4">文件名称:</label>
					<input name="fileName"  id ="fileName" autocomplete="off" placeholder="请输入文件名称" class="search-select" onchange = "changeSelectCon(1,this,'inp')">
				</div>
				<div class="layui-inline">
					<label class="f12-gray4">数据类型:</label>
					<div id = "fileTypeDiv" class="layui-inline"></div>
				</div>
			</div>
		</form>
	</div>
	<div class="shadow-content" style="margin:1.5rem;">
    	<table id="tableTest" lay-filter="tableFilter"></table>
	</div>
	<script type="text/html" id="barDemo">
		<a class="layui-btn layui-btn-xs" lay-event="detail">详情查看</a>
     	<a class="layui-btn layui-btn-xs" lay-event="downLoad">下载</a>
		<a class="layui-btn layui-btn-xs" lay-event="delete">删除</a>
   	</script>
    <script>
	$("#toggle").click(function() {
		$(this).html($("#content").is(":hidden") ? "收起" + "<i class='iconfont up iconSelect_drop-down'/></i>" : "展开" +
			"<i class='iconfont up iconSelect_drop-down'/></i>");
		$("#content").slideToggle();
	});
	var pageId = "210000";
	
     var table;
     var form;
     layui.use(['table','laydate', 'form'], function(){
    	  var laydate = layui.laydate;
    	  laydate.render({ 
    		  elem: '#date'
    		  ,type: 'date'
    		  ,range: true
    		  ,done: function(value, date, endDate){
    			  changeSelectCon(0,"date",'date',value)
  			  }
		  });
		  form = layui.form;
    	  $.request({
				action : 'BranchFileTypeAction/branchFileTypeQuery',
				data : {
				},
				success : function(data) {
					var html = '<select id = "fileType" lay-filter="test"><option value = "">请选择</option>';
					var fileTypeList = data.data;
					for (var i = 0; i < fileTypeList.length; i ++) {
						var fileTypeInf = fileTypeList[i];
						html += '<option value = "' + fileTypeInf.id +'">' + fileTypeInf.name + '</option>';
					}
					html += '</select>';
					$("#fileTypeDiv").html(html);
					form.render();
					
					form.on('select(test)', function(data){
						changeSelectCon(2,data.elem,"sel")
					});      
				},
				error : function(data2) {
					$.ErrorAlert(data2.MINErrorMessage);
				}
	  	});
    	  
    	  
		  table = layui.table;
		  
		  // 加载数据
		  table.render({
			id: 'tableTest'
		    ,elem: '#tableTest'
		    ,limit:10
		    ,url: 'DataWareManageAction/fileInfQuery' //数据接口
		    ,method: 'post'
		    ,where:{MINView:"JSON"}
		    ,page: true //开启分页
		    ,cols: [[ //表头
		      {field:'num', title: '序号',width:'5%', type:'numbers', align: 'center'}
		      ,{field: 'uploadDate', title: '时间', width:'10%', sort: true}
		      ,{field: 'typeName', title: '数据类型', width:'10%'}
		      ,{field: 'fileName', title: '文件名称', width:'20%'}
		      ,{field: 'userName', title: '导入人员', width:'10%'}
		      ,{field: 'dataNum', title: '数据条数', width: '10%', sort: true}
		      ,{field: 'operate', title: '操作', width: '25%', toolbar: '#barDemo', fixed : 'right'}
		    ]]
		    ,done: function(res, curr, count){
		    }
		    ,even: true //开启隔行背景
		  });
		  
		 // 监听工具条（操作）
		  table.on('tool(tableFilter)', function(obj){ //注：tool是工具条事件名，tableFilter是table原始容器的属性 lay-filter="对应的值"
		  	var data = obj.data; //获得当前行数据
		    var layEvent = obj.event; //获得 lay-event 对应的值（也可以是表头的 event 参数对应的值）
		    var tr = obj.tr; //获得当前行 tr 的DOM对象
		    if (layEvent === 'detail'){ //查看
		    	showDetail(data);
		    } else if(layEvent === 'downLoad'){
		    	window.open("../../DataWareManageAction/fileInfDownload?fileId=" + data.id);
		    } else if(layEvent === 'delete'){
		    	layer.confirm('确认删除？', function(index){
	        		layer.close(index);
	        		$.request({
						action : 'DataWareManageAction/fileInfDelete',
						data : {
							fileId : data.id,
							fileType : data.type//文件类型
						},
						success : function(data1) {
							$.SuccAlert("操作成功!");
							reloadSearch();
						},
						error : function(data2) {
							$.ErrorAlert(data2.MINErrorMessage);
						}
		    	  	});
	      		});
		    }
		  });
	 });
      
      function reloadSearch (t) {
	    	var fileName = $("#fileName").val();
	    	var date = $("#date").val();
	    	var type = $("#fileTypeDiv").find("select option:selected").val();
	        //执行重载
 		    table.reload('tableTest', {
 		        page: {
 		        	curr: 1 //重新从第 1 页开始
 		        }
 		        ,where: {
 		        	date : date,
 		        	fileName : fileName,
 		        	type : type
 		        }
 		     });
 		 if (t == 1) {
     		  $.Alert("修改成功"); 
     	 }
      }
      
      function reset(){
    	  $('#formRole')[0].reset();
    	  $("#conditions").html('<div class="fl f12-gray4-op">所选条件：</div>');
      }
      
      function uploadExcel(){
    	  var openPageId = pageId + "-01";
    	  openMainTabPage(openPageId, "导入", "reprotManage/dataWareUpload.html?pageId="+openPageId, '', pageId, reloadSearch);
      }
      function downLoadExcel(){
		$.request({
			action : 'BranchFileTypeAction/branchFileTypeQuery',
			data : {
			},
			success : function(data) {
				var html = '<select><option value = "">请选择</option>';
				var fileTypeList = data.data;
				for (var i = 0; i < fileTypeList.length; i ++) {
					var fileTypeInf = fileTypeList[i];
					html += '<option value = "' + fileTypeInf.id +'">' + fileTypeInf.name + '</option>';
				}
				html += '</select>';
				layer.open({
				  type: 1,
				  skin: 'layui-layer-rim', //加上边框
				  area: ['600px', '400px'], //宽高
				  content: '<form class="layui-form" style = "margin-top : 20px;">' +
								'<div class="layui-inline" style = "margin-left : 20px;">' +
									'<label class="f12-gray4">数据日期:</label>' +
									'<div class="layui-input-inline" style="position: relative;">' +
										'<input type="text" class="layui-input" name = "date" placeholder="请选择日期" readOnly/>' +
									'</div>' +
								'</div>' +
								'<div class="layui-inline">' +
									'<label class="f12-gray4">文件名称:</label>' +
									'<div class="layui-inline">' +
										html +
									'</div>' +
								'</div>' +
							'</form>',
				  btn: ['导出', '取消'],
				  yes: function(index, layero){
					  var date = $(".layui-layer").find("input[name='date']").val();
				  	  var type = $(".layui-layer").find("select option:selected").val();
				  	  if (isEmpty(date)) {
				  		  $.ErrorAlert("请选择日期范围!");
				  		  return;
				  	  }
				  	  if (isEmpty(type)) {
				  		  $.ErrorAlert("请选择数据类型!");
				  		  return;
				  	  }
					  var param = {};
				  	  param.date = date;
				  	  param.type = type;
			    	  exportExcel("../../DataWareManageAction/fileDataDownload", param); 
				  },
				  btn2: function(index, layero){
				  },
				  success: function(layero, index){
					form.render();
					var time = $(".layui-layer").attr("time");
					$(".layui-layer").find("input[name='date']").attr("id","date" + time);
					layui.use(['laydate'], function(){
			    	  var laydate = layui.laydate;
			    	  laydate.render({ 
			    		  elem: '#date' + time
			    		  ,type: 'date'
			    		  ,range: true
					  });
					})
				  }
				});
				
				
			},
			error : function(data2) {
				$.ErrorAlert(data2.MINErrorMessage);
			}
		});
      }
      
      function showDetail(data){
    	  var openPageId = pageId + "-02";
    	  openMainTabPage(openPageId, "详情查看", "reprotManage/dataWareDetail.html?pageId="+openPageId+"&fileId="+data.id+"&fileType="+data.type, '', pageId, null);
      }
      
   	function changeSelectCon(index, t, type, dateValue){
   		if (type == "date") {
   			if (isEmpty(dateValue)) {
   				$("#search" + index).remove();
   			} else {
   				$("#search" + index).remove();
   				if (isEmpty($("#search" + index).attr("name"))) {
   					$("#conditions").append(getSelectConHtml(index, t, type,dateValue));
   				}
   			}
   		} else if (type == 'inp') {
   			if (isEmpty($(t).val())) {
   				$("#search" + index).remove();
   			} else {
   				$("#search" + index).remove();
   				if (isEmpty($("#search" + index).attr("name"))) {
   					$("#conditions").append(getSelectConHtml(index, t, type));
   				}
   			}
   		} else {
   			if (isEmpty($(t).val()) && isEmpty($(t).find("select option:selected").val())) {
   				$("#search" + index).remove();
   			} else {
   				$("#search" + index).remove();
   				if (isEmpty($("#search" + index).attr("name"))) {
   					$("#conditions").append(getSelectConHtml(index, t, type));
   				}
   			}
   		}
   	}
    	
	var array = new Array('上传日期','文件名称', '数据类型');
	function getSelectConHtml(index, t, type,dateValue){
		var name;
		if (type == "date") {
			name = $("#"+t).attr("id");
		} else {
			name = $(t).attr("id");
		}
		var value;
		if(type == "inp"){
			value = t.value.substr(0,5)+"..";
		}
		if (type == "date") {
			value = dateValue;
		}
		if(type == "sel"){
			value = $(t).find("option:selected").text();
		}
		var html = '<div class="fl xuanzhong-active" id = "search' + index + '" name = "' + name + '" onclick = "removeSearch(this)">' +
						'<div class="fl">' + array[index] + '</div>' +
						':<span>'+value+'</span>' +
						'<svg class="icon" aria-hidden="true">' +
						  '<use xlink:href="#iconicon_close1"></use>' +
						'</svg>' +
					'</div>';
		return html;
	}
	function removeSearch(t) {
		if ($(t).attr("name") == 'subjects') {
			initSelect('stateDiv', "COMPANY_STATE", "state", '', true); 
			form.render();
			$(t).remove();
		} else {
			$("#"+$(t).attr("name")).val('');
			var tagName = $("#"+$(t).attr("name")).get(0).tagName;
			if ("SELECT" == tagName) {
				console.log($("#"+$(t).attr("name")).next())
				console.log($("#"+$(t).attr("name")).next().find("input"))
				$($("#"+$(t).attr("name")).next().find("input")).val('');
			}
			$(t).remove();
		}
	}
    </script>
</body>

</html>