【全新改版升级】JimuReport 积木报表 v1.9.0 版本发布，填报...

zhangdaiscott · 发表于 2024-11-4 18:10:49

项目介绍

积木报表JimuReport，是一款免费的数据可视化报表，含报表、仪表盘和大屏设计，像搭建积木一样完全在线设计！功能涵盖：数据报表、打印设计、图表报表、门户设计、大屏设计等！

Web版报表设计器，类Excel操作风格，通过拖拽完成报表设计，所见即所得。
大屏采用类word风格，可以随意拖动组件，想怎么设计怎么设计，可以像百度和阿里一样，设计出炫酷大屏！
从v1.9.0+起积木仪表盘支持大屏迈进了革命的步伐，她的牛叉之处：同时支持仪表盘、大屏、门户（支持交互）、移动。
秉承"简单、易用、专业"的产品理念，极大的降低报表开发难度、缩短开发周期、节省成本。
领先的企业级Web报表，支持各种复杂报表，专注于解决企业报表难题。

当前版本：v1.9.0 | 2024-11-04

集成依赖一、积木报表依赖（springboot2版）

<dependency>
<groupId>org.jeecgframework.jimureport</groupId>
<artifactId>jimureport-spring-boot-starter</artifactId>
<version>1.9.0</version>
</dependency>

复制代码

二、积木仪表盘大屏依赖（springboot2版）

<dependency>
<groupId>org.jeecgframework.jimureport</groupId>
<artifactId>jimureport-dashboard-spring-boot-starter</artifactId>
<version>1.9.0</version>
</dependency>

复制代码

升级日志

此次版本改动较大，完善了填报功能支持行表格、一对多、查询填报等高级填报功能；支持共享数据集；整体界面大改版，使用体验更加简便；仪表盘提供大屏能力，支持黑色主题风格；

报表升级SQL

-- 新功能支持共享数据集
ALTER TABLE jimu_report_db
ADD COLUMN iz_shared_source int(1) NULL COMMENT '是否为共享数据源(0 否 1 是)' AFTER api_convert;
ALTER TABLE jimu_report_db
ADD COLUMN jimu_shared_source_id varchar(32) NULL COMMENT '指向共享数据集的id' AFTER iz_shared_source;

复制代码

仪表盘升级SQL

ALTER TABLE `onl_drag_page`
ADD COLUMN `del_flag` int(11) NULL COMMENT '删除状态( 0未删除 1已删除)' AFTER `visits_num`;
UPDATE `onl_drag_page` SET `del_flag` = 0 WHERE `del_flag` IS NULL;
CREATE TABLE `onl_drag_share` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
`drag_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '在线仪表盘设计器id',
`preview_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '预览地址',
`preview_lock` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码锁',
`last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
`term_of_validity` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '有效期(0:永久有效，1:1天，7:7天)',
`status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否过期(0未过期，1已过期)',
`preview_lock_status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否为密码锁(0 否,1是)',
`share_token` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分享token',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='仪表盘预览分享表';
ALTER TABLE `onl_drag_share`
ADD UNIQUE INDEX `uniq_ods_drag_id`(`drag_id`) USING BTREE COMMENT '仪表盘id唯一索引';
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1501109939736690691', '200', '统计进度图', 'JTotalProgress', 'ri:bar-chart-horizontal-line', 7, NULL, '{\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": -1,\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "value": 50\n }\n ],\n "option": {\r\n "targetValue":{},\n "series": [\n {\n "barWidth": 19,\n "label": {\n "show": true,\n "position": "right",\n "offset": [\n 0,\n -40\n ],\n "formatter": "{c}{a}",\n "color": "black",\n "fontSize": 24\n },\n "itemStyle": {\n "normal": {\n "barBorderRadius": 10\n }\n },\n "color": "#151B87",\n "zlevel": 1\n },\n {\n "type": "bar",\n "barGap": "-100%",\n "color": "#eeeeee",\n "barWidth": 19,\n "itemStyle": {\n "normal": {\n "barBorderRadius": 10\n }\n }\n }\n ]\n }\n}', '1', 'jeecg', '2022-03-08 16:17:54', 'admin', '2022-04-28 20:58:49');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1501109939736690693', '200', '字符云', 'JWordCloud', 'ri:bar-chart-horizontal-line', 7, NULL, '{\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": -1,\n "linkageConfig": [],\n "dataMapping": [\r\n {\r\n "filed": "维度",\r\n "mapping": ""\r\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\r\n "name":"手机",\n "value": 50\n }\n ],\n "option": {\r\n "minSize": 12,\r\n "maxSize": 60,\n "series": [\n {\n "type": "wordCloud",\r\n "shape": "circle"\n }\n ]\n }\n}', '1', 'jeecg', '2022-03-08 16:17:54', 'admin', '2022-04-28 20:58:49');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008904673035976704', '1009728871115423744', '翻牌器', 'JCountTo', NULL, 100, NULL, '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/42/nav",\n "timeOut": 0,\n "background": "#4A90E2",\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "turnConfig": {\n "url": ""\n },\n "chartData": "10000",\n "option": {\n "whole": false,\n "boxWidth":50,\r\n "boxHeight":50,\n "fontSize": 16,\n "color": "#fff",\n "fontWeight": "normal",\n "prefixFontSize": 16,\n "prefixColor": "#fff",\n "prefixFontWeight": "normal",\n "suffix": "",\n "suffixFontSize": 16,\n "suffixColor": "#fff",\n "suffixFontWeight": "normal",\n "prefix": "",\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "body": {\n "text": "",\n "color": "#FFFFFF",\n "fontWeight": "bold",\n "marginLeft": 0,\n "marginTop": 0\n }\n }\n}', '1', 'admin', '2024-10-23 11:13:49', 'admin', '2024-10-23 11:55:21');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1009335943687733248', '1009728871115423744', '男女占比', 'JGender', NULL, 100, NULL, '{\n "w": 8,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/26/pictogram",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "男",\n "mapping": ""\n },\n {\n "filed": "女",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "man": 50,\n "woman": 35\n }\n ],\n "option": {\n "title": {\n "show": true,\n "text": "男女占比"\n },\n "grid": {\n "bottom": 115\n },\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "series": []\n }\n}', '1', 'admin', '2024-10-24 15:47:32', 'admin', '2024-10-24 15:48:01');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1009345312659767296', '1009728871115423744', '颜色块', 'JColorBlock', NULL, 100, NULL, '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/42/nav",\n "timeOut": 0,\n "background": "#4A90E2",\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "前缀",\n "mapping": ""\n },\n {\n "filed": "后缀",\n "mapping": ""\n },\n {\n "filed": "颜色",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "turnConfig": {\n "url": ""\n },\n "chartData": [\n {\n "backgroundColor": "#67C23A",\n "prefix": "朝阳总销售额",\n "value": "12345",\n "suffix": "亿"\n },\n {\n "backgroundColor": "#409EFF",\n "prefix": "昌平总销售额",\n "value": "12345",\n "suffix": "亿"\n },\n {\n "backgroundColor": "#E6A23C",\n "prefix": "海淀总销售额",\n "value": "12345",\n "suffix": "亿"\n },\n {\n "backgroundColor": "#F56C6C",\n "prefix": "西城总销售额",\n "value": "12345",\n "suffix": "亿"\n }\n ],\n "option": {\n "whole": false,\n "width": 50,\n "height": 50,\n "lineNum": 2,\n "borderSplitx": 20,\n "borderSplity": 20,\n "fontSize": 16,\n "color": "#fff",\n "fontWeight": "normal",\n "textAlign": "center",\n "padding": 5,\n "prefixFontSize": 16,\n "prefixColor": "#fff",\n "prefixFontWeight": "normal",\n "prefixSplitx": 0,\n "prefixSplity": 0,\n "suffix": "",\n "suffixSplitx": 0,\n "suffixFontSize": 16,\n "suffixColor": "#fff",\n "suffixFontWeight": "normal",\n "prefix": "",\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "body": {\n "text": "",\n "color": "#FFFFFF",\n "fontWeight": "bold",\n "marginLeft": 0,\n "marginTop": 0\n }\n }\n}', '1', 'admin', '2024-10-24 16:24:45', 'admin', '2024-10-24 16:24:56');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1009386233476579328', '1009728871115423744', '胶囊图', 'JCapsuleChart', NULL, 100, NULL, '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "name": "苹果",\n "value": 1000879,\n "type": "手机品牌"\n },\n {\n "name": "三星",\n "value": 3400879,\n "type": "手机品牌"\n },\n {\n "name": "小米",\n "value": 2300879,\n "type": "手机品牌"\n },\n {\n "name": "oppo",\n "value": 5400879,\n "type": "手机品牌"\n },\n {\n "name": "vivo",\n "value": 3400879,\n "type": "手机品牌"\n }\n ],\n "option": {\n "showValue": false,\n "unit": "",\n "customColor": [],\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "基础柱形图",\n "show": true,\n "textStyle": {\n "color": "#464646",\n "fontWeight": "normal"\n }\n }\n }\n}', '1', 'admin', '2024-10-24 19:07:22', 'admin', '2024-10-24 19:07:37');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1009395760485793792', '1009728871115423744', '动态环形图', 'JActiveRing', NULL, 100, NULL, '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "name": "周口",\n "value": 55\n },\n {\n "name": "南阳",\n "value": 120\n },\n {\n "name": "西峡",\n "value": 78\n },\n {\n "name": "驻马店",\n "value": 66\n },\n {\n "name": "新乡",\n "value": 80\n }\n ],\n "option": {\n "lineWidth": 10,\n "radius": 100,\n "activeRadius": 100,\n "showOriginValue": false,\n "customColor": [],\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "动态环形图",\n "show": true,\n "textStyle": {\n "color": "#464646",\n "fontWeight": "normal"\n }\n }\n }\n}', '1', 'admin', '2024-10-24 19:45:13', 'admin', '2024-10-24 19:45:39');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1009679509282783232', '1009728871115423744', '排行榜', 'JScrollRankingBoard', NULL, 100, NULL, '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "name": "苹果",\n "value": 1000879,\n "type": "手机品牌"\n },\n {\n "name": "三星",\n "value": 3400879,\n "type": "手机品牌"\n },\n {\n "name": "小米",\n "value": 2300879,\n "type": "手机品牌"\n },\n {\n "name": "oppo",\n "value": 5400879,\n "type": "手机品牌"\n },\n {\n "name": "vivo",\n "value": 3400879,\n "type": "手机品牌"\n }\n ],\n "option": {\n "waitTime": 2000,\n "rowNum": 5,\n "carousel": "single",\n "sort": true,\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "排行榜",\n "show": true,\n "textStyle": {\n "color": "#464646",\n "fontWeight": "normal"\n }\n }\n }\n}', '1', 'admin', '2024-10-25 14:32:44', 'admin', '2024-10-25 14:33:00');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1009694340236869632', '1009728871115423744', '轮播表', 'JScrollBoard', NULL, 100, NULL, '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n [\n "行1列1",\n "行1列2",\n "行1列3"\n ],\n [\n "行2列1",\n "行2列2",\n "行2列3"\n ],\n [\n "行3列1",\n "行3列2",\n "行3列3"\n ],\n [\n "行4列1",\n "行4列2",\n "行4列3"\n ],\n [\n "行5列1",\n "行5列2",\n "行5列3"\n ]\n ],\n "option": {\n "waitTime": 2000,\n "rowNum": 5,\n "carousel": "single",\n "sort": true,\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "轮播表",\n "show": true,\n "textStyle": {\n "color": "#464646",\n "fontWeight": "normal"\n }\n }\n }\n}', '1', 'admin', '2024-10-25 15:31:40', 'admin', '2024-10-25 15:32:08');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1009728871115423744', '0', '大屏', 'bigscreen', 'ant-design:fund-projection-screen-outlined', 100, NULL, NULL, '1', 'admin', '2024-10-25 17:48:53', 'admin', '2024-10-25 17:49:14');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1009728983979950080', '1009728871115423744', '边框', 'border', NULL, 100, NULL, NULL, '1', 'admin', '2024-10-25 17:49:20', 'admin', '2024-10-25 17:49:50');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1009729002476830720', '1009728871115423744', '装饰', 'decoration', NULL, 100, NULL, NULL, '1', 'admin', '2024-10-25 17:49:24', 'admin', '2024-10-25 17:50:05');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1010847514343669760', '1009728871115423744', '水波图', 'JLiquid', NULL, 100, NULL, '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "value": 25\n }\n ],\n "option": {\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "水波图",\n "show": true,\n "textStyle": {\n "color": "#464646",\n "fontWeight": "normal"\n }\n }\n }\n}', '1', 'admin', '2024-10-28 19:53:58', 'admin', '2024-10-28 19:54:17');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1011075798868328448', '1009728871115423744', '玉珏图', 'JRadialBar', NULL, 100, NULL, '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData":[\n {\n "name": "A",\n "value": 297\n },\n {\n "name": "B",\n "value": 506\n },\n {\n "name": "C",\n "value": 805\n },\n {\n "name": "D",\n "value": 1478\n },\n {\n "name": "E",\n "value": 2029\n },\n {\n "name": "F",\n "value": 7100\n },\n {\n "name": "G",\n "value": 7346\n },\n {\n "name": "H",\n "value": 10178\n }\n ],\n "option": {\n "type": "bar",\n "radius": 0.8,\n "innerRadius": 0.2,\n "maxAngle": 240,\n "radiuShow": false,\n "bgShow": false,\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "玉珏图",\n "show": true,\n "textStyle": {\n "color": "#464646",\n "fontWeight": "normal"\n }\n }\n }\n}', '1', 'admin', '2024-10-29 11:01:06', 'admin', '2024-10-29 11:01:35');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1011128533818966016', '1009728871115423744', '百分比条形图', 'JPercentBar', NULL, 100, NULL, '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "分组",\n "mapping": ""\n },\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData":[\n {\n "type": "Asia",\n "name": "1750",\n "value": 502\n },\n {\n "type": "Asia",\n "name": "1800",\n "value": 635\n },\n {\n "type": "Asia",\n "name": "1850",\n "value": 809\n },\n {\n "type": "Asia",\n "name": "1900",\n "value": 947\n },\n {\n "type": "Asia",\n "name": "1950",\n "value": 1402\n },\n {\n "type": "Asia",\n "name": "1999",\n "value": 3634\n },\n {\n "type": "Asia",\n "name": "2050",\n "value": 5268\n },\n {\n "type": "Africa",\n "name": "1750",\n "value": 106\n },\n {\n "type": "Africa",\n "name": "1800",\n "value": 107\n },\n {\n "type": "Africa",\n "name": "1850",\n "value": 111\n },\n {\n "type": "Africa",\n "name": "1900",\n "value": 133\n },\n {\n "type": "Africa",\n "name": "1950",\n "value": 221\n },\n {\n "type": "Africa",\n "name": "1999",\n "value": 767\n },\n {\n "type": "Africa",\n "name": "2050",\n "value": 1766\n },\n {\n "type": "Europe",\n "name": "1750",\n "value": 163\n },\n {\n "type": "Europe",\n "name": "1800",\n "value": 203\n },\n {\n "type": "Europe",\n "name": "1850",\n "value": 276\n },\n {\n "type": "Europe",\n "name": "1900",\n "value": 408\n },\n {\n "type": "Europe",\n "name": "1950",\n "value": 547\n },\n {\n "type": "Europe",\n "name": "1999",\n "value": 729\n },\n {\n "type": "Europe",\n "name": "2050",\n "value": 628\n }\n ],\n "option": {\n "yNameFontColor": "#fff",\n "yNameFontSize": 12,\n "xNameFontColor": "#fff",\n "xNameFontSize": 12,\n "legendLayout": "horizontal",\n "legendPosition": "bottom",\n "legendFontColor": "#fff",\n "legendFontSize": 16,\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "百分比图",\n "show": true,\n "textStyle": {\n "color": "#464646",\n "fontWeight": "normal"\n }\n }\n }\n}', '1', 'admin', '2024-10-29 14:30:39', 'admin', '2024-10-29 14:30:56');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1011137156657872896', '1009728871115423744', '矩形图', 'JRectangle', NULL, 100, NULL, '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "name": "分类 1",\n "value": 560\n },\n {\n "name": "分类 2",\n "value": 500\n },\n {\n "name": "分类 3",\n "value": 150\n },\n {\n "name": "分类 4",\n "value": 140\n },\n {\n "name": "分类 5",\n "value": 115\n },\n {\n "name": "分类 6",\n "value": 95\n },\n {\n "name": "分类 7",\n "value": 90\n },\n {\n "name": "分类 8",\n "value": 75\n },\n {\n "name": "分类 9",\n "value": 98\n },\n {\n "name": "分类 10",\n "value": 60\n },\n {\n "name": "分类 11",\n "value": 45\n },\n {\n "name": "分类 12",\n "value": 40\n },\n {\n "name": "分类 13",\n "value": 40\n },\n {\n "name": "分类 14",\n "value": 35\n },\n {\n "name": "分类 15",\n "value": 40\n },\n {\n "name": "分类 16",\n "value": 40\n },\n {\n "name": "分类 17",\n "value": 40\n },\n {\n "name": "分类 18",\n "value": 30\n },\n {\n "name": "分类 19",\n "value": 28\n },\n {\n "name": "分类 20",\n "value": 16\n }\n ],\n "option": {\n "theme": "default",\n "titleFontSize": 12,\n "titleColor": "#fff",\n "tipFontSize": 12,\n "tipColor": "#fff",\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "基础矩形图",\n "show": true,\n "textStyle": {\n "color": "#464646",\n "fontWeight": "normal"\n }\n }\n }\n}', '1', 'admin', '2024-10-29 15:04:54', 'admin', '2024-10-29 15:05:11');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1011144678642974720', '1009728871115423744', '旋转饼图', 'JRotatePie', NULL, 100, NULL, '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": -1,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "value": 1048,\n "name": "vivo"\n },\n {\n "value": 735,\n "name": "oppo"\n },\n {\n "value": 580,\n "name": "苹果"\n },\n {\n "value": 484,\n "name": "小米"\n },\n {\n "value": 300,\n "name": "三星"\n }\n ],\n "option": {\n "grid": {\n "show": false,\n "bottom": 115\n },\n "title": {\n "text": "旋转饼图",\n "subtext": "",\n "left": "left",\n "textStyle": {\n "fontWeight": "normal"\n },\n "show": true\n },\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "tooltip": {\n "trigger": "item"\n },\n "legend": {\n "orient": "vertical"\n },\n "series": [\n {\n "name": "",\n "type": "pie",\n "data": [],\n "emphasis": {\n "itemStyle": {\n "shadowBlur": 10,\n "shadowOffsetX": 0,\n "shadowColor": "rgba(0, 0, 0, 0.5)"\n }\n }\n }\n ]\n }\n}', '1', 'admin', '2024-10-29 15:34:48', 'admin', '2024-10-29 15:35:16');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1011160078130774016', '1009728871115423744', '视频', 'JVideoPlay', NULL, 100, NULL, '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/42/nav",\n "timeOut": 0,\n "background": "#4A90E2",\n "dataMapping": [\n {\n "filed": "路径",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "src": "http://vjs.zencdn.net/v/oceans.mp4"\n }\n ],\n "option": {\n "autoPlay": false,\n "loop": true\n }\n}', '1', 'admin', '2024-10-29 16:35:59', 'admin', '2024-10-29 16:36:14');
UPDATE `onl_drag_comp` SET `parent_id` = '1537764165146476546', `comp_name` = '普通散点图', `comp_type` = 'JScatter', `icon` = 'mdi:chart-scatter-plot', `order_num` = 100, `type_id` = NULL, `comp_config` = '{\r\n "w": 12,\r\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "name": 200,\n "value": 300\n },\n {\n "name": 400,\n "value": 500\n },\n {\n "name": 150,\n "value": 320\n },\n {\n "name": 320,\n "value": 320\n },\n {\n "name": 170,\n "value": 300\n }\n ],\n "option": {\n "grid": {\n "show": false,\n "bottom": 115\n },\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "基础散点图",\n "show": true,\n "textStyle": {\r\n "fontWeight":"normal"\n }\n },\n "tooltip": {\n "trigger": "item",\n "formatter": "x:{b}<br/>y:{c}",\n "axisPointer": {\n "type": "shadow",\n "label": {\n "show": true,\n "backgroundColor": "#333"\n }\n }\n },\n "yAxis": {\n "splitLine": {\n "interval": 2\n },\n "lineStyle": {\n "color": "#f3f3f3"\n }\n },\n "series": [\n {\n "data": [],\n "type": "scatter",\n "symbolSize": 20,\r\n "itemStyle": {\r\n "color": "#64b5f6"\r\n }\n }\n ]\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = '2022-06-16 14:16:07', `update_by` = NULL, `update_time` = '2022-06-16 17:10:52' WHERE `id` = '1537318081257291777';
UPDATE `onl_drag_comp` SET `parent_id` = '200200', `comp_name` = '基础柱形图', `comp_type` = 'JBar', `icon` = 'ic:baseline-bar-chart', `order_num` = NULL, `type_id` = NULL, `comp_config` = '{\r\n "w": 12,\r\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "name": "苹果",\n "value": 1000879,\n "type": "手机品牌"\n },\n {\n "name": "三星",\n "value": 3400879,\n "type": "手机品牌"\n },\n {\n "name": "小米",\n "value": 2300879,\n "type": "手机品牌"\n },\n {\n "name": "oppo",\n "value": 5400879,\n "type": "手机品牌"\n },\n {\n "name": "vivo",\n "value": 3400879,\n "type": "手机品牌"\n }\n ],\n "option": {\n "grid": {\n "show": false,\n "top":90, \n "bottom": 115,\r\n "containLabel": true\n },\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "基础柱形图",\n "show": true,\n "textStyle": {\r\n "fontWeight":"normal"\n }\n },\n "tooltip": {\n "trigger": "axis",\n "axisPointer": {\n "type": "shadow",\n "label": {\n "show": true,\n "backgroundColor": "#333"\n }\n }\n },\n "yAxis": {\n "splitLine": {\n "interval": 2\n },\n "lineStyle": {\n "color": "#f3f3f3"\n }\n },\n "series": [\n {\n "data": [],\n "type": "bar",\n "barWidth": 40,\n "itemStyle": {\n "color": "#64b5f6",\n "borderRadius": 0\n }\n }\n ]\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = NULL, `update_by` = 'admin', `update_time` = '2022-08-04 19:18:21' WHERE `id` = '200200201';
UPDATE `onl_drag_comp` SET `parent_id` = '200200', `comp_name` = '堆叠柱形图', `comp_type` = 'JStackBar', `icon` = 'ic:outline-stacked-bar-chart', `order_num` = NULL, `type_id` = NULL, `comp_config` = '{\r\n "w": 12,\r\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/26/stackedBar",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "分组",\n "mapping": ""\n },\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "name": "1991",\n "value": 3,\n "type": "Lon"\n },\n {\n "name": "1992",\n "value": 4,\n "type": "Lon"\n },\n {\n "name": "1993",\n "value": 3.5,\n "type": "Lon"\n },\n {\n "name": "1994",\n "value": 5,\n "type": "Lon"\n },\n {\n "name": "1995",\n "value": 4.9,\n "type": "Lon"\n },\n {\n "name": "1996",\n "value": 6,\n "type": "Lon"\n },\n {\n "name": "1997",\n "value": 7,\n "type": "Lon"\n },\n {\n "name": "1998",\n "value": 9,\n "type": "Lon"\n },\n {\n "name": "1999",\n "value": 13,\n "type": "Lon"\n },\n {\n "name": "1991",\n "value": 3,\n "type": "Bor"\n },\n {\n "name": "1992",\n "value": 4,\n "type": "Bor"\n },\n {\n "name": "1993",\n "value": 3.5,\n "type": "Bor"\n },\n {\n "name": "1994",\n "value": 5,\n "type": "Bor"\n },\n {\n "name": "1995",\n "value": 4.9,\n "type": "Bor"\n },\n {\n "name": "1996",\n "value": 6,\n "type": "Bor"\n },\n {\n "name": "1997",\n "value": 7,\n "type": "Bor"\n },\n {\n "name": "1998",\n "value": 9,\n "type": "Bor"\n },\n {\n "name": "1999",\n "value": 13,\n "type": "Bor"\n }\n ],\n "option": {\n "title": {\n "text": "堆叠柱形图",\r\n "textStyle":{\r\n "fontWeight":"normal"\r\n },\n "show": true\n },\n "grid": {\n "bottom": 115,\n "top":90\n },\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "tooltip": {\n "trigger": "axis",\n "axisPointer": {\n "type": "shadow",\n "label": {\n "show": true,\n "backgroundColor": "#333"\n }\n }\n },\n "series": []\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = '2021-12-28 16:18:31', `update_by` = 'admin', `update_time` = '2022-08-04 19:18:32' WHERE `id` = '200200202';
UPDATE `onl_drag_comp` SET `parent_id` = '1537002903949037570', `comp_name` = '双轴图', `comp_type` = 'DoubleLineBar', `icon` = 'material-symbols:ssid-chart', `order_num` = 5, `type_id` = NULL, `comp_config` = '{\r\n "w": 12,\r\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/26/stackedBar",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "分组",\n "mapping": ""\n },\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "seriesType": [\n {\n "series": "降水量",\n "type": "bar"\n },\n {\n "series": "温度",\n "type": "line"\n }\n ],\n "chartData": [\n {\n "name": "1991",\n "value": 110,\n "type": "降水量"\n },\n {\n "name": "1992",\n "value": 130,\n "type": "降水量"\n },\n {\n "name": "1993",\n "value": 113.5,\n "type": "降水量"\n },\n {\n "name": "1994",\n "value": 150,\n "type": "降水量"\n },\n {\n "name": "1995",\n "value": 240.9,\n "type": "降水量"\n },\n {\n "name": "1996",\n "value": 160,\n "type": "降水量"\n },\n {\n "name": "1997",\n "value": 97,\n "type": "降水量"\n },\n {\n "name": "1998",\n "value": 290,\n "type": "降水量"\n },\n {\n "name": "1999",\n "value": 230,\n "type": "降水量"\n },\n {\n "name": "1991",\n "value": 33,\n "type": "温度"\n },\n {\n "name": "1992",\n "value": 35,\n "type": "温度"\n },\n {\n "name": "1993",\n "value": 37,\n "type": "温度"\n },\n {\n "name": "1994",\n "value": 35,\n "type": "温度"\n },\n {\n "name": "1995",\n "value": 34.9,\n "type": "温度"\n },\n {\n "name": "1996",\n "value": 36,\n "type": "温度"\n },\n {\n "name": "1997",\n "value": 37,\n "type": "温度"\n },\n {\n "name": "1998",\n "value": 39,\n "type": "温度"\n },\n {\n "name": "1999",\n "value": 33,\n "type": "温度"\n }\n ],\n "option": {\n "title": {\n "text": "双轴图",\n "show": true,\n "textStyle": {\n "fontWeight": "normal",\n "fontSize": "14"\n }\n },\n "legend": {\n "t": 4\n },\n "grid": {\n "bottom": 115\n },\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "tooltip": {\n "trigger": "axis",\n "axisPointer": {\n "type": "shadow",\n "label": {\n "show": true,\n "backgroundColor": "#333"\n }\n }\n },\n "yAxis": [\n {\n "type": "value"\n },\n {\n "type": "value"\n }\n ],\n "series": []\n }\n}', `status` = '1', `create_by` = 'jeecg', `create_time` = '2022-09-05 19:05:53', `update_by` = 'ldd', `update_time` = '2022-12-06 18:11:10' WHERE `id` = '726723325897637888';
UPDATE `onl_drag_comp` SET `parent_id` = '200', `comp_name` = '进度图', `comp_type` = 'JProgress', `icon` = 'ri:bar-chart-horizontal-line', `order_num` = 7, `type_id` = NULL, `comp_config` = '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": -1,\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "name": "内存使用率",\n "value": 50\n }\n ],\n "option": {\n "grid": {\n "show": false\n },\n "title": {\n "text": "基础进度图",\n "show": true,\n "textStyle": {}\n },\n "tooltip": {\n "trigger": "axis",\n "axisPointer": {\n "type": "shadow",\n "label": {\n "show": true,\n "backgroundColor": "#333"\n }\n }\n },\n "series": [\n {\n "barWidth": 19,\n "label": {\n "show": true,\n "position": "right",\n "offset": [\n 0,\n -40\n ],\n "formatter": "{c}{a}",\n "color": "black",\n "fontSize": 24\n },\n "itemStyle": {\n "normal": {\n "barBorderRadius": 10\n }\n },\n "color": "#151B87",\n "zlevel": 1\n },\n {\n "type": "bar",\n "barGap": "-100%",\n "color": "#eeeeee",\n "barWidth": 19,\n "itemStyle": {\n "normal": {\n "barBorderRadius": 10\n }\n }\n }\n ]\n }\n}', `status` = '1', `create_by` = 'jeecg', `create_time` = '2022-03-08 16:17:54', `update_by` = 'admin', `update_time` = '2022-04-28 20:58:49' WHERE `id` = '1501109939736690689';
UPDATE `onl_drag_comp` SET `parent_id` = '200200', `comp_name` = '背景柱形图', `comp_type` = 'JBackgroundBar', `icon` = 'ic:baseline-bar-chart', `order_num` = 2, `type_id` = NULL, `comp_config` = '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/33/chart",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "维度",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "name": "苹果",\n "value": 1000879,\n "type": "手机品牌"\n },\n {\n "name": "三星",\n "value": 3400879,\n "type": "手机品牌"\n },\n {\n "name": "小米",\n "value": 2300879,\n "type": "手机品牌"\n },\n {\n "name": "oppo",\n "value": 5400879,\n "type": "手机品牌"\n },\n {\n "name": "vivo",\n "value": 3400879,\n "type": "手机品牌"\n }\n ],\n "option": {\n "grid": {\n "show": false,\n "bottom": 115,\n "top": 90\n },\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "背景柱形图",\n "show": true,\n "textStyle": {\n "fontWeight": "normal"\n }\n },\n "tooltip": {\n "trigger": "axis",\n "axisPointer": {\n "type": "shadow",\n "label": {\n "show": true,\n "backgroundColor": "#333"\n }\n }\n },\n "yAxis": {\n "splitLine": {\n "interval": 2\n },\n "lineStyle": {\n "color": "#f3f3f3"\n }\n },\n "series": [\n {\n "data": [],\n "type": "bar",\n "barWidth": 40,\n "itemStyle": {\n "color": "#5470c6",\n "borderRadius": 0\n },\n "showBackground": true,\n "backgroundStyle": {\n "color": "#eee"\n }\n }\n ]\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = '2022-06-15 14:02:45', `update_by` = 'admin', `update_time` = '2022-08-04 19:18:56' WHERE `id` = '1536952329568276481';
UPDATE `onl_drag_comp` SET `parent_id` = '100', `comp_name` = '数值', `comp_type` = 'JNumber', `icon` = 'ant-design:field-number-outlined', `order_num` = 14, `type_id` = NULL, `comp_config` = '{\r\n "w": 12,\r\n "h": 30,\r\n "dataType": 1,\r\n "timeOut": 0,\r\n "turnConfig": {\r\n "url": ""\r\n },\r\n "chartData": {\r\n "value": "1024"\r\n },\r\n "analysis": {\r\n "isCompare": false,\r\n "compareType": "",\r\n "trendType": "1"\r\n },\r\n "option": {\r\n "isCompare": false,\r\n "trendType": "1",\r\n "card": {\r\n "title": "",\r\n "extra": "",\r\n "rightHref": "",\r\n "size": "small",\r\n "textStyle": {\r\n "fontSize": 18,\r\n "fontWeight": "bold",\r\n "color": "#464646"\r\n }\r\n },\r\n "body": {\r\n "text": "",\r\n "fontWeight": "bold"\r\n }\r\n }\r\n}', `status` = '1', `create_by` = 'jeecg', `create_time` = '2022-09-01 15:10:03', `update_by` = 'jeecg', `update_time` = '2022-09-02 16:52:23' WHERE `id` = '725214423934730240';
UPDATE `onl_drag_comp` SET `parent_id` = '100120', `comp_name` = '散点地图', `comp_type` = 'JBubbleMap', `icon` = 'ic:outline-scatter-plot', `order_num` = 1, `type_id` = NULL, `comp_config` = '{\n "w": 12,\n "h": 30,\n "activeKey": 1,\n "dataType": 1,\n "background": "#ffffff",\n "url": "http://api.jeecg.com/mock/33/radar",\n "timeOut": 0,\n "dataMapping": [{\n "filed": "区域",\n "mapping": ""\n }, {\n "filed": "数值",\n "mapping": ""\n }],\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "jsConfig": "",\n "chartData": [\n {\n "name": "北京",\n "value": 199\n },\n {\n "name": "天津",\n "value": 42\n },\n {\n "name": "河北",\n "value": 102\n },\n {\n "name": "山西",\n "value": 81\n },\n {\n "name": "内蒙古",\n "value": 47\n },\n {\n "name": "辽宁",\n "value": 67\n },\n {\n "name": "吉林",\n "value": 82\n },\n {\n "name": "黑龙江",\n "value": 123\n },\n {\n "name": "上海",\n "value": 24\n },\n {\n "name": "江苏",\n "value": 92\n },\n {\n "name": "浙江",\n "value": 114\n },\n {\n "name": "安徽",\n "value": 109\n },\n {\n "name": "福建",\n "value": 116\n },\n {\n "name": "江西",\n "value": 91\n },\n {\n "name": "山东",\n "value": 119\n },\n {\n "name": "河南",\n "value": 137\n },\n {\n "name": "湖北",\n "value": 116\n },\n {\n "name": "湖南",\n "value": 114\n },\n {\n "name": "重庆",\n "value": 91\n },\n {\n "name": "四川",\n "value": 125\n },\n {\n "name": "贵州",\n "value": 62\n },\n {\n "name": "云南",\n "value": 83\n },\n {\n "name": "西藏",\n "value": 9\n },\n {\n "name": "陕西",\n "value": 80\n },\n {\n "name": "甘肃",\n "value": 56\n },\n {\n "name": "青海",\n "value": 10\n },\n {\n "name": "宁夏",\n "value": 18\n },\n {\n "name": "新疆",\n "value": 180\n },\n {\n "name": "广东",\n "value": 123\n },\n {\n "name": "广西",\n "value": 59\n },\n {\n "name": "海南",\n "value": 14\n }\n ],\n "commonOption": {\n "barSize": 10,\n "barColor": "#fff176",\n "barColor2": "#fcc02e",\n "gradientColor": false,\n "areaColor": {},\n "inRange": {\n "color": [\n "#04387b",\n "#467bc0"\n ]\n },\n "breadcrumb": {\n "drillDown": false,\n "textColor": "#000000"\n }\n },\n "option": {\n "drillDown": false,\n "area": {\n "markerCount": 5,\n "shadowBlur": 10,\n "markerOpacity": 1,\n "markerColor": "#DDE330",\n "shadowColor": "#DDE330",\n "scatterLabelShow": false,\n "markerType": "effectScatter",\n "value": [\n "china"\n ],\n "name": [\n "中国"\n ]\n },\n "graphic": [],\n "grid": {\n "show": false,\n "bottom": 115\n },\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "",\n "left": 10,\r\n "textStyle":{\r\n "fontWeight":"normal"\r\n },\n "show": true\n },\n "legend": {\n "data": []\n },\n "visualMap": {\n "show": false,\n "min": 0,\n "type": "continuous",\n "max": 200,\n "left": "5%",\n "top": "bottom",\n "calculable": true,\n "seriesIndex": [\n 1\n ]\n },\n "geo": {\n "top": 30,\n "label": {\n "emphasis": {\n "show": false,\n "color": "#fff"\n }\n },\n "roam": true,\n "zoom": 1,\n "itemStyle": {\n "normal": {\n "borderWidth": 1,\n "areaColor": "",\n "shadowColor": "#80d9f8",\n "shadowOffsetX": 0,\n "shadowOffsetY": 0,\n "shadowBlur": 0\n },\n "emphasis": {\n "areaColor": "#fff59c",\n "borderWidth": 0\n }\n }\n }\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = NULL, `update_by` = 'admin', `update_time` = '2022-08-05 10:32:09' WHERE `id` = '100120100';
UPDATE `onl_drag_comp` SET `parent_id` = '100120', `comp_name` = '飞线地图', `comp_type` = 'JFlyLineMap', `icon` = 'la:plane', `order_num` = 1, `type_id` = NULL, `comp_config` = '{\n "w": 12,\n "h": 50,\n "dataType": 1,\n "background": "#292626",\n "url": "http://api.jeecg.com/mock/33/radar",\n "timeOut": 0,\n "dataMapping": [\n {\n "filed": "区域",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "chartData": [\n {\n "fromName": "江苏",\n "toName": "贵州",\n "fromLng": 118.8062,\n "fromLat": 31.9208,\n "toLng": 106.6992,\n "toLat": 26.7682,\n "value": 100\n },\n {\n "fromName": "江苏",\n "toName": "北京",\n "fromLng": 118.8062,\n "fromLat": 31.9208,\n "toLng": 116.46,\n "toLat": 39.92,\n "value": 100\n },\n {\n "fromName": "新疆",\n "toName": "北京",\n "fromLng": 87.68,\n "fromLat": 43.67,\n "toLng": 116.46,\n "toLat": 39.92,\n "value": 100\n }\n ],\n "commonOption": {\n "barSize": 10,\n "barColor": "#D6F263",\n "barColor2": "#A3DB6B",\n "gradientColor": false,\n "areaColor": {},\n "inRange": {\n "color": [\n "#04387b",\n "#467bc0"\n ]\n },\n "effect": {\n "show": true,\n "trailLength": 0,\n "period": 6,\n "symbolSize": 15\n },\n "breadcrumb": {\n "drillDown": false,\n "textColor": "#ffffff"\n }\n },\n "option": {\n "area": {\n "markerCount": 5,\n "shadowBlur": 10,\n "markerOpacity": 1,\n "markerColor": "#DDE330",\n "shadowColor": "#DDE330",\n "scatterLabelShow": false,\n "markerType": "effectScatter",\n "value": [\n "china"\n ],\n "name": [\n "中国"\n ]\n },\n "graphic": [],\n "grid": {\n "show": false,\n "bottom": 115\n },\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "",\n "padding": [\n 5,\n 0,\n 0,\n 15\n ],\n "show": true\n },\n "visualMap": {\n "show": false,\n "min": 0,\n "type": "continuous",\n "max": 200,\n "left": "5%",\n "top": "bottom",\n "calculable": true,\n "seriesIndex": [\n 2\n ]\n },\n "geo": {\n "top": 80,\n "label": {\n "emphasis": {\n "show": false,\n "color": "#fff"\n }\n },\n "roam": true,\n "zoom": 1,\n "itemStyle": {\n "normal": {\n "borderColor": "#5A7864",\n "borderWidth": 1,\n "areaColor": "#323c48",\n "shadowColor": "",\n "shadowOffsetX": 0,\n "shadowOffsetY": 0,\n "shadowBlur": 0\n },\n "emphasis": {\n "areaColor": "#EEDD78",\n "borderWidth": 0\n }\n }\n }\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = NULL, `update_by` = 'admin', `update_time` = '2022-08-05 11:16:54' WHERE `id` = '100120101';
UPDATE `onl_drag_comp` SET `parent_id` = '100120', `comp_name` = '柱形地图', `comp_type` = 'JBarMap', `icon` = 'uil:graph-bar', `order_num` = 1, `type_id` = NULL, `comp_config` = '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "background": "#ffffff",\n "url": "http://api.jeecg.com/mock/33/radar",\n "timeOut": 0,\n "dataMapping": [\n {\n "filed": "区域",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "chartData": [\n {\n "name": "北京",\n "value": 900\n },\n {\n "name": "山西",\n "value": 1681\n },\n {\n "name": "内蒙古",\n "value": 47\n },\n {\n "name": "辽宁",\n "value": 1667\n },\n {\n "name": "福建",\n "value": 516\n },\n {\n "name": "江西",\n "value": 591\n },\n {\n "name": "山东",\n "value": 419\n },\n {\n "name": "河南",\n "value": 137\n },\n {\n "name": "云南",\n "value": 983\n },\n {\n "name": "西藏",\n "value": 9\n },\n {\n "name": "陕西",\n "value": 580\n },\n {\n "name": "甘肃",\n "value": 556\n },\n {\n "name": "海南",\n "value": 14\n }\n ],\n "commonOption": {\n "barSize": 12,\n "barColor": "#D6F263",\n "barColor2": "#A3DB6B",\n "gradientColor": false,\n "areaColor": {},\n "inRange": {\n "color": [\n "#04387b",\n "#467bc0"\n ]\n },\n "breadcrumb": {\n "drillDown": false,\n "textColor": "#000000"\n }\n },\n "option": {\n "drillDown": false,\n "tooltip": {\n "trigger": "item",\n "show": false,\n "enterable": true,\n "textStyle": {\n "fontSize": 20,\n "color": "#fff"\n },\n "backgroundColor": "rgba(0,2,89,0.8)"\n },\n "area": {\n "markerCount": 5,\n "shadowBlur": 10,\n "markerOpacity": 1,\n "markerColor": "#DDE330",\n "shadowColor": "#DDE330",\n "scatterLabelShow": false,\n "markerType": "effectScatter",\n "value": [\n "china"\n ],\n "name": [\n "中国"\n ]\n },\n "graphic": [],\n "grid": {\n "show": false,\n "bottom": 115\n },\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "",\r\n "textStyle":{\r\n "fontWeight":"normal"\r\n },\n "left": 10,\n "show": true\n },\n "visualMap": {\n "show": false,\n "max": 200,\n "seriesIndex": [\n 0\n ]\n },\n "geo": {\n "top": 30,\n "roam": true,\n "aspectScale": 0.96,\n "zoom": 1,\n "itemStyle": {\n "normal": {\n "borderColor": "#a9a9a9",\n "borderWidth": 1,\n "areaColor": "#37805B",\n "shadowColor": "#80d9f8",\n "shadowOffsetX": 0,\n "shadowOffsetY": 0,\n "shadowBlur": 0\n },\r\n "emphasis": {\r\n "areaColor": "#fff59c"\r\n }\n }\n },\n "series ": []\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = NULL, `update_by` = 'admin', `update_time` = '2022-08-05 11:17:01' WHERE `id` = '100120102';
UPDATE `onl_drag_comp` SET `parent_id` = '100120', `comp_name` = '热力地图', `comp_type` = 'JHeatMap', `icon` = 'carbon:heat-map-02', `order_num` = 1, `type_id` = NULL, `comp_config` = '{\n "w": 12,\n "h": 30,\n "dataType": 1,\n "background": "#000000",\n "url": "http://api.jeecg.com/mock/33/radar",\n "timeOut": 0,\n "dataMapping": [\n {\n "filed": "区域",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n }\n ],\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "chartData": [\n {\n "name": "海门",\n "value": 100\n },\n {\n "name": "鄂尔多斯",\n "value": 112\n },\n {\n "name": "招远",\n "value": 112\n },\n {\n "name": "舟山",\n "value": 112\n },\n {\n "name": "齐齐哈尔",\n "value": 114\n },\n {\n "name": "盐城",\n "value": 100\n },\n {\n "name": "赤峰",\n "value": 16\n },\n {\n "name": "青岛",\n "value": 450\n },\n {\n "name": "乳山",\n "value": 118\n },\n {\n "name": "金昌",\n "value": 119\n },\n {\n "name": "泉州",\n "value": 21\n },\n {\n "name": "莱西",\n "value": 300\n },\n {\n "name": "日照",\n "value": 121\n },\n {\n "name": "胶南",\n "value": 125\n },\n {\n "name": "南通",\n "value": 23\n },\n {\n "name": "拉萨",\n "value": 321\n },\n {\n "name": "云浮",\n "value": 444\n },\n {\n "name": "梅州",\n "value": 25\n },\n {\n "name": "文登",\n "value": 456\n },\n {\n "name": "上海",\n "value": 125\n },\n {\n "name": "攀枝花",\n "value": 125\n },\n {\n "name": "威海",\n "value": 25\n },\n {\n "name": "承德",\n "value": 25\n },\n {\n "name": "厦门",\n "value": 126\n },\n {\n "name": "汕尾",\n "value": 26\n },\n {\n "name": "潮州",\n "value": 247\n },\n {\n "name": "丹东",\n "value": 227\n },\n {\n "name": "太仓",\n "value": 427\n },\n {\n "name": "曲靖",\n "value": 327\n },\n {\n "name": "烟台",\n "value": 28\n },\n {\n "name": "福州",\n "value": 29\n },\n {\n "name": "瓦房店",\n "value": 30\n },\n {\n "name": "即墨",\n "value": 30\n },\n {\n "name": "抚顺",\n "value": 31\n },\n {\n "name": "玉溪",\n "value": 31\n },\n {\n "name": "张家口",\n "value": 31\n },\n {\n "name": "阳泉",\n "value": 31\n },\n {\n "name": "莱州",\n "value": 32\n },\n {\n "name": "湖州",\n "value": 32\n },\n {\n "name": "汕头",\n "value": 32\n },\n {\n "name": "昆山",\n "value": 33\n },\n {\n "name": "宁波",\n "value": 33\n },\n {\n "name": "湛江",\n "value": 33\n },\n {\n "name": "揭阳",\n "value": 34\n },\n {\n "name": "荣成",\n "value": 34\n },\n {\n "name": "连云港",\n "value": 35\n },\n {\n "name": "葫芦岛",\n "value": 35\n },\n {\n "name": "常熟",\n "value": 236\n },\n {\n "name": "东莞",\n "value": 336\n },\n {\n "name": "河源",\n "value": 36\n },\n {\n "name": "淮安",\n "value": 436\n },\n {\n "name": "泰州",\n "value": 236\n },\n {\n "name": "南宁",\n "value": 437\n },\n {\n "name": "营口",\n "value": 37\n },\n {\n "name": "惠州",\n "value": 337\n },\n {\n "name": "江阴",\n "value": 37\n },\n {\n "name": "蓬莱",\n "value": 37\n },\n {\n "name": "韶关",\n "value": 38\n },\n {\n "name": "嘉峪关",\n "value": 38\n },\n {\n "name": "广州",\n "value": 138\n },\n {\n "name": "延安",\n "value": 138\n },\n {\n "name": "太原",\n "value": 139\n },\n {\n "name": "清远",\n "value": 139\n },\n {\n "name": "中山",\n "value": 139\n },\n {\n "name": "昆明",\n "value": 139\n },\n {\n "name": "寿光",\n "value": 440\n },\n {\n "name": "盘锦",\n "value": 40\n },\n {\n "name": "长治",\n "value": 41\n },\n {\n "name": "深圳",\n "value": 41\n },\n {\n "name": "珠海",\n "value": 42\n },\n {\n "name": "宿迁",\n "value": 43\n },\n {\n "name": "咸阳",\n "value": 43\n },\n {\n "name": "铜川",\n "value": 44\n },\n {\n "name": "平度",\n "value": 44\n },\n {\n "name": "佛山",\n "value": 44\n },\n {\n "name": "海口",\n "value": 44\n },\n {\n "name": "江门",\n "value": 45\n },\n {\n "name": "章丘",\n "value": 45\n },\n {\n "name": "肇庆",\n "value": 46\n },\n {\n "name": "大连",\n "value": 47\n },\n {\n "name": "临汾",\n "value": 47\n },\n {\n "name": "吴江",\n "value": 47\n },\n {\n "name": "石嘴山",\n "value": 49\n },\n {\n "name": "沈阳",\n "value": 50\n },\n {\n "name": "苏州",\n "value": 50\n },\n {\n "name": "茂名",\n "value": 50\n },\n {\n "name": "嘉兴",\n "value": 51\n },\n {\n "name": "长春",\n "value": 51\n },\n {\n "name": "胶州",\n "value": 52\n },\n {\n "name": "银川",\n "value": 52\n },\n {\n "name": "张家港",\n "value": 52\n },\n {\n "name": "三门峡",\n "value": 53\n },\n {\n "name": "锦州",\n "value": 154\n },\n {\n "name": "南昌",\n "value": 154\n },\n {\n "name": "柳州",\n "value": 154\n },\n {\n "name": "三亚",\n "value": 154\n },\n {\n "name": "自贡",\n "value": 156\n },\n {\n "name": "吉林",\n "value": 156\n },\n {\n "name": "阳江",\n "value": 257\n },\n {\n "name": "泸州",\n "value": 157\n },\n {\n "name": "西宁",\n "value": 157\n },\n {\n "name": "宜宾",\n "value": 258\n },\n {\n "name": "呼和浩特",\n "value": 58\n },\n {\n "name": "成都",\n "value": 58\n },\n {\n "name": "大同",\n "value": 58\n },\n {\n "name": "镇江",\n "value": 59\n },\n {\n "name": "桂林",\n "value": 59\n },\n {\n "name": "张家界",\n "value": 59\n },\n {\n "name": "宜兴",\n "value": 59\n },\n {\n "name": "北海",\n "value": 60\n },\n {\n "name": "西安",\n "value": 61\n },\n {\n "name": "金坛",\n "value": 62\n },\n {\n "name": "东营",\n "value": 62\n },\n {\n "name": "牡丹江",\n "value": 63\n },\n {\n "name": "遵义",\n "value": 63\n },\n {\n "name": "绍兴",\n "value": 63\n },\n {\n "name": "扬州",\n "value": 64\n },\n {\n "name": "常州",\n "value": 64\n },\n {\n "name": "潍坊",\n "value": 65\n },\n {\n "name": "重庆",\n "value": 66\n },\n {\n "name": "台州",\n "value": 67\n },\n {\n "name": "南京",\n "value": 67\n },\n {\n "name": "滨州",\n "value": 70\n },\n {\n "name": "贵阳",\n "value": 71\n },\n {\n "name": "无锡",\n "value": 71\n },\n {\n "name": "本溪",\n "value": 71\n },\n {\n "name": "克拉玛依",\n "value": 72\n },\n {\n "name": "渭南",\n "value": 72\n },\n {\n "name": "马鞍山",\n "value": 72\n },\n {\n "name": "宝鸡",\n "value": 72\n },\n {\n "name": "焦作",\n "value": 75\n },\n {\n "name": "句容",\n "value": 75\n },\n {\n "name": "北京",\n "value": 79\n },\n {\n "name": "徐州",\n "value": 79\n },\n {\n "name": "衡水",\n "value": 80\n },\n {\n "name": "包头",\n "value": 80\n },\n {\n "name": "绵阳",\n "value": 80\n },\n {\n "name": "乌鲁木齐",\n "value": 84\n },\n {\n "name": "枣庄",\n "value": 84\n },\n {\n "name": "杭州",\n "value": 84\n },\n {\n "name": "淄博",\n "value": 85\n },\n {\n "name": "鞍山",\n "value": 86\n },\n {\n "name": "溧阳",\n "value": 86\n },\n {\n "name": "库尔勒",\n "value": 86\n },\n {\n "name": "安阳",\n "value": 190\n },\n {\n "name": "开封",\n "value": 390\n },\n {\n "name": "济南",\n "value": 292\n },\n {\n "name": "德阳",\n "value": 393\n },\n {\n "name": "温州",\n "value": 95\n },\n {\n "name": "九江",\n "value": 96\n },\n {\n "name": "邯郸",\n "value": 98\n },\n {\n "name": "临安",\n "value": 99\n },\n {\n "name": "兰州",\n "value": 99\n },\n {\n "name": "沧州",\n "value": 100\n },\n {\n "name": "临沂",\n "value": 103\n },\n {\n "name": "南充",\n "value": 104\n },\n {\n "name": "天津",\n "value": 105\n },\n {\n "name": "富阳",\n "value": 106\n },\n {\n "name": "泰安",\n "value": 112\n },\n {\n "name": "诸暨",\n "value": 112\n },\n {\n "name": "郑州",\n "value": 113\n },\n {\n "name": "哈尔滨",\n "value": 114\n },\n {\n "name": "聊城",\n "value": 116\n },\n {\n "name": "芜湖",\n "value": 117\n },\n {\n "name": "唐山",\n "value": 119\n },\n {\n "name": "平顶山",\n "value": 119\n },\n {\n "name": "邢台",\n "value": 119\n },\n {\n "name": "德州",\n "value": 120\n },\n {\n "name": "济宁",\n "value": 120\n },\n {\n "name": "荆州",\n "value": 127\n },\n {\n "name": "宜昌",\n "value": 130\n },\n {\n "name": "义乌",\n "value": 132\n },\n {\n "name": "丽水",\n "value": 133\n },\n {\n "name": "洛阳",\n "value": 134\n },\n {\n "name": "秦皇岛",\n "value": 136\n },\n {\n "name": "株洲",\n "value": 143\n },\n {\n "name": "石家庄",\n "value": 147\n },\n {\n "name": "莱芜",\n "value": 148\n },\n {\n "name": "常德",\n "value": 152\n },\n {\n "name": "保定",\n "value": 153\n },\n {\n "name": "湘潭",\n "value": 154\n },\n {\n "name": "金华",\n "value": 157\n },\n {\n "name": "岳阳",\n "value": 169\n },\n {\n "name": "长沙",\n "value": 175\n },\n {\n "name": "衢州",\n "value": 177\n },\n {\n "name": "廊坊",\n "value": 193\n },\n {\n "name": "菏泽",\n "value": 194\n },\n {\n "name": "合肥",\n "value": 229\n },\n {\n "name": "武汉",\n "value": 273\n },\n {\n "name": "大庆",\n "value": 279\n }\n ],\n "commonOption": {\n "barSize": 10,\n "barColor": "#D6F263",\n "barColor2": "#A3DB6B",\n "gradientColor": false,\n "areaColor": {},\n "heat": {\n "pointSize": 15,\n "blurSize": 20,\n "maxOpacity": 1\n },\n "inRange": {\n "color": [\n "#E08D8D",\n "#ff9800"\n ]\n },\n "breadcrumb": {\n "drillDown": false,\n "textColor": "#ffffff"\n }\n },\n "option": {\n "drillDown": false,\n "area": {\n "markerCount": 5,\n "shadowBlur": 10,\n "markerOpacity": 1,\n "markerColor": "#df2425",\n "shadowColor": "#DDE330",\n "scatterLabelShow": false,\n "markerType": "effectScatter",\n "value": [\n "china"\n ],\n "name": [\n "中国"\n ]\n },\n "graphic": [],\n "grid": {\n "show": false,\n "bottom": 115\n },\n "card": {\n "title": "",\n "extra": "",\n "rightHref": "",\n "size": "default"\n },\n "title": {\n "text": "",\n "left": 10,\r\n "textStyle":{\r\n "fontWeight":"normal"\r\n },\n "show": true\n },\n "legend": {\n "data": []\n },\n "visualMap": {\n "show": true,\n "min": 0,\n "type": "continuous",\n "max": 200,\n "left": "5%",\n "top": "bottom",\n "calculable": true,\n "seriesIndex": [\n 1\n ]\n },\n "geo": {\n "top": 30,\n "label": {\n "emphasis": {\n "show": false,\n "color": "#fff"\n }\n },\n "roam": true,\n "zoom": 1,\n "itemStyle": {\n "normal": {\n "borderColor": "#a9a9a9",\n "borderWidth": 1,\n "areaColor": "",\n "shadowColor": "#80d9f8",\n "shadowOffsetX": 0,\n "shadowOffsetY": 0,\n "shadowBlur": 0\n },\n "emphasis": {\n "areaColor": "#fff59c",\n "borderWidth": 0\n }\n }\n }\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = NULL, `update_by` = 'admin', `update_time` = '2022-08-05 11:17:24' WHERE `id` = '100120106';
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736000', '1009728983979950080', '边框1', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "1",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736002', '1009728983979950080', '边框2', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "2",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736003', '1009728983979950080', '边框3', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "3",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736004', '1009728983979950080', '边框4', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "4",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736005', '1009728983979950080', '边框5', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "5",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736006', '1009728983979950080', '边框6', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "6",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736007', '1009728983979950080', '边框7', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "7",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736008', '1009728983979950080', '边框8', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "8",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736009', '1009728983979950080', '边框9', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "9",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736010', '1009728983979950080', '边框10', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "10",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736011', '1009728983979950080', '边框11', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "11",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736012', '1009728983979950080', '边框12', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "12",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008616402292736013', '1009728983979950080', '边框13', 'JDragBorder', 'ant-design:border-outer-outlined', 100, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "13",\n "title": "边框",\n "titleWidth": 250,\n "mainColor": "#83bff6",\n "subColor": "#00CED1",\n "backgroundColor": "#ffffff00",\n "reverse": false,\n "dur": 3\n }\n}', '1', 'admin', '2024-10-22 16:08:20', 'admin', '2024-10-22 16:08:36');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008622512340893610', '1009729002476830720', '装饰10', 'JDragDecoration', 'ant-design:format-painter-filled', 10, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "10",\n "title": "边框",\n "mainColor": "#00CED1",\n "subColor": "#FAD400",\n "reverse": false,\n "dur": 3,\n "fontSize": 15\n }\n}', '1', 'admin', '2024-10-22 16:32:36', 'admin', '2024-10-22 16:32:48');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008622512340893611', '1009729002476830720', '装饰11', 'JDragDecoration', 'ant-design:format-painter-filled', 11, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "11",\n "title": "装饰",\n "mainColor": "#00CED1",\n "subColor": "#FAD400",\n "reverse": false,\n "dur": 3,\n "fontSize": 15\n }\n}', '1', 'admin', '2024-10-22 16:32:36', 'admin', '2024-10-22 16:32:48');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008622512340893612', '1009729002476830720', '装饰12', 'JDragDecoration', 'ant-design:format-painter-filled', 12, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "12",\n "title": "装饰",\n "mainColor": "#00CED1",\n "subColor": "#FAD400",\n "reverse": false,\n "dur": 3,\n "fontSize": 15\n }\n}', '1', 'admin', '2024-10-22 16:32:36', 'admin', '2024-10-22 16:32:48');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008622512340893691', '1009729002476830720', '装饰1', 'JDragDecoration', 'ant-design:format-painter-filled', 1, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "1",\n "title": "边框",\n "mainColor": "#00CED1",\n "subColor": "#FAD400",\n "reverse": false,\n "dur": 3,\n "fontSize": 15\n }\n}', '1', 'admin', '2024-10-22 16:32:36', 'admin', '2024-10-22 16:32:48');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008622512340893693', '1009729002476830720', '装饰3', 'JDragDecoration', 'ant-design:format-painter-filled', 3, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "3",\n "title": "边框",\n "mainColor": "#00CED1",\n "subColor": "#FAD400",\n "reverse": false,\n "dur": 3,\n "fontSize": 15\n }\n}', '1', 'admin', '2024-10-22 16:32:36', 'admin', '2024-10-22 16:32:48');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008622512340893694', '1009729002476830720', '装饰4', 'JDragDecoration', 'ant-design:format-painter-filled', 4, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "4",\n "title": "边框",\n "mainColor": "#00CED1",\n "subColor": "#FAD400",\n "reverse": false,\n "dur": 3,\n "fontSize": 15\n }\n}', '1', 'admin', '2024-10-22 16:32:36', 'admin', '2024-10-22 16:32:48');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008622512340893695', '1009729002476830720', '装饰5', 'JDragDecoration', 'ant-design:format-painter-filled', 5, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "5",\n "title": "装饰",\n "mainColor": "#00CED1",\n "subColor": "#FAD400",\n "reverse": false,\n "dur": 3,\n "fontSize": 15\n }\n}', '1', 'admin', '2024-10-22 16:32:36', 'admin', '2024-10-22 16:32:48');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008622512340893696', '1009729002476830720', '装饰6', 'JDragDecoration', 'ant-design:format-painter-filled', 6, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "6",\n "title": "边框",\n "mainColor": "#00CED1",\n "subColor": "#FAD400",\n "reverse": false,\n "dur": 3,\n "fontSize": 15\n }\n}', '1', 'admin', '2024-10-22 16:32:36', 'admin', '2024-10-22 16:32:48');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008622512340893697', '1009729002476830720', '装饰7', 'JDragDecoration', 'ant-design:format-painter-filled', 7, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "7",\n "title": "边框",\n "mainColor": "#00CED1",\n "subColor": "#FAD400",\n "reverse": false,\n "dur": 3,\n "fontSize": 15\n }\n}', '1', 'admin', '2024-10-22 16:32:36', 'admin', '2024-10-22 16:32:48');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008622512340893698', '1009729002476830720', '装饰8', 'JDragDecoration', 'ant-design:format-painter-filled', 8, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "8",\n "title": "边框",\n "mainColor": "#00CED1",\n "subColor": "#FAD400",\n "reverse": false,\n "dur": 3,\n "fontSize": 15\n }\n}', '1', 'admin', '2024-10-22 16:32:36', 'admin', '2024-10-22 16:32:48');
INSERT INTO `onl_drag_comp`(`id`, `parent_id`, `comp_name`, `comp_type`, `icon`, `order_num`, `type_id`, `comp_config`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1008622512340893699', '1009729002476830720', '装饰9', 'JDragDecoration', 'ant-design:format-painter-filled', 9, NULL, '{\n "w": 12,\n "h": 12,\n "dataType": 1,\n "option": {\n "type": "9",\n "title": "装饰",\n "mainColor": "#00CED1",\n "subColor": "#FAD400",\n "reverse": false,\n "dur": 3,\n "fontSize": 15\n }\n}', '1', 'admin', '2024-10-22 16:32:36', 'admin', '2024-10-22 16:32:48');

复制代码

新功能

界面布局整体改版，使用更加简便（涉及左侧区域、顶部菜单、右键菜单、右侧配置区）
顶部图标更换，换成两行
新功能，支持共享数据集
新功能，打印当前页
在线填报，填报数据集支持拖拽
在线填报，支持行表格填报
在线填报，支持一对多填报
在线填报，支持查询填报
在线填报，Api支持相对路径
在线填报，支持唯一校验
在线填报，无token访问禁止使用"用户、角色、部门"等敏感控件
在线填报，预览地址改成restful风格
新增填报示例：SQL数据集填报、填报默认值
回收站功能，新删除的报表不在最前面
标题和字段，鼠标放上去显示全文
大数据导出报表失败时增加错误提示
列表优化，点击左侧树可以显示子级的文件夹
保存报表检查下有没有同行多个数据集，有的话提醒一下
列表页面增加批量变更文件夹功能
优化报表分享功能，用户可选是否要token

issues修复

【issues/2972】解决jimureport可上传任意文件漏洞
解决设计报告后无法保存，提示版本已过时严重问题
可以像EXCEL那样填报码？可以拆入行吗？ · Issue #2971
积木报表SQL数据集使用存储过程每次预览未关闭druid连接池 · Issue #2929
单元格中使用concat函数做字符串连接时错误 · Issue #2969
导出问题 · Issue #2964
jmreport可上传任意文件 · Issue #2972
设置动态合并格未合并正确 · Issue #2958
字典字段渲染时，报错 · Issue #2974
字体大小能否支持自定义 · Issue #2375
在报表设计器中如何使用超大字号 · Issue #2970
通过API配置数据字典问题 · Issue #2982
导出pdf报错 · Issue #2983
/drag/onlDragDatasetHead/getTotalData interface has an unauthorized SQL injection vulnerability. · Issue #7237
主子表导出excel，报空指针异常，导出数据为空。 · Issue #2945
预览白屏 · Issue #2975
外部的系统里导入积木报表的链接后打开会报错提示 · Issue #2981
单元格计算后只计算第一行，后面的数值全部都是一样，没有根据前面的数据来计算 · Issue #2980
一个字段设置了别名，对该字段设置组合之后，系统会将别名插入到原查询sql的order by参数中，因原表中无该字段，导致sql执行异常 · Issue #2973
在SQL数据集中明细字段的参数配置中设置排序，预览查询时提示"ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效"的错误 · Issue #2984
自定义函数怎么接收查询参数 · Issue #2989
打印留白问题 issues/3013
缩放打印报错 issues/3022
分享链接在未登录的情况下导出excle有问题JimuReport/issues/2951
分页打印中如何获取当前页金额 issues/2899
springboot3使用分库数据源配置，启动提示Bean被提前实例化 · Issue #3001
TestController被占用问题 · Issue #3045
自动分组问题 · Issue #3068
主子报表，子报表空指针问题 · Issue #3071
添加地图-点地图报表添加完报表参数查询条件后无法运行 · Issue #3064
（Bug）数据字典无法进行更新修改 · Issue #3042
GitHub · Where software is built](https://github.com/jeecgboot/JimuReport/issues/3056)
设置空值不计算后,分组小计的平均值仍然将空值算到计数中 · Issue #3052
图标报表无法预览 · Issue #3088
仪表盘地址栏传动态参数不生效 · Issue #7380
仪表盘设计器API数据集报错 · Issue #7376
仪表盘设计器集成时【customPrePath】不好用 · Issue #3060
积木新仪表盘数据源设置为API获取时，返回数据解析报错。IndexOutOfBoundsExceptions #3048
设置固定表尾，用A4纸打印，但表尾并没有在A4纸下方 #3065

代码下载

https://github.com/jeecgboot/JimuReport

技术文档

快速集成：https://help.jeecg.com/jimureport/quick.htm
官方网站： http://jimureport.com
在线体验： http://jimureport.com/login
技术文档： https://help.jeecg.com/jimureport

为什么选择 JimuReport?

永久免费，支持各种复杂报表，并且傻瓜式在线设计，非常的智能，低代码时代，这个是你的首选！

采用SpringBoot的脚手架项目，都可以快速集成
Web 版设计器，类似于excel操作风格，通过拖拽完成报表设计
通过SQL、API等方式，将数据源与模板绑定。同时支持表达式，自动计算合计等功能，使计算工作量降低
开发效率很高，傻瓜式在线报表设计，一分钟设计一个报表，又简单又强大
支持 ECharts，目前支持28种图表，在线拖拽设计，支持SQL和API两种数据源
支持分组、交叉，合计、表达式等复杂报表
支持打印设计（支持套打、背景打印等）可设置打印边距、方向、页眉页脚等参数一键快速打印同时可实现套打，不动产证等精准、无缝打印
可设计各种类型的单据、大屏，如出入库单、销售单、财务报表、合同、监控大屏、旅游数据大屏等
大屏设计器支持几十种图表样式，可自由拼接、组合，设计炫酷大屏
数据可视化，DataV、帆软的开源替代方案，比帆软拥有更好的体验和更简单的使用方式
积木报表官网 可以在线免费制作报表和大屏，手机号一键注册，便可永久使用。大屏采用类word风格，可以随意拖动组件，想怎么设计怎么设计，可以像百度和阿里一样，设计出炫酷的可视化大屏！重要的是：免费！免费！免费！

报表设计效果

仪表盘工作台

大屏设计效果