AdminController.php 82 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Components\Helpers;
  4. use App\Components\IPIP;
  5. use App\Components\NetworkDetection;
  6. use App\Components\PushNotification;
  7. use App\Components\QQWry;
  8. use App\Http\Models\Article;
  9. use App\Http\Models\Config;
  10. use App\Http\Models\Country;
  11. use App\Http\Models\Invite;
  12. use App\Http\Models\Label;
  13. use App\Http\Models\Level;
  14. use App\Http\Models\NotificationLog;
  15. use App\Http\Models\Order;
  16. use App\Http\Models\ReferralApply;
  17. use App\Http\Models\ReferralLog;
  18. use App\Http\Models\SsConfig;
  19. use App\Http\Models\SsGroup;
  20. use App\Http\Models\SsGroupNode;
  21. use App\Http\Models\SsNode;
  22. use App\Http\Models\SsNodeInfo;
  23. use App\Http\Models\SsNodeIp;
  24. use App\Http\Models\SsNodeLabel;
  25. use App\Http\Models\SsNodeOnlineLog;
  26. use App\Http\Models\SsNodePing;
  27. use App\Http\Models\SsNodeTrafficDaily;
  28. use App\Http\Models\SsNodeTrafficHourly;
  29. use App\Http\Models\User;
  30. use App\Http\Models\UserBalanceLog;
  31. use App\Http\Models\UserBanLog;
  32. use App\Http\Models\UserLabel;
  33. use App\Http\Models\UserLoginLog;
  34. use App\Http\Models\UserSubscribe;
  35. use App\Http\Models\UserTrafficDaily;
  36. use App\Http\Models\UserTrafficHourly;
  37. use App\Http\Models\UserTrafficLog;
  38. use App\Http\Models\UserTrafficModifyLog;
  39. use Auth;
  40. use DB;
  41. use Exception;
  42. use Hash;
  43. use Illuminate\Http\Request;
  44. use Log;
  45. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  46. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  47. use Redirect;
  48. use Response;
  49. use Session;
  50. /**
  51. * 管理员控制器
  52. *
  53. * Class AdminController
  54. *
  55. * @package App\Http\Controllers
  56. */
  57. class AdminController extends Controller
  58. {
  59. protected static $systemConfig;
  60. function __construct()
  61. {
  62. self::$systemConfig = Helpers::systemConfig();
  63. }
  64. public function index()
  65. {
  66. $past = strtotime(date('Y-m-d', strtotime("-".self::$systemConfig['expire_days']." days")));
  67. $view['expireDays'] = self::$systemConfig['expire_days'];
  68. $view['totalUserCount'] = User::query()->count(); // 总用户数
  69. $view['enableUserCount'] = User::query()->whereEnable(1)->count(); // 有效用户数
  70. $view['activeUserCount'] = User::query()->where('t', '>=', $past)->count(); // 活跃用户数
  71. $view['unActiveUserCount'] = User::query()->where('t', '<=', $past)->whereEnable(1)->where('t', '>', 0)->count(); // 不活跃用户数
  72. $view['onlineUserCount'] = User::query()->where('t', '>=', time()-600)->count(); // 10分钟内在线用户数
  73. $view['expireWarningUserCount'] = User::query()->where('expire_time', '>=', date('Y-m-d', strtotime("now")))->where('expire_time', '<=', date('Y-m-d', strtotime("+".self::$systemConfig['expire_days']." days")))->count(); // 临近过期用户数
  74. $view['largeTrafficUserCount'] = User::query()->whereRaw('(u + d) >= 107374182400')->whereIn('status', [0, 1])->count(); // 流量超过100G的用户
  75. // 1小时内流量异常用户
  76. $tempUsers = [];
  77. $userTotalTrafficList = UserTrafficHourly::query()->whereNodeId(0)->where('total', '>', 104857600)->where('created_at', '>=', date('Y-m-d H:i:s', time()-3900))->groupBy('user_id')->selectRaw("user_id, sum(total) as totalTraffic")->get(); // 只统计100M以上的记录,加快速度
  78. if(!$userTotalTrafficList->isEmpty()){
  79. foreach($userTotalTrafficList as $vo){
  80. if($vo->totalTraffic > (self::$systemConfig['traffic_ban_value']*1073741824)){
  81. $tempUsers[] = $vo->user_id;
  82. }
  83. }
  84. }
  85. $view['flowAbnormalUserCount'] = User::query()->whereIn('id', $tempUsers)->count();
  86. $view['nodeCount'] = SsNode::query()->count();
  87. $view['unnormalNodeCount'] = SsNode::query()->whereStatus(0)->count();
  88. $flowCount = SsNodeTrafficDaily::query()->where('created_at', '>=', date('Y-m-d 00:00:00', strtotime("-30 days")))->sum('total');
  89. $view['flowCount'] = flowAutoShow($flowCount);
  90. $totalFlowCount = SsNodeTrafficDaily::query()->sum('total');
  91. $view['totalFlowCount'] = flowAutoShow($totalFlowCount);
  92. $view['totalBalance'] = User::query()->sum('balance')/100;
  93. $view['totalWaitRefAmount'] = ReferralLog::query()->whereIn('status', [0, 1])->sum('ref_amount')/100;
  94. $view['totalRefAmount'] = ReferralApply::query()->whereStatus(2)->sum('amount')/100;
  95. $view['totalOrder'] = Order::query()->count();
  96. $view['totalOnlinePayOrder'] = Order::query()->wherePayWay(2)->count();
  97. $view['totalSuccessOrder'] = Order::query()->whereStatus(2)->count();
  98. $view['todaySuccessOrder'] = Order::query()->whereStatus(2)->where('created_at', '>=', date('Y-m-d 00:00:00'))->where('created_at', '<=', date('Y-m-d 23:59:59'))->count();
  99. return Response::view('admin.index', $view);
  100. }
  101. // 用户列表
  102. public function userList(Request $request)
  103. {
  104. $id = $request->input('id');
  105. $email = $request->input('email');
  106. $wechat = $request->input('wechat');
  107. $qq = $request->input('qq');
  108. $port = $request->input('port');
  109. $pay_way = $request->input('pay_way');
  110. $status = $request->input('status');
  111. $enable = $request->input('enable');
  112. $online = $request->input('online');
  113. $unActive = $request->input('unActive');
  114. $flowAbnormal = $request->input('flowAbnormal');
  115. $expireWarning = $request->input('expireWarning');
  116. $largeTraffic = $request->input('largeTraffic');
  117. $query = User::query()->with(['subscribe']);
  118. if(isset($id)){
  119. $query->whereId($id);
  120. }
  121. if(isset($email)){
  122. $query->where('email', 'like', '%'.$email.'%');
  123. }
  124. if(isset($wechat)){
  125. $query->where('wechat', 'like', '%'.$wechat.'%');
  126. }
  127. if(isset($qq)){
  128. $query->where('qq', 'like', '%'.$qq.'%');
  129. }
  130. if(isset($port)){
  131. $query->wherePort($port);
  132. }
  133. if(isset($pay_way)){
  134. $query->wherePayWay($pay_way);
  135. }
  136. if(isset($status)){
  137. $query->whereStatus($status);
  138. }
  139. if(isset($enable)){
  140. $query->whereEnable($enable);
  141. }
  142. // 流量超过100G的
  143. if($largeTraffic){
  144. $query->whereIn('status', [0, 1])->whereRaw('(u + d) >= 107374182400');
  145. }
  146. // 临近过期提醒
  147. if($expireWarning){
  148. $query->where('expire_time', '>=', date('Y-m-d'))->where('expire_time', '<=', date('Y-m-d', strtotime("+".self::$systemConfig['expire_days']." days")));
  149. }
  150. // 当前在线
  151. if($online){
  152. $query->where('t', '>=', time()-600);
  153. }
  154. // 不活跃用户
  155. if($unActive){
  156. $query->where('t', '>', 0)->where('t', '<=', strtotime(date('Y-m-d', strtotime("-".self::$systemConfig['expire_days']." days"))))->whereEnable(1);
  157. }
  158. // 1小时内流量异常用户
  159. if($flowAbnormal){
  160. $tempUsers = [];
  161. $userTotalTrafficList = UserTrafficHourly::query()->whereNodeId(0)->where('total', '>', 104857600)->where('created_at', '>=', date('Y-m-d H:i:s', time()-3900))->groupBy('user_id')->selectRaw("user_id, sum(total) as totalTraffic")->get(); // 只统计100M以上的记录,加快速度
  162. if(!$userTotalTrafficList->isEmpty()){
  163. foreach($userTotalTrafficList as $vo){
  164. if($vo->totalTraffic > (self::$systemConfig['traffic_ban_value']*1024*1024*1024)){
  165. $tempUsers[] = $vo->user_id;
  166. }
  167. }
  168. }
  169. $query->whereIn('id', $tempUsers);
  170. }
  171. $userList = $query->orderBy('id', 'desc')->paginate(15)->appends($request->except('page'));
  172. foreach($userList as $user){
  173. $user->transfer_enable = flowAutoShow($user->transfer_enable);
  174. $user->used_flow = flowAutoShow($user->u+$user->d);
  175. if($user->expire_time < date('Y-m-d')){
  176. $user->expireWarning = -1; // 已过期
  177. }elseif($user->expire_time == date('Y-m-d')){
  178. $user->expireWarning = 0; // 今天过期
  179. }elseif($user->expire_time > date('Y-m-d') && $user->expire_time <= date('Y-m-d', strtotime("+30 days"))){
  180. $user->expireWarning = 1; // 最近一个月过期
  181. }else{
  182. $user->expireWarning = 2; // 大于一个月过期
  183. }
  184. // 流量异常警告
  185. $time = date('Y-m-d H:i:s', time()-3900);
  186. $totalTraffic = UserTrafficHourly::query()->whereUserId($user->id)->whereNodeId(0)->where('created_at', '>=', $time)->sum('total');
  187. $user->trafficWarning = $totalTraffic > (self::$systemConfig['traffic_ban_value']*1024*1024*1024)? 1 : 0;
  188. // 订阅地址
  189. $user->link = (self::$systemConfig['subscribe_domain']? self::$systemConfig['subscribe_domain'] : self::$systemConfig['website_url']).'/s/'.$user->subscribe->code;
  190. }
  191. $view['userList'] = $userList;
  192. return Response::view('admin.user.userList', $view);
  193. }
  194. // 添加账号
  195. public function addUser(Request $request)
  196. {
  197. if($request->isMethod('POST')){
  198. // 校验email是否已存在
  199. $exists = User::query()->whereEmail($request->input('email'))->first();
  200. if($exists){
  201. return Response::json(['status' => 'fail', 'data' => '', 'message' => '用户名已存在,请重新输入']);
  202. }
  203. if(!$request->input('usage')){
  204. return Response::json(['status' => 'fail', 'data' => '', 'message' => '请至少选择一种用途']);
  205. }
  206. $user = new User();
  207. $user->email = trim($request->input('email'));
  208. $user->password = Hash::make(trim($request->input('password'))? : makeRandStr());
  209. $user->port = $request->input('port');
  210. $user->passwd = empty($request->input('passwd'))? makeRandStr() : $request->input('passwd');
  211. $user->vmess_id = $request->input('vmess_id')? : createGuid();
  212. $user->transfer_enable = toGB($request->input('transfer_enable', 0));
  213. $user->enable = $request->input('enable', 0);
  214. $user->method = $request->input('method');
  215. $user->protocol = $request->input('protocol');
  216. $user->protocol_param = $request->input('protocol_param')? : '';
  217. $user->obfs = $request->input('obfs');
  218. $user->obfs_param = $request->input('obfs_param')? : '';
  219. $user->speed_limit_per_con = $request->input('speed_limit_per_con');
  220. $user->speed_limit_per_user = $request->input('speed_limit_per_user');
  221. $user->wechat = $request->input('wechat')? : '';
  222. $user->qq = $request->input('qq')? : '';
  223. $user->usage = $request->input('usage');
  224. $user->pay_way = $request->input('pay_way');
  225. $user->balance = 0;
  226. $user->enable_time = empty($request->input('enable_time'))? date('Y-m-d') : $request->input('enable_time');
  227. $user->expire_time = empty($request->input('expire_time'))? date('Y-m-d', strtotime("+365 days")) : $request->input('expire_time');
  228. $user->remark = str_replace("eval", "", str_replace("atob", "", $request->input('remark')));
  229. $user->level = $request->input('level')? : 1;
  230. $user->is_admin = 0;
  231. $user->reg_ip = getClientIp();
  232. $user->referral_uid = 0;
  233. $user->reset_time = $request->input('reset_time') > date('Y-m-d')? $request->input('reset_time') : NULL;
  234. $user->status = $request->input('status')? : 1;
  235. $user->save();
  236. if($user->id){
  237. // 生成订阅码
  238. $subscribe = new UserSubscribe();
  239. $subscribe->user_id = $user->id;
  240. $subscribe->code = Helpers::makeSubscribeCode();
  241. $subscribe->times = 0;
  242. $subscribe->save();
  243. // 生成用户标签
  244. $this->makeUserLabels($user->id, $request->input('labels'));
  245. // 写入用户流量变动记录
  246. Helpers::addUserTrafficModifyLog($user->id, 0, 0, toGB($request->input('transfer_enable', 0)), '后台手动添加用户');
  247. return Response::json(['status' => 'success', 'data' => '', 'message' => '添加成功']);
  248. }else{
  249. return Response::json(['status' => 'fail', 'data' => '', 'message' => '添加失败']);
  250. }
  251. }else{
  252. // 生成一个可用端口
  253. $view['last_port'] = self::$systemConfig['is_rand_port']? Helpers::getRandPort() : Helpers::getOnlyPort();
  254. $view['method_list'] = Helpers::methodList();
  255. $view['protocol_list'] = Helpers::protocolList();
  256. $view['obfs_list'] = Helpers::obfsList();
  257. $view['level_list'] = Helpers::levelList();
  258. $view['label_list'] = Label::query()->orderBy('sort', 'desc')->orderBy('id', 'asc')->get();
  259. $view['initial_labels'] = explode(",", self::$systemConfig['initial_labels_for_user']);
  260. return Response::view('admin.user.addUser', $view);
  261. }
  262. }
  263. // 生成用户标签
  264. private function makeUserLabels($userId, $labels)
  265. {
  266. // 先删除该用户所有的标签
  267. UserLabel::query()->whereUserId($userId)->delete();
  268. if(!empty($labels) && is_array($labels)){
  269. foreach($labels as $label){
  270. $userLabel = new UserLabel();
  271. $userLabel->user_id = $userId;
  272. $userLabel->label_id = $label;
  273. $userLabel->save();
  274. }
  275. }
  276. }
  277. // 批量生成账号
  278. public function batchAddUsers(Request $request)
  279. {
  280. $amount = $request->input('amount');
  281. DB::beginTransaction();
  282. try{
  283. for($i = 0; $i < $amount; $i++){
  284. $uid = Helpers::addUser('批量生成-'.makeRandStr(), Hash::make(makeRandStr()), toGB(1024), 365);
  285. // 生成一个可用端口
  286. if($uid){
  287. // 生成订阅码
  288. $subscribe = new UserSubscribe();
  289. $subscribe->user_id = $uid;
  290. $subscribe->code = Helpers::makeSubscribeCode();
  291. $subscribe->times = 0;
  292. $subscribe->save();
  293. // 初始化默认标签
  294. if(!empty(self::$systemConfig['initial_labels_for_user'])){
  295. $labels = explode(',', self::$systemConfig['initial_labels_for_user']);
  296. $this->makeUserLabels($uid, $labels);
  297. }
  298. // 写入用户流量变动记录
  299. Helpers::addUserTrafficModifyLog($uid, 0, 0, toGB(1024), '后台批量生成用户');
  300. }
  301. }
  302. DB::commit();
  303. return Response::json(['status' => 'success', 'data' => '', 'message' => '批量生成账号成功']);
  304. }catch(Exception $e){
  305. DB::rollBack();
  306. return Response::json(['status' => 'fail', 'data' => '', 'message' => '批量生成账号失败:'.$e->getMessage()]);
  307. }
  308. }
  309. // 编辑账号
  310. public function editUser(Request $request, $id)
  311. {
  312. if($request->isMethod('POST')){
  313. $username = trim($request->input('username'));
  314. $email = trim($request->input('email'));
  315. $password = $request->input('password');
  316. $port = $request->input('port');
  317. $passwd = $request->input('passwd');
  318. $vmess_id = $request->input('vmess_id')? trim($request->input('vmess_id')) : createGuid();
  319. $transfer_enable = $request->input('transfer_enable');
  320. $enable = $request->input('enable');
  321. $method = $request->input('method');
  322. $protocol = $request->input('protocol');
  323. $protocol_param = $request->input('protocol_param');
  324. $obfs = $request->input('obfs');
  325. $obfs_param = $request->input('obfs_param');
  326. $speed_limit_per_con = $request->input('speed_limit_per_con');
  327. $speed_limit_per_user = $request->input('speed_limit_per_user');
  328. $wechat = $request->input('wechat');
  329. $qq = $request->input('qq');
  330. $usage = $request->input('usage');
  331. $pay_way = $request->input('pay_way');
  332. $status = $request->input('status');
  333. $labels = $request->input('labels');
  334. $enable_time = $request->input('enable_time');
  335. $expire_time = $request->input('expire_time');
  336. $remark = str_replace("eval", "", str_replace("atob", "", $request->input('remark')));
  337. $level = $request->input('level');
  338. $is_admin = $request->input('is_admin');
  339. $reset_time = $request->input('reset_time');
  340. // 校验email是否已存在
  341. $exists = User::query()->where('id', '<>', $id)->whereEmail($email)->first();
  342. if($exists){
  343. return Response::json(['status' => 'fail', 'data' => '', 'message' => '用户名已存在,请重新输入']);
  344. }
  345. // 校验端口是否已存在
  346. $exists = User::query()->where('id', '<>', $id)->where('port', '>', 0)->wherePort($port)->first();
  347. if($exists){
  348. return Response::json(['status' => 'fail', 'data' => '', 'message' => '端口已存在,请重新输入']);
  349. }
  350. // 禁止取消默认管理员
  351. if($id == 1 && $is_admin == 0){
  352. return Response::json(['status' => 'fail', 'data' => '', 'message' => '系统默认管理员不可取消']);
  353. }
  354. if(!$usage){
  355. return Response::json(['status' => 'fail', 'data' => '', 'message' => '请至少选择一种用途']);
  356. }
  357. // 用户编辑前的信息
  358. $user = User::query()->whereId($id)->first();
  359. DB::beginTransaction();
  360. try{
  361. $data = [
  362. 'username' => $username,
  363. 'email' => $email,
  364. 'port' => $port,
  365. 'passwd' => $passwd,
  366. 'vmess_id' => $vmess_id,
  367. 'transfer_enable' => toGB($transfer_enable),
  368. 'enable' => $status < 0? 0 : $enable,
  369. 'method' => $method,
  370. 'protocol' => $protocol,
  371. 'protocol_param' => $protocol_param,
  372. 'obfs' => $obfs,
  373. 'obfs_param' => $obfs_param,
  374. 'speed_limit_per_con' => $speed_limit_per_con,
  375. 'speed_limit_per_user' => $speed_limit_per_user,
  376. 'wechat' => $wechat,
  377. 'qq' => $qq,
  378. 'usage' => $usage,
  379. 'pay_way' => $pay_way,
  380. 'status' => $status,
  381. 'reset_time' => empty($reset_time)? NULL : $reset_time,
  382. 'enable_time' => empty($enable_time)? date('Y-m-d') : $enable_time,
  383. 'expire_time' => empty($expire_time)? date('Y-m-d', strtotime("+365 days")) : $expire_time,
  384. 'remark' => $remark,
  385. 'level' => $level
  386. ];
  387. // 只有admin才有权限操作管理员属性
  388. if(Auth::user()->id == 1){
  389. $data['is_admin'] = $is_admin;
  390. }
  391. if(!empty($password)){
  392. if(!(env('APP_DEMO') && $id == 1)){ // 演示环境禁止修改管理员密码
  393. $data['password'] = Hash::make($password);
  394. }
  395. }
  396. User::query()->whereId($id)->update($data);
  397. // 重新生成用户标签
  398. $this->makeUserLabels($id, $labels);
  399. // 写入用户流量变动记录
  400. if($user->transfer_enable != toGB($transfer_enable)){
  401. Helpers::addUserTrafficModifyLog($id, 0, $user->transfer_enable, toGB($transfer_enable), '后台手动编辑用户');
  402. }
  403. DB::commit();
  404. return Response::json(['status' => 'success', 'data' => '', 'message' => '编辑成功']);
  405. }catch(Exception $e){
  406. DB::rollBack();
  407. Log::error('编辑用户信息异常:'.$e->getMessage());
  408. return Response::json(['status' => 'fail', 'data' => '', 'message' => '编辑失败']);
  409. }
  410. }else{
  411. $user = User::query()->with(['label', 'referral'])->whereId($id)->first();
  412. if($user){
  413. $user->transfer_enable = flowToGB($user->transfer_enable);
  414. // 处理标签
  415. $label = [];
  416. foreach($user->label as $vo){
  417. $label[] = $vo->label_id;
  418. }
  419. $user->labels = $label;
  420. // 处理用途
  421. $user->usage = explode(',', $user->usage);
  422. }
  423. $view['user'] = $user;
  424. $view['method_list'] = Helpers::methodList();
  425. $view['protocol_list'] = Helpers::protocolList();
  426. $view['obfs_list'] = Helpers::obfsList();
  427. $view['level_list'] = Helpers::levelList();
  428. $view['label_list'] = Label::query()->orderBy('sort', 'desc')->orderBy('id', 'asc')->get();
  429. return Response::view('admin.user.editUser', $view);
  430. }
  431. }
  432. // 删除用户
  433. public function delUser(Request $request)
  434. {
  435. $id = $request->input('id');
  436. if($id <= 1){
  437. return Response::json(['status' => 'fail', 'data' => '', 'message' => '系统管理员不可删除']);
  438. }
  439. DB::beginTransaction();
  440. try{
  441. User::query()->whereId($id)->delete();
  442. UserSubscribe::query()->whereUserId($id)->delete();
  443. UserBanLog::query()->whereUserId($id)->delete();
  444. UserLabel::query()->whereUserId($id)->delete();
  445. UserBalanceLog::query()->whereUserId($id)->delete();
  446. UserTrafficModifyLog::query()->whereUserId($id)->delete();
  447. UserLoginLog::query()->whereUserId($id)->delete();
  448. DB::commit();
  449. return Response::json(['status' => 'success', 'data' => '', 'message' => '删除成功']);
  450. }catch(Exception $e){
  451. Log::error($e);
  452. DB::rollBack();
  453. return Response::json(['status' => 'fail', 'data' => '', 'message' => '删除失败']);
  454. }
  455. }
  456. // 节点列表
  457. public function nodeList(Request $request)
  458. {
  459. if($request->isMethod('POST')){
  460. $id = $request->input('id');
  461. $node = SsNode::query()->whereId($id)->first();
  462. // 使用DDNS的node先通过gethostbyname获取ipv4地址
  463. if($node->is_ddns){
  464. $ip = gethostbyname($node->server);
  465. if(strcmp($ip, $node->server) != 0){
  466. $node->ip = $ip;
  467. }else{
  468. return Response::json(['status' => 'fail', 'title' => 'IP获取错误', 'message' => $node->name.'IP获取失败']);
  469. }
  470. }
  471. $data[0] = NetworkDetection::networkCheck($node->ip, TRUE); //ICMP
  472. $data[1] = NetworkDetection::networkCheck($node->ip, FALSE, $node->single? $node->port : NULL); //TCP
  473. return Response::json(['status' => 'success', 'title' => '['.$node->name.']阻断信息', 'message' => $data]);
  474. }else{
  475. $status = $request->input('status');
  476. $query = SsNode::query();
  477. if(isset($status)){
  478. $query->whereStatus($status);
  479. }
  480. $nodeList = $query->orderBy('status', 'desc')->orderBy('id', 'asc')->paginate(15)->appends($request->except('page'));
  481. foreach($nodeList as $node){
  482. // 在线人数
  483. $online_log = SsNodeOnlineLog::query()->whereNodeId($node->id)->where('log_time', '>=', strtotime("-5 minutes"))->orderBy('id', 'desc')->first();
  484. $node->online_users = empty($online_log)? 0 : $online_log->online_user;
  485. // 已产生流量
  486. $totalTraffic = SsNodeTrafficDaily::query()->whereNodeId($node->id)->sum('total');
  487. $node->transfer = flowAutoShow($totalTraffic);
  488. // 负载(10分钟以内)
  489. $node_info = SsNodeInfo::query()->whereNodeId($node->id)->where('log_time', '>=', strtotime("-10 minutes"))->orderBy('id', 'desc')->first();
  490. $node->isOnline = empty($node_info) || empty($node_info->load)? 0 : 1;
  491. $node->load = $node->isOnline? $node_info->load : '离线';
  492. $node->uptime = empty($node_info)? 0 : seconds2time($node_info->uptime);
  493. }
  494. $view['nodeList'] = $nodeList;
  495. }
  496. return Response::view('admin.node.nodeList', $view);
  497. }
  498. // 添加节点
  499. public function addNode(Request $request)
  500. {
  501. if($request->isMethod('POST')){
  502. if($request->input('ssh_port') <= 0 || $request->input('ssh_port') >= 65535){
  503. return Response::json(['status' => 'fail', 'data' => '', 'message' => '添加失败:SSH端口不合法']);
  504. }
  505. if(FALSE === filter_var($request->input('ip'), FILTER_VALIDATE_IP, FILTER_FLAG_IPV4)){
  506. return Response::json(['status' => 'fail', 'data' => '', 'message' => '添加失败:IPv4地址不合法']);
  507. }
  508. if($request->input('ipv6') && FALSE === filter_var($request->input('ipv6'), FILTER_VALIDATE_IP, FILTER_FLAG_IPV6)){
  509. return Response::json(['status' => 'fail', 'data' => '', 'message' => '添加失败:IPv6地址不合法']);
  510. }
  511. if($request->input('server')){
  512. $domain = $request->input('server');
  513. $domain = explode('.', $domain);
  514. $domainSuffix = end($domain); // 取得域名后缀
  515. if(!in_array($domainSuffix, \config('domains'))){
  516. return Response::json(['status' => 'fail', 'data' => '', 'message' => '绑定域名不合法']);
  517. }
  518. }
  519. // TODO:判断是否已存在绑定了相同域名的节点,提示是否要强制替换,或者不提示之前强制将其他节点的绑定域名置为空,然后发起域名绑定请求,或者请求进入队列
  520. DB::beginTransaction();
  521. try{
  522. $ssNode = new SsNode();
  523. $ssNode->type = $request->input('type');
  524. $ssNode->name = $request->input('name');
  525. $ssNode->group_id = $request->input('group_id')? : 0;
  526. $ssNode->country_code = $request->input('country_code')? : 'un';
  527. $ssNode->server = $request->input('server')? : '';
  528. $ssNode->ip = $request->input('ip');
  529. $ssNode->ipv6 = $request->input('ipv6');
  530. $ssNode->desc = $request->input('desc')? : '';
  531. $ssNode->method = $request->input('method');
  532. $ssNode->protocol = $request->input('protocol');
  533. $ssNode->protocol_param = $request->input('protocol_param')? : '';
  534. $ssNode->obfs = $request->input('obfs')? : '';
  535. $ssNode->obfs_param = $request->input('obfs_param')? : '';
  536. $ssNode->traffic_rate = $request->input('traffic_rate')? : 1;
  537. $ssNode->bandwidth = $request->input('bandwidth')? : 1000;
  538. $ssNode->traffic = $request->input('traffic')? : 1000;
  539. $ssNode->monitor_url = $request->input('monitor_url')? : '';
  540. $ssNode->is_subscribe = $request->input('is_subscribe');
  541. $ssNode->is_ddns = $request->input('is_ddns');
  542. $ssNode->is_transit = $request->input('is_transit');
  543. $ssNode->ssh_port = $request->input('ssh_port')? : 22;
  544. $ssNode->detectionType = $request->input('detectionType');
  545. $ssNode->compatible = $request->input('type') == 2? 0 : ($request->input('is_ddns')? 0 : $request->input('compatible'));
  546. $ssNode->single = $request->input('single');
  547. $ssNode->port = $request->input('single')? ($request->input('port')? : 443) : '';
  548. $ssNode->passwd = $request->input('single')? ($request->input('passwd')? : 'password') : '';
  549. $ssNode->sort = $request->input('sort')? : 0;
  550. $ssNode->status = $request->input('status')? : 1;
  551. $ssNode->v2_alter_id = $request->input('v2_alter_id')? : 16;
  552. $ssNode->v2_port = $request->input('v2_port')? : 10087;
  553. $ssNode->v2_method = $request->input('v2_method')? : 'aes-128-gcm';
  554. $ssNode->v2_net = $request->input('v2_net')? : 'tcp';
  555. $ssNode->v2_type = $request->input('v2_type')? : 'none';
  556. $ssNode->v2_host = $request->input('v2_host')? : '';
  557. $ssNode->v2_path = $request->input('v2_path')? : '';
  558. $ssNode->v2_tls = $request->input('v2_tls')? : 0;
  559. $ssNode->v2_insider_port = $request->input('v2_insider_port')? : 10550;
  560. $ssNode->v2_outsider_port = $request->input('v2_outsider_port')? : 443;
  561. $ssNode->save();
  562. // 建立分组关联
  563. if($ssNode->id && $request->input('group_id', 0)){
  564. $ssGroupNode = new SsGroupNode();
  565. $ssGroupNode->group_id = $request->input('group_id', 0);
  566. $ssGroupNode->node_id = $ssNode->id;
  567. $ssGroupNode->save();
  568. }
  569. // 生成节点标签
  570. $labels = $request->input('labels');
  571. if($ssNode->id && !empty($labels)){
  572. foreach($labels as $label){
  573. $ssNodeLabel = new SsNodeLabel();
  574. $ssNodeLabel->node_id = $ssNode->id;
  575. $ssNodeLabel->label_id = $label;
  576. $ssNodeLabel->save();
  577. }
  578. }
  579. DB::commit();
  580. return Response::json(['status' => 'success', 'data' => '', 'message' => '添加成功']);
  581. }catch(Exception $e){
  582. DB::rollBack();
  583. Log::error('添加节点信息异常:'.$e->getMessage());
  584. return Response::json(['status' => 'fail', 'data' => '', 'message' => '添加失败:'.$e->getMessage()]);
  585. }
  586. }else{
  587. $view['method_list'] = Helpers::methodList();
  588. $view['protocol_list'] = Helpers::protocolList();
  589. $view['obfs_list'] = Helpers::obfsList();
  590. $view['level_list'] = Helpers::levelList();
  591. $view['group_list'] = SsGroup::query()->get();
  592. $view['country_list'] = Country::query()->orderBy('code', 'asc')->get();
  593. $view['label_list'] = Label::query()->orderBy('sort', 'desc')->orderBy('id', 'asc')->get();
  594. return Response::view('admin.group.addNode', $view);
  595. }
  596. }
  597. // 编辑节点
  598. public function editNode(Request $request)
  599. {
  600. $id = $request->input('id');
  601. if($request->isMethod('POST')){
  602. if($request->input('ssh_port') <= 0 || $request->input('ssh_port') >= 65535){
  603. return Response::json(['status' => 'fail', 'data' => '', 'message' => '编辑失败:SSH端口不合法']);
  604. }
  605. if(FALSE === filter_var($request->input('ip'), FILTER_VALIDATE_IP, FILTER_FLAG_IPV4)){
  606. return Response::json(['status' => 'fail', 'data' => '', 'message' => '编辑失败:IPv4地址不合法']);
  607. }
  608. if($request->input('ipv6') && FALSE === filter_var($request->input('ipv6'), FILTER_VALIDATE_IP, FILTER_FLAG_IPV6)){
  609. return Response::json(['status' => 'fail', 'data' => '', 'message' => '编辑失败:IPv6地址不合法']);
  610. }
  611. if($request->input('server')){
  612. $domain = $request->input('server');
  613. $domain = explode('.', $domain);
  614. $domainSuffix = end($domain); // 取得域名后缀
  615. if(!in_array($domainSuffix, \config('domains'))){
  616. return Response::json(['status' => 'fail', 'data' => '', 'message' => '绑定域名不合法']);
  617. }
  618. }
  619. if($request->input('v2_alter_id') <= 0 || $request->input('v2_alter_id') >= 65535){
  620. return Response::json(['status' => 'fail', 'data' => '', 'message' => '编辑失败:AlterId不合法']);
  621. }
  622. DB::beginTransaction();
  623. try{
  624. $data = [
  625. 'type' => $request->input('type'),
  626. 'name' => $request->input('name'),
  627. 'group_id' => $request->input('group_id')? $request->input('group_id') : 0,
  628. 'country_code' => $request->input('country_code'),
  629. 'server' => $request->input('server'),
  630. 'ip' => $request->input('ip'),
  631. 'ipv6' => $request->input('ipv6'),
  632. 'desc' => $request->input('desc'),
  633. 'method' => $request->input('method'),
  634. 'protocol' => $request->input('protocol'),
  635. 'protocol_param' => $request->input('protocol_param'),
  636. 'obfs' => $request->input('obfs'),
  637. 'obfs_param' => $request->input('obfs_param'),
  638. 'traffic_rate' => $request->input('traffic_rate'),
  639. 'bandwidth' => $request->input('bandwidth')? $request->input('bandwidth') : 1000,
  640. 'traffic' => $request->input('traffic')? $request->input('traffic') : 1000,
  641. 'monitor_url' => $request->input('monitor_url')? $request->input('monitor_url') : '',
  642. 'is_subscribe' => $request->input('is_subscribe'),
  643. 'is_ddns' => $request->input('is_ddns'),
  644. 'is_transit' => $request->input('is_transit'),
  645. 'ssh_port' => $request->input('ssh_port'),
  646. 'detectionType' => $request->input('detectionType'),
  647. 'compatible' => $request->input('type') == 2? 0 : ($request->input('is_ddns')? 0 : $request->input('compatible')),
  648. 'single' => $request->input('single'),
  649. 'port' => $request->input('single')? ($request->input('port')? $request->input('port') : 443) : '',
  650. 'passwd' => $request->input('single')? ($request->input('passwd')? $request->input('passwd') : 'password') : '',
  651. 'sort' => $request->input('sort'), 'status' => $request->input('status'),
  652. 'v2_alter_id' => $request->input('v2_alter_id')? $request->input('v2_alter_id') : 16,
  653. 'v2_port' => $request->input('v2_port')? $request->input('v2_port') : 10087,
  654. 'v2_method' => $request->input('v2_method')? $request->input('v2_method') : 'aes-128-gcm',
  655. 'v2_net' => $request->input('v2_net'), 'v2_type' => $request->input('v2_type'),
  656. 'v2_host' => $request->input('v2_host'), 'v2_path' => $request->input('v2_path'),
  657. 'v2_tls' => $request->input('v2_tls'),
  658. 'v2_insider_port' => $request->input('v2_insider_port', 10550),
  659. 'v2_outsider_port' => $request->input('v2_outsider_port', 443)
  660. ];
  661. SsNode::query()->whereid($id)->update($data);
  662. // 建立分组关联
  663. if($request->input('group_id')){
  664. // 先删除该节点所有关联
  665. SsGroupNode::query()->whereNodeId($id)->delete();
  666. // 建立关联
  667. $ssGroupNode = new SsGroupNode();
  668. $ssGroupNode->group_id = $request->input('group_id');
  669. $ssGroupNode->node_id = $id;
  670. $ssGroupNode->save();
  671. }
  672. // 生成节点标签
  673. $this->makeNodeLabels($id, $request->input('labels'));
  674. // TODO:更新节点绑定的域名DNS(将节点IP更新到域名DNS 的A记录)
  675. DB::commit();
  676. return Response::json(['status' => 'success', 'data' => '', 'message' => '编辑成功']);
  677. }catch(Exception $e){
  678. DB::rollBack();
  679. Log::error('编辑节点信息异常:'.$e->getMessage());
  680. return Response::json(['status' => 'fail', 'data' => '', 'message' => '编辑失败:'.$e->getMessage()]);
  681. }
  682. }else{
  683. $node = SsNode::query()->with(['label'])->whereId($id)->first();
  684. if($node){
  685. $labels = [];
  686. foreach($node->label as $vo){
  687. $labels[] = $vo->label_id;
  688. }
  689. $node->labels = $labels;
  690. }
  691. $view['node'] = $node;
  692. $view['method_list'] = Helpers::methodList();
  693. $view['protocol_list'] = Helpers::protocolList();
  694. $view['obfs_list'] = Helpers::obfsList();
  695. $view['level_list'] = Helpers::levelList();
  696. $view['group_list'] = SsGroup::query()->get();
  697. $view['country_list'] = Country::query()->orderBy('code', 'asc')->get();
  698. $view['label_list'] = Label::query()->orderBy('sort', 'desc')->orderBy('id', 'asc')->get();
  699. return Response::view('admin.node.editNode', $view);
  700. }
  701. }
  702. // 生成节点标签
  703. private function makeNodeLabels($nodeId, $labels)
  704. {
  705. // 先删除所有该节点的标签
  706. SsNodeLabel::query()->whereNodeId($nodeId)->delete();
  707. if(!empty($labels) && is_array($labels)){
  708. foreach($labels as $label){
  709. $ssNodeLabel = new SsNodeLabel();
  710. $ssNodeLabel->node_id = $nodeId;
  711. $ssNodeLabel->label_id = $label;
  712. $ssNodeLabel->save();
  713. }
  714. }
  715. }
  716. // 删除节点
  717. public function delNode(Request $request)
  718. {
  719. $id = $request->input('id');
  720. $node = SsNode::query()->whereId($id)->first();
  721. if(!$node){
  722. return Response::json(['status' => 'fail', 'data' => '', 'message' => '节点不存在,请重试']);
  723. }
  724. DB::beginTransaction();
  725. try{
  726. // 删除分组关联、节点标签、节点相关日志
  727. SsNode::query()->whereId($id)->delete();
  728. SsGroupNode::query()->whereNodeId($id)->delete();
  729. SsNodeLabel::query()->whereNodeId($id)->delete();
  730. SsNodeInfo::query()->whereNodeId($id)->delete();
  731. SsNodeOnlineLog::query()->whereNodeId($id)->delete();
  732. SsNodeTrafficDaily::query()->whereNodeId($id)->delete();
  733. SsNodeTrafficHourly::query()->whereNodeId($id)->delete();
  734. SsNodePing::query()->whereNodeId($id)->delete();
  735. UserTrafficDaily::query()->whereNodeId($id)->delete();
  736. UserTrafficHourly::query()->whereNodeId($id)->delete();
  737. UserTrafficLog::query()->whereNodeId($id)->delete();
  738. DB::commit();
  739. return Response::json(['status' => 'success', 'data' => '', 'message' => '删除成功']);
  740. }catch(Exception $e){
  741. DB::rollBack();
  742. Log::error('删除节点信息异常:'.$e->getMessage());
  743. return Response::json(['status' => 'fail', 'data' => '', 'message' => '删除失败:'.$e->getMessage()]);
  744. }
  745. }
  746. // 节点流量监控
  747. public function nodeMonitor($node_id)
  748. {
  749. $node = SsNode::query()->whereId($node_id)->orderBy('sort', 'desc')->first();
  750. if(!$node){
  751. Session::flash('errorMsg', '节点不存在,请重试');
  752. return Redirect::back();
  753. }
  754. // 查看流量
  755. $dailyData = [];
  756. $hourlyData = [];
  757. // 节点一个月内的流量
  758. $nodeTrafficDaily = SsNodeTrafficDaily::query()->with(['info'])->whereNodeId($node->id)->where('created_at', '>=', date('Y-m', time()))->orderBy('created_at', 'asc')->pluck('total')->toArray();
  759. $dailyTotal = date('d', time())-1;//今天不算,减一
  760. $dailyCount = count($nodeTrafficDaily);
  761. for($x = 0; $x < ($dailyTotal-$dailyCount); $x++){
  762. $dailyData[$x] = 0;
  763. }
  764. for($x = ($dailyTotal-$dailyCount); $x < $dailyTotal; $x++){
  765. $dailyData[$x] = round($nodeTrafficDaily[$x-($dailyTotal-$dailyCount)]/(1024*1024*1024), 3);
  766. }
  767. // 节点一天内的流量
  768. $nodeTrafficHourly = SsNodeTrafficHourly::query()->with(['info'])->whereNodeId($node->id)->where('created_at', '>=', date('Y-m-d', time()))->orderBy('created_at', 'asc')->pluck('total')->toArray();
  769. $hourlyTotal = date('H', time());
  770. $hourlyCount = count($nodeTrafficHourly);
  771. for($x = 0; $x < ($hourlyTotal-$hourlyCount); $x++){
  772. $hourlyData[$x] = 0;
  773. }
  774. for($x = ($hourlyTotal-$hourlyCount); $x < $hourlyTotal; $x++){
  775. $hourlyData[$x] = round($nodeTrafficHourly[$x-($hourlyTotal-$hourlyCount)]/(1024*1024*1024), 3);
  776. }
  777. $view['trafficDaily'] = ['nodeName' => $node->name, 'dailyData' => "'".implode("','", $dailyData)."'"];
  778. $view['trafficHourly'] = ['nodeName' => $node->name, 'hourlyData' => "'".implode("','", $hourlyData)."'"];
  779. // 本月天数数据
  780. $monthDays = [];
  781. for($i = 1; $i <= date("d"); $i++){
  782. $monthDays[] = $i;
  783. }
  784. // 本日小时数据
  785. $dayHours = [];
  786. for($i = 1; $i <= date("H"); $i++){
  787. $dayHours[] = $i;
  788. }
  789. $view['nodeName'] = $node->name;
  790. $view['nodeServer'] = $node->server;
  791. $view['monthDays'] = "'".implode("','", $monthDays)."'";
  792. $view['dayHours'] = "'".implode("','", $dayHours)."'";
  793. return Response::view('admin.node.nodeMonitor', $view);
  794. }
  795. // Ping节点延迟
  796. public function pingNode(Request $request)
  797. {
  798. $node = SsNode::query()->whereId($request->input('id'))->first();
  799. if(!$node){
  800. return Response::json(['status' => 'fail', 'message' => '节点不存在,请重试']);
  801. }
  802. $result = NetworkDetection::ping($node->is_ddns? $node->server : $node->ip);
  803. if($result){
  804. $data[0] = $result['China Telecom']['time']? : '无';
  805. $data[1] = $result['China Unicom']['time']? : '无';
  806. $data[2] = $result['China Mobile']['time']? : '无';
  807. $data[3] = $result['Hong Kong']['time']? : '无';
  808. return Response::json(['status' => 'success', 'message' => $data]);
  809. }else{
  810. return Response::json(['status' => 'fail', 'message' => 'Ping访问失败']);
  811. }
  812. }
  813. public function nodePingLog(Request $request)
  814. {
  815. $node_id = $request->input('nodeId');
  816. $query = SsNodePing::query();
  817. if(isset($node_id)){
  818. $query->whereNodeId($node_id);
  819. }
  820. $view['nodeList'] = SsNode::query()->orderBy('id', 'asc')->get();
  821. $view['pingLogs'] = $query->orderBy('id', 'asc')->paginate(15)->appends($request->except('page'));
  822. return Response::view('admin.logs.nodePingLog', $view);
  823. }
  824. // 文章列表
  825. public function articleList(Request $request)
  826. {
  827. $view['list'] = Article::query()->orderBy('sort', 'desc')->paginate(15)->appends($request->except('page'));
  828. return Response::view('admin.article.articleList', $view);
  829. }
  830. // 添加文章
  831. public function addArticle(Request $request)
  832. {
  833. if($request->isMethod('POST')){
  834. $article = new Article();
  835. $article->title = $request->input('title');
  836. $article->type = $request->input('type', 1);
  837. $article->author = '管理员';
  838. $article->summary = $request->input('summary');
  839. // LOGO
  840. if($article->type == 4){
  841. $article->logo = $request->input('logo');
  842. }else{
  843. $logo = '';
  844. if($request->hasFile('logo')){
  845. $file = $request->file('logo');
  846. $fileType = $file->getClientOriginalExtension();
  847. // 验证文件合法性
  848. if(!in_array($fileType, ['jpg', 'png', 'jpeg', 'bmp'])){
  849. Session::flash('errorMsg', 'LOGO不合法');
  850. return Redirect::back()->withInput();
  851. }
  852. $logoName = date('YmdHis').mt_rand(1000, 2000).'.'.$fileType;
  853. $move = $file->move(base_path().'/public/upload/image/', $logoName);
  854. $logo = $move? '/upload/image/'.$logoName : '';
  855. }
  856. $article = new Article();
  857. $article->title = $request->input('title');
  858. $article->type = $request->input('type', 1);
  859. $article->author = '管理员';
  860. $article->summary = $request->input('summary');
  861. $article->logo = $logo;
  862. }
  863. $article->content = $request->input('content');
  864. $article->sort = $request->input('sort', 0);
  865. $article->save();
  866. if($article->id){
  867. Session::flash('successMsg', '添加成功');
  868. }else{
  869. Session::flash('errorMsg', '添加失败');
  870. }
  871. return Redirect::to('admin/articleList');
  872. }else{
  873. return Response::view('admin.article.addArticle');
  874. }
  875. }
  876. // 编辑文章
  877. public function editArticle(Request $request)
  878. {
  879. $id = $request->input('id');
  880. if($request->isMethod('POST')){
  881. $title = $request->input('title');
  882. $type = $request->input('type');
  883. $summary = $request->input('summary');
  884. $content = $request->input('content');
  885. $sort = $request->input('sort');
  886. // 商品LOGO
  887. if($type == 4){
  888. $logo = $request->input('logo');
  889. }else{
  890. $logo = '';
  891. if($request->hasFile('logo')){
  892. $file = $request->file('logo');
  893. $fileType = $file->getClientOriginalExtension();
  894. // 验证文件合法性
  895. if(!in_array($fileType, ['jpg', 'png', 'jpeg', 'bmp'])){
  896. Session::flash('errorMsg', 'LOGO不合法');
  897. return Redirect::back()->withInput();
  898. }
  899. $logoName = date('YmdHis').mt_rand(1000, 2000).'.'.$fileType;
  900. $move = $file->move(base_path().'/public/upload/image/', $logoName);
  901. $logo = $move? '/upload/image/'.$logoName : '';
  902. }
  903. }
  904. $data = ['type' => $type, 'title' => $title, 'summary' => $summary, 'content' => $content, 'sort' => $sort];
  905. if($logo){
  906. $data['logo'] = $logo;
  907. }
  908. $ret = Article::query()->whereId('id', $id)->update($data);
  909. if($ret){
  910. Session::flash('successMsg', '编辑成功');
  911. }else{
  912. Session::flash('errorMsg', '编辑失败');
  913. }
  914. return Redirect::to('admin/editArticle?id='.$id);
  915. }else{
  916. $view['article'] = Article::query()->whereId($id)->first();
  917. return Response::view('admin.article.editArticle', $view);
  918. }
  919. }
  920. // 删除文章
  921. public function delArticle(Request $request)
  922. {
  923. $id = $request->input('id');
  924. $ret = Article::query()->whereId($id)->delete();
  925. if($ret){
  926. return Response::json(['status' => 'success', 'data' => '', 'message' => '删除成功']);
  927. }else{
  928. return Response::json(['status' => 'fail', 'data' => '', 'message' => '删除失败']);
  929. }
  930. }
  931. // 节点分组列表
  932. public function groupList(Request $request)
  933. {
  934. $view['groupList'] = SsGroup::query()->paginate(15)->appends($request->except('page'));
  935. $levelList = Helpers::levelList();
  936. $levelMap = [];
  937. foreach($levelList as $vo){
  938. $levelMap[$vo['level']] = $vo['level_name'];
  939. }
  940. $view['levelMap'] = $levelMap;
  941. return Response::view('admin.group.groupList', $view);
  942. }
  943. // 添加节点分组
  944. public function addGroup(Request $request)
  945. {
  946. if($request->isMethod('POST')){
  947. $ssGroup = new SsGroup();
  948. $ssGroup->name = $request->input('name');
  949. $ssGroup->level = $request->input('level');
  950. $ssGroup->save();
  951. return Response::json(['status' => 'success', 'data' => '', 'message' => '添加成功']);
  952. }else{
  953. $view['levelList'] = Helpers::levelList();
  954. return Response::view('admin.group.addGroup', $view);
  955. }
  956. }
  957. // 编辑节点分组
  958. public function editGroup(Request $request, $id)
  959. {
  960. if($request->isMethod('POST')){
  961. $name = $request->input('name');
  962. $level = $request->input('level');
  963. $data = ['name' => $name, 'level' => $level];
  964. $ret = SsGroup::query()->whereId($id)->update($data);
  965. if($ret){
  966. return Response::json(['status' => 'success', 'data' => '', 'message' => '编辑成功']);
  967. }else{
  968. return Response::json(['status' => 'fail', 'data' => '', 'message' => '编辑失败']);
  969. }
  970. }else{
  971. $view['group'] = SsGroup::query()->whereId($id)->first();
  972. $view['levelList'] = Helpers::levelList();
  973. return Response::view('admin.group.editGroup', $view);
  974. }
  975. }
  976. // 删除节点分组
  977. public function delGroup(Request $request)
  978. {
  979. $id = $request->input('id');
  980. // 检查是否该分组下是否有节点
  981. $ssGroupNodeCount = SsGroupNode::query()->whereGroupId($id)->count();
  982. if($ssGroupNodeCount){
  983. return Response::json(['status' => 'fail', 'data' => '', 'message' => '删除失败:该分组下有节点关联,请先解除关联']);
  984. }
  985. $ret = SsGroup::query()->whereId($id)->delete();
  986. if($ret){
  987. return Response::json(['status' => 'success', 'data' => '', 'message' => '删除成功']);
  988. }else{
  989. return Response::json(['status' => 'fail', 'data' => '', 'message' => '删除失败']);
  990. }
  991. }
  992. // 流量日志
  993. public function trafficLog(Request $request)
  994. {
  995. $port = $request->input('port');
  996. $user_id = $request->input('user_id');
  997. $email = $request->input('email');
  998. $nodeId = $request->input('nodeId');
  999. $startTime = $request->input('startTime');
  1000. $endTime = $request->input('endTime');
  1001. $query = UserTrafficLog::query()->with(['user', 'node']);
  1002. if(isset($port)){
  1003. $query->whereHas('user', function($q) use ($port){
  1004. $q->wherePort($port);
  1005. });
  1006. }
  1007. if(isset($user_id)){
  1008. $query->whereUserId($user_id);
  1009. }
  1010. if(isset($email)){
  1011. $query->whereHas('user', function($q) use ($email){
  1012. $q->where('email', 'like', '%'.$email.'%');
  1013. });
  1014. }
  1015. if(isset($nodeId)){
  1016. $query->whereNodeId($nodeId);
  1017. }
  1018. if(isset($startTime)){
  1019. $query->where('log_time', '>=', strtotime($startTime));
  1020. }
  1021. if(isset($endTime)){
  1022. $query->where('log_time', '<=', strtotime($endTime));
  1023. }
  1024. // 已使用流量
  1025. $view['totalTraffic'] = flowAutoShow($query->sum('u')+$query->sum('d'));
  1026. $list = $query->orderBy('id', 'desc')->paginate(20)->appends($request->except('page'));
  1027. foreach($list as $vo){
  1028. $vo->u = flowAutoShow($vo->u);
  1029. $vo->d = flowAutoShow($vo->d);
  1030. $vo->log_time = date('Y-m-d H:i:s', $vo->log_time);
  1031. }
  1032. $view['list'] = $list;
  1033. $view['nodeList'] = SsNode::query()->whereStatus(1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->get();
  1034. return Response::view('admin.logs.trafficLog', $view);
  1035. }
  1036. // SS(R)链接反解析
  1037. public function decompile(Request $request)
  1038. {
  1039. if($request->isMethod('POST')){
  1040. $content = $request->input('content');
  1041. if(empty($content)){
  1042. return Response::json(['status' => 'fail', 'data' => '', 'message' => '请在左侧填入要反解析的SS(R)链接']);
  1043. }
  1044. // 反解析处理
  1045. $content = str_replace("\n", ",", $content);
  1046. $content = explode(',', $content);
  1047. $txt = '';
  1048. foreach($content as $item){
  1049. // 判断是SS还是SSR链接
  1050. $str = '';
  1051. if(FALSE !== strpos($item, 'ssr://')){
  1052. $str = mb_substr($item, 6);
  1053. }elseif(FALSE !== strpos($item, 'ss://')){
  1054. $str = mb_substr($item, 5);
  1055. }
  1056. $txt .= "\r\n".base64url_decode($str);
  1057. }
  1058. // 生成转换好的JSON文件
  1059. file_put_contents(public_path('downloads/decompile.json'), $txt);
  1060. return Response::json(['status' => 'success', 'data' => $txt, 'message' => '反解析成功']);
  1061. }else{
  1062. return Response::view('admin.decompile');
  1063. }
  1064. }
  1065. // 格式转换(SS转SSR)
  1066. public function convert(Request $request)
  1067. {
  1068. if($request->isMethod('POST')){
  1069. $method = $request->input('method');
  1070. $transfer_enable = $request->input('transfer_enable');
  1071. $protocol = $request->input('protocol');
  1072. $protocol_param = $request->input('protocol_param');
  1073. $obfs = $request->input('obfs');
  1074. $obfs_param = $request->input('obfs_param');
  1075. $content = $request->input('content');
  1076. if(empty($content)){
  1077. return Response::json(['status' => 'fail', 'data' => '', 'message' => '请在左侧填入要转换的内容']);
  1078. }
  1079. // 校验格式
  1080. $content = json_decode($content);
  1081. if(empty($content->port_password)){
  1082. return Response::json(['status' => 'fail', 'data' => '', 'message' => '转换失败:配置信息里缺少【port_password】字段,或者该字段为空']);
  1083. }
  1084. // 转换成SSR格式JSON
  1085. $data = [];
  1086. foreach($content->port_password as $port => $passwd){
  1087. $data[] = ['d' => 0, 'enable' => 1, 'method' => $method, 'obfs' => $obfs, 'obfs_param' => empty($obfs_param)? "" : $obfs_param, 'passwd' => $passwd, 'port' => $port, 'protocol' => $protocol, 'protocol_param' => empty($protocol_param)? "" : $protocol_param, 'transfer_enable' => toGB($transfer_enable), 'u' => 0, 'user' => date('Ymd').'_IMPORT_'.$port,];
  1088. }
  1089. $json = json_encode($data);
  1090. // 生成转换好的JSON文件
  1091. file_put_contents(public_path('downloads/convert.json'), $json);
  1092. return Response::json(['status' => 'success', 'data' => $json, 'message' => '转换成功']);
  1093. }else{
  1094. // 加密方式、协议、混淆
  1095. $view['method_list'] = Helpers::methodList();
  1096. $view['protocol_list'] = Helpers::protocolList();
  1097. $view['obfs_list'] = Helpers::obfsList();
  1098. return Response::view('admin.convert', $view);
  1099. }
  1100. }
  1101. // 下载转换好的JSON文件
  1102. public function download(Request $request)
  1103. {
  1104. $type = $request->input('type');
  1105. if(empty($type)){
  1106. exit('参数异常');
  1107. }
  1108. if($type == '1'){
  1109. $filePath = public_path('downloads/convert.json');
  1110. }else{
  1111. $filePath = public_path('downloads/decompile.json');
  1112. }
  1113. if(!file_exists($filePath)){
  1114. exit('文件不存在,请检查目录权限');
  1115. }
  1116. return Response::download($filePath);
  1117. }
  1118. // 数据导入
  1119. public function import(Request $request)
  1120. {
  1121. if($request->isMethod('POST')){
  1122. if(!$request->hasFile('uploadFile')){
  1123. Session::flash('errorMsg', '请选择要上传的文件');
  1124. return Redirect::back();
  1125. }
  1126. $file = $request->file('uploadFile');
  1127. // 只能上传JSON文件
  1128. if($file->getClientMimeType() != 'application/json' || $file->getClientOriginalExtension() != 'json'){
  1129. Session::flash('errorMsg', '只允许上传JSON文件');
  1130. return Redirect::back();
  1131. }
  1132. if(!$file->isValid()){
  1133. Session::flash('errorMsg', '产生未知错误,请重新上传');
  1134. return Redirect::back();
  1135. }
  1136. $save_path = realpath(storage_path('uploads'));
  1137. $new_name = md5($file->getClientOriginalExtension()).'.json';
  1138. $file->move($save_path, $new_name);
  1139. // 读取文件内容
  1140. $data = file_get_contents($save_path.'/'.$new_name);
  1141. $data = json_decode($data);
  1142. if(!$data){
  1143. Session::flash('errorMsg', '内容格式解析异常,请上传符合SSR(R)配置规范的JSON文件');
  1144. return Redirect::back();
  1145. }
  1146. try{
  1147. DB::beginTransaction();
  1148. foreach($data as $user){
  1149. $obj = new User();
  1150. $obj->email = $user->user;
  1151. $obj->password = Hash::make('123456');
  1152. $obj->port = $user->port;
  1153. $obj->passwd = $user->passwd;
  1154. $obj->vmess_id = $user->vmess_id;
  1155. $obj->transfer_enable = $user->transfer_enable;
  1156. $obj->u = 0;
  1157. $obj->d = 0;
  1158. $obj->t = 0;
  1159. $obj->enable = 1;
  1160. $obj->method = $user->method;
  1161. $obj->protocol = $user->protocol;
  1162. $obj->protocol_param = $user->protocol_param;
  1163. $obj->obfs = $user->obfs;
  1164. $obj->obfs_param = $user->obfs_param;
  1165. $obj->speed_limit_per_con = 204800;
  1166. $obj->speed_limit_per_user = 204800;
  1167. $obj->wechat = '';
  1168. $obj->qq = '';
  1169. $obj->usage = 1;
  1170. $obj->pay_way = 3;
  1171. $obj->balance = 0;
  1172. $obj->enable_time = date('Y-m-d');
  1173. $obj->expire_time = '2099-01-01';
  1174. $obj->remark = '';
  1175. $obj->is_admin = 0;
  1176. $obj->reg_ip = getClientIp();
  1177. $obj->created_at = date('Y-m-d H:i:s');
  1178. $obj->updated_at = date('Y-m-d H:i:s');
  1179. $obj->save();
  1180. }
  1181. DB::commit();
  1182. }catch(Exception $e){
  1183. DB::rollBack();
  1184. Session::flash('errorMsg', '出错了,可能是导入的配置中有端口已经存在了');
  1185. return Redirect::back();
  1186. }
  1187. Session::flash('successMsg', '导入成功');
  1188. return Redirect::back();
  1189. }else{
  1190. return Response::view('admin.import');
  1191. }
  1192. }
  1193. // 导出配置信息
  1194. public function export(Request $request, $id)
  1195. {
  1196. if(empty($id)){
  1197. return Redirect::to('admin/userList');
  1198. }
  1199. $user = User::query()->whereId($id)->first();
  1200. if(empty($user)){
  1201. return Redirect::to('admin/userList');
  1202. }
  1203. if($request->isMethod('POST')){
  1204. $node_id = $request->input('id');
  1205. $infoType = $request->input('type');
  1206. $node = SsNode::query()->whereId($node_id)->first();
  1207. $proxyType = $node->type == 1? ($node->compatible? 'SS' : 'SSR') : 'V2Ray';
  1208. $data = $this->getNodeInfo($id, $node->id, $infoType != 'text'? 0 : 1);
  1209. return Response::json(['status' => 'success', 'data' => $data, 'title' => $proxyType]);
  1210. }else{
  1211. $view['nodeList'] = SsNode::query()->whereStatus(1)->orderBy('sort', 'desc')->orderBy('id', 'asc')->paginate(15)->appends($request->except('page'));
  1212. $view['user'] = $user;
  1213. }
  1214. return Response::view('admin.export', $view);
  1215. }
  1216. // 导出原版SS用户配置信息
  1217. public function exportSSJson()
  1218. {
  1219. $userList = User::query()->where('port', '>', 0)->get();
  1220. $defaultMethod = Helpers::getDefaultMethod();
  1221. $json = '';
  1222. if(!$userList->isEmpty()){
  1223. $tmp = [];
  1224. foreach($userList as $key => $user){
  1225. $tmp[] = '"'.$user->port.'":"'.$user->passwd.'"';
  1226. }
  1227. $userPassword = implode(",\n\t\t", $tmp);
  1228. $json = <<<EOF
  1229. {
  1230. "server":"0.0.0.0",
  1231. "local_address":"127.0.0.1",
  1232. "local_port":1080,
  1233. "port_password":{
  1234. {$userPassword}
  1235. },
  1236. "timeout":300,
  1237. "method":"{$defaultMethod}",
  1238. "fast_open":false
  1239. }
  1240. EOF;
  1241. }
  1242. // 生成JSON文件
  1243. $fileName = makeRandStr('16').'_shadowsocks.json';
  1244. $filePath = public_path('downloads/'.$fileName);
  1245. file_put_contents($filePath, $json);
  1246. if(!file_exists($filePath)){
  1247. exit('文件生成失败,请检查目录权限');
  1248. }
  1249. return Response::download($filePath);
  1250. }
  1251. // 修改个人资料
  1252. public function profile(Request $request)
  1253. {
  1254. if($request->isMethod('POST')){
  1255. $old_password = trim($request->input('old_password'));
  1256. $new_password = trim($request->input('new_password'));
  1257. if(!Hash::check($old_password, Auth::user()->password)){
  1258. return Redirect::back()->withErrors('旧密码错误,请重新输入');
  1259. }elseif(Hash::check($new_password, Auth::user()->password)){
  1260. return Redirect::back()->withErrors('新密码不可与旧密码一样,请重新输入');
  1261. }
  1262. $ret = User::uid()->update(['password' => Hash::make($new_password)]);
  1263. if(!$ret){
  1264. return Redirect::back()->withErrors('修改失败');
  1265. }else{
  1266. return Redirect::back()->with('successMsg', '修改成功');
  1267. }
  1268. }else{
  1269. return Response::view('admin.profile');
  1270. }
  1271. }
  1272. // 用户流量监控
  1273. public function userMonitor($id)
  1274. {
  1275. if(empty($id)){
  1276. return Redirect::to('admin/userList');
  1277. }
  1278. $user = User::query()->whereId($id)->first();
  1279. if(empty($user)){
  1280. return Redirect::to('admin/userList');
  1281. }
  1282. // 30天内的流量
  1283. $dailyData = [];
  1284. $hourlyData = [];
  1285. // 节点一个月内的流量
  1286. $userTrafficDaily = UserTrafficDaily::query()->whereUserId($user->id)->whereNodeId(0)->where('created_at', '>=', date('Y-m', time()))->orderBy('created_at', 'asc')->pluck('total')->toArray();
  1287. $dailyTotal = date('d')-1; // 今天不算,减一
  1288. $dailyCount = count($userTrafficDaily);
  1289. for($x = 0; $x < $dailyTotal-$dailyCount; $x++){
  1290. $dailyData[$x] = 0;
  1291. }
  1292. for($x = $dailyTotal-$dailyCount; $x < $dailyTotal; $x++){
  1293. $dailyData[$x] = round($userTrafficDaily[$x-($dailyTotal-$dailyCount)]/(1024*1024*1024), 3);
  1294. }
  1295. // 节点一天内的流量
  1296. $userTrafficHourly = UserTrafficHourly::query()->whereUserId($user->id)->whereNodeId(0)->where('created_at', '>=', date('Y-m-d', time()))->orderBy('created_at', 'asc')->pluck('total')->toArray();
  1297. $hourlyTotal = date('H');
  1298. $hourlyCount = count($userTrafficHourly);
  1299. for($x = 0; $x < $hourlyTotal-$hourlyCount; $x++){
  1300. $hourlyData[$x] = 0;
  1301. }
  1302. for($x = ($hourlyTotal-$hourlyCount); $x < $hourlyTotal; $x++){
  1303. $hourlyData[$x] = round($userTrafficHourly[$x-($hourlyTotal-$hourlyCount)]/(1024*1024*1024), 3);
  1304. }
  1305. // 本月天数数据
  1306. $monthDays = [];
  1307. for($i = 1; $i <= date("d"); $i++){
  1308. $monthDays[] = $i;
  1309. }
  1310. // 本日小时数据
  1311. $dayHours = [];
  1312. for($i = 1; $i <= date("H"); $i++){
  1313. $dayHours[] = $i;
  1314. }
  1315. $view['trafficDaily'] = "'".implode("','", $dailyData)."'";
  1316. $view['trafficHourly'] = "'".implode("','", $hourlyData)."'";
  1317. $view['monthDays'] = "'".implode("','", $monthDays)."'";
  1318. $view['dayHours'] = "'".implode("','", $dayHours)."'";
  1319. $view['email'] = $user->email;
  1320. return Response::view('admin.logs.userMonitor', $view);
  1321. }
  1322. // 生成端口
  1323. public function makePort()
  1324. {
  1325. return self::$systemConfig['is_rand_port']? Helpers::getRandPort() : Helpers::getOnlyPort();
  1326. }
  1327. // 加密方式、混淆、协议、等级、国家地区
  1328. public function config(Request $request)
  1329. {
  1330. if($request->isMethod('POST')){
  1331. $name = $request->input('name');
  1332. $type = $request->input('type', 1); // 类型:1-加密方式(method)、2-协议(protocol)、3-混淆(obfs)
  1333. $is_default = $request->input('is_default', 0);
  1334. $sort = $request->input('sort', 0);
  1335. if(empty($name)){
  1336. return Response::json(['status' => 'fail', 'data' => '', 'message' => '配置名称不能为空']);
  1337. }
  1338. // 校验是否已存在
  1339. $config = SsConfig::type($type)->whereName($name)->first();
  1340. if($config){
  1341. return Response::json(['status' => 'fail', 'data' => '', 'message' => '配置已经存在,请勿重复添加']);
  1342. }
  1343. $ssConfig = new SsConfig();
  1344. $ssConfig->name = $name;
  1345. $ssConfig->type = $type;
  1346. $ssConfig->is_default = $is_default;
  1347. $ssConfig->sort = $sort;
  1348. $ssConfig->save();
  1349. return Response::json(['status' => 'success', 'data' => '', 'message' => '添加成功']);
  1350. }else{
  1351. $view['method_list'] = SsConfig::type(1)->get();
  1352. $view['protocol_list'] = SsConfig::type(2)->get();
  1353. $view['obfs_list'] = SsConfig::type(3)->get();
  1354. $view['level_list'] = Helpers::levelList();
  1355. $view['country_list'] = Country::query()->get();
  1356. return Response::view('admin.config', $view);
  1357. }
  1358. }
  1359. // 删除配置
  1360. public function delConfig(Request $request)
  1361. {
  1362. $id = $request->input('id');
  1363. $ret = SsConfig::query()->whereId($id)->delete();
  1364. if($ret){
  1365. return Response::json(['status' => 'success', 'data' => '', 'message' => '删除成功']);
  1366. }else{
  1367. return Response::json(['status' => 'fail', 'data' => '', 'message' => '删除失败']);
  1368. }
  1369. }
  1370. // 设置默认配置
  1371. public function setDefaultConfig(Request $request)
  1372. {
  1373. $id = $request->input('id');
  1374. if(empty($id)){
  1375. return Response::json(['status' => 'fail', 'data' => '', 'message' => '非法请求']);
  1376. }
  1377. $config = SsConfig::query()->whereId($id)->first();
  1378. if(!$config){
  1379. return Response::json(['status' => 'fail', 'data' => '', 'message' => '配置不存在']);
  1380. }
  1381. // 去除该配置所属类型的默认值
  1382. SsConfig::default()->type($config->type)->update(['is_default' => 0]);
  1383. // 将该ID对应记录值置为默认值
  1384. SsConfig::query()->whereId($id)->update(['is_default' => 1]);
  1385. return Response::json(['status' => 'success', 'data' => '', 'message' => '操作成功']);
  1386. }
  1387. // 设置系统扩展信息,例如客服、统计代码
  1388. public function setExtend(Request $request)
  1389. {
  1390. $websiteAnalytics = $request->input('website_analytics');
  1391. $websiteCustomerService = $request->input('website_customer_service');
  1392. DB::beginTransaction();
  1393. try{
  1394. // 首页LOGO
  1395. if($request->hasFile('website_home_logo')){
  1396. $file = $request->file('website_home_logo');
  1397. $fileType = $file->getClientOriginalExtension();
  1398. // 验证文件合法性
  1399. if(!in_array($fileType, ['jpg', 'png', 'jpeg', 'bmp'])){
  1400. Session::flash('errorMsg', 'LOGO不合法');
  1401. return Redirect::back();
  1402. }
  1403. $logoName = date('YmdHis').mt_rand(1000, 2000).'.'.$fileType;
  1404. $move = $file->move(base_path().'/public/upload/image/', $logoName);
  1405. $websiteHomeLogo = $move? '/upload/image/'.$logoName : '';
  1406. Config::query()->whereName('website_home_logo')->update(['value' => $websiteHomeLogo]);
  1407. }
  1408. // 站内LOGO
  1409. if($request->hasFile('website_logo')){
  1410. $file = $request->file('website_logo');
  1411. $fileType = $file->getClientOriginalExtension();
  1412. // 验证文件合法性
  1413. if(!in_array($fileType, ['jpg', 'png', 'jpeg', 'bmp'])){
  1414. Session::flash('errorMsg', 'LOGO不合法');
  1415. return Redirect::back();
  1416. }
  1417. $logoName = date('YmdHis').mt_rand(1000, 2000).'.'.$fileType;
  1418. $move = $file->move(base_path().'/public/upload/image/', $logoName);
  1419. $websiteLogo = $move? '/upload/image/'.$logoName : '';
  1420. Config::query()->whereName('website_logo')->update(['value' => $websiteLogo]);
  1421. }
  1422. Config::query()->whereName('website_analytics')->update(['value' => $websiteAnalytics]);
  1423. Config::query()->whereName('website_customer_service')->update(['value' => $websiteCustomerService]);
  1424. Session::flash('successMsg', '更新成功');
  1425. DB::commit();
  1426. return Redirect::back();
  1427. }catch(Exception $e){
  1428. DB::rollBack();
  1429. Session::flash('errorMsg', '更新失败');
  1430. return Redirect::back();
  1431. }
  1432. }
  1433. // 日志分析
  1434. public function analysis()
  1435. {
  1436. $file = storage_path('app/ssserver.log');
  1437. if(!file_exists($file)){
  1438. Session::flash('analysisErrorMsg', $file.' 不存在,请先创建文件');
  1439. return Response::view('admin.analysis');
  1440. }
  1441. $logs = $this->tail($file, 10000);
  1442. if(FALSE === $logs){
  1443. $view['urlList'] = [];
  1444. }else{
  1445. $url = [];
  1446. foreach($logs as $log){
  1447. if(strpos($log, 'TCP connecting')){
  1448. continue;
  1449. }
  1450. preg_match('/TCP request (\w+\.){2}\w+/', $log, $tcp_matches);
  1451. if(!empty($tcp_matches)){
  1452. $url[] = str_replace('TCP request ', '[TCP] ', $tcp_matches[0]);
  1453. }else{
  1454. preg_match('/UDP data to (25[0-5]|2[0-4]\d|[0-1]\d{2}|[1-9]?\d)\.(25[0-5]|2[0-4]\d|[0-1]\d{2}|[1-9]?\d)\.(25[0-5]|2[0-4]\d|[0-1]\d{2}|[1-9]?\d)\.(25[0-5]|2[0-4]\d|[0-1]\d{2}|[1-9]?\d)/', $log, $udp_matches);
  1455. if(!empty($udp_matches)){
  1456. $url[] = str_replace('UDP data to ', '[UDP] ', $udp_matches[0]);
  1457. }
  1458. }
  1459. }
  1460. $view['urlList'] = array_unique($url);
  1461. }
  1462. return Response::view('admin.analysis', $view);
  1463. }
  1464. // 添加等级
  1465. public function addLevel(Request $request)
  1466. {
  1467. $level = $request->input('level');
  1468. $level_name = trim($request->input('level_name'));
  1469. if(empty($level)){
  1470. return Response::json(['status' => 'fail', 'data' => '', 'message' => '等级不能为空']);
  1471. }
  1472. if(empty($level_name)){
  1473. return Response::json(['status' => 'fail', 'data' => '', 'message' => '等级名称不能为空']);
  1474. }
  1475. $exists = Level::query()->whereLevel($level)->first();
  1476. if($exists){
  1477. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该等级已存在,请勿重复添加']);
  1478. }
  1479. $obj = new Level();
  1480. $obj->level = $level;
  1481. $obj->level_name = $level_name;
  1482. $obj->save();
  1483. if($obj->id){
  1484. return Response::json(['status' => 'success', 'data' => '', 'message' => '提交成功']);
  1485. }else{
  1486. return Response::json(['status' => 'fail', 'data' => '', 'message' => '操作失败']);
  1487. }
  1488. }
  1489. // 编辑等级
  1490. public function updateLevel(Request $request)
  1491. {
  1492. $id = $request->input('id');
  1493. $level = $request->input('level');
  1494. $level_name = $request->input('level_name');
  1495. if(!$id){
  1496. return Response::json(['status' => 'fail', 'data' => '', 'message' => 'ID不能为空']);
  1497. }
  1498. if(!$level){
  1499. return Response::json(['status' => 'fail', 'data' => '', 'message' => '等级不能为空']);
  1500. }
  1501. if(!$level_name){
  1502. return Response::json(['status' => 'fail', 'data' => '', 'message' => '等级名称不能为空']);
  1503. }
  1504. $le = Level::query()->whereId($id)->first();
  1505. if(!$le){
  1506. return Response::json(['status' => 'fail', 'data' => '', 'message' => '等级不存在']);
  1507. }
  1508. // 校验该等级下是否存在关联分组
  1509. $ssGroupCount = SsGroup::query()->whereLevel($le->level)->count();
  1510. if($ssGroupCount){
  1511. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该等级下存在关联分组,请先取消关联']);
  1512. }
  1513. // 校验该等级下是否存在关联账号
  1514. $userCount = User::query()->whereLevel($le->level)->count();
  1515. if($userCount){
  1516. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该等级下存在关联账号,请先取消关联']);
  1517. }
  1518. Level::query()->whereId($id)->update(['level' => $level, 'level_name' => $level_name]);
  1519. return Response::json(['status' => 'success', 'data' => '', 'message' => '操作成功']);
  1520. }
  1521. // 删除等级
  1522. public function delLevel(Request $request)
  1523. {
  1524. $id = $request->input('id');
  1525. if(empty($id)){
  1526. return Response::json(['status' => 'fail', 'data' => '', 'message' => 'ID不能为空']);
  1527. }
  1528. $level = Level::query()->whereId($id)->first();
  1529. if(empty($level)){
  1530. return Response::json(['status' => 'fail', 'data' => '', 'message' => '等级不存在']);
  1531. }
  1532. // 校验该等级下是否存在关联分组
  1533. $existGroups = SsGroup::query()->whereLevel($level->level)->get();
  1534. if(!$existGroups->isEmpty()){
  1535. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该等级下存在关联分组,请先取消关联']);
  1536. }
  1537. // 校验该等级下是否存在关联账号
  1538. $existUsers = User::query()->whereLevel($level->level)->get();
  1539. if(!$existUsers->isEmpty()){
  1540. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该等级下存在关联账号,请先取消关联']);
  1541. }
  1542. $ret = FALSE;
  1543. try{
  1544. $ret = Level::query()->whereId($id)->delete();
  1545. }catch(Exception $e){
  1546. Log::error('删除等级时报错:'.$e);
  1547. }
  1548. if($ret){
  1549. return Response::json(['status' => 'success', 'data' => '', 'message' => '操作成功']);
  1550. }else{
  1551. return Response::json(['status' => 'fail', 'data' => '', 'message' => '操作失败']);
  1552. }
  1553. }
  1554. // 添加国家/地区
  1555. public function addCountry(Request $request)
  1556. {
  1557. $name = $request->input('country_name');
  1558. $code = $request->input('country_code');
  1559. if(empty($name)){
  1560. return Response::json(['status' => 'fail', 'data' => '', 'message' => '国家/地区名称不能为空']);
  1561. }
  1562. if(empty($code)){
  1563. return Response::json(['status' => 'fail', 'data' => '', 'message' => '国家/地区代码不能为空']);
  1564. }
  1565. $exists = Country::query()->whereName($name)->first();
  1566. if($exists){
  1567. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该国家/地区名称已存在,请勿重复添加']);
  1568. }
  1569. $obj = new Country();
  1570. $obj->name = $name;
  1571. $obj->code = $code;
  1572. $obj->save();
  1573. if($obj->id){
  1574. return Response::json(['status' => 'success', 'data' => '', 'message' => '提交成功']);
  1575. }else{
  1576. return Response::json(['status' => 'fail', 'data' => '', 'message' => '操作失败']);
  1577. }
  1578. }
  1579. // 编辑国家/地区
  1580. public function updateCountry(Request $request)
  1581. {
  1582. $id = $request->input('id');
  1583. $name = $request->input('country_name');
  1584. $code = $request->input('country_code');
  1585. if(empty($id)){
  1586. return Response::json(['status' => 'fail', 'data' => '', 'message' => 'ID不能为空']);
  1587. }
  1588. if(empty($name)){
  1589. return Response::json(['status' => 'fail', 'data' => '', 'message' => '国家/地区名称不能为空']);
  1590. }
  1591. if(empty($code)){
  1592. return Response::json(['status' => 'fail', 'data' => '', 'message' => '国家/地区代码不能为空']);
  1593. }
  1594. $country = Country::query()->whereId($id)->first();
  1595. if(empty($country)){
  1596. return Response::json(['status' => 'fail', 'data' => '', 'message' => '国家/地区不存在']);
  1597. }
  1598. // 校验该国家/地区下是否存在关联节点
  1599. $existNode = SsNode::query()->whereCountryCode($country->code)->get();
  1600. if(!$existNode->isEmpty()){
  1601. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该国家/地区下存在关联节点,请先取消关联']);
  1602. }
  1603. $ret = Country::query()->whereId($id)->update(['name' => $name, 'code' => $code]);
  1604. if($ret){
  1605. return Response::json(['status' => 'success', 'data' => '', 'message' => '操作成功']);
  1606. }else{
  1607. return Response::json(['status' => 'fail', 'data' => '', 'message' => '操作失败']);
  1608. }
  1609. }
  1610. // 删除国家/地区
  1611. public function delCountry(Request $request)
  1612. {
  1613. $id = $request->input('id');
  1614. if(empty($id)){
  1615. return Response::json(['status' => 'fail', 'data' => '', 'message' => 'ID不能为空']);
  1616. }
  1617. $country = Country::query()->whereId($id)->first();
  1618. if(empty($country)){
  1619. return Response::json(['status' => 'fail', 'data' => '', 'message' => '国家/地区不存在']);
  1620. }
  1621. // 校验该国家/地区下是否存在关联节点
  1622. $existNode = SsNode::query()->whereCountryCode($country->code)->get();
  1623. if(!$existNode->isEmpty()){
  1624. return Response::json(['status' => 'fail', 'data' => '', 'message' => '该国家/地区下存在关联节点,请先取消关联']);
  1625. }
  1626. $ret = FALSE;
  1627. try{
  1628. $ret = Country::query()->whereId($id)->delete();
  1629. }catch(Exception $e){
  1630. Log::error('删除国家/地区时报错:'.$e);
  1631. }
  1632. if($ret){
  1633. return Response::json(['status' => 'success', 'data' => '', 'message' => '操作成功']);
  1634. }else{
  1635. return Response::json(['status' => 'fail', 'data' => '', 'message' => '操作失败']);
  1636. }
  1637. }
  1638. // 系统设置
  1639. public function system()
  1640. {
  1641. $view = self::$systemConfig;
  1642. $view['label_list'] = Label::query()->orderBy('sort', 'desc')->orderBy('id', 'asc')->get();
  1643. return Response::view('admin.system', $view);
  1644. }
  1645. // 设置某个配置项
  1646. public function setConfig(Request $request)
  1647. {
  1648. $name = $request->input('name');
  1649. $value = trim($request->input('value'));
  1650. if(!$name){
  1651. return Response::json(['status' => 'fail', 'message' => '设置失败:请求参数异常']);
  1652. }
  1653. // 屏蔽异常配置
  1654. if(!array_key_exists($name, self::$systemConfig)){
  1655. return Response::json(['status' => 'fail', 'message' => '设置失败:配置不存在']);
  1656. }
  1657. // 如果开启用户邮件重置密码,则先设置网站名称和网址
  1658. if(in_array($name, ['is_reset_password', 'is_activate_account', 'expire_warning', 'traffic_warning']) && $value != '0'){
  1659. $config = Config::query()->whereName('website_name')->first();
  1660. if($config->value == ''){
  1661. return Response::json(['status' => 'fail', 'message' => '设置失败:启用该配置需要先设置【网站名称】']);
  1662. }
  1663. $config = Config::query()->whereName('website_url')->first();
  1664. if($config->value == ''){
  1665. return Response::json(['status' => 'fail', 'message' => '设置失败:启用该配置需要先设置【网站地址】']);
  1666. }
  1667. }
  1668. // 支付设置判断
  1669. if(in_array($name, ['is_AliPay', 'is_QQPay', 'is_WeChatPay', 'is_otherPay']) && $value != ''){
  1670. switch($value){
  1671. case 'f2fpay':
  1672. if(!self::$systemConfig['f2fpay_app_id'] || !self::$systemConfig['f2fpay_private_key'] || !self::$systemConfig['f2fpay_public_key']){
  1673. return Response::json(['status' => 'fail', 'message' => '请先设置【支付宝F2F】必要参数']);
  1674. }
  1675. break;
  1676. case 'codepay':
  1677. if(!self::$systemConfig['codepay_url'] || !self::$systemConfig['codepay_id'] || !self::$systemConfig['codepay_key']){
  1678. return Response::json(['status' => 'fail', 'message' => '请先设置【码支付】必要参数']);
  1679. }
  1680. break;
  1681. case 'payjs':
  1682. if(!self::$systemConfig['payjs_mch_id'] || !self::$systemConfig['payjs_key']){
  1683. return Response::json(['status' => 'fail', 'message' => '请先设置【PayJs】必要参数']);
  1684. }
  1685. break;
  1686. case 'bitpayx':
  1687. if(!self::$systemConfig['bitpay_secret']){
  1688. return Response::json(['status' => 'fail', 'message' => '请先设置【麻瓜宝】必要参数']);
  1689. }
  1690. break;
  1691. default:
  1692. return Response::json(['status' => 'fail', 'message' => '未知支付渠道']);
  1693. break;
  1694. }
  1695. }
  1696. // 演示环境禁止修改特定配置项
  1697. if(env('APP_DEMO')){
  1698. $denyConfig = ['website_url', 'min_rand_traffic', 'max_rand_traffic', 'push_bear_send_key', 'push_bear_qrcode', 'is_forbid_china', 'website_security_code'];
  1699. if(in_array($name, $denyConfig)){
  1700. return Response::json(['status' => 'fail', 'message' => '演示环境禁止修改该配置']);
  1701. }
  1702. }
  1703. // 如果是返利比例,则需要除100
  1704. if(in_array($name, ['referral_percent'])){
  1705. $value = intval($value)/100;
  1706. }
  1707. // 更新配置
  1708. Config::query()->whereName($name)->update(['value' => $value]);
  1709. return Response::json(['status' => 'success', 'data' => '', 'message' => '操作成功']);
  1710. }
  1711. //推送通知测试
  1712. public function sendTestNotification()
  1713. {
  1714. if(self::$systemConfig['is_notification']){
  1715. $result = PushNotification::send('这是测试的标题', 'SSRPanel_OM测试内容');
  1716. if($result == FALSE){
  1717. return Response::json(['status' => 'fail', 'message' => '发送失败,请重新尝试!']);
  1718. }
  1719. switch(self::$systemConfig['is_notification']){
  1720. case 'serverChan':
  1721. if(!$result->errno){
  1722. return Response::json(['status' => 'success', 'message' => '发送成功,请查看手机是否收到推送消息']);
  1723. }else{
  1724. return Response::json(['status' => 'fail', 'message' => $result? $result->errmsg : '未知']);
  1725. }
  1726. break;
  1727. case 'bark':
  1728. if($result->code == 200){
  1729. return Response::json(['status' => 'success', 'message' => '发送成功,请查看手机是否收到推送消息']);
  1730. }else{
  1731. return Response::json(['status' => 'fail', 'message' => $result->message]);
  1732. }
  1733. break;
  1734. default:
  1735. }
  1736. }
  1737. return Response::json(['status' => 'fail', 'message' => '请先选择【日志通知】渠道']);
  1738. }
  1739. // 邀请码列表
  1740. public function inviteList(Request $request)
  1741. {
  1742. $view['inviteList'] = Invite::query()->with(['generator', 'user'])->orderBy('status', 'asc')->orderBy('id', 'desc')->paginate(15)->appends($request->except('page'));
  1743. return Response::view('admin.inviteList', $view);
  1744. }
  1745. // 生成邀请码
  1746. public function makeInvite()
  1747. {
  1748. for($i = 0; $i < 10; $i++){
  1749. $obj = new Invite();
  1750. $obj->uid = 0;
  1751. $obj->fuid = 0;
  1752. $obj->code = strtoupper(substr(md5(microtime().makeRandStr()), 8, 12));
  1753. $obj->status = 0;
  1754. $obj->dateline = date('Y-m-d H:i:s', strtotime("+".self::$systemConfig['admin_invite_days']." days"));
  1755. $obj->save();
  1756. }
  1757. return Response::json(['status' => 'success', 'data' => '', 'message' => '生成成功']);
  1758. }
  1759. // 导出邀请码
  1760. public function exportInvite()
  1761. {
  1762. $inviteList = Invite::query()->whereStatus(0)->orderBy('id', 'asc')->get();
  1763. $filename = '邀请码'.date('Ymd').'.xlsx';
  1764. $spreadsheet = new Spreadsheet();
  1765. $spreadsheet->getProperties()->setCreator('SSRPanel')->setLastModifiedBy('SSRPanel')->setTitle('邀请码')->setSubject('邀请码')->setDescription('')->setKeywords('')->setCategory('');
  1766. try{
  1767. $spreadsheet->setActiveSheetIndex(0);
  1768. $sheet = $spreadsheet->getActiveSheet();
  1769. $sheet->setTitle('邀请码');
  1770. $sheet->fromArray(['邀请码', '有效期'], NULL);
  1771. foreach($inviteList as $k => $vo){
  1772. $sheet->fromArray([$vo->code, $vo->dateline], NULL, 'A'.($k+2));
  1773. }
  1774. header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); // 输出07Excel文件
  1775. //header('Content-Type:application/vnd.ms-excel'); // 输出Excel03版本文件
  1776. header('Content-Disposition: attachment;filename="'.$filename.'"');
  1777. header('Cache-Control: max-age=0');
  1778. $writer = new Xlsx($spreadsheet);
  1779. $writer->save('php://output');
  1780. }catch(\PhpOffice\PhpSpreadsheet\Exception $e){
  1781. Log::error('导出优惠券时报错'.$e);
  1782. }
  1783. }
  1784. // 订单列表
  1785. public function orderList(Request $request)
  1786. {
  1787. $email = $request->input('email');
  1788. $order_sn = $request->input('order_sn');
  1789. $is_coupon = $request->input('is_coupon');
  1790. $is_expire = $request->input('is_expire');
  1791. $pay_way = $request->input('pay_way');
  1792. $status = $request->input('status');
  1793. $range_time = $request->input('range_time');
  1794. $sort = $request->input('sort'); // 0-按创建时间降序、1-按创建时间升序
  1795. $order_id = $request->input('oid');
  1796. $query = Order::query()->with(['user', 'goods', 'coupon']);
  1797. if(isset($email)){
  1798. $query->whereHas('user', function($q) use ($email){
  1799. $q->where('email', 'like', '%'.$email.'%');
  1800. });
  1801. }
  1802. if(isset($order_sn)){
  1803. $query->where('order_sn', 'like', '%'.$order_sn.'%');
  1804. }
  1805. if(isset($is_coupon)){
  1806. if($is_coupon){
  1807. $query->where('coupon_id', '<>', 0);
  1808. }else{
  1809. $query->whereCouponId(0);
  1810. }
  1811. }
  1812. if(isset($is_expire)){
  1813. $query->whereIsExpire($is_expire);
  1814. }
  1815. if(isset($pay_way)){
  1816. $query->wherePayWay($pay_way);
  1817. }
  1818. if(isset($status)){
  1819. $query->whereStatus($status);
  1820. }
  1821. if(isset($range_time) && $range_time != ','){
  1822. $range_time = explode(',', $range_time);
  1823. $query->where('created_at', '>=', $range_time[0])->where('created_at', '<=', $range_time[1]);
  1824. }
  1825. if(isset($order_id)){
  1826. $query->whereOid($order_id);
  1827. }
  1828. if($sort){
  1829. $query->orderBy('oid', 'asc');
  1830. }else{
  1831. $query->orderBy('oid', 'desc');
  1832. }
  1833. $view['orderList'] = $query->paginate(15)->appends($request->except('page'));
  1834. return Response::view('admin.logs.orderList', $view);
  1835. }
  1836. // 重置用户流量
  1837. public function resetUserTraffic(Request $request)
  1838. {
  1839. $id = $request->input('id');
  1840. User::query()->whereId($id)->update(['u' => 0, 'd' => 0]);
  1841. return Response::json(['status' => 'success', 'data' => '', 'message' => '操作成功']);
  1842. }
  1843. // 操作用户余额
  1844. public function handleUserBalance(Request $request)
  1845. {
  1846. if($request->isMethod('POST')){
  1847. $userId = $request->input('user_id');
  1848. $amount = $request->input('amount');
  1849. if(empty($userId) || empty($amount)){
  1850. return Response::json(['status' => 'fail', 'data' => '', 'message' => '充值异常']);
  1851. }
  1852. DB::beginTransaction();
  1853. try{
  1854. $user = User::query()->whereId($userId)->first();
  1855. // 写入余额变动日志
  1856. Helpers::addUserBalanceLog($userId, 0, $user->balance, $user->balance+$amount, $amount, '后台手动充值');
  1857. // 加减余额
  1858. if($amount < 0){
  1859. $user->decrement('balance', abs($amount)*100);
  1860. }else{
  1861. $user->increment('balance', abs($amount)*100);
  1862. }
  1863. DB::commit();
  1864. return Response::json(['status' => 'success', 'data' => '', 'message' => '充值成功']);
  1865. }catch(Exception $e){
  1866. DB::rollBack();
  1867. return Response::json(['status' => 'fail', 'data' => '', 'message' => '充值失败:'.$e->getMessage()]);
  1868. }
  1869. }else{
  1870. return Response::view('admin.handleUserBalance');
  1871. }
  1872. }
  1873. // 用户余额变动记录
  1874. public function userBalanceLogList(Request $request)
  1875. {
  1876. $email = $request->input('email');
  1877. $query = UserBalanceLog::query()->with(['user'])->orderBy('id', 'desc');
  1878. if(isset($email)){
  1879. $query->whereHas('user', function($q) use ($email){
  1880. $q->where('email', 'like', '%'.$email.'%');
  1881. });
  1882. }
  1883. $view['list'] = $query->paginate(15)->appends($request->except('page'));
  1884. return Response::view('admin.logs.userBalanceLogList', $view);
  1885. }
  1886. // 用户封禁记录
  1887. public function userBanLogList(Request $request)
  1888. {
  1889. $email = $request->input('email');
  1890. $query = UserBanLog::query()->with(['user'])->orderBy('id', 'desc');
  1891. if(isset($email)){
  1892. $query->whereHas('user', function($q) use ($email){
  1893. $q->where('email', 'like', '%'.$email.'%');
  1894. });
  1895. }
  1896. $view['list'] = $query->paginate(15)->appends($request->except('page'));
  1897. return Response::view('admin.logs.userBanLogList', $view);
  1898. }
  1899. // 用户流量变动记录
  1900. public function userTrafficLogList(Request $request)
  1901. {
  1902. $email = $request->input('email');
  1903. $query = UserTrafficModifyLog::query()->with(['user', 'order', 'order.goods']);
  1904. if(isset($email)){
  1905. $query->whereHas('user', function($q) use ($email){
  1906. $q->where('email', 'like', '%'.$email.'%');
  1907. });
  1908. }
  1909. $view['list'] = $query->orderBy('id', 'desc')->paginate(15)->appends($request->except('page'));
  1910. return Response::view('admin.logs.userTrafficLogList', $view);
  1911. }
  1912. // 用户在线IP记录
  1913. public function userOnlineIPList(Request $request)
  1914. {
  1915. $email = $request->input('email');
  1916. $port = $request->input('port');
  1917. $wechat = $request->input('wechat');
  1918. $qq = $request->input('qq');
  1919. $query = User::query()->where('status', '>=', 0)->whereEnable(1);
  1920. if(isset($email)){
  1921. $query->where('email', 'like', '%'.$email.'%');
  1922. }
  1923. if(isset($wechat)){
  1924. $query->where('wechat', 'like', '%'.$wechat.'%');
  1925. }
  1926. if(isset($qq)){
  1927. $query->where('qq', 'like', '%'.$qq.'%');
  1928. }
  1929. if(isset($port)){
  1930. $query->wherePort($port);
  1931. }
  1932. $userList = $query->paginate(15)->appends($request->except('page'));
  1933. if(!$userList->isEmpty()){
  1934. foreach($userList as $user){
  1935. // 最近5条在线IP记录,如果后端设置为60秒上报一次,则为10分钟内的在线IP
  1936. $user->onlineIPList = SsNodeIp::query()->with(['node'])->whereType('tcp')->wherePort($user->port)->where('created_at', '>=', strtotime("-10 minutes"))->orderBy('id', 'desc')->limit(5)->get();
  1937. }
  1938. }
  1939. $view['userList'] = $userList;
  1940. return Response::view('admin.logs.userOnlineIPList', $view);
  1941. }
  1942. // 转换成某个用户的身份
  1943. public function switchToUser(Request $request)
  1944. {
  1945. $id = $request->input('user_id');
  1946. $user = User::query()->find($id);
  1947. if(!$user){
  1948. return Response::json(['status' => 'fail', 'data' => '', 'message' => "用户不存在"]);
  1949. }
  1950. // 存储当前管理员ID,并将当前登录信息改成要切换的用户的身份信息
  1951. Session::put('admin', Auth::user()->id);
  1952. Auth::login($user);
  1953. return Response::json(['status' => 'success', 'data' => '', 'message' => "身份切换成功"]);
  1954. }
  1955. // 标签列表
  1956. public function labelList(Request $request)
  1957. {
  1958. $labelList = Label::query()->paginate(15)->appends($request->except('page'));
  1959. foreach($labelList as $label){
  1960. $label->userCount = UserLabel::query()->whereLabelId($label->id)->groupBy('label_id')->count();
  1961. $label->nodeCount = SsNodeLabel::query()->whereLabelId($label->id)->groupBy('label_id')->count();
  1962. }
  1963. $view['labelList'] = $labelList;
  1964. return Response::view('admin.label.labelList', $view);
  1965. }
  1966. // 添加标签
  1967. public function addLabel(Request $request)
  1968. {
  1969. if($request->isMethod('POST')){
  1970. $name = $request->input('name');
  1971. $sort = $request->input('sort');
  1972. $label = new Label();
  1973. $label->name = $name;
  1974. $label->sort = $sort;
  1975. $label->save();
  1976. return Response::json(['status' => 'success', 'data' => '', 'message' => '添加成功']);
  1977. }else{
  1978. return Response::view('admin.label.addLabel');
  1979. }
  1980. }
  1981. // 编辑标签
  1982. public function editLabel(Request $request)
  1983. {
  1984. if($request->isMethod('POST')){
  1985. $id = $request->input('id');
  1986. $name = $request->input('name');
  1987. $sort = $request->input('sort');
  1988. Label::query()->whereId($id)->update(['name' => $name, 'sort' => $sort]);
  1989. return Response::json(['status' => 'success', 'data' => '', 'message' => '添加成功']);
  1990. }else{
  1991. $id = $request->input('id');
  1992. $view['label'] = Label::query()->whereId($id)->first();
  1993. return Response::view('admin.label.editLabel', $view);
  1994. }
  1995. }
  1996. // 删除标签
  1997. public function delLabel(Request $request)
  1998. {
  1999. $id = $request->input('id');
  2000. DB::beginTransaction();
  2001. try{
  2002. Label::query()->whereId($id)->delete();
  2003. UserLabel::query()->whereLabelId($id)->delete(); // 删除用户关联
  2004. SsNodeLabel::query()->whereLabelId($id)->delete(); // 删除节点关联
  2005. DB::commit();
  2006. return Response::json(['status' => 'success', 'data' => '', 'message' => '删除成功']);
  2007. }catch(Exception $e){
  2008. DB::rollBack();
  2009. return Response::json(['status' => 'fail', 'data' => '', 'message' => '删除失败:'.$e->getMessage()]);
  2010. }
  2011. }
  2012. // 邮件发送日志列表
  2013. public function notificationLog(Request $request)
  2014. {
  2015. $email = $request->input('email');
  2016. $type = $request->input('type');
  2017. $query = NotificationLog::query();
  2018. if(isset($email)){
  2019. $query->where('address', 'like', '%'.$email.'%');
  2020. }
  2021. if(isset($type)){
  2022. $query->whereType($type);
  2023. }
  2024. $view['list'] = $query->orderBy('id', 'desc')->paginate(15)->appends($request->except('page'));
  2025. return Response::view('admin.logs.notificationLog', $view);
  2026. }
  2027. // 在线IP监控(实时)
  2028. public function onlineIPMonitor(Request $request)
  2029. {
  2030. $ip = $request->input('ip');
  2031. $email = $request->input('email');
  2032. $port = $request->input('port');
  2033. $nodeId = $request->input('nodeId');
  2034. $userId = $request->input('id');
  2035. $query = SsNodeIp::query()->with(['node', 'user'])->whereType('tcp')->where('created_at', '>=', strtotime("-120 seconds"));
  2036. if(isset($ip)){
  2037. $query->whereIp($ip);
  2038. }
  2039. if(isset($email)){
  2040. $query->whereHas('user', function($q) use ($email){
  2041. $q->where('email', 'like', '%'.$email.'%');
  2042. });
  2043. }
  2044. if(isset($port)){
  2045. $query->whereHas('user', function($q) use ($port){
  2046. $q->wherePort($port);
  2047. });
  2048. }
  2049. if(isset($nodeId)){
  2050. $query->whereHas('node', function($q) use ($nodeId){
  2051. $q->whereId($nodeId);
  2052. });
  2053. }
  2054. if(isset($userId)){
  2055. $query->whereHas('user', function($q) use ($userId){
  2056. $q->whereId($userId);
  2057. });
  2058. }
  2059. $list = $query->groupBy('port')->orderBy('id', 'desc');
  2060. foreach($list as $vo){
  2061. // 跳过上报多IP的
  2062. if(strpos($vo->ip, ',') == TRUE){
  2063. continue;
  2064. }
  2065. $ipInfo = QQWry::ip($vo->ip);
  2066. if(isset($ipInfo['error'])){
  2067. // 用IPIP的库再试一下
  2068. $ipip = IPIP::ip($vo->ip);
  2069. $ipInfo = ['country' => $ipip['country_name'], 'province' => $ipip['region_name'], 'city' => $ipip['city_name']];
  2070. }
  2071. $vo->ipInfo = $ipInfo['country'].' '.$ipInfo['province'].' '.$ipInfo['city'];
  2072. }
  2073. $view['list'] = $list->paginate(20)->appends($request->except('page'));
  2074. $view['nodeList'] = SsNode::query()->whereStatus(1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->get();
  2075. return Response::view('admin.logs.onlineIPMonitor', $view);
  2076. }
  2077. }