ltkj-admin/src/main/java/com/ltkj/web/controller/system/DictCompController.java
@@ -52,6 +52,14 @@ return AjaxResult.success(dictCompService.list()); } @GetMapping("/getZybCompList") @ApiOperation(value = "获取职业病单位信息集合接口") public AjaxResult getZybCompList() { LambdaQueryWrapper<DictComp> wq = new LambdaQueryWrapper<>(); wq.eq(DictComp::getDwlx,"1"); return AjaxResult.success(dictCompService.list(wq)); } /** * 查询体检单位信息维护列表 */ ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjProjectController.java
@@ -713,4 +713,53 @@ @GetMapping("/getProListByBwwh") @ApiOperation(value = "查询部位对应项目或未对应部位的项目") public AjaxResult getProListByBwwh(@ApiParam(value = "标本类型")@RequestParam(required = false) String bw) { try { List<TjProject> projectList =tjProjectService.getProListByBwwh(bw); return AjaxResult.success(projectList); } catch (Exception e) { throw new RuntimeException(e); } } @GetMapping("/delProByBbwwh") @ApiOperation(value = "删除项目对应部位") @Transactional public AjaxResult delProByBbwwh(@ApiParam(value = "项目ID")@RequestParam(required = false) String proId) { try { TjProject tjProject = tjProjectService.getById(proId); tjProject.setCheckBw(null); tjProjectService.updateById(tjProject); return AjaxResult.success(); } catch (Exception e) { throw new RuntimeException(e); } } @PostMapping("/updateProByBwwh") @ApiOperation(value = "修改所选项目的部位") @Transactional public AjaxResult updateProByBwwh(@ApiParam(value = "项目ID集合")@RequestParam(required = false) List<String> proIds, @ApiParam(value = "标本类型")@RequestParam(required = false)String bw) { try { if(null != proIds && !proIds.isEmpty()){ for (String proId : proIds) { TjProject tjProject = tjProjectService.getById(proId); tjProject.setCheckBw(bw); tjProjectService.updateById(tjProject); } } return AjaxResult.success(); } catch (Exception e) { throw new RuntimeException(e); } } } ltkj-hosp/src/main/java/com/ltkj/hosp/domain/DictComp.java
@@ -226,6 +226,14 @@ @Excel(name = "五笔简码") private String wbm; private String dwlx; private String ssdq; private String lsgx; private String jjlx; private String qygm; private String hyfl; private String fxpg; @TableField(exist = false) @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date startTime; ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjProject.java
@@ -235,6 +235,7 @@ private String specimenType; @ApiModelProperty(value = "检查部位") @TableField(updateStrategy = FieldStrategy.IGNORED) private String checkBw; ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjReservation.java
@@ -81,8 +81,8 @@ * 出生日期 */ @JsonFormat(pattern = "yyyy-MM-dd") @ExcelExport(value = "出生日期",sort =6) @ExcelImport("出生日期") // @ExcelExport(value = "出生日期",sort =6) // @ExcelImport("出生日期") @Excel(name = "出生日期",sort = 6,dateFormat = "yyyy/MM/dd") @ApiModelProperty("出生日期") private Date birthday; ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java
@@ -203,4 +203,8 @@ @Select("call getProListByBblx(#{bblx,mode=IN}) ") List<TjProject> getProListByBblx(@Param(value ="bblx")String bblx); @Select("call getProListByBwwh(#{bw,mode=IN}) ") List<TjProject> getProListByBwwh(String bw); } ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjProjectService.java
@@ -144,4 +144,6 @@ void zdysqlxg(String sql); List<TjProject> getProListByBblx(String bblx); List<TjProject> getProListByBwwh(String bw); } ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjProjectServiceImpl.java
@@ -352,4 +352,9 @@ return tjProjectMapper.getProListByBblx(bblx); } @Override public List<TjProject> getProListByBwwh(String bw) { return tjProjectMapper.getProListByBwwh(bw); } }