Reporter/src/main/java/Reports/OktsCat.java at master · AlbertoJava/Reporter · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
package Reports;

import Reports.AbstratReports.AbstractExcelReport;
import Utilz.SqlExecutor;
import Utilz.SqlProperties;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.VerticalAlignment;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class OktsCat extends AbstractExcelReport {
    Table t = null;

    public OktsCat(SqlProperties props, SqlExecutor sqlExecutor) {
        super(props, sqlExecutor);
    }

    @Override
    public boolean createReport(ResultSet result) {
        boolean flag = false;
        t = new Table(result);
        t.transposeTable();
        // t.printMatrix();
        List<String> headerRowXLS = new ArrayList();
        headerRowXLS.add("??????????");
        headerRowXLS.add("??????? ??????");
        headerRowXLS.add("?????????? ??????");
        headerRowXLS.add("? ?????? 2018 ????");
        headerRowXLS.add("? ?????? 2017 ????");


        List<String> headerColumnXLS = new ArrayList();
        headerColumnXLS.add("?????????? ?? (??.)? ???. ????????? ?? ??????????? ???????? ?????????? ?????????, ?? ???:");
        headerColumnXLS.add("-? ???????? ? ???????? ????????? ?? ??(??.)");
        headerColumnXLS.add("-?? ??????? (??.)");
        headerColumnXLS.add("-???????? ?? ???????? (??.)");
        headerColumnXLS.add("????? ?????????? ??? (??.) ??? ????????? ?????????? ?????????:");
        headerColumnXLS.add("- ? ??????? ?????????? (??.)");
        headerColumnXLS.add("- ? ??????? ?????????? (??.)");
        headerColumnXLS.add("????? ?????????????  ?????????? ????????  ?? ??????????? ???????? ????????? ? ?? (???. ???.)");
        headerColumnXLS.add("????? ?????????? ????????, ?????????? ???????? (???. ???.), ? ?.?.:");
        headerColumnXLS.add("- ?? ??????????? ???????? ??????? (???. ???.)");
        headerColumnXLS.add("- ?? ??????????? ???.  ???????? ? ????????????  ????? (???. ???.)");

        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet worksheet = workbook.createSheet("WeekReport");

        worksheet.setColumnWidth(0, 40 * 256);
        worksheet.setColumnWidth(1, 30 * 256);
        worksheet.setColumnWidth(2, 30 * 256);
        worksheet.setColumnWidth(3, 20 * 256);
        worksheet.setColumnWidth(4, 20 * 256);


        HSSFCellStyle style = workbook.createCellStyle();

        style.setWrapText(true);
        style.setAlignment(HorizontalAlignment.CENTER);
        style.setVerticalAlignment(VerticalAlignment.CENTER);
        HSSFFont fontHeader = workbook.createFont();
        fontHeader.setFontName("Times New Roman");
        fontHeader.setFontHeightInPoints((short) 12);
        fontHeader.setBold(true);
        style.setFont(fontHeader);

        createHeader(headerRowXLS, worksheet, style, 0, 0);
        createVerticalHeader(headerColumnXLS, style, worksheet, 1, 0);
        String[][] m = new String[t.getMatrix().length - 1][t.getMatrix()[0].length];
        for (int i = 1; i < t.getMatrix().length; i++) {
            for (int j = 0; j < t.getMatrix()[0].length; j++) {
                m[i - 1][j] = t.getMatrix()[i][j];
            }
        }
        insertData(m/*t.getMatrix()*/, worksheet, 1, 1);
        flag = createFile(workbook);

        return flag;


    }


}