57 lines
3.5 KiB
PHP
57 lines
3.5 KiB
PHP
<?php
|
|
|
|
namespace App\Console\Commands;
|
|
|
|
use Illuminate\Console\Command;
|
|
use Illuminate\Support\Facades\Cache;
|
|
use Illuminate\Support\Facades\DB;
|
|
use Illuminate\Support\Str;
|
|
|
|
/** Category and pin metadata only; article bodies/categories are published through the editorial API. */
|
|
final class OrganizeTutorials extends Command
|
|
{
|
|
protected $signature = 'tutorials:organize {--apply : Save the category name and pin its configured articles}';
|
|
|
|
protected $description = 'Rename the beginner category and pin its verified entry articles, with a private metadata backup';
|
|
|
|
public function handle(): int
|
|
{
|
|
$category = DB::table('categories')->where('sSlug', config('tutorials.beginner_slug'))->where('iStatus', 1)->first();
|
|
$slugs = array_values(array_unique(config('tutorials.pinned_slugs', [config('tutorials.guide_slug')])));
|
|
$articles = DB::table('articles')->whereIn('sSlug', $slugs)->where('iStatus', 1)->get();
|
|
if (! $category || ! $slugs || $articles->count() !== count($slugs)
|
|
|| $articles->contains(fn ($article) => (int) $article->iCategoryId !== (int) $category->id)) {
|
|
$this->error('Publish every configured entry article in the beginner category before applying metadata.');
|
|
return self::FAILURE;
|
|
}
|
|
$this->line(json_encode(['category' => $category->sSlug, 'name' => config('tutorials.beginner_name'), 'articles' => $slugs, 'pinned' => true], JSON_UNESCAPED_UNICODE));
|
|
if (! $this->option('apply')) return self::SUCCESS;
|
|
$backup = storage_path('app/private/editorial/tutorial-metadata-'.Str::uuid().'.json');
|
|
$snapshot = ['category_id' => $category->id, 'sName' => $category->sName,
|
|
'articles' => $articles->map(fn ($article) => ['id' => $article->id, 'sSlug' => $article->sSlug, 'iIsTop' => $article->iIsTop])->all()];
|
|
$json = json_encode($snapshot, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_THROW_ON_ERROR);
|
|
if (file_put_contents($backup, $json, LOCK_EX) !== strlen($json) || ! chmod($backup, 0600)) {
|
|
throw new \RuntimeException('Unable to save the private metadata backup.');
|
|
}
|
|
DB::transaction(function () use ($category, $articles) {
|
|
$currentCategory = DB::table('categories')->where('id', $category->id)->lockForUpdate()->first();
|
|
if (! $currentCategory || $currentCategory->sName !== $category->sName || ! $currentCategory->iStatus) {
|
|
throw new \RuntimeException('Tutorial category changed; inspect before retrying.');
|
|
}
|
|
foreach ($articles as $article) {
|
|
$current = DB::table('articles')->where('id', $article->id)->lockForUpdate()->first();
|
|
if (! $current || (int) $current->iCategoryId !== (int) $category->id || ! $current->iStatus
|
|
|| $current->sSlug !== $article->sSlug || (int) $current->iIsTop !== (int) $article->iIsTop) {
|
|
throw new \RuntimeException('Tutorial metadata changed; inspect before retrying.');
|
|
}
|
|
DB::table('articles')->where('id', $article->id)->update(['iIsTop' => 1]);
|
|
}
|
|
DB::table('categories')->where('id', $category->id)->update(['sName' => config('tutorials.beginner_name')]);
|
|
});
|
|
Cache::forget('global_nav_tree');
|
|
\Spatie\ResponseCache\Facades\ResponseCache::clear();
|
|
$this->info('Category name saved and configured entry articles pinned. Private backup: '.$backup);
|
|
return self::SUCCESS;
|
|
}
|
|
}
|