ShareGroupMoney.php 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683
  1. <?php
  2. namespace app\models;
  3. use app\modules\client\models\OrderComplete;
  4. use app\utils\OrderNo;
  5. use yii\behaviors\TimestampBehavior;
  6. use yii\db\ActiveRecord;
  7. use yii\helpers\ArrayHelper;
  8. /**
  9. * This is the model class for table "{{%share_group_money}}".
  10. *
  11. * @property integer $id
  12. * @property integer $store_id
  13. * @property integer $user_id
  14. * @property integer $type
  15. * @property integer $type_id
  16. * @property float $amount
  17. * @property float $radix
  18. * @property float $profit
  19. * @property integer $is_freeze
  20. * @property integer $is_send
  21. * @property integer $send_time
  22. * @property integer $is_send_freeze
  23. * @property float $freeze_amount
  24. * @property integer $freeze_send_time
  25. * @property integer $profit_type
  26. * @property integer $order_id
  27. * @property string $group_data
  28. * @property integer $created_at
  29. * @property integer $updated_at
  30. */
  31. class ShareGroupMoney extends \yii\db\ActiveRecord
  32. {
  33. const TYPE_DIRECT = 0;
  34. const TYPE_SUPPORT = 1;
  35. const TYPE_GROUP = 2;
  36. //佣金类型 :佣金
  37. const PROFIT_TYPE_COMMON = 0;
  38. //佣金类型 :余额
  39. const PROFIT_TYPE_BALANCE = 1;
  40. /**
  41. * @inheritdoc
  42. */
  43. public static function tableName()
  44. {
  45. return '{{%share_group_money}}';
  46. }
  47. public function behaviors()
  48. {
  49. return [
  50. [
  51. 'class' => TimestampBehavior::class
  52. ]
  53. ];
  54. }
  55. /**
  56. * @inheritdoc
  57. */
  58. public function rules()
  59. {
  60. return [
  61. [['id', 'store_id', 'user_id', 'type', 'type_id', 'created_at', 'updated_at', 'is_freeze', 'is_send', 'is_send_freeze', 'freeze_send_time', 'send_time', 'order_id'], 'integer'],
  62. [['amount', 'radix', 'profit', 'freeze_amount'], 'number'],
  63. [['group_data'], 'string']
  64. ];
  65. }
  66. /**
  67. * @inheritdoc
  68. */
  69. public function attributeLabels()
  70. {
  71. return [
  72. 'id' => '',
  73. 'store_id' => 'Store Id',
  74. 'user_id' => '用户ID',
  75. 'type' => '佣金类型:0直推 1成团 2帮扶',
  76. 'type_id' => '佣金来源表ID',
  77. 'amount' => '佣金金额',
  78. 'radix' => '佣金基数',
  79. 'profit' => '佣金计算比例',
  80. 'is_freeze' => '是否带冻结佣金',
  81. 'is_send' => '是否发放佣金',
  82. 'is_send_freeze' => '是否发放冻结佣金',
  83. 'send_time' => '发放时间',
  84. 'freeze_amount' => '冻结佣金金额 帮扶时冻结佣金+佣金金额 = 全部的佣金金额',
  85. 'group_data' => '成团数据',
  86. 'order_id' => '直推/帮扶订单ID',
  87. 'created_at' => '',
  88. 'updated_at' => ''
  89. ];
  90. }
  91. //添加佣金记录 主要是直推以及帮扶
  92. public static function addMoneyLog($type, $type_id, $store_id, $order_id) {
  93. try {
  94. $money_log = self::findOne(['type' => $type, 'type_id' => $type_id, 'order_id' => $order_id]);
  95. if ($money_log) {
  96. throw new \Exception('记录已经存在');
  97. }
  98. $order_detail = OrderDetail::find()->where(['order_id' => $order_id])->select('goods_id, total_price')
  99. ->asArray()->all();
  100. $share_group_setting = Option::get('share_group_setting', $store_id, 'share_group')['value'];
  101. $share_group_setting = json_decode($share_group_setting ?? '', true);
  102. if (empty($share_group_setting)) {
  103. throw new \Exception('未配置佣金设置');
  104. }
  105. $goods_ids = explode(',', $share_group_setting['goods_ids'] ?? '');
  106. $share_group_direct_profit = $share_group_setting['share_group_direct_profit'];
  107. $share_group_support_profit = $share_group_setting['share_group_support_profit'];
  108. $share_group_other_accounts_switch = $share_group_setting['share_group_other_accounts_switch'];
  109. $share_group_support_freeze_profit = $share_group_setting['share_group_support_freeze_profit'];
  110. $support_group_price_send_type = intval($share_group_setting['support_group_price_send_type'] ?? 0);
  111. $open = false;
  112. $radix = 0;
  113. foreach ($order_detail as $goods_item) {
  114. if (in_array($goods_item['goods_id'], $goods_ids)) {
  115. $open = true;
  116. $radix = bcadd($goods_item['total_price'], $radix, 2);
  117. }
  118. }
  119. if (!$open) {
  120. throw new \Exception('下单商品未在拼购商品列表内');
  121. }
  122. $is_freeze = 0;
  123. $is_send = 0;
  124. $freeze_amount = 0;
  125. $profit = 0;
  126. $amount = 0;
  127. $user_id = 0;
  128. if ($type == self::TYPE_DIRECT) {
  129. $amount = bcmul($radix, bcdiv($share_group_direct_profit, 100, 2), 2);
  130. $profit = $share_group_direct_profit;
  131. //获取原上级的用户信息
  132. $purchase_log = ShareGroupPurchaseParentLog::findOne($type_id);
  133. $user_id = $purchase_log->parent_user_id;
  134. //判断整个树中是否存在原上级 增加batch_id判断是为了优化下级先成为37拼购成员 上级后成为37拼购成员 后给原上级发放佣金的bug
  135. $checkParentLog = ShareGroupPurchaseParentLog::find()->where(['user_id' => $user_id])->andWhere(['OR', ['batch_id' => $purchase_log->batch_id], [
  136. 'id' => $purchase_log->batch_id
  137. ]])->asArray()->one();
  138. if (!$checkParentLog) {
  139. //如果不存在上级 可能存在问题就是 不是同一条树 可能是帮扶过来的 或者就是真的没有上级
  140. // throw new \Exception('上级不存在');
  141. $user_id = 0;
  142. }
  143. //判断是否存在扶持 //新逻辑 如果后台设置的帮扶区直推佣金发放给0原上级/1新上级
  144. $shareGroupSupportLog = ShareGroupSupportLog::findOne(['user_id' => $purchase_log->user_id]);
  145. if ($shareGroupSupportLog) {
  146. if ($support_group_price_send_type) {
  147. //判断不是顶级的就需要给新上级发放佣金
  148. if ($shareGroupSupportLog->parent_id != 0) {
  149. $shareGroupPurchaseUser = ShareGroupPurchaseUser::findOne(['user_id' => $purchase_log->user_id]);
  150. if ($shareGroupPurchaseUser) {
  151. $user_id = $shareGroupPurchaseUser->parent_user_id;
  152. }
  153. } else {
  154. //如果是顶级的 还是需要给原上级发放佣金
  155. $user_id = $shareGroupSupportLog->parent_user_id;
  156. }
  157. } else {
  158. $user_id = $shareGroupSupportLog->parent_user_id;
  159. }
  160. }
  161. if (!$user_id) {
  162. throw new \Exception('上级不存在');
  163. }
  164. } elseif ($type == self::TYPE_SUPPORT) {
  165. //判断已经完成过拼购就不计算冻结佣金 否则需要将佣金冻结
  166. $amount = bcmul($radix, bcdiv($share_group_support_profit, 100, 2), 2);
  167. $profit = $share_group_support_profit;
  168. $shareGroupParentSupportLog = ShareGroupSupportLog::findOne($type_id);
  169. $user_id = $shareGroupParentSupportLog->parent_user_id;
  170. //判断是否已经完成过拼购
  171. $group_log = self::findOne(['type' => self::TYPE_GROUP, 'user_id' => $shareGroupParentSupportLog->parent_user_id]);
  172. $purchase_log = ShareGroupPurchaseParentLog::findOne(['user_id' => $user_id]);
  173. //是否冻结
  174. if (!ShareGroupPurchaseParentLog::checkUnfreeze($user_id, $purchase_log->batch_id ?: $group_log->id)) {
  175. if (intval($share_group_other_accounts_switch) && $share_group_support_freeze_profit > 0) {
  176. $is_freeze = 1;
  177. $freeze_amount = bcmul($amount, bcdiv($share_group_support_freeze_profit, 100, 2), 2);
  178. $amount = bcsub($amount, $freeze_amount, 2);
  179. }
  180. }
  181. }
  182. $form = new self();
  183. $form->store_id = $store_id;
  184. $form->user_id = $user_id;
  185. $form->type = $type;
  186. $form->type_id = $type_id;
  187. $form->amount = $amount;
  188. $form->radix = $radix;
  189. $form->profit = $profit;
  190. $form->is_freeze = $is_freeze;
  191. $form->is_send = $is_send;
  192. $form->order_id = $order_id;
  193. $form->freeze_amount = $freeze_amount;
  194. if (!$form->save()) {
  195. throw new \Exception(implode(';', array_values($form->firstErrors)));
  196. }
  197. return [
  198. 'code' => 0,
  199. 'msg' => 'success'
  200. ];
  201. } catch (\Exception $e) {
  202. return [
  203. 'code' => 1,
  204. 'msg' => $e->getMessage()
  205. ];
  206. }
  207. }
  208. public static function checkIsFinish($user_id) {
  209. $purchase_parent_user_log = ShareGroupPurchaseParentLog::find()->where(['user_id' => $user_id])
  210. ->select('id')->asArray()->all();
  211. foreach ($purchase_parent_user_log as $item) {
  212. $purchase_parent_child_user_log = ShareGroupPurchaseParentLog::find()->where(['parent_id' => $item['id']])
  213. ->select('id')->column();
  214. if (count($purchase_parent_child_user_log) == 2) {
  215. $purchase_parent_min_user_log = ShareGroupPurchaseParentLog::find()->where(['parent_id' => $purchase_parent_child_user_log])
  216. ->select('id')->column();
  217. if (count($purchase_parent_min_user_log) == 4) {
  218. return true;
  219. }
  220. }
  221. }
  222. return false;
  223. }
  224. //检测存在团里面有取消订单的情况的团
  225. public static function checkCancelOrderMoney($order_id) {
  226. //通过订单获取对应的团
  227. $shareGroupMoneySub = ShareGroupMoneySub::findOne(['order_id' => $order_id]);
  228. if ($shareGroupMoneySub) {
  229. $shareGroupMoneyId = ShareGroupMoney::findOne(['is_send' => 0, 'id' => $shareGroupMoneySub->share_money_id]);
  230. //判断当前团是否满足拼购人数需求
  231. $open = false;
  232. $shareGroupMoneySubOrderId = ShareGroupMoneySub::find()->where(['share_money_id' => $shareGroupMoneyId->id])
  233. ->select('order_id')->column();
  234. if ($shareGroupMoneySubOrderId < 6) {
  235. return;
  236. }
  237. //获取已经取消的订单或者已经完成售后的订单
  238. $cancel_order_id = [];
  239. $order = Order::find()->where(['id' => $shareGroupMoneySubOrderId, 'trade_status' => Order::ORDER_FLOW_CANCEL])
  240. ->select('id')->column();
  241. if ($order) {
  242. $cancel_order_id = $order;
  243. $open = true;
  244. }
  245. $orderRefund = OrderRefund::find()->where(['order_id' => $shareGroupMoneySubOrderId, 'is_delete' => 0, 'is_user_cancel' => 0, 'status' => [2, 3]])
  246. ->select('order_id')->column();
  247. if ($orderRefund) {
  248. $cancel_order_id = array_merge($cancel_order_id, $orderRefund);
  249. // 如果售后类型不是换货或拒绝退换货,不处理
  250. $open = true;
  251. }
  252. if ($open) {
  253. $order_is_sale = Order::find()->where(['is_sale' => 1])->andWhere(['NOT IN', 'id', $cancel_order_id])
  254. ->select('id')->column();
  255. //如果订单中同时存在已取消或者已售后的订单且他俩数量 和 已完成售后的订单数量加起来小于6 那说明还存在未完成售后的订单
  256. if (count($order_is_sale) + count($cancel_order_id) < 6) {
  257. return;
  258. }
  259. $order = Order::find()->where(['id' => $shareGroupMoneyId->order_id])->asArray()->one();
  260. self::sendMoney($order);
  261. }
  262. }
  263. }
  264. public static function sendMoney($order) {
  265. debug_log(['order_id' => $order['id']], '20250422.log');
  266. $t = \Yii::$app->db->beginTransaction();
  267. try {
  268. // $groupPurchaseParentLog = ShareGroupPurchaseParentLog::find()->where(['order_id' => $order['id']])
  269. // ->select('id')->column();
  270. //
  271. //
  272. // $groupSupportLog = ShareGroupSupportLog::find()->where(['order_id' => $order['id']])
  273. // ->select('id')->column();
  274. //订单过售后期发放佣金
  275. $freeze_amount_list = self::find()->where([
  276. 'is_send' => 0,
  277. 'type' => [
  278. self::TYPE_DIRECT,
  279. self::TYPE_SUPPORT,
  280. ],
  281. 'order_id' => $order['id']
  282. ])->select('id')->column();
  283. foreach ($freeze_amount_list as $freeze_amount_item) {
  284. $freeze_amount_item_ = self::findOne(['id' => $freeze_amount_item, 'is_send' => 0]);
  285. if (!$freeze_amount_item_) {
  286. continue;
  287. }
  288. $freeze_amount_item_->is_send = 1;
  289. $freeze_amount_item_->send_time = time();
  290. $shareGroupPurchaseUser = ShareGroupPurchaseUser::findOne(['user_id' => $freeze_amount_item_->user_id]);
  291. if (!$shareGroupPurchaseUser) {
  292. continue;
  293. }
  294. if ($freeze_amount_item_->type == self::TYPE_DIRECT) {
  295. $shareGroupPurchaseUser->direct_price += $freeze_amount_item_->amount;
  296. $shareGroupPurchaseUser->total_price += $freeze_amount_item_->amount;
  297. $shareGroupPurchaseUser->price += $freeze_amount_item_->amount;
  298. }
  299. if ($freeze_amount_item_->type == self::TYPE_SUPPORT) {
  300. $shareGroupPurchaseUser->support_price += $freeze_amount_item_->amount;
  301. $shareGroupPurchaseUser->total_price += $freeze_amount_item_->amount;
  302. $shareGroupPurchaseUser->price += $freeze_amount_item_->amount;
  303. }
  304. //判断用户是否存在 存在则开始发放
  305. $user = User::findOne(['id' => $freeze_amount_item_->user_id, 'is_delete' => 0]);
  306. if ($user && $freeze_amount_item_->amount > 0) {
  307. $user->price = bcadd($user->price, $freeze_amount_item_->amount, 2);
  308. $user->total_price = bcadd($user->total_price, $freeze_amount_item_->amount, 2);
  309. if (!$user->save()) {
  310. throw new \Exception(json_encode($user->errors, JSON_UNESCAPED_UNICODE));
  311. }
  312. $result = UserShareMoney::set($freeze_amount_item_->amount, $freeze_amount_item_->user_id, 0, 0, 12, $freeze_amount_item_->store_id, 0, '37拼购'.($freeze_amount_item_->type == ShareGroupMoney::TYPE_SUPPORT ? "扶持" : "直推").'佣金发放');
  313. if (!$result) {
  314. throw new \Exception('保存失败');
  315. }
  316. $group_parent_purchase_log = ShareGroupPurchaseParentLog::findOne(['user_id' => $freeze_amount_item_->user_id]);
  317. //判断是否已经完成过拼购
  318. if (ShareGroupPurchaseParentLog::checkUnfreeze($freeze_amount_item_->user_id, $group_parent_purchase_log->batch_id ?: $group_parent_purchase_log->id) &&
  319. intval($freeze_amount_item_->is_freeze) === 1 &&
  320. intval($freeze_amount_item_->is_send_freeze) == 0 &&
  321. $freeze_amount_item_->freeze_amount > 0
  322. ) {
  323. $freeze_amount_item_->is_send_freeze = 1;
  324. $freeze_amount_item_->freeze_send_time = time();
  325. $shareGroupPurchaseUser->support_price += $freeze_amount_item_->freeze_amount;
  326. $shareGroupPurchaseUser->total_price += $freeze_amount_item_->freeze_amount;
  327. $shareGroupPurchaseUser->price += $freeze_amount_item_->freeze_amount;
  328. $user->price = bcadd($user->price, $freeze_amount_item_->freeze_amount, 2);
  329. $user->total_price = bcadd($user->total_price, $freeze_amount_item_->freeze_amount, 2);
  330. if (!$user->save()) {
  331. throw new \Exception(json_encode($user->errors, JSON_UNESCAPED_UNICODE));
  332. }
  333. $result = UserShareMoney::set($freeze_amount_item_->freeze_amount, $freeze_amount_item_->user_id, 0, 0, 12, $freeze_amount_item_->store_id, 0, '37拼购冻结佣金发放');
  334. if (!$result) {
  335. throw new \Exception('保存失败');
  336. }
  337. }
  338. }
  339. if (!$freeze_amount_item_->save()) {
  340. throw new \Exception(json_encode($freeze_amount_item_->errors, JSON_UNESCAPED_UNICODE));
  341. }
  342. if (!$shareGroupPurchaseUser->save()) {
  343. throw new \Exception(json_encode($shareGroupPurchaseUser->errors, JSON_UNESCAPED_UNICODE));
  344. }
  345. }
  346. $group_sub_order_log = ShareGroupMoneySub::find()->where(['order_id' => $order['id']])->select('share_money_id')
  347. ->asArray()->all();
  348. foreach ($group_sub_order_log as $group_sub_order_log_item) {
  349. $shareGroupMoney = self::findOne(['id' => $group_sub_order_log_item['share_money_id']]);//, 'is_send' => 0 兼容之前问题导致的提前释放问题
  350. if (!$shareGroupMoney) {
  351. continue;
  352. }
  353. $group_sub_log_ = ShareGroupMoneySub::find()->where(['share_money_id' => $group_sub_order_log_item['share_money_id']])
  354. ->select('id, share_money_id, amount, is_send')
  355. ->asArray()->all();
  356. if (count($group_sub_log_) < 6) {
  357. continue;
  358. }
  359. $group_sub_log_send_amount = 0;
  360. foreach ($group_sub_log_ as $group_sub_log_item) {
  361. if (intval($group_sub_log_item['is_send'])) {
  362. $group_sub_log_send_amount = bcadd($group_sub_log_send_amount, $group_sub_log_item['amount'], 2);
  363. }
  364. }
  365. $group_sub_log = ShareGroupMoneySub::find()->where(['share_money_id' => $group_sub_order_log_item['share_money_id'], 'is_send' => 0])
  366. ->select('id, share_money_id, amount')
  367. ->asArray()->all();
  368. $shareGroupMoneyAmount = $shareGroupMoney->amount;
  369. if ($shareGroupMoney->profit_type == self::PROFIT_TYPE_COMMON) {
  370. $shareGroupMoneyAmount = bcsub($shareGroupMoneyAmount, $group_sub_log_send_amount, 2);
  371. foreach ($group_sub_log as $group_sub_item) {
  372. $shareGroupMoneySub = ShareGroupMoneySub::findOne($group_sub_item['id']);
  373. $order = Order::findOne($shareGroupMoneySub->order_id);
  374. //如果订单在过完售后期且存在售后订单或者存在已经取消的订单 就计算剩余金额发放给用户
  375. if ($order->trade_status == Order::ORDER_FLOW_CANCEL) {
  376. $shareGroupMoneyAmount = bcsub($shareGroupMoney->amount, $shareGroupMoneySub->amount, 2);
  377. continue;
  378. }
  379. $orderRefund = OrderRefund::findOne(['order_id' => $shareGroupMoneySub->order_id, 'is_delete' => 0, 'is_user_cancel' => 0]);
  380. if ($orderRefund && !\in_array($orderRefund->status, [2, 3])) {
  381. // 如果售后类型不是换货或拒绝退换货,不处理
  382. $shareGroupMoneyAmount = bcsub($shareGroupMoney->amount, $shareGroupMoneySub->amount, 2);
  383. continue;
  384. }
  385. if (!intval($order->is_sale)) {
  386. goto order_sale;
  387. }
  388. }
  389. }
  390. if ($shareGroupMoneyAmount <= 0) {
  391. debug_log(['shareGroupMoneyAmount' => $shareGroupMoneyAmount, 'continue' => 1], '20250422.log');
  392. $shareGroupMoney->is_send = 1;
  393. $shareGroupMoney->send_time = time();
  394. if (!$shareGroupMoney->save()) {
  395. throw new \Exception(json_encode($shareGroupMoney->errors, JSON_UNESCAPED_UNICODE));
  396. }
  397. continue;
  398. }
  399. $shareGroupPurchaseUser = ShareGroupPurchaseUser::findOne(['user_id' => $shareGroupMoney->user_id]);
  400. if (!$shareGroupPurchaseUser) {
  401. continue;
  402. }
  403. debug_log(['shareGroupMoneyAmount' => $shareGroupMoneyAmount], '20250422.log');
  404. $user_price = 0;
  405. //判断用户是否存在 存在则开始发放
  406. $user = User::findOne(['id' => $shareGroupMoney->user_id, 'is_delete' => 0]);
  407. if ($user) {
  408. if ($shareGroupMoney->profit_type == self::PROFIT_TYPE_COMMON) {
  409. $user_price = $shareGroupMoneyAmount;
  410. } else {
  411. AccountLog::saveLog(
  412. $shareGroupMoney->user_id,
  413. $shareGroupMoneyAmount,
  414. AccountLog::TYPE_BALANCE,
  415. AccountLog::LOG_TYPE_INCOME,
  416. 0,
  417. 0,
  418. '37拼购成团余额发放'
  419. );
  420. }
  421. }
  422. debug_log(['user_price' => $user_price], '20250422.log');
  423. ShareGroupMoneySub::updateAll(['is_send' => 1, 'updated_at' => time()], ['share_money_id' => $shareGroupMoney->id]);
  424. $shareGroupMoney->is_send = 1;
  425. $shareGroupMoney->send_time = time();
  426. if (!$shareGroupMoney->save()) {
  427. throw new \Exception(json_encode($shareGroupMoney->errors, JSON_UNESCAPED_UNICODE));
  428. }
  429. //自动复购
  430. if (intval($shareGroupMoney->profit_type) === self::PROFIT_TYPE_COMMON) {
  431. $share_group_setting = Option::get('share_group_setting', $shareGroupMoney->store_id, 'share_group')['value'];
  432. $share_group_setting = json_decode($share_group_setting ?? '', true);
  433. $share_group_commission_profit = $share_group_setting['share_group_commission_profit'];//成团佣金比例
  434. $share_group_auto_switch = intval($share_group_setting['share_group_auto_switch']);//是否自动复购
  435. if ($share_group_auto_switch) {
  436. $shareGroupPurchaseParentLog = ShareGroupPurchaseParentLog::findOne($shareGroupMoney->type_id);
  437. $old_order = Order::findOne($shareGroupPurchaseParentLog->order_id);
  438. $old_order = ArrayHelper::toArray($old_order);
  439. $old_order_detail_id = $shareGroupPurchaseParentLog->order_detail_id;
  440. $old_order_detail_id = explode(',', $old_order_detail_id);
  441. $old_order_detail_ = OrderDetail::find()->where(['id' => $old_order_detail_id])
  442. ->asArray()->all();
  443. $pay_price_ = $old_order['express_price'];
  444. $old_order_detail = [];
  445. foreach ($old_order_detail_ as $old_order_detail_item) {
  446. $goods = Goods::find()->where('id = :id FOR UPDATE', [':id' => $old_order_detail_item['goods_id']])->one();
  447. // $goods = Goods::findOne($old_order_detail_item['goods_id']);
  448. $old_order_detail_item['attr'] = json_decode($old_order_detail_item['attr'], true);
  449. $attr_id_list = array_column($old_order_detail_item['attr'], 'attr_id');
  450. try {
  451. $goodsNumSubResult = $goods->numSub($attr_id_list, $old_order_detail_item['num'], $old_order['md_id'] ?: -1);
  452. } catch (\Exception $e) {
  453. $goodsNumSubResult = false;
  454. }
  455. if ($goodsNumSubResult) {
  456. $old_order_detail_item['attr'] = json_encode($old_order_detail_item['attr'], JSON_UNESCAPED_UNICODE);
  457. $old_order_detail[] = $old_order_detail_item;
  458. $pay_price_ = bcadd($pay_price_, $old_order_detail_item['total_price'], 2);
  459. }
  460. }
  461. if (empty($old_order_detail)) {
  462. debug_log(['复购失败商品库存不足'], 'share_group_money.log');
  463. goto order_price;
  464. }
  465. if ($shareGroupMoneyAmount < $pay_price_) {
  466. debug_log(['复购失败佣金小于订单金额'], 'share_group_money.log');
  467. goto order_price;
  468. }
  469. unset($old_order['id']);
  470. $order = new Order();
  471. $order->attributes = $old_order;
  472. $order->total_price = $order->pay_price = $pay_price_;
  473. $order->order_no = OrderNo::getOrderNo(OrderNo::ORDER_MALL);
  474. $order->created_at = time();
  475. $order->trade_status = 0;
  476. $order->is_sale = 0;
  477. $order->md_id = $old_order['md_id'];
  478. $order->arrival_time = $old_order['arrival_time'];
  479. $order->integral_price = 0;
  480. $order->integral_difference_price = 0;
  481. $order->confirm_time = 0;
  482. $order->send_time = 0;
  483. $order->pay_time = time();
  484. $order->is_price = 0;
  485. // $order->rebate = 0;
  486. // $order->first_price = 0;
  487. // $order->second_price = 0;
  488. // $order->third_price = 0;
  489. $order->coupon_sub_price = 0;
  490. $order->integral = json_encode(["forehead" => "0.00", "forehead_integral" => "0.00"]);
  491. $order->give_integral = 0;
  492. $order->share_price = 0;
  493. $order->future_sales_time = 0;
  494. $order->take_price = 0;
  495. $order->send_price = 0;
  496. $result = $order->save();
  497. if ($result) {
  498. debug_log(['error_order' => $order->getErrors()], 'share_group_money.log');
  499. }
  500. $goods_profit = 0;
  501. foreach ($old_order_detail as $old_order_detail_item) {
  502. unset($old_order_detail_item['id']);
  503. $order_detail = new OrderDetail();
  504. $order_detail->attributes = $old_order_detail_item;
  505. $order_detail->order_id = $order->id;
  506. $result = $order_detail->save();
  507. if (!$result) {
  508. debug_log(['error_order' => $order_detail->getErrors()], 'share_group_money.log');
  509. throw new \Exception('订单详情保存失败' . json_encode($order_detail->getErrors(), JSON_UNESCAPED_UNICODE));
  510. }
  511. // $goods_profit = bcmul($old_order_detail_item['total_price'], bcdiv($share_group_commission_profit, 100, 2), 2);
  512. }
  513. $user_price = bcsub($user_price, $order->pay_price, 2);
  514. // $user_price = bcadd($user_price, $goods_profit);
  515. $form = new OrderComplete();
  516. $form->order_id = $order->id;
  517. $form->order_type = 0;
  518. $form->store_id = $order->store_id;
  519. $form->is_auto_repeat = 1;
  520. $form->notify();
  521. }
  522. }
  523. order_price:
  524. $user->price = bcadd($user->price, $user_price, 2);
  525. if (!$user->save()) {
  526. throw new \Exception(json_encode($user->errors, JSON_UNESCAPED_UNICODE));
  527. }
  528. // UserShareMoney::set($user_price, $shareGroupMoney->user_id, 0, 0, 12, $shareGroupMoney->store_id, 0, '37拼购成团佣金发放');
  529. // if (!$result) {
  530. // throw new \Exception('保存失败');
  531. // }
  532. if ($shareGroupMoney->profit_type == self::PROFIT_TYPE_COMMON) {
  533. $result = UserShareMoney::set($user_price, $shareGroupMoney->user_id, 0, 0, 12, $shareGroupMoney->store_id, 0, '37拼购成团佣金发放');
  534. // if (!$result) {
  535. // throw new \Exception('保存失败');
  536. // }
  537. $shareGroupPurchaseUser->group_price += $user_price;
  538. $shareGroupPurchaseUser->total_price += $user_price;
  539. $shareGroupPurchaseUser->price += $user_price;
  540. if (!$shareGroupPurchaseUser->save()) {
  541. throw new \Exception(json_encode($shareGroupPurchaseUser->errors, JSON_UNESCAPED_UNICODE));
  542. }
  543. }
  544. }
  545. order_sale:
  546. $t->commit();
  547. return [
  548. 'code' => 0,
  549. 'msg' => ''
  550. ];
  551. } catch (\Exception $e) {
  552. $t->rollBack();
  553. return [
  554. 'code' => 1,
  555. 'msg' => $e->getMessage() . $e->getLine() . $e->getFile()
  556. ];
  557. }
  558. }
  559. }