admin管理员组

文章数量:1034052

HighReport报表工具使用Json数据格式数据集方法

HighReport报表工具支持Json数据格式数据集，支持各种复杂Json数据格式

HighReport是报表对Json数据支持最强的，原因有二
  1. 独立自主研发的Json数据解析引擎
  2. 独立自主研发的JsonPath解析引擎

JsonPath支持父路径定位，这样就可以实现一些高级Json报表

序号

节点

说明

1

*

所有节点

2

.

当前节点

3

..

父节点

4

rows

节点名称

5

[]

节点属性

举例

abc/*/efg

abc/*/efg[id==3]

abc/*/efg[id==3 && name=="test"]

为啥研发JsonPah，因为标准的JsonPath库有些功能不支持

复杂Json数据示例

{

"message": {

"header": {

"auth": {

"callerid": "1552267812363",

"license": "9425846d54cf43434b7d81dd6b922fa75",

"token": "392c952d-9c0e-1342-9987-29d6d8319182",

"ipaddr": null,

"macaddr": null

},

"servicecode": {

"systemcode": "",

"busscode": "",

"version": "1",

"apiurl": "/jmzz-y12-blzk/key-query/danger-patient/list"

},

"response": {

"code": 1,

"excode": null,

"text": null,

"detail": null

}

},

"body": {

"bussresponse": {

"code": "1",

"excode": "",

"text": "请求成功",

"detail": ""

},

"queryresponse": {

"pageno": 1,

"pagesize": 10,

"pagecount": 7,

"recordcount": 62,

"sortfiled": null,

"sorttype": null

},

"datacompress": null,

"dataencrypt": null,

"dataset": [

{

"name": "list",

"row": [

{

"aid": 219619,

"patientId": 100022078,

"institutionId": 1,

"bedNum": "0016",

"patientStatus": 1,

"conditionState": 1,

"patientName": "杨二幂",

"deptId": 1069,

"deptName": "住院骨科",

"inpatinetAreaId": 1068,

"inpatinetArea": "骨科病区",

"patientSexId": 1,

"patientSex": "男",

"patientAge": "20岁",

"inhosapplyDate": "2020-05-14 15:57:35",

"outhosapplayDate": null,

"patientPersonId": 591,

"medicalRecordNum": "",

"hospitalId": "02000110",

"doctorGroupId": 100,

"doctorGroupName": "骨科诊疗组",

"nursingGroupId": 79,

"nursingGroupName": "骨科护理组",

"bedDoctorId": 1741,

"bedDoctor": "江二峰",

"bedNurId": 1743,

"bedNur": "陈二红",

"chargeDoctorId": 1741,

"chargeDoctor": "江二峰",

"directorDoctorId": 1741,

"directorDoctor": "江峰",

"inhosImpName": "乙型病毒性肝炎",

"inhosImpDate": "2021-07-23 11:28:36",

"dangerDate": "2020-08-03 16:46:00"

},

{

"aid": 10343,

"patientId": 100022078,

"institutionId": 1,

"bedNum": "0016",

"patientStatus": 1,

"conditionState": 2,

"patientName": "杨二幂",

"deptId": 1069,

"deptName": "住院骨科",

"inpatinetAreaId": 1068,

"inpatinetArea": "骨科病区",

"patientSexId": 1,

"patientSex": "男",

"patientAge": "20岁",

"inhosapplyDate": "2020-05-14 15:57:35",

"outhosapplayDate": null,

"patientPersonId": 591,

"medicalRecordNum": "",

"hospitalId": "02000110",

"doctorGroupId": 100,

"doctorGroupName": "骨科诊疗组",

"nursingGroupId": 79,

"nursingGroupName": "骨科护理组",

"bedDoctorId": 1741,

"bedDoctor": "江二峰",

"bedNurId": 1743,

"bedNur": "陈二红",

"chargeDoctorId": 1741,

"chargeDoctor": "江二峰",

"directorDoctorId": 1741,

"directorDoctor": "江二峰",

"inhosImpName": "乙型病毒性肝炎",

"inhosImpDate": "2021-07-23 11:28:36",

"dangerDate": "2020-05-23 12:15:14"

}

]

}

]

},

"extend": null

}

}

报表设置Json数据集

支持WebApi标准接口

报表左边展示Json数据层次结构，支持对象、属性和数组

数据结构是2个不同的子节点数组

HighReport报表工具使用Json数据格式数据集方法

HighReport报表工具支持Json数据格式数据集，支持各种复杂Json数据格式

HighReport是报表对Json数据支持最强的，原因有二
  1. 独立自主研发的Json数据解析引擎
  2. 独立自主研发的JsonPath解析引擎

JsonPath支持父路径定位，这样就可以实现一些高级Json报表

序号

节点

说明

1

*

所有节点

2

.

当前节点

3

..

父节点

4

rows

节点名称

5

[]

节点属性

举例

abc/*/efg

abc/*/efg[id==3]

abc/*/efg[id==3 && name=="test"]

为啥研发JsonPah，因为标准的JsonPath库有些功能不支持

复杂Json数据示例

{

"message": {

"header": {

"auth": {

"callerid": "1552267812363",

"license": "9425846d54cf43434b7d81dd6b922fa75",

"token": "392c952d-9c0e-1342-9987-29d6d8319182",

"ipaddr": null,

"macaddr": null

},

"servicecode": {

"systemcode": "",

"busscode": "",

"version": "1",

"apiurl": "/jmzz-y12-blzk/key-query/danger-patient/list"

},

"response": {

"code": 1,

"excode": null,

"text": null,

"detail": null

}

},

"body": {

"bussresponse": {

"code": "1",

"excode": "",

"text": "请求成功",

"detail": ""

},

"queryresponse": {

"pageno": 1,

"pagesize": 10,

"pagecount": 7,

"recordcount": 62,

"sortfiled": null,

"sorttype": null

},

"datacompress": null,

"dataencrypt": null,

"dataset": [

{

"name": "list",

"row": [

{

"aid": 219619,

"patientId": 100022078,

"institutionId": 1,

"bedNum": "0016",

"patientStatus": 1,

"conditionState": 1,

"patientName": "杨二幂",

"deptId": 1069,

"deptName": "住院骨科",

"inpatinetAreaId": 1068,

"inpatinetArea": "骨科病区",

"patientSexId": 1,

"patientSex": "男",

"patientAge": "20岁",

"inhosapplyDate": "2020-05-14 15:57:35",

"outhosapplayDate": null,

"patientPersonId": 591,

"medicalRecordNum": "",

"hospitalId": "02000110",

"doctorGroupId": 100,

"doctorGroupName": "骨科诊疗组",

"nursingGroupId": 79,

"nursingGroupName": "骨科护理组",

"bedDoctorId": 1741,

"bedDoctor": "江二峰",

"bedNurId": 1743,

"bedNur": "陈二红",

"chargeDoctorId": 1741,

"chargeDoctor": "江二峰",

"directorDoctorId": 1741,

"directorDoctor": "江峰",

"inhosImpName": "乙型病毒性肝炎",

"inhosImpDate": "2021-07-23 11:28:36",

"dangerDate": "2020-08-03 16:46:00"

},

{

"aid": 10343,

"patientId": 100022078,

"institutionId": 1,

"bedNum": "0016",

"patientStatus": 1,

"conditionState": 2,

"patientName": "杨二幂",

"deptId": 1069,

"deptName": "住院骨科",

"inpatinetAreaId": 1068,

"inpatinetArea": "骨科病区",

"patientSexId": 1,

"patientSex": "男",

"patientAge": "20岁",

"inhosapplyDate": "2020-05-14 15:57:35",

"outhosapplayDate": null,

"patientPersonId": 591,

"medicalRecordNum": "",

"hospitalId": "02000110",

"doctorGroupId": 100,

"doctorGroupName": "骨科诊疗组",

"nursingGroupId": 79,

"nursingGroupName": "骨科护理组",

"bedDoctorId": 1741,

"bedDoctor": "江二峰",

"bedNurId": 1743,

"bedNur": "陈二红",

"chargeDoctorId": 1741,

"chargeDoctor": "江二峰",

"directorDoctorId": 1741,

"directorDoctor": "江二峰",

"inhosImpName": "乙型病毒性肝炎",

"inhosImpDate": "2021-07-23 11:28:36",

"dangerDate": "2020-05-23 12:15:14"

}

]

}

]

},

"extend": null

}

}

报表设置Json数据集

支持WebApi标准接口

报表左边展示Json数据层次结构，支持对象、属性和数组

数据结构是2个不同的子节点数组

本文标签： HighReport报表工具使用Json数据格式数据集方法

版权声明：本文标题：HighReport报表工具使用Json数据格式数据集方法 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://it.en369.cn/jiaocheng/1748109556a2254794.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。