| 1 | import { eq, inArray } from "drizzle-orm"; |
| 2 | import { z } |
| 3 | import { db, settings |
| 4 | import { encrypt, safeDecrypt |
| 5 | import { adminProcedure } |
| 6 | import { |
| 7 | buildSmtpTransporter, |
| 8 | DEFAULT_TEMPLATES, |
| 9 | TEMPLATE_NAMES, |
| 10 | TEMPLATE_VARIABLES, |
| 11 | getEmailTemplate, |
| 12 | substituteVars, |
| 13 | } from "@struxa/auth/email"; |
| 14 | |
| 15 | const PASSWORD_SENTINEL = " |
| 16 | |
| 17 | const SMTP_SETTINGS_KEYS = [ |
| 18 | "smtp_enabled", |
| 19 | "smtp_host", |
| 20 | "smtp_port", |
| 21 | "smtp_user", |
| 22 | "smtp_password", |
| 23 | "smtp_from_email", |
| 24 | "smtp_from_name", |
| 25 | "smtp_secure", |
| 26 | ] as const; |
| 27 | |
| 28 | async function upsertSetting( |
| 29 | await db |
| 30 | .insert(settings) |
| 31 | .values({ key |
| 32 | .onDuplicateKeyUpdate({ set: |
| 33 | } |
| 34 | |
| 35 | export const emailRouter = |
| 36 | getSmtpConfig: adminProcedure.handler |
| 37 | const rows = |
| 38 | .select() |
| 39 | .from(settings) |
| 40 | .where(inArray(settings |
| 41 | const s = |
| 42 | return { |
| 43 | enabled: s.smtp_enabled |
| 44 | host: s.smtp_host |
| 45 | port: s.smtp_port |
| 46 | user: s.smtp_user |
| 47 | passwordSet: !!s.smtp_password |
| 48 | fromEmail: s.smtp_from_email |
| 49 | fromName: s.smtp_from_name |
| 50 | secure: s.smtp_secure |
| 51 | }; |
| 52 | }), |
| 53 | |
| 54 | saveSmtpConfig: adminProcedure |
| 55 | .input( |
| 56 | z.object({ |
| 57 | enabled: z.boolean |
| 58 | host: z.string |
| 59 | port: z.string |
| 60 | user: z.string |
| 61 | password: z.string |
| 62 | fromEmail: z.string |
| 63 | fromName: z.string |
| 64 | secure: z.boolean |
| 65 | }), |
| 66 | ) |
| 67 | .handler(async ( |
| 68 | await upsertSetting("smtp_enabled |
| 69 | await upsertSetting("smtp_host |
| 70 | await upsertSetting("smtp_port |
| 71 | await upsertSetting("smtp_user |
| 72 | await upsertSetting("smtp_from_email |
| 73 | await upsertSetting("smtp_from_name |
| 74 | await upsertSetting("smtp_secure |
| 75 | |
| 76 | if (input.password |
| 77 | await upsertSetting("smtp_password |
| 78 | } |
| 79 | }), |
| 80 | |
| 81 | testConnection: adminProcedure |
| 82 | .input(z.object |
| 83 | .handler(async ( |
| 84 | const rows = |
| 85 | const s = |
| 86 | |
| 87 | if (s.smtp_enabled |
| 88 | return { ok: |
| 89 | } |
| 90 | |
| 91 | const password = |
| 92 | const transporter = |
| 93 | host: s.smtp_host |
| 94 | port: parseInt(s |
| 95 | user: s.smtp_user |
| 96 | password, |
| 97 | fromEmail: s.smtp_from_email |
| 98 | fromName: s.smtp_from_name |
| 99 | secure: s.smtp_secure |
| 100 | }); |
| 101 | |
| 102 | try { |
| 103 | await transporter.verify |
| 104 | } catch (err) |
| 105 | return { ok: |
| 106 | } |
| 107 | |
| 108 | const appName = |
| 109 | const html = |
| 110 | const from = |
| 111 | ? `"${s. |
| 112 | : s.smtp_from_email; |
| 113 | |
| 114 | try { |
| 115 | await transporter.sendMail |
| 116 | from, |
| 117 | to: input.email |
| 118 | subject: `[${appName |
| 119 | html, |
| 120 | }); |
| 121 | } catch (err) |
| 122 | return { |
| 123 | ok: false as const |
| 124 | error: `Verified but send failed: ${err |
| 125 | }; |
| 126 | } |
| 127 | |
| 128 | return { ok: |
| 129 | }), |
| 130 | |
| 131 | getTemplate: adminProcedure |
| 132 | .input(z.object |
| 133 | .handler(async ( |
| 134 | const customHtml = |
| 135 | const sampleVars: |
| 136 | appName: "Struxa", |
| 137 | userName: "John Doe", |
| 138 | verificationUrl: "https://panel.example.com/verify?token=sample", |
| 139 | resetUrl: "https://panel.example.com/reset?token=sample", |
| 140 | serverName: "My Minecraft Server", |
| 141 | }; |
| 142 | const defaultHtml = |
| 143 | return { |
| 144 | customHtml: customHtml ?? |
| 145 | defaultHtml, |
| 146 | variables: TEMPLATE_VARIABLES[input |
| 147 | }; |
| 148 | }), |
| 149 | |
| 150 | saveTemplate: adminProcedure |
| 151 | .input(z.object |
| 152 | .handler(async ( |
| 153 | const key = |
| 154 | if (input.html |
| 155 | await db.delete |
| 156 | } else { |
| 157 | await upsertSetting(key |
| 158 | } |
| 159 | }), |
| 160 | |
| 161 | previewTemplate: adminProcedure |
| 162 | .input(z.object |
| 163 | .handler(async ( |
| 164 | const sampleVars: |
| 165 | appName: "Struxa", |
| 166 | userName: "John Doe", |
| 167 | verificationUrl: "https://panel.example.com/verify?token=sample", |
| 168 | resetUrl: "https://panel.example.com/reset?token=sample", |
| 169 | serverName: "My Minecraft Server", |
| 170 | }; |
| 171 | |
| 172 | let html: |
| 173 | if (input.html |
| 174 | html = substituteVars( |
| 175 | } else { |
| 176 | const custom = |
| 177 | html = custom |
| 178 | ? substituteVars(custom, |
| 179 | : (DEFAULT_TEMPLATES[input |
| 180 | } |
| 181 | return { html |
| 182 | }), |
| 183 | }; |