| | |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.project.domain.FunddetailReqVo; |
| | | import com.ruoyi.project.domain.ServiceFunddetail; |
| | | import com.ruoyi.project.domain.SpStatBonus; |
| | | import com.ruoyi.project.domain.SpStatBonusReq; |
| | | import com.ruoyi.project.domain.vo.TaxMoneyByItemEO; |
| | | import com.ruoyi.project.domain.vo.TaxMoneySumEO; |
| | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.time.LocalDate; |
| | | import java.time.ZoneId; |
| | | import java.time.temporal.TemporalAdjusters; |
| | |
| | | startPage(); |
| | | return getDataTable(serviceFunddetailService.getListBySpStatBonus(spStatBonusReq)); |
| | | } |
| | | |
| | | /** |
| | | * 导出绩效奖金统计 |
| | | */ |
| | | @ApiOperation("导出绩效奖金统计") |
| | | @Log(title = "绩效统计", businessType = BusinessType.EXPORT) |
| | | @GetMapping("/exportBonus") |
| | | public AjaxResult exportBonus(SpStatBonusReq spStatBonusReq) { |
| | | List<SpStatBonus> list = serviceFunddetailService.getListBySpStatBonus(spStatBonusReq); |
| | | // 金额 0.00 不显示 |
| | | for (SpStatBonus row : list) { |
| | | row.setAmount(blankZero(row.getAmount())); |
| | | } |
| | | ExcelUtil<SpStatBonus> util = new ExcelUtil<SpStatBonus>(SpStatBonus.class); |
| | | return util.exportExcel(list, "绩效统计数据"); |
| | | } |
| | | |
| | | private BigDecimal blankZero(BigDecimal value) { |
| | | return (value == null || value.compareTo(BigDecimal.ZERO) == 0) ? null : value; |
| | | } |
| | | } |