1
22
23 package com.liferay.portal.service.persistence;
24
25 import com.liferay.portal.SystemException;
26 import com.liferay.portal.kernel.dao.orm.QueryPos;
27 import com.liferay.portal.kernel.dao.orm.QueryUtil;
28 import com.liferay.portal.kernel.dao.orm.SQLQuery;
29 import com.liferay.portal.kernel.dao.orm.Session;
30 import com.liferay.portal.kernel.dao.orm.Type;
31 import com.liferay.portal.kernel.util.OrderByComparator;
32 import com.liferay.portal.kernel.util.StringUtil;
33 import com.liferay.portal.model.PasswordPolicy;
34 import com.liferay.portal.model.impl.PasswordPolicyImpl;
35 import com.liferay.portal.service.persistence.impl.BasePersistenceImpl;
36 import com.liferay.util.dao.orm.CustomSQLUtil;
37
38 import java.util.Iterator;
39 import java.util.List;
40
41
47 public class PasswordPolicyFinderImpl
48 extends BasePersistenceImpl implements PasswordPolicyFinder {
49
50 public static String COUNT_BY_C_N =
51 PasswordPolicyFinder.class.getName() + ".countByC_N";
52
53 public static String FIND_BY_C_N =
54 PasswordPolicyFinder.class.getName() + ".findByC_N";
55
56 public int countByC_N(long companyId, String name) throws SystemException {
57 name = StringUtil.lowerCase(name);
58
59 Session session = null;
60
61 try {
62 session = openSession();
63
64 String sql = CustomSQLUtil.get(COUNT_BY_C_N);
65
66 SQLQuery q = session.createSQLQuery(sql);
67
68 q.addScalar(COUNT_COLUMN_NAME, Type.LONG);
69
70 QueryPos qPos = QueryPos.getInstance(q);
71
72 qPos.add(companyId);
73 qPos.add(name);
74 qPos.add(name);
75
76 Iterator<Long> itr = q.list().iterator();
77
78 if (itr.hasNext()) {
79 Long count = itr.next();
80
81 if (count != null) {
82 return count.intValue();
83 }
84 }
85
86 return 0;
87 }
88 catch (Exception e) {
89 throw new SystemException(e);
90 }
91 finally {
92 closeSession(session);
93 }
94 }
95
96 public List<PasswordPolicy> findByC_N(
97 long companyId, String name, int start, int end,
98 OrderByComparator obc)
99 throws SystemException {
100
101 name = StringUtil.lowerCase(name);
102
103 Session session = null;
104
105 try {
106 session = openSession();
107
108 String sql = CustomSQLUtil.get(FIND_BY_C_N);
109
110 sql = CustomSQLUtil.replaceOrderBy(sql, obc);
111
112 SQLQuery q = session.createSQLQuery(sql);
113
114 q.addEntity("PasswordPolicy", PasswordPolicyImpl.class);
115
116 QueryPos qPos = QueryPos.getInstance(q);
117
118 qPos.add(companyId);
119 qPos.add(name);
120 qPos.add(name);
121
122 return (List<PasswordPolicy>)QueryUtil.list(
123 q, getDialect(), start, end);
124 }
125 catch (Exception e) {
126 throw new SystemException(e);
127 }
128 finally {
129 closeSession(session);
130 }
131 }
132
133 }