dianwang
/
dianwangAdm


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482
							<!DOCTYPE html>
<html>

<head>
    <meta charset="utf-8">
    <title>导入</title>
    <script src="../../js/min-loader-next.js"></script>
    <link rel="stylesheet" href="../../plugins/layui/lay/modules/steps/style.css"></link>
    <style>
    	.layui-input {
    		width : 200px;
    	}
    </style>
</head>
<body class="content">
	<div id="step_demo" class="step-body" style = "margin-top : 20px; margin-left: 10%;">
	    <div class="step-header" style="width:80%;overflow: hidden;">
	        <ul>
	            <li>
	                <span class="step-name">选择文件类型</span>
	            </li>
	            <li>
	                <span class="step-name">上传文件</span>
	            </li>
	            <li>
	                <span class="step-name">提交</span>
	            </li>
	        </ul>
	    </div>
	</div>
	<div class="order-body" style = "width: 80%; margin-left : 10%;height : 450px" name = "step">
		<form class="layui-form" style = "text-align : center;">
			<div class="order-select" id="content" style = "background: #FFFFFF;border-radius: 8px;padding: 16px 1.4rem;">
				<div class="layui-inline" style="margin-top: 150px;">
					<label class="f12-gray4">请选择文件类型:</label>
					<div id = "fileTypeDiv" class="layui-inline">
					</div>
				</div>
				<div style="margin-top : 200px;">
			      <button type="button" class="layui-btn" style = "width : 214px" onclick = "goStep(2)">下一步</button>
			    </div>
			</div>
		</form>
	</div>
	<div name = "step" style = "width: 80%; margin-left : 10%;height : 300px; display : none; text-align : center;">
		<div style = "width: 80%; margin-left : 0px;" class = "layui-upload-drag" id = "uploadDiv">
		  <i class="layui-icon"></i>
		  <p>点击上传，或将文件拖拽到此处</p>
		  <div class="layui-hide" id="uploadDemoView">
		    <hr>
		    <img src="" alt="上传成功后渲染" style="max-width: 196px">
		  </div>
		</div>
		<div style="margin-top : 50px;">
	      <button type="button" class="layui-btn" style = "width : 214px" id = "uploadBtn">提交</button>
	    </div>
	</div>
	<div name = "step" style = "width: 80%; margin-left : 10%;height : 300px; display : none; text-align : center; margin-top : 50px;">
		<i class="layui-icon layui-icon-ok-circle" style="font-size: 100px; color: #009688;"></i>
		<p style = "font-weight: 700;font-size: 25px;">文件上传成功！</p>
		<p style = " color: #b2bbc2;">可在数据仓库-原始数据进行查看</p>
		<div style="margin-top : 100px;">
	      <button type="button" class="layui-btn" style = "width : 214px" onclick = "finish()">完成</button>
	    </div>
	</div>
	<div id = "tableDemo1000001" name = "tableDiv" style = "display : none; margin: 10px;">
		<p style = "font-weight: 700;">表格示例</p>
		<p>1、请上传有标准行列的一组数据</p>
		<p>2、日期字段需包含年月日（如：2020/08/08）或年月日时分（如：2020/08/08 00:00:00）</p>
		<table class="layui-table">
			<tr>
				<td>No.</td>
				<td>台区编号</td>
				<td>台区名称</td>
				<td>数据日期</td>
				<td>单位</td>
				<td>供电所名称</td>
				<td>终端名称</td>
				<td>终端编号</td>
				<td>终端地址码</td>
				<td>停电时间</td>
				<td>来电时间</td>
			</tr>
			<tr>
				<td>1</td>
				<td>0001304032</td>
				<td>南羊流</td>
				<td>2020-05-21</td>
				<td>新泰</td>
				<td>羊流供电所</td>
				<td>羊流南羊流西终端</td>
				<td>1000000001804848</td>
				<td>21989275</td>
				<td>2020-05-21 05:15:00</td>
				<td>2020-05-21 07:29:00</td>
			</tr>
			<tr>
				<td>2</td>
				<td>0001304032</td>
				<td>南羊流</td>
				<td>2020-05-21</td>
				<td>新泰</td>
				<td>羊流供电所</td>
				<td>羊流南羊流西终端</td>
				<td>1000000001804848</td>
				<td>21989275</td>
				<td>2020-05-21 05:15:00</td>
				<td>2020-05-21 07:29:00</td>
			</tr>
		</table>
	</div>
	<div id = "tableDemo1000002" name = "tableDiv" style = "display : none; margin: 10px;">
		<p style = "font-weight: 700;">表格示例</p>
		<p>1、请上传有标准行列的一组数据</p>
		<p>2、日期字段需包含年月日（如：2020/08/08）或年月日时分（如：2020/08/08 00:00:00）</p>
		<table class="layui-table">
			<tr>
				<td>ID</td>
				<td>TNAME</td>
				<td>CMODE</td>
				<td>VALUE</td>
				<td>facname</td>
				<td>type</td>
				<td>fdid</td>
				<td>yxstatus</td>
				<td>tytime</td>
			</tr>
			<tr>
				<td>1073741832</td>
				<td>鱼池线11开关</td>
				<td>无线</td>
				<td>1</td>
				<td>珠海许继</td>
				<td>DYFTU</td>
				<td>117440611</td>
				<td>0</td>
				<td>2012-03-13 16:59:07</td>
			</tr>
			<tr>
				<td>1073741833</td>
				<td>农业大学开关[Z]</td>
				<td>无线</td>
				<td>1</td>
				<td>珠海许继</td>
				<td>FJFTU</td>
				<td>117441716</td>
				<td>1</td>
				<td>2012/3/13 16:59:07</td>
			</tr>
		</table>
	</div>
	<div id = "tableDemo1000003" name = "tableDiv" style = "display : none; margin: 10px;">
		<p style = "font-weight: 700;">表格示例</p>
		<p>1、请上传有标准行列的一组数据</p>
		<p>2、日期字段需包含年月日（如：2020/08/08）或年月日时分（如：2020/08/08 00:00:00）</p>
		<table class="layui-table">
			<tr>
				<td>序号</td>
				<td>故障停电开始时间</td>
				<td>故障停电结束时间</td>
				<td>供电类型</td>
				<td>出线变电站</td>
				<td>线路名称</td>
				<td>线路类型</td>
				<td>启动FA</td>
				<td>故障区间判断</td>
				<td>故障前后段恢复</td>
				<td>故障隔离</td>
			</tr>
			<tr>
				<td>1</td>
				<td>2012-03-13 16:59:07</td>
				<td>2012-03-13 17:59:07</td>
				<td>市公司</td>
				<td>110KV东关变电站</td>
				<td>青年路线</td>
				<td>电流型</td>
				<td>是</td>
				<td>正确</td>
				<td>正确</td>
				<td>成功</td>
			</tr>
			<tr>
				<td>2</td>
				<td>2012-03-13 16:59:07</td>
				<td>2012-03-13 17:59:07</td>
				<td>市公司</td>
				<td>110KV南湖变电站</td>
				<td>满庄线</td>
				<td>电流型</td>
				<td>是</td>
				<td>定位错误</td>
				<td>恢复失败</td>
				<td>隔离失败</td>
			</tr>
		</table>
	</div>
	<div id = "tableDemo1000006" name = "tableDiv" style = "display : none; margin: 10px;">
		<p style = "font-weight: 700;">表格示例</p>
		<p>1、请上传有标准行列的一组数据</p>
		<p>2、日期字段需包含年月日（如：2020/08/08）或年月日时分（如：2020/08/08 00:00:00）</p>
		<table class="layui-table">
			<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>
				<td>关联工单</td>
				<td>问题原因分类</td>
				<td>工单分级</td>
				<td>责任部门</td>
				<td>归档时间</td>
				<td>挂起时间</td>
				<td>挂起原因</td>
				<td>服务渠道</td>
				<td>省级回退责任原因</td>
			</tr>
			<tr>
				<td>1</td>
				<td>200620092407</td>
				<td>2020062006093555</td>
				<td>完成</td>
				<td>服务申请</td>
				<td>结束</td>
				<td>123</td>
				<td>2020-06-20 09:55</td>
				<td>【短信变更】</td>
				<td>7896</td>
				<td>先生</td>
				<td>山东省泰安市泰山区环山路和博阳路交叉口</td>
				<td>12</td>
				<td>【非常满意归档】已将处理结果告知客户，客户表示非常满意。</td>
				<td>用电服务需求</td>
				<td>客户侧用电需求配合</td>
				<td>客户侧用电需求配合</td>
				<td>泰安供电公司</td>
				<td>高新供电中心</td>
				<td>23</td>
				<td>24</td>
				<td>东部新区供电所</td>
				<td>营业班</td>
				<td>否</td>
				<td></td>
				<td></td>
				<td>营销远程工作站</td>
				<td>2020-06-22 15:47</td>
				<td></td>
				<td></td>
				<td>呼叫中心</td>
				<td></td>
				<td></td>
				<td>高新</td>
				<td>东部新区供电所</td>
				<td>泰山</td>
				<td>0</td>
				<td>6</td>
				<td>泰山</td>
				<td>基础信息</td>
			</tr>
			<tr>
				<td>2</td>
				<td>200620092407</td>
				<td>2020062006093555</td>
				<td>完成</td>
				<td>服务申请</td>
				<td>结束</td>
				<td>123</td>
				<td>2020-06-20 09:55</td>
				<td>【短信变更】</td>
				<td>7896</td>
				<td>先生</td>
				<td>山东省泰安市泰山区环山路和博阳路交叉口</td>
				<td>12</td>
				<td>【非常满意归档】已将处理结果告知客户，客户表示非常满意。</td>
				<td>用电服务需求</td>
				<td>客户侧用电需求配合</td>
				<td>客户侧用电需求配合</td>
				<td>泰安供电公司</td>
				<td>高新供电中心</td>
				<td>23</td>
				<td>24</td>
				<td>东部新区供电所</td>
				<td>营业班</td>
				<td>否</td>
				<td></td>
				<td></td>
				<td>营销远程工作站</td>
				<td>2020-06-22 15:47</td>
				<td></td>
				<td></td>
				<td>呼叫中心</td>
				<td></td>
				<td></td>
				<td>高新</td>
				<td>东部新区供电所</td>
				<td>泰山</td>
				<td>0</td>
				<td>6</td>
				<td>泰山</td>
				<td>基础信息</td>
			</tr>
		</table>
	</div>
	<div id = "tableDemo1000007" name = "tableDiv" style = "display : none; margin: 10px;">
		<p style = "font-weight: 700;">表格示例</p>
		<p>1、请上传有标准行列的一组数据</p>
		<p>2、日期字段需包含年月日（如：2020/08/08）或年月日时分（如：2020/08/08 00:00:00）</p>
		<table class="layui-table">
			<tr>
				<td>序号</td>
				<td>类型</td>
				<td>单位</td>
				<td>设备名称</td>
				<td>发生时间</td>
				<td>事项类型</td>
				<td>馈线自动化动作情况（FA)</td>
				<td>跳闸类型</td>
				<td>故障原因</td>
				<td>重合闸动作情况</td>
				<td>处理纪事</td>
				<td>异常概况</td>
			</tr>
			<tr>
				<td>1</td>
				<td>计停</td>
				<td>景区供电中心</td>
				<td>中天门站:10kV岱顶线</td>
				<td>2012-03-13 17:59:07</td>
				<td>跳闸</td>
				<td>主线跳闸</td>
				<td>用户进线电缆施工损伤，造成AC相间短路跳闸</td>
				<td>未投重合闸</td>
				<td>配电自动化显示：北上高站:10kV汉明线创业支07-01D开关跳闸</td>
				<td>指挥支线天泰文化旅游发展用户箱变电缆进水</td>
			</tr>
			<tr>
				<td>2</td>
				<td>非计停</td>
				<td>景区供电中心</td>
				<td>中天门站:10kV岱顶线</td>
				<td>2012-03-13 17:59:07</td>
				<td>跳闸</td>
				<td>主线跳闸</td>
				<td>用户进线电缆施工损伤，造成AC相间短路跳闸</td>
				<td>未投重合闸</td>
				<td>配电自动化显示：北上高站:10kV汉明线创业支07-01D开关跳闸</td>
				<td>指挥支线天泰文化旅游发展用户箱变电缆进水</td>
			</tr>
		</table>
	</div>
	
    <script>
		var pageId = getQueryString("pageId");
		
		var $step;
		layui.config({
	        base: '../../plugins/layui/lay/modules/steps/'
	    }).use(['steps','jquery'],function(){
	    	var $ = layui.$;
    	    $step = $("#step_demo").step();
		})
		
		layui.use('form', function(){
			var form = layui.form;
			$.request({
				action : 'BranchFileTypeAction/branchFileTypeQuery',
				data : {
				},
				success : function(data) {
					var html = '<select id = "fileType"><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();
				},
				error : function(data2) {
					$.ErrorAlert(data2.MINErrorMessage);
				}
    	  	});
		})
		
		function goStep (step) {
			if (step == 2) {
				var fileType = $("#fileTypeDiv").find("select option:selected").val();
				if (isEmpty(fileType)) {
					$.ErrorAlert("请选择上传文件类型!");
					return;
				}
				if (!isEmpty(fileType)) {
					$("[name='tableDiv']").hide();
					$("#tableDemo"+fileType).show();
				}
			}
			if (step == 3) {
				$("#tableDemo").hide();
			}
			
			$step.goStep(step);
			var stepDiv = $("div[name = 'step']");
			for (var i = 0; i < stepDiv.length; i ++) {
				if (step == (i + 1)) {
					$(stepDiv[i]).show();
				} else {
					$(stepDiv[i]).hide();
				}
			}
		}
		var chongfuFlag = false;
		layui.use('upload', function(){
			var $ = layui.jquery
			,upload = layui.upload;
			
			  //拖拽上传
			upload.render({
			    elem: '#uploadDiv'
			    ,url: '../../DataWareManageAction/fileInfUpload'
			    ,auto: false
			    ,bindAction: '#uploadBtn'
		    	,accept: 'file' 
		    	,field: 'file'
	    	    ,exts: 'xls|xlsx'
				,before: function(obj){ 
					var fileType = $("#fileTypeDiv").find("select option:selected").val();
   	    		    layer.load(); //上传loading
   	    		    this.data = {fileType : fileType, chongfuFlag : chongfuFlag};
   	    		}
			    ,done: function(res){
			    	layer.closeAll('loading'); //关闭loading
			    	if (res.code == 0) {
			    		goStep(3);
			    	} else {
			    		var fileType = $("#fileTypeDiv").find("select option:selected").val();
			    		console.log(res.MINErrorMessage);
			    		var errorMessage = res.MINErrorMessage;
			    		console.log(typeof(errorMessage));
			    		if (fileType == "1000001" && errorMessage.substr(0, 7) == "chongfu") {
			    			var message = res.MINErrorMessage.split("|");
		    				layer.confirm("台区编号：【"+message[1]+"】 台区名称：【"+message[2]+"】 数据日期：【"+message[3]+"】数据重复,是否继续上传?", {icon: 3, title:'提示'}, function(index){
		    					chongfuFlag = true;
								layer.close(index);
								$('#uploadBtn').click();
		    				});
		    			}
			    	}
			    }
			    ,error: function(index, upload){
			    	layer.closeAll('loading'); //关闭loading
			    	$.ErrorAlert("操作失败!");
			    }
			});
		})
		
		function finish() {
			deleteTabPageParent(pageId); 
		}
    </script>
</body>

</html>