总检页面增加体检类型搜索调整了存储过程

zhaowenxuan

2025-05-19 f2162e182405184e14bfa8d628150ccc49318fc3

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderServiceImpl.java

@@ -5,18 +5,16 @@
import cn.hutool.core.date.DateUtil;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ltkj.common.utils.DateUtils;
import com.ltkj.hosp.domain.DictComp;
import com.ltkj.hosp.domain.TjCustomer;
import com.ltkj.hosp.domain.TjPackage;
import com.ltkj.hosp.domain.*;
import com.ltkj.hosp.service.IDictCompService;
import com.ltkj.hosp.service.ITjCustomerService;
import com.ltkj.hosp.service.ITjOrderService;
import com.ltkj.hosp.service.ITjPackageService;
import com.ltkj.hosp.vodomain.LineChartsVo;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ltkj.hosp.mapper.TjOrderMapper;
import com.ltkj.hosp.domain.TjOrder;
import org.springframework.transaction.annotation.Transactional;

/**
@@ -26,6 +24,7 @@
 * @date 2022-11-21
 */
@Service
@Slf4j
public class TjOrderServiceImpl extends ServiceImpl<TjOrderMapper, TjOrder> implements ITjOrderService {
    @Autowired
    private TjOrderMapper tjOrderMapper;
@@ -69,7 +68,7 @@
     */
    @Override
    public List<TjOrder> selectExportOrderList(TjOrder tjOrder) {
        List<TjOrder> tjOrders = tjOrderMapper.selectExportOrderList(tjOrder);
        List<TjOrder> tjOrders = tjOrderMapper.selectTjOrderList(tjOrder);
        for (TjOrder order : tjOrders) {
            if (order.getUserId()!=null){
                TjCustomer byId = customerService.getById(order.getUserId());
@@ -179,6 +178,11 @@
    }

    @Override
    public TjOrder getOrderByCardId(String cardId) {
        return tjOrderMapper.getOrderByCardId(cardId);
    }

    @Override
    public List<TjOrder> getTjOrderList(String tjNum, Integer checkStatus, Long compId, Date beginTime, Date endTime) {
        return tjOrderMapper.getTjOrderList(tjNum,checkStatus,compId,beginTime,endTime);
    }
@@ -222,7 +226,7 @@

    @Override
    public Map<String,Object> getCunChuGuoChengCustomerList(String tjNumber, Integer page, Integer pageSize, Integer checkStatus,
                                                          String compId, String beginTime, String endTime, String tjname) {
                                                          String compId, String beginTime, String endTime, String tjname,String tjCategory) {

        Map<String, Object> map = new HashMap<>();
        map.put("checkStatus",checkStatus);
@@ -233,6 +237,7 @@
        map.put("tjname",tjname);
        map.put("beginTime",beginTime);
        map.put("endTime",endTime);
        map.put("p_tjCategory",tjCategory);
        List<List<?>> list = tjOrderMapper.getCunChuGuoChengCustomerList(map);
        Map<String,Object> map1=new HashMap<>();
        map1.put("customers",list);
@@ -242,7 +247,8 @@
    }

    @Override
    public Map<String, Object> getCsCunChuGuoChengCustomerList(String tjNumber, Integer page, Integer pageSize, Integer checkStatus, String compId, String beginTime, String endTime, String tjname) {
    public Map<String, Object> getCsCunChuGuoChengCustomerList(String tjNumber, Integer page, Integer pageSize,
                                                               Integer checkStatus, String compId, String beginTime, String endTime, String tjname,String tcm) {
        Map<String, Object> map = new HashMap<>();
        map.put("checkStatus",checkStatus);
        map.put("page",page);
@@ -250,6 +256,7 @@
        map.put("tjNumber",tjNumber);
        map.put("compId",compId);
        map.put("tjname",tjname);
        map.put("tcm",tcm);
        map.put("beginTime",beginTime);
        map.put("endTime",endTime);
        List<List<?>> list = tjOrderMapper.getCsCunChuGuoChengCustomerList(map);
@@ -275,12 +282,201 @@
    }

    @Override
    public List<Map<String, String>> selectDjdInfo(String tjNumber) {
    public List<Map<String, Object>> selectDjdInfo(String tjNumber) {
        log.info("传递进来的体检号为: "+tjNumber);
        return tjOrderMapper.selectDjdInfo(tjNumber);
    }

    @Override
    public Map<String, Object> selectDjdUserInfo(String tjNumber) {
        log.info("传递进来的体检号为: "+tjNumber);
        return tjOrderMapper.selectDjdUserInfo(tjNumber);
    }

    @Override
    public List<String> getHuoQuJcsqdh(String cardId) {
        return tjOrderMapper.getHuoQuJcsqdh(cardId);
    }

    @Override
    public Boolean delHuoQuJcsqdh(String cardId) {
        return tjOrderMapper.delHuoQuJcsqdh(cardId);
    }

    @Override
    public List<String> getHuoQuJysqdh(String cardId) {
        return tjOrderMapper.getHuoQuJysqdh(cardId);
    }

    @Override
    public Boolean delHuoQuJysqdh(String cardId) {
        return tjOrderMapper.delHuoQuJysqdh(cardId);
    }

    @Override
    public List<String> getHuoQuZlsqdh(String cardId) {
        return tjOrderMapper.getHuoQuZlsqdh(cardId);
    }

    @Override
    public Boolean delHuoQuZlsqdh(String cardId) {
        return tjOrderMapper.delHuoQuZlsqdha(cardId);
    }

    @Override
    public List<Map<String, Object>> getTjTongJiJieKou(Map<String, Object> map) {
        return tjOrderMapper.getTjTongJiJieKou(map);
    }

    @Override
    public List<String> getHuoQuBlJcsqdh(String cardId, String bldh) {
        return tjOrderMapper.getHuoQuBlJcsqdh(cardId,bldh);
    }

    @Override
    public Boolean delHuoQuBlJcsqdh(String cardId, String bldh) {
        return tjOrderMapper.delHuoQuBlJcsqdh(cardId,bldh);
    }

    @Override
    public List<String> getHuoQuBlJysqdh(String cardId, String bldh) {
        return tjOrderMapper.getHuoQuBlJysqdh(cardId,bldh);
    }

    @Override
    public Boolean delHuoQuBlJysqdh(String cardId, String bldh) {
        return tjOrderMapper.delHuoQuBlJysqdh(cardId,bldh);
    }

    @Override
    public List<String> getHuoQuBlZlsqdh(String cardId, String bldh) {
        return tjOrderMapper.getHuoQuBlZlsqdh(cardId,bldh);
    }

    @Override
    public Boolean delHuoQuZlsqdh(String cardId, String bldh) {
        return tjOrderMapper.delHuoQuZlsqdh(cardId,bldh);
    }

    @Override
    public int getOrderCountByTjNum(String tjNum) {
        return tjOrderMapper.getOrderCountByTjNum(tjNum);
    }

    @Override
    public Map<String, Object> getgetBghsList(String tjNumber, Integer page, Integer pageSize,
                                              String compId, String beginTime, String endTime, String tjname) {
        Map<String, Object> map = new HashMap<>();
        map.put("page",page);
        map.put("pageSize",pageSize);
        map.put("tjNumber",tjNumber);
        map.put("compId",compId);
        map.put("tjname",tjname);
        map.put("beginTime",beginTime);
        map.put("endTime",endTime);
        List<List<?>> list = tjOrderMapper.getgetBghsList(map);
        Map<String,Object> map1=new HashMap<>();
        map1.put("customers",list);
        map1.put("total",map.get("total"));
        return map1;
    }

    @Override
    public List<LtkjJianchajianyanTree> getBuLuXmXinXi(List<String> bldh,String cardId) {
        return tjOrderMapper.getBuLuXmXinXi(bldh,cardId);
    }

    @Override
    public List<String> getBljcsqdhByPacs(String cardId, String bldh) {
        return tjOrderMapper.getBlJcsqdhByPacsAndBldh(cardId,bldh);
    }

    @Override
    public List<String> getBljysqdhByLis(String cardId, String bldh) {
        return tjOrderMapper.getBlJysqdhByLisAndBldh(cardId,bldh);
    }

    @Override
    public List<String> getBljcsqdhByPacs(String cardId) {
        return tjOrderMapper.getBlJcsqdhByPacs(cardId);
    }

    @Override
    public List<String> getBljysqdhByLis(String cardId) {
        return tjOrderMapper.getBlJysqdhByLis(cardId);
    }

    @Override
    public List<String> getDingShiTongBuJianYanTjNum() {
        return tjOrderMapper.getDingShiTongBuJianYanTjNum();
    }

    @Override
    public List<String> getDingShiTongBuJianChaTjNum() {
        return tjOrderMapper.getDingShiTongBuJianChaTjNum();
    }

    @Override
    public List<String> getJianChaTjNum() {
        return tjOrderMapper.getJianChaTjNum();
    }

    @Override
    public void tjQiandaodengji(String tjNum) {
        Map<String, Object> map = new HashMap<>();
        map.put("tjNum",tjNum);
        tjOrderMapper.tjQiandaodengji(map);
    }

    @Override
    public void tjLispacstongbujianyi(String tjNumber, Long deptId, String nickName, Long userId) {
        Map<String, Object> map = new HashMap<>();
        map.put("tjNum",tjNumber);
        map.put("ksId",deptId.toString());
        map.put("ysxm",nickName);
        map.put("ysid",userId.toString());
        tjOrderMapper.tjLispacstongbujianyi(map);
    }

    @Override
    public Map<String, Object> getTjBgdyList(Integer pageNum, Integer pageSize, Integer dyzt,
                                             String tjNum, String name, String dw, String djbeginTime, String djendTime) {

        Map<String, Object> map = new HashMap<>();
        map.put("page",pageNum);
        map.put("pageSize",pageSize);
        map.put("dyzt",dyzt.toString());
        map.put("tjNumber",tjNum);
        map.put("dw",dw);
        map.put("tjname",name);
        map.put("beginTime",djbeginTime);
        map.put("endTime",djendTime);
//        map.put("total",userId.toString());
        List<List<?>> list =   tjOrderMapper.getTjBgdyList(map);
        Map<String,Object> map1=new HashMap<>();
        map1.put("list",list);
        map1.put("total",map.get("total"));
        return map1;
    }

    @Override
    public Map<String, Object> getYxJcList(Integer checkStatus ,String tjNumber, Integer page, Integer pageSize,
                                           String compId, String beginTime, String endTime, String tjname,String tcm,String deptId) {
        Map<String, Object> map = new HashMap<>();
        map.put("checkStatus",checkStatus);
        map.put("page",page);
        map.put("pageSize",pageSize);
        map.put("tjNumber",tjNumber);
        map.put("compId",compId);
        map.put("tjname",tjname);
        map.put("tcm",tcm);
        map.put("beginTime",beginTime);
        map.put("endTime",endTime);
        map.put("ks",deptId);
        List<List<?>> list = tjOrderMapper.getYxJcList(map);
        Map<String,Object> map1=new HashMap<>();
        map1.put("customers",list);
        map1.put("total",map.get("total"));
        return map1;
    }
}