更新存储在yii2模型中的数组数组中的mongodb文档中的字段

Question

I have a database in mongodb for restaurants. Sample database is as follows.

{
   "restaurantId":"1",
   "menu":
   {
        "menuCategory":
        [
            {
                "menuCategoryId":"12"
                "menuItems":
                [
                    {
                        "menuId":"123",
                        "likesCount":0
                    },
                    {
                        "menuId":"1234",
                        "likesCount":0
                    }
                ]
            },
            {
                "menuCategoryId":"1290"
                "menuItems":
                [
                    {
                        "menuId":"2222",
                        "likesCount":0
                    },
                    {
                        "menuId":"3333",
                        "likesCount":0
                    }
                ]
            }
        ]
   }
}

In this document, I have to either increase or decrease the likes count against the menuId and restaurantId which is received in yii2. I am not able to find the likes count for the particular menuId in the restaurant to update it.

I tried the following query to update the likesCount.

db.restaurants.update({$and:[{"restaurantId":"1"},{"menu.menuCategory.menu.menuId":"123"}]}, {$set:{"likesCount":5}})

Answer 1

This query may help you:-

db.restaurants.update(
{$and:[{"restaurantId":"1"},
{"menu.menuCategory.menuItems.menuId":"123"}]}, 
{$set:{"menu.menuCategory.0.menuItems.0.likesCount":5}})

EDIT

Try something like below:-

 db.restaurants.find(
 {"restaurantId":"1","menu.menuCategory.menuItems.menuId":"123"}).toArray(
function(err, result)
{
    var index,found = false;
  for(var j in result[0].menu.menuCategory){
    for(var i in result[0].menu.menuCategory[j].menuItems)
    {
         if(results[0].menu.menuCategory[j].menuItems[i].menuId == "123")
         {
            found = true;
            index = i;
            break;
        }  
     }}

  if(found)
  {
       var x = 'menu.menuCategory.$.menuItems.'+index+'.likes';

       var  updateObject = {$set : {}};    
       updateObject['$set'][x] = 5;

      db.restaurants.update(
    {"restaurantId":"1",
   "menu.menuCategory.menuItems.menuId":"123"}, updateObject);
  }
});

See if this can help you.