/**
* OLAT - Online Learning and Training<br>
* http://www.olat.org
* <p>
* Licensed under the Apache License, Version 2.0 (the "License"); <br>
* you may not use this file except in compliance with the License.<br>
* You may obtain a copy of the License at
* <p>
* http://www.apache.org/licenses/LICENSE-2.0
* <p>
* Unless required by applicable law or agreed to in writing,<br>
* software distributed under the License is distributed on an "AS IS" BASIS, <br>
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. <br>
* See the License for the specific language governing permissions and <br>
* limitations under the License.
* <p>
* Copyright (c) since 2004 at Multimedia- & E-Learning Services (MELS),<br>
* University of Zurich, Switzerland.
* <hr>
* <a href="http://www.openolat.org">
* OpenOLAT - Online Learning and Training</a><br>
* This file has been modified by the OpenOLAT community. Changes are licensed
* under the Apache 2.0 license as the original file.
*/
package org.olat.course.assessment;
import java.io.File;
import java.util.List;
import java.util.Map;
import org.olat.core.gui.translator.Translator;
import org.olat.core.id.Identity;
import org.olat.core.util.FileUtils;
import org.olat.core.util.StringHelper;
import org.olat.core.util.Util;
import org.olat.core.util.i18n.I18nModule;
import org.olat.course.nodes.CourseNode;
import org.olat.user.UserManager;
import org.olat.user.propertyhandlers.UserPropertyHandler;
/**
*
*
* @author Christian Guretzki
*/
public class EfficiencyStatementArchiver {
private static final String DELIMITER = "\t";
private static final String EOL = "\n";
private static final String EFFICIENCY_ARCHIVE_FILE = "efficiencyArchive.xls";
private static EfficiencyStatementArchiver instance = new EfficiencyStatementArchiver();
private Translator translator;
private List<UserPropertyHandler> userPropertyHandler;
/**
* constructs an unitialised BusinessGroup, use setXXX for setting attributes
*/
public EfficiencyStatementArchiver() {
Translator fallBackTranslator = Util.createPackageTranslator(CourseNode.class, I18nModule.getDefaultLocale());
translator = Util.createPackageTranslator(this.getClass(), I18nModule.getDefaultLocale(), fallBackTranslator);
// fallback for user properties translation
translator = UserManager.getInstance().getPropertyHandlerTranslator(translator);
// list of user property handlers used in this archiver
userPropertyHandler = UserManager.getInstance().getUserPropertyHandlersFor(EfficiencyStatementArchiver.class.getCanonicalName(), true);
}
public static EfficiencyStatementArchiver getInstance() {
return instance;
}
public void archive(List<EfficiencyStatement> efficiencyStatements, Identity identity, File archiveFile) {
FileUtils.save(new File(archiveFile, EFFICIENCY_ARCHIVE_FILE), toXls(efficiencyStatements, identity), "utf-8");
}
private String toXls(List<EfficiencyStatement> efficiencyStatements, Identity identity) {
StringBuilder buf = new StringBuilder();
buf.append(translator.translate("efficiencystatement.title"));
appendIdentityIntro(buf, identity);
for (EfficiencyStatement efficiencyStatement: efficiencyStatements) {
buf.append(EOL);
buf.append(EOL);
appendIntro(buf, efficiencyStatement);
buf.append(EOL);
appendDetailsHeader(buf);
appendDetailsTable(buf, efficiencyStatement);
}
return buf.toString();
}
private void appendDetailsHeader(StringBuilder buf) {
buf.append( translator.translate("table.header.node") );
buf.append(DELIMITER);
buf.append( translator.translate("table.header.details") );
buf.append(DELIMITER);
buf.append( translator.translate("table.header.type") );
buf.append(DELIMITER);
buf.append( translator.translate("table.header.attempts") );
buf.append(DELIMITER);
buf.append( translator.translate("table.header.score") );
buf.append(DELIMITER);
buf.append( translator.translate("table.header.passed") );
buf.append(EOL);
}
private void appendDetailsTable(StringBuilder buf, EfficiencyStatement efficiencyStatement) {
for (Map<String,Object> nodeData : efficiencyStatement.getAssessmentNodes()) {
appendValue(buf, nodeData, AssessmentHelper.KEY_TITLE_SHORT);
appendValue(buf, nodeData, AssessmentHelper.KEY_TITLE_LONG);
appendTypeValue(buf, nodeData, AssessmentHelper.KEY_TYPE);
appendValue(buf, nodeData, AssessmentHelper.KEY_ATTEMPTS);
appendValue(buf, nodeData, AssessmentHelper.KEY_SCORE);
appendValue(buf, nodeData, AssessmentHelper.KEY_PASSED);
buf.append(EOL);
}
}
private void appendTypeValue(StringBuilder buf, Map<String,Object> nodeData, String key_type) {
Object value = nodeData.get(key_type);
if (value != null && (value instanceof String)) {
String valueString = (String)value;
if (valueString.equals("st")) {
buf.append("");
} else {
buf.append( translator.translate("title_" + valueString) );
}
} else {
buf.append("");
}
buf.append(DELIMITER);
}
private void appendIdentityIntro(StringBuilder buf, Identity identity) {
for (UserPropertyHandler propertyHandler : userPropertyHandler) {
String label = translator.translate(propertyHandler.i18nColumnDescriptorLabelKey());
String value = propertyHandler.getUserProperty(identity.getUser(), translator.getLocale());
appendLine(buf, label, (StringHelper.containsNonWhitespace(value) ? value : ""));
}
}
private void appendIntro(StringBuilder buf, EfficiencyStatement efficiencyStatement) {
buf.append(EOL);
appendLine(buf, translator.translate("course"), efficiencyStatement.getCourseTitle() + " (" + efficiencyStatement.getCourseRepoEntryKey().toString() +")");
appendLine(buf, translator.translate("date"), StringHelper.formatLocaleDateTime(efficiencyStatement.getLastUpdated(), I18nModule.getDefaultLocale()) );
List<Map<String,Object>> nodeDataList = efficiencyStatement.getAssessmentNodes();
if(nodeDataList.size() > 0) {
Map<String,Object> nodeData = nodeDataList.get(0);
if (nodeData != null) {
appendLabelValueLine(buf, nodeData, translator.translate("table.header.score"), AssessmentHelper.KEY_SCORE);
appendLabelValueLine(buf, nodeData, translator.translate("table.header.passed"), AssessmentHelper.KEY_PASSED);
}
}
}
private void appendValue(StringBuilder buf, Map<String,Object> nodeData, String key) {
Object value = nodeData.get(key);
if (value != null) {
buf.append(value);
} else {
buf.append("");
}
buf.append(DELIMITER);
}
private void appendLabelValueLine(StringBuilder buf, Map<String,Object> nodeData, String label, String key) {
buf.append(label);
buf.append(DELIMITER);
Object value = nodeData.get(key);
if (value != null) {
buf.append(value.toString());
} else {
buf.append("n/a");
}
buf.append(EOL);
}
private void appendLine(StringBuilder buf, String label, String value) {
buf.append(label);
buf.append(DELIMITER);
buf.append(value);
buf.append(DELIMITER);
buf.append(EOL);
}
}