GroupActivityLogic.php 16 KB

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