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