Your OTP Code

INSERT INTO `email_templates` (`id`, `name`, `subject`, `description`, `created_at`, `updated_at`) VALUES (1, 'otpTemplate', 'OTP Verification', '\n\n\n \n \n Your OTP Code\n \n\n\n

\n \n

Hello,

\n Your One-Time Password (OTP) for account verification is:\n

\n {{otp}}\n

\n Please enter this code in the required field to complete your action. This code is valid for 5 minutes.\n

\n If you did not request this code, please ignore this email.\n

\n \n

\n\n\n', '2025-08-12 12:57:45', '2025-08-12 12:57:45'), (2, 'orderPlaced', 'Esim Order', '\n\n\n \n \n Your eSIM Order Has Been Placed!\n \n\n\n

\n \n

Hello,

\n Thank you for your recent eSIM order with {{companyName}}!\n

\n Your order has been successfully placed and is being processed. Here are your order details:\n

\n\n

Order ID: {{orderId}}

Package: {{packageName}}

Amount: {{orderAmount}}

Order Date & Time: {{orderDate}}

\n\n

\n You will receive a separate email shortly with your **eSIM QR code** and detailed activation instructions. Please keep an eye on your inbox (and spam/junk folder).\n

\n If you have any questions or need assistance, please visit our Support Center or contact us directly.\n

\n \n

\n\n\n', '2025-08-12 13:40:35', '2025-08-12 13:40:35'), (3, 'activation', 'Esim Activation Details', '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n <meta charset=\"UTF-8\">\r\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n <title>Your eSIM Details and Activation</title>\r\n <style>\r\n body, html {\r\n margin: 0;\r\n padding: 0;\r\n font-family: \'Inter\', sans-serif;\r\n line-height: 1.6;\r\n background-color: #f7f7f7;\r\n color: #333;\r\n }\r\n .container {\r\n max-width: 600px;\r\n margin: 20px auto;\r\n background-color: #ffffff;\r\n border-radius: 8px;\r\n overflow: hidden;\r\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\r\n }\r\n .header {\r\n background-color: #3b82f6;\r\n color: #ffffff;\r\n padding: 20px;\r\n text-align: center;\r\n border-top-left-radius: 8px;\r\n border-top-right-radius: 8px;\r\n }\r\n .content {\r\n padding: 30px;\r\n text-align: center;\r\n }\r\n \r\n .qr-code-img {\r\n max-width: 250px;\r\n height: auto;\r\n display: block;\r\n margin: 25px auto;\r\n border: 1px solid #e0e0e0;\r\n border-radius: 4px;\r\n }\r\n .activation-steps {\r\n background-color: #f9f9f9;\r\n border: 1px solid #e0e0e0;\r\n padding: 20px;\r\n margin: 20px auto;\r\n border-radius: 8px;\r\n max-width: 500px;\r\n text-align: left;\r\n }\r\n .activation-steps ol {\r\n padding-left: 20px;\r\n margin-top: 15px;\r\n }\r\n .activation-steps li {\r\n margin-bottom: 10px;\r\n }\r\n .activation-steps li:last-child {\r\n margin-bottom: 0;\r\n }\r\n .esim-details {\r\n background-color: #f9f9f9;\r\n border: 1px solid #e0e0e0;\r\n padding: 20px;\r\n margin: 20px auto;\r\n border-radius: 8px;\r\n max-width: 400px;\r\n text-align: left;\r\n }\r\n .esim-details p {\r\n margin-bottom: 8px;\r\n }\r\n .esim-details p:last-child {\r\n margin-bottom: 0;\r\n }\r\n .esim-details strong {\r\n color: #000;\r\n }\r\n .footer {\r\n background-color: #f0f0f0;\r\n color: #777;\r\n padding: 20px;\r\n text-align: center;\r\n font-size: 12px;\r\n border-bottom-left-radius: 8px;\r\n border-bottom-right-radius: 8px;\r\n margin-top: 20px;\r\n }\r\n @media only screen and (max-width: 600px) {\r\n .container {\r\n width: 95%;\r\n margin: 10px auto;\r\n }\r\n .content {\r\n padding: 20px;\r\n }\r\n .qr-code-img {\r\n max-width: 200px;\r\n }\r\n .activation-steps, .esim-details {\r\n padding: 15px;\r\n }\r\n }\r\n </style>\r\n</head>\r\n<body style=\"background-color: #f7f7f7; padding: 16px;\">\r\n <div class=\"container\">\r\n <div class=\"header\">\r\n <h1 style=\"font-size: 28px; font-weight: bold;\">Your eSIM is Ready!</h1>\r\n </div>\r\n <div class=\"content\">\r\n <p style=\"font-size: 18px;\">Hello,</p>\r\n <p style=\"font-size: 16px; margin-top: 8px;\">\r\n Thank you for your eSIM purchase. Your eSIM is now ready for activation!\r\n </p>\r\n\r\n <p style=\"font-size: 16px; margin-top: 20px; font-weight: 600;\">\r\n Scan the QR Code below to activate your eSIM:\r\n </p>\r\n <img src=\"{{qrCode}}\" \r\n alt=\"eSIM QR Code\" class=\"qr-code-img\"\r\n style=\"max-width: 250px; height: auto; display: block; margin: 25px auto; border: 1px solid #e0e0e0; border-radius: 4px;\">\r\n <p style=\"font-size: 14px; color: #777;\">\r\n (Make sure you have a Wi-Fi connection when activating)\r\n </p>\r\n\r\n <div class=\"esim-details\">\r\n <p style=\"font-size: 17px; font-weight: bold; margin-bottom: 10px;\">Your eSIM Details:</p>\r\n <p style=\"font-size: 16px;\"><strong>Package:</strong> {{packageName}}</p>\r\n <p style=\"font-size: 16px;\"><strong>Country/Region:</strong> {{location}}</p>\r\n <p style=\"font-size: 16px;\"><strong>eSIM Number (ICCID):</strong> {{iccid}}</p>\r\n <p style=\"font-size: 16px;\"><strong>Activation Url:</strong> {{activationUrl}} (if required for manual setup)</p>\r\n </div>\r\n\r\n <p style=\"font-size: 16px; margin-top: 20px;\">\r\n If you encounter any issues, please refer to our <a href=\"/\" style=\"color:#2563eb; text-decoration:underline;\">eSIM Activation Guide</a> or contact our support team.\r\n </p>\r\n </div>\r\n <div class=\"footer\">\r\n <p>&copy; {{date}} {{companyName}}. All rights reserved.</p>\r\n <p>This is an automated email. Please do not reply to this message.</p>\r\n </div>\r\n </div>\r\n</body>\r\n</html>', '2025-08-12 16:47:02', '2025-08-29 12:40:05');

Verification Code

Your eSIM Order is Confirmed!