File: /var/www/html/laravel/app/Console/Commands/UpdateDiffPercent.php
<?php
namespace App\Console\Commands;
use App\Models\Notam;
use Illuminate\Console\Command;
class UpdateDiffPercent extends Command
{
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'notam:update-diff-percent';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Update diff percent for all notams';
/**
* Create a new command instance.
*
* @return void
*/
public function __construct()
{
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle()
{
$notams = Notam::query()->select('notams.*')
->get();
/** @var Notam $notam */
foreach ($notams as $notam) {
$output = $notam->output;
$correctResponse = $notam->correct_response;
if ($output && $correctResponse) {
$cleanedCorrectResponse = $notam->cleanJson($notam->prepareJson($notam->reachOutput($correctResponse)));
$cleanedGptResponse = $notam->cleanJson($notam->prepareJson($notam->reachOutput()));
similar_text(
$cleanedCorrectResponse,
$cleanedGptResponse,
$matchPercent,
);
$matchPercent = floor($matchPercent);
if ($matchPercent != $notam->match_percent) {
echo "Notam {$notam->id} has match percent {$notam->match_percent} and new match percent {$matchPercent}\n";
$notam->match_percent = $matchPercent;
$currentUpdatedAt = $notam->updated_at;
$notam->updated_at = date('Y-m-d H:i:s', $currentUpdatedAt->getTimestamp() + 1);
$notam->saveQuietly(['timestamps' => false]);
}
} else {
echo "Notam {$notam->id} has no Text property\n";
}
}
}
}