com.ueboot.shiro.repository.userrole.impl.UserRoleRepositoryImpl Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of ueboot-shiro Show documentation

The newest version!

/*
* Copyright (c)  2018
* All rights reserved.
* 2018-08-21 09:39:51
*/
package com.ueboot.shiro.repository.userrole.impl;

import com.ueboot.core.jpa.repository.DefaultJpaRepository;
import com.ueboot.core.jpa.repository.query.StringQuery;
import com.ueboot.shiro.entity.StatisticInfo;
import com.ueboot.shiro.entity.UserRole;
import com.ueboot.shiro.repository.userrole.UserRoleBaseRepository;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
* 自定义接口实现类，可以使用父类DefaultJpaRepository当中的find(),findBySql等方法实现自定义的StringQuery查询
* 相关使用示例，参见文档http://docs.ueboot.com
* Created on 2018-08-21 09:39:51
* @author yangkui
* @since 2.1.0 by ueboot-generator
*/
@Slf4j
@Repository
public class UserRoleRepositoryImpl extends DefaultJpaRepository implements UserRoleBaseRepository {

    /***
     *统计数据
     * @param roleId
     * @return
     */

    @Override
    public Long statisticUserSumByRoleId(Long roleId) {
        StringQuery query=StringQuery.newQuery()
                .query("select count(ur.id) as num from UserRole ur  where  ur.role.id=:roleId")
                .param("roleId",roleId)
                .predicate(true)
                .build();
        List list=this.find(query,StatisticInfo.class);
        if(list!=null&&list.isEmpty()){
            return 0L;
        }
        return list.get(0).getNum();
    }
}