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