| | |
| | | <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"/> |
| | |
| | | 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, |
| | |
| | | @ExcelProperty(value="纠纷类型") |
| | | private String caseTypeName; |
| | | @ExcelProperty(value="承办部门") |
| | | private String mediateDeptName; |
| | | private String mediateUnitName; |
| | | @ExcelProperty(value="配合部门") |
| | | private String assistUnitName; |
| | | @ExcelProperty(value="化解结果") |
| | |
| | | /** |
| | | * 实际调解部门编号(承办部门) |
| | | */ |
| | | private String mediateDeptId; |
| | | private String mediateUnitId; |
| | | |
| | | /** |
| | | * 实际调解部门名称(承办部门) |
| | | */ |
| | | private String mediateDeptName; |
| | | private String mediateUnitName; |
| | | |
| | | /** |
| | | * 实际调解部门编号(配合部门) |
| | |
| | | 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()); |
| | |
| | | * @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); |
| | | } |
| | |
| | | </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,--> |
| | |
| | | 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(); |