Diff -- /var/www/vhosts/3dshawn.com/shop.3dshawn.com/admin_emails.cgi

O Operator
Diff

/var/www/vhosts/3dshawn.com/shop.3dshawn.com/admin_emails.cgi

added on local at 2026-07-11 18:36:20

Added
+1058
lines
Removed
-0
lines
Context
0
unchanged
Blobs
from
to ec4b400cd7e7
Restore this content →
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.
1#!/usr/bin/perl
2#======================================================================
3# ShopCart -- /admin_emails.cgi (Email Setup)
4#
5# Consolidates the former trio via SCRIPT_NAME dispatch:
6# admin_emails.cgi -- Templates tab (default)
7# admin_email_controls.cgi -- Controls tab (spam-protection knobs)
8# admin_email_schedules.cgi -- Schedules tab
9#
10# Super-admin only across all tabs.
11#======================================================================
12use strict;
13use warnings;
14
15use lib '/var/www/vhosts/3dshawn.com/shop.3dshawn.com';
16use CGI;
17use MODS::DBConnect;
18use MODS::ShopCart::Wrapper;
19use MODS::ShopCart::Config;
20use MODS::Login;
21use MODS::ShopCart::Mailer;
22
23my $q = CGI->new;
24my $form = $q->Vars;
25my $wrap = MODS::ShopCart::Wrapper->new;
26my $db = MODS::DBConnect->new;
27my $cfg = MODS::ShopCart::Config->new;
28my $DB = $cfg->settings('database_name');
29
30my $auth = MODS::Login->new;
31my $u = $auth->login_verify;
32unless ($u) { print "Status: 302 Found\nLocation: /login.cgi\n\n"; exit; }
33require MODS::ShopCart::Permissions;
34MODS::ShopCart::Permissions->new->require_super_admin($u);
35my $uid = $u->{user_id} + 0;
36
37my $entry = ($ENV{SCRIPT_NAME} || '') =~ m{/([^/]+)\.cgi$} ? $1 : 'admin_emails';
38
39if ($entry eq 'admin_email_controls') { _emx_controls(); exit; }
40elsif ($entry eq 'admin_email_schedules') { _emx_schedules(); exit; }
41else { _emx_templates(); exit; }
42
43#======================================================================
44# Templates tab (formerly admin_emails.cgi)
45#======================================================================
46sub _emx_templates {
47 my $dbh = $db->db_connect;
48 my $act = $form->{act} || '';
49 my $flash = '';
50
51 # ---- POST handlers --------------------------------------------------
52 if (($ENV{REQUEST_METHOD} || '') eq 'POST') {
53 if ($act eq 'save') {
54 my $tid = ($form->{template_id} || 0) + 0;
55 my $name = substr($form->{name} || '', 0, 160); $name =~ s/'/''/g;
56 my $subj = substr($form->{subject} || '', 0, 255); $subj =~ s/'/''/g;
57 my $body = substr($form->{body_html} || '', 0, 65000); $body =~ s/'/''/g;
58 my $cat = $form->{category} || 'lifecycle';
59 $cat = 'lifecycle' unless $cat =~ /^(transactional|lifecycle|product|marketing)$/;
60 my $active = $form->{is_active} ? 1 : 0;
61 $db->db_readwrite($dbh, qq~
62 UPDATE ${DB}.email_templates
63 SET name='$name', subject='$subj', body_html='$body',
64 category='$cat', is_active='$active',
65 updated_by_user_id='$uid'
66 WHERE id='$tid'
67 ~, $0, __LINE__);
68 $flash = 'Saved.';
69 }
70 elsif ($act eq 'send_test') {
71 my $slug = $form->{slug} || '';
72 $slug =~ s/[^a-z0-9_-]//g;
73 my $to = $form->{test_to} || $u->{email} || '';
74 my $mailer = MODS::ShopCart::Mailer->new;
75 my %sample = (
76 display_name => $u->{display_name} || 'Test User',
77 first_name => (split /\s+/, ($u->{display_name} || 'Test'))[0],
78 company_name => $u->{company_name} || 'Test Workspace',
79 trial_ends_at => '2026-07-04 09:00:00',
80 days_left => 7,
81 inviter_name => 'You',
82 inviter_email => $u->{email} || '',
83 accept_url => 'https://shop.3dshawn.com/accept_invite.cgi?token=SAMPLE',
84 reset_url => 'https://shop.3dshawn.com/reset_password.cgi?t=SAMPLE',
85 );
86 my $ok = $mailer->send_template(
87 slug => $slug,
88 user_id => $uid,
89 to => $to,
90 vars => \%sample,
91 );
92 $flash = $ok ? "Test sent to $to." : "Test failed -- check _mail.log and email_sends_log.";
93 }
94 }
95
96 # ---- GET (list or edit) ---------------------------------------------
97 my $edit_slug = $form->{edit} || '';
98 $edit_slug =~ s/[^a-z0-9_-]//g;
99
100 my @templates = $db->db_readwrite_multiple($dbh, qq~
101 SELECT t.id, t.slug, t.category, t.name, t.subject, t.body_html,
102 t.is_system, t.is_active, t.updated_at,
103 (SELECT COUNT(*) FROM ${DB}.email_schedules WHERE template_id=t.id AND is_active=1) AS sched_count
104 FROM ${DB}.email_templates t
105 ORDER BY t.category, t.slug
106 ~, $0, __LINE__);
107
108 my @recent_sends = $db->db_readwrite_multiple($dbh, qq~
109 SELECT id, user_id, template_slug, to_email, subject, status, failure_reason, created_at,
110 UNIX_TIMESTAMP(created_at) AS created_at_epoch
111 FROM ${DB}.email_sends_log ORDER BY id DESC LIMIT 20
112 ~, $0, __LINE__);
113
114 $db->db_disconnect($dbh);
115
116 print "Content-Type: text/html; charset=utf-8\r\nCache-Control: no-store\r\n\r\n";
117
118 my $body;
119 my $flash_html = $flash ? qq~<div style="padding:10px 14px;background:rgba(34,197,94,.12);border:1px solid rgba(34,197,94,.3);border-radius:8px;color:#86efac;font-size:13px;margin-bottom:18px">$flash</div>~ : '';
120
121 if ($edit_slug) {
122 my ($t) = grep { $_->{slug} eq $edit_slug } @templates;
123 if ($t) {
124 my $name = _emx_h($t->{name});
125 my $subj = _emx_h($t->{subject});
126 my $body_h = _emx_h($t->{body_html});
127 my $cat = $t->{category};
128 my $checked = $t->{is_active} ? 'checked' : '';
129 my $is_sys = $t->{is_system} ? '<span style="font-size:11px;padding:2px 8px;border-radius:4px;background:rgba(139,92,246,.18);color:#c4b5fd;margin-left:8px">SYSTEM</span>' : '';
130 my @opts;
131 foreach my $k (qw(transactional lifecycle product marketing)) {
132 my $sel = ($k eq $cat) ? ' selected' : '';
133 push @opts, qq~<option value="$k"$sel>$k</option>~;
134 }
135 my $opt_html = join('', @opts);
136 my $tabs = _emx_setup_tabs('templates');
137 $body = qq~
138<div class="page-pad">
139 <h1 style="margin:0 0 6px;font-size:28px;color:#fff">Email Setup</h1>
140 <p style="color:#94a3b8;margin:0 0 18px;font-size:14px">Templates, schedules, and spam-protection controls.</p>
141 $tabs
142 <a href="/admin_emails.cgi" style="color:#94a3b8;font-size:13px;text-decoration:none">&larr; All templates</a>
143 <h2 style="margin:8px 0 6px;font-size:22px;color:#fff">Edit: $name $is_sys</h2>
144 <p style="color:#94a3b8;margin:0 0 24px;font-size:14px"><code style="color:#c4b5fd">$t->{slug}</code> &middot; category <strong>$cat</strong></p>
145 $flash_html
146 <form method="POST" action="/admin_emails.cgi" style="display:grid;grid-template-columns:1fr 280px;gap:24px">
147 <div>
148 <input type="hidden" name="act" value="save">
149 <input type="hidden" name="template_id" value="$t->{id}">
150 <label style="display:block;font-size:12px;text-transform:uppercase;letter-spacing:.05em;color:#cbd5e1;margin-bottom:6px">Name</label>
151 <input class="input" type="text" name="name" value="$name" maxlength="160" style="width:100%;margin-bottom:14px">
152 <label style="display:block;font-size:12px;text-transform:uppercase;letter-spacing:.05em;color:#cbd5e1;margin-bottom:6px">Category</label>
153 <select class="select" name="category" style="width:100%;margin-bottom:14px">$opt_html</select>
154 <label style="display:block;font-size:12px;text-transform:uppercase;letter-spacing:.05em;color:#cbd5e1;margin-bottom:6px">Subject</label>
155 <input class="input" type="text" name="subject" value="$subj" maxlength="255" style="width:100%;margin-bottom:14px">
156 <label style="display:block;font-size:12px;text-transform:uppercase;letter-spacing:.05em;color:#cbd5e1;margin-bottom:6px">Body</label>
157 <div class="wyse" id="wyse" style="margin-bottom:14px">
158 <div class="wyse-toolbar">
159 <button type="button" class="wbtn" data-cmd="bold" title="Bold (Ctrl+B)"><b>B</b></button>
160 <button type="button" class="wbtn" data-cmd="italic" title="Italic (Ctrl+I)"><i>I</i></button>
161 <button type="button" class="wbtn" data-cmd="underline" title="Underline"><u>U</u></button>
162 <button type="button" class="wbtn" data-cmd="strikeThrough" title="Strikethrough"><s>S</s></button>
163 <span class="wsep"></span>
164 <button type="button" class="wbtn wbtn-text" data-block="h1" title="Heading 1">H1</button>
165 <button type="button" class="wbtn wbtn-text" data-block="h2" title="Heading 2">H2</button>
166 <button type="button" class="wbtn wbtn-text" data-block="h3" title="Heading 3">H3</button>
167 <button type="button" class="wbtn wbtn-text" data-block="p" title="Paragraph">P</button>
168 <span class="wsep"></span>
169 <button type="button" class="wbtn" data-cmd="insertUnorderedList" title="Bulleted list">&bull;</button>
170 <button type="button" class="wbtn" data-cmd="insertOrderedList" title="Numbered list">1.</button>
171 <button type="button" class="wbtn wbtn-text" data-block="blockquote" title="Block quote">&ldquo;</button>
172 <button type="button" class="wbtn wbtn-text" data-action="code" title="Inline code">&lt;/&gt;</button>
173 <span class="wsep"></span>
174 <button type="button" class="wbtn wbtn-text" data-action="link" title="Insert link">Link</button>
175 <button type="button" class="wbtn" data-cmd="unlink" title="Remove link">&#128279;</button>
176 <button type="button" class="wbtn wbtn-text" data-cmd="insertHorizontalRule" title="Insert horizontal rule">&mdash;</button>
177 <span class="wsep"></span>
178 <select class="wsel" id="wyse-var" title="Insert a template variable at the cursor">
179 <option value="">+ Variable</option>
180 <option value="{{display_name}}">display_name</option>
181 <option value="{{first_name}}">first_name</option>
182 <option value="{{company_name}}">company_name</option>
183 <option value="{{trial_ends_at}}">trial_ends_at</option>
184 <option value="{{days_left}}">days_left</option>
185 <option value="{{billing_url}}">billing_url</option>
186 <option value="{{dashboard_url}}">dashboard_url</option>
187 <option value="{{unsubscribe_url}}">unsubscribe_url</option>
188 <option value="{{inviter_name}}">inviter_name</option>
189 <option value="{{inviter_email}}">inviter_email</option>
190 <option value="{{accept_url}}">accept_url</option>
191 <option value="{{reset_url}}">reset_url</option>
192 </select>
193 <span class="wsep" style="margin-left:auto"></span>
194 <button type="button" class="wbtn wbtn-text wbtn-preview" id="wyse-preview" title="Preview the email with sample values substituted">Preview &#9654;</button>
195 <button type="button" class="wbtn wbtn-text wbtn-mode" id="wyse-mode" title="Toggle between rendered HTML and raw source">Source &#8644;</button>
196 </div>
197 <div class="wyse-rendered" id="wyse-rendered" contenteditable="true" spellcheck="true"></div>
198 <textarea class="wyse-source" id="wyse-source" style="display:none">$body_h</textarea>
199 </div>
200 <input type="hidden" name="body_html" id="wyse-hidden">
201 <div class="wprev-backdrop" id="wprev-backdrop" role="dialog" aria-modal="true">
202 <div class="wprev-modal">
203 <div class="wprev-head">
204 <div class="wprev-title">Preview &middot; sample values substituted</div>
205 <button type="button" class="wprev-close" id="wprev-close">Close</button>
206 </div>
207 <div class="wprev-meta">
208 <div class="wprev-from">From: ShopCart &lt;noreply\@shop.3dshawn.com&gt; &middot; To: shawn\@example.com</div>
209 <div class="wprev-subject" id="wprev-subject"></div>
210 </div>
211 <div class="wprev-body" id="wprev-body"></div>
212 </div>
213 </div>
214 <style>
215 .wyse { border:1px solid rgba(255,255,255,.10); border-radius:10px; overflow:hidden; background:#0f1420; }
216 .wyse-toolbar { display:flex; flex-wrap:wrap; gap:2px; padding:8px 10px; background:#171b2a; border-bottom:1px solid rgba(255,255,255,.10); align-items:center; }
217 .wyse .wbtn { background:transparent; border:1px solid transparent; color:#cbd5e1; font-size:13px; min-width:32px; height:30px; padding:0 8px; border-radius:6px; cursor:pointer; display:inline-flex; align-items:center; justify-content:center; line-height:1; font-family:inherit; }
218 .wyse .wbtn:hover { background:rgba(255,255,255,.06); color:#fff; }
219 .wyse .wbtn.is-active { background:rgba(90,169,255,.20); color:#bfdbff; border-color:rgba(90,169,255,.35); }
220 .wyse .wbtn-text { font-size:12px; font-weight:600; }
221 .wyse .wsep { width:1px; height:18px; background:rgba(255,255,255,.10); margin:0 6px; }
222 .wyse .wsel { background:#0f1420; color:#cbd5e1; border:1px solid rgba(255,255,255,.12); border-radius:6px; padding:5px 8px; font-size:12px; cursor:pointer; height:30px; }
223 .wyse .wbtn-mode { background:rgba(139,92,246,.15); color:#c4b5fd; border-color:rgba(139,92,246,.30); }
224 .wyse .wbtn-mode:hover { background:rgba(139,92,246,.25); }
225 .wyse .wbtn-preview { background:rgba(34,197,94,.14); color:#86efac; border-color:rgba(34,197,94,.30); }
226 .wyse .wbtn-preview:hover { background:rgba(34,197,94,.24); }
227 .wprev-backdrop { position:fixed; inset:0; background:rgba(0,0,0,.65); z-index:9000; display:none; align-items:flex-start; justify-content:center; padding:40px 16px; overflow:auto; }
228 .wprev-backdrop.is-open { display:flex; }
229 .wprev-modal { background:#0b0f1a; color:#e2e8f0; max-width:720px; width:100%; border:1px solid rgba(255,255,255,.10); border-radius:14px; overflow:hidden; box-shadow:0 20px 60px rgba(0,0,0,.5); }
230 .wprev-head { display:flex; align-items:center; padding:14px 20px; border-bottom:1px solid rgba(255,255,255,.10); background:#171b2a; gap:14px; }
231 .wprev-head .wprev-title { font-size:12px; text-transform:uppercase; letter-spacing:.06em; color:#94a3b8; font-weight:600; }
232 .wprev-head .wprev-close { margin-left:auto; background:transparent; border:1px solid rgba(255,255,255,.12); color:#cbd5e1; padding:6px 14px; border-radius:6px; cursor:pointer; font-size:13px; }
233 .wprev-head .wprev-close:hover { background:rgba(255,255,255,.06); }
234 .wprev-meta { padding:12px 20px; font-size:12px; color:#94a3b8; border-bottom:1px solid rgba(255,255,255,.05); background:rgba(20,20,30,.3); }
235 .wprev-meta .wprev-from { color:#cbd5e1; font-weight:500; }
236 .wprev-meta .wprev-subject { color:#f1f5f9; font-weight:700; font-size:15px; margin-top:6px; }
237 .wprev-body { padding:24px 28px; line-height:1.65; font-size:14px; max-height:60vh; overflow:auto; }
238 .wprev-body p { margin:.6em 0; }
239 .wprev-body h1 { font-size:22px; margin:.4em 0 .3em; color:#f1f5f9; }
240 .wprev-body h2 { font-size:18px; margin:.5em 0 .3em; color:#f1f5f9; }
241 .wprev-body h3 { font-size:16px; margin:.5em 0 .3em; color:#f1f5f9; }
242 .wprev-body ul, .wprev-body ol { padding-left:1.6em; margin:.5em 0; }
243 .wprev-body a { color:#5aa9ff; text-decoration:underline; }
244 .wprev-body code { background:rgba(255,255,255,.06); padding:1px 6px; border-radius:4px; font-family:ui-monospace,Consolas,Menlo,monospace; font-size:12.5px; }
245 .wprev-body blockquote { border-left:3px solid rgba(255,255,255,.20); margin:.8em 0; padding:.2em 1em; color:#cbd5e1; }
246 .wprev-body hr { border:0; border-top:1px solid rgba(255,255,255,.15); margin:1em 0; }
247 .wyse-rendered { min-height:380px; padding:16px 20px; color:#e2e8f0; font-size:14px; line-height:1.6; outline:none; background:#0b0f1a; }
248 .wyse-rendered:focus { background:#0b0f1a; }
249 .wyse-rendered h1 { font-size:22px; margin:.4em 0 .3em; color:#f1f5f9; }
250 .wyse-rendered h2 { font-size:18px; margin:.5em 0 .3em; color:#f1f5f9; }
251 .wyse-rendered h3 { font-size:16px; margin:.5em 0 .3em; color:#f1f5f9; }
252 .wyse-rendered p { margin:.5em 0; }
253 .wyse-rendered ul, .wyse-rendered ol { padding-left:1.6em; margin:.5em 0; }
254 .wyse-rendered a { color:#5aa9ff; text-decoration:underline; }
255 .wyse-rendered code { background:rgba(255,255,255,.06); padding:1px 6px; border-radius:4px; font-family:ui-monospace,Consolas,Menlo,monospace; font-size:12.5px; }
256 .wyse-rendered blockquote { border-left:3px solid rgba(255,255,255,.20); margin:.8em 0; padding:.2em 1em; color:#cbd5e1; }
257 .wyse-rendered hr { border:0; border-top:1px solid rgba(255,255,255,.15); margin:1em 0; }
258 .wyse-source { width:100%; min-height:380px; padding:14px 18px; background:#070a13; color:#cbd5e1; border:0; outline:none; font-family:ui-monospace,Consolas,Menlo,monospace; font-size:12.5px; resize:vertical; box-sizing:border-box; }
259 </style>
260 <script>
261 (function () {
262 var root = document.getElementById('wyse');
263 var rendered= document.getElementById('wyse-rendered');
264 var source = document.getElementById('wyse-source');
265 var hidden = document.getElementById('wyse-hidden');
266 var modeBtn = document.getElementById('wyse-mode');
267 var varSel = document.getElementById('wyse-var');
268 if (!root || !rendered || !source) return;
269
270 var mode = 'rendered';
271
272 rendered.innerHTML = source.value;
273 hidden.value = source.value;
274
275 function syncHidden() {
276 if (mode === 'rendered') {
277 source.value = rendered.innerHTML;
278 } else {
279 rendered.innerHTML = source.value;
280 }
281 hidden.value = source.value;
282 }
283
284 root.querySelectorAll('.wbtn[data-cmd]').forEach(function (b) {
285 b.addEventListener('click', function (ev) {
286 ev.preventDefault();
287 if (mode !== 'rendered') return;
288 rendered.focus();
289 document.execCommand(b.getAttribute('data-cmd'), false, null);
290 syncHidden();
291 });
292 });
293
294 root.querySelectorAll('.wbtn[data-block]').forEach(function (b) {
295 b.addEventListener('click', function (ev) {
296 ev.preventDefault();
297 if (mode !== 'rendered') return;
298 rendered.focus();
299 document.execCommand('formatBlock', false, b.getAttribute('data-block'));
300 syncHidden();
301 });
302 });
303
304 root.querySelectorAll('.wbtn[data-action]').forEach(function (b) {
305 b.addEventListener('click', function (ev) {
306 ev.preventDefault();
307 if (mode !== 'rendered') return;
308 rendered.focus();
309 var action = b.getAttribute('data-action');
310 if (action === 'link') {
311 var url = prompt('URL?', 'https://');
312 if (url) document.execCommand('createLink', false, url);
313 } else if (action === 'code') {
314 var sel = window.getSelection();
315 if (sel && sel.rangeCount && !sel.isCollapsed) {
316 var range = sel.getRangeAt(0);
317 var code = document.createElement('code');
318 try { range.surroundContents(code); } catch (e) {
319 code.appendChild(range.extractContents());
320 range.insertNode(code);
321 }
322 }
323 }
324 syncHidden();
325 });
326 });
327
328 if (varSel) {
329 varSel.addEventListener('change', function () {
330 var v = varSel.value;
331 if (!v) return;
332 if (mode === 'rendered') {
333 rendered.focus();
334 document.execCommand('insertText', false, v);
335 } else {
336 var ta = source;
337 var start = ta.selectionStart, end = ta.selectionEnd;
338 ta.value = ta.value.slice(0, start) + v + ta.value.slice(end);
339 ta.selectionStart = ta.selectionEnd = start + v.length;
340 ta.focus();
341 }
342 varSel.value = '';
343 syncHidden();
344 });
345 }
346
347 modeBtn.addEventListener('click', function (ev) {
348 ev.preventDefault();
349 if (mode === 'rendered') {
350 source.value = rendered.innerHTML;
351 rendered.style.display = 'none';
352 source.style.display = 'block';
353 mode = 'source';
354 modeBtn.innerHTML = 'Rendered &#8644;';
355 source.focus();
356 } else {
357 rendered.innerHTML = source.value;
358 source.style.display = 'none';
359 rendered.style.display = 'block';
360 mode = 'rendered';
361 modeBtn.innerHTML = 'Source &#8644;';
362 rendered.focus();
363 }
364 syncHidden();
365 });
366
367 rendered.addEventListener('input', syncHidden);
368 source.addEventListener('input', syncHidden);
369
370 var form = root.closest('form');
371 if (form) form.addEventListener('submit', syncHidden);
372
373 var SAMPLES = {
374 display_name : 'Shawn (Platform Owner)',
375 first_name : 'Shawn',
376 company_name : "Shawn's Workspace",
377 trial_ends_at : '2026-07-04 09:00:00',
378 days_left : '7',
379 billing_url : 'https://shop.3dshawn.com/billing.cgi',
380 dashboard_url : 'https://shop.3dshawn.com/dashboard.cgi',
381 unsubscribe_url: 'https://shop.3dshawn.com/unsubscribe.cgi?t=SAMPLE',
382 inviter_name : 'Shawn',
383 inviter_email : 'shawn\@example.com',
384 accept_url : 'https://shop.3dshawn.com/accept_invite.cgi?token=SAMPLE',
385 reset_url : 'https://shop.3dshawn.com/reset_password.cgi?t=SAMPLE'
386 };
387 function fillVars(html) {
388 return (html || '').replace(/\{\{\s*([a-z_][a-z0-9_]*)\s*\}\}/gi, function (_, k) {
389 return (k in SAMPLES) ? SAMPLES[k] : '{{' + k + '}}';
390 });
391 }
392 var backdrop = document.getElementById('wprev-backdrop');
393 var prevBody = document.getElementById('wprev-body');
394 var prevSubj = document.getElementById('wprev-subject');
395 var prevBtn = document.getElementById('wyse-preview');
396 var closeBtn = document.getElementById('wprev-close');
397 function openPreview() {
398 syncHidden();
399 prevBody.innerHTML = fillVars(source.value);
400 var subjInput = document.querySelector('input[name=subject]');
401 prevSubj.textContent = fillVars(subjInput ? subjInput.value : '');
402 backdrop.classList.add('is-open');
403 document.body.style.overflow = 'hidden';
404 }
405 function closePreview() {
406 backdrop.classList.remove('is-open');
407 document.body.style.overflow = '';
408 }
409 if (prevBtn) prevBtn.addEventListener('click', function (ev) { ev.preventDefault(); openPreview(); });
410 if (closeBtn) closeBtn.addEventListener('click', closePreview);
411 backdrop.addEventListener('click', function (ev) {
412 if (ev.target === backdrop) closePreview();
413 });
414 document.addEventListener('keydown', function (ev) {
415 if (ev.key === 'Escape' && backdrop.classList.contains('is-open')) closePreview();
416 });
417 })();
418 </script>
419 <label style="display:flex;align-items:center;gap:8px;font-size:13px;color:#cbd5e1;margin-bottom:18px">
420 <input type="checkbox" name="is_active" value="1" $checked> Active (template can be sent)
421 </label>
422 <button type="submit" class="btn btn-primary btn-lg">Save changes</button>
423 </div>
424 <aside style="background:rgba(20,20,30,.4);padding:16px 18px;border:1px solid rgba(255,255,255,.08);border-radius:12px;height:fit-content">
425 <h3 style="font-size:13px;text-transform:uppercase;letter-spacing:.05em;color:#94a3b8;margin:0 0 6px">Variables &amp; sample values</h3>
426 <p style="font-size:11px;color:#94a3b8;margin:0 0 12px;line-height:1.5">Drop \{\{name\}\} into the body or subject; at send time it's swapped for the real value. The samples below are what the <strong>Preview</strong> button uses.</p>
427 <table style="font-size:11.5px;line-height:1.5;width:100%;border-collapse:collapse">
428 <tr><td style="padding:3px 6px 3px 0;color:#c4b5fd;font-family:ui-monospace,Consolas,Menlo,monospace;white-space:nowrap">\{\{display_name\}\}</td><td style="padding:3px 0;color:#cbd5e1">Shawn (Platform Owner)</td></tr>
429 <tr><td style="padding:3px 6px 3px 0;color:#c4b5fd;font-family:ui-monospace,Consolas,Menlo,monospace;white-space:nowrap">\{\{first_name\}\}</td><td style="padding:3px 0;color:#cbd5e1">Shawn</td></tr>
430 <tr><td style="padding:3px 6px 3px 0;color:#c4b5fd;font-family:ui-monospace,Consolas,Menlo,monospace;white-space:nowrap">\{\{company_name\}\}</td><td style="padding:3px 0;color:#cbd5e1">Shawn's Workspace</td></tr>
431 <tr><td style="padding:3px 6px 3px 0;color:#c4b5fd;font-family:ui-monospace,Consolas,Menlo,monospace;white-space:nowrap">\{\{trial_ends_at\}\}</td><td style="padding:3px 0;color:#cbd5e1">2026-07-04 09:00:00</td></tr>
432 <tr><td style="padding:3px 6px 3px 0;color:#c4b5fd;font-family:ui-monospace,Consolas,Menlo,monospace;white-space:nowrap">\{\{days_left\}\}</td><td style="padding:3px 0;color:#cbd5e1">7</td></tr>
433 <tr><td style="padding:3px 6px 3px 0;color:#c4b5fd;font-family:ui-monospace,Consolas,Menlo,monospace;white-space:nowrap">\{\{billing_url\}\}</td><td style="padding:3px 0;color:#94a3b8;font-size:10.5px">.../billing.cgi</td></tr>
434 <tr><td style="padding:3px 6px 3px 0;color:#c4b5fd;font-family:ui-monospace,Consolas,Menlo,monospace;white-space:nowrap">\{\{dashboard_url\}\}</td><td style="padding:3px 0;color:#94a3b8;font-size:10.5px">.../dashboard.cgi</td></tr>
435 <tr><td style="padding:3px 6px 3px 0;color:#c4b5fd;font-family:ui-monospace,Consolas,Menlo,monospace;white-space:nowrap">\{\{unsubscribe_url\}\}</td><td style="padding:3px 0;color:#94a3b8;font-size:10.5px">.../unsubscribe.cgi?t=...</td></tr>
436 <tr><td style="padding:3px 6px 3px 0;color:#c4b5fd;font-family:ui-monospace,Consolas,Menlo,monospace;white-space:nowrap">\{\{inviter_name\}\}</td><td style="padding:3px 0;color:#cbd5e1">Shawn</td></tr>
437 <tr><td style="padding:3px 6px 3px 0;color:#c4b5fd;font-family:ui-monospace,Consolas,Menlo,monospace;white-space:nowrap">\{\{inviter_email\}\}</td><td style="padding:3px 0;color:#cbd5e1">shawn\@example.com</td></tr>
438 <tr><td style="padding:3px 6px 3px 0;color:#c4b5fd;font-family:ui-monospace,Consolas,Menlo,monospace;white-space:nowrap">\{\{accept_url\}\}</td><td style="padding:3px 0;color:#94a3b8;font-size:10.5px">.../accept_invite.cgi</td></tr>
439 <tr><td style="padding:3px 6px 3px 0;color:#c4b5fd;font-family:ui-monospace,Consolas,Menlo,monospace;white-space:nowrap">\{\{reset_url\}\}</td><td style="padding:3px 0;color:#94a3b8;font-size:10.5px">.../reset_password.cgi</td></tr>
440 </table>
441 <hr style="border:0;border-top:1px solid rgba(255,255,255,.08);margin:18px 0">
442 <h3 style="font-size:13px;text-transform:uppercase;letter-spacing:.05em;color:#94a3b8;margin:0 0 12px">Send test</h3>
443 <p style="font-size:12px;color:#94a3b8;margin:0 0 10px">Renders with sample values + sends to:</p>
444 </aside>
445 </form>
446
447 <form method="POST" action="/admin_emails.cgi" style="margin-top:24px;padding:16px;border:1px solid rgba(91,33,182,.3);background:rgba(91,33,182,.05);border-radius:10px">
448 <input type="hidden" name="act" value="send_test">
449 <input type="hidden" name="slug" value="$t->{slug}">
450 <label style="display:block;font-size:12px;text-transform:uppercase;letter-spacing:.05em;color:#cbd5e1;margin-bottom:6px">Send test to</label>
451 <div style="display:flex;gap:8px">
452 <input class="input" type="email" name="test_to" value="$u->{email}" style="flex:1">
453 <button type="submit" class="btn btn-secondary">Send test &rarr;</button>
454 </div>
455 </form>
456</div>~;
457 } else {
458 $body = qq~<div class="page-pad"><p style="color:#fca5a5">Template not found.</p></div>~;
459 }
460 } else {
461 my $rows = '';
462 my %cat_color = (
463 transactional => '#a78bfa',
464 lifecycle => '#5aa9ff',
465 product => '#34d399',
466 marketing => '#fbbf24',
467 );
468 foreach my $t (@templates) {
469 my $sys = $t->{is_system} ? '<span style="font-size:10px;padding:1px 6px;border-radius:3px;background:rgba(139,92,246,.18);color:#c4b5fd">SYS</span>' : '';
470 my $active = $t->{is_active} ? '<span style="color:#86efac">active</span>' : '<span style="color:#94a3b8">inactive</span>';
471 my $col = $cat_color{$t->{category}} || '#94a3b8';
472 my $sn = _emx_h($t->{name});
473 my $ss = _emx_h($t->{subject});
474 $rows .= qq~
475 <tr style="border-top:1px solid rgba(255,255,255,.05);cursor:pointer" onclick="location.href='/admin_emails.cgi?edit=$t->{slug}'">
476 <td style="padding:10px 12px"><div style="font-weight:600;color:#e2e8f0">$sn $sys</div><div style="font-size:11px;color:#94a3b8;font-family:ui-monospace,Consolas,Menlo,monospace">$t->{slug}</div></td>
477 <td style="padding:10px 12px"><span style="font-size:11px;color:$col;text-transform:uppercase;letter-spacing:.05em;font-weight:600">$t->{category}</span></td>
478 <td style="padding:10px 12px;font-size:13px;color:#cbd5e1">$ss</td>
479 <td style="padding:10px 12px;font-size:12px">$t->{sched_count} sched</td>
480 <td style="padding:10px 12px;font-size:12px">$active</td>
481 </tr>~;
482 }
483 my $sends_html = '';
484 foreach my $s (@recent_sends) {
485 my $color = $s->{status} eq 'sent' ? '#86efac'
486 : $s->{status} eq 'failed' ? '#fca5a5'
487 : $s->{status} =~ /^suppressed/ ? '#fbbf24'
488 : '#94a3b8';
489 my $to = _emx_h($s->{to_email});
490 my $sj = _emx_h($s->{subject});
491 my $rsn = _emx_h($s->{failure_reason} || '');
492 my $s_when = ($s->{created_at} && $s->{created_at_epoch})
493 ? qq~<span class="ts" data-ts="$s->{created_at_epoch}" data-fmt="datetime">$s->{created_at}</span>~
494 : ($s->{created_at} // '');
495 $sends_html .= qq~
496 <tr style="border-top:1px solid rgba(255,255,255,.05)">
497 <td style="padding:6px 10px;font-size:11px;color:#94a3b8">$s_when</td>
498 <td style="padding:6px 10px;font-size:12px;color:#cbd5e1;font-family:ui-monospace,Consolas,Menlo,monospace">$s->{template_slug}</td>
499 <td style="padding:6px 10px;font-size:12px;color:#cbd5e1">$to</td>
500 <td style="padding:6px 10px;font-size:11px;color:$color;text-transform:uppercase;letter-spacing:.05em">$s->{status}</td>
501 <td style="padding:6px 10px;font-size:11px;color:#94a3b8">$rsn</td>
502 </tr>~;
503 }
504 my $tabs = _emx_setup_tabs('templates');
505 $body = qq~
506<div class="page-pad">
507 <h1 style="margin:0 0 6px;font-size:28px;color:#fff">Email Setup</h1>
508 <p style="color:#94a3b8;margin:0 0 18px;font-size:14px">Templates, schedules, and spam-protection controls.</p>
509 $tabs
510 $flash_html
511 <h2 style="font-size:18px;color:#fff;margin:0 0 6px">Templates</h2>
512 <p style="color:#94a3b8;margin:0 0 14px;font-size:13px">Edit subject + body for every email ShopCart sends. Click a row to edit.</p>
513
514 <div style="border:1px solid rgba(255,255,255,.08);border-radius:12px;overflow:hidden;background:rgba(20,20,30,.4);margin-bottom:32px">
515 <table style="width:100%;border-collapse:collapse">
516 <thead><tr>
517 <th style="padding:10px 12px;text-align:left;font-size:11px;color:#94a3b8;text-transform:uppercase;letter-spacing:.05em">Name</th>
518 <th style="padding:10px 12px;text-align:left;font-size:11px;color:#94a3b8;text-transform:uppercase;letter-spacing:.05em">Category</th>
519 <th style="padding:10px 12px;text-align:left;font-size:11px;color:#94a3b8;text-transform:uppercase;letter-spacing:.05em">Subject</th>
520 <th style="padding:10px 12px;text-align:left;font-size:11px;color:#94a3b8;text-transform:uppercase;letter-spacing:.05em">Schedules</th>
521 <th style="padding:10px 12px;text-align:left;font-size:11px;color:#94a3b8;text-transform:uppercase;letter-spacing:.05em">Status</th>
522 </tr></thead>
523 <tbody>$rows</tbody>
524 </table>
525 </div>
526
527 <h2 style="font-size:18px;color:#fff;margin:0 0 14px">Recent sends</h2>
528 <div style="border:1px solid rgba(255,255,255,.08);border-radius:12px;overflow:hidden;background:rgba(20,20,30,.4)">
529 <table style="width:100%;border-collapse:collapse">
530 <thead><tr>
531 <th style="padding:6px 10px;text-align:left;font-size:10px;color:#94a3b8;text-transform:uppercase">When</th>
532 <th style="padding:6px 10px;text-align:left;font-size:10px;color:#94a3b8;text-transform:uppercase">Template</th>
533 <th style="padding:6px 10px;text-align:left;font-size:10px;color:#94a3b8;text-transform:uppercase">To</th>
534 <th style="padding:6px 10px;text-align:left;font-size:10px;color:#94a3b8;text-transform:uppercase">Status</th>
535 <th style="padding:6px 10px;text-align:left;font-size:10px;color:#94a3b8;text-transform:uppercase">Detail</th>
536 </tr></thead>
537 <tbody>$sends_html</tbody>
538 </table>
539 </div>
540</div>~;
541 }
542
543 $wrap->render({ userinfo => $u, page_key => 'email_setup', title => 'Email Setup', body => $body });
544 return;
545}
546
547#======================================================================
548# Controls tab (formerly admin_email_controls.cgi)
549#======================================================================
550sub _emx_controls {
551 my $dbh = $db->db_connect;
552 my $act = $form->{act} || '';
553 my $flash = '';
554
555 if (($ENV{REQUEST_METHOD} || '') eq 'POST' && $act eq 'save_controls') {
556 my %controls = (
557 email_rate_hourly_cap => { min=>1, max=>10000, default=>20 },
558 email_rate_daily_cap => { min=>1, max=>100000, default=>100 },
559 email_dedupe_window_hours => { min=>0, max=>720, default=>24 },
560 email_account_age_min_hours => { min=>0, max=>720, default=>1 },
561 email_bounce_suspend_pct => { min=>0, max=>100, default=>10 },
562 email_bounce_min_volume => { min=>1, max=>100000, default=>20 },
563 email_abuse_suspend_threshold => { min=>1, max=>100, default=>1 },
564 email_suspend_days => { min=>1, max=>365, default=>7 },
565 );
566 foreach my $k (keys %controls) {
567 my $raw = $form->{$k}; next unless defined $raw;
568 my $n = $raw + 0;
569 my $spec = $controls{$k};
570 $n = $spec->{default} if ($n < $spec->{min} || $n > $spec->{max});
571 my $kq = $k; $kq =~ s/'/''/g;
572 my $vq = $n; $vq =~ s/'/''/g;
573 $db->db_readwrite($dbh, qq~
574 INSERT INTO ${DB}.platform_settings (setting_key, setting_value)
575 VALUES ('$kq', '$vq')
576 ON DUPLICATE KEY UPDATE setting_value='$vq'
577 ~, $0, __LINE__);
578 }
579 $flash = 'Email controls saved.';
580 }
581
582 my @control_rows = $db->db_readwrite_multiple($dbh, qq~
583 SELECT setting_key, setting_value FROM ${DB}.platform_settings
584 WHERE setting_key IN (
585 'email_rate_hourly_cap','email_rate_daily_cap','email_dedupe_window_hours',
586 'email_account_age_min_hours','email_bounce_suspend_pct','email_bounce_min_volume',
587 'email_abuse_suspend_threshold','email_suspend_days')
588 ~, $0, __LINE__);
589 my %controls;
590 foreach my $r (@control_rows) { $controls{$r->{setting_key}} = $r->{setting_value}; }
591 my %control_defaults = (
592 email_rate_hourly_cap => 20, email_rate_daily_cap => 100,
593 email_dedupe_window_hours => 24, email_account_age_min_hours => 1,
594 email_bounce_suspend_pct => 10, email_bounce_min_volume => 20,
595 email_abuse_suspend_threshold => 1, email_suspend_days => 7,
596 );
597 foreach my $k (keys %control_defaults) { $controls{$k} //= $control_defaults{$k}; }
598
599 $db->db_disconnect($dbh);
600
601 print "Content-Type: text/html; charset=utf-8\r\nCache-Control: no-store\r\n\r\n";
602
603 my $flash_html = $flash ? qq~<div style="padding:10px 14px;background:rgba(34,197,94,.12);border:1px solid rgba(34,197,94,.3);border-radius:8px;color:#86efac;font-size:13px;margin-bottom:18px">$flash</div>~ : '';
604
605 my $tabs = _emx_setup_tabs('controls');
606
607 my $body = qq~
608<div class="page-pad">
609 <h1 style="margin:0 0 6px;font-size:28px;color:#fff">Email Setup</h1>
610 <p style="color:#94a3b8;margin:0 0 18px;font-size:14px">Templates, schedules, and spam-protection controls.</p>
611 $tabs
612 $flash_html
613 <h2 style="font-size:18px;color:#fff;margin:0 0 6px">Controls <span style="font-size:11px;color:#94a3b8;font-weight:400;letter-spacing:.05em">&middot; SPAM PROTECTION</span></h2>
614 <p style="color:#94a3b8;margin:0 0 14px;font-size:13px">Tune the per-account caps, account-age gate, bounce auto-suspend, and abuse-report threshold. Defaults are conservative &mdash; raise carefully.</p>
615 <form method="POST" action="/admin_email_controls.cgi" style="border:1px solid rgba(255,255,255,.08);border-radius:12px;background:rgba(20,20,30,.4);padding:18px">
616 <input type="hidden" name="act" value="save_controls">
617 <div style="display:grid;grid-template-columns:repeat(auto-fit,minmax(220px,1fr));gap:14px">
618 <label style="font-size:12px;color:#cbd5e1">
619 <div style="text-transform:uppercase;letter-spacing:.05em;color:#94a3b8;font-size:10px;margin-bottom:4px">Hourly burst cap</div>
620 <input class="input" type="number" name="email_rate_hourly_cap" value="$controls{email_rate_hourly_cap}" min="1" max="10000" style="width:100%">
621 <div style="color:#94a3b8;font-size:11px;margin-top:4px">Sends/account/hour. Hard cap.</div>
622 </label>
623 <label style="font-size:12px;color:#cbd5e1">
624 <div style="text-transform:uppercase;letter-spacing:.05em;color:#94a3b8;font-size:10px;margin-bottom:4px">Daily cap</div>
625 <input class="input" type="number" name="email_rate_daily_cap" value="$controls{email_rate_daily_cap}" min="1" max="100000" style="width:100%">
626 <div style="color:#94a3b8;font-size:11px;margin-top:4px">Sends/account/24h. Hard cap.</div>
627 </label>
628 <label style="font-size:12px;color:#cbd5e1">
629 <div style="text-transform:uppercase;letter-spacing:.05em;color:#94a3b8;font-size:10px;margin-bottom:4px">Dedupe window (hours)</div>
630 <input class="input" type="number" name="email_dedupe_window_hours" value="$controls{email_dedupe_window_hours}" min="0" max="720" style="width:100%">
631 <div style="color:#94a3b8;font-size:11px;margin-top:4px">Same recipient + same template within N hours = drop.</div>
632 </label>
633 <label style="font-size:12px;color:#cbd5e1">
634 <div style="text-transform:uppercase;letter-spacing:.05em;color:#94a3b8;font-size:10px;margin-bottom:4px">Account-age gate (hours)</div>
635 <input class="input" type="number" name="email_account_age_min_hours" value="$controls{email_account_age_min_hours}" min="0" max="720" style="width:100%">
636 <div style="color:#94a3b8;font-size:11px;margin-top:4px">Min account age before inviter can send (password reset / verify bypass).</div>
637 </label>
638 <label style="font-size:12px;color:#cbd5e1">
639 <div style="text-transform:uppercase;letter-spacing:.05em;color:#94a3b8;font-size:10px;margin-bottom:4px">Bounce suspend %</div>
640 <input class="input" type="number" name="email_bounce_suspend_pct" value="$controls{email_bounce_suspend_pct}" min="0" max="100" style="width:100%">
641 <div style="color:#94a3b8;font-size:11px;margin-top:4px">Auto-suspend inviter at &gt;= this % bounces.</div>
642 </label>
643 <label style="font-size:12px;color:#cbd5e1">
644 <div style="text-transform:uppercase;letter-spacing:.05em;color:#94a3b8;font-size:10px;margin-bottom:4px">Bounce min volume</div>
645 <input class="input" type="number" name="email_bounce_min_volume" value="$controls{email_bounce_min_volume}" min="1" max="100000" style="width:100%">
646 <div style="color:#94a3b8;font-size:11px;margin-top:4px">% only triggers above this send volume (avoids 1/1 = 100%).</div>
647 </label>
648 <label style="font-size:12px;color:#cbd5e1">
649 <div style="text-transform:uppercase;letter-spacing:.05em;color:#94a3b8;font-size:10px;margin-bottom:4px">Abuse-report threshold</div>
650 <input class="input" type="number" name="email_abuse_suspend_threshold" value="$controls{email_abuse_suspend_threshold}" min="1" max="100" style="width:100%">
651 <div style="color:#94a3b8;font-size:11px;margin-top:4px">N reports in 30d = auto-suspend.</div>
652 </label>
653 <label style="font-size:12px;color:#cbd5e1">
654 <div style="text-transform:uppercase;letter-spacing:.05em;color:#94a3b8;font-size:10px;margin-bottom:4px">Suspend duration (days)</div>
655 <input class="input" type="number" name="email_suspend_days" value="$controls{email_suspend_days}" min="1" max="365" style="width:100%">
656 <div style="color:#94a3b8;font-size:11px;margin-top:4px">How long the auto-suspend lasts.</div>
657 </label>
658 </div>
659 <div style="margin-top:18px">
660 <button type="submit" class="btn" style="background:#5aa9ff;color:#0b1220;border:0;border-radius:8px;padding:10px 18px;font-weight:600">Save email controls</button>
661 </div>
662 </form>
663</div>~;
664
665 $wrap->render({ userinfo => $u, page_key => 'email_setup', title => 'Email Setup', body => $body });
666 return;
667}
668
669#======================================================================
670# Schedules tab (formerly admin_email_schedules.cgi)
671#======================================================================
672sub _emx_schedules {
673 my $dbh = $db->db_connect;
674 my $act = $form->{act} || '';
675 my $flash = '';
676
677 my @EVENTS = qw(trial_end_at signup invoice_paid invoice_failed password_reset);
678 my %EVENT_DESC = (
679 trial_end_at => "Relative to companies.trial_ends_at",
680 signup => "Relative to user signup",
681 invoice_paid => "Relative to a successful invoice payment",
682 invoice_failed => "Relative to a failed invoice charge",
683 password_reset => "When a password reset is requested",
684 );
685
686 if (($ENV{REQUEST_METHOD} || '') eq 'POST') {
687 if ($act eq 'save') {
688 my $sid = ($form->{schedule_id} || 0) + 0;
689 my $off_d = ($form->{offset_days} || 0) + 0;
690 my $off_h = ($form->{offset_hours} || 0) + 0;
691 my $hr = $form->{send_at_local_hour};
692 my $hr_sql = (defined $hr && $hr =~ /^\d+$/ && $hr >= 0 && $hr <= 23) ? "'$hr'" : 'NULL';
693 my $ev = $form->{trigger_event} || 'trial_end_at';
694 $ev = 'trial_end_at' unless grep { $_ eq $ev } @EVENTS;
695 my $active = $form->{is_active} ? 1 : 0;
696 my $notes = substr($form->{notes} || '', 0, 250); $notes =~ s/'/''/g;
697 $db->db_readwrite($dbh, qq~
698 UPDATE ${DB}.email_schedules
699 SET trigger_event='$ev', offset_days='$off_d', offset_hours='$off_h',
700 send_at_local_hour=$hr_sql, is_active='$active', notes='$notes',
701 updated_by_user_id='$uid'
702 WHERE id='$sid'
703 ~, $0, __LINE__);
704 $flash = 'Schedule updated.';
705 }
706 elsif ($act eq 'add') {
707 my $tid = ($form->{template_id} || 0) + 0;
708 my $ev = $form->{trigger_event} || 'trial_end_at';
709 $ev = 'trial_end_at' unless grep { $_ eq $ev } @EVENTS;
710 my $off_d = ($form->{offset_days} || 0) + 0;
711 my $off_h = ($form->{offset_hours} || 0) + 0;
712 if ($tid) {
713 $db->db_readwrite($dbh, qq~
714 INSERT INTO ${DB}.email_schedules
715 (template_id, trigger_event, offset_days, offset_hours, is_active, created_at, updated_by_user_id)
716 VALUES ('$tid', '$ev', '$off_d', '$off_h', 1, NOW(), '$uid')
717 ~, $0, __LINE__);
718 $flash = 'Schedule added.';
719 }
720 }
721 elsif ($act eq 'delete') {
722 my $sid = ($form->{schedule_id} || 0) + 0;
723 if ($sid) {
724 $db->db_readwrite($dbh, qq~DELETE FROM ${DB}.email_schedules WHERE id='$sid'~, $0, __LINE__);
725 $flash = 'Schedule deleted.';
726 }
727 }
728 }
729
730 my @scheds = $db->db_readwrite_multiple($dbh, qq~
731 SELECT s.id, s.template_id, s.trigger_event, s.offset_days, s.offset_hours,
732 s.send_at_local_hour, s.is_active, s.notes, s.updated_at,
733 t.slug, t.name AS template_name, t.category
734 FROM ${DB}.email_schedules s
735 JOIN ${DB}.email_templates t ON t.id = s.template_id
736 ORDER BY s.trigger_event, s.offset_days, t.slug
737 ~, $0, __LINE__);
738
739 my @templates = $db->db_readwrite_multiple($dbh, qq~
740 SELECT id, slug, name, category FROM ${DB}.email_templates ORDER BY category, slug
741 ~, $0, __LINE__);
742
743 $db->db_disconnect($dbh);
744
745 print "Content-Type: text/html; charset=utf-8\r\nCache-Control: no-store\r\n\r\n";
746
747 my $flash_html = $flash ? qq~<div style="padding:10px 14px;background:rgba(34,197,94,.12);border:1px solid rgba(34,197,94,.3);border-radius:8px;color:#86efac;font-size:13px;margin-bottom:18px">$flash</div>~ : '';
748
749 my $rows = '';
750 foreach my $s (@scheds) {
751 my $hr_val = defined($s->{send_at_local_hour}) ? $s->{send_at_local_hour} : '';
752 my $checked = $s->{is_active} ? 'checked' : '';
753 my $name = _emx_h($s->{template_name});
754 my $notes = _emx_h($s->{notes} || '');
755 my $ev_opts = '';
756 foreach my $e (@EVENTS) {
757 my $sel = ($e eq $s->{trigger_event}) ? ' selected' : '';
758 $ev_opts .= qq~<option value="$e"$sel>$e</option>~;
759 }
760 my $timing = ($s->{offset_days} == 0 && $s->{offset_hours} == 0) ? 'on event'
761 : ($s->{offset_days} < 0 || $s->{offset_hours} < 0) ? "before"
762 : "after";
763 my $timing_color = $timing eq 'before' ? '#5aa9ff'
764 : $timing eq 'after' ? '#fbbf24'
765 : '#86efac';
766 my $timing_label = uc($timing);
767 $rows .= qq~
768 <tr style="border-top:1px solid rgba(255,255,255,.05)">
769 <td style="padding:14px 14px;font-size:13px;color:#e2e8f0;vertical-align:top;width:180px">
770 <div style="font-weight:600">$name</div>
771 <div style="font-size:11px;color:#94a3b8;font-family:ui-monospace,Consolas,Menlo,monospace;margin-top:4px">$s->{slug}</div>
772 </td>
773 <td style="padding:14px 14px;vertical-align:top">
774 <form method="POST" action="/admin_email_schedules.cgi" style="display:grid;grid-template-columns:1fr 1fr;gap:10px;margin:0;align-items:start">
775 <input type="hidden" name="act" value="save">
776 <input type="hidden" name="schedule_id" value="$s->{id}">
777
778 <div>
779 <label style="display:block;font-size:10px;color:#94a3b8;text-transform:uppercase;letter-spacing:.06em;margin-bottom:4px">Trigger event</label>
780 <select name="trigger_event" class="select" style="font-size:13px;padding:6px 8px;width:100%">$ev_opts</select>
781 </div>
782
783 <div>
784 <label style="display:block;font-size:10px;color:#94a3b8;text-transform:uppercase;letter-spacing:.06em;margin-bottom:4px">Notes</label>
785 <textarea class="input grow-on-focus" name="notes" rows="1" placeholder="optional note shown only on this admin page" style="font-size:13px;padding:6px 8px;width:100%;height:32px;resize:none;overflow:hidden;transition:height .15s ease;font-family:inherit;line-height:1.4" onfocus="this.style.height='120px';this.style.overflow='auto'" onblur="this.style.height='32px';this.style.overflow='hidden'">$notes</textarea>
786 </div>
787
788 <div style="display:flex;gap:10px;flex-wrap:wrap;align-items:flex-start">
789 <div style="border:1px solid rgba(90,169,255,.18);background:rgba(90,169,255,.04);border-radius:8px;padding:8px 12px">
790 <label style="display:block;font-size:10px;color:#94a3b8;text-transform:uppercase;letter-spacing:.06em;margin-bottom:4px">Offset <span style="color:$timing_color;font-weight:600">&middot; $timing_label</span></label>
791 <div style="display:flex;gap:6px;align-items:center;font-size:12px;color:#94a3b8">
792 <input class="input" name="offset_days" type="number" value="$s->{offset_days}" style="width:60px;padding:6px 8px;text-align:center"> <span>days</span>
793 <input class="input" name="offset_hours" type="number" value="$s->{offset_hours}" style="width:60px;padding:6px 8px;text-align:center"> <span>hours</span>
794 </div>
795 </div>
796 <div style="border:1px solid rgba(34,197,94,.18);background:rgba(34,197,94,.04);border-radius:8px;padding:8px 12px;display:flex;gap:14px;align-items:flex-end;flex-wrap:wrap">
797 <div>
798 <label style="display:block;font-size:10px;color:#94a3b8;text-transform:uppercase;letter-spacing:.06em;margin-bottom:4px">Send at local hour</label>
799 <div style="display:flex;gap:6px;align-items:center;font-size:12px;color:#94a3b8">
800 <input class="input" name="send_at_local_hour" type="number" min="0" max="23" value="$hr_val" placeholder="any" style="width:60px;padding:6px 8px;text-align:center"> <span>:00</span>
801 </div>
802 </div>
803 <label style="font-size:13px;color:#cbd5e1;display:flex;align-items:center;gap:8px;margin:0 0 6px 0;cursor:pointer">
804 <input type="checkbox" name="is_active" value="1" $checked style="width:16px;height:16px">
805 <span>Active</span>
806 </label>
807 </div>
808 </div>
809
810 <div style="display:flex;gap:10px;justify-content:flex-end;align-items:flex-start">
811 <button type="submit" class="btn btn-primary" style="font-size:13px;padding:8px 18px">Save changes</button>
812 <button type="button"
813 class="js-delete-schedule"
814 data-id="$s->{id}"
815 data-name="$name"
816 data-slug="$s->{slug}"
817 style="font-size:13px;padding:8px 18px;background:rgba(239,68,68,.10);color:#fca5a5;border:1px solid rgba(239,68,68,.35);border-radius:6px;cursor:pointer;font-weight:600">
818 Delete
819 </button>
820 </div>
821 </form>
822 </td>
823 </tr>~;
824 }
825
826 my $tpl_opts = '';
827 foreach my $t (@templates) {
828 my $n = _emx_h($t->{name});
829 $tpl_opts .= qq~<option value="$t->{id}">[$t->{category}] $n ($t->{slug})</option>~;
830 }
831 my $ev_opts = '';
832 foreach my $e (@EVENTS) {
833 my $desc = _emx_h($EVENT_DESC{$e});
834 $ev_opts .= qq~<option value="$e">$e &ndash; $desc</option>~;
835 }
836
837 my $tabs_html = _emx_setup_tabs('schedules');
838
839 my $body = qq~
840<style>
841 .cmodal-back {
842 position: fixed; inset: 0; z-index: 9000;
843 background: rgba(8, 10, 16, .75);
844 backdrop-filter: blur(4px);
845 -webkit-backdrop-filter: blur(4px);
846 display: none; align-items: center; justify-content: center;
847 padding: 24px;
848 opacity: 0;
849 transition: opacity .18s ease;
850 }
851 .cmodal-back.is-open { display: flex; opacity: 1; }
852 .cmodal {
853 width: 100%; max-width: 460px;
854 background: linear-gradient(180deg, #161b29 0%, #0d1119 100%);
855 border: 1px solid rgba(255,255,255,.10);
856 border-radius: 16px;
857 box-shadow: 0 24px 70px rgba(0,0,0,.55), 0 0 0 1px rgba(255,255,255,.02) inset;
858 overflow: hidden;
859 transform: translateY(8px) scale(.98);
860 transition: transform .18s ease;
861 }
862 .cmodal-back.is-open .cmodal { transform: translateY(0) scale(1); }
863 .cmodal-head {
864 padding: 22px 24px 14px;
865 display: flex; align-items: flex-start; gap: 14px;
866 }
867 .cmodal-icon {
868 flex: 0 0 auto; width: 40px; height: 40px;
869 border-radius: 10px;
870 background: linear-gradient(135deg, rgba(239,68,68,.20), rgba(239,68,68,.08));
871 border: 1px solid rgba(239,68,68,.35);
872 display: flex; align-items: center; justify-content: center;
873 color: #fca5a5;
874 }
875 .cmodal-titlewrap { flex: 1; }
876 .cmodal-title { font-size: 17px; font-weight: 700; color: #f1f5f9; line-height: 1.3; margin: 4px 0 0; }
877 .cmodal-body {
878 padding: 0 24px 16px 78px;
879 font-size: 13.5px; color: #cbd5e1; line-height: 1.6;
880 }
881 .cmodal-body strong { color: #e2e8f0; }
882 .cmodal-body .cmodal-target {
883 display: inline-flex; gap: 8px; align-items: center;
884 margin-top: 10px;
885 padding: 8px 12px;
886 background: rgba(255,255,255,.03);
887 border: 1px solid rgba(255,255,255,.06);
888 border-radius: 8px;
889 font-size: 12.5px;
890 }
891 .cmodal-body .cmodal-target code {
892 font-family: ui-monospace,Consolas,Menlo,monospace;
893 font-size: 11.5px; color: #c4b5fd;
894 }
895 .cmodal-foot {
896 padding: 14px 22px 22px;
897 display: flex; justify-content: flex-end; gap: 10px;
898 background: rgba(0,0,0,.18);
899 border-top: 1px solid rgba(255,255,255,.05);
900 }
901 .cmodal-btn {
902 border: 0; border-radius: 9px;
903 padding: 10px 18px;
904 font-size: 13.5px; font-weight: 600;
905 cursor: pointer;
906 transition: background .12s, transform .08s;
907 font-family: inherit;
908 }
909 .cmodal-btn:active { transform: translateY(1px); }
910 .cmodal-btn-cancel {
911 background: rgba(255,255,255,.06);
912 color: #cbd5e1;
913 border: 1px solid rgba(255,255,255,.10);
914 }
915 .cmodal-btn-cancel:hover { background: rgba(255,255,255,.10); }
916 .cmodal-btn-danger {
917 background: linear-gradient(180deg, #dc2626, #b91c1c);
918 color: #fff;
919 border: 1px solid rgba(127,29,29,.6);
920 box-shadow: 0 1px 0 rgba(255,255,255,.10) inset, 0 6px 16px rgba(220,38,38,.30);
921 }
922 .cmodal-btn-danger:hover { background: linear-gradient(180deg, #ef4444, #dc2626); }
923</style>
924
925<div class="page-pad">
926 <h1 style="margin:0 0 6px;font-size:28px;color:#fff">Email Setup</h1>
927 <p style="color:#94a3b8;margin:0 0 18px;font-size:14px">Templates, schedules, and spam-protection controls.</p>
928 $tabs_html
929 $flash_html
930 <h2 style="font-size:18px;color:#fff;margin:0 0 6px">Schedules</h2>
931 <p style="color:#94a3b8;margin:0 0 14px;font-size:13px">When each lifecycle email fires. Negative offset = before the trigger event, positive = after.</p>
932
933 <div style="border:1px solid rgba(255,255,255,.08);border-radius:12px;overflow:hidden;background:rgba(20,20,30,.4);margin-bottom:32px">
934 <table style="width:100%;border-collapse:collapse">
935 <thead><tr>
936 <th style="padding:12px 14px;text-align:left;font-size:10.5px;color:#94a3b8;text-transform:uppercase;letter-spacing:.08em;width:180px">Template</th>
937 <th style="padding:12px 14px;text-align:left;font-size:10.5px;color:#94a3b8;text-transform:uppercase;letter-spacing:.08em">Trigger + offset</th>
938 </tr></thead>
939 <tbody>$rows</tbody>
940 </table>
941 </div>
942
943 <h2 style="font-size:18px;color:#fff;margin:0 0 14px">Add new schedule</h2>
944 <form method="POST" action="/admin_email_schedules.cgi" style="display:grid;grid-template-columns:1fr 1fr 100px 100px auto;gap:10px;align-items:end;padding:16px;border:1px solid rgba(91,33,182,.30);background:rgba(91,33,182,.05);border-radius:10px">
945 <input type="hidden" name="act" value="add">
946 <div><label style="display:block;font-size:11px;color:#cbd5e1;margin-bottom:4px;text-transform:uppercase">Template</label>
947 <select name="template_id" class="select" required>$tpl_opts</select></div>
948 <div><label style="display:block;font-size:11px;color:#cbd5e1;margin-bottom:4px;text-transform:uppercase">Trigger</label>
949 <select name="trigger_event" class="select">$ev_opts</select></div>
950 <div><label style="display:block;font-size:11px;color:#cbd5e1;margin-bottom:4px;text-transform:uppercase">Days</label>
951 <input class="input" name="offset_days" type="number" value="0" style="text-align:center"></div>
952 <div><label style="display:block;font-size:11px;color:#cbd5e1;margin-bottom:4px;text-transform:uppercase">Hours</label>
953 <input class="input" name="offset_hours" type="number" value="0" style="text-align:center"></div>
954 <div><button type="submit" class="btn btn-primary">+ Add schedule</button></div>
955 </form>
956</div>
957
958<div class="cmodal-back" id="cmodal-back" role="dialog" aria-modal="true" aria-labelledby="cmodal-title">
959 <div class="cmodal">
960 <div class="cmodal-head">
961 <div class="cmodal-icon">
962 <svg viewBox="0 0 24 24" width="22" height="22" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round">
963 <path d="M3 6h18"/><path d="M8 6V4a2 2 0 0 1 2-2h4a2 2 0 0 1 2 2v2"/>
964 <path d="M19 6l-1 14a2 2 0 0 1-2 2H8a2 2 0 0 1-2-2L5 6"/>
965 <line x1="10" y1="11" x2="10" y2="17"/><line x1="14" y1="11" x2="14" y2="17"/>
966 </svg>
967 </div>
968 <div class="cmodal-titlewrap">
969 <div style="font-size:11px;text-transform:uppercase;letter-spacing:.08em;color:#fca5a5;font-weight:600">Confirm deletion</div>
970 <h2 class="cmodal-title" id="cmodal-title">Delete this schedule?</h2>
971 </div>
972 </div>
973 <div class="cmodal-body">
974 The template itself stays in place &mdash; only this scheduled send rule is removed. Other schedules for the same template are unaffected.
975 <div class="cmodal-target" id="cmodal-target">
976 <svg viewBox="0 0 24 24" width="14" height="14" fill="none" stroke="#94a3b8" stroke-width="2"><circle cx="12" cy="12" r="10"/><polyline points="12 6 12 12 16 14"/></svg>
977 <span id="cmodal-target-name" style="color:#e2e8f0;font-weight:500"></span>
978 <code id="cmodal-target-slug"></code>
979 </div>
980 </div>
981 <div class="cmodal-foot">
982 <button type="button" class="cmodal-btn cmodal-btn-cancel" id="cmodal-cancel">Cancel</button>
983 <button type="button" class="cmodal-btn cmodal-btn-danger" id="cmodal-confirm">Delete schedule</button>
984 </div>
985 </div>
986</div>
987
988<form id="cmodal-form" method="POST" action="/admin_email_schedules.cgi" style="display:none">
989 <input type="hidden" name="act" value="delete">
990 <input type="hidden" name="schedule_id" id="cmodal-form-id" value="">
991</form>
992
993<script>
994(function () {
995 var back = document.getElementById('cmodal-back');
996 var nameEl = document.getElementById('cmodal-target-name');
997 var slugEl = document.getElementById('cmodal-target-slug');
998 var idEl = document.getElementById('cmodal-form-id');
999 var form = document.getElementById('cmodal-form');
1000 var btnC = document.getElementById('cmodal-cancel');
1001 var btnD = document.getElementById('cmodal-confirm');
1002
1003 function open(name, slug, id) {
1004 nameEl.textContent = name;
1005 slugEl.textContent = slug;
1006 idEl.value = id;
1007 back.classList.add('is-open');
1008 document.body.style.overflow = 'hidden';
1009 setTimeout(function(){ btnC.focus(); }, 50);
1010 }
1011 function close() {
1012 back.classList.remove('is-open');
1013 document.body.style.overflow = '';
1014 }
1015 document.querySelectorAll('.js-delete-schedule').forEach(function (b) {
1016 b.addEventListener('click', function (ev) {
1017 ev.preventDefault();
1018 open(b.getAttribute('data-name'), b.getAttribute('data-slug'), b.getAttribute('data-id'));
1019 });
1020 });
1021 btnC.addEventListener('click', close);
1022 btnD.addEventListener('click', function () { form.submit(); });
1023 back.addEventListener('click', function (ev) { if (ev.target === back) close(); });
1024 document.addEventListener('keydown', function (ev) {
1025 if (ev.key === 'Escape' && back.classList.contains('is-open')) close();
1026 });
1027})();
1028</script>~;
1029
1030 $wrap->render({ userinfo => $u, page_key => 'email_setup', title => 'Email Setup', body => $body });
1031 return;
1032}
1033
1034#======================================================================
1035# Shared helpers
1036#======================================================================
1037sub _emx_h {
1038 my $s = shift // '';
1039 $s =~ s/&/&amp;/g; $s =~ s/</&lt;/g; $s =~ s/>/&gt;/g;
1040 $s =~ s/"/&quot;/g; $s =~ s/'/&#39;/g;
1041 return $s;
1042}
1043
1044sub _emx_setup_tabs {
1045 my ($active) = @_;
1046 my %t = (templates => 'Templates', schedules => 'Schedules', controls => 'Controls');
1047 my %h = (templates => '/admin_emails.cgi', schedules => '/admin_email_schedules.cgi', controls => '/admin_email_controls.cgi');
1048 my $html = '<div style="display:flex;gap:0;border-bottom:1px solid rgba(255,255,255,.08);margin:0 0 22px">';
1049 foreach my $k (qw(templates schedules controls)) {
1050 my $is_active = ($k eq $active);
1051 my $color = $is_active ? '#5aa9ff' : '#94a3b8';
1052 my $border = $is_active ? '#5aa9ff' : 'transparent';
1053 my $weight = $is_active ? '600' : '500';
1054 $html .= qq~<a href="$h{$k}" style="padding:10px 20px;color:$color;text-decoration:none;font-size:13px;border-bottom:2px solid $border;font-weight:$weight;letter-spacing:.02em">$t{$k}</a>~;
1055 }
1056 $html .= '</div>';
1057 return $html;
1058}