1
package org.hisp.dhis.reporttable.statement;
4
* Copyright (c) 2004-2007, University of Oslo
7
* Redistribution and use in source and binary forms, with or without
8
* modification, are permitted provided that the following conditions are met:
9
* * Redistributions of source code must retain the above copyright notice, this
10
* list of conditions and the following disclaimer.
11
* * Redistributions in binary form must reproduce the above copyright notice,
12
* this list of conditions and the following disclaimer in the documentation
13
* and/or other materials provided with the distribution.
14
* * Neither the name of the HISP project nor the names of its contributors may
15
* be used to endorse or promote products derived from this software without
16
* specific prior written permission.
18
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
19
* ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
20
* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
21
* DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
22
* ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
23
* (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
24
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
25
* ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
26
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
27
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
30
import java.util.Iterator;
32
import org.hisp.dhis.reporttable.ReportTable;
35
* @author Lars Helge Overland
38
public class GetReportTableDataStatement
39
extends ReportTableStatement
41
// -------------------------------------------------------------------------
43
// -------------------------------------------------------------------------
45
public GetReportTableDataStatement( ReportTable reportTable )
50
// -------------------------------------------------------------------------
51
// ReportTableStatement implementation
52
// -------------------------------------------------------------------------
55
protected void init( ReportTable reportTable )
57
StringBuffer buffer = new StringBuffer();
59
buffer.append( "SELECT value, " );
61
Iterator<String> selectColumns = reportTable.getSelectColumns().iterator();
63
while( selectColumns.hasNext() )
65
buffer.append( selectColumns.next() + ( selectColumns.hasNext() ? SEPARATOR : SPACE ) );
68
buffer.append( "FROM " + getDataTable( reportTable.getMode() ) + SPACE );
70
Iterator<String> indexColumns = reportTable.getIndexColumns().iterator();
72
String indexColumn = indexColumns.next();
74
buffer.append( "WHERE " + indexColumn + "='" + QUERY_PARAM_ID + indexColumn + "' " );
76
while ( indexColumns.hasNext() )
78
indexColumn = indexColumns.next();
80
buffer.append( "AND " + indexColumn + "='" + QUERY_PARAM_ID + indexColumn + "' " );
83
statement = buffer.toString();
86
// -------------------------------------------------------------------------
88
// -------------------------------------------------------------------------
90
private String getDataTable( String mode )
92
if ( mode == null || mode.equals( ReportTable.MODE_INDICATORS ) )
94
return "aggregatedindicatorvalue";
96
else if ( mode.equals( ReportTable.MODE_DATAELEMENTS ) )
98
return "aggregateddatavalue";
100
else if ( mode.equals( ReportTable.MODE_DATASETS ) )
102
return "aggregateddatasetcompleteness";