JimuReport

https://help.jimureport.com
Admin
JimuReport is a free data visualization and reporting platform that provides online design for...
Tokens:131,084
Snippets:1,323
Trust Score:8.1
Update:3 months ago
Show doc for...
Tokens:
Raw
### SQL Dictionary Example

Source: https://help.jimureport.com/query/controlType

Example of configuring a dictionary using a direct SQL query. Ensure the SQL syntax is compatible with your database.

```sql
SELECT username AS value, realname AS text FROM sys_user
```

--------------------------------

### API Dynamic Parameter Example

Source: https://help.jimureport.com/query/controlType

Example of how to pass system variables to an API endpoint using '#{variableName}'.

```javascript
/jeecg-boot/jmreport/test/getDictSex?createBy=#{sysUserCode}
```

--------------------------------

### Basic Line Chart Configuration

Source: https://help.jimureport.com/drag/component/data/currency

A basic configuration example for a line chart using ECharts syntax. Ensure the configuration starts with 'option =' and ends with 'return option;'.

```javascript
option = {
    xAxis: {
        type: 'category',
        data: ['周一', '周二', '周三', '周四', '周五', '周六', '周日']
    },
    yAxis: {type: 'value'},
    series: [{
        data: [150, 230, 224, 218, 135, 147, 260],
        type: 'line'
    }]
};
return option;
```

--------------------------------

### Query Data Input Example

Source: https://help.jimureport.com/submit/handler/api

Example of input parameter for the query API, which is a list of data primary keys.

```json
["07b3912e628e4e61a98cc6099b37d10c"]

```

--------------------------------

### Query Data Response - Master-Detail Example

Source: https://help.jimureport.com/submit/handler/api

Example JSON response for a query operation returning master and detail data.

```json
{
    "success": true,
    "message": "",
    "code": 200,
    "result": {
        "singleData": {
            "jmRecordId": "993816826335285248"
            "order_code": "1"
        },
        "listData": [
            [
                {
                    "jmRecordId": "994386177849380864",
                    "product_name": "5",
                    "price": 4,
                },
                {
                    "product_name": "6",
                    "price": 123,
                }
            ],
            [
                {
                    "jmRecordId": "994386177849380864",
                    "op": "order",
                    "op_time": 2024-09-10 00: 00: 00,
                }
            ]
        ],
    }
}

```

--------------------------------

### SQL Data Raw Example

Source: https://help.jimureport.com/funnelChart/datasource

If no specific data processing is needed in SQL, you can select all data directly. This example shows selecting all columns from a table.

```sql
select * from test_multi
```

--------------------------------

### Dynamic API Data Example

Source: https://help.jimureport.com/brokenChart/datasource

This is an example structure for dynamic API data. Adhere to this format for correct rendering.

```json
{
  "data": [
    {
      "name": "周一",
      "value": 1000,
      "type": "iphone"
    },
    {
      "name": "周二",
      "value": 1300,
      "type": "iphone"
    },
    {
      "name": "周三",
      "value": 1400,
      "type": "iphone"
    },
    {
      "name": "周四",
      "value": 1080,
      "type": "iphone"
    },
    {
      "name": "周五",
      "value": 2000,
      "type": "iphone"
    },
    {
      "name": "周一",
      "value": 1300,
      "type": "huawei"
    },
    {
      "name": "周二",
      "value": 1600,
      "type": "huawei"
    },
    {
      "name": "周三",
      "value": 1800,
      "type": "huawei"
    },
    {
      "name": "周四",
      "value": 2000,
      "type": "huawei"
    },
    {
      "name": "周五",
      "value": 3000,
      "type": "huawei"
    },
    {
      "name": "周一",
      "value": 1100,
      "type": "xiaomi"
    },
    {
      "name": "周二",
      "value": 1200,
      "type": "xiaomi"
    },
    {
      "name": "周三",
      "value": 1300,
      "type": "xiaomi"
    },
    {
      "name": "周四",
      "value": 1400,
      "type": "xiaomi"
    },
    {
      "name": "周五",
      "value": 1500,
      "type": "xiaomi"
    },
    {
      "name": "周一",
      "value": 1000,
      "type": "vivo"
    },
    {
      "name": "周二",
      "value": 1000,
      "type": "vivo"
    },
    {
      "name": "周三",
      "value": 1000,
      "type": "vivo"
    },
    {
      "name": "周四",
      "value": 1000,
      "type": "vivo"
    },
    {
      "name": "周五",
      "value": 1000,
      "type": "vivo"
    }
  ]
}
```

--------------------------------

### Chart Data Format Example

Source: https://help.jimureport.com/basicSetting/cusApiFields

This is an example of the expected data format for charts.

```json
{"name":"xxx","value":xxx,"type":"xx"}
```

--------------------------------

### SQL Query Example for Dynamic Data

Source: https://help.jimureport.com/screen/datasource/sql

Example SQL query demonstrating how to alias database columns to match expected data keys for visualization. Ensure returned data keys align with static data keys.

```sql
select value, 1 as min, 100 as max,name as label from bigscreen_test_sql where value='77'
```

--------------------------------

### Submit Data Response Example

Source: https://help.jimureport.com/submit/handler/api

Example response from the submit API, returning a list of primary keys for the submitted data.

```json
["994122418224386048","994122418224386049"]

```

--------------------------------

### Java Submit Handler Example

Source: https://help.jimureport.com/submit/handler/java

Implement the ISubmitHandler interface to create a Java processor for handling data submission and querying. This example demonstrates storing data in memory.

```java
package com.jeecg.modules.jmreport.submit;

import org.jeecg.modules.jmreport.api.data.ISubmitHandler;
import org.jeecg.modules.jmreport.api.vo.SubmitData;
import org.jeecg.modules.jmreport.common.util.RandomUtil;
import org.jeecg.modules.jmreport.common.vo.Result;
import org.springframework.stereotype.Component;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @Description: 提交处理器示例
 * @Author: chenrui
 * @Date: 2024/8/14 17:33
 */
@Component("demoSubmitHandler")
public class DemoSubmitHandler implements ISubmitHandler {

    public static final Map<String,SubmitData> CACHE_DATA = new HashMap<>();


    @Override
    public Result<List<String>> doSubmit(SubmitData data) {
        List<String> ids = new ArrayList<>();
        String genShortUuid = RandomUtil.getInstance().genShortUuid();
        CACHE_DATA.put(genShortUuid, data);
        ids.add(genShortUuid);
        return Result.OK(ids);
    }

    @Override
    public Result<SubmitData> queryByIds(List<String> dataIds) {
        String id = dataIds.get(0);
        return Result.OK(CACHE_DATA.get(id));
    }
}
```

--------------------------------

### Video Component Data Format Example

Source: https://help.jimureport.com/screen/video/videoComp

This is an example of the data format required for the video component. The 'value' field should contain the URL of the video file.

```json
{
    "value": "http://www.w3school.com.cn/i/movie.ogg"
}
```

--------------------------------

### SQL Data Grouping Example

Source: https://help.jimureport.com/funnelChart/datasource

When using SQL data, group your data for proper aggregation. This example shows the correct format for summing values by category.

```sql
select sum(value) cnt, category from test_multi GROUP BY category
```

--------------------------------

### Static API Data Example

Source: https://help.jimureport.com/chart/gaugeChart

Example of static API data format for gauge charts. Use this when providing fixed data points.

```json
[
  {
    "name": "出勤率",
    "value": 60
  }
]
```

--------------------------------

### Static API Data Example

Source: https://help.jimureport.com/brokenChart/datasource

Use this format for static API data. Ensure the code adheres to this structure for proper rendering.

```json
[
  {"name":"周一","value":1000,"type":"iphone"},
  {"name":"周二","value":1300,"type":"iphone"},
  {"name":"周三","value":1400,"type":"iphone"},
  {"name":"周四","value":1080,"type":"iphone"},
  {"name":"周五","value":2000,"type":"iphone"},
  {"name":"周一","value":1300,"type":"huawei"},
  {"name":"周二","value":1600,"type":"huawei"},
  {"name":"周三","value":1800,"type":"huawei"},
  {"name":"周四","value":2000,"type":"huawei"},
  {"name":"周五","value":3000,"type":"huawei"},
  {"name":"周一","value":1100,"type":"xiaomi"},
  {"name":"周二","value":1200,"type":"xiaomi"},
  {"name":"周三","value":1300,"type":"xiaomi"},
  {"name":"周四","value":1400,"type":"xiaomi"},
  {"name":"周五","value":1500,"type":"xiaomi"},
  {"name":"周一","value":1000,"type":"vivo"},
  {"name":"周二","value":1000,"type":"vivo"},
  {"name":"周三","value":1000,"type":"vivo"},
  {"name":"周四","value":1000,"type":"vivo"},
  {"name":"周五","value":1000,"type":"vivo"}
]
```

--------------------------------

### SQL Query Example

Source: https://help.jimureport.com/dataSet/sql

A basic SQL query to select all data from a table. Supports parameters and multi-table joins.

```sql
select * from rep_demo_jianpiao
```

--------------------------------

### Static API Data Example

Source: https://help.jimureport.com/mapChart/datasource

Provides an example of static API data in JSON format. This data can be directly input when configuring a map chart's data source as 'Api dataset' with 'Static data' type.

```json
[
  {"name":"河北","value":279},
  {"name":"海南","value":273},
  {"name":"山东","value":229},
  {"name":"甘肃","value":194},
  {"name":"宁夏","value":193},
  {"name":"浙江","value":177},
  {"name":"湖南","value":119},
  {"name":"湖北","value":79},
  {"name":"河南","value":67},
  {"name":"北京","value":58},
  {"name":"天津","value":59},
  {"name":"上海","value":63}
]
```

--------------------------------

### Create and Populate rep_demo_dxtj Table

Source: https://help.jimureport.com/summary/template

This SQL script defines the schema for the rep_demo_dxtj table and inserts sample data. Use this to set up the table for testing conditional query previews.

```sql
DROP TABLE IF EXISTS `rep_demo_dxtj`;  
CREATE TABLE `rep_demo_dxtj`  (  
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',  
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',  
  `gtime` datetime NULL DEFAULT NULL COMMENT '雇佣日期',  
  `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职务',  
  `jphone` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '家庭电话',  
  `birth` datetime NULL DEFAULT NULL COMMENT '出生日期',  
  `hukou` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '户口所在地',  
  `laddress` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系地址',  
  `jperson` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '紧急联系人',  
  `sex` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'xingbie',  
  `bpm_status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '流程状态',  
  `age` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '年龄',  
  PRIMARY KEY (`id`) USING BTREE  
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;  
  
-- ----------------------------  
-- Records of rep_demo_dxtj  
-- ----------------------------  
INSERT INTO `rep_demo_dxtj` VALUES ('1338808084247613441', '张三', '2019-11-06 00:00:00', '1', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1338809169074982920', '张小哲', '2019-11-06 00:00:00', '2', '18034596971', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1338809448658898952', '闫妮', '2019-11-06 00:00:00', '2', '18034596972', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1338809620973490184', '陌生', '2019-11-06 00:00:00', '2', '18034596973', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1338809652606930952', '贺江', '2019-11-06 00:00:00', '2', '18034596974', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '2', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1338809685200867336', '村子明', '2019-11-06 00:00:00', '3', '18034596975', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '2', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1338809710203113481', '尚德', '2019-11-06 00:00:00', '4', '18034596977', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1338809749470187528', '郑恺', '2019-11-06 00:00:00', '4', '18034596978', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1338809774971555849', '未名园', '2019-11-06 00:00:00', '4', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1338809805199904777', '韩寒', '2019-11-06 00:00:00', '5', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1338809830017601544', '迪丽热拉', '2019-11-06 00:00:00', '6', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1338809864356368393', '张一山', '2019-11-06 00:00:00', '6', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1339160157602480137', '张三', '2019-11-06 00:00:00', '1', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1339160157602480146', '张大大', '2019-11-06 00:00:00', '2', '18034596971', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674439', '郭美美', '2019-11-06 00:00:00', '2', '18034596972', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674448', '莫愁', '2019-11-06 00:00:00', '2', '18034596973', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);  
INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674457', '鲁与', '2019-11-06 00:00:00', '2', '18034596974', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '2', NULL, NULL);  
```

--------------------------------

### POST Request Example with URL Parameters

Source: https://help.jimureport.com/drag/rumen/dataset/api

Demonstrates how to make a POST request where parameters are appended to the URL, which the backend then processes into a JSON body. This is useful for scenarios where direct JSON body transmission is not feasible.

```http
POST /api/user/create?name=张三&age=18  
Authorization: Bearer {token}  
```

--------------------------------

### Create and Use Test Database

Source: https://help.jimureport.com/datasoft/doris

Creates a new database named 'jimureport' and sets it as the current database for subsequent operations.

```sql
create database jimureport;
use jimureport;
```

--------------------------------

### Create Test Demo Table

Source: https://help.jimureport.com/datasoft/doris

Defines a table named 'test_demo' with various columns including VARCHAR, DATETIME, INT, and STRING types. It specifies unique keys, distribution, and properties for the table.

```sql
DROP TABLE IF EXISTS `test_demo`;
CREATE TABLE `test_demo` (
  `id` VARCHAR(32) NOT NULL COMMENT '主键',
  `create_by` VARCHAR(50) DEFAULT NULL COMMENT '创建人登录名称',
  `create_time` DATETIME DEFAULT NULL COMMENT '创建日期',
  `update_by` VARCHAR(50) DEFAULT NULL COMMENT '更新人登录名称',
  `update_time` DATETIME DEFAULT NULL COMMENT '更新日期',
  `no` VARCHAR(30) DEFAULT NULL COMMENT '编号',
  `name` VARCHAR(200) DEFAULT NULL COMMENT '用户名',
  `sex` VARCHAR(32) DEFAULT NULL COMMENT '性别',
  `age` INT DEFAULT NULL COMMENT '年龄',
  `descc` VARCHAR(500) DEFAULT NULL COMMENT '描述',
  `birthday` DATETIME DEFAULT NULL COMMENT '生日',
  `file_kk` VARCHAR(500) DEFAULT NULL COMMENT '附件',
  `top_pic` VARCHAR(500) DEFAULT NULL COMMENT '头像',
  `sel_search` VARCHAR(32) DEFAULT NULL COMMENT '下拉搜索',
  `fen_tree` VARCHAR(200) DEFAULT NULL COMMENT '分类字典',
  `blob_txt` STRING COMMENT '大字段',
  `sel_mult` VARCHAR(200) DEFAULT NULL COMMENT '多选下拉',
  `cust_tree` VARCHAR(200) DEFAULT NULL COMMENT '自定义树',
  `sel_user` VARCHAR(200) DEFAULT NULL COMMENT '选择用户',
  `sel_dep` VARCHAR(200) DEFAULT NULL COMMENT '选择部门',
  `chengshi` VARCHAR(200) DEFAULT NULL COMMENT '省市区',
  `is_open` VARCHAR(1) DEFAULT NULL COMMENT '开关',
  `bpm_status` VARCHAR(2) DEFAULT NULL COMMENT '流程状态',
  `qc_time` VARCHAR(32) DEFAULT NULL COMMENT '起床时间'
) UNIQUE KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS 10
PROPERTIES (
    "replication_allocation" = "tag.location.default: 1"
);
```

--------------------------------

### Query Data Response - Single Data Example

Source: https://help.jimureport.com/submit/handler/api

Example JSON response for a query operation returning single data.

```json
{
    "success": true,
    "message": "",
    "code": 200,
    "result": {
        "singleData": {
            "jmRecordId": "993816826335285248"
            "order_code": "1"
        }
    }
}

```

--------------------------------

### Generate Component from File

Source: https://help.jimureport.com/biScreen/aiChart

Create a visualization component by uploading a data file (CSV, Excel) and then describing the desired component in natural language. AI will parse the file content to generate the visualization.

```Markdown
根据上传的销售数据文件，生成产品销量对比柱形图  

```

--------------------------------

### Flop Data Format Example

Source: https://help.jimureport.com/biScreen/componentconfig/text/flop

Example of the expected JSON data format for the Flop component, specifying a single 'value' field.

```json
{
  "value": 250
}
```

--------------------------------

### Run ClickHouse Service with Persistent Storage

Source: https://help.jimureport.com/datasoft/clickhouse

Starts the ClickHouse server as a Docker service, mapping ports, and mounting volumes for data, configuration, and logs to ensure persistence.

```bash
docker run -d --name=single-clickhouse-server -p 8123:8123 -p 9000:9000 -p 9009:9009 --ulimit nofile=262144:262144 --volume D:/clickhouse/data:/var/lib/clickhouse:rw --volume D:/clickhouse/conf:/etc/clickhouse-server:rw --volume D:/clickhouse/log:/var/log/clickhouse-server:rw yandex/clickhouse-server
```

--------------------------------

### Insert Test Data into Doris

Source: https://help.jimureport.com/datasoft/doris

Provides sample SQL INSERT statements for populating the 'test_demo' table in Doris. These examples demonstrate various data types and field usages.

```sql
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1244275574052069377', 'admin', '2020-03-29 22:49:49', 'admin', '2020-03-29 22:49:55', '1', 'JEECG用户', '2', 712, '18611111111', NULL, NULL, NULL, 'jeecg', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
```

```sql
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1244451590208847873', 'admin', '2020-03-30 10:29:15', 'admin', '2020-03-30 10:29:56', '2', '李四', '1', 22, 'null', NULL, 'https://static.jeecg.com/temp/gh_f28e66390fc9_344 (shop)_1585535389933.jpg,https://static.jeecg.com/temp/gh_0cf466a0aa08_258 (cms)_1585535393383.jpg', 'https://static.jeecg.com/temp/11_1585535385960.jpg,https://static.jeecg.com/temp/1112_1585535386759.jpg', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
```

```sql
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1245192850573905921', 'admin', '2020-04-01 11:34:45', 'admin', '2021-06-07 15:38:02', '4', '张三', '2', 11, '15011111111', NULL, '', '', '', '', '', '', '', '', '', '120101', 'N', NULL, '');
```

```sql
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1247856910876667905', 'admin', '2020-04-08 20:00:46', 'admin', '2021-08-03 18:18:45', '4', '王五', '1', 130, '', '1959-10-01 00:00:00', '', '', '', '', '', '', '', '', '', '120102', 'N', NULL, '');
```

```sql
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1272525317374849026', 'admin', '2020-06-15 21:44:12', 'admin', '2021-08-03 18:18:51', '5', '赵六', '1', 33, '', '2020-06-17 03:02:11', '', '', '', '', '', '', '', '', '', '110101', 'N', NULL, '');
```

```sql
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1272525403630710785', 'admin', '2020-06-15 21:44:33', 'admin', '2020-07-27 17:32:06', '6', '管理员', '2', 622, '18611788525', '2020-06-12 00:00:00', '', '', '', '', '', NULL, '', '', '', '', 'N', NULL, NULL);
```

```sql
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1273802277560377345', 'admin', '2020-06-19 10:18:24', 'admin', '2020-11-11 11:26:02', '7', '孙七', '2', 5011, '<p>186111111113333</p>', NULL, 'temp/jeecg cloud 微服务架构图_1592534712178.png', 'temp/jeecg cloud 微服务架构图_1592533111865.png', '', '', '', '1227492235802251265', '', '', 'a7d7e77e06c84325a40932163adcdaa6,57197590443c44f083d42ae24ef26a2c', '140423', 'N', NULL, '');
```

```sql
INSERT INTO `test_demo` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `no`, `name`, `sex`, `age`, `descc`, `birthday`, `file_kk`, `top_pic`, `sel_search`, `fen_tree`, `blob_txt`, `sel_mult`, `cust_tree`, `sel_user`, `sel_dep`, `chengshi`, `is_open`, `bpm_status`, `qc_time`) VALUES ('1275416273598132225', 'admin', '2020-06-23 21:11:50', 'admin', '2020-08-18 13:54:07', NULL, '周八', '2', 1379, '', '1959-10-01 00:00:00', '捷微200_1592917896501.png', 'https://static.jeecg.com/temp/20180607175028Fn1Lq7zw_1592981132188.png', 'jeecg', NULL, '', '1227492235802251265,a75d45a015c44384a04449ee80dc3503', NULL, NULL, NULL, NULL, 'Y', NULL, NULL);
```

--------------------------------

### Master-Detail (List) Submission Payload Example

Source: https://help.jimureport.com/submit/handler/api

Example JSON payload for submitting master and detail (list) data, including deletion IDs.

```json
{
    "singleData": {
        "order_code": "1",
        "order_date": "2024-09-11 00:00:00",
        "descc": "22",
        "jmRecordId": "993816826335285248"
    },
    "listData": [
        [
            {
                "jmRecordId": "994386177849380864",
                "product_name": "5",
                "price": 4
            },
            {
                "product_name": "6",
                "product_name": "5",
                "price": 4
            }
        ],
        [
            {
                "jmRecordId": "994386177849380864",
                "op": "order",
                "op_time": 2024-09-10 00:00:00
            }
        ]
    ],
    "delIds": {
        "0": [
            "994122418224386048"
        ]
    }
}

```

--------------------------------

### Single Data Submission Payload Example

Source: https://help.jimureport.com/submit/handler/api

Example JSON payload for submitting a single record of data, including a primary key for editing.

```json
{
    "singleData": {
        "order_code": "1",
        "order_date": "2024-09-11 00:00:00",
        "descc": "22",
        "jmRecordId": "993816826335285248"
    }
}

```

--------------------------------

### Funnel Chart Data Format Example

Source: https://help.jimureport.com/screen/chart/funnel

Provides an example of the expected data format for a funnel chart. Each object should contain a 'value' and a 'name'.

```json
[
    {"value":335,"name":"直接访问"},
    {"value":310,"name":"邮件营销"},
    {"value":234,"name":"联盟广告"}
]

```

--------------------------------

### Dynamic API Data Example

Source: https://help.jimureport.com/chart/gaugeChart

Example of dynamic API data format for gauge charts. Use this when data is fetched from an API endpoint.

```json
{
  "data": [
    {
      "name": "出勤率",
      "value": 80
    }
  ]
}
```

--------------------------------

### Add JimuReport and JimuBI Dependencies to pom.xml

Source: https://help.jimureport.com/projectJoin/ruoyiDrag

Include the necessary JimuReport and JimuBI starter dependencies in your project's pom.xml file. The 'nosql-starter' and 'echarts-starter' are optional and should be included based on your project's requirements for NoSQL support and ECharts charting.

```xml
<!-- 积木报表 -->  
<dependency>  
    <groupId>org.jeecgframework.jimureport</groupId>  
    <artifactId>jimureport-spring-boot-starter</artifactId>  
    <version>2.1.1</version>  
</dependency>  
<!-- mongo、redis和文件数据集支持包，按需引入 -->  
<dependency>  
  <groupId>org.jeecgframework.jimureport</groupId>  
  <artifactId>jimureport-nosql-starter</artifactId>  
  <version>2.1.0</version>  
</dependency>  
<!-- 后台导出接口Echart图表支持包，按需引入 -->  
<dependency>  
  <groupId>org.jeecgframework.jimureport</groupId>  
  <artifactId>jimureport-echarts-starter</artifactId>  
  <version>2.3.0</version>  
</dependency>  
<!-- 积木BI大屏 -->  
<dependency>  
    <groupId>org.jeecgframework.jimureport</groupId>  
    <artifactId>jimubi-spring-boot-starter</artifactId>  
    <version>2.1.4</version>  
</dependency>  
```

--------------------------------

### Tab Data Format Example

Source: https://help.jimureport.com/screen/other-comp/tab

This is an example of the data format used to define tabs. Each object represents a tab with a 'label' for display and a 'value' for identification.

```json
[
    {
        "label": "选项卡1",
        "value": "1"
    },
    {
        "label": "选项卡2",
        "value": "2"
    }
]

```

--------------------------------

### Configure Chart Drilling Link

Source: https://help.jimureport.com/linkage/reportDrilling

Set up a link for chart drilling, specifying the target report and how it should be displayed.

```markdown
链接报表：需要跳转的报表  
弹出方式：在本页面还是新窗口  


```

--------------------------------

### Yujue Chart Data Format Example

Source: https://help.jimureport.com/screen/chart/yujue

This is an example of the data format required for the Yujue chart. Each object in the array represents a segment of the chart with a name and a value.

```json
[
    {
        "name": "A",
        "value": 297
    },
    {
        "name": "B",
        "value": 506
    }
]
```

--------------------------------

### Copy Configuration Files from Container

Source: https://help.jimureport.com/datasoft/clickhouse

Copies the ClickHouse server configuration and user configuration files from a running temporary container to a local Windows directory.

```bash
docker cp temp-clickhouse-server:/etc/clickhouse-server/config.xml D:/clickhouse/conf/config.xml
```

```bash
docker cp temp-clickhouse-server:/etc/clickhouse-server/users.xml D:/clickhouse/conf/users.xml
```

--------------------------------

### Insert Sample Data into rep_demo_dxtj Table

Source: https://help.jimureport.com/summary/template

These SQL INSERT statements are used to populate the 'rep_demo_dxtj' table with various records. Each statement adds a single row with different values for the columns.

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674466', '高尚', '2019-11-06 00:00:00', '3', '18034596975', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '2', NULL, NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674475', '尚北京', '2019-11-06 00:00:00', '4', '18034596977', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674484', '杨颖花', '2019-11-06 00:00:00', '4', '18034596978', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674493', '李丽', '2019-11-06 00:00:00', '4', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674502', '韩露露', '2019-11-06 00:00:00', '5', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674511', '李凯泽', '2019-11-06 00:00:00', '6', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1339160157606674520', '王明阳', '2019-11-06 00:00:00', '6', '18034596970', '1988-12-15 00:00:00', '北京市朝阳区奥运村街道亚运村小区', '18034596972', '王亮', '1', NULL, NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1465569145448341506', '1234', '2021-11-30 00:00:00', NULL, '', NULL, '', '', '', '', '2', NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1465576185881206786', '修改111', '2021-11-30 00:00:00', 'admin', '1234567', '2021-11-30 00:00:00', '', '', '', '', '2', NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1465578657030905857', '设计器111', '2021-11-30 00:00:00', 'admin', '', '2021-11-30 00:00:00', '11111111', '', '', '', '2', NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1465583853266051074', '分支1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1465584879729680386', '分支2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', '29');
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1465585110500286465', '分支年龄29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', '29');
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1465585651322232833', '同步', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1465594808561606657', '首节点', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1465950213573758977', '组任务', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL);
```

```sql
INSERT INTO `rep_demo_dxtj` VALUES ('1465958504584499202', '李四', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', NULL);
```

--------------------------------

### Run Temporary ClickHouse Server Container

Source: https://help.jimureport.com/datasoft/clickhouse

Starts a temporary ClickHouse server container for configuration purposes. The container will be removed upon stopping.

```bash
docker run --rm -d --name=temp-clickhouse-server yandex/clickhouse-server
```
Tokens:
Raw