解决端口不能正常自动释放问题

Administrator · Administrator · commit 11ced40415aa · 2018-03-05T09:39:36.000+08:00
diff --git a/app/Console/Commands/AutoReleasePortJob.php b/app/Console/Commands/AutoReleasePortJob.php
@@ -25,7 +25,9 @@ public function handle()
             $userList = User::query()->where('status', '<', 0)->get();
             if (!$userList->isEmpty()) {
                 foreach ($userList as $user) {
-                    User::query()->where('id', $user->id)->update(['port' => 0]);
+                    if ($user->port) {
+                        User::query()->where('id', $user->id)->update(['port' => 0]);
+                    }
                 }
             }
         }
diff --git a/app/Console/Kernel.php b/app/Console/Kernel.php
@@ -50,7 +50,7 @@ protected function schedule(Schedule $schedule)
         $schedule->command('command:autoDisableUserJob')->everyMinute();
         $schedule->command('command:autoExpireCouponJob')->everyThirtyMinutes();
         $schedule->command('command:autoExpireInviteJob')->everyThirtyMinutes();
-        $schedule->command('command:autoReleasePortJob')->daily();
+        $schedule->command('command:autoReleasePortJob')->everyMinute();
         $schedule->command('command:autoReopenUserJob')->everyMinute();
         $schedule->command('command:autoResetUserTrafficJob')->everyFiveMinutes();
         $schedule->command('command:autoStatisticsNodeDailyTrafficJob')->dailyAt('04:30');
diff --git a/sql/update/20180305.sql b/sql/update/20180305.sql
@@ -0,0 +1,2 @@
+-- 去掉user表的唯一索引，解决无法自动释放端口的问题
+ALTER TABLE `user` DROP INDEX `port`;

Original file line number	Diff line number	Diff line change
`@@ -25,7 +25,9 @@ public function handle()`
`25`	`25`	`$userList = User::query()->where('status', '<', 0)->get();`
`26`	`26`	`if (!$userList->isEmpty()) {`
`27`	`27`	`foreach ($userList as $user) {`
`28`		`- User::query()->where('id', $user->id)->update(['port' => 0]);`
	`28`	`+ if ($user->port) {`
	`29`	`+ User::query()->where('id', $user->id)->update(['port' => 0]);`
	`30`	`+ }`
`29`	`31`	`}`
`30`	`32`	`}`
`31`	`33`	`}`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+-- 去掉user表的唯一索引，解决无法自动释放端口的问题`
	`2`	+ALTER TABLE `user` DROP INDEX `port`;