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

Introduction

Here is the source code for net.groupbuy.dao.impl.MemberRankDaoImpl.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.math.BigDecimal;
import java.util.List;

import javax.persistence.FlushModeType;
import javax.persistence.NoResultException;

import net.groupbuy.dao.MemberRankDao;
import net.groupbuy.entity.MemberRank;
import net.groupbuy.entity.Product;

import org.springframework.stereotype.Repository;
import org.springframework.util.Assert;

/**
 * Dao - 
 * 
 * @author SHOP++ Team
 * @version 3.0
 */
@Repository("memberRankDaoImpl")
public class MemberRankDaoImpl extends BaseDaoImpl<MemberRank, Long> implements MemberRankDao {

    public boolean nameExists(String name) {
        if (name == null) {
            return false;
        }
        String jpql = "select count(*) from MemberRank memberRank where lower(memberRank.name) = lower(:name)";
        Long count = entityManager.createQuery(jpql, Long.class).setFlushMode(FlushModeType.COMMIT)
                .setParameter("name", name).getSingleResult();
        return count > 0;
    }

    public boolean amountExists(BigDecimal amount) {
        if (amount == null) {
            return false;
        }
        String jpql = "select count(*) from MemberRank memberRank where memberRank.amount = :amount";
        Long count = entityManager.createQuery(jpql, Long.class).setFlushMode(FlushModeType.COMMIT)
                .setParameter("amount", amount).getSingleResult();
        return count > 0;
    }

    public MemberRank findDefault() {
        try {
            String jpql = "select memberRank from MemberRank memberRank where memberRank.isDefault = true";
            return entityManager.createQuery(jpql, MemberRank.class).setFlushMode(FlushModeType.COMMIT)
                    .getSingleResult();
        } catch (NoResultException e) {
            return null;
        }
    }

    public MemberRank findByAmount(BigDecimal amount) {
        if (amount == null) {
            return null;
        }
        String jpql = "select memberRank from MemberRank memberRank where memberRank.isSpecial = false and memberRank.amount <= :amount order by memberRank.amount desc";
        return entityManager.createQuery(jpql, MemberRank.class).setFlushMode(FlushModeType.COMMIT)
                .setParameter("amount", amount).setMaxResults(1).getSingleResult();
    }

    /**
     * ??
     * 
     * @param memberRank
     *            
     */
    @Override
    public void persist(MemberRank memberRank) {
        Assert.notNull(memberRank);
        if (memberRank.getIsDefault()) {
            String jpql = "update MemberRank memberRank set memberRank.isDefault = false where memberRank.isDefault = true";
            entityManager.createQuery(jpql).setFlushMode(FlushModeType.COMMIT).executeUpdate();
        }
        super.persist(memberRank);
    }

    /**
     * ?
     * 
     * @param memberRank
     *            
     * @return 
     */
    @Override
    public MemberRank merge(MemberRank memberRank) {
        Assert.notNull(memberRank);
        if (memberRank.getIsDefault()) {
            String jpql = "update MemberRank memberRank set memberRank.isDefault = false where memberRank.isDefault = true and memberRank != :memberRank";
            entityManager.createQuery(jpql).setFlushMode(FlushModeType.COMMIT)
                    .setParameter("memberRank", memberRank).executeUpdate();
        }
        return super.merge(memberRank);
    }

    /**
     * ?
     * 
     * @param memberRank
     *            
     */
    @Override
    public void remove(MemberRank memberRank) {
        if (memberRank != null && !memberRank.getIsDefault()) {
            String jpql = "select product from Product product join product.memberPrice memberPrice where index(memberPrice) = :memberRank";
            List<Product> products = entityManager.createQuery(jpql, Product.class)
                    .setFlushMode(FlushModeType.COMMIT).setParameter("memberRank", memberRank).getResultList();
            for (int i = 0; i < products.size(); i++) {
                Product product = products.get(i);
                product.getMemberPrice().remove(memberRank);
                if (i % 20 == 0) {
                    super.flush();
                    super.clear();
                }
            }
            super.remove(super.merge(memberRank));
        }
    }

}