SplitAccountService.java 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416
  1. package com.caimei.modules.order.service;
  2. import com.alibaba.fastjson.JSON;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.caimei.modules.order.dao.NewOrderDao;
  5. import com.caimei.modules.order.dao.NewShopOrderDao;
  6. import com.caimei.modules.order.entity.*;
  7. import com.caimei.modules.order.utils.Disguiser;
  8. import com.caimei.redis.RedisService;
  9. import com.caimei.utils.MathUtil;
  10. import com.thinkgem.jeesite.common.service.BaseService;
  11. import okhttp3.*;
  12. import org.apache.commons.lang3.StringUtils;
  13. import org.springframework.stereotype.Service;
  14. import org.springframework.transaction.annotation.Transactional;
  15. import javax.annotation.Resource;
  16. import java.io.IOException;
  17. import java.lang.reflect.Field;
  18. import java.math.BigDecimal;
  19. import java.text.SimpleDateFormat;
  20. import java.util.*;
  21. import java.util.concurrent.TimeUnit;
  22. import java.util.concurrent.atomic.AtomicReference;
  23. import java.util.stream.Collectors;
  24. @Service
  25. @Transactional(readOnly = true)
  26. public class SplitAccountService extends BaseService {
  27. public static OkHttpClient client = new OkHttpClient.Builder()
  28. .connectTimeout(3, TimeUnit.SECONDS)
  29. .readTimeout(20, TimeUnit.SECONDS)
  30. .build();
  31. @Resource
  32. private NewOrderDao newOrderDao;
  33. @Resource
  34. private RedisService redisService;
  35. @Resource
  36. private NewShopOrderDao newShopOrderDao;
  37. @Transactional(readOnly = false, rollbackFor = Exception.class)
  38. public void SplitAccount(String[] shopOrderIds) {
  39. logger.info("【手动分账开始】>>>>>>>>>>手动分账");
  40. Calendar calendar = Calendar.getInstance();
  41. calendar.setTime(new Date());
  42. SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  43. String currentTime = format.format(calendar.getTime());
  44. List<String> ids = new ArrayList<>();
  45. ids = Arrays.stream(shopOrderIds).collect(Collectors.toList());
  46. ids.forEach(i -> {
  47. // 查询未分账已支付收款
  48. List<OrderReceiptRelationPo> orderRelations = newOrderDao.getUndividedPaidReceipt(currentTime, i);
  49. List<SplitAccountPo> splitBillDetail = new ArrayList<>();
  50. AtomicReference<Double> costPrice = new AtomicReference<Double>(0d);
  51. AtomicReference<Double> cmCostPrice = new AtomicReference<Double>(0d);
  52. AtomicReference<Double> organizeCostPrice = new AtomicReference<Double>(0d);
  53. AtomicReference<Double> total = new AtomicReference<Double>(0d);
  54. // 收款对应的订单信息
  55. ShopOrderVo shopOrder = newOrderDao.getShopOrderListByOrderId(Integer.valueOf(i));
  56. for (OrderReceiptRelationPo orderRelation : orderRelations) {
  57. logger.info("【分账】>>>>>>>>>>子订单id:" + orderRelation.getShopOrderId() + "进入分账");
  58. setSplitAccountDetail(costPrice, organizeCostPrice, cmCostPrice, total, shopOrder, orderRelation);
  59. }
  60. if (MathUtil.compare(total, MathUtil.add(MathUtil.add(costPrice, cmCostPrice), organizeCostPrice)) <= 0) {
  61. logger.info("收款总金额不足分帐------------->total: " + total.get()
  62. + "costPrice: " + costPrice.get() + "----------"
  63. + "cmCostPrice: " + cmCostPrice.get() + "-------------"
  64. + "organizeCostPrice: " + organizeCostPrice.get() + "---------------");
  65. return;
  66. }
  67. /**
  68. * 线上订单,付第三方如果不为0,需要从供应商成本中支付
  69. */
  70. double payOther = newOrderDao.findPayOther(Integer.valueOf(i));
  71. if (MathUtil.compare(payOther, 0) > 0) {
  72. SplitAccountPo splitAccount = new SplitAccountPo();
  73. splitAccount.setOrderId(shopOrder.getOrderId());
  74. splitAccount.setShopOrderId(shopOrder.getShopOrderId());
  75. splitAccount.setSplitAccount(payOther);
  76. splitAccount.setProductType(6);
  77. splitAccount.setType(6);
  78. splitAccount.setSubUserNo(Constant.CUSTOMERNUM3);
  79. logger.info("付第三方分账参数------------->" + splitAccount);
  80. splitBillDetail.add(splitAccount);
  81. // 当前版本付第三方从供应商成本支出
  82. costPrice.updateAndGet(v -> MathUtil.sub(v, payOther).doubleValue());
  83. }
  84. if (costPrice.get() > 0) {
  85. SplitAccountPo splitAccount = new SplitAccountPo();
  86. splitAccount.setShopOrderId(shopOrder.getShopOrderId());
  87. splitAccount.setOrderId(shopOrder.getOrderId());
  88. splitAccount.setSplitAccount(costPrice.get());
  89. splitAccount.setProductType(1);
  90. // 该商品设置了商户号
  91. splitAccount.setType(4);
  92. splitAccount.setSubUserNo(shopOrder.getSplitCode());
  93. logger.info("成本分账参数------------->" + splitAccount.toString());
  94. splitBillDetail.add(splitAccount);
  95. }
  96. /** 成本分完,金额未尽,有组织佣金的情况,优先组织佣金
  97. * 当前版本,采美供应商上架丽格商城,会存在三成本均>0的情况
  98. * 若无组织佣金,所有剩余金额归于采美佣金
  99. */
  100. if (organizeCostPrice.get() > 0) {
  101. SplitAccountPo splitAccount = new SplitAccountPo();
  102. splitAccount.setShopOrderId(shopOrder.getShopOrderId());
  103. splitAccount.setOrderId(shopOrder.getOrderId());
  104. splitAccount.setSplitAccount(organizeCostPrice.get());
  105. splitAccount.setProductType(5);
  106. // 该商品设置了商户号
  107. splitAccount.setType(4);
  108. String code = newOrderDao.findSplitCodeByOrganize(shopOrder.getOrganizeId());
  109. if (StringUtils.isBlank(code)) {
  110. logger.info("组织的分帐号未空,无法分帐组织佣金!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!");
  111. return;
  112. }
  113. splitAccount.setSubUserNo(code);
  114. logger.info("组织佣金分账参数------------->" + splitAccount.toString());
  115. splitBillDetail.add(splitAccount);
  116. }
  117. /** 当前版本还要考虑分组织/集团佣金
  118. * 如果还有钱则为佣金,分到网络
  119. */
  120. if (cmCostPrice.get() > 0) {
  121. // 此处不考虑手续费,外部计算总额
  122. SplitAccountPo splitAccount = new SplitAccountPo();
  123. splitAccount.setOrderId(shopOrder.getOrderId());
  124. splitAccount.setShopOrderId(shopOrder.getShopOrderId());
  125. splitAccount.setSplitAccount(cmCostPrice.get());
  126. splitAccount.setProductType(3);
  127. splitAccount.setType(5);
  128. splitAccount.setSubUserNo(Constant.CUSTOMERNUM2);
  129. logger.info("佣金分账参数------------->" + splitAccount);
  130. splitBillDetail.add(splitAccount);
  131. }
  132. HashMap<String, BigDecimal> sbm = new HashMap<>();
  133. for (SplitAccountPo splitAccountPo : splitBillDetail) {
  134. String subUserNo = splitAccountPo.getSubUserNo();
  135. // 计算当前商户号总分账金额
  136. if (sbm.containsKey(subUserNo)) {
  137. BigDecimal v = MathUtil.add(sbm.get(subUserNo), splitAccountPo.getSplitAccount());
  138. sbm.put(subUserNo, v);
  139. } else {
  140. sbm.put(subUserNo, BigDecimal.valueOf(splitAccountPo.getSplitAccount()));
  141. }
  142. // splitcode相同的收款的时候已经是成本已分帐
  143. if (subUserNo.equals(shopOrder.getSplitCode())) {
  144. // 供应商自己收款,此部分金额留在自己商户号,作为成本分账
  145. splitAccountPo.setPayStatus(1);
  146. // 保存分账详情
  147. newOrderDao.insertSplitAccount(splitAccountPo);
  148. }
  149. }
  150. ArrayList<AccountPayOrder.AccountPayOrderExt.SplitBillRule> splitBillRules = new ArrayList<>();
  151. sbm.forEach((key, value) -> {
  152. /**
  153. * 不是自己的splitcode分走,是自己的不动
  154. * 把成本之外的金额加入splitRule分账参数,延续上面逻辑,供应商自己的成本由自己的商户号收款,
  155. * 自己成本部分不需要加入分账参数,仅需在else中做业务表参数处理
  156. */
  157. if (!key.equals(shopOrder.getSplitCode())) {
  158. // 佣金
  159. AccountPayOrder.AccountPayOrderExt.SplitBillRule splitBillRule = new AccountPayOrder.AccountPayOrderExt.SplitBillRule();
  160. // 分账计算的时候未处理手续费,总额处理手续费 x + x * 0.1% = value
  161. BigDecimal div = MathUtil.div(value, 1.001, 2);
  162. if (MathUtil.sub(value, div).doubleValue() < 0.01) {
  163. // 如果手续费小于最低手续费,取0.01
  164. div = MathUtil.round(MathUtil.sub(value, 0.01), 2);
  165. }
  166. splitBillRule.setSplitBillAmount(div);
  167. splitBillRule.setSplitBillMerchantNo(key);
  168. splitBillRules.add(splitBillRule);
  169. } else {
  170. // 修改子订单付款状态及付款金额
  171. newOrderDao.updateShopOrderByPayStatus(Integer.valueOf(i), value.doubleValue(), shopOrder.getPayStatus());
  172. SimpleDateFormat format2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  173. String currentTime2 = format2.format(new Date());
  174. // 保存付款单表
  175. PayShopPo payShop = new PayShopPo();
  176. payShop.setShopId(shopOrder.getShopId());
  177. payShop.setName("线上支付分账");
  178. payShop.setTotalAmount(value.doubleValue());
  179. payShop.setWipePayment(0d);
  180. payShop.setPayType(6);
  181. payShop.setStatus(1);
  182. payShop.setDelFlag(0);
  183. payShop.setApplyTime(currentTime2);
  184. payShop.setReviewTime(currentTime2);
  185. payShop.setPayTime(currentTime2);
  186. newOrderDao.insertPayShop(payShop);
  187. // 保存 付供应商记录
  188. PayShopRecordPo shopRecord = new PayShopRecordPo();
  189. shopRecord.setShopId(shopOrder.getShopId());
  190. shopRecord.setShopOrderId(shopOrder.getShopOrderId());
  191. shopRecord.setShopOrderNo(shopOrder.getShopOrderNo());
  192. shopRecord.setPayAmount(value.doubleValue());
  193. shopRecord.setWipePayment(0d);
  194. shopRecord.setPayType(6);
  195. shopRecord.setPayTime(currentTime2);
  196. shopRecord.setPayShopId(payShop.getId());
  197. shopRecord.setStatus(1);
  198. shopRecord.setDelFlag(0);
  199. newOrderDao.insertPayShopRecord(shopRecord);
  200. // 子订单是否全部付款
  201. List<String> payStatus = newShopOrderDao.findPayStatusByOrderID(shopOrder.getOrderId());
  202. boolean isPay = true;
  203. for (String shops : payStatus) {
  204. if (!"3".equals(shops)) {
  205. isPay = false;
  206. break;
  207. }
  208. }
  209. // 修改主订单付款状态
  210. if (isPay) {
  211. newOrderDao.updateOrderByPayStatus(shopOrder.getOrderId(), 3);
  212. } else {
  213. newOrderDao.updateOrderByPayStatus(shopOrder.getOrderId(), 2);
  214. }
  215. }
  216. });
  217. /**
  218. * 在上述else代码逻辑中已完成成本的业务表参数处理,在分账详情中排除成本,剩余佣金部分在分账结束收到
  219. * 成功返回码时处理(成本不参与分账)
  220. */
  221. splitBillDetail.removeIf(s -> s.getSubUserNo().equals(shopOrder.getSplitCode()));
  222. if (null != splitBillRules && splitBillRules.size() > 0) {
  223. //第三方分账接口
  224. try {
  225. AccountPayOrder accountPayOrder = new AccountPayOrder();
  226. accountPayOrder.setP1_bizType("AccountPaySub");
  227. accountPayOrder.setP2_signType("MD5");
  228. String format1 = new SimpleDateFormat("yyyy-MM-dd_HH:mm:ss.SSS").format(new Date());
  229. accountPayOrder.setP3_timestamp(format1);
  230. String substring = format1.substring(20);
  231. // fz+当前微秒时间+原唯一订单号
  232. accountPayOrder.setP4_orderId("FZ" + substring + shopOrder.getShopOrderId());
  233. //付款账户子订单绑定商户号
  234. accountPayOrder.setP5_customerNumber(shopOrder.getSplitCode());
  235. AccountPayOrder.AccountPayOrderExt accountPayOrderExt = new AccountPayOrder.AccountPayOrderExt();
  236. //收款账户商编 填写splitBillRules时候不填写MerchantNo,Amount并且即使填写这两个参数不生效!!
  237. //accountPayOrderExt.setInMerchantNo(splitMoneyVo.getName());
  238. //accountPayOrderExt.setAmount(splitMoneyVo.getSplitMoney());
  239. accountPayOrderExt.setOrderType(AccountPayOrderType.TRANSFER);
  240. accountPayOrderExt.setServerCallbackUrl(Constant.prodSplit);
  241. accountPayOrderExt.setGoodsName("分账");
  242. if (null != splitBillRules && splitBillRules.size() > 0) {
  243. accountPayOrderExt.setSplitBillRules(splitBillRules);
  244. }
  245. String ext = JSON.toJSONString(accountPayOrderExt);
  246. logger.info("分账规则串json串:" + ext);
  247. accountPayOrder.setP6_ext(ext);
  248. // 生成签名
  249. StringBuilder builder = new StringBuilder();
  250. builder.append(Constant.SPLIT)
  251. .append(accountPayOrder.getP1_bizType()).append(Constant.SPLIT)
  252. .append(accountPayOrder.getP2_signType()).append(Constant.SPLIT)
  253. .append(accountPayOrder.getP3_timestamp()).append(Constant.SPLIT)
  254. .append(accountPayOrder.getP4_orderId()).append(Constant.SPLIT)
  255. .append(accountPayOrder.getP5_customerNumber()).append(Constant.SPLIT)
  256. .append(accountPayOrder.getP6_ext()).append(Constant.SPLIT)
  257. .append(Constant.XUNI);
  258. String sign = Disguiser.disguiseMD5(builder.toString().trim());
  259. Map<String, String> bean = convertBean(accountPayOrder);
  260. logger.info("--------------------> 发送分账参数: " + bean);
  261. Map<String, String> map = postForm(bean, Constant.FZ, sign, Map.class);
  262. logger.info("----------------分账返回数据: " + map.toString());
  263. if (map != null) {
  264. String code = map.get("rt5_retCode");
  265. if (!"0000".equals(code)) {
  266. String msg = map.get("rt6_retMsg");
  267. logger.info("【手动分账】>>>>>>>>>>手动分账失败>>>>>>>msg:" + msg);
  268. } else {
  269. for (SplitAccountPo splitAccount : splitBillDetail) {
  270. splitAccount.setPayStatus(1);
  271. // 保存分账详情
  272. newOrderDao.insertSplitAccount(splitAccount);
  273. }
  274. redisService.remove("XSFZMDS");
  275. logger.info("【手动分账】>>>>>>>>>>此订单分账结束");
  276. }
  277. }
  278. } catch (Exception e) {
  279. logger.error("【手动分账】>>>>>>>>>>错误信息", e);
  280. }
  281. }
  282. });
  283. }
  284. public void setSplitAccountDetail(AtomicReference<Double> costPrice, AtomicReference<Double> organizePrice,
  285. AtomicReference<Double> cmCostPrice, AtomicReference<Double> total,
  286. ShopOrderVo shopOrder, OrderReceiptRelationPo orderRelation) {
  287. // 待分账总金额
  288. double splitAmount = orderRelation.getAssociateAmount();
  289. total.updateAndGet(v -> MathUtil.add(v, splitAmount).doubleValue());
  290. // 总手续费
  291. double procedureFee;
  292. if (12 == orderRelation.getPayType()) {
  293. procedureFee = 10.00;
  294. } else if (17 == orderRelation.getPayType()) {
  295. //b2c 0.2%
  296. procedureFee = MathUtil.mul(splitAmount, 0.002, 2).doubleValue();
  297. //b2c最低手续费0.1
  298. if (procedureFee < 0.1) {
  299. procedureFee = 0.1;
  300. }
  301. } else if (13 == orderRelation.getPayType() || 15 == orderRelation.getPayType()) {
  302. //微信0.65%
  303. procedureFee = MathUtil.mul(splitAmount, 0.0065, 2).doubleValue();
  304. } else if (29 == orderRelation.getPayType()) {
  305. procedureFee = MathUtil.mul(splitAmount, 0.003, 2).doubleValue();
  306. if (procedureFee < 0.1) {
  307. procedureFee = 0.1;
  308. }
  309. } else if (30 == orderRelation.getPayType()) {
  310. procedureFee = MathUtil.mul(splitAmount, 0.006, 2).doubleValue();
  311. if (procedureFee < 0.1) {
  312. procedureFee = 0.1;
  313. }
  314. } else {
  315. //手续费 其他0.25%
  316. procedureFee = MathUtil.mul(splitAmount, 0.0025, 2).doubleValue();
  317. }
  318. if (MathUtil.compare(procedureFee, 0.01) <= 0) {
  319. procedureFee = 0.01;
  320. }
  321. // 商品数据
  322. List<OrderProductVo> orderProductList = newOrderDao.getOrderProductByShopOrderId(shopOrder.getShopOrderId());
  323. for (OrderProductVo orderProduct : orderProductList) {
  324. /** 价格 * 数量
  325. * 前版本为全比例成本,当前版本重新加回固定成本,新增字段cmCostPrice(平台服务费,分帐分采美),organizeCostPrice(组织/集团成本。分帐分组织)
  326. * 在此规则下,分帐方式取cop固定成本值。因存在成本修改,不能取cm_sku实时更新成本!
  327. */
  328. costPrice.updateAndGet(v -> MathUtil.add(v, MathUtil.mul(orderProduct.getCostPrice(), orderProduct.getNum(), 2)).doubleValue());
  329. organizePrice.updateAndGet(v -> MathUtil.add(v, MathUtil.mul(orderProduct.getOrganizeCostPrice(), orderProduct.getNum(), 2)).doubleValue());
  330. cmCostPrice.updateAndGet(v -> MathUtil.add(v, MathUtil.mul(orderProduct.getCmCostPrice(), orderProduct.getNum(), 2)).doubleValue());
  331. }
  332. //手续费承担方 线上支付手续费:默认1采美承担,2供应商承担
  333. Integer supportFlag = newOrderDao.findSupport(shopOrder.getShopOrderId());
  334. if (2 == supportFlag) {
  335. //供应商自己承担手续费
  336. costPrice.set(costPrice.get() - procedureFee);
  337. }
  338. }
  339. public <T> T postForm(Map<String, String> params, String url, String sign, Class<T> clazz) {
  340. FormBody.Builder builder = new FormBody.Builder();
  341. for (Map.Entry<String, String> entry : params.entrySet()) {
  342. builder.add(entry.getKey(), entry.getValue());
  343. }
  344. builder.add("sign", sign);
  345. Request request = new Request.Builder() // okHttp post
  346. .url(url)
  347. .post(builder.build())
  348. .build();
  349. Response response = null;
  350. try {
  351. response = client.newCall(request).execute();
  352. } catch (IOException e) {
  353. throw new IllegalStateException("请求出错", e);
  354. }
  355. if (!response.isSuccessful()) {
  356. try {
  357. logger.info(response.body().string());
  358. } catch (IOException e) {
  359. e.printStackTrace();
  360. }
  361. throw new RuntimeException("请求失败了: http response code: " + response.code());
  362. }
  363. ResponseBody body = response.body();
  364. String content = null;
  365. try {
  366. content = body.string();
  367. } catch (IOException e) {
  368. throw new IllegalStateException("IO异常", e);
  369. }
  370. JSONObject res = JSON.parseObject(content);
  371. if (!res.getBooleanValue("rt4_success")) {
  372. logger.error("error: " + res.getString("rt6_retMsg"));
  373. }
  374. /** rt4_success 为 true,需验签 **/
  375. return res.toJavaObject(clazz);
  376. }
  377. public Map<String, String> convertBean(Object bean) {
  378. Class clazz = bean.getClass();
  379. Field[] fields = clazz.getDeclaredFields();
  380. for (Field f : fields) {
  381. f.setAccessible(true);
  382. }
  383. try {
  384. Map<String, String> retMap = new LinkedHashMap<>();
  385. for (Field f : fields) {
  386. String key = f.toString().substring(f.toString().lastIndexOf(".") + 1);
  387. Object value = f.get(bean);
  388. if (value == null) {
  389. value = "";
  390. }
  391. retMap.put(key, (String) value);
  392. }
  393. return retMap;
  394. } catch (Exception e) {
  395. logger.info("分账", e);
  396. throw new IllegalStateException("分账异常", e);
  397. }
  398. }
  399. }