From dcde17c2cc7b7438415f91bc2731f998eb0a36fc Mon Sep 17 00:00:00 2001
From: liuleilei <234@qq.com>
Date: 星期五, 15 十二月 2023 15:03:58 +0800
Subject: [PATCH] 员工列表

---
 server/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java |   47 +++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 45 insertions(+), 2 deletions(-)

diff --git a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
index dae492d..9677c71 100644
--- a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
+++ b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
@@ -42,11 +42,14 @@
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
 import org.apache.commons.collections.CollectionUtils;
 import org.apache.commons.lang3.StringUtils;
+import org.apache.commons.lang3.time.DateUtils;
 import org.apache.shiro.SecurityUtils;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
+
+import java.util.Arrays;
 import java.util.Date;
 import java.util.List;
 import java.util.Objects;
@@ -204,11 +207,49 @@
         userAction.setIsdeleted(Constants.ZERO);
         userAction.setCreateDate(new Date());
         userAction.setCreator(loginUserInfo.getId());
-        userAction.setType(Constants.TWO);
+        if(Constants.equalsInteger(result.getType(),Constants.TWO)){
+            userAction.setType(Constants.ONE);
+        }
+        if(Constants.equalsInteger(result.getType(),Constants.ZERO)){
+            userAction.setType(Constants.TWO);
+        }
         userAction.setMemberId(result.getId()+"");
         userAction.setBeforeStatus(status);
         userActionJoinMapper.insert(userAction);
     }
+
+
+    @Override
+    public void updateRemoveStatusById(List<Member> members) {
+        LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+
+        Date date=new Date();
+        members.stream().forEach(s ->{
+            Member result=memberMapper.selectById(s.getId());
+            Integer status=result.getStatus();
+            Member update = new Member();
+            update.setEditDate(date);
+            update.setEditor(loginUserInfo.getId());
+            update.setStatus(s.getStatus());
+            update.setId(s.getId());
+            memberMapper.updateById(update);
+
+            UserAction userAction=new UserAction();
+            userAction.setIsdeleted(Constants.ZERO);
+            userAction.setCreateDate(new Date());
+            userAction.setCreator(loginUserInfo.getId());
+            if(Constants.equalsInteger(result.getType(),Constants.TWO)){
+                userAction.setType(Constants.ZERO);
+            }
+            if(Constants.equalsInteger(result.getType(),Constants.ZERO)){
+                userAction.setType(Constants.THREE);
+            }
+            userAction.setMemberId(result.getId()+"");
+            userAction.setBeforeStatus(status);
+            userActionJoinMapper.insert(userAction);
+        });
+    }
+
 
 
 
@@ -535,7 +576,8 @@
         queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId);
         queryWrapper.selectAll(Member.class)
                 .selectAs(Company::getName,MemberInfoDTO::getCompanyName)
-                .select(" (select count(v.id) from visits v where v.MEMBER_ID=t.id and v.ISDELETED=0) as visitsCount")
+                .select(" (select ua.CREATE_DATE from user_action ua where ua.MEMBER_ID=t.id and ua.ISDELETED=0 and ua.type=1 order by ua.CREATE_DATE limit 1) as userActionType1")
+             /*   .select(" (select count(v.id) from visits v where v.MEMBER_ID=t.id and v.ISDELETED=0) as visitsCount")*/
                 .select(" (select STARTTIME from visits v where v.MEMBER_ID=t.id and v.ISDELETED=0 order by CREATE_DATE limit 1) as visitsLastDate");
 
         queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getType()),Member::getType,pageWrap.getModel().getType());
@@ -544,6 +586,7 @@
                 .like(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()),Company::getName,pageWrap.getModel().getCompanyName())
                 .like(StringUtils.isNotBlank(pageWrap.getModel().getIdcardNo()),Member::getIdcardNo,pageWrap.getModel().getIdcardNo())
                 .eq(Member::getStatus,Constants.Status.ENABLE)
+                .eq(Objects.nonNull(pageWrap.getModel().getCode()),Member::getCode,pageWrap.getModel().getCode())
                 .orderByDesc(Member::getCreateDate);
 
 

--
Gitblit v1.9.3