:::warning{title="前引"}
[hutool-5.8.6](https://hutool.cn/docs/#/CHANGELOG?id=_586-2022-09-05) 中新增了【ObjUtil】API
:::



# 问题原因
> 代码中使用了ObjUtil.isEmpy()方法

> 项目中不同模块引用了**不同版本的hutool-all

```pom.xml(根POM)
            <dependency>
                <groupId>cn.hutool</groupId>
                <artifactId>hutool-all</artifactId>
                <version>5.7.2</version>
            </dependency>
```
```pom.xml(子POM)
            <dependency>
                <groupId>cn.hutool</groupId>
                <artifactId>hutool-all</artifactId>
            </dependency>
            --------------------
            <dependency>
                <groupId>cn.hutool</groupId>
                <artifactId>hutool-all</artifactId>
                <version>5.8.16</version>
            </dependency>
            
```
# 问题分析
> **根POM**的hutool版本未新增【ObjUtil】API，**子POM**自身虽然继承了根模块的POM但由于也同时引用了<5.8.16>版本编码阶段不会出现问题，但可能在编译阶段未正确target ObjUtil类造成报错。

## 问题报错

![8f24bc557f3d69372d1bac3b9a44ea90.jpg](https://zhoudeshui.top/static/img/4736351f5fb9aa1a21084ac71f19a893.8f24bc557f3d69372d1bac3b9a44ea90.webp)

【踩坑日记】记一次不同版本hutool中ObjUtil引发的问题

【技术分享】wvp-GB28181-pro之页面免登录访问

# pom依赖
```xml
        
        <dependency>
            <groupId>com.luhuiguo</groupId>
            <artifactId>aspose-cells</artifactId>
            
            <version>23.1</version>
        </dependency>
```



# Excel2Utils
```java
package top.zhoudeshui.utils;

import com.aspose.cells.SaveFormat;
import com.aspose.cells.Workbook;
import com.ruoyi.common.exception.ServiceException;
import com.ruoyi.common.utils.uuid.UUID;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.io.FilenameUtils;
import org.springframework.web.multipart.MultipartFile;

import java.io.*;
import java.nio.file.Files;
import java.nio.file.Path;
import java.nio.file.Paths;

@Slf4j
/**
 * Excel转换工具 - 支持Excel与PDF/其他格式互转
 * @author zhoudeshui
 */
public class Excel2Utils {

    // 验证Aspose许可证（需自行配置）
//    static {
//        try {
//            // 加载许可证文件（如果有商业授权）
////             License license = new License();
////             license.setLicense(new FileInputStream("path/to/license.xml"));
//            log.info("Aspose.Cells 许可证加载成功");
//        } catch (Exception e) {
//            log.warn("Aspose.Cells 许可证未找到，将使用评估模式（可能有水印限制）");
//        }
//    }

    // 输入流 -> 输出流
    public static void convert(InputStream inputStream, OutputStream outputStream, int saveFormat) {
        try {
            Workbook workbook = new Workbook(inputStream);
            workbook.save(outputStream, saveFormat);
            outputStream.flush();
            log.info("Excel转换成功：输入流 -> 输出流，格式: {}", getFormatName(saveFormat));
        } catch (Exception e) {
            log.error("Excel转换失败：输入流 -> 输出流", e);
            throw new ServiceException("Excel转换失败：" + e.getMessage());
        }
    }

    // 输入流 -> 输出文件
    public static File convert(InputStream inputStream, String outputPath, int saveFormat) {
        try (FileOutputStream fos = new FileOutputStream(createOutputFile(outputPath))) {
            convert(inputStream, fos, saveFormat);
            return new File(outputPath); // 直接通过路径创建File对象（与原逻辑一致）
        } catch (Exception e) {
            log.error("Excel转换失败：输入流 -> 输出文件", e);
            throw new ServiceException("Excel转换失败：" + e.getMessage());
        }
    }

    // 输入文件 -> 输出流
    public static void convert(String inputPath, OutputStream outputStream, int saveFormat) {
        try (FileInputStream fis = new FileInputStream(inputPath)) {
            convert(fis, outputStream, saveFormat);
        } catch (Exception e) {
            log.error("Excel转换失败：输入文件 -> 输出流", e);
            throw new ServiceException("Excel转换失败：" + e.getMessage());
        }
    }

    // 输入文件 -> 输出文件
    public static File convert(String inputPath, String outputPath, int saveFormat) {
        try (FileInputStream fis = new FileInputStream(inputPath)) {
            return convert(fis, outputPath, saveFormat);
        } catch (Exception e) {
            log.error("Excel转换失败：输入文件 -> 输出文件", e);
            throw new ServiceException("Excel转换失败：" + e.getMessage());
        }
    }

    // 处理MultipartFile输入
    public static File convert(MultipartFile file, String outputPath, int saveFormat) {
        try {
            return convert(file.getInputStream(), outputPath, saveFormat);
        } catch (Exception e) {
            log.error("Excel转换失败：MultipartFile -> 输出文件", e);
            throw new ServiceException("Excel转换失败：" + e.getMessage());
        }
    }

    // 辅助方法：创建输出文件
    private static File createOutputFile(String outputPath) throws IOException {
        Path outputFilePath = Paths.get(outputPath);
        File outputFile = outputFilePath.toFile();

        // 确保目录存在（合并嵌套的 if 语句）
        Path parentDirPath = outputFilePath.getParent();
        if (parentDirPath != null) {
            File parentDir = parentDirPath.toFile();
            if (!parentDir.exists() && !parentDir.mkdirs()) {
                throw new IOException("无法创建目录: " + parentDir.getAbsolutePath());
            }
        }

        // 如果文件已存在，删除它（使用 Files.delete 获取更详细的错误信息）
        if (Files.exists(outputFilePath)) {
            try {
                Files.delete(outputFilePath);
            } catch (IOException e) {
                throw new IOException("无法删除已存在的文件: " + outputFile.getAbsolutePath(), e);
            }
        }

        return outputFile;
    }

    // 辅助方法：获取格式名称
    private static String getFormatName(int saveFormat) {
        switch (saveFormat) {
            case SaveFormat.PDF:
                return "PDF";
            case SaveFormat.XLSX:
                return "XLSX";
            case SaveFormat.CSV:
                return "CSV";
            case SaveFormat.HTML:
                return "HTML";
            default:
                return String.valueOf(saveFormat);
        }
    }

    // 辅助方法：安静关闭流
    private static void closeQuietly(Closeable closeable) {
        if (closeable != null) {
            try {
                closeable.close();
            } catch (IOException e) {
                log.warn("关闭流失败", e);
            }
        }
    }

    // 生成随机文件名
    public static String generateRandomFileName(String originalFilename) {
        String extension = FilenameUtils.getExtension(originalFilename);
        return UUID.randomUUID().toString() + (extension.isEmpty() ? "" : "." + extension);
    }

    // 使用示例
    public static void main(String[] args) {
        try {
            // 示例1：Excel转PDF（文件到文件）
            Excel2Utils.convert("C:\\Users\\zhoudeshui\\Desktop\\result.xlsx", "C:\\Users\\zhoudeshui\\Desktop\\output.pdf", SaveFormat.PDF);

            // 示例2：Excel转CSV（流到流）
            try (FileInputStream fis = new FileInputStream("input.xlsx");
                 FileOutputStream fos = new FileOutputStream("output.csv")) {
                Excel2Utils.convert(fis, fos, SaveFormat.CSV);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}
```

【小工具】Excel2Utils之aspose转换类

## src\router\index.js

> 添加允许获取路由Url参数
```vue
  {
    path: "/",
    component: Layout,
    redirect: "/dashboard",
    children: [
      {
        path: "dashboard", // 路由路径
        name: "控制台", // 路由名称
        component: () => import("@/views/dashboard/index"), // 组件路径
        meta: { title: "控制台", icon: "dashboard", affix: true },
        props: true, // 启用参数传递
      },
    ],
  },
```
> **关键代码: props: true**



## src\layout\index.vue

> 捕获freelogin路由参数 隐藏组件
```vue
<template>
  <div :class="classObj" class="app-wrapper">
    <div v-if="device==='mobile'&&sidebar.opened" class="drawer-bg" @click="handleClickOutside" />
    <sidebar class="sidebar-container" v-if="!isSidebarHidden"/>
    <div class="main-container">
      <div :class="{'fixed-header':fixedHeader}" v-if="!isSidebarHidden">
        <navbar />
      </div>
      <tags-View v-if="!isSidebarHidden"/>
      <app-main />
    </div>
  </div>
</template>

<script>
<template>
  <div :class="[classObj, {'sidebar-hidden': isSidebarHidden}]" class="app-wrapper">
    <div v-if="device==='mobile'&&sidebar.opened" class="drawer-bg" @click="handleClickOutside" />
    <sidebar class="sidebar-container" v-if="!isSidebarHidden"/>
    <div class="main-container">
      <div :class="{'fixed-header':fixedHeader}" v-if="!isSidebarHidden">
        <navbar />
      </div>
      <tags-View v-if="!isSidebarHidden"/>
      <app-main />
    </div>
  </div>
</template>

<script>
import { Navbar, Sidebar, AppMain, TagsView } from './components'
import ResizeMixin from './mixin/ResizeHandler'

export default {
  name: 'Layout',
  components: {
    Navbar,
    Sidebar,
    AppMain,
    TagsView
  },
  mixins: [ResizeMixin],
  computed: {
    sidebar() {
      return this.$store.state.app.sidebar
    },
    device() {
      return this.$store.state.app.device
    },
    fixedHeader() {
      return this.$store.state.settings.fixedHeader
    },
    classObj() {
      return {
        hideSidebar: !this.sidebar.opened,
        openSidebar: this.sidebar.opened,
        withoutAnimation: this.sidebar.withoutAnimation,
        mobile: this.device === 'mobile'
      }
    },
    // 控制侧边栏隐藏的计算属性
    isSidebarHidden() {
      return this.$route?.query?.freelogin === '1'
    }
  },
  methods: {
    handleClickOutside() {
      this.$store.dispatch('app/closeSideBar', { withoutAnimation: false })
    }
  }
}
</script>

<style lang="scss" scoped>
  @import "~@/styles/mixin.scss";
  @import "~@/styles/variables.scss";

  .app-wrapper {
    @include clearfix;
    position: relative;
    height: 100%;
    width: 100%;
    &.mobile.openSidebar{
      position: fixed;
      top: 0;
    }
  }
  .drawer-bg {
    background: #000;
    opacity: 0.3;
    width: 100%;
    top: 0;
    height: 100%;
    position: absolute;
    z-index: 999;
  }

  .fixed-header {
    position: fixed;
    top: 0;
    right: 0;
    z-index: 9;
    width: calc(100% - #{$sideBarWidth});
    transition: width 0.28s;
  }

  .hideSidebar .fixed-header {
    width: calc(100% - 54px)
  }

  .mobile .fixed-header {
    width: 100%;
  }

  // 侧边栏隐藏时的样式调整
  .app-wrapper.sidebar-hidden .main-container {
    margin-left: 0 !important; // 移除左侧边距
    width: 100% !important; // 主内容占满全屏
  }

  .app-wrapper.sidebar-hidden .fixed-header {
    width: 100% !important; // 顶部导航占满全屏
  }
</style>
```
> **关键代码: this.$route?.query?.freelogin**

基于WVP-GB28181-pro[https://github.com/648540858/wvp-GB28181-pro]

pom依赖

src\router\index.js

Jaocb_v1.21调用WPS COM组件😀👍