RechargeService.php 14 KB

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