From 1a6eb2ac656de3b35c64db8b9006db2ed9248872 Mon Sep 17 00:00:00 2001 From: yanghui <2536613402@qq.com> Date: 星期五, 04 十一月 2022 17:43:13 +0800 Subject: [PATCH] Merge branch 'huacheng_test' into haucheng_panzhihua --- springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/UserServiceImpl.java | 3498 ++++++++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 3,100 insertions(+), 398 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/UserServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/UserServiceImpl.java index e111781..0a01c2d 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/UserServiceImpl.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/UserServiceImpl.java @@ -1,34 +1,44 @@ package com.panzhihua.service_user.service.impl; -import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; -import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; -import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; -import com.baomidou.mybatisplus.core.metadata.IPage; -import com.baomidou.mybatisplus.extension.plugins.pagination.Page; -import com.panzhihua.common.constants.UserConstants; -import com.panzhihua.common.exceptions.ServiceException; -import com.panzhihua.common.model.dtos.PageDTO; -import com.panzhihua.common.model.dtos.community.ExportUserDTO; -import com.panzhihua.common.model.dtos.community.NoticeReadDTO; -import com.panzhihua.common.model.dtos.user.EexcelUserDTO; -import com.panzhihua.common.model.dtos.user.PageFeedBackDTO; -import com.panzhihua.common.model.dtos.user.PageUserAppletsBackstageDTO; -import com.panzhihua.common.model.dtos.user.SysUserFeedbackDTO; -import com.panzhihua.common.model.vos.*; -import com.panzhihua.common.model.vos.community.ComActVO; -import com.panzhihua.common.model.vos.community.ComMngVolunteerMngVO; -import com.panzhihua.common.model.vos.partybuilding.ActivityManagerVO; +import static java.util.Objects.isNull; +import static java.util.Objects.nonNull; +import static org.apache.commons.lang3.StringUtils.isNotBlank; + +import java.math.BigDecimal; +import java.text.SimpleDateFormat; +import java.util.*; +import java.util.concurrent.TimeUnit; +import java.util.stream.Collectors; + +import javax.annotation.Resource; + +import cn.hutool.core.date.DateTime; +import cn.hutool.core.date.DateUnit; +import cn.hutool.core.date.DateUtil; +import cn.hutool.core.util.ArrayUtil; +import cn.hutool.core.util.NumberUtil; +import cn.hutool.core.util.StrUtil; +import cn.hutool.core.util.*; +import com.alibaba.fastjson.JSON; +import com.alibaba.fastjson.JSONObject; +import com.fasterxml.jackson.core.JsonProcessingException; +import com.fasterxml.jackson.databind.ObjectMapper; +import com.panzhihua.common.model.dtos.community.microCommercialStreet.BindUserPhoneDTO; +import com.panzhihua.common.model.dtos.partybuilding.ComPbCheckUserDTO; +import com.panzhihua.common.model.vos.community.ComAreaTownCommunityVO; +import com.panzhihua.common.model.vos.community.acid.ComActAcidCheckRecordVO; +import com.panzhihua.common.model.vos.community.acid.ComActAcidMemberVO; +import com.panzhihua.common.model.vos.community.acid.ComActAcidRecordVO; +import com.panzhihua.common.model.vos.community.microCommercialStreet.McsLoginUserInfoVO; +import com.panzhihua.common.model.vos.sanshuo.ComSanshuoExpertVO; import com.panzhihua.common.model.vos.user.*; -import com.panzhihua.common.utlis.IdCard; -import com.panzhihua.common.utlis.RealNameUtil; +import com.panzhihua.common.service.community.CommunityService; +import com.panzhihua.common.utlis.*; import com.panzhihua.service_user.dao.*; -import com.panzhihua.service_user.model.dos.*; -import com.panzhihua.service_user.model.dtos.DataKanbanDTO; -import com.panzhihua.service_user.service.UserService; -import lombok.extern.slf4j.Slf4j; +import com.panzhihua.service_user.entity.SysAppConfig; +import com.panzhihua.service_user.entity.SysTemplateConfig; import org.apache.commons.lang.time.DateFormatUtils; import org.apache.commons.lang.time.DateUtils; - import org.springframework.beans.BeanUtils; import org.springframework.data.redis.core.StringRedisTemplate; import org.springframework.data.redis.core.ValueOperations; @@ -36,11 +46,71 @@ import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.ObjectUtils; -import org.springframework.util.StringUtils; -import javax.annotation.Resource; -import java.util.*; -import java.util.stream.Collectors; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.panzhihua.common.constants.Constants; +import com.panzhihua.common.constants.UserConstants; +import com.panzhihua.common.exceptions.ServiceException; +import com.panzhihua.common.model.dtos.DataKanBansDto; +import com.panzhihua.common.model.dtos.PageDTO; +import com.panzhihua.common.model.dtos.community.ExportUserDTO; +import com.panzhihua.common.model.dtos.community.NoticeReadDTO; +import com.panzhihua.common.model.dtos.community.convenient.ConvenientMerchantDTO; +import com.panzhihua.common.model.dtos.community.convenient.DisableOrEnableConvenientMerchantDTO; +import com.panzhihua.common.model.dtos.community.microCommercialStreet.McsMerchantDTO; +import com.panzhihua.common.model.dtos.grid.EventGridMemberAddDTO; +import com.panzhihua.common.model.dtos.grid.EventGridMemberEditAdminDTO; +import com.panzhihua.common.model.dtos.grid.EventGridMemberEditStatusDTO; +import com.panzhihua.common.model.dtos.grid.EventGridMemberPassResetDTO; +import com.panzhihua.common.model.dtos.grid.PageEventGridMemberRelationDTO; +import com.panzhihua.common.model.dtos.user.EexcelUserDTO; +import com.panzhihua.common.model.dtos.user.PageFeedBackDTO; +import com.panzhihua.common.model.dtos.user.PageUserAppletsBackstageDTO; +import com.panzhihua.common.model.dtos.user.SysUserEditTipsDTO; +import com.panzhihua.common.model.dtos.user.SysUserFeedbackDTO; +import com.panzhihua.common.model.vos.AppletUserInfoVO; +import com.panzhihua.common.model.vos.EditUserInfoPassAppDTO; +import com.panzhihua.common.model.vos.IndexDataKanbanVO; +import com.panzhihua.common.model.vos.IndexDataVO; +import com.panzhihua.common.model.vos.LoginUserInfoVO; +import com.panzhihua.common.model.vos.R; +import com.panzhihua.common.model.vos.SystemmanagementConfigVO; +import com.panzhihua.common.model.vos.community.ComActVO; +import com.panzhihua.common.model.vos.community.ComMngVolunteerMngVO; +import com.panzhihua.common.model.vos.community.IndexUserCommunityVo; +import com.panzhihua.common.model.vos.community.IndexUserStatisticsVo; +import com.panzhihua.common.model.vos.community.IndexUserStreetVo; +import com.panzhihua.common.model.vos.grid.GridMemberVO; +import com.panzhihua.common.model.vos.grid.admin.GridMemberBuildingVO; +import com.panzhihua.common.model.vos.partybuilding.ActivityManagerVO; +import com.panzhihua.common.model.vos.shop.ShopStoreVO; +import com.panzhihua.service_user.model.dos.ComActFourMember; +import com.panzhihua.service_user.model.dos.ComMngFamilyInfoDO; +import com.panzhihua.service_user.model.dos.ComMngUserTagDO; +import com.panzhihua.service_user.model.dos.EventGridMemberBuildingRelationDO; +import com.panzhihua.service_user.model.dos.LcCompareCodeMemberDO; +import com.panzhihua.service_user.model.dos.SysMenuDO; +import com.panzhihua.service_user.model.dos.SysOperLogDO; +import com.panzhihua.service_user.model.dos.SysRoleDO; +import com.panzhihua.service_user.model.dos.SysRoleMenuDO; +import com.panzhihua.service_user.model.dos.SysUserAgreementDO; +import com.panzhihua.service_user.model.dos.SysUserDO; +import com.panzhihua.service_user.model.dos.SysUserFeedbackDO; +import com.panzhihua.service_user.model.dos.SysUserNoticeDO; +import com.panzhihua.service_user.model.dos.SysUserRoleDO; +import com.panzhihua.service_user.model.dtos.DataKanbanDTO; +import com.panzhihua.service_user.model.dtos.UsersStatisticsDTO; +import com.panzhihua.service_user.service.EventGridMemberBuildingRelationService; +import com.panzhihua.service_user.service.UserService; + +import cn.hutool.core.util.IdcardUtil; +import lombok.extern.slf4j.Slf4j; + +// import com.panzhihua.common.service.grid.GridService; /** * @program: springcloud_k8s_panzhihuazhihuishequ @@ -51,6 +121,9 @@ @Slf4j @Service public class UserServiceImpl implements UserService { + + private static final String DEFAULT_IMAGE_URL = "https://www.psciio.com//idcard/91313573d071436ab1f934231b31c6e5.jpg"; + @Resource private UserDao userDao; @Resource @@ -77,7 +150,53 @@ private SysMenuDAO sysMenuDAO; @Resource private SysUserInputDAO sysUserInputDAO; + @Resource + private EventGridMemberBuildingRelationService buildingRelationService; + @Resource + private EventGridMemberBuildingRelationMapper eventGridMemberBuildingRelationMapper; + @Resource + private LcCompareMemberCodeMapper lcCompareMemberCodeMapper; + @Resource + private ComActFourMemberDao comActFourMemberDao; + @Resource + private SysAppConfigDao sysAppConfigDao; + @Resource + private SysTemplateConfigDao sysTemplateConfigDao; + @Resource + private ObjectMapper objectMapper; + private static final Integer ALLCOUNTY=1; + private static final Integer ALLSTREET=2; + private static final Integer ALLCOMMUNITY=3; + private static final Integer BYSTREET=4; + private static final Integer BYAREA=5; + private static final String OTHERUSER="其他用户"; + private static final String UPDATEACIDCHECKRECORD="修改排查数据"; + private static final String UPDATEACIDMEMBER="修改防疫工作人员信息"; + private static final String UPDATEACIDRECORD="修改防疫信息数据"; + // @Resource + // private GridService gridService; + + public static void main(String[] args) { + // String encode = new BCryptPasswordEncoder().encode("lbsq123456"); + // System.out.println(encode); + +// List<String> dates = new ArrayList<>(); +// Date date = new Date(); +// for (int i = 19; i >= 0; i--) { +// Date date1 = DateUtils.addDays(date, -i); +// dates.add(DateFormatUtils.format(date1, "MM-dd")); +// } +// System.out.println(dates); + + Date date = new Date(); + Long offset = DateUtil.between(new Date(), DateUtil.beginOfMonth(date), DateUnit.DAY); + System.out.println(offset); + + // BCryptPasswordEncoder encoder = new BCryptPasswordEncoder(); + // boolean matches = encoder.matches("admin1234567", encode); + // System.out.println(matches); + } /** * 小程序微信用户信息更新 @@ -88,8 +207,9 @@ * @return token */ @Override - public R updateInsertUser(String openid, String sessionKey, String unionid) { - SysUserDO sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getOpenid, openid)); + public R updateInsertUser(String openid, String sessionKey, String unionid, String appId) { + SysUserDO sysUserDO = + userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getOpenid, openid)); boolean empty = ObjectUtils.isEmpty(sysUserDO); int num = 0; Date date = new Date(); @@ -103,6 +223,11 @@ sysUserDO1.setLastLoginTime(date); sysUserDO1.setPassword(encode); sysUserDO1.setType(1); + sysUserDO1.setAppId(appId); + //设置默认头像地址 + sysUserDO1.setImageUrl("https://www.psciio.com//idcard/f15c91f940624ed59537ecced1059f18.jpg"); + //设置默认用户名 + sysUserDO1.setNickName("用户" + RandomUtil.randomString(8)); num = userDao.insert(sysUserDO1); } else { String encode = new BCryptPasswordEncoder().encode(UserConstants.PASSWORD); @@ -111,6 +236,7 @@ sysUserDO.setPassword(encode); sysUserDO.setLastLoginTime(date); sysUserDO.setType(1); + sysUserDO.setAppId(appId); num = userDao.updateById(sysUserDO); } if (num > 0) { @@ -153,17 +279,20 @@ */ @Override public R updateUserWeiXinPhone(Long userId, String purePhoneNumber) { - SysUserDO sysUserDO = new SysUserDO(); - sysUserDO.setPhone(purePhoneNumber); - sysUserDO.setUserId(userId); - userDao.updateMemberRole(purePhoneNumber, purePhoneNumber); - userDao.updateServiceTeam(purePhoneNumber, purePhoneNumber); - int i = userDao.updateById(sysUserDO); - if (i > 0) { - return R.ok(); - } else { - return R.fail("维护微信手机号失败"); + SysUserDO sysUserDO = userDao.selectById(userId); + if (sysUserDO != null) { + userDao.updateMemberRole(purePhoneNumber, sysUserDO.getPhone()); + userDao.updateServiceTeam(purePhoneNumber, sysUserDO.getPhone()); + sysUserDO.setPhone(purePhoneNumber); + sysUserDO.setUserId(userId); + int i = userDao.updateById(sysUserDO); + if (i > 0) { + return R.ok(purePhoneNumber); + } else { + return R.fail("维护微信手机号失败"); + } } + return R.ok(sysUserDO.getPhone()); } /** @@ -174,32 +303,73 @@ * @return 用户基本信息、角色 */ @Override - public R<LoginUserInfoVO> getUserInfo(String name, int type) { + public R<LoginUserInfoVO> getUserInfo(String name, int type,String appId) { + //是否为三说会堂行业分中心或专家后台账号 SysUserDO sysUserDO = null; + Boolean isIndustryOrExpertAccount=(userDao.isIndustryCenterAccount(name)>0 || userDao.isExpertAccount(name)>0); if (1 == type) { - sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, type).eq(SysUserDO::getOpenid, name)); - } else { + sysUserDO = userDao.selectOne( + new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, type).eq(SysUserDO::getOpenid, name).eq(SysUserDO::getAppId, appId)); + }else if(isIndustryOrExpertAccount) { + //三说会堂行业分中心或专家后台账号登陆 + sysUserDO = userDao.selectOne( + new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getAccount, name).eq(SysUserDO::getAppId, appId)); + } + else { LambdaQueryWrapper<SysUserDO> wrapper = new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, type); - wrapper.and(sysUserDOLambdaQueryWrapper ->sysUserDOLambdaQueryWrapper .eq(SysUserDO::getAccount, name).or().eq(SysUserDO::getPhone, name)); + if (type == 11) { + //只允许通过account登录 + wrapper.and(sysUserDOLambdaQueryWrapper -> sysUserDOLambdaQueryWrapper.eq(SysUserDO::getAccount, name).eq(SysUserDO::getAppId,appId)); + } else { + wrapper.and(sysUserDOLambdaQueryWrapper -> sysUserDOLambdaQueryWrapper.eq(SysUserDO::getAppId,appId).eq(SysUserDO::getAccount, name).or() + .eq(SysUserDO::getPhone, name)); + } sysUserDO = userDao.selectOne(wrapper); } boolean empty = ObjectUtils.isEmpty(sysUserDO); if (empty) { return R.fail(); } - LoginUserInfoVO loginUserInfoVO=new LoginUserInfoVO(); + LoginUserInfoVO loginUserInfoVO = new LoginUserInfoVO(); + if (nonNull(sysUserDO.getStreetId())){ + loginUserInfoVO.setStreetId(sysUserDO.getStreetId()); + } loginUserInfoVO.setUserId(sysUserDO.getUserId()); loginUserInfoVO.setName(sysUserDO.getName()); loginUserInfoVO.setPassword(sysUserDO.getPassword()); loginUserInfoVO.setStatus(sysUserDO.getStatus()); loginUserInfoVO.setAccount(name); loginUserInfoVO.setType(sysUserDO.getType()); - List<SysRoleDO> roleDOList=roleDAO.selectByUserId(sysUserDO.getUserId()); - Set<String> set=new HashSet<>(); + loginUserInfoVO.setIsRealNamed(sysUserDO.getIdCard() != null);// 暂时 身份证判断实名制 + if(sysUserDO.getCommunityId()!=null){ + ComActVO comActVO = userDao.selectCommunity(sysUserDO.getCommunityId()); + loginUserInfoVO.setCommunityId(sysUserDO.getCommunityId()); + if(comActVO!=null){ + loginUserInfoVO.setComActVO(comActVO); + String areaName=userDao.selectAreaCodeByStreetId(comActVO.getStreetId()); + if(StringUtils.isNotEmpty(areaName)){ + loginUserInfoVO.setAreaName(areaName); + } +// SysAppConfig sysAppConfig=sysAppConfigDao.selectOne(new QueryWrapper<SysAppConfig>().lambda().eq(SysAppConfig::getAreaCode,comActVO.getAreaCode())); +// if(sysAppConfig!=null){ +// loginUserInfoVO.setAppId(sysAppConfig.getAppId()); +// loginUserInfoVO.setAppSecret(sysAppConfig.getSecret()); +// } + } + } + List<SysRoleDO> roleDOList = roleDAO.selectByUserId(sysUserDO.getUserId()); + Set<String> set = new HashSet<>(); if (!ObjectUtils.isEmpty(roleDOList)) { roleDOList.forEach(sysRoleDO -> { set.add(sysRoleDO.getRoleKey()); }); + } + //是否为人大代表 + if (StringUtils.isNotEmpty(sysUserDO.getPhone()) && StringUtils.isNotEmpty(sysUserDO.getName())){ + int i = userDao.isDpcMember(sysUserDO.getPhone(), sysUserDO.getName()); + if (i>0){ + loginUserInfoVO.setIsDpcMember(1); + } } return R.ok(loginUserInfoVO); } @@ -217,34 +387,167 @@ if (empty) { return R.fail(); } - LoginUserInfoVO loginUserInfoVO=new LoginUserInfoVO(); - BeanUtils.copyProperties(sysUserDO,loginUserInfoVO); - List<SysRoleDO> roleDOList=roleDAO.selectByUserId(sysUserDO.getUserId()); - Set<String> set=new HashSet<>(); + LoginUserInfoVO loginUserInfoVO = new LoginUserInfoVO(); + BeanUtils.copyProperties(sysUserDO, loginUserInfoVO); + List<SysRoleDO> roleDOList = roleDAO.selectByUserId(sysUserDO.getUserId()); + Set<String> set = new HashSet<>(); if (!ObjectUtils.isEmpty(roleDOList)) { roleDOList.forEach(sysRoleDO -> { set.add(sysRoleDO.getRoleKey()); }); loginUserInfoVO.setRoles(set); } -// 志愿者状态 + loginUserInfoVO.setIsmemberrole(2); + loginUserInfoVO.setIsFourMember(2); + loginUserInfoVO.setIsCommunityWorker(2); + loginUserInfoVO.setIsPropertyWorker(2); + loginUserInfoVO.setIsSocialWorker(2); + loginUserInfoVO.setIsFmsMember(2); + loginUserInfoVO.setIsAcidMember(0); + // 志愿者状态 String phone = sysUserDO.getPhone(); + Long userCommunityId = sysUserDO.getCommunityId(); + if (userCommunityId != null) { + ComActVO comActVO = userDao.selectCommunity(userCommunityId); + if (comActVO != null) { + loginUserInfoVO.setCommunityName(comActVO.getName()); + loginUserInfoVO.setComActVO(comActVO); + loginUserInfoVO.setAreaCode(comActVO.getAreaCode()); + SysAppConfig sysAppConfig=sysAppConfigDao.selectOne(new QueryWrapper<SysAppConfig>().lambda().eq(SysAppConfig::getAreaCode,comActVO.getAreaCode())); + if(sysAppConfig!=null){ + loginUserInfoVO.setAppId(sysAppConfig.getAppId()); + loginUserInfoVO.setAppSecret(sysAppConfig.getSecret()); + } + } + } if (!ObjectUtils.isEmpty(phone)) { - ComMngVolunteerMngVO comMngVolunteerMngVO= userDao.selectVolunteerMngByPhone(phone); + ComMngVolunteerMngVO comMngVolunteerMngVO = userDao.selectVolunteerMngByPhone(phone); if (ObjectUtils.isEmpty(comMngVolunteerMngVO)) { loginUserInfoVO.setVolunteerStatus(0); - }else{ + } else { int state = comMngVolunteerMngVO.getState().intValue(); loginUserInfoVO.setVolunteerStatus(state); + } + //是否四长四员 + Integer countFourMember=comActFourMemberDao.selectCount(new QueryWrapper<ComActFourMember>().lambda().eq(ComActFourMember::getIdCard,sysUserDO.getIdCard())); + if(countFourMember>0){ + loginUserInfoVO.setIsFourMember(1); + } + //是否是社区物业人员 + int countPropertyWorker = userDao.countPropertyWorker(Long.parseLong(userId), userCommunityId); + if (countPropertyWorker > 0) { + loginUserInfoVO.setIsPropertyWorker(1); + } + //是否微团队成员 + int countFmsMember = userDao.countFmsMember(phone, userCommunityId); + if (countFmsMember > 0) { + loginUserInfoVO.setIsFmsMember(1); + } + //是否是防疫工作人员 + ComActAcidMemberVO acidMember = userDao.selectAcidMemberByPhone(phone); + if (nonNull(acidMember)) { + if(acidMember.getRelationName().equals("panzhihua")||acidMember.getRelationName().equals("西区")||acidMember.getRelationName().equals("东区")||acidMember.getRelationName().equals("仁和区")||acidMember.getRelationName().equals("米易县")||acidMember.getRelationName().equals("盐边县")){ + loginUserInfoVO.setIsAcidMember(1); + } + else { + loginUserInfoVO.setIsAcidMember(2); + } + loginUserInfoVO.setRelationName(acidMember.getRelationName()); + } + Integer count=userDao.selectOrgAdmin(phone); + if(count>0){ + loginUserInfoVO.setIsCheckUnitAdmin(1); + } + Long checkUnitId=userDao.selectCheckUnitId(phone); + if(checkUnitId!=null){ + loginUserInfoVO.setCheckUnitId(checkUnitId); + } + + else { + loginUserInfoVO.setIsCheckUnitAdmin(0); + } + //是否网格员 + int easyPhotoMember = userDao.countEasyPhotoMember(phone, userCommunityId); + if (easyPhotoMember > 0) { + loginUserInfoVO.setIsEasyPhotoMember(1); + } + // 是否是"管理员"或者 本社区 "社区团队"、"党委成员" + Integer countTeam = userDao.selectCountTeam(phone, userCommunityId); + Integer selectCountMemberRole = userDao.selectCountMemberRole(phone, userCommunityId); + Integer isSysUser = userDao.selectCountSysUser(phone, userCommunityId); + if (countTeam != null && countTeam > 0) { + loginUserInfoVO.setIsmemberrole(1); + loginUserInfoVO.setIsCommunityWorker(1); + } else if (selectCountMemberRole != null && selectCountMemberRole > 0) { + loginUserInfoVO.setIsmemberrole(1); + } else if (isSysUser != null && isSysUser > 0) { + loginUserInfoVO.setIsmemberrole(1); + } + Integer countSocialWorker = userDao.countSocialWorker(phone,userCommunityId); + if(countSocialWorker>0){ + loginUserInfoVO.setIsSocialWorker(1); + } + } + loginUserInfoVO.setIsRealNamed(sysUserDO.getIdCard() != null); + //是否社区或街道后台 + int countSocialOrg=userDao.countSocialOrg(sysUserDO.getUserId()); + if(countSocialOrg>0){ + loginUserInfoVO.setUserType(3); + } + if (nonNull(sysUserDO.getAccount())){ + if (isStreetAccount(sysUserDO.getAccount())){ + //街道账号 + loginUserInfoVO.setLevel(3); + } + if (sysUserDO.getAccount().equals("admin")){ + loginUserInfoVO.setLevel(1); + } + } + if (loginUserInfoVO.getType().equals(3)){ + loginUserInfoVO.setLevel(4); + } + if (sysUserDO.getType().equals(11)){ + //专家 + loginUserInfoVO.setLevel(5); + }else if (sysUserDO.getType().equals(12)){ + //行业分中心 + loginUserInfoVO.setLevel(2); + } + //是否为三说会堂专家 + ComSanshuoExpertVO expertVO=userDao.isExpert(loginUserInfoVO.getPhone()); + if (nonNull(expertVO)){ + loginUserInfoVO.setType(13); + } + //是否为人大代表 + if (StringUtils.isNotEmpty(phone) && StringUtils.isNotEmpty(sysUserDO.getName())){ + int i = userDao.isDpcMember(phone, sysUserDO.getName()); + if (i>0){ + loginUserInfoVO.setIsDpcMember(1); } } return R.ok(loginUserInfoVO); } /** + * 是否为综治后台街道账号 + * */ + public Boolean isStreetAccount(String name){ + Boolean flag=false; + String[] account={"glpz","qxpjd","tjdjd","dbdjd","yqjd","bcg","hmkjd","dhjd","jsgyy","dzhljd"}; + if (nonNull(name)){ + if (ArrayUtil.contains(account,name)){ + flag=true; + } + } + return flag; + } + + + /** * 修改用户登录密码 * - * @param changePasswordVO 新密码 + * @param changePasswordVO + * 新密码 * @return 修改结果 */ @Override @@ -258,16 +561,16 @@ return R.fail("新密码与原密码不能相同"); } BCryptPasswordEncoder encoder = new BCryptPasswordEncoder(); - if( !encoder.matches(oldPassword,dataPassowrd)){ + if (!encoder.matches(oldPassword, dataPassowrd)) { return R.fail("原密码错误"); } - SysUserDO sysUserDO=new SysUserDO(); + SysUserDO sysUserDO = new SysUserDO(); sysUserDO.setUserId(userId); String encode = new BCryptPasswordEncoder().encode(newPassword); sysUserDO.setPassword(encode); int update = userDao.updateById(sysUserDO); - if (update>0) { + if (update > 0) { return R.ok(); } return R.fail(); @@ -276,22 +579,25 @@ /** * 某社区后台人员查询 * - * @param param 名字 - * @param communityId 社区id + * @param param + * 名字 + * @param communityId + * 社区id * @return 人员集合 */ @Override public R listActivityManager(String param, Long communityId) { - LambdaQueryWrapper<SysUserDO> queryWrapper=new LambdaQueryWrapper<>(); - List<ActivityManagerVO> activityManagerVOS=new ArrayList<>(); - queryWrapper = new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getCommunityId, communityId).eq(SysUserDO::getStatus, 1).eq(SysUserDO::getType,3); + LambdaQueryWrapper<SysUserDO> queryWrapper = new LambdaQueryWrapper<>(); + List<ActivityManagerVO> activityManagerVOS = new ArrayList<>(); + queryWrapper = new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getCommunityId, communityId) + .eq(SysUserDO::getStatus, 1).eq(SysUserDO::getType, 3); if (!ObjectUtils.isEmpty(param)) { queryWrapper = queryWrapper.eq(SysUserDO::getName, param); } List<SysUserDO> sysUserDOS = userDao.selectList(queryWrapper); if (!ObjectUtils.isEmpty(sysUserDOS)) { sysUserDOS.forEach(sysUserDO -> { - ActivityManagerVO activityManagerVO=new ActivityManagerVO(); + ActivityManagerVO activityManagerVO = new ActivityManagerVO(); activityManagerVO.setManagerId(sysUserDO.getUserId()); activityManagerVO.setName(sysUserDO.getName()); activityManagerVOS.add(activityManagerVO); @@ -301,9 +607,24 @@ } /** + * 微心愿搜索社区团队人员列表 + * + * @param param + * 请求参数 + * @param communityId + * 社区id + * @return 社区团队人员列表 + */ + @Override + public R listActivityManager2(String param, Long communityId) { + return R.ok(userDao.getServiceTeamList(param, communityId)); + } + + /** * 分页查询人脸识别 * - * @param loginUserInfoVO 查询参数 + * @param loginUserInfoVO + * 查询参数 * @return 分页集合 */ @Override @@ -311,10 +632,10 @@ Page page = new Page<>(); Long pageNum = loginUserInfoVO.getPageNum(); Long pageSize = loginUserInfoVO.getPageSize(); - if (null==pageNum||0==pageNum) { + if (null == pageNum || 0 == pageNum) { pageNum = 1l; } - if (null==pageSize||0==pageSize) { + if (null == pageSize || 0 == pageSize) { pageSize = 10l; } page.setSize(pageSize); @@ -333,9 +654,9 @@ public R putUserFace(LoginUserInfoVO loginUserInfoVO) { int operationType = loginUserInfoVO.getOperationType().intValue(); Long userId = loginUserInfoVO.getUserId(); - SysUserDO sysUserDO=new SysUserDO(); + SysUserDO sysUserDO = new SysUserDO(); sysUserDO.setUserId(userId); - switch (operationType){ + switch (operationType) { case 1: sysUserDO.setFaceState(1); break; @@ -347,14 +668,14 @@ default: break; } - int num=0; - if (operationType==3) { -// num=userDao.deleteById(userId); - num=userDao.updateFaceState(userId); + int num = 0; + if (operationType == 3) { + // num=userDao.deleteById(userId); + num = userDao.updateFaceState(userId); } else { - num=userDao.updateById(sysUserDO); + num = userDao.updateById(sysUserDO); } - if (num>0) { + if (num > 0) { return R.ok(); } return R.fail(); @@ -363,23 +684,48 @@ /** * 分页查询人口管理 * - * @param loginUserInfoVO 查询参数 + * @param userInfoVO 查询参数 * @return 分页数据 */ @Override - public R pageUser(LoginUserInfoVO loginUserInfoVO) { - Page page = new Page<>(); - Long pageNum = loginUserInfoVO.getPageNum(); - Long pageSize = loginUserInfoVO.getPageSize(); - if (null==pageNum||0==pageNum) { - pageNum = 1l; - } - if (null==pageSize||0==pageSize) { - pageSize = 10l; - } - page.setSize(pageSize); - page.setCurrent(pageNum); - IPage<LoginUserInfoVO> iPage = userDao.pageUser(page, loginUserInfoVO); + public R pageUser(AppletUserInfoVO userInfoVO) { + IPage<AppletUserInfoVO> iPage = + userDao.pageUser(new Page<>(userInfoVO.getPageNum(), userInfoVO.getPageSize()), userInfoVO); + iPage.getRecords().forEach(record -> { +// record.setPhone(SensitiveUtil.desensitizedPhoneNumber(record.getPhone())); + record.setIdCard(SensitiveUtil.desensitizedIdNumber(record.getIdCard())); + + if (StringUtils.isNotEmpty(record.getTags())) { + StringBuffer sb = new StringBuffer(); + sb.append(record.getTags() + ","); + if (record.getIsPartymember().equals(1)) { + if (!sb.toString().contains("党员")) { + sb.append("党员,"); + } + } + if (record.getIsVolunteer().equals(1)) { + if (!sb.toString().contains("志愿者")) { + sb.append("志愿者,"); + } + } + String tags = sb.toString(); + record.setTags(tags.substring(0, tags.length() - 1)); + } else { + StringBuffer sb = new StringBuffer(); + if (record.getIsPartymember().equals(1)) { + sb.append("党员,"); + } + if (record.getIsVolunteer().equals(1)) { + sb.append("志愿者,"); + } + String tags = sb.toString(); + if (tags.length() > 0) { + record.setTags(tags.substring(0, tags.length() - 1)); + } else { + record.setTags("无"); + } + } + }); return R.ok(iPage); } @@ -390,78 +736,101 @@ */ @Override public R listTag() { - List<String> list=new ArrayList<>(); - List<ComMngUserTagDO> comMngUserTagDOS = comMngUserTagDAO.selectList(null); + List<String> list = new ArrayList<>(); + List<ComMngUserTagDO> comMngUserTagDOS = comMngUserTagDAO.selectList(new LambdaQueryWrapper<ComMngUserTagDO>() + .eq(ComMngUserTagDO::getSysFlag, 1)); if (!ObjectUtils.isEmpty(comMngUserTagDOS)) { - list=comMngUserTagDOS.stream().map(comMngUserTagDO -> comMngUserTagDO.getTagName()).collect(Collectors.toList()); + list = comMngUserTagDOS.stream().map(comMngUserTagDO -> comMngUserTagDO.getTagName()) + .collect(Collectors.toList()); } return R.ok(list); } /** - * 人员详情 + * 人员详情 detailuser * * @param userId 用户id * @return 人员详情 */ @Override - public R detailUser(Long userId) { - LoginUserInfoVO loginUserInfoVO=new LoginUserInfoVO(); - if(userId<100000000l){ - SysUserDO sysUserDO = userDao.selectById(userId); - if (ObjectUtils.isEmpty(sysUserDO)) { - return R.fail("人员不存在"); - } - BeanUtils.copyProperties(sysUserDO,loginUserInfoVO); - List<ComMngFamilyInfoDO> comMngFamilyInfoDOS = comMngFamilyInfoDAO.selectList(new QueryWrapper<ComMngFamilyInfoDO>().lambda().eq(ComMngFamilyInfoDO::getUserId, userId)); - if (!ObjectUtils.isEmpty(comMngFamilyInfoDOS)) { - List<ComMngFamilyInfoVO>comMngFamilyInfoVOS=new ArrayList<>(); - comMngFamilyInfoDOS.forEach(comMngFamilyInfoDO -> { - ComMngFamilyInfoVO comMngFamilyInfoVO=new ComMngFamilyInfoVO(); - BeanUtils.copyProperties(comMngFamilyInfoDO,comMngFamilyInfoVO); - comMngFamilyInfoVOS.add(comMngFamilyInfoVO); - }); - loginUserInfoVO.setComMngFamilyInfoVOS(comMngFamilyInfoVOS); - } - - }else{ - //导入社区人员 - SysUserInputDO sysUserInputDO = sysUserInputDAO.selectById(userId - 100000000); - if (ObjectUtils.isEmpty(sysUserInputDO)) { - return R.fail("人员不存在"); - } - String name1 = sysUserInputDO.getName(); - BeanUtils.copyProperties(sysUserInputDO,loginUserInfoVO); - String doorNumber = sysUserInputDO.getDoorNumber(); - Long areaId = sysUserInputDO.getAreaId(); - List<SysUserInputDO> sysUserInputDOS = sysUserInputDAO.selectList(new QueryWrapper<SysUserInputDO>().lambda().eq(SysUserInputDO::getDoorNumber, doorNumber).eq(SysUserInputDO::getAreaId, areaId)); - if (!ObjectUtils.isEmpty(sysUserInputDOS)) { - List<ComMngFamilyInfoVO>comMngFamilyInfoVOS=new ArrayList<>(); - sysUserInputDOS.forEach(sysUserInputDO1 -> { - String name = sysUserInputDO1.getName(); - if (name1.equals(name)) { - return; - } - Integer isRent = sysUserInputDO1.getIsRent(); - ComMngFamilyInfoVO comMngFamilyInfoVO=new ComMngFamilyInfoVO(); - comMngFamilyInfoVO.setIdCard(sysUserInputDO1.getIdCard()); - comMngFamilyInfoVO.setName(name); - comMngFamilyInfoVO.setPhone(sysUserInputDO1.getPhone()); - if (isRent.intValue()==0) { - comMngFamilyInfoVO.setRelationship("家人"); - }else{ - comMngFamilyInfoVO.setRelationship("合租"); - } - comMngFamilyInfoVO.setAge(IdCard.IdNOToAge(sysUserInputDO1.getIdCard())); - comMngFamilyInfoVOS.add(comMngFamilyInfoVO); - }); - loginUserInfoVO.setComMngFamilyInfoVOS(comMngFamilyInfoVOS); - } - + public R<LoginUserInfoVO> detailUser(Long userId) { + LoginUserInfoVO loginUserInfoVO = new LoginUserInfoVO(); + SysUserDO sysUserDO = userDao.selectById(userId); + if (ObjectUtils.isEmpty(sysUserDO)) { + return R.fail("人员不存在"); } - ComActVO comActVO=userDao.selectCommunity(loginUserInfoVO.getCommunityId()); + BeanUtils.copyProperties(sysUserDO, loginUserInfoVO); + List<ComMngFamilyInfoDO> comMngFamilyInfoDOS = comMngFamilyInfoDAO + .selectList(new QueryWrapper<ComMngFamilyInfoDO>().lambda().eq(ComMngFamilyInfoDO::getUserId, userId)); + if (!ObjectUtils.isEmpty(comMngFamilyInfoDOS)) { + List<ComMngFamilyInfoVO> comMngFamilyInfoVOS = new ArrayList<>(); + comMngFamilyInfoDOS.forEach(comMngFamilyInfoDO -> { + ComMngFamilyInfoVO comMngFamilyInfoVO = new ComMngFamilyInfoVO(); + BeanUtils.copyProperties(comMngFamilyInfoDO, comMngFamilyInfoVO); + comMngFamilyInfoVOS.add(comMngFamilyInfoVO); + }); + loginUserInfoVO.setComMngFamilyInfoVOS(comMngFamilyInfoVOS); + } + ComActVO comActVO = userDao.selectCommunity(loginUserInfoVO.getCommunityId()); if (!ObjectUtils.isEmpty(comActVO)) { + String areaName = userDao.selectAreaCodeByStreetId(comActVO.getStreetId()); + if (StringUtils.isNotEmpty(areaName)) { + loginUserInfoVO.setAreaName(areaName); + } + loginUserInfoVO.setComActVO(comActVO); loginUserInfoVO.setCommunityName(comActVO.getName()); + loginUserInfoVO.setAreaCode(comActVO.getAreaCode()); + } else { + loginUserInfoVO.setAreaCode("510423"); + } + //是否是社区物业人员 + int countPropertyWorker = userDao.countPropertyWorker(userId, loginUserInfoVO.getCommunityId()); + loginUserInfoVO.setIsPropertyWorker(countPropertyWorker > 0 ? 1 : 0); + //是否微团队成员 + int countFmsMember = userDao.countFmsMember(loginUserInfoVO.getPhone(), loginUserInfoVO.getCommunityId()); + loginUserInfoVO.setIsFmsMember(countFmsMember > 0 ? 1 : 0); + //是否是防疫工作人员 + loginUserInfoVO.setIsAcidMember(0); + ComActAcidMemberVO acidMember = userDao.selectAcidMemberByPhone(loginUserInfoVO.getPhone()); + if (nonNull(acidMember)) { + if (acidMember.getRelationName().equals("panzhihua") || acidMember.getRelationName().equals("西区") || acidMember.getRelationName().equals("东区") || acidMember.getRelationName().equals("仁和区") || acidMember.getRelationName().equals("米易县") || acidMember.getRelationName().equals("盐边县")) { + loginUserInfoVO.setIsAcidMember(1); + } else { + loginUserInfoVO.setIsAcidMember(2); + } + loginUserInfoVO.setRelationName(acidMember.getRelationName()); + } + loginUserInfoVO.setIdCard(SensitiveUtil.desensitizedIdNumber(loginUserInfoVO.getIdCard())); + loginUserInfoVO.setPhone(SensitiveUtil.desensitizedPhoneNumber(loginUserInfoVO.getPhone())); + //判断账号类型 + int countSocialOrg = userDao.countSocialOrg(userId); + if (countSocialOrg > 0) { + loginUserInfoVO.setUserType(3); + } else { + if (loginUserInfoVO.getStreetId() != null) { + loginUserInfoVO.setUserType(1); + } else { + loginUserInfoVO.setUserType(2); + loginUserInfoVO.setLevel(4); + } + } + if (sysUserDO.getType().equals(11)){ + loginUserInfoVO.setLevel(5); + }else if (sysUserDO.getType().equals(12)){ + loginUserInfoVO.setLevel(2); + }else if (isNull(loginUserInfoVO.getLevel())){ + loginUserInfoVO.setLevel(1); + } + loginUserInfoVO.setBackstageType(1); + String[] account = {"dongqu", "xiqu", "yanbianxian", "miyixian", "renhequ", "fantaixinqu"}; + if ("zuzhibu".equals(sysUserDO.getAccount())) { + loginUserInfoVO.setBackstageType(2); + } + if (ArrayUtil.contains(account, sysUserDO.getAccount())) { + loginUserInfoVO.setBackstageType(3); + } + if (sysUserDO.getBindingCheckUnitId() != null) { + loginUserInfoVO.setBackstageType(4); } return R.ok(loginUserInfoVO); } @@ -474,11 +843,13 @@ */ @Override public R putUserTag(LoginUserInfoVO loginUserInfoVO) { - SysUserDO sysUserDO=new SysUserDO(); + SysUserDO sysUserDO = new SysUserDO(); sysUserDO.setUserId(loginUserInfoVO.getUserId()); - sysUserDO.setTags(loginUserInfoVO.getTags()); - int update = userDao.updateById(sysUserDO); - if (update>0) { + if (StringUtils.isNotEmpty(loginUserInfoVO.getTags()) && !"无".equals(loginUserInfoVO.getTags())) { + sysUserDO.setTags(loginUserInfoVO.getTags()); + } + int update = userDao.putUserTag(sysUserDO); + if (update > 0) { return R.ok(); } return R.fail(); @@ -492,11 +863,63 @@ */ @Override public R putUserIsVolunteer(String phone, int type) { - SysUserDO sysUserDO=new SysUserDO(); + + SysUserDO sysUserDO = new SysUserDO(); sysUserDO.setIsVolunteer(type); + // ????根据手机号匹配 int update = userDao.update(sysUserDO, new UpdateWrapper<SysUserDO>().lambda().eq(SysUserDO::getPhone, phone)); - if (update>0) { + if (update > 0) { + ComMngVolunteerMngVO comMngVolunteerMngVO = userDao.selectVolunteerMngByPhone(phone); + if (comMngVolunteerMngVO != null && comMngVolunteerMngVO.getSubmitUserId() != null) { + Long userId = comMngVolunteerMngVO.getSubmitUserId(); + // 删除用户信息缓存 + String userKey = UserConstants.LOGIN_USER_INFO + userId; + stringRedisTemplate.delete(userKey); + } else { + List<SysUserDO> userDOList = + userDao.selectList(new LambdaQueryWrapper<SysUserDO>().eq(SysUserDO::getPhone, phone)); + if (userDOList != null && userDOList.size() > 0) { + userDOList.forEach(usrDo -> { + Long userId = usrDo.getUserId(); + // 删除用户信息缓存 + String userKey = UserConstants.LOGIN_USER_INFO + userId; + stringRedisTemplate.delete(userKey); + }); + } + } return R.ok(); + } + return R.fail(); + } + + /** + * 修改用户志愿者状态 + * + * @param userId 志愿者用户ID + * @param type + */ + @Override + public R putUserIsVolunteerById(Long userId, int type) { + SysUserDO sysUserDO = new SysUserDO(); + sysUserDO.setIsVolunteer(type); + sysUserDO.setUserId(userId); + + SysUserDO userInDB = userDao.selectById(userId); + if (userInDB != null) { + boolean isVol = userInDB.getIsVolunteer() == 1; + if (isVol) { + return R.fail("用户已是志愿者"); + } + if (userInDB.getType() != 1) { + return R.fail("用户不是小程序用户"); + } + int update = userDao.updateById(sysUserDO); + if (update > 0) { + // 删除用户信息缓存 + String userKey = UserConstants.LOGIN_USER_INFO + userId; + stringRedisTemplate.delete(userKey); + return R.ok(); + } } return R.fail(); } @@ -509,16 +932,17 @@ */ @Override public R putUserCommunityArea(LoginUserInfoVO loginUserInfoVO) { - SysUserDO sysUserDO=new SysUserDO(); + + SysUserDO sysUserDO = new SysUserDO(); sysUserDO.setCommunityId(loginUserInfoVO.getCommunityId()); - sysUserDO.setAreaId(loginUserInfoVO.getAreaId()); + // sysUserDO.setAreaId(loginUserInfoVO.getAreaId()); sysUserDO.setUserId(loginUserInfoVO.getUserId()); int update = userDao.updateById(sysUserDO); - if (update>0) { - //删除用户信息缓存 + if (update > 0) { + // 删除用户信息缓存 String userKey = UserConstants.LOGIN_USER_INFO + loginUserInfoVO.getUserId(); stringRedisTemplate.delete(userKey); - return R.ok(); + return R.ok(sysUserDO); } return R.fail(); } @@ -531,28 +955,66 @@ */ @Override public R putUserAuthentication(LoginUserInfoVO loginUserInfoVO) { - //接入第三方实名认证 + // 接入第三方实名认证 String idCard = loginUserInfoVO.getIdCard(); String name = loginUserInfoVO.getName(); - boolean b = RealNameUtil.authentication(idCard, name); - if (!b) { - return R.fail("身份认证失败:公安系统认证错误"); - } - SysUserDO sysUserDO=new SysUserDO(); + log.info("用户实名认证发送请求,姓名:" + name + "身份证号码:" + idCard); + // try { + // boolean b = RealNameUtil.authentication(idCard, name); + // if (!b) { + // return R.fail("身份认证失败:请填写真实信息"); + // } + // }catch (ServiceException serviceException){ + // return R.fail(serviceException.getMessage()); + // } + SysUserDO sysUserDO = new SysUserDO(); sysUserDO.setName(name); sysUserDO.setIdCard(idCard); - sysUserDO.setSex(loginUserInfoVO.getSex()); - sysUserDO.setBirthday(loginUserInfoVO.getBirthday()); - sysUserDO.setJob(loginUserInfoVO.getJob()); + // 通过身份证号判断性别以及出生日期 + sysUserDO.setSex(IdCard.sex(idCard)); + sysUserDO.setBirthday(IdcardUtil.getBirthDate(idCard)); + if (!StringUtils.isEmpty(loginUserInfoVO.getJob())) { + sysUserDO.setJob(loginUserInfoVO.getJob()); + } sysUserDO.setUserId(loginUserInfoVO.getUserId()); sysUserDO.setFaceUrl(loginUserInfoVO.getFaceUrl()); + if (!StringUtils.isEmpty(loginUserInfoVO.getPhone())) { + sysUserDO.setPhone(loginUserInfoVO.getPhone()); + } sysUserDO.setFaceState(null); - SysUserDO sysUserDO1 = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getIdCard, idCard)); + SysUserDO sysUserDO1 = + userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getIdCard, idCard).eq(SysUserDO::getCommunityId, loginUserInfoVO.getCommunityId())); if (!ObjectUtils.isEmpty(sysUserDO1)) { return R.fail("身份证已经存在"); } int update = userDao.updateById(sysUserDO); - if (update>0) { + if (update > 0) { + // 清空缓存 + String userKey = UserConstants.LOGIN_USER_INFO + loginUserInfoVO.getUserId(); + stringRedisTemplate.delete(userKey); + // 实名认证成功查询是否有已审核的党员信息,有则更新党员信息绑定党员的userId + Long memberId = userDao.getPartyBuildingByIdCard(idCard); + if (memberId != null) { + sysUserDO.setIsPartymember(1); + userDao.updateById(sysUserDO); + // 修改审核绑定的userId + userDao.updateComPbMemberUserId(idCard, sysUserDO.getUserId()); + } + + /*SysUserDO user = userDao.selectById(loginUserInfoVO.getUserId()); + if (user != null) { + // 实名认证成功推送订阅消息给用户 + try { + WxXCXTempSend util = new WxXCXTempSend(); + String accessToken = util.getAccessToken(); + SysTemplateConfig sysTemplateConfig = sysTemplateConfigDao.selectOne(new QueryWrapper<SysTemplateConfig>().lambda().eq(SysTemplateConfig::getAreaCode, loginUserInfoVO.getComActVO()).eq(SysTemplateConfig::getType, 5)); + // 用户实名认证推送消息 + WxUtil.sendSubscribeRZSH(user.getOpenid(), accessToken, "实名认证", + com.panzhihua.common.utlis.DateUtils.getCurrentDateStr(), "认证成功", sysTemplateConfig.getTemplateId()); + } catch (Exception e) { + log.error("推送用户订阅消息失败,失败原因:" + e.getMessage()); + } + }*/ return R.ok(); } return R.fail(); @@ -579,24 +1041,24 @@ } SysUserDO sysUserDO1 = userDao.selectById(userPhoneVO.getUserId()); String phone = sysUserDO1.getPhone(); - if (!StringUtils.isEmpty(phone)&& !phone.equals(oldPhone)) { + if (!StringUtils.isEmpty(phone) && !phone.equals(oldPhone)) { return R.fail("旧手机号错误"); } ValueOperations<String, String> valueOperations = stringRedisTemplate.opsForValue(); String code = valueOperations.get(key); if (!code.equals(smsCode)) { - if(!smsCode.equals("777333")){ + if (!smsCode.equals("777333")) { return R.fail("验证码错误"); } } - SysUserDO sysUserDO=new SysUserDO(); + SysUserDO sysUserDO = new SysUserDO(); sysUserDO.setUserId(userPhoneVO.getUserId()); sysUserDO.setPhone(newPhone); userDao.updateMemberRole(newPhone, oldPhone); userDao.updateServiceTeam(newPhone, oldPhone); int update = userDao.updateById(sysUserDO); - if (update>0) { - + if (update > 0) { + return R.ok(); } return R.fail(); @@ -611,45 +1073,45 @@ @Override public R putUser(LoginUserInfoVO loginUserInfoVO) { Integer faceState = loginUserInfoVO.getFaceState(); - if (null==faceState||0==faceState) { + if (null == faceState || 0 == faceState) { loginUserInfoVO.setFaceState(null); } Integer isPartymember = loginUserInfoVO.getIsPartymember(); - if (null==isPartymember||0==isPartymember) { + if (null == isPartymember || 0 == isPartymember) { loginUserInfoVO.setIsPartymember(null); } Integer isVolunteer = loginUserInfoVO.getIsVolunteer(); - if (null==isVolunteer||0==isVolunteer) { + if (null == isVolunteer || 0 == isVolunteer) { loginUserInfoVO.setIsVolunteer(null); } Integer operationType = loginUserInfoVO.getOperationType(); - if (null==operationType||0==operationType) { + if (null == operationType || 0 == operationType) { loginUserInfoVO.setOperationType(null); } Integer sex = loginUserInfoVO.getSex(); - if (null==sex||0==sex) { + if (null == sex || 0 == sex) { loginUserInfoVO.setSex(null); } Integer status = loginUserInfoVO.getStatus(); - if (null==status||0==status) { + if (null == status || 0 == status) { loginUserInfoVO.setStatus(null); } Integer type = loginUserInfoVO.getType(); - if (null==type||0==type) { + if (null == type || 0 == type) { loginUserInfoVO.setType(null); } Long communityId = loginUserInfoVO.getCommunityId(); - if (null==communityId||0==communityId) { + if (null == communityId || 0 == communityId) { loginUserInfoVO.setCommunityId(null); } String faceUrl = loginUserInfoVO.getFaceUrl(); if (!ObjectUtils.isEmpty(faceUrl)) { loginUserInfoVO.setFaceState(0); } - SysUserDO sysUserDO=new SysUserDO(); - BeanUtils.copyProperties(loginUserInfoVO,sysUserDO); + SysUserDO sysUserDO = new SysUserDO(); + BeanUtils.copyProperties(loginUserInfoVO, sysUserDO); int update = userDao.updateById(sysUserDO); - if (update>0) { + if (update > 0) { return R.ok(); } return R.fail(); @@ -662,13 +1124,15 @@ * @return 成员集合 */ @Override - public R listFamily(Long userId) { - List<ComMngFamilyInfoVO>comMngFamilyInfoVOS=new ArrayList<>(); - List<ComMngFamilyInfoDO> comMngFamilyInfoDOS = comMngFamilyInfoDAO.selectList(new QueryWrapper<ComMngFamilyInfoDO>().lambda().eq(ComMngFamilyInfoDO::getUserId, userId)); - if (!ObjectUtils.isEmpty(comMngFamilyInfoDOS)) { - comMngFamilyInfoDOS.forEach(comMngFamilyInfoDO -> { - ComMngFamilyInfoVO comMngFamilyInfoVO=new ComMngFamilyInfoVO(); - BeanUtils.copyProperties(comMngFamilyInfoDO,comMngFamilyInfoVO); + public R listFamily(Long userId, Long pageNum, Long pageSize) { + List<ComMngFamilyInfoVO> comMngFamilyInfoVOS = new ArrayList<>(); + LambdaQueryWrapper<ComMngFamilyInfoDO> query = new QueryWrapper<ComMngFamilyInfoDO>().lambda() + .eq(ComMngFamilyInfoDO::getUserId, userId).orderByDesc(ComMngFamilyInfoDO::getCreateAt); + IPage<ComMngFamilyInfoDO> pageData = comMngFamilyInfoDAO.selectPage(new Page<>(pageNum, pageSize), query); + if (!ObjectUtils.isEmpty(pageData.getRecords())) { + pageData.getRecords().forEach(comMngFamilyInfoDO -> { + ComMngFamilyInfoVO comMngFamilyInfoVO = new ComMngFamilyInfoVO(); + BeanUtils.copyProperties(comMngFamilyInfoDO, comMngFamilyInfoVO); comMngFamilyInfoVOS.add(comMngFamilyInfoVO); }); } @@ -683,14 +1147,17 @@ */ @Override public R addFamily(ComMngFamilyInfoVO comMngFamilyInfoVO) { - ComMngFamilyInfoDO comMngFamilyInfoDO=new ComMngFamilyInfoDO(); - BeanUtils.copyProperties(comMngFamilyInfoVO,comMngFamilyInfoDO); - ComMngFamilyInfoDO comMngFamilyInfoDO1 = comMngFamilyInfoDAO.selectOne(new QueryWrapper<ComMngFamilyInfoDO>().lambda().eq(ComMngFamilyInfoDO::getIdCard, comMngFamilyInfoVO.getIdCard()).eq(ComMngFamilyInfoDO::getUserId, comMngFamilyInfoVO.getUserId())); + ComMngFamilyInfoDO comMngFamilyInfoDO = new ComMngFamilyInfoDO(); + BeanUtils.copyProperties(comMngFamilyInfoVO, comMngFamilyInfoDO); + ComMngFamilyInfoDO comMngFamilyInfoDO1 = comMngFamilyInfoDAO.selectOne(new QueryWrapper<ComMngFamilyInfoDO>() + .lambda().eq(ComMngFamilyInfoDO::getIdCard, comMngFamilyInfoVO.getIdCard()) + .eq(ComMngFamilyInfoDO::getUserId, comMngFamilyInfoVO.getUserId())); if (!ObjectUtils.isEmpty(comMngFamilyInfoDO1)) { return R.fail("家庭成员已经存在"); } + comMngFamilyInfoDO.setAge(IdCard.IdNOToAge(comMngFamilyInfoVO.getIdCard())); int insert = comMngFamilyInfoDAO.insert(comMngFamilyInfoDO); - if (insert>0) { + if (insert > 0) { return R.ok(); } return R.fail(); @@ -704,10 +1171,11 @@ */ @Override public R putFamily(ComMngFamilyInfoVO comMngFamilyInfoVO) { - ComMngFamilyInfoDO comMngFamilyInfoDO=new ComMngFamilyInfoDO(); - BeanUtils.copyProperties(comMngFamilyInfoVO,comMngFamilyInfoDO); + ComMngFamilyInfoDO comMngFamilyInfoDO = new ComMngFamilyInfoDO(); + BeanUtils.copyProperties(comMngFamilyInfoVO, comMngFamilyInfoDO); + comMngFamilyInfoDO.setAge(IdCard.IdNOToAge(comMngFamilyInfoVO.getIdCard())); int update = comMngFamilyInfoDAO.updateById(comMngFamilyInfoDO); - if (update>0) { + if (update > 0) { return R.ok(); } return R.fail(); @@ -722,25 +1190,84 @@ @Override @Transactional(rollbackFor = Exception.class) public R addUserBackstage(AdministratorsUserVO administratorsUserVO) { - SysUserDO sysUserDO=new SysUserDO(); + ComActVO comActVO = userDao.selectCommunity(administratorsUserVO.getCommunityId()); + if (nonNull(comActVO)) { + List<ComAreaTownCommunityVO> areaTownList = userDao.selectAreaTownCommunity(comActVO.getName()); + if (!areaTownList.isEmpty()) { + administratorsUserVO.setRelationName(comActVO.getName()); + String address = comActVO.getAddress(); + if (areaTownList.size() > 1 && isNotBlank(address)) { + ComAreaTownCommunityVO townCommunityVO = areaTownList.stream() + .filter(e -> address.contains(e.getArea()) && address.contains(e.getTown())).findFirst().orElse(null); + if (nonNull(townCommunityVO)) { + administratorsUserVO.setRelationName(String.join(",", townCommunityVO.getArea(), townCommunityVO.getTown(), townCommunityVO.getCommunity())); + } + } + } + } + SysUserDO sysUserDO = new SysUserDO(); Long roleId = administratorsUserVO.getRoleId(); - Long communityId = administratorsUserVO.getCommunityId(); - if (roleId.intValue()==999999999) { -//新增社区高级管理员角色 - SysRoleDO sysRoleDO=new SysRoleDO(); - sysRoleDO.setCommunityId(communityId); - sysRoleDO.setRoleName("超级管理员"); - sysRoleDO.setRoleKey("chaojiguanliyuan"+communityId); + if (roleId.intValue() == 999999999 || roleId.intValue() == 888888888) { + Long communityId = administratorsUserVO.getCommunityId(); + // 新增社区高级管理员角色 + SysRoleDO sysRoleDO = new SysRoleDO(); + if (roleId.intValue() == 999999999) { + sysRoleDO.setCommunityId(communityId); + sysRoleDO.setRoleName("超级管理员"); + sysRoleDO.setRoleKey(Constants.ADMIN_SHOP_ROLE_KEY + communityId); + } else { + sysRoleDO.setCommunityId(0L); + sysRoleDO.setRoleName(administratorsUserVO.getShopStoreName()); + sysRoleDO.setRoleKey(Constants.SHOP_ROLE_KEY + administratorsUserVO.getShopStorePhone()); + } sysRoleDO.setRoleSort(0); sysRoleDO.setCreateBy(administratorsUserVO.getUserId()); int insert = roleDAO.insert(sysRoleDO); - if (insert>0) { - SysRoleDO sysRoleDO1 = roleDAO.selectOne(new QueryWrapper<SysRoleDO>().lambda().eq(SysRoleDO::getRoleKey, sysRoleDO.getRoleKey())); - roleId=sysRoleDO1.getRoleId(); -// 新角色设置所有权限 - MenuRoleVO menuRoleVO=new MenuRoleVO(); + if (insert > 0) { + SysRoleDO sysRoleDO1 = roleDAO.selectOne( + new QueryWrapper<SysRoleDO>().lambda().eq(SysRoleDO::getRoleKey, sysRoleDO.getRoleKey())); + roleId = sysRoleDO1.getRoleId(); + // 新角色设置所有权限 + MenuRoleVO menuRoleVO = new MenuRoleVO(); menuRoleVO.setIsAll(1); menuRoleVO.setCommunityId(communityId); + menuRoleVO.setRoleId(roleId); + this.putMenuRole(menuRoleVO); + } + } + if (roleId.intValue() == 777777777) { + SysRoleDO sysRoleDO = new SysRoleDO(); + sysRoleDO.setRoleName("超级管理员"); + sysRoleDO.setRoleKey(Constants.STREET_ROLE_KEY + administratorsUserVO.getStreetId()); + sysRoleDO.setRoleSort(0); + sysRoleDO.setCreateBy(administratorsUserVO.getUserId()); + int insert = roleDAO.insert(sysRoleDO); + if (insert > 0) { + SysRoleDO sysRoleDO1 = roleDAO.selectOne( + new QueryWrapper<SysRoleDO>().lambda().eq(SysRoleDO::getRoleKey, sysRoleDO.getRoleKey())); + roleId = sysRoleDO1.getRoleId(); + // 新街道管理员角色设置固定三社权限 + MenuRoleVO menuRoleVO = new MenuRoleVO(); + List<Long> menu = new ArrayList<>(); + if (administratorsUserVO.getSocialType() == 1) { + menu.add(233L); + menu.add(234L); + menu.add(235L); + menu.add(236L); + menu.add(237L); + } else if (administratorsUserVO.getSocialType() == 2) { + menu.add(233L); + menu.add(234L); + menu.add(236L); + menu.add(237L); + menu.add(238L); + } else if (administratorsUserVO.getSocialType() == 3) { + menu.add(233L); + menu.add(237L); + } else { + menuRoleVO.setIsAll(1); + } + menuRoleVO.setMenuIds(menu); menuRoleVO.setRoleId(roleId); this.putMenuRole(menuRoleVO); } @@ -751,29 +1278,115 @@ } String encode = new BCryptPasswordEncoder().encode(administratorsUserVO.getPassword()); administratorsUserVO.setPassword(encode); - BeanUtils.copyProperties(administratorsUserVO,sysUserDO); + BeanUtils.copyProperties(administratorsUserVO, sysUserDO); + sysUserDO.setAppId(administratorsUserVO.getAppid()); int insert = 0; try { insert = userDao.insert(sysUserDO); } catch (Exception e) { e.printStackTrace(); - log.error("新增后台用户报错【{}】",e.getMessage()); + log.error("新增后台用户报错【{}】", e.getMessage()); if (e.getMessage().contains("union_phone_type")) { throw new ServiceException("手机号已经存在"); - }else if(e.getMessage().contains("union_account_type")){ + } else if (e.getMessage().contains("union_account_type")) { throw new ServiceException("账户已经存在"); + } else if (e.getMessage().contains("23000")) { + throw new ServiceException("手机号已存在"); } } - if (insert>0) { - SysUserDO sysUserDO1 = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, administratorsUserVO.getType()).eq(SysUserDO::getPhone, administratorsUserVO.getPhone())); + if (insert > 0) { + SysUserDO sysUserDO1 = userDao + .selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, administratorsUserVO.getType()) + .eq(SysUserDO::getAccount, administratorsUserVO.getAccount())); Long userId = sysUserDO1.getUserId(); - SysUserRoleDO sysUserRoleDO=new SysUserRoleDO(); + SysUserRoleDO sysUserRoleDO = new SysUserRoleDO(); sysUserRoleDO.setUserId(userId); sysUserRoleDO.setRoleId(roleDO.getRoleId()); int insert1 = sysUserRoleDAO.insert(sysUserRoleDO); - if (insert1>0) { - return R.ok(); + if (insert1 > 0) { + return R.ok(userId); + } + } + return R.fail(); + } + + @Override + public R addUserBackstageProperty(AdministratorsUserVO administratorsUserVO) { + SysUserDO sysUserDO = new SysUserDO(); + Long roleId = administratorsUserVO.getRoleId(); + if (roleId.intValue() == 777777777) { + SysRoleDO sysRoleDO = new SysRoleDO(); + sysRoleDO.setRoleName("三社超级管理员"); + List<Long> menu = new ArrayList<>(); + if (administratorsUserVO.getSocialType() == 1) { + sysRoleDO.setRoleKey(Constants.STREET_ROLE_KEY + administratorsUserVO.getStreetId()); + menu.add(300L); + menu.add(301L); + menu.add(302L); + menu.add(303L); + menu.add(304L); + } else if (administratorsUserVO.getSocialType() == 2) { + sysRoleDO.setRoleKey("social_org" + administratorsUserVO.getStreetId()); + menu.add(300L); + menu.add(301L); + menu.add(302L); + menu.add(303L); + } else if (administratorsUserVO.getSocialType() == 3) { + sysRoleDO.setRoleKey("social_org_member" + administratorsUserVO.getStreetId()); + menu.add(300L); + menu.add(303L); + } + + sysRoleDO.setRoleSort(0); + sysRoleDO.setCreateBy(administratorsUserVO.getUserId()); + SysRoleDO sysRoleDO1 = roleDAO.selectOne( + new QueryWrapper<SysRoleDO>().lambda().eq(SysRoleDO::getRoleKey, sysRoleDO.getRoleKey())); + if (sysRoleDO1 != null) { + sysRoleDO = sysRoleDO1; + roleId = sysRoleDO.getRoleId(); + } else { + roleDAO.insert(sysRoleDO); + // 新街道管理员角色设置固定三社权限 + MenuRoleVO menuRoleVO = new MenuRoleVO(); + menuRoleVO.setMenuIds(menu); + menuRoleVO.setRoleId(sysRoleDO.getRoleId()); + this.putMenuRole(menuRoleVO); + } + } + SysRoleDO roleDO = roleDAO.selectById(roleId); + if (ObjectUtils.isEmpty(roleDO)) { + return R.fail("角色不存在"); + } + String encode = new BCryptPasswordEncoder().encode(administratorsUserVO.getPassword()); + administratorsUserVO.setPassword(encode); + BeanUtils.copyProperties(administratorsUserVO, sysUserDO); + int insert = 0; + try { + insert = userDao.insert(sysUserDO); + } catch (Exception e) { + e.printStackTrace(); + log.error("新增后台用户报错【{}】", e.getMessage()); + if (e.getMessage().contains("union_phone_type")) { + throw new ServiceException("手机号已经存在"); + } else if (e.getMessage().contains("union_account_type")) { + throw new ServiceException("账户已经存在"); + } else if (e.getMessage().contains("23000")) { + throw new ServiceException("手机号已存在"); + } + + } + if (insert > 0) { + SysUserDO sysUserDO1 = userDao + .selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, administratorsUserVO.getType()) + .eq(SysUserDO::getAccount, administratorsUserVO.getAccount())); + Long userId = sysUserDO1.getUserId(); + SysUserRoleDO sysUserRoleDO = new SysUserRoleDO(); + sysUserRoleDO.setUserId(userId); + sysUserRoleDO.setRoleId(roleDO.getRoleId()); + int insert1 = sysUserRoleDAO.insert(sysUserRoleDO); + if (insert1 > 0) { + return R.ok(userId); } } return R.fail(); @@ -787,48 +1400,72 @@ */ @Transactional(rollbackFor = Exception.class) public R putMenuRole(MenuRoleVO menuRoleVO) { - List<Long>menuIds=new ArrayList<>(); + List<Long> menuIds = new ArrayList<>(); Long roleId = menuRoleVO.getRoleId(); Integer isAll = menuRoleVO.getIsAll(); Long communityId = menuRoleVO.getCommunityId(); -// if (isAll.intValue()==1) { -// List<SysMenuDO> sysMenuDOS = sysMenuDAO.selectList(new QueryWrapper<SysMenuDO>().lambda().eq(SysMenuDO::getCommunityId, 2l).eq(SysMenuDO::getParentId,0).orderByAsc(SysMenuDO::getOrderNum)); -// Long menuIdParent = sysMenuDOS.get(1).getMenuId(); -// List<SysMenuDO> sysMenuDOSErJi = sysMenuDAO.selectList(new QueryWrapper<SysMenuDO>().lambda().eq(SysMenuDO::getParentId, menuIdParent)); -// if (!ObjectUtils.isEmpty(sysMenuDOS)) { -// sysMenuDOS.forEach(sysMenuDO -> { -// sysMenuDO.setCommunityId(communityId); -// sysMenuDO.setMenuId(null); -// sysMenuDAO.insert(sysMenuDO); -// }); -//// 完成一级目录创建 -// List<SysMenuDO> sysMenuDOS1 = sysMenuDAO.selectList(new QueryWrapper<SysMenuDO>().lambda().eq(SysMenuDO::getCommunityId, communityId).orderByAsc(SysMenuDO::getOrderNum)); -// sysMenuDOS1.forEach(sysMenuDO -> { -// Integer orderNum = sysMenuDO.getOrderNum(); -// if (orderNum.intValue()>0) { -// sysMenuDOSErJi.forEach(sysMenuDO1 -> { -// sysMenuDO1.setParentId(sysMenuDO.getMenuId()); -// sysMenuDO1.setCommunityId(communityId); -// sysMenuDO1.setMenuId(null); -// sysMenuDAO.insert(sysMenuDO1); -// }); -// } -// }); + // if (isAll.intValue()==1) { + // List<SysMenuDO> sysMenuDOS = sysMenuDAO.selectList(new + // QueryWrapper<SysMenuDO>().lambda().eq(SysMenuDO::getCommunityId, + // 2l).eq(SysMenuDO::getParentId,0).orderByAsc(SysMenuDO::getOrderNum)); + // Long menuIdParent = sysMenuDOS.get(1).getMenuId(); + // List<SysMenuDO> sysMenuDOSErJi = sysMenuDAO.selectList(new + // QueryWrapper<SysMenuDO>().lambda().eq(SysMenuDO::getParentId, menuIdParent)); + // if (!ObjectUtils.isEmpty(sysMenuDOS)) { + // sysMenuDOS.forEach(sysMenuDO -> { + // sysMenuDO.setCommunityId(communityId); + // sysMenuDO.setMenuId(null); + // sysMenuDAO.insert(sysMenuDO); + // }); + //// 完成一级目录创建 + // List<SysMenuDO> sysMenuDOS1 = sysMenuDAO.selectList(new + // QueryWrapper<SysMenuDO>().lambda().eq(SysMenuDO::getCommunityId, + // communityId).orderByAsc(SysMenuDO::getOrderNum)); + // sysMenuDOS1.forEach(sysMenuDO -> { + // Integer orderNum = sysMenuDO.getOrderNum(); + // if (orderNum.intValue()>0) { + // sysMenuDOSErJi.forEach(sysMenuDO1 -> { + // sysMenuDO1.setParentId(sysMenuDO.getMenuId()); + // sysMenuDO1.setCommunityId(communityId); + // sysMenuDO1.setMenuId(null); + // sysMenuDAO.insert(sysMenuDO1); + // }); + // } + // }); + // } + // } + + // 菜单写死不重新生成菜单 todo 所有注释上面自动生成新菜单功能 + + // 获取所有权限id + List<SysMenuDO> menuDOList = sysMenuDAO.selectList(new QueryWrapper<SysMenuDO>().lambda() + .eq(SysMenuDO::getCommunityId, 2L).eq(SysMenuDO::getVisible, 0).orderByAsc(SysMenuDO::getOrderNum)); + if (!menuDOList.isEmpty()) { + menuIds = menuDOList.stream().map(sysMenuDO -> sysMenuDO.getMenuId()).collect(Collectors.toList()); + + List<SysRoleMenuDO> sysRoleMenuDOList = sysRoleMenuDAO.selectList(new QueryWrapper<SysRoleMenuDO>().lambda().eq(SysRoleMenuDO::getRoleId, roleId).in(SysRoleMenuDO::getMenuId, menuIds)); + if (!sysRoleMenuDOList.isEmpty()) { + menuIds = menuIds.stream().filter(menuId -> !sysRoleMenuDOList.stream() + .anyMatch(sysRoleMenuDO -> sysRoleMenuDO.getMenuId().equals(menuId))).collect(Collectors.toList()); + } + if (!menuIds.isEmpty()) { + if (menuRoleVO.getMenuIds() == null) { + sysRoleMenuDAO.batchInsertWithRoleId(menuIds, roleId); + } else { + sysRoleMenuDAO.batchInsertWithRoleId(menuRoleVO.getMenuIds(), roleId); + } + } +// for (int i = 0; i < menuIds.size(); i++) { +// SysRoleMenuDO sysRoleMenuDO = sysRoleMenuDAO.selectOne(new QueryWrapper<SysRoleMenuDO>().lambda() +// .eq(SysRoleMenuDO::getMenuId, menuIds.get(i)).eq(SysRoleMenuDO::getRoleId, roleId)); +// if (sysRoleMenuDO == null) { +// sysRoleMenuDO = new SysRoleMenuDO(); +// sysRoleMenuDO.setMenuId(menuIds.get(i)); +// sysRoleMenuDO.setRoleId(roleId); +// sysRoleMenuDAO.insert(sysRoleMenuDO); +// } // } -// } - -// 菜单写死不重新生成菜单 todo 所有注释上面自动生成新菜单功能 - -// 获取所有权限id - List<SysMenuDO> menuDOList = sysMenuDAO.selectList(new QueryWrapper<SysMenuDO>().lambda().eq(SysMenuDO::getCommunityId, 2l).orderByAsc(SysMenuDO::getOrderNum)); - menuIds=menuDOList.stream().map(sysMenuDO -> sysMenuDO.getMenuId()).collect(Collectors.toList()); - for(int i=0;i<menuIds.size();i++){ - SysRoleMenuDO sysRoleMenuDO=new SysRoleMenuDO(); - sysRoleMenuDO.setMenuId(menuIds.get(i)); - sysRoleMenuDO.setRoleId(roleId); - sysRoleMenuDAO.insert(sysRoleMenuDO); } - return R.ok(); } @@ -840,11 +1477,11 @@ */ @Override public R putUserBackstage(AdministratorsUserVO administratorsUserVO) { - SysUserDO sysUserDO=new SysUserDO(); + SysUserDO sysUserDO = new SysUserDO(); Long roleId = administratorsUserVO.getRoleId(); - SysRoleDO roleDO=null; - if (null!=roleId&&0!=roleId) { - roleDO = roleDAO.selectById(roleId); + SysRoleDO roleDO = null; + if (null != roleId && 0 != roleId) { + roleDO = roleDAO.selectById(roleId); if (ObjectUtils.isEmpty(roleDO)) { return R.fail("角色不存在"); } @@ -854,24 +1491,25 @@ String encode = new BCryptPasswordEncoder().encode(password); administratorsUserVO.setPassword(encode); } - BeanUtils.copyProperties(administratorsUserVO,sysUserDO); - int update=0; + BeanUtils.copyProperties(administratorsUserVO, sysUserDO); + int update = 0; try { - update = userDao.updateById(sysUserDO); + update = userDao.updateById(sysUserDO); } catch (Exception e) { e.printStackTrace(); - log.error("编辑后台用户出错【{}】",e.getMessage()); + log.error("编辑后台用户出错【{}】", e.getMessage()); if (e.getMessage().contains("union_phone_type")) { return R.fail("此手机号已被占用,请更换其他手机号码"); } } - if (update>0&&null!=roleDO) { - SysUserRoleDO sysUserRoleDO=new SysUserRoleDO(); + if (update > 0 && null != roleDO) { + SysUserRoleDO sysUserRoleDO = new SysUserRoleDO(); sysUserRoleDO.setRoleId(roleDO.getRoleId()); - int update1 = sysUserRoleDAO.update(sysUserRoleDO,new UpdateWrapper<SysUserRoleDO>().lambda().eq(SysUserRoleDO::getUserId,administratorsUserVO.getUserId())); - if (update1>0) { + int update1 = sysUserRoleDAO.update(sysUserRoleDO, new UpdateWrapper<SysUserRoleDO>().lambda() + .eq(SysUserRoleDO::getUserId, administratorsUserVO.getUserId())); + if (update1 > 0) { return R.ok(); - }else{ + } else { sysUserRoleDO.setUserId(administratorsUserVO.getUserId()); sysUserRoleDAO.insert(sysUserRoleDO); } @@ -886,7 +1524,6 @@ * @return 删除结果 */ @Override - @Transactional(rollbackFor = Exception.class) public R deleteUserBackstage(AdministratorsUserVO administratorsUserVO) { Long userId = administratorsUserVO.getUserId(); SysUserDO sysUserDO = userDao.selectById(userId); @@ -895,15 +1532,16 @@ } Long communityId = sysUserDO.getCommunityId(); Long communityId1 = administratorsUserVO.getCommunityId(); - if (communityId1.intValue()!=communityId.intValue()) { + if (communityId1 != null && communityId1.intValue() != communityId.intValue()) { return R.fail("用户不属于当前平台"); } - //删除用户 + // 删除用户 int delete = userDao.deleteById(userId); - //删除用户角色关系 - if (delete>0) { - int delete1 = sysUserRoleDAO.delete(new QueryWrapper<SysUserRoleDO>().lambda().eq(SysUserRoleDO::getUserId, userId)); - if (delete1==0) { + // 删除用户角色关系 + if (delete > 0) { + int delete1 = + sysUserRoleDAO.delete(new QueryWrapper<SysUserRoleDO>().lambda().eq(SysUserRoleDO::getUserId, userId)); + if (delete1 == 0) { return R.fail("用户没有角色关系"); } } @@ -921,10 +1559,10 @@ Page page = new Page<>(); Long pageNum = administratorsUserVO.getPageNum(); Long pageSize = administratorsUserVO.getPageSize(); - if (null==pageNum||pageNum==0) { + if (null == pageNum || pageNum == 0) { pageNum = 1l; } - if (null==pageSize||pageSize==0) { + if (null == pageSize || pageSize == 0) { pageSize = 10l; } page.setSize(pageSize); @@ -941,13 +1579,24 @@ */ @Override public R addOperLog(SysOperLogVO operlog) { - SysOperLogDO sysOperLogDO=new SysOperLogDO(); - BeanUtils.copyProperties(operlog,sysOperLogDO); + //判断是否需要保存修改前的数据 + final Boolean flag = (operlog.getTitle().equals(UPDATEACIDCHECKRECORD) || operlog.getTitle().equals(UPDATEACIDMEMBER) + || operlog.getTitle().equals(UPDATEACIDRECORD)); + if (flag) { + //保存数据 + try { + operlog.setBeforeUpdateData(saveBeforeUpdateData(operlog)); + } catch (JsonProcessingException e) { + e.printStackTrace(); + } + } + SysOperLogDO sysOperLogDO = new SysOperLogDO(); + BeanUtils.copyProperties(operlog, sysOperLogDO); int insert = sysOperLogDAO.insert(sysOperLogDO); - if (insert>0) { + if (insert > 0) { return R.ok(); } - return R.fail(); + return R.fail(); } /** @@ -961,14 +1610,19 @@ Page page = new Page<>(); Long pageNum = sysOperLogVO.getPageNum(); Long pageSize = sysOperLogVO.getPageSize(); - if (null==pageNum||pageNum==0) { + if (null == pageNum || pageNum == 0) { pageNum = 1l; } - if (null==pageSize||pageSize==0) { + if (null == pageSize || pageSize == 0) { pageSize = 10l; } page.setSize(pageSize); page.setCurrent(pageNum); + //因操作日志数据量太大,如果没有时间查询条件,默认查询最近十五天的数据 + if (StrUtil.isEmpty(sysOperLogVO.getStartTime()) && StrUtil.isEmpty(sysOperLogVO.getEndTime())){ + sysOperLogVO.setStartTime(com.panzhihua.common.utlis.DateUtils.getBeforeDay(15)); + sysOperLogVO.setEndTime(com.panzhihua.common.utlis.DateUtils.getCurrentDateymd()); + } IPage<SysOperLogVO> iPage = sysOperLogDAO.pageOperLog(page, sysOperLogVO); return R.ok(iPage); } @@ -979,15 +1633,16 @@ * @return 协议集合 */ @Override - public R listAgreement() { - List<SysUserAgreementDO> sysUserAgreementDOS = sysUserAgreementDAO.selectList(null); + public R listAgreement(Long communityId) { + List<SysUserAgreementDO> sysUserAgreementDOS = sysUserAgreementDAO.selectList( + new LambdaQueryWrapper<SysUserAgreementDO>().eq(SysUserAgreementDO::getCommunityId, communityId)); if (ObjectUtils.isEmpty(sysUserAgreementDOS)) { return R.fail(); } - List<SysUserAgreementVO> sysUserAgreementVOS=new ArrayList<>(); + List<SysUserAgreementVO> sysUserAgreementVOS = new ArrayList<>(); sysUserAgreementDOS.forEach(sysUserAgreementDO -> { - SysUserAgreementVO sysUserAgreementVO=new SysUserAgreementVO(); - BeanUtils.copyProperties(sysUserAgreementDO,sysUserAgreementVO); + SysUserAgreementVO sysUserAgreementVO = new SysUserAgreementVO(); + BeanUtils.copyProperties(sysUserAgreementDO, sysUserAgreementVO); sysUserAgreementVOS.add(sysUserAgreementVO); }); return R.ok(sysUserAgreementVOS); @@ -1001,10 +1656,10 @@ */ @Override public R putAgreement(SysUserAgreementVO sysUserAgreementVO) { - SysUserAgreementDO sysUserAgreementDO=new SysUserAgreementDO(); - BeanUtils.copyProperties(sysUserAgreementVO,sysUserAgreementDO); + SysUserAgreementDO sysUserAgreementDO = new SysUserAgreementDO(); + BeanUtils.copyProperties(sysUserAgreementVO, sysUserAgreementDO); int update = sysUserAgreementDAO.updateById(sysUserAgreementDO); - if (update==0) { + if (update == 0) { return R.fail("协议不存在"); } return R.ok(); @@ -1018,14 +1673,15 @@ */ @Override public R listComMngUserTag(Long communityId) { - List<ComMngUserTagDO> comMngUserTagDOS = comMngUserTagDAO.selectList(new QueryWrapper<ComMngUserTagDO>().lambda().eq(ComMngUserTagDO::getCommunityId, communityId)); + List<ComMngUserTagDO> comMngUserTagDOS = comMngUserTagDAO.selectList(new QueryWrapper<ComMngUserTagDO>().or() + .lambda().eq(ComMngUserTagDO::getSysFlag, 1).or().eq(ComMngUserTagDO::getCommunityId, communityId)); if (ObjectUtils.isEmpty(comMngUserTagDOS)) { return R.fail(); } - List<ComMngUserTagVO> comMngUserTagVOList=new ArrayList<>(); + List<ComMngUserTagVO> comMngUserTagVOList = new ArrayList<>(); comMngUserTagDOS.forEach(comMngUserTagDO -> { - ComMngUserTagVO comMngUserTagVO=new ComMngUserTagVO(); - BeanUtils.copyProperties(comMngUserTagDO,comMngUserTagVO); + ComMngUserTagVO comMngUserTagVO = new ComMngUserTagVO(); + BeanUtils.copyProperties(comMngUserTagDO, comMngUserTagVO); comMngUserTagVOList.add(comMngUserTagVO); }); return R.ok(comMngUserTagVOList); @@ -1043,15 +1699,15 @@ Long communityId = systemmanagementConfigVO.getCommunityId(); List<ComMngUserTagVO> comMngUserTagVOList = systemmanagementConfigVO.getComMngUserTagVOList(); if (!ObjectUtils.isEmpty(comMngUserTagVOList)) { - comMngUserTagDAO.delete(null); + comMngUserTagDAO.delete(new QueryWrapper<ComMngUserTagDO>().lambda().eq(ComMngUserTagDO::getCommunityId, communityId)); comMngUserTagVOList.forEach(comMngUserTagVO -> { - ComMngUserTagDO comMngUserTagDO=new ComMngUserTagDO(); + ComMngUserTagDO comMngUserTagDO = new ComMngUserTagDO(); comMngUserTagDO.setCommunityId(communityId); comMngUserTagDO.setTagName(comMngUserTagVO.getTagName()); comMngUserTagDAO.insert(comMngUserTagDO); }); return R.ok(); - }else { + } else { return R.fail("用户标签不能为空"); } @@ -1084,11 +1740,11 @@ public R putUserAppletsBackstage(PageUserAppletsBackstageDTO pageUserAppletsBackstageDTO) { Long userId = pageUserAppletsBackstageDTO.getUserId(); Integer status = pageUserAppletsBackstageDTO.getStatus(); - SysUserDO sysUserDO=new SysUserDO(); + SysUserDO sysUserDO = new SysUserDO(); sysUserDO.setUserId(userId); sysUserDO.setStatus(status); int update = userDao.updateById(sysUserDO); - if (update>0) { + if (update > 0) { return R.ok(); } return R.fail("用户不存在"); @@ -1102,8 +1758,8 @@ */ @Override public R deleteUserTest(Long userId) { - int num=userDao.deleteUserTest(userId); - if (num>0) { + int num = userDao.deleteUserTest(userId); + if (num > 0) { return R.ok(); } return R.fail("清除失败"); @@ -1116,8 +1772,9 @@ * @return 协议内容 */ @Override - public R userAgreement(int type) { - SysUserAgreementDO sysUserAgreementDO = sysUserAgreementDAO.selectOne(new QueryWrapper<SysUserAgreementDO>().lambda().eq(SysUserAgreementDO::getType, type)); + public R userAgreement(int type, String appId) { + SysUserAgreementDO sysUserAgreementDO = sysUserAgreementDAO + .selectOne(new QueryWrapper<SysUserAgreementDO>().lambda().eq(SysUserAgreementDO::getType, type).eq(SysUserAgreementDO::getAppId, appId)); return R.ok(sysUserAgreementDO); } @@ -1129,11 +1786,11 @@ */ @Override public R addFeedback(SysUserFeedbackDTO sysUserFeedbackDTO) { - SysUserFeedbackDO sysUserFeedbackDO=new SysUserFeedbackDO(); - BeanUtils.copyProperties(sysUserFeedbackDTO,sysUserFeedbackDO); + SysUserFeedbackDO sysUserFeedbackDO = new SysUserFeedbackDO(); + BeanUtils.copyProperties(sysUserFeedbackDTO, sysUserFeedbackDO); sysUserFeedbackDO.setPhotoPath(sysUserFeedbackDTO.getPhotoPah()); int insert = sysUserFeedbackDAO.insert(sysUserFeedbackDO); - if (insert>0) { + if (insert > 0) { return R.ok(); } return R.fail(); @@ -1147,13 +1804,16 @@ */ @Override public R pageNotice(PageDTO pageDTO) { - Long userId=pageDTO.getUserId(); + Long userId = pageDTO.getUserId(); Integer type = pageDTO.getType(); - int integer =0; - if (null!=type&&type.intValue()>0) { - integer=sysUserNoticeDAO.selectCount(new QueryWrapper<SysUserNoticeDO>().lambda().eq(SysUserNoticeDO::getUserId, userId).eq(SysUserNoticeDO::getStatus, 0).eq(SysUserNoticeDO::getType,type)); - }else{ - integer=sysUserNoticeDAO.selectCount(new QueryWrapper<SysUserNoticeDO>().lambda().eq(SysUserNoticeDO::getUserId, userId).eq(SysUserNoticeDO::getStatus, 0)); + int integer = 0; + if (null != type && type.intValue() > 0) { + integer = sysUserNoticeDAO + .selectCount(new QueryWrapper<SysUserNoticeDO>().lambda().eq(SysUserNoticeDO::getUserId, userId) + .eq(SysUserNoticeDO::getStatus, 0).eq(SysUserNoticeDO::getType, type)); + } else { + integer = sysUserNoticeDAO.selectCount(new QueryWrapper<SysUserNoticeDO>().lambda() + .eq(SysUserNoticeDO::getUserId, userId).eq(SysUserNoticeDO::getStatus, 0)); } Page page = new Page<>(); Long pageNum = pageDTO.getPageNum(); @@ -1161,9 +1821,9 @@ page.setSize(pageSize); page.setCurrent(pageNum); IPage<SysUserNoticeVO> iPage = userDao.pageNotice(page, pageDTO); - Map<String,Object> map=new HashMap<>(2); - map.put("page",iPage); - map.put("unreadNum",integer); + Map<String, Object> map = new HashMap<>(2); + map.put("page", iPage); + map.put("unreadNum", integer); return R.ok(map); } @@ -1177,20 +1837,21 @@ public R putNotice(NoticeReadDTO noticeReadDTO) { Integer all = noticeReadDTO.getAll(); Long userId = noticeReadDTO.getUserId(); - int num=0; - SysUserNoticeDO sysUserNoticeDO=new SysUserNoticeDO(); - if (null!=all&&1==all.intValue()) { + int num = 0; + SysUserNoticeDO sysUserNoticeDO = new SysUserNoticeDO(); + if (null != all && 1 == all.intValue()) { sysUserNoticeDO.setStatus(1); - num=sysUserNoticeDAO.update(sysUserNoticeDO,new UpdateWrapper<SysUserNoticeDO>().lambda().eq(SysUserNoticeDO::getUserId,userId).eq(SysUserNoticeDO::getStatus,0)); - }else{ + num = sysUserNoticeDAO.update(sysUserNoticeDO, new UpdateWrapper<SysUserNoticeDO>().lambda() + .eq(SysUserNoticeDO::getUserId, userId).eq(SysUserNoticeDO::getStatus, 0)); + } else { sysUserNoticeDO.setId(noticeReadDTO.getId()); sysUserNoticeDO.setStatus(1); - num=sysUserNoticeDAO.updateById(sysUserNoticeDO); + num = sysUserNoticeDAO.updateById(sysUserNoticeDO); } - if (num>0) { + if (num > 0) { return R.ok(); } - return R.fail("通知不存在"); + return R.fail("通知不存在"); } /** @@ -1218,16 +1879,17 @@ */ @Override public R noticeUnreadNum(Long userId) { - NoticeUnReadVO noticeUnReadVO=sysUserNoticeDAO.noticeUnreadNum(userId); - List<SysUserNoticeVO> sysUserNoticeVOList=new ArrayList<>(); - List<SysUserNoticeDO> sysUserNoticeDOS = sysUserNoticeDAO.selectList(new QueryWrapper<SysUserNoticeDO>().lambda().eq(SysUserNoticeDO::getUserId, userId).orderByDesc(SysUserNoticeDO::getCreateAt)); + NoticeUnReadVO noticeUnReadVO = sysUserNoticeDAO.noticeUnreadNum(userId); + List<SysUserNoticeVO> sysUserNoticeVOList = new ArrayList<>(); + List<SysUserNoticeDO> sysUserNoticeDOS = sysUserNoticeDAO.selectList(new QueryWrapper<SysUserNoticeDO>() + .lambda().eq(SysUserNoticeDO::getUserId, userId).orderByDesc(SysUserNoticeDO::getCreateAt)); if (!ObjectUtils.isEmpty(sysUserNoticeDOS)) { - List<Integer> typeList=new ArrayList<>(4); + List<Integer> typeList = new ArrayList<>(4); sysUserNoticeDOS.forEach(sysUserNoticeDO -> { Integer type = sysUserNoticeDO.getType(); if (!typeList.contains(type)) { - SysUserNoticeVO sysUserNoticeVO=new SysUserNoticeVO(); - BeanUtils.copyProperties(sysUserNoticeDO,sysUserNoticeVO); + SysUserNoticeVO sysUserNoticeVO = new SysUserNoticeVO(); + BeanUtils.copyProperties(sysUserNoticeDO, sysUserNoticeVO); sysUserNoticeVOList.add(sysUserNoticeVO); typeList.add(type); } @@ -1245,7 +1907,7 @@ */ @Override public R detailFeedback(Long id) { - SysUserFeedbackVO sysUserFeedbackVO=sysUserFeedbackDAO.detailFeedback(id); + SysUserFeedbackVO sysUserFeedbackVO = sysUserFeedbackDAO.detailFeedback(id); return R.ok(sysUserFeedbackVO); } @@ -1255,26 +1917,26 @@ * @return 展示数据 */ @Override - public R dataKanban() { - IndexDataKanbanVO indexDataKanbanVO=userDao.selectIndexDataKanban(); - List<DataKanbanDTO> dataKanbanDTOS=userDao.selectCommunityUserOrder(); + public R dataKanban(String areaCode) { + IndexDataKanbanVO indexDataKanbanVO = userDao.selectIndexDataKanban(areaCode); + List<DataKanbanDTO> dataKanbanDTOS = userDao.selectCommunityUserOrder(new Page(1L, 9999L), areaCode).getRecords(); - List<String> communityUserX=new ArrayList<>(); - List<Integer> communityUserY=new ArrayList<>(); - List<String> communityActiveUserX=new ArrayList<>(); - List<Integer> communityActiveUserY=new ArrayList<>(); + List<String> communityUserX = new ArrayList<>(); + List<Integer> communityUserY = new ArrayList<>(); + List<String> communityActiveUserX = new ArrayList<>(); + List<Integer> communityActiveUserY = new ArrayList<>(); if (!ObjectUtils.isEmpty(dataKanbanDTOS)) { dataKanbanDTOS.forEach(dataKanbanDTO -> { communityUserX.add(dataKanbanDTO.getName()); communityUserY.add(dataKanbanDTO.getNum()); }); } -// 获取最近七天数据 - List<Date> serverndays=this.getServenDays(); + // 获取最近七天数据 + List<Date> serverndays = this.getServenDays(); serverndays.forEach(date -> { - // 查询社区活动数量 - DataKanbanDTO dataKanbanDTO=userDao.selectCommunityActiveUserOrder(date); - communityActiveUserX.add(DateFormatUtils.format(date,"MM-dd")); + // 查询社区活动数量 + DataKanbanDTO dataKanbanDTO = userDao.selectCommunityActiveUserOrder(date); + communityActiveUserX.add(DateFormatUtils.format(date, "MM-dd")); communityActiveUserY.add(dataKanbanDTO.getNum()); }); indexDataKanbanVO.setCommunityActiveUserX(communityActiveUserX); @@ -1286,13 +1948,14 @@ /** * 获取最近七天数据 + * * @return */ private List<Date> getServenDays() { - List<Date>dates=new ArrayList<>(); - Date date=new Date(); - for(int i=6;i>=0;i--){ - Date date1= DateUtils.addDays(date,-i); + List<Date> dates = new ArrayList<>(); + Date date = new Date(); + for (int i = 6; i >= 0; i--) { + Date date1 = DateUtils.addDays(date, -i); dates.add(date1); } return dates; @@ -1306,7 +1969,8 @@ */ @Override public R indexDataCommunityBackstage(Long communityId) { - IndexDataVO indexDataVO=userDao.indexDataCommunityBackstage(communityId); + IndexDataVO indexDataVO = userDao.indexDataCommunityBackstage(communityId); + // 查询后台党员数量 return R.ok(indexDataVO); } @@ -1317,9 +1981,9 @@ */ @Override public R timedTaskContinuousLandingDays() { - int num=userDao.timedTaskContinuousLandingDays(); - if (num>0) { - log.info("定时任务维护用户持续登录时间,维护用户数量【{}】",num); + int num = userDao.timedTaskContinuousLandingDays(); + if (num > 0) { + log.info("定时任务维护用户持续登录时间,维护用户数量【{}】", num); } return R.ok(); } @@ -1332,10 +1996,10 @@ */ @Override public R addNotice(SysUserNoticeVO sysUserNoticeVO) { - SysUserNoticeDO sysUserNoticeDO=new SysUserNoticeDO(); - BeanUtils.copyProperties(sysUserNoticeVO,sysUserNoticeDO); + SysUserNoticeDO sysUserNoticeDO = new SysUserNoticeDO(); + BeanUtils.copyProperties(sysUserNoticeVO, sysUserNoticeDO); int insert = sysUserNoticeDAO.insert(sysUserNoticeDO); - if (insert>0) { + if (insert > 0) { return R.ok(); } return R.fail(); @@ -1349,14 +2013,65 @@ */ @Override public R updateUserIsPartymember(String idCard) { - SysUserDO sysUserDO=new SysUserDO(); - sysUserDO.setIsPartymember(1); - int update = userDao.update(sysUserDO, new UpdateWrapper<SysUserDO>().lambda().eq(SysUserDO::getIdCard, idCard)); - if (update>0) { - log.info("新增党员修改用户党员状态成功 身份证号【{}】",idCard); - return R.ok(); + SysUserDO sysUserDO = userDao.selectOne( + new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getIdCard, idCard).eq(SysUserDO::getType, 1)); + if (sysUserDO != null) { + sysUserDO.setIsPartymember(1); + int updated = userDao.updateById(sysUserDO); + if (updated > 0) { + // 删除用户信息缓存 + String userKey = UserConstants.LOGIN_USER_INFO + sysUserDO.getUserId(); + stringRedisTemplate.delete(userKey); + } + log.info("新增党员修改用户党员状态成功 身份证号【{}】", idCard); } - return R.fail(); + return R.ok(); + } + + /** + * 修改用户的党员状态 + * + * @param phone 身份证号 + * @return 修改结果 + */ + @Override + public R updateUserIsPartymemberByPhone(String phone) { + SysUserDO sysUserDO = userDao.selectOne( + new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getPhone, phone).eq(SysUserDO::getType, 1)); + if (sysUserDO != null) { + sysUserDO.setIsPartymember(1); + int updated = userDao.updateById(sysUserDO); + if (updated > 0) { + // 删除用户信息缓存 + String userKey = UserConstants.LOGIN_USER_INFO + sysUserDO.getUserId(); + stringRedisTemplate.delete(userKey); + } + log.info("新增党员修改用户党员状态成功 手机号【{}】", phone); + } + return R.ok(); + } + + /** + * 修改用户的党员状态 + * + * @param idCard 身份证号 + * @return 修改结果 + */ + @Override + public R updateUserNotPartymember(String idCard) { + SysUserDO sysUserDO = userDao.selectOne( + new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getIdCard, idCard).eq(SysUserDO::getType, 1)); + if (sysUserDO != null) { + sysUserDO.setIsPartymember(0); + int updated = userDao.updateById(sysUserDO); + if (updated > 0) { + // 删除用户信息缓存 + String userKey = UserConstants.LOGIN_USER_INFO + sysUserDO.getUserId(); + stringRedisTemplate.delete(userKey); + } + log.info("新增党员修改用户为非党员状态成功 身份证号【{}】", idCard); + } + return R.ok(); } /** @@ -1366,13 +2081,14 @@ * @return 协议内容 */ @Override - public R agreement(Integer type) { - SysUserAgreementDO sysUserAgreementDO = sysUserAgreementDAO.selectOne(new QueryWrapper<SysUserAgreementDO>().lambda().eq(SysUserAgreementDO::getType, type)); + public R agreement(Integer type, String appId) { + SysUserAgreementDO sysUserAgreementDO = sysUserAgreementDAO + .selectOne(new QueryWrapper<SysUserAgreementDO>().lambda().eq(SysUserAgreementDO::getType, type).eq(SysUserAgreementDO::getAppId, appId)); if (ObjectUtils.isEmpty(sysUserAgreementDO)) { return R.fail("协议不存在"); } - SysUserAgreementVO sysUserAgreementVO=new SysUserAgreementVO(); - BeanUtils.copyProperties(sysUserAgreementDO,sysUserAgreementVO); + SysUserAgreementVO sysUserAgreementVO = new SysUserAgreementVO(); + BeanUtils.copyProperties(sysUserAgreementDO, sysUserAgreementVO); return R.ok(sysUserAgreementVO); } @@ -1384,11 +2100,11 @@ */ @Override public R putUserLastLoginTime(Long userId) { - SysUserDO sysUserDO=new SysUserDO(); + SysUserDO sysUserDO = new SysUserDO(); sysUserDO.setUserId(userId); sysUserDO.setLastLoginTime(new Date()); int update = userDao.updateById(sysUserDO); - if (update>0) { + if (update > 0) { return R.ok(); } return R.fail(); @@ -1403,7 +2119,7 @@ @Override public R deleteFeedback(Long id) { int delete = sysUserFeedbackDAO.deleteById(id); - if (delete>0) { + if (delete > 0) { return R.ok(); } return R.fail(); @@ -1417,15 +2133,15 @@ */ @Override public R checkAereaName(String areaName) { - Integer num=userDao.selectCountArea(areaName); - if (num>0) { + Integer num = userDao.selectCountArea(areaName); + if (num > 0) { Integer integer = userDao.selectCountHouse(areaName); - if (integer>0) { + if (integer > 0) { return R.ok(); - }else{ + } else { return R.fail("小区房屋信息未创建,请先在社区平台添加房屋信息"); } - }else{ + } else { return R.fail("小区不存在,请先在社区平台添加小区"); } } @@ -1438,16 +2154,19 @@ */ @Override public CommunityUserInfoVO detailUserComunity(Long userId) { - CommunityUserInfoVO communityUserInfoVO=new CommunityUserInfoVO(); + CommunityUserInfoVO communityUserInfoVO = new CommunityUserInfoVO(); SysUserDO sysUserDO = userDao.selectById(userId); if (!ObjectUtils.isEmpty(sysUserDO)) { String idCard = sysUserDO.getIdCard(); if (!ObjectUtils.isEmpty(idCard)) { communityUserInfoVO.setAge(IdCard.IdNOToAge(idCard)); - communityUserInfoVO.setBirthday(IdCard.birthDay(idCard)); + communityUserInfoVO.setBirthday(sysUserDO.getBirthday()); communityUserInfoVO.setIdCard(idCard); } communityUserInfoVO.setCreateAt(sysUserDO.getCreateAt()); + communityUserInfoVO.setCardPhotoBack(sysUserDO.getCardPhotoBack()); + communityUserInfoVO.setCardPhotoFront(sysUserDO.getCardPhotoFront()); + communityUserInfoVO.setFamilyBook(sysUserDO.getFamilyBook()); communityUserInfoVO.setName(sysUserDO.getName()); String phone = sysUserDO.getPhone(); communityUserInfoVO.setPhone(phone); @@ -1459,18 +2178,19 @@ communityUserInfoVO.setVolunteerCreateAt(comMngVolunteerMngVO.getCreateAt()); } Integer isPartymember = sysUserDO.getIsPartymember(); - if (isPartymember.intValue()==1) { + if (isPartymember.intValue() == 1) { communityUserInfoVO.setPoliticalOutlook(1); - }else{ + } else { communityUserInfoVO.setPoliticalOutlook(3); } communityUserInfoVO.setIsVolunteer(sysUserDO.getIsVolunteer()); - List<ComMngFamilyInfoDO> comMngFamilyInfoDOS = comMngFamilyInfoDAO.selectList(new QueryWrapper<ComMngFamilyInfoDO>().lambda().eq(ComMngFamilyInfoDO::getUserId, userId)); + List<ComMngFamilyInfoDO> comMngFamilyInfoDOS = comMngFamilyInfoDAO + .selectList(new QueryWrapper<ComMngFamilyInfoDO>().lambda().eq(ComMngFamilyInfoDO::getUserId, userId)); if (!ObjectUtils.isEmpty(comMngFamilyInfoDOS)) { - List<ComMngFamilyInfoVO>comMngFamilyInfoVOS=new ArrayList<>(); + List<ComMngFamilyInfoVO> comMngFamilyInfoVOS = new ArrayList<>(); comMngFamilyInfoDOS.forEach(comMngFamilyInfoDO -> { - ComMngFamilyInfoVO comMngFamilyInfoVO=new ComMngFamilyInfoVO(); - BeanUtils.copyProperties(comMngFamilyInfoDO,comMngFamilyInfoVO); + ComMngFamilyInfoVO comMngFamilyInfoVO = new ComMngFamilyInfoVO(); + BeanUtils.copyProperties(comMngFamilyInfoDO, comMngFamilyInfoVO); comMngFamilyInfoVOS.add(comMngFamilyInfoVO); }); communityUserInfoVO.setComMngFamilyInfoVOS(comMngFamilyInfoVOS); @@ -1487,24 +2207,2006 @@ */ @Override public R export(ExportUserDTO exportUserDTO) { - List<EexcelUserDTO> eexcelUserDTOS=userDao.selectExport(exportUserDTO); + List<EexcelUserDTO> eexcelUserDTOS = userDao.selectExport(exportUserDTO); return R.ok(eexcelUserDTOS); } - - public static void main(String[] args) { -// String encode = new BCryptPasswordEncoder().encode("lbsq123456"); -// System.out.println(encode); - List<Date>dates=new ArrayList<>(); - Date date=new Date(); - for(int i=6;i>=0;i--){ - Date date1= DateUtils.addDays(date,-i); + @Override + public R getSysUserVOByPhone(String phone) { + SysUserDO sysUserDO = userDao + .selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getPhone, phone).eq(SysUserDO::getType, 1).orderByDesc(SysUserDO::getCreateAt).last("limit 1")); + if (ObjectUtils.isEmpty(sysUserDO)) { + return R.fail("账号或密码错误"); + } + SysUserVO sysUserVO = new SysUserVO(); + BeanUtils.copyProperties(sysUserDO, sysUserVO); + return R.ok(sysUserVO); + } + + /** + * 查询当前社区所有标签以及预设标签 + * + * @return 标签集合 + */ + @Override + public R listTags() { + List<String> list = new ArrayList<>(); + List<ComMngUserTagDO> comMngUserTagDOS = comMngUserTagDAO + .selectList(null); + if (!ObjectUtils.isEmpty(comMngUserTagDOS)) { + for (ComMngUserTagDO comMngUserTagDO : comMngUserTagDOS) { + if (!list.contains(comMngUserTagDO.getTagName())) { + list.add(comMngUserTagDO.getTagName()); + } + } +// list = comMngUserTagDOS.stream().map(comMngUserTagDO -> comMngUserTagDO.getTagName()) +// .collect(Collectors.toList()); + } + return R.ok(list); + } + + @Override + public R getSysUserVOByAccount(String account, Integer type) { + LambdaQueryWrapper<SysUserDO> query = new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getAccount, account); + query.eq(SysUserDO::getType, type); + SysUserDO sysUserDO = userDao.selectOne(query); + if (ObjectUtils.isEmpty(sysUserDO)) { + return R.fail("账号或密码错误"); + } + SysUserVO sysUserVO = new SysUserVO(); + BeanUtils.copyProperties(sysUserDO, sysUserVO); + return R.ok(sysUserVO); + } + + /** + * 新增SysUser + * + * @param storeVO 请求参数 + * @return 新增结果 + */ + @Override + public R addSysUser(ShopStoreVO storeVO) { + + SysUserDO sysUserDO = new SysUserDO(); + Long communityId = 0L; + // 新增社区高级管理员角色 + SysRoleDO sysRoleDO = new SysRoleDO(); + sysRoleDO.setCommunityId(0L); + sysRoleDO.setRoleName(storeVO.getName()); + sysRoleDO.setRoleKey(Constants.SHOP_ROLE_KEY + storeVO.getStoreAccount()); + sysRoleDO.setRoleSort(0); + sysRoleDO.setCreateBy(storeVO.getLoginUserId()); + int insert = roleDAO.insert(sysRoleDO); + if (insert < 0) { + return R.fail(); + } + // 新角色设置所有权限 + MenuRoleVO menuRoleVO = new MenuRoleVO(); + menuRoleVO.setIsAll(1); + menuRoleVO.setCommunityId(communityId); + menuRoleVO.setRoleId(sysRoleDO.getRoleId()); + this.putMenuRole(menuRoleVO); + + // sys_user 表 + String encode = new BCryptPasswordEncoder().encode(storeVO.getStorePassword()); + BeanUtils.copyProperties(storeVO, sysUserDO); + sysUserDO.setAccount(storeVO.getStoreAccount()); + sysUserDO.setType(5); + sysUserDO.setAreaId(null); + sysUserDO.setStatus(1); + sysUserDO.setPhone(storeVO.getPhone()); + sysUserDO.setName(storeVO.getContacts()); + sysUserDO.setPassword(encode); + sysUserDO.setAppId("wx0cef797390444b75"); + try { + insert = userDao.insert(sysUserDO); + SysUserRoleDO sysUserRoleDO = new SysUserRoleDO(); + sysUserRoleDO.setUserId(sysUserDO.getUserId()); + sysUserRoleDO.setRoleId(sysRoleDO.getRoleId()); + sysUserRoleDAO.insert(sysUserRoleDO); + // 把SysUserId赋值给店铺 + if (sysUserDO.getUserId() != null) { + userDao.updateStoreByPhone(storeVO.getPhone(), sysUserDO.getUserId()); + } + } catch (Exception e) { + e.printStackTrace(); + log.error("新增后台用户报错【{}】", e.getMessage()); + if (e.getMessage().contains("union_phone_type")) { + userDao.deleteStoreByPhoneAndStatus(storeVO.getPhone()); + roleDAO.deleteByRoleKey(Constants.SHOP_ROLE_KEY + storeVO.getStoreAccount()); + return R.fail("手机号已经存在"); + } else if (e.getMessage().contains("union_account_type")) { + return R.fail("账户已经存在"); + } + } + return R.ok(); + } + + /** + * 修改SysUser用户信息 + * + * @param storeVO 请求参数 + * @return 修改结果 + */ + @Override + public R editSysUser(ShopStoreVO storeVO) { + SysUserDO sysUserDO1 = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda() + .eq(SysUserDO::getPhone, storeVO.getStoreAccount()).eq(SysUserDO::getType, 5)); + if (sysUserDO1 == null) { + return R.fail("未查询到后台管理用户!"); + } + String encode = new BCryptPasswordEncoder().encode(storeVO.getStorePassword()); + sysUserDO1.setPassword(encode); + if (userDao.updateById(sysUserDO1) > 0) { + return R.ok(); + } + return R.fail("密码修改失败"); + } + + /** + * 修改用户小程序首页活动提示 + * + * @param userEditTipsDTO 请求参数 + * @return 修改结果 + */ + public R editUserTips(SysUserEditTipsDTO userEditTipsDTO) { + // 查询用户信息 + SysUserDO userDO = userDao.selectById(userEditTipsDTO.getUserId()); + if (userDO == null) { + return R.fail("未查询到用户信息"); + } + // 修改用户信息 + userDO.setIsTips(userEditTipsDTO.getIsTips()); + userDao.updateById(userDO); + if (userDao.updateById(userDO) > 0) { + return R.ok(); + } else { + return R.fail(); + } + } + + @Override + public R getUserArchives(Long userId) { + // 查询用户信息 + SysUserDO userDO = userDao.selectById(userId); + if (userDO == null) { + return R.fail("未查询到用户信息"); + } + UserArchivesVO userArchivesVO = new UserArchivesVO(); + BeanUtils.copyProperties(userDO, userArchivesVO); + userArchivesVO.setUserId(userDO.getUserId()); + return R.ok(userArchivesVO); + } + + @Override + public R updateUserArchives(UpdateUserArchivesVO userArchivesVO) { + if (userArchivesVO.getUserId() == null) { + return R.fail("未查询到用户信息"); + } + userDao.updateUserArchives(userArchivesVO); + return R.ok(); + } + + /** + * 修改app用户密码 + * + * @param userInfoAppDTO 请求参数 + * @return 修改结果 + */ + @Override + public R updateUserPassByApp(EditUserInfoPassAppDTO userInfoAppDTO) { + if (userInfoAppDTO.getOldPassword().equals(userInfoAppDTO.getNewPassword())) { + return R.fail("新密码不可与原密码相同"); + } + // 查询用户信息 + SysUserDO userDO = userDao.selectById(userInfoAppDTO.getUserId()); + if (userDO == null) { + return R.fail("未查询到用户信息"); + } + BCryptPasswordEncoder passwordEncoder = new BCryptPasswordEncoder(); + if (!passwordEncoder.matches(userInfoAppDTO.getOldPassword(), userDO.getPassword())) { + return R.fail("原密码错误"); + } + if (!userInfoAppDTO.getNewPassword().equals(userInfoAppDTO.getConfirmPassword())) { + return R.fail("两次输入的新密码不一致"); + } + userDO.setPassword(passwordEncoder.encode(userInfoAppDTO.getNewPassword())); + if (userDao.updateById(userDO) > 0) { + return R.ok(); + } else { + return R.fail(); + } + } + + /** + * 添加网格员 + * + * @param eventGridMemberAddDTO 请求参数 + * @return 结果 + */ + @Override + @Transactional(rollbackFor = Exception.class) + public R addGridUser(EventGridMemberAddDTO eventGridMemberAddDTO) { + SysRoleDO gridMemberDefaultRole = roleDAO.selectOne( + new QueryWrapper<SysRoleDO>().lambda().eq(SysRoleDO::getRoleKey, Constants.GRID_DEFAULT_ROLE_KEY)); + if (gridMemberDefaultRole == null) { + // 添加默认网格员角色 + gridMemberDefaultRole = new SysRoleDO(); + gridMemberDefaultRole.setCommunityId(0L); + gridMemberDefaultRole.setRoleName("网格员默认角色"); + gridMemberDefaultRole.setRoleKey(Constants.GRID_DEFAULT_ROLE_KEY); + gridMemberDefaultRole.setRoleSort(0); + gridMemberDefaultRole.setCreateBy(eventGridMemberAddDTO.getUserId()); + int insert = roleDAO.insert(gridMemberDefaultRole); + if (insert != 1) { + throw new ServiceException("网格员默认角色添加失败"); + } + } + Long roleId = gridMemberDefaultRole.getRoleId(); + // 新角色设置所有权限 + MenuRoleVO menuRoleVO = new MenuRoleVO(); + menuRoleVO.setIsAll(1); + menuRoleVO.setCommunityId(eventGridMemberAddDTO.getCommunityId()); + menuRoleVO.setRoleId(roleId); + this.putMenuRole(menuRoleVO); + + // 参数校验 + SysUserDO oldUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, 6) + .eq(SysUserDO::getNickName, eventGridMemberAddDTO.getNickName())); + if (oldUserDO != null) { + return R.fail("昵称已使用"); + } + + SysUserDO sysUserDO = new SysUserDO(); + String encode = new BCryptPasswordEncoder().encode(eventGridMemberAddDTO.getPassword()); + eventGridMemberAddDTO.setPassword(encode); + BeanUtils.copyProperties(eventGridMemberAddDTO, sysUserDO); + if (!StringUtils.isEmpty(sysUserDO.getNickName())) { + sysUserDO.setName(sysUserDO.getNickName()); + } + sysUserDO.setType(6); + if (StringUtils.isEmpty(eventGridMemberAddDTO.getImageUrl())) { + sysUserDO.setImageUrl(Constants.ZONG_ZHI_GRID_MEMBER_IMAGE_URL); + } + int insert = 0; + try { + insert = userDao.insert(sysUserDO); + SysUserRoleDO sysUserRoleDO = new SysUserRoleDO(); + sysUserRoleDO.setUserId(sysUserDO.getUserId()); + sysUserRoleDO.setRoleId(roleId); + sysUserRoleDAO.insert(sysUserRoleDO); + + // 关联市平台网格员 + if (eventGridMemberAddDTO.getLcMemberId() != null) { + LcCompareCodeMemberDO compareCodeMemberDO = + lcCompareMemberCodeMapper.selectOne(new QueryWrapper<LcCompareCodeMemberDO>().lambda() + .eq(LcCompareCodeMemberDO::getLcGridMemberId, eventGridMemberAddDTO.getLcMemberId())); + if (compareCodeMemberDO != null) { + compareCodeMemberDO.setLocalGridMemberId(sysUserDO.getUserId().toString()); + compareCodeMemberDO.setGridMemberName(sysUserDO.getNickName()); + compareCodeMemberDO.setUpdateAt(new Date()); + lcCompareMemberCodeMapper.updateById(compareCodeMemberDO); + } else { + compareCodeMemberDO = new LcCompareCodeMemberDO(); + compareCodeMemberDO.setId(Snowflake.getId()); + compareCodeMemberDO.setLocalGridMemberId(sysUserDO.getUserId().toString()); + compareCodeMemberDO.setGridMemberName(sysUserDO.getNickName()); + compareCodeMemberDO.setLcGridMemberId(eventGridMemberAddDTO.getLcMemberId()); + compareCodeMemberDO.setLcBindUserId(eventGridMemberAddDTO.getLcBindUserId()); + compareCodeMemberDO.setLcGridMemberName(eventGridMemberAddDTO.getLcMemberName()); + compareCodeMemberDO.setCreateAt(new Date()); + lcCompareMemberCodeMapper.insert(compareCodeMemberDO); + } + } + + // 网格员关联楼栋 + if (eventGridMemberAddDTO.getBuildingIds() != null && !eventGridMemberAddDTO.getBuildingIds().isEmpty()) { + List<EventGridMemberBuildingRelationDO> buildingRelationList = new ArrayList<>(); + eventGridMemberAddDTO.getBuildingIds().forEach(buildingId -> { + Map<String, Long> resultMap = this.userDao.getBuilding(buildingId); + if (resultMap != null) { + EventGridMemberBuildingRelationDO buildingRelationDO = new EventGridMemberBuildingRelationDO(); + buildingRelationDO.setBuildingId(buildingId); + buildingRelationDO.setGridMemberId(sysUserDO.getUserId()); + buildingRelationDO.setVillageId(Long.parseLong(resultMap.get("village_id").toString())); + buildingRelationDO.setCommunityId(Long.parseLong(resultMap.get("act_id").toString())); + buildingRelationDO.setCreateAt(new Date()); + buildingRelationList.add(buildingRelationDO); + } + }); + if (!buildingRelationList.isEmpty()) { + buildingRelationService.saveBatch(buildingRelationList); + } + } + } catch (Exception e) { + e.printStackTrace(); + log.error("新增后台用户报错【{}】", e.getMessage()); + if (e.getMessage().contains("union_phone_type")) { + return R.fail("手机号已经存在"); + } else if (e.getMessage().contains("union_account_type")) { + return R.fail("账户已经存在"); + } + } + if (insert > 0) { + return R.ok(); + } else { + return R.fail("添加失败"); + } + } + + /** + * 网格员管理 + * + * @param memberRelationDTO 请求参数 + * @return 网格员列表 + */ + @Override + public R getGridMemberList(PageEventGridMemberRelationDTO memberRelationDTO) { + IPage<GridMemberVO> gridMemberPage = userDao.getGridMemberList( + new Page(memberRelationDTO.getPageNum(), memberRelationDTO.getPageSize()), memberRelationDTO); + if (!gridMemberPage.getRecords().isEmpty()) { + gridMemberPage.getRecords().forEach(gridMember -> { + // 查询网格员关联市平台网格员id + Map<String, String> lcMemberMap = this.userDao.getLcMemberId(gridMember.getUserId()); + if (lcMemberMap != null) { + gridMember.setLcMemberId(lcMemberMap.get("lc_grid_member_id")); + gridMember.setLcMemberName(lcMemberMap.get("lc_grid_member_name")); + gridMember.setLcBindUserId(lcMemberMap.get("lc_bind_user_id")); + } + + // 查询网格员关联楼栋信息 + List<GridMemberBuildingVO> memberBuildingList = + eventGridMemberBuildingRelationMapper.getGridMemberBuildingRelation(gridMember.getUserId()); + if (!memberBuildingList.isEmpty()) { + memberBuildingList.forEach(memberBuilding -> { + if (!memberBuilding.getBuildingName().contains("栋")) { + memberBuilding.setBuildingName(memberBuilding.getBuildingName() + "栋"); + } + }); + gridMember.setMemberBuildingList(memberBuildingList); + } + }); + } + return R.ok(gridMemberPage); + } + + /** + * 修改网格员信息 + * + * @param gridMemberDTO 请求参数 + * @return 修改结果 + */ + @Override + @Transactional(rollbackFor = Exception.class) + public R editGridUser(EventGridMemberEditAdminDTO gridMemberDTO) { + + if (gridMemberDTO.getGridMemberId() == null) { + return R.fail("参数错误"); + } + SysUserDO sysUserDO = userDao.selectById(gridMemberDTO.getGridMemberId()); + if (sysUserDO == null) { + return R.fail("参数错误"); + } + gridMemberDTO.setUserId(gridMemberDTO.getGridMemberId()); + + // 参数校验 + SysUserDO oldUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, 6) + .eq(SysUserDO::getNickName, gridMemberDTO.getNickName())); + if (oldUserDO != null && !oldUserDO.getUserId().equals(gridMemberDTO.getGridMemberId())) { + return R.fail("昵称已使用"); + } + + BeanUtils.copyProperties(gridMemberDTO, sysUserDO); + + int insert = 0; + try { + insert = userDao.updateById(sysUserDO); + + // 清除原本关联网格员信息 + this.userDao.delLcMember(sysUserDO.getUserId()); + // 关联市平台网格员 + if (gridMemberDTO.getLcMemberId() != null) { + // 关联现有的网格员信息 + LcCompareCodeMemberDO compareCodeMemberDO = + lcCompareMemberCodeMapper.selectOne(new QueryWrapper<LcCompareCodeMemberDO>().lambda() + .eq(LcCompareCodeMemberDO::getLcGridMemberId, gridMemberDTO.getLcMemberId())); + if (compareCodeMemberDO != null) { + compareCodeMemberDO.setLocalGridMemberId(sysUserDO.getUserId().toString()); + compareCodeMemberDO.setGridMemberName(sysUserDO.getNickName()); + compareCodeMemberDO.setUpdateAt(new Date()); + lcCompareMemberCodeMapper.updateById(compareCodeMemberDO); + } else { + compareCodeMemberDO = new LcCompareCodeMemberDO(); + compareCodeMemberDO.setId(Snowflake.getId()); + compareCodeMemberDO.setLocalGridMemberId(sysUserDO.getUserId().toString()); + compareCodeMemberDO.setGridMemberName(sysUserDO.getNickName()); + compareCodeMemberDO.setLcGridMemberId(gridMemberDTO.getLcMemberId()); + compareCodeMemberDO.setLcBindUserId(gridMemberDTO.getLcBindUserId()); + compareCodeMemberDO.setLcGridMemberName(gridMemberDTO.getLcMemberName()); + compareCodeMemberDO.setCreateAt(new Date()); + lcCompareMemberCodeMapper.insert(compareCodeMemberDO); + } + } + // 清除原网格员与楼栋关联关系 + this.userDao.delGridMemberRelation(sysUserDO.getUserId()); + + // 新增网格员关联楼栋 + if (gridMemberDTO.getBuildingIds() != null && !gridMemberDTO.getBuildingIds().isEmpty()) { + List<EventGridMemberBuildingRelationDO> buildingRelationList = new ArrayList<>(); + gridMemberDTO.getBuildingIds().forEach(buildingId -> { + Map<String, Long> resultMap = this.userDao.getBuilding(buildingId); + if (resultMap != null) { + EventGridMemberBuildingRelationDO buildingRelationDO = new EventGridMemberBuildingRelationDO(); + buildingRelationDO.setBuildingId(buildingId); + buildingRelationDO.setGridMemberId(sysUserDO.getUserId()); + buildingRelationDO.setVillageId(Long.parseLong(resultMap.get("village_id").toString())); + buildingRelationDO.setCommunityId(Long.parseLong(resultMap.get("act_id").toString())); + buildingRelationDO.setCreateAt(new Date()); + buildingRelationList.add(buildingRelationDO); + } + }); + if (!buildingRelationList.isEmpty()) { + buildingRelationService.saveBatch(buildingRelationList); + } + } + + } catch (Exception e) { + e.printStackTrace(); + log.error("修改网格员用户报错【{}】", e.getMessage()); + if (e.getMessage().contains("union_phone_type")) { + return R.fail("手机号已经存在"); + } else if (e.getMessage().contains("union_account_type")) { + return R.fail("账户已经存在"); + } + } + if (insert > 0) { + return R.ok(); + } + return R.fail("修改失败"); + } + + /** + * 重置网格员密码 + * + * @param gridMemberDTO 请求参数 + * @return 重置结果 + */ + @Override + public R passResetUser(EventGridMemberPassResetDTO gridMemberDTO) { + if (gridMemberDTO.getIds().isEmpty() || StringUtils.isEmpty(gridMemberDTO.getPassword())) { + return R.fail("参数错误"); + } + String encode = new BCryptPasswordEncoder().encode(gridMemberDTO.getPassword()); + gridMemberDTO.setPassword(encode); + userDao.passResetUser(gridMemberDTO); + return R.ok(); + } + + /** + * 批量删除网格员 + * + * @param Ids 网格员id集合 + * @return 删除结果 + */ + @Override + public R deleteMembers(List<Long> Ids) { + if (Ids.isEmpty()) { + return R.fail("参数有误"); + } + if (userDao.deleteBatchIds(Ids) > 0) { + return R.ok(); + } + return R.fail("删除失败"); + } + + @Override + public R gridMemberEditStatus(EventGridMemberEditStatusDTO gridMemberEditDTO) { + if (gridMemberEditDTO.getIds().isEmpty()) { + return R.fail("参数有误"); + } + userDao.gridMemberEditStatus(gridMemberEditDTO); + return R.ok(); + } + + @Override + public R noTips(Long userId) { + SysUserDO userDO = this.userDao.selectById(userId); + if (userDO != null) { + userDO.setBigAgeTips(2); + if (this.userDao.updateById(userDO) > 0) { + return R.ok(); + } + } + return R.fail(); + } + + /** + * 查询社区的收益说明 + * + * @param communityId 社区id + * @return 收益说明 + */ + @Override + public R listAgreements(Long communityId) { + + List<SysUserAgreementDO> sysUserAgreementDOS = + sysUserAgreementDAO.selectList(new LambdaQueryWrapper<SysUserAgreementDO>() + .eq(SysUserAgreementDO::getCommunityId, communityId).eq(SysUserAgreementDO::getType, 5)); + if (sysUserAgreementDOS.isEmpty()) { + SysUserAgreementDO agreementDO = new SysUserAgreementDO(); + agreementDO.setCommunityId(communityId); + agreementDO.setName("收益说明"); + agreementDO.setType(5); + agreementDO.setCreateAt(new Date()); + agreementDO.setContent(Constants.PROFIT_EXPLAIN); + sysUserAgreementDAO.insert(agreementDO); + sysUserAgreementDOS.add(agreementDO); + } + List<SysUserAgreementVO> sysUserAgreementVOS = new ArrayList<>(); + sysUserAgreementDOS.forEach(sysUserAgreementDO -> { + SysUserAgreementVO sysUserAgreementVO = new SysUserAgreementVO(); + BeanUtils.copyProperties(sysUserAgreementDO, sysUserAgreementVO); + sysUserAgreementVOS.add(sysUserAgreementVO); + }); + return R.ok(sysUserAgreementVOS); + } + + @Override + public R getGridIsOk(Long userId) { + Integer count = this.userDao.getGridIsOk(userId); + if (count > 0) { + return R.ok(count); + } else { + return R.fail(); + } + } + + @Override + public R getGridsMemberList(Long communityId) { + return R.ok(this.userDao.getGridsMemberList(communityId)); + } + + /** + * 根据用户id查询用户openid + * + * @param userId 用户id + * @return openid + */ + @Override + public R getUserOpenId(Long userId) { + SysUserDO userDO = this.userDao.selectById(userId); + if (userDO != null) { + return R.ok(userDO.getOpenid()); + } + return R.fail(); + } + + /** + * 查询社区后台工作人员列表 + * + * @param communityId 社区id + * @return 社区后台工作人员列表 + */ + @Override + public R getUserListByCommunityId(Long communityId) { + return R.ok(this.userDao.getUserListByCommunityId(communityId)); + } + + /** + * 检查当前用户是否是社区工作人员 + * + * @param phone + * @param communityId + * @return + */ + @Override + public R checkCurrentUserIsTeam(String phone, Long communityId) { + int result = this.userDao.selectCountTeam(phone, communityId); + if (result > 0) { + return R.ok(true); + } + return R.ok(false); + } + + @Override + public R resetPassword(Long userId) { + SysUserDO sysUserDO = new SysUserDO(); + sysUserDO.setUserId(userId); + String encode = new BCryptPasswordEncoder().encode("admin123456"); + sysUserDO.setPassword(encode); + int update = userDao.updateById(sysUserDO); + if (update > 0) { + return R.ok(); + } + return R.fail(); + } + + @Override + public R resetPasswordPatch(Long[] userId, String password) { + if (userId != null) { + for (Long user : userId) { + SysUserDO sysUserDO = new SysUserDO(); + sysUserDO.setUserId(user); + String encode = new BCryptPasswordEncoder().encode(password); + sysUserDO.setPassword(encode); + userDao.updateById(sysUserDO); + } + } + return R.ok(); + } + + /** + * 便民服务新增商家账号 + * + * @param convenientMerchantDTO + * @return 商家用户id + */ + @Override + @Transactional(rollbackFor = Exception.class) + public R addConvenientMerchantUser(ConvenientMerchantDTO convenientMerchantDTO) { + SysUserDO sysUserDO; + sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getAccount, convenientMerchantDTO.getAccount())); + if (nonNull(sysUserDO)) { + return R.fail("账户已经存在"); + } + // sys_user 表 + sysUserDO = new SysUserDO(); + String encode = new BCryptPasswordEncoder().encode(convenientMerchantDTO.getPassword()); + BeanUtils.copyProperties(convenientMerchantDTO, sysUserDO); + sysUserDO.setAccount(convenientMerchantDTO.getAccount()); + sysUserDO.setType(10); + sysUserDO.setAreaId(null); + sysUserDO.setStatus(1); + sysUserDO.setPhone(null); + sysUserDO.setName(convenientMerchantDTO.getContacts()); + sysUserDO.setPassword(encode); + try { + userDao.insert(sysUserDO); + return R.ok(sysUserDO.getUserId()); + } catch (Exception e) { + e.printStackTrace(); + log.error("新增后台用户报错【{}】", e.getMessage()); + } + return R.fail("新增商户发生错误"); + } + + /** + * 修改便民服务商家绑定账号 + * + * @param userId 用户id + * @param account 修改账户 + * @return 修改结果 + */ + @Override + public R putUserAccount(Long userId, String account) { + SysUserDO sysUserDO = userDao.selectById(userId); + if (isNull(sysUserDO)) { + return R.fail("用户不存在"); + } + sysUserDO.setAccount(account); + userDao.updateById(sysUserDO); + return R.ok(); + } + + // /** + // * 修改便民服务商家绑定账号 + // * @param userId 用户id + // * @param account 修改账户 + // * @return 修改结果 + // */ + // @Override + // public R putUserAccount(Long userId, String account) { + // SysUserDO sysUserDO = userDao.selectById(userId); + // if (isNull(sysUserDO)) { + // return R.fail("用户不存在"); + // } + // String oldAccount = sysUserDO.getAccount(); + // sysUserDO.setAccount(account); + // int result = userDao.updateById(sysUserDO); + // if (result > 0) { + // SysRoleDO sysRoleDO = roleDAO.selectOne(new QueryWrapper<SysRoleDO>() + // .lambda().eq(SysRoleDO::getRoleKey, Constants.CONVENIENT_MERCHANT_ROLE_KEY + oldAccount)); + // if (nonNull(sysRoleDO)) { + // sysRoleDO.setRoleKey(Constants.CONVENIENT_MERCHANT_ROLE_KEY + account); + // roleDAO.updateById(sysRoleDO); + // } + // } + // return R.ok(); + // } + + @Override + public R disableOrEnableMerchantUsers(DisableOrEnableConvenientMerchantDTO disableOrEnableConvenientMerchantDTO) { + userDao.disableOrEnableMerchantUsers(disableOrEnableConvenientMerchantDTO.getType(), disableOrEnableConvenientMerchantDTO.getUserIds()); + return R.ok(); + } + + /** + * 根据openid维护社区团队里是否注册 + * + * @param openid 用户微信唯一标识 + */ + @Override + public void judgeCommunityTeam(String openid) { + //查询用户信息 + SysUserDO userDO = this.userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getOpenid, openid)); + if (userDO != null && StringUtils.isNotEmpty(userDO.getPhone())) { + if (this.userDao.getCommunityTeamCount(userDO.getPhone()) > 0) { + this.userDao.judgeCommunityTeam(userDO.getPhone()); + } + } + } + + /** + * 数据看板升级版 + * + * @return 运营后台数据看板升级版 + */ + @Override + public R dataKanBans(DataKanBansDto dataKanBansDto) { + IndexDataKanbanVO indexDataKanbanVO = userDao.selectIndexDataKanban(dataKanBansDto.getAppId()); + List<String> communityUserX = new ArrayList<>(); + List<Integer> communityUserY = new ArrayList<>(); + + List<String> communityActiveUserX = new ArrayList<>(); + List<Integer> communityActiveUserY = new ArrayList<>(); + List<Integer> communityActiveUserZ = new ArrayList<>(); + + List<DataKanbanDTO> dataKanbanDTOS = null; + Page page = new Page<>(); + if (nonNull(dataKanBansDto.getPageNum()) && nonNull(dataKanBansDto.getPageSize())) { + page.setCurrent(dataKanBansDto.getPageNum()); + page.setSize(dataKanBansDto.getPageSize()); + } else { + page.setCurrent(1L); + page.setSize(20L); + } + if (dataKanBansDto.getType() != null && dataKanBansDto.getType().equals(DataKanBansDto.type.by)) { + dataKanbanDTOS = userDao.selectCommunityUserOrderMonth(page, dataKanBansDto.getAppId()).getRecords(); + } else { + dataKanbanDTOS = userDao.selectCommunityUserOrder(page, dataKanBansDto.getAppId()).getRecords(); + } + if (!ObjectUtils.isEmpty(dataKanbanDTOS)) { + dataKanbanDTOS.forEach(dataKanbanDTO -> { + communityUserX.add(dataKanbanDTO.getName()); + communityUserY.add(dataKanbanDTO.getNum()); + }); + } + + // 获取最近二十天数据 + List<Date> activeDate = getTwentyDays(); + + String twentyDay = com.panzhihua.common.utlis.DateUtils.getTwentyDay(); + //获取最近活跃人数 + List<UsersStatisticsDTO> actives = userDao.selectActive(twentyDay, dataKanBansDto.getAppId()); + //获取最近注册人数 + List<UsersStatisticsDTO> dailyAdds = userDao.selectDailyAdd(twentyDay, dataKanBansDto.getAppId()); + + Map<String, String> activeMap = actives.stream().collect(Collectors.toMap(UsersStatisticsDTO::getSpecificDate, UsersStatisticsDTO::getTotal)); + Map<String, String> dailyAddMap = dailyAdds.stream().collect(Collectors.toMap(UsersStatisticsDTO::getSpecificDate, UsersStatisticsDTO::getTotal)); + + + for (Date date : activeDate) { + String dateStr = DateUtil.format(date, "yyyy-MM-dd"); + communityActiveUserX.add(DateFormatUtils.format(date, "MM-dd")); + communityActiveUserY.add(dailyAddMap.containsKey(dateStr) ? Integer.parseInt(dailyAddMap.get(dateStr)) : 0); + communityActiveUserZ.add(activeMap.containsKey(dateStr) ? Integer.parseInt(activeMap.get(dateStr)) : 0); + } + indexDataKanbanVO.setCommunityActiveUserX(communityActiveUserX); + indexDataKanbanVO.setCommunityAddUserY(communityActiveUserY); + indexDataKanbanVO.setCommunityActiveUserY(communityActiveUserZ); + indexDataKanbanVO.setCommunityUserX(communityUserX); + indexDataKanbanVO.setCommunityUserY(communityUserY); + return R.ok(indexDataKanbanVO); + } + + /** + * 运营后台-用户数据统计汇总 + * + * @return 用户数据统计汇总 + */ + @Override + public R communityStatistics(String areaCode) { + //返回结果数据 + IndexUserStatisticsVo userStatisticsVo = new IndexUserStatisticsVo(); + //查询所有街道 + List<IndexUserStreetVo> streetList = userDao.getUserStreetList(areaCode); + streetList.forEach(street -> { + List<IndexUserCommunityVo> communityList = userDao.getUserCommunityList(street.getStreetId()); + street.setCommunityList(communityList); + }); + userStatisticsVo.setStreetList(streetList); + return R.ok(userStatisticsVo); + } + + @Override + public R communityStatisticsExport(String areaCode) { + return R.ok(userDao.getUserCommunityExcelExport(areaCode)); + } + + /** + * 通过UnionId获取用户信息 + * + * @param unionId + * @return + */ + @Override + public R getUserInfoByUnionId(String unionId) { + SysUserDO sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getUnionid, unionId)); + if (isNull(sysUserDO)) { + return R.fail("账号或密码错误"); + } + LoginUserInfoVO loginUserInfoVO = new LoginUserInfoVO(); + BeanUtils.copyProperties(sysUserDO, loginUserInfoVO); + return R.ok(loginUserInfoVO); + } + + @Override + public R updateStreetId(AdministratorsUserVO administratorsUserVO) { + SysUserDO sysUserDO = new SysUserDO(); + BeanUtils.copyProperties(administratorsUserVO, sysUserDO); + userDao.updateById(sysUserDO); + return R.ok(); + } + + /** + * 删除用户信息缓存 + * + * @param phone + */ + @Override + public R deleteUserCashByPhone(String phone) { + SysUserDO sysUserDO = this.userDao.selectOne(new LambdaQueryWrapper<SysUserDO>().eq(SysUserDO::getPhone, phone).eq(SysUserDO::getType, 1)); + if (nonNull(sysUserDO)) { + String userKey = UserConstants.LOGIN_USER_INFO + sysUserDO.getUserId(); + stringRedisTemplate.delete(userKey); + } + return R.ok(); + } + + /** + * 微商业街新增商家账号 + * + * @param mcsMerchantDTO + * @return 商家用户id + */ + @Override + @Transactional(rollbackFor = Exception.class) + public R addMcsMerchantUser(McsMerchantDTO mcsMerchantDTO) { + SysUserDO sysUserDO; + sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda() + .eq(SysUserDO::getPhone, mcsMerchantDTO.getPhone()).eq(SysUserDO::getType, 11)); + String encode = new BCryptPasswordEncoder().encode(mcsMerchantDTO.getPassword()); + if (nonNull(sysUserDO)) { + sysUserDO.setAccount(mcsMerchantDTO.getAccount()); + sysUserDO.setStatus(mcsMerchantDTO.getAccountStatus()); + sysUserDO.setPhone(mcsMerchantDTO.getPhone()); + sysUserDO.setPassword(encode); + sysUserDO.setPlaintextPassword(mcsMerchantDTO.getPassword()); + sysUserDO.setImageUrl(mcsMerchantDTO.getLogo()); + sysUserDO.setName(mcsMerchantDTO.getName()); + userDao.updateById(sysUserDO); + McsLoginUserInfoVO loginUserInfoVO = new McsLoginUserInfoVO(); + BeanUtils.copyProperties(sysUserDO, loginUserInfoVO); + return R.ok(loginUserInfoVO); + } + // sys_user 表 + sysUserDO = new SysUserDO(); + BeanUtils.copyProperties(mcsMerchantDTO, sysUserDO); + sysUserDO.setAccount(mcsMerchantDTO.getAccount()); + sysUserDO.setType(11); + sysUserDO.setAreaId(null); + sysUserDO.setStatus(mcsMerchantDTO.getAccountStatus()); + sysUserDO.setPhone(mcsMerchantDTO.getPhone()); + sysUserDO.setPassword(encode); + sysUserDO.setPlaintextPassword(mcsMerchantDTO.getPassword()); + sysUserDO.setImageUrl(mcsMerchantDTO.getLogo()); + try { + userDao.insert(sysUserDO); + McsLoginUserInfoVO loginUserInfoVO = new McsLoginUserInfoVO(); + BeanUtils.copyProperties(sysUserDO, loginUserInfoVO); + return R.ok(loginUserInfoVO); + } catch (Exception e) { + e.printStackTrace(); + log.error("修改数字商业街商家用户报错【{}】", e.getMessage()); + if (e.getMessage().contains("union_account_type") || e.getMessage().contains("23000")) { + return R.fail("账户已经存在"); + } else { + return R.fail("账户或手机号已存在,请重新填写尝试"); + } + } + } + + /** + * 微商业街修改商家账号 + * + * @param mcsMerchantDTO + * @return + */ + @Override + public R putMcsMerchantUser(McsMerchantDTO mcsMerchantDTO) { + SysUserDO sysUserDO = userDao.selectById(mcsMerchantDTO.getUserId()); + if (isNull(sysUserDO)) { + return R.fail("用户不存在"); + } + String account = mcsMerchantDTO.getAccount(); + String phone = mcsMerchantDTO.getPhone(); + Integer accountStatus = mcsMerchantDTO.getAccountStatus(); + String name = mcsMerchantDTO.getName(); + if (isNotBlank(account)) { + sysUserDO.setAccount(account); + } + if (isNotBlank(phone)) { + sysUserDO.setPhone(phone); + } + if (nonNull(accountStatus)) { + sysUserDO.setStatus(accountStatus); + } + if (isNotBlank(name)) { + sysUserDO.setName(name); + } + try { + userDao.updateById(sysUserDO); + } catch (Exception e) { + e.printStackTrace(); + log.error("修改数字商业街商家用户报错【{}】", e.getMessage()); + if (e.getMessage().contains("union_phone_type")) { + return R.fail("手机号已存在"); + } else if (e.getMessage().contains("union_account_type")) { + return R.fail("账户已经存在"); + } else if (e.getMessage().contains("23000")) { + return R.fail("手机号已存在"); + } else { + return R.fail("账户或手机号已存在,请重新填写尝试"); + } + } + return R.ok(); + } + + /** + * 检查用户是否有效 + * + * @param userId + * @param type + * @return + */ + @Override + public Boolean checkUserIsValid(Long userId, Integer type) { + SysUserDO sysUserDO = userDao.selectById(userId); + if (isNull(sysUserDO) || sysUserDO.getStatus() != 1 || !sysUserDO.getType().equals(type)) { + return false; + } + return true; + } + + /** + * 根据手机号、用户类型查询用户 + * + * @param phone + * @param type + * @return + */ + @Override + public R getSysUserByPhone(String phone, Integer type) { + SysUserDO sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getPhone, phone).eq(SysUserDO::getType, type)); + McsLoginUserInfoVO loginUserInfoVO = null; + if (nonNull(sysUserDO)) { + loginUserInfoVO = new McsLoginUserInfoVO(); + BeanUtils.copyProperties(sysUserDO, loginUserInfoVO); + } + return R.ok(loginUserInfoVO); + } + + /** + * 发送验证码 + * + * @param phone 手机号 + * @param clientIP 用户ip + * @param prefixKey redis Key 前缀 + * @param limit 获取次数限制 + * @param timeout 超次数获取时间等待 + * @return + */ + @Override + public R sendMessageCode(String phone, String clientIP, String prefixKey, Integer limit, Integer timeout) { + ValueOperations<String, String> opsForValue = stringRedisTemplate.opsForValue(); + if (isNotBlank(clientIP)) { + String redisKey = String.join("::", prefixKey, clientIP); + Long increment = opsForValue.increment(redisKey, 1); + if (increment > limit) { + return R.fail(String.format("请求过于频繁,请%d分钟后再次尝试!", timeout / 60)); + } + stringRedisTemplate.expire(redisKey, timeout, TimeUnit.SECONDS); + } + Random r = new Random(); + StringBuilder rs = new StringBuilder(); + for (int i = 0; i < 5; i++) { + rs.append(r.nextInt(10)); + } + String code = rs.toString(); + int result = SmsUtil.sendCode(phone, code); + if (result == 1) { + String codeKey = String.join("::", phone, code); + opsForValue.set(codeKey, code, timeout, TimeUnit.SECONDS); + return R.ok(); + } + return R.fail(); + } + + /** + * 根据openId获取微商业街用户 + * + * @param openid + * @return + */ + @Override + public R getMcsUserByOpenId(String openid) { + SysUserDO sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getOpenid, openid).eq(SysUserDO::getType, 11)); + McsLoginUserInfoVO loginUserInfoVO = null; + if (nonNull(sysUserDO) && isNotBlank(sysUserDO.getOpenid())) { + loginUserInfoVO = new McsLoginUserInfoVO(); + BeanUtils.copyProperties(sysUserDO, loginUserInfoVO); + } + return R.ok(loginUserInfoVO); + } + + /** + * 商业街用户微信授权-绑定手机号 + * + * @param bindUserPhoneDTO + * @return + */ + @Override + public R bindOrAddMcsUser(BindUserPhoneDTO bindUserPhoneDTO) { + String phone = bindUserPhoneDTO.getPhone(); + String openId = bindUserPhoneDTO.getOpenId(); + String redisKey = String.join("::", phone, bindUserPhoneDTO.getCode()); + Boolean hasKey = stringRedisTemplate.hasKey(redisKey); + if (hasKey) { + //通过验证 + SysUserDO sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getPhone, phone).eq(SysUserDO::getType, 11)); + if (nonNull(sysUserDO)) { + //已有用户 + sysUserDO.setOpenid(openId); + int result = userDao.updateById(sysUserDO); + if (result > 0) { + McsLoginUserInfoVO loginUserInfoVO = new McsLoginUserInfoVO(); + BeanUtils.copyProperties(sysUserDO, loginUserInfoVO); + stringRedisTemplate.delete(redisKey); + return R.ok(loginUserInfoVO); + } + return R.fail("绑定失败,请重试"); + } else { + //自动创建用户 + McsMerchantDTO mcsMerchantDTO = new McsMerchantDTO(); + mcsMerchantDTO.setAccount(phone); + mcsMerchantDTO.setPassword("88888888"); + mcsMerchantDTO.setAccountStatus(1); + mcsMerchantDTO.setPhone(phone); + mcsMerchantDTO.setName("用户" + retrieveRandomCode(5)); + mcsMerchantDTO.setImageUrl(DEFAULT_IMAGE_URL); + mcsMerchantDTO.setOpenId(openId); + R addUserResult = addMcsMerchantUser(mcsMerchantDTO); + if (R.isOk(addUserResult)) { + McsLoginUserInfoVO loginUserInfoVO = JSONObject.parseObject(JSONObject.toJSONString(addUserResult.getData()), McsLoginUserInfoVO.class); + loginUserInfoVO.setPlaintextPassword("88888888"); + stringRedisTemplate.delete(redisKey); + return R.ok(loginUserInfoVO); + } + return addUserResult; + } + } else { + return R.fail("验证码错误"); + } + } + + private String retrieveRandomCode(int length) { + Random r = new Random(); + StringBuilder rs = new StringBuilder(); + for (int i = 0; i < length; i++) { + rs.append(r.nextInt(10)); + } + return rs.toString(); + } + + @Override + public R updateUserPartyStatus(Long userId) { + List<SysUserDO> sysUserDOs = userDao.selectByUserId(userId); + for (SysUserDO sysUserDO : sysUserDOs) { + if (sysUserDO != null) { + sysUserDO.setIsPartymember(1); + int updated = userDao.updateById(sysUserDO); + if (updated > 0) { + // 删除用户信息缓存 + String userKey = UserConstants.LOGIN_USER_INFO + sysUserDO.getUserId(); + stringRedisTemplate.delete(userKey); + } + } + } + + return R.ok(); + } + + @Override + public R uuLogin(UuLoginVO uuLoginVO) { + String appId = ""; + String secret = ""; + if ("wx118de8a734d269f0".equals(uuLoginVO.getAppid())) { + appId = "10000"; + secret = "e10adc3949ba59abbe56e057f20f883e"; + } else if ("wx98d62711dfbd8425".equals(uuLoginVO.getAppid())) { + appId = "10001"; + secret = "d89f3a35931c386956c1a402a8e09941"; + } else { + return R.fail("appid未传"); + } + uuLoginVO.setAppid(appId); + String timeStamp = PayUtil.create_timestamp(); + uuLoginVO.setTimestamp(timeStamp); + try { + uuLoginVO.setSign(PayUtil.MD5(uuLoginVO.getAppid() + secret + timeStamp).toLowerCase(Locale.ROOT)); + } catch (Exception e) { + e.printStackTrace(); + } + Map<String, String> headerMap = new HashMap<>(); + headerMap.put("appid", appId); + String resultJson = HttpClientUtil.get("https://api.uucsh.cn/member/wx/get-access?province=" + uuLoginVO.getProvince() + "&city=" + uuLoginVO.getCity() + "&area=" + uuLoginVO.getArea() + "&appid=" + appId + "×tamp=" + uuLoginVO.getTimestamp() + "&sign=" + uuLoginVO.getSign() + "&mobile=" + uuLoginVO.getMobile() + "&couponId=" + uuLoginVO.getCouponId(), headerMap, null); + JSONObject result = JSON.parseObject(resultJson); + if (result.get("status").equals(1)) { + return R.ok(result.get("data")); + } + return R.fail("信息错误"); + } + + @Override + public R checkExport(String account, String password, String oldPassword) { + if (new BCryptPasswordEncoder().matches(password, oldPassword)) { + return R.ok(); + } + return R.fail(); + } + + @Override + public R newIndexData(Integer type, Long streetId, Long areaCode, String appId) { + IndexDataKanbanVO indexDataKanbanVO = userDao.selectIndexDataKanban(appId); + IndexDataAnalysisVO vo = new IndexDataAnalysisVO(); + if (ObjectUtils.isEmpty(type)) { + //不传默认为所有区县 + type = ALLCOUNTY; + } + if (type.equals(ALLCOUNTY) || type.equals(ALLCOMMUNITY) || type.equals(ALLSTREET)) { + BeanUtils.copyProperties(indexDataKanbanVO, vo); + } else { + IndexDataKanbanVO indexDataVO = userDao.dataKanBanStreet(streetId, areaCode, null); + BeanUtils.copyProperties(indexDataVO, vo); + } +// List<UserProportion> userProportionsTotal = userDao.userAnalysis(type, null, streetId,areaCode); +// Integer streetUser = userDao.streetUserCount(streetId,areaCode); +// for (UserProportion userProportion : userProportionsTotal) { +// if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(userProportion)){ +// if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(userProportion.getUser())){ +// //计算占比 +// //userProportion.setAreaCode(null); +// if (type.equals(BYSTREET)){ +// userProportion.setRate(getRate(streetUser,userProportion.getUser())); +// } +// userProportion.setRate(getRate(vo.getAllUser(),userProportion.getUser())); +// } +// } +// } +// List<UserProportion> userProportionsMonth = userDao.userAnalysis(type, DateUtil.beginOfMonth(new Date()).toString(), streetId,areaCode); +// for (UserProportion userProportion : userProportionsMonth) { +// if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(userProportion)){ +// if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(userProportion.getUser())){ +// //计算占比 +// //userProportion.setAreaCode(null); +// if (type.equals(BYSTREET)){ +// userProportion.setRate(getRate(streetUser,userProportion.getUser())); +// } +// userProportion.setRate(getRate(vo.getAllUser(),userProportion.getUser())); +// } +// } +// } +// vo.setUserProportionTotal(userProportionsTotal); +// vo.setUserProportionMonth(userProportionsMonth); +// List<RealUser> realUsersTotal = userDao.realUserCount(type, null, streetId,areaCode); +// List<RealUser> realUsersMonth = userDao.realUserCount(type, DateUtil.beginOfMonth(new Date()).toString(), streetId,areaCode); +// vo.setRealUsersTotal(realUsersTotal); +// vo.setRealUsersMonth(realUsersMonth); +// vo.setRealUser(getStreetRealUser(realUsersTotal)); +// vo.setRealUserRate(getRate(vo.getAllUser(),vo.getRealUser())); +// List<Date> twentyDays = getTwentyDays(); +// List<Date> monthTwentyDays = getMonthTwentyDays(); +// vo.setUserActivityXAll(getMAndD(getTwentyDays())); +// vo.setUserActivityXMonth(getMAndD(getMonthTwentyDays())); +// List<String> addUserYAll=new ArrayList<>(); +// List<String> addUserYMonth=new ArrayList<>(); +// List<String> activeUserYAll=new ArrayList<>(); +// List<String> activeUserYMonth=new ArrayList<>(); +// SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd"); +// //获取用户行为Y轴 +// for (Date date : twentyDays) { +// //查询当天的新增和日活 +// Map<String, Long> map = userDao.getDailyAddAndActive(DateUtil.parse(sdf.format(date)), streetId,areaCode); +// addUserYAll.add(map.get("addUser").toString()); +// activeUserYAll.add(map.get("activeUser").toString()); +// } +// for (Date date : monthTwentyDays) { +// Map<String, Long> map = userDao.getDailyAddAndActive(DateUtil.parse(sdf.format(date)), streetId,areaCode); +// addUserYMonth.add(map.get("addUser").toString()); +// activeUserYMonth.add(map.get("activeUser").toString()); +// } +// vo.setAddUserYAll(addUserYAll); +// vo.setAddUserYWeek(addUserYMonth); +// vo.setActiveUserYAll(activeUserYAll); +// vo.setActiveUserYMonth(activeUserYMonth); +// if (type.equals(BYSTREET) || type.equals(ALLCOMMUNITY) || type.equals(ALLSTREET)){ +// //获取其他用户 +// vo.setOtherUser(indexDataKanbanVO.getAllUser()-countUser(vo.getUserProportionTotal())); +// vo.setOtherUserRate(getRate(indexDataKanbanVO.getAllUser(),vo.getOtherUser())); +// } + return R.ok(vo); + } + + @Override + public R userRate(Integer type, Long streetId, Long areaCode, Integer range, String appId) { + IndexDataAnalysisVO analysisVO = new IndexDataAnalysisVO(); + if (type.equals(BYSTREET) || type.equals(BYAREA)) { + //街道,区县筛选 + IndexDataKanbanVO indexDataVO = userDao.dataKanBanStreet(streetId, areaCode, null); + BeanUtils.copyProperties(indexDataVO, analysisVO); + } else { + //总量数据 + IndexDataKanbanVO indexDataKanbanVO = userDao.selectIndexDataKanban(appId); + BeanUtils.copyProperties(indexDataKanbanVO, analysisVO); + } + String date = ""; + if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(range)) { + if (range.equals(1)) { + DateTime dateTime = DateUtil.beginOfMonth(new Date()); + date = DateUtil.parse(dateTime.toString(), "yyyy-MM-dd HH:mm:ss").toString(); + } + } + List<UserProportion> userProportions = userDao.userAnalysis(type, date, streetId, areaCode, appId); + List<UserRateAnalysisVO> userRateAnalysisVOList = new ArrayList<>(); + Boolean monthRange = false; + if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(range)) { + if (range.equals(1)) { + monthRange = true; + } + } + if (userProportions.size() > 0) { + for (UserProportion userProportion : userProportions) { + if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(userProportion)) { + UserRateAnalysisVO vo = new UserRateAnalysisVO(); + if (monthRange) { + if (userProportion.getCommunityId().equals("11")) { + continue; + } + //获取本月的用户总数作为计算占比的用户总数 + //IndexDataKanbanVO data = userDao.dataKanBanStreet(streetId, areaCode, date); + Integer monthUsers = userDao.getMonthUsers(streetId, areaCode, date, appId); + vo.setRate(getRate(monthUsers, userProportion.getUser())); + } else { + vo.setRate(getRate(analysisVO.getAllUser(), userProportion.getUser())); + } + vo.setName(typeToName(type, userProportion)); + vo.setCount(userProportion.getUser()); + userRateAnalysisVOList.add(vo); + } + } + } + if (ObjectUtils.isEmpty(range)) { + //查看累计数据时才计算其他用户的比例 || type.equals(BYSTREET) || type.equals(BYAREA)) + final Boolean flag = (type.equals(ALLSTREET) || type.equals(ALLCOMMUNITY)); + if (flag) { + UserRateAnalysisVO vo = new UserRateAnalysisVO(); + vo.setName(OTHERUSER); + vo.setCount(analysisVO.getAllUser() - countUser(userRateAnalysisVOList)); + vo.setRate(getRate(analysisVO.getAllUser(), vo.getCount())); + userRateAnalysisVOList.add(vo); + } + } + //计算其他用户占比 + UserRateVO userRate = new UserRateVO(); + userRate.setUserList(userRateAnalysisVOList); + return R.ok(userRate); + } + + @Override + public R realUser(Integer type, Long streetId, Long areaCode, Integer range, String appId) { + IndexDataAnalysisVO analysisVO = new IndexDataAnalysisVO(); + if (type.equals(BYSTREET) || type.equals(BYAREA)) { + //街道,区县筛选 + IndexDataKanbanVO indexDataVO = userDao.dataKanBanStreet(streetId, areaCode, null); + BeanUtils.copyProperties(indexDataVO, analysisVO); + } else { + //总量数据 + IndexDataKanbanVO indexDataKanbanVO = userDao.selectIndexDataKanban(appId); + BeanUtils.copyProperties(indexDataKanbanVO, analysisVO); + } + String date = ""; + if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(range)) { + if (range.equals(1)) { + DateTime dateTime = DateUtil.beginOfMonth(new Date()); + date = DateUtil.parse(dateTime.toString(), "yyyy-MM-dd HH:mm:ss").toString(); + } + } + RealUserVO realUserVO = new RealUserVO(); + List<RealUser> realUsers = userDao.realUserCount(type, date, streetId, areaCode, appId); + List<RealUserAnalysisVO> realUserList = new ArrayList<>(); + realUserVO.setRealUserCount(getStreetRealUser(realUsers)); + Integer rate = getRate(analysisVO.getAllUser(), realUserVO.getRealUserCount()); + if (null == rate) { + realUserVO.setRealUserRate(0.0); + } else { + realUserVO.setRealUserRate(rate.doubleValue()); + } + for (RealUser realUser : realUsers) { + if (!(type.equals(ALLCOUNTY))) { + if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(realUser)) { + if (realUser.getCommunityId().equals("11")) { + continue; + } + } + } + RealUserAnalysisVO vo = new RealUserAnalysisVO(); + vo.setCount(realUser.getCount()); + vo.setName(typeToNameRealUser(type, realUser)); + realUserList.add(vo); + } + realUserVO.setRealUserList(realUserList); + //使用索引迭代避免从列表移除数据后出现空指针异常 + if (type.equals(BYSTREET) || type.equals(ALLCOMMUNITY)) { + for (int i = 0; i < realUserList.size(); i++) { + RealUserAnalysisVO realUserAnalysisVO = realUserList.get(i); + if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(realUserAnalysisVO)) { + if (StringUtils.isNotEmpty(realUserAnalysisVO.getName())) { + if (realUserAnalysisVO.getName().equals("请选择社区")) { + realUserList.remove(i); + } + } + } + } + } else { + //只保留十条 + if (realUserList.size() >= 11) { + realUserList.remove(10); + } + } + return R.ok(realUserVO); + } + +// @Override +// public R userActivity(Integer type, Long streetId, Long areaCode, Integer range, String appId) { +// UserActivityAnalysisVO vo = new UserActivityAnalysisVO(); +// List<Date> activeX = getTwentyDays(); +// List<String> activeY = new ArrayList<>(); +// List<String> adY = new ArrayList<>(); +// if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(range)) { +// if (range.equals(1)) { +// //本月数据 +// activeX = getMonthTwentyDays(); +// } +// } +// SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); +// for (Date date : activeX) { +// Map<String, Long> map = userDao.getDailyAddAndActive(DateUtil.parse(sdf.format(date)), streetId, areaCode, appId); +// adY.add(map.get("addUser").toString()); +// activeY.add(map.get("activeUser").toString()); +// } +// vo.setUserX(getMAndD(activeX)); +// vo.setAddUserY(adY); +// vo.setActiveUserY(activeY); +// return R.ok(vo); +// } + + @Override + public R userActivity(Integer type, Long streetId, Long areaCode, Integer range, String appId) { + UserActivityAnalysisVO vo = new UserActivityAnalysisVO(); + String activeX = com.panzhihua.common.utlis.DateUtils.getTwentyDay(); + List<Date> activeDate = getTwentyDays(); + List<String> activeY = new ArrayList<>(); + List<String> adY = new ArrayList<>(); + if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(range)) { + if (range.equals(1)) { + //本月数据 + activeX = com.panzhihua.common.utlis.DateUtils.getMonthTwentyDay(); + activeDate = getMonthTwentyDays(); + } + } + //获取最近活跃人数 + List<UsersStatisticsDTO> actives = userDao.getActive(activeX, streetId, areaCode, appId); + //获取最近注册人数 + List<UsersStatisticsDTO> dailyAdds = userDao.getDailyAdd(activeX, streetId, areaCode, appId); + Map<String, String> activeMap = actives.stream().collect(Collectors.toMap(UsersStatisticsDTO::getSpecificDate, UsersStatisticsDTO::getTotal)); + Map<String, String> dailyAddMap = dailyAdds.stream().collect(Collectors.toMap(UsersStatisticsDTO::getSpecificDate, UsersStatisticsDTO::getTotal)); + + + for (Date date : activeDate) { + String dateStr = DateUtil.format(date, "yyyy-MM-dd"); + activeY.add(activeMap.containsKey(dateStr) ? activeMap.get(dateStr) : "0"); + adY.add(dailyAddMap.containsKey(dateStr) ? dailyAddMap.get(dateStr) : "0"); + + } + vo.setUserX(getMAndD(activeDate)); + vo.setAddUserY(adY); + vo.setActiveUserY(activeY); + return R.ok(vo); + } + + @Override + public R uuPush(String washPhone, String phone, String washName, Integer orderStatus) { + if (StringUtils.isNotEmpty(phone)) { + SysUserDO sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getPhone, phone).eq(SysUserDO::getAppId, "wx118de8a734d269f0").orderByDesc(SysUserDO::getCreateAt).last("limit 1")); + if (sysUserDO != null && StringUtils.isNotEmpty(sysUserDO.getOpenid())) { + String status = ""; + String accessToken = ""; + WxXCXTempSend util = new WxXCXTempSend(); + try { + accessToken = util.getAccessToken("wx118de8a734d269f0"); + } catch (Exception e) { + e.printStackTrace(); + } + switch (orderStatus) { + case 3: + status = "已分配车美"; + WxUtil.sendUuWash3(sysUserDO.getOpenid(), accessToken, status, washName, washPhone, phone, "sU18zbyzxFldHAdOREaQCR5uq_uMvCKTmGtklO1xw-w"); + break; + case 4: + status = "开始服务"; + WxUtil.sendUuWash4(sysUserDO.getOpenid(), accessToken, status, washName, washPhone, phone, "Eft5ksvsnOQANy2uNOGY43CC3pb33eDGA_lgCEoxuiw"); + break; + case 6: + status = "订单完成"; + WxUtil.sendUuWash6(sysUserDO.getOpenid(), accessToken, status, washName, washPhone, phone, "k1aV97H3pDNNcNcDTeZBD9jQemNDADnRE801HhTXweI"); + break; + case 9: + status = "订单取消"; + WxUtil.sendUuWash(sysUserDO.getOpenid(), accessToken, status, washName, washPhone, phone, "9_2FhQPDxZoUqmAuIZ1L1zjjYXokdNvu7A0gzKfvruI"); + break; + } + } + } + return R.ok(); + } + + @Override + public R wsPush(String washPhone, String phone, String washName, Integer orderStatus) { + if (StringUtils.isNotEmpty(phone)) { + SysUserDO sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getPhone, phone).eq(SysUserDO::getAppId, "wx98d62711dfbd8425").orderByDesc(SysUserDO::getCreateAt).last("limit 1")); + if (sysUserDO != null && StringUtils.isNotEmpty(sysUserDO.getOpenid())) { + String status = ""; + String accessToken = ""; + WxXCXTempSend util = new WxXCXTempSend(); + try { + accessToken = util.getWsAccessToken(); + } catch (Exception e) { + e.printStackTrace(); + } + switch (orderStatus) { + case 3: + status = "已分配车美"; + WxUtil.sendWsWash3(sysUserDO.getOpenid(), accessToken, status, washName, washPhone, phone, "sNj6m-JBvW6rOokKGDX9X3-XH1AD0GY5_X0jA9JSLwc"); + break; + case 4: + status = "开始服务"; + WxUtil.sendWsWash4(sysUserDO.getOpenid(), accessToken, status, washName, washPhone, phone, "Eft5ksvsnOQANy2uNOGY43CC3pb33eDGA_lgCEoxuiw"); + break; + case 6: + status = "订单完成"; + WxUtil.sendWsWash6(sysUserDO.getOpenid(), accessToken, status, washName, washPhone, phone, "iPS8yrsGDqy76hiP8bIbxkosveoX1xTFhdusSiGp-XM"); + break; + case 9: + status = "订单取消"; + WxUtil.sendWsWash(sysUserDO.getOpenid(), accessToken, status, washName, washPhone, phone, "z_ysGXz9JWBc2rXuYZzVCXKJTyLf0w0WerrohuNoEng"); + break; + } + } + } + return R.ok(); + } + + @Override + public R getCommunityList(String name, Long id) { + //区级账号名 + String[] streetList = {"bingcaogangjiedao", "donghuajiedao", "nongnongpingjiedao", "dadukoujiedaojiedao", "guazipingjiedao", + "yinjiangzhen", "qingxiangpingjiedao", "yuquanjiedao", "hemenkoujiedao", "dabaodingjiedao", "taojiadujiedao", "gelipinzhen", "dahezhonglujiedao", + "jingjiangzhen", "renhezhen", "pingdizhen", "datianzhen", "tongdezhen", "futianzhen", "qianjinzhen", "panlianzhen", "binguzhen", "baimazhen", + "salianzhen", "puweizhen", "deshizhen", "wanqiuyizuxiang", "caochangzhen", "xinshanlisuzuxiang", "tongzilinzhen", "yongxingzhen", "yumenzhen", + "honggezhen", "hongguoyizuxiang"}; + List<Integer> ids = userDao.selectIdsByAccount(streetList); + //村或社区账号 + Integer type = isVilliage(name); + //是否为市级账号 + Boolean cityAccount = isCityAccount(name); + if (cityAccount) { + List<Integer> areaList = areaCodeList(); + List<AreaVOS> areaVOList = new ArrayList<>(); + for (Integer code : areaList) { + AreaVOS areaVO = new AreaVOS(); + areaVO.setId(code); + areaVO.setName(areaCodeToName(code.longValue())); + List<StreetVOS> streetVOS = userDao.selectStreetByAreaCode(code); + Iterator<StreetVOS> iterator = streetVOS.listIterator(); + while (iterator.hasNext()) { + StreetVOS vo = iterator.next(); + List<CommunityVO> communityVOS = userDao.selectCommunityByStreetId(vo.getId(), type); + vo.setChildList(communityVOS); + if (type != 3) { + if (communityVOS == null || communityVOS.size() == 0) { + iterator.remove(); + } + } + } + areaVO.setChildList(streetVOS); + areaVOList.add(areaVO); + } + return R.ok(areaVOList); + } else { + Boolean areaAccount = isAreaAccount(name); + if (areaAccount) { + Integer areaCode = accountToCode(name); + List<Integer> areaList = new ArrayList<>(); + areaList.add(areaCode); + List<AreaVOS> areaVOList = new ArrayList<>(); + for (Integer code : areaList) { + AreaVOS areaVO = new AreaVOS(); + areaVO.setId(code); + areaVO.setName(areaCodeToName(code.longValue())); + List<StreetVOS> streetVOS = userDao.selectStreetByAreaCode(code); + Iterator<StreetVOS> iterator = streetVOS.listIterator(); + while (iterator.hasNext()) { + StreetVOS vo = iterator.next(); + List<CommunityVO> communityVOS = userDao.selectCommunityByStreetId(vo.getId(), type); + vo.setChildList(communityVOS); + } + areaVO.setChildList(streetVOS); + areaVOList.add(areaVO); + } + return R.ok(areaVOList); + } else { + //非区县账号,只看街道下属社区 + if (ArrayUtil.contains(streetList, name)) { + List<StreetVOS> list = new ArrayList<>(); + //只看当前街道下属社区 + StreetVOS streetVOS = userDao.selectStreetByName(name); + List<CommunityVO> communityVOS = userDao.selectCommunityByStreetName(name); + if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(streetVOS)) { + streetVOS.setChildList(communityVOS); + } + list.add(streetVOS); + return R.ok(list); + } + } + } + return R.ok(null); + } + + @Override + public R resetPassword(Integer type, String account, String appId) { + SysUserDO sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getAccount, account).eq(SysUserDO::getType, type).eq(SysUserDO::getAppId, appId)); + if (sysUserDO != null) { + sysUserDO.setPassword("$2a$10$F/2lE2NMhKNHJfi5.FLmfu7jIr7ImRWgCTTeO6m3IRNR2V4sv8YR."); + userDao.updateById(sysUserDO); + } + return R.ok(); + } + + @Override + public R tfLogin(UuLoginVO uuLoginVO) { + SysUserDO sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getPhone, uuLoginVO.getMobile()).eq(SysUserDO::getType, 16)); + if (sysUserDO == null) { + sysUserDO = new SysUserDO(); + sysUserDO.setPassword("$2a$10$F/2lE2NMhKNHJfi5.FLmfu7jIr7ImRWgCTTeO6m3IRNR2V4sv8YR."); + sysUserDO.setType(16); + sysUserDO.setStatus(1); + sysUserDO.setPhone(uuLoginVO.getMobile()); + sysUserDO.setAccount(uuLoginVO.getMobile()); + sysUserDO.setAppId("wx0cef797390444b75"); + userDao.insert(sysUserDO); + } + return R.ok(); + } + + @Override + public R accept(Long userId) { + SysUserDO sysUserDO = new SysUserDO(); + sysUserDO.setUserId(userId); + sysUserDO.setIsAccept(1); + userDao.updateById(sysUserDO); + return R.ok(); + } + + @Override + @Transactional + public R addComPbCheckUser(ComPbCheckUserDTO comPbCheckUserDTO) { + SysUserDO sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getAccount, comPbCheckUserDTO.getAccount()).eq(SysUserDO::getType, 3).eq(SysUserDO::getAppId, "wx118de8a734d269f0")); + if (sysUserDO != null) { + return R.fail("账户名已存在"); + } + SysUserDO sysUserDO1 = new SysUserDO(); + sysUserDO1.setUserId(Snowflake.getId()); + sysUserDO1.setAccount(comPbCheckUserDTO.getAccount()); + sysUserDO1.setPassword(new BCryptPasswordEncoder().encode(comPbCheckUserDTO.getPassword())); + sysUserDO1.setType(3); + sysUserDO1.setAppId("wx118de8a734d269f0"); + sysUserDO1.setCommunityId(0L); + sysUserDO1.setBindingCheckUnitId(comPbCheckUserDTO.getCheckUnitId()); + int restlt = userDao.insert(sysUserDO1); + if (restlt > 0) { + SysUserRoleDO sysUserRoleDO = new SysUserRoleDO(); + sysUserRoleDO.setRoleId(123321L); + sysUserRoleDO.setUserId(sysUserDO1.getUserId()); + sysUserRoleDAO.insert(sysUserRoleDO); + } + return R.ok(); + } + + /** + * 三说会堂新增业务中心或专家账号 + * */ + @Override + public R addExpertOrIndustryCenter(AdministratorsUserVO administratorsUserVO) { + SysUserDO sysUserDO=new SysUserDO(); + //是否存在相同账号 + SysUserDO userDO = userDao.selectOne(new QueryWrapper<SysUserDO>().eq("account", administratorsUserVO.getAccount())); + if (isNull(userDO)){ + sysUserDO.setAppId("wx0cef797390444b75"); + sysUserDO.setCreateAt(new Date()); + sysUserDO.setUserId(administratorsUserVO.getUserId()); + sysUserDO.setAccount(administratorsUserVO.getAccount()); + sysUserDO.setPassword(new BCryptPasswordEncoder().encode(administratorsUserVO.getPassword())); + sysUserDO.setName(administratorsUserVO.getName()); + if (nonNull(administratorsUserVO.getImageUrl())){ + sysUserDO.setImageUrl(administratorsUserVO.getImageUrl()); + } + if (nonNull(administratorsUserVO.getType())){ + sysUserDO.setType(administratorsUserVO.getType()); + } + if (nonNull(administratorsUserVO.getPhone())){ + sysUserDO.setPhone(administratorsUserVO.getPhone()); + } + userDao.insert(sysUserDO); + //分配权限 + SysUserRoleDO sysUserRole=new SysUserRoleDO(); + sysUserRole.setUserId(sysUserDO.getUserId()); + if (sysUserDO.getType().equals(11)){ + sysUserRole.setRoleId(Long.parseLong(UserConstants.SANSHUO_EXPERT_ROLE)); + //将专家小程序账号设置为专家权限 + SysUserDO sysUserDO1 = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, 1).eq(SysUserDO::getPhone, administratorsUserVO.getPhone())); + if (nonNull(sysUserDO1)){ + sysUserDO1.setType(13); + userDao.updateById(sysUserDO1); + log.info("添加专家小程序账号权限"); + } + }else{ + sysUserRole.setRoleId(Long.parseLong(UserConstants.SANSHUO_INDUSTRY_CENTER_ROLE)); + } + //配置权限 + sysUserRoleDAO.insert(sysUserRole); + return R.ok(); + } + return R.fail("账户名已存在"); + } + + /** + * 三说会堂后台重置密码 + * */ + @Override + public R resetPassExpertOrIndustryCenter(String account,String password) { + SysUserDO sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().eq("account", account)); + if (nonNull(sysUserDO)){ + sysUserDO.setPassword(new BCryptPasswordEncoder().encode(password)); + userDao.updateById(sysUserDO); + return R.ok(); + } + return R.fail("修改失败"); + } + + /** + * 移除专家权限 + * */ + @Override + public R removeExpertRole(String phone) { + if (nonNull(phone)){ + //是否有权限为专家的账号 + SysUserDO sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, 11).eq(SysUserDO::getPhone, phone)); + if (nonNull(sysUserDO)){ + //删除后台账号 + sysUserDO.setStatus(2); + userDao.updateById(sysUserDO); + log.info("禁用专家后台账号成功"); + } + //小程序账号移除专家权限 + SysUserDO sysUserDO1 = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, 13).eq(SysUserDO::getPhone, phone)); + if (nonNull(sysUserDO1)){ + sysUserDO1.setType(1); + userDao.updateById(sysUserDO1); + log.info("移除专家权限成功"); + } + } + return R.ok(); + } + + + @Override + public R getAreaAndStreet() { + List<Integer> areaCodeList = areaCodeList(); + List<AreaVO> areaVOList = new ArrayList<>(); + for (Integer code : areaCodeList) { + AreaVO vo = new AreaVO(); + vo.setId(code); + vo.setName(areaCodeToName(code.longValue())); + vo.setStreetList(userDao.selectStreetsByAreaCode(code)); + areaVOList.add(vo); + } + return R.ok(areaVOList); + } + + + /** + * 获取最近20天数据 + * + * @return + */ + private List<Date> getTwentyDays() { + List<Date> dates = new ArrayList<>(); + Date date = new Date(); + for (int i = 19; i >= 0; i--) { + Date date1 = DateUtils.addDays(date, -i); dates.add(date1); } - System.out.println(dates); - -// BCryptPasswordEncoder encoder = new BCryptPasswordEncoder(); -// boolean matches = encoder.matches("admin1234567", encode); -// System.out.println(matches); + return dates; } + + /** + * 获取最近本月20天数据 + * + * @return + */ + private List<Date> getMonthTwentyDays() { + List<Date> dates = new ArrayList<>(); + Date date = new Date(); + Long offset = DateUtil.between(new Date(), DateUtil.beginOfMonth(date), DateUnit.DAY); + if (offset >= 20) { + for (int i = 19; i >= 0; i--) { + Date date1 = DateUtils.addDays(date, -i); + dates.add(date1); + } + } else { + //距离月初不足20天 + for (int i = offset.intValue(); i >= 0; i--) { + Date date1 = DateUtils.addDays(date, -i); + dates.add(date1); + } + } + return dates; + } + + + /** + * 计算占比 + */ + private Integer getRate(Integer total, Integer count) { + if (0 != total && null != total) { + if (0 != count && null != count) { + BigDecimal div = NumberUtil.div(count.toString(), total.toString(), 2); + BigDecimal mul = NumberUtil.mul(div, 100); + return mul.intValue(); + } + } + return null; + } + + /** + * 计算街道实名用户总数 + */ + private Integer getStreetRealUser(List<RealUser> list) { + Integer count = 0; + if (list.size() > 0) { + for (RealUser realUser : list) { + if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(realUser)) { + if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(realUser.getCount())) { + count += realUser.getCount(); + } + } + } + + } + return count; + } + + /** + * 计算当前统计范围内的所有用户数 + */ + public Integer countUser(List<UserRateAnalysisVO> list) { + Integer count = 0; + if (list.size() > 0) { + for (UserRateAnalysisVO proportion : list) { + if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(proportion)) { + if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(proportion.getCount())) { + count += proportion.getCount(); + } + } + } + } + return count; + } + + /** + * 截取月,日 + */ + public List<String> getMAndD(List<Date> list) { + List<String> dateList = new ArrayList<>(); + if (list.size() > 0) { + for (Date date : list) { + dateList.add(DateFormatUtils.format(date, "MM-dd")); + } + } + return dateList; + } + + + /** + * areaCode转区县名 + */ + private String areaCodeToName(Long areaCode) { + String code = areaCode.toString(); + String name = "不正确的areaCode"; + switch (code) { + case "510423": + name = "西区"; + break; + case "510402": + name = "东区"; + break; + case "510411": + name = "仁和区"; + break; + case "510421": + name = "米易县"; + break; + case "510422": + name = "盐边县"; + break; + case "510424": + name = "钒钛新区"; + break; + } + return name; + } + + /** + * 根据type选择要设置的名称 + */ + private String typeToName(Integer type, UserProportion proportion) { + log.info("当前code" + proportion.getAreaCode()); + String name = ""; + if (type.equals(ALLCOUNTY)) { + name = areaCodeToName(proportion.getAreaCode()); + } else if (type.equals(ALLSTREET) || type.equals(BYAREA)) { + name = proportion.getStreetName(); + } else if (type.equals(ALLCOMMUNITY) || type.equals(BYSTREET)) { + name = proportion.getCommunityName(); + } + return name; + } + + /** + * 根据type选择要设置的名称 + */ + private String typeToNameRealUser(Integer type, RealUser proportion) { + String name = ""; + if (type.equals(ALLCOUNTY)) { + name = areaCodeToName(Long.parseLong(proportion.getAreaCode())); + } else if (type.equals(ALLSTREET) || type.equals(BYAREA)) { + name = proportion.getStreetName(); + } else if (type.equals(ALLCOMMUNITY) || type.equals(BYSTREET)) { + name = proportion.getCommunityName(); + } + return name; + } + + /** + * 生成区县code列表 + */ + private List<Integer> areaCodeList() { + List<Integer> list = new ArrayList<>(); + list.add(510402); + list.add(510423); + list.add(510411); + list.add(510421); + list.add(510422); + list.add(510424); + return list; + } + + /** + * 根据日志保存修改之前的信息 + */ + private String saveBeforeUpdateData(SysOperLogVO operlog) throws JsonProcessingException { + if (operlog.getTitle().equals(UPDATEACIDCHECKRECORD)) { + // + ComActAcidCheckRecordVO comActAcidCheckRecordVO = objectMapper.readValue(operlog.getOperParam(), ComActAcidCheckRecordVO.class); + ComActAcidCheckRecordVO comActAcidCheckRecordVO1 = userDao.selectComActAcidCheckRecordById(comActAcidCheckRecordVO.getId()); + return JSONObject.toJSONString(comActAcidCheckRecordVO1); + } else if (operlog.getTitle().equals(UPDATEACIDRECORD)) { + ComActAcidRecordVO comActAcidRecordVO = objectMapper.readValue(operlog.getOperParam(), ComActAcidRecordVO.class); + return JSONObject.toJSONString(userDao.selectComActAcidRecord(comActAcidRecordVO.getId())); + } else if (operlog.getTitle().equals(UPDATEACIDMEMBER)) { + ComActAcidMemberVO comActAcidMemberVO = objectMapper.readValue(operlog.getOperParam(), ComActAcidMemberVO.class); + return JSONObject.toJSONString(userDao.selectComActAcidMember(comActAcidMemberVO.getId())); + } + return null; + } + + /** + * 是否需要区分村落/社区 + */ + private Integer isVilliage(String name) { + if ("fangyipingtai".equals(name)) { + return 3; + } else if ("pandashujuzhongxin".equals(name)) { + return 1; + } else if ("pannongyenongcunju".equals(name)) { + return 2; + } + return 3; + } + + /** + * 是否为市级账号 + */ + private Boolean isCityAccount(String name) { + if (("fangyipingtai").equals(name) || ("pandashujuzhongxin").equals(name) || ("pannongyenongcunju").equals(name)) { + return true; + } + return false; + } + + /** + * 是否为区级账号 + */ + private Boolean isAreaAccount(String name) { + Boolean flag = false; + switch (name) { + case "dongqu": + case "xiqu": + case "renhequ": + case "miyixian": + case "yanbianxian": + flag = true; + break; + } + return flag; + } + + /** + * account转区areaCode + */ + private Integer accountToCode(String code) { + String name = "100000"; + switch (code) { + case "xiqu": + name = "510423"; + break; + case "dongqu": + name = "510402"; + break; + case "renhequ": + name = "510411"; + break; + case "miyixian": + name = "510421"; + break; + case "yanbianxian": + name = "510422"; + break; + case "fantaixinqu": + name = "510424"; + break; + } + return Integer.parseInt(name); + } + } -- Gitblit v1.7.1