1   /**
2    * Copyright (c) 2000-2010 Liferay, Inc. All rights reserved.
3    *
4    * This library is free software; you can redistribute it and/or modify it under
5    * the terms of the GNU Lesser General Public License as published by the Free
6    * Software Foundation; either version 2.1 of the License, or (at your option)
7    * any later version.
8    *
9    * This library is distributed in the hope that it will be useful, but WITHOUT
10   * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
11   * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
12   * details.
13   */
14  
15  package com.liferay.portal.service.persistence;
16  
17  import com.liferay.portal.NoSuchMembershipRequestException;
18  import com.liferay.portal.NoSuchModelException;
19  import com.liferay.portal.SystemException;
20  import com.liferay.portal.kernel.annotation.BeanReference;
21  import com.liferay.portal.kernel.cache.CacheRegistry;
22  import com.liferay.portal.kernel.dao.orm.EntityCacheUtil;
23  import com.liferay.portal.kernel.dao.orm.FinderCacheUtil;
24  import com.liferay.portal.kernel.dao.orm.FinderPath;
25  import com.liferay.portal.kernel.dao.orm.Query;
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.Session;
29  import com.liferay.portal.kernel.log.Log;
30  import com.liferay.portal.kernel.log.LogFactoryUtil;
31  import com.liferay.portal.kernel.util.GetterUtil;
32  import com.liferay.portal.kernel.util.OrderByComparator;
33  import com.liferay.portal.kernel.util.StringBundler;
34  import com.liferay.portal.kernel.util.StringPool;
35  import com.liferay.portal.kernel.util.StringUtil;
36  import com.liferay.portal.model.MembershipRequest;
37  import com.liferay.portal.model.ModelListener;
38  import com.liferay.portal.model.impl.MembershipRequestImpl;
39  import com.liferay.portal.model.impl.MembershipRequestModelImpl;
40  import com.liferay.portal.service.persistence.impl.BasePersistenceImpl;
41  
42  import java.io.Serializable;
43  
44  import java.util.ArrayList;
45  import java.util.Collections;
46  import java.util.List;
47  
48  /**
49   * <a href="MembershipRequestPersistenceImpl.java.html"><b><i>View Source</i></b></a>
50   *
51   * <p>
52   * ServiceBuilder generated this class. Modifications in this class will be
53   * overwritten the next time is generated.
54   * </p>
55   *
56   * @author    Brian Wing Shun Chan
57   * @see       MembershipRequestPersistence
58   * @see       MembershipRequestUtil
59   * @generated
60   */
61  public class MembershipRequestPersistenceImpl extends BasePersistenceImpl<MembershipRequest>
62      implements MembershipRequestPersistence {
63      public static final String FINDER_CLASS_NAME_ENTITY = MembershipRequestImpl.class.getName();
64      public static final String FINDER_CLASS_NAME_LIST = FINDER_CLASS_NAME_ENTITY +
65          ".List";
66      public static final FinderPath FINDER_PATH_FIND_BY_GROUPID = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
67              MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
68              FINDER_CLASS_NAME_LIST, "findByGroupId",
69              new String[] { Long.class.getName() });
70      public static final FinderPath FINDER_PATH_FIND_BY_OBC_GROUPID = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
71              MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
72              FINDER_CLASS_NAME_LIST, "findByGroupId",
73              new String[] {
74                  Long.class.getName(),
75                  
76              "java.lang.Integer", "java.lang.Integer",
77                  "com.liferay.portal.kernel.util.OrderByComparator"
78              });
79      public static final FinderPath FINDER_PATH_COUNT_BY_GROUPID = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
80              MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
81              FINDER_CLASS_NAME_LIST, "countByGroupId",
82              new String[] { Long.class.getName() });
83      public static final FinderPath FINDER_PATH_FIND_BY_USERID = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
84              MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
85              FINDER_CLASS_NAME_LIST, "findByUserId",
86              new String[] { Long.class.getName() });
87      public static final FinderPath FINDER_PATH_FIND_BY_OBC_USERID = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
88              MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
89              FINDER_CLASS_NAME_LIST, "findByUserId",
90              new String[] {
91                  Long.class.getName(),
92                  
93              "java.lang.Integer", "java.lang.Integer",
94                  "com.liferay.portal.kernel.util.OrderByComparator"
95              });
96      public static final FinderPath FINDER_PATH_COUNT_BY_USERID = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
97              MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
98              FINDER_CLASS_NAME_LIST, "countByUserId",
99              new String[] { Long.class.getName() });
100     public static final FinderPath FINDER_PATH_FIND_BY_G_S = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
101             MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
102             FINDER_CLASS_NAME_LIST, "findByG_S",
103             new String[] { Long.class.getName(), Integer.class.getName() });
104     public static final FinderPath FINDER_PATH_FIND_BY_OBC_G_S = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
105             MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
106             FINDER_CLASS_NAME_LIST, "findByG_S",
107             new String[] {
108                 Long.class.getName(), Integer.class.getName(),
109                 
110             "java.lang.Integer", "java.lang.Integer",
111                 "com.liferay.portal.kernel.util.OrderByComparator"
112             });
113     public static final FinderPath FINDER_PATH_COUNT_BY_G_S = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
114             MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
115             FINDER_CLASS_NAME_LIST, "countByG_S",
116             new String[] { Long.class.getName(), Integer.class.getName() });
117     public static final FinderPath FINDER_PATH_FIND_ALL = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
118             MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
119             FINDER_CLASS_NAME_LIST, "findAll", new String[0]);
120     public static final FinderPath FINDER_PATH_COUNT_ALL = new FinderPath(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
121             MembershipRequestModelImpl.FINDER_CACHE_ENABLED,
122             FINDER_CLASS_NAME_LIST, "countAll", new String[0]);
123 
124     public void cacheResult(MembershipRequest membershipRequest) {
125         EntityCacheUtil.putResult(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
126             MembershipRequestImpl.class, membershipRequest.getPrimaryKey(),
127             membershipRequest);
128     }
129 
130     public void cacheResult(List<MembershipRequest> membershipRequests) {
131         for (MembershipRequest membershipRequest : membershipRequests) {
132             if (EntityCacheUtil.getResult(
133                         MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
134                         MembershipRequestImpl.class,
135                         membershipRequest.getPrimaryKey(), this) == null) {
136                 cacheResult(membershipRequest);
137             }
138         }
139     }
140 
141     public void clearCache() {
142         CacheRegistry.clear(MembershipRequestImpl.class.getName());
143         EntityCacheUtil.clearCache(MembershipRequestImpl.class.getName());
144         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_ENTITY);
145         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
146     }
147 
148     public MembershipRequest create(long membershipRequestId) {
149         MembershipRequest membershipRequest = new MembershipRequestImpl();
150 
151         membershipRequest.setNew(true);
152         membershipRequest.setPrimaryKey(membershipRequestId);
153 
154         return membershipRequest;
155     }
156 
157     public MembershipRequest remove(Serializable primaryKey)
158         throws NoSuchModelException, SystemException {
159         return remove(((Long)primaryKey).longValue());
160     }
161 
162     public MembershipRequest remove(long membershipRequestId)
163         throws NoSuchMembershipRequestException, SystemException {
164         Session session = null;
165 
166         try {
167             session = openSession();
168 
169             MembershipRequest membershipRequest = (MembershipRequest)session.get(MembershipRequestImpl.class,
170                     new Long(membershipRequestId));
171 
172             if (membershipRequest == null) {
173                 if (_log.isWarnEnabled()) {
174                     _log.warn(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
175                         membershipRequestId);
176                 }
177 
178                 throw new NoSuchMembershipRequestException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
179                     membershipRequestId);
180             }
181 
182             return remove(membershipRequest);
183         }
184         catch (NoSuchMembershipRequestException nsee) {
185             throw nsee;
186         }
187         catch (Exception e) {
188             throw processException(e);
189         }
190         finally {
191             closeSession(session);
192         }
193     }
194 
195     public MembershipRequest remove(MembershipRequest membershipRequest)
196         throws SystemException {
197         for (ModelListener<MembershipRequest> listener : listeners) {
198             listener.onBeforeRemove(membershipRequest);
199         }
200 
201         membershipRequest = removeImpl(membershipRequest);
202 
203         for (ModelListener<MembershipRequest> listener : listeners) {
204             listener.onAfterRemove(membershipRequest);
205         }
206 
207         return membershipRequest;
208     }
209 
210     protected MembershipRequest removeImpl(MembershipRequest membershipRequest)
211         throws SystemException {
212         membershipRequest = toUnwrappedModel(membershipRequest);
213 
214         Session session = null;
215 
216         try {
217             session = openSession();
218 
219             if (membershipRequest.isCachedModel() ||
220                     BatchSessionUtil.isEnabled()) {
221                 Object staleObject = session.get(MembershipRequestImpl.class,
222                         membershipRequest.getPrimaryKeyObj());
223 
224                 if (staleObject != null) {
225                     session.evict(staleObject);
226                 }
227             }
228 
229             session.delete(membershipRequest);
230 
231             session.flush();
232         }
233         catch (Exception e) {
234             throw processException(e);
235         }
236         finally {
237             closeSession(session);
238         }
239 
240         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
241 
242         EntityCacheUtil.removeResult(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
243             MembershipRequestImpl.class, membershipRequest.getPrimaryKey());
244 
245         return membershipRequest;
246     }
247 
248     /**
249      * @deprecated Use {@link BasePersistence#update(com.liferay.portal.model.BaseModel, boolean)}.
250      */
251     public MembershipRequest update(MembershipRequest membershipRequest)
252         throws SystemException {
253         if (_log.isWarnEnabled()) {
254             _log.warn(
255                 "Using the deprecated update(MembershipRequest membershipRequest) method. Use update(MembershipRequest membershipRequest, boolean merge) instead.");
256         }
257 
258         return update(membershipRequest, false);
259     }
260 
261     public MembershipRequest updateImpl(
262         com.liferay.portal.model.MembershipRequest membershipRequest,
263         boolean merge) throws SystemException {
264         membershipRequest = toUnwrappedModel(membershipRequest);
265 
266         Session session = null;
267 
268         try {
269             session = openSession();
270 
271             BatchSessionUtil.update(session, membershipRequest, merge);
272 
273             membershipRequest.setNew(false);
274         }
275         catch (Exception e) {
276             throw processException(e);
277         }
278         finally {
279             closeSession(session);
280         }
281 
282         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
283 
284         EntityCacheUtil.putResult(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
285             MembershipRequestImpl.class, membershipRequest.getPrimaryKey(),
286             membershipRequest);
287 
288         return membershipRequest;
289     }
290 
291     protected MembershipRequest toUnwrappedModel(
292         MembershipRequest membershipRequest) {
293         if (membershipRequest instanceof MembershipRequestImpl) {
294             return membershipRequest;
295         }
296 
297         MembershipRequestImpl membershipRequestImpl = new MembershipRequestImpl();
298 
299         membershipRequestImpl.setNew(membershipRequest.isNew());
300         membershipRequestImpl.setPrimaryKey(membershipRequest.getPrimaryKey());
301 
302         membershipRequestImpl.setMembershipRequestId(membershipRequest.getMembershipRequestId());
303         membershipRequestImpl.setCompanyId(membershipRequest.getCompanyId());
304         membershipRequestImpl.setUserId(membershipRequest.getUserId());
305         membershipRequestImpl.setCreateDate(membershipRequest.getCreateDate());
306         membershipRequestImpl.setGroupId(membershipRequest.getGroupId());
307         membershipRequestImpl.setComments(membershipRequest.getComments());
308         membershipRequestImpl.setReplyComments(membershipRequest.getReplyComments());
309         membershipRequestImpl.setReplyDate(membershipRequest.getReplyDate());
310         membershipRequestImpl.setReplierUserId(membershipRequest.getReplierUserId());
311         membershipRequestImpl.setStatusId(membershipRequest.getStatusId());
312 
313         return membershipRequestImpl;
314     }
315 
316     public MembershipRequest findByPrimaryKey(Serializable primaryKey)
317         throws NoSuchModelException, SystemException {
318         return findByPrimaryKey(((Long)primaryKey).longValue());
319     }
320 
321     public MembershipRequest findByPrimaryKey(long membershipRequestId)
322         throws NoSuchMembershipRequestException, SystemException {
323         MembershipRequest membershipRequest = fetchByPrimaryKey(membershipRequestId);
324 
325         if (membershipRequest == null) {
326             if (_log.isWarnEnabled()) {
327                 _log.warn(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
328                     membershipRequestId);
329             }
330 
331             throw new NoSuchMembershipRequestException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
332                 membershipRequestId);
333         }
334 
335         return membershipRequest;
336     }
337 
338     public MembershipRequest fetchByPrimaryKey(Serializable primaryKey)
339         throws SystemException {
340         return fetchByPrimaryKey(((Long)primaryKey).longValue());
341     }
342 
343     public MembershipRequest fetchByPrimaryKey(long membershipRequestId)
344         throws SystemException {
345         MembershipRequest membershipRequest = (MembershipRequest)EntityCacheUtil.getResult(MembershipRequestModelImpl.ENTITY_CACHE_ENABLED,
346                 MembershipRequestImpl.class, membershipRequestId, this);
347 
348         if (membershipRequest == null) {
349             Session session = null;
350 
351             try {
352                 session = openSession();
353 
354                 membershipRequest = (MembershipRequest)session.get(MembershipRequestImpl.class,
355                         new Long(membershipRequestId));
356             }
357             catch (Exception e) {
358                 throw processException(e);
359             }
360             finally {
361                 if (membershipRequest != null) {
362                     cacheResult(membershipRequest);
363                 }
364 
365                 closeSession(session);
366             }
367         }
368 
369         return membershipRequest;
370     }
371 
372     public List<MembershipRequest> findByGroupId(long groupId)
373         throws SystemException {
374         Object[] finderArgs = new Object[] { new Long(groupId) };
375 
376         List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_GROUPID,
377                 finderArgs, this);
378 
379         if (list == null) {
380             Session session = null;
381 
382             try {
383                 session = openSession();
384 
385                 StringBundler query = new StringBundler(3);
386 
387                 query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
388 
389                 query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
390 
391                 query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
392 
393                 String sql = query.toString();
394 
395                 Query q = session.createQuery(sql);
396 
397                 QueryPos qPos = QueryPos.getInstance(q);
398 
399                 qPos.add(groupId);
400 
401                 list = q.list();
402             }
403             catch (Exception e) {
404                 throw processException(e);
405             }
406             finally {
407                 if (list == null) {
408                     list = new ArrayList<MembershipRequest>();
409                 }
410 
411                 cacheResult(list);
412 
413                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_GROUPID,
414                     finderArgs, list);
415 
416                 closeSession(session);
417             }
418         }
419 
420         return list;
421     }
422 
423     public List<MembershipRequest> findByGroupId(long groupId, int start,
424         int end) throws SystemException {
425         return findByGroupId(groupId, start, end, null);
426     }
427 
428     public List<MembershipRequest> findByGroupId(long groupId, int start,
429         int end, OrderByComparator orderByComparator) throws SystemException {
430         Object[] finderArgs = new Object[] {
431                 new Long(groupId),
432                 
433                 String.valueOf(start), String.valueOf(end),
434                 String.valueOf(orderByComparator)
435             };
436 
437         List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_GROUPID,
438                 finderArgs, this);
439 
440         if (list == null) {
441             Session session = null;
442 
443             try {
444                 session = openSession();
445 
446                 StringBundler query = null;
447 
448                 if (orderByComparator != null) {
449                     query = new StringBundler(3 +
450                             (orderByComparator.getOrderByFields().length * 3));
451                 }
452                 else {
453                     query = new StringBundler(3);
454                 }
455 
456                 query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
457 
458                 query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
459 
460                 if (orderByComparator != null) {
461                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
462                         orderByComparator);
463                 }
464 
465                 else {
466                     query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
467                 }
468 
469                 String sql = query.toString();
470 
471                 Query q = session.createQuery(sql);
472 
473                 QueryPos qPos = QueryPos.getInstance(q);
474 
475                 qPos.add(groupId);
476 
477                 list = (List<MembershipRequest>)QueryUtil.list(q, getDialect(),
478                         start, end);
479             }
480             catch (Exception e) {
481                 throw processException(e);
482             }
483             finally {
484                 if (list == null) {
485                     list = new ArrayList<MembershipRequest>();
486                 }
487 
488                 cacheResult(list);
489 
490                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_GROUPID,
491                     finderArgs, list);
492 
493                 closeSession(session);
494             }
495         }
496 
497         return list;
498     }
499 
500     public MembershipRequest findByGroupId_First(long groupId,
501         OrderByComparator orderByComparator)
502         throws NoSuchMembershipRequestException, SystemException {
503         List<MembershipRequest> list = findByGroupId(groupId, 0, 1,
504                 orderByComparator);
505 
506         if (list.isEmpty()) {
507             StringBundler msg = new StringBundler(4);
508 
509             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
510 
511             msg.append("groupId=");
512             msg.append(groupId);
513 
514             msg.append(StringPool.CLOSE_CURLY_BRACE);
515 
516             throw new NoSuchMembershipRequestException(msg.toString());
517         }
518         else {
519             return list.get(0);
520         }
521     }
522 
523     public MembershipRequest findByGroupId_Last(long groupId,
524         OrderByComparator orderByComparator)
525         throws NoSuchMembershipRequestException, SystemException {
526         int count = countByGroupId(groupId);
527 
528         List<MembershipRequest> list = findByGroupId(groupId, count - 1, count,
529                 orderByComparator);
530 
531         if (list.isEmpty()) {
532             StringBundler msg = new StringBundler(4);
533 
534             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
535 
536             msg.append("groupId=");
537             msg.append(groupId);
538 
539             msg.append(StringPool.CLOSE_CURLY_BRACE);
540 
541             throw new NoSuchMembershipRequestException(msg.toString());
542         }
543         else {
544             return list.get(0);
545         }
546     }
547 
548     public MembershipRequest[] findByGroupId_PrevAndNext(
549         long membershipRequestId, long groupId,
550         OrderByComparator orderByComparator)
551         throws NoSuchMembershipRequestException, SystemException {
552         MembershipRequest membershipRequest = findByPrimaryKey(membershipRequestId);
553 
554         int count = countByGroupId(groupId);
555 
556         Session session = null;
557 
558         try {
559             session = openSession();
560 
561             StringBundler query = null;
562 
563             if (orderByComparator != null) {
564                 query = new StringBundler(3 +
565                         (orderByComparator.getOrderByFields().length * 3));
566             }
567             else {
568                 query = new StringBundler(3);
569             }
570 
571             query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
572 
573             query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
574 
575             if (orderByComparator != null) {
576                 appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
577                     orderByComparator);
578             }
579 
580             else {
581                 query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
582             }
583 
584             String sql = query.toString();
585 
586             Query q = session.createQuery(sql);
587 
588             QueryPos qPos = QueryPos.getInstance(q);
589 
590             qPos.add(groupId);
591 
592             Object[] objArray = QueryUtil.getPrevAndNext(q, count,
593                     orderByComparator, membershipRequest);
594 
595             MembershipRequest[] array = new MembershipRequestImpl[3];
596 
597             array[0] = (MembershipRequest)objArray[0];
598             array[1] = (MembershipRequest)objArray[1];
599             array[2] = (MembershipRequest)objArray[2];
600 
601             return array;
602         }
603         catch (Exception e) {
604             throw processException(e);
605         }
606         finally {
607             closeSession(session);
608         }
609     }
610 
611     public List<MembershipRequest> findByUserId(long userId)
612         throws SystemException {
613         Object[] finderArgs = new Object[] { new Long(userId) };
614 
615         List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_USERID,
616                 finderArgs, this);
617 
618         if (list == null) {
619             Session session = null;
620 
621             try {
622                 session = openSession();
623 
624                 StringBundler query = new StringBundler(3);
625 
626                 query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
627 
628                 query.append(_FINDER_COLUMN_USERID_USERID_2);
629 
630                 query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
631 
632                 String sql = query.toString();
633 
634                 Query q = session.createQuery(sql);
635 
636                 QueryPos qPos = QueryPos.getInstance(q);
637 
638                 qPos.add(userId);
639 
640                 list = q.list();
641             }
642             catch (Exception e) {
643                 throw processException(e);
644             }
645             finally {
646                 if (list == null) {
647                     list = new ArrayList<MembershipRequest>();
648                 }
649 
650                 cacheResult(list);
651 
652                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_USERID,
653                     finderArgs, list);
654 
655                 closeSession(session);
656             }
657         }
658 
659         return list;
660     }
661 
662     public List<MembershipRequest> findByUserId(long userId, int start, int end)
663         throws SystemException {
664         return findByUserId(userId, start, end, null);
665     }
666 
667     public List<MembershipRequest> findByUserId(long userId, int start,
668         int end, OrderByComparator orderByComparator) throws SystemException {
669         Object[] finderArgs = new Object[] {
670                 new Long(userId),
671                 
672                 String.valueOf(start), String.valueOf(end),
673                 String.valueOf(orderByComparator)
674             };
675 
676         List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_USERID,
677                 finderArgs, this);
678 
679         if (list == null) {
680             Session session = null;
681 
682             try {
683                 session = openSession();
684 
685                 StringBundler query = null;
686 
687                 if (orderByComparator != null) {
688                     query = new StringBundler(3 +
689                             (orderByComparator.getOrderByFields().length * 3));
690                 }
691                 else {
692                     query = new StringBundler(3);
693                 }
694 
695                 query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
696 
697                 query.append(_FINDER_COLUMN_USERID_USERID_2);
698 
699                 if (orderByComparator != null) {
700                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
701                         orderByComparator);
702                 }
703 
704                 else {
705                     query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
706                 }
707 
708                 String sql = query.toString();
709 
710                 Query q = session.createQuery(sql);
711 
712                 QueryPos qPos = QueryPos.getInstance(q);
713 
714                 qPos.add(userId);
715 
716                 list = (List<MembershipRequest>)QueryUtil.list(q, getDialect(),
717                         start, end);
718             }
719             catch (Exception e) {
720                 throw processException(e);
721             }
722             finally {
723                 if (list == null) {
724                     list = new ArrayList<MembershipRequest>();
725                 }
726 
727                 cacheResult(list);
728 
729                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_USERID,
730                     finderArgs, list);
731 
732                 closeSession(session);
733             }
734         }
735 
736         return list;
737     }
738 
739     public MembershipRequest findByUserId_First(long userId,
740         OrderByComparator orderByComparator)
741         throws NoSuchMembershipRequestException, SystemException {
742         List<MembershipRequest> list = findByUserId(userId, 0, 1,
743                 orderByComparator);
744 
745         if (list.isEmpty()) {
746             StringBundler msg = new StringBundler(4);
747 
748             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
749 
750             msg.append("userId=");
751             msg.append(userId);
752 
753             msg.append(StringPool.CLOSE_CURLY_BRACE);
754 
755             throw new NoSuchMembershipRequestException(msg.toString());
756         }
757         else {
758             return list.get(0);
759         }
760     }
761 
762     public MembershipRequest findByUserId_Last(long userId,
763         OrderByComparator orderByComparator)
764         throws NoSuchMembershipRequestException, SystemException {
765         int count = countByUserId(userId);
766 
767         List<MembershipRequest> list = findByUserId(userId, count - 1, count,
768                 orderByComparator);
769 
770         if (list.isEmpty()) {
771             StringBundler msg = new StringBundler(4);
772 
773             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
774 
775             msg.append("userId=");
776             msg.append(userId);
777 
778             msg.append(StringPool.CLOSE_CURLY_BRACE);
779 
780             throw new NoSuchMembershipRequestException(msg.toString());
781         }
782         else {
783             return list.get(0);
784         }
785     }
786 
787     public MembershipRequest[] findByUserId_PrevAndNext(
788         long membershipRequestId, long userId,
789         OrderByComparator orderByComparator)
790         throws NoSuchMembershipRequestException, SystemException {
791         MembershipRequest membershipRequest = findByPrimaryKey(membershipRequestId);
792 
793         int count = countByUserId(userId);
794 
795         Session session = null;
796 
797         try {
798             session = openSession();
799 
800             StringBundler query = null;
801 
802             if (orderByComparator != null) {
803                 query = new StringBundler(3 +
804                         (orderByComparator.getOrderByFields().length * 3));
805             }
806             else {
807                 query = new StringBundler(3);
808             }
809 
810             query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
811 
812             query.append(_FINDER_COLUMN_USERID_USERID_2);
813 
814             if (orderByComparator != null) {
815                 appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
816                     orderByComparator);
817             }
818 
819             else {
820                 query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
821             }
822 
823             String sql = query.toString();
824 
825             Query q = session.createQuery(sql);
826 
827             QueryPos qPos = QueryPos.getInstance(q);
828 
829             qPos.add(userId);
830 
831             Object[] objArray = QueryUtil.getPrevAndNext(q, count,
832                     orderByComparator, membershipRequest);
833 
834             MembershipRequest[] array = new MembershipRequestImpl[3];
835 
836             array[0] = (MembershipRequest)objArray[0];
837             array[1] = (MembershipRequest)objArray[1];
838             array[2] = (MembershipRequest)objArray[2];
839 
840             return array;
841         }
842         catch (Exception e) {
843             throw processException(e);
844         }
845         finally {
846             closeSession(session);
847         }
848     }
849 
850     public List<MembershipRequest> findByG_S(long groupId, int statusId)
851         throws SystemException {
852         Object[] finderArgs = new Object[] {
853                 new Long(groupId), new Integer(statusId)
854             };
855 
856         List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_G_S,
857                 finderArgs, this);
858 
859         if (list == null) {
860             Session session = null;
861 
862             try {
863                 session = openSession();
864 
865                 StringBundler query = new StringBundler(4);
866 
867                 query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
868 
869                 query.append(_FINDER_COLUMN_G_S_GROUPID_2);
870 
871                 query.append(_FINDER_COLUMN_G_S_STATUSID_2);
872 
873                 query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
874 
875                 String sql = query.toString();
876 
877                 Query q = session.createQuery(sql);
878 
879                 QueryPos qPos = QueryPos.getInstance(q);
880 
881                 qPos.add(groupId);
882 
883                 qPos.add(statusId);
884 
885                 list = q.list();
886             }
887             catch (Exception e) {
888                 throw processException(e);
889             }
890             finally {
891                 if (list == null) {
892                     list = new ArrayList<MembershipRequest>();
893                 }
894 
895                 cacheResult(list);
896 
897                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_G_S, finderArgs,
898                     list);
899 
900                 closeSession(session);
901             }
902         }
903 
904         return list;
905     }
906 
907     public List<MembershipRequest> findByG_S(long groupId, int statusId,
908         int start, int end) throws SystemException {
909         return findByG_S(groupId, statusId, start, end, null);
910     }
911 
912     public List<MembershipRequest> findByG_S(long groupId, int statusId,
913         int start, int end, OrderByComparator orderByComparator)
914         throws SystemException {
915         Object[] finderArgs = new Object[] {
916                 new Long(groupId), new Integer(statusId),
917                 
918                 String.valueOf(start), String.valueOf(end),
919                 String.valueOf(orderByComparator)
920             };
921 
922         List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_G_S,
923                 finderArgs, this);
924 
925         if (list == null) {
926             Session session = null;
927 
928             try {
929                 session = openSession();
930 
931                 StringBundler query = null;
932 
933                 if (orderByComparator != null) {
934                     query = new StringBundler(4 +
935                             (orderByComparator.getOrderByFields().length * 3));
936                 }
937                 else {
938                     query = new StringBundler(4);
939                 }
940 
941                 query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
942 
943                 query.append(_FINDER_COLUMN_G_S_GROUPID_2);
944 
945                 query.append(_FINDER_COLUMN_G_S_STATUSID_2);
946 
947                 if (orderByComparator != null) {
948                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
949                         orderByComparator);
950                 }
951 
952                 else {
953                     query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
954                 }
955 
956                 String sql = query.toString();
957 
958                 Query q = session.createQuery(sql);
959 
960                 QueryPos qPos = QueryPos.getInstance(q);
961 
962                 qPos.add(groupId);
963 
964                 qPos.add(statusId);
965 
966                 list = (List<MembershipRequest>)QueryUtil.list(q, getDialect(),
967                         start, end);
968             }
969             catch (Exception e) {
970                 throw processException(e);
971             }
972             finally {
973                 if (list == null) {
974                     list = new ArrayList<MembershipRequest>();
975                 }
976 
977                 cacheResult(list);
978 
979                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_G_S,
980                     finderArgs, list);
981 
982                 closeSession(session);
983             }
984         }
985 
986         return list;
987     }
988 
989     public MembershipRequest findByG_S_First(long groupId, int statusId,
990         OrderByComparator orderByComparator)
991         throws NoSuchMembershipRequestException, SystemException {
992         List<MembershipRequest> list = findByG_S(groupId, statusId, 0, 1,
993                 orderByComparator);
994 
995         if (list.isEmpty()) {
996             StringBundler msg = new StringBundler(6);
997 
998             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
999 
1000            msg.append("groupId=");
1001            msg.append(groupId);
1002
1003            msg.append(", statusId=");
1004            msg.append(statusId);
1005
1006            msg.append(StringPool.CLOSE_CURLY_BRACE);
1007
1008            throw new NoSuchMembershipRequestException(msg.toString());
1009        }
1010        else {
1011            return list.get(0);
1012        }
1013    }
1014
1015    public MembershipRequest findByG_S_Last(long groupId, int statusId,
1016        OrderByComparator orderByComparator)
1017        throws NoSuchMembershipRequestException, SystemException {
1018        int count = countByG_S(groupId, statusId);
1019
1020        List<MembershipRequest> list = findByG_S(groupId, statusId, count - 1,
1021                count, orderByComparator);
1022
1023        if (list.isEmpty()) {
1024            StringBundler msg = new StringBundler(6);
1025
1026            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1027
1028            msg.append("groupId=");
1029            msg.append(groupId);
1030
1031            msg.append(", statusId=");
1032            msg.append(statusId);
1033
1034            msg.append(StringPool.CLOSE_CURLY_BRACE);
1035
1036            throw new NoSuchMembershipRequestException(msg.toString());
1037        }
1038        else {
1039            return list.get(0);
1040        }
1041    }
1042
1043    public MembershipRequest[] findByG_S_PrevAndNext(long membershipRequestId,
1044        long groupId, int statusId, OrderByComparator orderByComparator)
1045        throws NoSuchMembershipRequestException, SystemException {
1046        MembershipRequest membershipRequest = findByPrimaryKey(membershipRequestId);
1047
1048        int count = countByG_S(groupId, statusId);
1049
1050        Session session = null;
1051
1052        try {
1053            session = openSession();
1054
1055            StringBundler query = null;
1056
1057            if (orderByComparator != null) {
1058                query = new StringBundler(4 +
1059                        (orderByComparator.getOrderByFields().length * 3));
1060            }
1061            else {
1062                query = new StringBundler(4);
1063            }
1064
1065            query.append(_SQL_SELECT_MEMBERSHIPREQUEST_WHERE);
1066
1067            query.append(_FINDER_COLUMN_G_S_GROUPID_2);
1068
1069            query.append(_FINDER_COLUMN_G_S_STATUSID_2);
1070
1071            if (orderByComparator != null) {
1072                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
1073                    orderByComparator);
1074            }
1075
1076            else {
1077                query.append(MembershipRequestModelImpl.ORDER_BY_JPQL);
1078            }
1079
1080            String sql = query.toString();
1081
1082            Query q = session.createQuery(sql);
1083
1084            QueryPos qPos = QueryPos.getInstance(q);
1085
1086            qPos.add(groupId);
1087
1088            qPos.add(statusId);
1089
1090            Object[] objArray = QueryUtil.getPrevAndNext(q, count,
1091                    orderByComparator, membershipRequest);
1092
1093            MembershipRequest[] array = new MembershipRequestImpl[3];
1094
1095            array[0] = (MembershipRequest)objArray[0];
1096            array[1] = (MembershipRequest)objArray[1];
1097            array[2] = (MembershipRequest)objArray[2];
1098
1099            return array;
1100        }
1101        catch (Exception e) {
1102            throw processException(e);
1103        }
1104        finally {
1105            closeSession(session);
1106        }
1107    }
1108
1109    public List<MembershipRequest> findAll() throws SystemException {
1110        return findAll(QueryUtil.ALL_POS, QueryUtil.ALL_POS, null);
1111    }
1112
1113    public List<MembershipRequest> findAll(int start, int end)
1114        throws SystemException {
1115        return findAll(start, end, null);
1116    }
1117
1118    public List<MembershipRequest> findAll(int start, int end,
1119        OrderByComparator orderByComparator) throws SystemException {
1120        Object[] finderArgs = new Object[] {
1121                String.valueOf(start), String.valueOf(end),
1122                String.valueOf(orderByComparator)
1123            };
1124
1125        List<MembershipRequest> list = (List<MembershipRequest>)FinderCacheUtil.getResult(FINDER_PATH_FIND_ALL,
1126                finderArgs, this);
1127
1128        if (list == null) {
1129            Session session = null;
1130
1131            try {
1132                session = openSession();
1133
1134                StringBundler query = null;
1135                String sql = null;
1136
1137                if (orderByComparator != null) {
1138                    query = new StringBundler(2 +
1139                            (orderByComparator.getOrderByFields().length * 3));
1140
1141                    query.append(_SQL_SELECT_MEMBERSHIPREQUEST);
1142
1143                    appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
1144                        orderByComparator);
1145
1146                    sql = query.toString();
1147                }
1148
1149                else {
1150                    sql = _SQL_SELECT_MEMBERSHIPREQUEST.concat(MembershipRequestModelImpl.ORDER_BY_JPQL);
1151                }
1152
1153                Query q = session.createQuery(sql);
1154
1155                if (orderByComparator == null) {
1156                    list = (List<MembershipRequest>)QueryUtil.list(q,
1157                            getDialect(), start, end, false);
1158
1159                    Collections.sort(list);
1160                }
1161                else {
1162                    list = (List<MembershipRequest>)QueryUtil.list(q,
1163                            getDialect(), start, end);
1164                }
1165            }
1166            catch (Exception e) {
1167                throw processException(e);
1168            }
1169            finally {
1170                if (list == null) {
1171                    list = new ArrayList<MembershipRequest>();
1172                }
1173
1174                cacheResult(list);
1175
1176                FinderCacheUtil.putResult(FINDER_PATH_FIND_ALL, finderArgs, list);
1177
1178                closeSession(session);
1179            }
1180        }
1181
1182        return list;
1183    }
1184
1185    public void removeByGroupId(long groupId) throws SystemException {
1186        for (MembershipRequest membershipRequest : findByGroupId(groupId)) {
1187            remove(membershipRequest);
1188        }
1189    }
1190
1191    public void removeByUserId(long userId) throws SystemException {
1192        for (MembershipRequest membershipRequest : findByUserId(userId)) {
1193            remove(membershipRequest);
1194        }
1195    }
1196
1197    public void removeByG_S(long groupId, int statusId)
1198        throws SystemException {
1199        for (MembershipRequest membershipRequest : findByG_S(groupId, statusId)) {
1200            remove(membershipRequest);
1201        }
1202    }
1203
1204    public void removeAll() throws SystemException {
1205        for (MembershipRequest membershipRequest : findAll()) {
1206            remove(membershipRequest);
1207        }
1208    }
1209
1210    public int countByGroupId(long groupId) throws SystemException {
1211        Object[] finderArgs = new Object[] { new Long(groupId) };
1212
1213        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_GROUPID,
1214                finderArgs, this);
1215
1216        if (count == null) {
1217            Session session = null;
1218
1219            try {
1220                session = openSession();
1221
1222                StringBundler query = new StringBundler(2);
1223
1224                query.append(_SQL_COUNT_MEMBERSHIPREQUEST_WHERE);
1225
1226                query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
1227
1228                String sql = query.toString();
1229
1230                Query q = session.createQuery(sql);
1231
1232                QueryPos qPos = QueryPos.getInstance(q);
1233
1234                qPos.add(groupId);
1235
1236                count = (Long)q.uniqueResult();
1237            }
1238            catch (Exception e) {
1239                throw processException(e);
1240            }
1241            finally {
1242                if (count == null) {
1243                    count = Long.valueOf(0);
1244                }
1245
1246                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_GROUPID,
1247                    finderArgs, count);
1248
1249                closeSession(session);
1250            }
1251        }
1252
1253        return count.intValue();
1254    }
1255
1256    public int countByUserId(long userId) throws SystemException {
1257        Object[] finderArgs = new Object[] { new Long(userId) };
1258
1259        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_USERID,
1260                finderArgs, this);
1261
1262        if (count == null) {
1263            Session session = null;
1264
1265            try {
1266                session = openSession();
1267
1268                StringBundler query = new StringBundler(2);
1269
1270                query.append(_SQL_COUNT_MEMBERSHIPREQUEST_WHERE);
1271
1272                query.append(_FINDER_COLUMN_USERID_USERID_2);
1273
1274                String sql = query.toString();
1275
1276                Query q = session.createQuery(sql);
1277
1278                QueryPos qPos = QueryPos.getInstance(q);
1279
1280                qPos.add(userId);
1281
1282                count = (Long)q.uniqueResult();
1283            }
1284            catch (Exception e) {
1285                throw processException(e);
1286            }
1287            finally {
1288                if (count == null) {
1289                    count = Long.valueOf(0);
1290                }
1291
1292                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_USERID,
1293                    finderArgs, count);
1294
1295                closeSession(session);
1296            }
1297        }
1298
1299        return count.intValue();
1300    }
1301
1302    public int countByG_S(long groupId, int statusId) throws SystemException {
1303        Object[] finderArgs = new Object[] {
1304                new Long(groupId), new Integer(statusId)
1305            };
1306
1307        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_G_S,
1308                finderArgs, this);
1309
1310        if (count == null) {
1311            Session session = null;
1312
1313            try {
1314                session = openSession();
1315
1316                StringBundler query = new StringBundler(3);
1317
1318                query.append(_SQL_COUNT_MEMBERSHIPREQUEST_WHERE);
1319
1320                query.append(_FINDER_COLUMN_G_S_GROUPID_2);
1321
1322                query.append(_FINDER_COLUMN_G_S_STATUSID_2);
1323
1324                String sql = query.toString();
1325
1326                Query q = session.createQuery(sql);
1327
1328                QueryPos qPos = QueryPos.getInstance(q);
1329
1330                qPos.add(groupId);
1331
1332                qPos.add(statusId);
1333
1334                count = (Long)q.uniqueResult();
1335            }
1336            catch (Exception e) {
1337                throw processException(e);
1338            }
1339            finally {
1340                if (count == null) {
1341                    count = Long.valueOf(0);
1342                }
1343
1344                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_G_S, finderArgs,
1345                    count);
1346
1347                closeSession(session);
1348            }
1349        }
1350
1351        return count.intValue();
1352    }
1353
1354    public int countAll() throws SystemException {
1355        Object[] finderArgs = new Object[0];
1356
1357        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL,
1358                finderArgs, this);
1359
1360        if (count == null) {
1361            Session session = null;
1362
1363            try {
1364                session = openSession();
1365
1366                Query q = session.createQuery(_SQL_COUNT_MEMBERSHIPREQUEST);
1367
1368                count = (Long)q.uniqueResult();
1369            }
1370            catch (Exception e) {
1371                throw processException(e);
1372            }
1373            finally {
1374                if (count == null) {
1375                    count = Long.valueOf(0);
1376                }
1377
1378                FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, finderArgs,
1379                    count);
1380
1381                closeSession(session);
1382            }
1383        }
1384
1385        return count.intValue();
1386    }
1387
1388    public void afterPropertiesSet() {
1389        String[] listenerClassNames = StringUtil.split(GetterUtil.getString(
1390                    com.liferay.portal.util.PropsUtil.get(
1391                        "value.object.listener.com.liferay.portal.model.MembershipRequest")));
1392
1393        if (listenerClassNames.length > 0) {
1394            try {
1395                List<ModelListener<MembershipRequest>> listenersList = new ArrayList<ModelListener<MembershipRequest>>();
1396
1397                for (String listenerClassName : listenerClassNames) {
1398                    listenersList.add((ModelListener<MembershipRequest>)Class.forName(
1399                            listenerClassName).newInstance());
1400                }
1401
1402                listeners = listenersList.toArray(new ModelListener[listenersList.size()]);
1403            }
1404            catch (Exception e) {
1405                _log.error(e);
1406            }
1407        }
1408    }
1409
1410    @BeanReference(type = AccountPersistence.class)
1411    protected AccountPersistence accountPersistence;
1412    @BeanReference(type = AddressPersistence.class)
1413    protected AddressPersistence addressPersistence;
1414    @BeanReference(type = BrowserTrackerPersistence.class)
1415    protected BrowserTrackerPersistence browserTrackerPersistence;
1416    @BeanReference(type = ClassNamePersistence.class)
1417    protected ClassNamePersistence classNamePersistence;
1418    @BeanReference(type = CompanyPersistence.class)
1419    protected CompanyPersistence companyPersistence;
1420    @BeanReference(type = ContactPersistence.class)
1421    protected ContactPersistence contactPersistence;
1422    @BeanReference(type = CountryPersistence.class)
1423    protected CountryPersistence countryPersistence;
1424    @BeanReference(type = EmailAddressPersistence.class)
1425    protected EmailAddressPersistence emailAddressPersistence;
1426    @BeanReference(type = GroupPersistence.class)
1427    protected GroupPersistence groupPersistence;
1428    @BeanReference(type = ImagePersistence.class)
1429    protected ImagePersistence imagePersistence;
1430    @BeanReference(type = LayoutPersistence.class)
1431    protected LayoutPersistence layoutPersistence;
1432    @BeanReference(type = LayoutSetPersistence.class)
1433    protected LayoutSetPersistence layoutSetPersistence;
1434    @BeanReference(type = ListTypePersistence.class)
1435    protected ListTypePersistence listTypePersistence;
1436    @BeanReference(type = LockPersistence.class)
1437    protected LockPersistence lockPersistence;
1438    @BeanReference(type = MembershipRequestPersistence.class)
1439    protected MembershipRequestPersistence membershipRequestPersistence;
1440    @BeanReference(type = OrganizationPersistence.class)
1441    protected OrganizationPersistence organizationPersistence;
1442    @BeanReference(type = OrgGroupPermissionPersistence.class)
1443    protected OrgGroupPermissionPersistence orgGroupPermissionPersistence;
1444    @BeanReference(type = OrgGroupRolePersistence.class)
1445    protected OrgGroupRolePersistence orgGroupRolePersistence;
1446    @BeanReference(type = OrgLaborPersistence.class)
1447    protected OrgLaborPersistence orgLaborPersistence;
1448    @BeanReference(type = PasswordPolicyPersistence.class)
1449    protected PasswordPolicyPersistence passwordPolicyPersistence;
1450    @BeanReference(type = PasswordPolicyRelPersistence.class)
1451    protected PasswordPolicyRelPersistence passwordPolicyRelPersistence;
1452    @BeanReference(type = PasswordTrackerPersistence.class)
1453    protected PasswordTrackerPersistence passwordTrackerPersistence;
1454    @BeanReference(type = PermissionPersistence.class)
1455    protected PermissionPersistence permissionPersistence;
1456    @BeanReference(type = PhonePersistence.class)
1457    protected PhonePersistence phonePersistence;
1458    @BeanReference(type = PluginSettingPersistence.class)
1459    protected PluginSettingPersistence pluginSettingPersistence;
1460    @BeanReference(type = PortletPersistence.class)
1461    protected PortletPersistence portletPersistence;
1462    @BeanReference(type = PortletItemPersistence.class)
1463    protected PortletItemPersistence portletItemPersistence;
1464    @BeanReference(type = PortletPreferencesPersistence.class)
1465    protected PortletPreferencesPersistence portletPreferencesPersistence;
1466    @BeanReference(type = RegionPersistence.class)
1467    protected RegionPersistence regionPersistence;
1468    @BeanReference(type = ReleasePersistence.class)
1469    protected ReleasePersistence releasePersistence;
1470    @BeanReference(type = ResourcePersistence.class)
1471    protected ResourcePersistence resourcePersistence;
1472    @BeanReference(type = ResourceActionPersistence.class)
1473    protected ResourceActionPersistence resourceActionPersistence;
1474    @BeanReference(type = ResourceCodePersistence.class)
1475    protected ResourceCodePersistence resourceCodePersistence;
1476    @BeanReference(type = ResourcePermissionPersistence.class)
1477    protected ResourcePermissionPersistence resourcePermissionPersistence;
1478    @BeanReference(type = RolePersistence.class)
1479    protected RolePersistence rolePersistence;
1480    @BeanReference(type = ServiceComponentPersistence.class)
1481    protected ServiceComponentPersistence serviceComponentPersistence;
1482    @BeanReference(type = ShardPersistence.class)
1483    protected ShardPersistence shardPersistence;
1484    @BeanReference(type = SubscriptionPersistence.class)
1485    protected SubscriptionPersistence subscriptionPersistence;
1486    @BeanReference(type = UserPersistence.class)
1487    protected UserPersistence userPersistence;
1488    @BeanReference(type = UserGroupPersistence.class)
1489    protected UserGroupPersistence userGroupPersistence;
1490    @BeanReference(type = UserGroupGroupRolePersistence.class)
1491    protected UserGroupGroupRolePersistence userGroupGroupRolePersistence;
1492    @BeanReference(type = UserGroupRolePersistence.class)
1493    protected UserGroupRolePersistence userGroupRolePersistence;
1494    @BeanReference(type = UserIdMapperPersistence.class)
1495    protected UserIdMapperPersistence userIdMapperPersistence;
1496    @BeanReference(type = UserTrackerPersistence.class)
1497    protected UserTrackerPersistence userTrackerPersistence;
1498    @BeanReference(type = UserTrackerPathPersistence.class)
1499    protected UserTrackerPathPersistence userTrackerPathPersistence;
1500    @BeanReference(type = WebDAVPropsPersistence.class)
1501    protected WebDAVPropsPersistence webDAVPropsPersistence;
1502    @BeanReference(type = WebsitePersistence.class)
1503    protected WebsitePersistence websitePersistence;
1504    private static final String _SQL_SELECT_MEMBERSHIPREQUEST = "SELECT membershipRequest FROM MembershipRequest membershipRequest";
1505    private static final String _SQL_SELECT_MEMBERSHIPREQUEST_WHERE = "SELECT membershipRequest FROM MembershipRequest membershipRequest WHERE ";
1506    private static final String _SQL_COUNT_MEMBERSHIPREQUEST = "SELECT COUNT(membershipRequest) FROM MembershipRequest membershipRequest";
1507    private static final String _SQL_COUNT_MEMBERSHIPREQUEST_WHERE = "SELECT COUNT(membershipRequest) FROM MembershipRequest membershipRequest WHERE ";
1508    private static final String _FINDER_COLUMN_GROUPID_GROUPID_2 = "membershipRequest.groupId = ?";
1509    private static final String _FINDER_COLUMN_USERID_USERID_2 = "membershipRequest.userId = ?";
1510    private static final String _FINDER_COLUMN_G_S_GROUPID_2 = "membershipRequest.groupId = ? AND ";
1511    private static final String _FINDER_COLUMN_G_S_STATUSID_2 = "membershipRequest.statusId = ?";
1512    private static final String _ORDER_BY_ENTITY_ALIAS = "membershipRequest.";
1513    private static final String _NO_SUCH_ENTITY_WITH_PRIMARY_KEY = "No MembershipRequest exists with the primary key ";
1514    private static final String _NO_SUCH_ENTITY_WITH_KEY = "No MembershipRequest exists with the key {";
1515    private static Log _log = LogFactoryUtil.getLog(MembershipRequestPersistenceImpl.class);
1516}