GroupActivityLogic.php 16 KB

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