zjh 本地 2023/12/22 -1

zjh

2023-12-22 4ccd96e52b9815ddfd5528fbebc6560042ec189b

zjh 本地 2023/12/22 -1

 ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java

@@ -75,6 +75,19 @@
    private ITjOrderService orderService;
    @Resource
    private ISysDeptService deptService;


    @GetMapping("/newGetTjPat")
    @ApiOperation(value = "新的查询体检信息接口")
    public AjaxResult newGetTjPat() {
        List<Map<String, Object>> maps = testMapper.newGetTjPat();
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(maps);
    }




    @GetMapping("/getRedisValue")
    @ApiOperation(value = "测试redis模糊查询")
    public AjaxResult getRedisValue(@RequestParam int aa,

 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCustomerController.java

@@ -10,8 +10,9 @@
import com.ltkj.framework.datasource.DynamicDataSourceContextHolder;
import com.ltkj.hosp.domain.TjReservation;
import com.ltkj.hosp.mapper.TestMapper;
import com.ltkj.hosp.service.ITjReservationService;
import com.ltkj.hosp.service.TjvLtkjvtjpatService;
import com.ltkj.hosp.service.*;
import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail;
import com.ltkj.hosp.sqlDomain.LtkjMiddleHead;
import com.ltkj.hosp.sqlDomain.LtkjTjPat;
import com.ltkj.system.service.ISysConfigService;
import io.swagger.annotations.Api;
@@ -25,13 +26,13 @@
import com.ltkj.common.core.domain.AjaxResult;
import com.ltkj.common.enums.BusinessType;
import com.ltkj.hosp.domain.TjCustomer;
import com.ltkj.hosp.service.ITjCustomerService;
import com.ltkj.common.utils.poi.ExcelUtil;
import com.ltkj.common.core.page.TableDataInfo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;


/**
@@ -57,6 +58,18 @@
    private TestMapper testMapper;
    @Resource
    private TjvLtkjvtjpatService tjvLtkjvtjpatService;
    @Resource
    private LtkjMiddleHeadService headService;
    @Resource
    private LtkjMiddleDetailService middleDetailService;

    @GetMapping("/newGetTjPat")
    @ApiOperation(value = "查询his数据库返回新的数据")
    public AjaxResult newGetTjPat() {
        List<Map<String, Object>> maps = testMapper.newGetTjPat();
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(maps);
    }



@@ -105,9 +118,11 @@
                    qw.eq(TjCustomer::getCusIdcard, cusIdcard);
                    TjCustomer customer = tjCustomerService.getOne(qw);
                    customer.setReservationId(customer.getCardId());
                    extracted(customer);
                    return success(customer);
                }else {
                    tjCustomer.setReservationId(tjCustomer.getCardId());
                    extracted(tjCustomer);
                    return success(tjCustomer);
                }

@@ -194,6 +209,24 @@
        return error("身份证号不存在");
    }

    private void extracted(TjCustomer customer) {
        LtkjMiddleHead pat = testMapper.getMiddleHeadByPartId(customer.getCardId());
        if (null != pat) {
            List<LtkjMiddleDetail> list = testMapper.getMiddleDetailByFeadId(pat.getFeadId());
            DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
            LtkjMiddleHead o = headService.getMiddleHeadByPartId(customer.getCardId());
            if(o==null){
                headService.save(pat);
                for (LtkjMiddleDetail ltkjMiddleDetail : list) {
                    middleDetailService.save(ltkjMiddleDetail);
                }
                testMapper.saveTjProByCusId(customer.getCardId(), customer.getCusIdcard());
            }
            testMapper.saveTjProByCusId(customer.getCardId(), customer.getCusIdcard());
        }
        DynamicDataSourceContextHolder.clearDataSourceType();
    }


    /**
     * 查询客户信息列表

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java

@@ -9,6 +9,7 @@
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * @Company: 西安路泰科技有限公司
@@ -42,8 +43,15 @@
    @Select("SELECT * FROM histjv_LTKJVTJPAT")
    public List<LtkjTjPat> getTjPat();

    @DataSource(value = DataSourceType.SLAVE_PACS)
    @Select("select fcard_iD xh,fcard_no pacCode,pat_name pacName,\n" +
            " (case when patsex_id='0' then '男' when patsex_id='1' then '女' else '未知' end )+';'+brnl detail,\n" +
            " pat_id price , mobile pacRemark\n" +
            "  from histjv_ltkjvtjpat")
    public List<Map<String,Object>> newGetTjPat();

    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM histjv_LTKJVTJPAT where Ltrim(Rtrim(fcard_no)) = #{id} ")
    @Select("SELECT * FROM histjv_LTKJVTJPAT where Ltrim(Rtrim(fcard_no)) = #{id} or Ltrim(Rtrim(fcard_id))=#{id} ")
    public LtkjTjPat getTjPatByIdCard(String id);