wuxw
2023-11-01 7fca0ff445f4c19d547daf71b47201505cb2b9c0
service-job/src/main/java/com/java110/job/task/wechat/PublicWeChatPushMessageTemplate.java
old mode 100644 new mode 100755
@@ -1,28 +1,39 @@
package com.java110.job.task.wechat;
import com.alibaba.fastjson.JSON;
import com.java110.core.factory.WechatFactory;
import com.java110.core.smo.fee.IFeeInnerServiceSMO;
import com.java110.core.smo.store.ISmallWeChatInnerServiceSMO;
import com.java110.core.smo.user.IOwnerAppUserInnerServiceSMO;
import com.java110.dto.fee.BillOweFeeDto;
import com.alibaba.fastjson.JSONObject;
import com.java110.core.factory.GenerateCodeFactory;
import com.java110.core.log.LoggerFactory;
import com.java110.dto.community.CommunityDto;
import com.java110.dto.fee.FeeDto;
import com.java110.dto.oweFeeCallable.OweFeeCallableDto;
import com.java110.dto.owner.OwnerAppUserDto;
import com.java110.dto.smallWeChat.SmallWeChatDto;
import com.java110.dto.reportFee.ReportOweFeeDto;
import com.java110.dto.task.TaskDto;
import com.java110.entity.wechat.Content;
import com.java110.entity.wechat.Data;
import com.java110.entity.wechat.PropertyFeeTemplateMessage;
import com.java110.intf.fee.IFeeInnerServiceSMO;
import com.java110.intf.fee.IOweFeeCallableV1InnerServiceSMO;
import com.java110.intf.report.IReportOweFeeInnerServiceSMO;
import com.java110.intf.store.ISmallWeChatInnerServiceSMO;
import com.java110.intf.store.ISmallWechatAttrInnerServiceSMO;
import com.java110.intf.user.IOwnerAppUserInnerServiceSMO;
import com.java110.job.msgNotify.MsgNotifyFactory;
import com.java110.job.quartz.TaskSystemQuartz;
import com.java110.po.oweFeeCallable.OweFeeCallablePo;
import com.java110.utils.cache.MappingCache;
import com.java110.utils.cache.UrlCache;
import com.java110.utils.constant.MappingConstant;
import com.java110.utils.constant.WechatConstant;
import com.java110.utils.util.DateUtil;
import com.java110.utils.util.StringUtil;
import com.java110.vo.ResultVo;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Component;
import org.springframework.web.client.RestTemplate;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
 * @program: MicroCommunity
@@ -31,7 +42,7 @@
 * @create: 2020-06-15 13:35
 **/
@Component
public class PublicWeChatPushMessageTemplate extends TaskSystemQuartz{
public class PublicWeChatPushMessageTemplate extends TaskSystemQuartz {
    private static Logger logger = LoggerFactory.getLogger(PublicWeChatPushMessageTemplate.class);
@@ -42,85 +53,199 @@
    private ISmallWeChatInnerServiceSMO smallWeChatInnerServiceSMOImpl;
    @Autowired
    private ISmallWechatAttrInnerServiceSMO smallWechatAttrInnerServiceSMOImpl;
    @Autowired
    private IOwnerAppUserInnerServiceSMO ownerAppUserInnerServiceSMOImpl;
    @Autowired
    private IReportOweFeeInnerServiceSMO reportOweFeeInnerServiceSMOImpl;
    @Autowired
    private RestTemplate outRestTemplate;
    @Autowired
    private IOweFeeCallableV1InnerServiceSMO oweFeeCallableV1InnerServiceSMOImpl;
    //模板信息推送地址
    private static String sendMsgUrl = "https://api.weixin.qq.com/cgi-bin/message/template/send?access_token=";
    //模板id
    private static String templateId = "ZF4j_ug2XW-UGwW1F-Gi4M1-51lpiu-PM89Oa6oZv6w";
    private static String DEFAULT_TEMPLATE_ID = "ZF4j_ug2XW-UGwW1F-Gi4M1-51lpiu-PM89Oa6oZv6w";
    @Override
    protected void process(TaskDto taskDto) throws Exception {
    protected void process(TaskDto taskDto) {
        logger.debug("开始执行微信模板信息推送" + taskDto.toString());
        //查询公众号配置
        SmallWeChatDto smallWeChatDto = new SmallWeChatDto();
        smallWeChatDto.setWeChatType("1100");
        List<SmallWeChatDto> smallWeChatDtos = smallWeChatInnerServiceSMOImpl.querySmallWeChats(smallWeChatDto);
        // 获取小区
        List<CommunityDto> communityDtos = getAllCommunity();
        if(smallWeChatDtos.size() <=0 || smallWeChatDto == null){
            logger.info("未配置微信公众号信息,定时任务执行结束");
        for (CommunityDto communityDto : communityDtos) {
            try {
                publishMsg(taskDto, communityDto);
            } catch (Exception e) {
                logger.error("推送消息失败", e);
            }
        }
    }
    private void publishMsg(TaskDto taskDto, CommunityDto communityDto) throws Exception {
        ReportOweFeeDto reportOweFeeDto = new ReportOweFeeDto();
        reportOweFeeDto.setCommunityId(communityDto.getCommunityId());
        reportOweFeeDto.setHasOweFee("Y");
        List<ReportOweFeeDto> reportOweFeeDtos = reportOweFeeInnerServiceSMOImpl.queryReportAllOweFees(reportOweFeeDto);
        if (reportOweFeeDtos == null || reportOweFeeDtos.size() < 1) {
            return;
        }
        SmallWeChatDto weChatDto = smallWeChatDtos.get(0);
        String accessToken =  WechatFactory.getAccessToken(weChatDto.getAppId(),weChatDto.getAppSecret());
        OweFeeCallablePo oweFeeCallablePo = null;
        List<OweFeeCallablePo> oweFeeCallablePos = new ArrayList<>();
        String notifyWay = MappingCache.getValue(MappingConstant.ENV_DOMAIN, "DEFAULT_MSG_NOTIFY_WAY");
        if (StringUtil.isEmpty(notifyWay) || MsgNotifyFactory.NOTIFY_WAY_WECHAT.equals(notifyWay)) {
            notifyWay = OweFeeCallableDto.CALLABLE_WAY_WECHAT;
        } else {
            notifyWay = OweFeeCallableDto.CALLABLE_WAY_SMS;
        }
        if(accessToken == null || accessToken == ""){
            logger.info("推送微信模板,获取accessToken失败:{}",accessToken);
        for (ReportOweFeeDto fee : reportOweFeeDtos) {
            if(StringUtil.isEmpty(fee.getOwnerId())){
                continue;
            }
            oweFeeCallablePo = new OweFeeCallablePo();
            oweFeeCallablePo.setAmountdOwed(fee.getAmountOwed());
            oweFeeCallablePo.setCallableWay(notifyWay);
            oweFeeCallablePo.setOfcId(GenerateCodeFactory.getGeneratorId("11"));
            oweFeeCallablePo.setFeeId(fee.getFeeId());
            oweFeeCallablePo.setFeeName(fee.getFeeName());
            oweFeeCallablePo.setCommunityId(communityDto.getCommunityId());
            oweFeeCallablePo.setConfigId(fee.getConfigId());
            oweFeeCallablePo.setOwnerId(fee.getOwnerId());
            oweFeeCallablePo.setOwnerName(fee.getOwnerName());
            oweFeeCallablePo.setPayerObjId(fee.getPayerObjId());
            oweFeeCallablePo.setPayerObjName(fee.getPayerObjName());
            oweFeeCallablePo.setPayerObjType(fee.getPayerObjType());
            oweFeeCallablePo.setRemark("系统自动催缴");
            oweFeeCallablePo.setStaffId("-1");
            oweFeeCallablePo.setStaffName("系统自动催缴");
            oweFeeCallablePo.setState(OweFeeCallableDto.STATE_WAIT);
            oweFeeCallablePo.setStartTime(fee.getEndTime());
            oweFeeCallablePo.setEndTime(fee.getDeadlineTime());
            oweFeeCallablePos.add(oweFeeCallablePo);
        }
        if (oweFeeCallablePos.size() < 1) {
            return;
        }
        //根据小区id查询业主与公众号绑定信息
        OwnerAppUserDto ownerAppUserDto = new OwnerAppUserDto();
        ownerAppUserDto.setCommunityId(weChatDto.getObjId());
        ownerAppUserDto.setAppType("WECHAT");
        List<OwnerAppUserDto>  ownerAppUserDtos = ownerAppUserInnerServiceSMOImpl.queryOwnerAppUsers(ownerAppUserDto);
        if(ownerAppUserDtos.size() <=0 || ownerAppUserDtos == null){
            logger.info("未查询到业主与微信公众号绑定关系");
            return;
        int flag = oweFeeCallableV1InnerServiceSMOImpl.saveOweFeeCallables(oweFeeCallablePos);
        if (flag < 1) {
            throw new IllegalArgumentException("保存催缴记录失败");
        }
        String oweUrl = "";
        JSONObject content = null;
        String oweRoomUrl = UrlCache.getOwnerUrl() + MappingCache.getValue(WechatConstant.WECHAT_DOMAIN, WechatConstant.OWE_FEE_PAGE);
        String oweCarUrl = UrlCache.getOwnerUrl() + MappingCache.getValue(WechatConstant.WECHAT_DOMAIN, WechatConstant.OWE_CAR_FEE_PAGE);
        List<String> memberIdList = new ArrayList<>(ownerAppUserDtos.size());
        for(OwnerAppUserDto appUserDto :ownerAppUserDtos ){
            memberIdList.add(appUserDto.getMemberId());
        }
        OweFeeCallablePo updateOweFeeCallablePo = null;
        OwnerAppUserDto ownerAppUserDto = null;
        String[] memberIds = memberIdList.toArray(new String[memberIdList.size()]);
        //查询欠费信息
        BillOweFeeDto billOweFeeDto = new BillOweFeeDto();
        billOweFeeDto.setCommunityId(weChatDto.getObjId());
        billOweFeeDto.setOwnerIds(memberIds);
        billOweFeeDto.setState("1000");
        List<BillOweFeeDto> billOweFeeDtos = feeInnerServiceSMOImpl.queryBillOweFees(billOweFeeDto);
        ResultVo resultVo = null;
        String userId = "";
        String url = sendMsgUrl + accessToken;
        for( BillOweFeeDto fee : billOweFeeDtos){
            for(OwnerAppUserDto appUserDto :ownerAppUserDtos ){
                if(fee.getOwnerId().equals(appUserDto.getMemberId())){
                    Data data = new Data();
                    PropertyFeeTemplateMessage templateMessage = new PropertyFeeTemplateMessage();
                    templateMessage.setTemplate_id(templateId);
                    templateMessage.setTouser(appUserDto.getOpenId());
                    data.setFirst(new Content("物业费缴费提醒"));
                    data.setKeyword1(new Content(fee.getPayerObjName()));
                    data.setKeyword2(new Content(fee.getFeeEndTime()));
                    data.setKeyword3(new Content(fee.getAmountOwed()));
                    data.setRemark(new Content("请您及时缴费,如有疑问请联系相关物业人员"));
                    templateMessage.setData(data);
                    logger.info("发送模板消息内容:{}", JSON.toJSONString(templateMessage));
                    ResponseEntity<String> responseEntity = outRestTemplate.postForEntity(url, JSON.toJSONString(templateMessage), String.class);
                    logger.info("微信模板返回内容:{}",responseEntity);
        //todo 根据房屋发送欠费信息
        Map<String, List<OweFeeCallablePo>> roomOweFeeCallables = computeRoomOweFeeCallable(oweFeeCallablePos);
        List<JSONObject> contents = null;
        for (String key : roomOweFeeCallables.keySet()) {
            userId = "";
            contents = new ArrayList<>();
            for (OweFeeCallablePo tmpOweFeeCallablePo : roomOweFeeCallables.get(key)) {
                if (StringUtil.isEmpty(tmpOweFeeCallablePo.getOwnerId()) || tmpOweFeeCallablePo.getOwnerId().startsWith("-")) {
                    updateOweFeeCallablePo = new OweFeeCallablePo();
                    updateOweFeeCallablePo.setOfcId(tmpOweFeeCallablePo.getOfcId());
                    updateOweFeeCallablePo.setCommunityId(tmpOweFeeCallablePo.getCommunityId());
                    updateOweFeeCallablePo.setState(OweFeeCallableDto.STATE_FAIL);
                    updateOweFeeCallablePo.setRemark(tmpOweFeeCallablePo.getRemark() + "-业主不存在");
                    oweFeeCallableV1InnerServiceSMOImpl.updateOweFeeCallable(updateOweFeeCallablePo);
                    continue;
                }
                oweUrl = FeeDto.PAYER_OBJ_TYPE_ROOM.equals(tmpOweFeeCallablePo.getPayerObjType()) ? oweRoomUrl : oweCarUrl;
                content = new JSONObject();
                content.put("feeTypeName", tmpOweFeeCallablePo.getFeeName());
                content.put("payerObjName", tmpOweFeeCallablePo.getPayerObjName());
                content.put("billAmountOwed", tmpOweFeeCallablePo.getAmountdOwed());
                content.put("date", DateUtil.dateTimeToDate(tmpOweFeeCallablePo.getStartTime()) + "~" + DateUtil.dateTimeToDate(tmpOweFeeCallablePo.getEndTime()));
                content.put("url", oweUrl);
                ownerAppUserDto = new OwnerAppUserDto();
                ownerAppUserDto.setMemberId(tmpOweFeeCallablePo.getOwnerId());
                ownerAppUserDto.setCommunityId(tmpOweFeeCallablePo.getCommunityId());
                ownerAppUserDto.setAppType(OwnerAppUserDto.APP_TYPE_WECHAT);
                List<OwnerAppUserDto> ownerAppUserDtos = ownerAppUserInnerServiceSMOImpl.queryOwnerAppUsers(ownerAppUserDto);
                if (ownerAppUserDtos != null && !ownerAppUserDtos.isEmpty()) {
                    userId = ownerAppUserDtos.get(0).getUserId();
                }
                contents.add(content);
            }
            if (contents.isEmpty()) {
                continue;
            }
            //todo 发送推送消息
            resultVo = MsgNotifyFactory.sendOweFeeMsg(communityDto.getCommunityId(), userId, roomOweFeeCallables.get(key).get(0).getOwnerId(), contents);
            for (OweFeeCallablePo tmpOweFeeCallablePo : roomOweFeeCallables.get(key)) {
                if (StringUtil.isEmpty(tmpOweFeeCallablePo.getOwnerId()) || tmpOweFeeCallablePo.getOwnerId().startsWith("-")) {
                    continue;
                }
                updateOweFeeCallablePo = new OweFeeCallablePo();
                updateOweFeeCallablePo.setOfcId(tmpOweFeeCallablePo.getOfcId());
                updateOweFeeCallablePo.setCommunityId(tmpOweFeeCallablePo.getCommunityId());
                if (resultVo.getCode() != ResultVo.CODE_OK) {
                    updateOweFeeCallablePo.setState(OweFeeCallableDto.STATE_FAIL);
                    updateOweFeeCallablePo.setRemark(tmpOweFeeCallablePo.getRemark() + "-" + resultVo.getMsg());
                } else {
                    updateOweFeeCallablePo.setState(OweFeeCallableDto.STATE_COMPLETE);
                }
                oweFeeCallableV1InnerServiceSMOImpl.updateOweFeeCallable(updateOweFeeCallablePo);
            }
        }
    }
    /**
     * 根据房屋
     *
     * @param oweFeeCallablePos
     * @return
     */
    private Map<String, List<OweFeeCallablePo>> computeRoomOweFeeCallable(List<OweFeeCallablePo> oweFeeCallablePos) {
        Map<String, List<OweFeeCallablePo>> infos = new HashMap<>();
        List<OweFeeCallablePo> tmps = null;
        for (OweFeeCallablePo oweFeeCallablePo : oweFeeCallablePos) {
            if (infos.containsKey(oweFeeCallablePo.getPayerObjId())) {
                tmps = infos.get(oweFeeCallablePo.getPayerObjId());
                tmps.add(oweFeeCallablePo);
                continue;
            }
            tmps = new ArrayList<>();
            tmps.add(oweFeeCallablePo);
            infos.put(oweFeeCallablePo.getPayerObjId(), tmps);
        }
        return infos;
    }
}