var Csv = require('csv')
//const data=[{c:'111哈s哈',b:2},{c:3,b:4}];//假设这个是从数据库读取出来的json const data = result; const batchname = Batch_Name; //假设这个是从数据库获取到的批次名称 //如果使用中文会有乱码，网上解决方案 使用iconv 将utf8 转换为gbk iconv.convert(content); // console.log(result) Csv.stringify(data, {: columns: ['c','b']//这儿是导出列//这儿是导出列,如果注释本行将导出所有列的值，不然只导出指定列的值 }, (err, output) => { if(err) { return reply({ code:400, msg:"下载出错！！！", data:null }); } output=output.replace(/\"/g,"")//这儿替换所有的双引号
//reply(output) console.log(output)//reply(new Buffer(output, 'utf8').toString('binary')).type('text/csv').charset('ansi').header('Content-Disposition', `attachment;filename=${batchname}.csv`);var buffer=new Buffer(output,'utf8'); var str=iconv.encode(buffer,'gb2312'); reply(str.toString('binary')).type('text/csv').header('Content-Disposition', `attachment;filename=${batchname}.csv`); });
//实例
{ method: ['get'], path: '/vippoints/export/{excelname?}', config: { tags: ['api'], description: ' 会员卡积分导出', notes: '这里是notes对应的内容', }, handler: (request, reply) => { let cookie = request.state; const excelname = request.params.excelname.trim(); if(cookie.ymciadmin) { let accountobj = JSON.parse(security.aes.decrypt(cookie.ymciadmin)); if(accountobj.state == 0 || accountobj.type != 0) { return reply({ code: 542, msg: '你没有此权限' }) } let filter = {}; let pipeline = [{ $match: filter },
{ $group: { _id: "$cardnumber", total: { $sum: "$point" } } }, { $sort: { total: -1 } } ] VPoint.readAllsum(pipeline, (err, docs) => { let arrs = docs; if(docs.length != 0) { Usercenter.readAll({}, (err, result) => { for(var i = 0; i < result.length; i++) { result[i].pointsum = 0; for(var j = 0; j < arrs.length; j++) { if(result[i].vipcardnumber == arrs[j]._id) { result[i].pointsum = arrs[j].total; } } } // console.log(result) let data = []; data[0] = { "name": "姓名", "IDCard": "身份证", "mobile": "电话号码", "vipcardnumber": "会员卡号", "vipleval": "会员级别", "pointsum": "活动积分", "province": "省", "city": "市", "area": "县/区", "address_detail": "详情地址",
} for(var i = 0; i < result.length; i++) { result[i].IDCard = "\'" + result[i].IDCard //身份证长度超过15位需要在前加单引号 data[i + 1] = result[i]; } Csv.stringify(data, { columns: ['name', 'IDCard', 'mobile', 'vipcardnumber', 'vipleval', 'pointsum', 'province', 'city', 'area', 'address_detail'] }, (err, output) => { if(err) { return reply({ code: 400, msg: "下载出错！！！", data: null }); } output = output.replace(/\"/g, "") //reply(buffer.toString('binary')).type('text/csv').header('Content-Disposition', `attachment;filename=${excelname}.csv`); // 解决不同浏览器下载文件名称乱码以及 解决excel打开内容乱码 var userAgent = (request.headers['user-agent'] || '').toLowerCase(); if(userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) { reply(Buffer.concat([new Buffer('\xEF\xBB\xBF', 'binary'), new Buffer(output)])).type('xlsx/text/csv').header('Content-Disposition', 'attachment; filename=' + encodeURIComponent(excelname) + '.csv'); } else if(userAgent.indexOf('firefox') >= 0) { reply(Buffer.concat([new Buffer('\xEF\xBB\xBF', 'binary'), new Buffer(output)])).type('xlsx/text/csv').header('Content-Disposition', 'attachment; filename*="utf8\'\'' + encodeURIComponent(excelname)+'.csv"'); } else { reply(Buffer.concat([new Buffer('\xEF\xBB\xBF', 'binary'), new Buffer(output)])).type('xlsx/text/csv').header('Content-Disposition', 'attachment; filename=' + new Buffer(excelname).toString('binary')+'.csv'); } });
}) } else { reply({ code: 235, msg: '未找到相关信息!', data: {} }); } }) } else { reply({ code: 510, msg: '登录失败，请重新登陆!', data: {} }); } }
},
转载于:https://www.cnblogs.com/luoliangfei/p/7509554.html
