updateUserName.php 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  1. <?php
  2. namespace App\Console\Commands;
  3. use App\Components\QQInfo;
  4. use App\Http\Models\User;
  5. use Illuminate\Console\Command;
  6. use Log;
  7. class updateUserName extends Command
  8. {
  9. protected $signature = 'updateUserName';
  10. protected $description = '升级用户昵称';
  11. public function __construct()
  12. {
  13. parent::__construct();
  14. }
  15. public function handle()
  16. {
  17. Log::info('----------------------------【升级用户昵称】开始----------------------------');
  18. $userList = User::query()->get();
  19. foreach($userList as $user){
  20. $name = process($user->id);
  21. User::query()->whereId($user->id)->update(['username' => $name]);
  22. Log::info('---用户[ID:'.$user->id.' - '.$user->email.'] :'.$user->username.'---');
  23. }
  24. foreach($userList as $user){
  25. if($user->email == $user->username){
  26. $name = process($user->id);
  27. User::query()->whereId($user->id)->update(['username' => $name]);
  28. Log::info('---用户[ID:'.$user->id.' - '.$user->email.'] :'.$user->username.'---');
  29. }
  30. }
  31. Log::info('----------------------------【升级用户昵称】结束----------------------------');
  32. }
  33. }
  34. function process($id)
  35. {
  36. $user = User::query()->whereId($id)->first();
  37. // 先设个默认值
  38. $name = $user->email;
  39. // 用户是否设置了QQ号
  40. if($user->qq){
  41. $name = QQInfo::getName3($user->qq);
  42. // 检测用户注册是否为QQ邮箱
  43. }elseif(strpos(strtolower($user->email), '@qq') != FALSE){
  44. // 分离QQ邮箱后缀
  45. $email = explode('@', $user->email);
  46. if(is_numeric($email[0])){
  47. $name = QQInfo::getName3($email[0]);
  48. }else{
  49. // 分离www前缀
  50. if(strpos($email[0], '.') != FALSE){
  51. $temp = explode('.', $email[0]);
  52. if(is_numeric($temp[1])){
  53. $name = QQInfo::getName3($temp[1]);
  54. }else{
  55. print_r($user->email.PHP_EOL);
  56. }
  57. }
  58. }
  59. }
  60. if($name == FALSE){
  61. $name = $user->email;
  62. }
  63. return $name;
  64. }