package com.doumee.api.business; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.doumee.api.BaseController; import com.doumee.core.annotation.excel.ExcelExporter; import com.doumee.core.model.ApiResponse; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.core.utils.DateUtil; import com.doumee.dao.business.model.Areas; import com.doumee.dao.business.model.Integral; import com.doumee.dao.business.model.MonthlySettlement; import com.doumee.service.business.MonthlySettlementService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.StringUtils; import org.apache.shiro.authz.annotation.RequiresPermissions; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.bind.annotation.*; import org.springframework.web.servlet.ModelAndView; import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; import java.util.Arrays; import java.util.List; /** *

* 月结费用 前端控制器 *

* 首页路由:/MonthlySettlement/list * @author Doumee * @since 2022-11-08 */ @Api(tags = " 月结费用") @RestController @RequestMapping("/business/monthlySettlement") public class MonthlySettlementController extends BaseController { @Autowired private MonthlySettlementService monthlySettlementService; /** * 分页列表 * @return */ @ApiOperation("分页查询") @PostMapping("/page") // @RequiresPermissions("business:monthlySettlement:query") public ApiResponse> findPage (@RequestBody PageWrap pageWrap) { PageData pa=monthlySettlementService.findPage(pageWrap); return ApiResponse.success(pa); } @ApiOperation("导出Excel") @PostMapping("/exportExcel") @RequiresPermissions("business:monthlySettlement:exportExcel") public void exportExcel (@RequestBody MonthlySettlement pageWrap, HttpServletResponse response) throws Exception { List list=monthlySettlementService.Listall(pageWrap); for(MonthlySettlement model:list){ if(model.getYear()!=null){ model.setYearmonth(model.getYear()+"."+model.getMonth()); } } ExcelExporter.build(MonthlySettlement.class).export(list, "资金月账单"+ DateUtil.getNowLongTime(), response); } }