mongoose 没有找到调用group的API 只能用mongodb自带的方式实现。
var xlsx = require('node-xlsx');
var MongoClient = require('mongodb').MongoClient,
Code = require('mongodb').Code;
var collection ;
MongoClient.connect('mongodb://192.168.1.17:27017/test', function(err, db) {
// Create a test collection
collection = db.collection('test_table');
})
exports.index = function(req, res){
var key1 = ['carrier','lang'];
var query1 = { '$or' : [{'impCount': {'$gt' : 16}},{'impCount': {'$lt' : 3}}] };
var initial = {msum : 0};
collection.group(key1, query1, initial, "function (obj, prev) { prev.msum += obj.impCount; }", function(err, datas) {
if(err)
var myDatas = [];
var count = 0;
for (var index in datas) {
var account = datas[index];
var colum = [];
var names;
if (index == 0) {
names = [];
}
for (var index2 in account) {
if (index == 0)
names.push(index2);
var value = account[index2];
if (value == null) {
value = "";
}
colum.push(value);
}
if (index == 0) {
myDatas.push(names);
}
myDatas.push(colum);
if (index == datas.length - 1) {
var buffer = xlsx.build([ {"name": "Group", "data": myDatas}]);
fs.writeFileSync("user.xlsx", buffer, 'binary');
}}
})
res.send("11111");
};