ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java
@@ -9,6 +9,7 @@ import com.ltkj.hosp.mapper.TestMapper; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.checkerframework.checker.units.qual.A; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; @@ -192,4 +193,11 @@ DynamicDataSourceContextHolder.clearDataSourceType(); return AjaxResult.success(save); } @GetMapping("/getTjPatByCusId") public AjaxResult getTjPatByCusId(String cusId) { testMapper.getTjPatByCusId(cusId); return AjaxResult.success(); } } ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCustomerController.java
@@ -7,7 +7,10 @@ import com.ltkj.common.utils.bean.BeanUtils; import com.ltkj.framework.config.MatchUtils; import com.ltkj.hosp.domain.TjReservation; import com.ltkj.hosp.mapper.TestMapper; import com.ltkj.hosp.service.ITjReservationService; import com.ltkj.hosp.sqlDomain.LtkjTjPat; import com.ltkj.system.service.ISysConfigService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import io.swagger.annotations.ApiParam; @@ -44,6 +47,12 @@ @Resource private ITjReservationService tjReservationService; @Resource private ISysConfigService sysConfigService; @Resource private TestMapper testMapper; /** @@ -66,6 +75,19 @@ return AjaxResult.error("身份证号码错误"); } } //根据配置调取存储过程 将临时表数据存入预约表2023.12.12 final String getInfoFromSqlData = sysConfigService.selectConfigByKey("getInfoFromSqlData"); if ("Y".equals(getInfoFromSqlData)){ final LtkjTjPat tjPatByIdCard = testMapper.getTjPatByIdCard(cusIdcard); if (tjPatByIdCard!=null){ testMapper.getTjPatByCusId(cusIdcard); }else { return error("身份证号不存在"); } } //end2023.12.12 LambdaQueryWrapper<TjReservation> wq = new LambdaQueryWrapper<>(); wq.eq(TjReservation::getIdCard, cusIdcard); wq.eq(TjReservation::getIsExpire, 2); @@ -98,13 +120,14 @@ tjCustomer1.setAgeUnit(tjReservation.getAgeUnit()); tjCustomer1.setCareer(tjReservation.getCareer()); tjCustomerService.updateById(tjCustomer1); tjCustomer1.setTeamNo(tjReservation.getTeamNo()); tjCustomer1.setCompId(tjReservation.getCompanyId()); tjCustomer1.setReservationId(tjReservation.getId()); tjCustomer1.setDiscount(tjReservation.getDiscount()); tjCustomer1.setGroupingId(tjReservation.getGroupingId()); return success(tjCustomer1); } TjCustomer tjCustomer = new TjCustomer(); @@ -122,7 +145,9 @@ tjCustomer.setAge(tjReservation.getAge()); tjCustomer.setAgeUnit(tjReservation.getAgeUnit()); tjCustomer.setCareer(tjReservation.getCareer()); tjCustomer.setDwPhone(tjReservation.getDwPhone()); tjCustomer.setCardId(tjReservation.getCardId()); tjCustomer.setIndexCard(tjReservation.getIndexCard()); //截取密码自动生成set进去 String substring = cusIdcard.substring(cusIdcard.length() - 6); ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjCustomer.java
@@ -304,6 +304,12 @@ @TableField(exist = false) private String tjCategory; @ApiModelProperty("座机") private String dwPhone; @ApiModelProperty("就诊编号") private String cardId; @Override public String toString() { ltkj-hosp/src/main/java/com/ltkj/hosp/domain/TjReservation.java
@@ -305,6 +305,15 @@ @TableField(exist = false) private Integer tjStatus; @ApiModelProperty("座机") private String dwPhone; @ApiModelProperty("就诊编号") private String cardId; @ApiModelProperty("索引卡号") private String indexCard; @Override ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java
@@ -34,6 +34,15 @@ public List<LtkjTjPat> getTjPat(); @DataSource(value = DataSourceType.SLAVE_HIS) @Select("SELECT * FROM tjv_LTKJVTJPAT where fcard_no=#{id}") public LtkjTjPat getTjPatByIdCard(String id); @DataSource(value = DataSourceType.MASTER) @Select("call pro_his_tjpart(#{sfzh,mode=IN})") public void getTjPatByCusId(String cusId); @DataSource(value = DataSourceType.SLAVE_HIS) @Select("SELECT * FROM tjv_exam_jcbgd") public List<LtkjExamJcbgd> getExamJcbgd();