1 /**
2 * Licensed under the Artistic License; you may not use this file
3 * except in compliance with the License.
4 * You may obtain a copy of the License at
5 *
6 * http://displaytag.sourceforge.net/license.html
7 *
8 * THIS PACKAGE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR
9 * IMPLIED WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED
10 * WARRANTIES OF MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE.
11 */
12
13 package org.displaytag.sample.decorators;
14
15 import org.apache.poi.hssf.usermodel.HSSFCell;
16 import org.apache.poi.hssf.usermodel.HSSFRow;
17 import org.apache.poi.hssf.usermodel.HSSFSheet;
18 import org.displaytag.decorator.hssf.DecoratesHssf;
19
20
21 /**
22 * Same idea implemented in HssfTableWriter applied to decorators.
23 * @see org.displaytag.render.HssfTableWriter
24 * @author Jorge L. Barroso
25 * @version $Revision$ ($Author$)
26 */
27 public class HssfTotalWrapper extends TotalWrapperTemplate implements DecoratesHssf
28 {
29
30 private HSSFSheet sheet;
31
32 private HSSFCell currentCell;
33
34 private HSSFRow currentRow;
35
36 private int colNum;
37
38 protected void writeCityTotal(String city, double total)
39 {
40 this.writeTotal(city, total);
41 }
42
43 private void writeTotal(String value, double total)
44 {
45 if (this.assertRequiredState())
46 {
47 int rowNum = this.sheet.getLastRowNum();
48 this.currentRow = this.sheet.createRow(++rowNum);
49 this.colNum = 0;
50 prepareCell();
51 prepareCell();
52 prepareCell();
53 this.currentCell.setCellValue("------------");
54
55 this.currentRow = this.sheet.createRow(++rowNum);
56 this.colNum = 0;
57 prepareCell();
58 prepareCell();
59 this.currentCell.setCellValue(value + " Total:");
60 prepareCell();
61 this.currentCell.setCellValue(total);
62 }
63 }
64
65 private void prepareCell()
66 {
67 this.currentCell = this.currentRow.createCell((short) this.colNum++);
68 this.currentCell.setEncoding(HSSFCell.ENCODING_UTF_16);
69 }
70
71 protected void writeGrandTotal(double total)
72 {
73 this.writeTotal("Grand", total);
74 }
75
76 public void setSheet(HSSFSheet sheet)
77 {
78 this.sheet = sheet;
79 }
80
81 /**
82 * Asserts that the sheet property needed have been set by the client.
83 * @return true if the required properties are not null; false otherwise.
84 */
85 private boolean assertRequiredState()
86 {
87 return this.sheet != null;
88 }
89 }
Save This Page