package com.ruoyi.requier.handler;

import cn.hutool.json.JSONUtil;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.deepoove.poi.data.*;
import com.deepoove.poi.data.style.*;
import com.ruoyi.framework.exception.ErrorException;
import com.ruoyi.framework.util.MyUtil;
import com.ruoyi.inspect.dto.SampleProductDto;
import com.ruoyi.inspect.mapper.InsProductMapper;
import com.ruoyi.inspect.mapper.InsSampleMapper;
import com.ruoyi.inspect.pojo.InsProduct;
import com.ruoyi.inspect.pojo.InsReport;
import com.ruoyi.inspect.pojo.InsSample;
import com.ruoyi.inspect.vo.InsProductFiberVO;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.xwpf.usermodel.ParagraphAlignment;
import org.apache.poi.xwpf.usermodel.TableRowAlign;
import org.apache.poi.xwpf.usermodel.XWPFTable;
import org.apache.poi.xwpf.usermodel.XWPFTableCell;

import java.text.Collator;
import java.util.*;
import java.util.concurrent.atomic.AtomicInteger;
import java.util.stream.Collectors;

/**
 * 光纤带尺寸参数报告处理类
 */
public class FiberOpticRibbonReportHandler {

    /**
     * 默认表格宽度
     */
    private final static int[] DEFAULT_COL_WIDTHS = {1600,0, 1200, 1200, 1200, 1200, 1200, 1200,1200};

    private final InsProductMapper insProductMapper;
    private final InsSampleMapper insSampleMapper;

    public FiberOpticRibbonReportHandler(InsProductMapper insProductMapper, InsSampleMapper insSampleMapper){
        this.insProductMapper = insProductMapper;
        this.insSampleMapper = insSampleMapper;
    }

    private final static String ITEM_SPLIT_CHAR = "&";//检验项分隔符

    private final static String COLOR_SPLIT_CHAR = "-";//色标分隔符

    /**
     *
     * @param samples    所有样品
     * @param insReport  report对象
     * @param tables6    尺寸参数附件表格行列表
     * @param colorDict  色标字典
     */
    public void doWrite(List<SampleProductDto> samples, InsReport insReport, List<Map<String,Object>> tables6,
                        List<String> colorDict){
        AtomicInteger index6 = new AtomicInteger(1);//页码
        samples.forEach(sample -> {
            //查询样品下的检验项和光纤带编号
            List<InsProductFiberVO> insProducts1 = insProductMapper.selectInsProductInsFibersList(sample.getId());
            //根据光纤带编号
            Map<String,List<InsProductFiberVO>> groupProducts = insProducts1.stream()
                    .filter(p->p.getInspectionItem().equals("尺寸参数"))
                    .collect(Collectors.groupingBy(product -> product.getBushColor()+"-"+product.getCode()));
            if(groupProducts.isEmpty()){
                return;
            }
            List<String[]> collect = groupProducts.keySet().stream().map(k -> k.split(COLOR_SPLIT_CHAR)).sorted((o1, o2) -> {
                if (o1.length > 1 && o2.length > 1) {
                    if (!Objects.equals(o1[0], o2[0])) {
                        Integer o1Index = colorDict.indexOf(o1[0]);
                        Integer o2Index = colorDict.indexOf(o2[0]);
                        return o1Index.compareTo(o2Index);
                    }
                    if (!Objects.equals(o1[1], o2[1])) {
                        Integer o1Index = colorDict.indexOf(o1[1]);
                        Integer o2Index = colorDict.indexOf(o2[1]);
                        return o1Index.compareTo(o2Index);
                    }
                }
                return 0;
            }).collect(Collectors.toList());
            List<String> sortKeys = collect.stream().map(c->String.join(COLOR_SPLIT_CHAR,c)).collect(Collectors.toList());
            //检验项列表(表头)
            List<String> itemMap = insProducts1.stream().sorted((o1,o2)->{
                //根据检验项排序
                if(!Objects.equals(o1.getInspectionItem(),o2.getInspectionItem())){
                    List<String> specialItems = Arrays.asList("耐环境应力开裂","热收缩率");
                    if(specialItems.contains(o1.getInspectionItem()) && specialItems.contains(o2.getInspectionItem())){
                        return Integer.MAX_VALUE;
                    }
                    Collator instance = Collator.getInstance(Locale.CHINA);
                    return instance.compare(o1.getInspectionItem(),o2.getInspectionItem());
                }
                //检验子项排序
                if(StringUtils.isNotBlank(o1.getInspectionItemSubclass())&& StringUtils.isNotBlank(o2.getInspectionItemSubclass())){
                    if(!Objects.equals(o1.getInspectionItemSubclass(),o2.getInspectionItemSubclass())){
                        Collator instance = Collator.getInstance(Locale.CHINA);
                        return instance.compare(o1.getInspectionItemSubclass(),o2.getInspectionItemSubclass());
                    }
                }
                return 0;
            }).map(insProduct -> {
                String item = MyUtil.joinChars("@",insProduct.getInspectionItem(),insProduct.getInspectionItemEn());
                String itemSubClass = MyUtil.joinChars("@",insProduct.getInspectionItemSubclass(),insProduct.getInspectionItemSubclassEn());
                return MyUtil.joinChars(ITEM_SPLIT_CHAR,item,itemSubClass);
            }).distinct().collect(Collectors.toList());
            long size = itemMap.size();//表头长度
            long size2 = insProducts1.stream().map(InsProduct::getInsFibersId).distinct().count();
            long number = 10;
            //判断检验项目是否有父子关系
            int a = itemMap.stream().anyMatch(p -> p.split(ITEM_SPLIT_CHAR).length>0) ? 2 : 1;
            for (long c = 0; c < size; c++) {
                if (c % number == 0) {
                    List<RowRenderData> rows = new ArrayList<>();
                    //表格的行数
                    for (long i = 0; i < size2 + a + 2; i++) {
                        RowRenderData rowRenderData = new RowRenderData();
                        RowStyle rowStyle = new RowStyle();
                        rowStyle.setHeight(40);
                        rowRenderData.setRowStyle(rowStyle);
                        List<CellRenderData> cells = new ArrayList<>();
                        //表格的列数
                        for (long j = 0; j < 12; j++) {
                            CellRenderData cellRenderData = new CellRenderData();
                            CellStyle cellStyle = new CellStyle();
                            cellStyle.setVertAlign(XWPFTableCell.XWPFVertAlign.CENTER);
                            cellRenderData.setCellStyle(cellStyle);
                            List<ParagraphRenderData> paragraphRenderDataList = new ArrayList<>();
                            ParagraphRenderData paragraphRenderData = new ParagraphRenderData();
                            ParagraphStyle paragraphStyle = new ParagraphStyle();
                            paragraphStyle.setAlign(ParagraphAlignment.CENTER);
                            paragraphRenderData.setParagraphStyle(paragraphStyle);
                            List<RenderData> renderData = new ArrayList<>();
                            TextRenderData textRenderData = new TextRenderData();
                            Style style = new Style();
                            style.setFontFamily("宋体");
                            style.setColor("000000");
                            style.setFontSize(10);
                            textRenderData.setStyle(style);
                            if(i==0){
                                //第一行
                                if (j<=2) {
                                    textRenderData.setText("样品编号@Sample number∑456");
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                } else if (j >2&&j<=5) {
                                    textRenderData.setText(sample.getSampleCode()+"∑4566");
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                } else if (j >5&&j<=8) {
                                    textRenderData.setText("规格型号@Type∑457");
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }else{
                                    textRenderData.setText(sample.getModel()+"∑4577");
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }
                            }
                            else if (i == 1) {
                                //第二行
                                if (j == 0) {
                                    //第一列
                                    textRenderData.setText("管色标@Pipe∑100");
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                } else if (j == 1) {
                                    //第二列
                                    textRenderData.setText("光纤带编号@Scanning Number∑101");
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                } else {
                                    String inspectionItem = itemMap.get(itemMap.size()-1).split(ITEM_SPLIT_CHAR)[0];
                                    textRenderData.setText("∑" + inspectionItem);
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }
                            }
                            else if (a == 2 && i == 2) {
                                //有父子项目关系的第三行
                                if (j == 0) {
                                    //第一列
                                    textRenderData.setText("管色标@Pipe∑100");
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }
                                else if (j == 1) {
                                    //第二列
                                    textRenderData.setText("光纤带编号@Scanning Number∑101");
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }
                                else if (j >1&& j<=3) {
                                    String[] splits = itemMap.get(0).split(ITEM_SPLIT_CHAR);
                                    if (splits.length<2 || "@".equals(splits[1])) {
                                        textRenderData.setText(splits[0] + "∑" + splits[0]);
                                    } else {
                                        textRenderData.setText(splits[1]+"∑"+splits[0]+splits[1]);
                                    }
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }
                                else if (j>3&&j<=5) {
                                    String[] splits = itemMap.get(1).split(ITEM_SPLIT_CHAR);
                                    if (splits.length<2 || "@".equals(splits[1])) {
                                        textRenderData.setText(splits[0] + "∑" + splits[0]);
                                    } else {
                                        textRenderData.setText(splits[1]+"∑"+splits[0]+splits[1]);
                                    }
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }
                                else if (j >5&&j<=7) {
                                    String[] splits = itemMap.get(2).split(ITEM_SPLIT_CHAR);
                                    if (splits.length<2 || "@".equals(splits[1])) {
                                        textRenderData.setText(splits[0] + "∑" + splits[0]);
                                    } else {
                                        textRenderData.setText(splits[1]+"∑"+splits[0]+splits[1]);
                                    }
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }
                                else if (j >7&&j<=9) {
                                    String[] splits = itemMap.get(3).split(ITEM_SPLIT_CHAR);
                                    if (splits.length<2 || "@".equals(splits[1])) {
                                        textRenderData.setText(splits[0] + "∑" + splits[0]);
                                    } else {
                                        textRenderData.setText(splits[1]+"∑"+splits[0]+splits[1]);
                                    }
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }
                                else{
                                    String[] splits = itemMap.get(4).split(ITEM_SPLIT_CHAR);
                                    if (splits.length<2 || "@".equals(splits[1])) {
                                        textRenderData.setText(splits[0] + "∑" + splits[0]);
                                    } else {
                                        textRenderData.setText(splits[1]+"∑"+splits[0]+splits[1]);
                                    }
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }
                            }
                            else if ( i == 3) {
                                //第四行
                                if (j == 0) {
                                    //第一列
                                    textRenderData.setText("管色标@Pipe∑100");
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                } else if (j == 1) {
                                    //第二列
                                    textRenderData.setText("光纤带编号@Scanning Number∑101");
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                } else {
                                    //项目信息
                                    if((int)(j - 2)%2==0){
                                        textRenderData.setText("A端");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }else{
                                        textRenderData.setText("B端");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                }
                            }
                            else{
                                //循环光纤带编号
                                String key = sortKeys.get((int)i-4);
                                String item;
                                if (j<=3) {
                                    item = itemMap.get(0);
                                }
                                else if (j>3&&j<=5) {
                                    item = itemMap.get(1);
                                }
                                else if (j >5&&j<=7) {
                                    item =  itemMap.get(2);
                                }
                                else if (j >7&&j<=9) {
                                    item =  itemMap.get(3);
                                } else{
                                    item =  itemMap.get(4);
                                }
                                InsProductFiberVO insProduct = groupProducts.get(key).stream()
                                        .filter(p->{
                                            String insItem = MyUtil.joinChars("@",p.getInspectionItem(),p.getInspectionItemEn());
                                            String insSubItem = MyUtil.joinChars("@",p.getInspectionItemSubclass(),p.getInspectionItemSubclassEn());
                                            return item.equals(MyUtil.joinChars(ITEM_SPLIT_CHAR,insItem,insSubItem));
                                        }).findFirst().orElse(new InsProductFiberVO());
                                //填值
                                if (j == 0) {
                                    //第一列
                                    textRenderData.setText(insProduct.getBushColor());
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                } else if (j == 1) {
                                    //第二列
                                    textRenderData.setText(insProduct.getCode());
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                } else {
                                    //项目信息
                                    if((int)(j - 2)%2==0){
                                        textRenderData.setText(transformInsValue(insProduct.getInsValue()).get(0));
                                    }else{
                                        textRenderData.setText(transformInsValue(insProduct.getInsValue()).get(1));
                                    }
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }
                            }
                        }
                        rowRenderData.setCells(cells);
                        if (!rowRenderData.getCells().isEmpty()) {
                            rows.add(rowRenderData);
                        }
                    }
                    TableRenderData tableRenderData = new TableRenderData();
                    tableRenderData.setRows(rows);
                    int countSize = tableRenderData.getRows().get(0).getCells().size();
                    for (RowRenderData row : tableRenderData.getRows()) {
                        if (row.getCells().size() != countSize) {
                            throw new ErrorException("每行单元格不相等6");
                        }
                    }
                    TableStyle tableStyle = new TableStyle();
                    tableStyle.setWidth(XWPFTable.DEFAULT_PERCENTAGE_WIDTH);
                    tableStyle.setAlign(TableRowAlign.CENTER);
                    BorderStyle borderStyle = new BorderStyle();
                    borderStyle.setColor("000000");
                    borderStyle.setType(XWPFTable.XWPFBorderType.THICK);
                    borderStyle.setSize(14);
                    tableStyle.setLeftBorder(borderStyle);
                    tableStyle.setTopBorder(borderStyle);
                    tableStyle.setRightBorder(borderStyle);
                    tableStyle.setBottomBorder(borderStyle);
                    tableRenderData.setTableStyle(tableStyle);
                    Map<String, Object> table = new HashMap<>();
                    table.put("table6", tableRenderData);
                    table.put("report", insReport);
                    table.put("sample_number", sample.getSampleCode());
                    table.put("type", sample.getModel());
                    table.put("index6", index6.get());
                    tables6.add(table);
                    index6.getAndIncrement();
                }
            }
        });
    }

    /**
     * 格式化检验过程值json字符串
     * @param insValue 检验过程值json字符串
     * @return
     */
    private static List<String> transformInsValue(String insValue){
        List<String> list = new ArrayList<>();
        if(!insValue.isEmpty() && !"[]".equals(insValue)){
            for (Object o : JSONUtil.parseArray(insValue)) {
                JSONObject obj = JSON.parseObject(JSON.toJSONString(o));
                if(Objects.nonNull(obj.get("v"))){
                    list.add(obj.get("v").toString());
                }
            }
        }
        return list;
    }

    /**
     * 光纤附件表格：写入行数据
     * @param ribbonList 光纤项目信息
     * @param tables6   光纤带尺寸参数附件表格
     */
    public void writeFiberOpticRibbonEnclosureTableRow(List<InsProductFiberVO> ribbonList, List<Map<String, Object>> tables6,InsReport insReport){
        AtomicInteger index6 = new AtomicInteger(1);//页码
        int colCount = 12;//表格总列数
        int itemCount = 10;//表格项目列数
        //检验项列表(表头)
        List<String> itemMap = ribbonList.stream().sorted((o1,o2)->{
            //根据检验项排序
            if(!Objects.equals(o1.getInspectionItem(),o2.getInspectionItem())){
                List<String> specialItems = Arrays.asList("耐环境应力开裂","热收缩率");
                if(specialItems.contains(o1.getInspectionItem()) && specialItems.contains(o2.getInspectionItem())){
                    return Integer.MAX_VALUE;
                }
                Collator instance = Collator.getInstance(Locale.CHINA);
                return instance.compare(o1.getInspectionItem(),o2.getInspectionItem());
            }
            //检验子项排序
            if(StringUtils.isNotBlank(o1.getInspectionItemSubclass())&& StringUtils.isNotBlank(o2.getInspectionItemSubclass())){
                if(!Objects.equals(o1.getInspectionItemSubclass(),o2.getInspectionItemSubclass())){
                    Collator instance = Collator.getInstance(Locale.CHINA);
                    return instance.compare(o1.getInspectionItemSubclass(),o2.getInspectionItemSubclass());
                }
            }
            return 0;
        }).map(insProduct -> {
            String item = MyUtil.joinChars("@",insProduct.getInspectionItem(),insProduct.getInspectionItemEn());
            String itemSubClass = MyUtil.joinChars("@",insProduct.getInspectionItemSubclass(),insProduct.getInspectionItemSubclassEn());
            return MyUtil.joinChars(ITEM_SPLIT_CHAR,item,itemSubClass);
        }).distinct().collect(Collectors.toList());
        //根据样品id分组
        Map<Integer,List<InsProductFiberVO>> groupProducts = ribbonList.stream()
                .collect(Collectors.groupingBy(InsProductFiberVO::getInsSampleId));
        //sampleId顺序排序
        List<Integer> sortKeys = groupProducts.keySet().stream().sorted(Comparator.naturalOrder()).collect(Collectors.toList());
        //判断检验项目是否有父子关系
        int a = itemMap.stream().anyMatch(p -> p.split(ITEM_SPLIT_CHAR).length>0) ? 2 : 1;
        for (int c = 0; c < itemMap.size(); c++) {
            if (c % itemCount == 0) {
                List<RowRenderData> rows = new ArrayList<>();
                //表格的行数(样品数量+表头)
                int tableRow = sortKeys.size() + a + 1;
                for (int i = 0; i < tableRow; i++) {
                    RowRenderData rowRenderData = new RowRenderData();
                    RowStyle rowStyle = new RowStyle();
                    rowStyle.setHeight(40);
                    rowRenderData.setRowStyle(rowStyle);
                    List<CellRenderData> cells = new ArrayList<>();
                    //表格的列数
                    for (int j = 0; j < colCount; j++) {
                        CellRenderData cellRenderData = new CellRenderData();
                        CellStyle cellStyle = new CellStyle();
                        cellStyle.setVertAlign(XWPFTableCell.XWPFVertAlign.CENTER);
                        cellRenderData.setCellStyle(cellStyle);
                        List<ParagraphRenderData> paragraphRenderDataList = new ArrayList<>();
                        ParagraphRenderData paragraphRenderData = new ParagraphRenderData();
                        ParagraphStyle paragraphStyle = new ParagraphStyle();
                        paragraphStyle.setAlign(ParagraphAlignment.CENTER);
                        paragraphRenderData.setParagraphStyle(paragraphStyle);
                        List<RenderData> renderData = new ArrayList<>();
                        TextRenderData textRenderData = new TextRenderData();
                        Style style = new Style();
                        style.setFontFamily("宋体");
                        style.setColor("000000");
                        style.setFontSize(10);
                        textRenderData.setStyle(style);
                        //第一行
                        if(i==0){
                            if (j < 2) {
                                //第一列
                                textRenderData.setText("样品编号@Sample number∑45678");
                                renderData.add(textRenderData);
                                paragraphRenderData.setContents(renderData);
                                paragraphRenderDataList.add(paragraphRenderData);
                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                cells.add(cellRenderData);
                            } else{
                                //生成表头
                                if(itemMap.size()> (j - 2)){
                                    String inspectionItem = itemMap.get(j - 2).split(ITEM_SPLIT_CHAR)[0];
                                    textRenderData.setText( inspectionItem + "∑" + inspectionItem);
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }else{
                                    String inspectionItem = itemMap.get(itemMap.size()-1).split(ITEM_SPLIT_CHAR)[0];
                                    textRenderData.setText("∑" + inspectionItem);
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }
                            }
                        }
                        else if (a == 2 && i == 1) {
                            //有父子项目关系的第二行
                            if (j < 2) {
                                //第一列
                                textRenderData.setText("样品编号@Sample number∑45678");
                                renderData.add(textRenderData);
                                paragraphRenderData.setContents(renderData);
                                paragraphRenderDataList.add(paragraphRenderData);
                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                cells.add(cellRenderData);
                            } else if (j >1&& j<=3) {
                                String[] splits = itemMap.get(0).split(ITEM_SPLIT_CHAR);
                                if (splits.length<2 || "@".equals(splits[1])) {
                                    textRenderData.setText(splits[0] + "∑" + splits[0]);
                                } else {
                                    textRenderData.setText(splits[1]+"∑"+splits[0]+splits[1]);
                                }
                                renderData.add(textRenderData);
                                paragraphRenderData.setContents(renderData);
                                paragraphRenderDataList.add(paragraphRenderData);
                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                cells.add(cellRenderData);
                            }
                            else if (j>3&&j<=5) {
                                String[] splits = itemMap.get(1).split(ITEM_SPLIT_CHAR);
                                if (splits.length<2 || "@".equals(splits[1])) {
                                    textRenderData.setText(splits[0] + "∑" + splits[0]);
                                } else {
                                    textRenderData.setText(splits[1]+"∑"+splits[0]+splits[1]);
                                }
                                renderData.add(textRenderData);
                                paragraphRenderData.setContents(renderData);
                                paragraphRenderDataList.add(paragraphRenderData);
                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                cells.add(cellRenderData);
                            }
                            else if (j >5&&j<=7) {
                                String[] splits = itemMap.get(2).split(ITEM_SPLIT_CHAR);
                                if (splits.length<2 || "@".equals(splits[1])) {
                                    textRenderData.setText(splits[0] + "∑" + splits[0]);
                                } else {
                                    textRenderData.setText(splits[1]+"∑"+splits[0]+splits[1]);
                                }
                                renderData.add(textRenderData);
                                paragraphRenderData.setContents(renderData);
                                paragraphRenderDataList.add(paragraphRenderData);
                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                cells.add(cellRenderData);
                            }
                            else if (j >7&&j<=9) {
                                String[] splits = itemMap.get(3).split(ITEM_SPLIT_CHAR);
                                if (splits.length<2 || "@".equals(splits[1])) {
                                    textRenderData.setText(splits[0] + "∑" + splits[0]);
                                } else {
                                    textRenderData.setText(splits[1]+"∑"+splits[0]+splits[1]);
                                }
                                renderData.add(textRenderData);
                                paragraphRenderData.setContents(renderData);
                                paragraphRenderDataList.add(paragraphRenderData);
                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                cells.add(cellRenderData);
                            }
                            else{
                                String[] splits = itemMap.get(4).split(ITEM_SPLIT_CHAR);
                                if (splits.length<2 || "@".equals(splits[1])) {
                                    textRenderData.setText(splits[0] + "∑" + splits[0]);
                                } else {
                                    textRenderData.setText(splits[1]+"∑"+splits[0]+splits[1]);
                                }
                                renderData.add(textRenderData);
                                paragraphRenderData.setContents(renderData);
                                paragraphRenderDataList.add(paragraphRenderData);
                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                cells.add(cellRenderData);
                            }
                        }
                        else if (i == 2) {
                            //第三行
                            if (j < 2) {
                                //第一列
                                textRenderData.setText("样品编号@Sample number∑45678");
                                renderData.add(textRenderData);
                                paragraphRenderData.setContents(renderData);
                                paragraphRenderDataList.add(paragraphRenderData);
                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                cells.add(cellRenderData);
                            } else {
                                //项目信息
                                if((j - 2) %2==0){
                                    textRenderData.setText("A端");
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }else{
                                    textRenderData.setText("B端");
                                    renderData.add(textRenderData);
                                    paragraphRenderData.setContents(renderData);
                                    paragraphRenderDataList.add(paragraphRenderData);
                                    cellRenderData.setParagraphs(paragraphRenderDataList);
                                    cells.add(cellRenderData);
                                }
                            }
                        }
                        else{
                            //循环样品
                            Integer key = sortKeys.get(i-3);
                            //查询当前样品信息
                            InsSample insSample = insSampleMapper.selectById(key);
                            int index = Math.max(j - 2, 0);
                            String item;
                            if (j<=3) {
                                item = itemMap.get(0);
                            }
                            else if (j>3&&j<=5) {
                                item = itemMap.get(1);
                            }
                            else if (j >5&&j<=7) {
                                item =  itemMap.get(2);
                            }
                            else if (j >7&&j<=9) {
                                item =  itemMap.get(3);
                            } else{
                                item =  itemMap.get(4);
                            }
                            InsProductFiberVO insProduct = groupProducts.get(key).stream()
                                    .filter(p->{
                                        String insItem = MyUtil.joinChars("@",p.getInspectionItem(),p.getInspectionItemEn());
                                        String insItemSubClass = MyUtil.joinChars("@",p.getInspectionItemSubclass(),p.getInspectionItemSubclassEn());
                                        return item.equals(MyUtil.joinChars(ITEM_SPLIT_CHAR,insItem,insItemSubClass));
                                    })
                                    .findFirst().orElse(new InsProductFiberVO());
                            //填值
                            if (j < 2) {
                                //第一列
                                textRenderData.setText(insSample.getSampleCode()+"∑"+key);
                                renderData.add(textRenderData);
                                paragraphRenderData.setContents(renderData);
                                paragraphRenderDataList.add(paragraphRenderData);
                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                cells.add(cellRenderData);
                            } else {
                                //项目信息
                                if(index%2==0){
                                    textRenderData.setText(transformInsValue(insProduct.getInsValue()).get(0));
                                }else{
                                    textRenderData.setText(transformInsValue(insProduct.getInsValue()).get(1));
                                }
                                renderData.add(textRenderData);
                                paragraphRenderData.setContents(renderData);
                                paragraphRenderDataList.add(paragraphRenderData);
                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                cells.add(cellRenderData);
                            }
//                            if(itemMap.size()>j - 2) {
//                            }
                        }
                    }
                    rowRenderData.setCells(cells);
                    if (!rowRenderData.getCells().isEmpty()) {
                        rows.add(rowRenderData);
                    }
                }
                TableRenderData tableRenderData = new TableRenderData();
                tableRenderData.setRows(rows);
                int countSize = tableRenderData.getRows().get(0).getCells().size();
                for (RowRenderData row : tableRenderData.getRows()) {
                    if (row.getCells().size() != countSize) {
                        throw new ErrorException("光纤带报告附件表格列数不匹配");
                    }
                }
                TableStyle tableStyle = new TableStyle();
                tableStyle.setWidth(XWPFTable.DEFAULT_PERCENTAGE_WIDTH);
//                tableStyle.setColWidths(DEFAULT_COL_WIDTHS);
//                tableStyle.setWidth("10000");
                tableStyle.setAlign(TableRowAlign.CENTER);
                BorderStyle borderStyle = new BorderStyle();
                borderStyle.setColor("000000");
                borderStyle.setType(XWPFTable.XWPFBorderType.THICK);
                borderStyle.setSize(14);
                tableStyle.setLeftBorder(borderStyle);
                tableStyle.setTopBorder(borderStyle);
                tableStyle.setRightBorder(borderStyle);
                tableStyle.setBottomBorder(borderStyle);
                tableRenderData.setTableStyle(tableStyle);
                Map<String, Object> table = new HashMap<>();
                table.put("table6", tableRenderData);
                table.put("report", insReport);
                table.put("index6", index6.get());
                tables6.add(table);
                index6.getAndIncrement();
            }
        }
    }

}