山西直流电源系统
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
whyclxw
6 天以前 10613f0fe047752f23d83a567d46dca609b04447 
 src/main/java/com/whyc/service/ExportService.java


@@ -1,17 +1,28 @@


package com.whyc.service;




import cn.afterturn.easypoi.entity.ImageEntity;


import cn.afterturn.easypoi.excel.ExcelExportUtil;


import cn.afterturn.easypoi.excel.entity.TemplateExportParams;


import com.whyc.dto.Real.ExportTinfDataDto;


import com.whyc.dto.Response;


import com.whyc.dto.Statistic.MonStic;


import com.whyc.dto.Statistic.SticMonRes;


import com.whyc.mapper.CommonMapper;


import com.whyc.pojo.db_batt_testdata.BatttestdataId;


import com.whyc.pojo.db_batt_testdata.BatttestdataInf;


import com.whyc.pojo.db_user.User;


import com.whyc.util.ActionUtil;


import com.whyc.util.ServletUtils;


import org.apache.poi.hssf.usermodel.*;


import org.apache.poi.ss.formula.functions.T;


import org.apache.poi.ss.usermodel.ClientAnchor;


import org.apache.poi.ss.usermodel.Workbook;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.core.io.ClassPathResource;


import org.springframework.stereotype.Service;


import sun.misc.BASE64Decoder;




import javax.annotation.Resource;


import javax.servlet.http.HttpServletRequest;


import javax.servlet.http.HttpServletResponse;


import java.io.IOException;


@@ -20,10 +31,7 @@


import java.net.URLEncoder;


import java.text.ParseException;


import java.text.SimpleDateFormat;


import java.util.ArrayList;


import java.util.Date;


import java.util.List;


import java.util.Map;


import java.util.*;




@Service


public class ExportService {


@@ -31,17 +39,22 @@


    @Autowired


    private BatttestdataInfService battTinfService;




    @Autowired


    private SubTablePageInfoService subTablePageInfoService;




    @Resource


    private CommonMapper commonMapper;






    //单节数量统计导出（1.2.14）


    public void exportBattTinfStatistic(HttpServletRequest req, HttpServletResponse resp) throws ParseException {


        String topPic = req.getParameter("topPic");            //头部柱状图


        String goodVolPic = req.getParameter("goodVolPic");            //优秀电压图


        String goodResPic = req.getParameter("goodResPic");        //优秀内阻


        String badVolPic = req.getParameter("badVolPic");            //劣化电压图


        String badResPic = req.getParameter("badResPic");        //劣化内阻


        String damageVolPic = req.getParameter("damageVolPic");            //损坏电压图


        String damageResPic = req.getParameter("damageResPic");        //损坏内阻


        MonStic stic=ActionUtil.getGson("yyyy-MM-dd").fromJson(req.getParameter("stic"),  MonStic.class);


    public void exportBattTinfStatistic(HttpServletRequest req, HttpServletResponse resp, MonStic stic) throws ParseException {


        String topPic = stic.getTopPic();            //头部柱状图


        String goodVolPic = stic.getGoodVolPic();            //优秀电压图


        String goodResPic = stic.getGoodResPic();        //优秀内阻


        String badVolPic = stic.getBadVolPic();            //劣化电压图


        String badResPic = stic.getBadResPic();        //劣化内阻


        String damageVolPic = stic.getDamageVolPic();            //损坏电压图


        String damageResPic = stic.getDamageResPic();        //损坏内阻


        User uinf= ActionUtil.getUser();


        stic.setUid(uinf.getId());


        Map<String,Object> map= battTinfService.getMonStatistic(stic);


@@ -154,7 +167,7 @@


        //图片元素


        HSSFPatriarch patriarch = sheet.createDrawingPatriarch();


        int rowNum = 1;


        int rowNumAdd=27;


        int rowNumAdd=25;


        //插入图片


        int picNum = 0;


        String[] picName = new String[]{


@@ -164,11 +177,56 @@


            sheet.createRow(rowNum - 1);


            sheet.getRow(rowNum - 1).createCell(0).setCellValue(picName[i]);


            HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 512, 255, (short) 0, rowNum, (short) 10, rowNum + rowNumAdd);


            anchor.setAnchorType(ClientAnchor.AnchorType.DONT_MOVE_AND_RESIZE);


            anchor.setAnchorType(ClientAnchor.AnchorType.MOVE_DONT_RESIZE);


            patriarch.createPicture(anchor, wb.addPicture(bytes.get(picNum), HSSFWorkbook.PICTURE_TYPE_PNG)).resize(1);


            picNum++;


            rowNum += rowNumAdd;


            rowNum = rowNum+rowNumAdd+5;


        }


        rowNum++;


    }


    //历史测试数据导出


    public void exportTinfDataByTestRecordCount(HttpServletRequest req, HttpServletResponse resp, ExportTinfDataDto dto) throws IOException {


       Map<String,Object> map=new HashMap<>();


        //历史测试数据导出


        BatttestdataInf tinf = battTinfService.exportTinfDataByTestRecordCount(dto.getBattgroupId(), dto.getTestRecordCount());


        String tableName ="db_batt_testdata.tb_batttestdata_"+dto.getBattgroupId();


        //获取具体的放电数据


        List<BatttestdataId> dataList= subTablePageInfoService.exportTinfDataByTestRecordCount(dto.getBattgroupId(),dto.getTestRecordCount(),tableName);


        map.put("dataList",dataList);


        BASE64Decoder decoder = new BASE64Decoder();


        if(!dto.getPicGroupVol().equals("")) {


            ImageEntity volImage = new ImageEntity();


            volImage.setData(decoder.decodeBuffer(dto.getPicGroupVol().substring(dto.getPicGroupVol().indexOf(",") + 1)));


            volImage.setColspan(6);


            volImage.setRowspan(17);


            map.put("picGroupVol",volImage);


        }


        if(!dto.getPicBattVol().equals("")) {


            ImageEntity volImage = new ImageEntity();


            volImage.setData(decoder.decodeBuffer(dto.getPicGroupVol().substring(dto.getPicBattVol().indexOf(",") + 1)));


            volImage.setColspan(6);


            volImage.setRowspan(17);


            map.put("picBattVol",volImage);


        }


        if(!dto.getPicGroupCurr().equals("")) {


            ImageEntity volImage = new ImageEntity();


            volImage.setData(decoder.decodeBuffer(dto.getPicGroupVol().substring(dto.getPicGroupCurr().indexOf(",") + 1)));


            volImage.setColspan(6);


            volImage.setRowspan(17);


            map.put("picGroupCurr",volImage);


        }


        //获取导出模板地址


        ClassPathResource classPathResource = new ClassPathResource("excel_templates/batt_mon_static_template.xlsx");


        String path = classPathResource.getPath();


        TemplateExportParams templateExportParams1 = new TemplateExportParams(path);


        Workbook wb = ExcelExportUtil.exportExcel(templateExportParams1, map);


        try {


            String fileName = "历史测试数据表.xls";


            resp.setContentType("application/vnd.ms-excel");


            resp.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "utf-8"));


            resp.flushBuffer();


            wb.write(resp.getOutputStream());


        } catch (IOException e) {


            e.printStackTrace();


        }


    }


}