FeeCollectionPushMessageTemplate.java 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613
  1. package com.java110.job.task.wechat;
  2. import com.alibaba.fastjson.JSON;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.java110.core.factory.GenerateCodeFactory;
  5. import com.java110.core.factory.SendSmsFactory;
  6. import com.java110.core.factory.WechatFactory;
  7. import com.java110.dto.community.CommunityDto;
  8. import com.java110.dto.fee.FeeDto;
  9. import com.java110.dto.feeCollectionOrder.FeeCollectionOrderDto;
  10. import com.java110.dto.logSystemError.LogSystemErrorDto;
  11. import com.java110.dto.owner.OwnerAppUserDto;
  12. import com.java110.dto.owner.OwnerDto;
  13. import com.java110.dto.reportOweFee.ReportOweFeeDto;
  14. import com.java110.dto.reportOweFee.ReportOweFeeItemDto;
  15. import com.java110.dto.smallWeChat.SmallWeChatDto;
  16. import com.java110.dto.smallWechatAttr.SmallWechatAttrDto;
  17. import com.java110.dto.smsConfig.SmsConfigDto;
  18. import com.java110.dto.task.TaskDto;
  19. import com.java110.entity.wechat.Content;
  20. import com.java110.entity.wechat.Data;
  21. import com.java110.entity.wechat.Miniprogram;
  22. import com.java110.entity.wechat.PropertyFeeTemplateMessage;
  23. import com.java110.intf.common.ISmsConfigInnerServiceSMO;
  24. import com.java110.intf.fee.IFeeCollectionDetailInnerServiceSMO;
  25. import com.java110.intf.fee.IFeeCollectionOrderInnerServiceSMO;
  26. import com.java110.intf.fee.IFeeInnerServiceSMO;
  27. import com.java110.intf.report.IReportOweFeeInnerServiceSMO;
  28. import com.java110.intf.store.ISmallWeChatInnerServiceSMO;
  29. import com.java110.intf.store.ISmallWechatAttrInnerServiceSMO;
  30. import com.java110.intf.user.IOwnerAppUserInnerServiceSMO;
  31. import com.java110.intf.user.IOwnerInnerServiceSMO;
  32. import com.java110.job.quartz.TaskSystemQuartz;
  33. import com.java110.po.feeCollectionDetail.FeeCollectionDetailPo;
  34. import com.java110.po.feeCollectionOrder.FeeCollectionOrderPo;
  35. import com.java110.po.logSystemError.LogSystemErrorPo;
  36. import com.java110.service.smo.ISaveSystemErrorSMO;
  37. import com.java110.utils.cache.MappingCache;
  38. import com.java110.utils.constant.WechatConstant;
  39. import com.java110.utils.util.BeanConvertUtil;
  40. import com.java110.utils.util.DateUtil;
  41. import com.java110.utils.util.ExceptionUtil;
  42. import com.java110.utils.util.StringUtil;
  43. import com.java110.vo.ResultVo;
  44. import org.slf4j.Logger;
  45. import com.java110.core.log.LoggerFactory;
  46. import org.springframework.beans.factory.annotation.Autowired;
  47. import org.springframework.http.ResponseEntity;
  48. import org.springframework.stereotype.Component;
  49. import org.springframework.web.client.RestTemplate;
  50. import java.math.BigDecimal;
  51. import java.text.DecimalFormat;
  52. import java.text.ParseException;
  53. import java.util.*;
  54. /**
  55. * @program: MicroCommunity
  56. * @description: 费用催缴信息模板
  57. * @author: zcc
  58. * @create: 2020-06-15 13:35
  59. **/
  60. @Component
  61. public class FeeCollectionPushMessageTemplate extends TaskSystemQuartz {
  62. private static Logger logger = LoggerFactory.getLogger(FeeCollectionPushMessageTemplate.class);
  63. @Autowired
  64. private IFeeInnerServiceSMO feeInnerServiceSMOImpl;
  65. @Autowired
  66. private ISmallWeChatInnerServiceSMO smallWeChatInnerServiceSMOImpl;
  67. @Autowired
  68. private ISmallWechatAttrInnerServiceSMO smallWechatAttrInnerServiceSMOImpl;
  69. @Autowired
  70. private IOwnerAppUserInnerServiceSMO ownerAppUserInnerServiceSMOImpl;
  71. @Autowired
  72. private IOwnerInnerServiceSMO ownerInnerServiceSMOImpl;
  73. @Autowired
  74. private IFeeCollectionOrderInnerServiceSMO feeCollectionOrderInnerServiceSMOImpl;
  75. @Autowired
  76. private IFeeCollectionDetailInnerServiceSMO feeCollectionDetailInnerServiceSMOImpl;
  77. @Autowired
  78. private IReportOweFeeInnerServiceSMO reportOweFeeInnerServiceSMOImpl;
  79. @Autowired
  80. private ISmsConfigInnerServiceSMO smsConfigInnerServiceSMOImpl;
  81. @Autowired
  82. private RestTemplate outRestTemplate;
  83. @Autowired
  84. private ISaveSystemErrorSMO saveSystemErrorSMOImpl;
  85. //模板信息推送地址
  86. private static String sendMsgUrl = "https://api.weixin.qq.com/cgi-bin/message/template/send?access_token=";
  87. //模板id
  88. private static String DEFAULT_TEMPLATE_ID = "ZF4j_ug2XW-UGwW1F-Gi4M1-51lpiu-PM89Oa6oZv6w";
  89. private static final int DEFAULT_FEE_COUNT = 200;
  90. @Override
  91. protected void process(TaskDto taskDto) {
  92. logger.debug("开始执行微信模板信息推送" + taskDto.toString());
  93. // 获取小区
  94. List<CommunityDto> communityDtos = getAllCommunity();
  95. for (CommunityDto communityDto : communityDtos) {
  96. try {
  97. publishMsg(taskDto, communityDto);
  98. } catch (Exception e) {
  99. logger.error("推送消息失败", e);
  100. }
  101. }
  102. }
  103. private void publishMsg(TaskDto taskDto, CommunityDto communityDto) throws Exception {
  104. FeeCollectionOrderDto feeCollectionOrderDto = new FeeCollectionOrderDto();
  105. feeCollectionOrderDto.setCommunityId(communityDto.getCommunityId());
  106. feeCollectionOrderDto.setState(FeeCollectionOrderDto.STATE_WAIT);
  107. List<FeeCollectionOrderDto> feeCollectionOrderDtos = feeCollectionOrderInnerServiceSMOImpl.queryFeeCollectionOrders(feeCollectionOrderDto);
  108. if (feeCollectionOrderDtos == null || feeCollectionOrderDtos.size() < 1) {
  109. return;
  110. }
  111. ReportOweFeeDto reportOweFeeDto = new ReportOweFeeDto();
  112. reportOweFeeDto.setCommunityId(communityDto.getCommunityId());
  113. reportOweFeeDto.setHasOweFee("Y");
  114. int oweCount = reportOweFeeInnerServiceSMOImpl.queryReportOweFeesCount(reportOweFeeDto);
  115. if (oweCount == 0) {
  116. return;
  117. }
  118. int maxPage = (int) Math.ceil(oweCount * 1.0 / DEFAULT_FEE_COUNT);
  119. for (int roomIndex = 1; roomIndex <= maxPage; roomIndex++) {
  120. try {
  121. doReportOweFeePushMessage(roomIndex, DEFAULT_FEE_COUNT, communityDto, feeCollectionOrderDtos.get(0));
  122. FeeCollectionOrderPo feeCollectionOrderPo = BeanConvertUtil.covertBean(feeCollectionOrderDtos.get(0), FeeCollectionOrderPo.class);
  123. feeCollectionOrderPo.setState("F");
  124. feeCollectionOrderInnerServiceSMOImpl.updateFeeCollectionOrder(feeCollectionOrderPo);
  125. } catch (Exception e) {
  126. LogSystemErrorPo logSystemErrorPo = new LogSystemErrorPo();
  127. logSystemErrorPo.setErrId(GenerateCodeFactory.getGeneratorId(GenerateCodeFactory.CODE_PREFIX_errId));
  128. logSystemErrorPo.setErrType(LogSystemErrorDto.ERR_TYPE_OWE_FEE);
  129. logSystemErrorPo.setMsg(ExceptionUtil.getStackTrace(e));
  130. saveSystemErrorSMOImpl.saveLog(logSystemErrorPo);
  131. logger.error("欠费推送失败" + communityDto.getCommunityId(), e);
  132. }
  133. }
  134. }
  135. private void doReportOweFeePushMessage(int page, int row, CommunityDto communityDto, FeeCollectionOrderDto feeCollectionOrderDto) {
  136. ReportOweFeeDto reportOweFeeDto = new ReportOweFeeDto();
  137. reportOweFeeDto.setCommunityId(communityDto.getCommunityId());
  138. reportOweFeeDto.setHasOweFee("Y");
  139. reportOweFeeDto.setPage(page);
  140. reportOweFeeDto.setRow(row);
  141. List<ReportOweFeeDto> reportOweFeeDtos = reportOweFeeInnerServiceSMOImpl.queryReportOweFees(reportOweFeeDto);
  142. refreshReportOwe(reportOweFeeDtos);
  143. if (reportOweFeeDtos.size() > 0) {
  144. pushMessage(reportOweFeeDtos, feeCollectionOrderDto);
  145. } else {
  146. logger.error("当前没有欠费信息" + communityDto.getCommunityId());
  147. }
  148. }
  149. private void pushMessage(List<ReportOweFeeDto> reportOweFeeDtos, FeeCollectionOrderDto feeCollectionOrderDto) {
  150. for (ReportOweFeeDto reportOweFeeDo : reportOweFeeDtos) {
  151. try {
  152. doPushMessage(reportOweFeeDo, feeCollectionOrderDto);
  153. } catch (Exception e) {
  154. LogSystemErrorPo logSystemErrorPo = new LogSystemErrorPo();
  155. logSystemErrorPo.setErrId(GenerateCodeFactory.getGeneratorId(GenerateCodeFactory.CODE_PREFIX_errId));
  156. logSystemErrorPo.setErrType(LogSystemErrorDto.ERR_TYPE_OWE_FEE);
  157. logSystemErrorPo.setMsg(ExceptionUtil.getStackTrace(e));
  158. saveSystemErrorSMOImpl.saveLog(logSystemErrorPo);
  159. logger.error("欠费推送失败" + feeCollectionOrderDto.getCollectionName(), e);
  160. }
  161. }
  162. }
  163. /**
  164. * 推送消息
  165. *
  166. * @param reportOweFeeDo
  167. * @param feeCollectionOrderDto
  168. */
  169. private void doPushMessage(ReportOweFeeDto reportOweFeeDo, FeeCollectionOrderDto feeCollectionOrderDto) {
  170. FeeCollectionDetailPo feeCollectionDetailPo = new FeeCollectionDetailPo();
  171. ResultVo resultVo = null;
  172. switch (feeCollectionOrderDto.getCollectionWay()) {
  173. case FeeCollectionOrderDto.COLLECTION_WAY_SMS:
  174. resultVo = doSendSms(reportOweFeeDo, feeCollectionOrderDto);//短信
  175. feeCollectionDetailPo.setCollectionWay(FeeCollectionOrderDto.COLLECTION_WAY_SMS);
  176. break;
  177. case FeeCollectionOrderDto.COLLECTION_WAY_WECHAT:
  178. if(StringUtil.isEmpty(reportOweFeeDo.getOwnerId()) || "-1".equals(reportOweFeeDo.getOwnerId())){
  179. return;
  180. }
  181. if (!StringUtil.isEmpty(reportOweFeeDo.getOwnerId())) {
  182. Map paramInfo = getOwnerAppUserDto(feeCollectionOrderDto.getCommunityId(), reportOweFeeDo.getOwnerId());
  183. resultVo = doSendWechat(reportOweFeeDo, feeCollectionOrderDto, paramInfo);//微信
  184. feeCollectionDetailPo.setCollectionWay(FeeCollectionOrderDto.COLLECTION_WAY_WECHAT);
  185. }
  186. break;
  187. case FeeCollectionOrderDto.COLLECTION_WAY_WECHAT_SMS:
  188. resultVo = doSendWechatOrSms(reportOweFeeDo, feeCollectionOrderDto, feeCollectionDetailPo);//短信或者微信
  189. break;
  190. }
  191. logger.info("微信模板返回内容:{}", resultVo);
  192. if (resultVo != null) {
  193. feeCollectionDetailPo.setCollectionName(feeCollectionOrderDto.getCollectionName());
  194. feeCollectionDetailPo.setCommunityId(feeCollectionOrderDto.getCommunityId());
  195. feeCollectionDetailPo.setDetailId(GenerateCodeFactory.getGeneratorId(GenerateCodeFactory.CODE_PREFIX_detailId));
  196. feeCollectionDetailPo.setFeeName(feeCollectionOrderDto.getCollectionName() + "欠费");
  197. feeCollectionDetailPo.setOrderId(feeCollectionOrderDto.getOrderId());
  198. feeCollectionDetailPo.setOweAmount(reportOweFeeDo.getAmountOwed());
  199. feeCollectionDetailPo.setOwnerId(reportOweFeeDo.getOwnerId());
  200. feeCollectionDetailPo.setOwnerName(reportOweFeeDo.getOwnerName());
  201. feeCollectionDetailPo.setPayerObjId(reportOweFeeDo.getPayerObjId());
  202. feeCollectionDetailPo.setPayerObjName(reportOweFeeDo.getPayerObjName());
  203. feeCollectionDetailPo.setPayerObjType(reportOweFeeDo.getPayerObjType());
  204. feeCollectionDetailPo.setState(resultVo.getCode() == ResultVo.CODE_OK ? FeeCollectionOrderDto.STATE_FINISH : FeeCollectionOrderDto.STATE_ERROR);
  205. feeCollectionDetailPo.setRemarks(resultVo.getMsg().length() > 512 ? resultVo.getMsg().substring(0, 450) : resultVo.getMsg());
  206. feeCollectionDetailInnerServiceSMOImpl.saveFeeCollectionDetail(feeCollectionDetailPo);
  207. }
  208. }
  209. /**
  210. * 微信或者 短信推送
  211. *
  212. * @param reportOweFeeDo
  213. * @param feeCollectionOrderDto
  214. */
  215. private ResultVo doSendWechatOrSms(ReportOweFeeDto reportOweFeeDo, FeeCollectionOrderDto feeCollectionOrderDto, FeeCollectionDetailPo feeCollectionDetailPo) {
  216. Map paramInfo = getOwnerAppUserDto(feeCollectionOrderDto.getCommunityId(), reportOweFeeDo.getOweId());
  217. if (paramInfo == null) {
  218. feeCollectionDetailPo.setCollectionWay(FeeCollectionOrderDto.COLLECTION_WAY_SMS);
  219. return doSendSms(reportOweFeeDo, feeCollectionOrderDto);//短信推送
  220. }
  221. feeCollectionDetailPo.setCollectionWay(FeeCollectionOrderDto.COLLECTION_WAY_WECHAT);
  222. return doSendWechat(reportOweFeeDo, feeCollectionOrderDto, paramInfo);//微信推送
  223. }
  224. /**
  225. * 微信方式推送
  226. *
  227. * @param reportOweFeeDo
  228. * @param feeCollectionOrderDto
  229. */
  230. private ResultVo doSendWechat(ReportOweFeeDto reportOweFeeDo, FeeCollectionOrderDto feeCollectionOrderDto) {
  231. Map paramInfo = getOwnerAppUserDto(feeCollectionOrderDto.getCommunityId(), reportOweFeeDo.getOwnerId());
  232. if (paramInfo == null) {
  233. return new ResultVo(ResultVo.CODE_ERROR, "业主未绑定");
  234. }
  235. return doSendWechat(reportOweFeeDo, feeCollectionOrderDto, paramInfo);
  236. }
  237. /**
  238. * 微信方式推送
  239. *
  240. * @param reportOweFeeDo
  241. * @param feeCollectionOrderDto
  242. */
  243. private ResultVo doSendWechat(ReportOweFeeDto reportOweFeeDo, FeeCollectionOrderDto feeCollectionOrderDto, Map paramInfo) {
  244. if (paramInfo == null) {
  245. return new ResultVo(ResultVo.CODE_ERROR, "业主未绑定");
  246. }
  247. String templateId = paramInfo.get("templateId").toString();
  248. String url = paramInfo.get("url").toString();
  249. String oweRoomUrl = paramInfo.get("oweRoomUrl").toString();
  250. String oweCarUrl = paramInfo.get("oweCarUrl").toString();
  251. SmallWeChatDto weChatDto = (SmallWeChatDto) paramInfo.get("weChatDto");
  252. Miniprogram miniprogram = paramInfo.get("miniprogram") == null ? null : (Miniprogram) paramInfo.get("miniprogram");
  253. List<OwnerAppUserDto> ownerAppUserDtos = (List<OwnerAppUserDto>) paramInfo.get("ownerAppUserDtos");
  254. List<ReportOweFeeItemDto> itemDtos = reportOweFeeDo.getItems();
  255. String oweUrl = "";
  256. for (ReportOweFeeItemDto itemDto : itemDtos) {
  257. BigDecimal amountOwed = new BigDecimal(itemDto.getAmountOwed());
  258. oweUrl = FeeDto.PAYER_OBJ_TYPE_ROOM.equals(reportOweFeeDo.getPayerObjType()) ? oweRoomUrl : oweCarUrl;
  259. String[] roomName = new String[]{};
  260. if ("3333".equals(reportOweFeeDo.getPayerObjType())) {
  261. roomName = itemDto.getPayerObjName().split("-",3);
  262. }
  263. for (OwnerAppUserDto appUserDto : ownerAppUserDtos) {
  264. try {
  265. //获取用户缴费到期时间
  266. Date endTime = itemDto.getEndTime();
  267. Calendar calendar = Calendar.getInstance();
  268. calendar.setTime(endTime);
  269. calendar.add(Calendar.DATE, -1);
  270. endTime = calendar.getTime();
  271. Data data = new Data();
  272. PropertyFeeTemplateMessage templateMessage = new PropertyFeeTemplateMessage();
  273. templateMessage.setTemplate_id(templateId);
  274. templateMessage.setTouser(appUserDto.getOpenId());
  275. data.setFirst(new Content(itemDto.getFeeName() + "提醒"));
  276. if ("3333".equals(reportOweFeeDo.getPayerObjType())) {
  277. data.setKeyword1(new Content(roomName[0] + "栋" + roomName[1] + "单元" + roomName[2] + "室"));
  278. } else {
  279. data.setKeyword1(new Content(itemDto.getPayerObjName()));
  280. }
  281. DecimalFormat df = new DecimalFormat("0.00");
  282. data.setKeyword2(new Content(df.format(amountOwed) + "元"));
  283. data.setKeyword3(new Content(
  284. DateUtil.getFormatTimeString(itemDto.getStartTime(), DateUtil.DATE_FORMATE_STRING_B)
  285. + "至"
  286. + DateUtil.getFormatTimeString(endTime, DateUtil.DATE_FORMATE_STRING_B)));
  287. data.setRemark(new Content("请您及时缴费,如有疑问请联系相关物业人员!"));
  288. if (!StringUtil.isEmpty(oweUrl)) {
  289. if (miniprogram == null) {
  290. templateMessage.setUrl(oweUrl + itemDto.getPayerObjId() + "&wAppId=" + weChatDto.getAppId());
  291. } else {
  292. miniprogram.setPagepath(oweUrl.split("@@")[1] + itemDto.getPayerObjId() + "&wAppId=" + weChatDto.getAppId());
  293. templateMessage.setMiniprogram(miniprogram);
  294. }
  295. }
  296. templateMessage.setData(data);
  297. logger.info("发送模板消息内容:{}", JSON.toJSONString(templateMessage));
  298. ResponseEntity<String> responseEntity = outRestTemplate.postForEntity(url, JSON.toJSONString(templateMessage), String.class);
  299. logger.info("微信模板返回内容:{}", responseEntity);
  300. } catch (Exception e) {
  301. LogSystemErrorPo logSystemErrorPo = new LogSystemErrorPo();
  302. logSystemErrorPo.setErrId(GenerateCodeFactory.getGeneratorId(GenerateCodeFactory.CODE_PREFIX_errId));
  303. logSystemErrorPo.setErrType(LogSystemErrorDto.ERR_TYPE_OWE_FEE);
  304. logSystemErrorPo.setMsg(ExceptionUtil.getStackTrace(e));
  305. saveSystemErrorSMOImpl.saveLog(logSystemErrorPo);
  306. logger.error("欠费推送失败" + feeCollectionOrderDto.getCollectionName(), e);
  307. }
  308. }
  309. }
  310. return new ResultVo(ResultVo.CODE_OK, ResultVo.MSG_OK);
  311. }
  312. /**
  313. * 短信方式推送
  314. *
  315. * @param reportOweFeeDo
  316. * @param feeCollectionOrderDto
  317. */
  318. private ResultVo doSendSms(ReportOweFeeDto reportOweFeeDo, FeeCollectionOrderDto feeCollectionOrderDto) {
  319. SmsConfigDto smsConfigDto = new SmsConfigDto();
  320. smsConfigDto.setObjId(feeCollectionOrderDto.getCommunityId());
  321. smsConfigDto.setSmsBusi(SmsConfigDto.SMS_BUSI_OWE);
  322. List<SmsConfigDto> smsConfigDtos = smsConfigInnerServiceSMOImpl.querySmsConfigs(smsConfigDto);
  323. if (smsConfigDtos == null || smsConfigDtos.size() < 1) {
  324. return new ResultVo(ResultVo.CODE_ERROR, "未配置短信信息");
  325. }
  326. Object paramIn = null;
  327. List<ReportOweFeeItemDto> itemDtos = reportOweFeeDo.getItems();
  328. //获取用户缴费到期时间
  329. Date endTime = itemDtos.get(0).getEndTime();
  330. Calendar calendar = Calendar.getInstance();
  331. calendar.setTime(endTime);
  332. calendar.add(Calendar.DATE, -1);
  333. endTime = calendar.getTime();
  334. SmsConfigDto smsConfigDto1 = BeanConvertUtil.covertBean(smsConfigDtos.get(0), SmsConfigDto.class);
  335. // 尊敬的业主${user},您${house}的${feeType},账单日期${date}至${date2},缴费金额:${mount}元,请及时缴费
  336. if ("ALI".equals(smsConfigDto1.getSmsType())) {
  337. JSONObject param = new JSONObject();
  338. param.put("user", reportOweFeeDo.getOwnerName());
  339. param.put("house", reportOweFeeDo.getPayerObjName());
  340. param.put("feeType", itemDtos.get(0).getFeeName());
  341. param.put("date", DateUtil.getFormatTimeString(itemDtos.get(0).getStartTime(), DateUtil.DATE_FORMATE_STRING_B));
  342. param.put("date2", DateUtil.getFormatTimeString(endTime, DateUtil.DATE_FORMATE_STRING_B));
  343. param.put("mount", reportOweFeeDo.getAmountOwed());
  344. paramIn = param;
  345. } else {
  346. paramIn = new String[]{
  347. reportOweFeeDo.getOwnerName(),
  348. reportOweFeeDo.getPayerObjName(),
  349. reportOweFeeDo.getAmountOwed()
  350. };
  351. }
  352. OwnerDto ownerDto = new OwnerDto();
  353. ownerDto.setCommunityId(feeCollectionOrderDto.getCommunityId());
  354. ownerDto.setOwnerId(reportOweFeeDo.getOwnerId());
  355. List<OwnerDto> ownerDtos = ownerInnerServiceSMOImpl.queryOwners(ownerDto);
  356. if (ownerDtos == null || ownerDtos.size() < 1) {
  357. return new ResultVo(ResultVo.CODE_ERROR, "业主不存在");
  358. }
  359. ResultVo resultVo = null;
  360. for (OwnerDto ownerDto1 : ownerDtos) {
  361. resultVo = SendSmsFactory.sendOweFeeSms(ownerDto1.getLink(), smsConfigDto1, paramIn);
  362. }
  363. return resultVo;
  364. }
  365. private Map getOwnerAppUserDto(String communityId, String memberId) {
  366. SmallWeChatDto smallWeChatDto = new SmallWeChatDto();
  367. smallWeChatDto.setWeChatType("1100");
  368. smallWeChatDto.setObjType(SmallWeChatDto.OBJ_TYPE_COMMUNITY);
  369. smallWeChatDto.setObjId(communityId);
  370. List<SmallWeChatDto> smallWeChatDtos = smallWeChatInnerServiceSMOImpl.querySmallWeChats(smallWeChatDto);
  371. if (smallWeChatDto == null || smallWeChatDtos.size() <= 0) {
  372. logger.info("未配置微信公众号信息,定时任务执行结束");
  373. return null;
  374. }
  375. SmallWeChatDto weChatDto = smallWeChatDtos.get(0);
  376. SmallWechatAttrDto smallWechatAttrDto = new SmallWechatAttrDto();
  377. smallWechatAttrDto.setCommunityId(communityId);
  378. smallWechatAttrDto.setWechatId(weChatDto.getWeChatId());
  379. smallWechatAttrDto.setSpecCd(SmallWechatAttrDto.SPEC_CD_OWE_FEE_TEMPLATE);
  380. List<SmallWechatAttrDto> smallWechatAttrDtos = smallWechatAttrInnerServiceSMOImpl.querySmallWechatAttrs(smallWechatAttrDto);
  381. if (smallWechatAttrDtos == null || smallWechatAttrDtos.size() <= 0) {
  382. logger.info("未配置微信公众号消息模板");
  383. return null;
  384. }
  385. String templateId = smallWechatAttrDtos.get(0).getValue();
  386. String accessToken = WechatFactory.getAccessToken(weChatDto.getAppId(), weChatDto.getAppSecret());
  387. if (StringUtil.isEmpty(accessToken)) {
  388. logger.info("推送微信模板,获取accessToken失败:{}", accessToken);
  389. return null;
  390. }
  391. //根据小区id查询业主与公众号绑定信息
  392. OwnerAppUserDto ownerAppUserDto = new OwnerAppUserDto();
  393. ownerAppUserDto.setCommunityId(weChatDto.getObjId());
  394. ownerAppUserDto.setAppType(OwnerAppUserDto.APP_TYPE_WECHAT);
  395. ownerAppUserDto.setMemberId(memberId);
  396. List<OwnerAppUserDto> ownerAppUserDtos = ownerAppUserInnerServiceSMOImpl.queryOwnerAppUsers(ownerAppUserDto);
  397. if (ownerAppUserDtos == null || ownerAppUserDtos.size() < 1) {
  398. return null;
  399. }
  400. String sendTemplate = MappingCache.getValue(WechatConstant.WECHAT_DOMAIN, WechatConstant.SEND_TEMPLATE_URL);
  401. if (StringUtil.isEmpty(sendTemplate)) {
  402. sendTemplate = sendMsgUrl;
  403. }
  404. String url = sendTemplate + accessToken;
  405. String oweRoomUrl = MappingCache.getValue(WechatConstant.WECHAT_DOMAIN, WechatConstant.OWE_FEE_PAGE);
  406. String oweCarUrl = MappingCache.getValue(WechatConstant.WECHAT_DOMAIN, WechatConstant.OWE_CAR_FEE_PAGE);
  407. Miniprogram miniprogram = null;
  408. if (oweRoomUrl.contains("@@")) {
  409. miniprogram = new Miniprogram();
  410. miniprogram.setAppid(oweRoomUrl.split("@@")[0]);
  411. }
  412. //车辆费用
  413. if (oweCarUrl.contains("@@")) {
  414. miniprogram = new Miniprogram();
  415. miniprogram.setAppid(oweCarUrl.split("@@")[0]);
  416. }
  417. Map paramInfo = new HashMap();
  418. paramInfo.put("templateId", templateId);
  419. paramInfo.put("url", url);
  420. paramInfo.put("miniprogram", miniprogram);
  421. paramInfo.put("oweCarUrl", oweCarUrl);
  422. paramInfo.put("oweRoomUrl", oweRoomUrl);
  423. paramInfo.put("ownerAppUserDtos", ownerAppUserDtos);
  424. paramInfo.put("weChatDto", weChatDto);
  425. return paramInfo;
  426. }
  427. private void refreshReportOwe(List<ReportOweFeeDto> oldReportOweFeeDtos) {
  428. List<String> payObjIds = new ArrayList<>();
  429. if (oldReportOweFeeDtos == null || oldReportOweFeeDtos.size() < 1) {
  430. return;
  431. }
  432. for (ReportOweFeeDto reportOweFeeDto : oldReportOweFeeDtos) {
  433. payObjIds.add(reportOweFeeDto.getPayerObjId());
  434. }
  435. ReportOweFeeDto reportOweFeeDto = new ReportOweFeeDto();
  436. reportOweFeeDto.setPayerObjIds(payObjIds.toArray(new String[payObjIds.size()]));
  437. reportOweFeeDto.setHasOweFee("Y");
  438. List<ReportOweFeeDto> allReportOweFeeDtos = reportOweFeeInnerServiceSMOImpl.queryReportAllOweFees(reportOweFeeDto);
  439. List<ReportOweFeeDto> reportOweFeeDtos = new ArrayList<>();
  440. for (ReportOweFeeDto reportOweFee : allReportOweFeeDtos) {
  441. ReportOweFeeDto reportOwe = new ReportOweFeeDto();
  442. reportOwe.setOweId(reportOweFee.getOweId());
  443. reportOwe.setHasOweFee("Y");
  444. reportOweFee.setPayerObjType(reportOweFee.getPayerObjType());
  445. if (reportOweFee.getPayerObjType().equals("3333")) {
  446. List<ReportOweFeeDto> reportOweFees = reportOweFeeInnerServiceSMOImpl.queryReportAllOweFeesByRoom(reportOwe);
  447. reportOweFee.setOweId(reportOweFees.get(0).getOweId());
  448. reportOweFee.setOwnerId(reportOweFees.get(0).getOwnerId());
  449. reportOweFee.setOwnerName(reportOweFees.get(0).getOwnerName());
  450. } else if (reportOweFee.getPayerObjType().equals("6666")) {
  451. List<ReportOweFeeDto> reportOweFees = reportOweFeeInnerServiceSMOImpl.queryReportAllOweFeesByCar(reportOwe);
  452. reportOweFee.setOweId(reportOweFees.get(0).getOweId());
  453. reportOweFee.setOwnerId(reportOweFees.get(0).getOwnerId());
  454. reportOweFee.setOwnerName(reportOweFees.get(0).getOwnerName());
  455. }
  456. reportOweFeeDtos.add(reportOweFee);
  457. }
  458. for (ReportOweFeeDto tmpReportOweFeeDto : oldReportOweFeeDtos) {
  459. dealItem(tmpReportOweFeeDto, reportOweFeeDtos);
  460. }
  461. }
  462. private void dealItem(ReportOweFeeDto oldReportOweFeeDto, List<ReportOweFeeDto> allReportOweFeeDtos) {
  463. List<ReportOweFeeItemDto> items = new ArrayList<>();
  464. if (allReportOweFeeDtos == null || allReportOweFeeDtos.size() < 1) {
  465. return;
  466. }
  467. ReportOweFeeItemDto reportOweFeeItemDto = null;
  468. for (ReportOweFeeDto reportOweFeeDto : allReportOweFeeDtos) {
  469. if (!oldReportOweFeeDto.getPayerObjId().equals(reportOweFeeDto.getPayerObjId())) {
  470. continue;
  471. }
  472. reportOweFeeItemDto = hasItem(items, reportOweFeeDto.getConfigId());
  473. if (reportOweFeeItemDto == null) {
  474. reportOweFeeItemDto = new ReportOweFeeItemDto();
  475. reportOweFeeItemDto.setConfigId(reportOweFeeDto.getConfigId());
  476. reportOweFeeItemDto.setFeeName(reportOweFeeDto.getFeeName());
  477. reportOweFeeItemDto.setAmountOwed(reportOweFeeDto.getAmountOwed());
  478. reportOweFeeItemDto.setPayerObjId(reportOweFeeDto.getPayerObjId());
  479. reportOweFeeItemDto.setPayerObjName(reportOweFeeDto.getPayerObjName());
  480. reportOweFeeItemDto.setConfigName(reportOweFeeDto.getConfigName());
  481. try {
  482. reportOweFeeItemDto.setStartTime(DateUtil.getDateFromString(reportOweFeeDto.getEndTime(), DateUtil.DATE_FORMATE_STRING_A));
  483. reportOweFeeItemDto.setEndTime(DateUtil.getDateFromString(reportOweFeeDto.getDeadlineTime(), DateUtil.DATE_FORMATE_STRING_A));
  484. } catch (ParseException e) {
  485. e.printStackTrace();
  486. }
  487. items.add(reportOweFeeItemDto);
  488. } else {
  489. BigDecimal oldAmount = new BigDecimal(Double.parseDouble(reportOweFeeItemDto.getAmountOwed()));
  490. oldAmount = oldAmount.add(new BigDecimal(Double.parseDouble(reportOweFeeDto.getAmountOwed()))).setScale(2, BigDecimal.ROUND_HALF_EVEN);
  491. reportOweFeeItemDto.setAmountOwed(oldAmount.doubleValue() + "");
  492. }
  493. if (!StringUtil.isEmpty(reportOweFeeDto.getOwnerName()) && StringUtil.isEmpty(oldReportOweFeeDto.getOwnerName())) {
  494. oldReportOweFeeDto.setOwnerName(reportOweFeeDto.getOwnerName());
  495. }
  496. if (!StringUtil.isEmpty(reportOweFeeDto.getOwnerId()) && StringUtil.isEmpty(oldReportOweFeeDto.getOwnerId())) {
  497. oldReportOweFeeDto.setOwnerId(reportOweFeeDto.getOwnerId());
  498. }
  499. if (!StringUtil.isEmpty(reportOweFeeDto.getPayerObjType()) && StringUtil.isEmpty(oldReportOweFeeDto.getPayerObjType())) {
  500. oldReportOweFeeDto.setPayerObjType(reportOweFeeDto.getPayerObjType());
  501. }
  502. oldReportOweFeeDto.setUpdateTime(reportOweFeeDto.getUpdateTime());
  503. oldReportOweFeeDto.setConfigName(reportOweFeeDto.getConfigName());
  504. }
  505. //计算总金额
  506. BigDecimal totalAmount = new BigDecimal(0);
  507. Date startTime = null;
  508. Date endTime = null;
  509. for (ReportOweFeeItemDto tempReportOweFeeItemDto : items) {
  510. if (startTime == null) {
  511. startTime = tempReportOweFeeItemDto.getStartTime();
  512. }
  513. if (startTime.getTime() > tempReportOweFeeItemDto.getStartTime().getTime()) {
  514. startTime = tempReportOweFeeItemDto.getStartTime();
  515. }
  516. if (endTime == null) {
  517. endTime = tempReportOweFeeItemDto.getEndTime();
  518. }
  519. if (endTime.getTime() < tempReportOweFeeItemDto.getEndTime().getTime()) {
  520. endTime = tempReportOweFeeItemDto.getEndTime();
  521. }
  522. totalAmount = totalAmount.add(new BigDecimal(Double.parseDouble(tempReportOweFeeItemDto.getAmountOwed()))).setScale(2, BigDecimal.ROUND_HALF_EVEN);
  523. }
  524. oldReportOweFeeDto.setEndTime(DateUtil.getFormatTimeString(startTime, DateUtil.DATE_FORMATE_STRING_A));
  525. oldReportOweFeeDto.setDeadlineTime(DateUtil.getFormatTimeString(endTime, DateUtil.DATE_FORMATE_STRING_A));
  526. oldReportOweFeeDto.setItems(items);
  527. oldReportOweFeeDto.setPayerObjName(items.get(0).getPayerObjName());
  528. oldReportOweFeeDto.setAmountOwed(totalAmount.doubleValue() + "");
  529. }
  530. private ReportOweFeeItemDto hasItem(List<ReportOweFeeItemDto> reportOweFeeItemDtos, String configId) {
  531. if (reportOweFeeItemDtos == null || reportOweFeeItemDtos.size() < 1) {
  532. return null;
  533. }
  534. for (ReportOweFeeItemDto reportOweFeeItemDto : reportOweFeeItemDtos) {
  535. if (reportOweFeeItemDto.getConfigId().equals(configId)) {
  536. return reportOweFeeItemDto;
  537. }
  538. }
  539. return null;
  540. }
  541. }