ZoeApi/controllers/iyrcController.js

require('../helpers/config');
require('../connections/mysql-server');

const express = require('express');
const router = express.Router();
const bodyParser = require('body-parser');

router.use(bodyParser.urlencoded({
    limit: '10mb',
    extended: true
  }
));
router.use(bodyParser.json({
  limit: '10mb',
  extended: true
}));

// Criar conexão com o banco de dados
var mysqlReference = require('mysql');
var DadosConnection = {
    host: Variables('ip_mysql'),
    user: Variables('user_mysql'),
    password: Variables('password_mysql'),
    database: 'iyrc_2020',
    port: 3306
};
let ConexaoMySQL = mysqlReference.createConnection(DadosConnection);

var routes = function () {

  router.get('/getParticipantes', (req, res) => {
    const SQLQry = `SELECT * FROM participantes;`;
    ConexaoMySQL.query(SQLQry, function (error, results, fields) {
      if (!error && results.length != 0) {
        res.send(JSON.stringify({
            "status": 200,
            "error": error,
            "response": results
        }))
        console.log(req.originalUrl + "/ success 200");
      }
      else {
        res.send(JSON.stringify({
            "status": 500,
            "error": error,
            "response": results
        }))
        console.log(req.originalUrl + "/ error 500");
      }
    })

  })

  router.get('/getParticipantesHTML/:token', (req, res) => {
    const SQLQry = `SELECT pa.*, DATE_FORMAT(pa.insert_date, "%d/%m/%Y") as cadastro, case when (select COUNT(*) from pontuacao p where p.idparticipantes = pa.idparticipantes) > 0 then 'Sim' else 'Não' end as jogou FROM participantes pa ORDER BY pa.idparticipantes DESC;`;
    ConexaoMySQL.query(SQLQry, function (error, results, fields) {
      if (!error && results.length != 0) {
        res.writeHeader(200, {"Content-Type": "text/html; charset=utf-8"});
        res.write('<span>Total:' + results.length + '</span><br>');
        res.write('<table border=1>');
          res.write('<th>Data</th>');
          res.write('<th>Nome</th>');
          res.write('<th>Responsável</th>');
          res.write('<th>E-Mail</th>');
          res.write('<th>Telefone</th>');
          res.write('<th>Estado</th>');
          res.write('<th>Cidade</th>');
          res.write('<th>Instagram</th>');
          res.write('<th>Jogou</th>');
          results.forEach((result) => {
              res.write('<tr>');
                res.write('<td>' + result.cadastro + '</td>');
                res.write('<td>' + result.nome + '</td>');
                res.write('<td>' + result.responsavel + '</td>');
                res.write('<td>' + result.email + '</td>');
                res.write('<td>' + result.telefone + '</td>');
                res.write('<td>' + result.estado + '</td>');
                res.write('<td>' + result.cidade + '</td>');
                res.write('<td>' + result.instagram + '</td>');
                res.write('<td>' + result.jogou + '</td>');
              res.write('</tr>');
          });
        res.write('</table>');
        res.end();
        console.log(req.originalUrl + "/ success 200");
      }
      else {
        res.send(JSON.stringify({
            "status": 500,
            "error": error,
            "response": results
        }))
        console.log(req.originalUrl + "/ error 500");
      }
    })

  })

  router.get('/getParticipanteByid/:idparticipantes', (req, res) => {
    var idparticipantes = req.params.idparticipantes;

    const SQLQry = `SELECT * FROM participantes WHERE idparticipantes = ${idparticipantes};`;
    ConexaoMySQL.query(SQLQry, function (error, results, fields) {
      if (!error && results.length != 0) {
        res.send(JSON.stringify({
            "status": 200,
            "error": error,
            "response": results
        }))
        console.log(req.originalUrl + "/ success 200");
      }
      else {
        res.send(JSON.stringify({
            "status": 500,
            "error": error,
            "response": results
        }))
        console.log(req.originalUrl + "/ error 500");
      }
    })
  })

  router.get('/getParticipanteScore/:idparticipantes/:idprovas', (req, res) => {
    var idparticipantes = req.params.idparticipantes;
    var idprovas = req.params.idprovas;

    const SQLQry = `SELECT pa.nome, SUM(po.pontuacao) AS 'pontuacao' FROM participantes pa INNER JOIN pontuacao po ON po.idparticipantes = pa.idparticipantes WHERE pa.idparticipantes = ${idparticipantes} AND po.idprovas = ${idprovas};`;
    ConexaoMySQL.query(SQLQry, function (error, results, fields) {
      if (!error && results.length != 0) {
        res.send(JSON.stringify({
            "status": 200,
            "error": error,
            "response": results
        }))
        console.log(req.originalUrl + "/ success 200");
      }
      else {
        res.send(JSON.stringify({
            "status": 500,
            "error": error,
            "response": results
        }))
        console.log(req.originalUrl + "/ error 500");
      }
    })
  })

  router.post('/insertParticipante', (req, res) => {
    const nome = req.body.nome;
    const responsavel = req.body.responsavel;
    const email = req.body.email;
    const telefone = req.body.telefone;
    const instagram = req.body.instagram;
    const estado = req.body.estado;
    const cidade = req.body.cidade;

    var SQLQry = `SELECT * FROM participantes WHERE email = '${email}';`;
    ConexaoMySQL.query(SQLQry, function (error, results, fields) {
      if (!error && results.length > 0) {
       res.redirect('http://iyrconline.com.br/formulario.html?erro1=email');
      }
      else {

        SQLQry = `INSERT INTO participantes (nome, responsavel, email, telefone, instagram, estado, cidade)
        VALUES ('${nome}', '${responsavel}', '${email}', '${telefone}', '${instagram}', '${estado}', '${cidade}');`;
        ConexaoMySQL.query(SQLQry, function (error, results, fields) {
          if (!error && results.length != 0) {
            EnviarEmail(results['insertId'], nome, email, 0, 0, function(SucessoEmail) {
              EnviarSMS(results['insertId'], telefone, 0, function(SucessoSMS) {
                res.redirect('http://iyrconline.com.br/outform.html');
                console.log(req.originalUrl + "/ success 200");
              });
            });
          }
          else {
            res.send(JSON.stringify({
              "status": 500,
              "error": error,
              "response": results
            }))
            console.log(req.originalUrl + "/ error 500");
          }
        })
      }
    })

  })

  router.post('/insertPontuacao', (req, res) => {
    console.log(req.body);
    const idprovas = req.body.idprovas;
    const idparticipantes = req.body.idparticipantes;
    const pontuacao = req.body.pontuacao;

    var SQLQry = `SELECT * FROM pontuacao WHERE idprovas = ${idprovas} AND idparticipantes = ${idparticipantes};`;
    ConexaoMySQL.query(SQLQry, function (error, results, fields) {
      if (!error && results.length > 0) {
		  	if (results[0]['pontuacao'] < pontuacao) { // A PONTUACAO DO USUARIO E MAIOR QUE A ANTERIOR NESSE JOGO
				SQLQry = `UPDATE pontuacao SET pontuacao = ${pontuacao} WHERE idparticipantes = ${idparticipantes} AND idprovas = ${idprovas};`;
				ConexaoMySQL.query(SQLQry, function (error, results, fields) {
					res.send(JSON.stringify({
						"status": 200,
						"error": error,
						"response": results
					  }))
					  console.log(req.originalUrl + " success 200");
				});
		  	}
		  	else {
				res.send(JSON.stringify({
					"status": 200,
					"error": error,
					"response": results
				  }))
				  console.log(req.originalUrl + " success 200");
		  	}
      }
      else {
        SQLQry = `INSERT INTO pontuacao (idprovas, idparticipantes, pontuacao)
        VALUES (${idprovas}, ${idparticipantes}, ${pontuacao});`;
        ConexaoMySQL.query(SQLQry, function (error, results, fields) {
          if (!error && results.length != 0) {
            /*SQLQry = `SELECT email FROM participantes WHERE idparticipantes = ${idparticipantes};`;
            ConexaoMySQL.query(SQLQry, function (error, results, fields) {
              EnviarEmail(results[0]['idparticipantes'], results[0]['nome'], results[0]['email'], pontuacao, 2, function(Sucesso) {
                console.log("Sucesso");
              })
            })*/
            res.send(JSON.stringify({
              "status": 200,
              "error": error,
              "response": results
            }));
            console.log(req.originalUrl + "/ success 200");
          }
          else {
            res.send(JSON.stringify({
              "status": 500,
              "error": error,
              "response": results
            }))
            console.log(req.originalUrl + "/ error 500");
          }
        })
      }

    })

  })

  router.get('/enviarEMAIL', (req, res) => {
    EnviarEmail(265, 'Heloísa Nogueira Moscati', 'zendionmazinni@gmail.com', 0, 0, function(Sucesso) {
      console.log("OK");
      res.send(Sucesso);
    })
  })

  router.get('/enviarSMS/:idparticipantes/:telefone', (req, res) => {
    let telefone = req.params.telefone;
    let idparticipantes = req.params.idparticipantes;
    EnviarSMS(idparticipantes, telefone, 0);
    res.send(true);
  })

  router.get('/sendMsgToUsers/:op1/:op2', (req, res) => {
    let Quem = req.params.op1;
    let Opcao = req.params.op2;
    var SQLQry = ``;
    if (Quem == 0) { // TODOS OS PARTICIPANTES
      SQLQry = `SELECT * FROM (
        SELECT DISTINCT 
        pa.idparticipantes,
        pa.nome,
        pa.email,
        pa.telefone,
        CASE WHEN po.idparticipantes = pa.idparticipantes THEN 'Sim' ELSE 'Não' END AS 'Jogou'
        FROM participantes pa
        LEFT JOIN pontuacao po
        ON pa.idparticipantes = po.idparticipantes) R;`;
    }
    else if (Quem == 1) { // JA PARTICIPARAM DA PRIMEIRA ETAPA
      SQLQry = `SELECT * FROM (
        SELECT DISTINCT 
        pa.idparticipantes,
        pa.nome,
        pa.email,
        pa.telefone,
        CASE WHEN po.idparticipantes = pa.idparticipantes THEN 'Sim' ELSE 'Não' END AS 'Jogou'
        FROM participantes pa
        LEFT JOIN pontuacao po
        ON pa.idparticipantes = po.idparticipantes) R
        WHERE Jogou = 'Sim';`;
    }
    else if (Quem == 2) { // NAO PARTICIPARAM DA PRIMEIRA ETAPA
      SQLQry = `SELECT * FROM (
        SELECT DISTINCT 
        pa.idparticipantes,
        pa.nome,
        pa.email,
        pa.telefone,
        CASE WHEN po.idparticipantes = pa.idparticipantes THEN 'Sim' ELSE 'Não' END AS 'Jogou'
        FROM participantes pa
        LEFT JOIN pontuacao po
        ON pa.idparticipantes = po.idparticipantes) R
        WHERE Jogou = 'Não';`;
    }
    ConexaoMySQL.query(SQLQry, function (error, results, fields) {
      if (!error && results.length != 0) {
        EnviaMsg(results, 0, Opcao, function(Sucesso) {
          res.send(Sucesso);
          console.log(req.originalUrl + "/ success 200");
        });
      }
      else {
        res.send(false);
        console.log(req.originalUrl + "/ error 500");
      }
    })

  })

  router.post('/getParticipanteScores', (req, res) => {
    var email = req.body.email;

    const SQLQry = `SELECT pa.idparticipantes, pa.nome, COUNT(po.idparticipantes) AS 'participacoes'
	FROM iyrc_2020.participantes pa 
	INNER JOIN iyrc_2020.pontuacao po ON po.idparticipantes = pa.idparticipantes 
	WHERE pa.email = '${email}' group by pa.idparticipantes`;
    ConexaoMySQL.query(SQLQry, function (error, results, fields) {
      if (!error && results.length != 0) {
        res.send(JSON.stringify({
            "status": 200,
            "error": error,
            "response": results
        }))
        console.log(req.originalUrl + "/ success 200");
      }
      else {
        res.send(JSON.stringify({
            "status": 500,
            "error": error,
            "response": results
        }))
        console.log(req.originalUrl + "/ error 500");
      }
    })
  })

  return router;
};

function EnviaMsg(ListaUsuarios, Index, Opcao, callback) {
  if (Index < ListaUsuarios.length) {
    console.log("Participante: " + ListaUsuarios[Index].nome);
    setTimeout(() => {
      EnviarEmail(ListaUsuarios[Index].idparticipantes, ListaUsuarios[Index].nome, ListaUsuarios[Index].email, 0, Opcao, function(SucessoEmail) {
        EnviarSMS(ListaUsuarios[Index].idparticipantes, ListaUsuarios[Index].telefone, Opcao, function(sucessoSMS) {
          Index++;
          EnviaMsg(ListaUsuarios, Index, Opcao, callback);
        });
      });
    }, 1000);
  }
  else {
    callback(true);
  }
}

function EnviarSMS(idparticipantes, telefone, Opcao, callback) {

  if (telefone == null || telefone == '') {
    callback(false);
    return;
  }

  let NumeroRegistro = Math.pow(idparticipantes, 2);

  var mensagem = ``;
  if (Opcao == 0) { // LINK DA PRIMEIRA ETAPA
    mensagem = `"PARABÉNS\r\nAbaixo está o link para disputar seu desafio IYRC!\r\nhttp://iyrconline.com.br/provas.html?${NumeroRegistro}"`;
  }
  else if (Opcao == 1) { // LINK DA SEGUNDA ETAPA
    mensagem = `"Segue o link para disputar a segunda etapa IYRC!\r\nhttp://iyrconline.com.br/provas.html?${NumeroRegistro}"`;
  }
  else if (Opcao == 2) { // PARABENS PRIMEIRA ETAPA
    mensagem = `Sua participação na primeira etapa do Campeonato Internacional de Robótica IYRC 2020 foi registrada!`;
  }
  else if (Opcao == 3) { // FALTA 1 DIA PARA SEGUNDA ETAPA
    mensagem = `Falta 1 dia para a segunda etapa do Campeonato Internacional de Robótica IYRC 2020!`;
  }
  else if (Opcao == 4) { // FALTAM 3 DIAS PARA A ETAPA FINAL
    mensagem = `Faltam 3 dias para a etapa final do Campeonato Internacional de Robótica IYRC 2020!`;
  }
  else if (Opcao == 5) { // FALTAM 2 DIAS PARA A ETAPA FINAL
    mensagem = `Faltam 2 dias para a etapa final do Campeonato Internacional de Robótica IYRC 2020!`;
  }
  else if (Opcao == 6) { // FALTA 1 DIA PARA A ETAPA FINAL
    mensagem = `Falta 1 dia para a etapa final do Campeonato Internacional de Robótica IYRC 2020!`;
  }
  else if (Opcao == 7) { // MUDANCA DATA DA ETAPA FINAL
    mensagem = `Fique atento! A data da etapa final do Campeonato Internacional de Robótica IYRC 2020 foi alterada para o dia 13/06/2020!`;
  }

  let url = `http://www.facilitamovel.com.br/api/messagesPhonesMultipleSend.ft?user=myrobot&password=3498567&destinatario=${telefone}&msg=${encodeURI(mensagem)};`//Sua URL
  
  /*var XMLHttpRequest = require("xmlhttprequest").XMLHttpRequest;
  let xhttp = new XMLHttpRequest();
  xhttp.open("GET", url, false);
  xhttp.send();*/

  const http = require('http');
  http.get(url, (resp) => {
    let data = '';
    resp.on('data', (chunk) => {
      data += chunk;
    });
    resp.on('end', () => {
      let Sucesso = false;
      if (data.includes('Usuario sem Creditos')) {
        console.log("ERRO AO ENVIAR SMS PARA: " + telefone + " - " + data);
        Sucesso = false;
      }
      else {
        console.log("SMS ENVIADO COM SUCESSO PARA: " + telefone + " - " + data);
        Sucesso = true;
      }
      callback(Sucesso);
    });
  }).on("error", (err) => {
    console.log("error: " + err);
    callback(false);
  });

  //console.log(url);
}

function EnviarEmail(idparticipantes, nome, email, pontuacao, Opcao, callback) {

  if (email == null || email == '') {
    callback(false);
    return;
  }

  const request = require('request');

  let NumeroRegistro = Math.pow(idparticipantes, 2);
  let Texto = ``;
  if (Opcao == 0) { // LINK DA PRIMIERA ETAPA
    Texto = CriarTextoEmail_Etapa1(nome, NumeroRegistro);
  }
  else if (Opcao == 1) { // LINK DA SEGUNDA ETAPA
    Texto = CriarTextoEmail_Etapa2(NumeroRegistro);
  }
  else if (Opcao == 2) { // PARABENS PRIMEIRA ETAPA
    Texto = CriarTextoEmail_Parabens(pontuacao);
  }
  else if (Opcao == 3) { // FALTA 1 DIA PARA SEGUNDA ETAPA
    Texto = CriarTextoEmail_Falta1DiaEtapa2();
  }
  else if (Opcao == 4) { // FALTA 2 DIAS PARA ETAPA FINAL
    Texto = CriarTextoEmail_Falta3DiasEtapaFinal();
  }
  else if (Opcao == 5) { // FALTA 2 DIAS PARA ETAPA FINAL
    Texto = CriarTextoEmail_Falta2DiasEtapaFinal();
  }
  else if (Opcao == 6) { // FALTA 2 DIAS PARA ETAPA FINAL
    Texto = CriarTextoEmail_Falta1DiaEtapaFinal();
  }
  else if (Opcao == 7) { // MUDANCA DA DATA DA ETAPA FINAL
    Texto = CriarTextoEmail_MudancaDataFinal();
  }

  request.post('http://18.228.91.135:3337/api/email/send', {
    json: {
      from: 'iyrconline@myrobot.com.br',
      to: email,
      subject: "Etapa Online do Campeonato Internacional de Robótica IYRC",
      text: Texto
    }
  }, function (error, response, body) {
      if (!error && response.statusCode == 200) {
        console.log("Sucesso ao enviar e-mail!");
        //callback(true);
      }
      else {
        console.log("Falha ao enviar e-mail!");
        //callback(false);
      }
    }
  );
  callback(true);
}

function CriarTextoEmail_Etapa1(Nome, NumeroRegistro) {

  return `<div style="background-color:#f7f7f7">
    <div style="margin:0px auto;max-width:600px">
      <table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
        <tbody>
          <tr>
            <td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
          </tr>
        </tbody>
      </table>
    </div>
    <div style="border:1px solid #d9d9d9;background:white;background-color:white;margin:0px auto;max-width:600px">
      <table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="background:white;background-color:white;width:100%">
        <tbody>
          <tr>
            <td style="direction:ltr;font-size:0px;padding:0px 0;padding-bottom:30px;text-align:center">
              <div style="margin:0px auto;max-width:600px">
                <table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
                  <tbody>
                    <tr>
                      <td style="direction:ltr;font-size:0px;padding:0;padding-left:0;padding-right:0;text-align:center">
                        <div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
                          <table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
                            <tbody>
                              <tr>
                                <td align="center" style="font-size:0px;padding:0 0;word-break:break-word">
                                  <table border="0" cellpadding="0" cellspacing="0" role="presentation" style="border-collapse:collapse;border-spacing:0px">
                                    <tbody>
                                      <tr>
                                        <td style="width:600px">
                                          <img height="auto" src="http://18.228.91.135/iyrc/img/banner.png" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0">
                                          <div class="a6S" dir="ltr" style="opacity: 0.01; left: 677.5px; top: 180px;">
                                            <div id=":173" class="T-I J-J5-Ji aQv T-I-ax7 L3 a5q" role="button" tabindex="0" aria-label="Fazer o download do anexo " data-tooltip-class="a1V" data-tooltip="Fazer o download">
                                              <div class="aSK J-J5-Ji aYr"></div>
                                            </div>
                                          </div>
                                        </td>
                                      </tr>
                                    </tbody>
                                  </table>
                                </td>
                              </tr>
                            </tbody>
                          </table>
                        </div>
                      </td>
                    </tr>
                  </tbody>
                </table>
              </div>
              <div style="margin:0px auto;max-width:600px">
                <table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
                  <tbody>
                    <tr>
                      <td style="direction:ltr;font-size:0px;padding:40px 40px 0 40px;padding-left:40px;padding-right:40px;text-align:center">
                        <div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
                          <table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
                            <tbody>
                              <tr>
                                <td align="center" style="font-size:0px;padding:0px;word-break:break-word">
                                  <div style="font-family:sans-serif;font-size:22px;line-height:250%;text-align:center;color:#6f34fa"><strong>PARABÉNS, VOCÊ ESTÁ INSCRITO!</strong>
                                  </div>
                                </td>
                              </tr>
                              <tr>
                                <td align="center" style="font-size:0px;padding:0px;word-break:break-word">
                                  <div style="font-family:sans-serif;font-size:22px;line-height:250%;text-align:center;color:#6f34fa"><strong>Olá, <span id="userName">${Nome}</span>!</strong>
                                  </div>
                                </td>
                              </tr>
                              <tr>
                                <td align="center" style="font-size:0px;padding:0px;padding-bottom:20px;word-break:break-word">
                                  <div style="font-family:sans-serif;font-size:16px;line-height:150%;text-align:center;color:#383838">Seu cadastro na <strong>Etapa Online do Campeonato Internacional de Robótica IYRC</strong> foi realizado com sucesso!
                                    <br>
                                        <br>Abaixo está o link para seu ambiente online de competição, onde poderá disputar seu desafio!
                                        <br>
                                        <br>
                                        <a style="font-family:sans-serif;font-size:16px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="http://iyrconline.com.br/provas.html?${NumeroRegistro}">Clique aqui para ser direcionado ao seu ambiente de competição</a>
                                        <br>
                                        <br><strong>Boa sorte e bom game!</strong>
                                    </div>
                                </td>
                              </tr>
                            </tbody>
                          </table>
                        </div>
                      </td>
                    </tr>
                  </tbody>
                </table>
              </div>					
            </td>
          </tr>
        </tbody>
      </table>
      </div>
      <div style="margin:0px auto;max-width:600px">
      <table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
        <tbody>
          <tr>
            <td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
          </tr>
        </tbody>
      </table>
    </div>
  </div>`;
}

function CriarTextoEmail_Parabens(Pontuacao) {

  return `<div style="background-color:#f7f7f7">
	<div style="margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
				</tr>
			</tbody>
		</table>
	</div>
	<div style="border:1px solid #d9d9d9;background:white;background-color:white;margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="background:white;background-color:white;width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:0px 0;padding-bottom:30px;text-align:center">
						<div style="margin:0px auto;max-width:600px">
							<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
								<tbody>
									<tr>
										<td style="direction:ltr;font-size:0px;padding:0;padding-left:0;padding-right:0;text-align:center">
											<div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
												<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
													<tbody>
														<tr>
															<td align="center" style="font-size:0px;padding:0 0;word-break:break-word">
																<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="border-collapse:collapse;border-spacing:0px">
																	<tbody>
																		<tr>
																			<td style="width:600px">
																				<img height="auto" src="http://18.228.91.135/iyrc/img/banner.png" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0">
																				<div class="a6S" dir="ltr" style="opacity: 0.01; left: 677.5px; top: 180px;">
																					<div id=":173" class="T-I J-J5-Ji aQv T-I-ax7 L3 a5q" role="button" tabindex="0" aria-label="Fazer o download do anexo " data-tooltip-class="a1V" data-tooltip="Fazer o download">
																						<div class="aSK J-J5-Ji aYr"></div>
																					</div>
																				</div>
																			</td>
																		</tr>
																	</tbody>
																</table>
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>
									</tr>
								</tbody>
							</table>
						</div>
						<div style="margin:0px auto;max-width:600px">
							<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
								<tbody>
									<tr>
										<td style="direction:ltr;font-size:0px;padding:40px 40px 0 40px;padding-left:40px;padding-right:40px;text-align:center">
											<div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
												<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
													<tbody>
														<tr>
															<td align="center" style="font-size:0px;padding:0px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:22px;line-height:150%;text-align:center;color:#6f34fa"><strong>VOC&Ecirc; FOI CLASSIFICADO PARA A 2&#170; ETAPA ONLINE DA IYRC!</strong>
																</div>
															</td>
														</tr>
														
														<tr>
															<td align="center" style="font-size:0px;padding:0px;padding-bottom:20px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:16px;line-height:150%;text-align:center;color:#383838">
																	Isso mostra que voc&eacute; est&aacute; se preparando para o campeonato presencial, mas ainda faltam 2 etapas. Voc&ecirc; consegue!
																	<br><br>
																	<strong>Sua pontua&ccedil;&atilde;o: <br> ${Pontuacao}</strong><br>
																	<img height="auto" src="http://18.228.91.135/iyrc/img/parabens-etapa-2.jpeg" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0" />
																	<br>
                                                                    <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="https://g1.globo.com/sp/piracicaba-regiao/noticia/2019/10/26/piracicaba-recebe-etapa-de-campeonato-internacional-de-robotica-ate-domingo.ghtml" target="_blank">Confira mat&eacute;ria no site G1 da Globo sobre a etapa nacional de 2019</a>
                                                                    <br><br>
                                                                    <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="http://www.camaracharqueada.sp.gov.br/Noticia/Visualizar/4072" target="_blank">Mat&eacute;ria com alunos de escola p&uacute;blica na etapa nacional da competi&ccedil;&atilde;o</a>
                                                                    <br>
                                                                    
                                                                </div>
															</td>
														</tr>
														<tr>
															<td align="center" style="font-size:0px;padding:0px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:22px;line-height:250%;text-align:center;color:#6f34fa">
																	<strong>ATEN&Ccedil;&Atilde;O!<br>
																	O PR&Oacute;XIMO DESAFIO ACONTECE EM:</strong>
																</div>
																<img src="http://gen.sendtric.com/countdown/g1yqux3pir" style="display: block;" />	
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>
									</tr>
								</tbody>
							</table>
						</div>					
					</td>
				</tr>
			</tbody>
		</table>
    </div>
    <div style="margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
				</tr>
			</tbody>
		</table>
	</div>
</div>`;
}

function CriarTextoEmail_Etapa2(NumeroRegistro) {
  return `<div style="background-color:#f7f7f7">
	<div style="margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
				</tr>
			</tbody>
		</table>
	</div>
	<div style="border:1px solid #d9d9d9;background:white;background-color:white;margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="background:white;background-color:white;width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:0px 0;padding-bottom:30px;text-align:center">
						<div style="margin:0px auto;max-width:600px">
							<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
								<tbody>
									<tr>
										<td style="direction:ltr;font-size:0px;padding:0;padding-left:0;padding-right:0;text-align:center">
											<div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
												<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
													<tbody>
														<tr>
															<td align="center" style="font-size:0px;padding:0 0;word-break:break-word">
																<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="border-collapse:collapse;border-spacing:0px">
																	<tbody>
																		<tr>
																			<td style="width:600px">
																				<img height="auto" src="http://18.228.91.135/iyrc/img/banner.png" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0">
																				<div class="a6S" dir="ltr" style="opacity: 0.01; left: 677.5px; top: 180px;">
																					<div id=":173" class="T-I J-J5-Ji aQv T-I-ax7 L3 a5q" role="button" tabindex="0" aria-label="Fazer o download do anexo " data-tooltip-class="a1V" data-tooltip="Fazer o download">
																						<div class="aSK J-J5-Ji aYr"></div>
																					</div>
																				</div>
																			</td>
																		</tr>
																	</tbody>
																</table>
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>
									</tr>
								</tbody>
							</table>
						</div>
						<div style="margin:0px auto;max-width:600px">
							<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
								<tbody>
									<tr>
										<td style="direction:ltr;font-size:0px;padding:40px 40px 0 40px;padding-left:40px;padding-right:40px;text-align:center">
											<div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
												<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
													<tbody>
														<tr>
															<td align="center" style="font-size:0px;padding:0px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:22px;line-height:150%;text-align:center;color:#6f34fa"><strong>VOC&Ecirc; EST&Aacute; PREPARADO?</strong>
																</div>
															</td>
														</tr>
														
														<tr>
															<td align="center" style="font-size:0px;padding:0px;padding-bottom:20px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:16px;line-height:150%;text-align:center;color:#383838">
																	&Eacute; hoje, S&aacute;bado, das 0h às 24h a segunda etapa do desafio online! S&atilde;o 5 mini games, tire a maior pontua&ccedil;&atilde;o e garanta sua vaga para a final que ser&aacute; transmitida em uma super live!
																	<br><br>

                                                                    <a style="font-family:sans-serif;font-size:22px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="http://iyrconline.com.br/provas.html?${NumeroRegistro}">Clique aqui para ser direcionado ao <br>seu ambiente de competi&ccedil;&atilde;o</a>
                                                                    <br><br><br>
																	
                                                                    <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="https://g1.globo.com/sp/piracicaba-regiao/noticia/2019/10/26/piracicaba-recebe-etapa-de-campeonato-internacional-de-robotica-ate-domingo.ghtml" target="_blank">Confira mat&eacute;ria no site G1 da Globo sobre a etapa nacional de 2019</a>
                                                                    <br><br>
                                                                    <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="http://www.camaracharqueada.sp.gov.br/Noticia/Visualizar/4072" target="_blank">Mat&eacute;ria com alunos de escola p&uacute;blica na etapa nacional da competi&ccedil;&atilde;o</a>
                                                                    <br>
                                                                    
                                                                </div>
															</td>
														</tr>
														<tr>
															<td align="center" style="font-size:0px;padding:0px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:22px;line-height:250%;text-align:center;color:#6f34fa">
																	<strong>ATEN&Ccedil;&Atilde;O!<br>
																	A FINAL ACONTECE EM:</strong>
																</div>
																<img src="http://gen.sendtric.com/countdown/bx6duyoyo9" style="display: block;" />	
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>
									</tr>
								</tbody>
							</table>
						</div>					
					</td>
				</tr>
			</tbody>
		</table>
    </div>
    <div style="margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
				</tr>
			</tbody>
		</table>
	</div>
</div>`;
}

function CriarTextoEmail_Falta1DiaEtapa2() {
  return `<div style="background-color:#f7f7f7">
	<div style="margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
				</tr>
			</tbody>
		</table>
	</div>
	<div style="border:1px solid #d9d9d9;background:white;background-color:white;margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="background:white;background-color:white;width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:0px 0;padding-bottom:30px;text-align:center">
						<div style="margin:0px auto;max-width:600px">
							<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
								<tbody>
									<tr>
										<td style="direction:ltr;font-size:0px;padding:0;padding-left:0;padding-right:0;text-align:center">
											<div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
												<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
													<tbody>
														<tr>
															<td align="center" style="font-size:0px;padding:0 0;word-break:break-word">
																<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="border-collapse:collapse;border-spacing:0px">
																	<tbody>
																		<tr>
																			<td style="width:600px">
																				<img height="auto" src="http://18.228.91.135/iyrc/img/banner.png" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0">
																				<div class="a6S" dir="ltr" style="opacity: 0.01; left: 677.5px; top: 180px;">
																					<div id=":173" class="T-I J-J5-Ji aQv T-I-ax7 L3 a5q" role="button" tabindex="0" aria-label="Fazer o download do anexo " data-tooltip-class="a1V" data-tooltip="Fazer o download">
																						<div class="aSK J-J5-Ji aYr"></div>
																					</div>
																				</div>
																			</td>
																		</tr>
																	</tbody>
																</table>
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>
									</tr>
								</tbody>
							</table>
						</div>
						<div style="margin:0px auto;max-width:600px">
							<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
								<tbody>
									<tr>
										<td style="direction:ltr;font-size:0px;padding:40px 40px 0 40px;padding-left:40px;padding-right:40px;text-align:center">
											<div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
												<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
													<tbody>
														<tr>
															<td align="center" style="font-size:0px;padding:0px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:22px;line-height:150%;text-align:center;color:#6f34fa"><strong>FALTA APENAS 1 DIA PARA <br>A PR&Oacute;XIMA ETAPA!</strong>
																</div>
															</td>
														</tr>
														
														<tr>
															<td align="center" style="font-size:0px;padding:0px;padding-bottom:20px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:16px;line-height:150%;text-align:center;color:#383838">
																	
																	
																	<img height="auto" src="http://18.228.91.135/iyrc/img/1-dia-second.png" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0" />
																	</a>
																	<br>
                                  &Eacute; amanh&atilde;, S&aacute;bado, das 0h às 24h a segunda etapa do desafio online! S&atilde;o 5 mini games, tire a maior pontua&ccedil;&atilde;o e garanta sua vaga para a final que ser&aacute; transmitida em uma super live!
																	<br><br>

                                                                    <br>
																	
                                                                    <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="https://g1.globo.com/sp/piracicaba-regiao/noticia/2019/10/26/piracicaba-recebe-etapa-de-campeonato-internacional-de-robotica-ate-domingo.ghtml" target="_blank">Confira mat&eacute;ria no site G1 da Globo sobre a etapa nacional de 2019</a>
                                                                    <br><br>
                                                                    <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="http://www.camaracharqueada.sp.gov.br/Noticia/Visualizar/4072" target="_blank">Mat&eacute;ria com alunos de escola p&uacute;blica na etapa nacional da competi&ccedil;&atilde;o</a>
                                                                    <br>
                                                                    
                                                                </div>
															</td>
														</tr>
														<tr>
															<td align="center" style="font-size:0px;padding:0px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:22px;line-height:250%;text-align:center;color:#6f34fa">
																	<strong>ATEN&Ccedil;&Atilde;O!<br>
																	O PR&Oacute;XIMO DESAFIO ACONTECE EM:</strong>
																</div>
																<img src="http://gen.sendtric.com/countdown/g1yqux3pir" style="display: block;" />	
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>
									</tr>
								</tbody>
							</table>
						</div>					
					</td>
				</tr>
			</tbody>
		</table>
    </div>
    <div style="margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
				</tr>
			</tbody>
		</table>
	</div>
</div>`;
}

function CriarTextoEmail_Falta3DiasEtapaFinal() {
  return `<div style="background-color:#f7f7f7">
	<div style="margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
				</tr>
			</tbody>
		</table>
	</div>
	<div style="border:1px solid #d9d9d9;background:white;background-color:white;margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="background:white;background-color:white;width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:0px 0;padding-bottom:30px;text-align:center">
						<div style="margin:0px auto;max-width:600px">
							<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
								<tbody>
									<tr>
										<td style="direction:ltr;font-size:0px;padding:0;padding-left:0;padding-right:0;text-align:center">
											<div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
												<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
													<tbody>
														<tr>
															<td align="center" style="font-size:0px;padding:0 0;word-break:break-word">
																<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="border-collapse:collapse;border-spacing:0px">
																	<tbody>
																		<tr>
																			<td style="width:600px">
																				<img height="auto" src="https://i.ibb.co/cvH9Djf/banner.png" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0">
																				<div class="a6S" dir="ltr" style="opacity: 0.01; left: 677.5px; top: 180px;">
																					<div id=":173" class="T-I J-J5-Ji aQv T-I-ax7 L3 a5q" role="button" tabindex="0" aria-label="Fazer o download do anexo " data-tooltip-class="a1V" data-tooltip="Fazer o download">
																						<div class="aSK J-J5-Ji aYr"></div>
																					</div>
																				</div>
																			</td>
																		</tr>
																	</tbody>
																</table>
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>
									</tr>
								</tbody>
							</table>
						</div>
						<div style="margin:0px auto;max-width:600px">
							<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
								<tbody>
									<tr>
										<td style="direction:ltr;font-size:0px;padding:40px 40px 0 40px;padding-left:40px;padding-right:40px;text-align:center">
											<div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
												<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
													<tbody>
														<tr>
															<td align="center" style="font-size:0px;padding:0px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:22px;line-height:150%;text-align:center;color:#6f34fa"><strong>FALTAM APENAS 3 DIAS PARA <br>A ETAPA FINAL!</strong>
																</div>
															</td>
														</tr>
														
														<tr>
															<td align="center" style="font-size:0px;padding:0px;padding-bottom:20px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:16px;line-height:150%;text-align:center;color:#383838">
																	
																	
																	<img height="auto" src="https://i.ibb.co/HDQY9Zt/3-dias-final.png" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0" />
																	</a>
																	<br>
                                                                    <br>Al&eacute;m de uma super oportunidade de estar entre os melhores da <strong>Rob&oacute;tica Mundial</strong>, no evento presencial ocorrem diversas premia&ccedil;&otilde;es.
                                                                    <br>
                                                                    <br>Prepare-se para estar com a gente nessa super competi&ccedil;&atilde;o!
                                                                    <br>
                                                                    <br>
                                                                     <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="https://g1.globo.com/sp/piracicaba-regiao/noticia/2019/10/26/piracicaba-recebe-etapa-de-campeonato-internacional-de-robotica-ate-domingo.ghtml" target="_blank">Confira mat&eacute;ria no site G1 da Globo sobre a etapa nacional de 2019</a>
                                                                    <br><br>
                                                                    <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="http://www.camaracharqueada.sp.gov.br/Noticia/Visualizar/4072" target="_blank">Mat&eacute;ria com alunos de escola p&uacute;blica na etapa nacional da competi&ccedil;&atilde;o</a>
                                                                    <br>
                                                                    
                                                                </div>
															</td>
														</tr>
														<tr>
															<td align="center" style="font-size:0px;padding:0px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:22px;line-height:250%;text-align:center;color:#6f34fa"><strong>ATEN&Ccedil;&Atilde;O! O DESAFIO FINAL ACONTECE EM:</strong>
																</div>
																<img src="http://gen.sendtric.com/countdown/bx6duyoyo9" style="display: block;" />	
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>
									</tr>
								</tbody>
							</table>
						</div>					
					</td>
				</tr>
			</tbody>
		</table>
    </div>
    <div style="margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
				</tr>
			</tbody>
		</table>
	</div>
</div>`;
}

function CriarTextoEmail_Falta2DiasEtapaFinal() {
  return `<div style="background-color:#f7f7f7">
	<div style="margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
				</tr>
			</tbody>
		</table>
	</div>
	<div style="border:1px solid #d9d9d9;background:white;background-color:white;margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="background:white;background-color:white;width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:0px 0;padding-bottom:30px;text-align:center">
						<div style="margin:0px auto;max-width:600px">
							<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
								<tbody>
									<tr>
										<td style="direction:ltr;font-size:0px;padding:0;padding-left:0;padding-right:0;text-align:center">
											<div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
												<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
													<tbody>
														<tr>
															<td align="center" style="font-size:0px;padding:0 0;word-break:break-word">
																<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="border-collapse:collapse;border-spacing:0px">
																	<tbody>
																		<tr>
																			<td style="width:600px">
																				<img height="auto" src="https://i.ibb.co/cvH9Djf/banner.png" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0">
																				<div class="a6S" dir="ltr" style="opacity: 0.01; left: 677.5px; top: 180px;">
																					<div id=":173" class="T-I J-J5-Ji aQv T-I-ax7 L3 a5q" role="button" tabindex="0" aria-label="Fazer o download do anexo " data-tooltip-class="a1V" data-tooltip="Fazer o download">
																						<div class="aSK J-J5-Ji aYr"></div>
																					</div>
																				</div>
																			</td>
																		</tr>
																	</tbody>
																</table>
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>
									</tr>
								</tbody>
							</table>
						</div>
						<div style="margin:0px auto;max-width:600px">
							<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
								<tbody>
									<tr>
										<td style="direction:ltr;font-size:0px;padding:40px 40px 0 40px;padding-left:40px;padding-right:40px;text-align:center">
											<div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
												<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
													<tbody>
														<tr>
															<td align="center" style="font-size:0px;padding:0px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:22px;line-height:150%;text-align:center;color:#6f34fa"><strong>FALTAM APENAS 2 DIAS PARA <br>A ETAPA FINAL!</strong>
																</div>
															</td>
														</tr>
														
														<tr>
															<td align="center" style="font-size:0px;padding:0px;padding-bottom:20px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:16px;line-height:150%;text-align:center;color:#383838">
																	
																	
																	<img height="auto" src="http://18.228.91.135/iyrc/img/faltam_2_dias.jpeg" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0" />
																	</a>
																	<br>
                                                                    <br>Al&eacute;m de uma super oportunidade de estar entre os melhores da <strong>Rob&oacute;tica Mundial</strong>, no evento presencial ocorrem diversas premia&ccedil;&otilde;es.
                                                                    <br>
                                                                    <br>Prepare-se para estar com a gente nessa super competi&ccedil;&atilde;o!
                                                                    <br>
                                                                    <br>
                                                                     <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="https://g1.globo.com/sp/piracicaba-regiao/noticia/2019/10/26/piracicaba-recebe-etapa-de-campeonato-internacional-de-robotica-ate-domingo.ghtml" target="_blank">Confira mat&eacute;ria no site G1 da Globo sobre a etapa nacional de 2019</a>
                                                                    <br><br>
                                                                    <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="http://www.camaracharqueada.sp.gov.br/Noticia/Visualizar/4072" target="_blank">Mat&eacute;ria com alunos de escola p&uacute;blica na etapa nacional da competi&ccedil;&atilde;o</a>
                                                                    <br>
                                                                    
                                                                </div>
															</td>
														</tr>
														<tr>
															<td align="center" style="font-size:0px;padding:0px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:22px;line-height:250%;text-align:center;color:#6f34fa"><strong>ATEN&Ccedil;&Atilde;O! O DESAFIO FINAL ACONTECE EM:</strong>
																</div>
																<img src="http://gen.sendtric.com/countdown/bx6duyoyo9" style="display: block;" />	
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>
									</tr>
								</tbody>
							</table>
						</div>					
					</td>
				</tr>
			</tbody>
		</table>
    </div>
    <div style="margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
				</tr>
			</tbody>
		</table>
	</div>
</div>`;
}

function CriarTextoEmail_Falta1DiaEtapaFinal() {
  return `<div style="background-color:#f7f7f7">
	<div style="margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
				</tr>
			</tbody>
		</table>
	</div>
	<div style="border:1px solid #d9d9d9;background:white;background-color:white;margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="background:white;background-color:white;width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:0px 0;padding-bottom:30px;text-align:center">
						<div style="margin:0px auto;max-width:600px">
							<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
								<tbody>
									<tr>
										<td style="direction:ltr;font-size:0px;padding:0;padding-left:0;padding-right:0;text-align:center">
											<div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
												<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
													<tbody>
														<tr>
															<td align="center" style="font-size:0px;padding:0 0;word-break:break-word">
																<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="border-collapse:collapse;border-spacing:0px">
																	<tbody>
																		<tr>
																			<td style="width:600px">
																				<img height="auto" src="https://i.ibb.co/cvH9Djf/banner.png" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0">
																				<div class="a6S" dir="ltr" style="opacity: 0.01; left: 677.5px; top: 180px;">
																					<div id=":173" class="T-I J-J5-Ji aQv T-I-ax7 L3 a5q" role="button" tabindex="0" aria-label="Fazer o download do anexo " data-tooltip-class="a1V" data-tooltip="Fazer o download">
																						<div class="aSK J-J5-Ji aYr"></div>
																					</div>
																				</div>
																			</td>
																		</tr>
																	</tbody>
																</table>
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>
									</tr>
								</tbody>
							</table>
						</div>
						<div style="margin:0px auto;max-width:600px">
							<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
								<tbody>
									<tr>
										<td style="direction:ltr;font-size:0px;padding:40px 40px 0 40px;padding-left:40px;padding-right:40px;text-align:center">
											<div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
												<table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
													<tbody>
														<tr>
															<td align="center" style="font-size:0px;padding:0px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:22px;line-height:150%;text-align:center;color:#6f34fa"><strong>FALTA APENAS 1 DIA PARA <br>A ETAPA FINAL!</strong>
																</div>
															</td>
														</tr>
														
														<tr>
															<td align="center" style="font-size:0px;padding:0px;padding-bottom:20px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:16px;line-height:150%;text-align:center;color:#383838">
																	
																	
																	<img height="auto" src="http://18.228.91.135/iyrc/img/falta_1_dia.jpeg" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0" />
																	</a>
																	<br>
                                                                    <br>Al&eacute;m de uma super oportunidade de estar entre os melhores da <strong>Rob&oacute;tica Mundial</strong>, no evento presencial ocorrem diversas premia&ccedil;&otilde;es.
                                                                    <br>
                                                                    <br>Prepare-se para estar com a gente nessa super competi&ccedil;&atilde;o!
                                                                    <br>
                                                                    <br>
                                                                     <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="https://g1.globo.com/sp/piracicaba-regiao/noticia/2019/10/26/piracicaba-recebe-etapa-de-campeonato-internacional-de-robotica-ate-domingo.ghtml" target="_blank">Confira mat&eacute;ria no site G1 da Globo sobre a etapa nacional de 2019</a>
                                                                    <br><br>
                                                                    <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="http://www.camaracharqueada.sp.gov.br/Noticia/Visualizar/4072" target="_blank">Mat&eacute;ria com alunos de escola p&uacute;blica na etapa nacional da competi&ccedil;&atilde;o</a>
                                                                    <br>
                                                                    
                                                                </div>
															</td>
														</tr>
														<tr>
															<td align="center" style="font-size:0px;padding:0px;word-break:break-word">
																<div style="font-family:sans-serif;font-size:22px;line-height:250%;text-align:center;color:#6f34fa"><strong>ATEN&Ccedil;&Atilde;O! O DESAFIO FINAL ACONTECE EM:</strong>
																</div>
																<img src="http://gen.sendtric.com/countdown/bx6duyoyo9" style="display: block;" />	
															</td>
														</tr>
													</tbody>
												</table>
											</div>
										</td>
									</tr>
								</tbody>
							</table>
						</div>					
					</td>
				</tr>
			</tbody>
		</table>
    </div>
    <div style="margin:0px auto;max-width:600px">
		<table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
			<tbody>
				<tr>
					<td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
				</tr>
			</tbody>
		</table>
	</div>
</div>`;
}

function CriarTextoEmail_MudancaDataFinal() {
  return `<div style="background-color:#f7f7f7">
  <div style="margin:0px auto;max-width:600px">
	  <table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
		  <tbody>
			  <tr>
				  <td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
			  </tr>
		  </tbody>
	  </table>
  </div>
  <div style="border:1px solid #d9d9d9;background:white;background-color:white;margin:0px auto;max-width:600px">
	  <table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="background:white;background-color:white;width:100%">
		  <tbody>
			  <tr>
				  <td style="direction:ltr;font-size:0px;padding:0px 0;padding-bottom:30px;text-align:center">
					  <div style="margin:0px auto;max-width:600px">
						  <table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
							  <tbody>
								  <tr>
									  <td style="direction:ltr;font-size:0px;padding:0;padding-left:0;padding-right:0;text-align:center">
										  <div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
											  <table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
												  <tbody>
													  <tr>
														  <td align="center" style="font-size:0px;padding:0 0;word-break:break-word">
															  <table border="0" cellpadding="0" cellspacing="0" role="presentation" style="border-collapse:collapse;border-spacing:0px">
																  <tbody>
																	  <tr>
																		  <td style="width:600px">
																			  <img height="auto" src="https://i.ibb.co/cvH9Djf/banner.png" style="border:0;display:block;outline:none;text-decoration:none;height:auto;width:100%;font-size:13px" width="600" class="CToWUd a6T" tabindex="0">
																			  <div class="a6S" dir="ltr" style="opacity: 0.01; left: 677.5px; top: 180px;">
																				  <div id=":173" class="T-I J-J5-Ji aQv T-I-ax7 L3 a5q" role="button" tabindex="0" aria-label="Fazer o download do anexo " data-tooltip-class="a1V" data-tooltip="Fazer o download">
																					  <div class="aSK J-J5-Ji aYr"></div>
																				  </div>
																			  </div>
																		  </td>
																	  </tr>
																  </tbody>
															  </table>
														  </td>
													  </tr>
												  </tbody>
											  </table>
										  </div>
									  </td>
								  </tr>
							  </tbody>
						  </table>
					  </div>
					  <div style="margin:0px auto;max-width:600px">
						  <table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
							  <tbody>
								  <tr>
									  <td style="direction:ltr;font-size:0px;padding:40px 40px 0 40px;padding-left:40px;padding-right:40px;text-align:center">
										  <div class="m_-4945555513056369728mj-column-per-100" style="font-size:0px;text-align:left;direction:ltr;display:inline-block;vertical-align:top;width:100%">
											  <table border="0" cellpadding="0" cellspacing="0" role="presentation" style="vertical-align:top" width="100%">
												  <tbody>
													  <tr>
														  <td align="center" style="font-size:0px;padding:0px;word-break:break-word">
															  <div style="font-family:sans-serif;font-size:22px;line-height:150%;text-align:center;color:#6f34fa"><strong>Ol&aacute; competidor!!!</strong>
															  </div>
														  </td>
													  </tr>
													  
													  <tr>
														  <td align="center" style="font-size:0px;padding:0px;padding-bottom:20px;word-break:break-word">
															  <div style="font-family:sans-serif;font-size:16px;line-height:150%;text-align:center;color:#383838">
																  
																  Devido &agrave; grande demanda de acesso aos jogos online da IYRC, prorrogamos a data da etapa final para dia <strong>13/06/2020, &agrave;s 14h.</strong>
																  <br>
																  <br>Fique ligado nas not&iacute;cias da IYRC Onine e convide seus amigos a participarem!!!
																  <br>
																  <br>
																  <strong>Boa sorte na final!!!</strong><br>
																  <br>
																   <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="https://g1.globo.com/sp/piracicaba-regiao/noticia/2019/10/26/piracicaba-recebe-etapa-de-campeonato-internacional-de-robotica-ate-domingo.ghtml" target="_blank">Confira mat&eacute;ria no site G1 da Globo sobre a etapa nacional de 2019</a>
																  <br><br>
																  <a style="font-family:sans-serif;font-size:14px;font-weight:bold;line-height:250%;text-align:center;color:#6f34fa" id="linkCompetition" href="http://www.camaracharqueada.sp.gov.br/Noticia/Visualizar/4072" target="_blank">Mat&eacute;ria com alunos de escola p&uacute;blica na etapa nacional da competi&ccedil;&atilde;o</a>
																  <br>
																  
															  </div>
														  </td>
													  </tr>
													  <tr>
														  <td align="center" style="font-size:0px;padding:0px;word-break:break-word">
															  <div style="font-family:sans-serif;font-size:22px;line-height:250%;text-align:center;color:#6f34fa"><strong>ATEN&Ccedil;&Atilde;O! O DESAFIO FINAL ACONTECE EM:</strong>
															  </div>
															  <img src="http://gen.sendtric.com/countdown/hf2rvbf2kv" style="display: block;" />	
														  </td>
													  </tr>
												  </tbody>
											  </table>
										  </div>
									  </td>
								  </tr>
							  </tbody>
						  </table>
					  </div>					
				  </td>
			  </tr>
		  </tbody>
	  </table>
  </div>
  <div style="margin:0px auto;max-width:600px">
	  <table align="center" border="0" cellpadding="0" cellspacing="0" role="presentation" style="width:100%">
		  <tbody>
			  <tr>
				  <td style="direction:ltr;font-size:0px;padding:10px;padding-left:40px;padding-right:40px;text-align:center"></td>
			  </tr>
		  </tbody>
	  </table>
  </div>
</div>`;
}

module.exports = routes;