StoreOrderSplitServices.php 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404
  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 || $orderInfo['pid'] > 0 && $key == 'new') {
  156. $storeOrderCartInfoServices->saveAll($cart_data_all);
  157. }
  158. $new_order = $this->dao->get($new_id);
  159. $storeOrderCartInfoServices->clearOrderCartInfo($new_id);
  160. $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));
  161. if ($key == 'new') {
  162. $order = $new_order;
  163. } else {
  164. $otherOrder = $new_order;
  165. }
  166. }
  167. if (!$orderInfo['pid']) $this->dao->update($id, ['pid' => -1]);
  168. //处理申请开票记录
  169. /** @var StoreOrderInvoiceServices $storeOrderInvoiceServics */
  170. $storeOrderInvoiceServics = app()->make(StoreOrderInvoiceServices::class);
  171. $storeOrderInvoiceServics->splitOrderInvoice((int)$id);
  172. return [$order, $otherOrder];
  173. });
  174. }
  175. /**
  176. * 订单拆分
  177. * @param int $id
  178. * @param array $cart_ids
  179. * @param array $orderInfo
  180. * @throws \think\db\exception\DataNotFoundException
  181. * @throws \think\db\exception\DbException
  182. * @throws \think\db\exception\ModelNotFoundException
  183. */
  184. public function split(int $id, array $cart_ids, $orderInfo = [])
  185. {
  186. $ids = array_unique(array_column($cart_ids, 'cart_id'));
  187. if (!$cart_ids || !$ids) {
  188. return false;
  189. }
  190. if (!$orderInfo) {
  191. $orderInfo = $this->dao->get($id, ['*']);
  192. }
  193. if (!$orderInfo) {
  194. throw new ValidateException('订单未能查到,不能拆分订单!');
  195. }
  196. /** @var StoreOrderCreateServices $storeOrderCreateServices */
  197. $storeOrderCreateServices = app()->make(StoreOrderCreateServices::class);
  198. $orderInfo = is_object($orderInfo) ? $orderInfo->toArray() : $orderInfo;
  199. foreach ($this->order_data as $field) {
  200. unset($orderInfo[$field]);
  201. }
  202. $order_data = $orderInfo;
  203. $order_data['pid'] = $id;
  204. mt_srand();
  205. $order_data['order_id'] = $orderInfo['order_id'] . '_' . rand(100, 999);
  206. $order_data['cart_id'] = [];
  207. $order_data['unique'] = $storeOrderCreateServices->getNewOrderId('');
  208. $order_data['add_time'] = time();
  209. $new_order = $this->dao->save($order_data);
  210. if (!$new_order) {
  211. throw new ValidateException('生成新订单失败');
  212. }
  213. $new_id = (int)$new_order->id;
  214. /** @var StoreOrderStatusServices $statusService */
  215. $statusService = app()->make(StoreOrderStatusServices::class);
  216. $statusService->save([
  217. 'oid' => $new_id,
  218. 'change_type' => 'split_create_order',
  219. 'change_message' => '发货拆分订单生成',
  220. 'change_time' => time()
  221. ]);
  222. /** @var StoreOrderCartInfoServices $storeOrderCartInfoServices */
  223. $storeOrderCartInfoServices = app()->make(StoreOrderCartInfoServices::class);
  224. //订单下原商品信息
  225. $cartInfo = $storeOrderCartInfoServices->getColumn(['oid' => $id, 'cart_id' => $ids], 'cart_num,surplus_num,cart_info', 'cart_id');
  226. $cart_data = $cart_data_all = $update_data = [];
  227. $cart_data['oid'] = $new_id;
  228. foreach ($cart_ids as $cart) {
  229. $surplus_num = $cartInfo[$cart['cart_id']]['surplus_num'] ?? 0;
  230. if (!isset($cartInfo[$cart['cart_id']]) || !$surplus_num) continue;
  231. $_info = is_string($cartInfo[$cart['cart_id']]['cart_info']) ? json_decode($cartInfo[$cart['cart_id']]['cart_info'], true) : $cartInfo[$cart['cart_id']]['cart_info'];
  232. $cart_data['cart_id'] = $storeOrderCreateServices->getNewOrderId('');
  233. $cart_data['product_id'] = $_info['product_id'];
  234. $cart_data['old_cart_id'] = $cart['cart_id'];
  235. $cart_data['cart_num'] = $cart['cart_num'];
  236. $cart_data['unique'] = md5($cart_data['cart_id'] . '_' . $cart_data['oid']);
  237. if ($cart['cart_num'] >= $surplus_num) {//拆分完成
  238. $cart_data['cart_num'] = $surplus_num;
  239. $update_data['split_status'] = 2;
  240. $update_data['surplus_num'] = 0;
  241. } else {//拆分部分数量
  242. $update_data['surplus_num'] = bcsub((string)$surplus_num, $cart['cart_num'], 0);
  243. $update_data['split_status'] = $update_data['surplus_num'] > 0 ? 1 : 2;
  244. }
  245. $_info = $this->slpitComputeOrderCart($cart_data['cart_num'], $_info);
  246. $_info['id'] = $cart_data['cart_id'];
  247. $cart_data['cart_info'] = json_encode($_info);
  248. //修改原来订单商品信息
  249. if (false === $storeOrderCartInfoServices->update(['oid' => $id, 'cart_id' => $cart['cart_id']], $update_data)) {
  250. throw new ValidateException('修改原来订单商品拆分状态失败,请稍候重试');
  251. }
  252. $cart_data_all[] = $cart_data;
  253. }
  254. if (!$storeOrderCartInfoServices->saveAll($cart_data_all)) {
  255. throw new ValidateException('新增拆分订单商品信息失败');
  256. }
  257. $new_order = $this->dao->get($new_id);
  258. $this->splitComputeOrder($new_id, $cart_data_all, $new_order);
  259. return $new_order;
  260. }
  261. /**
  262. * 重新计算新订单中价格等信息
  263. * @param int $id
  264. * @param $orderInfo
  265. * @param array $cart_info_data
  266. */
  267. 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)
  268. {
  269. $order_update['cart_id'] = array_column($cart_info_data, 'cart_id');
  270. $order_update['total_num'] = array_sum(array_column($cart_info_data, 'cart_num'));
  271. $total_price = $coupon_price = $deduction_price = $use_integral = $pay_postage = $gainIntegral = $one_brokerage = $two_brokerage = $staffBrokerage = $agentBrokerage = $divisionBrokerage = 0;
  272. foreach ($cart_info_data as $cart) {
  273. $_info = json_decode($cart['cart_info'], true);
  274. $total_price = bcadd((string)$total_price, (string)$_info['sum_true_price'], 2);
  275. $deduction_price = bcadd((string)$deduction_price, (string)$_info['integral_price'], 2);
  276. $coupon_price = bcadd((string)$coupon_price, (string)$_info['coupon_price'], 2);
  277. $use_integral = bcadd((string)$use_integral, (string)$_info['use_integral'], 0);
  278. $pay_postage = bcadd((string)$pay_postage, (string)$_info['postage_price'], 2);
  279. $cartInfoGainIntegral = bcmul((string)$cart['cart_num'], (string)($_info['productInfo']['give_integral'] ?? '0'), 0);
  280. $gainIntegral = bcadd((string)$gainIntegral, (string)$cartInfoGainIntegral, 0);
  281. $one_brokerage = bcadd((string)$one_brokerage, (string)$_info['one_brokerage'], 2);
  282. $two_brokerage = bcadd((string)$two_brokerage, (string)$_info['two_brokerage'], 2);
  283. $staffBrokerage = bcadd((string)$staffBrokerage, (string)$_info['staff_brokerage'], 2);
  284. $agentBrokerage = bcadd((string)$agentBrokerage, (string)$_info['agent_brokerage'], 2);
  285. $divisionBrokerage = bcadd((string)$divisionBrokerage, (string)$_info['division_brokerage'], 2);
  286. }
  287. $order_update['coupon_id'] = array_unique(array_column($cart_info_data, 'coupon_id'));
  288. $order_update['pay_price'] = bcadd((string)$total_price, (string)$pay_postage, 2);
  289. //有订单原来支付金额 改价订单
  290. if ($order_pay_price) {
  291. if ($pre_pay_price) {//上一个已经计算 这里减法
  292. $order_update['pay_price'] = bcsub((string)$pay_price, (string)$pre_pay_price, 2);
  293. } else {//按比例计算实际支付金额
  294. $order_update['pay_price'] = bcmul((string)bcdiv((string)$pay_price, (string)$order_pay_price, 4), (string)$order_update['pay_price'], 2);
  295. }
  296. }
  297. $order_update['total_price'] = bcadd((string)$total_price, (string)bcadd((string)$deduction_price, (string)$coupon_price, 2), 2);
  298. $order_update['deduction_price'] = $deduction_price;
  299. $order_update['coupon_price'] = $coupon_price;
  300. $order_update['use_integral'] = $use_integral;
  301. $order_update['gain_integral'] = $gainIntegral;
  302. $order_update['pay_postage'] = $pay_postage;
  303. $order_update['one_brokerage'] = $one_brokerage;
  304. $order_update['two_brokerage'] = $two_brokerage;
  305. $order_update['staff_brokerage'] = $staffBrokerage;
  306. $order_update['agent_brokerage'] = $agentBrokerage;
  307. $order_update['division_brokerage'] = $divisionBrokerage;
  308. if (false === $this->dao->update($id, $order_update, 'id')) {
  309. throw new ValidateException('保存新订单商品信息失败');
  310. }
  311. return true;
  312. }
  313. /**
  314. * 部分发货重新计算订单商品:实际金额、优惠、积分等金额
  315. * @param int $cart_num
  316. * @param array $cart_info
  317. * @return array
  318. */
  319. public function slpitComputeOrderCart(int $cart_num, array $cart_info, $orderType = 'new')
  320. {
  321. if (!$cart_num || !$cart_info) return [];
  322. if ($cart_num >= $cart_info['cart_num']) return $cart_info;
  323. $new_cart_info = $cart_info;
  324. $new_cart_info['cart_num'] = $cart_num;
  325. $compute_arr = ['coupon_price', 'integral_price', 'postage_price', 'use_integral', 'one_brokerage', 'two_brokerage', 'staff_brokerage', 'agent_brokerage', 'division_brokerage', 'sum_true_price'];
  326. foreach ($compute_arr as $field) {
  327. if (!isset($cart_info[$field]) || !$cart_info[$field]) {
  328. $new_cart_info[$field] = 0;
  329. continue;
  330. }
  331. $scale = 2;
  332. if ($field == 'use_integral') $scale = 0;
  333. $new_cart_info[$field] = bcmul((string)$cart_num, bcdiv((string)$cart_info[$field], (string)$cart_info['cart_num'], 4), $scale);
  334. if ($orderType == 'new') {//拆出
  335. $new_cart_info[$field] = bcmul((string)$cart_num, bcdiv((string)$cart_info[$field], (string)$cart_info['cart_num'], 4), $scale);
  336. } else {
  337. $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);
  338. $new_cart_info[$field] = bcsub((string)$cart_info[$field], (string)$field_number, $scale);
  339. }
  340. }
  341. return $new_cart_info;
  342. }
  343. /**
  344. * 获取整理后的订单商品信息
  345. * @param int $id
  346. * @param array $cart_ids
  347. * @param array $orderInfo
  348. * @return array|false
  349. * @throws \think\db\exception\DataNotFoundException
  350. * @throws \think\db\exception\DbException
  351. * @throws \think\db\exception\ModelNotFoundException
  352. */
  353. public function getSplitOrderCartInfo(int $id, array $cart_ids, $orderInfo = [])
  354. {
  355. $ids = array_unique(array_column($cart_ids, 'cart_id'));
  356. if (!$cart_ids || !$ids) {
  357. return false;
  358. }
  359. if (!$orderInfo) {
  360. $orderInfo = $this->dao->get($id, ['*']);
  361. }
  362. if (!$orderInfo) {
  363. throw new ValidateException('订单未能查到,不能拆分订单!');
  364. }
  365. /** @var StoreOrderCartInfoServices $storeOrderCartInfoServices */
  366. $storeOrderCartInfoServices = app()->make(StoreOrderCartInfoServices::class);
  367. $cartInfo = $storeOrderCartInfoServices->getCartColunm(['oid' => $id, 'cart_id' => $ids], '*', 'cart_id');
  368. $cart_data_all = [];
  369. foreach ($cart_ids as $cart) {
  370. $surplus_num = $cartInfo[$cart['cart_id']]['surplus_num'] ?? 0;
  371. if (!isset($cartInfo[$cart['cart_id']]) || !$surplus_num) continue;
  372. $_info = is_string($cartInfo[$cart['cart_id']]['cart_info']) ? json_decode($cartInfo[$cart['cart_id']]['cart_info'], true) : $cartInfo[$cart['cart_id']]['cart_info'];
  373. $cart_data = $cartInfo[$cart['cart_id']];
  374. $cart_data['oid'] = $id;
  375. $cart_data['product_id'] = $_info['product_id'];
  376. $cart_data['old_cart_id'] = $cart['cart_id'];
  377. $cart_data['cart_num'] = $cart['cart_num'];
  378. $cart_data['surplus_num'] = $cart['cart_num'];
  379. $cart_data['split_surplus_num'] = $cart['cart_num'];
  380. $_info = $this->slpitComputeOrderCart($cart_data['cart_num'], $_info);
  381. $_info['id'] = $cart_data['cart_id'];
  382. $cart_data['cart_info'] = $_info;
  383. $cart_data_all[] = $cart_data;
  384. unset($cartInfo[$cart['cart_id']]);
  385. }
  386. return $cart_data_all;
  387. }
  388. }