From 43727df73e52cc00a1f1aee3c20a1aec8db1b92f Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 27 二月 2025 08:45:25 +0800
Subject: [PATCH] 修改查询
---
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjProjectServiceImpl.java | 127 +++++++++++++++++++++++++++++++++++++++++-
1 files changed, 124 insertions(+), 3 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjProjectServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjProjectServiceImpl.java
index 24cb385..f02d8eb 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjProjectServiceImpl.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjProjectServiceImpl.java
@@ -1,17 +1,17 @@
package com.ltkj.hosp.service.impl;
import java.math.BigDecimal;
-import java.util.ArrayList;
-import java.util.Iterator;
-import java.util.List;
+import java.util.*;
import java.util.stream.Collectors;
+import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ltkj.common.utils.DateUtils;
import com.ltkj.common.utils.StringUtils;
import com.ltkj.common.utils.spring.SpringUtils;
import com.ltkj.hosp.treeUtil.TreeSelect;
+import net.sf.ehcache.constructs.scheduledrefresh.OverseerJob;
import org.springframework.stereotype.Service;
import com.ltkj.hosp.mapper.TjProjectMapper;
import com.ltkj.hosp.domain.TjProject;
@@ -156,6 +156,9 @@
@Override
public List<TreeSelect> selectProjectTreeList(TjProject tjProject) {
LambdaQueryWrapper<TjProject> wq=new LambdaQueryWrapper<>();
+ wq.eq(TjProject::getProStatus,0);
+ if(StrUtil.isNotBlank(tjProject.getProName()))wq.like(TjProject::getProName,tjProject.getProName());
+ if(StrUtil.isNotBlank(tjProject.getProEngName()))wq.like(TjProject::getProEngName,tjProject.getProEngName());
List<TjProject> projects = SpringUtils.getAopProxy(this).list(wq);
return buildProjectTreeSelect(projects);
}
@@ -190,6 +193,73 @@
public List<TjProject> getProBySqlAndName(String proName, String checkType, String deptId) {
return tjProjectMapper.getProBySqlAndName(proName,checkType,deptId);
}
+
+ @Override
+ public List<TjProject> getTjProListByPacIdAndDeptId(String pacId) {
+ return tjProjectMapper.getTjProListByPacIdAndDeptId(pacId);
+ }
+
+ @Override
+ public List<TjProject> getAllChildListById(String proId) {
+ return tjProjectMapper.getAllChildListById(proId);
+ }
+
+ @Override
+ public List<TjProject> getTjProjectList() {
+ return tjProjectMapper.getTjProjectList();
+ }
+
+ @Override
+ public List<TjProject> getDxTjProjectList() {
+ return tjProjectMapper.getDxTjProjectList();
+ }
+
+ @Override
+ public List<TjProject> getOpenDxTjProjectList(String nr) {
+ return tjProjectMapper.getOpenDxTjProjectList(nr);
+ }
+
+ @Override
+ public List<TjProject> getPacTjProjectList() {
+ return tjProjectMapper.getPacTjProjectList();
+ }
+
+ @Override
+ public List<Long> getHuaYanProId() {
+ return tjProjectMapper.getHuaYanProId();
+ }
+
+ @Override
+ public List<Long> getYingXiangProId() {
+ return tjProjectMapper.getYingXiangProId();
+ }
+
+ @Override
+ public List<Long> getHuaYanKsProId(String ksId) {
+ return tjProjectMapper.getHuaYanKsProId(ksId);
+ }
+
+ @Override
+ public List<Long> getNotCcCtXdtProId() {
+ return tjProjectMapper.getNotCcCtXdtProId();
+ }
+
+ @Override
+ public List<Long> getNneedReprotProId() {
+ return tjProjectMapper.getNneedReprotProId();
+ }
+
+ @Override
+ public List<TjProject> getTjProjectListByTbTransition(String proParentId, String tjNumber) {
+ return tjProjectMapper.getTjProjectListByTbTransition(proParentId,tjNumber);
+ }
+
+ @Override
+ public List<String> getTjNumLIstByXmmx(String xmmc) {
+ return tjProjectMapper.getTjNumLIstByXmmx(xmmc);
+ }
+
+
/**
* 閫掑綊鍒楄〃
@@ -226,4 +296,55 @@
private boolean hasChild(List<TjProject> list, TjProject t) {
return getChildList(list, t).size() > 0;
}
+
+
+ @Override
+ public List<Map<String,Object>> tjCsXmjgcx(String tjNum, String proId) {
+
+ Map<String,Object> map=new HashMap<>();
+ map.put("tjnum",tjNum);
+ map.put("proid",proId);
+ return tjProjectMapper.tjCsXmjgcx(map);
+ }
+
+ @Override
+ public List<Map<String, Object>> getTjproGzJy(String tjNum, String proId, String gzz, int cgorjyjc) {
+ Map<String,Object> map=new HashMap<>();
+ map.put("tjnum",tjNum);
+ map.put("proid",proId);
+ map.put("jgz",gzz);
+ map.put("cgorjyjc",cgorjyjc);
+ return tjProjectMapper.getTjproGzJy(map);
+ }
+
+ @Override
+ public Map<String,Object> getTjHyBgList(Integer page,Integer pageSize,String pname,String pid,String pym,String checktype) {
+ Map<String,Object> map=new HashMap<>();
+ map.put("page",page);
+ map.put("pageSize",pageSize);
+ map.put("pname",pname);
+ map.put("pid",pid);
+ map.put("pym",pym);
+ map.put("checktype",checktype);
+ List<List<?>> list = tjProjectMapper.getTjHyBgList(map);
+ Map<String,Object> map1=new HashMap<>();
+ map1.put("list",list);
+ map1.put("total",map.get("total"));
+ return map1;
+ }
+
+ @Override
+ public List<Map<String, Object>> zdysqlcx(String sql) {
+ Map<String,Object> map=new HashMap<>();
+ map.put("aaa",sql);
+ return tjProjectMapper.zdysqlcx(map);
+ }
+
+ @Override
+ public void zdysqlxg(String sql) {
+ Map<String,Object> map=new HashMap<>();
+ map.put("aaa",sql);
+ tjProjectMapper.zdysqlxg(map);
+ }
+
}
--
Gitblit v1.8.0