{
    "exported_at": "2026-06-30 14:55:47",
    "app": {
        "name": "OtoBonus Takip Paneli",
        "version": "0.1.0"
    },
    "project": {
        "id": 1,
        "project_name": "OtoBonus Sistemi",
        "project_key": "otobonus",
        "description": "Oyuncu, site sahibi ve root panellerinden oluşan; Playwright bot, n8n, Telegram ve MySQL/PHP altyapılı oto bonus otomasyon projesi.",
        "version": "0.1",
        "status": "planning",
        "created_at": "2026-06-30 11:31:27",
        "updated_at": null
    },
    "roles": [
        {
            "id": 1,
            "project_id": 1,
            "role_name": "Oyuncu / Son Kullanıcı",
            "role_key": "player",
            "description": "Bonus alacak kişi. Sadece uygun bonusları görür, seçer ve talep eder.",
            "permissions": "Bonus modeli oluşturamaz. Bonus ayarı değiştiremez. Sadece kendi işlem sonucunu takip eder.",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 2,
            "project_id": 1,
            "role_name": "Site Sahibi",
            "role_key": "site_owner",
            "description": "OtoBonus sistemini kendi sitesine entegre eden müşteri.",
            "permissions": "Hazır bonusları sitesine aktif eder. Limitleri düzenler. Bonus model talebi gönderir. Raporları ve bildirimleri takip eder.",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 3,
            "project_id": 1,
            "role_name": "Root / Sistem Sahibi",
            "role_key": "root",
            "description": "Tüm yazılımı yöneten ana yetkili taraf.",
            "permissions": "Tüm site sahiplerini, siteleri, bonus modellerini, bot loglarını, manuel işlemleri, n8n ve Telegram akışlarını yönetir.",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        }
    ],
    "decisions": [
        {
            "id": 1,
            "project_id": 1,
            "title": "Ana tablo prefix kararı",
            "decision_text": "Ana OtoBonus yazılımında tablo ön eki oto_bonus_v1_ şeklinde kullanılacak.",
            "category": "database",
            "status": "active",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 2,
            "project_id": 1,
            "title": "Takip paneli bağımsız olacak",
            "decision_text": "OtoBonus Takip Paneli ana sistemden bağımsız, geçici ve kolay silinebilir PHP/MySQL mini panel olacak.",
            "category": "tracker",
            "status": "active",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 3,
            "project_id": 1,
            "title": "Bot teknolojisi",
            "decision_text": "Admin panel otomasyonu için Node.js Playwright kullanılacak.",
            "category": "bot",
            "status": "active",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 4,
            "project_id": 1,
            "title": "n8n kullanımı",
            "decision_text": "n8n; Telegram bildirimleri, hata akışları, günlük raporlar ve gerektiğinde AI destekli yardımcı kararlar için kullanılacak.",
            "category": "automation",
            "status": "active",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 5,
            "project_id": 1,
            "title": "Bonus modeli ayrımı",
            "decision_text": "Oyuncular bonus modeli talep edemez. Site sahipleri Bonus Model Talebi gönderebilir. Root uygun görürse sisteme bonus modeli ekler.",
            "category": "bonus",
            "status": "active",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 6,
            "project_id": 1,
            "title": "Platform rol ayrımı",
            "decision_text": "Oyuncu, Site Sahibi ve Root rolleri birbirinden net şekilde ayrıldı.",
            "category": "auth",
            "status": "active",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        }
    ],
    "modules": [
        {
            "id": 1,
            "project_id": 1,
            "module_name": "Proje Planlama",
            "module_key": "planning",
            "description": "Roller, teknik kararlar, güvenlik sınırları ve geliştirme yol haritası.",
            "status": "todo",
            "sort_order": 1,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 2,
            "project_id": 1,
            "module_name": "Ana Dosya/Dizin Altyapısı",
            "module_key": "filesystem",
            "description": "PHP proje iskeleti, router, config, database ve public asset yapısı.",
            "status": "todo",
            "sort_order": 2,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 3,
            "project_id": 1,
            "module_name": "Veritabanı Tasarımı",
            "module_key": "database",
            "description": "oto_bonus_v1_ prefixli ana SQL mimarisi.",
            "status": "todo",
            "sort_order": 3,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 4,
            "project_id": 1,
            "module_name": "Root Panel",
            "module_key": "root_panel",
            "description": "Ana yönetici paneli.",
            "status": "todo",
            "sort_order": 4,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 5,
            "project_id": 1,
            "module_name": "Site Sahibi Paneli",
            "module_key": "site_owner_panel",
            "description": "Müşteri/site sahibi paneli.",
            "status": "todo",
            "sort_order": 5,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 6,
            "project_id": 1,
            "module_name": "Oyuncu Paneli",
            "module_key": "player_panel",
            "description": "Bonus talep edecek son kullanıcı paneli.",
            "status": "todo",
            "sort_order": 6,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 7,
            "project_id": 1,
            "module_name": "Bonus Motoru",
            "module_key": "bonus_engine",
            "description": "Bonus uygunluk, limit, çevrim, kayıp, yatırım ve freespin hesaplama motoru.",
            "status": "todo",
            "sort_order": 7,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 8,
            "project_id": 1,
            "module_name": "Bot Otomasyon Sistemi",
            "module_key": "bot_automation",
            "description": "Playwright worker, TOTP, admin panel login ve bonus ekleme otomasyonu.",
            "status": "todo",
            "sort_order": 8,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 9,
            "project_id": 1,
            "module_name": "Farklı Admin Panel Profilleri",
            "module_key": "bot_profiles",
            "description": "Farklı admin paneller için selector ve otomasyon profilleri.",
            "status": "todo",
            "sort_order": 9,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 10,
            "project_id": 1,
            "module_name": "n8n / Telegram Bildirimleri",
            "module_key": "notifications",
            "description": "n8n webhook, Telegram ve rapor bildirimleri.",
            "status": "todo",
            "sort_order": 10,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 11,
            "project_id": 1,
            "module_name": "Güvenlik",
            "module_key": "security",
            "description": "Credential encryption, TOTP secret encryption, audit log ve yetki kontrolleri.",
            "status": "todo",
            "sort_order": 11,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 12,
            "project_id": 1,
            "module_name": "Test Süreci",
            "module_key": "testing",
            "description": "Demo site, demo oyuncu, bot login, hata ve bonus ekleme testleri.",
            "status": "todo",
            "sort_order": 12,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 13,
            "project_id": 1,
            "module_name": "Yayına Hazırlık",
            "module_key": "deployment",
            "description": "Production config, cron/worker, backup ve log politikası.",
            "status": "todo",
            "sort_order": 13,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 14,
            "project_id": 1,
            "module_name": "Dokümantasyon",
            "module_key": "documentation",
            "description": "Kurulum, kullanım ve teknik notlar.",
            "status": "todo",
            "sort_order": 14,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        }
    ],
    "tasks": [
        {
            "id": 1,
            "project_id": 1,
            "module_id": 1,
            "title": "Platform rollerini netleştir",
            "description": "Oyuncu, Site Sahibi ve Root yetkilerini ayrı ayrı tanımla.",
            "priority": "high",
            "status": "todo",
            "sort_order": 1,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "planning",
            "module_name": "Proje Planlama"
        },
        {
            "id": 2,
            "project_id": 1,
            "module_id": 1,
            "title": "Ana tablo prefix kararını kaydet",
            "description": "Ana sistem için oto_bonus_v1_ prefix kararı takip paneline işlendi.",
            "priority": "normal",
            "status": "todo",
            "sort_order": 2,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "planning",
            "module_name": "Proje Planlama"
        },
        {
            "id": 3,
            "project_id": 1,
            "module_id": 2,
            "title": "PHP proje dizin yapısını oluştur",
            "description": "Ana sistemin public, config, core, modules, workers ve storage yapısını kur.",
            "priority": "high",
            "status": "todo",
            "sort_order": 3,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "filesystem",
            "module_name": "Ana Dosya/Dizin Altyapısı"
        },
        {
            "id": 4,
            "project_id": 1,
            "module_id": 3,
            "title": "Ana SQL tablolarını oluştur",
            "description": "oto_bonus_v1_ prefixli tablo mimarisini oluştur.",
            "priority": "critical",
            "status": "todo",
            "sort_order": 4,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "database",
            "module_name": "Veritabanı Tasarımı"
        },
        {
            "id": 5,
            "project_id": 1,
            "module_id": 4,
            "title": "Root dashboard oluştur",
            "description": "Genel sistem durumu, aktif siteler, bot işleri ve hatalar görüntülensin.",
            "priority": "high",
            "status": "todo",
            "sort_order": 5,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "root_panel",
            "module_name": "Root Panel"
        },
        {
            "id": 6,
            "project_id": 1,
            "module_id": 4,
            "title": "Bonus modelleri yönetimi",
            "description": "Root yeni bonus modeli oluşturabilsin ve düzenleyebilsin.",
            "priority": "high",
            "status": "todo",
            "sort_order": 6,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "root_panel",
            "module_name": "Root Panel"
        },
        {
            "id": 7,
            "project_id": 1,
            "module_id": 5,
            "title": "Bonus Model Talebi ekranı",
            "description": "Site sahipleri yeni bonus fikri/talebi gönderebilsin.",
            "priority": "high",
            "status": "todo",
            "sort_order": 7,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "site_owner_panel",
            "module_name": "Site Sahibi Paneli"
        },
        {
            "id": 8,
            "project_id": 1,
            "module_id": 5,
            "title": "Aktif bonus ayarları",
            "description": "Site sahibi kendi sitesinde aktif bonusların limitlerini düzenleyebilsin.",
            "priority": "high",
            "status": "todo",
            "sort_order": 8,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "site_owner_panel",
            "module_name": "Site Sahibi Paneli"
        },
        {
            "id": 9,
            "project_id": 1,
            "module_id": 6,
            "title": "Oyuncu bonus listeleme",
            "description": "Oyuncuya uygun bonuslar aktif, uygun olmayanlar pasif gösterilsin.",
            "priority": "critical",
            "status": "todo",
            "sort_order": 9,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "player_panel",
            "module_name": "Oyuncu Paneli"
        },
        {
            "id": 10,
            "project_id": 1,
            "module_id": 7,
            "title": "Bonus uygunluk servisi",
            "description": "Snapshot verisine göre uygunluk sonucu ve nedenleri üret.",
            "priority": "critical",
            "status": "todo",
            "sort_order": 10,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "bonus_engine",
            "module_name": "Bonus Motoru"
        },
        {
            "id": 11,
            "project_id": 1,
            "module_id": 7,
            "title": "Kayıp bonusu kuralı",
            "description": "İlk bonus kuralı olarak kayıp bonusu hesaplamasını yaz.",
            "priority": "high",
            "status": "todo",
            "sort_order": 11,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "bonus_engine",
            "module_name": "Bonus Motoru"
        },
        {
            "id": 12,
            "project_id": 1,
            "module_id": 7,
            "title": "Freespin bonusu kuralı",
            "description": "Freespin bonus modelini ve uygunluk şartlarını ekle.",
            "priority": "normal",
            "status": "todo",
            "sort_order": 12,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "bonus_engine",
            "module_name": "Bonus Motoru"
        },
        {
            "id": 13,
            "project_id": 1,
            "module_id": 8,
            "title": "Node.js Playwright worker kurulumu",
            "description": "MySQL kuyruktan job okuyup admin panelde işlem yapacak worker yaz.",
            "priority": "critical",
            "status": "todo",
            "sort_order": 13,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "bot_automation",
            "module_name": "Bot Otomasyon Sistemi"
        },
        {
            "id": 14,
            "project_id": 1,
            "module_id": 8,
            "title": "Google Authenticator/TOTP desteği",
            "description": "Yetkili TOTP secret ile 6 haneli kod üretip giriş yap.",
            "priority": "critical",
            "status": "todo",
            "sort_order": 14,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "bot_automation",
            "module_name": "Bot Otomasyon Sistemi"
        },
        {
            "id": 15,
            "project_id": 1,
            "module_id": 9,
            "title": "Varsayılan panel profili",
            "description": "Login, arama ve bonus ekleme selector alanları tanımlansın.",
            "priority": "high",
            "status": "todo",
            "sort_order": 15,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "bot_profiles",
            "module_name": "Farklı Admin Panel Profilleri"
        },
        {
            "id": 16,
            "project_id": 1,
            "module_id": 10,
            "title": "n8n webhook yapısı",
            "description": "Başarılı/hatalı işlemleri n8n webhook ile dışarı aktar.",
            "priority": "normal",
            "status": "todo",
            "sort_order": 16,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "notifications",
            "module_name": "n8n / Telegram Bildirimleri"
        },
        {
            "id": 17,
            "project_id": 1,
            "module_id": 10,
            "title": "Telegram bildirimleri",
            "description": "Root ve site sahibine işlem bildirimleri gönder.",
            "priority": "normal",
            "status": "todo",
            "sort_order": 17,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "notifications",
            "module_name": "n8n / Telegram Bildirimleri"
        },
        {
            "id": 18,
            "project_id": 1,
            "module_id": 11,
            "title": "Credential şifreleme",
            "description": "Admin panel şifreleri ve TOTP secret değerleri şifreli saklansın.",
            "priority": "critical",
            "status": "todo",
            "sort_order": 18,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "security",
            "module_name": "Güvenlik"
        },
        {
            "id": 19,
            "project_id": 1,
            "module_id": 12,
            "title": "Demo site ve demo oyuncu oluştur",
            "description": "İlk uçtan uca test için demo kayıtları hazırla.",
            "priority": "high",
            "status": "todo",
            "sort_order": 19,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "testing",
            "module_name": "Test Süreci"
        },
        {
            "id": 20,
            "project_id": 1,
            "module_id": 13,
            "title": "Worker servisleştirme",
            "description": "Node worker cron/supervisor/systemd ile canlıda çalışacak hale gelsin.",
            "priority": "normal",
            "status": "todo",
            "sort_order": 20,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "deployment",
            "module_name": "Yayına Hazırlık"
        },
        {
            "id": 21,
            "project_id": 1,
            "module_id": 14,
            "title": "Teknik kurulum dokümanı",
            "description": "Kurulum, tablo yapısı, bot ve panel kullanım notlarını yaz.",
            "priority": "normal",
            "status": "todo",
            "sort_order": 21,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "documentation",
            "module_name": "Dokümantasyon"
        }
    ],
    "completed_tasks": [],
    "pending_tasks": [
        {
            "id": 1,
            "project_id": 1,
            "module_id": 1,
            "title": "Platform rollerini netleştir",
            "description": "Oyuncu, Site Sahibi ve Root yetkilerini ayrı ayrı tanımla.",
            "priority": "high",
            "status": "todo",
            "sort_order": 1,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "planning",
            "module_name": "Proje Planlama"
        },
        {
            "id": 2,
            "project_id": 1,
            "module_id": 1,
            "title": "Ana tablo prefix kararını kaydet",
            "description": "Ana sistem için oto_bonus_v1_ prefix kararı takip paneline işlendi.",
            "priority": "normal",
            "status": "todo",
            "sort_order": 2,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "planning",
            "module_name": "Proje Planlama"
        },
        {
            "id": 3,
            "project_id": 1,
            "module_id": 2,
            "title": "PHP proje dizin yapısını oluştur",
            "description": "Ana sistemin public, config, core, modules, workers ve storage yapısını kur.",
            "priority": "high",
            "status": "todo",
            "sort_order": 3,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "filesystem",
            "module_name": "Ana Dosya/Dizin Altyapısı"
        },
        {
            "id": 4,
            "project_id": 1,
            "module_id": 3,
            "title": "Ana SQL tablolarını oluştur",
            "description": "oto_bonus_v1_ prefixli tablo mimarisini oluştur.",
            "priority": "critical",
            "status": "todo",
            "sort_order": 4,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "database",
            "module_name": "Veritabanı Tasarımı"
        },
        {
            "id": 5,
            "project_id": 1,
            "module_id": 4,
            "title": "Root dashboard oluştur",
            "description": "Genel sistem durumu, aktif siteler, bot işleri ve hatalar görüntülensin.",
            "priority": "high",
            "status": "todo",
            "sort_order": 5,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "root_panel",
            "module_name": "Root Panel"
        },
        {
            "id": 6,
            "project_id": 1,
            "module_id": 4,
            "title": "Bonus modelleri yönetimi",
            "description": "Root yeni bonus modeli oluşturabilsin ve düzenleyebilsin.",
            "priority": "high",
            "status": "todo",
            "sort_order": 6,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "root_panel",
            "module_name": "Root Panel"
        },
        {
            "id": 7,
            "project_id": 1,
            "module_id": 5,
            "title": "Bonus Model Talebi ekranı",
            "description": "Site sahipleri yeni bonus fikri/talebi gönderebilsin.",
            "priority": "high",
            "status": "todo",
            "sort_order": 7,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "site_owner_panel",
            "module_name": "Site Sahibi Paneli"
        },
        {
            "id": 8,
            "project_id": 1,
            "module_id": 5,
            "title": "Aktif bonus ayarları",
            "description": "Site sahibi kendi sitesinde aktif bonusların limitlerini düzenleyebilsin.",
            "priority": "high",
            "status": "todo",
            "sort_order": 8,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "site_owner_panel",
            "module_name": "Site Sahibi Paneli"
        },
        {
            "id": 9,
            "project_id": 1,
            "module_id": 6,
            "title": "Oyuncu bonus listeleme",
            "description": "Oyuncuya uygun bonuslar aktif, uygun olmayanlar pasif gösterilsin.",
            "priority": "critical",
            "status": "todo",
            "sort_order": 9,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "player_panel",
            "module_name": "Oyuncu Paneli"
        },
        {
            "id": 10,
            "project_id": 1,
            "module_id": 7,
            "title": "Bonus uygunluk servisi",
            "description": "Snapshot verisine göre uygunluk sonucu ve nedenleri üret.",
            "priority": "critical",
            "status": "todo",
            "sort_order": 10,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "bonus_engine",
            "module_name": "Bonus Motoru"
        },
        {
            "id": 11,
            "project_id": 1,
            "module_id": 7,
            "title": "Kayıp bonusu kuralı",
            "description": "İlk bonus kuralı olarak kayıp bonusu hesaplamasını yaz.",
            "priority": "high",
            "status": "todo",
            "sort_order": 11,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "bonus_engine",
            "module_name": "Bonus Motoru"
        },
        {
            "id": 12,
            "project_id": 1,
            "module_id": 7,
            "title": "Freespin bonusu kuralı",
            "description": "Freespin bonus modelini ve uygunluk şartlarını ekle.",
            "priority": "normal",
            "status": "todo",
            "sort_order": 12,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "bonus_engine",
            "module_name": "Bonus Motoru"
        },
        {
            "id": 13,
            "project_id": 1,
            "module_id": 8,
            "title": "Node.js Playwright worker kurulumu",
            "description": "MySQL kuyruktan job okuyup admin panelde işlem yapacak worker yaz.",
            "priority": "critical",
            "status": "todo",
            "sort_order": 13,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "bot_automation",
            "module_name": "Bot Otomasyon Sistemi"
        },
        {
            "id": 14,
            "project_id": 1,
            "module_id": 8,
            "title": "Google Authenticator/TOTP desteği",
            "description": "Yetkili TOTP secret ile 6 haneli kod üretip giriş yap.",
            "priority": "critical",
            "status": "todo",
            "sort_order": 14,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "bot_automation",
            "module_name": "Bot Otomasyon Sistemi"
        },
        {
            "id": 15,
            "project_id": 1,
            "module_id": 9,
            "title": "Varsayılan panel profili",
            "description": "Login, arama ve bonus ekleme selector alanları tanımlansın.",
            "priority": "high",
            "status": "todo",
            "sort_order": 15,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "bot_profiles",
            "module_name": "Farklı Admin Panel Profilleri"
        },
        {
            "id": 16,
            "project_id": 1,
            "module_id": 10,
            "title": "n8n webhook yapısı",
            "description": "Başarılı/hatalı işlemleri n8n webhook ile dışarı aktar.",
            "priority": "normal",
            "status": "todo",
            "sort_order": 16,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "notifications",
            "module_name": "n8n / Telegram Bildirimleri"
        },
        {
            "id": 17,
            "project_id": 1,
            "module_id": 10,
            "title": "Telegram bildirimleri",
            "description": "Root ve site sahibine işlem bildirimleri gönder.",
            "priority": "normal",
            "status": "todo",
            "sort_order": 17,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "notifications",
            "module_name": "n8n / Telegram Bildirimleri"
        },
        {
            "id": 18,
            "project_id": 1,
            "module_id": 11,
            "title": "Credential şifreleme",
            "description": "Admin panel şifreleri ve TOTP secret değerleri şifreli saklansın.",
            "priority": "critical",
            "status": "todo",
            "sort_order": 18,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "security",
            "module_name": "Güvenlik"
        },
        {
            "id": 19,
            "project_id": 1,
            "module_id": 12,
            "title": "Demo site ve demo oyuncu oluştur",
            "description": "İlk uçtan uca test için demo kayıtları hazırla.",
            "priority": "high",
            "status": "todo",
            "sort_order": 19,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "testing",
            "module_name": "Test Süreci"
        },
        {
            "id": 20,
            "project_id": 1,
            "module_id": 13,
            "title": "Worker servisleştirme",
            "description": "Node worker cron/supervisor/systemd ile canlıda çalışacak hale gelsin.",
            "priority": "normal",
            "status": "todo",
            "sort_order": 20,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "deployment",
            "module_name": "Yayına Hazırlık"
        },
        {
            "id": 21,
            "project_id": 1,
            "module_id": 14,
            "title": "Teknik kurulum dokümanı",
            "description": "Kurulum, tablo yapısı, bot ve panel kullanım notlarını yaz.",
            "priority": "normal",
            "status": "todo",
            "sort_order": 21,
            "completed_at": null,
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null,
            "module_key": "documentation",
            "module_name": "Dokümantasyon"
        }
    ],
    "database_tables": [
        {
            "id": 1,
            "project_id": 1,
            "table_name": "oto_bonus_v1_players",
            "purpose": "Oyuncu / bonus alacak son kullanıcı kayıtları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 2,
            "project_id": 1,
            "table_name": "oto_bonus_v1_site_owners",
            "purpose": "Site sahipleri / müşteri hesapları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 3,
            "project_id": 1,
            "table_name": "oto_bonus_v1_sites",
            "purpose": "OtoBonus sistemine bağlı siteler.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 4,
            "project_id": 1,
            "table_name": "oto_bonus_v1_site_credentials",
            "purpose": "Admin panel giriş bilgileri ve TOTP secret kayıtları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 5,
            "project_id": 1,
            "table_name": "oto_bonus_v1_bonus_models",
            "purpose": "Root tarafından oluşturulan global bonus modelleri.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 6,
            "project_id": 1,
            "table_name": "oto_bonus_v1_bonus_model_fields",
            "purpose": "Bonus modellerine bağlı dinamik ayar alanları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 7,
            "project_id": 1,
            "table_name": "oto_bonus_v1_site_bonus_settings",
            "purpose": "Siteye özel aktif bonus ayarları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 8,
            "project_id": 1,
            "table_name": "oto_bonus_v1_bonus_requests",
            "purpose": "Oyuncuların oluşturduğu bonus talepleri.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 9,
            "project_id": 1,
            "table_name": "oto_bonus_v1_bonus_model_requests",
            "purpose": "Site sahiplerinin root tarafına gönderdiği bonus model talepleri.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 10,
            "project_id": 1,
            "table_name": "oto_bonus_v1_bot_profiles",
            "purpose": "Farklı admin panel otomasyon profilleri.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 11,
            "project_id": 1,
            "table_name": "oto_bonus_v1_bot_jobs",
            "purpose": "Bot işlem kuyruğu.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 12,
            "project_id": 1,
            "table_name": "oto_bonus_v1_bot_logs",
            "purpose": "Bot işlem logları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 13,
            "project_id": 1,
            "table_name": "oto_bonus_v1_bot_screenshots",
            "purpose": "Bot ekran görüntüsü kayıtları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 14,
            "project_id": 1,
            "table_name": "oto_bonus_v1_user_snapshots",
            "purpose": "Botun admin panelden okuduğu oyuncu verisi snapshot kayıtları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 15,
            "project_id": 1,
            "table_name": "oto_bonus_v1_notifications",
            "purpose": "n8n/Telegram bildirim kayıtları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 16,
            "project_id": 1,
            "table_name": "oto_bonus_v1_audit_logs",
            "purpose": "Root, site sahibi ve sistem hareket kayıtları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        }
    ],
    "database_columns": [],
    "file_structure": [
        {
            "id": 18,
            "project_id": 1,
            "path": "/bot-node/sites/defaultPanelBot.js",
            "item_type": "file",
            "purpose": "Varsayılan admin panel profili.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 17,
            "project_id": 1,
            "path": "/bot-node/worker.js",
            "item_type": "file",
            "purpose": "Node.js Playwright ana worker.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 3,
            "project_id": 1,
            "path": "/config/app.php",
            "item_type": "file",
            "purpose": "Ana uygulama ayarları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 4,
            "project_id": 1,
            "path": "/config/database.php",
            "item_type": "file",
            "purpose": "Database bağlantı ayarları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 5,
            "project_id": 1,
            "path": "/config/encryption.php",
            "item_type": "file",
            "purpose": "Credential encryption ayarları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 8,
            "project_id": 1,
            "path": "/core/Auth.php",
            "item_type": "file",
            "purpose": "Rol bazlı auth yapısı.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 7,
            "project_id": 1,
            "path": "/core/Controller.php",
            "item_type": "file",
            "purpose": "Ana controller sınıfı.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 6,
            "project_id": 1,
            "path": "/core/Router.php",
            "item_type": "file",
            "purpose": "Router sınıfı.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 1,
            "project_id": 1,
            "path": "/public/index.php",
            "item_type": "file",
            "purpose": "Ana giriş dosyası.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 14,
            "project_id": 1,
            "path": "/workers/bot_worker.php",
            "item_type": "file",
            "purpose": "PHP tarafı worker tetikleyici.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 12,
            "project_id": 1,
            "path": "/modules/bonus/",
            "item_type": "directory",
            "purpose": "Bonus motoru servisleri.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 13,
            "project_id": 1,
            "path": "/modules/bot/",
            "item_type": "directory",
            "purpose": "PHP bot job/result servisleri.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 11,
            "project_id": 1,
            "path": "/modules/player/",
            "item_type": "directory",
            "purpose": "Oyuncu panel modülü.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 9,
            "project_id": 1,
            "path": "/modules/root/",
            "item_type": "directory",
            "purpose": "Root panel modülü.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 10,
            "project_id": 1,
            "path": "/modules/site-owner/",
            "item_type": "directory",
            "purpose": "Site sahibi panel modülü.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 2,
            "project_id": 1,
            "path": "/public/assets/",
            "item_type": "directory",
            "purpose": "CSS, JS, görsel dosyaları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 15,
            "project_id": 1,
            "path": "/storage/logs/",
            "item_type": "directory",
            "purpose": "Log kayıtları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        },
        {
            "id": 16,
            "project_id": 1,
            "path": "/storage/screenshots/",
            "item_type": "directory",
            "purpose": "Bot screenshot kayıtları.",
            "status": "planned",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        }
    ],
    "notes": [
        {
            "id": 1,
            "project_id": 1,
            "title": "İlk mimari notu",
            "note_text": "Bu takip paneli ana OtoBonus yazılımı tamamlanana kadar proje hafızası olarak kullanılacak. JSON export çıktısı daha sonra ChatGPT’ye verilerek proje kaldığı yerden aktarılabilecek.",
            "category": "general",
            "created_at": "2026-06-30 11:31:27",
            "updated_at": null
        }
    ]
}