package org.goobi.production.chart;
/**
* This file is part of the Goobi Application - a Workflow tool for the support of mass digitization.
*
* Visit the websites for more information.
* - http://www.goobi.org
* - http://launchpad.net/goobi-production
* - http://gdz.sub.uni-goettingen.de
* - http://www.intranda.com
* - http://digiverso.com
*
* This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free
* Software Foundation; either version 2 of the License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59
* Temple Place, Suite 330, Boston, MA 02111-1307 USA
*
* Linking this library statically or dynamically with other modules is making a combined work based on this library. Thus, the terms and conditions
* of the GNU General Public License cover the whole combination. As a special exception, the copyright holders of this library give you permission to
* link this library with independent modules to produce an executable, regardless of the license terms of these independent modules, and to copy and
* distribute the resulting executable under terms of your choice, provided that you also meet, for each linked independent module, the terms and
* conditions of the license of that module. An independent module is a module which is not derived from or based on this library. If you modify this
* library, you may extend this exception to your version of the library, but you are not obliged to do so. If you do not wish to do so, delete this
* exception statement from your version.
*/
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import org.apache.log4j.Logger;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.ProjectionList;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import de.sub.goobi.beans.Projekt;
import de.sub.goobi.beans.Schritt;
import de.sub.goobi.helper.Helper;
import de.sub.goobi.helper.enums.StepStatus;
/**
* This class implements the IProvideProjectTaskList and approaches the problem
* by using a projection on the hibernate criteria, which accelerates data retrieval
*
* @author Wulf Riebensahm
*
*/
public class HibernateProjectionProjectTaskList implements IProvideProjectTaskList {
private static final Logger logger = Logger.getLogger(HibernateProjectionProjectTaskList.class);
@Override
public List<IProjectTask> calculateProjectTasks(Projekt inProject, Boolean countImages, Integer inMax) {
List<IProjectTask> myTaskList = new ArrayList<IProjectTask>();
calculate(inProject, myTaskList, countImages, inMax);
return myTaskList;
}
@SuppressWarnings("rawtypes")
private synchronized void calculate(Projekt inProject, List<IProjectTask> myTaskList, Boolean countImages, Integer inMax) {
Session session = Helper.getHibernateSession();
Criteria crit = session.createCriteria(Schritt.class);
crit.createCriteria("prozess", "proc");
crit.addOrder(Order.asc("reihenfolge"));
crit.add(Restrictions.eq("proc.istTemplate", Boolean.FALSE));
crit.add(Restrictions.eq("proc.projekt", inProject));
ProjectionList proList = Projections.projectionList();
proList.add(Projections.property("titel"));
proList.add(Projections.property("bearbeitungsstatus"));
proList.add(Projections.sum("proc.sortHelperImages"));
proList.add(Projections.count("id"));
// proList.add(Projections.groupProperty(("reihenfolge")));
proList.add(Projections.groupProperty(("titel")));
proList.add(Projections.groupProperty(("bearbeitungsstatus")));
crit.setProjection(proList);
List list = crit.list();
Iterator it = list.iterator();
if(!it.hasNext()){
logger.debug("No any data!");
}
else{
Integer rowCount = 0;
while(it.hasNext()){
Object[] row = (Object[])it.next();
rowCount ++;
String message = "";
int i;
String shorttitle;
if (((String) row[FieldList.stepName.getFieldLocation()]).length() > 60){
shorttitle = ((String) row[FieldList.stepName.getFieldLocation()]).substring(0, 60) + "...";
}else{
shorttitle = (String) row[FieldList.stepName.getFieldLocation()];
}
IProjectTask pt = null;
for (IProjectTask task : myTaskList) {
if (task.getTitle().equals(shorttitle)) {
pt = task;
break;
}
}
if (pt == null) {
pt = new ProjectTask(shorttitle, 0, 0);
myTaskList.add(pt);
}
if (StepStatus.DONE.getValue().equals(row[FieldList.stepStatus.getFieldLocation()])) {
if (countImages) {
pt.setStepsCompleted((Integer) row[FieldList.pageCount.getFieldLocation()]);
} else {
pt.setStepsCompleted((Integer) row[FieldList.processCount.getFieldLocation()]);
}
}
if (countImages) {
pt.setStepsMax(pt.getStepsMax() + (Integer) row[FieldList.pageCount.getFieldLocation()]);
} else {
pt.setStepsMax(pt.getStepsMax() + (Integer) row[FieldList.processCount.getFieldLocation()]);
}
//TODO remove following lines all the way to system.out
for(i = 0; i < row.length;i++){
message = message + "|" + row[i];
}
logger.debug(new Integer(rowCount).toString() + message);
}
}
}
private enum FieldList {
stepName(0), stepStatus(1), pageCount(2), processCount(3);
Integer fieldLocation;
FieldList(Integer fieldLocation) {
this.fieldLocation = fieldLocation;
}
Integer getFieldLocation() {
return this.fieldLocation;
}
}
}