'.$e($greet).' '.$e($m['prenom'].' '.$m['nom']).',
'.$e($txt).'
'.$e($orig).'
'.$origHtml.'
';
// Текстовая версия
$text = $greet.' '.($m['prenom'].' '.$m['nom']).","."\n\n".
$txt."\n\n".
"-----------------------\n".$orig."\n".$m['message']."\n";
// Отправка
[$ok,$errSend] = admin_send_reply($to, $subj, $html, $text);
// Записываем статус "repondu" в любом случае (как раньше)
$stU = $pdo->prepare("UPDATE contact_messages
SET statut='repondu', reponse=?, replied_by=?, replied_at=NOW()
WHERE id=?");
$stU->execute([$txt, (int)($_SESSION['compte_id'] ?? 0), $id]);
if (function_exists('log_admin_action')) {
log_admin_action(
$pdo,
(int)($_SESSION['compte_id'] ?? 0),
'contact_reply',
json_encode(['id'=>$id,'email'=>$to,'sent'=>(bool)$ok,'error'=>$errSend], JSON_UNESCAPED_UNICODE)
);
}
// Возврат к списку (без id)
header('Location: ?page=afficher_messages&flash=1');
return;
}
}
}
elseif ($action === 'delete') {
$id = (int)($_POST['id'] ?? 0);
if ($id > 0) {
$del = $pdo->prepare("DELETE FROM contact_messages WHERE id=?");
$del->execute([$id]);
if (function_exists('log_admin_action')) {
log_admin_action($pdo, (int)($_SESSION['compte_id'] ?? 0), 'contact_delete',
json_encode(['id'=>$id,'deleted'=>$del->rowCount()>0], JSON_UNESCAPED_UNICODE));
}
header('Location: ?page=afficher_messages&deleted=1'); return;
} else {
$err = $translations['contactad_err_invalid_id'] ?? 'ID invalide';
}
}
}
// Открытое сообщение?
$msg = null;
if (isset($_GET['id'])) {
$id = (int)$_GET['id'];
$st = $pdo->prepare("SELECT * FROM contact_messages WHERE id=? LIMIT 1");
$st->execute([$id]);
$msg = $st->fetch(PDO::FETCH_ASSOC);
if ($msg && $msg['statut'] === 'nouveau') {
$pdo->prepare("UPDATE contact_messages SET statut='lu' WHERE id=?")->execute([$id]);
$msg['statut'] = 'lu';
}
}
// Список (пагинация)
$page = max(1, (int)($_GET['p'] ?? 1));
$per = 25; $off = ($page - 1) * $per;
$total = (int)$pdo->query("SELECT COUNT(*) FROM contact_messages")->fetchColumn();
$rows = $pdo->query("SELECT id, nom, prenom, email, sujet, statut, created_at
FROM contact_messages
ORDER BY id DESC
LIMIT $per OFFSET $off")->fetchAll(PDO::FETCH_ASSOC);
$pages = max(1, (int)ceil($total / $per));
?>