123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150 |
- <?php
- namespace App\Console\Commands;
- use Illuminate\Console\Command;
- use App\Jobs\AvatarPipeline\CreateAvatar;
- use App\Follower;
- use App\Profile;
- use App\User;
- use App\UserSetting;
- use App\Services\UserFilterService;
- use App\Models\DefaultDomainBlock;
- use App\Models\UserDomainBlock;
- use App\Jobs\FollowPipeline\FollowPipeline;
- use DB;
- use App\Services\FollowerService;
- use function Laravel\Prompts\search;
- class FixMissingUserProfile extends Command
- {
- /**
- * The name and signature of the console command.
- *
- * @var string
- */
- protected $signature = 'app:fix-missing-user-profile';
- /**
- * The console command description.
- *
- * @var string
- */
- protected $description = 'Command description';
- /**
- * Execute the console command.
- */
- public function handle()
- {
- $id = search(
- label: 'Search for the affected username',
- options: fn (string $value) => strlen($value) > 0
- ? User::doesntHave('profile')->whereNull('status')->whereLike('username', "%{$value}%")->pluck('username', 'id')->all()
- : []
- );
- if(!$id) {
- $this->error('Found none');
- }
- $user = User::find($id);
- if($user->profile) {
- $this->error('Already has profile');
- return;
- }
- if(in_array($user->status, ['deleted', 'delete'])) {
- $this->error('User has deleted account');
- return;
- }
- if(Profile::whereUsername($user->username)->exists()) {
- $this->error('Already has profile');
- return;
- }
- if (empty($user->profile)) {
- $profile = DB::transaction(function() use($user) {
- $profile = new Profile();
- $profile->user_id = $user->id;
- $profile->username = $user->username;
- $profile->name = $user->name;
- $pkiConfig = [
- 'digest_alg' => 'sha512',
- 'private_key_bits' => 2048,
- 'private_key_type' => OPENSSL_KEYTYPE_RSA,
- ];
- $pki = openssl_pkey_new($pkiConfig);
- openssl_pkey_export($pki, $pki_private);
- $pki_public = openssl_pkey_get_details($pki);
- $pki_public = $pki_public['key'];
- $profile->private_key = $pki_private;
- $profile->public_key = $pki_public;
- $profile->save();
- $this->applyDefaultDomainBlocks($user);
- return $profile;
- });
- DB::transaction(function() use($user, $profile) {
- $user = User::findOrFail($user->id);
- $user->profile_id = $profile->id;
- $user->save();
- CreateAvatar::dispatch($profile);
- });
- if((bool) config_cache('account.autofollow') == true) {
- $names = config_cache('account.autofollow_usernames');
- $names = explode(',', $names);
- if(!$names || !last($names)) {
- return;
- }
- $profiles = Profile::whereIn('username', $names)->get();
- if($profiles) {
- foreach($profiles as $p) {
- $follower = new Follower;
- $follower->profile_id = $profile->id;
- $follower->following_id = $p->id;
- $follower->save();
- FollowPipeline::dispatch($follower);
- }
- }
- }
- }
- if (empty($user->settings)) {
- DB::transaction(function() use($user) {
- UserSetting::firstOrCreate([
- 'user_id' => $user->id
- ]);
- });
- }
- }
- protected function applyDefaultDomainBlocks($user)
- {
- if($user->profile_id == null) {
- return;
- }
- $defaultDomainBlocks = DefaultDomainBlock::pluck('domain')->toArray();
- if(!$defaultDomainBlocks || !count($defaultDomainBlocks)) {
- return;
- }
- foreach($defaultDomainBlocks as $domain) {
- UserDomainBlock::updateOrCreate([
- 'profile_id' => $user->profile_id,
- 'domain' => strtolower(trim($domain))
- ]);
- }
- }
- }
|