view flys-artifacts/src/main/java/de/intevation/flys/artifacts/states/GaugeTimerangeState.java @ 4496:d8992459b408

Add method to return the facets of an artifact This methos should be used to get the facets of an artifact instead of accessing the facets member variable directly.
author Björn Ricks <bjoern.ricks@intevation.de>
date Wed, 14 Nov 2012 11:11:04 +0100
parents f6c73ee1b7f1
children 12766ab27a36
line wrap: on
line source
package de.intevation.flys.artifacts.states;

import java.util.Calendar;
import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.type.StandardBasicTypes;

import de.intevation.flys.artifacts.FLYSArtifact;
import de.intevation.flys.backend.SessionHolder;
import de.intevation.flys.model.Gauge;
import de.intevation.flys.utils.FLYSUtils;


/**
 * @author <a href="mailto:ingo.weinzierl@intevation.de">Ingo Weinzierl</a>
 */
public class GaugeTimerangeState extends IntRangeState {

    private static final Logger logger =
            Logger.getLogger(GaugeTimerangeState.class);


    protected long[] getLowerUpper(FLYSArtifact flys) {
        Gauge gauge = FLYSUtils.getReferenceGauge(flys);

        if (gauge == null) {
            logger.warn("No reference gauge specified!");
            return new long[] { 0, 0 };
        }

        Session session = SessionHolder.HOLDER.get();

        SQLQuery query = session.createSQLQuery(
                "SELECT min(start_time) as min, max(stop_time) as max " +
                        "FROM time_intervals WHERE id in " +
                        "(SELECT time_interval_id FROM discharge_tables " +
                "WHERE gauge_id =:gid)");

        query.addScalar("min", StandardBasicTypes.CALENDAR);
        query.addScalar("max", StandardBasicTypes.CALENDAR);

        query.setInteger("gid", gauge.getId());

        List<?> results = query.list();

        if (results != null) {
            Object[] res = (Object[]) results.get(0);

            Calendar lo = (Calendar) res[0];
            Calendar up = (Calendar) res[1];

            if (lo != null && up != null) {
                return new long[] { lo.getTimeInMillis(), up.getTimeInMillis() };
            }
        }

        logger.warn("Could not determine time range for gauge: " + gauge);

        return null;
    }


    @Override
    protected Object getLower(FLYSArtifact flys) {
        long[] lowerUpper = getLowerUpper(flys);

        return lowerUpper != null ? lowerUpper[0] : 0;
    }


    @Override
    protected Object getUpper(FLYSArtifact flys) {
        long[] lowerUpper = getLowerUpper(flys);

        return lowerUpper != null ? lowerUpper[1] : 0;
    }


    @Override
    protected String getUIProvider() {
        return "gaugetimerange";
    }

    @Override
    protected String getType() {
        return "longrange";
    }
}
// vim:set ts=4 sw=4 si et sta sts=4 fenc=utf-8 :

http://dive4elements.wald.intevation.org