V4Controller.php 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161
  1. <?php
  2. namespace App\Http\Controllers\Api\Client;
  3. use App\Http\Controllers\ClientController;
  4. use App\Http\Controllers\Controller;
  5. use App\Models\Node;
  6. use App\Models\User;
  7. use Illuminate\Http\Request;
  8. use DB;
  9. class V4Controller extends Controller
  10. {
  11. public function __construct()
  12. {
  13. $this->middleware('auth:api')->except('login', 'register', 'shop', 'getConfig','version','buy','ClashConfig','getsysconfig','GetV2rayNode','checkNodeWeihu','UserDis');
  14. auth()->shouldUse('api');
  15. }
  16. public function checkNodeWeihu() {
  17. $query = Node::with(['onlineLogs', 'dailyDataFlows']);
  18. $nodeList = $query->where("country_code","=","hk")->get();
  19. $nodeOlin = [];
  20. foreach ($nodeList as $key => $node) {
  21. // 在线人数
  22. $online_log = $node->onlineLogs()->where('log_time', '>=', strtotime('-5 minutes'))->latest('log_time')->first();
  23. $online_users = $online_log->online_user ?? 0;
  24. $nodeOlin[$key]["name"] =$node->name;
  25. $nodeOlin[$key]["id"] =$node->id;
  26. $nodeOlin[$key]["online_user"] = $online_users;
  27. }
  28. // var_dump($nodeOlin); die();
  29. $logInfo = [];
  30. foreach ($nodeOlin as $key => $vva) {
  31. $input = [
  32. "status" => $vva["online_user"] > 10 ? 1 : 0
  33. ];
  34. $post = Node::find($vva["id"]);
  35. // var_dump($post["name"]);
  36. // var_dump($post["status"]); die();
  37. if($post->update($input)){
  38. $logInfo[$key]["id"] = $vva["id"];
  39. $logInfo[$key]["name"] =$vva["name"];
  40. $logInfo[$key]["status"] = "{$input["status"]}更新成功";
  41. }else{
  42. $logInfo[$key]["id"] = $vva["id"];
  43. $logInfo[$key]["name"] =$vva["name"];
  44. $logInfo[$key]["status"] = "{$input["status"]}更新失败";
  45. }
  46. // var_dump($logInfo);
  47. // die();
  48. }
  49. return response()->json(['ret' => 1, 'data' => $logInfo], 200);
  50. }
  51. public function GetV2rayNode(Request $request){
  52. $user = User::query();
  53. $node = Node::query();
  54. $userinfo = $user->where('email','=','17624688@qq.com')->get();
  55. //$query = $query->nodes()->with(['labels', 'level_table','onlineLogs']);
  56. $retlist = $node->where('type','=',2)->get();
  57. $servers = [];
  58. foreach ($retlist as $key => $v ){
  59. $servers[] = $v->config($userinfo[0]);
  60. }
  61. return (new ClientController)->config("", $userinfo[0], $servers);
  62. //return response()->json(['ret' => 1, 'data' => $servers]);
  63. //return response()->json(['ret' => 1, 'data' => ['userinfo'=>$userinfo,'servers'=>$servers],'']);
  64. }
  65. public function AutoNode(Request $request){
  66. $auth_user = auth()->user();
  67. //select b.node_id, max(b.online_user) as online_user from node_online_log as b group by b.node_id
  68. $sub_query = 'select b.node_id, max(b.online_user) as online_user from node_online_log as b group by b.node_id';
  69. $query = Node::query();
  70. //select aa.online_user, aa.node_id, bb.* from (select b.node_id, max(log_time), b.online_user from node_online_log as b group by b.node_id) as aa left join node as bb on bb.id = aa.node_id where bb.country_code = 'hk' group by aa.online_user
  71. //limit 1
  72. $nodeList = $query->from(DB::raw('('.$sub_query.') as a'))
  73. ->leftJoin('node as bb','bb.id','=','a.node_id')
  74. ->where('bb.country_code','=','hk')
  75. ->groupBy('a.online_user')
  76. ->limit(1)
  77. ->get(['a.online_user','bb.*']);
  78. $keys = "online_users";
  79. foreach ($nodeList as $key => $v ){
  80. $servers = $v->config($auth_user);
  81. $servers[$keys] = $v["online_user"];
  82. }
  83. return response()->json(['ret' => 1, 'data' => $servers], 200);
  84. }
  85. /**
  86. * 获取全部节点
  87. * @param int|null $id
  88. * @return \Illuminate\Http\JsonResponse
  89. */
  90. public function nodeList(int $id = null)
  91. {
  92. $user = auth()->user();
  93. $query = $user->nodes()->with(['labels', 'level_table','onlineLogs']);
  94. $nodeList = $query->orderByDesc('sort')->orderBy('id')->get();
  95. //var_dump($nodes); die();
  96. if (isset($id)) {
  97. $nodes = $user->nodes()->get();
  98. $node = $nodes->find($id);
  99. if (empty($node)) {
  100. return response()->json([], 204);
  101. }
  102. return response()->json($node->config($user));
  103. }
  104. $temp = array();
  105. $servers = [];
  106. $firstnode = [];
  107. foreach ($nodeList as $node) {
  108. // 在线人数
  109. $online_log = $node->onlineLogs()->where('log_time', '>=', strtotime('-5 minutes'))->latest('log_time')->first();
  110. $node->online_users = $online_log->online_user ?? 0;
  111. $firstnode[] = $node;
  112. }
  113. foreach ($firstnode as $key => $val){
  114. $servers[] = $val->config($user);
  115. $servers[$key]["ip"] = $firstnode[$key]["ip"];
  116. $servers[$key]["online_users"] = $firstnode[$key]["online_users"];
  117. $servers[$key]["country_code"] = $firstnode[$key]["country_code"];
  118. }
  119. return response()->json(['ret' => 1, 'data' => $servers]);
  120. }
  121. public function UserDis(Request $request){
  122. $id = $request->input('id');
  123. // 从请求中获取需要更新的数据
  124. $data = [
  125. 'enable' => 0,
  126. 'expired_at' => '2023-05-01 15:35:19',
  127. 'remark' => '已经退款'
  128. ];
  129. // 使用Eloquent ORM查找对应的用户记录
  130. $user = User::find($id);
  131. // 使用update()方法更新用户记录
  132. return $user->update($data);
  133. }
  134. }