From 15fe19f4afa3bd506261c4c60e8685d7279f5438 Mon Sep 17 00:00:00 2001 From: zss <zss@example.com> Date: 星期五, 08 八月 2025 14:17:36 +0800 Subject: [PATCH] 财务管理模块--报表调整+质量模块调整(展示检验项,生成报告,与不合格进行关联) --- src/main/java/com/ruoyi/account/service/impl/AccountExpenseServiceImpl.java | 43 ++++++++++++++++++++++++------------------- 1 files changed, 24 insertions(+), 19 deletions(-) diff --git a/src/main/java/com/ruoyi/account/service/impl/AccountExpenseServiceImpl.java b/src/main/java/com/ruoyi/account/service/impl/AccountExpenseServiceImpl.java index 7871fb4..37c2f7c 100644 --- a/src/main/java/com/ruoyi/account/service/impl/AccountExpenseServiceImpl.java +++ b/src/main/java/com/ruoyi/account/service/impl/AccountExpenseServiceImpl.java @@ -9,14 +9,14 @@ import com.ruoyi.account.dto.AccountDto2; import com.ruoyi.account.dto.AccountDto3; import com.ruoyi.account.mapper.AccountExpenseMapper; -import com.ruoyi.account.mapper.AccountFileMapper; import com.ruoyi.account.mapper.AccountIncomeMapper; import com.ruoyi.account.pojo.AccountExpense; import com.ruoyi.account.pojo.AccountIncome; import com.ruoyi.account.service.AccountExpenseService; -import com.ruoyi.account.service.AccountIncomeService; import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.dto.DateQueryDto; +import com.ruoyi.project.system.domain.SysDictData; +import com.ruoyi.project.system.mapper.SysDictDataMapper; import lombok.AllArgsConstructor; import org.springframework.stereotype.Service; @@ -36,6 +36,8 @@ private AccountExpenseMapper accountExpenseMapper; private AccountIncomeMapper accountIncomeMapper; + + private SysDictDataMapper sysDictDataMapper; //鍒嗛〉鏌ヨ @@ -88,26 +90,29 @@ //璐㈠姟鎶ヨ〃骞存煡璇� @Override - public AccountDto3 reportExpense() { - AccountDto3 accountDto3 = new AccountDto3(); + public List<AccountDto3> reportExpense() { + List<AccountDto3> accountDto3s = new ArrayList<>(); + //鍏堟煡璇㈡敹鍏ョ被鍨嬫湁鍝簺 + List<SysDictData> incomeTypes = sysDictDataMapper.selectDictDataByType("expense_types"); DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd"); int currentYear = LocalDate.now().getYear(); // 鑾峰彇褰撳墠骞翠唤锛堝2025锛� - List<String> months = new ArrayList<>(); - Map<String, List<AccountDto2>> map = new HashMap<>(); - for (int i = 1; i <= 12; i++) { - months.add(i + "鏈�"); - // 褰撴湀绗竴澶╋細骞翠唤涓哄綋鍓嶅勾锛屾湀浠戒负i锛屾棩鏈熶负1 - LocalDate firstDay = LocalDate.of(currentYear, i, 1); - DateQueryDto dateQueryDto = new DateQueryDto(); - dateQueryDto.setEntryDateStart(firstDay.format(formatter)); - // 褰撴湀鏈�鍚庝竴澶╋細绗竴澶╃殑鏈堜唤鐨勬渶鍚庝竴澶� - dateQueryDto.setEntryDateEnd(firstDay.plusMonths(1).minusDays(1).format(formatter)); - List<AccountDto2> report = accountExpenseMapper.report(dateQueryDto); - map.put(i + "鏈�",report); + for (SysDictData incomeType : incomeTypes) { + AccountDto3 accountDto3 = new AccountDto3(); + accountDto3.setTypeName(incomeType.getDictLabel());//绫诲瀷 + List<BigDecimal> account=new ArrayList<>(); + for (int i = 1; i <= 12; i++) { + // 褰撴湀绗竴澶╋細骞翠唤涓哄綋鍓嶅勾锛屾湀浠戒负i锛屾棩鏈熶负1 + LocalDate firstDay = LocalDate.of(currentYear, i, 1); + DateQueryDto dateQueryDto = new DateQueryDto(); + dateQueryDto.setEntryDateStart(firstDay.format(formatter)); + // 褰撴湀鏈�鍚庝竴澶╋細绗竴澶╃殑鏈堜唤鐨勬渶鍚庝竴澶� + dateQueryDto.setEntryDateEnd(firstDay.plusMonths(1).minusDays(1).format(formatter)); + account.add(accountExpenseMapper.report1(dateQueryDto,incomeType.getDictValue())); + } + accountDto3.setAccount(account);//绫诲瀷 + accountDto3s.add(accountDto3); } - accountDto3.setMonth(months); - accountDto3.setAccountType(map); - return accountDto3; + return accountDto3s; } -- Gitblit v1.9.3