🎯 Blog AI Cron - Kapsamlı Final Plan

Model: SettingGroup::class
Tablo: settings_groups (Central DB)
Connection: CentralConnection trait
Örnek: "Blog - Yapay Zeka" (ID: 18)

Kolonlar:
- id
- parent_id
- name (JSON: tr, en, ar)
- slug
- description (JSON)
- icon
- layout (JSON: tabs, fields, order)

Model: Setting::class
Tablo: settings (Central DB)
Connection: CentralConnection trait

Kolonlar:
- id
- group_id
- label (JSON: tr, en, ar)
- key (unique)
- type (text, number, checkbox, select, textarea)
- default_value
- options (JSON - select için)

Örnek Ayarlar:
• blog_ai_enabled (checkbox)
• blog_ai_daily_count (select: 1-8)
• blog_ai_auto_publish (checkbox)

Model: SettingValue::class
Tablo: settings_values (Tenant DB)
Connection: Tenant connection (dynamic)

Kolonlar:
- id
- setting_id (Central setting'e referans)
- value (actual value)

Örnek Data:
• setting_id=130, value=1 (blog_ai_enabled=true)
• setting_id=131, value=4 (blog_ai_daily_count=4)
• setting_id=132, value=1 (blog_ai_auto_publish=true)

Setting Key: blog_ai_daily_count
Label: "Günlük Blog Sayısı"
Type: select
Options: [1, 2, 3, 4, 5, 6, 8]
Default: 4
Description: "Her gün kaç blog yazısı üretilsin?
• SEO Optimal: 4 blog/gün (120/ay)
• Maksimum Güvenli: 8 blog/gün (240/ay)"

// app/helpers.php veya app/Helpers/setting_helpers.php if (!function_exists('getTenantSetting')) { /** * Tenant-aware setting değeri çek * * @param string $key Setting key (blog_ai_enabled) * @param mixed $default Varsayılan değer * @return mixed */ function getTenantSetting(string $key, $default = null) { // Cache key $cacheKey = "setting_{$key}_tenant_" . tenant('id'); return Cache::remember($cacheKey, 3600, function () use ($key, $default) { // Setting tanımını al (Central DB) $setting = \Modules\SettingManagement\App\Models\Setting::where('key', $key)->first(); if (!$setting) { return $default; } // Setting value'yu al (Tenant DB) $settingValue = \Modules\SettingManagement\App\Models\SettingValue::on('tenant') ->where('setting_id', $setting->id) ->first(); if ($settingValue && $settingValue->value !== null) { return $settingValue->value; } return $setting->default_value ?? $default; }); } }

// app/Helpers/blog_helpers.php if (!function_exists('calculateActiveHours')) { /** * Günlük blog sayısına göre aktif saatleri hesapla * * @param int $dailyCount 1-8 arası * @return array Aktif saatler [0, 6, 12, 18] */ function calculateActiveHours(int $dailyCount): array { // Özel dağılımlar (optimize edilmiş) $schedules = [ 1 => [0], 2 => [0, 12], 3 => [0, 8, 16], 4 => [0, 6, 12, 18], 5 => [0, 5, 10, 15, 20], 6 => [0, 4, 8, 12, 16, 20], 8 => [0, 3, 6, 9, 12, 15, 18, 21], ]; return $schedules[$dailyCount] ?? [0]; } }

hour; // 0-23 $this->info("🚀 Cron Started - Hour: {$currentHour}"); // Tüm tenant'ları al (cache'den) $tenants = Cache::remember('blog_cron_tenant_list', 3600, function () { return \Stancl\Tenancy\Models\Tenant::all(); }); $processedCount = 0; foreach ($tenants as $tenant) { try { // Tenant context'e geç tenancy()->initialize($tenant); // Settings kontrol $enabled = getTenantSetting('blog_ai_enabled', false); if (!$enabled) { $this->line("⏭️ Tenant {$tenant->id}: Disabled"); continue; } // Daily count al $dailyCount = getTenantSetting('blog_ai_daily_count', 4); // Aktif saatleri hesapla (cache'den) $cacheKey = "blog_cron_schedule_tenant_{$tenant->id}"; $schedule = Cache::remember($cacheKey, 86400, function () use ($dailyCount) { return calculateActiveHours($dailyCount); }); // Şimdiki saat schedule'da var mı? if (!in_array($currentHour, $schedule)) { $this->line("⏭️ Tenant {$tenant->id}: Not scheduled for this hour"); continue; } // Blog üret! $this->generateBlog($tenant); $processedCount++; } catch (\Exception $e) { $this->error("❌ Tenant {$tenant->id}: {$e->getMessage()}"); } finally { tenancy()->end(); } } $this->info("✅ Completed: {$processedCount} blogs generated"); return self::SUCCESS; } private function generateBlog($tenant) { // Draft sayısını kontrol et $availableDrafts = BlogAIDraft::where('is_generated', false)->count(); if ($availableDrafts === 0) { // Önce draft üret GenerateDraftsJob::dispatch(self::DRAFT_REGENERATION_COUNT) ->onQueue('blog-ai'); $this->warn("⚠️ Tenant {$tenant->id}: No drafts, generating first"); return; } // Rastgele draft seç $selectedDraft = BlogAIDraft::where('is_generated', false) ->inRandomOrder() ->lockForUpdate() ->first(); if (!$selectedDraft) { $this->error("❌ Tenant {$tenant->id}: Could not select draft"); return; } // Auto-publish ayarı $autoPublish = getTenantSetting('blog_ai_auto_publish', true); // Blog generation job GenerateBlogFromDraftJob::dispatch($selectedDraft->draft_id, $autoPublish) ->onQueue('blog-ai'); $this->info("✅ Tenant {$tenant->id}: Blog job dispatched (Draft #{$selectedDraft->draft_id})"); // Draft havuzu kontrolü $remainingDrafts = $availableDrafts - 1; if ($remainingDrafts <= self::MINIMUM_DRAFT_THRESHOLD) { GenerateDraftsJob::dispatch(self::DRAFT_REGENERATION_COUNT) ->onQueue('blog-ai'); $this->warn("⚠️ Tenant {$tenant->id}: Low draft pool, regenerating"); } } }

protected function schedule(Schedule $schedule) { // Blog Auto Generation - Her saat başı $schedule->command('generate:tenant-blogs') ->hourly() // 00:00, 01:00, 02:00, ..., 23:00 ->withoutOverlapping(10) // Max 10 dakika çalışabilir ->runInBackground() ->appendOutputTo(storage_path('logs/blog-cron.log')) ->onSuccess(function () { \Log::channel('daily')->info('🎉 Blog Cron: Success'); }) ->onFailure(function () { \Log::channel('daily')->error('❌ Blog Cron: Failed'); }); }

// Modules/Blog/app/Jobs/GenerateBlogFromDraftJob.php public function __construct( public int $draftId, public bool $autoPublish = true // YENİ PARAMETRE ) {} public function handle() { // ... blog üretim logic ... // Status belirleme $status = $this->autoPublish ? 'published' : 'draft'; Blog::create([ 'title' => $title, 'body' => $body, 'status' => $status, // Auto-publish ayarına göre // ... diğer alanlar ]); }