flower_city/src/main/java/com/dg/core/db/manual/pojo/QueryResults.java
@@ -25,4 +25,7 @@ @ApiModelProperty("联想词列表") private List<KeywordEntity> keywordEntityList; @ApiModelProperty("关联联想词列表") private List<KeywordEntity> keywordAssociationList; } flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java
@@ -105,6 +105,27 @@ queryResults.setTransactionEventList(searchesAssociate); queryResults.setKeywordEntityList( keywordMapper.selectByName(keyWord)); queryResults.setTotal((baseMapper.selectSearch(keyWord).size())+(baseMapper.selectSearchAssociate(keyWord).size())); List<TransactionEvent> transactionEventEntities = baseMapper.queryMatterNameList(keyWord, null); List<String> list = new ArrayList<>(); for (TransactionEvent transactionEvent : transactionEventEntities) { if (transactionEvent.getAssociateNames() != null) { String[] associateNames = transactionEvent.getAssociateNames().split(","); for (String associateName : associateNames) { list.add(associateName); } } } List<KeywordEntity> keywordEntityList = new ArrayList<>(); String[] keywords = list.stream().distinct().collect(Collectors.joining(",")).split(",");//去重 for (String keyword : keywords) { if (keyword != null && !keyword.equals("")) { KeywordEntity keywordEntity = new KeywordEntity(); keywordEntity.setName(keyword); keywordEntityList.add(keywordEntity); } } queryResults.setKeywordAssociationList(keywordEntityList); return queryResults; } @@ -131,22 +152,27 @@ RecommendResult recommendResult=new RecommendResult(); List<KeywordEntity> keywordEntityList=new ArrayList<>(); List<TransactionEvent> transactionEventEntities = baseMapper.queryMatterNameList(keyWord,null); List<TransactionEvent> transactionEvents = baseMapper.queryAssociateNamesList(keyWord, null); recommendResult.setTransactionEventList(transactionEventEntities); List<String> list = new ArrayList<>(); for (TransactionEvent transactionEvent: transactionEventEntities) { if (transactionEvent.getAssociateNames()!=null) { for (TransactionEvent transactionEvent : transactionEvents) { // 直接返回办事指南名称 list.add(transactionEvent.getMatterName()); // 遍历关键词列表 可能后面流程更改会遇到暂时保存代码; /* if (transactionEvent.getAssociateNames() != null) { String[] associateNames = transactionEvent.getAssociateNames().split(","); for (String associateName : associateNames) { list.add(associateName); } } }*/ } String[] keywords = list.stream().distinct().collect(Collectors.joining(",")).split(",");//去重 for (String keyword:keywords) { if (keyword!=null&&!keyword.equals("")) {KeywordEntity keywordEntity=new KeywordEntity(); if (keyword != null && !keyword.equals("")) { KeywordEntity keywordEntity = new KeywordEntity(); keywordEntity.setName(keyword); keywordEntityList.add(keywordEntity);} keywordEntityList.add(keywordEntity); } } recommendResult.setKeywordEntityList(keywordEntityList); List<OrganizationChartEntity> organizationChartEntities = organizationChartMapper.selectByKeyWord(keyWord); flower_city/src/main/java/com/dg/core/util/WxUtil.java
@@ -27,6 +27,8 @@ private static String ACCESS_TOKEN_URL = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential"; private static String miniprogramState="trial";//trial 为测试版 formal 为正式版 切记发布版本时候改为正式版 /** * 获取花城token,(ps:0=token获取失败) * @@ -200,7 +202,8 @@ WxSubscribeDTO subscribeDTO = new WxSubscribeDTO(); subscribeDTO.setTouser(openId); subscribeDTO.setTemplate_id(templateId); subscribeDTO.setMiniprogram_state("formal");//测试,部署正式版本时候需要更改为formal subscribeDTO.setMiniprogram_state(miniprogramState); subscribeDTO.setPage("packageE/pages/myApply/myApply"); List<TemplateParam> paras=new ArrayList<TemplateParam>(); Calendar calendar = Calendar.getInstance(); paras.add(new TemplateParam("thing1","导办申请"));//业务办理类型 @@ -229,7 +232,8 @@ WxSubscribeDTO subscribeDTO = new WxSubscribeDTO(); subscribeDTO.setTouser(openId); subscribeDTO.setTemplate_id(templateId); subscribeDTO.setMiniprogram_state("formal");//测试,部署正式版本时候需要更改为formal subscribeDTO.setMiniprogram_state(miniprogramState); subscribeDTO.setPage("packageE/pages/applyHandle/index/index"); List<TemplateParam> paras=new ArrayList<TemplateParam>(); paras.add(new TemplateParam("thing4","您有一个新的导办工单需要处理"));//工单新增提示内容 paras.add(new TemplateParam("thing2",guideRepairOrder.getConsultUserName()));//咨询人 @@ -255,7 +259,8 @@ WxSubscribeDTO subscribeDTO = new WxSubscribeDTO(); subscribeDTO.setTouser(openId); subscribeDTO.setTemplate_id(templateId); subscribeDTO.setMiniprogram_state("formal");//测试,部署正式版本时候需要更改为formal subscribeDTO.setMiniprogram_state(miniprogramState); subscribeDTO.setPage("packageE/pages/applyHandle/index/index"); List<TemplateParam> paras=new ArrayList<TemplateParam>(); Calendar calendar = Calendar.getInstance(); calendar.setTime(new Date()); flower_city/src/main/resources/mapper/OrganizationChartMapper.xml
@@ -86,9 +86,9 @@ <select id="selectByKeyWord" resultMap="OrganizationChartResult"> <include refid="selectOrganizationChartVo"/> where organization_name like concat('%', #{keyWord}, '%') or #{keyWord} like concat('%', organization_name, '%') or((detailed_address like concat('%', #{keyWord}, '%') or #{keyWord} like concat('%', detailed_address, '%')) and TRIM(detailed_address) != '') or((resume like concat('%', #{keyWord}, '%') or #{keyWord} like concat('%', resume, '%')) and TRIM(resume) != '' ) where organization_name like concat('%', #{keyWord}, '%') or((detailed_address like concat('%', #{keyWord}, '%') ) and TRIM(detailed_address) !='') or((resume like concat('%', #{keyWord}, '%') ) and TRIM(resume) != '' ) </select> <select id="selectByCode" resultMap="OrganizationChartResult"> flower_city/src/main/resources/mapper/TransactionEventMapper.xml
@@ -345,7 +345,7 @@ <include refid="selectTransactionEventEntityVo"/> <where> <if test="matterName != null and matterName != ''"> AND (matter_name like concat('%', #{matterName}, '%') or #{matterName} like concat('%', matter_name, '%')) AND (matter_name like concat('%', #{matterName}, '%') ) </if> <if test="classifyId != null and classifyId != ''"> and (classify_id= #{classifyId} or classify_id in (select id FROM automessage_classify_administration where parent_id =#{classifyId} )) springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/UserApi.java
@@ -524,4 +524,10 @@ pageProjectDTO.setUserId(this.getUserId()); return communityService.pageProjectWhichIsSignedByUser(pageProjectDTO); } @ApiOperation("获取用户") @GetMapping("selectAutomessageSysUserById") public R selectAutomessageSysUserById(@RequestParam("id")Long id){ return communityService.selectAutomessageSysUserById(id); } } springcloud_k8s_panzhihuazhihuishequ/applets_backstage/src/main/java/com/panzhihua/applets_backstage/api/UserApi.java
@@ -1,12 +1,5 @@ package com.panzhihua.applets_backstage.api; import javax.annotation.Resource; import com.panzhihua.common.utlis.StringUtils; import org.springframework.data.redis.core.StringRedisTemplate; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; import com.panzhihua.common.controller.BaseController; import com.panzhihua.common.interfaces.OperLog; import com.panzhihua.common.model.vos.LoginUserInfoVO; @@ -14,9 +7,14 @@ import com.panzhihua.common.model.vos.user.ChangePasswordVO; import com.panzhihua.common.model.vos.user.SysMenuVO; import com.panzhihua.common.service.user.UserService; import com.panzhihua.common.utlis.StringUtils; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.data.redis.core.StringRedisTemplate; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; /** * @program: springcloud_k8s_panzhihuazhihuishequ @@ -85,4 +83,6 @@ } return R.ok(); } } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java
@@ -10556,4 +10556,12 @@ */ @GetMapping("selectCommunityIds") R selectCommunityIds(@RequestParam("id") Long id); /** * 查询社区id集合 * @param id * @return */ @GetMapping("selectAutomessageSysUserById") R selectAutomessageSysUserById(@RequestParam("id") Long id); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/AutomessageSysUserDao.java
@@ -23,7 +23,7 @@ * @param id * @return */ @Select("select * from automessage_sys_user where id = #{id}") @Select("select * from automessage_sys_user where user_id = #{id}") AutomessageSysUser selectAutomessageSysUserById(@Param("id") Long id); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/message/AcidMessage.java
@@ -118,7 +118,7 @@ WxXCXTempSend wxXCXTempSend=new WxXCXTempSend(); for(String openId:openIds){ try { WxUtil.sendLongTimeTemplate(openId,wxXCXTempSend.getAccessToken("wx118de8a734d269f0"),"疫情快讯",comActDynVO.getTitle().length()>10?comActDynVO.getTitle().substring(0,10)+"..":comActDynVO.getTitle(),"/pages/community_child/community/detail?id="+comActDynVO.getId()+"&title=疫情快讯详情"); WxUtil.sendLongTimeTemplate(openId,wxXCXTempSend.getXQAppAccessToken(),"疫情快讯",comActDynVO.getTitle().length()>10?comActDynVO.getTitle().substring(0,10)+"..":comActDynVO.getTitle(),"/pages/community_child/community/detail?id="+comActDynVO.getId()+"&title=疫情快讯详情"); } catch (Exception e) { e.printStackTrace(); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/AutomessageSysUserServiceImpl.java
@@ -7,6 +7,8 @@ import com.panzhihua.service_community.service.AutomessageSysUserService; import org.springframework.stereotype.Service; import javax.annotation.Resource; /** * @ClassName: AutomessageSysUserServiceImpl * @Author: yh @@ -16,8 +18,10 @@ @Service public class AutomessageSysUserServiceImpl extends ServiceImpl<AutomessageSysUserDao, AutomessageSysUser> implements AutomessageSysUserService { @Resource private AutomessageSysUserDao automessageSysUserDao; @Override public R selectAutomessageSysUserById(Long id) { return R.ok(super.getById(id)); return R.ok(automessageSysUserDao.selectAutomessageSysUserById(id)); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComEventServiceImpl.java
@@ -899,10 +899,17 @@ List<ComEventResource> resource = comEventResourceService.list(new QueryWrapper<ComEventResource>().lambda().eq(ComEventResource::getRefId, id) .eq(ComEventResource::getStatus, 5)); map.put("archiveImage", resource); map.put("contact", comActDAO.selectById(comEvent.getRequestUserCommunity()).getContactsPhone()); map.put("contact", getPhone(comEvent)); return map; } public String getPhone(ComEvent comEvent){ if (isNull(comEvent.getRequestUserCommunity())){ return comSanShuoIndustryCenterService.getById(comEvent.getCenterId()).getPhone(); }else { return comActDAO.selectById(comEvent.getRequestUserCommunity()).getContactsPhone(); } } @Override @Transactional(rollbackFor = Exception.class) springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/ComPbMemberDAO.java
@@ -205,4 +205,7 @@ * @return */ IPage<PartyBuildingMemberVO> pageRegisterMember(@Param("page") Page page, @Param("dto") PageMemberForInviteDTO dto); @Select("SELECT caa.community_id FROM com_act caa WHERE caa.`name` = ( select ca.`name` FROM com_act ca WHERE ca.community_id =#{id})") List<Long> selectIds(@Param("id") Long id); }