| | |
| | | log.info("æ°å¢æ½å¨æç®ä¿¡æ¯ï¼{}", serviceDonatebaseinfo); |
| | | SysUser user = SecurityUtils.getLoginUser().getUser(); |
| | | |
| | | // String bh = ""; |
| | | // bh = serviceDonatebaseinfoService.getDonateNumber(serviceDonatebaseinfo); |
| | | // if (bh == "") { |
| | | // return AjaxResult.error("æ°å¢æ¶çæçç¼å·ä¸ºç©º,å建失败!"); |
| | | // } else { |
| | | // ServiceDonatebaseinfo serviceDonatebaseinfo1 = new ServiceDonatebaseinfo(); |
| | | // serviceDonatebaseinfo1.setDonorno(bh); |
| | | // List<ServiceDonatebaseinfo> listrecord = serviceDonatebaseinfoService.queryList(serviceDonatebaseinfo1); |
| | | // if (listrecord.size() > 0) { |
| | | // return AjaxResult.error("æ°å¢æ¶çæçç¼å·" + bh + "å·²åå¨,æ æ³ä¿å!"); |
| | | // } |
| | | // |
| | | // } |
| | | String idcardno = serviceDonatebaseinfo.getIdcardno(); |
| | | ServiceDonatebaseinfo serviceDonatebaseinfo2 = new ServiceDonatebaseinfo(); |
| | | serviceDonatebaseinfo2.setIdcardno(idcardno); |
| | |
| | | boolean save = serviceDonatebaseinfoReportService.save(serviceDonatebaseinfoReport); |
| | | //å°çæçæä»¶å°ååå¨å°æ°æ®åºä¸ |
| | | if (save) |
| | | serviceDonatebaseinfoReportFileService.addList(serviceDonatebaseinfoReport.getAnnexfilesList(), serviceDonatebaseinfoReport.getCaseNo(), getNickName()); |
| | | serviceDonatebaseinfoReportFileService.addList(serviceDonatebaseinfoReport.getAnnexfilesList(), serviceDonatebaseinfoReport.getCaseNo(), getNickName(), serviceDonatebaseinfoReport.getId()); |
| | | return toAjax(save); |
| | | } |
| | | |
| | |
| | | import com.ruoyi.common.utils.PageUtils; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.project.domain.ServiceDonatemaintenance; |
| | | import com.ruoyi.project.domain.vo.ServiceDonatemaintenanceVO; |
| | | import com.ruoyi.project.domain.dto.MaintenanceBaseInfoDTO; |
| | | import com.ruoyi.project.domain.dto.MedicalevaluationBaseInfoDTO; |
| | | import com.ruoyi.project.domain.vo.MaintenanceBaseInfoVO; |
| | | import com.ruoyi.project.service.IServiceDonatemaintenanceService; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.util.CollectionUtils; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import java.util.List; |
| | |
| | | @Autowired |
| | | private IServiceDonatemaintenanceService serviceDonatemaintenanceService; |
| | | |
| | | // /** |
| | | // * æ¥è¯¢ä¾ä½ç»´æ¤è®°å½å表 |
| | | // */ |
| | | // @ApiOperation("æ¥è¯¢ä¾ä½ç»´æ¤è®°å½å表") |
| | | // // @PreAuthorize("@ss.hasPermi('system:donatemaintenance:list')") |
| | | // @PostMapping("/list") |
| | | // public Map<String, Object> list(@RequestBody ServiceDonatemaintenance serviceDonatemaintenance) { |
| | | // Page<ServiceDonatemaintenance> serviceDonatemaintenancePage = serviceDonatemaintenanceService.queryList(serviceDonatemaintenance); |
| | | // return getDataTable(serviceDonatemaintenancePage.getRecords(), (int) serviceDonatemaintenancePage.getTotal()); |
| | | // } |
| | | |
| | | /** |
| | | /* |
| | | * æ¥è¯¢ä¾ä½ç»´æ¤è®°å½å表 |
| | | */ |
| | | @ApiOperation("è·åä¾ä½ç»´æ¤è®°å½åºæ¬ä¿¡æ¯å表") |
| | | // @PreAuthorize("@ss.hasPermi('system:donatemaintenance:list')") |
| | | @PostMapping("/maintenanceBaseInfoList") |
| | | public Map<String, Object> maintenanceBaseInfoList(@RequestBody ServiceDonatemaintenanceVO serviceDonatemaintenanceVO) { |
| | | Integer offset = PageUtils.getOffset(serviceDonatemaintenanceVO.getPageNum(), serviceDonatemaintenanceVO.getPageSize()); |
| | | serviceDonatemaintenanceVO.setPageNum(offset); |
| | | Page serviceDonatemaintenancePage = serviceDonatemaintenanceService.maintenanceBaseInfoList(serviceDonatemaintenanceVO); |
| | | return getDataTable(serviceDonatemaintenancePage.getRecords(), (int) serviceDonatemaintenancePage.getTotal()); |
| | | public Map<String, Object> maintenanceBaseInfoList(@RequestBody MaintenanceBaseInfoVO maintenanceBaseInfoVO) { |
| | | Integer offset = PageUtils.getOffset(maintenanceBaseInfoVO.getPageNum(), maintenanceBaseInfoVO.getPageSize()); |
| | | maintenanceBaseInfoVO.setPageNum(offset); |
| | | List<MaintenanceBaseInfoDTO> maintenanceBaseInfoDTOS = serviceDonatemaintenanceService.maintenanceBaseInfoList(maintenanceBaseInfoVO); |
| | | |
| | | //è·åæ»æ° |
| | | maintenanceBaseInfoVO.setPageNum(null); |
| | | maintenanceBaseInfoVO.setPageSize(null); |
| | | Integer totalCount = 0; |
| | | List<MaintenanceBaseInfoDTO> total = serviceDonatemaintenanceService.maintenanceBaseInfoList(maintenanceBaseInfoVO); |
| | | if (!CollectionUtils.isEmpty(total)) totalCount = total.size(); |
| | | return getDataTable(maintenanceBaseInfoDTOS, totalCount); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @ApiOperation("è·åå»çè¯ä¼°æ£è
åºæ¬ä¿¡æ¯å表") |
| | | //// @PreAuthorize("@ss.hasPermi('project:medicalevaluation:list')") |
| | | @PostMapping("/evaluateBaseInfolist") |
| | | public Map<String, Object> evaluateBaseInfolist(@RequestBody MedicalEvaluationWithBaseInfoVO medicalEvaluationWithBaseInfoVO) { |
| | | @PostMapping("/medevaluateBaseInfolist") |
| | | public Map<String, Object> medevaluateBaseInfolist(@RequestBody MedicalEvaluationWithBaseInfoVO medicalEvaluationWithBaseInfoVO) { |
| | | Integer offset = PageUtils.getOffset(medicalEvaluationWithBaseInfoVO.getPageNum(), medicalEvaluationWithBaseInfoVO.getPageSize()); |
| | | medicalEvaluationWithBaseInfoVO.setPageNum(offset); |
| | | List<MedicalevaluationBaseInfoDTO> medicalEvaluationWithBaseInfoVOS = serviceMedicalevaluationService.evaluateBaseInfolist(medicalEvaluationWithBaseInfoVO); |
| | | List<MedicalevaluationBaseInfoDTO> medicalEvaluationWithBaseInfoVOS = serviceMedicalevaluationService.medevaluateBaseInfolist(medicalEvaluationWithBaseInfoVO); |
| | | |
| | | //è·åæ»æ° |
| | | medicalEvaluationWithBaseInfoVO.setPageNum(null); |
| | | medicalEvaluationWithBaseInfoVO.setPageSize(null); |
| | | Integer totalCount = 0; |
| | | List<MedicalevaluationBaseInfoDTO> total = serviceMedicalevaluationService.evaluateBaseInfolist(medicalEvaluationWithBaseInfoVO); |
| | | List<MedicalevaluationBaseInfoDTO> total = serviceMedicalevaluationService.medevaluateBaseInfolist(medicalEvaluationWithBaseInfoVO); |
| | | if (!CollectionUtils.isEmpty(total)) totalCount = total.size(); |
| | | return getDataTable(medicalEvaluationWithBaseInfoVOS, totalCount); |
| | | } |
| | |
| | | @Excel(name = "ç»æ¢æ¡ä¾") |
| | | private Integer terminationCase; |
| | | |
| | | /** æ¡ä¾æ¶é´ */ |
| | | |
| | | @ApiModelProperty("ç»æ¢åå ï¼1好转 2æ»äº¡ 3ä¸ç¬¦åæç®æ å 4家屿¾å¼æç® 5å
¶å®") |
| | | @Excel(name = "ç»æ¢åå ï¼1好转 2æ»äº¡ 3ä¸ç¬¦åæç®æ å 4家屿¾å¼æç® 5å
¶å®") |
| | | private Integer terminationType; |
| | | |
| | | |
| | | @ApiModelProperty("ç»æ¢ç±»åï¼0å¼å¯ï¼1ç»æ¢ é»è®¤å¼ï¼0") |
| | | @Excel(name = "ç»æ¢ç±»å") |
| | | private String terminationResult; |
| | | |
| | | @ApiModelProperty("æ©å±å
容") |
| | | @Excel(name = "æ©å±å
容") |
| | | private String extracontent; |
| | | |
| | | |
| | | @ApiModelProperty("å½åå»é¢") |
| | | @Excel(name = "å½åå»é¢") |
| | | private String currentHospital; |
| | | |
| | | |
| | | @ApiModelProperty("䏿¥å»é¢") |
| | | @Excel(name = "䏿¥å»é¢") |
| | | private String reportHospital; |
| | | |
| | | /** |
| | | * æ¡ä¾æ¶é´ |
| | | */ |
| | | @ApiModelProperty("æ¡ä¾æ¶é´") |
| | | @TableField(fill = FieldFill.INSERT_UPDATE) |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | |
| | | @Excel(name = "åè°åå§å", readConverterExp = "åè°åå§å") |
| | | private String coordinatorName; |
| | | |
| | | /** |
| | | * 䏿¥çå»é¢ï¼æ£è
éè¦è½¬è¿å°çé£å®¶å»é¢ï¼ |
| | | */ |
| | | @ApiModelProperty("䏿¥çå»é¢") |
| | | @Excel(name = "䏿¥çå»é¢", readConverterExp = "䏿¥çå»é¢") |
| | | private String toHospital; |
| | | |
| | | } |
| | | |
| | |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.ruoyi.common.annotation.Excel; |
| | | import com.ruoyi.common.core.domain.BaseEntity; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | /** |
| | | * æç®æµç¨å¯¹è±¡ service_donateflowchart |
| | | * |
| | | * |
| | | * @author ruoyi |
| | | * @date 2021-11-15 |
| | | */ |
| | |
| | | |
| | | /** æç®è
ç¼å· */ |
| | | @Excel(name = "æç®è
ç¼å·") |
| | | @ApiModelProperty("æç®è
ç¼å·") |
| | | private String donorno; |
| | | |
| | | /** æµç¨åç§° */ |
| | | @Excel(name = "æµç¨åç§°") |
| | | @ApiModelProperty("æµç¨åç§°") |
| | | private String flowname; |
| | | |
| | | /** æµç¨éä»¶ */ |
| | | /** æµç¨éä»¶ ï¼ä½åºï¼*/ |
| | | @ApiModelProperty("æµç¨éä»¶ ï¼ä½åºï¼") |
| | | private String flowannex; |
| | | |
| | | /** æµç¨å
容 */ |
| | | /** æµç¨å
容 ï¼ä½åºï¼*/ |
| | | @ApiModelProperty("æµç¨å
容 ï¼ä½åºï¼") |
| | | private String flowcontent; |
| | | |
| | | /** æµç¨ç»è®º */ |
| | | @Excel(name = "æµç¨ç»è®º") |
| | | @ApiModelProperty("æµç¨ç»è®ºï¼ä½åºï¼") |
| | | @Excel(name = "æµç¨ç»è®ºï¼ä½åºï¼") |
| | | private Long flowconclusion; |
| | | |
| | | } |
| | |
| | | @ApiModelProperty("æ²»çå»é¢") |
| | | private String treatmenthospitalno; |
| | | |
| | | |
| | | /** |
| | | * ä½é¢å· |
| | | */ |
| | | @ApiModelProperty("ä½é¢å·") |
| | | private String inpatientNo; |
| | | |
| | | @ApiModelProperty("æ©å±å
容") |
| | | @Excel(name = "æ©å±å
容") |
| | | private String extracontent; |
| | | |
| | | /** |
| | | * æå¨å»çæºæ |
| | | */ |
| | |
| | | /** |
| | | * 工使µ |
| | | */ |
| | | @ApiModelProperty("工使µ") |
| | | @ApiModelProperty("工使µ:1.ä¾è
ç»´æ¤ 2.æç®ææ¿ 3.å»å¦è¯ä¼° 4.æ»äº¡å¤å® 5.伦çå®¡æ¥ 6.å¨å®åé
7.å¨å®å©ç¨ 99.æç®å®æ") |
| | | private Long workflow; |
| | | |
| | | /** |
| | |
| | | */ |
| | | @ApiModelProperty("å¹´é¾åä½") |
| | | private String ageunit; |
| | | |
| | | /** |
| | | * ä¼ æç
æ
åµ |
| | | */ |
| | | @ApiModelProperty("ä¼ æç
æ
åµ") |
| | | private String infectious; |
| | | |
| | | /** |
| | | * ä¼ æç
å
¶å®æ
åµ |
| | | */ |
| | | @ApiModelProperty("ä¼ æç
å
¶å®æ
åµ") |
| | | private String infectiousOther; |
| | | |
| | | /** |
| | | * è¡å |
| | |
| | | @ApiModelProperty("ç»æ¢æ¡ä¾ï¼0å¼å¯ï¼1ç»æ¢ é»è®¤å¼ï¼0") |
| | | @Excel(name = "ç»æ¢æ¡ä¾") |
| | | private Integer terminationCase; |
| | | |
| | | |
| | | @ApiModelProperty("ç»æ¢æ¡ä¾åå ") |
| | | @Excel(name = "ç»æ¢æ¡ä¾") |
| | | private Integer terminationResult; |
| | | |
| | | |
| | | @ApiModelProperty("ç»æ¢åå ï¼1好转 2æ»äº¡ 3ä¸ç¬¦åæç®æ å 4家屿¾å¼æç® 5å
¶å®") |
| | | @Excel(name = "ç»æ¢åå ï¼1好转 2æ»äº¡ 3ä¸ç¬¦åæç®æ å 4家屿¾å¼æç® 5å
¶å®") |
| | | private Integer terminationType; |
| | | |
| | | } |
| | |
| | | @ApiModelProperty("baseInfoçID") |
| | | private Long id; |
| | | |
| | | /** æç®ç±»å« æ ¹æ®åå
¸sys_DonationCategory */ |
| | | @ApiModelProperty("æç®ç±»å«") |
| | | @Excel(name = "æç®ç±»å«") |
| | | private String donationcategory; |
| | | |
| | | /** |
| | | * è®°å½ç¶æ |
| | |
| | | @Excel(name = "è®°å½ç¶æ") |
| | | private String recordstate; |
| | | |
| | | /** æç®ç±»å« æ ¹æ®åå
¸sys_DonationCategory */ |
| | | @ApiModelProperty("æç®ç±»å«") |
| | | @Excel(name = "æç®ç±»å«") |
| | | private String donationcategory; |
| | | |
| | | /** |
| | | * æ¡ä¾ç¼å· |
| | | */ |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.project.domain.dto; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.ruoyi.common.annotation.Excel; |
| | | import com.ruoyi.common.core.domain.BaseEntity; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * ä¾ä½ç»´æ¤è®°å½å¯¹è±¡ service_donatemaintenance |
| | | * |
| | | * @author ruoyi |
| | | * @date 2025-12-27 |
| | | */ |
| | | @Data |
| | | @ApiModel("ä¾ä½ç»´æ¤è®°å½") |
| | | public class MaintenanceBaseInfoDTO extends BaseEntity { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * è®°å½ç¶æ |
| | | */ |
| | | @ApiModelProperty("è®°å½ç¶æ") |
| | | @Excel(name = "è®°å½ç¶æ") |
| | | private String recordstate; |
| | | |
| | | |
| | | /** |
| | | * æ¡ä¾ç¼å· |
| | | */ |
| | | @ApiModelProperty("æ¡ä¾ç¼å·") |
| | | @Excel(name = "æ¡ä¾ç¼å·") |
| | | private String caseNo; |
| | | |
| | | /** |
| | | * æç®è
ç¼å· |
| | | */ |
| | | @ApiModelProperty("æç®è
ç¼å·") |
| | | @Excel(name = "æç®è
ç¼å·") |
| | | private String donorno; |
| | | |
| | | /** |
| | | * æå¨å»çæºæåç§° |
| | | */ |
| | | @ApiModelProperty("æå¨å»çæºæåç§°") |
| | | @Excel(name = "æå¨å»çæºæåç§°") |
| | | private String treatmenthospitalname; |
| | | |
| | | /** |
| | | * æå¨å»çæºæç¼ç |
| | | */ |
| | | @ApiModelProperty("æå¨å»çæºæç¼ç ") |
| | | private String treatmenthospitalno; |
| | | |
| | | /** |
| | | * æ§å« |
| | | */ |
| | | @ApiModelProperty("æ§å«") |
| | | private String sex; |
| | | |
| | | /** |
| | | * å§å |
| | | */ |
| | | @ApiModelProperty("å§å") |
| | | @Excel(name = "å§å") |
| | | private String name; |
| | | |
| | | /** |
| | | * å¼å§å¹´é¾ |
| | | */ |
| | | @ApiModelProperty("å¼å§å¹´é¾") |
| | | private Long startAge; |
| | | |
| | | /** |
| | | * ç»æå¹´é¾ |
| | | */ |
| | | @ApiModelProperty("ç»æå¹´é¾") |
| | | private Long endAge; |
| | | |
| | | /** |
| | | * è¡å |
| | | */ |
| | | @ApiModelProperty("è¡å ") |
| | | private String bloodtype; |
| | | |
| | | /** |
| | | * è¯ä»¶å·ç |
| | | */ |
| | | @ApiModelProperty("è¯ä»¶å·ç ") |
| | | private String idcardno; |
| | | |
| | | /** |
| | | * ç¾ç
è¯æåç§° |
| | | */ |
| | | @ApiModelProperty("ç¾ç
è¯æåç§°") |
| | | @Excel(name = "ç¾ç
è¯æåç§°") |
| | | private String diagnosisname; |
| | | |
| | | /** |
| | | * åè°åå§å |
| | | */ |
| | | @ApiModelProperty("åè°åå§å") |
| | | @Excel(name = "åè°åå§å", readConverterExp = "åè°åå§å") |
| | | private String coordinatorName; |
| | | |
| | | /** |
| | | * ä½é¢å· |
| | | */ |
| | | @ApiModelProperty("ä½é¢å·") |
| | | private String inpatientno; |
| | | |
| | | /** |
| | | * ç»´æ¤è®°å½ä¸»é® |
| | | */ |
| | | @ApiModelProperty("$column.columnComment") |
| | | private Long id; |
| | | |
| | | /** |
| | | * å
³èservice_donatebaseinfo表çID |
| | | */ |
| | | @ApiModelProperty("å
³èservice_donatebaseinfo表çID") |
| | | @Excel(name = "å
³èservice_donatebaseinfo表çID") |
| | | private Long infoid; |
| | | |
| | | |
| | | /** |
| | | * ç»´æ¤é¡¹ç®ç¼å· |
| | | */ |
| | | @ApiModelProperty("ç»´æ¤é¡¹ç®ç¼å·") |
| | | @Excel(name = "ç»´æ¤é¡¹ç®ç¼å·") |
| | | private String itemNo; |
| | | |
| | | /** |
| | | * ç»´æ¤é¡¹ç®åç§° |
| | | */ |
| | | @ApiModelProperty("ç»´æ¤é¡¹ç®åç§°") |
| | | @Excel(name = "ç»´æ¤é¡¹ç®åç§°") |
| | | private String itemName; |
| | | |
| | | /** |
| | | * ç»´æé¡¹ç®æ¶é´ |
| | | */ |
| | | @ApiModelProperty("ç»´æé¡¹ç®æ¶é´") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @Excel(name = "ç»´æé¡¹ç®æ¶é´", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") |
| | | private Date itemTime; |
| | | |
| | | /** |
| | | * 项ç®ç»´æ¤è¯¦æ
ï¼jsonç»æ |
| | | */ |
| | | @ApiModelProperty("项ç®ç»´æ¤è¯¦æ
ï¼jsonç»æ") |
| | | @Excel(name = "项ç®ç»´æ¤è¯¦æ
ï¼jsonç»æ") |
| | | private String itemDesc; |
| | | |
| | | } |
| | | |
| | |
| | | @ApiModelProperty("å»å¦è¯ä¼°çid") |
| | | private Long id; |
| | | |
| | | /** æç®ç±»å« æ ¹æ®åå
¸sys_DonationCategory */ |
| | | @ApiModelProperty("æç®ç±»å«") |
| | | @Excel(name = "æç®ç±»å«") |
| | | private String donationcategory; |
| | | |
| | | /** |
| | | * |
| | | */ |
| | |
| | | @ApiModelProperty("baseInfoçID") |
| | | private Long infoid; |
| | | |
| | | /** æç®ç±»å« æ ¹æ®åå
¸sys_DonationCategory */ |
| | | @ApiModelProperty("æç®ç±»å«") |
| | | @Excel(name = "æç®ç±»å«") |
| | | private String donationcategory; |
| | | |
| | | /** |
| | | * baseInfoçID |
| | | */ |
| | |
| | | private Long id; |
| | | |
| | | /** |
| | | * ä½é¢å· |
| | | */ |
| | | @ApiModelProperty("ä½é¢å·") |
| | | private String inpatientNo; |
| | | |
| | | /** |
| | | * æ¡ä¾ç¼å· |
| | | */ |
| | | @ApiModelProperty("æ¡ä¾ç¼å·") |
| | |
| | | private String caseNo; |
| | | |
| | | /** |
| | | * 工使µ |
| | | * ç»æ¢æ¡ä¾ï¼0å¼å¯ 1ç»æ¢ é»è®¤ 0 |
| | | */ |
| | | @ApiModelProperty("工使µ") |
| | | @ApiModelProperty("ç»æ¢æ¡ä¾ï¼0å¼å¯ 1ç»æ¢ é»è®¤ 0") |
| | | @Excel(name = "ç»æ¢æ¡ä¾ï¼0å¼å¯ 1ç»æ¢ é»è®¤ 0") |
| | | private Integer terminationCase; |
| | | |
| | | /** |
| | | * ç¾ç
è¯æåç§° |
| | | */ |
| | | @ApiModelProperty("ç¾ç
è¯æåç§°") |
| | | @Excel(name = "ç¾ç
è¯æåç§°") |
| | | private String diagnosisName; |
| | | |
| | | @ApiModelProperty("ç»æ¢åå ï¼1好转 2æ»äº¡ 3ä¸ç¬¦åæç®æ å 4家屿¾å¼æç® 5å
¶å®") |
| | | @Excel(name = "ç»æ¢åå ï¼1好转 2æ»äº¡ 3ä¸ç¬¦åæç®æ å 4家屿¾å¼æç® 5å
¶å®") |
| | | private Integer terminationType; |
| | | |
| | | /** |
| | | * 工使µ:1.ä¾è
ç»´æ¤ 2 æç®ææ¿ 3 å»å¦è¯ä¼° 4 æ»äº¡å¤å® 5 伦çå®¡æ¥ 6 å¨å®åé
7 å¨å®å©ç¨ 99 æç®å®æ |
| | | */ |
| | | @ApiModelProperty("工使µ:1.ä¾è
ç»´æ¤ 2 æç®ææ¿ 3 å»å¦è¯ä¼° 4 æ»äº¡å¤å® 5 伦çå®¡æ¥ 6 å¨å®åé
7 å¨å®å©ç¨ 99 æç®å®æ") |
| | | private Long workflow; |
| | | |
| | | /** |
| | | * 䏿¥å»é¢ |
| | | */ |
| | | @ApiModelProperty("䏿¥å»é¢") |
| | | private String treatmentHospitalName; |
| | | |
| | | /** |
| | | * ä¼ æç
æ
åµ |
| | | */ |
| | | @ApiModelProperty("ä¼ æç
æ
åµ") |
| | | private String infectious; |
| | | |
| | | /** |
| | | * ä¼ æç
å
¶å®æ
åµ |
| | | */ |
| | | @ApiModelProperty("ä¼ æç
å
¶å®æ
åµ") |
| | | private String infectiousOther; |
| | | |
| | | /** |
| | | * å¼å§å¹´é¾ |
| | | */ |
| | | @ApiModelProperty("å¼å§å¹´é¾") |
| | | private Long startAge; |
| | | |
| | | /** |
| | | * ç»æå¹´é¾ |
| | | */ |
| | | @ApiModelProperty("ç»æå¹´é¾") |
| | | private Long endAge; |
| | | |
| | | /** |
| | | * å§å |
| | |
| | | @ApiModelProperty("è¯ä»¶å·ç ") |
| | | private String idcardno; |
| | | |
| | | |
| | | /** |
| | | * è®°å½ç¶æ |
| | | */ |
| | | @ApiModelProperty("è®°å½ç¶æ") |
| | | @Excel(name = "è®°å½ç¶æ") |
| | | private String recordstate; |
| | | |
| | | |
| | | } |
| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.project.domain.vo; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.ruoyi.common.annotation.Excel; |
| | | import com.ruoyi.common.core.domain.BaseEntity; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * ä¾ä½ç»´æ¤è®°å½å¯¹è±¡ service_donatemaintenance |
| | | * |
| | | * @author ruoyi |
| | | * @date 2025-12-27 |
| | | */ |
| | | @Data |
| | | @ApiModel("ä¾ä½ç»´æ¤è®°å½") |
| | | public class MaintenanceBaseInfoVO extends BaseEntity { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * è®°å½ç¶æ |
| | | */ |
| | | @ApiModelProperty("è®°å½ç¶æ") |
| | | @Excel(name = "è®°å½ç¶æ") |
| | | private String recordstate; |
| | | |
| | | |
| | | /** |
| | | * æ¡ä¾ç¼å· |
| | | */ |
| | | @ApiModelProperty("æ¡ä¾ç¼å·") |
| | | @Excel(name = "æ¡ä¾ç¼å·") |
| | | private String caseNo; |
| | | |
| | | /** |
| | | * æç®è
ç¼å· |
| | | */ |
| | | @ApiModelProperty("æç®è
ç¼å·") |
| | | @Excel(name = "æç®è
ç¼å·") |
| | | private String donorno; |
| | | |
| | | /** |
| | | * æå¨å»çæºæåç§° |
| | | */ |
| | | @ApiModelProperty("æå¨å»çæºæåç§°") |
| | | @Excel(name = "æå¨å»çæºæåç§°") |
| | | private String treatmenthospitalname; |
| | | |
| | | /** |
| | | * æå¨å»çæºæç¼ç |
| | | */ |
| | | @ApiModelProperty("æå¨å»çæºæç¼ç ") |
| | | private String treatmenthospitalno; |
| | | |
| | | /** |
| | | * æ§å« |
| | | */ |
| | | @ApiModelProperty("æ§å«") |
| | | private String sex; |
| | | |
| | | /** |
| | | * å§å |
| | | */ |
| | | @ApiModelProperty("å§å") |
| | | @Excel(name = "å§å") |
| | | private String name; |
| | | |
| | | /** |
| | | * å¼å§å¹´é¾ |
| | | */ |
| | | @ApiModelProperty("å¼å§å¹´é¾") |
| | | private Long startAge; |
| | | |
| | | /** |
| | | * ç»æå¹´é¾ |
| | | */ |
| | | @ApiModelProperty("ç»æå¹´é¾") |
| | | private Long endAge; |
| | | |
| | | /** |
| | | * è¡å |
| | | */ |
| | | @ApiModelProperty("è¡å ") |
| | | private String bloodtype; |
| | | |
| | | /** |
| | | * è¯ä»¶å·ç |
| | | */ |
| | | @ApiModelProperty("è¯ä»¶å·ç ") |
| | | private String idcardno; |
| | | |
| | | /** |
| | | * ç¾ç
è¯æåç§° |
| | | */ |
| | | @ApiModelProperty("ç¾ç
è¯æåç§°") |
| | | @Excel(name = "ç¾ç
è¯æåç§°") |
| | | private String diagnosisname; |
| | | |
| | | /** |
| | | * åè°åå§å |
| | | */ |
| | | @ApiModelProperty("åè°åå§å") |
| | | @Excel(name = "åè°åå§å", readConverterExp = "åè°åå§å") |
| | | private String coordinatorName; |
| | | |
| | | /** |
| | | * ä½é¢å· |
| | | */ |
| | | @ApiModelProperty("ä½é¢å·") |
| | | private String inpatientno; |
| | | |
| | | /** |
| | | * ç»´æ¤è®°å½ä¸»é® |
| | | */ |
| | | @ApiModelProperty("$column.columnComment") |
| | | private Long id; |
| | | |
| | | /** |
| | | * å
³èservice_donatebaseinfo表çID |
| | | */ |
| | | @ApiModelProperty("å
³èservice_donatebaseinfo表çID") |
| | | @Excel(name = "å
³èservice_donatebaseinfo表çID") |
| | | private Long infoid; |
| | | |
| | | |
| | | /** |
| | | * ç»´æ¤é¡¹ç®ç¼å· |
| | | */ |
| | | @ApiModelProperty("ç»´æ¤é¡¹ç®ç¼å·") |
| | | @Excel(name = "ç»´æ¤é¡¹ç®ç¼å·") |
| | | private String itemNo; |
| | | |
| | | /** |
| | | * ç»´æ¤é¡¹ç®åç§° |
| | | */ |
| | | @ApiModelProperty("ç»´æ¤é¡¹ç®åç§°") |
| | | @Excel(name = "ç»´æ¤é¡¹ç®åç§°") |
| | | private String itemName; |
| | | |
| | | /** |
| | | * ç»´æé¡¹ç®æ¶é´ |
| | | */ |
| | | @ApiModelProperty("ç»´æé¡¹ç®æ¶é´") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @Excel(name = "ç»´æé¡¹ç®æ¶é´", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") |
| | | private Date itemTime; |
| | | |
| | | /** |
| | | * 项ç®ç»´æ¤è¯¦æ
ï¼jsonç»æ |
| | | */ |
| | | @ApiModelProperty("项ç®ç»´æ¤è¯¦æ
ï¼jsonç»æ") |
| | | @Excel(name = "项ç®ç»´æ¤è¯¦æ
ï¼jsonç»æ") |
| | | private String itemDesc; |
| | | |
| | | |
| | | @ApiModelProperty("é¨é¨åç§°") |
| | | @Excel(name = "é¨é¨åç§°") |
| | | private String deptname; |
| | | |
| | | } |
| | | |
| | |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.ruoyi.project.domain.ServiceDonatemaintenance; |
| | | import com.ruoyi.project.domain.dto.MaintenanceBaseInfoDTO; |
| | | import com.ruoyi.project.domain.vo.MaintenanceBaseInfoVO; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | import java.util.List; |
| | |
| | | /** |
| | | * æ¥è¯¢ä¾ä½ç»´æ¤è®°å½å表 |
| | | * |
| | | * @param serviceDonatemaintenance ä¾ä½ç»´æ¤è®°å½ |
| | | * @param maintenanceBaseInfoVO ä¾ä½ç»´æ¤è®°å½ |
| | | * @return ä¾ä½ç»´æ¤è®°å½éå |
| | | */ |
| | | public List<ServiceDonatemaintenance> selectServiceDonatemaintenanceList(ServiceDonatemaintenance serviceDonatemaintenance); |
| | | public List<MaintenanceBaseInfoDTO> selectServiceDonatemaintenanceList(MaintenanceBaseInfoVO maintenanceBaseInfoVO); |
| | | } |
| | |
| | | public List<ServiceDonatebaseinfoReportFile> queryList(ServiceDonatebaseinfoReportFile serviceDonatebaseinfoReportFile); |
| | | |
| | | //æ¹éä¸ä¼ |
| | | public Boolean addList(List<ServiceDonatebaseinfoReportFile> serviceDonatebaseinfoReportFiles,String caseNo,String updateName); |
| | | public Boolean addList(List<ServiceDonatebaseinfoReportFile> serviceDonatebaseinfoReportFiles,String caseNo,String updateName,Long reportId); |
| | | |
| | | public Boolean updateList(List<ServiceDonatebaseinfoReportFile> serviceDonatebaseinfoReportFiles, Long reportId,String caseNo,String updateName); |
| | | } |
| | |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.ruoyi.project.domain.ServiceDonatemaintenance; |
| | | import com.ruoyi.project.domain.vo.ServiceDonatemaintenanceVO; |
| | | import com.ruoyi.project.domain.dto.MaintenanceBaseInfoDTO; |
| | | import com.ruoyi.project.domain.vo.MaintenanceBaseInfoVO; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * ä¾ä½ç»´æ¤è®°å½Serviceæ¥å£ |
| | |
| | | /** |
| | | * è·åä¾ä½ç»´æ¤è®°å½åºæ¬ä¿¡æ¯å表 |
| | | * |
| | | * @param serviceDonatemaintenanceVO |
| | | * @param maintenanceBaseInfoVO |
| | | * @return |
| | | */ |
| | | public Page maintenanceBaseInfoList(ServiceDonatemaintenanceVO serviceDonatemaintenanceVO); |
| | | public List<MaintenanceBaseInfoDTO> maintenanceBaseInfoList(MaintenanceBaseInfoVO maintenanceBaseInfoVO); |
| | | } |
| | |
| | | |
| | | List<MedicalEvaluationVO> selectVOList(MedicalEvaluationVO medicalEvaluationVO); |
| | | |
| | | List<MedicalevaluationBaseInfoDTO> evaluateBaseInfolist(MedicalEvaluationWithBaseInfoVO medicalEvaluationWithBaseInfoVO); |
| | | List<MedicalevaluationBaseInfoDTO> medevaluateBaseInfolist(MedicalEvaluationWithBaseInfoVO medicalEvaluationWithBaseInfoVO); |
| | | } |
| | |
| | | |
| | | @Transactional(rollbackFor = Exception.class) |
| | | @Override |
| | | public Boolean addList(List<ServiceDonatebaseinfoReportFile> serviceDonatebaseinfoReportFiles,String caseNo,String createName) { |
| | | public Boolean addList(List<ServiceDonatebaseinfoReportFile> serviceDonatebaseinfoReportFiles,String caseNo,String createName,Long reportId) { |
| | | boolean save = false; |
| | | if (CollectionUtils.isNotEmpty(serviceDonatebaseinfoReportFiles)) { |
| | | for (ServiceDonatebaseinfoReportFile serviceDonatebaseinfoReportFile : serviceDonatebaseinfoReportFiles) { |
| | | serviceDonatebaseinfoReportFile.setCreateTime(new Date()); |
| | | serviceDonatebaseinfoReportFile.setCreateBy(createName); |
| | | serviceDonatebaseinfoReportFile.setCaseNo(caseNo); |
| | | serviceDonatebaseinfoReportFile.setDonatebaseinfoReportId(reportId); |
| | | serviceDonatebaseinfoReportFile.setCreateTime(new Date()); |
| | | save = save(serviceDonatebaseinfoReportFile); |
| | | } |
| | |
| | | serviceDonatebaseinfo1.setId(null); |
| | | serviceDonatebaseinfo1.setReporterno(serviceDonatebaseinfoReport.getCoordinatorNo()); |
| | | serviceDonatebaseinfo1.setReportername(serviceDonatebaseinfoReport.getCoordinatorName()); |
| | | serviceDonatebaseinfo1.setCurrentHospital(serviceDonatebaseinfoReport.getToHospital()); |
| | | serviceDonatebaseinfo1.setReportername(serviceDonatebaseinfoReport.getCoordinatorName()); |
| | | //å
éè¿caseNoæ¥è¯¢æ¯å¦åå¨ |
| | | ServiceDonatebaseinfo serviceDonatebaseinfo = new ServiceDonatebaseinfo(); |
| | | serviceDonatebaseinfo.setCaseNo(serviceDonatebaseinfoReport.getCaseNo()); |
| | |
| | | if (StringUtils.isNotBlank(serviceDonatebaseinfo.getGcsScore())) { |
| | | wrappers.eq(ServiceDonatebaseinfo::getGcsScore, serviceDonatebaseinfo.getGcsScore()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonatebaseinfo.getExtracontent())) { |
| | | wrappers.eq(ServiceDonatebaseinfo::getExtracontent, serviceDonatebaseinfo.getExtracontent()); |
| | | } |
| | | if (serviceDonatebaseinfo.getTerminationType()!=null) { |
| | | wrappers.eq(ServiceDonatebaseinfo::getTerminationType, serviceDonatebaseinfo.getTerminationType()); |
| | | } |
| | | Map<String, Object> params = serviceDonatebaseinfo.getParams(); |
| | | if (params.get("beginReporttime") != null && params.get("endReporttime") != null) { |
| | | wrappers.between(ServiceDonatebaseinfo::getReporttime, params.get("beginReporttime"), params.get("endReporttime")); |
| | |
| | | import com.ruoyi.common.utils.bean.DtoConversionUtils; |
| | | import com.ruoyi.project.domain.ServiceDonatebaseinfo; |
| | | import com.ruoyi.project.domain.ServiceDonatemaintenance; |
| | | import com.ruoyi.project.domain.dto.MaintenanceBaseInfoDTO; |
| | | import com.ruoyi.project.domain.dto.ServiceDonatebaseinfoDTO; |
| | | import com.ruoyi.project.domain.vo.ServiceDonatemaintenanceVO; |
| | | import com.ruoyi.project.domain.vo.MaintenanceBaseInfoVO; |
| | | import com.ruoyi.project.mapper.ServiceDonatemaintenanceMapper; |
| | | import com.ruoyi.project.service.IServiceDonatebaseinfoService; |
| | | import com.ruoyi.project.service.IServiceDonatemaintenanceService; |
| | |
| | | } |
| | | |
| | | @Override |
| | | public Page maintenanceBaseInfoList(ServiceDonatemaintenanceVO serviceDonatemaintenanceVO) { |
| | | ServiceDonatebaseinfo serviceDonatebaseinfo = new ServiceDonatebaseinfo(); |
| | | serviceDonatebaseinfo.setPageNum(serviceDonatemaintenanceVO.getPageNum()); |
| | | serviceDonatebaseinfo.setPageSize(serviceDonatemaintenanceVO.getPageSize()); |
| | | serviceDonatebaseinfo.setName(serviceDonatemaintenanceVO.getName()); |
| | | serviceDonatebaseinfo.setTreatmenthospitalname(serviceDonatemaintenanceVO.getTreatmenthospitalname()); |
| | | serviceDonatebaseinfo.setDeptname(serviceDonatemaintenanceVO.getDeptname()); |
| | | serviceDonatebaseinfo.setRecordstate(serviceDonatemaintenanceVO.getRecordstate()); |
| | | Page serviceDonatebaseinfoPage = serviceDonatebaseinfoService.queryListPage(serviceDonatebaseinfo); |
| | | |
| | | List<ServiceDonatebaseinfo> records = serviceDonatebaseinfoPage.getRecords(); |
| | | List<ServiceDonatebaseinfoDTO> serviceDonatebaseinfoDTOS = DtoConversionUtils.sourceToTarget(records, ServiceDonatebaseinfoDTO.class); |
| | | for (ServiceDonatebaseinfoDTO serviceDonatebaseinfoDTO : serviceDonatebaseinfoDTOS) { |
| | | ServiceDonatemaintenance serviceDonatemaintenance = new ServiceDonatemaintenance(); |
| | | serviceDonatemaintenance.setInfoid(serviceDonatebaseinfoDTO.getId()); |
| | | List<ServiceDonatemaintenance> serviceDonatemaintenanceList = serviceDonatemaintenanceMapper.selectServiceDonatemaintenanceList(serviceDonatemaintenance); |
| | | serviceDonatebaseinfoDTO.setServiceDonatemaintenanceList(serviceDonatemaintenanceList); |
| | | } |
| | | |
| | | serviceDonatebaseinfoPage.setRecords(serviceDonatebaseinfoDTOS); |
| | | return serviceDonatebaseinfoPage; |
| | | public List<MaintenanceBaseInfoDTO> maintenanceBaseInfoList(MaintenanceBaseInfoVO maintenanceBaseInfoVO) { |
| | | List<MaintenanceBaseInfoDTO> maintenanceBaseInfoDTOS = serviceDonatemaintenanceMapper.selectServiceDonatemaintenanceList(maintenanceBaseInfoVO); |
| | | return maintenanceBaseInfoDTOS; |
| | | } |
| | | |
| | | } |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<MedicalevaluationBaseInfoDTO> evaluateBaseInfolist(MedicalEvaluationWithBaseInfoVO medicalEvaluationWithBaseInfoVO) { |
| | | public List<MedicalevaluationBaseInfoDTO> medevaluateBaseInfolist(MedicalEvaluationWithBaseInfoVO medicalEvaluationWithBaseInfoVO) { |
| | | List<MedicalevaluationBaseInfoDTO> medicalevaluationBaseInfoDTOS = serviceMedicalevaluationMapper.selectEvaluateBaseInfoList(medicalEvaluationWithBaseInfoVO); |
| | | |
| | | //夿pgaeNunæ¯ä¸ºäºè®©æ¥è¯¢totalä¸åæ¥è¯¢serviceMedicalevaluationorgan |
| | |
| | | LEFT JOIN service_deathinfo sdi ON sd.ID = sdi.InfoID |
| | | AND sd.del_flag = 0 |
| | | AND sdi.del_flag = 0 |
| | | AND sdi.ID IS NOT NULL |
| | | <where> |
| | | sd.termination_case = 0 |
| | | <if test="infoid != null ">and se.InfoID = #{infoid}</if> |
| | | <if test="caseNo != null and caseNo != ''">and sd.case_no = #{caseNo}</if> |
| | | <if test="name != null and name != ''">and sd.Name = #{name}</if> |
| | |
| | | <result property="gcsScore" column="gcs_score"/> |
| | | <result property="coordinatorNo" column="coordinator_no"/> |
| | | <result property="coordinatorName" column="coordinator_name"/> |
| | | <result property="terminationResult" column="termination_result"/> |
| | | <result property="reportHospital" column="report_hospital"/> |
| | | <result property="currentHospital" column="current_hospital"/> |
| | | <result property="terminationType" column="termination_type"/> |
| | | <result property="extracontent" column="extracontent"/> |
| | | </resultMap> |
| | | |
| | | <sql id="selectServiceDonatebaseinfoVo"> |
| | |
| | | sd.treatmenthospitalno AS treatmenthospitalno, |
| | | sd.DonorNo AS donorno, |
| | | sd.id AS id, |
| | | sd.InpatientNo AS inpatientNo, |
| | | sd.case_no AS caseNo, |
| | | sd.NAME AS NAME, |
| | | sd.RecordState AS recordstate, |
| | | sd.termination_case AS terminationCase, |
| | | sd.termination_type AS terminationType, |
| | | sd.termination_result AS terminationResult, |
| | | sd.workflow AS workflow, |
| | | sd.Infectious AS infectious, |
| | | sd.Infectious_other AS infectiousOther, |
| | | sd.Sex AS sex, |
| | | sd.Age AS age, |
| | | sd.BloodType AS bloodtype, |
| | |
| | | sd.ReportTime AS reportTime, |
| | | sd.coordinator_no AS coordinatorNo, |
| | | sd.coordinator_name AS coordinatorName, |
| | | sd.termination_case AS terminationCase, |
| | | sd.diagnosisname AS diagnosisname, |
| | | sd.extracontent AS extracontent, |
| | | sm.assess_state AS assessState,-- è¯ä¼°ç¶æ |
| | | sm.assess_time AS assessTime,-- è¯ä¼°æ¶é´ |
| | | sr.SignDate AS signDate,-- 亲å±ç¡®è®¤æ¶é´ |
| | |
| | | AND sdt.del_flag = 0 -- 宿ç»è®° |
| | | |
| | | <where>sd.del_flag = 0 |
| | | <if test="name != null ">AND sd.Name >= #{name}</if> |
| | | <if test="terminationCase != null ">AND sd.termination_case = #{terminationCase}</if> |
| | | <if test="treatmentHospitalName != null ">AND sd.TreatmentHospitalName = #{treatmentHospitalName}</if> |
| | | <if test="name != null ">AND sd.Name = #{name}</if> |
| | | <if test="inpatientNo != null ">AND sd.InpatientNo = #{inpatientNo}</if> |
| | | <if test="startAge != null">AND sd.age >= #{startAge}</if> |
| | | <if test="endAge !=null">AND sd.age <= #{endAge} |
| | | </if> |
| | | <if test="idcardno != null and idcardno != ''">and IDCardNo = #{idcardno}</if> |
| | | <if test="recordstate != null and recordstate != ''">and sd.RecordState = #{recordstate}</if> |
| | | <if test="workflow != null">and sd.workflow = #{workflow}</if> |
| | | <if test="diagnosisName != null">and sd.DiagnosisName like concat('%', #{diagnosisName}, '%')</if> |
| | | </where> |
| | | |
| | | ORDER BY sd.ReportTime DESC |
| | | <if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if> |
| | | |
| | | </select> |
| | | </mapper> |
| | |
| | | sd.treatmenthospitalno AS treatmenthospitalno, |
| | | sd.DonorNo AS donorno, |
| | | sd.case_no AS caseNo, |
| | | sd.DonationCategory as donationcategory, |
| | | sd.NAME AS name, |
| | | sd.RecordState AS recordstate, |
| | | sd.Sex AS sex, |
| | |
| | | LEFT JOIN service_donatecompletioninfo sdc ON sd.ID = sdc.InfoID |
| | | AND sd.del_flag = 0 |
| | | AND sdc.del_flag = 0 |
| | | and sdc.ID is not null |
| | | <where> |
| | | sd.termination_case = 0 |
| | | <if test="name != null and name != ''">and sd.Name like concat('%', #{name}, '%')</if> |
| | | <if test="inpatientno != null and inpatientno != ''">and sd.inpatientno = #{inpatientno}</if> |
| | | <if test="donorno != null and donorno != ''">and sdc.DonorNo = #{donorno}</if> |
| | |
| | | </sql> |
| | | |
| | | <select id="selectServiceDonatemaintenanceList" parameterType="com.ruoyi.project.domain.ServiceDonatemaintenance" |
| | | resultMap="ServiceDonatemaintenanceResult"> |
| | | <include refid="selectServiceDonatemaintenanceVo"/> |
| | | resultType="com.ruoyi.project.domain.dto.DonationCompletionBaseInfoDTO"> |
| | | select |
| | | sd.treatmenthospitalname AS treatmenthospitalname, |
| | | sd.treatmenthospitalno AS treatmenthospitalno, |
| | | sd.DonorNo AS donorno, |
| | | sd.DonationCategory as donationcategory, |
| | | sd.case_no AS caseNo, |
| | | sd.NAME AS name, |
| | | sd.RecordState AS recordstate, |
| | | sd.Sex AS sex, |
| | | sd.Age AS age, |
| | | sd.BloodType AS bloodtype, |
| | | sd.idcardno AS idcardno, |
| | | sd.diagnosisname AS diagnosisname, |
| | | sdm.id AS infoid, |
| | | sdm.item_no as itemNo, |
| | | sdm.item_name as itemName, |
| | | sdm.item_time as itemTime, |
| | | sdm.item_desc as itemDesc |
| | | FROM |
| | | service_donatebaseinfo sd |
| | | LEFT JOIN service_donatemaintenance sdm ON sd.ID = sdm.InfoID |
| | | AND sd.del_flag = 0 |
| | | AND sdm.del_flag = 0 |
| | | and sdm.ID is not null |
| | | <where> |
| | | del_flag=0 |
| | | sd.termination_case = 0 |
| | | <if test="infoid != null ">and InfoID = #{infoid}</if> |
| | | <if test="caseNo != null and caseNo != ''">and case_no = #{caseNo}</if> |
| | | <if test="donorno != null and donorno != ''">and DonorNo = #{donorno}</if> |
| | | <if test="name != null and name != ''">and name = #{name}</if> |
| | | <if test="coordinatorName != null and coordinatorName != ''">and coordinator_name = #{coordinatorName}</if> |
| | | <if test="itemNo != null and itemNo != ''">and item_no = #{itemNo}</if> |
| | | <if test="itemName != null and itemName != ''">and item_name like concat('%', #{itemName}, '%')</if> |
| | | <if test="itemTime != null ">and item_time = #{itemTime}</if> |
| | |
| | | sd.treatmenthospitalname AS treatmenthospitalname, |
| | | sd.treatmenthospitalno AS treatmenthospitalno, |
| | | sd.DonorNo AS donorno, |
| | | sd.DonationCategory as donationcategory, |
| | | sd.case_no AS caseNo, |
| | | sd.Name AS NAME, |
| | | sd.Sex AS sex, |
| | |
| | | service_donatebaseinfo sd |
| | | LEFT JOIN service_donateorgan_base sdb ON sd.ID = sdb.InfoID and sd.del_flag = 0 |
| | | and sdb.del_flag = 0 |
| | | and sdb.ID is not null |
| | | <where> |
| | | |
| | | sd.termination_case = 0 |
| | | <if test="donorno != null and donorno != ''">and sd.DonorNo = #{donorno}</if> |
| | | <if test="treatmenthospitalname != null and treatmenthospitalname != ''">and sd.treatmenthospitalname like |
| | | concat('%', #{treatmenthospitalname}, '%') |
| | |
| | | select |
| | | sd.treatmenthospitalname AS treatmenthospitalname, |
| | | sd.treatmenthospitalno AS treatmenthospitalno, |
| | | sd.DonationCategory as donationcategory, |
| | | sd.DonorNo AS donorno, |
| | | sd.case_no AS caseNo, |
| | | sd.NAME AS name, |
| | |
| | | FROM |
| | | service_donatebaseinfo sd |
| | | LEFT JOIN service_donationwitness st ON sd.ID = st.InfoID |
| | | and st.ID is not null |
| | | AND sd.del_flag = 0 |
| | | AND st.del_flag = 0 |
| | | <where> |
| | | sd.termination_case = 0 |
| | | |
| | | <if test="name != null and name != ''">and sd.Name like concat('%', #{name}, '%')</if> |
| | | <if test="inpatientno != null and inpatientno != ''">and sd.inpatientno = #{inpatientno}</if> |
| | | <if test="donorno != null and donorno != ''">and st.DonorNo = #{donorno}</if> |
| | |
| | | SELECT |
| | | sd.treatmenthospitalname as treatmenthospitalname, |
| | | sd.treatmenthospitalno as treatmenthospitalno, |
| | | sd.DonationCategory as donationcategory, |
| | | sd.DonorNo as donorno, |
| | | sd.case_no as caseNo, |
| | | sd.Name as name, |
| | |
| | | FROM |
| | | service_donatebaseinfo sd |
| | | LEFT JOIN service_ethicalreviewinitiate se ON sd.ID = se.InfoID and sd.del_flag = 0 |
| | | AND se.del_flag = 0 |
| | | AND se.del_flag = 0 and se.ID is not null |
| | | <where> |
| | | sd.termination_case = 0 |
| | | |
| | | <if test="infoid != null ">and se.InfoID = #{infoid}</if> |
| | | <if test="caseNo != null and caseNo != ''">and sd.case_no = #{caseNo}</if> |
| | | <if test="expertConclusion != null ">and se.expert_conclusion = #{expertConclusion}</if> |
| | |
| | | <result property="assessTime" column="assess_time"/> |
| | | <result property="assessState" column="assess_state"/> |
| | | <result property="assessannex" column="AssessAnnex"/> |
| | | <result property="donationcategory" column="donationcategory"/> |
| | | </resultMap> |
| | | |
| | | <sql id="selectServiceMedicalevaluationVo"> |
| | |
| | | SELECT |
| | | sb.TreatmentHospitalName, |
| | | sb.TreatmentHospitalNo, |
| | | sb.DonationCategory as donationcategory, |
| | | sb.DonorNo, |
| | | sb.case_no, |
| | | sb.Name, |
| | |
| | | sb.id as infoID, |
| | | sm.ID, |
| | | sm.assessannex, |
| | | sm.assess_time, |
| | | sm.assess_state |
| | | FROM service_donatebaseinfo sb |
| | | LEFT JOIN service_medicalevaluation sm ON sb.ID = sm.InfoID and sm.del_flag = 0 |
| | | and sb.del_flag = 0 |
| | | and sb.del_flag = 0 and sm.ID is not null |
| | | <where> |
| | | sb.termination_case = 0 |
| | | <if test="infoid != null">AND sm.InfoID = #{infoid}</if> |
| | | <if test="caseNo != null and caseNo != ''">AND sm.case_no = #{caseNo}</if> |
| | | <if test="donorno != null and donorno != ''">AND sm.DonorNo = #{donorno}</if> |