From e23a1db0b60437f17d09d65c65f8fd0c8a5d88c7 Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期一, 26 八月 2024 18:11:07 +0800
Subject: [PATCH] 最新版本

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java |  265 ++++++++++++++++++++++++++++------------------------
 1 files changed, 144 insertions(+), 121 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 f394837..693f779 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
@@ -2,6 +2,7 @@
 
 import cn.hutool.core.util.IdcardUtil;
 import cn.hutool.core.util.PhoneUtil;
+import cn.hutool.http.HttpRequest;
 import com.alibaba.fastjson.JSONObject;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
@@ -9,8 +10,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;
@@ -52,6 +51,8 @@
 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.doumee.service.system.SystemUserService;
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
 import org.apache.commons.collections.CollectionUtils;
 import org.apache.commons.lang3.RandomStringUtils;
@@ -60,11 +61,14 @@
 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.http.server.reactive.ServerHttpRequest;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 import org.springframework.web.multipart.MultipartFile;
 
+import javax.annotation.Resource;
 import java.util.Date;
 import java.util.*;
 import java.util.stream.Collectors;
@@ -94,8 +98,8 @@
 
     @Autowired
     private EmpowerMapper empowerMapper;
-
     @Autowired
+
     private DeviceMapper deviceMapper;
 
     @Autowired
@@ -122,8 +126,12 @@
     private SystemUserMapper systemUserMapper;
 
     @Autowired
+    @Lazy
     private SmsEmailService smsEmailService;
 
+    @Autowired
+    private SystemLoginService systemLoginService; 
+    
     @Value("${debug_model}")
     private Boolean isDebug;
     @Override
@@ -144,7 +152,7 @@
                 //鍒涘缓绯荤粺鐧婚檰璐﹀彿锛堥粯璁ゆ棤浠讳綍瑙掕壊锛�
                 if(Constants.equalsInteger(member.getCompanyType(),Constants.ONE)){
                     //濡傛灉鏄唴閮ㄧ粍缁囦汉鍛橈紝鏂板绯荤粺鐧婚檰璐﹀彿
-                    systemUserMapper.insert(createSystemUser(insert));
+                    systemUserMapper.insert(createSystemUser(insert,systemDictDataBiz));
                     //澶勭悊鍩硅鏈夋晥鏈熶笟鍔�
                     dealTrainTIme(member,0,loginUserInfo);
                 }
@@ -158,7 +166,7 @@
         }
         return insert;
     }
-    private SystemUser createSystemUser(Member insert) {
+    public static SystemUser createSystemUser(Member insert,SystemDictDataBiz systemDictDataBiz) {
         SystemUser user = new SystemUser();
         // 鐢熸垚瀵嗙爜鐩�
         String salt = RandomStringUtils.randomAlphabetic(6);
@@ -167,6 +175,7 @@
         user.setSalt(salt);
         // 鍒涘缓鐢ㄦ埛璁板綍
         user.setType(insert.getType());
+        user.setAvatar(insert.getFaceImg());
         user.setUsername(insert.getPhone());
         user.setEmpNo(insert.getCode());
         user.setRealname(insert.getName());
@@ -177,6 +186,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);
@@ -202,6 +212,7 @@
         insert.setCanVisit(Constants.ZERO);//榛樿涓嶅彲璁块棶
         insert.setAuthStatus(Constants.ZERO);
         insert.setName(member.getName());
+        insert.setHkId(UUID.randomUUID().toString().replace("-",""));
         insert.setHkStatus(Constants.ONE);
         insert.setSex(Constants.getSexByCardNo( member.getIdcardNo()));//鏍规嵁韬唤璇佸彿鑾峰彇鎬у埆
         insert.setBirthday( DateUtil.fromStringToDate("yyyyMMdd",IdcardUtil.getBirthByIdCard(member.getIdcardNo())));
@@ -374,6 +385,7 @@
         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(), "鐢佃瘽鍙风爜鏍煎紡鏈夎");
@@ -443,15 +455,20 @@
             member.setHkOrgId(company.getHkId());
             isNeedUpdateUser = true;
         }
+        if(StringUtils.isNotBlank(model.getFaceImg())){
+            isNeedUpdateUser=true;
+        }
         if(isNeedUpdateUser){
             //鏇存柊绯荤粺鐢ㄦ埛璐﹀彿淇℃伅
             systemUserMapper.update(null,new UpdateWrapper<SystemUser>().lambda()
                             .set(SystemUser::getUpdateUser,member.getLoginUserInfo().getId())
                             .set(SystemUser::getUpdateTime,new Date())
-                            .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)
@@ -472,6 +489,10 @@
         }
         member.setHkId(model.getHkId());
         member.setFaceId(model.getFaceId());//浜鸿劯缂栫爜
+        if(StringUtils.equals(model.getFaceImg(),member.getFaceImg())){
+            //濡傛灉浜鸿劯娌″彉鍖�
+            member.setFaceImg(null);
+        }
         return model;
     }
 
@@ -529,9 +550,8 @@
     }
 
     @Override
-    public void deleteById(Integer id,LoginUserInfo user) {
-        LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
-
+    @Transactional(rollbackFor = {BusinessException.class,Exception.class})
+    public void deleteById(Integer id,LoginUserInfo loginUserInfo) {
         Member member=new Member();
         member.setId(id);
         member.setIsdeleted(Constants.ZERO);
@@ -540,6 +560,17 @@
         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));
     }
 
@@ -565,7 +596,7 @@
         }else{
             if( ! (Constants.equalsInteger(memberRole.getTimeType(),Constants.ZERO)
                     ||Constants.equalsInteger(memberRole.getTimeType(),Constants.TWO)
-                    || (Constants.equalsObject(memberRole.getTimeType(),Constants.ONE)
+                    || (Constants.equalsInteger(memberRole.getTimeType(),Constants.ONE)
                     && memberRole.getStartTime() !=null && memberRole.getEndTime() != null ))){
                 throw  new BusinessException(ResponseStatus.BAD_REQUEST);
             }
@@ -576,7 +607,7 @@
                 throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"鏈夋晥鏈熸埅姝㈡棩鏈熶笉鑳藉皬浜庡紑濮嬫椂闂达紒");
             }
         }
-        if(Constants.equalsObject(memberRole.getTimeType(),Constants.ZERO) ){
+        if(Constants.equalsInteger(memberRole.getTimeType(),Constants.ZERO) ){
            memberRole.setStartTime(null);
            memberRole.setEndTime(null);
         }
@@ -586,12 +617,12 @@
                 //濡傛灉鍛樺伐淇℃伅涓嶅悎娉曠洿鎺ヨ烦杩�
                continue;
             }
+            if(StringUtils.isBlank(member.getFaceId()) || !Constants.equalsInteger(member.getFaceStatus(),Constants.ONE)){
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝鐢ㄦ埛銆�"+member.getName()+"銆戠殑浜鸿劯淇℃伅涓嶆弧瓒虫巿鏉冩潯浠讹紝璇疯繑鍥炲畬鍠勫悗鍐嶈繘琛岃鎿嶄綔锛�");
+            }
             member.setStartTime(memberRole.getStartTime());
             member.setEndTime(memberRole.getEndTime());
             Integer ischange = getRoleIdByParam(memberRole.getRoleIds(),member,memberRoleMapper,deviceRoleMapper);
-            if(ischange == 0){
-                return;//鏈彂鐜版潈闄愬彉鍖栵紝鐩存帴杩斿洖
-            }
             if(memberRole.getRoleIds()!=null && memberRole.getRoleIds().length>0 && StringUtils.isBlank(member.getRoleId())){
                 throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝鏈煡璇㈠埌鏈夋晥闂ㄧ缁勬暟鎹�");
             }
@@ -714,7 +745,7 @@
                     memberRole.setRoleId(deviceRole.getId());
                     memberRoleList.add(memberRole);
                 }
-                memberRoleMapper.insertBatchSomeColumn(memberRoleList);
+                memberRoleMapper.insert(memberRoleList);
             }
             member.setRoleId(ids);
             return  1;
@@ -778,8 +809,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);//鏈巿鏉�
@@ -789,7 +820,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));
                 }
@@ -813,8 +843,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,7 +940,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);
     }
@@ -944,10 +974,10 @@
        if(model ==null) {
             throw  new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝浜哄憳淇℃伅涓嶅瓨鍦紒");
        }
-        if(!Constants.equalsObject(model.getIsdeleted(),Constants.ONE)){
+        if(!Constants.equalsInteger(model.getIsdeleted(),Constants.ONE)){
             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝鍙湁閽堝绂昏亴浜哄憳鍙繘琛岃鎿嶄綔锛�");
        }
-        if(Constants.equalsObject(model.getHkStatus(),Constants.ONE)){
+        if(Constants.equalsInteger(model.getHkStatus(),Constants.ONE)){
             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ヤ汉鍛樺凡琚垹闄わ紒");
        }
         if(StringUtils.isBlank(model.getHkId())){
@@ -962,7 +992,7 @@
             throw  new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝浜哄憳淇℃伅涓嶅瓨鍦紒");
         }
        if(model.getCompanyId()!=null) {
-           if(Constants.equalsObject(member.getHeadStatus(),Constants.ONE)){
+           if(Constants.equalsInteger(member.getHeadStatus(),Constants.ONE)){
                //濡傛灉鏄彇娑堜富绠�
                companyMapper.update(null,new UpdateWrapper<Company>().lambda()
                        .eq(Company::getId,model.getCompanyId())
@@ -1076,6 +1106,36 @@
         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());
+        }
+        if(null != member.getCompanyId()) {
+            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(),""));
+//            }
+//        }
+        return  list;
+    }
+    @Override
+    public List<Member> findDriveList(Member member) {
+        MPJLambdaWrapper<Member> queryWrapper = new MPJLambdaWrapper<>();
+        queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId);
+        queryWrapper.selectAll(Member.class)
+                .selectAs(Company::getName,Member::getCompanyName)
+                .eq(Member::getType,Constants.TWO)
+                .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());
@@ -1107,7 +1167,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  ");
             }
         }
@@ -1311,7 +1370,7 @@
 //                .eq(Member::getStatus,Constants.Status.ENABLE.getValue())
 //                .eq(Member::getType,Constants.memberType.internal)
                 .eq(pageWrap.getModel().getHkStatus()!=null,Member::getHkStatus,pageWrap.getModel().getHkStatus())
-                .orderByDesc(!Constants.equalsObject(pageWrap.getModel().getIsdeleted(),Constants.ONE),Member::getCreateDate)
+                .orderByDesc(!Constants.equalsInteger(pageWrap.getModel().getIsdeleted(),Constants.ONE),Member::getCreateDate)
                 .orderByDesc(Constants.equalsInteger(pageWrap.getModel().getIsdeleted(),Constants.ONE),Member::getEditDate);
         if(Constants.formatIntegerNum(dataSyncConfig.getOrgUserDataOrigin())==DataSyncConfig.origin.erp){
             queryWrapper.eq( StringUtils.isNotBlank(pageWrap.getModel().getErpOrgId()),Member::getErpOrgId,pageWrap.getModel().getErpOrgId());
@@ -1418,12 +1477,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());
@@ -1501,7 +1559,7 @@
                         list.add(model);
                     }
                     //瀵煎叆鏂板鐨勬巿鏉冧俊鎭�
-                    empowerMapper.insertBatchSomeColumn(list);
+                    empowerMapper.insert(list);
                 }
             }
         }
@@ -1532,7 +1590,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;
         }
@@ -1571,16 +1629,20 @@
      * @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);
         //鏍规嵁openId 鏌ヨ鐢ㄦ埛淇℃伅
@@ -1589,6 +1651,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 ")
@@ -1607,12 +1670,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;
     }
@@ -1621,30 +1688,27 @@
 
 
     @Override
-    public MemberVO getVisitedMember(CheckVisitedDTO checkVisitedDTO){
-        Integer validType = Integer.valueOf(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.BEVISITED_USER_VALID).getCode());
-        if(Objects.isNull(checkVisitedDTO)||StringUtils.isBlank(checkVisitedDTO.getMobile())||(validType.equals(Constants.ONE)&&StringUtils.isBlank(checkVisitedDTO.getName()))){
-            throw new BusinessException(ResponseStatus.BAD_REQUEST);
-        }
-        Member member = memberMapper.selectOne(new QueryWrapper<Member>().lambda()
-                .eq(Member::getPhone,checkVisitedDTO.getMobile())
-                .eq(validType.equals(Constants.ONE),Member::getName,checkVisitedDTO.getName())
+    public List<MemberVO> getVisitedMember(CheckVisitedDTO checkVisitedDTO){
+        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)
-//                .eq(Member::getStatus,Constants.ZERO)
+                .eq(Member::getStatus,Constants.ZERO)
                 .eq(Member::getCanVisit,Constants.ONE)
-                .eq(Member::getType,Constants.memberType.internal)
-                .last(" limit 1 ")
+                .eq(Member::getType,Constants.memberType.internal) 
         );
-        MemberVO memberVO = new MemberVO();
-        if(!Objects.isNull(member)){
-            if(!member.getStatus().equals(Constants.ZERO)){
-                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"琚浜鸿处鍙峰紓甯革紝璇风‘璁ゅ悗鍐嶈瘯");
+        List<MemberVO> memberVOList = new ArrayList<>();
+        if (com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(memberList)) {
+            for (Member member:memberList) {
+                MemberVO memberVO = new MemberVO();
+                BeanUtils.copyProperties(member,memberVO);
+                memberVOList.add(memberVO);
             }
-            BeanUtils.copyProperties(member,memberVO);
-        }else{
-            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"璇锋牳瀹炶璁夸汉淇℃伅!");
         }
-        return memberVO;
+        return memberVOList;
     }
 
 
@@ -1686,50 +1750,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
@@ -1738,7 +1758,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());
         }
         //鍦ㄥ満杞﹁締
@@ -1762,7 +1782,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>()
@@ -1830,21 +1850,24 @@
     private void dealHkUserBizBatch(List<Member> newList) {
         List<String> hkIds = new ArrayList<>();
         try {
-            memberMapper.insertBatchSomeColumn(newList);
-            List<SystemUser> userList = new ArrayList<>();
             for(Member insert: newList){
                 if(dealHkUserBiz(insert)){
                     //鍒涘缓绯荤粺鐧婚檰璐﹀彿锛堥粯璁ゆ棤浠讳綍瑙掕壊锛�
-                    if(Constants.equalsInteger(insert.getCompanyType(),Constants.ONE)){
-                        //濡傛灉鏄唴閮ㄧ粍缁囦汉鍛橈紝鏂板绯荤粺鐧婚檰璐﹀彿
-                        userList.add(createSystemUser(insert));
-                    }
                 }else{
                     throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝鍛樺伐淇℃伅銆�"+insert.getName()+"銆戝悓姝ュ畨闃插钩鍙板け璐ワ紝璇风◢鍚庨噸璇曪紒");
                 }
             }
+            memberMapper.insert(newList);
+            List<SystemUser> userList = new ArrayList<>();
+            for(Member insert: newList){
+                //鍒涘缓绯荤粺鐧婚檰璐﹀彿锛堥粯璁ゆ棤浠讳綍瑙掕壊锛�
+                if(Constants.equalsInteger(insert.getCompanyType(),Constants.ONE)){
+                    //濡傛灉鏄唴閮ㄧ粍缁囦汉鍛橈紝鏂板绯荤粺鐧婚檰璐﹀彿
+                    userList.add(createSystemUser(insert,systemDictDataBiz));
+                }
+            }
             if(userList.size()>0){
-                systemUserMapper.insertBatchSomeColumn(userList);
+                systemUserMapper.insert(userList);
             }
         }catch (Exception e){
             //濡傛灉鍙戠敓寮傚父锛屽垹闄ゅ凡缁忓垱寤虹殑浜哄憳淇℃伅
@@ -1852,7 +1875,6 @@
             throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝鍛樺伐淇℃伅瀵煎叆澶辫触锛岃绋嶅悗閲嶈瘯锛�");
         }
     }
-
     private Member checkModelParam(MemberImport model, List<Member> newList
             ,int index
             ,LoginUserInfo loginUserInfo
@@ -1883,7 +1905,7 @@
         if(company == null){
             throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+(index+3)+"琛岀粍缁囧悕绉般��"+model.getCompanyName()+"銆戜笉瀛樺湪锛岃妫�鏌ヨ〃鏍煎唴瀹癸紒");
         }
-        if(companyType != null && !Constants.equalsObject(companyType,company.getType())){
+        if(companyType != null && !Constants.equalsInteger(companyType,company.getType())){
             throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"瀵逛笉璧凤紝绗�"+(index+3)+"琛岀粍缁囧悕绉般��"+model.getCompanyName()+"銆戠被鍨嬩笉姝g‘锛岃妫�鏌ヨ〃鏍煎唴瀹癸紒");
         }
         String candNo = DESUtil.encrypt(Constants.EDS_PWD, model.getIdcardNo());
@@ -1966,7 +1988,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);
@@ -1983,6 +2005,7 @@
         systemUser.setSalt(salt);
         systemUser.setPassword(member.getPassward());
         systemUser.setStatus(Constants.ZERO);
+        systemUser.setSource(Constants.TWO);
         systemUserMapper.insert(systemUser);
 
     }

--
Gitblit v1.9.3