node.js - 如果请求值存在，Nodejs 将搜索多个元素

Question

提前致谢。

我正在使用 POST 方法从数据库中搜索。但是某些请求正文值可能未定义。仅当 POST 方法中存在时，我才想忽略这些和搜索元素

function searchPhone(req, res) {
    return Phones.findAll({
        where: {
            description: { $like: '%' + req.body.description + '%', },
            simcard: [req.body.simcard| 1],  //if req.body.simcard exist in post then search if not skip 
        }
    })
    .then(fav => res.status(200).send(fav));
}

Answer 1

你可以做的一种方法是:

function searchPhone(req, res) {

    let where = {};
    where['description'] = { $like: '%' + req.body.description + '%' };

    if(req.body.simcard) {
        where['simcard'] = [req.body.simcard| 1]
    }

    return Phones.findAll({ where }).then(fav => res.status(200).send(fav));
}

Not sure about the below one , but I think it will work , give my confirmation tomorrow

function searchPhone(req, res) {
    return Phones.findAll({
        where: {
            description: { $like: '%' + req.body.description + '%' },
            simcard: req.body.simcard ,  // <-- I think this will be ignored 
                                        //if simcard is not in req.body , please check the console for query
        }
    })
    .then(fav => res.status(200).send(fav));
}