@Override public String allowDeleteProgramStage( ProgramStage programStage ) { String sql = "SELECT COUNT(*) " + "FROM trackedentitydatavalue pdv INNER JOIN programstageinstance psi " + "ON pdv.programstageinstanceid=psi.programstageinstanceid " + "WHERE psi.programstageid=" + programStage.getId(); return jdbcTemplate.queryForObject( sql, Integer.class ) == 0 ? null : ERROR; }
@Override public String allowDeleteProgramStage( ProgramStage programStage ) { String sql = "SELECT COUNT(*) FROM programstageinstance WHERE programstageid=" + programStage.getId(); return jdbcTemplate.queryForObject( sql, Integer.class ) == 0 ? null : ERROR; }
@Override public int saveProgramStage( ProgramStage programStage ) { programStageStore.save( programStage ); return programStage.getId(); }
private void setProgramStage_DocumentContent( Document document, PdfWriter writer, String programStageUid ) throws Exception { ProgramStage programStage = programStageService.getProgramStage( programStageUid ); if ( programStage == null ) { throw new RuntimeException( "Error - ProgramStage not found for UID " + programStageUid ); } else { // Get Rectangle with TextBox Width to be used Rectangle rectangle = new Rectangle( 0, 0, TEXTBOXWIDTH, PdfDataEntryFormUtil.CONTENT_HEIGHT_DEFAULT ); // Create Main Layout table and set the properties PdfPTable mainTable = getProgramStageMainTable(); // Generate Period List for ProgramStage List<Period> periods = getProgramStagePeriodList(); // Add Org Unit, Period, Hidden ProgramStageID Field insertTable_OrgAndPeriod( mainTable, writer, periods ); insertTable_TextRow( writer, mainTable, TEXT_BLANK ); // Add ProgramStage Field - programStage.getId(); insertTable_HiddenValue( mainTable, rectangle, writer, PdfDataEntryFormUtil.LABELCODE_PROGRAMSTAGEIDTEXTBOX, String.valueOf( programStage.getId() ) ); // Add ProgramStage Content to PDF - [The Main Section] insertTable_ProgramStage( mainTable, writer, programStage ); // Add the mainTable to document document.add( mainTable ); } }
sql += hlp.whereAnd() + " ps.programstageid = " + params.getProgramStage().getId() + " ";
sql += hlp.whereAnd() + " ps.programstageid = " + params.getProgramStage().getId() + " ";