yantian yue
2023-10-18 465d5c4666546e7e54f0e3c34c7bcce5830aaa6a
OPCUA增加查询条件
已修改3个文件
23 ■■■■■ 文件已修改
guns-vip-main/src/main/java/cn/stylefeng/guns/opcua/mapper/mapping/OpcuaConfMapper.xml 12 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
guns-vip-main/src/main/webapp/assets/modular/bs/opcuaConf/opcuaConf.js 3 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
guns-vip-main/src/main/webapp/pages/modular/bs/opcuaConf/opcuaConf.html 8 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
guns-vip-main/src/main/java/cn/stylefeng/guns/opcua/mapper/mapping/OpcuaConfMapper.xml
@@ -26,24 +26,36 @@
        select
        <include refid="Base_Column_List"/>
        from sys_opcua_conf where 1 = 1
        <if test="paramCondition.node != null and paramCondition.node != ''">
            and node like CONCAT('%',#{paramCondition.node},'%')
        </if>
    </select>
    <select id="customMapList" resultType="map" parameterType="cn.stylefeng.guns.opcua.model.params.OpcuaConfParam">
        select
        <include refid="Base_Column_List"/>
        from sys_opcua_conf where 1 = 1
        <if test="paramCondition.node != null and paramCondition.node != ''">
            and node like CONCAT('%',#{paramCondition.node},'%')
        </if>
    </select>
    <select id="customPageList" resultType="cn.stylefeng.guns.opcua.model.result.OpcuaConfResult" parameterType="cn.stylefeng.guns.opcua.model.params.OpcuaConfParam">
        select
        <include refid="Base_Column_List"/>
        from sys_opcua_conf where 1 = 1
        <if test="paramCondition.node != null and paramCondition.node != ''">
            and node like CONCAT('%',#{paramCondition.node},'%')
        </if>
    </select>
    <select id="customPageMapList" resultType="map" parameterType="cn.stylefeng.guns.opcua.model.params.OpcuaConfParam">
        select
        <include refid="Base_Column_List"/>
        from sys_opcua_conf where 1 = 1
        <if test="paramCondition.node != null and paramCondition.node != ''">
            and node like CONCAT('%',#{paramCondition.node},'%')
        </if>
    </select>
</mapper>
guns-vip-main/src/main/webapp/assets/modular/bs/opcuaConf/opcuaConf.js
@@ -6,7 +6,7 @@
    var func = layui.func;
    /**
     * 管理
     * OPCUA配置管理
     */
    var OpcuaConf = {
        tableId: "opcuaConfTable"
@@ -38,6 +38,7 @@
    OpcuaConf.search = function () {
        var queryData = {};
        queryData['node'] = $('#node').val();
        table.reload(OpcuaConf.tableId, {
            where: queryData, page: {curr: 1}
guns-vip-main/src/main/webapp/pages/modular/bs/opcuaConf/opcuaConf.html
@@ -1,7 +1,7 @@
@layout("/common/_container.html",{js:["/assets/modular/bs/opcuaConf/opcuaConf.js"]}){
<div class="layui-body-header">
    <span class="layui-body-header-title">管理</span>
    <span class="layui-body-header-title">OPCUA配置</span>
</div>
<div class="layui-fluid">
@@ -12,6 +12,12 @@
                    <div class="layui-form toolbar">
                        <div class="layui-form-item">
                            <div class="layui-inline">
                                节点:
                            </div>
                            <div class="layui-inline">
                                <input id="node" class="layui-input" type="text" placeholder="节点"/>
                            </div>
                            <div class="layui-inline">
                                <button id="btnSearch" class="layui-btn icon-btn"><i class="layui-icon">&#xe615;</i>搜索</button>
                                <button id="btnAdd" class="layui-btn icon-btn"><i class="layui-icon">&#xe654;</i>添加</button>
                                <button id="btnExp" class="layui-btn icon-btn"><i class="layui-icon">&#xe67d;</i>导出</button>