ruoyi vue版集成积木报表

一、数据库执行sql语句

JimuReport/db at master · jeecgboot/JimuReport · GitHub

二、引入依赖并完成启动包的扫描

<!-- JimuReport -->
<dependency>
    <groupId>org.jeecgframework.jimureport</groupId>
    <artifactId>jimureport-spring-boot-starter</artifactId>
    <version>1.5.2</version>
</dependency>

三、启动包加入

@SpringBootApplication(exclude = { DataSourceAutoConfiguration.class, MongoAutoConfiguration.class, MongoDataAutoConfiguration.class },scanBasePackages = {"org.jeecg.modules.jmreport","com.zhongqing"})

四、SecurityConfig拦截排除

目录在ruoyi-framework

.antMatchers("/jmreport/**").anonymous()

五、配置yml文件

jeecg :
  jmreport:
    #自定义项目前缀，必须与前端 process.env.VUE_APP_BASE_API 的值一致
    customPrePath:
    #    customPrePath: /dev-api
    # 打印纸张配置 title描述 size宽高
    printPaper:
      - title: 工艺巡检纸
        size:
          - 750
          - 950
      - title: 设备巡检纸
        size:
          - 485
          - 675
      - title: 生产数据纸
        size:
          - 650
          - 675
      - title: 设备台账纸
        size:
          - 392
          - 592
      - title: 水质报表纸
        size:
          - 1400
          - 1450
    #列数
    col: 150

六、需要做权限token传递

**
 * 自定义积木报表鉴权(如果不进行自定义，则所有请求不做权限控制)
 *
 * @Author Zack
 * @Date 2022/8/11 9:45
 */
@Component
public class JimuReportTokenService implements JmReportTokenServiceI {

    @Autowired
    private TokenService tokenService;

    @Override
    public String getToken(HttpServletRequest request) {
        //先从url参数中取，若没有，再从header中取
        String paramToken = request.getParameter("token");
        String headerToken = request.getHeader("token");
        if (StringUtils.isEmpty(paramToken)) {
            paramToken = headerToken;
        }
        LoginUser loginUser = tokenService.getLoginUser(paramToken);
        if (loginUser != null) {
            return paramToken;
        }
        return "";
    }

    @Override
    public String getUsername(String token) {
        LoginUser loginUser = tokenService.getLoginUser(token);
        return loginUser.getUsername();
    }

    /**
     * 校验设计器权限
     * @param token
     * @return
     */
    @Override
    public Boolean verifyToken(String token) {
        LoginUser loginUser = tokenService.getLoginUser(token);
        if (StringUtils.isNotNull(loginUser)) {
            //刷新Token有效期
            tokenService.refreshToken(loginUser);
            //超管不需要鉴权
            if(loginUser.getUser() != null && loginUser.getUser().isAdmin()){
                return true;
            }else{
                //校验菜单权限
                Set<String> permissions = loginUser.getPermissions();
                if(permissions != null && permissions.contains("report:jimu:list")){
                    return true;
                }
            }
        }
        return false;
    }

    /**
     * 系统上下文变量(http://report.jeecg.com/2159712)
     * @param token
     * @return
     */
    @Override
    public Map<String, Object> getUserInfo(String token) {
        Map<String, Object> map = new HashMap(5);
        LoginUser loginUser = tokenService.getLoginUser(token);
        //设置用户名
        map.put(SYS_USER_CODE, loginUser.getUsername());
        //设置部门编码
        map.put(SYS_ORG_CODE, loginUser.getDeptId());
        // 将所有信息存放至map 解析sql/api会根据map的键值解析
        return map;
    }

    @Override
    public HttpHeaders customApiHeader() {

        HttpHeaders header = new HttpHeaders();

        //主要用于API数据源。默认给API数据源的header中携带上Token。
        //如使用当前项目的API，则需要在header中携带Authorization头
        header.add(tokenService.getHeader(), getToken());

        header.add("token", getToken());
        header.add("X-Access-Token", getToken());
        return header;
    }
}

七、前端配置

<template>
  <div class="app-container">
   <i-frame :src="openUrl" id="jimuReportFrame" />

  </div>
</template>

<script>
import { getToken } from '@/utils/auth'
import iFrame from "@/components/iFrame/index";
export default {
  name: 'JimuReportDesign',
  components: { iFrame },
  data() {
    return {
      openUrl: process.env.VUE_APP_BASE_API + '/jmreport/list?token=Bearer ' +  getToken()
    }
  },
}
</script>

8、页面菜单权限配置

配置组件路径以及list