From 2079ba28f20bde46f7736699c97abf0e1564770d Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期一, 14 十月 2024 09:30:46 +0800
Subject: [PATCH] 最新版本

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java |  204 +++++++++++++++++++++++++-------------------------
 1 files changed, 101 insertions(+), 103 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
index 21b6767..7a0a0f7 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
@@ -9,8 +9,6 @@
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.doumee.biz.system.SystemDictDataBiz;
 import com.doumee.config.DataSyncConfig;
-import com.doumee.config.Jwt.JwtPayLoad;
-import com.doumee.config.Jwt.JwtTokenUtil;
 import com.doumee.core.annotation.excel.ExcelImporter;
 import com.doumee.core.constants.ResponseStatus;
 import com.doumee.core.exception.BusinessException;
@@ -25,7 +23,6 @@
 import com.doumee.core.model.PageData;
 import com.doumee.core.model.PageWrap;
 import com.doumee.core.utils.*;
-import com.doumee.core.utils.redis.RedisUtil;
 import com.doumee.core.wx.WXConstant;
 import com.doumee.dao.admin.request.LaborEmpowerDTO;
 import com.doumee.dao.admin.request.LaborMemberDTO;
@@ -35,7 +32,6 @@
 import com.doumee.dao.business.*;
 import com.doumee.dao.business.dao.CompanyMapper;
 import com.doumee.dao.business.dto.RegisterDriverDTO;
-import com.doumee.dao.business.dto.ResetPasswordDTO;
 import com.doumee.dao.business.join.MemberJoinMapper;
 import com.doumee.dao.business.join.RetentionJoinMapper;
 import com.doumee.dao.business.join.UserActionJoinMapper;
@@ -43,7 +39,6 @@
 import com.doumee.dao.system.SystemUserMapper;
 import com.doumee.dao.system.model.SystemDictData;
 import com.doumee.dao.system.model.SystemUser;
-import com.doumee.dao.web.reqeust.AccountLoginDTO;
 import com.doumee.dao.web.reqeust.CheckVisitedDTO;
 import com.doumee.dao.web.reqeust.VisitMemberDTO;
 import com.doumee.dao.web.response.MemberVO;
@@ -52,6 +47,7 @@
 import com.doumee.service.business.SmsEmailService;
 import com.doumee.service.business.impl.hksync.HkSyncEmpowerServiceImpl;
 import com.doumee.service.business.impl.hksync.ferp.HkSyncOrgUserToHKServiceImpl;
+import com.doumee.service.system.SystemLoginService;
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
 import org.apache.commons.collections.CollectionUtils;
 import org.apache.commons.lang3.RandomStringUtils;
@@ -60,6 +56,7 @@
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.beans.factory.annotation.Value;
+import org.springframework.context.annotation.Lazy;
 import org.springframework.data.redis.core.RedisTemplate;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
@@ -94,8 +91,8 @@
 
     @Autowired
     private EmpowerMapper empowerMapper;
-
     @Autowired
+
     private DeviceMapper deviceMapper;
 
     @Autowired
@@ -122,8 +119,12 @@
     private SystemUserMapper systemUserMapper;
 
     @Autowired
+    @Lazy
     private SmsEmailService smsEmailService;
 
+    @Autowired
+    private SystemLoginService systemLoginService; 
+    
     @Value("${debug_model}")
     private Boolean isDebug;
     @Override
@@ -144,7 +145,7 @@
                 //鍒涘缓绯荤粺鐧婚檰璐﹀彿锛堥粯璁ゆ棤浠讳綍瑙掕壊锛�
                 if(Constants.equalsInteger(member.getCompanyType(),Constants.ONE)){
                     //濡傛灉鏄唴閮ㄧ粍缁囦汉鍛橈紝鏂板绯荤粺鐧婚檰璐﹀彿
-                    systemUserMapper.insert(createSystemUser(insert));
+                    systemUserMapper.insert(createSystemUser(insert,systemDictDataBiz));
                     //澶勭悊鍩硅鏈夋晥鏈熶笟鍔�
                     dealTrainTIme(member,0,loginUserInfo);
                 }
@@ -153,12 +154,13 @@
             }
         }catch (Exception e){
             //濡傛灉鍙戠敓寮傚父锛屽垹闄ゅ凡缁忓垱寤虹殑浜哄憳淇℃伅
+            e.printStackTrace();
             deleteHkUserBiz(new String[]{insert.getHkId()});
             throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝鍛樺伐淇℃伅鏂板缓澶辫触锛岃绋嶅悗閲嶈瘯锛�");
         }
         return insert;
     }
-    private SystemUser createSystemUser(Member insert) {
+    public static SystemUser createSystemUser(Member insert,SystemDictDataBiz systemDictDataBiz) {
         SystemUser user = new SystemUser();
         // 鐢熸垚瀵嗙爜鐩�
         String salt = RandomStringUtils.randomAlphabetic(6);
@@ -178,6 +180,7 @@
         user.setUpdateUser(insert.getEditor());
         user.setUpdateTime(insert.getEditDate());
         user.setMemberId(insert.getId());
+        user.setSource(Constants.ZERO);
         user.setDeleted(Boolean.FALSE);
         user.setFixed(Boolean.FALSE);
         user.setStatus(Constants.ZERO);
@@ -241,7 +244,7 @@
         }
         //澶勭悊鏂板鏁版嵁
         BaseResponse<UserAddResponse> result =  HKService.addUser(hkAddRequest);
-        if(result!=null && StringUtils.equals(result.getCode(),HKConstants.RESPONSE_SUCCEE) && result.getData()!=null){
+        if(result!=null && StringUtils.equals(result.getCode(), HKConstants.RESPONSE_SUCCEE) && result.getData()!=null){
             insert.setHkId(hkAddRequest.getPersonId());
             insert.setFaceId(result.getData().getFaceId());
             if(StringUtils.isNotBlank(insert.getFaceId())){
@@ -328,12 +331,14 @@
             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"韬唤璇佸彿鏍煎紡鏈夎");
         }
         if(memberMapper.selectCount(new QueryWrapper<Member>().lambda()
+                .in(Member::getType,new Integer[]{Constants.ZERO,Constants.TWO})
                 .eq(Member::getIdcardNo,DESUtil.encrypt(Constants.EDS_PWD, member.getIdcardNo()))
                 .eq(Member::getIsdeleted,Constants.ZERO)) >0){
             throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "韬唤璇佸彿銆�"+member.getIdcardNo()+"銆戝凡琚娇鐢紝涓嶈兘閲嶅");
         }
         if(memberMapper.selectCount(new QueryWrapper<Member>().lambda()
                 .eq(Member::getPhone,  member.getPhone())
+                .in(Member::getType,new Integer[]{Constants.ZERO,Constants.TWO})
                 .eq(Member::getIsdeleted,Constants.ZERO) ) >0){
             throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "鎵嬫満鍙枫��"+member.getPhone()+"銆戝凡琚娇鐢紝涓嶈兘閲嶅");
         }
@@ -376,12 +381,14 @@
         if(model ==null ||Constants.equalsInteger(member.getIsdeleted(),Constants.ONE)){
             throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝璇ュ憳宸ヤ俊鎭笉瀛樺湪锛岃鍒锋柊椤甸潰閲嶈瘯锛�");
         }
+        member.setSex(model.getSex());//榛樿鏄師鏉ョ殑鎬у埆
         if (StringUtils.isNotBlank(member.getPhone())  ){
             if ( !PhoneUtil.isPhone(member.getPhone())) {
                 throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "鐢佃瘽鍙风爜鏍煎紡鏈夎");
             }
             if(memberMapper.selectCount(new QueryWrapper<Member>().lambda()
                     .eq(Member::getPhone,member.getPhone())
+                    .in(Member::getType,new Integer[]{Constants.ZERO,Constants.TWO})
                     .eq(Member::getIsdeleted,Constants.ZERO)
                     .ne(Member::getId,member.getId())) >0){
                 throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "鎵嬫満鍙枫��"+member.getPhone()+"銆戝凡琚娇鐢紝涓嶈兘閲嶅");
@@ -396,6 +403,7 @@
             if( !StringUtils.equals(model.getIdcardNo(),encrptNo) ){
                 if(memberMapper.selectCount(new QueryWrapper<Member>().lambda()
                         .eq(Member::getIdcardNo,encrptNo)
+                        .in(Member::getType,new Integer[]{Constants.ZERO,Constants.TWO})
                         .eq(Member::getIsdeleted,Constants.ZERO)
                         .ne(Member::getId,member.getId())) >0){
                     throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "韬唤璇佸彿銆�"+member.getIdcardNoNew()+"銆戝凡琚娇鐢紝涓嶈兘閲嶅");
@@ -453,11 +461,12 @@
             systemUserMapper.update(null,new UpdateWrapper<SystemUser>().lambda()
                             .set(SystemUser::getUpdateUser,member.getLoginUserInfo().getId())
                             .set(SystemUser::getUpdateTime,new Date())
-                            .set(StringUtils.isNotBlank(model.getFaceImg()),SystemUser::getAvatar,member.getFaceImg())
-                            .set(StringUtils.isNotBlank(model.getPhone()),SystemUser::getMobile,member.getPhone())
-                            .set(StringUtils.isNotBlank(model.getName()),SystemUser::getRealname,member.getName())
-                            .set(model.getCompanyId() !=null,SystemUser::getCompanyId,member.getCompanyId())
-                            .set(StringUtils.isNotBlank(model.getCode()),SystemUser::getEmpNo,member.getCode())
+                            .set(StringUtils.isNotBlank(member.getFaceImg()),SystemUser::getAvatar,member.getFaceImg())
+                            .set(StringUtils.isNotBlank(member.getPhone()),SystemUser::getMobile,member.getPhone())
+                            .set(StringUtils.isNotBlank(member.getPhone()),SystemUser::getUsername,member.getPhone())
+                            .set(StringUtils.isNotBlank(member.getName()),SystemUser::getRealname,member.getName())
+                            .set(member.getCompanyId() !=null,SystemUser::getCompanyId,member.getCompanyId())
+                            .set(StringUtils.isNotBlank(member.getCode()),SystemUser::getEmpNo,member.getCode())
                     .eq(SystemUser::getMemberId,model.getId()));
         }
         if(Constants.equalsInteger(model.getCompanyType(),Constants.ZERO)
@@ -539,15 +548,27 @@
     }
 
     @Override
+    @Transactional(rollbackFor = {BusinessException.class,Exception.class})
     public void deleteById(Integer id,LoginUserInfo loginUserInfo) {
         Member member=new Member();
         member.setId(id);
-        member.setIsdeleted(Constants.ZERO);
+        member.setIsdeleted(Constants.ONE);
         member.setEditor(loginUserInfo.getId());
         member.setEditDate(new Date());
         member.setHkStatus(Constants.ZERO);
         member.setRemark("浜哄憳宸插垹闄わ紝绛夊緟鍒犻櫎闂ㄧ鏉冮檺");
         memberMapper.updateById(member);
+
+        //鍒櫎绯荤粺鐧婚檰璐︽埛
+        SystemUser user = new SystemUser();
+        user.setMemberId(id);
+        systemUserMapper.update(null,new UpdateWrapper<SystemUser>().lambda()
+                .eq(SystemUser::getMemberId,id)
+                .set(SystemUser::getDeleted,Boolean.TRUE)
+                .set(SystemUser::getUpdateUser,member.getEditor())
+                .set(SystemUser::getUpdateTime,member.getEditDate())
+        );
+
         saveUserActionBiz(member,loginUserInfo,Constants.UserActionType.DELETE,userActionJoinMapper,JSONObject.toJSONString(member));
     }
 
@@ -594,7 +615,7 @@
                 //濡傛灉鍛樺伐淇℃伅涓嶅悎娉曠洿鎺ヨ烦杩�
                continue;
             }
-            if(StringUtils.isNotBlank(member.getFaceId()) || !Constants.equalsInteger(member.getFaceStatus(),Constants.ONE)){
+            if(StringUtils.isBlank(member.getFaceId()) || !Constants.equalsInteger(member.getFaceStatus(),Constants.ONE)){
                 throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝鐢ㄦ埛銆�"+member.getName()+"銆戠殑浜鸿劯淇℃伅涓嶆弧瓒虫巿鏉冩潯浠讹紝璇疯繑鍥炲畬鍠勫悗鍐嶈繘琛岃鎿嶄綔锛�");
             }
             member.setStartTime(memberRole.getStartTime());
@@ -722,7 +743,7 @@
                     memberRole.setRoleId(deviceRole.getId());
                     memberRoleList.add(memberRole);
                 }
-                memberRoleMapper.insertBatchSomeColumn(memberRoleList);
+                memberRoleMapper.insert(memberRoleList);
             }
             member.setRoleId(ids);
             return  1;
@@ -758,7 +779,10 @@
         if (CollectionUtils.isEmpty(ids)) {
             return;
         }
-        Member member=new Member();
+        for(Integer id : ids){
+            deleteById(id,loginUserInfo);
+        }
+       /* Member member=new Member();
         ids.stream().forEach(s ->{
             member.setId(s);
             member.setIsdeleted(Constants.ONE);
@@ -768,7 +792,7 @@
             member.setEditDate(new Date());
             memberMapper.updateById(member);
             saveUserActionBiz(member,loginUserInfo,Constants.UserActionType.DELETE,userActionJoinMapper,JSONObject.toJSONString(member));
-        });
+        });*/
 
     }
 
@@ -786,8 +810,8 @@
         }
         for (Integer id:ids) {
             Member member = memberMapper.selectById(id);
-            if(!Objects.isNull(member)&&member.getStatus()==Constants.ZERO){
-                member.setStatus(Constants.TWO);
+            if(!Objects.isNull(member)&&member.getStatus()!=Constants.TWO){
+                member.setStatus(Constants.TWO);//鎭㈠姝e父鐘舵��
                 member.setEditor(loginUserInfo.getId());
                 member.setEditDate(new Date());
                 member.setAuthStatus(Constants.ZERO);//鏈巿鏉�
@@ -797,7 +821,6 @@
                 member.setEditor(loginUserInfo.getId());
                 //鍒犻櫎鍛樺伐闂ㄧ鏉冮檺
                 cancelAllMemberEmpower(member,memberRoleMapper,empowerMapper);
-
                 if(Constants.equalsInteger(type,Constants.ONE)){
                     saveUserActionBiz(member,loginUserInfo,Constants.UserActionType.FREEZE,userActionJoinMapper,JSONObject.toJSONString(member));
                 }
@@ -821,8 +844,8 @@
         }
         for (Integer id:ids) {
             Member member = memberMapper.selectById(id);
-            if(!Objects.isNull(member)&&member.getStatus()==Constants.ZERO){
-                member.setStatus(Constants.ONE);//鎭㈠姝e父鐘舵��
+            if(!Objects.isNull(member)&&member.getStatus()==Constants.TWO){
+                member.setStatus(Constants.ZERO);//鎭㈠姝e父鐘舵��
                 member.setEditor(loginUserInfo.getId());
                 member.setEditDate(new Date());
                 member.setAuthStatus(Constants.ZERO);//鏈巿鏉�
@@ -910,6 +933,7 @@
     }
 
     public static void saveUserActionBiz(Member updateMember,LoginUserInfo user, Constants.UserActionType type,UserActionJoinMapper userActionMapper,String content) {
+        updateMember.setEditDate(updateMember.getEditDate()==null?new Date():updateMember.getEditDate());
         UserAction userAction=new UserAction();
         userAction.setIsdeleted(Constants.ZERO);
         userAction.setCreateDate(updateMember.getEditDate());
@@ -918,7 +942,7 @@
         userAction.setType(type.getKey());
         userAction.setContent(content);
         String info = type.getInfo();
-        userAction.setRemark(info.replace("${param1}",user!=null?user.getRealname():"绯荤粺").replace("${param2}", com.doumee.core.utils.DateUtil.getPlusTime2(updateMember.getEditDate())));
+        userAction.setRemark(info.replace("${param1}",user!=null?user.getRealname():"绯荤粺").replace("${param2}", com.doumee.core.utils.DateUtil.getPlusTime2(updateMember.getEditDate()!=null?updateMember.getEditDate():new Date())));
         userAction.setMemberId(updateMember.getId()+"");
         userActionMapper.insert(userAction);
     }
@@ -1053,6 +1077,7 @@
         update.setEditor(loginUserInfo.getId());
         update.setCanVisit(member.getCanVisit());
         memberMapper.updateById(update);
+        member.setEditDate(update.getEditDate());
         //璁板綍鎿嶄綔鏃ュ織
         saveUserActionBiz(member,loginUserInfo,Constants.equalsInteger(member.getCanVisit(),Constants.ONE)?Constants.UserActionType.CANVISIT:Constants.UserActionType.CANCEL_VISIT,userActionJoinMapper,null);
     }
@@ -1084,7 +1109,12 @@
         queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId);
         queryWrapper.selectAll(Member.class)
                 .selectAs(Company::getName,Member::getCompanyName) ;
-
+        if(StringUtils.isNotBlank(member.getName())){
+            queryWrapper.like(Member::getName,member.getName());
+        }
+        if(Objects.nonNull(member.getCompanyType())){
+            queryWrapper.eq(Company::getType,member.getCompanyType());
+        }
         if(null != member.getType()) {
             queryWrapper.eq(Member::getType,member.getType());
         }
@@ -1092,12 +1122,13 @@
             queryWrapper.eq(Member::getCompanyId,member.getCompanyId());
         }
         queryWrapper.eq(Member::getIsdeleted,Constants.ZERO);
+        queryWrapper.eq(Member::getWorkStatus,Constants.ZERO);
         List<Member> list =  memberJoinMapper.selectJoinList(Member.class,queryWrapper);
-        if(list!=null){
-            for(Member m : list){
-                m.setName(StringUtils.defaultString(m.getName(),"")+"-"+StringUtils.defaultString(m.getCompanyName(),""));
-            }
-        }
+//        if(list!=null){
+//            for(Member m : list){
+//                m.setName(StringUtils.defaultString(m.getName(),"")+"-"+StringUtils.defaultString(m.getCompanyName(),""));
+//            }
+//        }
         return  list;
     }
     @Override
@@ -1107,7 +1138,7 @@
         queryWrapper.selectAll(Member.class)
                 .selectAs(Company::getName,Member::getCompanyName)
                 .eq(Member::getType,Constants.TWO)
-                .exists("select d.id from car_driver b where b.isdeleted=0 and b.member_id=t.id");
+                .exists("select b.id from car_driver b where b.isdeleted=0 and b.member_id=t.id");
 
         if(null != member.getType()) {
             queryWrapper.eq(Member::getType,member.getType());
@@ -1139,7 +1170,6 @@
         if(pageWrap.getModel().getType() != null){
             if(pageWrap.getModel().getType().equals(Constants.memberType.visitor)){
                 queryWrapper.select(" * , (select v.COMPANY_NAME  from visits v where v.MEMBER_ID =  member.id and v.STATUS = 2   order by v.CREATE_DATE desc limit 1 ) as companyName  , " +
-                        " (select v.STARTTIME  from visits v where v.MEMBER_ID =  member.id and v.STATUS = 2   order by v.CREATE_DATE desc limit 1 )  as lastVisitDate , " +
                         " (select count(1) from visits v where v.MEMBER_ID =  member.id and v.STATUS = 2 ) as visitTimes  ");
             }
         }
@@ -1312,7 +1342,7 @@
     public PageData<Member> findMemberInfoPage(PageWrap<MemberQuery> pageWrap) {
         IPage<Member> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
         MPJLambdaWrapper<Member> queryWrapper = new MPJLambdaWrapper<>();
-
+        pageWrap.getModel().setIsdeleted(Constants.formatIntegerNum(pageWrap.getModel().getIsdeleted()));
         queryWrapper.selectAll(Member.class);
         queryWrapper.selectAs(Company::getName,Member::getCompanyName);
         queryWrapper.selectAs(SystemUser::getRealname,Member::getEditorName);
@@ -1422,7 +1452,7 @@
         queryWrapper.selectAll(Member.class)
                 .selectAs(Company::getName,Member::getCompanyName)
                 .selectAs(Member::getLastVisitDate,Member::getLastVisitDate)
-                .select(" (select count(v.id) from visits v where v.MEMBER_ID=t.id and v.ISDELETED=0 and v.status  in (7,8) ) as visitsCount");
+                .select(" (select count(v.id) from visits v where v.MEMBER_ID=t.id and v.ISDELETED=0 and v.status  in (7,8) ) as visitTimes");
         queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Member::getName,pageWrap.getModel().getName())
                 .like(StringUtils.isNotBlank(pageWrap.getModel().getPhone()),Member::getPhone,pageWrap.getModel().getPhone())
                 .and(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()), ms->ms.like(Member::getVisitCompanyName,pageWrap.getModel().getCompanyName())
@@ -1450,12 +1480,11 @@
     public PageData<Member> findUnusualPage(PageWrap<MemberQuery> pageWrap) {
         IPage<Member> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
         MPJLambdaWrapper<Member> queryWrapper = new MPJLambdaWrapper<>();
+        int actiontype =Constants.equalsInteger(pageWrap.getModel().getType(),Constants.ONE)?Constants.UserActionType.BLACKLIST.getKey():Constants.UserActionType.FREEZE.getKey();
         queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId);
         queryWrapper.selectAll(Member.class)
-                .selectAs(Company::getName,Member::getCompanyName)
-                .select(" (select ua.CREATE_DATE from user_action ua where ua.MEMBER_ID=t.id and ua.ISDELETED=0  order by ua.CREATE_DATE desc  limit 1) as optTime")
-                .select(" (select s.REALNAME from user_action uac left join system_user s on uac.CREATOR = s.ID    where uac.MEMBER_ID=t.id and uac.ISDELETED=0 order by uac.CREATE_DATE desc  limit 1) as creatorName")
-                .select(" (select STARTTIME from visits v where v.MEMBER_ID=t.id and v.ISDELETED=0 order by CREATE_DATE desc  limit 1) as visitsLastDate")
+                .selectAs(Company::getCompanyNamePath,Member::getCompanyName)
+                .select(" (select ua.remark from user_action ua where ua.MEMBER_ID=t.id and ua.ISDELETED=0 and ua.type="+actiontype+"  order by ua.CREATE_DATE desc  limit 1) as optRemark")
                 .eq(Member::getIsdeleted,Constants.ZERO);
                 queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getCreaterId()),Member::getEditor,pageWrap.getModel().getCreaterId());
                 queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getType()),Member::getType,pageWrap.getModel().getType());
@@ -1533,7 +1562,7 @@
                         list.add(model);
                     }
                     //瀵煎叆鏂板鐨勬巿鏉冧俊鎭�
-                    empowerMapper.insertBatchSomeColumn(list);
+                    empowerMapper.insert(list);
                 }
             }
         }
@@ -1564,7 +1593,7 @@
                 .eq(Member::getType,Constants.memberType.internal)
                 .eq(Member::getStatus,Constants.ZERO)
                 .isNotNull(Member::getHkId)
-                .apply("to_days(lastVisitDate)+ "+days+" < to_days(now())" ));
+                .apply("to_days(LAST_VISIT_DATE)+ "+days+" < to_days(now())" ));
         if(CollectionUtils.isEmpty(memberList)){
            return;
         }
@@ -1603,16 +1632,19 @@
      * @return
      */
     @Override
-    public WxAuthorizeVO wxAuthorize(String code){
+    public WxAuthorizeVO wxAuthorize(String code, Integer source){
+        if(StringUtils.isBlank(code)||Objects.isNull(source)){
+            throw new BusinessException(ResponseStatus.BAD_REQUEST);
+        }
         String appId = systemDictDataBiz.queryByCode(Constants.WX_PLATFORM,Constants.WX_PLATFORM_APPID).getCode();
         String appSecret = systemDictDataBiz.queryByCode(Constants.WX_PLATFORM,Constants.WX_PLATFORM_SECRET).getCode();
         String getTokenUrl = WXConstant.GET_USER_INFO_URL.replace("CODE", code)
                 .replace("APPID", appId).replace("SECRET", appSecret);
-        JSONObject tokenJson = JSONObject.parseObject(HttpsUtil.get(getTokenUrl,true));
-        String openId = null;
-        if(!Objects.isNull(tokenJson.get("access_token"))){
-            openId = tokenJson.getString("openid");
-        }
+//        JSONObject tokenJson = JSONObject.parseObject(HttpsUtil.get(getTokenUrl,true));
+        String openId = code;
+//        if(!Objects.isNull(tokenJson.get("access_token"))){
+//            openId = tokenJson.getString("openid");
+//        }
 //        String openId = "12345";
         WxAuthorizeVO wxAuthorizeVO = new WxAuthorizeVO();
         wxAuthorizeVO.setOpenid(openId);
@@ -1622,6 +1654,7 @@
                 .selectAs(Company::getName,Member::getCompanyName)
                 .leftJoin(Company.class,Company::getId,Member::getCompanyId)
                 .eq(Member::getOpenid,openId)
+                .eq(Member::getType,source)
                 .eq(Member::getIsdeleted,Constants.ZERO)
                 .orderByDesc(Member::getCreateDate)
                 .last(" limit 1 ")
@@ -1640,12 +1673,16 @@
             String prefixUrl = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() +
                     systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode();
             member.setPrefixUrl(prefixUrl);
-//            JwtPayLoad payLoad = new JwtPayLoad(Integer.toString(member.getId()));
-//            String token = JwtTokenUtil.generateToken(payLoad);
-//            //瀛樺偍token鑷硆edis
-//            RedisUtil.addObject(redisTemplate,Constants.RedisKeys.INTERNAL_TOKEN+"_"+member.getId(),token,Constants.RedisKeys.EXPIRE_TIME);
-//            wxAuthorizeVO.setToken(token);
             wxAuthorizeVO.setMember(member);
+            //鍙告満 涓� 鍐呴儴浜哄憳 鎻愪緵token
+            if(Constants.equalsInteger(source,Constants.ZERO)||Constants.equalsInteger(source,Constants.TWO)){
+                SystemUser systemUser = systemUserMapper.selectOne(new QueryWrapper<SystemUser>().lambda().eq(SystemUser::getMemberId,member.getId())
+                        .eq(SystemUser::getStatus,Constants.ZERO).last(" limit 1 "));
+                if(Objects.nonNull(systemUser)){
+                    String token = systemLoginService.loginByUserId(systemUser.getId());
+                    wxAuthorizeVO.setToken(token);
+                }
+            }
         }
         return wxAuthorizeVO;
     }
@@ -1655,7 +1692,10 @@
 
     @Override
     public List<MemberVO> getVisitedMember(CheckVisitedDTO checkVisitedDTO){
-        List<Member> memberList = memberMapper.selectList(new QueryWrapper<Member>().lambda()
+        List<Member> memberList = memberJoinMapper.selectJoinList(Member.class,new MPJLambdaWrapper<Member>()
+                .selectAll(Member.class)
+                        .selectAs(Company::getName,Member::getCompanyName)
+                .leftJoin(Company.class,Company::getId,Member::getCompanyId)
                 .eq(StringUtils.isNotBlank(checkVisitedDTO.getMobile()),Member::getPhone,checkVisitedDTO.getMobile())
                 .eq(StringUtils.isNotBlank(checkVisitedDTO.getName()),Member::getName,checkVisitedDTO.getName())
                 .eq(Member::getIsdeleted,Constants.ZERO)
@@ -1713,50 +1753,6 @@
 
 
 
-    @Override
-    public WxAuthorizeVO accountLogin(AccountLoginDTO accountLoginDTO){
-        if(accountLoginDTO.getAccount().length()!=18
-            //&&!IdcardUtil.isValidCard(accountLoginDTO.getAccount())
-        ){
-            throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝韬唤璇佸彿鐮佹湁璇紝璇锋牳瀹炲悗閲嶈瘯锛�");
-        }
-        Member member = memberMapper.selectOne(new QueryWrapper<Member>().lambda()
-                .eq(Member::getIdcardNo, DESUtil.encrypt(Constants.EDS_PWD, accountLoginDTO.getAccount()))
-                .ne(Member::getType,Constants.memberType.visitor)
-        );
-        if(Objects.isNull(member)){
-            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏈煡璇㈠埌鐢ㄦ埛,璇疯仈绯荤鐞嗗憳");
-        }
-        if(member.getIsdeleted() == Constants.ONE){
-            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鐢ㄦ埛宸插垹闄�,璇疯仈绯荤鐞嗗憳");
-        }
-        if(member.getStatus() != Constants.ZERO){
-            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鐢ㄦ埛宸茬鐢�,璇疯仈绯荤鐞嗗憳");
-        }
-        String md5Password = DESUtil.encrypt(Constants.EDS_PWD, accountLoginDTO.getPassword());
-        if(!md5Password.equals(member.getPassward())){
-            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璐︽埛瀵嗙爜閿欒!");
-        }
-        if(StringUtils.isNotBlank(accountLoginDTO.getOpenId())){
-            //鍏堟竻绌哄師鏈夎瀹㈢殑openid缁戝畾鍏崇郴
-            memberMapper.update(null, new UpdateWrapper<Member>().lambda()
-                    .ne(Member::getType,Constants.memberType.visitor)
-                    .eq(Member::getOpenid,accountLoginDTO.getOpenId())
-                    .set(Member::getOpenid,null)
-            );
-            //鏇存柊褰撳墠鐧诲綍鐢ㄦ埛 openId
-            member.setOpenid(accountLoginDTO.getOpenId());
-            memberMapper.updateById(member);
-        }
-        WxAuthorizeVO wxAuthorizeVO = new WxAuthorizeVO();
-        JwtPayLoad payLoad = new JwtPayLoad(Integer.toString(member.getId()));
-        String token = JwtTokenUtil.generateToken(payLoad);
-        //瀛樺偍token鑷硆edis
-        RedisUtil.addObject(redisTemplate,Constants.RedisKeys.INTERNAL_TOKEN+"_"+member.getId(),token,Constants.RedisKeys.EXPIRE_TIME);
-        wxAuthorizeVO.setToken(token);
-        return wxAuthorizeVO;
-    }
-
 
 
     @Override
@@ -1765,7 +1761,7 @@
         List<Member> memberList = memberMapper.selectList(new QueryWrapper<Member>().lambda().eq(Member::getIsdeleted,Constants.ZERO));
         if(CollectionUtils.isNotEmpty(memberList)){
             stagingHeadVO.setWorkerCount(memberList.stream().filter(m->m.getType().equals(Constants.memberType.internal)).count());
-            stagingHeadVO.setLwCount(memberList.stream().filter(m->m.getType().equals(Constants.memberType.lw_visitor)).count());
+            stagingHeadVO.setLwCount(memberList.stream().filter(m->m.getType().equals(Constants.memberType.driver)).count());
             stagingHeadVO.setVisitorCount(memberList.stream().filter(m->m.getType().equals(Constants.memberType.visitor)).count());
         }
         //鍦ㄥ満杞﹁締
@@ -1789,7 +1785,7 @@
                 new MPJLambdaWrapper<Member>()
                         .select("count(1) as memberCount, t1.name as companyName")
                         .leftJoin(Company.class,Company::getId,Member::getCompanyId)
-                        .eq(Member::getType,Constants.memberType.lw_visitor)
+                        .eq(Member::getType,Constants.memberType.driver)
                         .groupBy(Company::getId,Company::getName)
         );
         List<Map<String,Object>> retentionMaps = retentionJoinMapper.selectMaps(new MPJLambdaWrapper<Retention>()
@@ -1864,17 +1860,17 @@
                     throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝鍛樺伐淇℃伅銆�"+insert.getName()+"銆戝悓姝ュ畨闃插钩鍙板け璐ワ紝璇风◢鍚庨噸璇曪紒");
                 }
             }
-            memberMapper.insertBatchSomeColumn(newList);
+            memberMapper.insert(newList);
             List<SystemUser> userList = new ArrayList<>();
             for(Member insert: newList){
                 //鍒涘缓绯荤粺鐧婚檰璐﹀彿锛堥粯璁ゆ棤浠讳綍瑙掕壊锛�
                 if(Constants.equalsInteger(insert.getCompanyType(),Constants.ONE)){
                     //濡傛灉鏄唴閮ㄧ粍缁囦汉鍛橈紝鏂板绯荤粺鐧婚檰璐﹀彿
-                    userList.add(createSystemUser(insert));
+                    userList.add(createSystemUser(insert,systemDictDataBiz));
                 }
             }
             if(userList.size()>0){
-                systemUserMapper.insertBatchSomeColumn(userList);
+                systemUserMapper.insert(userList);
             }
         }catch (Exception e){
             //濡傛灉鍙戠敓寮傚父锛屽垹闄ゅ凡缁忓垱寤虹殑浜哄憳淇℃伅
@@ -1995,7 +1991,7 @@
         Member member = new Member();
         member.setCreateDate(new Date());
         member.setIsdeleted(Constants.ZERO);
-        member.setType(Constants.TWO);
+        member.setType(Constants.THREE);
         member.setName(registerDriverDTO.getName());
         member.setPhone(registerDriverDTO.getPhone());
         member.setStatus(Constants.ZERO);
@@ -2009,9 +2005,11 @@
         systemUser.setUsername(registerDriverDTO.getPhone());
         systemUser.setRealname(registerDriverDTO.getName());
         systemUser.setMemberId(member.getId());
+        systemUser.setMobile(registerDriverDTO.getPhone());
         systemUser.setSalt(salt);
         systemUser.setPassword(member.getPassward());
         systemUser.setStatus(Constants.ZERO);
+        systemUser.setSource(Constants.TWO);
         systemUserMapper.insert(systemUser);
 
     }

--
Gitblit v1.9.3