元谋二期后端软件系统
blame | 历史 | 补丁 | 提交 | 提交对比 | show whitespace
Administrator
2023-12-21 86e5bb4399d25e0a4ffa5188d6c0a5cc727efef1 
 pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/divide/DivideCtrl.java


@@ -1,5 +1,7 @@


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;


@@ -16,14 +18,19 @@


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 java.io.IOException;


import java.io.UnsupportedEncodingException;


import java.net.URLEncoder;


import java.time.format.DateTimeFormatter;


import java.util.Date;


import java.util.List;


@@ -93,4 +100,28 @@


        return BaseResponseUtils.buildSuccess(true) ;


    }






    @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);


    }




    /**


     * 设置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");


    }


}