| | |
| | | <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> |
| | |
| | | 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' |
| | |
| | | } |
| | | }); |
| | | 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; |
| | | }; |
| | | }); |
| | | }); |