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