package com.artfess.cqlt.controller; import com.artfess.base.annotation.ApiGroup; import com.artfess.base.constants.ApiGroupConsts; import com.artfess.base.controller.BaseController; import com.artfess.base.exception.RequiredException; import com.artfess.base.model.CommonResult; import com.artfess.base.query.PageList; import com.artfess.base.query.QueryFilter; import com.artfess.base.util.DateUtils; import com.artfess.base.valid.AddGroup; import com.artfess.base.valid.UpdateGroup; import com.artfess.cqlt.manager.QfFinanceCfDManager; import com.artfess.cqlt.manager.QfFinanceCfMManager; import com.artfess.cqlt.model.QfFinanceBsBudgetM; import com.artfess.cqlt.model.QfFinanceCfBudgetM; import com.artfess.cqlt.model.QfFinanceCfD; import com.artfess.cqlt.model.QfFinanceCfM; import com.artfess.i18n.util.I18nUtil; import com.artfess.poi.util.ExcelUtil; import com.artfess.poi.util.FileDownloadUtil; import com.artfess.poi.util.HeaderNode; import com.artfess.uc.api.impl.util.ContextUtil; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import io.swagger.annotations.ApiParam; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.i18n.LocaleContextHolder; import org.springframework.core.io.ClassPathResource; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.time.LocalDate; import java.util.Arrays; import java.util.List; /** * 财务--现金流量填报主表 前端控制器 * * @company 阿特菲斯信息技术有限公司 * @author min.wu * @since 2023-03-02 */ @Slf4j @RestController @Api(tags = "财务--现金流量填报主表") @RequestMapping("/qf/finance/cf/v1/") @ApiGroup(group = {ApiGroupConsts.GROUP_BIZ}) public class QfFinanceCfMController extends BaseController { @Autowired private QfFinanceCfDManager detailManager; @PostMapping("/test") @ApiOperation("批量添加") public CommonResult test(@RequestBody QfFinanceCfM t) { for (int i = 1; i <= 12; i++) { QfFinanceCfM mainInfo = new QfFinanceCfM(); mainInfo.setFillMonth(i); mainInfo.setFillUser(ContextUtil.getCurrentUserId()); mainInfo.setFillDate(LocalDate.now()); mainInfo.setFillQuarter(DateUtils.getQuarter(i)); mainInfo.setFillYear(t.getFillYear()); mainInfo.setReportId(t.getReportId()); baseService.insertInfo(mainInfo); } return new CommonResult(true, I18nUtil.getMessage("option.success", LocaleContextHolder.getLocale()), t.getId()); } @Override @PostMapping("/") @ApiOperation("添加实体的接口") public CommonResult create(@ApiParam(name = "model", value = "实体信息") @RequestBody @Validated({AddGroup.class}) QfFinanceCfM t) { t.setFillUser(ContextUtil.getCurrentUserId()); t.setFillDate(LocalDate.now()); t.setFillQuarter(DateUtils.getQuarter(t.getFillMonth())); boolean result = baseService.insertInfo(t); if (!result) { return new CommonResult(false, I18nUtil.getMessage("option.fail", LocaleContextHolder.getLocale()), null); } return new CommonResult(true, I18nUtil.getMessage("option.success", LocaleContextHolder.getLocale()), t.getId()); } @Override @PutMapping("/") @ApiOperation("更新实体") public CommonResult updateById(@ApiParam(name = "model", value = "实体信息") @RequestBody @Validated({UpdateGroup.class}) QfFinanceCfM t) { boolean result = baseService.updateInfo(t); if (!result) { return new CommonResult(false, I18nUtil.getMessage("option.fail", LocaleContextHolder.getLocale()), null); } return new CommonResult(true, I18nUtil.getMessage("option.success", LocaleContextHolder.getLocale()), null); } @PutMapping("/updateStatus") @ApiOperation("生效") public CommonResult updateStatus(@ApiParam(name = "model", value = "实体信息") @RequestBody QfFinanceCfM t) { boolean result = baseService.updateStatus(t); if (!result) { return new CommonResult(false, I18nUtil.getMessage("option.fail", LocaleContextHolder.getLocale()), null); } return new CommonResult(true, I18nUtil.getMessage("option.success", LocaleContextHolder.getLocale()), null); } @Override @DeleteMapping("/{id}") @ApiOperation("根据id删除") public CommonResult deleteById(@ApiParam(name = "id", value = "实体id") @PathVariable String id) { boolean result = baseService.removeById(id); if (!result) { return new CommonResult(false, I18nUtil.getMessage("delete.fail", LocaleContextHolder.getLocale()), null); } return new CommonResult(true, I18nUtil.getMessage("option.success", LocaleContextHolder.getLocale()), null); } @Override @DeleteMapping("/") @ApiOperation("根据id集合批量删除") public CommonResult deleteByIds(@ApiParam(name = "ids", value = "实体集合") @RequestParam String... ids) { boolean result = baseService.removeByIds(Arrays.asList(ids)); if (!result) { return new CommonResult(false, I18nUtil.getMessage("delete.fail", LocaleContextHolder.getLocale()), null); } return new CommonResult(true, I18nUtil.getMessage("option.success", LocaleContextHolder.getLocale()), null); } /** * @param file * @param mainId * @return */ @ApiOperation(value = "现金流量数据导入") @PostMapping("/importExcel") public CommonResult importExcel(@RequestParam("file") MultipartFile file, @RequestParam(value = "mainId", required = false) String mainId) { try { List list = ExcelUtil.importAllData(file, false); boolean result = baseService.importExcel(list, mainId); if (!result) { throw new IllegalArgumentException(I18nUtil.getMessage("import.fail", LocaleContextHolder.getLocale())); } return new CommonResult<>(); } catch (Exception e) { e.printStackTrace(); throw new IllegalArgumentException(I18nUtil.getMessage("import.fail", LocaleContextHolder.getLocale()) + "," + e.getMessage()); } } /** * 下载导入模板 * * @param response * @return */ @ApiOperation(value = "下载导入模板") @GetMapping("/downModel") public void downTemplate(HttpServletResponse response) { try { ClassPathResource classPathResource = new ClassPathResource("model/financeCFDetail.xlsx"); FileDownloadUtil.fileDownload(response, classPathResource.getInputStream(), "现金流量信息数据样例数据.xlsx"); } catch (Exception e) { response.setCharacterEncoding("utf-8"); throw new RequiredException(I18nUtil.getMessage("resources.noexist", LocaleContextHolder.getLocale())); } } @ApiOperation(value = "现金流量数据导出") @PostMapping("/export") public void export(HttpServletRequest request, HttpServletResponse response, @ApiParam(name = "queryFilter", value = "分页查询信息") @RequestBody QueryFilter queryFilter) throws Exception { PageList page = detailManager.query(queryFilter); detailManager.export(request, response, page.getRows(), "现金流量信息"); } }