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

O Operator
Diff

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

added on local at 2026-07-11 18:33:27

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