javascript - 返回一组文档，其中所有子数组都包含loopback或nodejs中的给定值

Question

如何返回一组具有与常见值匹配的子数组的文档。为了更好地解释，请考虑以下数据:

[
{
    Category: 1,
    Products: [
                {
                    Name: 'ABC',
                    ColorCode:[1,2,3,4,5]
                },
                {
                    Name: 'DEF',
                    ColorCode:[1,2,3,4,5,6]
                },
                {
                    Name: 'GHI',
                    ColorCode:[1,2,3,4,6,7]
                }                   
            ]
},
{
    Category: 2,
    Products: [
                {
                    Name: 'JKL',
                    ColorCode:[4,6,7,]
                },
                {
                    Name: 'MNO',
                    ColorCode:[4,5,6,9,]
                }                   
            ]
},
{
    Category: 3,
    Products: [
                {
                    Name: 'OPQ',
                    ColorCode:[3,4,5,6,9,10]
                },
                {
                    Name: 'RST',
                    ColorCode:[2,3,5,6,9,10]
                }                   
            ]
}]

任务是，获取包含特定颜色代码的所有产品的所有类别:

例如，对于颜色代码 = 6，结果应该是:

[
{
    Category: 2,
    Products: [
                {
                    Name: 'JKL',
                    ColorCode:[4,6,7,]
                },
                {
                    Name: 'MNO',
                    ColorCode:[5,6,9,]
                }                   
            ]
},
{
    Category: 3,
    Products: [
                {
                    Name: 'OPQ',
                    ColorCode:[3,4,5,6,9,10]
                },
                {
                    Name: 'RST',
                    ColorCode:[2,3,5,6,9,10]
                }                   
            ]
}]

对于颜色代码 = 4，结果应该是:

[
{
    Category: 1,
    Products: [
                {
                    Name: 'ABC',
                    ColorCode:[1,2,3,4,5]
                },
                {
                    Name: 'DEF',
                    ColorCode:[1,2,3,4,5,6]
                },
                {
                    Name: 'GHI',
                    ColorCode:[1,2,3,4,6,7]
                }                   
            ]
},
{
    Category: 2,
    Products: [
                {
                    Name: 'JKL',
                    ColorCode:[4,6,7,]
                },
                {
                    Name: 'MNO',
                    ColorCode:[4,5,6,9,]
                }                   
            ]
}]

对于颜色代码 = 7，结果应该是一个空数组:[]

提前致谢。

Answer 1

您正在寻找Array.prototype.filter .

// filter out categories that don't contain color code 4
categories.filter(function(category) {
  return category.products.filter(containsColor(4)) > 0;
});

function containsColor(colorCode) {
  return function(product) {
    return product.ColorCode.indexOf(colorCode) >= 0;
  };
}