package com.ruoyi.account.service.impl;
|
|
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ruoyi.account.dto.AccountDto;
|
import com.ruoyi.account.dto.AccountDto2;
|
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 lombok.AllArgsConstructor;
|
import org.springframework.stereotype.Service;
|
|
import javax.servlet.http.HttpServletResponse;
|
import java.math.BigDecimal;
|
import java.util.List;
|
import java.util.Map;
|
|
@AllArgsConstructor
|
@Service
|
public class AccountExpenseServiceImpl extends ServiceImpl<AccountExpenseMapper, AccountExpense> implements AccountExpenseService {
|
|
private AccountExpenseMapper accountExpenseMapper;
|
|
private AccountIncomeMapper accountIncomeMapper;
|
|
|
//分页查询
|
@Override
|
public IPage<AccountExpense> accountExpenseListPage(Page page, AccountExpense accountExpense) {
|
return accountExpenseMapper.accountExpenseListPage(page,accountExpense);
|
}
|
|
//导出
|
@Override
|
public void accountExpenseExport(HttpServletResponse response, AccountExpense accountExpense) {
|
List<AccountExpense> accountExpenses =accountExpenseMapper.accountExpenseExport(accountExpense);
|
ExcelUtil<AccountExpense> util = new ExcelUtil<AccountExpense>(AccountExpense.class);
|
util.exportExcel(response, accountExpenses, "支出管理导出");
|
}
|
|
//财务报表图表
|
@Override
|
public AccountDto report(DateQueryDto dateQueryDto) {
|
AccountDto accountDto = new AccountDto();
|
//获取该段时间内的所有收入
|
List<AccountDto2> accountIncomes =accountIncomeMapper.report(dateQueryDto);
|
accountDto.setIncomeType(accountIncomes);
|
Long incomeNumber = accountIncomeMapper.selectCount(Wrappers.<AccountIncome>lambdaQuery()
|
.between(AccountIncome::getIncomeDate, dateQueryDto.getEntryDateStart(), dateQueryDto.getEntryDateEnd()));
|
accountDto.setIncomeNumber(incomeNumber);
|
BigDecimal totalIncome = accountIncomes.stream().map(AccountDto2::getAccount).reduce(BigDecimal.ZERO, BigDecimal::add);
|
accountDto.setTotalIncome(totalIncome);
|
//获取该段时间内的所有支出
|
List<AccountDto2> accountExpenses =accountExpenseMapper.report(dateQueryDto);
|
accountDto.setExpenseType(accountExpenses);
|
Long expenseNumber = accountExpenseMapper.selectCount(Wrappers.<AccountExpense>lambdaQuery()
|
.between(AccountExpense::getExpenseDate, dateQueryDto.getEntryDateStart(), dateQueryDto.getEntryDateEnd()));
|
accountDto.setExpenseNumber(expenseNumber);
|
BigDecimal totalExpense = accountExpenses.stream().map(AccountDto2::getAccount).reduce(BigDecimal.ZERO, BigDecimal::add);
|
accountDto.setTotalExpense(totalExpense);
|
//净收入
|
BigDecimal netRevenue = totalIncome.subtract(totalExpense);
|
accountDto.setNetRevenue(netRevenue);
|
return accountDto;
|
}
|
|
|
}
|
