From 3a61407d9b86b5ef9eb622ef009abd5ed3e777dd Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期五, 13 十二月 2024 17:38:58 +0800
Subject: [PATCH] 20241213

---
 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjAdviceController.java |  129 +++++++++++++++++++++++++------------------
 1 files changed, 75 insertions(+), 54 deletions(-)

diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjAdviceController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjAdviceController.java
index 517cf9f..493fd23 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjAdviceController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjAdviceController.java
@@ -6,10 +6,12 @@
 import javax.annotation.Resource;
 import javax.servlet.http.HttpServletResponse;
 
+import cn.hutool.core.util.StrUtil;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.ltkj.common.annotation.Excel;
+import com.ltkj.common.core.domain.entity.SysDept;
 import com.ltkj.common.utils.StringUtils;
 import com.ltkj.common.utils.poi.ExcelUtil;
 import com.ltkj.framework.config.UserHoder;
@@ -21,6 +23,7 @@
 import com.ltkj.hosp.service.ITjProjectService;
 import com.ltkj.hosp.service.TjAdviceKjbqService;
 import com.ltkj.hosp.service.TjUserAdviceService;
+import com.ltkj.system.service.ISysDeptService;
 import com.ltkj.system.service.ISysUserService;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
@@ -53,6 +56,8 @@
     private TjUserAdviceService userAdviceService;
     @Autowired
     private ISysUserService userService;
+    @Autowired
+    private ISysDeptService sysDeptService;
 
     @PostMapping("/addTjAdviceKjbq")
     @ApiOperation(value = "鏂板浣撴寤鸿蹇嵎鏍囩鎺ュ彛")
@@ -198,60 +203,76 @@
                            @ApiParam(value = "鏍囬") @RequestParam(required = false) String bt,
                            @ApiParam(value = "寤鸿") @RequestParam(required = false) String nr,
                            @ApiParam(value = "椤电爜鏁�(榛樿1)") @RequestParam(defaultValue = "1") Integer page,
-                           @ApiParam(value = "鏄剧ず鏉℃暟(榛樿10)") @RequestParam(defaultValue = "10") Integer pageSize) {
-        Page<TjAdvice> page1 = new Page<>(page, pageSize);
-        Map<String, Object> map = new HashMap<>();
-        List<TjAdvice> list = null;
-        long total = 0;
-        if (null != proName) {
-            LambdaQueryWrapper<TjProject> wq = new LambdaQueryWrapper<>();
-            list = new ArrayList<>();
-            wq.like(TjProject::getProName, proName);
-            List<TjProject> projectList = tjProjectService.list(wq);
-            if (null != projectList && !projectList.isEmpty()) {
-                for (TjProject project : projectList) {
-                    LambdaQueryWrapper<TjAdvice> wqq = new LambdaQueryWrapper<>();
-                    wqq.eq(TjAdvice::getProId, project.getProId());
-                    IPage<TjAdvice> adviceList = tjAdviceService.page(page1, wqq);
-                    if (null != adviceList.getRecords() && !adviceList.getRecords().isEmpty()) {
-                        for (TjAdvice record : adviceList.getRecords()) {
-                            record.setProName(project.getProName());
-                            String kjbq = record.getKjbq();
-                            if(null !=kjbq && !kjbq.isEmpty()){
-                                String[] split = kjbq.split(",");
-                                record.setKjbqz(Arrays.asList(split));
-                            }
-                        }
-                        list.addAll(adviceList.getRecords());
-                    }
-                    total = adviceList.getTotal();
-                }
-            }
-            map.put("list", list);
-            map.put("total", total);
-            return AjaxResult.success(map);
-        }
-        LambdaQueryWrapper<TjAdvice> wq=new LambdaQueryWrapper<>();
-        if(!StringUtil.isBlank(bt)) wq.like(TjAdvice::getTitle,bt);
-        if(!StringUtil.isBlank(nr)) wq.like(TjAdvice::getAdvice,nr);
-        Page<TjAdvice> page2 = tjAdviceService.page(page1,wq);
-        list = page2.getRecords();
-        if (null != list && !list.isEmpty()) {
-            for (TjAdvice advice : list) {
-                TjProject tjProject = tjProjectService.getById(advice.getProId());
-                if (null != tjProject) {
-                    advice.setProName(tjProject.getProName());
-                }
-                String kjbq = advice.getKjbq();
-                if(null !=kjbq && !kjbq.equals("")){
-                    String[] split = kjbq.split(",");
-                    advice.setKjbqz(Arrays.asList(split));
-                }
-            }
-        }
-        map.put("list", list);
-        map.put("total", page2.getTotal());
-        return AjaxResult.success(map);
+                           @ApiParam(value = "鏄剧ず鏉℃暟(榛樿10)") @RequestParam(defaultValue = "10") Integer pageSize,
+    @RequestParam(value = "deptId")String deptId) {
+//        LambdaQueryWrapper<SysDept> wrapper = new LambdaQueryWrapper<>();
+//        wrapper.eq(SysDept::getParentId, 0);
+//        SysDept sysDept = sysDeptService.getOne(wrapper);
+//        Page<TjAdvice> page1 = new Page<>(page, pageSize);
+//        Map<String, Object> map = new HashMap<>();
+//        List<TjAdvice> list = null;
+//        long total = 0;
+//        if (null != proName) {
+//            LambdaQueryWrapper<TjProject> wq = new LambdaQueryWrapper<>();
+//            list = new ArrayList<>();
+//            wq.like(TjProject::getProName, proName);
+//            List<TjProject> projectList = tjProjectService.list(wq);
+//            if (null != projectList && !projectList.isEmpty()) {
+//                for (TjProject project : projectList) {
+//                    LambdaQueryWrapper<TjAdvice> wqq = new LambdaQueryWrapper<>();
+//                    wqq.eq(TjAdvice::getProId, project.getProId());
+//                    if (!deptId.equals(String.valueOf(sysDept.getDeptId()))) {
+//                        wqq.eq(TjAdvice::getDept_id, deptId);
+//                    }
+//                    IPage<TjAdvice> adviceList = tjAdviceService.page(page1, wqq);
+//                    if (null != adviceList.getRecords() && !adviceList.getRecords().isEmpty()) {
+//                        for (TjAdvice record : adviceList.getRecords()) {
+//                            record.setProName(project.getProName());
+//                            String kjbq = record.getKjbq();
+//                            if(null !=kjbq && !kjbq.isEmpty()){
+//                                String[] split = kjbq.split(",");
+//                                record.setKjbqz(Arrays.asList(split));
+//                            }
+//                        }
+//                        list.addAll(adviceList.getRecords());
+//                    }
+//                    total = adviceList.getTotal();
+//                }
+//            }
+//            map.put("list", list);
+//            map.put("total", total);
+//            List<TjAdvice> list1 =  tjAdviceService.selectList(proName,deptId,(page -1) * pageSize,pageSize);
+//            return AjaxResult.success(map);
+//        }
+//        LambdaQueryWrapper<TjAdvice> wq=new LambdaQueryWrapper<>();
+//        if(!StringUtil.isBlank(bt)) wq.like(TjAdvice::getTitle,bt);
+//        if(!StringUtil.isBlank(nr)) wq.like(TjAdvice::getAdvice,nr);
+//        if (!deptId.equals(String.valueOf(sysDept.getDeptId()))) {
+//            wq.eq(TjAdvice::getDept_id, deptId);
+//        }
+//        Page<TjAdvice> page2 = tjAdviceService.page(page1,wq);
+//        list = page2.getRecords();
+//        if (null != list && !list.isEmpty()) {
+//            for (TjAdvice advice : list) {
+//                TjProject tjProject = tjProjectService.getById(advice.getProId());
+//                if (null != tjProject) {
+//                    advice.setProName(tjProject.getProName());
+//                }
+//                String kjbq = advice.getKjbq();
+//                if(null !=kjbq && !kjbq.equals("")){
+//                    String[] split = kjbq.split(",");
+//                    advice.setKjbqz(Arrays.asList(split));
+//                }
+//            }
+//        }
+//        map.put("list", list);
+//        map.put("total", page2.getTotal());
+        List<TjAdvice> tjAdvices = tjAdviceService.selectList(proName, deptId, (page - 1) * pageSize, pageSize);
+        Integer count = tjAdviceService.selectListCount(proName, deptId);
+        HashMap<String, Object> hashMap = new HashMap<>();
+        hashMap.put("list",tjAdvices);
+        hashMap.put("total",count);
+        return AjaxResult.success(hashMap);
     }
 
     /**

--
Gitblit v1.8.0