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.Direction; import com.artfess.base.query.FieldSort; 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.QfFinanceLiquidityDetailManager; import com.artfess.cqlt.manager.QfFinanceLiquidityMManager; import com.artfess.cqlt.model.QfFinanceLiquidityDetail; import com.artfess.cqlt.model.QfFinanceLiquidityM; 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.apache.poi.ss.formula.functions.T; 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.DeleteMapping; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.PutMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; 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/liquidity/") @ApiGroup(group = {ApiGroupConsts.GROUP_BIZ}) public class QfFinanceLiquidityMController extends BaseController { @Autowired private QfFinanceLiquidityDetailManager liquidityDetailManager; @Override @PostMapping(value="/query", produces={"application/json; charset=utf-8" }) @ApiOperation("分页查询结果") public PageList query(@ApiParam(name="queryFilter", value="分页查询信息") @RequestBody QueryFilter queryFilter) { List sorter = queryFilter.getSorter(); sorter.add(new FieldSort("fill_week_", Direction.ASC)); queryFilter.setSorter(sorter); queryFilter.getSorter().removeIf(e -> "fillMonth".equals(e.getProperty())); return baseService.query(queryFilter); } @Override @PostMapping("/") @ApiOperation("添加实体的接口") public CommonResult create(@ApiParam(name = "model", value = "实体信息") @RequestBody @Validated({AddGroup.class}) QfFinanceLiquidityM t) { t.setFillUser(ContextUtil.getCurrentUserId()); t.setFillDate(LocalDate.now()); 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}) QfFinanceLiquidityM 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 QfFinanceLiquidityM 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/financeeLiquidityDetail.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 = liquidityDetailManager.query(queryFilter); liquidityDetailManager.export(request, response, page.getRows(), "周资金信息"); } }