javascript - 如何使用自定义日期格式的 find() 方法从集合中检索数据

Question

我的架构

客户.js

import mongoose from 'mongoose';
const Customers = mongoose.Schema({
    CustomerID: { type: String, default: "" },
    Name: { type: String, default: "" },
    Email: { type: String, default: "" },
    PhoneNumber: { type: String, default: "" },
    Join_Date: { type: Date, default: null }
}, { collection: 'Customers' });
export default mongoose.model('Customers', Customers);

我的路由器 Controller

import Customers from "./Customers";
router.post('/List_All_Customers', (req, res) => {
    Customers.find().lean().exec().then((Data) => {
        res.json({Data: Data});
    }).catch((err) => {
        console.log(err);
    });
})

我目前的成绩

{
    Data: [
        {
            CustomerID: "6ad050d4-04ac-41f2-8c93-49f68f106889",
            Name: "Uday Kumar",
            Email: "uday@blaabla.com",
            PhoneNumber: "+91-991010191",
            Join_Date: "2018-04-24T12:00:00.000Z"
        },
        {
            CustomerID: "792b67f9-9026-43bc-9017-46cd2568b4e9",
            Name: "Prem Kumar",
            Email: "prem@blaabla.com",
            PhoneNumber: "+91-881010091",
            Join_Date: "2018-04-24T15:00:00.000Z"
        }
    ]
}

期待结果

{
    Data: [
        {
            CustomerID: "6ad050d4-04ac-41f2-8c93-49f68f106889",
            Name: "Uday Kumar",
            Email: "uday@blaabla.com",
            PhoneNumber: "+91-991010191",
            Join_Date: "Apr-24 2018, 12:00:00"
        },
        {
            CustomerID: "792b67f9-9026-43bc-9017-46cd2568b4e9",
            Name: "Prem Kumar",
            Email: "prem@blaabla.com",
            PhoneNumber: "+91-881010091",
            Join_Date: "Apr-24 2018, 15:00:00"
        }
    ]
}

mongodb 中是否有自定义日期的结果。我在我的项目中使用 mongoose mongodb 连接。

我可以在 momentjs 中使用 for 循环操作数据，但这需要时间。

所以我需要一个解决方案来解决我的问题。

提前致谢。

欢迎提出意见。

Answer 1

你可以使用 javascript ma​​p 函数喜欢

import Customers from "./Customers";
router.post('/List_All_Customers', (req, res) => {
    Customers.find().lean().exec().then((Data) => {
      Promise.resolve(arr.map(item=>{
       item.Join_Date = fnToConvertDateToYourFormate(item.Join_Date);
       return item;
      })).then(Data=>{
        res.json({Data: Data});
      });
    }).catch((err) => {
        console.log(err);
    });
})

或您可以使用 Mongoose MapReduce http://mongoosejs.com/docs/api.html#mapreduce_mapReduce

var o = {};
o.map = function () { 
this.Join_Date = fnToConvertDateToYourFormate(this.Join_Date);
emit(this.CustomerId,this)
}
o.reduce = function (k, vals) {  }
mongoose.model('Customers').mapReduce(o, function (err, results) {
  console.log(results)
});