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 public List<ResourceTypePermission> findByEitherScopeC_G_N(
056 long companyId, long groupId, String name)
057 throws SystemException {
058
059 Session session = null;
060
061 try {
062 session = openSession();
063
064 String sql = CustomSQLUtil.get(FIND_BY_EITHER_SCOPE_C_G_N);
065
066 SQLQuery q = session.createSQLQuery(sql);
067
068 q.addEntity(
069 "ResourceTypePermission", ResourceTypePermissionImpl.class);
070
071 QueryPos qPos = QueryPos.getInstance(q);
072
073 qPos.add(companyId);
074 qPos.add(name);
075 qPos.add(groupId);
076
077 return (List<ResourceTypePermission>)QueryUtil.list(
078 q, getDialect(), QueryUtil.ALL_POS, QueryUtil.ALL_POS);
079 }
080 catch (Exception e) {
081 throw new SystemException(e);
082 }
083 finally {
084 closeSession(session);
085 }
086 }
087
088
101 public List<ResourceTypePermission> findByGroupScopeC_N_R(
102 long companyId, String name, long roleId)
103 throws SystemException {
104
105 Session session = null;
106
107 try {
108 session = openSession();
109
110 String sql = CustomSQLUtil.get(FIND_BY_GROUP_SCOPE_C_N_R);
111
112 SQLQuery q = session.createSQLQuery(sql);
113
114 q.addEntity(
115 "ResourceTypePermission", ResourceTypePermissionImpl.class);
116
117 QueryPos qPos = QueryPos.getInstance(q);
118
119 qPos.add(companyId);
120 qPos.add(name);
121 qPos.add(roleId);
122
123 return (List<ResourceTypePermission>)QueryUtil.list(
124 q, getDialect(), QueryUtil.ALL_POS, QueryUtil.ALL_POS);
125 }
126 catch (Exception e) {
127 throw new SystemException(e);
128 }
129 finally {
130 closeSession(session);
131 }
132 }
133
134 }