package com.dy.pipIrrProject.divide;
|
|
import com.alibaba.excel.EasyExcel;
|
import com.alibaba.excel.support.ExcelTypeEnum;
|
import com.dy.common.aop.SsoAop;
|
import com.dy.common.webUtil.BaseResponse;
|
import com.dy.common.webUtil.BaseResponseUtils;
|
import com.dy.common.webUtil.QueryResultVo;
|
import com.dy.common.webUtil.ResultCodeMsg;
|
import com.dy.pipIrrGlobal.pojoPr.PrDivide;
|
import com.dy.pipIrrGlobal.voPr.VoDivide;
|
import com.dy.pipIrrGlobal.voSe.VoActiveCard;
|
import com.dy.pipIrrProject.result.ProjectResultCode;
|
import io.swagger.v3.oas.annotations.Operation;
|
import io.swagger.v3.oas.annotations.Parameter;
|
import io.swagger.v3.oas.annotations.media.Content;
|
import io.swagger.v3.oas.annotations.media.Schema;
|
import io.swagger.v3.oas.annotations.responses.ApiResponse;
|
import io.swagger.v3.oas.annotations.responses.ApiResponses;
|
import io.swagger.v3.oas.annotations.tags.Tag;
|
import jakarta.servlet.http.HttpServletResponse;
|
import jakarta.validation.Valid;
|
import lombok.RequiredArgsConstructor;
|
import lombok.SneakyThrows;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.http.MediaType;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.validation.BindingResult;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import java.io.IOException;
|
import java.io.UnsupportedEncodingException;
|
import java.net.URLEncoder;
|
import java.time.format.DateTimeFormatter;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Objects;
|
import java.util.Optional;
|
|
/**
|
* @author ZhuBaoMin
|
* @date 2023/12/20 20:11
|
* @LastEditTime 2023/12/20 20:11
|
* @Description
|
*/
|
|
@Slf4j
|
@Tag(name = "分水房管理", description = "分水房操作")
|
@RestController
|
@RequestMapping(path="divide")
|
@RequiredArgsConstructor
|
public class DivideCtrl {
|
private final DivideSv divideSv;
|
|
@Operation(summary = "获得一页分水房记录", description = "返回一页分水房数据")
|
@ApiResponses(value = {
|
@ApiResponse(
|
responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE,
|
description = "返回一页开卡数据（BaseResponse.content:QueryResultVo[{}]）",
|
content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE,
|
schema = @Schema(implementation = VoActiveCard.class))}
|
)
|
})
|
@GetMapping(path = "/getDivides", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@SsoAop()
|
public BaseResponse<QueryResultVo<List<VoDivide>>> getDivides(@RequestBody @Parameter(description = "查询form表单json数据", required = true) QueryVo vo){
|
try {
|
QueryResultVo<List<VoDivide>> res = divideSv.getDivides(vo);
|
return BaseResponseUtils.buildSuccess(res);
|
} catch (Exception e) {
|
log.error("获取开卡记录异常", e);
|
return BaseResponseUtils.buildException(e.getMessage()) ;
|
}
|
}
|
|
@Operation(summary = "添加分水房记录", description = "添加分水房记录")
|
@ApiResponses(value = {
|
@ApiResponse(
|
responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE,
|
description = "操作结果：true：成功，false：失败（BaseResponse.content）",
|
content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE,
|
schema = @Schema(implementation = Boolean.class))}
|
)
|
})
|
@PostMapping(path = "add", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@Transactional(rollbackFor = Exception.class)
|
@SsoAop()
|
public BaseResponse<Boolean> add(@RequestBody @Parameter(description = "form表单json数据", required = true) @Valid PrDivide po, @Parameter(hidden = true) BindingResult bindingResult){
|
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
|
if(bindingResult != null && bindingResult.hasErrors()){
|
return BaseResponseUtils.buildFail(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
|
}
|
|
Date operateTime = new Date();
|
po.setOperatedt(operateTime);
|
Integer rec = Optional.ofNullable(divideSv.addDivide(po)).orElse(0);
|
if(rec == 0) {
|
return BaseResponseUtils.buildFail(ProjectResultCode.DIVIDE_FAIL.getMessage());
|
}
|
return BaseResponseUtils.buildSuccess(true) ;
|
}
|
|
|
/**
|
* 导出分水房列表
|
* @param response
|
* @param vo
|
*/
|
@SneakyThrows(IOException.class)
|
@RequestMapping(value = "/exportDivides", method = RequestMethod.GET)
|
public void exportDivides(HttpServletResponse response, QueryVo vo) {
|
setExcelRespProp(response, "分水房列表");
|
//List<VoDivide> memberList = LocalJsonUtil.getListFromJson("json/members.json", VoDivide.class);
|
List<VoDivide> memberList = divideSv.exportDivides(vo);
|
|
EasyExcel.write(response.getOutputStream())
|
.head(VoDivide.class)
|
.excelType(ExcelTypeEnum.XLSX)
|
.sheet("分水房列表")
|
.doWrite(memberList);
|
}
|
|
@SneakyThrows
|
@RequestMapping(value = "/importDivides", method = RequestMethod.POST)
|
@ResponseBody
|
public BaseResponse<Boolean> importDivides(@RequestPart("file") MultipartFile file) {
|
List<VoDivide> memberList = EasyExcel.read(file.getInputStream())
|
.head(VoDivide.class)
|
.sheet()
|
.doReadSync();
|
return BaseResponseUtils.buildSuccess(memberList) ;
|
}
|
|
/**
|
* 设置excel下载响应头属性
|
*/
|
private void setExcelRespProp(HttpServletResponse response, String rawFileName) throws UnsupportedEncodingException {
|
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
|
response.setCharacterEncoding("utf-8");
|
String fileName = URLEncoder.encode(rawFileName, "UTF-8").replaceAll("\\+", "%20");
|
response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
|
}
|
}
|
