PricePointDaoImpl.java

/**
 * Revenue Settlement and Sharing System GE
 * Copyright (C) 2011-2014, Javier Lucio - lucio@tid.es
 * Telefonica Investigacion y Desarrollo, S.A.
 *
 * Copyright (C) 2015 CoNWeT Lab., Universidad Politécnica de Madrid
 * 
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as
 * published by the Free Software Foundation, either version 3 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 Affero General Public License for more details.
 * 
 * You should have received a copy of the GNU Affero General Public License
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
 */

/**
 * 
 */
package es.upm.fiware.rss.dao.impl;

import java.util.Collections;
import java.util.List;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Repository;

import es.upm.fiware.rss.dao.PricePointDAO;
import es.upm.fiware.rss.model.BmOb;
import es.upm.fiware.rss.model.BmObCountry;
import es.upm.fiware.rss.model.BmPricePoint;
import es.upm.fiware.rss.model.BmPricePointId;

/**
 * 
 */
@Repository
public class PricePointDaoImpl extends GenericDaoImpl<BmPricePoint, BmPricePointId> implements PricePointDAO {

    /**
     * Variable to print the trace.
     */
    private static final Logger LOGGER = LoggerFactory.getLogger(PricePointDaoImpl.class);

    /*
     * (non-Javadoc)
     * 
     * @see es.upm.greta.bmms.dao.impl.GenericDaoImpl#getDomainClass()
     */
    @Override
    protected Class<BmPricePoint> getDomainClass() {
        return BmPricePoint.class;
    }

    /* Methods for retrieve price point list */

    @Override
    public List<BmPricePoint> getListPricePoint(final BmObCountry obCountry) {
        String hql = "from BmPricePoint p where p.bmObCountry.id.nuCountryId = " + obCountry.getId().getNuCountryId()
            + " and p.bmObCountry.id.nuObId = " + obCountry.getId().getNuObId();
        return this.listPricePointQuery(hql);
    }

    @Override
    public List<BmPricePoint> getListPricePoint(final BmOb ob) {
        String hql = "from BmPricePoint p where p.bmObCountry.id.nuObId = " + ob.getNuObId();
        return this.listPricePointQuery(hql);
    }

    @Override
    public List<BmPricePoint> getListPricePoint(final float price) {
        String hql = "from BmPricePoint p where p.nuPrice = " + price;
        return this.listPricePointQuery(hql);
    }

    @Override
    public List<BmPricePoint> getListPricePoint(final float minPrice, final float maxPrice) {
        String hql = "from BmPricePoint p where p.nuPrice >= " + minPrice + " and p.nuPrice <= " + maxPrice;
        return this.listPricePointQuery(hql);
    }

    /* Methods for retrieve a price point */

    @Override
    public BmPricePoint getPricePoint(final BmObCountry ob, final String txPricePointId) {
        String hql = "from BmPricePoint p where p.id.nuCountryId = " + ob.getId().getNuCountryId()
            + " and p.id.nuObId = " + ob.getId().getNuObId() + " and p.id.txPricePointId = '" + txPricePointId
            + "' order by p.dtEditDate desc";

        List<BmPricePoint> lpp = this.listPricePointQuery(hql);
        if (lpp.size() > 0) {
            return lpp.get(0);
        } else {
            return null;
        }

        /*
         * Criteria criteria = getSession().createCriteria(BmPricePoint.class);
         * criteria.add(Restrictions.eq("txPricePointId", txPricePointId)); criteria.add(Restrictions.eq("nuCountryId",
         * ob.getId().getNuCountryId())); criteria.add(Restrictions.eq("nuObId", ob.getId().getNuObId()));
         * List<BmPricePoint> result = criteria.list(); if (result != null && result.size() > 0) { return result.get(0);
         * } else { return null; }
         */
    }

    @Override
    public BmPricePoint getPricePoint(BmObCountry ob, float price) {
        String hql = "from BmPricePoint p where p.id.nuCountryId = " + ob.getId().getNuCountryId()
            + " and p.id.nuObId = " + ob.getId().getNuObId() + " and p.nuPrice = " + price
            + " order by p.dtEditDate desc";

        List<BmPricePoint> lpp = this.listPricePointQuery(hql);
        if (lpp.size() > 0) {
            return lpp.get(0);
        } else {
            return null;
        }
    }

    /* Private Methods */

    /**
     * Method executes HQL query.
     * 
     * @param hql
     *            String with HQL query
     * @return resultList
     */
    private List<BmPricePoint> listPricePointQuery(final String hql) {
        PricePointDaoImpl.LOGGER.debug(hql);
        // @SuppressWarnings("rawtypes")
        List list = this.getSession().createQuery(hql).list();
        // @SuppressWarnings("unchecked")
        List<BmPricePoint> resultList = Collections.checkedList(list, BmPricePoint.class);
        return resultList;
    }

}