三维实景增加选择状态

‘liusuyi’

2024-03-02 ef412709a533e49235ff2f4775d5385f9646f5e1

三维实景增加选择状态

 ard-work/src/main/java/com/ruoyi/management3d/tiles3d/controller/ArdTiles3dController.java

@@ -69,6 +69,7 @@
     */
    @PreAuthorize("@ss.hasPermi('management3d:tiles3d:query')")
    @GetMapping(value = "/{tilesId}")
    @ApiOperation("获取三维实景详细信息")
    public AjaxResult getInfo(@PathVariable("tilesId") String tilesId) {
        return success(ardTiles3dService.selectArdTiles3dByTilesId(tilesId));
    }
@@ -76,6 +77,7 @@
    /**
     * 新增三维实景
     */
    @ApiOperation("新增三维实景")
    @PreAuthorize("@ss.hasPermi('management3d:tiles3d:add')")
    @Log(title = "三维实景", businessType = BusinessType.INSERT)
    @PostMapping
@@ -86,6 +88,7 @@
    /**
     * 修改三维实景
     */
    @ApiOperation("修改三维实景")
    @PreAuthorize("@ss.hasPermi('management3d:tiles3d:edit')")
    @Log(title = "三维实景", businessType = BusinessType.UPDATE)
    @PutMapping
@@ -96,6 +99,7 @@
    /**
     * 删除三维实景
     */
    @ApiOperation("删除三维实景")
    @PreAuthorize("@ss.hasPermi('management3d:tiles3d:remove')")
    @Log(title = "三维实景", businessType = BusinessType.DELETE)
    @DeleteMapping("/{tilesIds}")

 ard-work/src/main/java/com/ruoyi/management3d/tiles3d/domain/ArdTiles3d.java

@@ -79,6 +79,17 @@
    @Excel(name = "用户id")
    private String userId;

    /** 选中状态 */
    private boolean selected;

    public boolean isSelected() {
        return selected;
    }

    public void setSelected(boolean selected) {
        this.selected = selected;
    }

    public void setTilesId(String tilesId) 
    {
        this.tilesId = tilesId;

 ard-work/src/main/resources/mapper/management3d/ArdTiles3dMapper.xml

@@ -25,6 +25,7 @@
        <result property="createTime" column="create_time"/>
        <result property="updateBy" column="update_by"/>
        <result property="updateTime" column="update_time"/>
        <result property="selected" column="selected"/>
    </resultMap>

    <sql id="selectArdTiles3dVo">
@@ -47,7 +48,8 @@
               c.create_by,
               c.create_time,
               c.update_by,
               c.update_time
               c.update_time,
               c.selected
        from ard_tiles3d c
        left join sys_dept d on d.dept_id = c.dept_id
        left join sys_user u on u.user_id = c.user_id
@@ -56,6 +58,7 @@
    <select id="selectArdTiles3dList" parameterType="ArdTiles3d" resultMap="ArdTiles3dResult">
        <include refid="selectArdTiles3dVo"/>
        <where>
            <if test="selected != null  and selected != ''">and c.selected = #{selected}</if>
            <if test="tilesId != null  and tilesId != ''">and c.tiles_id = #{tilesId}</if>
            <if test="tilesName != null  and tilesName != ''">and c.tiles_name like '%'||#{tilesName}||'%'</if>
            <if test="tilesUrl != null  and tilesUrl != ''">and c.tiles_url = #{tilesUrl}</if>
@@ -111,6 +114,7 @@
            <if test="createTime != null">create_time,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="selected != null">selected,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="tilesId != null">#{tilesId},</if>
@@ -133,6 +137,7 @@
            <if test="createTime != null">#{createTime},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="selected != null">#{selected},</if>
        </trim>
    </insert>

@@ -162,6 +167,7 @@
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="selected != null">selected = #{selected},</if>
        </trim>
        where tiles_id = #{tilesId}
    </update>