db = Database::getInstance(); } public function index() { header('Content-Type: application/xml; charset=utf-8'); // Dinamik base URL oluştur (HTTP/HTTPS otomatik tespit) $baseUrl = Helper::getBaseUrl(); $currentDate = date('Y-m-d'); // Statik sayfalar $staticPages = [ ['url' => '', 'priority' => '1.0', 'changefreq' => 'daily'], ['url' => '/hizmetler', 'priority' => '0.9', 'changefreq' => 'weekly'], ['url' => '/hakkimizda', 'priority' => '0.8', 'changefreq' => 'monthly'], ['url' => '/fiyat-listesi', 'priority' => '0.8', 'changefreq' => 'weekly'], ['url' => '/sirket-bilgileri', 'priority' => '0.7', 'changefreq' => 'monthly'], ['url' => '/iletisim', 'priority' => '0.7', 'changefreq' => 'monthly'], ['url' => '/iletisim/servis-formu', 'priority' => '0.8', 'changefreq' => 'monthly'], ['url' => '/iletisim/fiyat-teklifi', 'priority' => '0.8', 'changefreq' => 'monthly'], ['url' => '/cozum-merkezi', 'priority' => '0.8', 'changefreq' => 'weekly'], ['url' => '/cerez-politikasi', 'priority' => '0.5', 'changefreq' => 'yearly'], ['url' => '/gizlilik-politikasi', 'priority' => '0.5', 'changefreq' => 'yearly'], ['url' => '/hizmet-sozlesmesi', 'priority' => '0.5', 'changefreq' => 'yearly'], ['url' => '/kullanim-kosullari', 'priority' => '0.5', 'changefreq' => 'yearly'], ['url' => '/kvkk-aydinlatma-metni', 'priority' => '0.5', 'changefreq' => 'yearly'], ['url' => '/mesafeli-satis-sozlesmesi', 'priority' => '0.5', 'changefreq' => 'yearly'], ]; // Aktif hizmetler $services = $this->db->fetchAll( "SELECT slug, updated_at FROM services WHERE status = 'active' ORDER BY sort_order ASC" ); echo '' . "\n"; echo '' . "\n"; // Statik sayfalar foreach ($staticPages as $page) { $lastmod = $currentDate; echo " \n"; echo " " . htmlspecialchars($baseUrl . $page['url']) . "\n"; echo " " . $lastmod . "\n"; echo " " . $page['changefreq'] . "\n"; echo " " . $page['priority'] . "\n"; echo " \n"; } // Hizmet sayfaları foreach ($services as $service) { $lastmod = !empty($service['updated_at']) ? date('Y-m-d', strtotime($service['updated_at'])) : $currentDate; echo " \n"; echo " " . htmlspecialchars($baseUrl . '/hizmetler/' . $service['slug']) . "\n"; echo " " . $lastmod . "\n"; echo " weekly\n"; echo " 0.8\n"; echo " \n"; } // Arıza çözümleri yazıları $posts = $this->db->fetchAll( "SELECT slug, device_type, brand, updated_at FROM posts WHERE status = 'published' ORDER BY created_at DESC" ); foreach ($posts as $post) { $lastmod = !empty($post['updated_at']) ? date('Y-m-d', strtotime($post['updated_at'])) : $currentDate; // URL oluştur $url = '/cozum-merkezi'; if (!empty($post['device_type'])) { $url .= '/' . Helper::slug($post['device_type']); if (!empty($post['brand'])) { $url .= '/' . Helper::slug($post['brand']); } } $url .= '/' . $post['slug']; echo " \n"; echo " " . htmlspecialchars($baseUrl . $url) . "\n"; echo " " . $lastmod . "\n"; echo " monthly\n"; echo " 0.7\n"; echo " \n"; } echo ''; exit; } }