updateUserName.php 1.8 KB

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