HockeyCMS-SHOP/admin/email_templates.php

<?php
// Αρχείο: /var/www/html/hockey-cms/admin/email_templates.php
require_once 'admin_auth.php';
require_once '../config/database.php';

if (!isset($_SESSION['user_id']) or $_SESSION['role_id'] != 1) {
    header("Location: ../index.php");
    exit;
}

// --- Μηχανισμός Αλλαγής Γλώσσας ---
if (isset($_GET['lang']) && in_array($_GET['lang'], ['el', 'en'])) {
    $_SESSION['lang'] = $_GET['lang'];
}
$current_lang = $_SESSION['lang'] ?? 'el';

$translations = [
    'el' => [
        'page_title' => 'Πρότυπα Email - Hockey CMS',
        'header_title' => 'Διαχείριση Προτύπων Email',
        'info_vars' => '<strong>Διαθέσιμες μεταβλητές (Placeholders):</strong> Μπορείτε να χρησιμοποιήσετε τα παρακάτω μέσα στα θέματα και στα κείμενα, τα οποία θα αντικαθίστανται αυτόματα:<br>',
        'order_id_hint' => '(Κωδικός Παραγγελίας)',
        'customer_name_hint' => '(Όνομα Πελάτη)',
        'total_amount_hint' => '(Συνολικό Ποσό)',
        'status_hint' => '(Κατάσταση Παραγγελίας)',
        'subj_el' => 'Θέμα Email (Ελληνικά - EL)',
        'subj_en' => 'Θέμα Email (English - EN)',
        'body_el' => 'Κείμενο / Σώμα Email (Ελληνικά - EL)',
        'body_en' => 'Κείμενο / Σώμα Email (English - EN)',
        'btn_save' => '💾 Αποθήκευση Όλων των Προτύπων',
        'msg_ok' => 'Τα πρότυπα email αποθηκεύτηκαν επιτυχώς!',
        'msg_err' => 'Σφάλμα αποθήκευσης: '
    ],
    'en' => [
        'page_title' => 'Email Templates - Hockey CMS',
        'header_title' => 'Email Templates Management',
        'info_vars' => '<strong>Available variables (Placeholders):</strong> You can use the following in subjects and bodies, which will be replaced automatically:<br>',
        'order_id_hint' => '(Order ID)',
        'customer_name_hint' => '(Customer Name)',
        'total_amount_hint' => '(Total Amount)',
        'status_hint' => '(Order Status)',
        'subj_el' => 'Email Subject (Greek - EL)',
        'subj_en' => 'Email Subject (English - EN)',
        'body_el' => 'Email Body (Greek - EL)',
        'body_en' => 'Email Body (English - EN)',
        'btn_save' => '💾 Save All Templates',
        'msg_ok' => 'Email templates saved successfully!',
        'msg_err' => 'Save Error: '
    ]
];
$t = $translations[$current_lang];

header('Content-Type: text/html; charset=utf-8');
$message = '';

// --- ΑΠΟΘΗΚΕΥΣΗ ΠΡΟΤΥΠΩΝ ---
if ($_SERVER['REQUEST_METHOD'] === 'POST' and isset($_POST['action']) and $_POST['action'] == 'save_templates') {
    try {
        $pdo->beginTransaction();
        foreach ($_POST['templates'] as $id => $data) {
            $stmt = $pdo->prepare("UPDATE email_templates SET subject_el = ?, subject_en = ?, body_el = ?, body_en = ? WHERE id = ?");
            $stmt->execute([
                trim($data['subject_el']),
                trim($data['subject_en']),
                trim($data['body_el']),
                trim($data['body_en']),
                (int)$id
            ]);
        }
        $pdo->commit();
        $message = "<div class='alert success'>{$t['msg_ok']}</div>";
    } catch (Exception $e) {
        $pdo->rollBack();
        $message = "<div class='alert error'>{$t['msg_err']}" . $e->getMessage() . "</div>";
    }
}

// Ανάγνωση προτύπων από τη βάση
$templates = $pdo->query("SELECT * FROM email_templates ORDER BY id ASC")->fetchAll(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="<?php echo $current_lang; ?>">
<head>
    <meta charset="UTF-8">
    <title><?php echo $t['page_title']; ?></title>
    <link href="https://fonts.googleapis.com/css2?family=Inter:wght@400;500;600;700;800&display=swap" rel="stylesheet">
    <style>
        :root {
            --primary: #f97316;
            --primary-hover: #ea580c;
            --bg-color: #0b1120;
            --panel-bg: #1e293b;
            --border-color: #334155;
            --text-main: #f8fafc;
            --text-muted: #94a3b8;
        }
        body { font-family: 'Inter', sans-serif; background-color: var(--bg-color); color: var(--text-main); margin: 0; }
        .content { margin-left: 250px; padding: 30px; }
        .content h2 { margin-top: 0; color: var(--primary); font-size: 26px; text-transform: uppercase; letter-spacing: 0.5px; }
        
        .card { background: var(--panel-bg); padding: 25px; border-radius: 8px; box-shadow: 0 4px 6px -1px rgba(0,0,0,0.3); border: 1px solid var(--border-color); margin-bottom: 25px; }
        .card h3 { margin-top: 0; color: var(--text-main); border-bottom: 1px solid rgba(255,255,255,0.05); padding-bottom: 15px; font-size: 18px; text-transform: uppercase; letter-spacing: 0.5px; display: flex; justify-content: space-between; align-items: center;}
        
        .form-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 20px; }
        .form-group { margin-bottom: 20px; }
        .form-group label { display: block; margin-bottom: 8px; font-weight: 700; font-size: 13px; color: var(--text-muted); text-transform: uppercase; letter-spacing: 0.5px;}
        .form-group input, .form-group textarea { width: 100%; padding: 12px; background: #0f172a; border: 1px solid var(--border-color); color: var(--text-main); border-radius: 6px; box-sizing: border-box; font-family: 'Inter', sans-serif; outline: none; transition: 0.2s; font-size: 14px;}
        .form-group input:focus, .form-group textarea:focus { border-color: var(--primary); box-shadow: 0 0 0 2px rgba(249, 115, 22, 0.2); }
        
        .btn { padding: 12px 25px; background: var(--primary); color: white; border: none; border-radius: 6px; cursor: pointer; font-weight: 800; font-size: 14px; text-transform: uppercase; transition: 0.2s; }
        .btn:hover { background: var(--primary-hover); transform: translateY(-1px); }
        
        .alert { padding: 15px; border-radius: 6px; margin-bottom: 20px; font-weight: 600; font-size: 14px;}
        .success { background: rgba(16, 185, 129, 0.1); color: #10b981; border: 1px solid rgba(16, 185, 129, 0.2); }
        .error { background: rgba(239, 68, 68, 0.1); color: #ef4444; border: 1px solid rgba(239, 68, 68, 0.2); }
        
        .info-box { background: rgba(59, 130, 246, 0.1); border-left: 4px solid #3b82f6; padding: 15px; border-radius: 4px; font-size: 13px; color: #60a5fa; margin-bottom: 20px; line-height: 1.5; }
        .info-box code { background: rgba(0,0,0,0.3); padding: 2px 6px; border-radius: 4px; color: #f8fafc; font-family: monospace; border: 1px solid var(--border-color);}
        
        .badge-key { background: rgba(0,0,0,0.3); color: var(--text-muted); padding: 4px 10px; border-radius: 12px; font-size: 11px; font-family: monospace; border: 1px solid var(--border-color); text-transform: none; letter-spacing: 0;}
    </style>
</head>
<body>
    
    <?php include 'sidebar.php'; ?>

    <div class="content">
        <h2><?php echo $t['header_title']; ?></h2>
        <?php echo $message; ?>

        <div class="info-box">
            <?php echo $t['info_vars']; ?>
            <code>{order_id}</code> <?php echo $t['order_id_hint']; ?>, 
            <code>{customer_name}</code> <?php echo $t['customer_name_hint']; ?>, 
            <code>{total_amount}</code> <?php echo $t['total_amount_hint']; ?>, 
            <code>{status}</code> <?php echo $t['status_hint']; ?>
        </div>

        <form method="POST" action="email_templates.php">
            <input type="hidden" name="action" value="save_templates">

            <?php foreach ($templates as $tpl): ?>
                <div class="card">
                    <h3>
                        <span><?php echo htmlspecialchars($tpl['name']); ?></span>
                        <span class="badge-key"><?php echo htmlspecialchars($tpl['template_key']); ?></span>
                    </h3>

                    <div class="form-grid">
                        <div class="form-group">
                            <label><?php echo $t['subj_el']; ?></label>
                            <input type="text" name="templates[<?php echo $tpl['id']; ?>][subject_el]" value="<?php echo htmlspecialchars($tpl['subject_el']); ?>" required>
                        </div>
                        <div class="form-group">
                            <label><?php echo $t['subj_en']; ?></label>
                            <input type="text" name="templates[<?php echo $tpl['id']; ?>][subject_en]" value="<?php echo htmlspecialchars($tpl['subject_en']); ?>" required>
                        </div>
                    </div>

                    <div class="form-grid">
                        <div class="form-group">
                            <label><?php echo $t['body_el']; ?></label>
                            <textarea name="templates[<?php echo $tpl['id']; ?>][body_el]" rows="6" required><?php echo htmlspecialchars($tpl['body_el']); ?></textarea>
                        </div>
                        <div class="form-group">
                            <label><?php echo $t['body_en']; ?></label>
                            <textarea name="templates[<?php echo $tpl['id']; ?>][body_en]" rows="6" required><?php echo htmlspecialchars($tpl['body_en']); ?></textarea>
                        </div>
                    </div>
                </div>
            <?php endforeach; ?>

            <button type="submit" class="btn"><?php echo $t['btn_save']; ?></button>
        </form>
    </div>
</body>
</html>