CREATE TABLE public.tb_users
(
    id integer NOT NULL DEFAULT nextval('tb_users_seq'::regclass),
    email character varying(50) COLLATE pg_catalog."default" NOT NULL,
    password character varying(50) COLLATE pg_catalog."default",
    enable boolean,
    register text COLLATE pg_catalog."default" DEFAULT now()
)

Caso o serviço de verificação de e-mails esteja instável ou fora do ar, será necessário alterar a permissão por uma query.

UPDATE tb_users SET enable = true WHERE email = '[email protected]';

Todas as requisições são feitas para ambiente de produção. Altere os arquivos para que sejam direcionadas para localhost. 

import { Injectable } from '@angular/core';
import { HttpClient } from '@angular/common/http';
import { environment } from '../../environments/environment';
const APP_API = environment.api;


@Injectable({
  providedIn: 'root'
})
export class HttpService {

  constructor(private http: HttpClient) { }

  get(endpoint) {
    return this.http.get(`${APP_API}/${endpoint}`);
  }

  post(endpoint, body = {}) {
    return this.http.post(`${APP_API}/${endpoint}`, body);
  }

}

export const environment = {
production: true,
api: 'https://applinkerserver.applinker.engpro.totvs.com.br'
};

export const environment = {
production: false,
api: 'http://localhost:3000'
};

Visualize o arquivo package.json no atributo scripts para identificar as configurações de porta. 

Todas as requisições são feitas para ambiente de produção. Altere os arquivos para que sejam direcionadas para localhost. 

export class ConfigDB {
  private conn;

  public async connectDB() {

    const { Pool, Client } = require('pg')
    
    const connectionString = "postgres://applinker:dado_sensivel@postgres:5432/applinker"
                            
    const pool = new Pool({
      connectionString: connectionString,
    })

    pool
    .connect()
    .then( ()=> console.info('conectado com sucesso'))
    .catch( () => console.info('falha ao conectar com o banco de dados.'))

    return await pool
    }
}

export class ConfigDB {
  private conn;

  public async connectDB() {

    const { Pool, Client } = require('pg')
    
    const connectionString = "postgres://postgres:123456@localhost:5432/applinker";
                            
    const pool = new Pool({
      connectionString: connectionString,
    })

    pool
    .connect()
    .then( ()=> console.info('conectado com sucesso'))
    .catch( () => console.info('falha ao conectar com o banco de dados.'))

    return await pool
    }
}

import { ConfigDB } from './../database/config_db';
import { Request, Response } from 'express';
import * as ldap from 'ldapjs';
import * as jwt from 'jsonwebtoken';
import * as nodemailer from 'nodemailer';
import { google } from 'googleapis';

const SMTP_CONFIG = require('./../../config/env/smtp')

const config = require('../../config/env/')();

// declaracao do OAuth2
const OAuth2 = google.auth.OAuth2;

export class AuthController {

  protected client;
  protected adSuffix = "dc=local";
  constructor() {

    // this.client = ldap.createClient({
    //     url: config.activeDirectory.url
    // });

    // this.client.bind(config.activeDirectory.user, config.activeDirectory.password, err => {
    //     if (err) {
    //         throw new Error('user LDAP não autenticado!');
    //     }
    // });

  }

  public auth(req: Request, res: Response, next: any) {

    this.authWithoutAD(req, res, next);

  }
  // public authWithAD(req: Request, res: Response, next: any) {
  //     const searchOptions = {
  //         scope: "sub",
  //         filter: `(&(objectClass=person)(sAMAccountName=${req.body.user})(!(userAccountControl:1.2.840.113556.1.4.803:=2)))`
  //     };

  //     this.client.search(this.adSuffix,searchOptions,(err, response) => {
  //         console.log('logando...');
  //         if (err) {
  //             console.log(`erro ao efetuar as busca ${err}`);
  //         }
  //         response.on('searchEntry', entry => {
  //             console.log('buscando login...');
  //             this.client.bind(entry.object.dn, req.body.password, (err) => {
  //                 if (err) {
  //                     res.status(400); 
  //                     res.send({error: "Unauthorized"});
  //                 } else {
  //                     res.send({
  //                         user: entry.object.sAMAccountName,
  //                         userEmail: entry.object.mail,
  //                         token: jwt.sign({user: entry.object.sAMAccountName}, config.masterKey)
  //                     });
  //                 }
  //                 res.end();

  //             });

  //         });

  //     });

  //     req.setTimeout(20000);
  // }


  public async register(req: Request, res: Response, next: any) {
    const db = new ConfigDB();
    try {
      const conn = await db.connectDB();

      let result = await conn.query("select * from tb_users where email = $1 ", [req.body.user]);

      if (result.rows.length > 0) {
        return res.status(400).send({ error: "O email ja esta sendo utilizado." });
      }

      result = await conn.query("insert into tb_users (email, password,enable) values ($1, md5($2),false)", [req.body.user, req.body.password]);

      if (!result.err) {
        res.send({
          userEmail: req.body.user
        });
        await this.sentEmail(req.body.user)
      } else {
        res.status(400).send({ error: "Não foi possivel cadastrar" });
      }

      conn.end();
    } catch (err) {
      return res.status(500).send({ error: err.name });
    }
  }

  public async authWithoutAD(req: Request, res: Response, next: any) {
    const db = new ConfigDB();
    try {
      const conn = await db.connectDB();

      let result = await conn.query("select email from tb_users where email = $1 and password = md5($2) and enable = true", [req.body.user, req.body.password]);

      if (result.rowCount > 0) {
        res.send({
          user: req.body.user.split("@")[0],
          userEmail: req.body.user,
          token: jwt.sign({ user: req.body.user }, config.masterKey)
        });
      } else {
        result = await conn.query("select email from tb_users where email = $1 and password = md5($2) and enable = false", [req.body.user, req.body.password]);
        if (result.rowCount > 0) {
          res.status(401).send({ error: "Usuário aguardando aprovação " });
        } else {
          res.status(403).send({ error: "Senha ou email incorretos " });
        }

      }

    } catch (err) {
      res.status(500).send({ error: err.name });
    }
  }

  // Acrescentando OAuth2 Authentication
  public async sentEmail(email: string): Promise<void> {
    const emailToken = jwt.sign({ email }, config.masterKey);

    const oauth2Client = new OAuth2(SMTP_CONFIG.client_id, SMTP_CONFIG.secret_key, SMTP_CONFIG.redirect_uri);

    oauth2Client.setCredentials({
      refresh_token: SMTP_CONFIG.refresh_token
    })

    const accessToken = await oauth2Client.getAccessToken().then((token) => {
      return token.token;
    })

    const transporter = await nodemailer.createTransport({
      host: SMTP_CONFIG.host,
      port: SMTP_CONFIG.port,
      secure: true,
      auth: {
        type: 'OAuth2',
        user: SMTP_CONFIG.user,
        clientId: SMTP_CONFIG.client_id,
        clientSecret: SMTP_CONFIG.secret_key,
        refreshToken: SMTP_CONFIG.refresh_token,
        accessToken: accessToken
      }
    })


    await transporter.sendMail({
      subject: 'Verificação de acesso ao AppLinker',
      from: 'Protheus Mobile' + `<${SMTP_CONFIG.user}>`,
      to: `${email}`,
      html: `<div>
                <div
                  style="background:#4DBFBF;background-color:#4DBFBF;margin:0px auto;max-width:600px;"
                >
                  <table
                    align="center"
                    border="0"
                    cellpadding="0"
                    cellspacing="0"
                    role="presentation"
                    style="background:#4DBFBF;background-color:#ffffff;width:100%;"
                  >
                    <tbody>
                      <tr>
                        <td
                          style="direction:ltr;font-size:0px;padding:20px 0;text-align:center;vertical-align:top;"
                        >
                          <div
                            class="dys-column-per-100 outlook-group-fix"
                            style="direction:ltr;display:inline-block;font-size:13px;text-align:left;vertical-align:top;width:100%;"
                          >
                            <table
                              border="0"
                              cellpadding="0"
                              cellspacing="0"
                              role="presentation"
                              style="vertical-align:top;"
                              width="100%"
                            >
                              <tr>
                                <td
                                  align="center"
                                  style="font-size:0px;padding:10px 25px;word-break:break-word;"
                                >
                                  <div
                                    style='color:#0c9abe;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:36px;line-height:1;text-align:center;'
                                  >
                                    Boas Vindas
                                  </div>
                                </td>
                              </tr>
                              <tr>
                                <td
                                  align="center"
                                  style="font-size:0px;padding:10px 25px;word-break:break-word;"
                                >
                                  <div
                                    style='color:#586a6e;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:16px;line-height:20px;text-align:center;'
                                  >
                                    <br />
                                    Para ativar sua conta no AppLinker clique no botão abaixo:
                                    <br />
                                    <br />
                                  </div>
                                </td>
                              </tr>
                              <tr>
                                <td
                                  align="center"
                                  style="font-size:0px;padding:10px 25px;word-break:break-word;"
                                  vertical-align="middle"
                                >
                                  <table
                                    border="0"
                                    cellpadding="0"
                                    cellspacing="0"
                                    role="presentation"
                                    style="border-collapse:separate;line-height:100%;width:200px;"
                                  >
                                    <tr>
                                      <td
                                        align="center"
                                        bgcolor="#178F8F"
                                        role="presentation"
                                        style='background-color:#0c9abe; border:"solid 1px red";border-radius:4px;cursor:auto;padding:10px 25px;'
                                        valign="middle"
                                      >
                                        <a
                                          href="https://applinkerserver.applinker.engpro.totvs.com.br/auth/validate/${emailToken}"
                                          style='background-color:#0c9abe; color:white;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:16px;font-weight:bold;line-height:30px;margin:0;text-decoration:none;text-transform:none;'
                                          target="_blank"
                                        >
                                          Ativar
                                        </a>
                                      </td>
                                    </tr>
                                  </table>
                                </td>
                              </tr>
                              <tr>
                                <td
                                  align="center"
                                  style="font-size:0px;padding:10px 25px;word-break:break-word;"
                                >
                                    <div
                                    style=' color:#586a6e;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:12px;margin-top:10;text-decoration:none;text-transform:none;'
                                    >
                                        Para mais detalhes a respeito do uso da AppLinker <a href="https://tdn.totvs.com/x/KHbQHw">clique aqui!<a/>
                                    </div>
                                </td>
                              </tr>
                            </table>
                          </div>
                        </td>
                      </tr>
                    </tbody>
                  </table>
                </div>
              </div>
              >`
    }).catch(error => {
      console.log(error)
    })
  }

  public async sentEmailToReset(req: Request, res: Response, next: any): Promise<void> {
    try {
    
      const email = req.body.user;
      const emailToken = jwt.sign({ email }, config.masterKey);
      const oauth2Client = new OAuth2(SMTP_CONFIG.client_id, SMTP_CONFIG.secret_key, SMTP_CONFIG.redirect_uri);

      oauth2Client.setCredentials({
        refresh_token: SMTP_CONFIG.refresh_token
      })

      const accessToken = await oauth2Client.getAccessToken().then((token) => {
        return token.token;
      })

    
      const transporter = await nodemailer.createTransport({
        host: SMTP_CONFIG.host,
        port: SMTP_CONFIG.port,
        secure: true,
        auth: {
          type: 'OAuth2',
          user: SMTP_CONFIG.user,
          clientId: SMTP_CONFIG.client_id,
          clientSecret: SMTP_CONFIG.secret_key,
          refreshToken: SMTP_CONFIG.refresh_token,
          accessToken: accessToken
        }
      })

      await transporter.sendMail({
        subject: 'Verificação de acesso ao AppLinker',
        from: 'Protheus Mobile' + `<${SMTP_CONFIG.user}>`,
        to: `${email}`,
        html: `<div>
              <div
                style="background:#4DBFBF;background-color:#4DBFBF;margin:0px auto;max-width:600px;"
              >
                <table
                  align="center"
                  border="0"
                  cellpadding="0"
                  cellspacing="0"
                  role="presentation"
                  style="background:#4DBFBF;background-color:#ffffff;width:100%;"
                >
                  <tbody>
                    <tr>
                      <td
                        style="direction:ltr;font-size:0px;padding:20px 0;text-align:center;vertical-align:top;"
                      >
                        <div
                          class="dys-column-per-100 outlook-group-fix"
                          style="direction:ltr;display:inline-block;font-size:13px;text-align:left;vertical-align:top;width:100%;"
                        >
                          <table
                            border="0"
                            cellpadding="0"
                            cellspacing="0"
                            role="presentation"
                            style="vertical-align:top;"
                            width="100%"
                          >
                            <tr>
                              <td
                                align="center"
                                style="font-size:0px;padding:10px 25px;word-break:break-word;"
                              >
                                <div
                                  style='color:#0c9abe;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:36px;line-height:1;text-align:center;'
                                >
                                  Boas Vindas
                                </div>
                              </td>
                            </tr>
                            <tr>
                              <td
                                align="center"
                                style="font-size:0px;padding:10px 25px;word-break:break-word;"
                              >
                                <div
                                  style='color:#586a6e;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:16px;line-height:20px;text-align:center;'
                                >
                                  <br />
                                  Para alterar a senha cadastrada no AppLinker clique no botão abaixo:
                                  <br />
                                  <br />
                                </div>
                              </td>
                            </tr>
                            <tr>
                              <td
                                align="center"
                                style="font-size:0px;padding:10px 25px;word-break:break-word;"
                                vertical-align="middle"
                              >
                                <table
                                  border="0"
                                  cellpadding="0"
                                  cellspacing="0"
                                  role="presentation"
                                  style="border-collapse:separate;line-height:100%;width:200px;"
                                >
                                  <tr>
                                    <td
                                      align="center"
                                      bgcolor="#178F8F"
                                      role="presentation"
                                      style='background-color:#0c9abe; border:"solid 1px red";border-radius:4px;cursor:auto;padding:10px 25px;'
                                      valign="middle"
                                    >
                                      <a
                                        href="https://applinker.engpro.totvs.com.br/reset-password?token=${emailToken}"
                                        style='background-color:#0c9abe; color:white;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:16px;font-weight:bold;line-height:30px;margin:0;text-decoration:none;text-transform:none;'
                                        target="_blank"
                                      >
                                        Alterar Senha
                                      </a>
                                    </td>
                                  </tr>
                                </table>
                              </td>
                            </tr>
                            <tr>
                              <td
                                align="center"
                                style="font-size:0px;padding:10px 25px;word-break:break-word;"
                              >
                                  <div
                                  style=' color:#586a6e;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:12px;margin-top:10;text-decoration:none;text-transform:none;'
                                  >
                                      Para mais detalhes a respeito do uso da AppLinker <a href="https://tdn.totvs.com/x/KHbQHw">clique aqui!<a/>
                                  </div>
                              </td>
                            </tr>
                          </table>
                        </div>
                      </td>
                    </tr>
                  </tbody>
                </table>
              </div>
            </div>`
      }).then(() => {
        res.status(200).send({ message: 'Email enviado com sucesso.' });
      }).catch(error => {
        res.status(500).send({ message: 'Não foi possivel enviar o email.' })
      })
    } catch (err) {
      console.log('aqui')
      res.status(500).send({ error: err.name });
    }

  }



  public async validate(req: Request, res: Response, next: any) {
    const db = new ConfigDB();
    try {
      const conn = await db.connectDB();

      const token = req.params.token;
      if (token) {
        jwt.verify(token, config.masterKey, async (err, decodedToken) => {
          if (err) {
            return res.status(400).json({ error: 'Incorrect token' });
          }
          const { email } = decodedToken;
          let result = await conn.query("update tb_users set enable = true where email = $1 and enable = false", [email]);
          return res.redirect('https://applinker.engpro.totvs.com.br/login?isActive=true')
        })

      } else {
        res.status(500).send({ error: 'Invalid token' });
      }
    } catch (err) {
      res.status(500).send({ error: err.name });
    }
  }

  public async resetPassword(req: Request, res: Response, next: any) {
    const db = new ConfigDB();
    try {
      const conn = await db.connectDB();
      const token = req.body.token;
      if (token) {
        jwt.verify(token, config.masterKey, async (err, decodedToken) => {
          if (err) {
            return res.status(400).json({ error: 'Incorrect token' });
          }
          const { email } = decodedToken;
          let result = await conn.query("update tb_users set password = md5($2) where email = $1", [email, req.body.password]);
          if (result.rowCount > 0) {
            res.status(200).send({ message: "Senha alterada com sucesso" });
          } else {
            res.status(403).send({ error: "Não foi possivel alterar a senha." });
          }
        })
      } else {
        res.status(500).send({ error: 'Invalid token' });
      }
    } catch (err) {
      res.status(500).send({ error: err.name });
    }
  }

}

import { ConfigDB } from './../database/config_db';
import { Request, Response } from 'express';
import * as jwt from 'jsonwebtoken';
import * as nodemailer from 'nodemailer';
import { google } from 'googleapis';

const SMTP_CONFIG = require('./../../config/env/smtp')

const config = require('../../config/env/')();

// declaracao do OAuth2
const OAuth2 = google.auth.OAuth2;

export class AuthController {

  protected client;
  protected adSuffix = "dc=local";
  constructor() {}

  public auth(req: Request, res: Response, next: any) {

    this.authWithoutAD(req, res, next);

  }
  
  public async register(req: Request, res: Response, next: any) {
    const db = new ConfigDB();
    try {
      const conn = await db.connectDB();
      let result = await conn.query("select * from tb_users where email = $1 ", [req.body.user]);
      if (result.rows.length > 0) {
        return res.status(400).send({ error: "O email ja esta sendo utilizado." });
      }
      await conn.query("insert into tb_users (email, password,enable) values ($1, md5($2),false)", [req.body.user, req.body.password]).then(res => {
        result = res
      }).catch(error => {
        console.log(error);
      });

      if (!result.err) {
        res.send({
          userEmail: req.body.user
        });
        await this.sentEmail(req.body.user)
      } else {
        res.status(400).send({ error: "Não foi possivel cadastrar" });
      }

      conn.end();
    } catch (err) {
      return res.status(500).send({ error: err.name });
    }
  }

  public async authWithoutAD(req: Request, res: Response, next: any) {
    const db = new ConfigDB();
    try {
      const conn = await db.connectDB();

      let result = await conn.query("select email from tb_users where email = $1 and password = md5($2) and enable = true", [req.body.user, req.body.password]);

      if (result.rowCount > 0) {
        res.send({
          user: req.body.user.split("@")[0],
          userEmail: req.body.user,
          token: jwt.sign({ user: req.body.user }, config.masterKey)
        });
      } else {
        result = await conn.query("select email from tb_users where email = $1 and password = md5($2) and enable = false", [req.body.user, req.body.password]);
        if (result.rowCount > 0) {
          res.status(401).send({ error: "Usuário aguardando aprovação " });
        } else {
          res.status(403).send({ error: "Senha ou email incorretos " });
        }

      }

    } catch (err) {
      res.status(500).send({ error: err.name });
    }
  }

  // Acrescentando OAuth2 Authentication
  public async sentEmail(email: string): Promise<void> {
    const emailToken = jwt.sign({ email }, config.masterKey);

    const oauth2Client = new OAuth2(SMTP_CONFIG.client_id, SMTP_CONFIG.secret_key, SMTP_CONFIG.redirect_uri);

    oauth2Client.setCredentials({
      refresh_token: SMTP_CONFIG.refresh_token
    })

    const accessToken = await oauth2Client.getAccessToken().then((token) => {
      return token.token;
    })

    const transporter = await nodemailer.createTransport({
      host: SMTP_CONFIG.host,
      port: SMTP_CONFIG.port,
      secure: true,
      auth: {
        type: 'OAuth2',
        user: SMTP_CONFIG.user,
        clientId: SMTP_CONFIG.client_id,
        clientSecret: SMTP_CONFIG.secret_key,
        refreshToken: SMTP_CONFIG.refresh_token,
        accessToken: accessToken
      }
    })


    await transporter.sendMail({
      subject: 'Verificação de acesso ao AppLinker',
      from: 'Protheus Mobile' + `<${SMTP_CONFIG.user}>`,
      to: `${email}`,
      html: `<div>
                <div
                  style="background:#4DBFBF;background-color:#4DBFBF;margin:0px auto;max-width:600px;"
                >
                  <table
                    align="center"
                    border="0"
                    cellpadding="0"
                    cellspacing="0"
                    role="presentation"
                    style="background:#4DBFBF;background-color:#ffffff;width:100%;"
                  >
                    <tbody>
                      <tr>
                        <td
                          style="direction:ltr;font-size:0px;padding:20px 0;text-align:center;vertical-align:top;"
                        >
                          <div
                            class="dys-column-per-100 outlook-group-fix"
                            style="direction:ltr;display:inline-block;font-size:13px;text-align:left;vertical-align:top;width:100%;"
                          >
                            <table
                              border="0"
                              cellpadding="0"
                              cellspacing="0"
                              role="presentation"
                              style="vertical-align:top;"
                              width="100%"
                            >
                              <tr>
                                <td
                                  align="center"
                                  style="font-size:0px;padding:10px 25px;word-break:break-word;"
                                >
                                  <div
                                    style='color:#0c9abe;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:36px;line-height:1;text-align:center;'
                                  >
                                    Boas Vindas
                                  </div>
                                </td>
                              </tr>
                              <tr>
                                <td
                                  align="center"
                                  style="font-size:0px;padding:10px 25px;word-break:break-word;"
                                >
                                  <div
                                    style='color:#586a6e;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:16px;line-height:20px;text-align:center;'
                                  >
                                    <br />
                                    Para ativar sua conta no AppLinker clique no botão abaixo:
                                    <br />
                                    <br />
                                  </div>
                                </td>
                              </tr>
                              <tr>
                                <td
                                  align="center"
                                  style="font-size:0px;padding:10px 25px;word-break:break-word;"
                                  vertical-align="middle"
                                >
                                  <table
                                    border="0"
                                    cellpadding="0"
                                    cellspacing="0"
                                    role="presentation"
                                    style="border-collapse:separate;line-height:100%;width:200px;"
                                  >
                                    <tr>
                                      <td
                                        align="center"
                                        bgcolor="#178F8F"
                                        role="presentation"
                                        style='background-color:#0c9abe; border:"solid 1px red";border-radius:4px;cursor:auto;padding:10px 25px;'
                                        valign="middle"
                                      >
                                        <a
                                        href="http://localhost:3000/auth/validate/${emailToken}"
                                        style='background-color:#0c9abe; color:white;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:16px;font-weight:bold;line-height:30px;margin:0;text-decoration:none;text-transform:none;'
                                          target="_blank"
                                        >
                                          Ativar
                                        </a>
                                      </td>
                                    </tr>
                                  </table>
                                </td>
                              </tr>
                              <tr>
                                <td
                                  align="center"
                                  style="font-size:0px;padding:10px 25px;word-break:break-word;"
                                >
                                    <div
                                    style=' color:#586a6e;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:12px;margin-top:10;text-decoration:none;text-transform:none;'
                                    >
                                        Para mais detalhes a respeito do uso da AppLinker <a href="https://tdn.totvs.com/x/KHbQHw">clique aqui!<a/>
                                    </div>
                                </td>
                              </tr>
                            </table>
                          </div>
                        </td>
                      </tr>
                    </tbody>
                  </table>
                </div>
              </div>
              >`
    }).catch(error => {
      console.log(error)
    })
  }

  public async sentEmailToReset(req: Request, res: Response, next: any): Promise<void> {
    try {
    
      const email = req.body.user;
      const emailToken = jwt.sign({ email }, config.masterKey);
      const oauth2Client = new OAuth2(SMTP_CONFIG.client_id, SMTP_CONFIG.secret_key, SMTP_CONFIG.redirect_uri);

      oauth2Client.setCredentials({
        refresh_token: SMTP_CONFIG.refresh_token
      })

      const accessToken = await oauth2Client.getAccessToken().then((token) => {
        return token.token;
      })

    
      const transporter = await nodemailer.createTransport({
        host: SMTP_CONFIG.host,
        port: SMTP_CONFIG.port,
        secure: true,
        auth: {
          type: 'OAuth2',
          user: SMTP_CONFIG.user,
          clientId: SMTP_CONFIG.client_id,
          clientSecret: SMTP_CONFIG.secret_key,
          refreshToken: SMTP_CONFIG.refresh_token,
          accessToken: accessToken
        }
      })

      await transporter.sendMail({
        subject: 'Verificação de acesso ao AppLinker',
        from: 'Protheus Mobile' + `<${SMTP_CONFIG.user}>`,
        to: `${email}`,
        html: `<div>
              <div
                style="background:#4DBFBF;background-color:#4DBFBF;margin:0px auto;max-width:600px;"
              >
                <table
                  align="center"
                  border="0"
                  cellpadding="0"
                  cellspacing="0"
                  role="presentation"
                  style="background:#4DBFBF;background-color:#ffffff;width:100%;"
                >
                  <tbody>
                    <tr>
                      <td
                        style="direction:ltr;font-size:0px;padding:20px 0;text-align:center;vertical-align:top;"
                      >
                        <div
                          class="dys-column-per-100 outlook-group-fix"
                          style="direction:ltr;display:inline-block;font-size:13px;text-align:left;vertical-align:top;width:100%;"
                        >
                          <table
                            border="0"
                            cellpadding="0"
                            cellspacing="0"
                            role="presentation"
                            style="vertical-align:top;"
                            width="100%"
                          >
                            <tr>
                              <td
                                align="center"
                                style="font-size:0px;padding:10px 25px;word-break:break-word;"
                              >
                                <div
                                  style='color:#0c9abe;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:36px;line-height:1;text-align:center;'
                                >
                                  Boas Vindas
                                </div>
                              </td>
                            </tr>
                            <tr>
                              <td
                                align="center"
                                style="font-size:0px;padding:10px 25px;word-break:break-word;"
                              >
                                <div
                                  style='color:#586a6e;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:16px;line-height:20px;text-align:center;'
                                >
                                  <br />
                                  Para alterar a senha cadastrada no AppLinker clique no botão abaixo:
                                  <br />
                                  <br />
                                </div>
                              </td>
                            </tr>
                            <tr>
                              <td
                                align="center"
                                style="font-size:0px;padding:10px 25px;word-break:break-word;"
                                vertical-align="middle"
                              >
                                <table
                                  border="0"
                                  cellpadding="0"
                                  cellspacing="0"
                                  role="presentation"
                                  style="border-collapse:separate;line-height:100%;width:200px;"
                                >
                                  <tr>
                                    <td
                                      align="center"
                                      bgcolor="#178F8F"
                                      role="presentation"
                                      style='background-color:#0c9abe; border:"solid 1px red";border-radius:4px;cursor:auto;padding:10px 25px;'
                                      valign="middle"
                                    >
                                      <a
                                      href="http://localhost:3000/reset-password?token=${emailToken}"
                                      style='background-color:#0c9abe; color:white;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:16px;font-weight:bold;line-height:30px;margin:0;text-decoration:none;text-transform:none;'
                                        target="_blank"
                                      >
                                        Alterar Senha
                                      </a>
                                    </td>
                                  </tr>
                                </table>
                              </td>
                            </tr>
                            <tr>
                              <td
                                align="center"
                                style="font-size:0px;padding:10px 25px;word-break:break-word;"
                              >
                                  <div
                                  style=' color:#586a6e;font-family:"Droid Sans", "Helvetica Neue", Arial, sans-serif;font-size:12px;margin-top:10;text-decoration:none;text-transform:none;'
                                  >
                                      Para mais detalhes a respeito do uso da AppLinker <a href="https://tdn.totvs.com/x/KHbQHw">clique aqui!<a/>
                                  </div>
                              </td>
                            </tr>
                          </table>
                        </div>
                      </td>
                    </tr>
                  </tbody>
                </table>
              </div>
            </div>`
      }).then(() => {
        res.status(200).send({ message: 'Email enviado com sucesso.' });
      }).catch(error => {
        res.status(500).send({ message: 'Não foi possivel enviar o email.' })
      })
    } catch (err) {
      res.status(500).send({ error: err.name });
    }

  }



  public async validate(req: Request, res: Response, next: any) {
    const db = new ConfigDB();
    try {
      const conn = await db.connectDB();

      const token = req.params.token;
      if (token) {
        jwt.verify(token, config.masterKey, async (err, decodedToken) => {
          if (err) {
            return res.status(400).json({ error: 'Incorrect token' });
          }
          const { email } = decodedToken;
          let result = await conn.query("update tb_users set enable = true where email = $1 and enable = false", [email]);
          return res.redirect('http://localhost:4200/login?isActive=true')
        })

      } else {
        res.status(500).send({ error: 'Invalid token' });
      }
    } catch (err) {
      res.status(500).send({ error: err.name });
    }
  }

  public async resetPassword(req: Request, res: Response, next: any) {
    const db = new ConfigDB();
    try {
      const conn = await db.connectDB();
      const token = req.body.token;
      if (token) {
        jwt.verify(token, config.masterKey, async (err, decodedToken) => {
          if (err) {
            return res.status(400).json({ error: 'Incorrect token' });
          }
          const { email } = decodedToken;
          let result = await conn.query("update tb_users set password = md5($2) where email = $1", [email, req.body.password]);
          if (result.rowCount > 0) {
            res.status(200).send({ message: "Senha alterada com sucesso" });
          } else {
            res.status(403).send({ error: "Não foi possivel alterar a senha." });
          }
        })
      } else {
        res.status(500).send({ error: 'Invalid token' });
      }
    } catch (err) {
      res.status(500).send({ error: err.name });
    }
  }
}

CREATE TABLE public.tb_users
(
    id serial NOT NULL,
    email character varying(50) COLLATE pg_catalog."default" NOT NULL,
    password character varying(50) COLLATE pg_catalog."default",
    enable boolean,
    register text COLLATE pg_catalog."default" DEFAULT now()
)