private void populateReportsGrid(ReportTemplateLiteVoCollection templates) { if (templates == null || (templates != null && templates.size() == 0)) return; ReportListVoCollection coll = new ReportListVoCollection(); for (int i = 0; i < templates.size(); i++) { ReportTemplateLiteVo rep = templates.get(i); if (rep != null && rep.getReportIsNotNull()) { coll.add(domain.getReport(rep.getReport())); } } populateReports(coll); }
private void populateReportsGrid() { ReportListVoCollection reportColl = domain.listReports(); ReportsCategoryListVoCollection voReportsCategoryColl = domain.listCategories(); populateCategoriesGrid(voReportsCategoryColl); populateReports(reportColl); }
private void populateReports(ReportListVoCollection reportColl) { if (reportColl == null) return; for (int i = 0; i < reportColl.size(); i++) { ReportListVo voReportList = reportColl.get(i); DynamicGridRow row = getReportRow(form.dyngrdReports().getRows(), voReportList); addReport(row, voReportList); } }
@SuppressWarnings("unchecked") public ReportListVoCollection listReports() { StringBuffer hql = new StringBuffer(); hql.append("from ReportBo as r1_1 left join r1_1.templates as t1_1"); hql.append(" where"); hql.append(" (r1_1.isActive =" + Boolean.TRUE + " and t1_1.isActive =" + Boolean.TRUE+" )"); //hql.append(" and r1_1.isRIE is null"); DomainFactory factory = getDomainFactory(); List list = factory.find(hql.toString()); return ReportListVoAssembler.createReportListVoCollectionFromReportBo(list).sort(); }
/** * List all the Reports that are active */ public ims.admin.vo.ReportListVoCollection listReports() { ReportRunner impl = (ReportRunner)getDomainImpl(ReportRunnerImpl.class); return impl.listReports(); }
private void populateReports(ReportListVoCollection coll) { if (coll == null) return; for (int i = 0; i < coll.size(); i++) { ReportListVo voReportList = coll.get(i); DynamicGridRow row = getReportRow(form.dyngrdReports().getRows(), voReportList); addReport(row, voReportList); } }
private void searchReport() { form.dyngrdReports().getRows().clear(); String reportName = form.ctnFindReport().txtReport().getValue(); String templateName = form.ctnFindReport().txtTemplate().getValue(); ReportsCategoryLiteVo cat = form.ctnFindReport().qmbCategory().getValue(); if (reportName == null || reportName.length() == 0) { reportName = "%"; } else { if(!reportName.startsWith("%")) reportName = "%" + reportName; if(!reportName.endsWith("%")) reportName = reportName + "%"; } if (templateName == null || templateName.length() == 0) { templateName = "%"; } else { if(!templateName.startsWith("%")) templateName = "%" + templateName; if(!templateName.endsWith("%")) templateName = templateName + "%"; } ReportListVoCollection reportColl = domain.searchReports(reportName, templateName, cat); //WDEV-12505 if(reportColl == null || reportColl.size() == 0) { engine.showMessage("No results matching your search criteria were found!"); return; } ReportsCategoryListVoCollection voReportsCategoryColl = domain.searchCategories(reportName, templateName, cat); populateCategoriesGrid(voReportsCategoryColl); populateReports(reportColl); if(form.dyngrdReports().getRows().size() == 1) form.dyngrdReports().getRows().get(0).setExpanded(true, true); }
private void searchReport() { //clearBackgroundSelection(form.dyngrdReports().getRows()); form.dyngrdReports().getRows().clear(); form.htmDownload().setHTML(""); String reportName = form.ctnFindReport().txtReport().getValue(); String templateName = form.ctnFindReport().txtTemplate().getValue(); ReportsCategoryLiteVo cat = form.ctnFindReport().qmbCategory().getValue(); if (reportName == null || reportName.length() == 0) { reportName = "%"; } else { if(!reportName.startsWith("%")) reportName = "%" + reportName; if(!reportName.endsWith("%")) reportName = reportName + "%"; } if (templateName == null || templateName.length() == 0) { templateName = "%"; } else { if(!templateName.startsWith("%")) templateName = "%" + templateName; if(!templateName.endsWith("%")) templateName = templateName + "%"; } ReportListVoCollection reportColl = domain.searchReports(reportName, templateName, cat); ReportsCategoryListVoCollection voReportsCategoryColl = domain.searchCategories(reportName, templateName, cat); populateCategoriesGrid(voReportsCategoryColl); populateReports(reportColl); if(form.dyngrdReports().getRows().size() == 1) form.dyngrdReports().getRows().get(0).setExpanded(true, true); enablePreviewButtons(); if(reportColl == null || reportColl.size() == 0) { engine.showMessage("No results matching your search criteria were found !"); return; } }
@SuppressWarnings("unchecked") public ims.admin.vo.ReportListVoCollection searchReports(String reportName, String templateName, ReportsCategoryRefVo categoryRef) { StringBuffer hql = new StringBuffer(); StringBuffer cond = new StringBuffer(); ArrayList markers = new ArrayList(); ArrayList values = new ArrayList(); String andStr = " "; hql.append("select rep from ReportsCategory as cat right join cat.reports as rep left join rep.templates as tpl "); cond.append(andStr + "rep.isActive = :isActive"); markers.add("isActive"); values.add(Boolean.TRUE); andStr = " and "; cond.append(andStr + "UPPER(rep.reportName) like UPPER(:reportName)"); markers.add("reportName"); values.add(reportName); andStr = " and "; cond.append(andStr + "tpl.isActive = :isActive"); markers.add("isActive"); values.add(Boolean.TRUE); andStr = " and "; cond.append(andStr + "UPPER(tpl.name) like UPPER(:templateName)"); markers.add("templateName"); values.add(templateName); andStr = " and "; if(categoryRef != null && categoryRef.getID_ReportsCategoryIsNotNull()) { cond.append(andStr + "cat.id = :catId"); markers.add("catId"); values.add(categoryRef.getID_ReportsCategory()); andStr = " and "; } if (andStr.equals(" and ")) { hql.append(" where "); } hql.append(cond.toString()); DomainFactory factory = getDomainFactory(); List list = factory.find(hql.toString(), markers, values); return ReportListVoAssembler.createReportListVoCollectionFromReportBo(list).sort(); }
public ReportListVoCollection searchReports(String reportName, String templateName, ReportsCategoryRefVo categoryRef) { ReportRunner impl = (ReportRunner)getDomainImpl(ReportRunnerImpl.class); return impl.searchReports(reportName, templateName, categoryRef); }