当前博客:关于报表设计器多表打印方案

173 次浏览【转载需注明来源】

博客作者:【快码FOF编程】

个性签名:寒窗苦读十年一朝凤舞九天

在一些特殊场景中,常常需要多表打印;也就是打印中需要存在多张表,例如在打印界面中有三张表,这里称之为:A、B、C。

此时给A表设置200条数据,那么A表就肯定超过了A4纸张的高度;此时就面临一个问题:B表如何放在A表的最后面呢,同样的C表又如何放在B表的后面呢?

针对这种场景,快码FOF报表设计器给出一个方案,那就是自定义CSS的组件关联。

表关联一般使用以下三个属性:

  "上级组件ID": "reportFormsTable_2",
  "上级组件ID间隔": "10",
  "上级组件加载时间": "200"

其中"上级组件ID"是上一个表的ID,例如上述场景中的A、B、C三张表,如果想要B表放在A表的后面,则给B表设置自定义CSS的关联就行,参考下图:

给B表设置了上级组件ID为A 表的ID,此时B表就可以关联A表,永远存在于A表的后面,同时上级组件ID间隔则是离A表的间隔距离。

这里要注重的讲解一下上级组件加载时间,这个非常重要,它有一个加载顺序,例如上述案例中有A、B、C三张表,那么B表在A表的后面,则"上级组件加载时间"通常输入100,而C表要在B表的后面,则C表的“上级组件加载时间”最好是200;其余的则以此类推~

上述案例的布局源码如下:

布局测试案例代码文件:

多表关联打印案例.zip

布局源代码:

{
  "version": "1.0.0",
  "formName": "表单示例",
  "Author": "快码编程UI设计器",
  "formId": "formPreviewForm",
  "generateId": 4,
  "data": [
    {
      "id": "reportFormsTable_1",
      "index": 0,
      "tag": "reportFormsTable",
      "tagIcon": "layui-icon layui-icon-picture",
      "title": "打印表格",
      "width": "100%",
      "height": "250",
      "margin": "",
      "padding": "",
      "left": 0,
      "top": 1,
      "zIndex": 1,
      "reportFormsColumn": 1,
      "reportFormsRow": false,
      "reportFormsColumnMargin": 5,
      "reportFormsSqlType": "普通数据模式",
      "reportFormsDataType": "不跟随数据库变动",
      "reportFormsTableType": false,
      "reportFormsTableRowsSize": "默认尺寸",
      "reportFormsTableLine": "",
      "reportFormsTableHead": "[{\"数据\": [{ \"内容\": \"姓名\",\"宽度\":100 },{ \"内容\": \"年龄\" }]}]",
      "reportFormsTableHeadToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsTableData": "[{\"数据\": [{ \"内容\": \"张三\" },{ \"内容\": \"24\" }]},{\"数据\": [{ \"内容\": \"李四\" },{ \"内容\": \"25\" }]}]",
      "reportFormsTableDataToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsStyle": "{\"边框颜色\": \"#eee\"}",
      "reportFormsStyleToolJson": {
        "宽度": 100,
        "高度": 100,
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "上边框颜色": "#000",
        "右边框颜色": "#000",
        "下边框颜色": "#000",
        "左边框颜色": "#000",
        "自定义CSS": "",
        "上级组件ID": "",
        "上级组件ID间隔": "10",
        "上级组件加载时间": "100"
      },
      "reportFormsSqlCode_NoBut": "",
      "reportFormsSqlDataName": "[]",
      "reportFormsCode_NoBut": "",
      "grid": false
    },
    {
      "id": "reportFormsTable_2",
      "index": 1,
      "tag": "reportFormsTable",
      "tagIcon": "layui-icon layui-icon-picture",
      "title": "打印表格",
      "width": "100%",
      "height": 250,
      "margin": "",
      "padding": "",
      "left": -0.8000122070313864,
      "top": 218.59999694824216,
      "zIndex": 2,
      "reportFormsColumn": 1,
      "reportFormsRow": false,
      "reportFormsColumnMargin": 5,
      "reportFormsSqlType": "普通数据模式",
      "reportFormsDataType": "不跟随数据库变动",
      "reportFormsTableType": false,
      "reportFormsTableRowsSize": "默认尺寸",
      "reportFormsTableLine": "",
      "reportFormsTableHead": "[{\"数据\": [{ \"内容\": \"姓名\",\"宽度\":100 },{ \"内容\": \"年龄\" }]}]",
      "reportFormsTableHeadToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsTableData": "[{\"数据\": [{ \"内容\": \"张三\" },{ \"内容\": \"24\" }]},{\"数据\": [{ \"内容\": \"李四\" },{ \"内容\": \"25\" }]}]",
      "reportFormsTableDataToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsStyle": "{\"边框颜色\":\"#eee\",\"上级组件ID间隔\":\"10\",\"上级组件ID\":\"reportFormsTable_1\",\"上级组件加载时间\":\"100\"}",
      "reportFormsStyleToolJson": {
        "宽度": 100,
        "高度": 100,
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "上边框颜色": "#000",
        "右边框颜色": "#000",
        "下边框颜色": "#000",
        "左边框颜色": "#000",
        "自定义CSS": "",
        "上级组件ID": "",
        "上级组件ID间隔": "10",
        "上级组件加载时间": "100"
      },
      "reportFormsSqlCode_NoBut": "",
      "reportFormsSqlDataName": "[]",
      "reportFormsCode_NoBut": "",
      "grid": false
    },
    {
      "id": "reportFormsTable_4",
      "index": 2,
      "tag": "reportFormsTable",
      "tagIcon": "layui-icon layui-icon-picture",
      "title": "打印表格",
      "width": "100%",
      "height": 250,
      "margin": "",
      "padding": "",
      "left": -0.8000122070313864,
      "top": 303.1999969482422,
      "zIndex": 3,
      "reportFormsColumn": 1,
      "reportFormsRow": false,
      "reportFormsColumnMargin": 5,
      "reportFormsSqlType": "普通数据模式",
      "reportFormsDataType": "不跟随数据库变动",
      "reportFormsTableType": false,
      "reportFormsTableRowsSize": "默认尺寸",
      "reportFormsTableLine": "",
      "reportFormsTableHead": "[{\"数据\": [{ \"内容\": \"姓名\",\"宽度\":100 },{ \"内容\": \"年龄\" }]}]",
      "reportFormsTableHeadToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsTableData": "[{\"数据\": [{ \"内容\": \"张三\" },{ \"内容\": \"24\" }]},{\"数据\": [{ \"内容\": \"李四\" },{ \"内容\": \"25\" }]}]",
      "reportFormsTableDataToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsStyle": "{\"边框颜色\":\"#eee\",\"上级组件ID\":\"reportFormsTable_2\",\"上级组件ID间隔\":\"10\",\"上级组件加载时间\":\"200\"}",
      "reportFormsStyleToolJson": {
        "宽度": 100,
        "高度": 100,
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "上边框颜色": "#000",
        "右边框颜色": "#000",
        "下边框颜色": "#000",
        "左边框颜色": "#000",
        "自定义CSS": "",
        "上级组件ID": "",
        "上级组件ID间隔": "10",
        "上级组件加载时间": "100"
      },
      "reportFormsSqlCode_NoBut": "",
      "reportFormsSqlDataName": "[]",
      "reportFormsCode_NoBut": "",
      "grid": false
    }
  ],
  "optionsArray": [
    {
      "id": "reportFormsTable_1",
      "index": 0,
      "tag": "reportFormsTable",
      "tagIcon": "layui-icon layui-icon-picture",
      "title": "打印表格",
      "width": "100%",
      "height": "250",
      "margin": "",
      "padding": "",
      "left": 0,
      "top": 1,
      "zIndex": 1,
      "reportFormsColumn": 1,
      "reportFormsRow": false,
      "reportFormsColumnMargin": 5,
      "reportFormsSqlType": "普通数据模式",
      "reportFormsDataType": "不跟随数据库变动",
      "reportFormsTableType": false,
      "reportFormsTableRowsSize": "默认尺寸",
      "reportFormsTableLine": "",
      "reportFormsTableHead": "[{\"数据\": [{ \"内容\": \"姓名\",\"宽度\":100 },{ \"内容\": \"年龄\" }]}]",
      "reportFormsTableHeadToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsTableData": "[{\"数据\": [{ \"内容\": \"张三\" },{ \"内容\": \"24\" }]},{\"数据\": [{ \"内容\": \"李四\" },{ \"内容\": \"25\" }]}]",
      "reportFormsTableDataToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsStyle": "{\"边框颜色\": \"#eee\"}",
      "reportFormsStyleToolJson": {
        "宽度": 100,
        "高度": 100,
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "上边框颜色": "#000",
        "右边框颜色": "#000",
        "下边框颜色": "#000",
        "左边框颜色": "#000",
        "自定义CSS": "",
        "上级组件ID": "",
        "上级组件ID间隔": "10",
        "上级组件加载时间": "100"
      },
      "reportFormsSqlCode_NoBut": "",
      "reportFormsSqlDataName": "[]",
      "reportFormsCode_NoBut": "",
      "grid": false
    },
    {
      "id": "reportFormsTable_2",
      "index": 1,
      "tag": "reportFormsTable",
      "tagIcon": "layui-icon layui-icon-picture",
      "title": "打印表格",
      "width": "100%",
      "height": 250,
      "margin": "",
      "padding": "",
      "left": -0.8000122070313864,
      "top": 218.59999694824216,
      "zIndex": 2,
      "reportFormsColumn": 1,
      "reportFormsRow": false,
      "reportFormsColumnMargin": 5,
      "reportFormsSqlType": "普通数据模式",
      "reportFormsDataType": "不跟随数据库变动",
      "reportFormsTableType": false,
      "reportFormsTableRowsSize": "默认尺寸",
      "reportFormsTableLine": "",
      "reportFormsTableHead": "[{\"数据\": [{ \"内容\": \"姓名\",\"宽度\":100 },{ \"内容\": \"年龄\" }]}]",
      "reportFormsTableHeadToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsTableData": "[{\"数据\": [{ \"内容\": \"张三\" },{ \"内容\": \"24\" }]},{\"数据\": [{ \"内容\": \"李四\" },{ \"内容\": \"25\" }]}]",
      "reportFormsTableDataToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsStyle": "{\"边框颜色\":\"#eee\",\"上级组件ID间隔\":\"10\",\"上级组件ID\":\"reportFormsTable_1\",\"上级组件加载时间\":\"100\"}",
      "reportFormsStyleToolJson": {
        "宽度": 100,
        "高度": 100,
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "上边框颜色": "#000",
        "右边框颜色": "#000",
        "下边框颜色": "#000",
        "左边框颜色": "#000",
        "自定义CSS": "",
        "上级组件ID": "",
        "上级组件ID间隔": "10",
        "上级组件加载时间": "100"
      },
      "reportFormsSqlCode_NoBut": "",
      "reportFormsSqlDataName": "[]",
      "reportFormsCode_NoBut": "",
      "grid": false
    },
    {
      "id": "reportFormsTable_4",
      "index": 2,
      "tag": "reportFormsTable",
      "tagIcon": "layui-icon layui-icon-picture",
      "title": "打印表格",
      "width": "100%",
      "height": 250,
      "margin": "",
      "padding": "",
      "left": -0.8000122070313864,
      "top": 303.1999969482422,
      "zIndex": 3,
      "reportFormsColumn": 1,
      "reportFormsRow": false,
      "reportFormsColumnMargin": 5,
      "reportFormsSqlType": "普通数据模式",
      "reportFormsDataType": "不跟随数据库变动",
      "reportFormsTableType": false,
      "reportFormsTableRowsSize": "默认尺寸",
      "reportFormsTableLine": "",
      "reportFormsTableHead": "[{\"数据\": [{ \"内容\": \"姓名\",\"宽度\":100 },{ \"内容\": \"年龄\" }]}]",
      "reportFormsTableHeadToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsTableData": "[{\"数据\": [{ \"内容\": \"张三\" },{ \"内容\": \"24\" }]},{\"数据\": [{ \"内容\": \"李四\" },{ \"内容\": \"25\" }]}]",
      "reportFormsTableDataToolJson": {
        "宽度": 100,
        "高度": 100,
        "内容": "",
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "元素ID": "",
        "允许输入": true,
        "合并行": 0,
        "合并列": 0,
        "垂直对齐-居中": "居中对齐",
        "垂直对齐-顶部": "顶部对齐",
        "垂直对齐-底部": "底部对齐",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "边框粗细": 1,
        "上边框颜色": "#000",
        "上边框粗细": 1,
        "右边框颜色": "#000",
        "右边框粗细": 1,
        "下边框颜色": "#000",
        "下边框粗细": 1,
        "左边框颜色": "#000",
        "左边框粗细": 1,
        "自定义CSS": ""
      },
      "reportFormsStyle": "{\"边框颜色\":\"#eee\",\"上级组件ID\":\"reportFormsTable_2\",\"上级组件ID间隔\":\"10\",\"上级组件加载时间\":\"200\"}",
      "reportFormsStyleToolJson": {
        "宽度": 100,
        "高度": 100,
        "字体": "微软雅黑",
        "字体尺寸": 14,
        "背景色": "#FFFFFF",
        "文本色": "#000000",
        "水平对齐-居中": "居中对齐",
        "水平对齐-左侧": "左侧对齐",
        "水平对齐-右侧": "右侧对齐",
        "字体类型-加粗": "粗体",
        "字体类型-正常": "正常",
        "边框颜色": "#000",
        "上边框颜色": "#000",
        "右边框颜色": "#000",
        "下边框颜色": "#000",
        "左边框颜色": "#000",
        "自定义CSS": "",
        "上级组件ID": "",
        "上级组件ID间隔": "10",
        "上级组件加载时间": "100"
      },
      "reportFormsSqlCode_NoBut": "",
      "reportFormsSqlDataName": "[]",
      "reportFormsCode_NoBut": "",
      "grid": false
    }
  ],
  "dataSource": {},
  "formData": {},
  "globalDisable": false,
  "viewOrDesign": true,
  "formDefaultButton": true,
  "formProperty": {},
  "selectItems": [],
  "model": "A4",
  "page": {
    "id": ""
  },
  "elem": {
    "0": {
      "sizzle1706509822161": {
        "undefined": {
          "parentNode": [
            8835,
            19,
            false
          ]
        }
      },
      "sizzle1706509822448": {
        "undefined": {
          "parentNode": [
            1131,
            34,
            true
          ]
        }
      }
    },
    "length": 1
  },
  "id": "formdesigner",
  "size": [
    "21cm",
    "29.7cm"
  ],
  "selectItem": {
    "id": "reportFormsTable_2",
    "index": 1,
    "tag": "reportFormsTable",
    "tagIcon": "layui-icon layui-icon-picture",
    "title": "打印表格",
    "width": "100%",
    "height": 250,
    "margin": "",
    "padding": "",
    "left": -0.8000122070313864,
    "top": 218.59999694824216,
    "zIndex": 2,
    "reportFormsColumn": 1,
    "reportFormsRow": false,
    "reportFormsColumnMargin": 5,
    "reportFormsSqlType": "普通数据模式",
    "reportFormsDataType": "不跟随数据库变动",
    "reportFormsTableType": false,
    "reportFormsTableRowsSize": "默认尺寸",
    "reportFormsTableLine": "",
    "reportFormsTableHead": "[{\"数据\": [{ \"内容\": \"姓名\",\"宽度\":100 },{ \"内容\": \"年龄\" }]}]",
    "reportFormsTableHeadToolJson": {
      "宽度": 100,
      "高度": 100,
      "内容": "",
      "字体": "微软雅黑",
      "字体尺寸": 14,
      "背景色": "#FFFFFF",
      "文本色": "#000000",
      "元素ID": "",
      "允许输入": true,
      "合并行": 0,
      "合并列": 0,
      "垂直对齐-居中": "居中对齐",
      "垂直对齐-顶部": "顶部对齐",
      "垂直对齐-底部": "底部对齐",
      "水平对齐-居中": "居中对齐",
      "水平对齐-左侧": "左侧对齐",
      "水平对齐-右侧": "右侧对齐",
      "字体类型-加粗": "粗体",
      "字体类型-正常": "正常",
      "边框颜色": "#000",
      "边框粗细": 1,
      "上边框颜色": "#000",
      "上边框粗细": 1,
      "右边框颜色": "#000",
      "右边框粗细": 1,
      "下边框颜色": "#000",
      "下边框粗细": 1,
      "左边框颜色": "#000",
      "左边框粗细": 1,
      "自定义CSS": ""
    },
    "reportFormsTableData": "[{\"数据\": [{ \"内容\": \"张三\" },{ \"内容\": \"24\" }]},{\"数据\": [{ \"内容\": \"李四\" },{ \"内容\": \"25\" }]}]",
    "reportFormsTableDataToolJson": {
      "宽度": 100,
      "高度": 100,
      "内容": "",
      "字体": "微软雅黑",
      "字体尺寸": 14,
      "背景色": "#FFFFFF",
      "文本色": "#000000",
      "元素ID": "",
      "允许输入": true,
      "合并行": 0,
      "合并列": 0,
      "垂直对齐-居中": "居中对齐",
      "垂直对齐-顶部": "顶部对齐",
      "垂直对齐-底部": "底部对齐",
      "水平对齐-居中": "居中对齐",
      "水平对齐-左侧": "左侧对齐",
      "水平对齐-右侧": "右侧对齐",
      "字体类型-加粗": "粗体",
      "字体类型-正常": "正常",
      "边框颜色": "#000",
      "边框粗细": 1,
      "上边框颜色": "#000",
      "上边框粗细": 1,
      "右边框颜色": "#000",
      "右边框粗细": 1,
      "下边框颜色": "#000",
      "下边框粗细": 1,
      "左边框颜色": "#000",
      "左边框粗细": 1,
      "自定义CSS": ""
    },
    "reportFormsStyle": "{\"边框颜色\":\"#eee\",\"上级组件ID间隔\":\"10\",\"上级组件ID\":\"reportFormsTable_1\",\"上级组件加载时间\":\"100\"}",
    "reportFormsStyleToolJson": {
      "宽度": 100,
      "高度": 100,
      "字体": "微软雅黑",
      "字体尺寸": 14,
      "背景色": "#FFFFFF",
      "文本色": "#000000",
      "水平对齐-居中": "居中对齐",
      "水平对齐-左侧": "左侧对齐",
      "水平对齐-右侧": "右侧对齐",
      "字体类型-加粗": "粗体",
      "字体类型-正常": "正常",
      "边框颜色": "#000",
      "上边框颜色": "#000",
      "右边框颜色": "#000",
      "下边框颜色": "#000",
      "左边框颜色": "#000",
      "自定义CSS": "",
      "上级组件ID": "",
      "上级组件ID间隔": "10",
      "上级组件加载时间": "100"
    },
    "reportFormsSqlCode_NoBut": "",
    "reportFormsSqlDataName": "[]",
    "reportFormsCode_NoBut": "",
    "grid": false
  },
  "selectItemsAttr": false
}
默认排序
Generic placeholder image
Generic placeholder image
快码FOF编程 Time: 2024-01-30 14:10:53

多表关联打印案例来了


关于报表设计器多表打印方案