net.groupbuy.dao.impl.MemberAttributeDaoImpl.java Source code

Introduction

Here is the source code for net.groupbuy.dao.impl.MemberAttributeDaoImpl.java

Source

/*
 * Copyright 2005-2013 shopxx.net. All rights reserved.
 * Support: http://www.shopxx.net
 * License: http://www.shopxx.net/license
 */
package net.groupbuy.dao.impl;

import java.util.List;

import javax.persistence.FlushModeType;

import net.groupbuy.dao.MemberAttributeDao;
import net.groupbuy.entity.Member;
import net.groupbuy.entity.MemberAttribute;
import net.groupbuy.entity.MemberAttribute.Type;

import org.springframework.stereotype.Repository;

/**
 * Dao - 
 * 
 * @author SHOP++ Team
 * @version 3.0
 */
@Repository("memberAttributeDaoImpl")
public class MemberAttributeDaoImpl extends BaseDaoImpl<MemberAttribute, Long> implements MemberAttributeDao {

    public Integer findUnusedPropertyIndex() {
        for (int i = 0; i < Member.ATTRIBUTE_VALUE_PROPERTY_COUNT; i++) {
            String jpql = "select count(*) from MemberAttribute memberAttribute where memberAttribute.propertyIndex = :propertyIndex";
            Long count = entityManager.createQuery(jpql, Long.class).setFlushMode(FlushModeType.COMMIT)
                    .setParameter("propertyIndex", i).getSingleResult();
            if (count == 0) {
                return i;
            }
        }
        return null;
    }

    public List<MemberAttribute> findList() {
        String jpql = "select memberAttribute from MemberAttribute memberAttribute where memberAttribute.isEnabled = true order by memberAttribute.order asc";
        return entityManager.createQuery(jpql, MemberAttribute.class).setFlushMode(FlushModeType.COMMIT)
                .getResultList();
    }

    /**
     * 
     * 
     * @param memberAttribute
     *            
     */
    @Override
    public void remove(MemberAttribute memberAttribute) {
        if (memberAttribute != null && (memberAttribute.getType() == Type.text
                || memberAttribute.getType() == Type.select || memberAttribute.getType() == Type.checkbox)) {
            String propertyName = Member.ATTRIBUTE_VALUE_PROPERTY_NAME_PREFIX + memberAttribute.getPropertyIndex();
            String jpql = "update Member members set members." + propertyName + " = null";
            entityManager.createQuery(jpql).setFlushMode(FlushModeType.COMMIT).executeUpdate();
            super.remove(memberAttribute);
        }
    }

}