AlipayController.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279
  1. <?php
  2. namespace App\Http\Controllers\Api;
  3. use App\Components\AlipayNotify;
  4. use App\Components\Helpers;
  5. use App\Http\Controllers\Controller;
  6. use App\Http\Models\Goods;
  7. use App\Http\Models\GoodsLabel;
  8. use App\Http\Models\Order;
  9. use App\Http\Models\Payment;
  10. use App\Http\Models\SsNode;
  11. use App\Http\Models\SsNodeLabel;
  12. use App\Http\Models\User;
  13. use App\Http\Models\UserLabel;
  14. use App\Mail\sendUserInfo;
  15. use DB;
  16. use Hash;
  17. use Illuminate\Http\Request;
  18. use Log;
  19. use Mail;
  20. /**
  21. * Class AlipayController
  22. *
  23. * @author wz812180
  24. *
  25. * @package App\Http\Controllers\Api
  26. */
  27. class AlipayController extends Controller
  28. {
  29. protected static $systemConfig;
  30. function __construct()
  31. {
  32. self::$systemConfig = Helpers::systemConfig();
  33. }
  34. // 接收GET请求
  35. public function index(Request $request)
  36. {
  37. \Log::info("【支付宝国际】回调接口[GET]:" . var_export($request->all(), true) . '[' . getClientIp() . ']');
  38. exit("【支付宝国际】接口正常");
  39. }
  40. // 接收POST请求
  41. public function store(Request $request)
  42. {
  43. \Log::info("【支付宝国际】回调接口[POST]:" . var_export($request->all(), true));
  44. $result = "fail";
  45. $alipayNotify = new AlipayNotify(self::$systemConfig['alipay_sign_type'], self::$systemConfig['alipay_partner'], self::$systemConfig['alipay_key'], self::$systemConfig['alipay_private_key'], self::$systemConfig['alipay_public_key'], self::$systemConfig['alipay_transport']);
  46. // 验证支付宝交易
  47. $verify_result = $alipayNotify->verifyNotify();
  48. if ($verify_result) { // 验证成功
  49. $result = "success";
  50. if ($_POST['trade_status'] == 'TRADE_FINISHED' || $_POST['trade_status'] == 'TRADE_SUCCESS') {
  51. // 商户订单号
  52. $data = [];
  53. $data['out_trade_no'] = $request->get('out_trade_no');
  54. // 支付宝交易号
  55. $data['trade_no'] = $request->get('trade_no');
  56. // 交易状态
  57. $data['trade_status'] = $request->get('trade_status');
  58. // 交易金额(这里是按照结算货币汇率的金额,和rmb_fee不相等)
  59. $data['total_fee'] = $request->get('total_fee');
  60. $this->tradePaid($data);
  61. } else {
  62. Log::info('AliPay-POST:交易失败[' . getClientIp() . ']');
  63. }
  64. } else {
  65. Log::info('AliPay-POST:验证失败[' . getClientIp() . ']');
  66. }
  67. // 返回验证结果
  68. exit($result);
  69. }
  70. // 交易支付
  71. private function tradePaid($msg)
  72. {
  73. Log::info('【支付宝国际】回调交易支付');
  74. // 获取未完成状态的订单防止重复增加时间
  75. $payment = Payment::query()->with(['order', 'order.goods'])->where('status', 0)->where('order_sn', $msg['out_trade_no'])->first();
  76. if (!$payment) {
  77. Log::info('【支付宝国际】回调订单不存在');
  78. return;
  79. }
  80. // 处理订单
  81. DB::beginTransaction();
  82. try {
  83. // 如果支付单中没有用户信息则创建一个用户
  84. if (!$payment->user_id) {
  85. // 生成一个可用端口
  86. $port = self::$systemConfig['is_rand_port'] ? Helpers::getRandPort() : Helpers::getOnlyPort();
  87. $user = new User();
  88. $user->username = '自动生成-' . $payment->order->email;
  89. $user->password = Hash::make(makeRandStr());
  90. $user->port = $port;
  91. $user->passwd = makeRandStr();
  92. $user->vmess_id = createGuid();
  93. $user->enable = 1;
  94. $user->method = Helpers::getDefaultMethod();
  95. $user->protocol = Helpers::getDefaultProtocol();
  96. $user->obfs = Helpers::getDefaultObfs();
  97. $user->usage = 1;
  98. $user->transfer_enable = 1; // 新创建的账号给1,防止定时任务执行时发现u + d >= transfer_enable被判为流量超限而封禁
  99. $user->enable_time = date('Y-m-d');
  100. $user->expire_time = date('Y-m-d', strtotime("+" . $payment->order->goods->days . " days"));
  101. $user->reg_ip = getClientIp();
  102. $user->referral_uid = 0;
  103. $user->traffic_reset_day = 0;
  104. $user->status = 1;
  105. $user->save();
  106. if ($user->id) {
  107. Order::query()->where('oid', $payment->oid)->update(['user_id' => $user->id]);
  108. }
  109. }
  110. // 更新支付单
  111. $payment->pay_way = 2; // 1-微信、2-支付宝
  112. $payment->status = 1;
  113. $payment->save();
  114. // 更新订单
  115. $order = Order::query()->with(['user'])->where('oid', $payment->oid)->first();
  116. $order->status = 2;
  117. $order->save();
  118. $goods = Goods::query()->where('id', $order->goods_id)->first();
  119. // 商品为流量或者套餐
  120. if ($goods->type <= 2) {
  121. // 如果买的是套餐,则先将之前购买的所有套餐置都无效,并扣掉之前所有套餐的流量,重置用户已用流量为0
  122. if ($goods->type == 2) {
  123. $existOrderList = Order::query()
  124. ->with(['goods'])
  125. ->whereHas('goods', function ($q) {
  126. $q->where('type', 2);
  127. })
  128. ->where('user_id', $order->user_id)
  129. ->where('oid', '<>', $order->oid)
  130. ->where('is_expire', 0)
  131. ->where('status', 2)
  132. ->get();
  133. foreach ($existOrderList as $vo) {
  134. Order::query()->where('oid', $vo->oid)->update(['is_expire' => 1]);
  135. // 先判断,防止手动扣减过流量的用户流量被扣成负数
  136. if ($order->user->transfer_enable - $vo->goods->traffic * 1048576 <= 0) {
  137. // 写入用户流量变动记录
  138. Helpers::addUserTrafficModifyLog($order->user_id, $order->oid, 0, 0, '[在线支付]用户购买套餐,先扣减之前套餐的流量(扣完)');
  139. User::query()->where('id', $order->user_id)->update(['u' => 0, 'd' => 0, 'transfer_enable' => 0]);
  140. } else {
  141. // 写入用户流量变动记录
  142. $user = User::query()->where('id', $order->user_id)->first(); // 重新取出user信息
  143. Helpers::addUserTrafficModifyLog($order->user_id, $order->oid, $user->transfer_enable, ($user->transfer_enable - $vo->goods->traffic * 1048576), '[在线支付]用户购买套餐,先扣减之前套餐的流量(未扣完)');
  144. User::query()->where('id', $order->user_id)->update(['u' => 0, 'd' => 0]);
  145. User::query()->where('id', $order->user_id)->decrement('transfer_enable', $vo->goods->traffic * 1048576);
  146. }
  147. }
  148. }
  149. // 写入用户流量变动记录
  150. $user = User::query()->where('id', $order->user_id)->first(); // 重新取出user信息
  151. Helpers::addUserTrafficModifyLog($order->user_id, $order->oid, $user->transfer_enable, ($user->transfer_enable + $goods->traffic * 1048576), '[在线支付]用户购买商品,加上流量');
  152. // 把商品的流量加到账号上
  153. User::query()->where('id', $order->user_id)->increment('transfer_enable', $goods->traffic * 1048576);
  154. // 计算账号过期时间
  155. if ($order->user->expire_time < date('Y-m-d', strtotime("+" . $goods->days . " days"))) {
  156. $expireTime = date('Y-m-d', strtotime("+" . $goods->days . " days"));
  157. } else {
  158. $expireTime = $order->user->expire_time;
  159. }
  160. // 套餐就改流量重置日,流量包不改
  161. if ($goods->type == 2) {
  162. if (date('m') == 2 && date('d') == 29) {
  163. $traffic_reset_day = 28;
  164. } else {
  165. $traffic_reset_day = date('d') == 31 ? 30 : abs(date('d'));
  166. }
  167. User::query()->where('id', $order->user_id)->update(['traffic_reset_day' => $traffic_reset_day, 'expire_time' => $expireTime, 'enable' => 1]);
  168. } else {
  169. User::query()->where('id', $order->user_id)->update(['expire_time' => $expireTime, 'enable' => 1]);
  170. }
  171. // 写入用户标签
  172. if ($goods->label) {
  173. // 用户默认标签
  174. $defaultLabels = [];
  175. if (self::$systemConfig['initial_labels_for_user']) {
  176. $defaultLabels = explode(',', self::$systemConfig['initial_labels_for_user']);
  177. }
  178. // 取出现有的标签
  179. $userLabels = UserLabel::query()->where('user_id', $order->user_id)->pluck('label_id')->toArray();
  180. $goodsLabels = GoodsLabel::query()->where('goods_id', $order->goods_id)->pluck('label_id')->toArray();
  181. // 标签去重
  182. $newUserLabels = array_values(array_unique(array_merge($userLabels, $goodsLabels, $defaultLabels)));
  183. // 删除用户所有标签
  184. UserLabel::query()->where('user_id', $order->user_id)->delete();
  185. // 生成标签
  186. foreach ($newUserLabels as $vo) {
  187. $obj = new UserLabel();
  188. $obj->user_id = $order->user_id;
  189. $obj->label_id = $vo;
  190. $obj->save();
  191. }
  192. }
  193. // 写入返利日志
  194. if ($order->user->referral_uid) {
  195. $this->addReferralLog($order->user_id, $order->user->referral_uid, $order->oid, $order->amount, $order->amount * self::$systemConfig['referral_percent']);
  196. }
  197. // 取消重复返利
  198. User::query()->where('id', $order->user_id)->update(['referral_uid' => 0]);
  199. } elseif ($goods->type == 3) { // 商品为在线充值
  200. User::query()->where('id', $order->user_id)->increment('balance', $goods->price * 100);
  201. // 余额变动记录日志
  202. $this->addUserBalanceLog($order->user_id, $order->oid, $order->user->balance, $order->user->balance + $goods->price, $goods->price, '用户在线充值');
  203. }
  204. // 自动提号机:如果order的email值不为空
  205. if ($order->email) {
  206. $title = '自动发送账号信息';
  207. $content = [
  208. 'order_sn' => $order->order_sn,
  209. 'goods_name' => $order->goods->name,
  210. 'goods_traffic' => flowAutoShow($order->goods->traffic * 1048576),
  211. 'port' => $order->user->port,
  212. 'passwd' => $order->user->passwd,
  213. 'method' => $order->user->method,
  214. //'protocol' => $order->user->protocol,
  215. //'protocol_param' => $order->user->protocol_param,
  216. //'obfs' => $order->user->obfs,
  217. //'obfs_param' => $order->user->obfs_param,
  218. 'created_at' => $order->created_at->toDateTimeString(),
  219. 'expire_at' => $order->expire_at
  220. ];
  221. // 获取可用节点列表
  222. $labels = UserLabel::query()->where('user_id', $order->user_id)->get()->pluck('label_id');
  223. $nodeIds = SsNodeLabel::query()->whereIn('label_id', $labels)->get()->pluck('node_id');
  224. $nodeList = SsNode::query()->whereIn('id', $nodeIds)->orderBy('sort', 'desc')->orderBy('id', 'desc')->get()->toArray();
  225. $content['serverList'] = $nodeList;
  226. $logId = Helpers::addEmailLog($order->email, $title, json_encode($content));
  227. Mail::to($order->email)->send(new sendUserInfo($logId, $content));
  228. }
  229. DB::commit();
  230. } catch (\Exception $e) {
  231. DB::rollBack();
  232. Log::info('【支付宝国际】回调更新支付单和订单异常:' . $e->getMessage());
  233. }
  234. }
  235. public function show(Request $request)
  236. {
  237. exit('show');
  238. }
  239. }