forked from Sunbird-coKreat/program-service
-
Notifications
You must be signed in to change notification settings - Fork 0
/
email_templates.sql
18 lines (14 loc) · 22.2 KB
/
email_templates.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
INSERT INTO sunbird.email_template (name, template)
VALUES ('emailNominationAccept', '<!doctype html><head> <meta name="viewport" content="width=device-width"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title></title> <style> @media screen and (min-width: 320px) { .container { width: 100%; font-family: sans-serif; font-size: 14px; display: block; Margin: 0 auto; background: #fff; max-width: initial; padding: 25px; } body { background: #fff !important; } td, p { font-size: 15px !important; } } @media screen and (min-width: 767px) { .container { max-width: 580px; padding: 8px 25px; width: 580px !important; margin-top: 25px !important; } body { background-color: #f6f6f6 !important; } } </style></head><body style="background-color: #f6f6f6; font-family: sans-serif; -webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.7; margin: 0; padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <div class="container"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;"> <tr> <td><img src="https://vdn.diksha.gov.in/tenant/ntp/logo.png" alt="logo" align="right" width="180" max-width="100%" style="padding-top: 15px;"> </td> </tr> <tr> <td style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin-bottom: 15px;line-height: 1.7;padding:10px 0"> Hi,</td> </tr> <tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal;margin-bottom: 15px;line-height: 1.7;"> This is to inform you that your nomination for the project $orgName has been accepted. You can start contributing content for this project. Please ensure that the content you contribute is relevant to the project needs, is as per the Content Policy and is submitted as per the timelines given in the project details. </p> </td> </tr> <tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin-bottom: 15px;line-height: 1.7;"> All your content will undergo review and will be accepted or rejected based on its relevance and quality. The final decision lies with the project owner. </p> </td> </tr> <tr> <td> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal;line-height: 1.7;"> Regards, </div> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal;margin-bottom: 15px;line-height: 1.7;"> VidyaDaan Team </div> </td> </tr> <tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;line-height: 1.7;"> Note: This is an automatically generated email. Replies to this mailbox will not be monitored. If you are not the intended recipient of this message, or need to communicate with the team, write to <a href="mailto:[email protected]">[email protected]</a> </p> </td> </tr> </table> </div></body></html>')
INSERT INTO sunbird.email_template (name, template)
VALUES ('emailNominationReject', '<!doctype html><head> <meta name="viewport" content="width=device-width"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title></title> <style> @media screen and (min-width: 320px) { .container { width: 100%; font-family: sans-serif; font-size: 14px; display: block; Margin: 0 auto; background: #fff; max-width: initial; padding: 25px; } body { background: #fff !important; } td, p { font-size: 15px !important; } } @media screen and (min-width: 767px) { .container { max-width: 580px; padding: 8px 25px; width: 580px !important; margin-top: 25px !important; } body { background-color: #f6f6f6 !important; } } </style></head><body style="background-color: #f6f6f6; font-family: sans-serif; -webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.7; margin: 0; padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <div class="container"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;"> <tr> <td><img src="https://vdn.diksha.gov.in/tenant/ntp/logo.png" alt="logo" align="right" width="180" max-width="100%" style="padding-top: 15px;"> </td> </tr> <tr> <td style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin-bottom: 15px;line-height: 1.7;padding:10px 0"> Hi,</td> </tr> <tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal;margin-bottom: 15px;line-height: 1.7;"> This is to inform you that your nomination for the project $orgName has not been accepted. Please login to <a href="https://vdn.diksha.gov.in/" target="_blank">https://vdn.diksha.gov.in/</a> for details. </p> </td> </tr> <tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin-bottom: 15px;line-height: 1.7;"> Thank you for your interest. You can nominate yourself / your organisation for other projects that are currently open for nomination, or for future projects. </p> </td> </tr> <tr> <td> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal;line-height: 1.7;"> Regards, </div> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin-bottom: 15px;line-height: 1.7;"> VidyaDaan Team </div> </td> </tr> <tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;line-height: 1.7;"> Note: This is an automatically generated email. Replies to this mailbox will not be monitored. If you are not the intended recipient of this message, or need to communicate with the team, write to <a href="mailto:[email protected]">[email protected]</a> </p> </td> </tr> </table> </div></body></html>')
INSERT INTO sunbird.email_template (name, template)
VALUES ('emailContentRequestedChanges', '<!doctype html> <head> <meta name="viewport" content="width=device-width"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title></title> <style> @media screen and (min-width: 320px) { .container { width: 100%; font-family: sans-serif; font-size: 14px; display: block; Margin: 0 auto; background: #fff; max-width: initial; padding: 25px; } body { background: #fff !important; } td, p { font-size: 15px !important; } } @media screen and (min-width: 767px) { .container { max-width: 580px; padding: 8px 25px; width: 580px !important; margin-top: 25px !important; } body { background-color: #F6F6F6 !important; } } </style> </head> <body style="background-color: #F6F6F6; font-family: sans-serif; -webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.7; margin: 0; padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <div class="container"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;"> <tr> <td><img src="https://vdn.diksha.gov.in/tenant/ntp/logo.png" alt="logo" align="right" width="180" max-width="100%" style="padding-top: 15px;"> </td> </tr> <tr> <td style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin-bottom: 15px;line-height: 1.7;padding:10px 0"> Hi,</td> </tr> <tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal;margin-bottom: 15px;line-height: 1.7;"> This is to inform you that your content $contentName contributed to the project $projectName has not been accepted by your organization upon review. Please login to <a href="https://vdn.diksha.gov.in/">https://vdn.diksha.gov.in/</a> for details. </p> </td> </tr> <tr> <td> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal;line-height: 1.7;"> Regards, </div> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal;margin-bottom: 15px;line-height: 1.7;"> VidyaDaan Team </div> </td> </tr> <tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;line-height: 1.7;"> Note: This is an automatically generated email. Replies to this mailbox will not be monitored. If you are not the intended recipient of this message, or need to communicate with the team, write to <a href="mailto:[email protected]">[email protected]</a> </p> </td> </tr> </table> </div> </body> </html>')
INSERT INTO sunbird.email_template (name, template)
VALUES ('emailContentReject', '<!doctype html> <head> <meta name="viewport" content="width=device-width"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title></title> <style> @media screen and (min-width: 320px) { .container { width: 100%; font-family: sans-serif; font-size: 14px; display: block; Margin: 0 auto; background: #fff; max-width: initial; padding: 25px; } body { background: #fff !important; } td, p { font-size: 15px !important; } } @media screen and (min-width: 767px) { .container { max-width: 580px; padding: 8px 25px; width: 580px !important; margin-top: 25px !important; } body { background-color: #F6F6F6 !important; } } </style> </head> <body style="background-color: #F6F6F6; font-family: sans-serif; -webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.7; margin: 0; padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <div class="container"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;"> <tr> <td><img src="https://vdn.diksha.gov.in/tenant/ntp/logo.png" alt="logo" align="right" width="180" max-width="100%" style="padding-top: 15px;"> </td> </tr> <tr> <td style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin-bottom: 15px;line-height: 1.7;padding:10px 0"> Hi,</td> </tr> <tr> <td> <p> This is to inform you that your content $contentName contributed to the project $projectName has not been approved by the project owner. Please login to <a href="https://vdn.diksha.gov.in/">https://vdn.diksha.gov.in/</a> for details. </p> </td> </tr> <tr> <td> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal;line-height: 1.7;"> Regards, </div> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal;margin-bottom: 15px;line-height: 1.7;"> VidyaDaan Team </div> </td> </tr> <tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;line-height: 1.7;"> Note: This is an automatically generated email. Replies to this mailbox will not be monitored. If you are not the intended recipient of this message, or need to communicate with the team, write to <a href="mailto:[email protected]">[email protected]</a> </p> </td> </tr> </table> </div> </body> </html>')
INSERT INTO sunbird.email_template (name, template)
VALUES ('emailContentAccept', '<!doctype html> <head> <meta name="viewport" content="width=device-width"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title></title> <style> @media screen and (min-width: 320px) { .container { width: 100%; font-family: sans-serif; font-size: 14px; display: block; Margin: 0 auto; background: #fff; max-width: initial; padding: 25px; } body { background: #fff !important; } td, p { font-size: 15px !important; } } @media screen and (min-width: 767px) { .container { max-width: 580px; padding: 8px 25px; width: 580px !important; margin-top: 25px !important; } body { background-color: #F6F6F6 !important; } } </style> </head> <body style="background-color: #F6F6F6; font-family: sans-serif; -webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.7; margin: 0; padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <div class="container"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;"> <tr> <td><img src="https://vdn.diksha.gov.in/tenant/ntp/logo.png" alt="logo" align="right" width="180" max-width="100%" style="padding-top: 15px;"> </td> </tr> <tr> <td style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin-bottom: 15px;line-height: 1.7;padding:10px 0"> Hi,</td> </tr> <tr> <td> <p> This is to inform you that your content $contentName contributed to the project $projectName has been approved by the project owner. </p> </td> </tr> <tr> <td> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal;line-height: 1.7;"> Regards, </div> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal;margin-bottom: 15px;line-height: 1.7;"> VidyaDaan Team </div> </td> </tr> <tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;line-height: 1.7;"> Note: This is an automatically generated email. Replies to this mailbox will not be monitored. If you are not the intended recipient of this message, or need to communicate with the team, write to <a href="mailto:[email protected]">[email protected]</a> </p> </td> </tr> </table> </div> </body> </html>')
UPDATE sunbird.email_template SET template='<!doctype html><head> <meta name="viewport" content="width=device-width"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title></title> <style>@media screen and (min-width: 320px){.container{width: 100%; font-family: sans-serif; font-size: 14px; display: block; Margin: 0 auto; background: #fff; max-width: initial; padding: 25px;}body{background: #fff !important;}td, p{font-size: 15px !important;}}@media screen and (min-width: 767px){.container{max-width: 580px; padding: 8px 25px; width: 580px !important; margin-top: 25px !important;}body{background-color: #f6f6f6 !important;}}</style></head><body style="background-color: #f6f6f6; font-family: sans-serif; -webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.7; margin: 0; padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <div class="container"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;"> <tr> <td><img src="$baseUrl/tenant/ntp/logo.png" alt="logo" align="right" width="180" max-width="100%" style="padding-top: 15px;"> </td></tr><tr> <td style="font-family:sans-serif;font-size:14px;font-weight:normal;margin-bottom:15px;line-height:1.7;padding:10px 0">Hi,</td></tr><tr> <td> <p style="font-family:sans-serif;font-size:14px;font-weight:normal;margin-bottom:15px;line-height:1.7">This is to inform you that your nomination for the project $projectName has been accepted. You can start contributing content for this project. Please ensure that the content you contribute is relevant to the project needs, is as per the Content Policy and is submitted as per the timelines given in the project details. </p></td></tr><tr> <td> <p style="font-family:sans-serif;font-size:14px;font-weight:normal;margin-bottom:15px;line-height:1.7"> If you are a <strong>contributing organization,</strong> please follow the steps mentioned below to contribute:</p><ul style="font-family:sans-serif;font-size:14px;font-weight:normal;margin-bottom:15px;line-height:1.7"> <li> Step 1: Admin has to invite users of your organization to sign in to the system and assign them the role of contributors and reviewers;<i> Please watch “How to invite contributors and reviewers” video in this link: <a href="$baseUrl/contribute/help" target="_blank">$baseUrl/contribute/help</a></i> </li><li> Step 2: Users with the contributor role will have to upload content; <i>Please watch “How to contribute content as a contributor of an organization” video in this link: <a href="$baseUrl/contribute/help" target="_blank">$baseUrl/contribute/help</a></i> </li><li> Step 3: Users with the reviewer role will have to perform the internal review before the content can be sent for the final review to the sourcing organization;<i> Please watch “How to review content as a reviewer of an organization” video in this link: <a href="$baseUrl/contribute/help" target="_blank">$baseUrl/contribute/help</a></i> </li></ul> <p style="font-family:sans-serif;font-size:14px;font-weight:normal;margin-bottom:15px;line-height:1.7">Contributing organizations are requested to share the above videos with their contributors and reviewers. </p><p style="font-family:sans-serif;font-size:14px;font-weight:normal;margin-bottom:15px;line-height:1.7"> If you are an <strong>individual contributor,</strong> <i>please watch “How to contribute content as a individual contribute” video in this link: <a href="$baseUrl/contribute/help" target="_blank">$baseUrl/contribute/help</a></i> </p></td></tr><tr> <td> <p style="font-family:sans-serif;font-size:14px;font-weight:normal;margin-bottom:15px;line-height:1.7"> All your content will undergo review and will be accepted or rejected based on its relevance and quality. The final decision lies with the project owner. </p></td></tr><tr> <td> <div style="font-family:sans-serif;font-size:14px;font-weight:normal;line-height:1.7"> Regards,</div><div style="font-family:sans-serif;font-size:14px;font-weight:normal;margin-bottom:15px;line-height:1.7">VidyaDaan Team </div></td></tr><tr> <td> <p style="font-family:sans-serif;font-size:14px;font-weight:normal;margin:0;Margin-bottom:15px;line-height:1.7">Note: This is an automatically generated email. Replies to this mailbox will not be monitored. If you are not the intended recipient of this message, or need to communicate with the team, write to <a href="mailto:[email protected]" target="_blank">[email protected]</a> </p></td></tr></tbody> </table> </div></body></html>' WHERE name='emailNominationAccept';
UPDATE sunbird.email_template SET template='<!doctype html><head> <meta name="viewport" content="width=device-width"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title></title> <style>@media screen and (min-width: 320px){.container{width: 100%; font-family: sans-serif; font-size: 14px; display: block; Margin: 0 auto; background: #fff; max-width: initial; padding: 25px;}body{background: #fff !important;}td, p{font-size: 15px !important;}}@media screen and (min-width: 767px){.container{max-width: 580px; padding: 8px 25px; width: 580px !important; margin-top: 25px !important;}body{background-color: #f6f6f6 !important;}}</style></head><body style="background-color: #f6f6f6; font-family: sans-serif; -webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.7; margin: 0; padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <div class="container"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;"> <tr> <td><img src="$baseUrl/tenant/ntp/logo.png" alt="logo" align="right" width="180" max-width="100%" style="padding-top: 15px;"> </td></tr><tr> <td style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin-bottom: 15px;line-height: 1.7;padding:10px 0"> Hi,</td></tr><tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal;margin-bottom: 15px;line-height: 1.7;"> This is to inform you that your nomination for the project $projectName has not been accepted. Please login to <a href="$baseUrl/" target="_blank">$baseUrl/</a> for details. </p></td></tr><tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin-bottom: 15px;line-height: 1.7;"> Thank you for your interest. You can nominate yourself / your organisation for other projects that are currently open for nomination, or for future projects. </p></td></tr><tr> <td> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal;line-height: 1.7;"> Regards, </div><div style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin-bottom: 15px;line-height: 1.7;"> VidyaDaan Team </div></td></tr><tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;line-height: 1.7;"> Note: This is an automatically generated email. Replies to this mailbox will not be monitored. If you are not the intended recipient of this message, or need to communicate with the team, write to <a href="mailto:[email protected]" target="_blank">[email protected]</a> </p></td></tr></table> </div></body></html>' WHERE name='emailNominationReject';
INSERT INTO sunbird.email_template (name, template)
VALUES ('emailContentAcceptWithChanges', '<!doctype html> <head> <meta name="viewport" content="width=device-width"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title></title> <style> @media screen and (min-width: 320px) { .container { width: 100%; font-family: sans-serif; font-size: 14px; display: block; Margin: 0 auto; background: #fff; max-width: initial; padding: 25px; } body { background: #fff !important; } td, p { font-size: 15px !important; } } @media screen and (min-width: 767px) { .container { max-width: 580px; padding: 8px 25px; width: 580px !important; margin-top: 25px !important; } body { background-color: #F6F6F6 !important; } } </style> </head> <body style="background-color: #F6F6F6; font-family: sans-serif; -webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.7; margin: 0; padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <div class="container"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%;"> <tr> <td><img src="https://vdn.diksha.gov.in/tenant/ntp/logo.png" alt="logo" align="right" width="180" max-width="100%" style="padding-top: 15px;"> </td> </tr> <tr> <td style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin-bottom: 15px;line-height: 1.7;padding:10px 0"> Hi,</td> </tr> <tr> <td> <p> This is to inform you that your content $contentName contributed to the project $projectName has been approved by the project owner with few changes. </p> </td> </tr> <tr> <td> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal;line-height: 1.7;"> Regards, </div> <div style="font-family: sans-serif; font-size: 14px; font-weight: normal;margin-bottom: 15px;line-height: 1.7;"> VidyaDaan Team </div> </td> </tr> <tr> <td> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; Margin-bottom: 15px;line-height: 1.7;"> Note: This is an automatically generated email. Replies to this mailbox will not be monitored. If you are not the intended recipient of this message, or need to communicate with the team, write to <a href="mailto:[email protected]">[email protected]</a> </p> </td> </tr> </table> </div> </body> </html>')