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;
|
|
/**
|
* <p>
|
* 月结费用 前端控制器
|
* </p>
|
* 首页路由：/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<PageData<MonthlySettlement>> findPage (@RequestBody PageWrap<MonthlySettlement> pageWrap) {
|
PageData<MonthlySettlement> 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<MonthlySettlement> 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);
|
}
|
|
|
|
}
|
