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 package ar.com.fdvs.dj.test.groups;
31
32 import java.awt.Color;
33
34 import net.sf.jasperreports.view.JasperViewer;
35 import ar.com.fdvs.dj.domain.AutoText;
36 import ar.com.fdvs.dj.domain.DJCalculation;
37 import ar.com.fdvs.dj.domain.DynamicReport;
38 import ar.com.fdvs.dj.domain.ImageBanner;
39 import ar.com.fdvs.dj.domain.Style;
40 import ar.com.fdvs.dj.domain.builders.ColumnBuilder;
41 import ar.com.fdvs.dj.domain.builders.DynamicReportBuilder;
42 import ar.com.fdvs.dj.domain.builders.GroupBuilder;
43 import ar.com.fdvs.dj.domain.constants.Border;
44 import ar.com.fdvs.dj.domain.constants.Font;
45 import ar.com.fdvs.dj.domain.constants.GroupLayout;
46 import ar.com.fdvs.dj.domain.constants.HorizontalAlign;
47 import ar.com.fdvs.dj.domain.constants.Transparency;
48 import ar.com.fdvs.dj.domain.constants.VerticalAlign;
49 import ar.com.fdvs.dj.domain.entities.DJGroup;
50 import ar.com.fdvs.dj.domain.entities.columns.AbstractColumn;
51 import ar.com.fdvs.dj.domain.entities.columns.PropertyColumn;
52 import ar.com.fdvs.dj.test.BaseDjReportTest;
53
54 public class GroupsReportTestG2T1 extends BaseDjReportTest {
55
56 public DynamicReport buildReport() throws Exception {
57
58 Style detailStyle = new Style();
59 detailStyle.setVerticalAlign(VerticalAlign.TOP);
60
61 Style groupTitleStyle = new Style();
62 groupTitleStyle.setFont(Font.ARIAL_BIG);
63
64 Style col2Style = new Style();
65 col2Style.setFont(Font.ARIAL_BIG_BOLD);
66 col2Style.setBorderBottom(Border.THIN);
67 col2Style.setVerticalAlign(VerticalAlign.TOP);
68
69 Style headerStyle = new Style();
70 headerStyle.setFont(Font.ARIAL_MEDIUM_BOLD);
71 headerStyle.setBackgroundColor(Color.gray);
72 headerStyle.setTextColor(Color.white);
73 headerStyle.setHorizontalAlign(HorizontalAlign.CENTER);
74 headerStyle.setVerticalAlign(VerticalAlign.MIDDLE);
75 headerStyle.setTransparency(Transparency.OPAQUE);
76
77 Style g1VariablesStyle = new Style();
78 g1VariablesStyle.setFont(Font.ARIAL_MEDIUM_BOLD);
79 g1VariablesStyle.setBorderTop(Border.THIN);
80 g1VariablesStyle.setHorizontalAlign(HorizontalAlign.RIGHT);
81 g1VariablesStyle.setVerticalAlign(VerticalAlign.MIDDLE);
82 g1VariablesStyle.setTextColor(new Color(50,50,150));
83
84 Style g2VariablesStyle = new Style();
85 g2VariablesStyle.setFont(Font.ARIAL_MEDIUM_BOLD);
86 g2VariablesStyle.setTextColor(new Color(150,150,150));
87 g2VariablesStyle.setHorizontalAlign(HorizontalAlign.RIGHT);
88 g2VariablesStyle.setVerticalAlign(VerticalAlign.MIDDLE);
89
90
91 Style titleStyle = new Style();
92 titleStyle.setFont(new Font(18, Font._FONT_VERDANA, true));
93 Style importeStyle = new Style();
94 importeStyle.setHorizontalAlign(HorizontalAlign.RIGHT);
95 Style oddRowStyle = new Style();
96 oddRowStyle.setBorder(Border.NO_BORDER);
97 oddRowStyle.setBackgroundColor(Color.LIGHT_GRAY);
98 oddRowStyle.setTransparency(Transparency.OPAQUE);
99
100 DynamicReportBuilder drb = new DynamicReportBuilder();
101 Integer margin = new Integer(20);
102 drb
103 .setTitleStyle(titleStyle)
104 .setTitle("November 2006 sales report")
105 .setSubtitle("The items in this report correspond "
106 +"to the main products: DVDs, Books, Foods and Magazines")
107 .setDetailHeight(new Integer(15)).setLeftMargin(margin)
108 .setRightMargin(margin).setTopMargin(margin).setBottomMargin(margin)
109 .setPrintBackgroundOnOddRows(false)
110 .setGrandTotalLegend("Grand Total")
111 .setGrandTotalLegendStyle(g2VariablesStyle)
112 .setDefaultStyles(titleStyle, null, headerStyle, detailStyle)
113 .setPrintColumnNames(false)
114 .addImageBanner(System.getProperty("user.dir") +"/target/test-classes/images/logo_fdv_solutions_60.jpg", new Integer(100), new Integer(30), ImageBanner.ALIGN_RIGHT)
115 .setOddRowBackgroundStyle(oddRowStyle);
116
117
118 AbstractColumn columnState = ColumnBuilder.getNew()
119 .setColumnProperty("state", String.class.getName())
120 .setTitle("State:").setWidth(new Integer(50))
121 .setStyle(titleStyle).setHeaderStyle(groupTitleStyle)
122 .build();
123
124 AbstractColumn columnBranch = ColumnBuilder.getNew()
125 .setColumnProperty("branch", String.class.getName())
126 .setTitle("Branch").setWidth(new Integer(85))
127 .setStyle(col2Style).setHeaderStyle(col2Style)
128 .build();
129
130 AbstractColumn columnaProductLine = ColumnBuilder.getNew()
131 .setColumnProperty("productLine", String.class.getName())
132 .setTitle("Product Line").setWidth(new Integer(85))
133 .setStyle(detailStyle).setHeaderStyle(headerStyle)
134 .build();
135
136 AbstractColumn columnaItem = ColumnBuilder.getNew()
137 .setColumnProperty("item", String.class.getName())
138 .setTitle("Item").setWidth(new Integer(85))
139 .setStyle(detailStyle).setHeaderStyle(headerStyle)
140 .build();
141
142 AbstractColumn columnCode = ColumnBuilder.getNew()
143 .setColumnProperty("id", Long.class.getName())
144 .setTitle("ID").setWidth(new Integer(40))
145 .setStyle(importeStyle).setHeaderStyle(headerStyle)
146 .build();
147
148 AbstractColumn columnaQuantity = ColumnBuilder.getNew()
149 .setColumnProperty("quantity", Long.class.getName())
150 .setTitle("Quantity").setWidth(new Integer(80))
151 .setStyle(importeStyle).setHeaderStyle(headerStyle)
152 .build();
153
154 AbstractColumn columnAmount = ColumnBuilder.getNew()
155 .setColumnProperty("amount", Float.class.getName())
156 .setTitle("Amount").setWidth(new Integer(90)).setPattern("$ 0.00")
157 .setStyle(importeStyle).setHeaderStyle(headerStyle)
158 .build();
159
160 GroupBuilder gb1 = new GroupBuilder();
161
162
163 DJGroup g1 = gb1.setCriteriaColumn((PropertyColumn) columnState)
164 .addFooterVariable(columnAmount,DJCalculation.SUM,g1VariablesStyle)
165 .addFooterVariable(columnaQuantity,DJCalculation.SUM,g1VariablesStyle)
166 .setGroupLayout(GroupLayout.VALUE_IN_HEADER_WITH_HEADERS)
167 .build();
168
169 GroupBuilder gb2 = new GroupBuilder();
170 DJGroup g2 = gb2.setCriteriaColumn((PropertyColumn) columnBranch)
171 .addFooterVariable(columnAmount,DJCalculation.SUM,g2VariablesStyle)
172 .addFooterVariable(columnaQuantity, DJCalculation.SUM,g2VariablesStyle)
173 .setGroupLayout(GroupLayout.VALUE_IN_HEADER)
174 .build();
175
176 drb.addColumn(columnState);
177 drb.addColumn(columnBranch);
178 drb.addColumn(columnaProductLine);
179 drb.addColumn(columnaItem);
180 drb.addColumn(columnCode);
181 drb.addColumn(columnaQuantity);
182 drb.addColumn(columnAmount);
183
184 drb.addGroup(g1);
185 drb.addGroup(g2);
186
187 drb.setUseFullPageWidth(true);
188 drb.addAutoText(AutoText.AUTOTEXT_PAGE_X_SLASH_Y, AutoText.POSITION_FOOTER, AutoText.ALIGNMENT_RIGHT);
189
190 DynamicReport dr = drb.build();
191 return dr;
192 }
193
194 public static void main(String[] args) throws Exception {
195 GroupsReportTestG2T1 test = new GroupsReportTestG2T1();
196 test.testReport();
197 JasperViewer.viewReport(test.jp);
198 }
199
200 }