RechargeService.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381
  1. <?php
  2. namespace app\admin\service\notify;
  3. use app\admin\service\coupon\CouponDetailService;
  4. use app\model\Coupon;
  5. use app\model\CouponDetail;
  6. use app\model\Goods;
  7. use app\model\Member;
  8. use app\model\MemberAccount;
  9. use app\model\MemberQuota;
  10. use app\model\MemberRole;
  11. use app\model\Order;
  12. use app\model\OrderSheet;
  13. use app\model\PayDetail;
  14. use app\model\RuleAdded;
  15. use app\model\RuleAddedComponent;
  16. use Monolog\Handler\IFTTTHandler;
  17. use support\exception\BusinessException;
  18. use support\Log;
  19. class RechargeService
  20. {
  21. /**
  22. * @Desc
  23. * @Author Gorden
  24. * @Date 2024/5/28 16:50
  25. *
  26. * @param $orderId
  27. * @return mixed
  28. * @throws BusinessException
  29. */
  30. public static function disposeOrder($orderId)
  31. {
  32. $orderSheet = OrderSheet::where('join_sheet_order_id', $orderId)->first();
  33. if (!$orderSheet) {
  34. throw new BusinessException('订单数据异常');
  35. }
  36. $goods = Goods::find($orderSheet->join_sheet_goods_id);
  37. // 自定义充值产品
  38. if ($goods->join_goods_category_id == 210) {
  39. return 0;
  40. }
  41. if (empty($goods->goods_attribute_json)) {
  42. throw new BusinessException('产品数据异常');
  43. }
  44. $attributeJson = json_decode($goods->goods_attribute_json, true);
  45. if (!isset($attributeJson['added'])) {
  46. throw new BusinessException('产品数据异常');
  47. }
  48. return $attributeJson['added']['nbr'];
  49. }
  50. public static function getGoodsAttributeJson($orderId)
  51. {
  52. try {
  53. $orderSheet = OrderSheet::where('join_sheet_order_id', $orderId)->first();
  54. if (!$orderSheet) {
  55. throw new BusinessException('订单数据异常');
  56. }
  57. $goods = Goods::find($orderSheet->join_sheet_goods_id);
  58. if (empty($goods->goods_attribute_json)) {
  59. throw new BusinessException('产品数据异常');
  60. }
  61. return json_decode($goods->goods_attribute_json, true);
  62. } catch (BusinessException $e) {
  63. throw new BusinessException($e->getMessage());
  64. } catch (\Exception $e) {
  65. throw new BusinessException('产品数据异常');
  66. }
  67. }
  68. /**
  69. * @Desc
  70. * @Author Gorden
  71. * @Date 2024/5/29 16:25
  72. *
  73. * @param $memberId
  74. * @param $payAmount
  75. * @throws BusinessException
  76. */
  77. public static function disposeRole($memberId, $payAmount)
  78. {
  79. try {
  80. $member = Member::with([
  81. 'role' => function ($query) {
  82. $query->select('member_role_id', 'member_role_sort');
  83. }
  84. ])->where('member_id', $memberId)
  85. ->first();
  86. $memberRoleConfigJson = [];
  87. if (!empty($member->member_role_config_json)) {
  88. $memberRoleConfigJson = json_decode($member->member_role_config_json, true);
  89. }
  90. $role = MemberRole::where('member_role_category', 'COMBINE')
  91. ->where('member_role_range_begin', '<=', $payAmount)
  92. ->where('member_role_range_end', '>=', $payAmount)
  93. ->first();
  94. $memberRoleId = '';
  95. $memberRoleBegintime = '';
  96. // 没有角色,或者有角色,新角色等级高
  97. if ((!empty($member->role) && !empty($role) && $role->member_role_sort > $member->role->member_role_sort) || (empty($member->role) && !empty($role))) {
  98. $memberRoleId = $role->member_role_id;
  99. $memberRoleBegintime = date('Y-m-d H:i:s');
  100. $memberRoleConfigJson['next'] = [];
  101. } elseif (!empty($member->role) && !empty($role) && $role->member_role_sort == $member->role->member_role_sort) {
  102. $memberRoleId = $role->member_role_id;
  103. $memberRoleBegintime = date('Y-m-d H:i:s');
  104. $memberRoleConfigJson['next'] = [];
  105. } elseif (!empty($member->role) && !empty($role) && $role->member_role_sort < $member->role->member_role_sort) {
  106. $memberRoleId = $member->role->member_role_id;
  107. $memberRoleBegintime = $member->member_role_begintime;
  108. $memberRoleConfigJson['next'][] = ['member_role_begintime' => date('Y-m-d H:i:s'), 'member_role_id' => $role->member_role_id];
  109. }
  110. $memberRoleConfigJson['deadline_datetime'] = date('Y-m-d 23:59:59',strtotime($memberRoleBegintime.' +364 days'));
  111. Member::where('member_id', $memberId)->update([
  112. 'join_member_role_id' => $memberRoleId,
  113. 'member_role_begintime' => $memberRoleBegintime,
  114. 'member_role_config_json' => json_encode($memberRoleConfigJson)
  115. ]);
  116. } catch (\Exception $e) {
  117. Log::error('计算等级异常:' . $e->getMessage());
  118. throw new BusinessException("计算等级异常");
  119. }
  120. }
  121. public static function disposeRoleCoupon($goodsAttributeJson,$couponParams, $memberId)
  122. {
  123. try {
  124. if (empty($goodsAttributeJson['coupon'])) {
  125. return;
  126. }
  127. // 发券
  128. foreach ($goodsAttributeJson['coupon'] as $key => $coupon) {
  129. $couponModel = Coupon::where('coupon_id', $key)->select('coupon_id', 'coupon_validdate_day', 'coupon_validdate_end', 'coupon_is_period', 'coupon_number')->first();
  130. if (empty($couponModel)) {
  131. continue;
  132. }
  133. // 券是否过期
  134. if (!empty($couponModel->coupon_validdate_end) && strtotime($couponModel->coupon_validdate_end) < time()) {
  135. continue;
  136. }
  137. // 发周期券
  138. if ($couponModel->coupon_is_period == 'Y') {
  139. // 发券参数
  140. $couponSendParams = ['gettype' => 'ROLE', 'coupon_id' => $key, 'member_id' => $memberId,'order_id'=>$couponParams['order_id'] ?? ''];
  141. Log::info("发周期券参数", $couponSendParams);
  142. CouponDetailService::sendPeriodCoupon($couponSendParams);
  143. continue;
  144. }
  145. $couponResidue = 'all';
  146. if ($couponModel->coupon_number != 0) {
  147. $couponResidue = CouponDetail::where('join_detail_coupon_id', $key)->whereIn('coupon_detail_status', ['INIT', 'PENDING'])->count();
  148. // 超出优惠券设置的数量
  149. if ($couponResidue < $coupon['num']) {
  150. continue;
  151. }
  152. }
  153. $endDate = '';
  154. if (!empty($couponModel->coupon_validdate_end)) {
  155. $endDate = $couponModel->coupon_validdate_end;
  156. } elseif ($couponModel->coupon_validdate_day > 0) {
  157. $endDate = date('Y-m-d H:i:s', time() + ($couponModel->coupon_validdate_day * 24 * 3600) - 1);
  158. }
  159. // 发券参数
  160. $couponSendParams = [
  161. 'gettype' => 'ROLE',
  162. 'coupon_id' => $key,
  163. 'chooseCouponNbr' => $coupon['num'],
  164. 'member_id' => $memberId,
  165. 'coupon_detail_gain_datetime' => date('Y-m-d H:i:s'),
  166. 'coupon_detail_deadline_datetime' => $endDate,
  167. 'order_id'=>$couponParams['order_id'] ?? ''
  168. ];
  169. Log::info("发普通券参数", $couponSendParams);
  170. if ($couponResidue != 'all' && $couponResidue - $coupon['num'] >= 0) {
  171. CouponDetailService::customSendCouponHave($couponSendParams);
  172. } else {
  173. for ($i = 0; $i < $coupon['num']; $i++) {
  174. CouponDetailService::customSendCoupon($couponSendParams);
  175. }
  176. }
  177. }
  178. } catch (\Exception $e) {
  179. throw new BusinessException("发券异常");
  180. }
  181. }
  182. /**
  183. * @Desc
  184. * @Author Gorden
  185. * @Date 2024/5/28 18:03
  186. *
  187. * @param $roleId
  188. * @param $memberId
  189. * @return void
  190. * @throws BusinessException
  191. */
  192. public static function disposeAdded($roleId, $memberId)
  193. {
  194. $role = MemberRole::find($roleId);
  195. if (empty($role->member_role_rule_json)) {
  196. throw new BusinessException('增值套包数据异常');
  197. }
  198. $ruleJson = json_decode($role->member_role_rule_json, true);
  199. if (!isset($ruleJson['added'])) {
  200. throw new BusinessException('增值套包数据异常');
  201. }
  202. $addedId = $ruleJson['added'];
  203. $added = RuleAdded::find($addedId);
  204. if (!$added) {
  205. throw new BusinessException('增值套包数据异常');
  206. }
  207. $diff = $added->rule_added_goods_diff;
  208. $components = RuleAddedComponent::where('join_component_rule_added_id', $addedId)->get()->toArray();
  209. switch ($diff) {
  210. case "SUM":
  211. self::diffSum($memberId, $components);
  212. break;
  213. case "REPLACE":
  214. self::diffReplace($memberId, $components);
  215. break;
  216. case "NONE":
  217. self::diffNone($memberId, $components);
  218. }
  219. }
  220. /**
  221. * @Desc
  222. * @Author Gorden
  223. * @Date 2024/5/28 18:03
  224. *
  225. * @param $memberId
  226. * @param $components
  227. * @return void
  228. */
  229. public static function diffSum($memberId, $components)
  230. {
  231. foreach ($components as $component) {
  232. self::saveMemberQuota($memberId, $component);
  233. }
  234. }
  235. /**
  236. * @Desc
  237. * @Author Gorden
  238. * @Date 2024/5/28 18:02
  239. *
  240. * @param $memberId
  241. * @param $components
  242. * @return void
  243. */
  244. public static function diffReplace($memberId, $components)
  245. {
  246. foreach ($components as $component) {
  247. if (MemberQuota::where('join_quota_member_id', $memberId)->where('join_member_rule_added_component_id', $component['rule_added_component_id'])->exists()) {
  248. MemberQuota::where('join_quota_member_id', $memberId)
  249. ->where('join_member_rule_added_component_id', $component['rule_added_component_id'])
  250. ->where('member_quota_status', 'PENDING')
  251. ->delete();
  252. }
  253. self::saveMemberQuota($memberId, $component);
  254. }
  255. }
  256. /**
  257. * @Desc
  258. * @Author Gorden
  259. * @Date 2024/5/28 18:02
  260. *
  261. * @param $memberId
  262. * @param $components
  263. * @return void
  264. */
  265. public static function diffNone($memberId, $components)
  266. {
  267. foreach ($components as $component) {
  268. if (MemberQuota::where('join_quota_member_id', $memberId)->where('join_member_rule_added_component_id', $component['rule_added_component_id'])->exists()) {
  269. continue;
  270. }
  271. self::saveMemberQuota($memberId, $component);
  272. }
  273. }
  274. /**
  275. * @Desc
  276. * @Author Gorden
  277. * @Date 2024/5/28 18:02
  278. *
  279. * @param $memberId
  280. * @param $component
  281. * @return void
  282. */
  283. private static function saveMemberQuota($memberId, $component)
  284. {
  285. if ($component['rule_added_component_classify'] == 'MONTH') {
  286. $total = 12 * intval($component['rule_added_component_goods_nbr']);
  287. for ($i = 0; $i < $total; $i++) {
  288. self::doSaveMemberQuota($memberId, $component, 1);
  289. }
  290. } elseif ($component['rule_added_component_classify'] == 'YEAR') {
  291. if ($component['rule_added_component_goods_nbr'] == "-99.00") {
  292. self::doSaveMemberQuota($memberId, $component, -99);
  293. } else {
  294. for ($i = 0; $i < intval($component['rule_added_component_goods_nbr']); $i++) {
  295. self::doSaveMemberQuota($memberId, $component, 1);
  296. }
  297. }
  298. } else {
  299. if ($component['rule_added_component_goods_nbr'] == "-99.00") {
  300. self::doSaveMemberQuota($memberId, $component, -99);
  301. } else {
  302. for ($i = 0; $i < intval($component['rule_added_component_goods_nbr']); $i++) {
  303. self::doSaveMemberQuota($memberId, $component, 1);
  304. }
  305. }
  306. }
  307. }
  308. private static function doSaveMemberQuota($memberId, $component, $nbr)
  309. {
  310. $model = new MemberQuota();
  311. $model->member_quota_id = 'MQ' . date('ymdHi') . random_string(4, 'up');
  312. $model->join_quota_member_id = $memberId;
  313. $model->join_member_rule_added_component_id = $component['rule_added_component_id'];
  314. $model->member_quota_status = 'PENDING';
  315. $model->member_quota_category = $component['rule_added_component_category'];
  316. $model->member_quota_name = $component['rule_added_component_name'];
  317. $model->member_quota_nbr = $nbr;
  318. $model->member_quota_json = $component['rule_added_component_goods_json'];
  319. $model->member_quota_addtimes = time();
  320. $model->save();
  321. }
  322. /**
  323. * @Desc 充值前保存原账户数据
  324. * @Author Gorden
  325. * @Date 2024/10/14 9:18
  326. *
  327. * @param MemberAccount $memberAccount
  328. * @param $payAmount
  329. * @param $addedRate
  330. * @param $addedAmount
  331. * @return void
  332. * @throws BusinessException
  333. */
  334. public static function saveOriginData(MemberAccount $memberAccount, $payAmount, $addedRate, $addedAmount)
  335. {
  336. try {
  337. $memberAccount = $memberAccount->toArray();
  338. $memberAccount['pay_amount'] = $payAmount;
  339. $memberAccount['added_rate'] = $addedRate;
  340. $memberAccount['added_amount'] = $addedAmount;
  341. $member = Member::where('member_id', $memberAccount['join_account_member_id'])->first();
  342. $memberExtendJson = [];
  343. if (!empty($member->member_extend_json)) {
  344. $memberExtendJson = json_decode($member->member_extend_json, true);
  345. }
  346. $memberExtendJson['snap'][date('Y-m-d H:i:s')] = $memberAccount;
  347. $member->member_extend_json = json_encode($memberExtendJson);
  348. $member->save();
  349. } catch (\Exception $e) {
  350. throw new BusinessException('存储原数据失败');
  351. }
  352. }
  353. }