Blame view

app/Console/Commands/DeleteOldMessages.php 1022 Bytes
2ea18676c   Hayk Nazaryan   delete old messages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
  <?php
  
  namespace App\Console\Commands;
  
  use App\Models\Chat;
  use App\Models\Message;
  use App\Models\User;
  use Illuminate\Console\Command;
  
  class DeleteOldMessages extends Command
  {
      /**
       * The name and signature of the console command.
       *
       * @var string
       */
      protected $signature = 'app:delete-messages';
  
      /**
       * The console command description.
       *
       * @var string
       */
      protected $description = 'Command description';
  
      /**
       * Execute the console command.
       *
       * @return int
       */
      public function handle()
      {
          Message::query()->get()->map(function ($message) {
              $chatFrom = Chat::query()->where(['id' => $message->chat_id_from])->first();
              if (!$chatFrom) {
28b1a49de   Hayk Nazaryan   delete old messages
36
                  $message->delete();
2ea18676c   Hayk Nazaryan   delete old messages
37
38
39
              }
              $chatTo = Chat::query()->where(['id' => $message->chat_id_to])->first();
              if (!$chatTo) {
28b1a49de   Hayk Nazaryan   delete old messages
40
                  $message->delete();
2ea18676c   Hayk Nazaryan   delete old messages
41
42
43
44
45
46
47
              }
          });
  
  
          return Command::SUCCESS;
      }
  }