Consume.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306
  1. <?php
  2. /**
  3. * Niushop商城系统 - 团队十年电商经验汇集巨献!
  4. * =========================================================
  5. * Copy right 2019-2029 杭州牛之云科技有限公司, 保留所有权利。
  6. * ----------------------------------------------
  7. * 官方网址: https://www.niushop.com
  8. * =========================================================
  9. */
  10. namespace addon\memberconsume\model;
  11. use app\model\member\MemberAccount as MemberAccountModel;
  12. use app\model\order\OrderCommon as OrderCommonModel;
  13. use app\model\order\OrderRefund;
  14. use app\model\system\Config as ConfigModel;
  15. use app\model\BaseModel;
  16. use addon\coupon\model\CouponType;
  17. use addon\coupon\model\Coupon;
  18. use think\facade\Log;
  19. /**
  20. * 会员消费
  21. */
  22. class Consume extends BaseModel
  23. {
  24. /**
  25. * 会员消费设置
  26. * array $data
  27. */
  28. public function setConfig($data, $is_use, $site_id)
  29. {
  30. $config = new ConfigModel();
  31. $res = $config->setConfig($data, '会员消费设置', $is_use, [ [ 'site_id', '=', $site_id ], [ 'app_module', '=', 'shop' ], [ 'config_key', '=', 'MEMBER_CONSUME_CONFIG' ] ]);
  32. return $res;
  33. }
  34. /**
  35. * 会员消费设置
  36. */
  37. public function getConfig($site_id)
  38. {
  39. $config = new ConfigModel();
  40. $res = $config->getConfig([ [ 'site_id', '=', $site_id ], [ 'app_module', '=', 'shop' ], [ 'config_key', '=', 'MEMBER_CONSUME_CONFIG' ] ]);
  41. if (empty($res[ 'data' ][ 'value' ])) {
  42. $res[ 'data' ][ 'value' ] = [
  43. 'is_return_point' => 0,
  44. 'return_point_status' => 'complete',
  45. 'return_point_rate' => 0,
  46. 'return_growth_rate' => 0,
  47. 'is_return_coupon' => 0,
  48. 'return_coupon' => '',
  49. ];
  50. }
  51. if (!isset($res[ 'data' ][ 'value' ][ 'is_return_coupon' ])) $res[ 'data' ][ 'value' ][ 'is_return_coupon' ] = 0;
  52. $coupon_list = [];
  53. if ($res[ 'data' ][ 'value' ][ 'is_return_coupon' ] != 0 && $res[ 'data' ][ 'value' ][ 'return_coupon' ] != '') {
  54. $coupon = new CouponType();
  55. $coupon_list = $coupon->getCouponTypeList([ [ 'site_id', '=', $site_id ], [ 'status', '=', 1 ], [ 'coupon_type_id', 'in', $res[ 'data' ][ 'value' ][ 'return_coupon' ] ] ])[ 'data' ];
  56. }
  57. $res[ 'data' ][ 'value' ][ 'coupon_list' ] = $coupon_list;
  58. $res[ 'data' ][ 'value' ][ 'is_recovery_reward' ] = $res[ 'data' ][ 'value' ][ 'is_recovery_reward' ] ?? 0;
  59. return $res;
  60. }
  61. public function getOrderMoney($out_trade_no)
  62. {
  63. $pay_info = model('pay')->getInfo([ [ 'out_trade_no', '=', $out_trade_no ], [ 'pay_status', '=', 2 ] ]);
  64. if (empty($pay_info)) return $this->error('', '支付信息未找到');
  65. $order_money = 0;
  66. switch ( $pay_info[ 'event' ] ) {
  67. case 'OrderPayNotify':
  68. //普通订单
  69. $order = new OrderCommonModel();
  70. $order_info = $order->getOrderInfo([ [ 'out_trade_no', '=', $out_trade_no ] ], 'order_money');
  71. $order_money = $order_info[ 'data' ][ 'order_money' ] ?? '0.00';
  72. break;
  73. case 'GiftCardOrderPayNotify':
  74. //礼品卡
  75. $order_info = model("giftcard_order")->getInfo([ [ 'out_trade_no', '=', $out_trade_no ] ], 'order_money');
  76. $order_money = $order_info[ 'order_money' ] ?? '0.00';
  77. break;
  78. case 'BlindboxGoodsOrderPayNotify':
  79. //盲盒
  80. $order_info = model("blindbox_order")->getInfo([ [ 'out_trade_no', '=', $out_trade_no ], 'price' ]);
  81. $order_money = $order_info[ 'price' ] ?? '0.00';
  82. break;
  83. case 'CashierOrderPayNotify':
  84. //收银订单
  85. $order = new OrderCommonModel();
  86. $order_info = $order->getOrderInfo([ [ 'out_trade_no', '=', $out_trade_no ], [ 'member_id', '>', 0 ] ], 'order_money')[ 'data' ] ?? [];
  87. $order_money = $order_info[ 'order_money' ] ?? '0.00';
  88. break;
  89. }
  90. return $this->success($order_money);
  91. }
  92. /**
  93. * memberConsume 消费记录发放
  94. * @return array
  95. */
  96. public function memberConsume($param)
  97. {
  98. Log::write('memberConsume' . json_encode($param));
  99. $member_account_model = new MemberAccountModel();
  100. $out_trade_no = $param[ 'out_trade_no' ];
  101. $pay_info = model('pay')->getInfo([ [ 'out_trade_no', '=', $param[ 'out_trade_no' ] ], [ 'pay_status', '=', 2 ] ]);
  102. if (empty($pay_info)) return $this->error('', '支付信息未找到');
  103. $order_info = [];
  104. switch ( $pay_info[ 'event' ] ) {
  105. case 'OrderPayNotify':
  106. //普通订单
  107. $order = new OrderCommonModel();
  108. $order_info = $order->getOrderInfo([ [ 'out_trade_no', '=', $out_trade_no ] ], 'order_id, order_money, site_id, member_id, order_type')[ 'data' ];
  109. break;
  110. case 'GiftCardOrderPayNotify':
  111. //礼品卡
  112. $order_info = model("giftcard_order")->getInfo([ [ 'out_trade_no', '=', $out_trade_no ] ], 'order_id,order_money, site_id, member_id');
  113. break;
  114. case 'BlindboxGoodsOrderPayNotify':
  115. //盲盒
  116. $order_info = model("blindbox_order")->getInfo([ [ 'out_trade_no', '=', $out_trade_no ] ], 'order_id,price as order_money, site_id, member_id');
  117. break;
  118. case 'CashierOrderPayNotify':
  119. //普通订单
  120. $order = new OrderCommonModel();
  121. $order_info = $order->getOrderInfo([ [ 'out_trade_no', '=', $out_trade_no ], [ 'member_id', '>', 0 ], [ 'cashier_order_type', 'in', [ 'goods', 'card' ] ] ], 'order_id, order_money, site_id, member_id, order_type, cashier_order_type, order_scene')[ 'data' ];
  122. break;
  123. }
  124. if (empty($order_info)) return $this->success();
  125. //是否发放过
  126. $count = model('promotion_consume_record')->getCount([ [ 'out_trade_no', '=', $param[ 'out_trade_no' ] ] ]);
  127. if (!empty($count)) {
  128. return $this->success();
  129. }
  130. $consume_config = $this->getConfig($order_info[ 'site_id' ])[ 'data' ];
  131. if ($consume_config[ 'is_use' ] &&
  132. (
  133. ( ( $pay_info[ 'event' ] == 'OrderPayNotify' || $pay_info[ 'event' ] == 'CashierOrderPayNotify' ) &&
  134. (
  135. ( ( $order_info[ 'order_type' ] == 4 || ( $pay_info[ 'event' ] == 'CashierOrderPayNotify' && $order_info[ 'order_scene' ] == 'cashier' ) ) && $consume_config[ 'value' ][ 'return_point_status' ] == 'receive' && $param[ 'status' ] == 'complete' ) ||
  136. $consume_config[ 'value' ][ 'return_point_status' ] == $param[ 'status' ]
  137. )
  138. ) ||
  139. $pay_info[ 'event' ] == 'BlindboxGoodsOrderPayNotify' ||
  140. $pay_info[ 'event' ] == 'GiftCardOrderPayNotify'
  141. )
  142. ) {
  143. // 判断是否开启了奖励回收
  144. if ($consume_config[ 'value' ][ 'is_recovery_reward' ] && ( $pay_info[ 'event' ] == 'OrderPayNotify' || $pay_info[ 'event' ] == 'CashierOrderPayNotify' )) {
  145. $refunded_count = model('order_goods')->getCount([ [ 'order_id', '=', $order_info[ 'order_id' ] ], [ 'refund_status', '=', OrderRefund::REFUND_COMPLETE ] ]);
  146. if ($refunded_count > 0) return $this->success();
  147. }
  148. $consume_data = [];
  149. $consume_config = $consume_config[ 'value' ];
  150. if (!empty($consume_config[ 'return_point_rate' ])) {
  151. $adjust_num = intval($consume_config[ 'return_point_rate' ] / 100 * $order_info[ 'order_money' ]);
  152. if ($adjust_num > 0) {
  153. $remark = '活动奖励发放';
  154. $member_account_model->addMemberAccount($order_info[ 'site_id' ], $order_info[ 'member_id' ], 'point', $adjust_num, 'memberconsume', $order_info[ 'order_id' ], $remark);
  155. $consume_data[] = [
  156. 'site_id' => $order_info[ 'site_id' ],
  157. 'type' => 'point',
  158. 'value' => $adjust_num,
  159. 'order_id' => $order_info[ 'order_id' ],
  160. 'member_id' => $order_info[ 'member_id' ],
  161. 'out_trade_no' => $pay_info[ 'out_trade_no' ],
  162. 'remark' => $remark,
  163. 'config' => json_encode($consume_config),
  164. 'create_time' => time()
  165. ];
  166. }
  167. }
  168. if (!empty($consume_config[ 'return_growth_rate' ])) {
  169. $adjust_num = intval($consume_config[ 'return_growth_rate' ] / 100 * $order_info[ 'order_money' ]);
  170. if ($adjust_num > 0) {
  171. $remark = '活动奖励发放';
  172. $member_account_model->addMemberAccount($order_info[ 'site_id' ], $order_info[ 'member_id' ], 'growth', $adjust_num, 'memberconsume', $order_info[ 'order_id' ], $remark);
  173. $consume_data[] = [
  174. 'site_id' => $order_info[ 'site_id' ],
  175. 'type' => 'growth',
  176. 'value' => $adjust_num,
  177. 'order_id' => $order_info[ 'order_id' ],
  178. 'member_id' => $order_info[ 'member_id' ],
  179. 'out_trade_no' => $pay_info[ 'out_trade_no' ],
  180. 'remark' => $remark,
  181. 'config' => json_encode($consume_config),
  182. 'create_time' => time()
  183. ];
  184. }
  185. }
  186. if (!empty($consume_config[ 'is_return_coupon' ]) && !empty($consume_config[ 'return_coupon' ])) {
  187. $coupon_type = new CouponType();
  188. $coupon_list = $coupon_type->getCouponTypeList([ [ 'site_id', '=', $order_info[ 'site_id' ] ], [ 'status', '=', 1 ], [ 'coupon_type_id', 'in', $consume_config[ 'return_coupon' ] ] ])[ 'data' ];
  189. $coupon = new Coupon();
  190. foreach ($coupon_list as $k => $v) {
  191. $coupon->giveCoupon([ [ 'coupon_type_id' => $v[ 'coupon_type_id' ], 'num' => 1 ] ], $order_info[ 'site_id' ], $order_info[ 'member_id' ], 6);
  192. if ($v[ 'at_least' ] > 0) {
  193. $remark = '满' . $v[ 'at_least' ] . ( $v[ 'type' ] == 'discount' ? '打' . $v[ 'discount' ] : '减' . $v[ 'money' ] );
  194. } else {
  195. $remark = '无门槛' . ( $v[ 'type' ] == 'discount' ? '打' . $v[ 'discount' ] : '减' . $v[ 'money' ] );
  196. }
  197. $consume_data[] = [
  198. 'site_id' => $order_info[ 'site_id' ],
  199. 'type' => 'coupon',
  200. 'value' => $v[ 'coupon_type_id' ],
  201. 'order_id' => $order_info[ 'order_id' ],
  202. 'member_id' => $order_info[ 'member_id' ],
  203. 'out_trade_no' => $pay_info[ 'out_trade_no' ],
  204. 'remark' => $remark,
  205. 'config' => json_encode($consume_config),
  206. 'create_time' => time()
  207. ];
  208. }
  209. }
  210. if ($consume_data) {
  211. model('promotion_consume_record')->addList($consume_data);
  212. }
  213. }
  214. return $this->success();
  215. }
  216. private function returnStatusToZh($status)
  217. {
  218. $status_zh = [
  219. 'pay' => '付款',
  220. 'receive' => '收货',
  221. 'complete' => '完成'
  222. ];
  223. return $status_zh[ $status ];
  224. }
  225. /**
  226. * 奖励记录分页列表
  227. * @param array $condition
  228. * @param int $page
  229. * @param int $page_size
  230. * @param string $order
  231. * @param string $field
  232. * @param string $alias
  233. * @param array $join
  234. * @return array
  235. */
  236. public function getConsumeRecordPageList($condition = [], $page = 1, $page_size = PAGE_LIST_ROWS, $order = '', $field = '*', $alias = 'a', $join = [])
  237. {
  238. $list = model('promotion_consume_record')->pageList($condition, $field, $order, $page, $page_size, $alias, $join);
  239. return $this->success($list);
  240. }
  241. /**
  242. * 奖励回收
  243. * @param $out_trade_no
  244. */
  245. public function rewardRecovery($out_trade_no)
  246. {
  247. if (empty($out_trade_no)) return $this->error();
  248. $list = model('promotion_consume_record')->getList([ [ 'type', 'in', [ 'point', 'coupon' ] ], [ 'out_trade_no', '=', $out_trade_no ], [ 'is_recycled', '=', 0 ] ]);
  249. if (!empty($list)) {
  250. $site_id = $list[ 0 ][ 'site_id' ];
  251. $member_id = $list[ 0 ][ 'member_id' ];
  252. $consume_config = $this->getConfig($site_id)[ 'data' ];
  253. // 回收权益
  254. if ($consume_config[ 'value' ][ 'is_recovery_reward' ]) {
  255. $member_account = new MemberAccountModel();
  256. foreach ($list as $item) {
  257. // 扣除积分
  258. if ($item[ 'type' ] == 'point') {
  259. $member_info = model('member')->getInfo([ [ 'member_id', '=', $member_id ] ], 'point');
  260. $point = $item[ 'value' ] > $member_info[ 'point' ] ? $member_info[ 'point' ] : $item[ 'value' ];
  261. $res = $member_account->addMemberAccount($site_id, $member_id, 'point', -( $point ), 'memberconsume', $item[ 'order_id' ], "订单退款奖励回收");
  262. if ($res[ 'code' ] == 0) {
  263. model('promotion_consume_record')->update([ 'is_recycled' => 1 ], [ [ 'id', '=', $item[ 'id' ] ] ]);
  264. }
  265. }
  266. // 删除未使用的优惠券
  267. if ($item[ 'type' ] == 'coupon') {
  268. $coupon = model('promotion_coupon')->getFirstData([ [ 'member_id', '=', $member_id ], [ 'coupon_type_id', '=', $item[ 'value' ] ], [ 'state', '=', 1 ] ], 'coupon_id');
  269. if (!empty($coupon)) {
  270. $delete_num = model('promotion_coupon')->delete([ [ 'coupon_id', '=', $coupon[ 'coupon_id' ] ] ]);
  271. if ($delete_num) {
  272. model('promotion_consume_record')->update([ 'is_recycled' => 1 ], [ [ 'id', '=', $item[ 'id' ] ] ]);
  273. }
  274. }
  275. }
  276. }
  277. }
  278. }
  279. }
  280. }