temp.php

temp.php

<?php

use App\Models\Registration;
use App\Models\Subscription;

.
.
.
.
.
.
.
.

$registrations = Registration::where('is_revoked_by_batch', true)->get();

foreach($registrations as $registration) {
  
 $serviceFlags = explode("|", $registration->subscriptions);
    
    foreach ($serviceFlags as $serviceFlag) {
      
      Subscription::where('username', $registration->username)
        ->where('service_flag', $serviceFlag)
        ->where('is_revoked', false)
        ->update([
          'is_revoked' => true
        ]);
      
    }

}