项目介绍

积木报表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

技术文档

为什么选择 JimuReport?

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

报表设计效果

仪表盘工作台

大屏设计效果


JEECG低代码平台
664 声望84 粉丝