package org.akaza.openclinica.dao.managestudy;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
public class ListDiscNotesForCRFSort implements CriteriaCommand {
List<Sort> sorts = new ArrayList<Sort>();
HashMap<String, String> columnMapping = new HashMap<String, String>();
public ListDiscNotesForCRFSort() {
columnMapping.put("studySubject.label", "ss.label");
columnMapping.put("studySubject.status", "ss.status_id");
columnMapping.put("studySubject.oid", "ss.oc_oid");
columnMapping.put("studySubject.secondaryLabel", "ss.secondary_label");
columnMapping.put("subject.charGender", "s.gender");
}
public void addSort(String property, String order) {
sorts.add(new Sort(property, order));
}
public List<Sort> getSorts() {
return sorts;
}
public String execute(String criteria) {
String theCriteria = "";
for (Sort sort : sorts) {
if (theCriteria.length() == 0) {
theCriteria += buildCriteriaInitial(criteria, sort.getProperty(), sort.getOrder());
} else {
theCriteria += buildCriteria(criteria, sort.getProperty(), sort.getOrder());
}
}
return theCriteria;
}
private String buildCriteriaInitial(String criteria, String property, String order) {
if (order.equals(Sort.ASC)) {
criteria = criteria + " order by " + columnMapping.get(property) + " asc ";
} else if (order.equals(Sort.DESC)) {
criteria = criteria + " order by " + columnMapping.get(property) + " desc ";
}
return criteria;
}
private String buildCriteria(String criteria, String property, String order) {
if (order.equals(Sort.ASC)) {
criteria = criteria + " , " + columnMapping.get(property) + " asc ";
} else if (order.equals(Sort.DESC)) {
criteria = criteria + " , " + columnMapping.get(property) + " desc ";
}
return criteria;
}
private static class Sort {
public final static String ASC = "asc";
public final static String DESC = "desc";
private final String property;
private final String order;
public Sort(String property, String order) {
this.property = property;
this.order = order;
}
public String getProperty() {
return property;
}
public String getOrder() {
return order;
}
}
}