1

yangle

2023-12-26 0ca6e523743f8772acef18f8b2e42c2df5a093ad

 WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html

@@ -181,6 +181,7 @@
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>生成送货单</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="set_dao"><i class="layui-icon layui-icon-form"></i>导出</button>
                        </div>
                    </script>
                </div>
@@ -229,14 +230,15 @@
            base: '../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index' //主入口模块
        }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer'], function () {
        }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer','excel'], function () {
            var $ = layui.$
                , admin = layui.admin
                , layer = layui.layer
                , laydate = layui.laydate
                , table = layui.table
                , form = layui.form
                , element = layui.element;
                , element = layui.element
                , excel = layui.excel;
            //常规用法
            laydate.render({
                elem: '#HDate1'
@@ -460,7 +462,7 @@
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
                                        break;
                                    default:
                                        if (data[i].name == '订单数量' || data[i].name == '已发货数量' || data[i].name == '未发货数量') {
                                        if (data[i].name == '订单数量' || data[i].name == '已发货数量' || data[i].name == '未发货数量' || data[i].name == '剩余收料数量' || data[i].name == '未到货数量' || data[i].name == '累计收料数量' || data[i].name == '剩余入库数量' || data[i].name == '入库数量') {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, totalRow: true });
                                        } else {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
@@ -880,6 +882,30 @@
                            }
                        });
                        break;
                    case 'set_dao':
                        //获取列表列数据源
                        var ColName = [];
                        for (var i = 1; i < option.cols[0].length; i++) {
                            if (option.cols[0][i]["hide"] != true) {
                                ColName.push(option.cols[0][i]["field"]);
                            }
                        }
                        //绑定数据
                        var data = excel.filterExportData(option.data, ColName)

                        //赋值于表头列名
                        var Title = [];
                        for (var i = 0; i < ColName.length; i++) {
                            Title.push("\"" + ColName[i] + "\":\"" + ColName[i] + "\"");
                        }
                        var TitleName = JSON.parse("{" + Title.toString() + "}");
                        data.unshift(TitleName);

                        //导出 sheet1 工作表名
                        excel.exportExcel({
                            sheet1: data
                        }, '采购订单列表.xlsx', 'xlsx');
                        break;
                };
            });
        });