@Override public String toString() { return getId(); } }
public String getName() { return getId(); } @Override
@Override public String toString() { return getId(); } }
@Override public String toString() { return getId(); } SourceDocumentState(String aId)
public String getName() { return getId(); }
public String getName() { return getId(); }
"SELECT new " + SourceDocumentStateStats.class.getName() + "(" + "COUNT(*), " + "SUM(CASE WHEN state = '" + NEW.getId() + "' THEN 1 ELSE 0 END), " + "SUM(CASE WHEN (state = '" + ANNOTATION_IN_PROGRESS.getId() + "' OR state is NULL) THEN 1 ELSE 0 END), " + "SUM(CASE WHEN state = '" + ANNOTATION_FINISHED.getId() + "' THEN 1 ELSE 0 END), " + "SUM(CASE WHEN state = '" + CURATION_IN_PROGRESS.getId() + "' THEN 1 ELSE 0 END), " + "SUM(CASE WHEN state = '" + CURATION_FINISHED.getId() + "' THEN 1 ELSE 0 END)) " + "FROM SourceDocument " + "WHERE project = :project";
"SELECT new " + SourceDocumentStateStats.class.getName() + "(" + "COUNT(*), " + "SUM(CASE WHEN state = '" + NEW.getId() + "' THEN 1 ELSE 0 END), " + "SUM(CASE WHEN (state = '" + ANNOTATION_IN_PROGRESS.getId() + "' OR state is NULL) THEN 1 ELSE 0 END), " + "SUM(CASE WHEN state = '" + ANNOTATION_FINISHED.getId() + "' THEN 1 ELSE 0 END), " + "SUM(CASE WHEN state = '" + CURATION_IN_PROGRESS.getId() + "' THEN 1 ELSE 0 END), " + "SUM(CASE WHEN state = '" + CURATION_FINISHED.getId() + "' THEN 1 ELSE 0 END)) " + "FROM SourceDocument " + "WHERE project = :project";