PNG  IHDR* pHYs+ IDATx]n#; cdLb Ǚ[at¤_:uP}>!Usă cag޿ ֵNu`ݼTâabO7uL&y^wFٝA"l[|ŲHLN밪4*sG3|Dv}?+y߉{OuOAt4Jj.u]Gz*҉sP'VQKbA1u\`& Af;HWj hsO;ogTu uj7S3/QzUr&wS`M$X_L7r2;aE+ώ%vikDA:dR+%KzƉo>eOth$z%: :{WwaQ:wz%4foɹE[9<]#ERINƻv溂E%P1i01 |Jvҗ&{b?9g=^wζXn/lK::90KwrюO\!ջ3uzuGv^;騢wq<Iatv09:tt~hEG`v;3@MNZD.1]L:{ծI3`L(÷ba")Y.iljCɄae#I"1 `3*Bdz>j<fU40⨬%O$3cGt]j%Fߠ_twJ;ABU8vP3uEԑwQ V:h%))LfraqX-ۿX]v-\9I gl8tzX ]ecm)-cgʒ#Uw=Wlێn(0hPP/ӨtQ“&J35 $=]r1{tLuǮ*i0_;NƝ8;-vݏr8+U-kruȕYr0RnC]*ެ(M:]gE;{]tg(#ZJ9y>utRDRMdr9㪩̞zֹb<ģ&wzJM"iI( .ꮅX)Qw:9,i좜\Ԛi7&N0:asϓc];=ΗOӣ APqz93 y $)A*kVHZwBƺnWNaby>XMN*45~ղM6Nvm;A=jֲ.~1}(9`KJ/V F9[=`~[;sRuk]rєT!)iQO)Y$V ی ۤmzWz5IM Zb )ˆC`6 rRa}qNmUfDsWuˤV{ Pݝ'=Kֳbg,UҘVz2ﴻnjNgBb{? ߮tcsͻQuxVCIY۠:(V뺕 ٥2;t`@Fo{Z9`;]wMzU~%UA蛚dI vGq\r82iu +St`cR.6U/M9IENDB`view = new View(); $this->db = Database::getInstance(); if (!isset($_SESSION['admin_id'])) { Helper::redirect(Helper::url('/admin/login')); } } public function index() { $status = $_GET['status'] ?? 'all'; $where = ''; $params = []; if ($status !== 'all') { $where = 'WHERE status = ?'; $params[] = $status; } $messages = $this->db->fetchAll( "SELECT * FROM contact_messages $where ORDER BY created_at DESC", $params ); // İstatistikler $stats = [ 'all' => $this->db->fetchOne("SELECT COUNT(*) as total FROM contact_messages")['total'], 'new' => $this->db->fetchOne("SELECT COUNT(*) as total FROM contact_messages WHERE status = 'new'")['total'], 'read' => $this->db->fetchOne("SELECT COUNT(*) as total FROM contact_messages WHERE status = 'read'")['total'], 'replied' => $this->db->fetchOne("SELECT COUNT(*) as total FROM contact_messages WHERE status = 'replied'")['total'], ]; $this->view->set('page_title', 'Mesaj Yönetimi'); $this->view->set('messages', $messages); $this->view->set('stats', $stats); $this->view->set('current_status', $status); require_once APP_PATH . '/app/views/admin/messages/index.php'; } public function view($id) { $message = $this->db->fetchOne("SELECT * FROM contact_messages WHERE id = ?", [$id]); if (!$message) { $_SESSION['error'] = 'Mesaj bulunamadı!'; Helper::redirect(Helper::url('/admin/messages')); } // Mesajı okundu olarak işaretle if ($message['status'] === 'new') { $this->db->update('contact_messages', ['status' => 'read'], 'id = ?', [$id]); $message['status'] = 'read'; // Güncellenmiş durumu göster } $this->view->set('page_title', 'Mesaj Detayı'); $this->view->set('message', $message); require_once APP_PATH . '/app/views/admin/messages/view.php'; } public function delete($id) { $this->db->delete('contact_messages', 'id = ?', [$id]); $_SESSION['success'] = 'Mesaj başarıyla silindi!'; Helper::redirect(Helper::url('/admin/messages')); } public function updateStatus($id) { $status = $_GET['status'] ?? 'read'; if (!in_array($status, ['new', 'read', 'replied'])) { $status = 'read'; } $this->db->update('contact_messages', ['status' => $status], 'id = ?', [$id]); $_SESSION['success'] = 'Mesaj durumu güncellendi!'; Helper::redirect(Helper::url('/admin/messages')); } }