/**
 * Abiquo community edition
 * cloud management application for hybrid clouds
 * Copyright (C) 2008-2010 - Abiquo Holdings S.L.
 *
 * This application is free software; you can redistribute it and/or
 * modify it under the terms of the GNU LESSER GENERAL PUBLIC
 * LICENSE as published by the Free Software Foundation under
 * version 3 of the License
 *
 * This software 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
 * LESSER GENERAL PUBLIC LICENSE v.3 for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the
 * Free Software Foundation, Inc., 59 Temple Place - Suite 330,
 * Boston, MA 02111-1307, USA.
 */

package com.abiquo.abiserver.persistence.dao.virtualappliance.hibernate;

import java.math.BigDecimal;
import java.math.BigInteger;
import java.util.Collection;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;

import com.abiquo.abiserver.business.hibernate.pojohb.virtualappliance.VirtualDataCenterHB;
import com.abiquo.abiserver.exception.PersistenceException;
import com.abiquo.abiserver.persistence.DAOFactory;
import com.abiquo.abiserver.persistence.dao.virtualappliance.VirtualDataCenterDAO;
import com.abiquo.abiserver.persistence.hibernate.HibernateDAO;
import com.abiquo.abiserver.persistence.hibernate.HibernateDAOFactory;

/**
 * Class that implements the extra DAO functions for the
 * {@link com.abiquo.abiserver.persistence.dao.virtualappliance.VirtualDataCenterDAO} interface
 * 
 * @author jdevesa@abiquo.com
 */
@SuppressWarnings("unchecked")
public class VirtualDataCenterDAOHibernate extends HibernateDAO<VirtualDataCenterHB, Integer>
    implements VirtualDataCenterDAO
{

    private static final String VIRTUAL_DATACENTER_GET_BY_NETWORK =
        "VIRTUAL_DATACENTER.GET_BY_NETWORK";

    private static final String VIRTUAL_DATACENTER_GET_BY_VAPP = "VIRTUAL_DATACENTER_GET_BY_VAPP";

    private static final String VIRTUAL_DATACENTERS_BY_ENTERPRISE =
        "VIRTUAL_DATACENTER_BY_ENTERPRISE";

    private static final String VIRTUAL_DATACENTERS_BY_ENTERPRISE_AND_DATACENTER =
        "VIRTUAL_DATACENTER_BY_ENTERPRISE_AND_DATACENTER";

    private static final String SUM_VOLUMES_RESOURCES =
        "select sum(r.limitResource) from rasd r, rasd_management rm where r.instanceID = rm.idResource and rm.idResourceType = '8' and rm.idVirtualDatacenter = :virtualDatacenterId";

    private static final String COUNT_PUBLIC_IP_RESOURCES =
        "select count(*) from ip_pool_management ipm, network_configuration nc, vlan_network vn, datacenter dc, rasd_management rm "
            + " where ipm.dhcp_service_id=nc.dhcp_service_id and vn.network_configuration_id = nc.network_configuration_id and vn.network_id = dc.network_id and rm.idManagement = ipm.idManagement "
            + " and ipm.mac is not null " //
            + " and rm.idVirtualDataCenter = :virtualDatacenterId";

    @Override
    public VirtualDataCenterHB findByIdNamed(Integer id)
    {
        return (VirtualDataCenterHB) getSession().get("VirtualDataCenterHB", id);
    }

    @Override
    public VirtualDataCenterHB getVirtualDatacenterFromNetworkId(Integer idNetwork)
        throws PersistenceException
    {
        VirtualDataCenterHB vdcHB;

        try
        {
            Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
            Query query = session.getNamedQuery(VIRTUAL_DATACENTER_GET_BY_NETWORK);
            query.setInteger("network_id", idNetwork);
            vdcHB = (VirtualDataCenterHB) query.uniqueResult();
        }
        catch (HibernateException he)
        {
            throw new PersistenceException(he.getMessage(), he);
        }

        return vdcHB;
    }

    @Override
    public VirtualDataCenterHB getVirtualDatacenterFromVirtualAppliance(Integer vappId)
        throws PersistenceException
    {
        try
        {
            Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
            Query query = session.getNamedQuery(VIRTUAL_DATACENTER_GET_BY_VAPP);
            query.setInteger("vappId", vappId);
            return (VirtualDataCenterHB) query.uniqueResult();
        }
        catch (HibernateException he)
        {
            throw new PersistenceException(he.getMessage(), he);
        }

    }

    @Override
    public Collection<VirtualDataCenterHB> getVirtualDatacentersFromEnterprise(Integer enterpriseId)
    {
        Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
        return session.getNamedQuery(VIRTUAL_DATACENTERS_BY_ENTERPRISE)
            .setParameter("enterpriseId", enterpriseId).list();
    }

    @Override
    public Collection<VirtualDataCenterHB> getVirtualDatacentersFromEnterpriseAndDatacenter(
        Integer enterpriseId, Integer datacenterId)
    {
        Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();
        return session.getNamedQuery(VIRTUAL_DATACENTERS_BY_ENTERPRISE_AND_DATACENTER)
            .setParameter("enterpriseId", enterpriseId).setParameter("datacenterId", datacenterId)
            .list();
    }

    private final static Long MB_TO_BYTES = 1024l * 1024l;

    public long getCurrentStorageAllocated(int virtualDatacenterId)
    {
        Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();

        BigDecimal storage =
            (BigDecimal) session.createSQLQuery(SUM_VOLUMES_RESOURCES)
                .setParameter("virtualDatacenterId", virtualDatacenterId).uniqueResult();

        return storage == null ? 0 : storage.longValue() * MB_TO_BYTES;
    }

    public long getCurrentPublicIpAllocated(int virtualDatacenterId)
    {
        Session session = HibernateDAOFactory.getSessionFactory().getCurrentSession();

        BigInteger publicIps =
            (BigInteger) session.createSQLQuery(COUNT_PUBLIC_IP_RESOURCES)
                .setParameter("virtualDatacenterId", virtualDatacenterId).uniqueResult();

        return publicIps == null ? 0 : publicIps.longValue();

    }

    public long getCurrentVlanAllocated(int virtualDatacenterId)
    {
        final DAOFactory daoF = HibernateDAOFactory.instance();

        Integer vlanCount =
            daoF.getVlanNetworkDAO().findByVirtualDatacenter(virtualDatacenterId).size();

        return vlanCount == null ? 0 : vlanCount;
    }
}