java.sql.Date toDate = reportLocal.getDateTo();
resultVO.setDateRange(fromDate, toDate);
String where = localAdvancedSearch.getWhereClauseForReport(userId, search, "");
ReportBuilder reportbuilder = null;
switch (reportId) {
case ReportBuilder.CONTACTS1_REPORT_ID: // Contacts1
case ReportBuilder.CONTACTS2_REPORT_ID: // Contacts2
{
reportbuilder = new Contacts1ReportBuilder(reportId, fromDate, toDate, this.dataSource, where);
break;
}
case ReportBuilder.HR1_REPORT_ID: // Hr1
{
reportbuilder = new Hr1ReportBuilder(fromDate, toDate, this.dataSource, where);
break;
}
case ReportBuilder.HR2_REPORT_ID: // Hr2
{
reportbuilder = new Hr2ReportBuilder(fromDate, toDate, this.dataSource, where);
break;
}
case ReportBuilder.HR3_REPORT_ID: // Hr3
case ReportBuilder.HR4_REPORT_ID: // Hr4
{
where = localAdvancedSearch.getWhereClauseForReport(userId, search, "tsl");
reportbuilder = new Hr3ReportBuilder(reportId, fromDate, toDate, this.dataSource, where);
break;
}
case ReportBuilder.ACTIVITIES1_REPORT_ID: // Activities1
case ReportBuilder.ACTIVITIES2_REPORT_ID: // Activities2
{
where = localAdvancedSearch.getWhereClauseForReport(userId, search, "act");
reportbuilder = new Activities1ReportBuilder(reportId, fromDate, toDate, this.dataSource, where);
break;
}
case ReportBuilder.SALES1_REPORT_ID: // Sales1
case ReportBuilder.SALES2_REPORT_ID: // Sales2
{
where = localAdvancedSearch.getWhereClauseForReport(userId, search, "op");
reportbuilder = new Sales1ReportBuilder(reportId, fromDate, toDate, this.dataSource, where);
break;
}
case ReportBuilder.SALES3_REPORT_ID: // Sales3
{
where = localAdvancedSearch.getWhereClauseForReport(userId, search, "pi");
reportbuilder = new Sales3ReportBuilder(reportId, fromDate, toDate, this.dataSource, where);
break;
}
case ReportBuilder.SALES4_REPORT_ID: // Sales4
{
// where =
// localAdvancedSearch.getWhereClauseByReportIdWithAlias(userId,
// reportId, reportLocal.getModuleId(),"cvord");
reportbuilder = new Sales4ReportBuilder(reportId, fromDate, toDate, this.dataSource, where);
break;
}
case ReportBuilder.PROJECTS1_REPORT_ID: // Project1
{
where = localAdvancedSearch.getWhereClauseForReport(userId, search, "task");
reportbuilder = new Project1ReportBuilder(reportId, fromDate, toDate, this.dataSource, where);
break;
}
case ReportBuilder.SUPPORT1_REPORT_ID: // Support1
case ReportBuilder.SUPPORT2_REPORT_ID: // Support2
case ReportBuilder.SUPPORT3_REPORT_ID: // Support3
{
where = localAdvancedSearch.getWhereClauseForReport(userId, search, "tick");
reportbuilder = new Support1ReportBuilder(reportId, fromDate, toDate, this.dataSource, where);
break;
}
case ReportBuilder.INDIVIDUAL_NOTE_ID:
{
reportbuilder = new IndividualNoteStandardReport(fromDate, toDate, this.dataSource, where);
}
}
if (reportbuilder != null) {
resultVO.setResults(reportbuilder.runReport());
reportbuilder.closeConnection();
}
// this.debugStandardReport(resultVO);
} catch (Exception e) {