Diff -- /var/www/vhosts/webstls.com/httpdocs/admin_emails.cgi
Diff

/var/www/vhosts/webstls.com/httpdocs/admin_emails.cgi

added on WebSTLs (webstls.com) at 2026-07-01 22:26:17

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