From f2cbc818993dab5646c99886810b17c6c79668ee Mon Sep 17 00:00:00 2001
From: kongdeqiang <123456>
Date: 星期二, 24 三月 2026 13:48:09 +0800
Subject: [PATCH] feat: 去除权限控制
---
src/main/java/com/example/service/impl/DataExcelServiceImpl.java | 36 +++++++++++++++++++++++++++++++-----
1 files changed, 31 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/example/service/impl/DataExcelServiceImpl.java b/src/main/java/com/example/service/impl/DataExcelServiceImpl.java
index 877a06b..98d4073 100644
--- a/src/main/java/com/example/service/impl/DataExcelServiceImpl.java
+++ b/src/main/java/com/example/service/impl/DataExcelServiceImpl.java
@@ -4,10 +4,12 @@
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.read.listener.ReadListener;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.entity.DataExcel;
+import com.example.entity.Department;
import com.example.excel.DataExcelImport;
import com.example.mapper.DataExcelMapper;
import com.example.service.DataExcelService;
@@ -36,6 +38,35 @@
}
@Override
+ public IPage<DataExcel> getDataExcelPageNew(Long current, Long size, String unitCode, String transactionNo, String accountingPeriod) {
+ Page<DataExcel> page = new Page<>(current, size);
+ page.setOptimizeJoinOfCountSql(false);
+ page.setOptimizeCountSql(false);
+ LambdaQueryWrapper<DataExcel> wrapper = new LambdaQueryWrapper<>();
+ wrapper.eq(unitCode != null && !unitCode.isEmpty(), DataExcel::getUnitCode, unitCode)
+ .like(transactionNo != null && !transactionNo.isEmpty(), DataExcel::getTransactionNo, transactionNo)
+ .eq(accountingPeriod != null && !accountingPeriod.isEmpty(), DataExcel::getAccountingPeriod, accountingPeriod)
+ .orderByDesc(DataExcel::getId);
+ return page(page, wrapper);
+ }
+
+ @Override
+ public List<Department> getDepartmentTree() {
+ QueryWrapper<DataExcel> wrapper = new QueryWrapper<>();
+ // 鍏抽敭锛氫袱涓瓧娈靛幓閲嶏紙DISTINCT 浣滅敤浜庤繖涓や釜瀛楁鐨勭粍鍚堬級
+ wrapper.select("distinct unit_code, unit_name");
+ List<DataExcel> list = baseMapper.selectList(wrapper);
+ List<Department> resultList = new ArrayList<>();
+ for (DataExcel dataExcel : list) {
+ Department department = new Department();
+ department.setDeptCode(dataExcel.getUnitCode());
+ department.setDeptName(dataExcel.getUnitName());
+ resultList.add(department);
+ }
+ return resultList;
+ }
+
+ @Override
public String importData(MultipartFile file, List<String> permissionDeptCodes) {
List<DataExcel> insertList = new ArrayList<>();
List<DataExcel> updateList = new ArrayList<>();
@@ -51,11 +82,6 @@
errorMsgs.add("绗�" + data.getSeqNo() + "琛屽崟浣嶇紪鐮佷负绌�");
return;
}
-// if (!permissionDeptCodes.contains(data.getUnitCode())) {
-// errorMsgs.add("绗�" + data.getSeqNo() + "琛屾棤鏉冮檺瀵煎叆閮ㄩ棬缂栫爜: " + data.getUnitCode());
-// return;
-// }
-
DataExcel entity = new DataExcel();
entity.setSortNo(data.getSortNo());
entity.setSeqNo(data.getSeqNo());
--
Gitblit v1.9.1