drone-service/drone-fw/src/main/java/org/sxkj/fw/area/mapper/FwDefenseSceneManageMapper.xml
@@ -79,7 +79,7 @@ FROM ja_fw_defense_scene_manage dsm LEFT JOIN ja_fw_defense_scene ds ON ds.id = dsm.defense_scene_id AND ds.is_deleted = 0 LEFT JOIN ja_fw_area_divide ad ON FIND_IN_SET(ad.id, ds.area_divide_ids) > 0 AND ad.is_deleted = 0 WHERE dsm.id = #{id} AND dsm.is_deleted = 0 WHERE dsm.id = #{id} ) ad ON CHAR_LENGTH(ad.device_ids) - CHAR_LENGTH(REPLACE(ad.device_ids, ',', '')) >= numbers.n - 1 WHERE ad.device_ids IS NOT NULL AND ad.device_ids != '' </select> drone-service/drone-gd/src/main/java/org/sxkj/gd/implement/mapper/GdMaterialMapper.xml
@@ -15,6 +15,9 @@ <select id="selectGdMaterialPage" resultMap="gdMaterialResultMap"> select * from ja_gd_material where is_deleted = 0 <if test="gdMaterial.materialName != null"> and material_name like concat('%',#{gdMaterial.materialName},'%') </if> </select> drone-service/drone-gd/src/main/java/org/sxkj/gd/implement/service/impl/GdImplementListServiceImpl.java
@@ -71,6 +71,8 @@ // 查询实施清单详情 GdImplementListEntity gdImplement = getOne(Condition.getQueryWrapper(GenericConverter.convert(idParam, GdImplementListEntity.class))); getThingListMaterialRelationVO.setImplementListId(gdImplement.getId()); getThingListMaterialRelationVO.setProcessDefinitionId(gdImplement.getProcessDefinitionId()); getThingListMaterialRelationVO.setProcessInstanceId(gdImplement.getProcessInstanceId()); List<GdThingListMaterialRelEntity> gdThingListMaterialRelEntityList = gdThingListMaterialRelService.list( Wrappers.<GdThingListMaterialRelEntity>query() drone-service/drone-gd/src/main/java/org/sxkj/gd/implement/vo/GdMaterialVO.java
@@ -54,7 +54,7 @@ * 是否适用全部情形:1是 0否 */ @ApiModelProperty(value = "是否适用全部情形:1是 0否") private Byte isAllScenario; private Integer isAllScenario; /** * 材料说明 */ drone-service/drone-gd/src/main/java/org/sxkj/gd/implement/vo/GdThingListMaterialRelVO.java
@@ -16,10 +16,10 @@ */ package org.sxkj.gd.implement.vo; import org.sxkj.gd.implement.entity.GdThingListMaterialRelEntity; import org.springblade.core.tool.node.INode; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; import java.io.Serializable; /** * 实施清单-材料关联表(情形化配置) 视图实体类 @@ -28,8 +28,29 @@ * @since 2026-01-31 */ @Data @EqualsAndHashCode(callSuper = true) public class GdThingListMaterialRelVO extends GdThingListMaterialRelEntity { public class GdThingListMaterialRelVO implements Serializable { private static final long serialVersionUID = 1L; /** * 关联实施清单ID */ @ApiModelProperty(value = "关联实施清单ID") private Long implementListId; /** * 关联材料ID */ @ApiModelProperty(value = "关联材料ID") private Long materialId; /** * 材料序号(列表展示字段) */ @ApiModelProperty(value = "材料序号(列表展示字段)") private Integer sort; /** * 材料情形化配置:{"scenario_name":"情形1","is_need":1,"remark":"仅情形1需提供"} */ @ApiModelProperty(value = "材料情形化配置:{\"scenario_name\":\"情形1\",\"is_need\":1,\"remark\":\"仅情形1需提供\"}") private String scenarioConfig; }