From e4a06e0730dc0aa6ced97cbb3362d6b8ef473d39 Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期四, 27 三月 2025 15:56:34 +0800
Subject: [PATCH] 最新版本541200007

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java |  277 +++++++++++++++++++++++++++++++++++++++++++++++-------
 1 files changed, 239 insertions(+), 38 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 a2446bb..6f0f506 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
@@ -19,9 +19,10 @@
 import com.doumee.core.haikang.model.param.respose.UserAddResponse;
 import com.doumee.core.haikang.model.param.respose.UserDelResponse;
 import com.doumee.core.haikang.service.HKService;
-import com.doumee.core.model.LoginUserInfo;
-import com.doumee.core.model.PageData;
-import com.doumee.core.model.PageWrap;
+import com.doumee.service.business.third.TmsService;
+import com.doumee.service.business.third.model.LoginUserInfo;
+import com.doumee.service.business.third.model.PageData;
+import com.doumee.service.business.third.model.PageWrap;
 import com.doumee.core.utils.*;
 import com.doumee.core.wx.WXConstant;
 import com.doumee.dao.admin.request.LaborEmpowerDTO;
@@ -31,11 +32,13 @@
 import com.doumee.dao.admin.response.StagingDataVO;
 import com.doumee.dao.business.*;
 import com.doumee.dao.business.dao.CompanyMapper;
+import com.doumee.dao.business.dao.MemberMapper;
 import com.doumee.dao.business.dto.RegisterDriverDTO;
 import com.doumee.dao.business.join.MemberJoinMapper;
 import com.doumee.dao.business.join.RetentionJoinMapper;
 import com.doumee.dao.business.join.UserActionJoinMapper;
 import com.doumee.dao.business.model.*;
+import com.doumee.dao.business.model.Member;
 import com.doumee.dao.system.SystemUserMapper;
 import com.doumee.dao.system.model.SystemDictData;
 import com.doumee.dao.system.model.SystemUser;
@@ -47,11 +50,14 @@
 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.business.third.model.request.TmsEmployeeListRequest;
+import com.doumee.service.business.third.model.response.TmsEmployeeListResponse;
 import com.doumee.service.system.SystemLoginService;
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
 import org.apache.commons.collections.CollectionUtils;
 import org.apache.commons.lang3.RandomStringUtils;
 import org.apache.commons.lang3.StringUtils;
+import org.apache.poi.ss.usermodel.CellType;
 import org.apache.shiro.SecurityUtils;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -117,7 +123,13 @@
     @Autowired
     private VisitsMapper visitsMapper;
     @Autowired
+    private TmsService tmsService;
+    @Autowired
     private SystemUserMapper systemUserMapper;
+    @Autowired
+    private CarsMapper carsMapper;
+    @Autowired
+    private ParkBookMapper parkBookMapper;
 
     @Autowired
     @Lazy
@@ -153,6 +165,10 @@
             }else{
                 throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝鍛樺伐淇℃伅鍚屾瀹夐槻骞冲彴澶辫触锛岃绋嶅悗閲嶈瘯锛�");
             }
+        }catch (BusinessException e){
+            //濡傛灉鍙戠敓寮傚父锛屽垹闄ゅ凡缁忓垱寤虹殑浜哄憳淇℃伅
+            deleteHkUserBiz(new String[]{insert.getHkId()});
+            throw  e;
         }catch (Exception e){
             //濡傛灉鍙戠敓寮傚父锛屽垹闄ゅ凡缁忓垱寤虹殑浜哄憳淇℃伅
             e.printStackTrace();
@@ -185,6 +201,7 @@
         user.setSource(Constants.ZERO);
         user.setDeleted(Boolean.FALSE);
         user.setFixed(Boolean.FALSE);
+        user.setPinyin(Constants.getChinesePingyin(user.getRealname()));
         user.setStatus(Constants.ZERO);
         return user;
     }
@@ -213,6 +230,7 @@
         insert.setSex(Constants.getSexByCardNo( member.getIdcardNo()));//鏍规嵁韬唤璇佸彿鑾峰彇鎬у埆
         insert.setJobDate(member.getJobDate());
         insert.setIsDangyuan(member.getIsDangyuan());
+        insert.setPinyin(Constants.getChinesePingyin(member.getName()));
         insert.setPositionId(member.getPositionId());
         if(StringUtils.isNotBlank(member.getIdcardNo())){
             insert.setBirthday( DateUtil.fromStringToDate("yyyyMMdd",IdcardUtil.getBirthByIdCard(member.getIdcardNo())));
@@ -243,7 +261,7 @@
      * @return
      */
     private boolean dealHkUserBiz(Member insert) {
-        String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode()
+        String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_LOCAL_RESOURCE_PATH).getCode()
                 +systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode();
         UserAddRequest hkAddRequest = HkSyncOrgUserToHKServiceImpl.getUserAddModel(insert,path,Constants.ZERO);
         if(hkAddRequest == null){
@@ -266,7 +284,7 @@
         return false;
     }
     private boolean dealHkUserForUpdateBiz(Member update ) {
-        String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode()
+        String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_LOCAL_RESOURCE_PATH).getCode()
                 +systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode();
 
         UserAddRequest hkAddRequest = HkSyncOrgUserToHKServiceImpl.getUserAddModel(update,path,Constants.ONE);
@@ -418,7 +436,6 @@
                         .ne(Member::getId,member.getId())) >0){
                     throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "韬唤璇佸彿銆�"+member.getIdcardNoNew()+"銆戝凡琚娇鐢紝涓嶈兘閲嶅");
                 }
-
                 member.setSex(Constants.getSexByCardNo( member.getIdcardNoNew()));//鏍规嵁韬唤璇佸彿鑾峰彇鎬у埆
                 member.setIdcardDecode( Constants.getTuominStr(member.getIdcardNoNew()));
                 member.setIdcardNo(encrptNo);
@@ -472,6 +489,7 @@
                             .set(SystemUser::getUpdateUser,member.getLoginUserInfo().getId())
                             .set(SystemUser::getUpdateTime,new Date())
                             .set(StringUtils.isNotBlank(member.getFaceImg()),SystemUser::getAvatar,member.getFaceImg())
+                            .set(StringUtils.isNotBlank(member.getName()),SystemUser::getPinyin,Constants.getChinesePingyin(member.getName()))
                             .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())
@@ -501,6 +519,8 @@
             //濡傛灉浜鸿劯娌″彉鍖�
             member.setFaceImg(null);
         }
+
+        member.setPinyin(Constants.getChinesePingyin(member.getName()));
         return model;
     }
 
@@ -563,11 +583,13 @@
     @Override
     @Transactional(rollbackFor = {BusinessException.class,Exception.class})
     public void deleteById(Integer id,LoginUserInfo loginUserInfo) {
+
+        Date date =new Date();
         Member member=new Member();
         member.setId(id);
         member.setIsdeleted(Constants.ONE);
         member.setEditor(loginUserInfo.getId());
-        member.setEditDate(new Date());
+        member.setEditDate(date);
         member.setHkStatus(Constants.ZERO);
         member.setRemark("浜哄憳宸插垹闄わ紝绛夊緟鍒犻櫎闂ㄧ鏉冮檺");
         memberMapper.updateById(member);
@@ -581,8 +603,30 @@
                 .set(SystemUser::getUpdateUser,member.getEditor())
                 .set(SystemUser::getUpdateTime,member.getEditDate())
         );
-
         saveUserActionBiz(member,loginUserInfo,Constants.UserActionType.DELETE,userActionJoinMapper,JSONObject.toJSONString(member));
+        List<Cars> carsList = carsMapper.selectList(new QueryWrapper<Cars>().lambda()
+                .eq(Cars::getMemberId,member.getId())
+                .eq(Cars::getIsdeleted,Constants.ZERO)
+                .eq(Cars::getAuthStatus,Constants.ONE)//宸叉巿鏉冨寘鏈熺殑杞﹁締
+        );
+        if (carsList!=null && carsList.size()>0){
+            for(Cars car :carsList){
+               if(Constants.equalsInteger(car.getAuthStatus(),Constants.ONE)){
+                   carsMapper.update(null,new UpdateWrapper<Cars>().lambda()
+                           .eq(Cars::getId,car.getId())
+                           .set(Cars::getStartTime,null)
+//                           .set(Cars::getMemberId,null)
+                           .set(Cars::getEndTime,null)
+                           .set(Cars::getAuthTimeType,null)
+                           .set(Cars::getAuthStatus,Constants.ZERO)
+                           .set(Cars::getEditDate,member.getEditDate())
+                           .set(Cars::getEdirot,member.getEditor())
+                   );
+                   //鍒犻櫎宸叉巿鏉冧笅鍙戠殑鍖呮湡鎺堟潈
+                   CarsServiceImpl.dealCancelBookBiz(car.getCode(),date,parkBookMapper);
+               }
+            }
+        }
     }
 
 
@@ -887,7 +931,7 @@
             loginUserInfo = updateMember.getLoginUserInfo();
         }
         //鏍¢獙鍙傛暟 骞朵笖鏇存柊systemuser 鎵嬫満鍙峰拰宸ュ彿淇℃伅锛堝鏋滈渶瑕佷慨鏀圭殑璇濓級
-         Member model =   isMemberUpdateParamValid(updateMember);
+        Member model =   isMemberUpdateParamValid(updateMember);
         updateMember.setEditor(loginUserInfo.getId());
         updateMember.setEditDate(new Date());
         //娴峰悍浜哄憳鏂板涓氬姟
@@ -902,6 +946,7 @@
                     .set(StringUtils.isNotBlank(updateMember.getName()),Member::getName,updateMember.getName())
                     .set(Member::getEditDate,updateMember.getEditDate())
                     .set(Member::getEditor,updateMember.getEditor())
+                    .set(StringUtils.isNotBlank(updateMember.getName()),Member::getPinyin,Constants.getChinesePingyin(updateMember.getName()))
                     .set(StringUtils.isNotBlank(updateMember.getIdcardNo()),Member::getIdcardNo,updateMember.getIdcardNo())
                     .set(StringUtils.isNotBlank(updateMember.getIdcardDecode()),Member::getIdcardDecode,updateMember.getIdcardDecode())
                     .set( Member::getAuthStatus,Constants.ZERO)
@@ -913,11 +958,11 @@
                     .set(StringUtils.isNotBlank(updateMember.getFaceImg()),Member::getFaceImg,updateMember.getFaceImg())
                     .set(updateMember.getFaceId()!=null,Member::getFaceId,updateMember.getFaceId())
                     .set(updateMember.getCompanyId()!=null,Member::getCompanyId,updateMember.getCompanyId())
-                    .set(StringUtils.isNotBlank(updateMember.getCode()),Member::getCode,updateMember.getCode())
+                    .set(Member::getCode,updateMember.getCode())
+//                    .set(StringUtils.isNotBlank(updateMember.getCode()),Member::getCode,updateMember.getCode())
                     .set( updateMember.getPositionId()!=null,Member::getPositionId,updateMember.getPositionId())
                     .set( updateMember.getIsDangyuan()!=null,Member::getIsDangyuan,updateMember.getIsDangyuan())
                     .set( updateMember.getJobDate()!=null,Member::getJobDate,updateMember.getJobDate())
-                    .set(StringUtils.isNotBlank(updateMember.getCode()),Member::getCode,updateMember.getCode())
                     .eq(Member::getId,updateMember.getId()));
             dealTrainTIme(updateMember,1,loginUserInfo);
             cancelAllMemberEmpower(updateMember,memberRoleMapper,empowerMapper);
@@ -951,7 +996,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 userAction=new UserAction();
         userAction.setIsdeleted(Constants.ZERO);
         userAction.setCreateDate(updateMember.getEditDate());
         userAction.setCreator(updateMember.getEditor());
@@ -970,7 +1015,7 @@
         wrapper.lambda().ne(Member::getRemark,"浜鸿劯宸插悓姝ユ渶鏂�");
         List<Member> list =memberMapper.selectList(wrapper);
        if(list!=null){
-           String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode()
+           String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_LOCAL_RESOURCE_PATH).getCode()
                    +systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode();
            for(Member m : list){
              String faceId=  HkSyncOrgUserToHKServiceImpl.dealMemberFace(m,path);
@@ -1152,6 +1197,7 @@
         }
         queryWrapper.eq(Member::getIsdeleted,Constants.ZERO);
         queryWrapper.eq(Member::getWorkStatus,Constants.ZERO);
+        queryWrapper.orderByAsc(Member::getPinyin);
         List<Member> list =  memberJoinMapper.selectJoinList(Member.class,queryWrapper);
 //        if(list!=null){
 //            for(Member m : list){
@@ -1178,6 +1224,7 @@
             queryWrapper.eq(Member::getCompanyId,member.getCompanyId());
         }
         queryWrapper.eq(Member::getIsdeleted,Constants.ZERO);
+        queryWrapper.orderByAsc(Member::getPinyin);
         List<Member> list =  memberJoinMapper.selectJoinList(Member.class,queryWrapper);
         if(list!=null){
             for(Member m : list){
@@ -1185,6 +1232,46 @@
             }
         }
         return  list;
+    }
+    @Override
+    public  void initPinyinTool(){
+        MPJLambdaWrapper<Member> queryWrapper = new MPJLambdaWrapper<>();
+        List<Member> list =  memberJoinMapper.selectList(queryWrapper);
+        if(list!=null){
+            for(Member m : list){
+               if(m.getName()!=null){
+                   Member u = new Member();
+                   u.setId(m.getId());
+                   u.setPinyin(Constants.getChinesePingyin(m.getName()));
+                   memberMapper.updateById(u);
+               }
+            }
+        }
+
+        MPJLambdaWrapper<SystemUser> q1 = new MPJLambdaWrapper<>();
+        List<SystemUser> list1 =  systemUserMapper.selectList(q1);
+        if(list1!=null){
+            for(SystemUser m : list1){
+                if(m.getRealname()!=null){
+                    SystemUser u = new SystemUser();
+                    u.setId(m.getId());
+                    u.setPinyin(Constants.getChinesePingyin(m.getRealname()));
+                    systemUserMapper.updateById(u);
+                }
+            }
+        }
+        MPJLambdaWrapper<Company> q2 = new MPJLambdaWrapper<>();
+        List<Company> list2 =  companyMapper.selectList(q2);
+        if(list2!=null){
+            for(Company m : list2){
+                if(m.getName()!=null){
+                    Company u = new Company();
+                    u.setId(m.getId());
+                    u.setPinyin(Constants.getChinesePingyin(m.getName()));
+                    companyMapper.updateById(u);
+                }
+            }
+        }
     }
 
     @Override
@@ -1422,7 +1509,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.equalsInteger(pageWrap.getModel().getIsdeleted(),Constants.ONE),Member::getCreateDate)
+                .orderByAsc(!Constants.equalsInteger(pageWrap.getModel().getIsdeleted(),Constants.ONE),Member::getPinyin)
                 .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());
@@ -1528,7 +1615,7 @@
                 .eq(Objects.nonNull(pageWrap.getModel().getStatus()),Member::getStatus,pageWrap.getModel().getStatus())
                 .eq(Member::getType,Constants.memberType.visitor)
                 .eq(Member::getIsdeleted,Constants.ZERO)
-                .orderByDesc(Member::getCreateDate);
+                .orderByAsc(Member::getPinyin);
         if(Constants.formatIntegerNum(dataSyncConfig.getOrgUserDataOrigin())==DataSyncConfig.origin.erp){
             queryWrapper.eq( StringUtils.isNotBlank(pageWrap.getModel().getErpOrgId()),Member::getErpOrgId,pageWrap.getModel().getErpOrgId());
         }else{
@@ -1566,7 +1653,7 @@
 
         queryWrapper.selectAs(Position::getName,Member::getPositionName);
         queryWrapper.leftJoin(Position.class,Position::getId,Member::getPositionId);
-
+        queryWrapper.orderByAsc(Member::getPinyin);
         IPage<Member> memberIPage = memberJoinMapper.selectJoinPage(page, Member.class,queryWrapper);
         return PageData.from(memberIPage);
 
@@ -1659,9 +1746,11 @@
                 .leftJoin(Company.class,Company::getId,Member::getCompanyId)
                 .eq(Member::getIsdeleted,Constants.ZERO)
                 .eq(Company::getType,Constants.ZERO)
-                .eq(Member::getStatus,Constants.ZERO)
+                .eq(Member::getStatus,Constants.ZERO
+                )
                 .isNotNull(Member::getHkId)
-                .apply("to_days(LAST_VISIT_DATE)+ "+days+" < to_days(now())" ));
+                .apply("to_days(LAST_VISIT_DATE)+ "+days+" < to_days(now())" )
+                .orderByAsc(Member::getPinyin));
         if(CollectionUtils.isEmpty(memberList)){
            return;
         }
@@ -1697,6 +1786,7 @@
     /**
      * 寰俊鎺堟潈鎺ュ彛
      * @param code
+     * 鏉ユ簮:0=鍙告満锛�1=璁垮锛�2=鍐呴儴鍛樺伐
      * @return
      */
     @Override
@@ -1708,15 +1798,120 @@
         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 = code;
-//        if(!Objects.isNull(tokenJson.get("access_token"))){
-//            openId = tokenJson.getString("openid");
-//        }
-//        String openId = "12345";
+        JSONObject tokenJson = JSONObject.parseObject(HttpsUtil.get(getTokenUrl,true));
+        String openId = "";
+        if(Objects.nonNull(tokenJson)&&!Objects.isNull(tokenJson.get("access_token"))){
+            openId = tokenJson.getString("openid");
+        }
         WxAuthorizeVO wxAuthorizeVO = new WxAuthorizeVO();
+        if(StringUtils.isBlank(openId)){
+            return wxAuthorizeVO;
+        }
         wxAuthorizeVO.setOpenid(openId);
-        //鏍规嵁openId 鏌ヨ鐢ㄦ埛淇℃伅
+        if(source==1){
+            //澶勭悊鏅�氳瀹汉鍛樿嚜鍔ㄦ巿鏉冮�昏緫
+            dealVisitUserAuthBiz(wxAuthorizeVO,openId,source);
+        }else if(source == 3){
+            //澶勭悊tms绠℃帶浜哄憳鑷姩鎺堟潈閫昏緫
+            dealGkUserAuthBiz(wxAuthorizeVO,openId,source);
+        }else if(source == 0){
+            //濡傛灉鏄徃鏈猴紝鍒欎粠system_user鏌ヨ
+            dealDriverUserAuthBiz(wxAuthorizeVO,openId,source);
+        }else{
+            //濡傛灉鏄唴閮ㄤ汉鍛橈紝鍒欎粠system_user鏌ヨ
+            dealSystemUserAuthBiz(wxAuthorizeVO,openId,source);
+        }
+        return wxAuthorizeVO;
+    }
+
+    private void dealSystemUserAuthBiz(WxAuthorizeVO wxAuthorizeVO, String openId, Integer source) {
+        SystemUser user = systemUserMapper.selectOne(new QueryWrapper<SystemUser>().lambda()
+                .eq(SystemUser::getOpenid,openId)
+                .in(SystemUser::getType,Constants.memberType.internal)
+                .eq(SystemUser::getDeleted,Constants.ZERO)
+                .last(" limit 1 "));
+        //闈炶瀹㈢敤鎴� 杩涜鍒ゆ柇鏄惁瀛樺湪鐢ㄦ埛
+        if(!Objects.isNull(user)){
+            Member member = memberMapper.selectById(user.getMemberId());
+            if(member == null || member.getIsdeleted() == Constants.ONE){
+                return;
+//                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鐢ㄦ埛宸插垹闄�,璇疯仈绯荤鐞嗗憳");
+            }
+            if(member.getStatus() != Constants.ZERO){
+                return;
+//                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鐢ㄦ埛宸茬鐢�,璇疯仈绯荤鐞嗗憳");
+            }
+            if(StringUtils.isNotBlank(member.getIdcardNo())){
+                member.setIdcardDecode(DESUtil.decrypt(Constants.EDS_PWD, member.getIdcardNo()));
+            }
+            String prefixUrl = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() +
+                    systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode();
+            member.setPrefixUrl(prefixUrl);
+            wxAuthorizeVO.setMember(member);
+            //鍙告満 涓� 鍐呴儴浜哄憳 鎻愪緵token
+            String token = systemLoginService.loginByUserId(user.getId());
+            wxAuthorizeVO.setToken(token);
+        }
+    }
+    private void dealDriverUserAuthBiz(WxAuthorizeVO wxAuthorizeVO, String openId, Integer source) {
+        SystemUser user = systemUserMapper.selectOne(new QueryWrapper<SystemUser>().lambda()
+                .eq(SystemUser::getOpenid,openId)
+                .in(SystemUser::getType,Constants.memberType.internal,Constants.memberType.driver)
+                .eq(SystemUser::getDeleted,Constants.ZERO)
+                .last(" limit 1 "));
+        //闈炶瀹㈢敤鎴� 杩涜鍒ゆ柇鏄惁瀛樺湪鐢ㄦ埛
+        if(!Objects.isNull(user)){
+            Member member = memberMapper.selectById(user.getMemberId());
+            if(member == null || member.getIsdeleted() == Constants.ONE){
+                return;
+//                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鐢ㄦ埛宸插垹闄�,璇疯仈绯荤鐞嗗憳");
+            }
+            if(member.getStatus() != Constants.ZERO){
+                return;
+//                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鐢ㄦ埛宸茬鐢�,璇疯仈绯荤鐞嗗憳");
+            }
+            if(StringUtils.isNotBlank(member.getIdcardNo())){
+                member.setIdcardDecode(DESUtil.decrypt(Constants.EDS_PWD, member.getIdcardNo()));
+            }
+            String prefixUrl = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() +
+                    systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode();
+            member.setPrefixUrl(prefixUrl);
+            wxAuthorizeVO.setMember(member);
+            //鍙告満 涓� 鍐呴儴浜哄憳 鎻愪緵token
+            String token = systemLoginService.loginByUserId(user.getId());
+            wxAuthorizeVO.setToken(token);
+        }
+    }
+
+    private void dealGkUserAuthBiz(WxAuthorizeVO wxAuthorizeVO, String openId, Integer source) {
+        //濡傛灉鏄徃鏈烘垨鑰呭唴閮ㄤ汉鍛橈紝鍒欎粠system_user鏌ヨ
+        SystemUser user = systemUserMapper.selectOne(new QueryWrapper<SystemUser>().lambda()
+                .eq(SystemUser::getOpenid,openId)
+                .eq(SystemUser::getType,source)
+//                .eq(Objects.nonNull(source)&&Constants.equalsInteger(source,Constants.TWO),SystemUser::getType,source)
+                .eq(SystemUser::getDeleted,Constants.ZERO)
+                .last(" limit 1 "));
+        //闈炶瀹㈢敤鎴� 杩涜鍒ゆ柇鏄惁瀛樺湪鐢ㄦ埛
+        if(!Objects.isNull(user)){
+            TmsEmployeeListRequest tp = new TmsEmployeeListRequest();
+            tp.setTel(user.getMobile());
+            TmsEmployeeListResponse response = tmsService.getEmployeeList(tp);
+            if(response == null || response.getTel()==null){
+                return;
+//                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝璇ヨ处鎴蜂汉鍛樹俊鎭笉姝g‘锛屽鏈夌枒闂鑱旂郴绯荤粺绠$悊鍛樻煡鐪嬶紒");
+            }
+
+            Member member = new Member();
+            member.setPhone(user.getMobile());
+//            member.setId(user.getId());
+            wxAuthorizeVO.setMember(member);
+            //鍙告満 涓� 鍐呴儴浜哄憳 鎻愪緵token
+            String token = systemLoginService.loginByUserId(user.getId());
+            wxAuthorizeVO.setToken(token);
+        }
+    }
+
+    private void dealVisitUserAuthBiz(WxAuthorizeVO wxAuthorizeVO, String openId,Integer source) {
         Member member = memberJoinMapper.selectJoinOne(Member.class,new MPJLambdaWrapper<Member>()
                 .selectAll(Member.class)
                 .selectAs(Company::getName,Member::getCompanyName)
@@ -1730,13 +1925,15 @@
         //闈炶瀹㈢敤鎴� 杩涜鍒ゆ柇鏄惁瀛樺湪鐢ㄦ埛
         if(!Objects.isNull(member)){
             if(member.getIsdeleted() == Constants.ONE){
-                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鐢ㄦ埛宸插垹闄�,璇疯仈绯荤鐞嗗憳");
+                return;
+//                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鐢ㄦ埛宸插垹闄�,璇疯仈绯荤鐞嗗憳");
             }
             if(member.getStatus() != Constants.ZERO){
-                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鐢ㄦ埛宸茬鐢�,璇疯仈绯荤鐞嗗憳");
+                return;
+//                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鐢ㄦ埛宸茬鐢�,璇疯仈绯荤鐞嗗憳");
             }
             if(StringUtils.isNotBlank(member.getIdcardNo())){
-               member.setIdcardDecode(DESUtil.decrypt(Constants.EDS_PWD, member.getIdcardNo()));
+                member.setIdcardDecode(DESUtil.decrypt(Constants.EDS_PWD, member.getIdcardNo()));
             }
             String prefixUrl = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() +
                     systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode();
@@ -1752,10 +1949,7 @@
                 }
             }
         }
-        return wxAuthorizeVO;
     }
-
-
 
 
     @Override
@@ -1767,12 +1961,13 @@
                 .selectAs(Position::getName,Member::getPositionName)
                 .leftJoin(Position.class,Position::getId,Member::getPositionId)
                 .eq(StringUtils.isNotBlank(checkVisitedDTO.getMobile()),Member::getPhone,checkVisitedDTO.getMobile())
-                .eq(StringUtils.isNotBlank(checkVisitedDTO.getName()),Member::getName,checkVisitedDTO.getName())
+                .like(StringUtils.isNotBlank(checkVisitedDTO.getName()),Member::getName,checkVisitedDTO.getName())
                 .eq(Member::getIsdeleted,Constants.ZERO)
                 .eq(Member::getStatus,Constants.ZERO)
                 .eq(Member::getWorkStatus,Constants.ZERO)
                 .eq(Member::getCanVisit,Constants.ONE)
                 .eq(Company::getType,Constants.ONE)
+                .orderByAsc(Member::getPinyin)
         );
         List<MemberVO> memberVOList = new ArrayList<>();
         if (com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(memberList)) {
@@ -1809,7 +2004,8 @@
             queryWrapper.and(StringUtils.isNotBlank(visitMemberDTO.getName()), ms->ms.like(Member::getPhone,visitMemberDTO.getName())
                     .or().like(Member::getPhone,visitMemberDTO.getName()));
         }
-        queryWrapper.orderByDesc(Visits::getCreateDate);
+        queryWrapper.orderByAsc(Member::getPinyin);
+//      queryWrapper.orderByDesc(Visits::getCreateDate);
         IPage<MemberVO> result = memberJoinMapper.selectJoinPage(page, MemberVO.class,queryWrapper);
 
         String prefixUrl = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() +
@@ -1881,7 +2077,7 @@
             ExcelImporter ie = null;
             List<MemberImport> dataList =null;
             try {
-                ie = new ExcelImporter(file,2,0);
+                ie = new ExcelImporter(file,1,0, CellType.STRING); // 纭繚鍗曞厓鏍肩被鍨嬩负瀛楃涓�);
                 dataList = ie.getDataList(MemberImport.class,null);
             }  catch (Exception e) {
                 e.printStackTrace();
@@ -1951,6 +2147,10 @@
             throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝鍛樺伐淇℃伅瀵煎叆澶辫触锛岃绋嶅悗閲嶈瘯锛�");
         }
     }
+
+    public static void main(String[] args) {
+        System.out.println(PhoneUtil.isPhone("18156047603"));
+    }
     private Member checkModelParam(MemberImport model, List<Member> newList
             ,int index
             ,LoginUserInfo loginUserInfo
@@ -2018,7 +2218,7 @@
     private Company findCompanyFromList(String companyName, List<Company> companyList) {
         if(companyList !=null){
             for(Company company : companyList){
-                if(StringUtils.equals(companyName,company.getName())){
+                if(StringUtils.equals(companyName,company.getCompanyNamePath())){
                     return  company;
                 }
             }
@@ -2060,6 +2260,7 @@
         }
         if(memberMapper.selectCount(new QueryWrapper<Member>().lambda()
                 .eq(Member::getIsdeleted,Constants.ZERO)
+                .in(Member::getType,Constants.memberType.gkuser,Constants.memberType.visitor)
                 .eq(Member::getPhone,registerDriverDTO.getPhone())
         )>Constants.ZERO){
             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鎵嬫満鍙峰凡娉ㄥ唽!");
@@ -2070,14 +2271,13 @@
         )>Constants.ZERO){
             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鎵嬫満鍙峰凡娉ㄥ唽!");
         };
-
         smsEmailService.validateCode(registerDriverDTO.getValidCode(),registerDriverDTO.getPhone());
         String salt = RandomStringUtils.randomAlphabetic(6);
-       ;
+
         Member member = new Member();
         member.setCreateDate(new Date());
         member.setIsdeleted(Constants.ZERO);
-        member.setType(Constants.THREE);
+        member.setType(Constants.memberType.driver);
         member.setName(registerDriverDTO.getName());
         member.setPhone(registerDriverDTO.getPhone());
         member.setStatus(Constants.ZERO);
@@ -2095,6 +2295,7 @@
         systemUser.setSalt(salt);
         systemUser.setPassword(member.getPassward());
         systemUser.setStatus(Constants.ZERO);
+        systemUser.setType(Constants.memberType.driver);
         systemUser.setSource(Constants.TWO);
         systemUserMapper.insert(systemUser);
 

--
Gitblit v1.9.3