DistributePopularizeController.java 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337
  1. package com.cyksj.web.controller.user;
  2. import cn.hutool.core.date.DateTime;
  3. import cn.hutool.core.date.DateUtil;
  4. import cn.hutool.core.util.StrUtil;
  5. import cn.hutool.extra.qrcode.QrCodeUtil;
  6. import cn.hutool.extra.qrcode.QrConfig;
  7. import com.baomidou.mybatisplus.core.toolkit.Wrappers;
  8. import com.cyksj.common.EnvCommonService;
  9. import com.cyksj.common.annotation.NoSubmit;
  10. import com.cyksj.common.exception.BusinessRuntimeException;
  11. import com.cyksj.common.util.ValidatorUtil;
  12. import com.cyksj.config.wxlogin.WxOpenPlatYHLXLoginConfig;
  13. import com.cyksj.dto.Result;
  14. import com.cyksj.enums.GatewayResponse;
  15. import com.cyksj.mapper.GoodsDonMapper;
  16. import com.cyksj.mapper.GoodsDonSkuMapper;
  17. import com.cyksj.mapper.OrderDonMapper;
  18. import com.cyksj.mapper.UserMapper;
  19. import com.cyksj.mapper.manage.coupon.CouponDistributePopularizeMapper;
  20. import com.cyksj.mapper.manage.coupon.CouponMapper;
  21. import com.cyksj.mapper.manage.distribute.DistributeMoneyApplyMapper;
  22. import com.cyksj.mapper.manage.distribute.DistributePointsExchangeMoneyMapper;
  23. import com.cyksj.mapper.manage.distribute.DistributeWaitingSendPointsMapper;
  24. import com.cyksj.mapper.manage.distribute.UserDistributeMapper;
  25. import com.cyksj.model.entity.*;
  26. import com.cyksj.model.request.ApplyMoneyReq;
  27. import com.cyksj.model.views.*;
  28. import com.cyksj.service.distribute.DistributeService;
  29. import com.cyksj.service.pay.TransferFuncService;
  30. import com.cyksj.service.user.UserService;
  31. import com.cyksj.web.util.StpCpsManageUser;
  32. import com.cyksj.web.util.StpUserUtil;
  33. import com.ejlchina.searcher.BeanSearcher;
  34. import com.ejlchina.searcher.SearchResult;
  35. import com.ejlchina.searcher.param.Operator;
  36. import com.ejlchina.searcher.util.MapUtils;
  37. import lombok.RequiredArgsConstructor;
  38. import org.springframework.transaction.annotation.Transactional;
  39. import org.springframework.web.bind.annotation.*;
  40. import javax.servlet.http.HttpServletRequest;
  41. import java.math.BigDecimal;
  42. import java.math.RoundingMode;
  43. import java.util.*;
  44. import java.util.stream.Collectors;
  45. /*
  46. *项目名: netflix
  47. *文件名: DistributePopularizeController
  48. *创建者: JavaZou
  49. *创建时间:2022/11/15 13:59
  50. * 服务端-》我的分发推广controller
  51. */
  52. @RestController
  53. @RequestMapping("/distribute/popularize")
  54. @RequiredArgsConstructor
  55. public class DistributePopularizeController {
  56. private final EnvCommonService envCommonService;
  57. private final UserMapper userMapper;
  58. private final UserService userService;
  59. private final BeanSearcher beanSearcher;
  60. private final GoodsDonMapper goodsDonMapper;
  61. private final GoodsDonSkuMapper goodsDonSkuMapper;
  62. private final DistributePointsExchangeMoneyMapper distributePointsExchangeMoneyMapper;
  63. private final DistributeMoneyApplyMapper distributeMoneyApplyMapper;
  64. private final UserDistributeMapper userDistributeMapper;
  65. private final DistributeWaitingSendPointsMapper distributeWaitingSendPointsMapper;
  66. private final OrderDonMapper orderDonMapper;
  67. private final TransferFuncService transferFuncService;
  68. private final DistributeService distributeService;
  69. private final CouponDistributePopularizeMapper couponDistributePopularizeMapper;
  70. private final CouponMapper couponMapper;
  71. private final WxOpenPlatYHLXLoginConfig wxOpenPlatYHLXLoginConfig;
  72. /**
  73. * 推广订单明细
  74. */
  75. @GetMapping("/orders/detail")
  76. public Result<SearchResult<DistributePopularizeOrdersView>> getOrdersView(HttpServletRequest request) {
  77. Long userId = StpUserUtil.getLoginIdAsLong();
  78. SearchResult<DistributePopularizeOrdersView> search = beanSearcher.search(DistributePopularizeOrdersView.class,
  79. MapUtils.flatBuilder(request.getParameterMap())
  80. .field(DistributePopularizeOrdersView::getSharedId, userId)
  81. .build());
  82. DistributePointsExchangeMoney distributePointsExchangeMoney = distributePointsExchangeMoneyMapper.selectOne(Wrappers.lambdaQuery(DistributePointsExchangeMoney.class).orderByDesc(DistributePointsExchangeMoney::getPoints).last("limit 1"));
  83. BigDecimal points = BigDecimal.valueOf(distributePointsExchangeMoney.getPoints());
  84. BigDecimal money = distributePointsExchangeMoney.getMoney();
  85. BigDecimal oneHundred = BigDecimal.valueOf(100);
  86. search.getDataList().forEach(data -> {
  87. GoodsDon goodsDon = goodsDonMapper.selectById(data.getGoodsId());
  88. GoodsDonSku goodsDonSku = goodsDonSkuMapper.selectById(data.getSkuId());
  89. data.setGoodsTitle(goodsDon.getTitle());
  90. if (goodsDonSku != null) {
  91. data.setSpecVal(goodsDonSku.getSpecVal());
  92. }
  93. data.setWaitGetMoney(data.getPoints().divide(points).multiply(money).divide(oneHundred, 2, RoundingMode.DOWN));
  94. //原先奖励
  95. data.setOriGetMoney(data.getOriPoints().divide(points).multiply(money).divide(oneHundred, 2, RoundingMode.DOWN));
  96. });
  97. return GatewayResponse.SUCCESS.newBuilder().toResult(search);
  98. }
  99. /**
  100. * 提现明细
  101. */
  102. @GetMapping("/applyMoney/detail")
  103. public Result<SearchResult<DistributeMoneyApplyView>> getApplyMoneyView(HttpServletRequest request) {
  104. Long userId = StpUserUtil.getLoginIdAsLong();
  105. SearchResult<DistributeMoneyApplyView> search = beanSearcher.search(DistributeMoneyApplyView.class,
  106. MapUtils.flatBuilder(request.getParameterMap())
  107. .field(DistributeMoneyApplyView::getUserId, userId).op(Operator.Equal)
  108. .build());
  109. return GatewayResponse.SUCCESS.newBuilder().toResult(search);
  110. }
  111. /**
  112. * 个人推广详情
  113. */
  114. @GetMapping("/get/detail")
  115. public Result<DistributePopularizeView> getDetail() {
  116. Long userId = StpUserUtil.getLoginIdAsLong();
  117. User user = userMapper.selectById(userId);
  118. if (StrUtil.isEmpty(user.getShowId())) {
  119. user.setShowId(userService.getUserShowId(userId));
  120. }
  121. DistributePopularizeView distributePopularizeView = new DistributePopularizeView();
  122. String dsUrl = String.format(envCommonService.DISTRIBUTE_DEFAULT_URL_PREFIX, user.getShowId());
  123. distributePopularizeView.setUrl(dsUrl);
  124. // distributePopularizeView.setUrlCode(QrCodeUtil.generateAsBase64(distributePopularizeView.getUrl(), QrConfig.create(), "png"));
  125. distributePopularizeView.setGotPoints(user.getPoints());
  126. Integer orders = userDistributeMapper.count(userId);
  127. distributePopularizeView.setDistributeOrders(orders);
  128. UserDistribute userDistribute = userDistributeMapper.selectOne(Wrappers.lambdaQuery(UserDistribute.class).eq(UserDistribute::getUserId, userId).eq(UserDistribute::getDeleted, 1).select(UserDistribute::getId).last("limit 1"));
  129. if (userDistribute != null) {
  130. //是否是固定推广者
  131. UserDistributeView userDistributeView = beanSearcher.searchFirst(UserDistributeView.class, MapUtils.builder()
  132. .put("dis_id", String.format(" and up.distribute_id = %s", userDistribute.getId()))
  133. .orderBy(UserDistributeView::getRate).desc()
  134. .build());
  135. //最高平台比例
  136. distributePopularizeView.setHighestRate(userDistributeView.getRate());
  137. } else {
  138. GoodsDon goodsDon = goodsDonMapper.selectOne(Wrappers.lambdaQuery(GoodsDon.class).eq(GoodsDon::getDeleted, true).eq(GoodsDon::getStatus, true).orderByDesc(GoodsDon::getRate).select(GoodsDon::getRate).last("limit 1"));
  139. distributePopularizeView.setIsGeneral(true);
  140. distributePopularizeView.setHighestRate(goodsDon.getRate());
  141. Optional.ofNullable(couponDistributePopularizeMapper.selectOne(Wrappers.lambdaQuery(CouponDistributePopularize.class)
  142. .eq(CouponDistributePopularize::getUserId, userId)
  143. .eq(CouponDistributePopularize::getIsGeneral, true)
  144. .eq(CouponDistributePopularize::getDeleted, 1)
  145. .last("limit 1")))
  146. .ifPresent(couponPopularize -> {
  147. Coupon coupon = couponMapper.getCouponById(couponPopularize.getCouponId());
  148. distributePopularizeView.setGeneralCode(couponPopularize.getExCode());
  149. BigDecimal discount = coupon.getDiscount();
  150. String discountStr = String.format("%s折", discount.multiply(BigDecimal.valueOf(100)).intValue());
  151. distributePopularizeView.setGeneralDiscount(discountStr);
  152. });
  153. }
  154. List<DistributeWaitingSendPoints> distributeWaitingSendPoints = distributeWaitingSendPointsMapper.selectList(Wrappers.lambdaQuery(DistributeWaitingSendPoints.class).eq(DistributeWaitingSendPoints::getSendStatus, DistributeWaitingSendPoints.Status.waiting).eq(DistributeWaitingSendPoints::getSharedId, userId).select(DistributeWaitingSendPoints::getPoints));
  155. BigDecimal waitingPoints = BigDecimal.ZERO;
  156. if (!distributeWaitingSendPoints.isEmpty()) {
  157. Optional<BigDecimal> points = distributeWaitingSendPoints.stream().map(DistributeWaitingSendPoints::getPoints).reduce(BigDecimal::add);
  158. if (points.isPresent()) {
  159. waitingPoints = points.get();
  160. }
  161. }
  162. distributePopularizeView.setWaitingSendPoints(waitingPoints);
  163. if (user.getPoints().compareTo(BigDecimal.ZERO) <= 0 && waitingPoints.compareTo(BigDecimal.ZERO) <= 0) {
  164. distributePopularizeView.setGotMoney(BigDecimal.ZERO);
  165. distributePopularizeView.setWaitingMoney(BigDecimal.ZERO);
  166. }else {
  167. DistributePointsExchangeMoney distributePointsExchangeMoney = distributePointsExchangeMoneyMapper.selectOne(Wrappers.lambdaQuery(DistributePointsExchangeMoney.class).orderByDesc(DistributePointsExchangeMoney::getPoints).last("limit 1"));
  168. BigDecimal points = BigDecimal.valueOf(distributePointsExchangeMoney.getPoints());
  169. BigDecimal money = distributePointsExchangeMoney.getMoney();
  170. BigDecimal oneHundred = BigDecimal.valueOf(100);
  171. if (user.getPoints().compareTo(BigDecimal.ZERO) >= 0) {
  172. distributePopularizeView.setGotMoney(user.getPoints().divide(points).multiply(money).divide(oneHundred, 2, RoundingMode.HALF_DOWN));
  173. }
  174. if (user.getPoints().compareTo(BigDecimal.ZERO) >= 0) {
  175. distributePopularizeView.setWaitingMoney(waitingPoints.divide(points).multiply(money).divide(oneHundred, 2, RoundingMode.DOWN));
  176. }
  177. }
  178. return GatewayResponse.SUCCESS.newBuilder().toResult(distributePopularizeView);
  179. }
  180. /**
  181. * 个人推广用户每日订单情况折线图
  182. */
  183. @GetMapping("/get/order/brokenLine")
  184. public Result<BrokenLineObjView> getPersonDistributeBrokenLineView(Long firstDate, Long lastDate) {
  185. Long userId = StpUserUtil.getLoginIdAsLong();
  186. String first = null;
  187. String end = null;
  188. if (firstDate != null) {
  189. first = DateUtil.format(DateTime.of(firstDate), "yyyy-MM-dd");
  190. }
  191. if (lastDate != null) {
  192. end = DateUtil.format(DateTime.of(lastDate), "yyyy-MM-dd");
  193. }
  194. BrokenLineObjView brokenLineObjView = Optional.ofNullable(orderDonMapper.selectPersonDistributeBrokenLine(userId, first, end))
  195. .orElse(new BrokenLineObjView());
  196. if (brokenLineObjView != null) {
  197. List<PersonDistributeBrokenLineView> views = beanSearcher.searchAll(PersonDistributeBrokenLineView.class, MapUtils.builder()
  198. .field(PersonDistributeBrokenLineView::getDate, first, end).op(Operator.Between)
  199. .put("userId", String.format("dw.shared_id = %s", userId))
  200. .orderBy(PersonDistributeBrokenLineView::getDate).asc()
  201. .build());
  202. Map<Long, List<PersonDistributeBrokenLineView>> distributeMap = views.stream().collect(Collectors.groupingBy(PersonDistributeBrokenLineView::getGoodsId));
  203. brokenLineObjView.setDistributeData(distributeMap);
  204. }
  205. return GatewayResponse.SUCCESS.newBuilder().toResult(brokenLineObjView);
  206. }
  207. /**
  208. * 提现
  209. */
  210. @NoSubmit
  211. @PostMapping("/post/applyMoney")
  212. @Transactional(rollbackFor = Throwable.class)
  213. public Result<DistributeMoneyApply> applyMoney(@RequestBody ApplyMoneyReq applyMoneyReq) throws Exception {
  214. Long userId = StpUserUtil.getLoginIdAsLong();
  215. applyMoneyReq.setUserId(userId);
  216. return transferFuncService.distributeApply(applyMoneyReq);
  217. }
  218. /**
  219. * 获取积分兑换门槛
  220. */
  221. @GetMapping("/applyMoney/threshold")
  222. public Result<DistributePointsExchangeMoney> getThreshold() {
  223. Long userId = StpUserUtil.getLoginIdAsLong();
  224. return GatewayResponse.SUCCESS.newBuilder().toResult(distributePointsExchangeMoneyMapper.selectOne(Wrappers.lambdaQuery(DistributePointsExchangeMoney.class).last("limit 1")));
  225. }
  226. /**
  227. * 提现缓存数据
  228. */
  229. @GetMapping("/get/applyMoney/detail")
  230. public Result<DistributeMoneyApply> getLastApplyDetail() {
  231. Long userId = StpUserUtil.getLoginIdAsLong();
  232. DistributeMoneyApply apply = distributeMoneyApplyMapper.selectOne(Wrappers.lambdaQuery(DistributeMoneyApply.class).eq(DistributeMoneyApply::getUserId, userId).orderByDesc(DistributeMoneyApply::getId).last("limit 1"));
  233. return GatewayResponse.SUCCESS.newBuilder().toResult(apply);
  234. }
  235. /**
  236. * 是否是普通分销者
  237. */
  238. @GetMapping("/get/isGeneral/distribute")
  239. public Result<Boolean> isGeneralDistribute() {
  240. Long userId = StpUserUtil.getLoginIdAsLong();
  241. UserDistribute userDistribute = userDistributeMapper.selectOne(Wrappers.lambdaQuery(UserDistribute.class)
  242. .eq(UserDistribute::getDeleted, 1)
  243. .eq(UserDistribute::getUserId, userId));
  244. if (userDistribute != null) {
  245. return GatewayResponse.SUCCESS.newBuilder().toResult(false);
  246. }
  247. return GatewayResponse.SUCCESS.newBuilder().toResult(true);
  248. }
  249. /**
  250. * 普通分销者弹窗
  251. */
  252. @GetMapping("/get/general/distribute/detail")
  253. public Result<DistributePopularizeView> getGeneralDistributeDetail() {
  254. Long userId = StpUserUtil.getLoginIdAsLong();
  255. List<GoodsDon> goodsDons = goodsDonMapper.selectList(Wrappers.lambdaQuery(GoodsDon.class).eq(GoodsDon::getDeleted, true).eq(GoodsDon::getStatus, true).eq(GoodsDon::getType, 1).orderByAsc(GoodsDon::getRate).select(GoodsDon::getRate, GoodsDon::getTitle));
  256. if (goodsDons.isEmpty()) {
  257. return GatewayResponse.SUCCESS.newBuilder().toResult();
  258. }
  259. DistributePopularizeView distributePopularizeView = new DistributePopularizeView();
  260. GoodsDon highestRateGoods = goodsDons.get(goodsDons.size() - 1);
  261. distributePopularizeView.setHighestRate(highestRateGoods.getRate());
  262. Map<Integer, List<GoodsDon>> rateMap = goodsDons.stream().filter(gd -> !gd.getRate().equals(highestRateGoods.getRate())).collect(Collectors.groupingBy(GoodsDon::getRate));
  263. List<DistributeGoodsGeneralRateView> generalDistributes = new ArrayList<>();
  264. rateMap.forEach((rate, v) -> {
  265. DistributeGoodsGeneralRateView rateView = new DistributeGoodsGeneralRateView();
  266. rateView.setRate(rate);
  267. String goodsInfo = v.stream().map(GoodsDon::getTitle).collect(Collectors.joining("/"));
  268. rateView.setGoodsInfo(goodsInfo);
  269. generalDistributes.add(rateView);
  270. });
  271. generalDistributes.sort(Comparator.comparing(DistributeGoodsGeneralRateView::getRate).reversed());
  272. distributePopularizeView.setGeneralDistributes(generalDistributes);
  273. return GatewayResponse.SUCCESS.newBuilder().toResult(distributePopularizeView);
  274. }
  275. /**
  276. * 设置普通推广码
  277. * 绑定个人专属码
  278. */
  279. @PostMapping("/general/code/{code}")
  280. public Result<String> setGeneralCode(@PathVariable("code") String code) {
  281. long userId = StpUserUtil.getLoginIdAsLong();
  282. if (StrUtil.isBlank(code)) {
  283. throw BusinessRuntimeException.getInstance("专属推广优惠码不能为空");
  284. }
  285. if (!ValidatorUtil.isEnNum(code) || code.length() > 20) {
  286. throw BusinessRuntimeException.getInstance("请输入英文数字组合的专属推广优惠码");
  287. }
  288. code = code.trim();
  289. distributeService.bindPopularizeCode(userId, code);
  290. return GatewayResponse.SUCCESS.newBuilder().toResult("设置成功");
  291. }
  292. /**
  293. * 固定推广登录信息
  294. */
  295. @GetMapping("/get/ds/detail")
  296. public Result<String> getDistributeDetail() {
  297. long userId = StpUserUtil.getLoginIdAsLong();
  298. User user = userMapper.selectById(userId);
  299. if (user == null) throw BusinessRuntimeException.getInstance("用户信息不存在");
  300. UserDistribute userDistribute = userDistributeMapper.selectOne(Wrappers.lambdaQuery(UserDistribute.class).eq(UserDistribute::getUserId, user.getId()).eq(UserDistribute::getDeleted, 1).select(UserDistribute::getId).last("limit 1"));
  301. if (userDistribute == null) throw BusinessRuntimeException.getInstance("只支持渠道分销用户登录");
  302. StpCpsManageUser.login(user.getId());
  303. String cpsToken = StpCpsManageUser.getTokenValue();
  304. return GatewayResponse.SUCCESS.newBuilder().toResult(wxOpenPlatYHLXLoginConfig.getCpsWebRedirectUri() + "?t=" + cpsToken);
  305. }
  306. }