1.模型管理增加模型路径字段。
2.tile管理增加默认加载字段。
| | |
| | | @Excel(name = "比例") |
| | | private Long proportion; |
| | | |
| | | /** 模型路径 */ |
| | | @Excel(name = "模型路径") |
| | | private Long modelUrl; |
| | | |
| | | } |
| | |
| | | /** 部门ID */ |
| | | @Excel(name = "部门ID") |
| | | private Long deptId; |
| | | |
| | | /** 默认加载 */ |
| | | @Excel(name = "默认加载") |
| | | private String defaultLoading; |
| | | |
| | | } |
| | |
| | | <result property="latitude" column="latitude" /> |
| | | <result property="height" column="height" /> |
| | | <result property="proportion" column="proportion" /> |
| | | <result property="modelUrl" column="model_url" /> |
| | | </resultMap> |
| | | |
| | | <sql id="selectArdModelManagementVo"> |
| | |
| | | longitude, |
| | | latitude, |
| | | height, |
| | | proportion |
| | | proportion, |
| | | model_url |
| | | from ard_model_management |
| | | </sql> |
| | | |
| | |
| | | <if test="latitude != null "> and latitude = #{latitude}</if> |
| | | <if test="height != null "> and height = #{height}</if> |
| | | <if test="proportion != null "> and proportion = #{proportion}</if> |
| | | <if test="modelUrl != null "> and model_url = #{modelUrl}</if> |
| | | </where> |
| | | </select> |
| | | |
| | |
| | | <if test="latitude != null">latitude,</if> |
| | | <if test="height != null">height,</if> |
| | | <if test="proportion != null">proportion,</if> |
| | | <if test="modelUrl != null">model_url,</if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">#{id},</if> |
| | |
| | | <if test="latitude != null">#{latitude},</if> |
| | | <if test="height != null">#{height},</if> |
| | | <if test="proportion != null">#{proportion},</if> |
| | | <if test="modelUrl != null">#{modelUrl},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | |
| | | <if test="latitude != null">latitude = #{latitude},</if> |
| | | <if test="height != null">height = #{height},</if> |
| | | <if test="proportion != null">proportion = #{proportion},</if> |
| | | <if test="modelUrl != null">model_url = #{modelUrl},</if> |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |
| | |
| | | <result property="loadingSpeed" column="loading_speed" /> |
| | | <result property="userId" column="user_id" /> |
| | | <result property="deptId" column="dept_id" /> |
| | | <result property="defaultLoading" column="default_loading" /> |
| | | </resultMap> |
| | | |
| | | <sql id="selectArdTileManagementVo"> |
| | |
| | | automatic_super_cleaning_model, |
| | | loading_speed, |
| | | user_id, |
| | | dept_id |
| | | dept_id, |
| | | default_loading |
| | | from ard_tile_management |
| | | </sql> |
| | | |
| | |
| | | <if test="loadingSpeed != null">loading_speed,</if> |
| | | <if test="userId != null">user_id,</if> |
| | | <if test="deptId != null">dept_id,</if> |
| | | <if test="defaultLoading != null">default_loading,</if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">#{id},</if> |
| | |
| | | <if test="loadingSpeed != null">#{loadingSpeed},</if> |
| | | <if test="userId != null">#{userId},</if> |
| | | <if test="deptId != null">#{deptId},</if> |
| | | <if test="defaultLoading != null">#{defaultLoading},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | |
| | | <if test="loadingSpeed != null">loading_speed = #{loadingSpeed},</if> |
| | | <if test="userId != null">user_id = #{userId},</if> |
| | | <if test="deptId != null">dept_id = #{deptId},</if> |
| | | <if test="defaultLoading != null">default_loading = #{defaultLoading},</if> |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |