From 47488a7bf69c5cdae18e80a616ec0a43e890765d Mon Sep 17 00:00:00 2001 From: zhouxiantao <1026371446@qq.com> Date: Sat, 14 Sep 2024 17:32:20 +0800 Subject: [PATCH] 小程序协议 --- dyh-service/dyh-sys/src/main/java/cn/huge/module/file/service/FileInfoService.java | 4 ++-- dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/domain/dto/CasePageDTO.java | 4 ++-- dyh-service/dyh-sys/src/main/java/cn/huge/module/file/dao/mapper/xml/FileInfoMapper.xml | 12 ++++++++++++ dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/dao/mapper/xml/CaseInfoMapper.xml | 8 ++++---- dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/domain/dto/CaseInfoWeExcelDTO.java | 2 +- dyh-service/dyh-sys/src/main/java/cn/huge/module/file/dao/mapper/FileInfoMapper.java | 7 +++++++ dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/service/CaseInfoService.java | 4 ++-- 7 files changed, 30 insertions(+), 11 deletions(-) diff --git a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/dao/mapper/xml/CaseInfoMapper.xml b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/dao/mapper/xml/CaseInfoMapper.xml index 6aa05bb..7d34a14 100644 --- a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/dao/mapper/xml/CaseInfoMapper.xml +++ b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/dao/mapper/xml/CaseInfoMapper.xml @@ -94,8 +94,8 @@ <result property="inputUnitName" column="input_unit_name"/> <result property="mediResult" column="medi_result"/> <result property="mediResultName" column="medi_result_name"/> - <result property="mediateDeptId" column="mediate_dept_id"/> - <result property="mediateDeptName" column="mediate_dept_name"/> + <result property="mediateUnitId" column="mediate_unit_id"/> + <result property="mediateUnitName" column="mediate_unit_name"/> <result property="assistUnitId" column="assist_unit_id"/> <result property="assistUnitName" column="assist_unit_name"/> <result property="closeTime" column="close_time"/> @@ -118,8 +118,8 @@ a.input_unit_name, b.medi_result, b.medi_result_name, - b.mediate_dept_id, - b.mediate_dept_name, + b.mediate_unit_id, + b.mediate_unit_name, b.assist_unit_id, b.assist_unit_name, b.close_time, diff --git a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/domain/dto/CaseInfoWeExcelDTO.java b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/domain/dto/CaseInfoWeExcelDTO.java index f88aaa8..2e3c999 100644 --- a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/domain/dto/CaseInfoWeExcelDTO.java +++ b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/domain/dto/CaseInfoWeExcelDTO.java @@ -18,7 +18,7 @@ @ExcelProperty(value="纠纷类型") private String caseTypeName; @ExcelProperty(value="承办部门") - private String mediateDeptName; + private String mediateUnitName; @ExcelProperty(value="配合部门") private String assistUnitName; @ExcelProperty(value="化解结果") diff --git a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/domain/dto/CasePageDTO.java b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/domain/dto/CasePageDTO.java index 6c312c6..c29b15f 100644 --- a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/domain/dto/CasePageDTO.java +++ b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/domain/dto/CasePageDTO.java @@ -61,12 +61,12 @@ /** * 实际调解部门编号(承办部门) */ - private String mediateDeptId; + private String mediateUnitId; /** * 实际调解部门名称(承办部门) */ - private String mediateDeptName; + private String mediateUnitName; /** * 实际调解部门编号(配合部门) diff --git a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/service/CaseInfoService.java b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/service/CaseInfoService.java index 448b8ac..f8ac102 100644 --- a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/service/CaseInfoService.java +++ b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/service/CaseInfoService.java @@ -804,8 +804,8 @@ if(ObjectUtils.isNotEmpty(caseInfoUnfold)){ caseInfoWeChatDTO.setMediResult(caseInfoUnfold.getMediResult()); caseInfoWeChatDTO.setMediResultName(caseInfoUnfold.getMediResultName()); - caseInfoWeChatDTO.setMediateDeptId(caseInfoUnfold.getMediateDeptId()); - caseInfoWeChatDTO.setMediateDeptName(caseInfoUnfold.getMediateDeptName()); + caseInfoWeChatDTO.setMediateDeptId(caseInfoUnfold.getMediateUnitId()); + caseInfoWeChatDTO.setMediateDeptName(caseInfoUnfold.getMediateUnitName()); caseInfoWeChatDTO.setAgreeType(caseInfoUnfold.getAgreeType()); caseInfoWeChatDTO.setAgreeTypeName(caseInfoUnfold.getAgreeTypeName()); caseInfoWeChatDTO.setAgreeContent(caseInfoUnfold.getAgreeContent()); diff --git a/dyh-service/dyh-sys/src/main/java/cn/huge/module/file/dao/mapper/FileInfoMapper.java b/dyh-service/dyh-sys/src/main/java/cn/huge/module/file/dao/mapper/FileInfoMapper.java index 2c7e446..e410d5c 100644 --- a/dyh-service/dyh-sys/src/main/java/cn/huge/module/file/dao/mapper/FileInfoMapper.java +++ b/dyh-service/dyh-sys/src/main/java/cn/huge/module/file/dao/mapper/FileInfoMapper.java @@ -76,4 +76,11 @@ * @return List<FileRelate> */ List<FileInfo> listFile(@Param("terms") Map<String, Object> terms); + + /** + * 根据多个编号查询 + * @param terms + * @return List<FileRelate> + */ + List<FileInfo> listFileByType(@Param("terms") Map<String, Object> terms); } diff --git a/dyh-service/dyh-sys/src/main/java/cn/huge/module/file/dao/mapper/xml/FileInfoMapper.xml b/dyh-service/dyh-sys/src/main/java/cn/huge/module/file/dao/mapper/xml/FileInfoMapper.xml index 5f4a18e..4eeadd0 100644 --- a/dyh-service/dyh-sys/src/main/java/cn/huge/module/file/dao/mapper/xml/FileInfoMapper.xml +++ b/dyh-service/dyh-sys/src/main/java/cn/huge/module/file/dao/mapper/xml/FileInfoMapper.xml @@ -319,6 +319,18 @@ </if> </select> + <select id="listFileByType" resultMap="fileResult"> + SELECT t2.owner_id, t2.owner_cat, t2.owner_type, t2.uploader_id, t2.uploader_name, + <include refid="column-part-t"/> + FROM dyh_file_info t1 + LEFT JOIN dyh_file_relate t2 ON t1.id = t2.file_id + WHERE + t1.delete_status = 0 + and t2.main_id = #{terms.mainId} + and t2.owner_type = #{terms.ownerType} + </select> + + <!-- <!– 根据多个编号查询 –>--> <!-- <select id="listByIdsTypes" resultMap="fileResult">--> <!-- SELECT t2.owner_id, t2.owner_cat, t2.owner_type, t2.uploader_id, t2.uploader_name,--> diff --git a/dyh-service/dyh-sys/src/main/java/cn/huge/module/file/service/FileInfoService.java b/dyh-service/dyh-sys/src/main/java/cn/huge/module/file/service/FileInfoService.java index 2f1c4f0..772b031 100644 --- a/dyh-service/dyh-sys/src/main/java/cn/huge/module/file/service/FileInfoService.java +++ b/dyh-service/dyh-sys/src/main/java/cn/huge/module/file/service/FileInfoService.java @@ -506,8 +506,8 @@ List<FileInfoBaseDTO> fileList = new ArrayList<>(); Map<String, Object> terms = new HashMap<>(); terms.put("mainId", mainId); - terms.put("types", ownerType); - List<FileInfo> fileInfoList = mapper.listFile(terms); + terms.put("ownerType", ownerType); + List<FileInfo> fileInfoList = mapper.listFileByType(terms); if(CollectionUtils.isNotEmpty(fileInfoList)){ for (FileInfo fileInfo : fileInfoList) { FileInfoBaseDTO fileInfoBaseDTO = new FileInfoBaseDTO(); -- Gitblit v1.8.0