com.payneteasy.superfly.dao.RoleDao Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of superfly-service Show documentation
Service layer classes, including DAO layer too
There is a newer version: 1.7-32
package com.payneteasy.superfly.dao;

import java.util.List;

import com.googlecode.jdbcproc.daofactory.annotation.AStoredProcedure;
import com.payneteasy.superfly.model.RoutineResult;
import com.payneteasy.superfly.model.ui.action.UIActionForCheckboxForRole;
import com.payneteasy.superfly.model.ui.group.UIGroupForCheckbox;
import com.payneteasy.superfly.model.ui.role.UIRole;
import com.payneteasy.superfly.model.ui.role.UIRoleForFilter;
import com.payneteasy.superfly.model.ui.role.UIRoleForList;
import com.payneteasy.superfly.model.ui.role.UIRoleForView;

/**
 * DAO to work with roles.
 * 
 * @author Roman Puchkovskiy
 */
public interface RoleDao {
    /**
     * Returns list of roles for UI filter.
     *
     * @param subsystemIds
     *            comma-separated list of IDs of subsystems to consider (ignored
     *            if null)
     * @param rolePrefix
     *            prefix from which role name must start (ignored if null)
     * @param startFrom
     *            role offset
     * @param recordsCount
     *            limit
     * @return roles
     */
    @AStoredProcedure(name = "ui_filter_dyn_roles")
    List getRolesForFilter(String subsystemIds,
            String rolePrefix, int startFrom, int recordsCount);

    @AStoredProcedure(name = "ui_get_roles_list")
    List getRoles(long startFrom, long recordsCount,
            int orderFieldNumber, String orderType, String rolesName,
            String subsystemsName);

    @AStoredProcedure(name = "ui_get_roles_list_count")
    long getRoleCount(String rolesName, String subsystemsName);

    @AStoredProcedure(name = "ui_get_role")
    UIRoleForView getRole(long roleId);

    @AStoredProcedure(name = "ui_delete_role")
    RoutineResult deleteRole(long roleId);

    @AStoredProcedure(name = "ui_edit_role_properties")
    RoutineResult updateRole(UIRole role);

    @AStoredProcedure(name = "ui_create_role")
    RoutineResult createRole(UIRole role);

    @AStoredProcedure(name = "ui_change_role_groups")
    RoutineResult changeRoleGroups(long roleId, String groupToAddIds,
            String groupToRemoveIds);

    @AStoredProcedure(name = "ui_get_all_role_groups_list")
    List getAllRoleGroups(long startFrom, long recordsCount,
            int orderFieldNumber, String orderType, long roleId);

    @AStoredProcedure(name = "ui_get_all_role_groups_list_count")
    long getAllRoleGroupsCount(long roleId);

    @AStoredProcedure(name = "ui_get_all_role_actions_list")
    List getAllRoleActions(long startFrom,
            long recordsCount, int orderFieldNumber, String orderType,
            long roleId, String actionName);

    @AStoredProcedure(name = "ui_get_all_role_actions_list_count")
    long getAllRoleActionsCount(long roleId, String actionName);

    @AStoredProcedure(name = "ui_get_mapped_role_actions_list")
    List getMappedRoleActions(long startFrom,
            long recordsCount, int orderFieldNumber, String orderType,
            long roleId, String actionName);

    @AStoredProcedure(name = "ui_get_mapped_role_actions_list_count")
    long getMappedRoleActionsCount(long roleId, String actionName);

    @AStoredProcedure(name = "ui_get_unmapped_role_actions_list")
    List getUnMappedRoleActions(long startFrom,
            long recordsCount, int orderFieldNumber, String orderType,
            long roleId, String actionName);

    @AStoredProcedure(name = "ui_get_unmapped_role_actions_list_count")
    int getUnMappedRoleActionsCount(long roleId, String actionName);

    @AStoredProcedure(name = "ui_change_role_actions")
    RoutineResult changeRoleActions(long roleId, String actionToAddIds,
            String actionToRemoveIds);

    @AStoredProcedure(name = "ui_get_mapped_role_groups_list")
    List getMappedRoleGroups(long startFrom,
            long recordsCount, int orderFieldNumber, String orderType,
            long roleId);

    @AStoredProcedure(name = "ui_get_mapped_role_groups_list_count")
    int getMappedRoleGroupsCount(long roleId);


    @AStoredProcedure(name = "ui_get_unmapped_role_groups_list")
    List getUnMappedRoleGroups(long startFrom,
            long recordsCount, int orderFieldNumber, String orderType,
            long roleId);
}