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