From 5e2d78f61bf7d1513d5d5c8cd55442133a6e898e Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期一, 14 七月 2025 18:23:36 +0800
Subject: [PATCH] 保洁巡检本周代码

---
 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java |   87 ++++++++++++++++++++++++++++++++++---------
 1 files changed, 68 insertions(+), 19 deletions(-)

diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java
index 357f769..2eaf4d9 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java
@@ -13,6 +13,8 @@
 import com.ruoyi.common.utils.StringUtils;
 import com.ruoyi.common.utils.bean.BeanValidators;
 import com.ruoyi.common.utils.spring.SpringUtils;
+import com.ruoyi.system.applet.query.DataReportQuery;
+import com.ruoyi.system.applet.vo.TaskFinishListVO;
 import com.ruoyi.system.domain.SysPost;
 import com.ruoyi.system.domain.SysUserPost;
 import com.ruoyi.system.domain.SysUserRole;
@@ -32,6 +34,8 @@
 import org.springframework.util.CollectionUtils;
 
 import javax.validation.Validator;
+import java.text.SimpleDateFormat;
+import java.time.LocalDate;
 import java.time.LocalDateTime;
 import java.time.format.DateTimeFormatter;
 import java.util.ArrayList;
@@ -662,16 +666,21 @@
         PageInfo<SysUserVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
 
 
-        List<SysUserVO> list = userMapper.pageList(query);
+        List<SysUserVO> list = userMapper.pageList(query,pageInfo);
         if(CollectionUtils.isEmpty(list)){
             return pageInfo;
         }
+        LocalDate now = LocalDate.now();
+        // 转化为yyyy-MM-dd字符串格式
+        String nowStr = now.format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
+        String start = nowStr+" :00:00:00";
+        String end = nowStr+" :23:59:59";
         for (SysUserVO sysUserVO : list) {
             TLeave tLeave = leaveMapper.selectOne(new LambdaQueryWrapper<TLeave>()
                     .eq(TLeave::getLeavePerson, sysUserVO.getUserId())
                     .eq(TLeave::getAuditStatus, 2)
-                    .ge(TLeave::getStartTime, DateUtils.getNowDate())
-                    .le(TLeave::getEndTime, DateUtils.getNowDate())
+                    .ge(TLeave::getStartTime, start)
+                    .le(TLeave::getEndTime, end)
                     .last("limit 1"));
             if (tLeave!=null){
                 sysUserVO.setLeaveName("请假中");
@@ -692,25 +701,27 @@
             }
             Integer deptType = sysUserVO.getDeptType();
                 if (1==deptType){
-                    TProjectDept tProjectDept = projectDeptMapper.selectById(sysUserVO.getDeptId());
-                    if (!tProjectDept.getParentId().equals("0")){
-                        TProjectDept tProjectDept1 = projectDeptMapper.selectById(tProjectDept.getParentId());
-                         sysUserVO.setDeptName(tProjectDept1.getProjectName()+">"+tProjectDept.getProjectName());
-                    }else{
-                        sysUserVO.setDeptName(tProjectDept.getProjectName());
-                    }
+                        TProjectDept tProjectDept = projectDeptMapper.selectById(sysUserVO.getDeptId());
+                        if (!tProjectDept.getParentId().equals("0")){
+                            TProjectDept tProjectDept1 = projectDeptMapper.selectById(tProjectDept.getParentId());
+                            if (tProjectDept1!=null){
+                                sysUserVO.setDeptName(tProjectDept1.getProjectName()+">"+tProjectDept.getProjectName());
+                            }else{
+                                sysUserVO.setDeptName(tProjectDept.getProjectName());
+                            }
+                        }else{
+                            sysUserVO.setDeptName(tProjectDept.getProjectName());
+                        }
                 }else{
-                    TDept tDept = deptMapper.selectById(sysUserVO.getDeptId());
-                     sysUserVO.setDeptName(tDept.getDeptName());
+                    if (sysUserVO.getUserId()==1){
+                        sysUserVO.setDeptName("公司");
+                    }else{
+                        TDept tDept = deptMapper.selectById(sysUserVO.getDeptId());
+                        sysUserVO.setDeptName(tDept.getDeptName());
+                    }
+
                 }
             }
-        pageInfo.setTotal(list.size());
-        if (org.springframework.util.StringUtils.hasLength(query.getDeptName())){
-            List<SysUserVO> collect = list.stream().filter(sysUserVO -> sysUserVO.getDeptName().contains(query.getDeptName())).collect(Collectors.toList());
-            pageInfo.setTotal(collect.size());
-            // 手动分页
-            list = collect.stream().skip((long) (query.getPageNum() - 1) * query.getPageSize()).limit(query.getPageSize()).collect(Collectors.toList());
-        }
         pageInfo.setRecords(list);
         return pageInfo;
     }
@@ -731,6 +742,44 @@
     }
 
     @Override
+    public List<SysUser> selectListByDeptId(String deptId) {
+        return userMapper.selectListByDeptId(deptId);
+    }
+
+    @Override
+    public List<SysUser> selectListByDeptType(Integer deptType) {
+        return userMapper.selectListByDeptType(deptType);
+    }
+
+    @Override
+    public List<SysUser> selectListByDeptIds(List<String> projectIds) {
+        return userMapper.selectListByDeptIds(projectIds);
+    }
+
+    @Override
+    public List<SysUser> selectUserByDeptId(List<String> ids) {
+        return userMapper.selectUserByDeptId(ids);
+    }
+
+    @Override
+    public PageInfo<TaskFinishListVO> pageListReport(DataReportQuery query) {
+        PageInfo<TaskFinishListVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
+        List<TaskFinishListVO> list = userMapper.pageListReport(query,pageInfo);
+        pageInfo.setRecords(list);
+        return pageInfo;
+    }
+
+    @Override
+    public Integer selectUserCount(List<String> projectId, Integer deptType) {
+        return userMapper.selectUserCount(projectId,deptType);
+    }
+
+    @Override
+    public List<SysUser> selectUserByNickName(String nickName) {
+        return userMapper.selectUserByNickName(nickName);
+    }
+
+    @Override
     public SysUser selectByPhone(String phonenumber) {
         return userMapper.selectByPhone(phonenumber);
     }

--
Gitblit v1.7.1