个人中心
gpt4 book ai didi

sql - 如何检索用户输入的特定合作伙伴 ID 的电子邮件并将其发送回 Controller 。

转载 作者：行者123 更新时间：2023-12-03 22:27:44 25 4
gpt4 key购买 nike

我有问题。
我不知道 sequelize.js 正确。
我有一个 HTML 表单，如下所示:

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Forget Password</title>
</head>
<body>
Forget Password: <br/>
<form action="/forgetpasswordpartner" method="POST">
    Enter PartnerID: 
    <input type="text" name="partnerid">
    <button type="submit" value="Send Email">Send Email</button>
</form>
</body>
</html>

我有 Controller : 
exports.sendresetlinkpartner = function (req, res, next) {
var partnerid = req.body.partnerid;
var token = randomstring.generate({
    length: 100,
    charset: 'alphanumeric',
    capitalization: 'uppercase'
});
var link = "http://localhost:3000/forgetpasswordpartner/" + token;
forgetpasswordmodel.sendresetemailpartner(partnerid, token, function (err, result) {
    if (err) throw err;
    else {
        res.send('Email not found in database');
    }
}, function (err, result) {
    if (err) throw err;
    else {
        let transporter = nodemailer.createTransport({
            host: 'xxxx',
            port:xxx,
            secure: false, // true for 465, false for other ports
            auth: {
                user: 'xxxxxx@xxxx.com', // generated ethereal user
                pass: 'xxxxxxxxx' // generated ethereal password
            },
            //if email is sent via localhost
            tls: {
                rejectUnauthorized: false
            }
        });
        let mailOptions = {
            from: '"xxxxxx" <xxxxxxx@xxxxx.com>', // sender address
            to: email, // list of receivers
            subject: 'Reset Password', // Subject line
            text: 'A password reset for your account was requested', // plain text body
            html: "Please click the button below to change your password.<br><a href=" + link + ">" + "<h2>Change your password</h2>" + "</a> "
            // html body
        };
        // send mail with defined transport object
        transporter.sendMail(mailOptions, (error, info) => {
            if (error) {

                res.send('Couldnot send Reset Password email.Please try again later');
                return console.log(error);
            }
            else {
                console.log('Message sent: %s', info.messageId);
                // Preview only available when sending through an Ethereal account
                console.log('Preview URL: %s', nodemailer.getTestMessageUrl(info));
                // Message sent: <b658f8ca-6296-ccf4-8306-87d57a0b4321@example.com>
                // Preview URL: https://ethereal.email/message/WaQKMgKddxQDoou...
            }
        });
        res.send('To Change your password, a link has been sent to your email.Check your mail');
    }
})
}

这是我的模型: 
exports.sendresetemailpartner=function(partnerid,token,callback1,callback2){

partner.findOne({where:{'partnerid':partnerid}}).then(partner.update({'token':token},{where:{'companyemail':email}})).then((partner)=>{
    if(!partner){
        console.log('Email not registered');
        callback1();
    }
    else{
        console.log('Token Updated');
        callback2();
    }
})

我知道我的模型是错误的
我想要的是首先检查“partnerid”是否存在于数据库中，如果存在，则在同一行记录中插入一个 token 并检索该合作伙伴 ID 的电子邮件并将该电子邮件 ID 发送回 Controller 以存储在“电子邮件”变量中并发送那封邮件

任何人都可以帮助我。

最佳答案

使用单独的 js 文件发送电子邮件。由于电子邮件也将通过其他一些方法访问。将其写为接受两个参数的泛型。

//utils.js
module.exports = {
    sendEmail: function(toEmail, link) {
        return new Promise(function(resolve, reject) {
            let transporter = nodemailer.createTransport({
                host: 'xxxx',
                port: xxx,
                secure: false, // true for 465, false for other ports
                auth: {
                    user: 'xxxxxx@xxxx.com', // generated ethereal user
                    pass: 'xxxxxxxxx' // generated ethereal password
                },
                //if email is sent via localhost
                tls: {
                    rejectUnauthorized: false
                }
            });

            let mailOptions = {
                from: '"xxxxxx" <xxxxxxx@xxxxx.com>', // sender address
                to: toEmail, // list of receivers
                subject: 'Reset Password', // Subject line
                text: 'A password reset for your account was requested', // plain text body
                html: "Please click the button below to change your password.<br><a href=" + link + ">" + "<h2>Change your password</h2>" + "</a> "
                // html body
            };

            // send mail with defined transport object
            transporter.sendMail(mailOptions, (error, info) => {
                if (error) {

                    res.send('Couldnot send Reset Password email.Please try again later');
                    //return console.log(error);
                    reject(error)
                } else {
                    console.log('Message sent: %s', info.messageId);
                    // Preview only available when sending through an Ethereal account
                    console.log('Preview URL: %s', nodemailer.getTestMessageUrl(info));
                    // Message sent: <b658f8ca-6296-ccf4-8306-87d57a0b4321@example.com>
                    // Preview URL: https://ethereal.email/message/WaQKMgKddxQDoou...
                    resolve("success")
                }
            });
        });
    }
}


//Require util.js

import Utils from '../utils'

exports.sendresetlinkpartner = function(req, res, next) {

    var partnerid = req.body.partnerid;
    var token = randomstring.generate({
        length: 100,
        charset: 'alphanumeric',
        capitalization: 'uppercase'
    });
    var link = "http://localhost:3000/forgetpasswordpartner/" + token;

    partner.findOne({
        where: {
            'partnerid': partnerid
        }
    }).then((fetchedPartner) => {
        fetchedPartner.update({
            token: token
        }).then((postUpdate) => {
            if (!postUpdate) {
                console.log('Email not registered');
            } else {
                Utils.sendEmail('xyz@gmail.com', link).then((postEmail) => {
                    // your logic for success
                });
            }
        });
    });
}

关于sql - 如何检索用户输入的特定合作伙伴 ID 的电子邮件并将其发送回 Controller 。，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/50525247/

25 4 0
文章推荐： node.js - 使用来自 GET param 的对象作为 sequelize 中的 where 子句
文章推荐： recursion - 在 Mathematica 中，为什么递归函数中的替换不会终止？
文章推荐： jquery-ui - 使用jquery进行jsp ajax调用
文章推荐： angularjs - Pyramid Framework 不允许 AngularJS 的 JSONP 回调格式