GroupActivityLogic.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379
  1. <?php
  2. namespace app\api\logic;
  3. use think\Exception;
  4. use think\facade\Db;
  5. use think\facade\Log;
  6. use app\common\enum\RefundEnum;
  7. use app\common\logic\BaseLogic;
  8. use app\common\logic\RefundLogic;
  9. use app\common\model\goods\Goods;
  10. use app\common\model\equity\UserEquity;
  11. use app\common\model\equity\EquityConfig;
  12. use app\common\model\refund\RefundRecord;
  13. use app\common\model\equity\UserEquityLog;
  14. use app\common\model\group_activity\GroupOrder;
  15. use app\common\service\wechat\WeChatMnpService;
  16. use app\common\model\group_activity\GroupActivity;
  17. use app\common\model\group_activity\GroupUserOrder;
  18. /**
  19. * 拼团活动逻辑处理
  20. * Class GroupActivityLogic
  21. * @package app\api\logic
  22. */
  23. class GroupActivityLogic extends BaseLogic
  24. {
  25. /**
  26. * @notes 拼团活动详情
  27. */
  28. public static function detail($id,$userId){
  29. $detail = GroupActivity::with('goods')->where(['id'=>$id])->visible([
  30. 'id','title','image','start_time','end_time','type','equity_id',
  31. 'participant_num','origin_price','price','form_time_limit'
  32. ])->findOrEmpty()->toArray();
  33. if(!empty($detail)){
  34. $detail['price'] = explode(",",$detail['price']);
  35. $detail['participant_num'] = explode(",",$detail['participant_num']);
  36. $detail['timestamp'] = time();
  37. $goods = Goods::where('id',$detail['goods']['goods_id'])->field('service_image,goods_category_id')->findOrEmpty()->toArray();
  38. $detail['goods'] = array_merge($detail['goods'],$goods);
  39. //查询用户是否已有付款订单
  40. $detail['order'] = GroupUserOrder::with('group_order')->where(['user_id'=>$userId,'group_activity_id'=>$detail['id'],'pay_status'=>1,'refund_status' => 0])->field('id,status,pay_way,pay_time,pay_status,remark,create_time,group_order_id')->findOrEmpty()->toArray();
  41. }
  42. return $detail;
  43. }
  44. /**
  45. * @notes 拼团订单详情
  46. */
  47. public static function orderDetail($sn,$url){
  48. $detail = GroupOrder::where(['sn'=>$sn])->findOrEmpty()->toArray();
  49. if(!empty($detail)){
  50. $detail['activity'] = GroupActivity::with('goods')->where(['id'=>$detail['group_activity_id']])->visible([
  51. 'id','title','image','start_time','end_time','type','equity_id',
  52. 'participant_num','origin_price','price','form_time_limit'
  53. ])->findOrEmpty()->toArray();
  54. $detail['users'] = GroupUserOrder::alias('a')
  55. ->leftJoin('user b','a.user_id=b.id')
  56. ->where(['a.sn'=>$sn,'a.status'=>1])
  57. ->field(['a.id','a.user_id','a.status','a.create_time','b.avatar','b.nickname'])
  58. ->order('a.create_time','asc')
  59. ->select()
  60. ->toArray();
  61. foreach($detail['users'] as &$item){
  62. if (strpos($item['avatar'], 'http') === false && !empty($item['avatar'])) {
  63. $item['avatar'] = config('custom.cdn_url').$item['avatar'];
  64. }
  65. }
  66. //如果开启了模拟成团,成团后,自动填补剩余人数
  67. if ($detail['status'] == 1 && $detail['num'] < $detail['activity']['participant_num']) {
  68. $num = $detail['activity']['participant_num'] - $detail['num'];
  69. $robot = self::getRobot($num,$url);
  70. $detail['users'] = array_merge($detail['users'],$robot);
  71. }
  72. $detail['timestamp'] = time();
  73. }
  74. return $detail;
  75. }
  76. //模拟用户
  77. private static function getRobot($num,$url){
  78. $nicknames = ["草莓啵啵熊","甜心小奶喵","清风吟月","浅梦逸云","静听花落","星辰浅语","云卷云舒间","花影舞流年","月色如水柔","暖阳","星辰","云舒","悠然","素心","晚晴","素心","清风","月白","静雅","不羁的灵魂","独行侠逸风","叛逆的旋律","冷傲冰爵","烈焰狂歌者","酷玩潮咖","神秘暗影侠","朋克精灵","暴走的音符","个性涂鸦师","墨染书香","青衫烟雨客","素笺淡墨痕","简逸","微光","清风","浅笑","逸梦","逸尘","浅念","澜影","默言","素笺","心屿","墨染","弦音","竹影","浅酌","暮雪","星辰","雨薇","凝霜","云岫","流萤","晨曦","浅夏","诗韵","逸云","浅唱"];
  79. shuffle($nicknames);
  80. $users = [];
  81. $num = $num > 10 ? 10 : $num;
  82. for ($i=0; $i < $num; $i++) {
  83. $users[] = [
  84. 'id' => 0,
  85. 'user_id' => 0,
  86. 'status' => 1,
  87. 'avatar' => $url.'/uploads/group_activity/robot/0be648e5767f18d6af2dbb630c53ba28'.rand(1,33).'.jpg',
  88. 'nickname' => $nicknames[$i],
  89. ];
  90. }
  91. return $users;
  92. }
  93. /**
  94. * @notes 用户订单详情
  95. */
  96. public static function userOrderDetail($sn,$userId){
  97. $detail = GroupUserOrder::with('groupOrder')->where(['sn'=>$sn, 'user_id' => $userId])->field('id,status,pay_way,pay_time,pay_status,refund_status,remark,create_time,group_order_id,user_equity_id')->findOrEmpty()->toArray();
  98. if ($detail) {
  99. $detail['is_refund'] = 0;
  100. if ($detail['pay_status'] == 1 && $detail['refund_status'] == 0) {
  101. if ($detail['user_equity_id'] > 0) {
  102. $detail['is_refund'] = UserEquityLog::where('user_equity_id', $detail['user_equity_id'])->count() > 0 ? 0 : 1;
  103. } else {
  104. $detail['is_refund'] = 1;
  105. }
  106. }
  107. $detail['goods'] = EquityConfig::where('id', $detail['groupOrder']['equity_id'])->field('id,equity_name,number,day_num')->findOrEmpty()->toArray();
  108. $detail['timestamp'] = time();
  109. }
  110. return $detail;
  111. }
  112. /**
  113. * 提交订单
  114. * @param array $params
  115. * @return array|false
  116. */
  117. public static function submitOrder($params)
  118. {
  119. Db::startTrans();
  120. try {
  121. $userOrder = GroupUserOrder::where(['group_activity_id' => $params['group_activity_id'], 'user_id' => $params['user_id']])->findOrEmpty()->toArray();
  122. if ($userOrder && $userOrder['pay_status'] == 1 && $userOrder['refund_status'] == 0) {
  123. throw new Exception('您已参加过该活动!');
  124. }
  125. //校验拼团活动
  126. if (empty($params['sn'])) {
  127. //如果已有团单,直接加入
  128. $groupOrder = GroupOrder::where(['group_activity_id' => $params['group_activity_id'],'user_id' => $params['user_id']])->findOrEmpty()->toArray();
  129. if (!$groupOrder) {
  130. //新开团
  131. $activity = GroupActivity::findOrEmpty($params['group_activity_id']); //活动详情
  132. if ($activity->isEmpty()) {
  133. throw new Exception('拼团活动不存在!'); //拼团活动不存在
  134. }
  135. //校验活动时间
  136. if (time() < strtotime($activity['start_time'])) {
  137. throw new Exception('拼团活动未开始!'); //拼团活动未开始
  138. }
  139. if (time() > $activity['end_time']) {
  140. throw new Exception('拼团活动已结束!'); //拼团活动已结束
  141. }
  142. $order_amount = explode(",",$activity['price'])[0];
  143. //生成拼团单
  144. $data = [
  145. 'sn' => generate_sn(GroupOrder::class, 'sn'),
  146. 'group_activity_id' => $params['group_activity_id'],
  147. 'equity_id' => $activity['equity_id'],
  148. 'goods_id' => EquityConfig::where('id', $activity['equity_id'])->value('goods_id'),
  149. 'user_id' => $params['user_id'],
  150. 'origin_price' => $activity['origin_price'],
  151. 'price' => $order_amount,
  152. 'create_time' => time(),
  153. 'end_time' => time() + $activity['form_time_limit'] * 60 * 60,
  154. ];
  155. $group_order = GroupOrder::create($data);
  156. }
  157. } else {
  158. //加入已开的拼团单
  159. $group_order = GroupOrder::where(['group_activity_id' => $params['group_activity_id'], 'sn' => $params['sn']])->findOrEmpty()->toArray();
  160. if (empty($group_order)) {
  161. throw new Exception('拼团订单不存在!'); //拼团活动不存在
  162. }
  163. if ($group_order['num'] >= 100) {
  164. throw new Exception('拼团人数已满!'); //拼团人数已满
  165. }
  166. if ($group_order['status'] == 1 ) {
  167. throw new Exception('活动已成团');
  168. }
  169. if ($group_order['status'] >= 1 ) {
  170. throw new Exception('拼团已取消!');
  171. }
  172. if ($group_order['end_time'] < time()) {
  173. throw new Exception('拼团活动已结束!'); //拼团活动已结束
  174. }
  175. $order_amount = $group_order['price'];
  176. }
  177. //生成用户拼单订单
  178. $data = [
  179. 'sn' => $group_order['sn'],
  180. 'group_order_id' => $group_order['id'],
  181. 'group_activity_id' => $params['group_activity_id'],
  182. 'user_id' => $params['user_id'],
  183. 'remark' => isset($params['remark']) ?? '',
  184. 'order_amount' => $order_amount,
  185. 'order_terminal' => $params['terminal'],
  186. ];
  187. if ($userOrder) {
  188. $data['create_time'] = time();
  189. $data['update_time'] = $data['delete_time'] = null;
  190. GroupUserOrder::where('id',$userOrder['id'])->update($data);
  191. } else {
  192. $userOrder = GroupUserOrder::create($data);
  193. }
  194. Db::commit();
  195. } catch (\Exception $e) {
  196. Db::rollback();
  197. self::setError($e->getMessage());
  198. return false;
  199. }
  200. return [
  201. 'order_id' => (int)$userOrder['id'],
  202. 'sn' => $group_order['sn']
  203. ];
  204. }
  205. /**
  206. * 取消订单
  207. * @param $params
  208. * @return false|void
  209. */
  210. public static function cancelOrder($params)
  211. {
  212. Db::startTrans();
  213. try {
  214. $detail = GroupUserOrder::where([
  215. 'user_id' => $params['user_id'],
  216. 'sn'=>$params['sn']
  217. ])->field('id,status')->findOrEmpty()->toArray();
  218. if(empty($detail)){
  219. throw new Exception('订单不存在');
  220. }
  221. if($detail['status'] == 1){
  222. throw new Exception('已支付订单不支持取消');
  223. }
  224. if($detail['status'] != 0){
  225. throw new Exception('当前订单不支持取消');
  226. }
  227. //将用户订单状态更新为已取消
  228. GroupUserOrder::where('id',$detail['id'])->update(['status' => 4, 'pay_status' => 2]);
  229. Db::commit();
  230. return true;
  231. }
  232. catch (\Exception $e) {
  233. Db::rollback();
  234. self::setError($e->getMessage());
  235. return false;
  236. }
  237. }
  238. /**
  239. * 订单退款
  240. * @param $params
  241. * @return false|void
  242. */
  243. public static function refundOrder($params)
  244. {
  245. Db::startTrans();
  246. try {
  247. $order = GroupUserOrder::where([
  248. 'user_id' => $params['user_id'],
  249. 'sn'=>$params['sn']
  250. ])->field('id,sn,status,order_amount,pay_status,pay_way,user_equity_id,user_id,order_terminal')->findOrEmpty()->toArray();
  251. if(empty($order)){
  252. throw new Exception('订单不存在');
  253. }
  254. if($order['status'] != 1 || $order['pay_status'] != 1){
  255. throw new Exception('当前订单不支持退款');
  256. }
  257. if ($order['user_equity_id']) {
  258. //判断权益卡是否已使用
  259. $used = UserEquityLog::where(['user_equity_id' => $order['user_equity_id'],'user_id' => $params['user_id']])->count();
  260. if ($used) {
  261. throw new Exception('当前权益卡已使用,不支持退款');
  262. }
  263. //删除用户权益卡
  264. $userEquity = UserEquity::where(['id' => $order['user_equity_id'],'user_id' => $params['user_id']])->findOrEmpty();
  265. $userEquity->delete();
  266. }
  267. //将用户订单状态更新为申请退款
  268. GroupUserOrder::where('id',$order['id'])->update(['status' => 3,'refund_status' => 1]);
  269. // 生成退款记录
  270. $recordSn = generate_sn(RefundRecord::class, 'sn');
  271. $record = RefundRecord::create([
  272. 'sn' => $recordSn,
  273. 'user_id' => $order['user_id'],
  274. 'order_id' => $order['id'],
  275. 'order_sn' => $order['sn'],
  276. 'order_type' => RefundEnum::ORDER_TYPE_GROUP,
  277. 'order_amount' => $order['order_amount'],
  278. 'refund_amount' => $order['order_amount'],
  279. 'refund_type' => RefundEnum::TYPE_ADMIN,
  280. 'transaction_id' => $order['transaction_id'] ?? '',
  281. 'refund_way' => RefundEnum::getRefundWayByPayWay($order['pay_way']),
  282. ]);
  283. // 退款
  284. $result = RefundLogic::refund($order, $record['id'], $order['order_amount'], 1);
  285. $flag = true;
  286. $resultMsg = '退款成功';
  287. if ($result !== true) {
  288. $flag = false;
  289. $resultMsg = RefundLogic::getError();
  290. }
  291. Db::commit();
  292. return [$flag, $resultMsg];
  293. }
  294. catch (\Exception $e) {
  295. Db::rollback();
  296. self::$error = $e->getMessage();
  297. return [false, $e->getMessage()];
  298. }
  299. }
  300. public static function deleteOrder($params):bool
  301. {
  302. try{
  303. $order = GroupUserOrder::where([
  304. 'user_id' => $params['user_id'],
  305. 'sn' => $params['sn']
  306. ])->findOrEmpty();
  307. if($order->isEmpty()){
  308. throw new \Exception('订单不存在');
  309. }
  310. if($order['status'] == 1){
  311. throw new Exception('已支付订单不支持删除');
  312. }
  313. $order->delete();
  314. return true;
  315. } catch(\Exception $e){
  316. self::setError($e->getMessage());
  317. return false;
  318. }
  319. }
  320. /**
  321. * 获取拼团订单分享二维码
  322. * @return string|void
  323. */
  324. public static function getQRCode($params,$url)
  325. {
  326. try {
  327. $mnp_page = 'pages/web_view/group';
  328. $scene_page = 'group';
  329. $response = (new WeChatMnpService())->getUnlimitedQRCode(
  330. 'page='.$scene_page.'&id='.$params['id'].'&sn='.$params['sn'],
  331. $mnp_page,
  332. env('miniprogram.mini_env_version', 'release'),
  333. false
  334. );
  335. $qrcode = $response->getContent();
  336. if(!is_dir('./uploads/wx_qrcode/'.date('Ymd'))){
  337. mkdir('./uploads/wx_qrcode/'.date('Ymd'));
  338. }
  339. $file_name = 'uploads/wx_qrcode/'.date('Ymd').'/'.time().rand(1000,9999).'.png';
  340. file_put_contents($file_name, $qrcode);
  341. return $url.'/'.$file_name;
  342. } catch (\Throwable $e) {
  343. Log::info('getQRCode:'.$e->getMessage());
  344. return '';
  345. }
  346. }
  347. }