电子围栏修改接口修改为只修改坐标参数

Administrator

2021-04-20 7926987b0f6eea5ee65477226ce1dc63395be2d6

电子围栏修改接口修改为只修改坐标参数

 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/enclosure/controller/EnclosureController.java

@@ -175,4 +175,18 @@
        response.setHeader("Access-Control-Allow-Credentials","true");
        return R.data(enclosureService.selectList());
    }

    /**
     * 电子围栏查询详情
     * @param response
     * @param enclosure 电子围栏信息
     * @return
     */
    @GetMapping("/selectEnclosureDetail")
    public R selectEnclosureDetail(HttpServletResponse response,Enclosure enclosure) {
        response.setHeader("Access-Control-Allow-Origin", "*");
        response.setHeader("Access-Control-Allow-Methods", "POST, GET, OPTIONS, DELETE");
        response.setHeader("Access-Control-Allow-Credentials","true");
        return R.data(enclosureService.selectEnclosureDetail(enclosure));
    }
}

 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/enclosure/mapper/EnclosureMapper.java

@@ -18,6 +18,7 @@

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.springblade.jfpt.enclosure.entity.Enclosure;
import org.springblade.jfpt.enclosure.vo.EnclosureVO;

@@ -42,4 +43,11 @@
    void inserte(String anumber, String aname, String a);
    void updatee(String id, String anumber, String aname, String a);
    List<EnclosureVO> selectList();

    /**
     * 电子围栏查询详情
     * @param enclosure 电子围栏信息
     * @return
     */
    Enclosure selectEnclosureDetail(@Param("enclosure") Enclosure enclosure);
}

 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/enclosure/mapper/EnclosureMapper.xml

@@ -20,11 +20,20 @@
    </insert>

    <update id="updatee">
        update sys_enclosure SET anumber=#{anumber},aname=#{aname},coordinate=ST_GeomFromText(${a}) where anumber=#{anumber}
        update sys_enclosure SET coordinate=ST_GeomFromText(${a}) where anumber=#{anumber}
    </update>

    <select id="selectList" resultMap="enclosureResultMap">
        SELECT id,anumber,aname,ST_ASTEXT (coordinate) AS coordinate FROM sys_enclosure
    </select>

    <!--电子围栏详情 detail-->
    <select id="selectEnclosureDetail" resultType="org.springblade.jfpt.enclosure.entity.Enclosure">
        SELECT id,anumber,aname,ST_ASTEXT (coordinate) AS coordinate FROM sys_enclosure
        where 1=1
        <if test="enclosure.anumber!=null and enclosure.anumber!='' ">
            and anumber = #{enclosure.anumber}
        </if>
    </select>

</mapper>

 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/enclosure/service/IEnclosureService.java

@@ -42,4 +42,11 @@
    void inserte(String anumber, String aname, String a);
    void updatee(String id, String anumber, String aname, String a);
    List<EnclosureVO> selectList();

    /**
     * 电子围栏查询详情
     * @param enclosure 电子围栏信息
     * @return
     */
    Enclosure selectEnclosureDetail(Enclosure enclosure);
}

 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/enclosure/service/impl/EnclosureServiceImpl.java

@@ -55,4 +55,13 @@
        return baseMapper.selectList();
    }

    /**
     * 电子围栏查询详情
     * @param enclosure 电子围栏信息
     * @return
     */
    @Override
    public Enclosure selectEnclosureDetail(Enclosure enclosure) {
        return baseMapper.selectEnclosureDetail(enclosure);
    }
}