V4Controller.php 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234
  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. //刷新用户信息
  17. public function GetUserinfo(Request $request)
  18. {
  19. $user = auth()->user();
  20. $userinfo = $user->profile();
  21. if (empty($userinfo)){
  22. return response()->json(['ret' => 0, 'msg' => "获取用户信息失败"]);
  23. }
  24. return response()->json(['ret' => 1, 'data' => $userinfo], 200);
  25. }
  26. public function checkNodeWeihu() {
  27. $query = Node::with(['onlineLogs', 'dailyDataFlows']);
  28. $nodeList = $query->where("country_code","=","hk")->get();
  29. $nodeOlin = [];
  30. foreach ($nodeList as $key => $node) {
  31. // 在线人数
  32. $online_log = $node->onlineLogs()->where('log_time', '>=', strtotime('-5 minutes'))->latest('log_time')->first();
  33. $online_users = $online_log->online_user ?? 0;
  34. $nodeOlin[$key]["name"] =$node->name;
  35. $nodeOlin[$key]["id"] =$node->id;
  36. $nodeOlin[$key]["online_user"] = $online_users;
  37. }
  38. // var_dump($nodeOlin); die();
  39. $logInfo = [];
  40. foreach ($nodeOlin as $key => $vva) {
  41. $input = [
  42. "status" => $vva["online_user"] > 10 ? 1 : 0
  43. ];
  44. $post = Node::find($vva["id"]);
  45. // var_dump($post["name"]);
  46. // var_dump($post["status"]); die();
  47. if($post->update($input)){
  48. $logInfo[$key]["id"] = $vva["id"];
  49. $logInfo[$key]["name"] =$vva["name"];
  50. $logInfo[$key]["status"] = "{$input["status"]}更新成功";
  51. }else{
  52. $logInfo[$key]["id"] = $vva["id"];
  53. $logInfo[$key]["name"] =$vva["name"];
  54. $logInfo[$key]["status"] = "{$input["status"]}更新失败";
  55. }
  56. // var_dump($logInfo);
  57. // die();
  58. }
  59. return response()->json(['ret' => 1, 'data' => $logInfo], 200);
  60. }
  61. public function GetV2rayNode(Request $request){
  62. $user = User::query();
  63. $node = Node::query();
  64. $userinfo = $user->where('email','=','17624688@qq.com')->get();
  65. //$query = $query->nodes()->with(['labels', 'level_table','onlineLogs']);
  66. $retlist = $node->where('type','=',2)->get();
  67. $servers = [];
  68. foreach ($retlist as $key => $v ){
  69. $servers[] = $v->config($userinfo[0]);
  70. }
  71. return (new ClientController)->config("", $userinfo[0], $servers);
  72. //return response()->json(['ret' => 1, 'data' => $servers]);
  73. //return response()->json(['ret' => 1, 'data' => ['userinfo'=>$userinfo,'servers'=>$servers],'']);
  74. }
  75. public function AutoNode(Request $request){
  76. $auth_user = auth()->user();
  77. //select b.node_id, max(b.online_user) as online_user from node_online_log as b group by b.node_id
  78. $sub_query = 'select b.node_id, max(b.online_user) as online_user from node_online_log as b group by b.node_id';
  79. $query = Node::query();
  80. //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
  81. //limit 1
  82. $nodeList = $query->from(DB::raw('('.$sub_query.') as a'))
  83. ->leftJoin('node as bb','bb.id','=','a.node_id')
  84. ->where('bb.country_code','=','hk')
  85. ->groupBy('a.online_user')
  86. ->limit(1)
  87. ->get(['a.online_user','bb.*']);
  88. $keys = "online_users";
  89. foreach ($nodeList as $key => $v ){
  90. $servers = $v->config($auth_user);
  91. $servers[$keys] = $v["online_user"];
  92. }
  93. return response()->json(['ret' => 1, 'data' => $servers], 200);
  94. }
  95. /**
  96. * 获取全部节点
  97. * @param int|null $id
  98. * @return \Illuminate\Http\JsonResponse
  99. */
  100. public function nodeList(Request $request,int $id = null)
  101. {
  102. $isVless = $request->input("vless");
  103. $debug = $request->input("isdebug");
  104. $user = auth()->user();
  105. $query = $user->nodes()->with(['labels', 'level_table','onlineLogs']);
  106. if (empty($isVless)){
  107. $isVless = 0;
  108. }
  109. if ($isVless == 1){
  110. $nodeList = $query->orderByDesc('sort')->orderBy('id')->get();
  111. } else {
  112. $nodeList = $query->where("vless",'=',0)->orderByDesc('sort')->orderBy('id')->get();
  113. }
  114. if(isset($debug))
  115. {
  116. foreach ($nodeList as $node) {
  117. // 在线人数
  118. $online_log = $node->onlineLogs()->where('log_time', '>=', strtotime('-5 minutes'))->latest('log_time')->first();
  119. $node->leables = $node->labels;
  120. $node->online_users = $online_log->online_user ?? 0;
  121. $firstnode[] = $node;
  122. }
  123. foreach ($firstnode as $key => $val){
  124. $namesString = "";
  125. foreach ($firstnode[$key]["leables"] as $label) {
  126. $namesString .= $label["name"] . ", ";
  127. }
  128. // 移除最后一个逗号和空格
  129. $namesString = rtrim($namesString, ", ");
  130. $servers[] = $val->config($user);
  131. $servers[$key]["ip"] = $firstnode[$key]["ip"];
  132. $servers[$key]["online_users"] = $firstnode[$key]["online_users"];
  133. $servers[$key]["leables"] = $namesString;
  134. $servers[$key]["leables_level"] = $firstnode[$key]["level_table"]["level"];
  135. $servers[$key]["country_code"] = $firstnode[$key]["country_code"];
  136. }
  137. return response()->json($servers);
  138. }
  139. //var_dump($nodes); die();
  140. if (isset($id)) {
  141. $nodes = $user->nodes()->get();
  142. $node = $nodes->find($id);
  143. if (empty($node)) {
  144. return response()->json([], 204);
  145. }
  146. return response()->json($node->config($user));
  147. }
  148. $temp = array();
  149. $servers = [];
  150. $firstnode = [];
  151. foreach ($nodeList as $node) {
  152. // 在线人数
  153. $online_log = $node->onlineLogs()->where('log_time', '>=', strtotime('-5 minutes'))->latest('log_time')->first();
  154. $node->leables = $node->labels;
  155. $node->online_users = $online_log->online_user ?? 0;
  156. $firstnode[] = $node;
  157. }
  158. foreach ($firstnode as $key => $val){
  159. $namesString = "";
  160. foreach ($firstnode[$key]["leables"] as $label) {
  161. $namesString .= $label["name"] . ", ";
  162. }
  163. $namesString = rtrim($namesString, ", ");
  164. $servers[] = $val->config($user);
  165. $servers[$key]["ip"] = $firstnode[$key]["ip"];
  166. $servers[$key]["online_users"] = $firstnode[$key]["online_users"];
  167. $servers[$key]["country_code"] = $firstnode[$key]["country_code"];
  168. $servers[$key]["leables"] = $namesString;
  169. $servers[$key]["leables_level"] = $firstnode[$key]["level_table"]["level"];
  170. $servers[$key]["traffic_rate"] = $firstnode[$key]["traffic_rate"];
  171. }
  172. return response()->json(['ret' => 1, 'data' => $servers]);
  173. }
  174. public function UserDis(Request $request){
  175. $id = $request->input('id');
  176. // 从请求中获取需要更新的数据
  177. $data = [
  178. 'enable' => 0,
  179. 'expired_at' => '2023-05-01 15:35:19',
  180. 'remark' => '已经退款'
  181. ];
  182. // 使用Eloquent ORM查找对应的用户记录
  183. $user = User::find($id);
  184. // 使用update()方法更新用户记录
  185. return $user->update($data);
  186. }
  187. }