MemberBalanceLogServiceImpl.java 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256
  1. package com.ydd.module.service.impl;
  2. import com.baomidou.mybatisplus.core.metadata.IPage;
  3. import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
  4. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  5. import com.ydd.common.core.domain.entity.SysUser;
  6. import com.ydd.common.core.page.PageResult;
  7. import com.ydd.common.enums.UserTypeEnums;
  8. import com.ydd.module.domain.*;
  9. import com.ydd.module.dto.MemberBalanceLogDto;
  10. import com.ydd.module.dto.ProfitsMerchantDTO;
  11. import com.ydd.module.dto.RechargeDto;
  12. import com.ydd.module.dto.SystemMemberBalanceLogDto;
  13. import com.ydd.module.enums.LogSourceEnum;
  14. import com.ydd.module.mapper.MemberBalanceLogMapper;
  15. import com.ydd.module.mapper.MemberMapper;
  16. import com.ydd.module.mapper.OrderMapper;
  17. import com.ydd.module.request.AccountFlowListRequest;
  18. import com.ydd.module.service.IAgentService;
  19. import com.ydd.module.service.IMemberService;
  20. import com.ydd.module.service.IProfitsDetailService;
  21. import lombok.RequiredArgsConstructor;
  22. import org.apache.commons.compress.utils.Lists;
  23. import org.springframework.beans.factory.annotation.Autowired;
  24. import org.springframework.stereotype.Service;
  25. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  26. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  27. import com.baomidou.mybatisplus.core.toolkit.Wrappers;
  28. import com.ydd.module.service.IMemberBalanceLogService;
  29. import java.math.BigDecimal;
  30. import java.util.ArrayList;
  31. import java.util.LinkedHashMap;
  32. import java.util.List;
  33. import java.util.stream.Collectors;
  34. /**
  35. * 用户账户明细Service业务层处理
  36. *
  37. * @author douya
  38. * @date 2021-02-01
  39. */
  40. @Service
  41. @RequiredArgsConstructor(onConstructor_ = @Autowired)
  42. public class MemberBalanceLogServiceImpl extends ServiceImpl<MemberBalanceLogMapper, MemberBalanceLog> implements IMemberBalanceLogService {
  43. private final MemberMapper memberMapper;
  44. private final IAgentService iAgentService;
  45. private final IMemberService iMemberService;
  46. private final OrderMapper orderMapper;
  47. private final IProfitsDetailService iProfitsDetailService;
  48. @Override
  49. public List<MemberBalanceLog> queryList(SystemMemberBalanceLogDto memberBalanceLog) {
  50. LambdaQueryWrapper<MemberBalanceLog> lqw = Wrappers.lambdaQuery();
  51. if (memberBalanceLog.getOrderId() != null) {
  52. lqw.eq(MemberBalanceLog::getOrderId, memberBalanceLog.getOrderId());
  53. }
  54. if (CollectionUtils.isNotEmpty(memberBalanceLog.getOrderIds())) {
  55. lqw.in(MemberBalanceLog::getOrderId, memberBalanceLog.getOrderIds());
  56. }
  57. if (memberBalanceLog.getMemberId() != null) {
  58. lqw.eq(MemberBalanceLog::getMemberId, memberBalanceLog.getMemberId());
  59. }
  60. if(memberBalanceLog.getPaymentType() != null) {
  61. lqw.eq(MemberBalanceLog::getPaymentType, memberBalanceLog.getPaymentType());
  62. }
  63. if (memberBalanceLog.getType() != null) {
  64. lqw.eq(MemberBalanceLog::getType, memberBalanceLog.getType());
  65. }
  66. if (memberBalanceLog.getSource() != null) {
  67. lqw.eq(MemberBalanceLog::getSource, memberBalanceLog.getSource());
  68. }
  69. if (memberBalanceLog.getAmount() != null) {
  70. lqw.eq(MemberBalanceLog::getAmount, memberBalanceLog.getAmount());
  71. }
  72. if (memberBalanceLog.getMerchantId() != null) {
  73. lqw.eq(MemberBalanceLog::getMerchantId, memberBalanceLog.getMerchantId());
  74. }
  75. if (memberBalanceLog.getStartTime() != null && memberBalanceLog.getStartTime() != "") {
  76. lqw.ge(MemberBalanceLog::getCreateTime, memberBalanceLog.getStartTime());
  77. }
  78. if (memberBalanceLog.getEndTime() != null && memberBalanceLog.getEndTime() != "") {
  79. lqw.le(MemberBalanceLog::getCreateTime, memberBalanceLog.getEndTime());
  80. }
  81. if (memberBalanceLog.getShowOther()) {
  82. lqw.and(wq -> wq.eq(MemberBalanceLog::getSource, LogSourceEnum.SUBSIDY.getStatus())
  83. .or().eq(MemberBalanceLog::getSource, LogSourceEnum.BACK_REFUND.getStatus()));
  84. }
  85. lqw.orderByDesc(MemberBalanceLog::getCreateTime);
  86. List<MemberBalanceLog> logList = this.list(lqw);
  87. // if (memberBalanceLog.getShowOther()) {
  88. for (MemberBalanceLog log : logList) {
  89. if (log.getOrderId() != null) {
  90. Order order = orderMapper.getAllOrderByOrderId(log.getOrderId());
  91. if (order != null) {
  92. log.setOrderSn(order.getOrderSn());
  93. }
  94. }
  95. // 查看自己的佣金
  96. List<ProfitsDetail> profitsDetailList = iProfitsDetailService.getByCommissionId(log.getOrderId());
  97. List<ProfitsDetail> profitsDetail = profitsDetailList.stream().filter(item -> item.getAgentId() != null).collect(Collectors.toList());
  98. if (profitsDetail.size() > 0){
  99. log.setGetCommission(profitsDetail.stream().map(ProfitsDetail::getCommission).reduce(BigDecimal.ZERO, BigDecimal::add));
  100. }
  101. if (log.getMemberId() != null) {
  102. Member member = memberMapper.selectById(log.getMemberId());
  103. if (member != null) {
  104. log.setMobile(member.getMobile());
  105. }
  106. }
  107. }
  108. // }
  109. return logList;
  110. }
  111. @Override
  112. public void updateMemberBalanceLog(Long memberId, BigDecimal amount, Integer source, Integer type, String desc,Long merchantId, Integer paymentType) {
  113. MemberBalanceLog memberBalanceLog = new MemberBalanceLog();
  114. memberBalanceLog.setMemberId(memberId);
  115. memberBalanceLog.setAmount(amount);
  116. memberBalanceLog.setType(type);
  117. memberBalanceLog.setSource(source);
  118. memberBalanceLog.setRemark(desc);
  119. memberBalanceLog.setMerchantId(merchantId);
  120. memberBalanceLog.setPaymentType(paymentType);
  121. baseMapper.insert(memberBalanceLog);
  122. memberMapper.updateMemberBalance(memberId, amount, type);
  123. }
  124. @Override
  125. public BigDecimal countNumByType(Long memberId, Integer type) {
  126. return baseMapper.countNumByType(memberId, type);
  127. }
  128. @Override
  129. public BigDecimal sumNumAmountByMemberId(Long merchantId, Integer source, ProfitsMerchant profitsMerchant) {
  130. return baseMapper.sumNumAmountByMemberId(merchantId, source, profitsMerchant);
  131. }
  132. @Override
  133. public BigDecimal sumNumAmountDtoByMemberId(Long merchantId, Integer source, ProfitsMerchantDTO profitsMerchantDTO) {
  134. return baseMapper.sumNumAmountDtoByMemberId(merchantId, source, profitsMerchantDTO);
  135. }
  136. @Override
  137. public BigDecimal sumNumAmountById(Long memberId, Integer source) {
  138. return baseMapper.sumNumAmountById(memberId, source);
  139. }
  140. @Override
  141. public List<MemberBalanceLog> getMyLogs(Long memberId, Integer source, String time,Long shopId) {
  142. // QueryWrapper<MemberBalanceLog> wrapper = new QueryWrapper<>();
  143. // memberId = 1L;
  144. // wrapper.eq("member_id", memberId);
  145. // wrapper.orderByDesc("create_time");
  146. List<MemberBalanceLog> balanceLogs = baseMapper.findLogs(memberId, source, time,shopId);
  147. balanceLogs.forEach(item -> {
  148. if (LogSourceEnum.BACK_REFUND.getStatus().equals(item.getSource())) {
  149. item.setRemark("取消订单退款");
  150. }
  151. if (LogSourceEnum.SUBSIDY.getStatus().equals(item.getSource())) {
  152. item.setRemark("后台补贴");
  153. }
  154. });
  155. //过滤掉退款金额为0的记录
  156. return balanceLogs;
  157. }
  158. @Override
  159. public void saveLog(Long loginId, Integer type, String desc, Integer source, BigDecimal payAmount,Long merchantId,Long orderId, Integer paymentType) {
  160. MemberBalanceLog log = new MemberBalanceLog();
  161. log.setRemark(desc);
  162. log.setAmount(payAmount);
  163. log.setMemberId(loginId);
  164. log.setSource(source);
  165. log.setType(type);
  166. log.setMerchantId(merchantId);
  167. log.setOrderId(orderId);
  168. log.setPaymentType(paymentType);
  169. baseMapper.insert(log);
  170. }
  171. @Override
  172. public PageResult queryRechargeList(Page page, MemberBalanceLog memberBalanceLog, SysUser user) {
  173. List<Integer> memberIds = new ArrayList<>();
  174. if (user.getType().equals(UserTypeEnums.AGENT.getCode())) {
  175. List<Long> agentIds = iAgentService.listAgent(user.getAgentId());
  176. for (Long agentId : agentIds) {
  177. List<Integer> memberId = iMemberService.selectMemberIdByAgentId(agentId.intValue());
  178. memberIds.addAll(memberId);
  179. }
  180. }
  181. List<MemberBalanceLog> list = baseMapper.queryRechargeList(page, memberBalanceLog, memberIds);
  182. list.stream().forEach(log -> {
  183. Member member = iMemberService.getById(log.getMemberId());
  184. if (member != null && member.getAgentId() != null) {
  185. Agent agent = iAgentService.getById(member.getAgentId());
  186. if (agent != null && agent.getName() != null) {
  187. log.setAgentName(agent.getName());
  188. }
  189. }
  190. });
  191. page.setRecords(list);
  192. return new PageResult(page);
  193. }
  194. @Override
  195. public PageResult queryRechargeDto(Page page, MemberBalanceLog memberBalanceLog, SysUser sysUser) {
  196. List<Integer> memberIds = new ArrayList<>();
  197. List<Long> agents = Lists.newArrayList();
  198. if (sysUser.getType().equals(UserTypeEnums.AGENT.getCode()) && memberBalanceLog.getAgentId() == null) {
  199. List<Long> agentIds = iAgentService.listAgent(sysUser.getAgentId());
  200. for (Long agentId : agentIds) {
  201. List<Integer> memberId = iMemberService.selectMemberIdByAgentId(agentId.intValue());
  202. memberIds.addAll(memberId);
  203. }
  204. }
  205. if (memberBalanceLog.getAgentId() != null) {
  206. agents = iAgentService.listAgent(memberBalanceLog.getAgentId().longValue());
  207. }
  208. // BigDecimal sumPrice=new BigDecimal(0);
  209. List<RechargeDto> list = baseMapper.queryRechargeDto(page, memberBalanceLog, memberIds, agents);
  210. if (list!=null && list.size() > 0) {
  211. for (RechargeDto rechargeDto : list) {
  212. Member member = iMemberService.getById(rechargeDto.getMemberId());
  213. if (member != null && member.getAgentId() != null) {
  214. Agent agent = iAgentService.getById(member.getAgentId());
  215. if (agent != null && agent.getName() != null) {
  216. rechargeDto.setAgentName(agent.getName());
  217. }
  218. }
  219. }
  220. }
  221. page.setRecords(list);
  222. return new PageResult(page);
  223. }
  224. @Override
  225. public Page<MemberBalanceLogDto> getBalanceLogList(AccountFlowListRequest request, Long loginId, List<Long> shopIdList, IPage<MemberBalanceLog> pageArt) {
  226. return baseMapper.getBalanceLogList(request, loginId, shopIdList, pageArt);
  227. }
  228. }