【界面改版】JimuReport 积木报表 v1.9.0 版本发布，填报能力和大屏能力

2024-11-04 發表於开源资讯

项目介绍

积木报表 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\": [\n0,\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\": [\n0,\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\": [\n1\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\": [\n5,\n0,\n0,\n15\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\": [\n2\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\": [\n0\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\": [\n1\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

技术文档

快速集成：零基础集成积木报表
官方网站： http://jimureport.com
在线体验： http://jimureport.com/login
技术文档： https://help.jeecg.com/jimureport

为什么选择 JimuReport?

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

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

报表设计效果

仪表盘工作台

大屏设计效果

功能清单

├─报表设计器
│├─数据源
││├─支持多种数据源，如Oracle,MySQL,SQLServer,PostgreSQL等主流的数据库
││├─支持SQL编写页面智能化，可以看到数据源下面的表清单和字段清单
││├─支持参数
││├─支持单数据源和多数数据源设置
││├─支持Nosql数据源Redis，MongoDB
││├─支持存储过程
│├─单元格格式
││├─边框
││├─字体大小
││├─字体颜色
││├─背景色
││├─字体加粗
││├─支持水平和垂直的分散对齐
││├─支持文字自动换行设置
││├─图片设置为图片背景
││├─支持无线行和无限列
││├─支持设计器内冻结窗口
││├─支持对单元格内容或格式的复制、粘贴和删除等功能
││├─等等
│├─报表元素
││├─文本类型：直接写文本；支持数值类型的文本设置小数位数
││├─图片类型：支持上传一张图表；支持图片动态生成
││├─图表类型
││├─函数类型
││└─支持求和
││└─平均值
││└─最大值
││└─最小值
│├─背景
││├─背景颜色设置
││├─背景图片设置
││├─背景透明度设置
││├─背景大小设置
│├─数据字典
│├─报表打印
││├─自定义打印
││└─医药笺、逮捕令、介绍信等自定义样式设计打印
││├─简单数据打印
││└─出入库单、销售表打印
││└─带参数打印
││└─分页打印
││├─套打
││└─不动产证打印
││└─打印
│├─数据报表
││├─分组数据报表
││└─横向数据分组
││└─纵向数据分组
││└─多级循环表头分组
││└─横向分组小计
││└─纵向分组小计
││└─分版
││└─分栏
││└─动态合并格
││└─自定义分页条数
││└─合计
││├─交叉报表
││├─明细表
││├─带条件查询报表
││├─表达式报表
││├─带二维码/条形码报表
││├─多表头复杂报表
││├─主子报表
││├─预警报表
││├─数据钻取报表
│├─图形报表
││├─柱形图
││├─堆叠柱形图
││├─折线图
││├─饼图
││├─动态轮播图
││├─折柱图
││├─散点图
││├─漏斗图
││├─雷达图
││├─象形图
││├─地图
││├─仪盘表
││├─关系图
││├─图表背景
││├─图表动态刷新
││├─图表数据字典
│├─参数
││├─参数配置
││├─参数管理
│├─导入导出
││├─支持导入Excel
││├─支持导出Excel、pdf；支持导出excel、pdf带参数
│├─打印设置
││├─打印区域设置
││├─打印机设置
││├─预览
││├─打印页码设置
├─大屏设计器
│├─系统功能
││├─静态数据源和动态数据源设置
││├─基础功能
││└─支持拖拽设计
││└─支持增、删、改、查大屏
││└─支持复制大屏数据和样式
││└─支持大屏预览、分享
││└─支持系统自动保存数据，同时支持手动恢复数据
││└─支持设置大屏密码
││└─支持对组件图层的删除、组合、上移、下移、置顶、置底等
││├─背景设置
││└─大屏的宽度和高度设置
││└─大屏简介设置
││└─背景颜色、背景图片设置
││└─封面图设置
││└─缩放比例设置
││└─环境地址设置
││└─水印设置
││├─地图设置
││└─添加地图
││└─地图数据隔离
│├─图表
││├─柱形图
││├─折线图
││├─折柱图
││├─饼图
││├─象形图
││├─雷达图
││├─散点图
││├─漏斗图
││├─文本框
││├─跑马灯
││├─超链接
││├─实时时间
││├─地图
││├─全国物流地图
││├─地理坐标地图
││├─城市派件地图
││├─图片
││├─图片框
││├─轮播图
││├─滑动组件
││├─iframe
││├─video
││├─翻牌器
││├─环形图
││├─进度条
││├─仪盘表
││├─字浮云
││├─表格
││├─选项卡
││├─万能组件
└─其他模块
 └─更多功能开发中。。

【界面改版】JimuReport 积木报表 v1.9.0 版本发布，填报能力和大屏能力

项目介绍

集成依赖

升级日志

代码下载

技术文档

为什么选择 JimuReport?

报表设计效果

仪表盘工作台

大屏设计效果

功能清单

相關推薦

积木报表 JimuReport v1.6.2-GA2 版本发布 — 高危 SQL 漏洞安全加固版本

【免费大屏】JimuReport 积木仪表盘 v1.8.1 首个集成版本发布

JimuReport 积木报表 v1.5.8 版本发布 — 免费的数据可视化报表

JimuReport 积木报表 v1.5.9 版本发布 — 免费的可视化报表

JimuReport 积木报表 v1.6.4 稳定版本正式发布 — 免费开源的报表工具

践行“人人可用”，DataEase 开源数据可视化分析平台发布 v2.0 版本

开源轻量级 IM 框架 MobileIMSDK 的微信小程序端已发布！

Apache EventMesh v1.9.0 发布，已支持轻量化事件连接器与 Openfunction 集成

芋道 ruoyi-vue-pro v1.7.0 发布：增加微信公众号、站内信、邮箱、数据脱敏

Bytebase v1.9.0 发布

新增多种图表类型，新增插件管理模块，DataEase 开源数据可视化分析工具 v2.8.0 发布

MQTT X v1.9.0 进行中：开箱即用的 MQTT bench 工具

橙单代码生成工具 3.0 正式版，启程迎接挑战

PicList V1.9.0 发布，云存储-图床管理和图片上传工具，URL 编码优化