Reimagining data structures with Meteor and MongoDB for more streamlined and sophisticated code

Question

Reimagining data structures with Meteor and MongoDB for more streamlined and sophisticated code

Here is a link to a bin with all the required details: http://jsbin.com/ribor/1/edit?js,output

To make answering on SO easier, I will provide the model examples here:

Orders = {
  _id: "T487wBz7Pvzjo2QHh",
  beverages: [
    { 
      _id: "8ea26bb103efae385f80f881",
      delivered: false,
      name: "Wine",
      units: "55"
    }
  ],
  location: "yTKWLFwSDvp3DyCkx",
  locationName: "Ladies Garden",
  locationNumber: "101",
  timestamp: 1398393004864,
  user_id: "W3Fdq36Ts2TdWxCRP",
  username: "jgeezy"
};

Locations = {
  _id: "yTKWLFwSDvp3DyCkx",
  beverages: [
    {
      _id: "e5552a68266ed76895b8228a",
      fillTo: "10",
      name: "Wine Coolers",
      orderWhen: "10",
      startUnits: "10"
    }
  ],
  name: "Teen Cabana",
  number: "103",
  organization: "Super Happy Teens!",
  vendor: false
};

I am trying to create rows in a table for each location displaying the total number of undelivered beverage orders per location. Though I have a function written for this purpose:

Template.dashboardOrders.undeliveredOrders = ->
  undeliveredOrders = Orders.find({'beverages.delivered': false}, {
    transform: (order) ->
      order.unfilledOrders = 0
      _.each order.beverages, (bev) ->
        if not bev.delivered
          order.unfilledOrders += 1
      order
  })

The current output is an array sorted by Order and timestamp, whereas I need it sorted by unique location and timestamp. I've tried different map and reduce methods but haven't been successful. Any guidance on how to achieve this would be greatly appreciated!

BONUS Additionally, I feel my approach could be more elegant without having to return the order object and use += to increment. Perhaps there is a better way to handle this.

javascript mongodb meteor

Answer 1

Answer №1

To address @jasongonzales' second question, I will now provide a second answer. The initial query returned all undelivered orders sorted by location and timestamp. In addition to this requirement, the following is also needed:

The goal is to include undelivered orders per location along with a count of these orders.

There are multiple approaches to achieve this objective. One effective method involves processing the data retrieved by the query rather than attempting to fit everything into the query itself:

Template.dashboardOrders.undeliveredOrdersByLocation = ->
  orders = Orders.find
      beverages.delivered: no
    ,
      sort:
        location: 1
        timestamp: 1

  # Utilize an object named locations to store undelivered orders organized by location;
  # Keys within the object represent location _id's while values consist of relevant mongo docs:
  locations = {}

  # Iterate through each undelivered order and add it to the respective entry in the locations object:
  orders.forEach (doc) ->
    unless locations[doc.location]?
      locations[doc.location] =
        undeliveredOrders: []
        undeliveredOrdersCount: 0
        location: doc.location
        locationName: doc.locationName
        locationNumber: doc.locationNumber
        # Additional fields based on template requirements 

    locations[doc.location].undeliveredOrders.push doc
    locations[doc.location].undeliveredOrdersCount++

  # Convert the locations object into an array for template usage:
  return _.values(locations) # Discarding keys as they are not needed

A sample template example was not provided, but you can incorporate the locations array in the following manner:

{{#each undeliveredOrdersByLocation}}
  Number of undelivered orders at {{locationName}}: {{undeliveredOrdersCount}}
    {{#each undeliveredOrders}}
      Order placed by {{username}} on {{timestamp}}, comprising:
        <ul>
          {{#each beverages}}
            <li>{{units}} units of {{name}} awaiting delivery.</li>
          {{/each}}
        </ul>
    {{/each}}
{{/each}}

Answer 2

To address @jasongonzales' second question, I will now provide a second answer. The initial query returned all undelivered orders sorted by location and timestamp. In addition to this requirement, the following is also needed:

The goal is to include undelivered orders per location along with a count of these orders.

There are multiple approaches to achieve this objective. One effective method involves processing the data retrieved by the query rather than attempting to fit everything into the query itself:

Template.dashboardOrders.undeliveredOrdersByLocation = ->
  orders = Orders.find
      beverages.delivered: no
    ,
      sort:
        location: 1
        timestamp: 1

  # Utilize an object named locations to store undelivered orders organized by location;
  # Keys within the object represent location _id's while values consist of relevant mongo docs:
  locations = {}

  # Iterate through each undelivered order and add it to the respective entry in the locations object:
  orders.forEach (doc) ->
    unless locations[doc.location]?
      locations[doc.location] =
        undeliveredOrders: []
        undeliveredOrdersCount: 0
        location: doc.location
        locationName: doc.locationName
        locationNumber: doc.locationNumber
        # Additional fields based on template requirements 

    locations[doc.location].undeliveredOrders.push doc
    locations[doc.location].undeliveredOrdersCount++

  # Convert the locations object into an array for template usage:
  return _.values(locations) # Discarding keys as they are not needed

A sample template example was not provided, but you can incorporate the locations array in the following manner:

{{#each undeliveredOrdersByLocation}}
  Number of undelivered orders at {{locationName}}: {{undeliveredOrdersCount}}
    {{#each undeliveredOrders}}
      Order placed by {{username}} on {{timestamp}}, comprising:
        <ul>
          {{#each beverages}}
            <li>{{units}} units of {{name}} awaiting delivery.</li>
          {{/each}}
        </ul>
    {{/each}}
{{/each}}

Answer 3

Answer №2

Have you considered this approach instead?

Template.dashboardOrders.pendingOrders = ->
  Orders.find
      status: pending
    ,
      sort:
        dateCreated: 1
        timestamp: 1

What do you think of this solution?

If you prefer an array over a cursor, simply include .fetch() at the end.

Answer 4

Have you considered this approach instead?

Template.dashboardOrders.pendingOrders = ->
  Orders.find
      status: pending
    ,
      sort:
        dateCreated: 1
        timestamp: 1

What do you think of this solution?

If you prefer an array over a cursor, simply include .fetch() at the end.

Reimagining data structures with Meteor and MongoDB for more streamlined and sophisticated code

Answer №1

Answer №2

Similar questions

Get rid of the .php extension in the URL completely

Having difficulty accessing a JSON imported object beyond the FOR loop

Running a Python Selenium script

I'm having trouble getting my JavaScript function to run all of the code

Issue with MongoDB's addToSet function failing to add an element to an array

in AngularJS, check for object attributes existence before proceeding to use them

Guide to delivering a PDF document from a controller

When troubleshooting a basic Node.js CRUD API with Postman, an error stating "Cannot Post" is encountered. What steps can be taken to address this issue and resolve it?

A guide on switching the status of various inputs in a table based on the selection of a radio button

How can you simultaneously start multiple tweens in Three.js using Tween chain?

Monitoring Local Host with MongoDB Service

Using JavaScript to implement word filtering in MongoDB

Is there a way to automate the duplication/copying of files using JavaScript?

Extracting a precise data point stored in Mongo database

Struggling to store pushed data accurately into an array using node.js

Guide on synchronizing information from mongodb to elasticsearch through Logstash

Inserting a large array using Mongoose's insertMany method may not be as effective

The heroku server in rails4 is experiencing issues with loading stylesheets, images, and javascript

Aggregating nested documents in MongoDB

When the tab on my website is clicked, the fontawesome icons elegantly transition into their designated positions