mongodb aggregation

mongodb.js

// analytics_start_date:1509465600000
// analytics_end_date:1511971200000

db.orders.aggregate([
  {
    $match: {
      // 'user_id': {
      //   $in: [
      //     '1d63afb0-a40a-11e7-822a-3ba2e980456e',
      //     'd6053b60-97a3-11e7-b104-4b6408cb9132'
      //   ]
      // },
      // 'state_timestamp.delivered_time': {
      'created_at': {
        $gte: new Date(1509465600000),
        $lt: new Date(1511971200000)
      }
    }
  },
  {
    $group: {
      _id: '$user_id',
      total_orders: { $sum: 1 },
      collected_orders: {
        $sum: {
          $cond: [{ $eq: ['$state.is_collected', true] }, 1, 0]
        }
      },
      archived_orders: {
        $sum: {
          $cond: [{ $eq: ['$state.is_archived', true] }, 1, 0]
        }
      },
      delivered_orders: {
        $sum: {
          $cond: [{ $eq: ['$state.is_delivered', true] }, 1, 0]
        }
      },
      sorted_orders: {
        $sum: {
          $cond: [{ $eq: ['$state.is_sorted', true] }, 1, 0]
        }
      },
      cancelled_orders: {
        $sum: {
          $cond: [{ $eq: ['$state.is_cancelled', true] }, 1, 0]
        }
      },
    }
  },
  {
    $lookup: {
      from: 'users',
      localField: '_id',
      foreignField: 'id',
      as: '_user'
    }
  },
  {
    $unwind: '$_user'
  },
  {
    $unwind: '$_user'
  },
  {
    $project: {
      _id: 0,
      'account_number': '$_user.account_number',
      'company_name': '$_user.info.company_name',
      total_orders: 1,
      collected_orders: 1,
      sorted_orders: 1,
      delivered_orders: 1,
      archived_orders: 1,
      cancelled_orders: 1,
    }
  },
  {
    $sort: {
      total_orders: -1
    }
  },
  {
    $skip: 2
  },
  {
    $limit: 2
  }
]).pretty()