From bd992b57fe7cc9ccc54affc75d3c869b15261b92 Mon Sep 17 00:00:00 2001
From: lige <bestlige@outlook.com>
Date: 星期二, 23 一月 2024 09:23:26 +0800
Subject: [PATCH] 报告 异常

---
 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjProjectController.java |   59 +++++++++++++++++++++++++++++++++++++++++------------------
 1 files changed, 41 insertions(+), 18 deletions(-)

diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjProjectController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjProjectController.java
index b94ca7d..2661014 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjProjectController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjProjectController.java
@@ -12,7 +12,9 @@
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.ltkj.common.core.domain.entity.SysDept;
 import com.ltkj.common.utils.bean.BeanUtils;
+import com.ltkj.framework.datasource.DynamicDataSourceContextHolder;
 import com.ltkj.hosp.domain.*;
+import com.ltkj.hosp.mapper.TestMapper;
 import com.ltkj.hosp.service.*;
 import com.ltkj.hosp.treeUtil.TreeSelect;
 import com.ltkj.system.service.ISysConfigService;
@@ -57,6 +59,20 @@
     private DictProSfxmService dictProSfxmService;
     @Autowired
     private ITjRulesService tjRulesService;
+    @Resource
+    private TestMapper testMapper;
+
+
+    @GetMapping("/getTjHyBgList")
+    @ApiOperation(value = "鏌ヨlis鏁版嵁搴撻」鐩俊鎭帴鍙�")
+    public AjaxResult getTjHyBgList(@RequestParam(required = false)String pacCode,
+                                  @RequestParam(required = false)String pacName,
+                                  @RequestParam(required = false)String pacRemark) {
+        List<Map<String, Object>> maps = testMapper.getTjHyBgList(pacCode,pacName,pacRemark);
+        DynamicDataSourceContextHolder.clearDataSourceType();
+        return AjaxResult.success(maps);
+    }
+
 
     /**
      * 鏌ヨ浣撴椤圭洰鍒楄〃
@@ -66,27 +82,34 @@
     public AjaxResult getlist(@RequestParam(required = false) @ApiParam(value = "椤圭洰鍚嶇О") String proName,
                               @RequestParam(required = false) @ApiParam(value = "妫�鏌ョ被鍒�") String checkType,
                               @RequestParam(required = false) @ApiParam(value = "閮ㄩ棬id") String deptId) {
-        LambdaQueryWrapper<TjProject> wq0 = new LambdaQueryWrapper<>();
-        wq0.eq(TjProject::getProParentId, 0);
-        if(null !=proName){
-            wq0.like(TjProject::getProName,proName);
-        }
-        if(null !=checkType){
-            wq0.like(TjProject::getProCheckType,checkType);
-        }
-        if(null !=deptId){
-            wq0.like(TjProject::getDeptId,deptId);
-        }
+//        LambdaQueryWrapper<TjProject> wq0 = new LambdaQueryWrapper<>();
+//        wq0.eq(TjProject::getProParentId, 0);
+//        if(null !=proName){
+//            wq0.like(TjProject::getProName,proName);
+//        }
+//        if(null !=checkType){
+//            wq0.like(TjProject::getProCheckType,checkType);
+//        }
+//        if(null !=deptId){
+//            wq0.like(TjProject::getDeptId,deptId);
+//        }
+//
+//        List<TjProject> tjProjects = tjProjectService.list(wq0);
 
-        List<TjProject> tjProjects = tjProjectService.list(wq0);
+        //涓婇潰鐨勬崲sql
+        final List<TjProject> tjProjects = tjProjectService.getProBySqlAndName(proName, checkType, deptId);
+
         if (tjProjects != null) {
             for (TjProject project : tjProjects) {
                 LambdaQueryWrapper<TjProject> wq1 = new LambdaQueryWrapper<>();
                 wq1.eq(TjProject::getProParentId, project.getProId());
+                if(null !=proName) {
+                    wq1.like(TjProject::getProName, proName);
+                }
                 List<TjProject> projectList = tjProjectService.list(wq1);
                 project.setTjProjectList(projectList);
 
-                //鏍规嵁姣忎釜椤圭洰鐨刣eptId鎷垮埌name  2023/2/7
+
                 SysDept sysDept = deptService.selectDeptById(project.getDeptId());
                 if (sysDept!=null){
                     project.setDeptName(sysDept.getDeptName());
@@ -125,7 +148,7 @@
     /**
      * 瀵煎嚭浣撴椤圭洰鍒楄〃
      */
-    @PreAuthorize("@ss.hasPermi('hosp:project:export')")
+    //@PreAuthorize("@ss.hasPermi('hosp:project:export')")
     @Log(title = "浣撴椤圭洰", businessType = BusinessType.EXPORT)
     @PostMapping("/export")
     @ApiOperation(value = "瀵煎嚭浣撴椤圭洰鍒楄〃")
@@ -138,7 +161,7 @@
     /**
      * 鑾峰彇浣撴椤圭洰璇︾粏淇℃伅
      */
-    @PreAuthorize("@ss.hasPermi('hosp:project:query')")
+    //@PreAuthorize("@ss.hasPermi('hosp:project:query')")
     @GetMapping(value = "/{proId}")
     @ApiOperation(value = "鑾峰彇浣撴椤圭洰璇︾粏淇℃伅")
     public AjaxResult getInfo(@PathVariable("proId") @ApiParam(value = "浣撴椤圭洰id") Long proId) {
@@ -174,7 +197,7 @@
     /**
      * 鏂板浣撴椤圭洰
      */
-    @PreAuthorize("@ss.hasPermi('hosp:project:add')")
+    //@PreAuthorize("@ss.hasPermi('hosp:project:add')")
     @ApiOperation(value = "鏂板浣撴椤圭洰")
     @Log(title = "浣撴椤圭洰", businessType = BusinessType.INSERT)
     @PostMapping
@@ -245,7 +268,7 @@
     /**
      * 淇敼浣撴椤圭洰
      */
-    @PreAuthorize("@ss.hasPermi('hosp:project:edit')")
+    //@PreAuthorize("@ss.hasPermi('hosp:project:edit')")
     @Log(title = "浣撴椤圭洰", businessType = BusinessType.UPDATE)
     @PutMapping
     @ApiOperation(value = "淇敼浣撴椤圭洰")
@@ -344,7 +367,7 @@
     /**
      * 鍒犻櫎浣撴椤圭洰
      */
-    @PreAuthorize("@ss.hasPermi('hosp:project:remove')")
+    // @PreAuthorize("@ss.hasPermi('hosp:project:remove')")
     @Log(title = "浣撴椤圭洰", businessType = BusinessType.DELETE)
     @DeleteMapping("/{proIds}")
     @ApiOperation(value = "鍒犻櫎浣撴椤圭洰(鍙垹闄ょ埗椤圭洰鍜屽瓙椤圭洰)")

--
Gitblit v1.8.0