gx_tieta/.settings/org.jboss.tools.jst.web.xml
@@ -9,73 +9,73 @@ <file-system NAME="classes" location="%workspace.home%/classes" model-entity="FileSystemFolder"/> <file-system NAME="fuguang" location="%eclipse.project%" model-entity="FileSystemFolder"/> <file-system NAME="lib-javaee.jar" location="D:\Program Files\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\javaee.jar" model-entity="FileSystemJar"/> location="D:\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\javaee.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-jsf-impl.jar" location="D:\Program Files\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\jsf-impl.jar" model-entity="FileSystemJar"/> location="D:\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\jsf-impl.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-jsf-api.jar" location="D:\Program Files\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\jsf-api.jar" model-entity="FileSystemJar"/> location="D:\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\jsf-api.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-jstl-1.2.jar" location="D:\Program Files\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\jstl-1.2.jar" model-entity="FileSystemJar"/> location="D:\MyEclipse\Common\plugins\com.genuitec.eclipse.j2eedt.core_10.0.0.me201110301321\data\libraryset\EE_5\jstl-1.2.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-c3p0-0.9.5.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\lib\c3p0-0.9.5.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\lib\c3p0-0.9.5.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-c3p0-oracle-thin-extras-0.9.5.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\lib\c3p0-oracle-thin-extras-0.9.5.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\lib\c3p0-oracle-thin-extras-0.9.5.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-mchange-commons-java-0.2.9.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\lib\mchange-commons-java-0.2.9.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\lib\mchange-commons-java-0.2.9.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-resources.jar" location="D:\Program Files\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\resources.jar" model-entity="FileSystemJar"/> location="D:\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\resources.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-dnsns.jar" location="D:\Program Files\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\ext\dnsns.jar" model-entity="FileSystemJar"/> location="D:\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\ext\dnsns.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-localedata.jar" location="D:\Program Files\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\ext\localedata.jar" model-entity="FileSystemJar"/> location="D:\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\ext\localedata.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-sunjce_provider.jar" location="D:\Program Files\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\ext\sunjce_provider.jar" model-entity="FileSystemJar"/> location="D:\MyEclipse\Common\binary\com.sun.java.jdk.win32.x86_64_1.6.0.013\jre\lib\ext\sunjce_provider.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-beanutils-1.7.0.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-beanutils-1.7.0.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-beanutils-1.7.0.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-codec-1.10.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-codec-1.10.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-codec-1.10.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-collections-3.1.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-collections-3.1.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-collections-3.1.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-dbcp-1.2.1.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-dbcp-1.2.1.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-dbcp-1.2.1.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-fileupload-1.2.2.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-fileupload-1.2.2.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-fileupload-1.2.2.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-io-2.0.1.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-io-2.0.1.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-io-2.0.1.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-lang-2.5.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-lang-2.5.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-lang-2.5.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-commons-pool-1.2.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-pool-1.2.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\commons-pool-1.2.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-dom4j-1.6.1.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\dom4j-1.6.1.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\dom4j-1.6.1.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-ezmorph-1.0.3.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\ezmorph-1.0.3.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\ezmorph-1.0.3.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-freemarker-2.3.16.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\freemarker-2.3.16.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\freemarker-2.3.16.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-gson-2.2.4.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\gson-2.2.4.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\gson-2.2.4.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-javassist-3.11.0.GA.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\javassist-3.11.0.GA.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\javassist-3.11.0.GA.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-json-lib-2.1-jdk15.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\json-lib-2.1-jdk15.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\json-lib-2.1-jdk15.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-mysql-connector-java-5.1.33-bin.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.33-bin.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.33-bin.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-ognl-3.0.1.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\ognl-3.0.1.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\ognl-3.0.1.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-poi-3.10.1-20140818.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\poi-3.10.1-20140818.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\poi-3.10.1-20140818.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-sqljdbc.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\sqljdbc.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\sqljdbc.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-struts2-core-2.2.3.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\struts2-core-2.2.3.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\struts2-core-2.2.3.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-struts2-json-plugin-2.2.3.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\struts2-json-plugin-2.2.3.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\struts2-json-plugin-2.2.3.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-struts2-sunspoter-stream-1.0.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\struts2-sunspoter-stream-1.0.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\struts2-sunspoter-stream-1.0.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-xwork-core-2.2.3.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\xwork-core-2.2.3.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\xwork-core-2.2.3.jar" model-entity="FileSystemJar"/> <file-system NAME="lib-jacob.jar" location="C:\Users\LiJun\git\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\jacob.jar" model-entity="FileSystemJar"/> location="D:\GitWorkSpace\gx_tieta\gx_tieta\WebRoot\WEB-INF\lib\jacob.jar" model-entity="FileSystemJar"/> <web SERVLET_VERSION="2.4" model-entity="JstWeb" model-path="/web.xml"> <module URI="/WEB-INF/faces-config.xml" model-entity="WebJSFModule" model-path="/faces-config.xml" src="src" web-root="WEB-ROOT"/> gx_tieta/WebRoot/batt-traffic-statistics.jsp
New file @@ -0,0 +1,381 @@ <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <%@ taglib uri="/struts-tags" prefix="s" %> <!DOCTYPE HTML> <html> <head> <base href="<%=basePath%>"> <title>流量统计</title> <!--流量统计--> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link href="css/basic.css" rel="stylesheet"> <link rel="stylesheet" href="css/BrdwMaint.css"> <link rel="stylesheet" type="text/css" href="css/loading.css"> <link rel="stylesheet" type="text/css" href="css/dischargeplan_layout.css"> <link rel="stylesheet" type="text/css" href="src/css/layui.css"> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <style type="text/css"> body { overflow-x: hidden !important; } #tbHead table{ width: 100%; } #tbBrdw { overflow: auto; } #tbBrdw tbody tr:hover { background-color: #DDDDDD; } #cardOption .con_table { overflow: auto; } #tbBrdw table { width: 100%; } #tbBrdw table i.fa-refresh { font-size:18px; cursor: pointer; } #cardOption input[type="checkbox"] { vertical-align: middle; } #cardOption table thead input[type="checkbox"]{ margin-left: 4px; } </style> </head> <body> <!--头部内容开始--> <jsp:include page="Top.jsp" flush="true"/> <!--头部内容结束--> <!--导航开始--> <jsp:include page="nav.jsp" flush="true"/> <!-- 主体内容 --> <div id="main"> <div id="eleInfor"> <span class="summary">流量统计</span> <div class="checkCon"> <!-- 维护区信息 --> <form action="" id="search_form"> <table> <tr class="fWeight"> <td>省</td> <!-- 省 --> <td>市</td> <!-- 市 --> <td><s:text name="Computer_name"/></td> <!-- 机房名称 --> <td>统计方式</td> <td colspan="2" style="width: 30%;">时间段</td> </tr> <tr> <td> <select id="station_name1"> </select> </td> <td> <select id="city"> </select> </td> <td> <select id="station_name"> </select> </td> <td> <select> <option>按年统计</option> <option>按月统计</option> <option>按日统计</option> </select> </td> <td><input type="text" id="startalm" readonly="readonly" name="bmd.adata.alm_start_time" value="2000-1-1" /></td> <td><input type="text" id="endTalm" readonly="readonly" name="bmd.adata.alm_start_time1" /></td> </tr> </table> </form> </div> </div> <!-- 表格固定的头部 --> <div id="tbHead"></div> <!-- 表格滚动的部分 --> <div id="tbBrdw"></div> <!-- 按钮内容 --> <div id="paging"> <span>总计</span> <span>5000</span> </div> </div> <!-- 整体灰色遮罩层 --> <div id="allShade"></div> <script type="text/javascript" src="js/loading.js"></script> <script type="text/javascript" src="js/createTab.js"></script> <script type="text/javascript" src="src/layui.js"></script> <script type="text/javascript" src="js/eleHistWarn1-jquery.ui.js"></script> <script type="text/javascript"> layui.use(['layer'], function() { var layer = layui.layer; var arrTh = new Array(); // 表格的头部 var arrTd = new Array(); // 表格的表体 var tblStatus = new Array(); // 表格状态数组 var tblOptsHd = new Array(); // 表格选项头部 var tblOptsBd = new Array(); // 表格选项数组 arrTh = ['时间段', '机房名称','流量','统计时间']; //arrTh = ['<s:text name="Maintenance_area"/>', '<s:text name="Computer_name"/>', '<s:text name="Nominal_capacity"/>(AH)', '<s:text name="Actual_capacity"/>(AH)','<s:text name="Residual_capacity"/>(AH)', '<s:text name="real_time"/><s:text name="Current"/>(A)', '<s:text name="Power_cut"/><s:text name="Endurance"/><s:text name="Time"/>']; //tblOptsHd = ['编号', '选项', '是否选择']; tblOptsHd = ['<s:text name="Number"/>', '<s:text name="Options"/>', '<s:text name="IsChecked"/>']; var tblHd = $('#tbHead'); var tblBd = $('#tbBrdw'); // 根据表格的头部生成表格选项和表格的状态数组 $(function() { centerDiv($('#cardOption')); // 遍历表格头部生成状态数组 for(var i = 0; i < arrTh.length; i++) { tblStatus.push(1); var temp = new Array(); temp.push(i+1); temp.push(arrTh[i]); temp.push('<input type="checkbox" checked="checked"/>'); tblOptsBd.push(temp); } var cardHd = $('#cardOption .tbHead'); var cardBd = $('#cardOption .con_table'); createCard(cardHd, tblOptsHd, tblOptsBd); createCard(cardBd, tblOptsHd, tblOptsBd); }); // 生成表格 $(function() { for(i=0;i<5000;i++){arrTd.push(i)} createAllTbl(tblHd, tblBd, arrTh, arrTd, tblStatus); // 点击表格选项显示表格选项弹出框 $('#paging .card-opt').click(function() { var checkboxList = $('#cardOption .con_table table tbody').find('input[type="checkbox"]'); // 根据状态数组修改表格选项复选框的状态 for(var i = 0; i < tblStatus.length; i++) { if(tblStatus[i] == 1) { checkboxList.eq(i).prop('checked', true); }else{ checkboxList.eq(i).prop('checked', false); } } $('#cardOption').show(); $('#allShade').show(); }); // 点击取消和确定隐藏表格选项窗口和遮罩层 $('#cardOption .en-card-opts').click(function() { // 根据表格选项的复选框设置状态数组 var checkboxList = $('#cardOption .con_table table tbody').find('input[type="checkbox"]'); checkboxList.each(function(i) { if($(this).is(':checked')) { tblStatus[i] = 1; }else{ tblStatus[i] = 0; } }); createAllTbl(tblHd, tblBd, arrTh, arrTd, tblStatus); $('#cardOption').hide(); $('#allShade').hide(); }); $('#cardOption .out-card-opts').click(function() { $('#cardOption').hide(); $('#allShade').hide(); }); }); // 根据表格的的头部生成 $(function() { $('#endtime').val(new Date().format('yyyy-MM-dd')); }); // 初始化页面高度 $(function() { pageInit(); $(window).resize(function() { pageInit(); }); }); // 初始化页面内容 function pageInit() { var winHt = $(window).height(); var bodyHt = $('body').height(); var tblHt = $('#tbBrdw').height(); var shiftHt = winHt - bodyHt - 32; if(shiftHt > 0) { $('#tbBrdw').height(shiftHt + tblHt); } } // 生成表格的头部和表体 function createAllTbl (header, body, arrTh, arrTd, status) { //console.info(status); var newArrTh = new Array(); var newArrTd = new Array(); newArrTh = getArrTh(status, arrTh); newArrTd = getArrTd(status, arrTd); createTablenew(header, newArrTh, newArrTd); createTablenew(body, newArrTh, newArrTd); // 定义表格的头部和表体宽度一致 var bdWidth = body.find('table').width(); header.find('table').width(bdWidth); } //对于弹出串口进行定位(position:fixed) function centerDiv(ele){ //获取屏幕的高度对弹出窗口进行定位 var srnHei=$(window).height(); //屏幕的高度 var eleHei=ele.height(); //弹出窗口的高度 var topHei=parseInt((srnHei-eleHei)/2); //获取居中高度 ele.css({ 'top':topHei }); } // 省-市-机房-电池组 $(document).ready(function(){ //页面加载时查询维护区中的枢纽类型 $.post("User_battgroup_baojigroup_battgroupAction!serchStationName1InGroup",null,function(data){ data=data.result; data=eval("("+data+")"); //console.info(data); if(data.code==1 && data.data.length>0){ var $select = $("#station_name1"); $select.text(''); for(var i=0;i<=data.data.length;i++){ $option=$("<option></option>"); if(i==0){ $option.html("<s:text name='All'/>(<s:text name='Common'/>"+data.data.length+"<s:text name='Species'/>)"); $option.attr("value", ""); }else{ $option.text(data.data[i-1]); $option.attr("value",data.data[i-1]); } $select.append($option); } }else{ $("#station_name1").text('').html('<option>暂无管理的维护区</option>'); } findCity(); }); }); function findCity() { var data = { StationName1: $("#station_name1").val() }; // 请求获取当前省下的市 $.ajax({ type: "post", url: "BattInfAction!serchStationName2", async:true, dataType:'json', data:"json = "+JSON.stringify(data), success: function(data){ var rs = JSON.parse(data.result); var $select = $("#city"); if(rs.code == 1) { var _data= rs.data; // 根据数据构造生成下拉列表的数据 var optsList = []; for(var i=0;i<_data.length;i++){ var __data = _data[i]; var tmp = getOptionsData(__data.StationName2, __data.StationName2, __data); optsList.push(tmp); } // 根据数据生成下拉列表 createOptions($select, optsList, true); }else { $select.text('').html('<option>暂无可测市</option>'); } findStationNamebyStationname1(); } }); } //当维护区的值变换时更新市 $('#station_name1').change(function(){ findCity(); }); //当维护区的值变换时更新机房站点 $('#city').change(function(){ findStationNamebyStationname1(); }); //根据省，市查询站点 function findStationNamebyStationname1(){ findStationNamebyStationname1.stations = new Array(); var tmp = { StationName1:$("#station_name1").val(), StationName2:$("#city").val() }; //var selectvalue=$("#station_name1 option:selected").val(); //alert(selectvalue); $.post("BattInfAction!serchStationName3","json="+JSON.stringify(tmp),function(data){ var rs = JSON.parse(data.result); if(rs.code==1){ var _data = rs.data; var $select = $("#station_name"); // 根据数据构造生成下拉列表的数据 var optsList = []; for(var i=0;i<_data.length;i++){ var __data = _data[i]; //console.info(__data); var _attr = { StationId: __data.FBSDeviceId, }; var tmp = getOptionsData(__data.StationName3, __data.StationName, __data, _attr); optsList.push(tmp); } findStationNamebyStationname1.stations = _data; // 根据数据生成下拉列表 createOptions($select, optsList, true); }else{ $("#station_name").text('').html('<option>暂无可测机房站点</option>'); } }); } }); //获取选中的机房对象 function getSelectStation(dev_id,arr){ if(arr != undefined && arr.length > 0){ for(var i=0;i<arr.length;i++){ if(arr[i].FBSDeviceId == dev_id){ return arr[i]; } } } return undefined; } </script> </body> </html> gx_tieta/src/com/fgkj/actions/Battinf_exAction.java
New file @@ -0,0 +1,31 @@ package com.fgkj.actions; import com.fgkj.dto.BattInf; import com.fgkj.dto.ServiceModel; import com.fgkj.services.Battinf_exService; import com.opensymphony.xwork2.ActionSupport; public class Battinf_exAction extends ActionUtil{ private Battinf_exService service=new Battinf_exService(); private String json; private String result; //根据电池组的信息stationid查询 public String serchByCondition(){ BattInf binf=getGson().fromJson(json, BattInf.class); ServiceModel model=service.serchByCondition(binf); result=tojson(model); return SUCCESS; } public String getResult() { return result; } public void setJson(String json) { this.json = json; } } gx_tieta/src/com/fgkj/actions/Deverror_recordAction.java
New file @@ -0,0 +1,42 @@ package com.fgkj.actions; import java.util.List; import com.fgkj.dto.BattInf; import com.fgkj.dto.Deverror_record; import com.fgkj.dto.ServiceModel; import com.fgkj.dto.User_inf; import com.fgkj.services.Deverror_recordService; public class Deverror_recordAction extends ActionUtil{ private Deverror_recordService service=new Deverror_recordService(); private String json; private String result; //用户手动添加问题 public String add(){ Deverror_record dev_record=getGson("yyyy-MM-dd").fromJson(json, Deverror_record.class); User_inf uinf=(User_inf) getUser(); dev_record.setUid(uinf.getUId()); ServiceModel model=service.add(dev_record); result=tojson(model); return SUCCESS; } //根据stationid查询设备的问题记录 public String serchByCondition(){ BattInf binf=getGson().fromJson(json, BattInf.class); User_inf uinf=(User_inf) getUser(); binf.setNum(uinf.getUId()); ServiceModel model=service.serchByCondition(binf); result=tojson(model); return SUCCESS; } public String getResult() { return result; } public void setJson(String json) { this.json = json; } } gx_tieta/src/com/fgkj/actions/StationtrafficAction.java
New file @@ -0,0 +1,32 @@ package com.fgkj.actions; import com.fgkj.dto.ServiceModel; import com.fgkj.dto.Stationtraffic; import com.fgkj.dto.User_inf; import com.fgkj.services.StationtrafficService; public class StationtrafficAction extends ActionUtil{ private StationtrafficService service=new StationtrafficService(); private String json; private String result; //统计基站流量 public String serchByCondition() { Stationtraffic st=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, Stationtraffic.class); User_inf uinf=(User_inf) getUser(); st.setNote(uinf.getUId().toString()); ServiceModel model=service.serchByCondition(st); result=tojson(model); return SUCCESS; } public String getResult() { return result; } public void setJson(String json) { this.json = json; } } gx_tieta/src/com/fgkj/dao/BaseDAO.java
@@ -188,6 +188,12 @@ public static final int ECHARTS_USR=92; public static final int BATTINF_EX=93; public static final int DEVERROR_RECORD=94; public static final int STATIONTRAFFIC=95; public boolean add(Object obj); // 添加 public boolean update(Object obj); // 更新 gx_tieta/src/com/fgkj/dao/BaseDAOFactory.java
@@ -31,6 +31,7 @@ import com.fgkj.dao.impl.Battalarm_dataDAOImpl; import com.fgkj.dao.impl.Battalarm_data_historyImpl; import com.fgkj.dao.impl.BattinfThirdImpl; import com.fgkj.dao.impl.Battinf_exImpl; import com.fgkj.dao.impl.BattresdataDAOImpl; import com.fgkj.dao.impl.Battresdata_infDAOImpl; import com.fgkj.dao.impl.BatttestdataDAOImpl; @@ -42,12 +43,14 @@ import com.fgkj.dao.impl.CustompageImpl; import com.fgkj.dao.impl.Database_backupImpl; import com.fgkj.dao.impl.Dev_paramImpl; import com.fgkj.dao.impl.Deverror_recordImpl; import com.fgkj.dao.impl.Devstate_usrImpl; import com.fgkj.dao.impl.Echarts_usrImpl; import com.fgkj.dao.impl.Fbsdev_Statechange_infImpl; import com.fgkj.dao.impl.MapImpl; import com.fgkj.dao.impl.Positiomap_usrImpl; import com.fgkj.dao.impl.Process_surveyImpl; import com.fgkj.dao.impl.StationtrafficImpl; import com.fgkj.dao.impl.UserDAOImpl; import com.fgkj.dao.impl.User_ChartImpl; import com.fgkj.dao.impl.User_battgroup_baojigroupImpl; @@ -194,6 +197,9 @@ case 90:return new Fbs9100s_dfu_stateImpl(); case 91:return new Bts_station_eventImpl(); case 92:return new Echarts_usrImpl(); case 93:return new Battinf_exImpl(); case 94:return new Deverror_recordImpl(); case 95:return new StationtrafficImpl(); default :return null; } } gx_tieta/src/com/fgkj/dao/impl/Battinf_exImpl.java
New file @@ -0,0 +1,128 @@ package com.fgkj.dao.impl; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.fgkj.dao.BaseDAO; import com.fgkj.dao.CallBack; import com.fgkj.dao.DAOHelper; import com.fgkj.db.DBUtil; import com.fgkj.dto.BattInf; import com.fgkj.dto.Battinf_ex; public class Battinf_exImpl implements BaseDAO,CallBack{ public List getResults(ResultSet rs) { // TODO Auto-generated method stub return null; } public boolean add(Object obj) { // TODO Auto-generated method stub return false; } public boolean update(Object obj) { // TODO Auto-generated method stub return false; } public boolean del(Object obj) { // TODO Auto-generated method stub return false; } public List searchAll() { // TODO Auto-generated method stub return null; } //根据电池组的信息stationid查询 public List serchByCondition(Object obj) { BattInf binf=(BattInf) obj; String sql=" select * from db_battinf.tb_battinf_ex where stationId=? "; List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getStationId()}, new CallBack() { public List getResults(ResultSet rs) { List list=new ArrayList(); try { while(rs.next()){ Battinf_ex binf_ex=new Battinf_ex(); binf_ex.setNum(rs.getInt("num")); binf_ex.setStationId(rs.getString("stationId")); binf_ex.setFBSDeviceId(rs.getInt("fBSDeviceId")); binf_ex.setStationName(rs.getString("stationName")); binf_ex.setStationCode(rs.getString("stationCode")); binf_ex.setStationRegion(rs.getString("stationRegion")); binf_ex.setKeyWords(rs.getString("keyWords")); binf_ex.setAffiliation(rs.getString("affiliation")); binf_ex.setDataSources(rs.getString("dataSources")); binf_ex.setStationType(rs.getString("stationType")); binf_ex.setLongitude(rs.getDouble("longitude")); binf_ex.setLatitude(rs.getInt("latitude")); binf_ex.setStationAddr(rs.getString("stationAddr")); binf_ex.setStationLevel(rs.getString("stationLevel")); binf_ex.setMaintenanceState(rs.getString("maintenanceState")); binf_ex.setBlockedState(rs.getString("blockedState")); binf_ex.setMaintenanceCompany(rs.getString("maintenanceCompany")); binf_ex.setBusinessScenario(rs.getString("businessScenario")); binf_ex.setCoverScenario(rs.getString("coverScenario")); binf_ex.setSiteTerrain(rs.getString("siteTerrain")); binf_ex.setPropertyRights(rs.getString("propertyRights")); binf_ex.setPropertyUnit(rs.getString("propertyUnit")); binf_ex.setIsShare(rs.getString("isShare")); binf_ex.setUseUnit(rs.getString("useUnit")); binf_ex.setSiteCode(rs.getString("siteCode")); binf_ex.setHistorySiteCode(rs.getString("historySiteCode")); binf_ex.setSiteInternalNumber(rs.getString("siteInternalNumber")); binf_ex.setSitePinyinReferred(rs.getString("sitePinyinReferred")); binf_ex.setSiteChineseReferred(rs.getString("siteChineseReferred")); binf_ex.setSiteMergeRecord(rs.getString("siteMergeRecord")); binf_ex.setIsOpenBusiness(rs.getString("isOpenBusiness")); binf_ex.setSchoolPersonnel(rs.getString("schoolPersonnel")); binf_ex.setEntryTime(rs.getString("entryTime")); binf_ex.setModifyPeople(rs.getString("modifyPeople")); binf_ex.setModifyTime(rs.getString("modifyTime")); binf_ex.setNote(rs.getString("note")); binf_ex.setSiteReceivesMark(rs.getString("siteReceivesMark")); binf_ex.setSiteValidity(rs.getString("siteValidity")); binf_ex.setSiteNameCMCC(rs.getString("siteNameCMCC")); binf_ex.setSiteNameCUCC(rs.getString("siteNameCUCC")); binf_ex.setSiteNameCTC(rs.getString("siteNameCTC")); binf_ex.setProducer(rs.getString("producer")); binf_ex.setLastTimeLong(rs.getDouble("lastTimeLong")); binf_ex.setLastTimeType(rs.getString("lastTimeType")); binf_ex.setLastTimeDate(rs.getTimestamp("lastTimeDate")); binf_ex.setShareInfo(rs.getString("shareInfo")); binf_ex.setElectPowerCMCC(rs.getInt("electPowerCMCC")); binf_ex.setElectPowerCUCC(rs.getInt("electPowerCUCC")); binf_ex.setElectPowerCTC(rs.getInt("electPowerCTC")); binf_ex.setIsCanElectPower(rs.getInt("isCanElectPower")); binf_ex.setUpperStationRoute(rs.getDouble("upperStationRoute")); binf_ex.setUpperStationDifficult(rs.getString("upperStationDifficult")); binf_ex.setClienteleErrorService(rs.getString("clienteleErrorService")); list.add(binf_ex); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } }); return list; } public List serchByInfo(Object obj) { // TODO Auto-generated method stub return null; } public static void main(String[] args) { Battinf_exImpl bimpl=new Battinf_exImpl(); BattInf binf=new BattInf(); binf.setStationId("42000001"); List list=bimpl.serchByCondition(binf); System.out.println(list.size()); } } gx_tieta/src/com/fgkj/dao/impl/Deverror_recordImpl.java
New file @@ -0,0 +1,126 @@ package com.fgkj.dao.impl; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.fgkj.dao.BaseDAO; import com.fgkj.dao.CallBack; import com.fgkj.dao.DAOHelper; import com.fgkj.dao.LimitNumberFactory; import com.fgkj.db.DBUtil; import com.fgkj.dto.BattInf; import com.fgkj.dto.Deverror_record; import com.fgkj.dto.Page; public class Deverror_recordImpl implements BaseDAO,CallBack{ public List getResults(ResultSet rs) { // TODO Auto-generated method stub return null; } //用户手动添加问题 public boolean add(Object obj) { Deverror_record dev_record=(Deverror_record) obj; String sql=" insert into db_battinf.tb_deverror_record(stationId,record_time,error_descript,uid) values(?,?,?,?)"; boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{dev_record.getStationId(),dev_record.getRecord_time(),dev_record.getError_descript(),dev_record.getUid()}); return bl; } public boolean update(Object obj) { // TODO Auto-generated method stub return false; } public boolean del(Object obj) { // TODO Auto-generated method stub return false; } public List searchAll() { // TODO Auto-generated method stub return null; } //根据stationid查询设备的问题记录 public List serchByCondition(Object obj) { BattInf binf=(BattInf) obj; Page p=binf.getPage(); Connection conn=DBUtil.getConn(); String numberSql=" SELECT FOUND_ROWS() number"; String sql=" select SQL_CALC_FOUND_ROWS distinct tb_deverror_record.num,tb_deverror_record.stationid,record_time,error_descript,error_en " + " ,db_battinf.tb_battinf.stationname,stationname1,stationname2,stationname3,stationname5 " + " from db_battinf.tb_deverror_record,db_battinf.tb_battinf " + " where tb_deverror_record.stationid=tb_battinf.stationid " + " and tb_deverror_record.stationid like ? and stationname1 like ? and stationname2 like ? and stationname5 like ? " + " and tb_deverror_record.uid=? and error_en=0 " ; //用户管理 String userSql=" and db_battinf.tb_battinf.StationId in(" + " select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=? "+ " ) "; sql+=userSql; String orderSql=" order by record_time desc "; sql+=orderSql; String limitSql=" limit ?,? "; sql+=limitSql; List<Deverror_record> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{"%"+binf.getStationId()+"%","%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName5()+"%",binf.getNum() ,binf.getNum(),(p.getPageCurr()-1)*p.getPageSize(),p.getPageSize()}, new CallBack() { public List getResults(ResultSet rs) { List list=new ArrayList(); try { while(rs.next()){ Deverror_record dev_record=new Deverror_record(); dev_record.setNum(rs.getInt("num")); dev_record.setStationId(rs.getString("stationId")); dev_record.setStationName(rs.getString("stationName")); dev_record.setStationName1(rs.getString("stationName1")); dev_record.setStationName2(rs.getString("stationName2")); dev_record.setStationName3(rs.getString("stationName3")); dev_record.setStationName5(rs.getString("stationName5")); dev_record.setRecord_time(rs.getTimestamp("record_time")); dev_record.setError_descript(rs.getString("error_descript")); dev_record.setError_en(rs.getInt("error_en")); Page page=new Page(); dev_record.setPage(page); list.add(dev_record); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } }); //去掉limit条件后的总数 int number=LimitNumberFactory.GetLimtitNumber(conn, numberSql); if(list!=null&&list.size()>0){ list.get(list.size()-1).getPage().setPageSize(number); } return list; } public List serchByInfo(Object obj) { // TODO Auto-generated method stub return null; } public static void main(String[] args) { Deverror_recordImpl dimpl=new Deverror_recordImpl(); BattInf binf=new BattInf(); binf.setNum(1002); binf.setStationName(""); binf.setStationName1(""); binf.setStationName2(""); binf.setStationName3(""); binf.setStationName5(""); binf.setStationId(""); Page p=new Page(); p.setPageCurr(1); p.setPageSize(10); binf.setPage(p); dimpl.serchByCondition(binf); } } gx_tieta/src/com/fgkj/dao/impl/StationtrafficImpl.java
New file @@ -0,0 +1,167 @@ package com.fgkj.dao.impl; import java.sql.ResultSet; import java.sql.SQLException; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import java.util.List; import com.fgkj.actions.ActionUtil; import com.fgkj.dao.BaseDAO; import com.fgkj.dao.CallBack; import com.fgkj.dao.DAOHelper; import com.fgkj.db.DBUtil; import com.fgkj.dto.Stationtraffic; import com.sun.org.apache.bcel.internal.generic.IINC; public class StationtrafficImpl implements BaseDAO,CallBack{ public List getResults(ResultSet rs) { // TODO Auto-generated method stub return null; } public boolean add(Object obj) { // TODO Auto-generated method stub return false; } public boolean update(Object obj) { // TODO Auto-generated method stub return false; } public boolean del(Object obj) { // TODO Auto-generated method stub return false; } public List searchAll() { // TODO Auto-generated method stub return null; } //统计基站流量 public List serchByCondition(Object obj) { final Stationtraffic straffic=(Stationtraffic) obj; String sql=" select distinct tb_stationtraffic.num,dev_id,record_time,dayflow,nowflow" + " ,tb_battinf.StationId,tb_battinf.stationName,tb_battinf.stationName1,tb_battinf.stationName2,tb_battinf.stationName3,tb_battinf.stationName5 " + " from web_site.tb_stationtraffic,db_battinf.tb_battinf " + " where web_site.tb_stationtraffic.dev_id=db_battinf.tb_battinf.fBSDeviceId " + " and record_time>? and record_time<? " + " and dev_id=? " ; //用户管理 String userSql=" and db_battinf.tb_battinf.StationId in(" + " select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id and db_user.tb_user_battgroup_baojigroup_usr.uId=? "+ " ) "; sql+=userSql; String orderSql=" order by dev_id,record_time asc "; sql+=orderSql; List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{straffic.getRecord_time(),straffic.getRecord_time1(),straffic.getDev_id(),Integer.parseInt(straffic.getNote())}, new CallBack() { public List getResults(ResultSet rs) { List list=new ArrayList(); // 时间段 String perid_Time = ""; Calendar now = Calendar.getInstance(); int nowflow=0; try { while(rs.next()){ int nowflows=rs.getInt("nowflow"); // 年份，季度，月份 Date dev_recordtime = rs.getTimestamp("record_time"); // 获取具体年份，月份和该月的总天数 /*int year = dev_recordtime.getYear() + 1900; int month = dev_recordtime.getMonth() + 1;*/ now.setTime(dev_recordtime); int year = now.get(Calendar.YEAR); int month = now.get(Calendar.MONTH) + 1; // 0-based! int day = now.get(Calendar.DAY_OF_MONTH); //System.out.println(dev_recordtime+" "+day); String perid_Times=""; if(straffic.getNum()==1){//月统计 perid_Times = ActionUtil.getFirstDayOfMonth(year, month - 1); perid_Times += "~"; perid_Times += ActionUtil.getLastDayOfMonth(year, month - 1); }else if (straffic.getNum()==3) {// 按年份 perid_Times = ActionUtil.getFirstDayOfMonth(year, 0); perid_Times += "~"; perid_Times += ActionUtil.getLastDayOfMonth(year, 11); }else if(straffic.getNum()==2){ //日统计 perid_Times = ActionUtil.getDayTime(year, month-1, day, 1); perid_Times += "~"; perid_Times += ActionUtil.getDayTime(year, month-1, day, 4); } //System.out.println(perid_Times+" "+perid_Time+" "+nowflows); if(perid_Times.equals(perid_Time)){ nowflow+=nowflows; }else{ if(perid_Time.equals("")){ perid_Time=perid_Times; nowflow+=nowflows; continue; } Stationtraffic st=new Stationtraffic(); st.setDev_id(rs.getInt("dev_id")); st.setNowflow(nowflow); st.setStationName(rs.getString("stationName")); st.setStationName1(rs.getString("stationName1")); st.setStationName2(rs.getString("stationName2")); st.setStationName3(rs.getString("stationName3")); st.setStationName5(rs.getString("stationName5")); st.setNote(perid_Time); list.add(st); nowflow=0; nowflow+=nowflows; perid_Time=perid_Times; } if(rs.isLast()){ Stationtraffic st=new Stationtraffic(); st.setDev_id(rs.getInt("dev_id")); st.setNowflow(nowflow); st.setStationName(rs.getString("stationName")); st.setStationName1(rs.getString("stationName1")); st.setStationName2(rs.getString("stationName2")); st.setStationName3(rs.getString("stationName3")); st.setStationName5(rs.getString("stationName5")); st.setNote(perid_Time); list.add(st); } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } }); return list; } public List serchByInfo(Object obj) { // TODO Auto-generated method stub return null; } public static void main(String[] args) throws ParseException { StationtrafficImpl simpl=new StationtrafficImpl(); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Date date1 = sdf.parse("2000-01-01 00:00:00"); Date date2 = sdf.parse("2020-01-01 00:00:00"); Stationtraffic st=new Stationtraffic(); st.setNum(3); st.setDev_id(910000001); st.setNote("1002"); st.setRecord_time(ActionUtil.getSimpDate(date1)); st.setRecord_time1(ActionUtil.getSimpDate(date2)); List<Stationtraffic> list=simpl.serchByCondition(st); for (Stationtraffic s : list) { System.out.println(s); } } } gx_tieta/src/com/fgkj/dto/Battinf_ex.java
New file @@ -0,0 +1,444 @@ package com.fgkj.dto; import java.io.Serializable; import java.util.Date; public class Battinf_ex implements Serializable{ private int num; public String stationId; //机房id public int FBSDeviceId; //设备id public String stationName; //机房名称 public String stationCode; //站址编码 * public String stationRegion; //所属区域 * public String keyWords; //关键字 * public String affiliation; //所属组织 * public String dataSources; //数据来源 * public String stationType; //站址类型 * public double longitude; //经度 * public double latitude; //纬度 * public String stationAddr; //所在地址 * public String stationLevel; //站址等级 * public String maintenanceState; //维护状态 * public String blockedState; //封锁状态 * public String maintenanceCompany; //维护单位 * public String businessScenario; //业务场景 * public String CoverScenario; //覆盖场景 * public String siteTerrain; //站址地形 * public String propertyRights; //产权性质 * public String propertyUnit; //产权单位 * public String isShare; //是否共享 * public String useUnit; //使用单位 * public String siteCode; //物理站址编码 * public String historySiteCode; //历史物理站址编码 * public String siteInternalNumber; //站址内部编号 * public String sitePinyinReferred; //站址拼音简称 * public String siteChineseReferred; //中文简称 * public String siteMergeRecord; //站址合并记录 * public String isOpenBusiness; //是否开通业务 * public String schoolPersonnel; //录入人员 * public String entryTime; //录入时间 * public String modifyPeople; //修改人 * public String modifyTime; //修改时间 * public String note; //备注 * public String siteReceivesMark; //站址接收标记 * public String siteValidity; //是否有效 * public String siteNameCMCC; //移动站址名称 * public String siteNameCUCC; //联通站址名称 * public String siteNameCTC; //电信站址名称 * public String producer; //生产厂商 * /*public String battBrand; //电池品牌 * public String battModel; //电池型号 public String battCapStd; //标称容量 public int battCount; //电池组数 public int isElectLose; //是否备电不足 public int isUpError; //是否脱机上报异常 public int isNotElect; //是否疑似无备电 */ public double lastTimeLong; //续航测算时长 public String lastTimeType; //续航测算类别 public Date lastTimeDate; //续航发生时间 /*public String februaryOutTimeLong; //二月退服时长 public String marchOutTimeLong; //三月退服时长 public String aprilOutTimeLong; //四月退服时长 public String mayOutTimeLong; //五月退服时长 public String februaryOutTimeCount; //二月退服次数 public String marchOutTimeCount; //三月退服次数 public String aprilOutTimeCount; //四月退服次数 public String mayOutTimeCount; //五月退服次数 */ public String shareInfo; //共享情况 public int electPowerCMCC; //移动是否购买发电服务 public int electPowerCUCC; //联通是否购买发电服务 public int electPowerCTC; //电信是否购买发电服务 public int isCanElectPower; //是否具备发电服务 public double upperStationRoute; //上站路程 public String upperStationDifficult; //上站难易程度 public String clienteleErrorService; //客户问题库未完成蓄电池维修 /*public String verifyStationExist; //分公司核实站址是否实际存在 public String verifyIsDisCharge; //分公司 核实2018年是否已进行过电池整治 public String devletOrAdd; //删除或增加 public String islastTime; //是否在电池组续航能力内 */ public int getNum() { return num; } public void setNum(int num) { this.num = num; } public String getStationId() { return stationId; } public void setStationId(String stationId) { this.stationId = stationId; } public int getFBSDeviceId() { return FBSDeviceId; } public void setFBSDeviceId(int fBSDeviceId) { FBSDeviceId = fBSDeviceId; } public String getStationName() { return stationName; } public void setStationName(String stationName) { this.stationName = stationName; } public String getStationCode() { return stationCode; } public void setStationCode(String stationCode) { this.stationCode = stationCode; } public String getStationRegion() { return stationRegion; } public void setStationRegion(String stationRegion) { this.stationRegion = stationRegion; } public String getKeyWords() { return keyWords; } public void setKeyWords(String keyWords) { this.keyWords = keyWords; } public String getAffiliation() { return affiliation; } public void setAffiliation(String affiliation) { this.affiliation = affiliation; } public String getDataSources() { return dataSources; } public void setDataSources(String dataSources) { this.dataSources = dataSources; } public String getStationType() { return stationType; } public void setStationType(String stationType) { this.stationType = stationType; } public double getLongitude() { return longitude; } public void setLongitude(double longitude) { this.longitude = longitude; } public double getLatitude() { return latitude; } public void setLatitude(double latitude) { this.latitude = latitude; } public String getStationAddr() { return stationAddr; } public void setStationAddr(String stationAddr) { this.stationAddr = stationAddr; } public String getStationLevel() { return stationLevel; } public void setStationLevel(String stationLevel) { this.stationLevel = stationLevel; } public String getMaintenanceState() { return maintenanceState; } public void setMaintenanceState(String maintenanceState) { this.maintenanceState = maintenanceState; } public String getBlockedState() { return blockedState; } public void setBlockedState(String blockedState) { this.blockedState = blockedState; } public String getMaintenanceCompany() { return maintenanceCompany; } public void setMaintenanceCompany(String maintenanceCompany) { this.maintenanceCompany = maintenanceCompany; } public String getBusinessScenario() { return businessScenario; } public void setBusinessScenario(String businessScenario) { this.businessScenario = businessScenario; } public String getCoverScenario() { return CoverScenario; } public void setCoverScenario(String coverScenario) { CoverScenario = coverScenario; } public String getSiteTerrain() { return siteTerrain; } public void setSiteTerrain(String siteTerrain) { this.siteTerrain = siteTerrain; } public String getPropertyRights() { return propertyRights; } public void setPropertyRights(String propertyRights) { this.propertyRights = propertyRights; } public String getPropertyUnit() { return propertyUnit; } public void setPropertyUnit(String propertyUnit) { this.propertyUnit = propertyUnit; } public String getIsShare() { return isShare; } public void setIsShare(String isShare) { this.isShare = isShare; } public String getUseUnit() { return useUnit; } public void setUseUnit(String useUnit) { this.useUnit = useUnit; } public String getSiteCode() { return siteCode; } public void setSiteCode(String siteCode) { this.siteCode = siteCode; } public String getHistorySiteCode() { return historySiteCode; } public void setHistorySiteCode(String historySiteCode) { this.historySiteCode = historySiteCode; } public String getSiteInternalNumber() { return siteInternalNumber; } public void setSiteInternalNumber(String siteInternalNumber) { this.siteInternalNumber = siteInternalNumber; } public String getSitePinyinReferred() { return sitePinyinReferred; } public void setSitePinyinReferred(String sitePinyinReferred) { this.sitePinyinReferred = sitePinyinReferred; } public String getSiteChineseReferred() { return siteChineseReferred; } public void setSiteChineseReferred(String siteChineseReferred) { this.siteChineseReferred = siteChineseReferred; } public String getSiteMergeRecord() { return siteMergeRecord; } public void setSiteMergeRecord(String siteMergeRecord) { this.siteMergeRecord = siteMergeRecord; } public String getIsOpenBusiness() { return isOpenBusiness; } public void setIsOpenBusiness(String isOpenBusiness) { this.isOpenBusiness = isOpenBusiness; } public String getSchoolPersonnel() { return schoolPersonnel; } public void setSchoolPersonnel(String schoolPersonnel) { this.schoolPersonnel = schoolPersonnel; } public String getEntryTime() { return entryTime; } public void setEntryTime(String entryTime) { this.entryTime = entryTime; } public String getModifyPeople() { return modifyPeople; } public void setModifyPeople(String modifyPeople) { this.modifyPeople = modifyPeople; } public String getModifyTime() { return modifyTime; } public void setModifyTime(String modifyTime) { this.modifyTime = modifyTime; } public String getNote() { return note; } public void setNote(String note) { this.note = note; } public String getSiteReceivesMark() { return siteReceivesMark; } public void setSiteReceivesMark(String siteReceivesMark) { this.siteReceivesMark = siteReceivesMark; } public String getSiteValidity() { return siteValidity; } public void setSiteValidity(String siteValidity) { this.siteValidity = siteValidity; } public String getSiteNameCMCC() { return siteNameCMCC; } public void setSiteNameCMCC(String siteNameCMCC) { this.siteNameCMCC = siteNameCMCC; } public String getSiteNameCUCC() { return siteNameCUCC; } public void setSiteNameCUCC(String siteNameCUCC) { this.siteNameCUCC = siteNameCUCC; } public String getSiteNameCTC() { return siteNameCTC; } public void setSiteNameCTC(String siteNameCTC) { this.siteNameCTC = siteNameCTC; } public String getProducer() { return producer; } public void setProducer(String producer) { this.producer = producer; } public double getLastTimeLong() { return lastTimeLong; } public void setLastTimeLong(double lastTimeLong) { this.lastTimeLong = lastTimeLong; } public String getLastTimeType() { return lastTimeType; } public void setLastTimeType(String lastTimeType) { this.lastTimeType = lastTimeType; } public Date getLastTimeDate() { return lastTimeDate; } public void setLastTimeDate(Date lastTimeDate) { this.lastTimeDate = lastTimeDate; } public String getShareInfo() { return shareInfo; } public void setShareInfo(String shareInfo) { this.shareInfo = shareInfo; } public int getElectPowerCMCC() { return electPowerCMCC; } public void setElectPowerCMCC(int electPowerCMCC) { this.electPowerCMCC = electPowerCMCC; } public int getElectPowerCUCC() { return electPowerCUCC; } public void setElectPowerCUCC(int electPowerCUCC) { this.electPowerCUCC = electPowerCUCC; } public int getElectPowerCTC() { return electPowerCTC; } public void setElectPowerCTC(int electPowerCTC) { this.electPowerCTC = electPowerCTC; } public int getIsCanElectPower() { return isCanElectPower; } public void setIsCanElectPower(int isCanElectPower) { this.isCanElectPower = isCanElectPower; } public double getUpperStationRoute() { return upperStationRoute; } public void setUpperStationRoute(double upperStationRoute) { this.upperStationRoute = upperStationRoute; } public String getUpperStationDifficult() { return upperStationDifficult; } public void setUpperStationDifficult(String upperStationDifficult) { this.upperStationDifficult = upperStationDifficult; } public String getClienteleErrorService() { return clienteleErrorService; } public void setClienteleErrorService(String clienteleErrorService) { this.clienteleErrorService = clienteleErrorService; } @Override public String toString() { return "Battinf_ex [num=" + num + ", stationId=" + stationId + ", FBSDeviceId=" + FBSDeviceId + ", stationName=" + stationName + ", stationCode=" + stationCode + ", stationRegion=" + stationRegion + ", keyWords=" + keyWords + ", affiliation=" + affiliation + ", dataSources=" + dataSources + ", stationType=" + stationType + ", longitude=" + longitude + ", latitude=" + latitude + ", stationAddr=" + stationAddr + ", stationLevel=" + stationLevel + ", maintenanceState=" + maintenanceState + ", blockedState=" + blockedState + ", maintenanceCompany=" + maintenanceCompany + ", businessScenario=" + businessScenario + ", CoverScenario=" + CoverScenario + ", siteTerrain=" + siteTerrain + ", propertyRights=" + propertyRights + ", propertyUnit=" + propertyUnit + ", isShare=" + isShare + ", useUnit=" + useUnit + ", siteCode=" + siteCode + ", historySiteCode=" + historySiteCode + ", siteInternalNumber=" + siteInternalNumber + ", sitePinyinReferred=" + sitePinyinReferred + ", siteChineseReferred=" + siteChineseReferred + ", siteMergeRecord=" + siteMergeRecord + ", isOpenBusiness=" + isOpenBusiness + ", schoolPersonnel=" + schoolPersonnel + ", entryTime=" + entryTime + ", modifyPeople=" + modifyPeople + ", modifyTime=" + modifyTime + ", note=" + note + ", siteReceivesMark=" + siteReceivesMark + ", siteValidity=" + siteValidity + ", siteNameCMCC=" + siteNameCMCC + ", siteNameCUCC=" + siteNameCUCC + ", siteNameCTC=" + siteNameCTC + ", producer=" + producer + ", lastTimeLong=" + lastTimeLong + ", lastTimeType=" + lastTimeType + ", lastTimeDate=" + lastTimeDate + ", shareInfo=" + shareInfo + ", electPowerCMCC=" + electPowerCMCC + ", electPowerCUCC=" + electPowerCUCC + ", electPowerCTC=" + electPowerCTC + ", isCanElectPower=" + isCanElectPower + ", upperStationRoute=" + upperStationRoute + ", upperStationDifficult=" + upperStationDifficult + ", clienteleErrorService=" + clienteleErrorService + "]"; } } gx_tieta/src/com/fgkj/dto/Deverror_record.java
New file @@ -0,0 +1,113 @@ package com.fgkj.dto; import java.io.Serializable; import java.util.Date; public class Deverror_record implements Serializable{ private int num; private String stationId; private String stationName; private String stationName1; private String stationName2; private String stationName3; private String stationName5; private Date record_time; private String error_descript;//问题描述 private int uid; private int error_en; //问题是否解决 private String note; private Page page; public int getNum() { return num; } public void setNum(int num) { this.num = num; } public String getStationId() { return stationId; } public void setStationId(String stationId) { this.stationId = stationId; } public String getStationName() { return stationName; } public void setStationName(String stationName) { this.stationName = stationName; } public String getStationName1() { return stationName1; } public void setStationName1(String stationName1) { this.stationName1 = stationName1; } public String getStationName2() { return stationName2; } public void setStationName2(String stationName2) { this.stationName2 = stationName2; } public String getStationName3() { return stationName3; } public void setStationName3(String stationName3) { this.stationName3 = stationName3; } public String getStationName5() { return stationName5; } public void setStationName5(String stationName5) { this.stationName5 = stationName5; } public Date getRecord_time() { return record_time; } public void setRecord_time(Date record_time) { this.record_time = record_time; } public String getError_descript() { return error_descript; } public void setError_descript(String error_descript) { this.error_descript = error_descript; } public int getUid() { return uid; } public void setUid(int uid) { this.uid = uid; } public int getError_en() { return error_en; } public void setError_en(int error_en) { this.error_en = error_en; } public String getNote() { return note; } public void setNote(String note) { this.note = note; } public Page getPage() { return page; } public void setPage(Page page) { this.page = page; } @Override public String toString() { return "Deverror_record [num=" + num + ", stationId=" + stationId + ", stationName=" + stationName + ", stationName1=" + stationName1 + ", stationName2=" + stationName2 + ", stationName3=" + stationName3 + ", stationName5=" + stationName5 + ", record_time=" + record_time + ", error_descript=" + error_descript + ", uid=" + uid + ", error_en=" + error_en + ", note=" + note + ", page=" + page + "]"; } } gx_tieta/src/com/fgkj/dto/Stationtraffic.java
New file @@ -0,0 +1,117 @@ package com.fgkj.dto; import java.io.Serializable; import java.util.Date; public class Stationtraffic implements Serializable{ private int num; private int dev_id; private Date record_time; private Date record_time1; private int dayflow; private int nowflow; private String note; private String stationName; private String stationName1; private String stationName2; private String stationName3; private String stationName5; private Page page; public int getNum() { return num; } public void setNum(int num) { this.num = num; } public int getDev_id() { return dev_id; } public void setDev_id(int dev_id) { this.dev_id = dev_id; } public Date getRecord_time() { return record_time; } public void setRecord_time(Date record_time) { this.record_time = record_time; } public Date getRecord_time1() { return record_time1; } public void setRecord_time1(Date record_time1) { this.record_time1 = record_time1; } public int getDayflow() { return dayflow; } public void setDayflow(int dayflow) { this.dayflow = dayflow; } public int getNowflow() { return nowflow; } public void setNowflow(int nowflow) { this.nowflow = nowflow; } public String getNote() { return note; } public void setNote(String note) { this.note = note; } public String getStationName() { return stationName; } public void setStationName(String stationName) { this.stationName = stationName; } public String getStationName1() { return stationName1; } public void setStationName1(String stationName1) { this.stationName1 = stationName1; } public String getStationName2() { return stationName2; } public void setStationName2(String stationName2) { this.stationName2 = stationName2; } public String getStationName3() { return stationName3; } public void setStationName3(String stationName3) { this.stationName3 = stationName3; } public String getStationName5() { return stationName5; } public void setStationName5(String stationName5) { this.stationName5 = stationName5; } public Page getPage() { return page; } public void setPage(Page page) { this.page = page; } @Override public String toString() { return "Stationtraffic [num=" + num + ", dev_id=" + dev_id + ", record_time=" + record_time + ", record_time1=" + record_time1 + ", dayflow=" + dayflow + ", nowflow=" + nowflow + ", note=" + note + ", stationName=" + stationName + ", stationName1=" + stationName1 + ", stationName2=" + stationName2 + ", stationName3=" + stationName3 + ", stationName5=" + stationName5 + ", page=" + page + "]"; } } gx_tieta/src/com/fgkj/services/Battinf_exService.java
New file @@ -0,0 +1,31 @@ package com.fgkj.services; import java.util.List; import com.fgkj.dao.BaseDAO; import com.fgkj.dao.BaseDAOFactory; import com.fgkj.dto.ServiceModel; public class Battinf_exService { private ServiceModel model; private BaseDAO dao; public Battinf_exService() { super(); model=new ServiceModel(); dao=BaseDAOFactory.getBaseDAO(BaseDAO.BATTINF_EX); } //根据电池组的信息stationid查询 public ServiceModel serchByCondition(Object obj){ List list=dao.serchByCondition(obj); if (list!=null&&list.size()>0) { model.setCode(1); model.setData(list); model.setMsg("查询成功!"); } else { model.setCode(0); model.setMsg("查询失败!"); } return model; } } gx_tieta/src/com/fgkj/services/Deverror_recordService.java
New file @@ -0,0 +1,46 @@ package com.fgkj.services; import java.util.List; import com.fgkj.dao.BaseDAO; import com.fgkj.dao.BaseDAOFactory; import com.fgkj.dto.ServiceModel; public class Deverror_recordService { private ServiceModel model; private BaseDAO dao; public Deverror_recordService() { super(); model=new ServiceModel(); dao=BaseDAOFactory.getBaseDAO(BaseDAO.DEVERROR_RECORD); } //用户手动添加问题 public ServiceModel add(Object obj){ boolean bl=dao.add(obj); if (bl) { model.setCode(1); model.setMsg("添加成功!"); } else { model.setCode(0); model.setMsg("添加失败!"); } return model; } //根据stationid查询设备的问题记录 public ServiceModel serchByCondition(Object obj){ List list=dao.serchByCondition(obj); if (list!=null&&list.size()>0) { model.setCode(1); model.setData(list); model.setMsg("查询成功!"); } else { model.setCode(0); model.setMsg("查询失败!"); } return model; } } gx_tieta/src/com/fgkj/services/StationtrafficService.java
New file @@ -0,0 +1,32 @@ package com.fgkj.services; import java.util.List; import com.fgkj.dao.BaseDAO; import com.fgkj.dao.BaseDAOFactory; import com.fgkj.dto.ServiceModel; public class StationtrafficService { private BaseDAO dao; private ServiceModel model; public StationtrafficService() { super(); dao=BaseDAOFactory.getBaseDAO(BaseDAO.STATIONTRAFFIC); model=new ServiceModel(); } //统计基站流量 public ServiceModel serchByCondition(Object obj) { List list=dao.serchByCondition(obj); if(list!=null&&list.size()>0){ model.setCode(1); model.setData(list); model.setMsg("查询成功!"); }else{ model.setCode(0); model.setMsg("查询失败!"); } return model; } }
