增加流程与程序关联查询

yangys

2025-06-30 813f0f6d391b7f24682204c22c059ef69b124fa6

增加流程与程序关联查询

 blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/controller/NcProgramController.java

@@ -11,6 +11,7 @@
import org.springblade.core.tool.api.R;
import org.springblade.mdm.program.entity.NcProgram;
import org.springblade.mdm.program.service.NcProgramService;
import org.springblade.mdm.program.service.ProcessProgRefService;
import org.springblade.mdm.program.vo.NcNodeProgramQueryVO;
import org.springblade.mdm.program.vo.NcProgramUploadVO;
import org.springblade.mdm.program.vo.NcProgramVO;
@@ -33,7 +34,7 @@
public class NcProgramController {

    private final NcProgramService ncProgramService;

    private final ProcessProgRefService ncProcessProgRefService;
    @PostMapping("/upload")
    @Operation(summary = "上传文件", description = "上传程序/附件文件")
    public R<Boolean> upload(NcProgramUploadVO uploadVO) {
@@ -85,4 +86,10 @@
        IPage<NcProgramVO> pages = ncProgramService.pageQuery(query);
        return R.data(pages);
    }

    @GetMapping("/list-by-process")
    @Operation(summary = "节点程序文件列表", description = "某节点内的程序列表，仅‘程序包’字典值60")
    public R<List<NcProgramVO>> listByProcess(@Parameter(description="所属节点ID")@RequestParam String processInstanceId) {
        return R.data(ncProcessProgRefService.listByProcess(processInstanceId));
    }
}

 blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/mapper/ProcessProgRefMapper.java

@@ -4,9 +4,11 @@
import org.springblade.mdm.program.entity.NcNode;
import org.springblade.mdm.program.entity.ProcessProgRef;
import org.springblade.mdm.program.vo.NcNodeVO;
import org.springblade.mdm.program.vo.NcProgramVO;

import java.util.List;

public interface ProcessProgRefMapper extends BladeMapper<ProcessProgRef> {

    List<NcProgramVO> listByProcess(String processInstanceId);
}

 blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/mapper/ProcessProgRefMapper.xml

@@ -3,4 +3,8 @@
<mapper namespace="org.springblade.mdm.program.mapper.ProcessProgRefMapper">


    <select id="listByProcess" resultType="org.springblade.mdm.program.vo.NcProgramVO">
        select p.id,p.name,url,code from mdm_process_prog_ref r join mdm_nc_program p on r.nc_program_id=p.id
        where process_instance_id=#{processInstanceId} and p.is_deleted=0
    </select>
</mapper>

 blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/service/ProcessProgRefService.java

@@ -93,5 +93,12 @@
        this.saveBatch(entities);
    }


    /**
     * 查询流程关联的程序i二标
     * @param processInstanceId
     * @return
     */
    public List<NcProgramVO> listByProcess(String processInstanceId) {
        return this.getBaseMapper().listByProcess(processInstanceId);
    }
}