com.sapienter.jbilling.server.metafields.db.MetaFieldGroupDAS.java Source code

Introduction

Here is the source code for com.sapienter.jbilling.server.metafields.db.MetaFieldGroupDAS.java

Source

/*
 jBilling - The Enterprise Open Source Billing System
 Copyright (C) 2003-2011 Enterprise jBilling Software Ltd. and Emiliano Conde
    
 This file is part of jbilling.
    
 jbilling 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.
    
 jbilling 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 jbilling.  If not, see <http://www.gnu.org/licenses/>.
 */
package com.sapienter.jbilling.server.metafields.db;

import java.util.List;

import com.sapienter.jbilling.server.metafields.EntityType;
import com.sapienter.jbilling.server.util.db.AbstractDAS;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;

import java.util.List;

/**
 * @author Oleg Baskakov
 * @since 18-Apr-2013
 */

public class MetaFieldGroupDAS extends AbstractDAS<MetaFieldGroup> {

    @SuppressWarnings("unchecked")
    public List<MetaFieldGroup> getAvailableFieldGroups(Integer entityId, EntityType entityType) {
        DetachedCriteria query = DetachedCriteria.forClass(MetaFieldGroup.class);
        query.add(Restrictions.eq("entityId", entityId));
        query.add(Restrictions.eq("entityType", entityType));
        query.add(Restrictions.eq("class", MetaFieldGroup.class));
        query.addOrder(Order.asc("displayOrder"));
        return (List<MetaFieldGroup>) getHibernateTemplate().findByCriteria(query);
    }

    @SuppressWarnings("unchecked")
    public List<MetaFieldGroup> getAllAvailableFieldGroups(Integer entityId) {
        DetachedCriteria query = DetachedCriteria.forClass(MetaFieldGroup.class);
        query.add(Restrictions.eq("entityId", entityId));
        query.addOrder(Order.asc("displayOrder"));
        return (List<MetaFieldGroup>) getHibernateTemplate().findByCriteria(query);
    }

    @SuppressWarnings("unchecked")
    public Integer getAllAvailableFieldGroupsCount(Integer entityId) {
        DetachedCriteria query = DetachedCriteria.forClass(MetaFieldGroup.class);
        query.setProjection(Projections.rowCount()).add(Restrictions.eq("entityId", entityId))
                .addOrder(Order.asc("displayOrder"));
        List result = getHibernateTemplate().findByCriteria(query);
        return (Integer) result.get(0);

    }

    @SuppressWarnings("unchecked")
    public MetaFieldGroup getGroupByName(Integer entityId, EntityType entityType, String name) {
        if (name == null || name.trim().length() == 0) {
            return null;
        }
        DetachedCriteria query = DetachedCriteria.forClass(MetaFieldGroup.class);
        query.add(Restrictions.eq("entityId", entityId));
        query.add(Restrictions.eq("entityType", entityType));
        query.add(Restrictions.eq("description", name));
        query.add(Restrictions.eq("class", MetaFieldGroup.class));
        List<MetaFieldGroup> fields = (List<MetaFieldGroup>) getHibernateTemplate().findByCriteria(query);
        return !fields.isEmpty() ? fields.get(0) : null;
    }

}