It is not possible to add items to an array

Question

It is not possible to add items to an array

Attempting to retrieve data from the database using the callback method "getAllOrdersByUserId". The output is displayed below:

[ TextRow {
    DishOrderId: 163,
    BagId: 'BPZDXT68148',
    DateCreated: 2021-05-27T03:55:05.000Z,
    Bags:
     '[{"DishId":43,"DishName":"Kuchvi Biryani","Spicy":2,"UnitPrice":"6.99","Qty":5,"DishTotal":"34.95"}]',
    },
  TextRow {
    DishOrderId: 162,
    BagId: 'BNJENZ08608',
    DateCreated: 2021-05-27T03:46:26.000Z,
    Bags:
     '[{"DishId":41,"DishName":"Dum Biryani","Spicy":2,"UnitPrice":"6.99","Qty":5,"DishTotal":"34.95"}, {"DishId":42,"DishName":"Tysoon Biryani","Spicy":2,"UnitPrice":"6.99","Qty":5,"DishTotal":"34.95"}',
    } ]

Desiring to extract certain attributes from the above results in addition to "Bags". However, the challenge lies in fetching the URL for the image of the dishes, as it is not specified in "Bags". This requires parsing "Bags" and iterating through a loop to obtain the "DishId" that will be used to retrieve the URLs of the images from another method called getDishesByDishIds. The extracted DishIds are as follows:

[43]

[41, 42]

Executing the method getDishesByDishIds would yield the following results for the respective dish Ids when processed in loops:

[ TextRow {
    DishId: 43,
   
    DishImageUrl1:
     'http://192.168.86.104:1111/images/dishImageUrl1_1602546024189.JPG'
 } ]

 [ TextRow {
    DishId: 41,
    DishImageUrl1:
     'http://192.168.86.104:1111/images/dishImageUrl1_1602546024190.JPG'
 },
  TextRow {
    DishId: 42,
    DishImageUrl1:
     'http://192.168.86.104:1111/images/dishImageUrl1_1602546024191.JPG'
} ]

Encountering difficulty in achieving the desired outcome as shown below. The main issue is the inability to include the URLs in the final result as depicted:

{
    "success": 1,
    "bag": [
        {
            "DishOrderId": 163,
            "BagId": "BPZDXT68148",
            "DateCreated": "2021-05-27T03:55:05.000Z",
            "Bags": [
                {
                    "DishId": 43,
                    "DishName": "Kuchvi Biryani",
                    "Spicy": 2,
                    "UnitPrice": "6.99",
                    "Qty": 5,
                    "DishTotal": "34.95"
                }
            ],
            "Url": ['http://192.168.86.104:1111/images/dishImageUrl1_1602546024189.JPG']
        },
        {
            "DishOrderId": 162,
            "BagId": "BNJENZ08608",
            "DateCreated": "2021-05-27T03:46:26.000Z",
            "Bags": [
                {
                    "DishId": 41,
                    "DishName": "Dum Biryani",
                    "Spicy": 2,
                    "UnitPrice": "6.99",
                    "Qty": 5,
                    "DishTotal": "34.95"
                },
                {
                    "DishId": 42,
                    "DishName": "Tysoon Biryani",
                    "Spicy": 2,
                    "UnitPrice": "6.99",
                    "Qty": 5,
                    "DishTotal": "34.95"
                }
            ],
            "Url": ['http://192.168.86.104:1111/images/dishImageUrl1_1602546024190.JPG',
                    'http://192.168.86.104:1111/images/dishImageUrl1_1602546024191.JPG']
        }
    ]
}

The comprehensive code is provided below:

 myOrders: (req, res) => {
    const userId = req.body.userId;
    orderStatus = 2;
    getAllOrdersByUserId(userId, orderStatus, (error, results) => {
      if (error) {
        console.log(error);
        return res.status(500).json({
          success: 0,
          message: "Some other error",
          error: error,
        });
      }
      if (!results) {
        return res.status(404).json({
          success: 0,
          message: "Record not found",
        });
      } else{
        const myOrderArray = []; //this will be new array to store all details including dish Urls
        console.log(results);
        count = 0;
      for (i = 0; i < results.length; i++) { 
        const myOrder = {}
        myOrder.DishOrderId = results[i].DishOrderId;
        myOrder.BagId = results[i].BagId;
        myOrder.DateCreated = results[i].DateCreated;
        myOrder.Bags = JSON.parse(results[i].Bags);
        myOrderArray.push(myOrder);

        OrderDishes = JSON.parse(results[i].Bags);
        //for each one of dish in order dishes get the dish id
        let dishId = []
        DishUrls = [];
        countz = 0;
        for (j = 0; j < OrderDishes.length; j++) {
          dishId.push(OrderDishes[j].DishId);

                  //fetch image url for the dish Id fetched
                  //DishUrls = [];
                  getDishesByDishIds(dishId, (error, getDishesByDishIdsResults) => {
                    if (error) {
                      console.log(error);
                      return res.status(500).json({
                        success: 0,
                        message: "Some other error",
                        error: error,
                      });
                    }
                  
                  console.log(getDishesByDishIdsResults); 
                 // DishUrls = [];
                  count2 = 0;
                  for (l = 0; l < getDishesByDishIdsResults.length; l++) {
                    count2++;
                    if(getDishesByDishIdsResults[l].DishImageUrl1 == undefined){
                      if(count2 == getDishesByDishIdsResults.length){
                        //proceed with other steps
                        console.log(DishUrls);
                      }
                    }
                    else{
                      DishUrls.push(getDishesByDishIdsResults[l].DishImageUrl1);                      
                    }
                  }
                });

          countz ++;
          if(countz == OrderDishes.length){
            //do next step
             console.log(DishUrls);
             myOrder.Url = DishUrls; //not working  , coming incorrect
          }
        }   
      }
      
      return res.json({
        success: 1,
        bag: myOrderArray,
       });

      }
   
    });
  },
};

Apologies for the lengthy post, but any assistance provided will be greatly appreciated as I have been stuck on this issue for a few days.

javascript express

Answer 1

Answer №1

Important Notice

Please bear with me... This code was written in the late hours of the night after an exhausting day at the office...

I have serious doubts about the reliability of this code. It has not been tested properly and is quite poorly written. It might not even function as intended.

However...

I do hope that it can at least point you in the right direction.

Improved Code

myOrders: (req, res) => {
    const userId = req.body.userId;
    let orderStatus = 2;

    getAllOrdersByUserId(userId, orderStatus, (error, results) => {
        if (error) {
            console.log(error);
            res.status(500).json({
                success: 0,
                message: "Another error occurred",
                error: error,
            });

            return;
        }

        if (!results) {
            res.status(404).json({
                success: 0,
                message: "Record not found",
            });

            return;
        }

        for (let i = 0; i < results.length; i++) {
            
            (() => {
                let currentOrder = results[i];
                currentOrder.Bags = JSON.parse(currentOrder.Bags);

                return new Promise((resolve, reject) => {
                    let dishIds = [];

                    for (let j = 0; j < currentOrder.Bags.length; j++) {
                        dishIds.push(currentOrder.Bags[j].DishId);
                    }

                    (() => {
                        return new Promise((innerResolve, innerReject) => {
                            getDishesByDishIds(dishIds, (error, getDishesByDishIdsResults) => {
                                let dishUrlResults = [];

                                if (error) {
                                    innerReject("An error occurred during retrieval of the dish image urls");
                                    return;
                                }
                
                                for (let l = 0; l < getDishesByDishIdsResults.length; l++) {
                                    if (getDishesByDishIdsResults[l].DishImageUrl1 != undefined) {
                                        dishUrlResults.push(getDishesByDishIdsResults[l].DishImageUrl1);
                                    }
                                }

                                innerResolve(dishUrlResults);
                            });
                        });
                    })()
                    .then((urlResults) => {
                        currentOrder.Url = urlResults;
                        resolve();
                    })
                    .catch((innerPromiseError) => {
                        reject(innerPromiseError);
                    });
                });
            })()
            .then(() => {
                res.json({
                    success: 1,
                    bag: results,
                });
            })
            .catch((promiseError) => {
                //Could not complete the request
                console.log(promiseError);

                res.status(500).json({
                    success: 0,
                    message: "Another error occurred",
                    error: error,
                });
            });
        }
    });
}

Answer 2

Important Notice

Please bear with me... This code was written in the late hours of the night after an exhausting day at the office...

I have serious doubts about the reliability of this code. It has not been tested properly and is quite poorly written. It might not even function as intended.

However...

I do hope that it can at least point you in the right direction.

Improved Code

myOrders: (req, res) => {
    const userId = req.body.userId;
    let orderStatus = 2;

    getAllOrdersByUserId(userId, orderStatus, (error, results) => {
        if (error) {
            console.log(error);
            res.status(500).json({
                success: 0,
                message: "Another error occurred",
                error: error,
            });

            return;
        }

        if (!results) {
            res.status(404).json({
                success: 0,
                message: "Record not found",
            });

            return;
        }

        for (let i = 0; i < results.length; i++) {
            
            (() => {
                let currentOrder = results[i];
                currentOrder.Bags = JSON.parse(currentOrder.Bags);

                return new Promise((resolve, reject) => {
                    let dishIds = [];

                    for (let j = 0; j < currentOrder.Bags.length; j++) {
                        dishIds.push(currentOrder.Bags[j].DishId);
                    }

                    (() => {
                        return new Promise((innerResolve, innerReject) => {
                            getDishesByDishIds(dishIds, (error, getDishesByDishIdsResults) => {
                                let dishUrlResults = [];

                                if (error) {
                                    innerReject("An error occurred during retrieval of the dish image urls");
                                    return;
                                }
                
                                for (let l = 0; l < getDishesByDishIdsResults.length; l++) {
                                    if (getDishesByDishIdsResults[l].DishImageUrl1 != undefined) {
                                        dishUrlResults.push(getDishesByDishIdsResults[l].DishImageUrl1);
                                    }
                                }

                                innerResolve(dishUrlResults);
                            });
                        });
                    })()
                    .then((urlResults) => {
                        currentOrder.Url = urlResults;
                        resolve();
                    })
                    .catch((innerPromiseError) => {
                        reject(innerPromiseError);
                    });
                });
            })()
            .then(() => {
                res.json({
                    success: 1,
                    bag: results,
                });
            })
            .catch((promiseError) => {
                //Could not complete the request
                console.log(promiseError);

                res.status(500).json({
                    success: 0,
                    message: "Another error occurred",
                    error: error,
                });
            });
        }
    });
}

It is not possible to add items to an array

Answer №1

Important Notice

Improved Code

Similar questions

Adjust the value based on selection

Guidance on dividing children in an object into distinct arrays

comparing values in an array with jquery

Switching Tabs When a Button is Clicked

When a form is submitted, it causes NodeJs to return an undefined URL segment

Diagnosing circular JSON can be a challenging task

The jsx file is not being parsed by Webpack

Determining When to Activate Button Based on Angular - Verifying That All Choices Have Been Ch

The compatibility issue between Bootstrap4 Navbar and "jQuery.BgSwitcher" is causing functionality limitations on mobile devices

Aggregate information from an array containing multiple nested arrays

What exactly happens behind the scenes when utilizing the React hook useEffect()? Is an effect set up with useEffect able to halt the main thread

Changing a PDF file into binary form using Node JS and Express

Utilize styled-components in next.js to import and resize .svg files seamlessly

Develop an Angular JS directive to create a date input with three separate fields, all

Tips for making nested sliding divs within a parent sliding div

Tips for Retrieving Information from Firebase in an Angular Application

The Datalist feature in HTML5 offers an auto-suggest functionality that displays a list of options beginning with the

Is Node.js Better with a Framework or Without?

Setting the result of d3.csv into a globally accessible variable

Troubleshooting: Issue with selecting items in jQuery Datatables