MMM-MealViewer

kazanjig

I’m trying to develop a module to get today’s school lunch menu options from my kids’ school. The district uses a service provided by mealviewer.com. The API is available at https://api.mealviewer.com/api/v4/school/[schoolname]/[date range start MM-DD-YYYY]/[date range end MM-DD-YYYY]/. To keep it simple I’m only pulling the current day so the start and end date values are the same.

Here’s an example: https://api.mealviewer.com/api/v4/school/ElmwoodElementary/02-15-2019/02-15-2019/

You can see that there is a TON of XML data returned. I’m only interested in the [CafeteriaLine] nodes and each of their respective [FoodItem] nodes and then the respective [Item_Type] and [Item_Name] for each [FoodItem].

I’m able to send an HTTP request and get (some) data but, unfortunately, most of the nonsense is returned and I don’t see the menu information. It’s like a big chunk out of the middle of the XML data is missing, whether I dump it out to the log before or after parsing it to JSON.

Any thoughts?

cowboysdude

Happy to help… when you have time we can chat.

Mykle1

@cowboysdude said in MMM-MealViewer:

Happy to help… when you have time we can chat.

You are in danger of getting a reputation for being a nice guy. ;-)

cowboysdude

@mykle1 said in MMM-MealViewer:

@cowboysdude said in MMM-MealViewer:

Happy to help… when you have time we can chat.

You are in danger of getting a reputation for being a nice guy. ;-)

Mykle1

@cowboysdude

cowboysdude

kazanjig

.@cowboysdude was exceptionally helpful last night.
thumbs up

sdetweil

Behave boys! Lol

cowboysdude

@sdetweil said in MMM-MealViewer:

Behave boys! Lol

@sdetweil said in MMM-MealViewer:

Behave boys! Lol

We try VERY hard LOL

kazanjig

But now I seem to have gotten myself into a pickle. I tried expanding the functionality to add a date range and multiple schools and, of course, I broke it. It’s doing the same thing as before where the ‘cafeteriaLineList’ property is stripped out of the helper results…

EDIT:
LOL, it’s the weekend and I had it pulling just for today, Sunday. Of course there’s no data. Dumb da dumb dumb…

cowboysdude

@kazanjig said in MMM-MealViewer:

cafeteriaLineList

Probably not stripped out just buried like many of the other things were LOL If you don’t get it we can look at it later if you want.

sdetweil

@cowboysdude you did convert the XML to json, right?

cowboysdude

@sdetweil Yes I did … it’s all coming back as json but it has a TON of data…

kazanjig

MAJOR EDIT, MAJOR DUMMIE: helps if you append the rows to the table… Success! Now for some CSS.

@cowboysdude I edited my earlier post… minor detail about it being the weekend and not being able to pull lunch data for a day with no school. Now just having getting the data to show up in the table…

It will display the “loading” message, but then it’s blank when this.loaded = true. I outputted the innerHTML values to console and they’re all there. Not sure why they won’t show up in the DOM.

  getDom: function() {
    // Set up the local wrapper
    var wrapper = null;

    // If we have some data to display then build the results table
    if (this.loaded) {
      wrapper = document.createElement("table");

      // Iterate through the schools
      for (var i = 0; i < this.results.length; i++) {

        // Set up header row with the school name
        schoolRow = document.createElement("tr");

        schoolName = document.createElement("td");
        schoolName.innerHTML = this.results[i].physicalLocation.name;

        schoolRow.appendChild(schoolName);

        // Iterate through the cafeteria lines for the school
        for (var j = 0; j < this.results[i].menuSchedules[0].menuBlocks[0].cafeteriaLineList.data.length; j++) {

          // Set up header row with the cafeteria line name
          cafeteriaLineRow = document.createElement("tr");

          cafeteriaLineName = document.createElement("td");
          cafeteriaLineName.innerHTML = this.results[i].menuSchedules[0].menuBlocks[0].cafeteriaLineList.data[j].name;

          cafeteriaLineRow.appendChild(cafeteriaLineName);

          // Iterate through the menu items for the cafeteria line
          for (var k = 0; k < this.results[i].menuSchedules[0].menuBlocks[0].cafeteriaLineList.data[j].foodItemList.data.length; k++) {

            foodItemRow = document.createElement("tr");

            foodItemType = document.createElement("td");
            foodItemType.innerHTML = this.results[i].menuSchedules[0].menuBlocks[0].cafeteriaLineList.data[j].foodItemList.data[k].item_Type;

            foodItemName = document.createElement("td");
            foodItemName.innerHTML = this.results[i].menuSchedules[0].menuBlocks[0].cafeteriaLineList.data[j].foodItemList.data[k].item_Name;

            foodItemRow.appendChild(foodItemType);
            foodItemRow.appendChild(foodItemName);
          }
        }
      }
    }

    else {
      // Otherwise lets just use a simple div
      wrapper = document.createElement('div');
      wrapper.innerHTML = 'Loading menu data...';
    }

    return wrapper;
  },

kazanjig

So I now get the following table:

Elementary Lunch
Entree “Bold” Cheese Pizza
Entree “Bold” Pepperoni Pizza
Vegetable Parmesan Butternut Gratin
Vegetable Seasoned Green Beans
Elementary Alternative
Entree Chef Salad
Entree Bologna & Cheese Sandwich

The foodItemType in the first column and the foodItemName in the second column are siblings in the data array.

I’d like turn the first occurrence of foodItemType into a category so the table looks like this (ignore the spacing hyphens):

Elementary Lunch
Entree “Bold” Cheese Pizza
--------------“Bold” Pepperoni Pizza
Vegetable Parmesan Butternut Gratin
-------------------Seasoned Green Beans
Elementary Alternative
Entree Chef Salad
-------------Bologna & Cheese Sandwich

Here’s the current loop that creates the table. Any help would be appreciated.

        // Iterate through the cafeteria lines for the school
        for (var j = 0; j < this.results[i].menuSchedules[0].menuBlocks[0].cafeteriaLineList.data.length; j++) {

          if (this.results[i].menuSchedules[0].menuBlocks[0].cafeteriaLineList.data[j].name !== 'Elmwood Vegetarian Hot Entree') {

            // Set up header row with the cafeteria line name
            cafeteriaLineRow = document.createElement("tr");

            cafeteriaLineName = document.createElement("td");
            cafeteriaLineName.innerHTML = this.results[i].menuSchedules[0].menuBlocks[0].cafeteriaLineList.data[j].name.replace("Elmwood Elementary", "Elementary Lunch").replace("Elmwood Alternative", "Elementary Alternative");
            cafeteriaLineRow.appendChild(cafeteriaLineName);
            wrapper.appendChild(cafeteriaLineRow);

            // Iterate through the menu items for the cafeteria line
            for (var k = 0; k < this.results[i].menuSchedules[0].menuBlocks[0].cafeteriaLineList.data[j].foodItemList.data.length; k++) {

              if (this.results[i].menuSchedules[0].menuBlocks[0].cafeteriaLineList.data[j].foodItemList.data[k].item_Name !== 'Choice Of:') {

                foodItemTypeRow = documen t.createElement("tr");

                foodItemType = document.createElement("td");
                foodItemType.innerHTML = this.results[i].menuSchedules[0].menuBlocks[0].cafeteriaLineList.data[j].foodItemList.data[k].item_Type;

                foodItemName = document.createElement("td");
                foodItemName.innerHTML = this.results[i].menuSchedules[0].menuBlocks[0].cafeteriaLineList.data[j].foodItemList.data[k].item_Name;

                foodItemTypeRow.appendChild(foodItemType);
                wrapper.appendChild(foodItemTypeRow);
                foodItemTypeRow.appendChild(foodItemName);
                wrapper.appendChild(foodItemTypeRow);
              }
            }
          }
        }

gonzonia

@kazanjig I know this post is old, but I’m trying to accomplish this in a different way. I was trying to do it with PHP instead and the XML coming back from the Mealviewer API isn’t recognized but when I load it directly in my browser all looks good. Would you be willing to share all the code you’re using to load this? I’m not as familiar with how the MM code works and how you’re plugging this into the whole thing. My implementation is just a shared home calendar view that I rolled myself (I may have to look into implementing MM though now that I’ve stumbled upon all this).

cowboysdude

@gonzonia PHP won’t work in this software. If he doesn’t answer you I will be happy to help you get this going…

gonzonia

@cowboysdude Thanks. I’m happy to use a JS implementation as well. The family calendar I created is just hitting a wordpress site I’m hosting on a mac mini. PHP was just so that it could load pre-render but the main thing is just to get the meal list populated on the calendar screen instead of having a separate tab open in the browser. I haven’t had a lot of time to try to look into this or switching to MM. I hate to be hijacking a MM thread but this is literally the only discussion I’ve found of anyone accessing the MealViewer data like this.

gonzonia

This post is deleted!

gonzonia

This post is deleted!