diff --git a/src/main/java/com/casic/accessControl/marker/manager/MarkerManager.java b/src/main/java/com/casic/accessControl/marker/manager/MarkerManager.java index c9c15de..d75e83d 100644 --- a/src/main/java/com/casic/accessControl/marker/manager/MarkerManager.java +++ b/src/main/java/com/casic/accessControl/marker/manager/MarkerManager.java @@ -58,8 +58,8 @@ private Logger logger = LoggerFactory.getLogger(this.getClass()); public DataTable pageQueryMarker(String params, String markerDto,Long companyId) { - List features = null; - List lines = null; +// List features = null; +// List lines = null; DataTable result = new DataTable(); DataTableParameter parameter = DataTableUtils.getDataTableParameterByJsonParam(params); int start = parameter.getiDisplayStart(); @@ -70,13 +70,18 @@ if (null != markerDto) { MarkerDto markerDto1 = new Gson().fromJson(markerDto, MarkerDto.class); - + if (markerDto1.getRecordType()!=null) { + criteria1.add(Restrictions.eq("recordType", markerDto1.getRecordType())); + } if (StringUtils.isNotBlank(markerDto1.getMemo())) { criteria1.add(Restrictions.like("memo", markerDto1.getMemo(), MatchMode.ANYWHERE)); } if (StringUtils.isNotBlank(markerDto1.getRoad())) { criteria1.add(Restrictions.like("road", markerDto1.getRoad(), MatchMode.ANYWHERE)); } + if (StringUtils.isNotBlank(markerDto1.getOwnerComp())) { + criteria1.add(Restrictions.like("ownerComp", markerDto1.getOwnerComp(), MatchMode.ANYWHERE)); + } if (StringUtils.isNotBlank(markerDto1.getCreator())) { criteria1.add(Restrictions.like("creator", markerDto1.getCreator(), MatchMode.ANYWHERE)); } diff --git a/src/main/java/com/casic/accessControl/marker/manager/MarkerManager.java b/src/main/java/com/casic/accessControl/marker/manager/MarkerManager.java index c9c15de..d75e83d 100644 --- a/src/main/java/com/casic/accessControl/marker/manager/MarkerManager.java +++ b/src/main/java/com/casic/accessControl/marker/manager/MarkerManager.java @@ -58,8 +58,8 @@ private Logger logger = LoggerFactory.getLogger(this.getClass()); public DataTable pageQueryMarker(String params, String markerDto,Long companyId) { - List features = null; - List lines = null; +// List features = null; +// List lines = null; DataTable result = new DataTable(); DataTableParameter parameter = DataTableUtils.getDataTableParameterByJsonParam(params); int start = parameter.getiDisplayStart(); @@ -70,13 +70,18 @@ if (null != markerDto) { MarkerDto markerDto1 = new Gson().fromJson(markerDto, MarkerDto.class); - + if (markerDto1.getRecordType()!=null) { + criteria1.add(Restrictions.eq("recordType", markerDto1.getRecordType())); + } if (StringUtils.isNotBlank(markerDto1.getMemo())) { criteria1.add(Restrictions.like("memo", markerDto1.getMemo(), MatchMode.ANYWHERE)); } if (StringUtils.isNotBlank(markerDto1.getRoad())) { criteria1.add(Restrictions.like("road", markerDto1.getRoad(), MatchMode.ANYWHERE)); } + if (StringUtils.isNotBlank(markerDto1.getOwnerComp())) { + criteria1.add(Restrictions.like("ownerComp", markerDto1.getOwnerComp(), MatchMode.ANYWHERE)); + } if (StringUtils.isNotBlank(markerDto1.getCreator())) { criteria1.add(Restrictions.like("creator", markerDto1.getCreator(), MatchMode.ANYWHERE)); } diff --git a/src/main/webapp/content/marker/marker-info-list.jsp b/src/main/webapp/content/marker/marker-info-list.jsp index ffe4c93..69a4d42 100644 --- a/src/main/webapp/content/marker/marker-info-list.jsp +++ b/src/main/webapp/content/marker/marker-info-list.jsp @@ -1 +1 @@ -<%@page contentType="text/html;charset=UTF-8" %> <%@include file="/taglibs.jsp" %> <%pageContext.setAttribute("currentMenu", "markerManagerMenu");%> 地下管线电子标识系统 <%----%> <%@include file="/common/layout/header.jsp" %>
<%@include file="/common/layout/menu_new.jsp" %>
<%--<%@include file="/common/layout/second-menu-auth.jsp" %>--%>
标识器管理
id 标识器编号 标识器名称 区域 线路 类型 埋深 里程1 里程2 安装时间 安装人员 备注 编辑 删除
<%@include file="/common/layout/footer.jsp" %> <%----%> <%----%> \ No newline at end of file +<%@page contentType="text/html;charset=UTF-8" %> <%@include file="/taglibs.jsp" %> <%pageContext.setAttribute("currentMenu", "markerManagerMenu");%> 地下管线电子标识系统 <%----%> <%@include file="/common/layout/header.jsp" %>
<%@include file="/common/layout/menu_new.jsp" %>
<%--<%@include file="/common/layout/second-menu-auth.jsp" %>--%>
标识器管理
<%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%>
id标识器编号标识器名称区域线路类型埋深里程1里程2安装时间安装人员备注编辑删除
<%@include file="/common/layout/footer.jsp" %> <%----%> <%----%> \ No newline at end of file diff --git a/src/main/java/com/casic/accessControl/marker/manager/MarkerManager.java b/src/main/java/com/casic/accessControl/marker/manager/MarkerManager.java index c9c15de..d75e83d 100644 --- a/src/main/java/com/casic/accessControl/marker/manager/MarkerManager.java +++ b/src/main/java/com/casic/accessControl/marker/manager/MarkerManager.java @@ -58,8 +58,8 @@ private Logger logger = LoggerFactory.getLogger(this.getClass()); public DataTable pageQueryMarker(String params, String markerDto,Long companyId) { - List features = null; - List lines = null; +// List features = null; +// List lines = null; DataTable result = new DataTable(); DataTableParameter parameter = DataTableUtils.getDataTableParameterByJsonParam(params); int start = parameter.getiDisplayStart(); @@ -70,13 +70,18 @@ if (null != markerDto) { MarkerDto markerDto1 = new Gson().fromJson(markerDto, MarkerDto.class); - + if (markerDto1.getRecordType()!=null) { + criteria1.add(Restrictions.eq("recordType", markerDto1.getRecordType())); + } if (StringUtils.isNotBlank(markerDto1.getMemo())) { criteria1.add(Restrictions.like("memo", markerDto1.getMemo(), MatchMode.ANYWHERE)); } if (StringUtils.isNotBlank(markerDto1.getRoad())) { criteria1.add(Restrictions.like("road", markerDto1.getRoad(), MatchMode.ANYWHERE)); } + if (StringUtils.isNotBlank(markerDto1.getOwnerComp())) { + criteria1.add(Restrictions.like("ownerComp", markerDto1.getOwnerComp(), MatchMode.ANYWHERE)); + } if (StringUtils.isNotBlank(markerDto1.getCreator())) { criteria1.add(Restrictions.like("creator", markerDto1.getCreator(), MatchMode.ANYWHERE)); } diff --git a/src/main/webapp/content/marker/marker-info-list.jsp b/src/main/webapp/content/marker/marker-info-list.jsp index ffe4c93..69a4d42 100644 --- a/src/main/webapp/content/marker/marker-info-list.jsp +++ b/src/main/webapp/content/marker/marker-info-list.jsp @@ -1 +1 @@ -<%@page contentType="text/html;charset=UTF-8" %> <%@include file="/taglibs.jsp" %> <%pageContext.setAttribute("currentMenu", "markerManagerMenu");%> 地下管线电子标识系统 <%----%> <%@include file="/common/layout/header.jsp" %>
<%@include file="/common/layout/menu_new.jsp" %>
<%--<%@include file="/common/layout/second-menu-auth.jsp" %>--%>
标识器管理
id 标识器编号 标识器名称 区域 线路 类型 埋深 里程1 里程2 安装时间 安装人员 备注 编辑 删除
<%@include file="/common/layout/footer.jsp" %> <%----%> <%----%> \ No newline at end of file +<%@page contentType="text/html;charset=UTF-8" %> <%@include file="/taglibs.jsp" %> <%pageContext.setAttribute("currentMenu", "markerManagerMenu");%> 地下管线电子标识系统 <%----%> <%@include file="/common/layout/header.jsp" %>
<%@include file="/common/layout/menu_new.jsp" %>
<%--<%@include file="/common/layout/second-menu-auth.jsp" %>--%>
标识器管理
<%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%> <%----%>
id标识器编号标识器名称区域线路类型埋深里程1里程2安装时间安装人员备注编辑删除
<%@include file="/common/layout/footer.jsp" %> <%----%> <%----%> \ No newline at end of file diff --git a/src/main/webapp/s/app/marker/marker-info-list.js b/src/main/webapp/s/app/marker/marker-info-list.js index 3763f9e..837cce9 100644 --- a/src/main/webapp/s/app/marker/marker-info-list.js +++ b/src/main/webapp/s/app/marker/marker-info-list.js @@ -1,19 +1,440 @@ var MarkerInfoList = function () { var oTable; - var Marker ={}; + var Marker = {}; + var typeValue = 1; + var aoColums; + var aoColumnDefs; var handleDatePickers = function () { if (jQuery().datepicker) { $('.date-picker').datepicker({ - rtl : App.isRTL() + rtl: App.isRTL() }); } } return { + // 初始化表头以及列表中需要展示的列和列宽设置 + tableTitle: function (type) { + if (type == 1) { + aoColums = [ + { + "mDataProp": "id" + }, + { + "mDataProp": "markerObjectType" + }, + { + "mDataProp": "pipeDiameter" + + }, + { + "mDataProp": "pipeMaterial" + + }, + { + "mDataProp": "layStyle" + + }, + { + "mDataProp": "depth" + + }, + { + "mDataProp": "road" + + }, + { + "mDataProp": "constructTime" + + }, + { + "mDataProp": "ownerComp" + + }, + { + "mDataProp": "markerType" + + }, + { + "mDataProp": "markerDepth" + + }, + { + "mDataProp": "creator" + + }, + { + "mDataProp": "createTime" + + }, + { + "mDataProp": "memo" + + }, + { + "mDataProp": "btnEdit", + "sWidth": '55px' + }, + { + "mDataProp": "btnDelete", + "sWidth": '55px' + } + ]; + aoColumnDefs = [ + { + 'bSortable': false, + 'bVisible': false, + 'aTargets': [0] + }, + { + 'bSortable': false, + 'aTargets': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13,14,15] + } + ]; + return " " + + "id" + + " 管线种类" + + " 管线直径" + + " 管线材质" + + " 埋设方式" + + " 管线埋深" + + " 所属道路" + + " 建设年代" + + " 所属单位" + + " 标识器类型" + + " 标识器埋深" + + " 安装人员" + + " 最后修改时间" + + " 备注" + + " 编辑" + + " 删除" + + "" + + " "; + } else if (type == 2) { + aoColums = [ + { + "mDataProp": "id" + }, + { + "mDataProp": "markerObjectType" + }, + { + "mDataProp": "depth" + + }, + { + "mDataProp": "road" + + }, + { + "mDataProp": "constructTime" + + }, + { + "mDataProp": "ownerComp" + + }, + { + "mDataProp": "markerType" + + }, + { + "mDataProp": "markerDepth" + + }, + { + "mDataProp": "creator" + + }, + { + "mDataProp": "createTime" + + }, + { + "mDataProp": "memo" + + }, + { + "mDataProp": "btnEdit", + "sWidth": '55px' + }, + { + "mDataProp": "btnDelete", + "sWidth": '55px' + } + ]; + aoColumnDefs = [ + { + 'bSortable': false, + 'bVisible': false, + 'aTargets': [0] + }, + { + 'bSortable': false, + 'aTargets': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11,12] + } + ]; + return " " + + "id" + + " 附属物名称" + + " 井深" + + " 所属道路" + + " 建设年代" + + " 所属单位" + + " 标识器类型" + + " 标识器埋深" + + " 安装人员" + + " 最后修改时间" + + " 备注" + + " 编辑" + + " 删除" + + "" + + " "; + } else if (type == 3) { + aoColums = [ + { + "mDataProp": "id" + }, + { + "mDataProp": "markerObjectType" + }, + { + "mDataProp": "depth" + + }, + { + "mDataProp": "road" + + }, + { + "mDataProp": "constructTime" + + }, + { + "mDataProp": "ownerComp" + + }, + { + "mDataProp": "markerType" + + }, + { + "mDataProp": "markerDepth" + + }, + { + "mDataProp": "creator" + + }, + { + "mDataProp": "createTime" + + }, + { + "mDataProp": "memo" + + }, + { + "mDataProp": "btnEdit", + "sWidth": '55px' + }, + { + "mDataProp": "btnDelete", + "sWidth": '55px' + } + ]; + aoColumnDefs = [ + { + 'bSortable': false, + 'bVisible': false, + 'aTargets': [0] + }, + { + 'bSortable': false, + 'aTargets': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11,12] + } + ]; + return " " + + "id" + + " 管点特征" + + " 特征点埋深" + + " 所属道路" + + " 建设年代" + + " 所属单位" + + " 标识器类型" + + " 标识器埋深" + + " 安装人员" + + " 最后修改时间" + + " 备注" + + " 编辑" + + " 删除" + + "" + + " "; + } else { + aoColums = [ + { + "mDataProp": "id" + }, + { + "mDataProp": "markerObjectType" + }, + { + "mDataProp": "depth" + + }, + { + "mDataProp": "pipeDiameter" + + }, + { + "mDataProp": "pipeMaterial" + + }, + { + "mDataProp": "belowType" + + }, + { + "mDataProp": "belowDepth" + + }, + { + "mDataProp": "belowDiameter" + + }, + { + "mDataProp": "belowMaterial" + + }, + { + "mDataProp": "road" + + }, + { + "mDataProp": "constructTime" + + }, + { + "mDataProp": "ownerComp" + + }, + { + "mDataProp": "markerType" + + }, + { + "mDataProp": "markerDepth" + + }, + { + "mDataProp": "creator" + + }, + { + "mDataProp": "createTime" + + }, + { + "mDataProp": "memo" + + }, + { + "mDataProp": "btnEdit", + "sWidth": '55px' + }, + { + "mDataProp": "btnDelete", + "sWidth": '55px' + } + ]; + aoColumnDefs = [ + { + 'bSortable': false, + 'bVisible': false, + 'aTargets': [0] + }, + { + 'bSortable': false, + 'aTargets': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12,13,14,15,16,17,18] + } + ]; + return " " + + "id" + + " 上层管种类" + + " 上层管埋深" + + " 上层管直径" + + " 上层管材料" + + " 下层管种类" + + " 下层管埋深" + + " 下层管直径" + + " 下层管材料" + + " 所属道路" + + " 建设年代" + + " 所属单位" + + " 标识器类型" + + " 标识器埋深" + + " 安装人员" + + " 最后修改时间" + + " 备注" + + " 编辑" + + " 删除" + + "" + + " "; + } + + }, + + init: function () { + //监听类型下拉列表变化事件, + //$("#markerObjectType").chosen(); + $("#markerObjectType").live("change", function (e) { + typeValue = $("#markerObjectType").val(); + $("#table_marker").children().remove(); + Marker.recordType = typeValue; + var title = MarkerInfoList.tableTitle(typeValue); + oTable = $('#table_marker').dataTable({ + // set the initial value + "iDisplayLength": 5, + "bAutoWidth": false, + "bDestroy": true, + "bLengthChange": false, + "bFilter": false, + "bServerSide": true, + "bPaginate": true, + "sDom": "<'row-fluid'<'span6'l><'span6'f>r>t<'row-fluid'<'span6'i><'span6'p>>", + "sPaginationType": "bootstrap", + "sAjaxSource": $('#context').val() + "/marker/marker-info-list.do", //TODO LIST:修改成对应的后台Controller地址 + "fnServerData": retrieveData, + "oLanguage": { + "sSearch": "标识器型号:", + "sLengthMenu": "每页显示 _MENU_ 条记录", + "sZeroRecords": "抱歉, 没有找到", + "sInfo": "从 _START_ 到 _END_ /共 _TOTAL_ 条数据", + "sInfoFiltered": "", + "sInfoEmpty": "没有数据", + "oPaginate": { + "sPrevious": "上一页", + "sNext": "下一页", + "sLast": "末页", + "sFirst": "首页" + } + }, + "aoColumns": aoColums, + "aoColumnDefs": aoColumnDefs + }); + $("#table_marker thead").children().remove(); + $("#table_marker thead").remove(); + $("#table_marker").append(title); + }); + + Marker.recordType = typeValue; + var title = MarkerInfoList.tableTitle(typeValue); + $("#table_marker").children().remove(); + $("#table_marker").append(title); handleDatePickers(); @@ -37,13 +458,10 @@ } oTable = $('#table_marker').dataTable({ -// "aLengthMenu": [ -// [5, 15, 20, -1], -// [5, 15, 20, "All"] // change per page values here -// ], // set the initial value "iDisplayLength": 5, - "bAutoWidth":false, + "bAutoWidth": false, + "bDestroy": true, "bLengthChange": false, "bFilter": false, "bServerSide": true, @@ -66,71 +484,8 @@ "sFirst": "首页" } }, - "aoColumns": [ - { - "mDataProp": "id" - }, - { - "mDataProp": "markerId" - }, - { - "mDataProp": "markerName" - - }, - { - "mDataProp": "featureName" - - }, - { - "mDataProp": "lineName" - - }, - { - "mDataProp": "markerObjectType" - - }, - { - "mDataProp": "depth" - - }, - { - "mDataProp": "mileage" - - }, - { - "mDataProp": "mileage2" - - }, - { - "mDataProp": "createTime" - - }, - { - "mDataProp": "creator" - - }, - { - "mDataProp": "memo" - - },{ - "mDataProp" : "btnEdit", - "sWidth" : '55px' - }, { - "mDataProp" : "btnDelete", - "sWidth" : '55px' - } - ], - "aoColumnDefs": [ - { - 'bSortable': false, - 'bVisible': false, - 'aTargets': [0] - }, - { - 'bSortable': false, - 'aTargets': [1, 2, 3, 4, 5, 6, 7, 8, 9,10,11,12,13] - } - ] + "aoColumns": aoColums, + "aoColumnDefs": aoColumnDefs }); @@ -213,13 +568,12 @@ }); $('#searchMarker').bind('click', function (e) { - Marker.markerName = $("#markerName").val(); - Marker.featureId = $("#select_area").val()?$("#select_area").val():null; - Marker.lineId = $("#select_line").val()?$("#select_line").val():null; - Marker.mileage = $("#mileStone1").val(); - Marker.mileage2 = $("#mileStone2").val(); - Marker.creator = $("#creator").val(); + Marker = {}; + Marker.recordType=$("#markerObjectType").val(); + Marker.road = $("#road").val(); + Marker.ownerComp = $("#ownerComp").val(); Marker.memo = $("#memo").val(); + Marker.creator = $("#creator").val(); Marker.sDate = $("#txt_begin_day").val(); Marker.eDate = $("#txt_end_day").val(); oTable.fnDraw(true); @@ -228,31 +582,18 @@ }); $('#exp').live('click', function (e) { - Marker.markerName = $("#markerName").val(); - Marker.featureId = $("#select_area").val()?$("#select_area").val():null; - Marker.lineId = $("#select_line").val()?$("#select_line").val():null; - Marker.mileage = $("#mileStone1").val(); - Marker.mileage2 = $("#mileStone2").val(); - Marker.creator = $("#creator").val(); + Marker = {}; + Marker.recordType = $("#markerObjectType").val(); + Marker.road = $("#road").val(); + Marker.ownerComp = $("#ownerComp").val(); Marker.memo = $("#memo").val(); + Marker.creator = $("#creator").val(); Marker.sDate = $("#txt_begin_day").val(); Marker.eDate = $("#txt_end_day").val(); - location.href = $('#context').val() + "/marker/export.do?strMarkerDto="+JSON.stringify(Marker); + location.href = $('#context').val() + "/marker/export.do?strMarkerDto=" + JSON.stringify(Marker); }); - }, - - initForm: function () { - - $('#select_area').select2({ - placeholder: "片区选择", - allowClear: false - }); - $('#select_line').select2({ - placeholder: "线路选择", - allowClear: false - }); } }; }(); \ No newline at end of file