随感而发,phpexcel 真好用

简单几步就可以实现导入导出!

function exportData() {
    var test = [];
    $.each(printdata, (k, v) => {
        test[k] = v.orderid;
    });
    $.post('/Order/getPrintOrder', {ids: test}, res => {
        var mydata = res;
        $.each(mydata, (k, v) => {
            mydata[k]['kp'] = v['kp'] == 0 ? '专票' : v['kp'] == 1 ? '普票' : '未税';
            mydata[k]['ordertype'] = ordertypeData[v['ordertype']];
            mydata[k]['hk'] = v['hk'] == 0 ? '回款' : '未回款';
            mydata[k]['newqf'] = v['newqf'] == 0 ? '线上订单' : '线下订单';
        });
        mydata.unshift
        ({
            cgorderid: "采购订单号", goodsname: "下单商品", goodsnum: "下单数量", goodsprice: "下单单价", goodstotal: "下单总价",
            sendtime: "送货时间", createtime: "创建时间", name: "联系人", qy: "区域",
            ordertype: "订单状态", pt: "平台", kp: "开票", hk: "回款",
        });
        var mydatas = excel.filterExportData(mydata, [
            "cgorderid", 'goodsname', "goodsnum", "goodsprice", "goodstotal",
            "sendtime", "createtime", "name", "qy",
            "ordertype", "pt", "kp", "hk",
        ]);
        excel.exportExcel({
            sheet1: mydatas
        }, getdate() + '导出线上订单数据.xlsx', 'xlsx');
    })
}