| | |
|---|
| | | |
|---|
| | | import javax.servlet.http.HttpServletResponse; |
|---|
| | | import java.math.BigDecimal; |
|---|
| | | import java.time.DayOfWeek; |
|---|
| | | 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; |
|---|
| | | import java.util.*; |
|---|
| | | |
|---|
| | | @AllArgsConstructor |
|---|
| | | @Service |
|---|
| | |
|---|
| | | accountDto.setIncomeNumber(incomeNumber); |
|---|
| | | BigDecimal totalIncome = accountIncomes.stream().map(AccountDto2::getAccount).reduce(BigDecimal.ZERO, BigDecimal::add); |
|---|
| | | accountDto.setTotalIncome(totalIncome); |
|---|
| | | accountIncomes.stream().forEach(accountDto2 -> { |
|---|
| | | accountDto2.setProportion(accountDto2.getAccount().divide(totalIncome,2,BigDecimal.ROUND_HALF_UP)); |
|---|
| | | }); |
|---|
| | | accountIncomes.forEach(accountDto2 -> accountDto2.setProportion( |
|---|
| | | totalIncome.compareTo(BigDecimal.ZERO) == 0 |
|---|
| | | ? BigDecimal.ZERO |
|---|
| | | : accountDto2.getAccount().divide(totalIncome, 2, BigDecimal.ROUND_HALF_UP))); |
|---|
| | | accountDto.setIncomeType(accountIncomes); |
|---|
| | | //获取该段时间内的所有支出 |
|---|
| | | List<AccountDto2> accountExpenses =accountExpenseMapper.report(dateQueryDto); |
|---|
| | |
|---|
| | | accountDto.setExpenseNumber(expenseNumber); |
|---|
| | | BigDecimal totalExpense = accountExpenses.stream().map(AccountDto2::getAccount).reduce(BigDecimal.ZERO, BigDecimal::add); |
|---|
| | | accountDto.setTotalExpense(totalExpense); |
|---|
| | | accountExpenses.stream().forEach(accountDto2 -> { |
|---|
| | | accountDto2.setProportion(accountDto2.getAccount().divide(totalExpense,2,BigDecimal.ROUND_HALF_UP)); |
|---|
| | | }); |
|---|
| | | accountExpenses.forEach(accountDto2 -> accountDto2.setProportion( |
|---|
| | | totalExpense.compareTo(BigDecimal.ZERO) == 0 |
|---|
| | | ? BigDecimal.ZERO |
|---|
| | | : accountDto2.getAccount().divide(totalExpense, 2, BigDecimal.ROUND_HALF_UP))); |
|---|
| | | accountDto.setExpenseType(accountExpenses); |
|---|
| | | //净收入 |
|---|
| | | BigDecimal netRevenue = totalIncome.subtract(totalExpense); |
|---|
| | |
|---|
| | | return accountDto3s; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public Map<String, List<String>> analysis() { |
|---|
| | | // 获取本周的时间范围 |
|---|
| | | LocalDate startOfWeek = LocalDate.now().with(DayOfWeek.MONDAY); |
|---|
| | | LocalDate endOfWeek = LocalDate.now().with(DayOfWeek.SUNDAY); |
|---|
| | | Map<String, List<String>> result = new HashMap<>(); |
|---|
| | | List<String> days = new ArrayList<>(); |
|---|
| | | List<String> totalIncomeList = new ArrayList<>(); |
|---|
| | | List<String> totalExpenseList = new ArrayList<>(); |
|---|
| | | List<String> netIncomeList = new ArrayList<>(); |
|---|
| | | // 根据时间范围循环查询每一天的总收入，总支出,净收入（总收入-总支出） |
|---|
| | | for (LocalDate date = startOfWeek; date.isBefore(endOfWeek) || date.isEqual(endOfWeek); date = date.plusDays(1)) { |
|---|
| | | BigDecimal totalIncome = accountIncomeMapper.selectList(Wrappers.<AccountIncome>lambdaQuery() |
|---|
| | | .eq(AccountIncome::getInputTime, date.toString())) |
|---|
| | | .stream() |
|---|
| | | .map(AccountIncome::getIncomeMoney) |
|---|
| | | .filter(Objects::nonNull) |
|---|
| | | .reduce(BigDecimal.ZERO, BigDecimal::add); |
|---|
| | | BigDecimal totalExpense = accountExpenseMapper.selectList(Wrappers.<AccountExpense>lambdaQuery() |
|---|
| | | .eq(AccountExpense::getInputTime, date.toString())) |
|---|
| | | .stream() |
|---|
| | | .map(AccountExpense::getExpenseMoney) |
|---|
| | | .filter(Objects::nonNull) |
|---|
| | | .reduce(BigDecimal.ZERO, BigDecimal::add); |
|---|
| | | BigDecimal netIncome = totalIncome.subtract(totalExpense); |
|---|
| | | days.add(date.toString()); |
|---|
| | | totalIncomeList.add(totalIncome.toString()); |
|---|
| | | totalExpenseList.add(totalExpense.toString()); |
|---|
| | | netIncomeList.add(netIncome.toString()); |
|---|
| | | } |
|---|
| | | result.put("days", days); // 天 |
|---|
| | | result.put("totalIncome", totalIncomeList); // 收入 |
|---|
| | | result.put("totalExpense", totalExpenseList); // 支出 |
|---|
| | | result.put("netIncome", netIncomeList); // 净收入 |
|---|
| | | |
|---|
| | | return result; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public Map<String, Object> categoryReport(DateQueryDto dateQueryDto) { |
|---|
| | | Map<String, Object> result = new HashMap<>(); |
|---|
| | | result.put("share", accountExpenseMapper.reportByCategory(dateQueryDto)); |
|---|
| | | result.put("trend", accountExpenseMapper.trendByCategory(dateQueryDto)); |
|---|
| | | return result; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public AccountExpense getByInvoiceNumber(String purchaseContractNumber) { |
|---|
| | | return accountExpenseMapper.selectOne(Wrappers.<AccountExpense>lambdaQuery() |
|---|
| | | .eq(AccountExpense::getInvoiceNumber, purchaseContractNumber)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<AccountExpense> getByInvoiceNumberList(String purchaseContractNumber) { |
|---|
| | | return accountExpenseMapper.selectList(Wrappers.<AccountExpense>lambdaQuery() |
|---|
| | | .eq(AccountExpense::getInvoiceNumber, purchaseContractNumber)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
