i want to get orders distributed by field > fulfillmentStatus:null in next stage i want to get object like {unfulfilled: data, order:data}
exports.getAllOrdersReport = async (req, res) => {
const { accountId } = req.account;
const { startDate, endDate } = req.query;
try {
const stores = await Account.findById({ _id: accountId }).distinct(
'stores'
);
// .exec();
let filter = {
storeId: { $in: stores },
dispatchStatus: { $ne: 'cancel' },
// deliveryStatus: { $ne: 'not_delivered' },
// isAssigned: true,
// isoCreatedAtDate: {
// $gte: new Date(startDate),
// $lt: new Date(endDate),
// },
};
const resultOrders = await Order.aggregate([{ $match: filter }]);
res.status(200).json(resultOrders);
} catch (error) {
console.log(error);
res.json(String(error));
}
};