content: // Licensed to the Apache Software Foundation (ASF) under one
  // or more contributor license agreements.  See the NOTICE file
  // distributed with this work for additional information
  // regarding copyright ownership.  The ASF licenses this file
  // to you under the Apache License, Version 2.0 (the
  // "License"); you may not use this file except in compliance
  // with the License.  You may obtain a copy of the License at
  //
  //   http://www.apache.org/licenses/LICENSE-2.0
  //
  // Unless required by applicable law or agreed to in writing,
  // software distributed under the License is distributed on an
  // "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  // KIND, either express or implied.  See the License for the
  // specific language governing permissions and limitations
  // under the License.
  
  package org.apache.cloudstack.acl.dao;
  
  import com.cloud.utils.Pair;
  import com.cloud.utils.db.Filter;
  import com.cloud.utils.db.GenericDaoBase;
  import com.cloud.utils.db.SearchBuilder;
  import com.cloud.utils.db.SearchCriteria;
  
  import org.apache.cloudstack.acl.RoleType;
  import org.apache.cloudstack.acl.RoleVO;
  import org.apache.commons.lang3.StringUtils;
  import org.springframework.stereotype.Component;
  
  import java.util.Collections;
  import java.util.List;
  
  @Component
  public class RoleDaoImpl extends GenericDaoBase<RoleVO, Long> implements RoleDao {
  
      private final SearchBuilder<RoleVO> RoleByIdsSearch;
      private final SearchBuilder<RoleVO> RoleByNameSearch;
      private final SearchBuilder<RoleVO> RoleByTypeSearch;
      private final SearchBuilder<RoleVO> RoleByNameAndTypeSearch;
      private final SearchBuilder<RoleVO> RoleByIsPublicSearch;
  
      public RoleDaoImpl() {
          super();
  
          RoleByIdsSearch = createSearchBuilder();
          RoleByIdsSearch.and("idIN", RoleByIdsSearch.entity().getId(), SearchCriteria.Op.IN);
          RoleByIdsSearch.done();
  
          RoleByNameSearch = createSearchBuilder();
          RoleByNameSearch.and("roleName", RoleByNameSearch.entity().getName(), SearchCriteria.Op.LIKE);
          RoleByNameSearch.and("isPublicRole", RoleByNameSearch.entity().isPublicRole(), SearchCriteria.Op.EQ);
          RoleByNameSearch.and("state", RoleByNameSearch.entity().getState(), SearchCriteria.Op.EQ);
          RoleByNameSearch.done();
  
          RoleByTypeSearch = createSearchBuilder();
          RoleByTypeSearch.and("roleType", RoleByTypeSearch.entity().getRoleType(), SearchCriteria.Op.EQ);
          RoleByTypeSearch.and("isPublicRole", RoleByTypeSearch.entity().isPublicRole(), SearchCriteria.Op.EQ);
          RoleByTypeSearch.and("state", RoleByTypeSearch.entity().getState(), SearchCriteria.Op.EQ);
          RoleByTypeSearch.done();
  
          RoleByNameAndTypeSearch = createSearchBuilder();
          RoleByNameAndTypeSearch.and("roleName", RoleByNameAndTypeSearch.entity().getName(), SearchCriteria.Op.EQ);
          RoleByNameAndTypeSearch.and("roleType", RoleByNameAndTypeSearch.entity().getRoleType(), SearchCriteria.Op.EQ);
          RoleByNameAndTypeSearch.and("isPublicRole", RoleByNameAndTypeSearch.entity().isPublicRole(), SearchCriteria.Op.EQ);
          RoleByNameAndTypeSearch.done();
  
          RoleByIsPublicSearch = createSearchBuilder();
          RoleByIsPublicSearch.and("isPublicRole", RoleByIsPublicSearch.entity().isPublicRole(), SearchCriteria.Op.EQ);
          RoleByIsPublicSearch.and("state", RoleByIsPublicSearch.entity().getState(), SearchCriteria.Op.EQ);
          RoleByIsPublicSearch.done();
      }
  
      @Override
      public List<RoleVO> findAllByName(final String roleName, boolean showPrivateRole) {
          return findAllByName(roleName, null, null, null, null, showPrivateRole).first();
      }
  
      @Override
      public Pair<List<RoleVO>, Integer> findAllByName(final String roleName, String keyword, String state, Long offset, Long limit, boolean showPrivateRole) {
          SearchCriteria<RoleVO> sc = RoleByNameSearch.create();
          filterPrivateRolesIfNeeded(sc, showPrivateRole);
          if (StringUtils.isNotEmpty(roleName)) {
              sc.setParameters("roleName", roleName);
          }
          if (StringUtils.isNotEmpty(keyword)) {
              sc.setParameters("roleName", "%" + keyword + "%");
          }
          if (StringUtils.isNotEmpty(state)) {
              sc.setParameters("state", state);
          }
  
          return searchAndCount(sc, new Filter(RoleVO.class, "id", true, offset, limit));
      }
  
      @Override
      public List<RoleVO> findAllByRoleType(final RoleType type, boolean showPrivateRole) {
          return findAllByRoleType(type, null, null, null, showPrivateRole).first();
      }
  
      public Pair<List<RoleVO>, Integer> findAllByRoleType(final RoleType type, String state, Long offset, Long limit, boolean showPrivateRole) {
          SearchCriteria<RoleVO> sc = RoleByTypeSearch.create();
          filterPrivateRolesIfNeeded(sc, showPrivateRole);
          sc.setParameters("roleType", type);
          if (StringUtils.isNotEmpty(state)) {
              sc.setParameters("state", state);
          }
          return searchAndCount(sc, new Filter(RoleVO.class, "id", true, offset, limit));
      }
  
      @Override
      public List<RoleVO> findByName(String roleName, boolean showPrivateRole) {
          SearchCriteria<RoleVO> sc = RoleByNameSearch.create();
          filterPrivateRolesIfNeeded(sc, showPrivateRole);
          sc.setParameters("roleName", roleName);
          return listBy(sc);
      }
  
      @Override
      public RoleVO findByNameAndType(String roleName, RoleType type, boolean showPrivateRole) {
          SearchCriteria<RoleVO> sc = RoleByNameAndTypeSearch.create();
          filterPrivateRolesIfNeeded(sc, showPrivateRole);
          sc.setParameters("roleName", roleName);
          sc.setParameters("roleType", type);
          return findOneBy(sc);
      }
  
      @Override
      public Pair<List<RoleVO>, Integer> listAllRoles(String state, Long startIndex, Long limit, boolean showPrivateRole) {
          SearchCriteria<RoleVO> sc = RoleByIsPublicSearch.create();
          if (StringUtils.isNotEmpty(state)) {
              sc.setParameters("state", state);
          }
          filterPrivateRolesIfNeeded(sc, showPrivateRole);
          return searchAndCount(sc, new Filter(RoleVO.class, "id", true, startIndex, limit));
      }
  
      @Override
      public List<RoleVO> searchByIds(Long... ids) {
          if (ids == null || ids.length == 0) {
              return Collections.emptyList();
          }
          SearchCriteria<RoleVO> sc = RoleByIdsSearch.create();
          sc.setParameters("idIN", ids);
          return listBy(sc);
      }
  
      public void filterPrivateRolesIfNeeded(SearchCriteria<RoleVO> sc, boolean showPrivateRole) {
          if (!showPrivateRole) {
              sc.setParameters("isPublicRole", true);
          }
      }
  }
  