From 26eec9c207eaea6378ea01180d31d5b0409e015a Mon Sep 17 00:00:00 2001 From: eight <641137800@qq.com> Date: 星期二, 19 十一月 2024 16:51:56 +0800 Subject: [PATCH] 设备导出 --- jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/devmanage/DeviceController.java | 19 ++++++++- jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/devmanage/vo/DeviceRespFlattenVO.java | 100 ++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 117 insertions(+), 2 deletions(-) diff --git a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/devmanage/DeviceController.java b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/devmanage/DeviceController.java index 054b4a7..7b6c348 100644 --- a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/devmanage/DeviceController.java +++ b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/devmanage/DeviceController.java @@ -111,9 +111,24 @@ HttpServletResponse response) throws IOException { pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE); List<DeviceDO> list = deviceService.getDevicePage(pageReqVO).getList(); + + List<DeviceRespFlattenVO> listFlatten = list.stream().map(deviceDO -> { + DeviceRespFlattenVO deviceRespFlattenVO = BeanUtils.toBean(deviceDO, DeviceRespFlattenVO.class); + if (null != deviceDO.getPatDetails()) { + deviceRespFlattenVO.setPatId(deviceDO.getPatDetails().getId()); + deviceRespFlattenVO.setPatName(deviceDO.getPatDetails().getName()); + deviceRespFlattenVO.setPatMobile(deviceDO.getPatDetails().getMobile()); + deviceRespFlattenVO.setPatDeptCode(deviceDO.getPatDetails().getDeptCode()); + deviceRespFlattenVO.setPatDeptDesc(deviceDO.getPatDetails().getDeptDesc()); + deviceRespFlattenVO.setPatWardCode(deviceDO.getPatDetails().getWardCode()); + deviceRespFlattenVO.setPatWardDesc(deviceDO.getPatDetails().getWardDesc()); + deviceRespFlattenVO.setPatBedNo(deviceDO.getPatDetails().getBedNo()); + } + return deviceRespFlattenVO; + }).toList(); + // 瀵煎嚭 Excel - ExcelUtils.write(response, "璁惧.xls", "鏁版嵁", DeviceRespVO.class, - BeanUtils.toBean(list, DeviceRespVO.class)); + ExcelUtils.write(response, "璁惧.xls", "鏁版嵁", DeviceRespFlattenVO.class, listFlatten); } @GetMapping("/dev-statistic") diff --git a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/devmanage/vo/DeviceRespFlattenVO.java b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/devmanage/vo/DeviceRespFlattenVO.java new file mode 100644 index 0000000..6395bdf --- /dev/null +++ b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/controller/admin/devmanage/vo/DeviceRespFlattenVO.java @@ -0,0 +1,100 @@ +package cn.lihu.jh.module.ecg.controller.admin.devmanage.vo; + +import cn.lihu.jh.module.ecg.dal.dataobject.patient.PatDetails; +import com.alibaba.excel.annotation.ExcelIgnoreUnannotated; +import com.alibaba.excel.annotation.ExcelProperty; +import io.swagger.v3.oas.annotations.media.Schema; +import lombok.Data; + +import java.time.LocalDate; +import java.time.LocalDateTime; + +@Schema(description = "绠$悊鍚庡彴 - 璁惧 Response Flatten VO") +@Data +@ExcelIgnoreUnannotated +public class DeviceRespFlattenVO { + + @Schema(description = "id", requiredMode = Schema.RequiredMode.REQUIRED, example = "15567") + @ExcelProperty("id") + private Integer id; + + @Schema(description = "璁惧缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "5317") + @ExcelProperty("璁惧缂栧彿") + private String devId; + + @Schema(description = "璁惧鍥烘湁缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "5317") + @ExcelProperty("璁惧鍥烘湁缂栧彿") + private String devCodeIntrinsic; + + @Schema(description = "璁惧鍖婚櫌缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "5317") + @ExcelProperty("璁惧鍖婚櫌缂栧彿") + private String devCodeHosp; + + @Schema(description = "璁惧绉戝缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "5317") + @ExcelProperty("璁惧绉戝缂栧彿") + private String devCodeDept; + + @Schema(description = "鍒嗙被鍚�", requiredMode = Schema.RequiredMode.REQUIRED) + @ExcelProperty("鍒嗙被鍚�") + private String category; + + @Schema(description = "鍝佺墝", requiredMode = Schema.RequiredMode.REQUIRED) + @ExcelProperty("鍝佺墝") + private String brand; + + @Schema(description = "鍨嬪彿", requiredMode = Schema.RequiredMode.REQUIRED) + @ExcelProperty("鍨嬪彿") + private String model; + + @Schema(description = "閲囪喘鏃ユ湡") + @ExcelProperty("閲囪喘鏃ユ湡") + private LocalDate purchaseDate; + + @Schema(description = "鍒涘缓鏃堕棿", requiredMode = Schema.RequiredMode.REQUIRED) + @ExcelProperty("鍒涘缓鏃堕棿") + private LocalDateTime createTime; + + @Schema(description = "鐘舵�佹棩鏈�") + @ExcelProperty("鐘舵�佹棩鏈�") + private LocalDate stateDate; + + /** + * 0 - 绌洪棽 10 - 浣跨敤涓� 20 - 宸查仐澶� + */ + @Schema(description = "鐘舵��") + @ExcelProperty("鐘舵��") + private Integer state; + + @Schema(description = "鎷嗚缂栧彿") + @ExcelProperty("鎷嗚缂栧彿") + private Long rentId; + + //@Schema(description = "鎮h�呰鎯�") + //@ExcelProperty("鎮h�呰鎯�") + //private PatDetails patDetails; + @Schema(description = "鎮h�匢D") + @ExcelProperty("鎮h�匢D") + String patId; + @Schema(description = "鎮h�呭悕") + @ExcelProperty("鎮h�呭悕") + String patName; + @Schema(description = "鎮h�呮墜鏈�") + @ExcelProperty("鎮h�呮墜鏈�") + String patMobile; + @Schema(description = "鎮h�呯瀹ょ紪鍙�") + @ExcelProperty("鎮h�呯瀹ょ紪鍙�") + String patDeptCode; + @Schema(description = "鎮h�呯瀹�") + @ExcelProperty("鎮h�呯瀹�") + String patDeptDesc; + @Schema(description = "鎮h�呯梾鍖虹紪鍙�") + @ExcelProperty("鎮h�呯梾鍖虹紪鍙�") + String patWardCode; + @Schema(description = "鎮h�呯梾鍖�") + @ExcelProperty("鎮h�呯梾鍖�") + String patWardDesc; + @Schema(description = "鎮h�呭簥鍙�") + @ExcelProperty("鎮h�呭簥鍙�") + String patBedNo; +} + -- Gitblit v1.9.3