package com.ruoyi.account.service.impl;
|
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
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.ruoyi.account.dto.AccountDto2;
|
import com.ruoyi.account.dto.AccountDto3;
|
import com.ruoyi.account.dto.ReportDateDto;
|
import com.ruoyi.account.mapper.AccountIncomeMapper;
|
import com.ruoyi.account.pojo.AccountIncome;
|
import com.ruoyi.account.service.AccountIncomeService;
|
import com.ruoyi.common.utils.DateUtils;
|
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;
|
|
import javax.servlet.http.HttpServletResponse;
|
import java.math.BigDecimal;
|
import java.time.LocalDate;
|
import java.time.format.DateTimeFormatter;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
@AllArgsConstructor
|
@Service
|
public class AccountIncomeServiceImpl extends ServiceImpl<AccountIncomeMapper, AccountIncome> implements AccountIncomeService {
|
|
private AccountIncomeMapper accountIncomeMapper;
|
|
private SysDictDataMapper sysDictDataMapper;
|
|
|
//分页查询
|
@Override
|
public IPage<AccountIncome> accountIncomeListPage(Page page, AccountIncome accountIncome) {
|
return accountIncomeMapper.accountIncomeListPage(page,accountIncome);
|
}
|
|
//导出
|
@Override
|
public void accountIncomeExport(HttpServletResponse response, AccountIncome accountIncome) {
|
List<AccountIncome> accountIncomes =accountIncomeMapper.accountIncomeExport(accountIncome);
|
ExcelUtil<AccountIncome> util = new ExcelUtil<AccountIncome>(AccountIncome.class);
|
util.exportExcel(response, accountIncomes, "收入管理导出");
|
}
|
|
//财务报表年查询
|
@Override
|
public List<AccountDto3> reportIncome(ReportDateDto reportDateDto) {
|
List<AccountDto3> accountDto3s = new ArrayList<>();
|
//先查询收入类型有哪些
|
List<SysDictData> incomeTypes = sysDictDataMapper.selectDictDataByType("income_types");
|
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
|
// int currentYear = LocalDate.now().getYear(); // 获取当前年份（如2025）
|
for (SysDictData incomeType : incomeTypes) {
|
AccountDto3 accountDto3 = new AccountDto3();
|
accountDto3.setTypeName(incomeType.getDictLabel());//类型
|
List<BigDecimal> account=new ArrayList<>();
|
LocalDate startDate = reportDateDto.getEntryDateStart();
|
LocalDate endDate = reportDateDto.getEntryDateEnd();
|
|
// 初始化循环变量为起始日期
|
LocalDate currentDate = startDate;
|
|
// 循环：当前日期不超过结束日期时继续
|
while (!currentDate.isAfter(endDate)) {
|
// 当月第一天
|
LocalDate firstDay = currentDate.withDayOfMonth(1);
|
DateQueryDto dateQueryDto = new DateQueryDto();
|
dateQueryDto.setEntryDateStart(firstDay.format(formatter));
|
|
// 当月最后一天
|
LocalDate lastDay = firstDay.plusMonths(1).minusDays(1);
|
dateQueryDto.setEntryDateEnd(lastDay.format(formatter));
|
|
// 累加数据
|
account.add(accountIncomeMapper.report1(dateQueryDto, incomeType.getDictValue()));
|
|
// 月份加一（自动处理跨年，比如12月加1个月会变成下一年1月）
|
currentDate = currentDate.plusMonths(1);
|
}
|
accountDto3.setAccount(account);//类型
|
accountDto3s.add(accountDto3);
|
}
|
return accountDto3s;
|
}
|
|
@Override
|
public AccountIncome getByInvoiceNumber(String purchaseContractNumber) {
|
AccountIncome accountIncome = accountIncomeMapper.selectOne(new LambdaQueryWrapper<AccountIncome>()
|
.eq(AccountIncome::getInvoiceNumber, purchaseContractNumber));
|
return accountIncome;
|
}
|
|
@Override
|
public List<AccountIncome> getByInvoiceNumberList(String purchaseContractNumber) {
|
return accountIncomeMapper.selectList(new LambdaQueryWrapper<AccountIncome>()
|
.eq(AccountIncome::getInvoiceNumber, purchaseContractNumber));
|
}
|
}
|
