1
19
20 package com.liferay.portal.service.persistence;
21
22 import com.liferay.portal.SystemException;
23 import com.liferay.portal.kernel.dao.orm.QueryPos;
24 import com.liferay.portal.kernel.dao.orm.SQLQuery;
25 import com.liferay.portal.kernel.dao.orm.Session;
26 import com.liferay.portal.model.OrgGroupPermission;
27 import com.liferay.portal.model.impl.OrgGroupPermissionImpl;
28 import com.liferay.portal.service.persistence.impl.BasePersistenceImpl;
29 import com.liferay.util.dao.orm.CustomSQLUtil;
30
31 import java.util.Iterator;
32
33
40 public class OrgGroupPermissionFinderImpl
41 extends BasePersistenceImpl implements OrgGroupPermissionFinder {
42
43 public static String FIND_BY_O_G_R =
44 OrgGroupPermissionFinder.class.getName() + ".findByO_G_R";
45
46 public void removeByO_G_R(
47 long organizationId, long groupId, long resourceId)
48 throws SystemException {
49
50 Session session = null;
51
52 try {
53 session = openSession();
54
55 String sql = CustomSQLUtil.get(FIND_BY_O_G_R);
56
57 SQLQuery q = session.createSQLQuery(sql);
58
59 q.addEntity("OrgGroupPermission", OrgGroupPermissionImpl.class);
60
61 QueryPos qPos = QueryPos.getInstance(q);
62
63 qPos.add(resourceId);
64 qPos.add(organizationId);
65 qPos.add(groupId);
66
67 Iterator<OrgGroupPermission> itr = q.list().iterator();
68
69 while (itr.hasNext()) {
70 OrgGroupPermission orgGroupPermission = itr.next();
71
72 OrgGroupPermissionUtil.remove(
73 orgGroupPermission.getPrimaryKey());
74 }
75 }
76 catch (Exception e) {
77 throw new SystemException(e);
78 }
79 finally {
80 closeSession(session);
81 }
82 }
83
84 }