首页 网页源码[高级案例] 报表打印合计列案例

报表打印合计列案例

资源信息 :

发布：2024-02-28 18:41:40  阅读：153

转载本资源必须注明出处，欢迎加入官群【445790831】

上传用户 :

资源归属：快码FOF编程

资源状态 :

资源状态：免费下载

资源好评 :
资源下载 :
快码FOF编程的头像

资源作者：【快码FOF编程】

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

看见很多同学都不会报表打印的合计，这里做出了一个案例。

先说说思路，思路其实非常简单，大致为：

1、遍历所有的行

2、取到要合计的列

3、做相加计算

4、把相加的数据置入到合计的列中。

同时这里给出这个案例的设计器代码：

{
  "version": "1.0.0",
  "formName": "表单示例",
  "Author": "快码编程UI设计器",
  "formId": "formPreviewForm",
  "generateId": 1,
  "data": [
    {
      "id": "reportFormsTable_1",
      "index": 0,
      "tag": "reportFormsTable",
      "tagIcon": "layui-icon layui-icon-picture",
      "title": "打印表格",
      "width": "100%",
      "height": "250",
      "margin": "",
      "padding": "",
      "left": 0,
      "top": 5,
      "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\"}]},{\"数据\":[{\"内容\":\"合计：\",\"合并列\":2}]}]",
      "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
    }
  ],
  "optionsArray": [
    {
      "id": "reportFormsTable_1",
      "index": 0,
      "tag": "reportFormsTable",
      "tagIcon": "layui-icon layui-icon-picture",
      "title": "打印表格",
      "width": "100%",
      "height": "250",
      "margin": "",
      "padding": "",
      "left": 0,
      "top": 5,
      "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\"}]},{\"数据\":[{\"内容\":\"合计：\",\"合并列\":2}]}]",
      "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
    }
  ],
  "dataSource": {},
  "formData": {},
  "globalDisable": false,
  "viewOrDesign": true,
  "formDefaultButton": true,
  "formProperty": {},
  "selectItems": [],
  "model": "A4",
  "page": {
    "id": ""
  },
  "elem": {
    "0": {
      "sizzle1709116345128": {
        "undefined": {
          "parentNode": [
            1439,
            19,
            false
          ]
        }
      },
      "sizzle1709116345400": {
        "undefined": {
          "parentNode": [
            246,
            32,
            true
          ]
        }
      }
    },
    "length": 1
  },
  "id": "formdesigner",
  "size": [
    "21cm",
    "29.7cm"
  ],
  "selectItem": {
    "id": "reportFormsTable_1",
    "index": 0,
    "tag": "reportFormsTable",
    "tagIcon": "layui-icon layui-icon-picture",
    "title": "打印表格",
    "width": "100%",
    "height": "250",
    "margin": "",
    "padding": "",
    "left": 0,
    "top": 5,
    "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\"}]},{\"数据\":[{\"内容\":\"合计：\",\"合并列\":2}]}]",
    "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
  }
}
默认排序
Generic placeholder image
测试账号

热门资源
JQ获取layui选择框选中数据案例

102 次浏览数
快码FOF中文编程图片框标签案例

271 次浏览数
快码FOF中文编程-一个比较复杂的工业界面

192 次浏览数
两个按钮，一个开启，则另一个禁用

176 次浏览数
移动端个人信息布局

159 次浏览数
快码FOF中文编程响应式布局-PC与移动端兼容案例

282 次浏览数
快码FOF中文编程-二维码生成案例

162 次浏览数
lay表单大合集案例

651 次浏览数
快码FOF中文编程移动端使用API滚动界面

473 次浏览数
仿shell 跨平台工具 让运维人员，不在局限于win系统！

737 次浏览数
快码FOF中文编程表格合并单元格案例

166 次浏览数
快码FOF-动态渲染左侧导航案例

437 次浏览数
一个气泡提示框插件。

85 次浏览数
layui内置的按钮

330 次浏览数
快码FOF中文编程网页端多页面共享数据案例

194 次浏览数

报表打印合计列案例

元