RechargeService.php 14 KB

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