001
014
015 package com.liferay.portal.service.persistence;
016
017 import com.liferay.portal.kernel.dao.orm.QueryPos;
018 import com.liferay.portal.kernel.dao.orm.QueryUtil;
019 import com.liferay.portal.kernel.dao.orm.SQLQuery;
020 import com.liferay.portal.kernel.dao.orm.Session;
021 import com.liferay.portal.kernel.exception.SystemException;
022 import com.liferay.portal.model.ResourceTypePermission;
023 import com.liferay.portal.model.impl.ResourceTypePermissionImpl;
024 import com.liferay.portal.service.persistence.impl.BasePersistenceImpl;
025 import com.liferay.util.dao.orm.CustomSQLUtil;
026
027 import java.util.List;
028
029
032 public class ResourceTypePermissionFinderImpl
033 extends BasePersistenceImpl<ResourceTypePermission>
034 implements ResourceTypePermissionFinder {
035
036 public static final String FIND_BY_EITHER_SCOPE_C_G_N =
037 ResourceTypePermissionFinder.class.getName() +
038 ".findByEitherScopeC_G_N";
039
040 public static final String FIND_BY_GROUP_SCOPE_C_N_R =
041 ResourceTypePermissionFinder.class.getName() + ".findByGroupScopeC_N_R";
042
043
055 @Override
056 public List<ResourceTypePermission> findByEitherScopeC_G_N(
057 long companyId, long groupId, String name)
058 throws SystemException {
059
060 Session session = null;
061
062 try {
063 session = openSession();
064
065 String sql = CustomSQLUtil.get(FIND_BY_EITHER_SCOPE_C_G_N);
066
067 SQLQuery q = session.createSQLQuery(sql);
068
069 q.addEntity(
070 "ResourceTypePermission", ResourceTypePermissionImpl.class);
071
072 QueryPos qPos = QueryPos.getInstance(q);
073
074 qPos.add(companyId);
075 qPos.add(name);
076 qPos.add(groupId);
077
078 return (List<ResourceTypePermission>)QueryUtil.list(
079 q, getDialect(), QueryUtil.ALL_POS, QueryUtil.ALL_POS);
080 }
081 catch (Exception e) {
082 throw new SystemException(e);
083 }
084 finally {
085 closeSession(session);
086 }
087 }
088
089
102 @Override
103 public List<ResourceTypePermission> findByGroupScopeC_N_R(
104 long companyId, String name, long roleId)
105 throws SystemException {
106
107 Session session = null;
108
109 try {
110 session = openSession();
111
112 String sql = CustomSQLUtil.get(FIND_BY_GROUP_SCOPE_C_N_R);
113
114 SQLQuery q = session.createSQLQuery(sql);
115
116 q.addEntity(
117 "ResourceTypePermission", ResourceTypePermissionImpl.class);
118
119 QueryPos qPos = QueryPos.getInstance(q);
120
121 qPos.add(companyId);
122 qPos.add(name);
123 qPos.add(roleId);
124
125 return (List<ResourceTypePermission>)QueryUtil.list(
126 q, getDialect(), QueryUtil.ALL_POS, QueryUtil.ALL_POS);
127 }
128 catch (Exception e) {
129 throw new SystemException(e);
130 }
131 finally {
132 closeSession(session);
133 }
134 }
135
136 }