package module.projects.presentationTier.vaadin.reportType.movementReportType;
import java.util.Map;
import module.projects.presentationTier.vaadin.reportType.MovementsDetailsReportType;
import com.vaadin.ui.Table;
public class CabimentosDetailsReportType extends MovementsDetailsReportType {
public CabimentosDetailsReportType(Map<String, String> args) {
super(args);
//setTableSummaryReport(new TableSummaryComponent(getReportViewer().getTable(), getLabel(), "FILHO_VALOR"));
}
@Override
public String getQuery() {
// TODO Auto-generated method stub
return "select distinct \"FILHO_IDMOV\", \"FILHO_IDRUB\", \"FILHO_TIPO\", TO_CHAR(\"FILHO_DATA\",'YYYY-MM-DD') as DATA, \"FILHO_DESCRICAO\", \"FILHO_VALOR\", \"FILHO_IVA\" from \"V_MOV_CABIMENTOS\" where \"PAI_IDPROJ\"='"
+ getProjectCode() + "' AND \"PAI_IDMOV\"='" + getParentId() + "' order by DATA";
}
@Override
public String getLabel() {
return getMessage("financialprojectsreports.reportTitle.cabimentosDetailsListing");
}
@Override
public void setColumnNames(Table table) {
table.setColumnHeader("FILHO_IDMOV", getMessage("financialprojectsreports.column.id"));
table.setColumnHeader("FILHO_IDRUB", getMessage("financialprojectsreports.column.rubric"));
table.setColumnHeader("FILHO_TIPO", getMessage("financialprojectsreports.column.type"));
table.setColumnHeader("DATA", getMessage("financialprojectsreports.column.date"));
table.setColumnHeader("FILHO_DESCRICAO", getMessage("financialprojectsreports.column.description"));
table.setColumnHeader("FILHO_VALOR", getMessage("financialprojectsreports.column.value"));
table.setColumnHeader("FILHO_IVA", getMessage("financialprojectsreports.column.iva"));
}
}