StoreOrderSplitServices.php 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
  8. // +----------------------------------------------------------------------
  9. // | Author: CRMEB Team <admin@crmeb.com>
  10. // +----------------------------------------------------------------------
  11. namespace app\services\order;
  12. use app\services\BaseServices;
  13. use app\dao\order\StoreOrderDao;
  14. use think\exception\ValidateException;
  15. /**
  16. * 订单拆分
  17. * Class StoreOrderSplitServices
  18. * @package app\services\order
  19. */
  20. class StoreOrderSplitServices extends BaseServices
  21. {
  22. /**
  23. * 需要清空恢复默认数据字段
  24. * @var string[]
  25. */
  26. protected $order_data = ['id', 'status', 'refund_status', 'refund_type', 'refund_express', 'refund_reason_wap_img', 'refund_reason_wap_explain', 'refund_reason_time', 'refund_reason_wap', 'refund_reason', 'refund_price', 'delivery_name', 'delivery_code', 'delivery_type', 'delivery_id', 'fictitious_content', 'delivery_uid'];
  27. /**
  28. * 构造方法
  29. * StoreOrderRefundServices constructor.
  30. * @param StoreOrderDao $dao
  31. */
  32. public function __construct(StoreOrderDao $dao)
  33. {
  34. $this->dao = $dao;
  35. }
  36. /**
  37. * 主订单平行拆单
  38. * @param $id
  39. * @param $cart_ids
  40. * @param $orderInfo
  41. * @return false|mixed
  42. * @throws \think\db\exception\DataNotFoundException
  43. * @throws \think\db\exception\DbException
  44. * @throws \think\db\exception\ModelNotFoundException
  45. */
  46. public function equalSplit($id, $cart_ids, $orderInfo)
  47. {
  48. /** @var StoreOrderCreateServices $storeOrderCreateServices */
  49. $storeOrderCreateServices = app()->make(StoreOrderCreateServices::class);
  50. /** @var StoreOrderCartInfoServices $storeOrderCartInfoServices */
  51. $storeOrderCartInfoServices = app()->make(StoreOrderCartInfoServices::class);
  52. /** @var StoreOrderStatusServices $statusService */
  53. $statusService = app()->make(StoreOrderStatusServices::class);
  54. $ids = array_unique(array_column($cart_ids, 'cart_id'));
  55. if (!$cart_ids || !$ids) return false;
  56. if (!$orderInfo) $orderInfo = $this->dao->get($id, ['*']);
  57. if (!$orderInfo) throw new ValidateException('订单未能查到,不能拆分订单!');
  58. $old_order = $orderInfo;
  59. $orderInfo = $orderInfoOld = is_object($orderInfo) ? $orderInfo->toArray() : $orderInfo;
  60. foreach ($this->order_data as $field) {
  61. unset($orderInfo[$field]);
  62. }
  63. unset($orderInfoOld['id']);
  64. //获取拆分之后的两个cart_id
  65. $cartInfo = $storeOrderCartInfoServices->getColumn(['oid' => $id], 'cart_num,surplus_num,cart_info', 'cart_id');
  66. $new_cart_ids = array_combine(array_column($cart_ids, 'cart_id'), $cart_ids);
  67. $other_cart_ids = [];
  68. foreach ($cartInfo as $cart_id => $cart) {
  69. if (!isset($new_cart_ids[$cart_id]) && $cart['surplus_num']) {//无拆分
  70. $other = ['cart_id' => (string)$cart_id, 'cart_num' => $cart['surplus_num']];
  71. } else if ($new_cart_ids[$cart_id]['cart_num'] < $cart['surplus_num']) {
  72. $other = ['cart_id' => (string)$cart_id, 'cart_num' => bcsub((string)$cart['surplus_num'], (string)$new_cart_ids[$cart_id]['cart_num'], 0)];
  73. } else {
  74. continue;
  75. }
  76. $other_cart_ids[] = $other;
  77. }
  78. $cart_ids_arr = ['new' => $cart_ids, 'other' => $other_cart_ids];
  79. if (empty($cart_ids_arr['other'])) return [$old_order, ['id' => 0]];
  80. return $this->transaction(function () use ($id, $cart_ids_arr, $orderInfo, $orderInfoOld, $cartInfo, $storeOrderCreateServices, $storeOrderCartInfoServices, $statusService) {
  81. $order = $otherOrder = [];
  82. $statusData = $statusService->getColumn(['oid' => $id], '*');
  83. //订单实际支付金额
  84. $order_pay_price = bcsub((string)bcadd((string)$orderInfo['total_price'], (string)$orderInfo['pay_postage'], 2), (string)bcadd((string)$orderInfo['deduction_price'], (string)$orderInfo['coupon_price'], 2), 2);
  85. //有改价
  86. $change_price = $order_pay_price != $orderInfo['pay_price'];
  87. foreach ($cart_ids_arr as $key => $cart_ids) {
  88. if ($orderInfo['pid'] == 0 || ($orderInfo['pid'] > 0 && $key == 'new')) {
  89. $order_data = $key == 'other' ? $orderInfoOld : $orderInfo;
  90. $order_data['pid'] = $orderInfo['pid'] > 0 ? $orderInfo['pid'] : $id;
  91. mt_srand();
  92. $order_data['order_id'] = $storeOrderCreateServices->getNewOrderId();
  93. $order_data['cart_id'] = [];
  94. $order_data['unique'] = $storeOrderCreateServices->getNewOrderId('');
  95. $order_data['add_time'] = time();
  96. $new_order = $this->dao->save($order_data);
  97. if (!$new_order) {
  98. throw new ValidateException('生成新订单失败');
  99. }
  100. $new_id = (int)$new_order->id;
  101. $allData = [];
  102. foreach ($statusData as $data) {
  103. $data['oid'] = $new_id;
  104. $allData[] = $data;
  105. }
  106. if ($allData) {
  107. $statusService->saveAll($allData);
  108. }
  109. } else {
  110. $new_id = $id;
  111. }
  112. $statusService->save([
  113. 'oid' => $new_id,
  114. 'change_type' => 'split_create_order',
  115. 'change_message' => '拆分订单生成',
  116. 'change_time' => time()
  117. ]);
  118. $cart_data_all = [];
  119. foreach ($cart_ids as $cart) {
  120. if ($orderInfo['pid'] == 0 || $orderInfo['pid'] > 0 && $key == 'new') {
  121. $_info = is_string($cartInfo[$cart['cart_id']]['cart_info']) ? json_decode($cartInfo[$cart['cart_id']]['cart_info'], true) : $cartInfo[$cart['cart_id']]['cart_info'];
  122. $new_cart_data['oid'] = $new_id;
  123. $new_cart_data['cart_id'] = $storeOrderCreateServices->getNewOrderId('');
  124. $new_cart_data['product_id'] = $_info['product_id'];
  125. $new_cart_data['old_cart_id'] = $cart['cart_id'];
  126. $new_cart_data['cart_num'] = $cart['cart_num'];
  127. $new_cart_data['surplus_num'] = $cart['cart_num'];
  128. $new_cart_data['unique'] = md5($new_cart_data['cart_id'] . '_' . $new_cart_data['oid']);
  129. $_info = $this->slpitComputeOrderCart($new_cart_data['cart_num'], $_info, $key);
  130. $_info['id'] = $new_cart_data['cart_id'];
  131. $new_cart_data['cart_info'] = json_encode($_info);
  132. $cart_data_all[] = $new_cart_data;
  133. } else {
  134. $cart_info = $storeOrderCartInfoServices->get(['cart_id' => $cart['cart_id']]);
  135. $_info = is_string($cartInfo[$cart['cart_id']]['cart_info']) ? json_decode($cartInfo[$cart['cart_id']]['cart_info'], true) : $cartInfo[$cart['cart_id']]['cart_info'];
  136. $cart_info->cart_num = $cart['cart_num'];
  137. $cart_info->refund_num = 0;
  138. $cart_info->surplus_num = $cart['cart_num'];
  139. $_info = $this->slpitComputeOrderCart($cart['cart_num'], $_info, $key);
  140. $_info['id'] = $cart_info['cart_id'];
  141. $cart_info->cart_info = json_encode($_info);
  142. $cart_info->save();
  143. $cart_data_all[] = [
  144. 'oid' => $new_id,
  145. 'cart_id' => $cart_info->cart_id,
  146. 'product_id' => $cart_info->product_id,
  147. 'old_cart_id' => $cart_info->old_cart_id,
  148. 'cart_num' => $cart_info->cart_num,
  149. 'surplus_num' => $cart_info->surplus_num,
  150. 'unique' => $cart_info->unique,
  151. 'cart_info' => json_encode($_info),
  152. ];
  153. }
  154. }
  155. if ($orderInfo['pid'] > 0 && $key == 'other') {
  156. $storeOrderCartInfoServices->delete(['oid' => $new_id]);
  157. }
  158. $storeOrderCartInfoServices->saveAll($cart_data_all);
  159. $new_order = $this->dao->get($new_id);
  160. $storeOrderCartInfoServices->clearOrderCartInfo($new_id);
  161. $this->splitComputeOrder((int)$new_id, $cart_data_all, (float)($change_price ? $order_pay_price : 0), (float)$orderInfo['pay_price'], (float)($new_order['pay_price'] ?? 0));
  162. if ($key == 'new') {
  163. $order = $new_order;
  164. } else {
  165. $otherOrder = $new_order;
  166. }
  167. }
  168. if (!$orderInfo['pid']) $this->dao->update($id, ['pid' => -1]);
  169. //处理申请开票记录
  170. /** @var StoreOrderInvoiceServices $storeOrderInvoiceServics */
  171. $storeOrderInvoiceServics = app()->make(StoreOrderInvoiceServices::class);
  172. $storeOrderInvoiceServics->splitOrderInvoice((int)$id);
  173. return [$order, $otherOrder];
  174. });
  175. }
  176. /**
  177. * 订单拆分
  178. * @param int $id
  179. * @param array $cart_ids
  180. * @param array $orderInfo
  181. * @throws \think\db\exception\DataNotFoundException
  182. * @throws \think\db\exception\DbException
  183. * @throws \think\db\exception\ModelNotFoundException
  184. */
  185. public function split(int $id, array $cart_ids, $orderInfo = [])
  186. {
  187. $ids = array_unique(array_column($cart_ids, 'cart_id'));
  188. if (!$cart_ids || !$ids) {
  189. return false;
  190. }
  191. if (!$orderInfo) {
  192. $orderInfo = $this->dao->get($id, ['*']);
  193. }
  194. if (!$orderInfo) {
  195. throw new ValidateException('订单未能查到,不能拆分订单!');
  196. }
  197. /** @var StoreOrderCreateServices $storeOrderCreateServices */
  198. $storeOrderCreateServices = app()->make(StoreOrderCreateServices::class);
  199. $orderInfo = is_object($orderInfo) ? $orderInfo->toArray() : $orderInfo;
  200. foreach ($this->order_data as $field) {
  201. unset($orderInfo[$field]);
  202. }
  203. $order_data = $orderInfo;
  204. $order_data['pid'] = $id;
  205. mt_srand();
  206. $order_data['order_id'] = $orderInfo['order_id'] . '_' . rand(100, 999);
  207. $order_data['cart_id'] = [];
  208. $order_data['unique'] = $storeOrderCreateServices->getNewOrderId('');
  209. $order_data['add_time'] = time();
  210. $new_order = $this->dao->save($order_data);
  211. if (!$new_order) {
  212. throw new ValidateException('生成新订单失败');
  213. }
  214. $new_id = (int)$new_order->id;
  215. /** @var StoreOrderStatusServices $statusService */
  216. $statusService = app()->make(StoreOrderStatusServices::class);
  217. $statusService->save([
  218. 'oid' => $new_id,
  219. 'change_type' => 'split_create_order',
  220. 'change_message' => '发货拆分订单生成',
  221. 'change_time' => time()
  222. ]);
  223. /** @var StoreOrderCartInfoServices $storeOrderCartInfoServices */
  224. $storeOrderCartInfoServices = app()->make(StoreOrderCartInfoServices::class);
  225. //订单下原商品信息
  226. $cartInfo = $storeOrderCartInfoServices->getColumn(['oid' => $id, 'cart_id' => $ids], 'cart_num,surplus_num,cart_info', 'cart_id');
  227. $cart_data = $cart_data_all = $update_data = [];
  228. $cart_data['oid'] = $new_id;
  229. foreach ($cart_ids as $cart) {
  230. $surplus_num = $cartInfo[$cart['cart_id']]['surplus_num'] ?? 0;
  231. if (!isset($cartInfo[$cart['cart_id']]) || !$surplus_num) continue;
  232. $_info = is_string($cartInfo[$cart['cart_id']]['cart_info']) ? json_decode($cartInfo[$cart['cart_id']]['cart_info'], true) : $cartInfo[$cart['cart_id']]['cart_info'];
  233. $cart_data['cart_id'] = $storeOrderCreateServices->getNewOrderId('');
  234. $cart_data['product_id'] = $_info['product_id'];
  235. $cart_data['old_cart_id'] = $cart['cart_id'];
  236. $cart_data['cart_num'] = $cart['cart_num'];
  237. $cart_data['unique'] = md5($cart_data['cart_id'] . '_' . $cart_data['oid']);
  238. if ($cart['cart_num'] >= $surplus_num) {//拆分完成
  239. $cart_data['cart_num'] = $surplus_num;
  240. $update_data['split_status'] = 2;
  241. $update_data['surplus_num'] = 0;
  242. } else {//拆分部分数量
  243. $update_data['surplus_num'] = bcsub((string)$surplus_num, $cart['cart_num'], 0);
  244. $update_data['split_status'] = $update_data['surplus_num'] > 0 ? 1 : 2;
  245. }
  246. $_info = $this->slpitComputeOrderCart($cart_data['cart_num'], $_info);
  247. $_info['id'] = $cart_data['cart_id'];
  248. $cart_data['cart_info'] = json_encode($_info);
  249. //修改原来订单商品信息
  250. if (false === $storeOrderCartInfoServices->update(['oid' => $id, 'cart_id' => $cart['cart_id']], $update_data)) {
  251. throw new ValidateException('修改原来订单商品拆分状态失败,请稍候重试');
  252. }
  253. $cart_data_all[] = $cart_data;
  254. }
  255. if (!$storeOrderCartInfoServices->saveAll($cart_data_all)) {
  256. throw new ValidateException('新增拆分订单商品信息失败');
  257. }
  258. $new_order = $this->dao->get($new_id);
  259. $this->splitComputeOrder($new_id, $cart_data_all, $new_order);
  260. return $new_order;
  261. }
  262. /**
  263. * 重新计算新订单中价格等信息
  264. * @param int $id
  265. * @param $orderInfo
  266. * @param array $cart_info_data
  267. */
  268. public function splitComputeOrder(int $id, array $cart_info_data, float $order_pay_price = 0.00, float $pay_price = 0.00, float $pre_pay_price = 0.00)
  269. {
  270. $order_update['cart_id'] = array_column($cart_info_data, 'cart_id');
  271. $order_update['total_num'] = array_sum(array_column($cart_info_data, 'cart_num'));
  272. $total_price = $coupon_price = $deduction_price = $use_integral = $pay_postage = $gainIntegral = $one_brokerage = $two_brokerage = $staffBrokerage = $agentBrokerage = $divisionBrokerage = 0;
  273. foreach ($cart_info_data as $cart) {
  274. $_info = json_decode($cart['cart_info'], true);
  275. $total_price = bcadd((string)$total_price, (string)$_info['sum_true_price'], 2);
  276. $deduction_price = bcadd((string)$deduction_price, (string)$_info['integral_price'], 2);
  277. $coupon_price = bcadd((string)$coupon_price, (string)$_info['coupon_price'], 2);
  278. $use_integral = bcadd((string)$use_integral, (string)$_info['use_integral'], 0);
  279. $pay_postage = isset($_info['postage_price']) ? bcadd((string)$pay_postage, (string)$_info['postage_price'], 2) : 0;
  280. $cartInfoGainIntegral = bcmul((string)$cart['cart_num'], (string)($_info['productInfo']['give_integral'] ?? '0'), 0);
  281. $gainIntegral = bcadd((string)$gainIntegral, (string)$cartInfoGainIntegral, 0);
  282. $one_brokerage = bcadd((string)$one_brokerage, (string)$_info['one_brokerage'], 2);
  283. $two_brokerage = bcadd((string)$two_brokerage, (string)$_info['two_brokerage'], 2);
  284. $staffBrokerage = bcadd((string)$staffBrokerage, (string)$_info['staff_brokerage'], 2);
  285. $agentBrokerage = bcadd((string)$agentBrokerage, (string)$_info['agent_brokerage'], 2);
  286. $divisionBrokerage = bcadd((string)$divisionBrokerage, (string)$_info['division_brokerage'], 2);
  287. }
  288. $order_update['coupon_id'] = array_unique(array_column($cart_info_data, 'coupon_id'));
  289. $order_update['pay_price'] = bcadd((string)$total_price, (string)$pay_postage, 2);
  290. //有订单原来支付金额 改价订单
  291. if ($order_pay_price) {
  292. if ($pre_pay_price) {//上一个已经计算 这里减法
  293. $order_update['pay_price'] = bcsub((string)$pay_price, (string)$pre_pay_price, 2);
  294. } else {//按比例计算实际支付金额
  295. $order_update['pay_price'] = bcmul((string)bcdiv((string)$pay_price, (string)$order_pay_price, 4), (string)$order_update['pay_price'], 2);
  296. }
  297. }
  298. $order_update['total_price'] = bcadd((string)$total_price, (string)bcadd((string)$deduction_price, (string)$coupon_price, 2), 2);
  299. $order_update['deduction_price'] = $deduction_price;
  300. $order_update['coupon_price'] = $coupon_price;
  301. $order_update['use_integral'] = $use_integral;
  302. $order_update['gain_integral'] = $gainIntegral;
  303. $order_update['pay_postage'] = $pay_postage;
  304. $order_update['one_brokerage'] = $one_brokerage;
  305. $order_update['two_brokerage'] = $two_brokerage;
  306. $order_update['staff_brokerage'] = $staffBrokerage;
  307. $order_update['agent_brokerage'] = $agentBrokerage;
  308. $order_update['division_brokerage'] = $divisionBrokerage;
  309. if (false === $this->dao->update($id, $order_update, 'id')) {
  310. throw new ValidateException('保存新订单商品信息失败');
  311. }
  312. return true;
  313. }
  314. /**
  315. * 部分发货重新计算订单商品:实际金额、优惠、积分等金额
  316. * @param int $cart_num
  317. * @param array $cart_info
  318. * @return array
  319. */
  320. public function slpitComputeOrderCart(int $cart_num, array $cart_info, $orderType = 'new')
  321. {
  322. if (!$cart_num || !$cart_info) return [];
  323. if ($cart_num >= $cart_info['cart_num']) return $cart_info;
  324. $new_cart_info = $cart_info;
  325. $new_cart_info['cart_num'] = $cart_num;
  326. $compute_arr = ['coupon_price', 'integral_price', 'postage_price', 'use_integral', 'one_brokerage', 'two_brokerage', 'staff_brokerage', 'agent_brokerage', 'division_brokerage', 'sum_true_price'];
  327. foreach ($compute_arr as $field) {
  328. if (!isset($cart_info[$field]) || !$cart_info[$field]) {
  329. $new_cart_info[$field] = 0;
  330. continue;
  331. }
  332. $scale = 2;
  333. if ($field == 'use_integral') $scale = 0;
  334. $new_cart_info[$field] = bcmul((string)$cart_num, bcdiv((string)$cart_info[$field], (string)$cart_info['cart_num'], 4), $scale);
  335. if ($orderType == 'new') {//拆出
  336. $new_cart_info[$field] = bcmul((string)$cart_num, bcdiv((string)$cart_info[$field], (string)$cart_info['cart_num'], 4), $scale);
  337. } else {
  338. $field_number = bcmul((string)bcsub((string)$cart_info['cart_num'], (string)$cart_num, 0), bcdiv((string)$cart_info[$field], (string)$cart_info['cart_num'], 4), $scale);
  339. $new_cart_info[$field] = bcsub((string)$cart_info[$field], (string)$field_number, $scale);
  340. }
  341. }
  342. return $new_cart_info;
  343. }
  344. /**
  345. * 获取整理后的订单商品信息
  346. * @param int $id
  347. * @param array $cart_ids
  348. * @param array $orderInfo
  349. * @return array|false
  350. * @throws \think\db\exception\DataNotFoundException
  351. * @throws \think\db\exception\DbException
  352. * @throws \think\db\exception\ModelNotFoundException
  353. */
  354. public function getSplitOrderCartInfo(int $id, array $cart_ids, $orderInfo = [])
  355. {
  356. $ids = array_unique(array_column($cart_ids, 'cart_id'));
  357. if (!$cart_ids || !$ids) {
  358. return false;
  359. }
  360. if (!$orderInfo) {
  361. $orderInfo = $this->dao->get($id, ['*']);
  362. }
  363. if (!$orderInfo) {
  364. throw new ValidateException('订单未能查到,不能拆分订单!');
  365. }
  366. /** @var StoreOrderCartInfoServices $storeOrderCartInfoServices */
  367. $storeOrderCartInfoServices = app()->make(StoreOrderCartInfoServices::class);
  368. $cartInfo = $storeOrderCartInfoServices->getCartColunm(['oid' => $id, 'cart_id' => $ids], '*', 'cart_id');
  369. $cart_data_all = [];
  370. foreach ($cart_ids as $cart) {
  371. $surplus_num = $cartInfo[$cart['cart_id']]['surplus_num'] ?? 0;
  372. if (!isset($cartInfo[$cart['cart_id']]) || !$surplus_num) continue;
  373. $_info = is_string($cartInfo[$cart['cart_id']]['cart_info']) ? json_decode($cartInfo[$cart['cart_id']]['cart_info'], true) : $cartInfo[$cart['cart_id']]['cart_info'];
  374. $cart_data = $cartInfo[$cart['cart_id']];
  375. $cart_data['oid'] = $id;
  376. $cart_data['product_id'] = $_info['product_id'];
  377. $cart_data['old_cart_id'] = $cart['cart_id'];
  378. $cart_data['cart_num'] = $cart['cart_num'];
  379. $cart_data['surplus_num'] = $cart['cart_num'];
  380. $cart_data['split_surplus_num'] = $cart['cart_num'];
  381. $_info = $this->slpitComputeOrderCart($cart_data['cart_num'], $_info);
  382. $_info['id'] = $cart_data['cart_id'];
  383. $cart_data['cart_info'] = $_info;
  384. $cart_data_all[] = $cart_data;
  385. unset($cartInfo[$cart['cart_id']]);
  386. }
  387. return $cart_data_all;
  388. }
  389. }