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 | 2276 +++++++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 1,870 insertions(+), 406 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 62ee081..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 @@ -2,23 +2,41 @@ import static java.util.Objects.isNull; import static java.util.Objects.nonNull; +import static org.apache.commons.lang3.StringUtils.isNotBlank; -import java.util.ArrayList; -import java.util.Date; -import java.util.HashMap; -import java.util.HashSet; -import java.util.List; -import java.util.Map; -import java.util.Set; +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.util.IdcardUtil; -import com.panzhihua.common.model.dtos.DataKanBansDto; -import com.panzhihua.common.model.vos.community.*; +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.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.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; @@ -37,11 +55,13 @@ 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; @@ -59,35 +79,35 @@ 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.common.model.vos.user.AdministratorsUserVO; -import com.panzhihua.common.model.vos.user.ChangePasswordVO; -import com.panzhihua.common.model.vos.user.ComMngFamilyInfoVO; -import com.panzhihua.common.model.vos.user.ComMngUserTagVO; -import com.panzhihua.common.model.vos.user.CommunityUserInfoVO; -import com.panzhihua.common.model.vos.user.MenuRoleVO; -import com.panzhihua.common.model.vos.user.NoticeUnReadVO; -import com.panzhihua.common.model.vos.user.SysOperLogVO; -import com.panzhihua.common.model.vos.user.SysUserAgreementVO; -import com.panzhihua.common.model.vos.user.SysUserFeedbackVO; -import com.panzhihua.common.model.vos.user.SysUserNoticeVO; -import com.panzhihua.common.model.vos.user.SysUserVO; -import com.panzhihua.common.model.vos.user.UpdateUserArchivesVO; -import com.panzhihua.common.model.vos.user.UserArchivesVO; -import com.panzhihua.common.model.vos.user.UserPhoneVO; -import com.panzhihua.common.utlis.IdCard; -import com.panzhihua.common.utlis.SensitiveUtil; -import com.panzhihua.common.utlis.Snowflake; -import com.panzhihua.common.utlis.StringUtils; -import com.panzhihua.common.utlis.WxUtil; -import com.panzhihua.common.utlis.WxXCXTempSend; +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; @@ -101,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 @@ -135,6 +158,22 @@ 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; @@ -142,13 +181,17 @@ // String encode = new BCryptPasswordEncoder().encode("lbsq123456"); // System.out.println(encode); - List<Date> dates = new ArrayList<>(); +// 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(); - for (int i = 6; i >= 0; i--) { - Date date1 = DateUtils.addDays(date, -i); - dates.add(date1); - } - System.out.println(dates); + 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); @@ -158,18 +201,15 @@ /** * 小程序微信用户信息更新 * - * @param openid - * 小程序唯一ID - * @param sessionKey - * 会话密钥 - * @param unionid - * 用户在开放平台的唯一标识符 + * @param openid 小程序唯一ID + * @param sessionKey 会话密钥 + * @param unionid 用户在开放平台的唯一标识符 * @return token */ @Override - public R updateInsertUser(String openid, String sessionKey, String unionid) { + public R updateInsertUser(String openid, String sessionKey, String unionid, String appId) { SysUserDO sysUserDO = - userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getOpenid, openid)); + userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getOpenid, openid)); boolean empty = ObjectUtils.isEmpty(sysUserDO); int num = 0; Date date = new Date(); @@ -183,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); @@ -191,6 +236,7 @@ sysUserDO.setPassword(encode); sysUserDO.setLastLoginTime(date); sysUserDO.setType(1); + sysUserDO.setAppId(appId); num = userDao.updateById(sysUserDO); } if (num > 0) { @@ -203,14 +249,10 @@ /** * 维护小程序用户基本信息 头像 昵称 性别 * - * @param userId - * 数据库用户ID - * @param nickName - * 昵称 - * @param gender - * 性别 - * @param avatarUrl - * 头像 + * @param userId 数据库用户ID + * @param nickName 昵称 + * @param gender 性别 + * @param avatarUrl 头像 * @return 维护结果 */ @Override @@ -231,46 +273,57 @@ /** * 维护微信用户手机号 * - * @param userId - * 数据库ID - * @param purePhoneNumber - * 没有区号的手机号 + * @param userId 数据库ID + * @param purePhoneNumber 没有区号的手机号 * @return 维护结果 */ @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(purePhoneNumber); - } 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()); } /** * 认证中心获取平台用户信息 * - * @param name - * 登录账户 - * @param type - * 用户类型 用户类型 1 小程序 2 运营平台 3 社区平台 + * @param name 登录账户 + * @param type 用户类型 用户类型 1 小程序 2 运营平台 3 社区平台 * @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 { + 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); @@ -278,6 +331,9 @@ return R.fail(); } LoginUserInfoVO loginUserInfoVO = new LoginUserInfoVO(); + if (nonNull(sysUserDO.getStreetId())){ + loginUserInfoVO.setStreetId(sysUserDO.getStreetId()); + } loginUserInfoVO.setUserId(sysUserDO.getUserId()); loginUserInfoVO.setName(sysUserDO.getName()); loginUserInfoVO.setPassword(sysUserDO.getPassword()); @@ -286,7 +342,20 @@ loginUserInfoVO.setType(sysUserDO.getType()); 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<>(); @@ -295,14 +364,20 @@ 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); } /** * 三端获取用户信息 * - * @param userId - * 用户ID + * @param userId 用户ID * @return 用户基本信息、角色 */ @Override @@ -325,6 +400,10 @@ 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(); @@ -332,6 +411,13 @@ 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)) { @@ -347,6 +433,44 @@ 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); @@ -359,10 +483,65 @@ } 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; + } + /** * 修改用户登录密码 @@ -411,7 +590,7 @@ 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); + .eq(SysUserDO::getStatus, 1).eq(SysUserDO::getType, 3); if (!ObjectUtils.isEmpty(param)) { queryWrapper = queryWrapper.eq(SysUserDO::getName, param); } @@ -468,8 +647,7 @@ /** * 编辑人脸采集数据通过、驳回、删除 * - * @param loginUserInfoVO - * 操作信息 + * @param loginUserInfoVO 操作信息 * @return 操作结果 */ @Override @@ -506,14 +684,13 @@ /** * 分页查询人口管理 * - * @param userInfoVO - * 查询参数 + * @param userInfoVO 查询参数 * @return 分页数据 */ @Override public R pageUser(AppletUserInfoVO userInfoVO) { IPage<AppletUserInfoVO> iPage = - userDao.pageUser(new Page<>(userInfoVO.getPageNum(), userInfoVO.getPageSize()), userInfoVO); + 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())); @@ -522,7 +699,7 @@ StringBuffer sb = new StringBuffer(); sb.append(record.getTags() + ","); if (record.getIsPartymember().equals(1)) { - if (!sb.toString().contains("党员")){ + if (!sb.toString().contains("党员")) { sb.append("党员,"); } } @@ -533,7 +710,7 @@ } String tags = sb.toString(); record.setTags(tags.substring(0, tags.length() - 1)); - }else { + } else { StringBuffer sb = new StringBuffer(); if (record.getIsPartymember().equals(1)) { sb.append("党员,"); @@ -561,10 +738,10 @@ public R listTag() { List<String> list = new ArrayList<>(); List<ComMngUserTagDO> comMngUserTagDOS = comMngUserTagDAO.selectList(new LambdaQueryWrapper<ComMngUserTagDO>() - .eq(ComMngUserTagDO::getSysFlag,1)); + .eq(ComMngUserTagDO::getSysFlag, 1)); if (!ObjectUtils.isEmpty(comMngUserTagDOS)) { list = comMngUserTagDOS.stream().map(comMngUserTagDO -> comMngUserTagDO.getTagName()) - .collect(Collectors.toList()); + .collect(Collectors.toList()); } return R.ok(list); } @@ -572,81 +749,96 @@ /** * 人员详情 detailuser * - * @param userId - * 用户id + * @param userId 用户id * @return 人员详情 */ @Override - public R detailUser(Long userId) { + public R<LoginUserInfoVO> 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 + 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(SensitiveUtil.desensitizedIdNumber(sysUserInputDO1.getIdCard())); - comMngFamilyInfoVO.setName(name); - comMngFamilyInfoVO.setPhone(SensitiveUtil.desensitizedPhoneNumber(sysUserInputDO1.getPhone())); - if (isRent.intValue() == 0) { - comMngFamilyInfoVO.setRelationship("家人"); - } else { - comMngFamilyInfoVO.setRelationship("合租"); - } - comMngFamilyInfoVO.setAge(IdCard.IdNOToAge(sysUserInputDO1.getIdCard())); - comMngFamilyInfoVOS.add(comMngFamilyInfoVO); - }); - loginUserInfoVO.setComMngFamilyInfoVOS(comMngFamilyInfoVOS); - } - + 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); } /** * 设置用户标签 * - * @param loginUserInfoVO - * 标签信息 + * @param loginUserInfoVO 标签信息 * @return 设置结果 */ @Override @@ -666,8 +858,7 @@ /** * 修改用户志愿者状态 * - * @param phone - * 志愿者手机号 + * @param phone 志愿者手机号 * @param type */ @Override @@ -686,7 +877,7 @@ stringRedisTemplate.delete(userKey); } else { List<SysUserDO> userDOList = - userDao.selectList(new LambdaQueryWrapper<SysUserDO>().eq(SysUserDO::getPhone, phone)); + userDao.selectList(new LambdaQueryWrapper<SysUserDO>().eq(SysUserDO::getPhone, phone)); if (userDOList != null && userDOList.size() > 0) { userDOList.forEach(usrDo -> { Long userId = usrDo.getUserId(); @@ -704,8 +895,7 @@ /** * 修改用户志愿者状态 * - * @param userId - * 志愿者用户ID + * @param userId 志愿者用户ID * @param type */ @Override @@ -737,8 +927,7 @@ /** * 用户绑定社区、小区 * - * @param loginUserInfoVO - * 社区小区数据 + * @param loginUserInfoVO 社区小区数据 * @return 绑定结果 */ @Override @@ -761,8 +950,7 @@ /** * 用户实名认证 * - * @param loginUserInfoVO - * 认证数据 + * @param loginUserInfoVO 认证数据 * @return 认证结果 */ @Override @@ -795,7 +983,7 @@ } sysUserDO.setFaceState(null); SysUserDO sysUserDO1 = - userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getIdCard, idCard)); + userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getIdCard, idCard).eq(SysUserDO::getCommunityId, loginUserInfoVO.getCommunityId())); if (!ObjectUtils.isEmpty(sysUserDO1)) { return R.fail("身份证已经存在"); } @@ -813,19 +1001,20 @@ userDao.updateComPbMemberUserId(idCard, sysUserDO.getUserId()); } - SysUserDO user = userDao.selectById(loginUserInfoVO.getUserId()); + /*SysUserDO user = userDao.selectById(loginUserInfoVO.getUserId()); if (user != null) { // 实名认证成功推送订阅消息给用户 try { WxXCXTempSend util = new WxXCXTempSend(); - String accessToken = util.getAppAccessToken(); + 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(), "认证成功"); + com.panzhihua.common.utlis.DateUtils.getCurrentDateStr(), "认证成功", sysTemplateConfig.getTemplateId()); } catch (Exception e) { log.error("推送用户订阅消息失败,失败原因:" + e.getMessage()); } - } + }*/ return R.ok(); } return R.fail(); @@ -834,8 +1023,7 @@ /** * 修改用户手机号 * - * @param userPhoneVO - * 手机号信息 + * @param userPhoneVO 手机号信息 * @return 修改结果 */ @Override @@ -879,8 +1067,7 @@ /** * 修改用户信息 * - * @param loginUserInfoVO - * 修改内容 + * @param loginUserInfoVO 修改内容 * @return 修改结果 */ @Override @@ -933,15 +1120,14 @@ /** * 家庭成员列表 * - * @param userId - * 登录用户 + * @param userId 登录用户 * @return 成员集合 */ @Override 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); + .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 -> { @@ -956,8 +1142,7 @@ /** * 新增家庭成员 * - * @param comMngFamilyInfoVO - * 家庭成员基本信息 + * @param comMngFamilyInfoVO 家庭成员基本信息 * @return 增加结果 */ @Override @@ -965,8 +1150,8 @@ 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())); + .lambda().eq(ComMngFamilyInfoDO::getIdCard, comMngFamilyInfoVO.getIdCard()) + .eq(ComMngFamilyInfoDO::getUserId, comMngFamilyInfoVO.getUserId())); if (!ObjectUtils.isEmpty(comMngFamilyInfoDO1)) { return R.fail("家庭成员已经存在"); } @@ -981,8 +1166,7 @@ /** * 编辑家庭成员 * - * @param comMngFamilyInfoVO - * 家庭成员信息 + * @param comMngFamilyInfoVO 家庭成员信息 * @return 编辑结果 */ @Override @@ -1000,13 +1184,27 @@ /** * 新增运营、社区后台账户 * - * @param administratorsUserVO - * 账户信息 + * @param administratorsUserVO 账户信息 * @return 新增结果 */ @Override @Transactional(rollbackFor = Exception.class) public R addUserBackstage(AdministratorsUserVO administratorsUserVO) { + 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(); if (roleId.intValue() == 999999999 || roleId.intValue() == 888888888) { @@ -1027,13 +1225,132 @@ int insert = roleDAO.insert(sysRoleDO); if (insert > 0) { SysRoleDO sysRoleDO1 = roleDAO.selectOne( - new QueryWrapper<SysRoleDO>().lambda().eq(SysRoleDO::getRoleKey, sysRoleDO.getRoleKey())); + 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); + } + } + 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); + sysUserDO.setAppId(administratorsUserVO.getAppid()); + 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(); + } + + @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); } } @@ -1054,73 +1371,8 @@ throw new ServiceException("手机号已经存在"); } else if (e.getMessage().contains("union_account_type")) { throw new ServiceException("账户已经存在"); - }else if(e.getMessage().contains("23000")){ + } else if (e.getMessage().contains("23000")) { throw new ServiceException("手机号已存在"); - } - - } - - if (insert > 0 && sysUserDO.getType() == 3) {// 添加的用户是社区账号时 - // 添加网格综合治理管理后台用户 - SysUserDO sysUserDOWangGe = new SysUserDO(); - BeanUtils.copyProperties(sysUserDO, sysUserDOWangGe); - sysUserDOWangGe.setUserId(null); - sysUserDOWangGe.setType(7);// 网格综治后台 - try { - int addWange = userDao.insert(sysUserDOWangGe); - if (addWange != 1) { - throw new ServiceException("新增网格综合治理管理后台用户失败"); - } - } 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(); - } - - @Override - public R addUserBackstageProperty(AdministratorsUserVO administratorsUserVO) { - SysUserDO sysUserDO = new SysUserDO(); - Long roleId = administratorsUserVO.getRoleId(); - 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("账户已经存在"); } } @@ -1143,8 +1395,7 @@ /** * 设置角色的权限 * - * @param menuRoleVO - * 用户设置的权限id + * @param menuRoleVO 用户设置的权限id * @return 设置结果 */ @Transactional(rollbackFor = Exception.class) @@ -1188,7 +1439,7 @@ // 获取所有权限id List<SysMenuDO> menuDOList = sysMenuDAO.selectList(new QueryWrapper<SysMenuDO>().lambda() - .eq(SysMenuDO::getCommunityId, 2L).orderByAsc(SysMenuDO::getOrderNum)); + .eq(SysMenuDO::getCommunityId, 2L).eq(SysMenuDO::getVisible, 0).orderByAsc(SysMenuDO::getOrderNum)); if (!menuDOList.isEmpty()) { menuIds = menuDOList.stream().map(sysMenuDO -> sysMenuDO.getMenuId()).collect(Collectors.toList()); @@ -1198,7 +1449,11 @@ .anyMatch(sysRoleMenuDO -> sysRoleMenuDO.getMenuId().equals(menuId))).collect(Collectors.toList()); } if (!menuIds.isEmpty()) { - sysRoleMenuDAO.batchInsertWithRoleId(menuIds, roleId); + 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() @@ -1217,8 +1472,7 @@ /** * 编辑运营、社区后台账户 * - * @param administratorsUserVO - * 编辑账户内容 + * @param administratorsUserVO 编辑账户内容 * @return 编辑结果 */ @Override @@ -1252,7 +1506,7 @@ SysUserRoleDO sysUserRoleDO = new SysUserRoleDO(); sysUserRoleDO.setRoleId(roleDO.getRoleId()); int update1 = sysUserRoleDAO.update(sysUserRoleDO, new UpdateWrapper<SysUserRoleDO>().lambda() - .eq(SysUserRoleDO::getUserId, administratorsUserVO.getUserId())); + .eq(SysUserRoleDO::getUserId, administratorsUserVO.getUserId())); if (update1 > 0) { return R.ok(); } else { @@ -1266,12 +1520,10 @@ /** * 删除后台用户 * - * @param administratorsUserVO - * 用户主键 + * @param administratorsUserVO 用户主键 * @return 删除结果 */ @Override - @Transactional(rollbackFor = Exception.class) public R deleteUserBackstage(AdministratorsUserVO administratorsUserVO) { Long userId = administratorsUserVO.getUserId(); SysUserDO sysUserDO = userDao.selectById(userId); @@ -1280,7 +1532,7 @@ } Long communityId = sysUserDO.getCommunityId(); Long communityId1 = administratorsUserVO.getCommunityId(); - if (communityId1.intValue() != communityId.intValue()) { + if (communityId1 != null && communityId1.intValue() != communityId.intValue()) { return R.fail("用户不属于当前平台"); } // 删除用户 @@ -1288,7 +1540,7 @@ // 删除用户角色关系 if (delete > 0) { int delete1 = - sysUserRoleDAO.delete(new QueryWrapper<SysUserRoleDO>().lambda().eq(SysUserRoleDO::getUserId, userId)); + sysUserRoleDAO.delete(new QueryWrapper<SysUserRoleDO>().lambda().eq(SysUserRoleDO::getUserId, userId)); if (delete1 == 0) { return R.fail("用户没有角色关系"); } @@ -1299,8 +1551,7 @@ /** * 分页查询后台用户 * - * @param administratorsUserVO - * 查询参数 + * @param administratorsUserVO 查询参数 * @return 后台用户 */ @Override @@ -1323,12 +1574,22 @@ /** * 保存操作日志 * - * @param operlog - * 日志内容 + * @param operlog 日志内容 * @return 保存结果 */ @Override public R addOperLog(SysOperLogVO operlog) { + //判断是否需要保存修改前的数据 + 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); @@ -1341,8 +1602,7 @@ /** * 分页展示操作日志 * - * @param sysOperLogVO - * 分页参数 + * @param sysOperLogVO 分页参数 * @return 分页集合 */ @Override @@ -1358,6 +1618,11 @@ } 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); } @@ -1370,7 +1635,7 @@ @Override public R listAgreement(Long communityId) { List<SysUserAgreementDO> sysUserAgreementDOS = sysUserAgreementDAO.selectList( - new LambdaQueryWrapper<SysUserAgreementDO>().eq(SysUserAgreementDO::getCommunityId, communityId)); + new LambdaQueryWrapper<SysUserAgreementDO>().eq(SysUserAgreementDO::getCommunityId, communityId)); if (ObjectUtils.isEmpty(sysUserAgreementDOS)) { return R.fail(); } @@ -1386,8 +1651,7 @@ /** * 编辑用户协议 * - * @param sysUserAgreementVO - * 编辑内容 + * @param sysUserAgreementVO 编辑内容 * @return 编辑结果 */ @Override @@ -1404,14 +1668,13 @@ /** * 用户标签 * - * @param communityId - * 社区id + * @param communityId 社区id * @return 标签集合 */ @Override public R listComMngUserTag(Long communityId) { List<ComMngUserTagDO> comMngUserTagDOS = comMngUserTagDAO.selectList(new QueryWrapper<ComMngUserTagDO>().or() - .lambda().eq(ComMngUserTagDO::getSysFlag, 1).or().eq(ComMngUserTagDO::getCommunityId, communityId)); + .lambda().eq(ComMngUserTagDO::getSysFlag, 1).or().eq(ComMngUserTagDO::getCommunityId, communityId)); if (ObjectUtils.isEmpty(comMngUserTagDOS)) { return R.fail(); } @@ -1427,8 +1690,7 @@ /** * 新增删除用户标签 * - * @param systemmanagementConfigVO - * 操作内容 + * @param systemmanagementConfigVO 操作内容 * @return 操作结果 */ @Override @@ -1437,7 +1699,7 @@ Long communityId = systemmanagementConfigVO.getCommunityId(); List<ComMngUserTagVO> comMngUserTagVOList = systemmanagementConfigVO.getComMngUserTagVOList(); if (!ObjectUtils.isEmpty(comMngUserTagVOList)) { - comMngUserTagDAO.delete(new QueryWrapper<ComMngUserTagDO>().lambda().eq(ComMngUserTagDO::getCommunityId,communityId)); + comMngUserTagDAO.delete(new QueryWrapper<ComMngUserTagDO>().lambda().eq(ComMngUserTagDO::getCommunityId, communityId)); comMngUserTagVOList.forEach(comMngUserTagVO -> { ComMngUserTagDO comMngUserTagDO = new ComMngUserTagDO(); comMngUserTagDO.setCommunityId(communityId); @@ -1454,8 +1716,7 @@ /** * 分页查询小程序用户 * - * @param pageUserAppletsBackstageDTO - * 查询参数 + * @param pageUserAppletsBackstageDTO 查询参数 * @return 分页集合 */ @Override @@ -1472,8 +1733,7 @@ /** * 编辑用户状态 * - * @param pageUserAppletsBackstageDTO - * 启用或者禁用 1 启用 2 禁用 + * @param pageUserAppletsBackstageDTO 启用或者禁用 1 启用 2 禁用 * @return 编辑结果 */ @Override @@ -1493,8 +1753,7 @@ /** * 调试接口--清除昵称、社区、小区 * - * @param userId - * 登录用户id + * @param userId 登录用户id * @return 清除结果 */ @Override @@ -1509,22 +1768,20 @@ /** * 用户协议和隐私政策 * - * @param type - * 所属app 1居民端app 2网格员端app 3商家端app + * @param type 所属app 1居民端app 2网格员端app 3商家端app * @return 协议内容 */ @Override - public R userAgreement(int type) { + public R userAgreement(int type, String appId) { SysUserAgreementDO sysUserAgreementDO = sysUserAgreementDAO - .selectOne(new QueryWrapper<SysUserAgreementDO>().lambda().eq(SysUserAgreementDO::getType, type)); + .selectOne(new QueryWrapper<SysUserAgreementDO>().lambda().eq(SysUserAgreementDO::getType, type).eq(SysUserAgreementDO::getAppId, appId)); return R.ok(sysUserAgreementDO); } /** * 意见反馈 * - * @param sysUserFeedbackDTO - * 反馈内容 + * @param sysUserFeedbackDTO 反馈内容 * @return 反馈结果 */ @Override @@ -1542,8 +1799,7 @@ /** * 分页通知列表 * - * @param pageDTO - * 分页参数 + * @param pageDTO 分页参数 * @return 分页结果 */ @Override @@ -1553,11 +1809,11 @@ 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)); + .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)); + .eq(SysUserNoticeDO::getUserId, userId).eq(SysUserNoticeDO::getStatus, 0)); } Page page = new Page<>(); Long pageNum = pageDTO.getPageNum(); @@ -1574,8 +1830,7 @@ /** * 通知已读 * - * @param noticeReadDTO - * 通知已读 + * @param noticeReadDTO 通知已读 * @return 修改状态 */ @Override @@ -1587,7 +1842,7 @@ 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)); + .eq(SysUserNoticeDO::getUserId, userId).eq(SysUserNoticeDO::getStatus, 0)); } else { sysUserNoticeDO.setId(noticeReadDTO.getId()); sysUserNoticeDO.setStatus(1); @@ -1602,8 +1857,7 @@ /** * 分页查询用户意见反馈 * - * @param pageFeedBackDTO - * 分页查询参数 + * @param pageFeedBackDTO 分页查询参数 * @return 意见集合 */ @Override @@ -1620,8 +1874,7 @@ /** * 未读消息汇总 * - * @param userId - * 登录用户信息 + * @param userId 登录用户信息 * @return 未读汇总 */ @Override @@ -1629,7 +1882,7 @@ 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)); + .lambda().eq(SysUserNoticeDO::getUserId, userId).orderByDesc(SysUserNoticeDO::getCreateAt)); if (!ObjectUtils.isEmpty(sysUserNoticeDOS)) { List<Integer> typeList = new ArrayList<>(4); sysUserNoticeDOS.forEach(sysUserNoticeDO -> { @@ -1649,8 +1902,7 @@ /** * 反馈意见详情 * - * @param id - * 反馈主键 + * @param id 反馈主键 * @return 反馈详情 */ @Override @@ -1665,9 +1917,9 @@ * @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<>(); @@ -1712,8 +1964,7 @@ /** * 社区管理后台数据看板 * - * @param communityId - * 社区id + * @param communityId 社区id * @return 看板用户数据 */ @Override @@ -1740,8 +1991,7 @@ /** * 新增用户通知 * - * @param sysUserNoticeVO - * 通知内容 + * @param sysUserNoticeVO 通知内容 * @return 新增结果 */ @Override @@ -1758,14 +2008,13 @@ /** * 修改用户的党员状态 * - * @param idCard - * 身份证号 + * @param idCard 身份证号 * @return 修改结果 */ @Override public R updateUserIsPartymember(String idCard) { SysUserDO sysUserDO = userDao.selectOne( - new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getIdCard, idCard).eq(SysUserDO::getType, 1)); + new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getIdCard, idCard).eq(SysUserDO::getType, 1)); if (sysUserDO != null) { sysUserDO.setIsPartymember(1); int updated = userDao.updateById(sysUserDO); @@ -1782,14 +2031,36 @@ /** * 修改用户的党员状态 * - * @param idCard - * 身份证号 + * @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)); + new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getIdCard, idCard).eq(SysUserDO::getType, 1)); if (sysUserDO != null) { sysUserDO.setIsPartymember(0); int updated = userDao.updateById(sysUserDO); @@ -1806,14 +2077,13 @@ /** * 获取各种协议 * - * @param type - * 1居民端app协议 2网格员端app协议 3商家端app协议 4隐私政策 + * @param type 1居民端app协议 2网格员端app协议 3商家端app协议 4隐私政策 * @return 协议内容 */ @Override - public R agreement(Integer type) { + public R agreement(Integer type, String appId) { SysUserAgreementDO sysUserAgreementDO = sysUserAgreementDAO - .selectOne(new QueryWrapper<SysUserAgreementDO>().lambda().eq(SysUserAgreementDO::getType, type)); + .selectOne(new QueryWrapper<SysUserAgreementDO>().lambda().eq(SysUserAgreementDO::getType, type).eq(SysUserAgreementDO::getAppId, appId)); if (ObjectUtils.isEmpty(sysUserAgreementDO)) { return R.fail("协议不存在"); } @@ -1825,8 +2095,7 @@ /** * 维护用户最后登录时间 * - * @param userId - * 用户主键 + * @param userId 用户主键 * @return 维护结果 */ @Override @@ -1844,8 +2113,7 @@ /** * 删除意见反馈 * - * @param id - * 主键 + * @param id 主键 * @return 删除结果 */ @Override @@ -1860,8 +2128,7 @@ /** * 校验小区是否存在 * - * @param areaName - * 小区名字 + * @param areaName 小区名字 * @return 校验结果 */ @Override @@ -1882,8 +2149,7 @@ /** * 社区人员详情包括导入人员 * - * @param userId - * 人员id + * @param userId 人员id * @return CommunityUserInfoVO */ @Override @@ -1919,7 +2185,7 @@ } communityUserInfoVO.setIsVolunteer(sysUserDO.getIsVolunteer()); List<ComMngFamilyInfoDO> comMngFamilyInfoDOS = comMngFamilyInfoDAO - .selectList(new QueryWrapper<ComMngFamilyInfoDO>().lambda().eq(ComMngFamilyInfoDO::getUserId, userId)); + .selectList(new QueryWrapper<ComMngFamilyInfoDO>().lambda().eq(ComMngFamilyInfoDO::getUserId, userId)); if (!ObjectUtils.isEmpty(comMngFamilyInfoDOS)) { List<ComMngFamilyInfoVO> comMngFamilyInfoVOS = new ArrayList<>(); comMngFamilyInfoDOS.forEach(comMngFamilyInfoDO -> { @@ -1936,8 +2202,7 @@ /** * 用户搜索了就下载搜索的用户否则下载所有用户 * - * @param exportUserDTO - * 用户搜索内容 + * @param exportUserDTO 用户搜索内容 * @return List<EexcelUserDTO> excel内容 */ @Override @@ -1949,9 +2214,9 @@ @Override public R getSysUserVOByPhone(String phone) { SysUserDO sysUserDO = userDao - .selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getPhone, phone).eq(SysUserDO::getType, 1)); + .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("用户不存在"); + return R.fail("账号或密码错误"); } SysUserVO sysUserVO = new SysUserVO(); BeanUtils.copyProperties(sysUserDO, sysUserVO); @@ -1967,7 +2232,7 @@ public R listTags() { List<String> list = new ArrayList<>(); List<ComMngUserTagDO> comMngUserTagDOS = comMngUserTagDAO - .selectList(null); + .selectList(null); if (!ObjectUtils.isEmpty(comMngUserTagDOS)) { for (ComMngUserTagDO comMngUserTagDO : comMngUserTagDOS) { if (!list.contains(comMngUserTagDO.getTagName())) { @@ -1986,7 +2251,7 @@ query.eq(SysUserDO::getType, type); SysUserDO sysUserDO = userDao.selectOne(query); if (ObjectUtils.isEmpty(sysUserDO)) { - return R.fail("用户不存在"); + return R.fail("账号或密码错误"); } SysUserVO sysUserVO = new SysUserVO(); BeanUtils.copyProperties(sysUserDO, sysUserVO); @@ -1996,8 +2261,7 @@ /** * 新增SysUser * - * @param storeVO - * 请求参数 + * @param storeVO 请求参数 * @return 新增结果 */ @Override @@ -2033,8 +2297,13 @@ 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()); @@ -2056,14 +2325,13 @@ /** * 修改SysUser用户信息 * - * @param storeVO - * 请求参数 + * @param storeVO 请求参数 * @return 修改结果 */ @Override public R editSysUser(ShopStoreVO storeVO) { SysUserDO sysUserDO1 = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda() - .eq(SysUserDO::getPhone, storeVO.getPhone()).eq(SysUserDO::getType, 5)); + .eq(SysUserDO::getPhone, storeVO.getStoreAccount()).eq(SysUserDO::getType, 5)); if (sysUserDO1 == null) { return R.fail("未查询到后台管理用户!"); } @@ -2078,8 +2346,7 @@ /** * 修改用户小程序首页活动提示 * - * @param userEditTipsDTO - * 请求参数 + * @param userEditTipsDTO 请求参数 * @return 修改结果 */ public R editUserTips(SysUserEditTipsDTO userEditTipsDTO) { @@ -2122,9 +2389,8 @@ /** * 修改app用户密码 - * - * @param userInfoAppDTO - * 请求参数 + * + * @param userInfoAppDTO 请求参数 * @return 修改结果 */ @Override @@ -2154,16 +2420,15 @@ /** * 添加网格员 - * - * @param eventGridMemberAddDTO - * 请求参数 + * + * @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)); + new QueryWrapper<SysRoleDO>().lambda().eq(SysRoleDO::getRoleKey, Constants.GRID_DEFAULT_ROLE_KEY)); if (gridMemberDefaultRole == null) { // 添加默认网格员角色 gridMemberDefaultRole = new SysRoleDO(); @@ -2187,7 +2452,7 @@ // 参数校验 SysUserDO oldUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, 6) - .eq(SysUserDO::getNickName, eventGridMemberAddDTO.getNickName())); + .eq(SysUserDO::getNickName, eventGridMemberAddDTO.getNickName())); if (oldUserDO != null) { return R.fail("昵称已使用"); } @@ -2214,8 +2479,8 @@ // 关联市平台网格员 if (eventGridMemberAddDTO.getLcMemberId() != null) { LcCompareCodeMemberDO compareCodeMemberDO = - lcCompareMemberCodeMapper.selectOne(new QueryWrapper<LcCompareCodeMemberDO>().lambda() - .eq(LcCompareCodeMemberDO::getLcGridMemberId, eventGridMemberAddDTO.getLcMemberId())); + lcCompareMemberCodeMapper.selectOne(new QueryWrapper<LcCompareCodeMemberDO>().lambda() + .eq(LcCompareCodeMemberDO::getLcGridMemberId, eventGridMemberAddDTO.getLcMemberId())); if (compareCodeMemberDO != null) { compareCodeMemberDO.setLocalGridMemberId(sysUserDO.getUserId().toString()); compareCodeMemberDO.setGridMemberName(sysUserDO.getNickName()); @@ -2271,15 +2536,14 @@ /** * 网格员管理 - * - * @param memberRelationDTO - * 请求参数 + * + * @param memberRelationDTO 请求参数 * @return 网格员列表 */ @Override public R getGridMemberList(PageEventGridMemberRelationDTO memberRelationDTO) { IPage<GridMemberVO> gridMemberPage = userDao.getGridMemberList( - new Page(memberRelationDTO.getPageNum(), memberRelationDTO.getPageSize()), memberRelationDTO); + new Page(memberRelationDTO.getPageNum(), memberRelationDTO.getPageSize()), memberRelationDTO); if (!gridMemberPage.getRecords().isEmpty()) { gridMemberPage.getRecords().forEach(gridMember -> { // 查询网格员关联市平台网格员id @@ -2292,7 +2556,7 @@ // 查询网格员关联楼栋信息 List<GridMemberBuildingVO> memberBuildingList = - eventGridMemberBuildingRelationMapper.getGridMemberBuildingRelation(gridMember.getUserId()); + eventGridMemberBuildingRelationMapper.getGridMemberBuildingRelation(gridMember.getUserId()); if (!memberBuildingList.isEmpty()) { memberBuildingList.forEach(memberBuilding -> { if (!memberBuilding.getBuildingName().contains("栋")) { @@ -2308,9 +2572,8 @@ /** * 修改网格员信息 - * - * @param gridMemberDTO - * 请求参数 + * + * @param gridMemberDTO 请求参数 * @return 修改结果 */ @Override @@ -2328,7 +2591,7 @@ // 参数校验 SysUserDO oldUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getType, 6) - .eq(SysUserDO::getNickName, gridMemberDTO.getNickName())); + .eq(SysUserDO::getNickName, gridMemberDTO.getNickName())); if (oldUserDO != null && !oldUserDO.getUserId().equals(gridMemberDTO.getGridMemberId())) { return R.fail("昵称已使用"); } @@ -2345,8 +2608,8 @@ if (gridMemberDTO.getLcMemberId() != null) { // 关联现有的网格员信息 LcCompareCodeMemberDO compareCodeMemberDO = - lcCompareMemberCodeMapper.selectOne(new QueryWrapper<LcCompareCodeMemberDO>().lambda() - .eq(LcCompareCodeMemberDO::getLcGridMemberId, gridMemberDTO.getLcMemberId())); + lcCompareMemberCodeMapper.selectOne(new QueryWrapper<LcCompareCodeMemberDO>().lambda() + .eq(LcCompareCodeMemberDO::getLcGridMemberId, gridMemberDTO.getLcMemberId())); if (compareCodeMemberDO != null) { compareCodeMemberDO.setLocalGridMemberId(sysUserDO.getUserId().toString()); compareCodeMemberDO.setGridMemberName(sysUserDO.getNickName()); @@ -2404,9 +2667,8 @@ /** * 重置网格员密码 - * - * @param gridMemberDTO - * 请求参数 + * + * @param gridMemberDTO 请求参数 * @return 重置结果 */ @Override @@ -2422,9 +2684,8 @@ /** * 批量删除网格员 - * - * @param Ids - * 网格员id集合 + * + * @param Ids 网格员id集合 * @return 删除结果 */ @Override @@ -2461,17 +2722,16 @@ /** * 查询社区的收益说明 - * - * @param communityId - * 社区id + * + * @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)); + sysUserAgreementDAO.selectList(new LambdaQueryWrapper<SysUserAgreementDO>() + .eq(SysUserAgreementDO::getCommunityId, communityId).eq(SysUserAgreementDO::getType, 5)); if (sysUserAgreementDOS.isEmpty()) { SysUserAgreementDO agreementDO = new SysUserAgreementDO(); agreementDO.setCommunityId(communityId); @@ -2508,9 +2768,8 @@ /** * 根据用户id查询用户openid - * - * @param userId - * 用户id + * + * @param userId 用户id * @return openid */ @Override @@ -2524,9 +2783,8 @@ /** * 查询社区后台工作人员列表 - * - * @param communityId - * 社区id + * + * @param communityId 社区id * @return 社区后台工作人员列表 */ @Override @@ -2536,6 +2794,7 @@ /** * 检查当前用户是否是社区工作人员 + * * @param phone * @param communityId * @return @@ -2563,9 +2822,9 @@ } @Override - public R resetPasswordPatch(Long[] userId,String password) { - if(userId!=null){ - for(Long user:userId){ + 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); @@ -2578,6 +2837,7 @@ /** * 便民服务新增商家账号 + * * @param convenientMerchantDTO * @return 商家用户id */ @@ -2589,10 +2849,6 @@ if (nonNull(sysUserDO)) { return R.fail("账户已经存在"); } - sysUserDO = userDao.selectOne(new QueryWrapper<SysUserDO>().lambda().eq(SysUserDO::getPhone, convenientMerchantDTO.getPhone())); - if (nonNull(sysUserDO)) { - return R.fail("手机号已经存在"); - } // sys_user 表 sysUserDO = new SysUserDO(); String encode = new BCryptPasswordEncoder().encode(convenientMerchantDTO.getPassword()); @@ -2601,7 +2857,7 @@ sysUserDO.setType(10); sysUserDO.setAreaId(null); sysUserDO.setStatus(1); - sysUserDO.setPhone(convenientMerchantDTO.getPhone()); + sysUserDO.setPhone(null); sysUserDO.setName(convenientMerchantDTO.getContacts()); sysUserDO.setPassword(encode); try { @@ -2616,7 +2872,8 @@ /** * 修改便民服务商家绑定账号 - * @param userId 用户id + * + * @param userId 用户id * @param account 修改账户 * @return 修改结果 */ @@ -2662,17 +2919,18 @@ userDao.disableOrEnableMerchantUsers(disableOrEnableConvenientMerchantDTO.getType(), disableOrEnableConvenientMerchantDTO.getUserIds()); return R.ok(); } - + /** * 根据openid维护社区团队里是否注册 - * @param openid 用户微信唯一标识 + * + * @param openid 用户微信唯一标识 */ @Override - public void judgeCommunityTeam(String openid){ + 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){ + 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()); } } @@ -2684,8 +2942,8 @@ * @return 运营后台数据看板升级版 */ @Override - public R dataKanBans(DataKanBansDto dataKanBansDto){ - IndexDataKanbanVO indexDataKanbanVO = userDao.selectIndexDataKanban(); + public R dataKanBans(DataKanBansDto dataKanBansDto) { + IndexDataKanbanVO indexDataKanbanVO = userDao.selectIndexDataKanban(dataKanBansDto.getAppId()); List<String> communityUserX = new ArrayList<>(); List<Integer> communityUserY = new ArrayList<>(); @@ -2694,10 +2952,18 @@ List<Integer> communityActiveUserZ = new ArrayList<>(); List<DataKanbanDTO> dataKanbanDTOS = null; - if(dataKanBansDto.getType() != null && dataKanBansDto.getType().equals(DataKanBansDto.type.by)){ - dataKanbanDTOS = userDao.selectCommunityUserOrderMonth(); - }else{ - dataKanbanDTOS = userDao.selectCommunityUserOrder(); + 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 -> { @@ -2707,14 +2973,24 @@ } // 获取最近二十天数据 - List<Date> serverndays = com.panzhihua.common.utlis.DateUtils.getOldDays(); - serverndays.forEach(date -> { - // 查询社区活动数量 - DataKanbanDTO dataKanbanDTO = userDao.selectCommunityAddUserOrder(date); + 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(dataKanbanDTO.getNum()); - communityActiveUserZ.add(dataKanbanDTO.getDayNum()); - }); + 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); @@ -2725,14 +3001,15 @@ /** * 运营后台-用户数据统计汇总 - * @return 用户数据统计汇总 + * + * @return 用户数据统计汇总 */ @Override - public R communityStatistics(){ + public R communityStatistics(String areaCode) { //返回结果数据 IndexUserStatisticsVo userStatisticsVo = new IndexUserStatisticsVo(); //查询所有街道 - List<IndexUserStreetVo> streetList = userDao.getUserStreetList(); + List<IndexUserStreetVo> streetList = userDao.getUserStreetList(areaCode); streetList.forEach(street -> { List<IndexUserCommunityVo> communityList = userDao.getUserCommunityList(street.getStreetId()); street.setCommunityList(communityList); @@ -2742,7 +3019,1194 @@ } @Override - public R communityStatisticsExport(){ - return R.ok(userDao.getUserCommunityExcelExport()); + 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); + } + 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