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.portlet.social.service.persistence;
16  
17  import com.liferay.portal.NoSuchModelException;
18  import com.liferay.portal.kernel.annotation.BeanReference;
19  import com.liferay.portal.kernel.cache.CacheRegistry;
20  import com.liferay.portal.kernel.dao.orm.EntityCacheUtil;
21  import com.liferay.portal.kernel.dao.orm.FinderCacheUtil;
22  import com.liferay.portal.kernel.dao.orm.FinderPath;
23  import com.liferay.portal.kernel.dao.orm.Query;
24  import com.liferay.portal.kernel.dao.orm.QueryPos;
25  import com.liferay.portal.kernel.dao.orm.QueryUtil;
26  import com.liferay.portal.kernel.dao.orm.Session;
27  import com.liferay.portal.kernel.exception.SystemException;
28  import com.liferay.portal.kernel.log.Log;
29  import com.liferay.portal.kernel.log.LogFactoryUtil;
30  import com.liferay.portal.kernel.util.GetterUtil;
31  import com.liferay.portal.kernel.util.OrderByComparator;
32  import com.liferay.portal.kernel.util.StringBundler;
33  import com.liferay.portal.kernel.util.StringPool;
34  import com.liferay.portal.kernel.util.StringUtil;
35  import com.liferay.portal.model.ModelListener;
36  import com.liferay.portal.service.persistence.BatchSessionUtil;
37  import com.liferay.portal.service.persistence.GroupPersistence;
38  import com.liferay.portal.service.persistence.LayoutPersistence;
39  import com.liferay.portal.service.persistence.ResourcePersistence;
40  import com.liferay.portal.service.persistence.UserPersistence;
41  import com.liferay.portal.service.persistence.impl.BasePersistenceImpl;
42  
43  import com.liferay.portlet.social.NoSuchActivityException;
44  import com.liferay.portlet.social.model.SocialActivity;
45  import com.liferay.portlet.social.model.impl.SocialActivityImpl;
46  import com.liferay.portlet.social.model.impl.SocialActivityModelImpl;
47  
48  import java.io.Serializable;
49  
50  import java.util.ArrayList;
51  import java.util.Collections;
52  import java.util.List;
53  
54  /**
55   * <a href="SocialActivityPersistenceImpl.java.html"><b><i>View Source</i></b></a>
56   *
57   * <p>
58   * ServiceBuilder generated this class. Modifications in this class will be
59   * overwritten the next time is generated.
60   * </p>
61   *
62   * @author    Brian Wing Shun Chan
63   * @see       SocialActivityPersistence
64   * @see       SocialActivityUtil
65   * @generated
66   */
67  public class SocialActivityPersistenceImpl extends BasePersistenceImpl<SocialActivity>
68      implements SocialActivityPersistence {
69      public static final String FINDER_CLASS_NAME_ENTITY = SocialActivityImpl.class.getName();
70      public static final String FINDER_CLASS_NAME_LIST = FINDER_CLASS_NAME_ENTITY +
71          ".List";
72      public static final FinderPath FINDER_PATH_FIND_BY_GROUPID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
73              SocialActivityModelImpl.FINDER_CACHE_ENABLED,
74              FINDER_CLASS_NAME_LIST, "findByGroupId",
75              new String[] { Long.class.getName() });
76      public static final FinderPath FINDER_PATH_FIND_BY_OBC_GROUPID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
77              SocialActivityModelImpl.FINDER_CACHE_ENABLED,
78              FINDER_CLASS_NAME_LIST, "findByGroupId",
79              new String[] {
80                  Long.class.getName(),
81                  
82              "java.lang.Integer", "java.lang.Integer",
83                  "com.liferay.portal.kernel.util.OrderByComparator"
84              });
85      public static final FinderPath FINDER_PATH_COUNT_BY_GROUPID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
86              SocialActivityModelImpl.FINDER_CACHE_ENABLED,
87              FINDER_CLASS_NAME_LIST, "countByGroupId",
88              new String[] { Long.class.getName() });
89      public static final FinderPath FINDER_PATH_FIND_BY_COMPANYID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
90              SocialActivityModelImpl.FINDER_CACHE_ENABLED,
91              FINDER_CLASS_NAME_LIST, "findByCompanyId",
92              new String[] { Long.class.getName() });
93      public static final FinderPath FINDER_PATH_FIND_BY_OBC_COMPANYID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
94              SocialActivityModelImpl.FINDER_CACHE_ENABLED,
95              FINDER_CLASS_NAME_LIST, "findByCompanyId",
96              new String[] {
97                  Long.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_COMPANYID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
103             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
104             FINDER_CLASS_NAME_LIST, "countByCompanyId",
105             new String[] { Long.class.getName() });
106     public static final FinderPath FINDER_PATH_FIND_BY_USERID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
107             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
108             FINDER_CLASS_NAME_LIST, "findByUserId",
109             new String[] { Long.class.getName() });
110     public static final FinderPath FINDER_PATH_FIND_BY_OBC_USERID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
111             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
112             FINDER_CLASS_NAME_LIST, "findByUserId",
113             new String[] {
114                 Long.class.getName(),
115                 
116             "java.lang.Integer", "java.lang.Integer",
117                 "com.liferay.portal.kernel.util.OrderByComparator"
118             });
119     public static final FinderPath FINDER_PATH_COUNT_BY_USERID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
120             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
121             FINDER_CLASS_NAME_LIST, "countByUserId",
122             new String[] { Long.class.getName() });
123     public static final FinderPath FINDER_PATH_FETCH_BY_MIRRORACTIVITYID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
124             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
125             FINDER_CLASS_NAME_ENTITY, "fetchByMirrorActivityId",
126             new String[] { Long.class.getName() });
127     public static final FinderPath FINDER_PATH_COUNT_BY_MIRRORACTIVITYID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
128             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
129             FINDER_CLASS_NAME_LIST, "countByMirrorActivityId",
130             new String[] { Long.class.getName() });
131     public static final FinderPath FINDER_PATH_FIND_BY_CLASSNAMEID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
132             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
133             FINDER_CLASS_NAME_LIST, "findByClassNameId",
134             new String[] { Long.class.getName() });
135     public static final FinderPath FINDER_PATH_FIND_BY_OBC_CLASSNAMEID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
136             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
137             FINDER_CLASS_NAME_LIST, "findByClassNameId",
138             new String[] {
139                 Long.class.getName(),
140                 
141             "java.lang.Integer", "java.lang.Integer",
142                 "com.liferay.portal.kernel.util.OrderByComparator"
143             });
144     public static final FinderPath FINDER_PATH_COUNT_BY_CLASSNAMEID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
145             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
146             FINDER_CLASS_NAME_LIST, "countByClassNameId",
147             new String[] { Long.class.getName() });
148     public static final FinderPath FINDER_PATH_FIND_BY_RECEIVERUSERID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
149             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
150             FINDER_CLASS_NAME_LIST, "findByReceiverUserId",
151             new String[] { Long.class.getName() });
152     public static final FinderPath FINDER_PATH_FIND_BY_OBC_RECEIVERUSERID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
153             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
154             FINDER_CLASS_NAME_LIST, "findByReceiverUserId",
155             new String[] {
156                 Long.class.getName(),
157                 
158             "java.lang.Integer", "java.lang.Integer",
159                 "com.liferay.portal.kernel.util.OrderByComparator"
160             });
161     public static final FinderPath FINDER_PATH_COUNT_BY_RECEIVERUSERID = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
162             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
163             FINDER_CLASS_NAME_LIST, "countByReceiverUserId",
164             new String[] { Long.class.getName() });
165     public static final FinderPath FINDER_PATH_FIND_BY_C_C = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
166             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
167             FINDER_CLASS_NAME_LIST, "findByC_C",
168             new String[] { Long.class.getName(), Long.class.getName() });
169     public static final FinderPath FINDER_PATH_FIND_BY_OBC_C_C = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
170             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
171             FINDER_CLASS_NAME_LIST, "findByC_C",
172             new String[] {
173                 Long.class.getName(), Long.class.getName(),
174                 
175             "java.lang.Integer", "java.lang.Integer",
176                 "com.liferay.portal.kernel.util.OrderByComparator"
177             });
178     public static final FinderPath FINDER_PATH_COUNT_BY_C_C = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
179             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
180             FINDER_CLASS_NAME_LIST, "countByC_C",
181             new String[] { Long.class.getName(), Long.class.getName() });
182     public static final FinderPath FINDER_PATH_FIND_BY_M_C_C = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
183             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
184             FINDER_CLASS_NAME_LIST, "findByM_C_C",
185             new String[] {
186                 Long.class.getName(), Long.class.getName(), Long.class.getName()
187             });
188     public static final FinderPath FINDER_PATH_FIND_BY_OBC_M_C_C = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
189             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
190             FINDER_CLASS_NAME_LIST, "findByM_C_C",
191             new String[] {
192                 Long.class.getName(), Long.class.getName(), Long.class.getName(),
193                 
194             "java.lang.Integer", "java.lang.Integer",
195                 "com.liferay.portal.kernel.util.OrderByComparator"
196             });
197     public static final FinderPath FINDER_PATH_COUNT_BY_M_C_C = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
198             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
199             FINDER_CLASS_NAME_LIST, "countByM_C_C",
200             new String[] {
201                 Long.class.getName(), Long.class.getName(), Long.class.getName()
202             });
203     public static final FinderPath FINDER_PATH_FETCH_BY_G_U_CD_C_C_T_R = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
204             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
205             FINDER_CLASS_NAME_ENTITY, "fetchByG_U_CD_C_C_T_R",
206             new String[] {
207                 Long.class.getName(), Long.class.getName(), Long.class.getName(),
208                 Long.class.getName(), Long.class.getName(),
209                 Integer.class.getName(), Long.class.getName()
210             });
211     public static final FinderPath FINDER_PATH_COUNT_BY_G_U_CD_C_C_T_R = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
212             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
213             FINDER_CLASS_NAME_LIST, "countByG_U_CD_C_C_T_R",
214             new String[] {
215                 Long.class.getName(), Long.class.getName(), Long.class.getName(),
216                 Long.class.getName(), Long.class.getName(),
217                 Integer.class.getName(), Long.class.getName()
218             });
219     public static final FinderPath FINDER_PATH_FIND_ALL = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
220             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
221             FINDER_CLASS_NAME_LIST, "findAll", new String[0]);
222     public static final FinderPath FINDER_PATH_COUNT_ALL = new FinderPath(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
223             SocialActivityModelImpl.FINDER_CACHE_ENABLED,
224             FINDER_CLASS_NAME_LIST, "countAll", new String[0]);
225 
226     public void cacheResult(SocialActivity socialActivity) {
227         EntityCacheUtil.putResult(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
228             SocialActivityImpl.class, socialActivity.getPrimaryKey(),
229             socialActivity);
230 
231         FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_MIRRORACTIVITYID,
232             new Object[] { new Long(socialActivity.getMirrorActivityId()) },
233             socialActivity);
234 
235         FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_G_U_CD_C_C_T_R,
236             new Object[] {
237                 new Long(socialActivity.getGroupId()),
238                 new Long(socialActivity.getUserId()),
239                 new Long(socialActivity.getCreateDate()),
240                 new Long(socialActivity.getClassNameId()),
241                 new Long(socialActivity.getClassPK()),
242                 new Integer(socialActivity.getType()),
243                 new Long(socialActivity.getReceiverUserId())
244             }, socialActivity);
245     }
246 
247     public void cacheResult(List<SocialActivity> socialActivities) {
248         for (SocialActivity socialActivity : socialActivities) {
249             if (EntityCacheUtil.getResult(
250                         SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
251                         SocialActivityImpl.class,
252                         socialActivity.getPrimaryKey(), this) == null) {
253                 cacheResult(socialActivity);
254             }
255         }
256     }
257 
258     public void clearCache() {
259         CacheRegistry.clear(SocialActivityImpl.class.getName());
260         EntityCacheUtil.clearCache(SocialActivityImpl.class.getName());
261         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_ENTITY);
262         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
263     }
264 
265     public SocialActivity create(long activityId) {
266         SocialActivity socialActivity = new SocialActivityImpl();
267 
268         socialActivity.setNew(true);
269         socialActivity.setPrimaryKey(activityId);
270 
271         return socialActivity;
272     }
273 
274     public SocialActivity remove(Serializable primaryKey)
275         throws NoSuchModelException, SystemException {
276         return remove(((Long)primaryKey).longValue());
277     }
278 
279     public SocialActivity remove(long activityId)
280         throws NoSuchActivityException, SystemException {
281         Session session = null;
282 
283         try {
284             session = openSession();
285 
286             SocialActivity socialActivity = (SocialActivity)session.get(SocialActivityImpl.class,
287                     new Long(activityId));
288 
289             if (socialActivity == null) {
290                 if (_log.isWarnEnabled()) {
291                     _log.warn(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY + activityId);
292                 }
293 
294                 throw new NoSuchActivityException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
295                     activityId);
296             }
297 
298             return remove(socialActivity);
299         }
300         catch (NoSuchActivityException nsee) {
301             throw nsee;
302         }
303         catch (Exception e) {
304             throw processException(e);
305         }
306         finally {
307             closeSession(session);
308         }
309     }
310 
311     public SocialActivity remove(SocialActivity socialActivity)
312         throws SystemException {
313         for (ModelListener<SocialActivity> listener : listeners) {
314             listener.onBeforeRemove(socialActivity);
315         }
316 
317         socialActivity = removeImpl(socialActivity);
318 
319         for (ModelListener<SocialActivity> listener : listeners) {
320             listener.onAfterRemove(socialActivity);
321         }
322 
323         return socialActivity;
324     }
325 
326     protected SocialActivity removeImpl(SocialActivity socialActivity)
327         throws SystemException {
328         socialActivity = toUnwrappedModel(socialActivity);
329 
330         Session session = null;
331 
332         try {
333             session = openSession();
334 
335             if (socialActivity.isCachedModel() || BatchSessionUtil.isEnabled()) {
336                 Object staleObject = session.get(SocialActivityImpl.class,
337                         socialActivity.getPrimaryKeyObj());
338 
339                 if (staleObject != null) {
340                     session.evict(staleObject);
341                 }
342             }
343 
344             session.delete(socialActivity);
345 
346             session.flush();
347         }
348         catch (Exception e) {
349             throw processException(e);
350         }
351         finally {
352             closeSession(session);
353         }
354 
355         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
356 
357         SocialActivityModelImpl socialActivityModelImpl = (SocialActivityModelImpl)socialActivity;
358 
359         FinderCacheUtil.removeResult(FINDER_PATH_FETCH_BY_MIRRORACTIVITYID,
360             new Object[] {
361                 new Long(socialActivityModelImpl.getOriginalMirrorActivityId())
362             });
363 
364         FinderCacheUtil.removeResult(FINDER_PATH_FETCH_BY_G_U_CD_C_C_T_R,
365             new Object[] {
366                 new Long(socialActivityModelImpl.getOriginalGroupId()),
367                 new Long(socialActivityModelImpl.getOriginalUserId()),
368                 new Long(socialActivityModelImpl.getOriginalCreateDate()),
369                 new Long(socialActivityModelImpl.getOriginalClassNameId()),
370                 new Long(socialActivityModelImpl.getOriginalClassPK()),
371                 new Integer(socialActivityModelImpl.getOriginalType()),
372                 new Long(socialActivityModelImpl.getOriginalReceiverUserId())
373             });
374 
375         EntityCacheUtil.removeResult(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
376             SocialActivityImpl.class, socialActivity.getPrimaryKey());
377 
378         return socialActivity;
379     }
380 
381     public SocialActivity updateImpl(
382         com.liferay.portlet.social.model.SocialActivity socialActivity,
383         boolean merge) throws SystemException {
384         socialActivity = toUnwrappedModel(socialActivity);
385 
386         boolean isNew = socialActivity.isNew();
387 
388         SocialActivityModelImpl socialActivityModelImpl = (SocialActivityModelImpl)socialActivity;
389 
390         Session session = null;
391 
392         try {
393             session = openSession();
394 
395             BatchSessionUtil.update(session, socialActivity, merge);
396 
397             socialActivity.setNew(false);
398         }
399         catch (Exception e) {
400             throw processException(e);
401         }
402         finally {
403             closeSession(session);
404         }
405 
406         FinderCacheUtil.clearCache(FINDER_CLASS_NAME_LIST);
407 
408         EntityCacheUtil.putResult(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
409             SocialActivityImpl.class, socialActivity.getPrimaryKey(),
410             socialActivity);
411 
412         if (!isNew &&
413                 (socialActivity.getMirrorActivityId() != socialActivityModelImpl.getOriginalMirrorActivityId())) {
414             FinderCacheUtil.removeResult(FINDER_PATH_FETCH_BY_MIRRORACTIVITYID,
415                 new Object[] {
416                     new Long(socialActivityModelImpl.getOriginalMirrorActivityId())
417                 });
418         }
419 
420         if (isNew ||
421                 (socialActivity.getMirrorActivityId() != socialActivityModelImpl.getOriginalMirrorActivityId())) {
422             FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_MIRRORACTIVITYID,
423                 new Object[] { new Long(socialActivity.getMirrorActivityId()) },
424                 socialActivity);
425         }
426 
427         if (!isNew &&
428                 ((socialActivity.getGroupId() != socialActivityModelImpl.getOriginalGroupId()) ||
429                 (socialActivity.getUserId() != socialActivityModelImpl.getOriginalUserId()) ||
430                 (socialActivity.getCreateDate() != socialActivityModelImpl.getOriginalCreateDate()) ||
431                 (socialActivity.getClassNameId() != socialActivityModelImpl.getOriginalClassNameId()) ||
432                 (socialActivity.getClassPK() != socialActivityModelImpl.getOriginalClassPK()) ||
433                 (socialActivity.getType() != socialActivityModelImpl.getOriginalType()) ||
434                 (socialActivity.getReceiverUserId() != socialActivityModelImpl.getOriginalReceiverUserId()))) {
435             FinderCacheUtil.removeResult(FINDER_PATH_FETCH_BY_G_U_CD_C_C_T_R,
436                 new Object[] {
437                     new Long(socialActivityModelImpl.getOriginalGroupId()),
438                     new Long(socialActivityModelImpl.getOriginalUserId()),
439                     new Long(socialActivityModelImpl.getOriginalCreateDate()),
440                     new Long(socialActivityModelImpl.getOriginalClassNameId()),
441                     new Long(socialActivityModelImpl.getOriginalClassPK()),
442                     new Integer(socialActivityModelImpl.getOriginalType()),
443                     new Long(socialActivityModelImpl.getOriginalReceiverUserId())
444                 });
445         }
446 
447         if (isNew ||
448                 ((socialActivity.getGroupId() != socialActivityModelImpl.getOriginalGroupId()) ||
449                 (socialActivity.getUserId() != socialActivityModelImpl.getOriginalUserId()) ||
450                 (socialActivity.getCreateDate() != socialActivityModelImpl.getOriginalCreateDate()) ||
451                 (socialActivity.getClassNameId() != socialActivityModelImpl.getOriginalClassNameId()) ||
452                 (socialActivity.getClassPK() != socialActivityModelImpl.getOriginalClassPK()) ||
453                 (socialActivity.getType() != socialActivityModelImpl.getOriginalType()) ||
454                 (socialActivity.getReceiverUserId() != socialActivityModelImpl.getOriginalReceiverUserId()))) {
455             FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_G_U_CD_C_C_T_R,
456                 new Object[] {
457                     new Long(socialActivity.getGroupId()),
458                     new Long(socialActivity.getUserId()),
459                     new Long(socialActivity.getCreateDate()),
460                     new Long(socialActivity.getClassNameId()),
461                     new Long(socialActivity.getClassPK()),
462                     new Integer(socialActivity.getType()),
463                     new Long(socialActivity.getReceiverUserId())
464                 }, socialActivity);
465         }
466 
467         return socialActivity;
468     }
469 
470     protected SocialActivity toUnwrappedModel(SocialActivity socialActivity) {
471         if (socialActivity instanceof SocialActivityImpl) {
472             return socialActivity;
473         }
474 
475         SocialActivityImpl socialActivityImpl = new SocialActivityImpl();
476 
477         socialActivityImpl.setNew(socialActivity.isNew());
478         socialActivityImpl.setPrimaryKey(socialActivity.getPrimaryKey());
479 
480         socialActivityImpl.setActivityId(socialActivity.getActivityId());
481         socialActivityImpl.setGroupId(socialActivity.getGroupId());
482         socialActivityImpl.setCompanyId(socialActivity.getCompanyId());
483         socialActivityImpl.setUserId(socialActivity.getUserId());
484         socialActivityImpl.setCreateDate(socialActivity.getCreateDate());
485         socialActivityImpl.setMirrorActivityId(socialActivity.getMirrorActivityId());
486         socialActivityImpl.setClassNameId(socialActivity.getClassNameId());
487         socialActivityImpl.setClassPK(socialActivity.getClassPK());
488         socialActivityImpl.setType(socialActivity.getType());
489         socialActivityImpl.setExtraData(socialActivity.getExtraData());
490         socialActivityImpl.setReceiverUserId(socialActivity.getReceiverUserId());
491 
492         return socialActivityImpl;
493     }
494 
495     public SocialActivity findByPrimaryKey(Serializable primaryKey)
496         throws NoSuchModelException, SystemException {
497         return findByPrimaryKey(((Long)primaryKey).longValue());
498     }
499 
500     public SocialActivity findByPrimaryKey(long activityId)
501         throws NoSuchActivityException, SystemException {
502         SocialActivity socialActivity = fetchByPrimaryKey(activityId);
503 
504         if (socialActivity == null) {
505             if (_log.isWarnEnabled()) {
506                 _log.warn(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY + activityId);
507             }
508 
509             throw new NoSuchActivityException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY +
510                 activityId);
511         }
512 
513         return socialActivity;
514     }
515 
516     public SocialActivity fetchByPrimaryKey(Serializable primaryKey)
517         throws SystemException {
518         return fetchByPrimaryKey(((Long)primaryKey).longValue());
519     }
520 
521     public SocialActivity fetchByPrimaryKey(long activityId)
522         throws SystemException {
523         SocialActivity socialActivity = (SocialActivity)EntityCacheUtil.getResult(SocialActivityModelImpl.ENTITY_CACHE_ENABLED,
524                 SocialActivityImpl.class, activityId, this);
525 
526         if (socialActivity == null) {
527             Session session = null;
528 
529             try {
530                 session = openSession();
531 
532                 socialActivity = (SocialActivity)session.get(SocialActivityImpl.class,
533                         new Long(activityId));
534             }
535             catch (Exception e) {
536                 throw processException(e);
537             }
538             finally {
539                 if (socialActivity != null) {
540                     cacheResult(socialActivity);
541                 }
542 
543                 closeSession(session);
544             }
545         }
546 
547         return socialActivity;
548     }
549 
550     public List<SocialActivity> findByGroupId(long groupId)
551         throws SystemException {
552         Object[] finderArgs = new Object[] { new Long(groupId) };
553 
554         List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_GROUPID,
555                 finderArgs, this);
556 
557         if (list == null) {
558             Session session = null;
559 
560             try {
561                 session = openSession();
562 
563                 StringBundler query = new StringBundler(3);
564 
565                 query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
566 
567                 query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
568 
569                 query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
570 
571                 String sql = query.toString();
572 
573                 Query q = session.createQuery(sql);
574 
575                 QueryPos qPos = QueryPos.getInstance(q);
576 
577                 qPos.add(groupId);
578 
579                 list = q.list();
580             }
581             catch (Exception e) {
582                 throw processException(e);
583             }
584             finally {
585                 if (list == null) {
586                     list = new ArrayList<SocialActivity>();
587                 }
588 
589                 cacheResult(list);
590 
591                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_GROUPID,
592                     finderArgs, list);
593 
594                 closeSession(session);
595             }
596         }
597 
598         return list;
599     }
600 
601     public List<SocialActivity> findByGroupId(long groupId, int start, int end)
602         throws SystemException {
603         return findByGroupId(groupId, start, end, null);
604     }
605 
606     public List<SocialActivity> findByGroupId(long groupId, int start, int end,
607         OrderByComparator orderByComparator) throws SystemException {
608         Object[] finderArgs = new Object[] {
609                 new Long(groupId),
610                 
611                 String.valueOf(start), String.valueOf(end),
612                 String.valueOf(orderByComparator)
613             };
614 
615         List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_GROUPID,
616                 finderArgs, this);
617 
618         if (list == null) {
619             Session session = null;
620 
621             try {
622                 session = openSession();
623 
624                 StringBundler query = null;
625 
626                 if (orderByComparator != null) {
627                     query = new StringBundler(3 +
628                             (orderByComparator.getOrderByFields().length * 3));
629                 }
630                 else {
631                     query = new StringBundler(3);
632                 }
633 
634                 query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
635 
636                 query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
637 
638                 if (orderByComparator != null) {
639                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
640                         orderByComparator);
641                 }
642 
643                 else {
644                     query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
645                 }
646 
647                 String sql = query.toString();
648 
649                 Query q = session.createQuery(sql);
650 
651                 QueryPos qPos = QueryPos.getInstance(q);
652 
653                 qPos.add(groupId);
654 
655                 list = (List<SocialActivity>)QueryUtil.list(q, getDialect(),
656                         start, end);
657             }
658             catch (Exception e) {
659                 throw processException(e);
660             }
661             finally {
662                 if (list == null) {
663                     list = new ArrayList<SocialActivity>();
664                 }
665 
666                 cacheResult(list);
667 
668                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_GROUPID,
669                     finderArgs, list);
670 
671                 closeSession(session);
672             }
673         }
674 
675         return list;
676     }
677 
678     public SocialActivity findByGroupId_First(long groupId,
679         OrderByComparator orderByComparator)
680         throws NoSuchActivityException, SystemException {
681         List<SocialActivity> list = findByGroupId(groupId, 0, 1,
682                 orderByComparator);
683 
684         if (list.isEmpty()) {
685             StringBundler msg = new StringBundler(4);
686 
687             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
688 
689             msg.append("groupId=");
690             msg.append(groupId);
691 
692             msg.append(StringPool.CLOSE_CURLY_BRACE);
693 
694             throw new NoSuchActivityException(msg.toString());
695         }
696         else {
697             return list.get(0);
698         }
699     }
700 
701     public SocialActivity findByGroupId_Last(long groupId,
702         OrderByComparator orderByComparator)
703         throws NoSuchActivityException, SystemException {
704         int count = countByGroupId(groupId);
705 
706         List<SocialActivity> list = findByGroupId(groupId, count - 1, count,
707                 orderByComparator);
708 
709         if (list.isEmpty()) {
710             StringBundler msg = new StringBundler(4);
711 
712             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
713 
714             msg.append("groupId=");
715             msg.append(groupId);
716 
717             msg.append(StringPool.CLOSE_CURLY_BRACE);
718 
719             throw new NoSuchActivityException(msg.toString());
720         }
721         else {
722             return list.get(0);
723         }
724     }
725 
726     public SocialActivity[] findByGroupId_PrevAndNext(long activityId,
727         long groupId, OrderByComparator orderByComparator)
728         throws NoSuchActivityException, SystemException {
729         SocialActivity socialActivity = findByPrimaryKey(activityId);
730 
731         int count = countByGroupId(groupId);
732 
733         Session session = null;
734 
735         try {
736             session = openSession();
737 
738             StringBundler query = null;
739 
740             if (orderByComparator != null) {
741                 query = new StringBundler(3 +
742                         (orderByComparator.getOrderByFields().length * 3));
743             }
744             else {
745                 query = new StringBundler(3);
746             }
747 
748             query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
749 
750             query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
751 
752             if (orderByComparator != null) {
753                 appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
754                     orderByComparator);
755             }
756 
757             else {
758                 query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
759             }
760 
761             String sql = query.toString();
762 
763             Query q = session.createQuery(sql);
764 
765             QueryPos qPos = QueryPos.getInstance(q);
766 
767             qPos.add(groupId);
768 
769             Object[] objArray = QueryUtil.getPrevAndNext(q, count,
770                     orderByComparator, socialActivity);
771 
772             SocialActivity[] array = new SocialActivityImpl[3];
773 
774             array[0] = (SocialActivity)objArray[0];
775             array[1] = (SocialActivity)objArray[1];
776             array[2] = (SocialActivity)objArray[2];
777 
778             return array;
779         }
780         catch (Exception e) {
781             throw processException(e);
782         }
783         finally {
784             closeSession(session);
785         }
786     }
787 
788     public List<SocialActivity> findByCompanyId(long companyId)
789         throws SystemException {
790         Object[] finderArgs = new Object[] { new Long(companyId) };
791 
792         List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_COMPANYID,
793                 finderArgs, this);
794 
795         if (list == null) {
796             Session session = null;
797 
798             try {
799                 session = openSession();
800 
801                 StringBundler query = new StringBundler(3);
802 
803                 query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
804 
805                 query.append(_FINDER_COLUMN_COMPANYID_COMPANYID_2);
806 
807                 query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
808 
809                 String sql = query.toString();
810 
811                 Query q = session.createQuery(sql);
812 
813                 QueryPos qPos = QueryPos.getInstance(q);
814 
815                 qPos.add(companyId);
816 
817                 list = q.list();
818             }
819             catch (Exception e) {
820                 throw processException(e);
821             }
822             finally {
823                 if (list == null) {
824                     list = new ArrayList<SocialActivity>();
825                 }
826 
827                 cacheResult(list);
828 
829                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_COMPANYID,
830                     finderArgs, list);
831 
832                 closeSession(session);
833             }
834         }
835 
836         return list;
837     }
838 
839     public List<SocialActivity> findByCompanyId(long companyId, int start,
840         int end) throws SystemException {
841         return findByCompanyId(companyId, start, end, null);
842     }
843 
844     public List<SocialActivity> findByCompanyId(long companyId, int start,
845         int end, OrderByComparator orderByComparator) throws SystemException {
846         Object[] finderArgs = new Object[] {
847                 new Long(companyId),
848                 
849                 String.valueOf(start), String.valueOf(end),
850                 String.valueOf(orderByComparator)
851             };
852 
853         List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_COMPANYID,
854                 finderArgs, this);
855 
856         if (list == null) {
857             Session session = null;
858 
859             try {
860                 session = openSession();
861 
862                 StringBundler query = null;
863 
864                 if (orderByComparator != null) {
865                     query = new StringBundler(3 +
866                             (orderByComparator.getOrderByFields().length * 3));
867                 }
868                 else {
869                     query = new StringBundler(3);
870                 }
871 
872                 query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
873 
874                 query.append(_FINDER_COLUMN_COMPANYID_COMPANYID_2);
875 
876                 if (orderByComparator != null) {
877                     appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
878                         orderByComparator);
879                 }
880 
881                 else {
882                     query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
883                 }
884 
885                 String sql = query.toString();
886 
887                 Query q = session.createQuery(sql);
888 
889                 QueryPos qPos = QueryPos.getInstance(q);
890 
891                 qPos.add(companyId);
892 
893                 list = (List<SocialActivity>)QueryUtil.list(q, getDialect(),
894                         start, end);
895             }
896             catch (Exception e) {
897                 throw processException(e);
898             }
899             finally {
900                 if (list == null) {
901                     list = new ArrayList<SocialActivity>();
902                 }
903 
904                 cacheResult(list);
905 
906                 FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_COMPANYID,
907                     finderArgs, list);
908 
909                 closeSession(session);
910             }
911         }
912 
913         return list;
914     }
915 
916     public SocialActivity findByCompanyId_First(long companyId,
917         OrderByComparator orderByComparator)
918         throws NoSuchActivityException, SystemException {
919         List<SocialActivity> list = findByCompanyId(companyId, 0, 1,
920                 orderByComparator);
921 
922         if (list.isEmpty()) {
923             StringBundler msg = new StringBundler(4);
924 
925             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
926 
927             msg.append("companyId=");
928             msg.append(companyId);
929 
930             msg.append(StringPool.CLOSE_CURLY_BRACE);
931 
932             throw new NoSuchActivityException(msg.toString());
933         }
934         else {
935             return list.get(0);
936         }
937     }
938 
939     public SocialActivity findByCompanyId_Last(long companyId,
940         OrderByComparator orderByComparator)
941         throws NoSuchActivityException, SystemException {
942         int count = countByCompanyId(companyId);
943 
944         List<SocialActivity> list = findByCompanyId(companyId, count - 1,
945                 count, orderByComparator);
946 
947         if (list.isEmpty()) {
948             StringBundler msg = new StringBundler(4);
949 
950             msg.append(_NO_SUCH_ENTITY_WITH_KEY);
951 
952             msg.append("companyId=");
953             msg.append(companyId);
954 
955             msg.append(StringPool.CLOSE_CURLY_BRACE);
956 
957             throw new NoSuchActivityException(msg.toString());
958         }
959         else {
960             return list.get(0);
961         }
962     }
963 
964     public SocialActivity[] findByCompanyId_PrevAndNext(long activityId,
965         long companyId, OrderByComparator orderByComparator)
966         throws NoSuchActivityException, SystemException {
967         SocialActivity socialActivity = findByPrimaryKey(activityId);
968 
969         int count = countByCompanyId(companyId);
970 
971         Session session = null;
972 
973         try {
974             session = openSession();
975 
976             StringBundler query = null;
977 
978             if (orderByComparator != null) {
979                 query = new StringBundler(3 +
980                         (orderByComparator.getOrderByFields().length * 3));
981             }
982             else {
983                 query = new StringBundler(3);
984             }
985 
986             query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
987 
988             query.append(_FINDER_COLUMN_COMPANYID_COMPANYID_2);
989 
990             if (orderByComparator != null) {
991                 appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
992                     orderByComparator);
993             }
994 
995             else {
996                 query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
997             }
998 
999             String sql = query.toString();
1000
1001            Query q = session.createQuery(sql);
1002
1003            QueryPos qPos = QueryPos.getInstance(q);
1004
1005            qPos.add(companyId);
1006
1007            Object[] objArray = QueryUtil.getPrevAndNext(q, count,
1008                    orderByComparator, socialActivity);
1009
1010            SocialActivity[] array = new SocialActivityImpl[3];
1011
1012            array[0] = (SocialActivity)objArray[0];
1013            array[1] = (SocialActivity)objArray[1];
1014            array[2] = (SocialActivity)objArray[2];
1015
1016            return array;
1017        }
1018        catch (Exception e) {
1019            throw processException(e);
1020        }
1021        finally {
1022            closeSession(session);
1023        }
1024    }
1025
1026    public List<SocialActivity> findByUserId(long userId)
1027        throws SystemException {
1028        Object[] finderArgs = new Object[] { new Long(userId) };
1029
1030        List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_USERID,
1031                finderArgs, this);
1032
1033        if (list == null) {
1034            Session session = null;
1035
1036            try {
1037                session = openSession();
1038
1039                StringBundler query = new StringBundler(3);
1040
1041                query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
1042
1043                query.append(_FINDER_COLUMN_USERID_USERID_2);
1044
1045                query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
1046
1047                String sql = query.toString();
1048
1049                Query q = session.createQuery(sql);
1050
1051                QueryPos qPos = QueryPos.getInstance(q);
1052
1053                qPos.add(userId);
1054
1055                list = q.list();
1056            }
1057            catch (Exception e) {
1058                throw processException(e);
1059            }
1060            finally {
1061                if (list == null) {
1062                    list = new ArrayList<SocialActivity>();
1063                }
1064
1065                cacheResult(list);
1066
1067                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_USERID,
1068                    finderArgs, list);
1069
1070                closeSession(session);
1071            }
1072        }
1073
1074        return list;
1075    }
1076
1077    public List<SocialActivity> findByUserId(long userId, int start, int end)
1078        throws SystemException {
1079        return findByUserId(userId, start, end, null);
1080    }
1081
1082    public List<SocialActivity> findByUserId(long userId, int start, int end,
1083        OrderByComparator orderByComparator) throws SystemException {
1084        Object[] finderArgs = new Object[] {
1085                new Long(userId),
1086                
1087                String.valueOf(start), String.valueOf(end),
1088                String.valueOf(orderByComparator)
1089            };
1090
1091        List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_USERID,
1092                finderArgs, this);
1093
1094        if (list == null) {
1095            Session session = null;
1096
1097            try {
1098                session = openSession();
1099
1100                StringBundler query = null;
1101
1102                if (orderByComparator != null) {
1103                    query = new StringBundler(3 +
1104                            (orderByComparator.getOrderByFields().length * 3));
1105                }
1106                else {
1107                    query = new StringBundler(3);
1108                }
1109
1110                query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
1111
1112                query.append(_FINDER_COLUMN_USERID_USERID_2);
1113
1114                if (orderByComparator != null) {
1115                    appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
1116                        orderByComparator);
1117                }
1118
1119                else {
1120                    query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
1121                }
1122
1123                String sql = query.toString();
1124
1125                Query q = session.createQuery(sql);
1126
1127                QueryPos qPos = QueryPos.getInstance(q);
1128
1129                qPos.add(userId);
1130
1131                list = (List<SocialActivity>)QueryUtil.list(q, getDialect(),
1132                        start, end);
1133            }
1134            catch (Exception e) {
1135                throw processException(e);
1136            }
1137            finally {
1138                if (list == null) {
1139                    list = new ArrayList<SocialActivity>();
1140                }
1141
1142                cacheResult(list);
1143
1144                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_USERID,
1145                    finderArgs, list);
1146
1147                closeSession(session);
1148            }
1149        }
1150
1151        return list;
1152    }
1153
1154    public SocialActivity findByUserId_First(long userId,
1155        OrderByComparator orderByComparator)
1156        throws NoSuchActivityException, SystemException {
1157        List<SocialActivity> list = findByUserId(userId, 0, 1, orderByComparator);
1158
1159        if (list.isEmpty()) {
1160            StringBundler msg = new StringBundler(4);
1161
1162            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1163
1164            msg.append("userId=");
1165            msg.append(userId);
1166
1167            msg.append(StringPool.CLOSE_CURLY_BRACE);
1168
1169            throw new NoSuchActivityException(msg.toString());
1170        }
1171        else {
1172            return list.get(0);
1173        }
1174    }
1175
1176    public SocialActivity findByUserId_Last(long userId,
1177        OrderByComparator orderByComparator)
1178        throws NoSuchActivityException, SystemException {
1179        int count = countByUserId(userId);
1180
1181        List<SocialActivity> list = findByUserId(userId, count - 1, count,
1182                orderByComparator);
1183
1184        if (list.isEmpty()) {
1185            StringBundler msg = new StringBundler(4);
1186
1187            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1188
1189            msg.append("userId=");
1190            msg.append(userId);
1191
1192            msg.append(StringPool.CLOSE_CURLY_BRACE);
1193
1194            throw new NoSuchActivityException(msg.toString());
1195        }
1196        else {
1197            return list.get(0);
1198        }
1199    }
1200
1201    public SocialActivity[] findByUserId_PrevAndNext(long activityId,
1202        long userId, OrderByComparator orderByComparator)
1203        throws NoSuchActivityException, SystemException {
1204        SocialActivity socialActivity = findByPrimaryKey(activityId);
1205
1206        int count = countByUserId(userId);
1207
1208        Session session = null;
1209
1210        try {
1211            session = openSession();
1212
1213            StringBundler query = null;
1214
1215            if (orderByComparator != null) {
1216                query = new StringBundler(3 +
1217                        (orderByComparator.getOrderByFields().length * 3));
1218            }
1219            else {
1220                query = new StringBundler(3);
1221            }
1222
1223            query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
1224
1225            query.append(_FINDER_COLUMN_USERID_USERID_2);
1226
1227            if (orderByComparator != null) {
1228                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
1229                    orderByComparator);
1230            }
1231
1232            else {
1233                query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
1234            }
1235
1236            String sql = query.toString();
1237
1238            Query q = session.createQuery(sql);
1239
1240            QueryPos qPos = QueryPos.getInstance(q);
1241
1242            qPos.add(userId);
1243
1244            Object[] objArray = QueryUtil.getPrevAndNext(q, count,
1245                    orderByComparator, socialActivity);
1246
1247            SocialActivity[] array = new SocialActivityImpl[3];
1248
1249            array[0] = (SocialActivity)objArray[0];
1250            array[1] = (SocialActivity)objArray[1];
1251            array[2] = (SocialActivity)objArray[2];
1252
1253            return array;
1254        }
1255        catch (Exception e) {
1256            throw processException(e);
1257        }
1258        finally {
1259            closeSession(session);
1260        }
1261    }
1262
1263    public SocialActivity findByMirrorActivityId(long mirrorActivityId)
1264        throws NoSuchActivityException, SystemException {
1265        SocialActivity socialActivity = fetchByMirrorActivityId(mirrorActivityId);
1266
1267        if (socialActivity == null) {
1268            StringBundler msg = new StringBundler(4);
1269
1270            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1271
1272            msg.append("mirrorActivityId=");
1273            msg.append(mirrorActivityId);
1274
1275            msg.append(StringPool.CLOSE_CURLY_BRACE);
1276
1277            if (_log.isWarnEnabled()) {
1278                _log.warn(msg.toString());
1279            }
1280
1281            throw new NoSuchActivityException(msg.toString());
1282        }
1283
1284        return socialActivity;
1285    }
1286
1287    public SocialActivity fetchByMirrorActivityId(long mirrorActivityId)
1288        throws SystemException {
1289        return fetchByMirrorActivityId(mirrorActivityId, true);
1290    }
1291
1292    public SocialActivity fetchByMirrorActivityId(long mirrorActivityId,
1293        boolean retrieveFromCache) throws SystemException {
1294        Object[] finderArgs = new Object[] { new Long(mirrorActivityId) };
1295
1296        Object result = null;
1297
1298        if (retrieveFromCache) {
1299            result = FinderCacheUtil.getResult(FINDER_PATH_FETCH_BY_MIRRORACTIVITYID,
1300                    finderArgs, this);
1301        }
1302
1303        if (result == null) {
1304            Session session = null;
1305
1306            try {
1307                session = openSession();
1308
1309                StringBundler query = new StringBundler(3);
1310
1311                query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
1312
1313                query.append(_FINDER_COLUMN_MIRRORACTIVITYID_MIRRORACTIVITYID_2);
1314
1315                query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
1316
1317                String sql = query.toString();
1318
1319                Query q = session.createQuery(sql);
1320
1321                QueryPos qPos = QueryPos.getInstance(q);
1322
1323                qPos.add(mirrorActivityId);
1324
1325                List<SocialActivity> list = q.list();
1326
1327                result = list;
1328
1329                SocialActivity socialActivity = null;
1330
1331                if (list.isEmpty()) {
1332                    FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_MIRRORACTIVITYID,
1333                        finderArgs, list);
1334                }
1335                else {
1336                    socialActivity = list.get(0);
1337
1338                    cacheResult(socialActivity);
1339
1340                    if ((socialActivity.getMirrorActivityId() != mirrorActivityId)) {
1341                        FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_MIRRORACTIVITYID,
1342                            finderArgs, socialActivity);
1343                    }
1344                }
1345
1346                return socialActivity;
1347            }
1348            catch (Exception e) {
1349                throw processException(e);
1350            }
1351            finally {
1352                if (result == null) {
1353                    FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_MIRRORACTIVITYID,
1354                        finderArgs, new ArrayList<SocialActivity>());
1355                }
1356
1357                closeSession(session);
1358            }
1359        }
1360        else {
1361            if (result instanceof List<?>) {
1362                return null;
1363            }
1364            else {
1365                return (SocialActivity)result;
1366            }
1367        }
1368    }
1369
1370    public List<SocialActivity> findByClassNameId(long classNameId)
1371        throws SystemException {
1372        Object[] finderArgs = new Object[] { new Long(classNameId) };
1373
1374        List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_CLASSNAMEID,
1375                finderArgs, this);
1376
1377        if (list == null) {
1378            Session session = null;
1379
1380            try {
1381                session = openSession();
1382
1383                StringBundler query = new StringBundler(3);
1384
1385                query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
1386
1387                query.append(_FINDER_COLUMN_CLASSNAMEID_CLASSNAMEID_2);
1388
1389                query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
1390
1391                String sql = query.toString();
1392
1393                Query q = session.createQuery(sql);
1394
1395                QueryPos qPos = QueryPos.getInstance(q);
1396
1397                qPos.add(classNameId);
1398
1399                list = q.list();
1400            }
1401            catch (Exception e) {
1402                throw processException(e);
1403            }
1404            finally {
1405                if (list == null) {
1406                    list = new ArrayList<SocialActivity>();
1407                }
1408
1409                cacheResult(list);
1410
1411                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_CLASSNAMEID,
1412                    finderArgs, list);
1413
1414                closeSession(session);
1415            }
1416        }
1417
1418        return list;
1419    }
1420
1421    public List<SocialActivity> findByClassNameId(long classNameId, int start,
1422        int end) throws SystemException {
1423        return findByClassNameId(classNameId, start, end, null);
1424    }
1425
1426    public List<SocialActivity> findByClassNameId(long classNameId, int start,
1427        int end, OrderByComparator orderByComparator) throws SystemException {
1428        Object[] finderArgs = new Object[] {
1429                new Long(classNameId),
1430                
1431                String.valueOf(start), String.valueOf(end),
1432                String.valueOf(orderByComparator)
1433            };
1434
1435        List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_CLASSNAMEID,
1436                finderArgs, this);
1437
1438        if (list == null) {
1439            Session session = null;
1440
1441            try {
1442                session = openSession();
1443
1444                StringBundler query = null;
1445
1446                if (orderByComparator != null) {
1447                    query = new StringBundler(3 +
1448                            (orderByComparator.getOrderByFields().length * 3));
1449                }
1450                else {
1451                    query = new StringBundler(3);
1452                }
1453
1454                query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
1455
1456                query.append(_FINDER_COLUMN_CLASSNAMEID_CLASSNAMEID_2);
1457
1458                if (orderByComparator != null) {
1459                    appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
1460                        orderByComparator);
1461                }
1462
1463                else {
1464                    query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
1465                }
1466
1467                String sql = query.toString();
1468
1469                Query q = session.createQuery(sql);
1470
1471                QueryPos qPos = QueryPos.getInstance(q);
1472
1473                qPos.add(classNameId);
1474
1475                list = (List<SocialActivity>)QueryUtil.list(q, getDialect(),
1476                        start, end);
1477            }
1478            catch (Exception e) {
1479                throw processException(e);
1480            }
1481            finally {
1482                if (list == null) {
1483                    list = new ArrayList<SocialActivity>();
1484                }
1485
1486                cacheResult(list);
1487
1488                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_CLASSNAMEID,
1489                    finderArgs, list);
1490
1491                closeSession(session);
1492            }
1493        }
1494
1495        return list;
1496    }
1497
1498    public SocialActivity findByClassNameId_First(long classNameId,
1499        OrderByComparator orderByComparator)
1500        throws NoSuchActivityException, SystemException {
1501        List<SocialActivity> list = findByClassNameId(classNameId, 0, 1,
1502                orderByComparator);
1503
1504        if (list.isEmpty()) {
1505            StringBundler msg = new StringBundler(4);
1506
1507            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1508
1509            msg.append("classNameId=");
1510            msg.append(classNameId);
1511
1512            msg.append(StringPool.CLOSE_CURLY_BRACE);
1513
1514            throw new NoSuchActivityException(msg.toString());
1515        }
1516        else {
1517            return list.get(0);
1518        }
1519    }
1520
1521    public SocialActivity findByClassNameId_Last(long classNameId,
1522        OrderByComparator orderByComparator)
1523        throws NoSuchActivityException, SystemException {
1524        int count = countByClassNameId(classNameId);
1525
1526        List<SocialActivity> list = findByClassNameId(classNameId, count - 1,
1527                count, orderByComparator);
1528
1529        if (list.isEmpty()) {
1530            StringBundler msg = new StringBundler(4);
1531
1532            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1533
1534            msg.append("classNameId=");
1535            msg.append(classNameId);
1536
1537            msg.append(StringPool.CLOSE_CURLY_BRACE);
1538
1539            throw new NoSuchActivityException(msg.toString());
1540        }
1541        else {
1542            return list.get(0);
1543        }
1544    }
1545
1546    public SocialActivity[] findByClassNameId_PrevAndNext(long activityId,
1547        long classNameId, OrderByComparator orderByComparator)
1548        throws NoSuchActivityException, SystemException {
1549        SocialActivity socialActivity = findByPrimaryKey(activityId);
1550
1551        int count = countByClassNameId(classNameId);
1552
1553        Session session = null;
1554
1555        try {
1556            session = openSession();
1557
1558            StringBundler query = null;
1559
1560            if (orderByComparator != null) {
1561                query = new StringBundler(3 +
1562                        (orderByComparator.getOrderByFields().length * 3));
1563            }
1564            else {
1565                query = new StringBundler(3);
1566            }
1567
1568            query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
1569
1570            query.append(_FINDER_COLUMN_CLASSNAMEID_CLASSNAMEID_2);
1571
1572            if (orderByComparator != null) {
1573                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
1574                    orderByComparator);
1575            }
1576
1577            else {
1578                query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
1579            }
1580
1581            String sql = query.toString();
1582
1583            Query q = session.createQuery(sql);
1584
1585            QueryPos qPos = QueryPos.getInstance(q);
1586
1587            qPos.add(classNameId);
1588
1589            Object[] objArray = QueryUtil.getPrevAndNext(q, count,
1590                    orderByComparator, socialActivity);
1591
1592            SocialActivity[] array = new SocialActivityImpl[3];
1593
1594            array[0] = (SocialActivity)objArray[0];
1595            array[1] = (SocialActivity)objArray[1];
1596            array[2] = (SocialActivity)objArray[2];
1597
1598            return array;
1599        }
1600        catch (Exception e) {
1601            throw processException(e);
1602        }
1603        finally {
1604            closeSession(session);
1605        }
1606    }
1607
1608    public List<SocialActivity> findByReceiverUserId(long receiverUserId)
1609        throws SystemException {
1610        Object[] finderArgs = new Object[] { new Long(receiverUserId) };
1611
1612        List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_RECEIVERUSERID,
1613                finderArgs, this);
1614
1615        if (list == null) {
1616            Session session = null;
1617
1618            try {
1619                session = openSession();
1620
1621                StringBundler query = new StringBundler(3);
1622
1623                query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
1624
1625                query.append(_FINDER_COLUMN_RECEIVERUSERID_RECEIVERUSERID_2);
1626
1627                query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
1628
1629                String sql = query.toString();
1630
1631                Query q = session.createQuery(sql);
1632
1633                QueryPos qPos = QueryPos.getInstance(q);
1634
1635                qPos.add(receiverUserId);
1636
1637                list = q.list();
1638            }
1639            catch (Exception e) {
1640                throw processException(e);
1641            }
1642            finally {
1643                if (list == null) {
1644                    list = new ArrayList<SocialActivity>();
1645                }
1646
1647                cacheResult(list);
1648
1649                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_RECEIVERUSERID,
1650                    finderArgs, list);
1651
1652                closeSession(session);
1653            }
1654        }
1655
1656        return list;
1657    }
1658
1659    public List<SocialActivity> findByReceiverUserId(long receiverUserId,
1660        int start, int end) throws SystemException {
1661        return findByReceiverUserId(receiverUserId, start, end, null);
1662    }
1663
1664    public List<SocialActivity> findByReceiverUserId(long receiverUserId,
1665        int start, int end, OrderByComparator orderByComparator)
1666        throws SystemException {
1667        Object[] finderArgs = new Object[] {
1668                new Long(receiverUserId),
1669                
1670                String.valueOf(start), String.valueOf(end),
1671                String.valueOf(orderByComparator)
1672            };
1673
1674        List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_RECEIVERUSERID,
1675                finderArgs, this);
1676
1677        if (list == null) {
1678            Session session = null;
1679
1680            try {
1681                session = openSession();
1682
1683                StringBundler query = null;
1684
1685                if (orderByComparator != null) {
1686                    query = new StringBundler(3 +
1687                            (orderByComparator.getOrderByFields().length * 3));
1688                }
1689                else {
1690                    query = new StringBundler(3);
1691                }
1692
1693                query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
1694
1695                query.append(_FINDER_COLUMN_RECEIVERUSERID_RECEIVERUSERID_2);
1696
1697                if (orderByComparator != null) {
1698                    appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
1699                        orderByComparator);
1700                }
1701
1702                else {
1703                    query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
1704                }
1705
1706                String sql = query.toString();
1707
1708                Query q = session.createQuery(sql);
1709
1710                QueryPos qPos = QueryPos.getInstance(q);
1711
1712                qPos.add(receiverUserId);
1713
1714                list = (List<SocialActivity>)QueryUtil.list(q, getDialect(),
1715                        start, end);
1716            }
1717            catch (Exception e) {
1718                throw processException(e);
1719            }
1720            finally {
1721                if (list == null) {
1722                    list = new ArrayList<SocialActivity>();
1723                }
1724
1725                cacheResult(list);
1726
1727                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_RECEIVERUSERID,
1728                    finderArgs, list);
1729
1730                closeSession(session);
1731            }
1732        }
1733
1734        return list;
1735    }
1736
1737    public SocialActivity findByReceiverUserId_First(long receiverUserId,
1738        OrderByComparator orderByComparator)
1739        throws NoSuchActivityException, SystemException {
1740        List<SocialActivity> list = findByReceiverUserId(receiverUserId, 0, 1,
1741                orderByComparator);
1742
1743        if (list.isEmpty()) {
1744            StringBundler msg = new StringBundler(4);
1745
1746            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1747
1748            msg.append("receiverUserId=");
1749            msg.append(receiverUserId);
1750
1751            msg.append(StringPool.CLOSE_CURLY_BRACE);
1752
1753            throw new NoSuchActivityException(msg.toString());
1754        }
1755        else {
1756            return list.get(0);
1757        }
1758    }
1759
1760    public SocialActivity findByReceiverUserId_Last(long receiverUserId,
1761        OrderByComparator orderByComparator)
1762        throws NoSuchActivityException, SystemException {
1763        int count = countByReceiverUserId(receiverUserId);
1764
1765        List<SocialActivity> list = findByReceiverUserId(receiverUserId,
1766                count - 1, count, orderByComparator);
1767
1768        if (list.isEmpty()) {
1769            StringBundler msg = new StringBundler(4);
1770
1771            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1772
1773            msg.append("receiverUserId=");
1774            msg.append(receiverUserId);
1775
1776            msg.append(StringPool.CLOSE_CURLY_BRACE);
1777
1778            throw new NoSuchActivityException(msg.toString());
1779        }
1780        else {
1781            return list.get(0);
1782        }
1783    }
1784
1785    public SocialActivity[] findByReceiverUserId_PrevAndNext(long activityId,
1786        long receiverUserId, OrderByComparator orderByComparator)
1787        throws NoSuchActivityException, SystemException {
1788        SocialActivity socialActivity = findByPrimaryKey(activityId);
1789
1790        int count = countByReceiverUserId(receiverUserId);
1791
1792        Session session = null;
1793
1794        try {
1795            session = openSession();
1796
1797            StringBundler query = null;
1798
1799            if (orderByComparator != null) {
1800                query = new StringBundler(3 +
1801                        (orderByComparator.getOrderByFields().length * 3));
1802            }
1803            else {
1804                query = new StringBundler(3);
1805            }
1806
1807            query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
1808
1809            query.append(_FINDER_COLUMN_RECEIVERUSERID_RECEIVERUSERID_2);
1810
1811            if (orderByComparator != null) {
1812                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
1813                    orderByComparator);
1814            }
1815
1816            else {
1817                query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
1818            }
1819
1820            String sql = query.toString();
1821
1822            Query q = session.createQuery(sql);
1823
1824            QueryPos qPos = QueryPos.getInstance(q);
1825
1826            qPos.add(receiverUserId);
1827
1828            Object[] objArray = QueryUtil.getPrevAndNext(q, count,
1829                    orderByComparator, socialActivity);
1830
1831            SocialActivity[] array = new SocialActivityImpl[3];
1832
1833            array[0] = (SocialActivity)objArray[0];
1834            array[1] = (SocialActivity)objArray[1];
1835            array[2] = (SocialActivity)objArray[2];
1836
1837            return array;
1838        }
1839        catch (Exception e) {
1840            throw processException(e);
1841        }
1842        finally {
1843            closeSession(session);
1844        }
1845    }
1846
1847    public List<SocialActivity> findByC_C(long classNameId, long classPK)
1848        throws SystemException {
1849        Object[] finderArgs = new Object[] {
1850                new Long(classNameId), new Long(classPK)
1851            };
1852
1853        List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_C_C,
1854                finderArgs, this);
1855
1856        if (list == null) {
1857            Session session = null;
1858
1859            try {
1860                session = openSession();
1861
1862                StringBundler query = new StringBundler(4);
1863
1864                query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
1865
1866                query.append(_FINDER_COLUMN_C_C_CLASSNAMEID_2);
1867
1868                query.append(_FINDER_COLUMN_C_C_CLASSPK_2);
1869
1870                query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
1871
1872                String sql = query.toString();
1873
1874                Query q = session.createQuery(sql);
1875
1876                QueryPos qPos = QueryPos.getInstance(q);
1877
1878                qPos.add(classNameId);
1879
1880                qPos.add(classPK);
1881
1882                list = q.list();
1883            }
1884            catch (Exception e) {
1885                throw processException(e);
1886            }
1887            finally {
1888                if (list == null) {
1889                    list = new ArrayList<SocialActivity>();
1890                }
1891
1892                cacheResult(list);
1893
1894                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_C_C, finderArgs,
1895                    list);
1896
1897                closeSession(session);
1898            }
1899        }
1900
1901        return list;
1902    }
1903
1904    public List<SocialActivity> findByC_C(long classNameId, long classPK,
1905        int start, int end) throws SystemException {
1906        return findByC_C(classNameId, classPK, start, end, null);
1907    }
1908
1909    public List<SocialActivity> findByC_C(long classNameId, long classPK,
1910        int start, int end, OrderByComparator orderByComparator)
1911        throws SystemException {
1912        Object[] finderArgs = new Object[] {
1913                new Long(classNameId), new Long(classPK),
1914                
1915                String.valueOf(start), String.valueOf(end),
1916                String.valueOf(orderByComparator)
1917            };
1918
1919        List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_C_C,
1920                finderArgs, this);
1921
1922        if (list == null) {
1923            Session session = null;
1924
1925            try {
1926                session = openSession();
1927
1928                StringBundler query = null;
1929
1930                if (orderByComparator != null) {
1931                    query = new StringBundler(4 +
1932                            (orderByComparator.getOrderByFields().length * 3));
1933                }
1934                else {
1935                    query = new StringBundler(4);
1936                }
1937
1938                query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
1939
1940                query.append(_FINDER_COLUMN_C_C_CLASSNAMEID_2);
1941
1942                query.append(_FINDER_COLUMN_C_C_CLASSPK_2);
1943
1944                if (orderByComparator != null) {
1945                    appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
1946                        orderByComparator);
1947                }
1948
1949                else {
1950                    query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
1951                }
1952
1953                String sql = query.toString();
1954
1955                Query q = session.createQuery(sql);
1956
1957                QueryPos qPos = QueryPos.getInstance(q);
1958
1959                qPos.add(classNameId);
1960
1961                qPos.add(classPK);
1962
1963                list = (List<SocialActivity>)QueryUtil.list(q, getDialect(),
1964                        start, end);
1965            }
1966            catch (Exception e) {
1967                throw processException(e);
1968            }
1969            finally {
1970                if (list == null) {
1971                    list = new ArrayList<SocialActivity>();
1972                }
1973
1974                cacheResult(list);
1975
1976                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_C_C,
1977                    finderArgs, list);
1978
1979                closeSession(session);
1980            }
1981        }
1982
1983        return list;
1984    }
1985
1986    public SocialActivity findByC_C_First(long classNameId, long classPK,
1987        OrderByComparator orderByComparator)
1988        throws NoSuchActivityException, SystemException {
1989        List<SocialActivity> list = findByC_C(classNameId, classPK, 0, 1,
1990                orderByComparator);
1991
1992        if (list.isEmpty()) {
1993            StringBundler msg = new StringBundler(6);
1994
1995            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
1996
1997            msg.append("classNameId=");
1998            msg.append(classNameId);
1999
2000            msg.append(", classPK=");
2001            msg.append(classPK);
2002
2003            msg.append(StringPool.CLOSE_CURLY_BRACE);
2004
2005            throw new NoSuchActivityException(msg.toString());
2006        }
2007        else {
2008            return list.get(0);
2009        }
2010    }
2011
2012    public SocialActivity findByC_C_Last(long classNameId, long classPK,
2013        OrderByComparator orderByComparator)
2014        throws NoSuchActivityException, SystemException {
2015        int count = countByC_C(classNameId, classPK);
2016
2017        List<SocialActivity> list = findByC_C(classNameId, classPK, count - 1,
2018                count, orderByComparator);
2019
2020        if (list.isEmpty()) {
2021            StringBundler msg = new StringBundler(6);
2022
2023            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
2024
2025            msg.append("classNameId=");
2026            msg.append(classNameId);
2027
2028            msg.append(", classPK=");
2029            msg.append(classPK);
2030
2031            msg.append(StringPool.CLOSE_CURLY_BRACE);
2032
2033            throw new NoSuchActivityException(msg.toString());
2034        }
2035        else {
2036            return list.get(0);
2037        }
2038    }
2039
2040    public SocialActivity[] findByC_C_PrevAndNext(long activityId,
2041        long classNameId, long classPK, OrderByComparator orderByComparator)
2042        throws NoSuchActivityException, SystemException {
2043        SocialActivity socialActivity = findByPrimaryKey(activityId);
2044
2045        int count = countByC_C(classNameId, classPK);
2046
2047        Session session = null;
2048
2049        try {
2050            session = openSession();
2051
2052            StringBundler query = null;
2053
2054            if (orderByComparator != null) {
2055                query = new StringBundler(4 +
2056                        (orderByComparator.getOrderByFields().length * 3));
2057            }
2058            else {
2059                query = new StringBundler(4);
2060            }
2061
2062            query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
2063
2064            query.append(_FINDER_COLUMN_C_C_CLASSNAMEID_2);
2065
2066            query.append(_FINDER_COLUMN_C_C_CLASSPK_2);
2067
2068            if (orderByComparator != null) {
2069                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
2070                    orderByComparator);
2071            }
2072
2073            else {
2074                query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
2075            }
2076
2077            String sql = query.toString();
2078
2079            Query q = session.createQuery(sql);
2080
2081            QueryPos qPos = QueryPos.getInstance(q);
2082
2083            qPos.add(classNameId);
2084
2085            qPos.add(classPK);
2086
2087            Object[] objArray = QueryUtil.getPrevAndNext(q, count,
2088                    orderByComparator, socialActivity);
2089
2090            SocialActivity[] array = new SocialActivityImpl[3];
2091
2092            array[0] = (SocialActivity)objArray[0];
2093            array[1] = (SocialActivity)objArray[1];
2094            array[2] = (SocialActivity)objArray[2];
2095
2096            return array;
2097        }
2098        catch (Exception e) {
2099            throw processException(e);
2100        }
2101        finally {
2102            closeSession(session);
2103        }
2104    }
2105
2106    public List<SocialActivity> findByM_C_C(long mirrorActivityId,
2107        long classNameId, long classPK) throws SystemException {
2108        Object[] finderArgs = new Object[] {
2109                new Long(mirrorActivityId), new Long(classNameId),
2110                new Long(classPK)
2111            };
2112
2113        List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_M_C_C,
2114                finderArgs, this);
2115
2116        if (list == null) {
2117            Session session = null;
2118
2119            try {
2120                session = openSession();
2121
2122                StringBundler query = new StringBundler(5);
2123
2124                query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
2125
2126                query.append(_FINDER_COLUMN_M_C_C_MIRRORACTIVITYID_2);
2127
2128                query.append(_FINDER_COLUMN_M_C_C_CLASSNAMEID_2);
2129
2130                query.append(_FINDER_COLUMN_M_C_C_CLASSPK_2);
2131
2132                query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
2133
2134                String sql = query.toString();
2135
2136                Query q = session.createQuery(sql);
2137
2138                QueryPos qPos = QueryPos.getInstance(q);
2139
2140                qPos.add(mirrorActivityId);
2141
2142                qPos.add(classNameId);
2143
2144                qPos.add(classPK);
2145
2146                list = q.list();
2147            }
2148            catch (Exception e) {
2149                throw processException(e);
2150            }
2151            finally {
2152                if (list == null) {
2153                    list = new ArrayList<SocialActivity>();
2154                }
2155
2156                cacheResult(list);
2157
2158                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_M_C_C,
2159                    finderArgs, list);
2160
2161                closeSession(session);
2162            }
2163        }
2164
2165        return list;
2166    }
2167
2168    public List<SocialActivity> findByM_C_C(long mirrorActivityId,
2169        long classNameId, long classPK, int start, int end)
2170        throws SystemException {
2171        return findByM_C_C(mirrorActivityId, classNameId, classPK, start, end,
2172            null);
2173    }
2174
2175    public List<SocialActivity> findByM_C_C(long mirrorActivityId,
2176        long classNameId, long classPK, int start, int end,
2177        OrderByComparator orderByComparator) throws SystemException {
2178        Object[] finderArgs = new Object[] {
2179                new Long(mirrorActivityId), new Long(classNameId),
2180                new Long(classPK),
2181                
2182                String.valueOf(start), String.valueOf(end),
2183                String.valueOf(orderByComparator)
2184            };
2185
2186        List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_BY_OBC_M_C_C,
2187                finderArgs, this);
2188
2189        if (list == null) {
2190            Session session = null;
2191
2192            try {
2193                session = openSession();
2194
2195                StringBundler query = null;
2196
2197                if (orderByComparator != null) {
2198                    query = new StringBundler(5 +
2199                            (orderByComparator.getOrderByFields().length * 3));
2200                }
2201                else {
2202                    query = new StringBundler(5);
2203                }
2204
2205                query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
2206
2207                query.append(_FINDER_COLUMN_M_C_C_MIRRORACTIVITYID_2);
2208
2209                query.append(_FINDER_COLUMN_M_C_C_CLASSNAMEID_2);
2210
2211                query.append(_FINDER_COLUMN_M_C_C_CLASSPK_2);
2212
2213                if (orderByComparator != null) {
2214                    appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
2215                        orderByComparator);
2216                }
2217
2218                else {
2219                    query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
2220                }
2221
2222                String sql = query.toString();
2223
2224                Query q = session.createQuery(sql);
2225
2226                QueryPos qPos = QueryPos.getInstance(q);
2227
2228                qPos.add(mirrorActivityId);
2229
2230                qPos.add(classNameId);
2231
2232                qPos.add(classPK);
2233
2234                list = (List<SocialActivity>)QueryUtil.list(q, getDialect(),
2235                        start, end);
2236            }
2237            catch (Exception e) {
2238                throw processException(e);
2239            }
2240            finally {
2241                if (list == null) {
2242                    list = new ArrayList<SocialActivity>();
2243                }
2244
2245                cacheResult(list);
2246
2247                FinderCacheUtil.putResult(FINDER_PATH_FIND_BY_OBC_M_C_C,
2248                    finderArgs, list);
2249
2250                closeSession(session);
2251            }
2252        }
2253
2254        return list;
2255    }
2256
2257    public SocialActivity findByM_C_C_First(long mirrorActivityId,
2258        long classNameId, long classPK, OrderByComparator orderByComparator)
2259        throws NoSuchActivityException, SystemException {
2260        List<SocialActivity> list = findByM_C_C(mirrorActivityId, classNameId,
2261                classPK, 0, 1, orderByComparator);
2262
2263        if (list.isEmpty()) {
2264            StringBundler msg = new StringBundler(8);
2265
2266            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
2267
2268            msg.append("mirrorActivityId=");
2269            msg.append(mirrorActivityId);
2270
2271            msg.append(", classNameId=");
2272            msg.append(classNameId);
2273
2274            msg.append(", classPK=");
2275            msg.append(classPK);
2276
2277            msg.append(StringPool.CLOSE_CURLY_BRACE);
2278
2279            throw new NoSuchActivityException(msg.toString());
2280        }
2281        else {
2282            return list.get(0);
2283        }
2284    }
2285
2286    public SocialActivity findByM_C_C_Last(long mirrorActivityId,
2287        long classNameId, long classPK, OrderByComparator orderByComparator)
2288        throws NoSuchActivityException, SystemException {
2289        int count = countByM_C_C(mirrorActivityId, classNameId, classPK);
2290
2291        List<SocialActivity> list = findByM_C_C(mirrorActivityId, classNameId,
2292                classPK, count - 1, count, orderByComparator);
2293
2294        if (list.isEmpty()) {
2295            StringBundler msg = new StringBundler(8);
2296
2297            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
2298
2299            msg.append("mirrorActivityId=");
2300            msg.append(mirrorActivityId);
2301
2302            msg.append(", classNameId=");
2303            msg.append(classNameId);
2304
2305            msg.append(", classPK=");
2306            msg.append(classPK);
2307
2308            msg.append(StringPool.CLOSE_CURLY_BRACE);
2309
2310            throw new NoSuchActivityException(msg.toString());
2311        }
2312        else {
2313            return list.get(0);
2314        }
2315    }
2316
2317    public SocialActivity[] findByM_C_C_PrevAndNext(long activityId,
2318        long mirrorActivityId, long classNameId, long classPK,
2319        OrderByComparator orderByComparator)
2320        throws NoSuchActivityException, SystemException {
2321        SocialActivity socialActivity = findByPrimaryKey(activityId);
2322
2323        int count = countByM_C_C(mirrorActivityId, classNameId, classPK);
2324
2325        Session session = null;
2326
2327        try {
2328            session = openSession();
2329
2330            StringBundler query = null;
2331
2332            if (orderByComparator != null) {
2333                query = new StringBundler(5 +
2334                        (orderByComparator.getOrderByFields().length * 3));
2335            }
2336            else {
2337                query = new StringBundler(5);
2338            }
2339
2340            query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
2341
2342            query.append(_FINDER_COLUMN_M_C_C_MIRRORACTIVITYID_2);
2343
2344            query.append(_FINDER_COLUMN_M_C_C_CLASSNAMEID_2);
2345
2346            query.append(_FINDER_COLUMN_M_C_C_CLASSPK_2);
2347
2348            if (orderByComparator != null) {
2349                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
2350                    orderByComparator);
2351            }
2352
2353            else {
2354                query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
2355            }
2356
2357            String sql = query.toString();
2358
2359            Query q = session.createQuery(sql);
2360
2361            QueryPos qPos = QueryPos.getInstance(q);
2362
2363            qPos.add(mirrorActivityId);
2364
2365            qPos.add(classNameId);
2366
2367            qPos.add(classPK);
2368
2369            Object[] objArray = QueryUtil.getPrevAndNext(q, count,
2370                    orderByComparator, socialActivity);
2371
2372            SocialActivity[] array = new SocialActivityImpl[3];
2373
2374            array[0] = (SocialActivity)objArray[0];
2375            array[1] = (SocialActivity)objArray[1];
2376            array[2] = (SocialActivity)objArray[2];
2377
2378            return array;
2379        }
2380        catch (Exception e) {
2381            throw processException(e);
2382        }
2383        finally {
2384            closeSession(session);
2385        }
2386    }
2387
2388    public SocialActivity findByG_U_CD_C_C_T_R(long groupId, long userId,
2389        long createDate, long classNameId, long classPK, int type,
2390        long receiverUserId) throws NoSuchActivityException, SystemException {
2391        SocialActivity socialActivity = fetchByG_U_CD_C_C_T_R(groupId, userId,
2392                createDate, classNameId, classPK, type, receiverUserId);
2393
2394        if (socialActivity == null) {
2395            StringBundler msg = new StringBundler(16);
2396
2397            msg.append(_NO_SUCH_ENTITY_WITH_KEY);
2398
2399            msg.append("groupId=");
2400            msg.append(groupId);
2401
2402            msg.append(", userId=");
2403            msg.append(userId);
2404
2405            msg.append(", createDate=");
2406            msg.append(createDate);
2407
2408            msg.append(", classNameId=");
2409            msg.append(classNameId);
2410
2411            msg.append(", classPK=");
2412            msg.append(classPK);
2413
2414            msg.append(", type=");
2415            msg.append(type);
2416
2417            msg.append(", receiverUserId=");
2418            msg.append(receiverUserId);
2419
2420            msg.append(StringPool.CLOSE_CURLY_BRACE);
2421
2422            if (_log.isWarnEnabled()) {
2423                _log.warn(msg.toString());
2424            }
2425
2426            throw new NoSuchActivityException(msg.toString());
2427        }
2428
2429        return socialActivity;
2430    }
2431
2432    public SocialActivity fetchByG_U_CD_C_C_T_R(long groupId, long userId,
2433        long createDate, long classNameId, long classPK, int type,
2434        long receiverUserId) throws SystemException {
2435        return fetchByG_U_CD_C_C_T_R(groupId, userId, createDate, classNameId,
2436            classPK, type, receiverUserId, true);
2437    }
2438
2439    public SocialActivity fetchByG_U_CD_C_C_T_R(long groupId, long userId,
2440        long createDate, long classNameId, long classPK, int type,
2441        long receiverUserId, boolean retrieveFromCache)
2442        throws SystemException {
2443        Object[] finderArgs = new Object[] {
2444                new Long(groupId), new Long(userId), new Long(createDate),
2445                new Long(classNameId), new Long(classPK), new Integer(type),
2446                new Long(receiverUserId)
2447            };
2448
2449        Object result = null;
2450
2451        if (retrieveFromCache) {
2452            result = FinderCacheUtil.getResult(FINDER_PATH_FETCH_BY_G_U_CD_C_C_T_R,
2453                    finderArgs, this);
2454        }
2455
2456        if (result == null) {
2457            Session session = null;
2458
2459            try {
2460                session = openSession();
2461
2462                StringBundler query = new StringBundler(9);
2463
2464                query.append(_SQL_SELECT_SOCIALACTIVITY_WHERE);
2465
2466                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_GROUPID_2);
2467
2468                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_USERID_2);
2469
2470                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_CREATEDATE_2);
2471
2472                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_CLASSNAMEID_2);
2473
2474                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_CLASSPK_2);
2475
2476                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_TYPE_2);
2477
2478                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_RECEIVERUSERID_2);
2479
2480                query.append(SocialActivityModelImpl.ORDER_BY_JPQL);
2481
2482                String sql = query.toString();
2483
2484                Query q = session.createQuery(sql);
2485
2486                QueryPos qPos = QueryPos.getInstance(q);
2487
2488                qPos.add(groupId);
2489
2490                qPos.add(userId);
2491
2492                qPos.add(createDate);
2493
2494                qPos.add(classNameId);
2495
2496                qPos.add(classPK);
2497
2498                qPos.add(type);
2499
2500                qPos.add(receiverUserId);
2501
2502                List<SocialActivity> list = q.list();
2503
2504                result = list;
2505
2506                SocialActivity socialActivity = null;
2507
2508                if (list.isEmpty()) {
2509                    FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_G_U_CD_C_C_T_R,
2510                        finderArgs, list);
2511                }
2512                else {
2513                    socialActivity = list.get(0);
2514
2515                    cacheResult(socialActivity);
2516
2517                    if ((socialActivity.getGroupId() != groupId) ||
2518                            (socialActivity.getUserId() != userId) ||
2519                            (socialActivity.getCreateDate() != createDate) ||
2520                            (socialActivity.getClassNameId() != classNameId) ||
2521                            (socialActivity.getClassPK() != classPK) ||
2522                            (socialActivity.getType() != type) ||
2523                            (socialActivity.getReceiverUserId() != receiverUserId)) {
2524                        FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_G_U_CD_C_C_T_R,
2525                            finderArgs, socialActivity);
2526                    }
2527                }
2528
2529                return socialActivity;
2530            }
2531            catch (Exception e) {
2532                throw processException(e);
2533            }
2534            finally {
2535                if (result == null) {
2536                    FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_G_U_CD_C_C_T_R,
2537                        finderArgs, new ArrayList<SocialActivity>());
2538                }
2539
2540                closeSession(session);
2541            }
2542        }
2543        else {
2544            if (result instanceof List<?>) {
2545                return null;
2546            }
2547            else {
2548                return (SocialActivity)result;
2549            }
2550        }
2551    }
2552
2553    public List<SocialActivity> findAll() throws SystemException {
2554        return findAll(QueryUtil.ALL_POS, QueryUtil.ALL_POS, null);
2555    }
2556
2557    public List<SocialActivity> findAll(int start, int end)
2558        throws SystemException {
2559        return findAll(start, end, null);
2560    }
2561
2562    public List<SocialActivity> findAll(int start, int end,
2563        OrderByComparator orderByComparator) throws SystemException {
2564        Object[] finderArgs = new Object[] {
2565                String.valueOf(start), String.valueOf(end),
2566                String.valueOf(orderByComparator)
2567            };
2568
2569        List<SocialActivity> list = (List<SocialActivity>)FinderCacheUtil.getResult(FINDER_PATH_FIND_ALL,
2570                finderArgs, this);
2571
2572        if (list == null) {
2573            Session session = null;
2574
2575            try {
2576                session = openSession();
2577
2578                StringBundler query = null;
2579                String sql = null;
2580
2581                if (orderByComparator != null) {
2582                    query = new StringBundler(2 +
2583                            (orderByComparator.getOrderByFields().length * 3));
2584
2585                    query.append(_SQL_SELECT_SOCIALACTIVITY);
2586
2587                    appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,
2588                        orderByComparator);
2589
2590                    sql = query.toString();
2591                }
2592
2593                else {
2594                    sql = _SQL_SELECT_SOCIALACTIVITY.concat(SocialActivityModelImpl.ORDER_BY_JPQL);
2595                }
2596
2597                Query q = session.createQuery(sql);
2598
2599                if (orderByComparator == null) {
2600                    list = (List<SocialActivity>)QueryUtil.list(q,
2601                            getDialect(), start, end, false);
2602
2603                    Collections.sort(list);
2604                }
2605                else {
2606                    list = (List<SocialActivity>)QueryUtil.list(q,
2607                            getDialect(), start, end);
2608                }
2609            }
2610            catch (Exception e) {
2611                throw processException(e);
2612            }
2613            finally {
2614                if (list == null) {
2615                    list = new ArrayList<SocialActivity>();
2616                }
2617
2618                cacheResult(list);
2619
2620                FinderCacheUtil.putResult(FINDER_PATH_FIND_ALL, finderArgs, list);
2621
2622                closeSession(session);
2623            }
2624        }
2625
2626        return list;
2627    }
2628
2629    public void removeByGroupId(long groupId) throws SystemException {
2630        for (SocialActivity socialActivity : findByGroupId(groupId)) {
2631            remove(socialActivity);
2632        }
2633    }
2634
2635    public void removeByCompanyId(long companyId) throws SystemException {
2636        for (SocialActivity socialActivity : findByCompanyId(companyId)) {
2637            remove(socialActivity);
2638        }
2639    }
2640
2641    public void removeByUserId(long userId) throws SystemException {
2642        for (SocialActivity socialActivity : findByUserId(userId)) {
2643            remove(socialActivity);
2644        }
2645    }
2646
2647    public void removeByMirrorActivityId(long mirrorActivityId)
2648        throws NoSuchActivityException, SystemException {
2649        SocialActivity socialActivity = findByMirrorActivityId(mirrorActivityId);
2650
2651        remove(socialActivity);
2652    }
2653
2654    public void removeByClassNameId(long classNameId) throws SystemException {
2655        for (SocialActivity socialActivity : findByClassNameId(classNameId)) {
2656            remove(socialActivity);
2657        }
2658    }
2659
2660    public void removeByReceiverUserId(long receiverUserId)
2661        throws SystemException {
2662        for (SocialActivity socialActivity : findByReceiverUserId(
2663                receiverUserId)) {
2664            remove(socialActivity);
2665        }
2666    }
2667
2668    public void removeByC_C(long classNameId, long classPK)
2669        throws SystemException {
2670        for (SocialActivity socialActivity : findByC_C(classNameId, classPK)) {
2671            remove(socialActivity);
2672        }
2673    }
2674
2675    public void removeByM_C_C(long mirrorActivityId, long classNameId,
2676        long classPK) throws SystemException {
2677        for (SocialActivity socialActivity : findByM_C_C(mirrorActivityId,
2678                classNameId, classPK)) {
2679            remove(socialActivity);
2680        }
2681    }
2682
2683    public void removeByG_U_CD_C_C_T_R(long groupId, long userId,
2684        long createDate, long classNameId, long classPK, int type,
2685        long receiverUserId) throws NoSuchActivityException, SystemException {
2686        SocialActivity socialActivity = findByG_U_CD_C_C_T_R(groupId, userId,
2687                createDate, classNameId, classPK, type, receiverUserId);
2688
2689        remove(socialActivity);
2690    }
2691
2692    public void removeAll() throws SystemException {
2693        for (SocialActivity socialActivity : findAll()) {
2694            remove(socialActivity);
2695        }
2696    }
2697
2698    public int countByGroupId(long groupId) throws SystemException {
2699        Object[] finderArgs = new Object[] { new Long(groupId) };
2700
2701        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_GROUPID,
2702                finderArgs, this);
2703
2704        if (count == null) {
2705            Session session = null;
2706
2707            try {
2708                session = openSession();
2709
2710                StringBundler query = new StringBundler(2);
2711
2712                query.append(_SQL_COUNT_SOCIALACTIVITY_WHERE);
2713
2714                query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);
2715
2716                String sql = query.toString();
2717
2718                Query q = session.createQuery(sql);
2719
2720                QueryPos qPos = QueryPos.getInstance(q);
2721
2722                qPos.add(groupId);
2723
2724                count = (Long)q.uniqueResult();
2725            }
2726            catch (Exception e) {
2727                throw processException(e);
2728            }
2729            finally {
2730                if (count == null) {
2731                    count = Long.valueOf(0);
2732                }
2733
2734                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_GROUPID,
2735                    finderArgs, count);
2736
2737                closeSession(session);
2738            }
2739        }
2740
2741        return count.intValue();
2742    }
2743
2744    public int countByCompanyId(long companyId) throws SystemException {
2745        Object[] finderArgs = new Object[] { new Long(companyId) };
2746
2747        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_COMPANYID,
2748                finderArgs, this);
2749
2750        if (count == null) {
2751            Session session = null;
2752
2753            try {
2754                session = openSession();
2755
2756                StringBundler query = new StringBundler(2);
2757
2758                query.append(_SQL_COUNT_SOCIALACTIVITY_WHERE);
2759
2760                query.append(_FINDER_COLUMN_COMPANYID_COMPANYID_2);
2761
2762                String sql = query.toString();
2763
2764                Query q = session.createQuery(sql);
2765
2766                QueryPos qPos = QueryPos.getInstance(q);
2767
2768                qPos.add(companyId);
2769
2770                count = (Long)q.uniqueResult();
2771            }
2772            catch (Exception e) {
2773                throw processException(e);
2774            }
2775            finally {
2776                if (count == null) {
2777                    count = Long.valueOf(0);
2778                }
2779
2780                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_COMPANYID,
2781                    finderArgs, count);
2782
2783                closeSession(session);
2784            }
2785        }
2786
2787        return count.intValue();
2788    }
2789
2790    public int countByUserId(long userId) throws SystemException {
2791        Object[] finderArgs = new Object[] { new Long(userId) };
2792
2793        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_USERID,
2794                finderArgs, this);
2795
2796        if (count == null) {
2797            Session session = null;
2798
2799            try {
2800                session = openSession();
2801
2802                StringBundler query = new StringBundler(2);
2803
2804                query.append(_SQL_COUNT_SOCIALACTIVITY_WHERE);
2805
2806                query.append(_FINDER_COLUMN_USERID_USERID_2);
2807
2808                String sql = query.toString();
2809
2810                Query q = session.createQuery(sql);
2811
2812                QueryPos qPos = QueryPos.getInstance(q);
2813
2814                qPos.add(userId);
2815
2816                count = (Long)q.uniqueResult();
2817            }
2818            catch (Exception e) {
2819                throw processException(e);
2820            }
2821            finally {
2822                if (count == null) {
2823                    count = Long.valueOf(0);
2824                }
2825
2826                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_USERID,
2827                    finderArgs, count);
2828
2829                closeSession(session);
2830            }
2831        }
2832
2833        return count.intValue();
2834    }
2835
2836    public int countByMirrorActivityId(long mirrorActivityId)
2837        throws SystemException {
2838        Object[] finderArgs = new Object[] { new Long(mirrorActivityId) };
2839
2840        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_MIRRORACTIVITYID,
2841                finderArgs, this);
2842
2843        if (count == null) {
2844            Session session = null;
2845
2846            try {
2847                session = openSession();
2848
2849                StringBundler query = new StringBundler(2);
2850
2851                query.append(_SQL_COUNT_SOCIALACTIVITY_WHERE);
2852
2853                query.append(_FINDER_COLUMN_MIRRORACTIVITYID_MIRRORACTIVITYID_2);
2854
2855                String sql = query.toString();
2856
2857                Query q = session.createQuery(sql);
2858
2859                QueryPos qPos = QueryPos.getInstance(q);
2860
2861                qPos.add(mirrorActivityId);
2862
2863                count = (Long)q.uniqueResult();
2864            }
2865            catch (Exception e) {
2866                throw processException(e);
2867            }
2868            finally {
2869                if (count == null) {
2870                    count = Long.valueOf(0);
2871                }
2872
2873                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_MIRRORACTIVITYID,
2874                    finderArgs, count);
2875
2876                closeSession(session);
2877            }
2878        }
2879
2880        return count.intValue();
2881    }
2882
2883    public int countByClassNameId(long classNameId) throws SystemException {
2884        Object[] finderArgs = new Object[] { new Long(classNameId) };
2885
2886        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_CLASSNAMEID,
2887                finderArgs, this);
2888
2889        if (count == null) {
2890            Session session = null;
2891
2892            try {
2893                session = openSession();
2894
2895                StringBundler query = new StringBundler(2);
2896
2897                query.append(_SQL_COUNT_SOCIALACTIVITY_WHERE);
2898
2899                query.append(_FINDER_COLUMN_CLASSNAMEID_CLASSNAMEID_2);
2900
2901                String sql = query.toString();
2902
2903                Query q = session.createQuery(sql);
2904
2905                QueryPos qPos = QueryPos.getInstance(q);
2906
2907                qPos.add(classNameId);
2908
2909                count = (Long)q.uniqueResult();
2910            }
2911            catch (Exception e) {
2912                throw processException(e);
2913            }
2914            finally {
2915                if (count == null) {
2916                    count = Long.valueOf(0);
2917                }
2918
2919                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_CLASSNAMEID,
2920                    finderArgs, count);
2921
2922                closeSession(session);
2923            }
2924        }
2925
2926        return count.intValue();
2927    }
2928
2929    public int countByReceiverUserId(long receiverUserId)
2930        throws SystemException {
2931        Object[] finderArgs = new Object[] { new Long(receiverUserId) };
2932
2933        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_RECEIVERUSERID,
2934                finderArgs, this);
2935
2936        if (count == null) {
2937            Session session = null;
2938
2939            try {
2940                session = openSession();
2941
2942                StringBundler query = new StringBundler(2);
2943
2944                query.append(_SQL_COUNT_SOCIALACTIVITY_WHERE);
2945
2946                query.append(_FINDER_COLUMN_RECEIVERUSERID_RECEIVERUSERID_2);
2947
2948                String sql = query.toString();
2949
2950                Query q = session.createQuery(sql);
2951
2952                QueryPos qPos = QueryPos.getInstance(q);
2953
2954                qPos.add(receiverUserId);
2955
2956                count = (Long)q.uniqueResult();
2957            }
2958            catch (Exception e) {
2959                throw processException(e);
2960            }
2961            finally {
2962                if (count == null) {
2963                    count = Long.valueOf(0);
2964                }
2965
2966                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_RECEIVERUSERID,
2967                    finderArgs, count);
2968
2969                closeSession(session);
2970            }
2971        }
2972
2973        return count.intValue();
2974    }
2975
2976    public int countByC_C(long classNameId, long classPK)
2977        throws SystemException {
2978        Object[] finderArgs = new Object[] {
2979                new Long(classNameId), new Long(classPK)
2980            };
2981
2982        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_C_C,
2983                finderArgs, this);
2984
2985        if (count == null) {
2986            Session session = null;
2987
2988            try {
2989                session = openSession();
2990
2991                StringBundler query = new StringBundler(3);
2992
2993                query.append(_SQL_COUNT_SOCIALACTIVITY_WHERE);
2994
2995                query.append(_FINDER_COLUMN_C_C_CLASSNAMEID_2);
2996
2997                query.append(_FINDER_COLUMN_C_C_CLASSPK_2);
2998
2999                String sql = query.toString();
3000
3001                Query q = session.createQuery(sql);
3002
3003                QueryPos qPos = QueryPos.getInstance(q);
3004
3005                qPos.add(classNameId);
3006
3007                qPos.add(classPK);
3008
3009                count = (Long)q.uniqueResult();
3010            }
3011            catch (Exception e) {
3012                throw processException(e);
3013            }
3014            finally {
3015                if (count == null) {
3016                    count = Long.valueOf(0);
3017                }
3018
3019                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_C_C, finderArgs,
3020                    count);
3021
3022                closeSession(session);
3023            }
3024        }
3025
3026        return count.intValue();
3027    }
3028
3029    public int countByM_C_C(long mirrorActivityId, long classNameId,
3030        long classPK) throws SystemException {
3031        Object[] finderArgs = new Object[] {
3032                new Long(mirrorActivityId), new Long(classNameId),
3033                new Long(classPK)
3034            };
3035
3036        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_M_C_C,
3037                finderArgs, this);
3038
3039        if (count == null) {
3040            Session session = null;
3041
3042            try {
3043                session = openSession();
3044
3045                StringBundler query = new StringBundler(4);
3046
3047                query.append(_SQL_COUNT_SOCIALACTIVITY_WHERE);
3048
3049                query.append(_FINDER_COLUMN_M_C_C_MIRRORACTIVITYID_2);
3050
3051                query.append(_FINDER_COLUMN_M_C_C_CLASSNAMEID_2);
3052
3053                query.append(_FINDER_COLUMN_M_C_C_CLASSPK_2);
3054
3055                String sql = query.toString();
3056
3057                Query q = session.createQuery(sql);
3058
3059                QueryPos qPos = QueryPos.getInstance(q);
3060
3061                qPos.add(mirrorActivityId);
3062
3063                qPos.add(classNameId);
3064
3065                qPos.add(classPK);
3066
3067                count = (Long)q.uniqueResult();
3068            }
3069            catch (Exception e) {
3070                throw processException(e);
3071            }
3072            finally {
3073                if (count == null) {
3074                    count = Long.valueOf(0);
3075                }
3076
3077                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_M_C_C,
3078                    finderArgs, count);
3079
3080                closeSession(session);
3081            }
3082        }
3083
3084        return count.intValue();
3085    }
3086
3087    public int countByG_U_CD_C_C_T_R(long groupId, long userId,
3088        long createDate, long classNameId, long classPK, int type,
3089        long receiverUserId) throws SystemException {
3090        Object[] finderArgs = new Object[] {
3091                new Long(groupId), new Long(userId), new Long(createDate),
3092                new Long(classNameId), new Long(classPK), new Integer(type),
3093                new Long(receiverUserId)
3094            };
3095
3096        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_G_U_CD_C_C_T_R,
3097                finderArgs, this);
3098
3099        if (count == null) {
3100            Session session = null;
3101
3102            try {
3103                session = openSession();
3104
3105                StringBundler query = new StringBundler(8);
3106
3107                query.append(_SQL_COUNT_SOCIALACTIVITY_WHERE);
3108
3109                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_GROUPID_2);
3110
3111                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_USERID_2);
3112
3113                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_CREATEDATE_2);
3114
3115                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_CLASSNAMEID_2);
3116
3117                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_CLASSPK_2);
3118
3119                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_TYPE_2);
3120
3121                query.append(_FINDER_COLUMN_G_U_CD_C_C_T_R_RECEIVERUSERID_2);
3122
3123                String sql = query.toString();
3124
3125                Query q = session.createQuery(sql);
3126
3127                QueryPos qPos = QueryPos.getInstance(q);
3128
3129                qPos.add(groupId);
3130
3131                qPos.add(userId);
3132
3133                qPos.add(createDate);
3134
3135                qPos.add(classNameId);
3136
3137                qPos.add(classPK);
3138
3139                qPos.add(type);
3140
3141                qPos.add(receiverUserId);
3142
3143                count = (Long)q.uniqueResult();
3144            }
3145            catch (Exception e) {
3146                throw processException(e);
3147            }
3148            finally {
3149                if (count == null) {
3150                    count = Long.valueOf(0);
3151                }
3152
3153                FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_G_U_CD_C_C_T_R,
3154                    finderArgs, count);
3155
3156                closeSession(session);
3157            }
3158        }
3159
3160        return count.intValue();
3161    }
3162
3163    public int countAll() throws SystemException {
3164        Object[] finderArgs = new Object[0];
3165
3166        Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL,
3167                finderArgs, this);
3168
3169        if (count == null) {
3170            Session session = null;
3171
3172            try {
3173                session = openSession();
3174
3175                Query q = session.createQuery(_SQL_COUNT_SOCIALACTIVITY);
3176
3177                count = (Long)q.uniqueResult();
3178            }
3179            catch (Exception e) {
3180                throw processException(e);
3181            }
3182            finally {
3183                if (count == null) {
3184                    count = Long.valueOf(0);
3185                }
3186
3187                FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, finderArgs,
3188                    count);
3189
3190                closeSession(session);
3191            }
3192        }
3193
3194        return count.intValue();
3195    }
3196
3197    public void afterPropertiesSet() {
3198        String[] listenerClassNames = StringUtil.split(GetterUtil.getString(
3199                    com.liferay.portal.util.PropsUtil.get(
3200                        "value.object.listener.com.liferay.portlet.social.model.SocialActivity")));
3201
3202        if (listenerClassNames.length > 0) {
3203            try {
3204                List<ModelListener<SocialActivity>> listenersList = new ArrayList<ModelListener<SocialActivity>>();
3205
3206                for (String listenerClassName : listenerClassNames) {
3207                    listenersList.add((ModelListener<SocialActivity>)Class.forName(
3208                            listenerClassName).newInstance());
3209                }
3210
3211                listeners = listenersList.toArray(new ModelListener[listenersList.size()]);
3212            }
3213            catch (Exception e) {
3214                _log.error(e);
3215            }
3216        }
3217    }
3218
3219    @BeanReference(type = SocialActivityPersistence.class)
3220    protected SocialActivityPersistence socialActivityPersistence;
3221    @BeanReference(type = SocialRelationPersistence.class)
3222    protected SocialRelationPersistence socialRelationPersistence;
3223    @BeanReference(type = SocialRequestPersistence.class)
3224    protected SocialRequestPersistence socialRequestPersistence;
3225    @BeanReference(type = GroupPersistence.class)
3226    protected GroupPersistence groupPersistence;
3227    @BeanReference(type = LayoutPersistence.class)
3228    protected LayoutPersistence layoutPersistence;
3229    @BeanReference(type = ResourcePersistence.class)
3230    protected ResourcePersistence resourcePersistence;
3231    @BeanReference(type = UserPersistence.class)
3232    protected UserPersistence userPersistence;
3233    private static final String _SQL_SELECT_SOCIALACTIVITY = "SELECT socialActivity FROM SocialActivity socialActivity";
3234    private static final String _SQL_SELECT_SOCIALACTIVITY_WHERE = "SELECT socialActivity FROM SocialActivity socialActivity WHERE ";
3235    private static final String _SQL_COUNT_SOCIALACTIVITY = "SELECT COUNT(socialActivity) FROM SocialActivity socialActivity";
3236    private static final String _SQL_COUNT_SOCIALACTIVITY_WHERE = "SELECT COUNT(socialActivity) FROM SocialActivity socialActivity WHERE ";
3237    private static final String _FINDER_COLUMN_GROUPID_GROUPID_2 = "socialActivity.groupId = ?";
3238    private static final String _FINDER_COLUMN_COMPANYID_COMPANYID_2 = "socialActivity.companyId = ?";
3239    private static final String _FINDER_COLUMN_USERID_USERID_2 = "socialActivity.userId = ?";
3240    private static final String _FINDER_COLUMN_MIRRORACTIVITYID_MIRRORACTIVITYID_2 =
3241        "socialActivity.mirrorActivityId = ?";
3242    private static final String _FINDER_COLUMN_CLASSNAMEID_CLASSNAMEID_2 = "socialActivity.classNameId = ?";
3243    private static final String _FINDER_COLUMN_RECEIVERUSERID_RECEIVERUSERID_2 = "socialActivity.receiverUserId = ?";
3244    private static final String _FINDER_COLUMN_C_C_CLASSNAMEID_2 = "socialActivity.classNameId = ? AND ";
3245    private static final String _FINDER_COLUMN_C_C_CLASSPK_2 = "socialActivity.classPK = ?";
3246    private static final String _FINDER_COLUMN_M_C_C_MIRRORACTIVITYID_2 = "socialActivity.mirrorActivityId = ? AND ";
3247    private static final String _FINDER_COLUMN_M_C_C_CLASSNAMEID_2 = "socialActivity.classNameId = ? AND ";
3248    private static final String _FINDER_COLUMN_M_C_C_CLASSPK_2 = "socialActivity.classPK = ?";
3249    private static final String _FINDER_COLUMN_G_U_CD_C_C_T_R_GROUPID_2 = "socialActivity.groupId = ? AND ";
3250    private static final String _FINDER_COLUMN_G_U_CD_C_C_T_R_USERID_2 = "socialActivity.userId = ? AND ";
3251    private static final String _FINDER_COLUMN_G_U_CD_C_C_T_R_CREATEDATE_2 = "socialActivity.createDate = ? AND ";
3252    private static final String _FINDER_COLUMN_G_U_CD_C_C_T_R_CLASSNAMEID_2 = "socialActivity.classNameId = ? AND ";
3253    private static final String _FINDER_COLUMN_G_U_CD_C_C_T_R_CLASSPK_2 = "socialActivity.classPK = ? AND ";
3254    private static final String _FINDER_COLUMN_G_U_CD_C_C_T_R_TYPE_2 = "socialActivity.type = ? AND ";
3255    private static final String _FINDER_COLUMN_G_U_CD_C_C_T_R_RECEIVERUSERID_2 = "socialActivity.receiverUserId = ?";
3256    private static final String _ORDER_BY_ENTITY_ALIAS = "socialActivity.";
3257    private static final String _NO_SUCH_ENTITY_WITH_PRIMARY_KEY = "No SocialActivity exists with the primary key ";
3258    private static final String _NO_SUCH_ENTITY_WITH_KEY = "No SocialActivity exists with the key {";
3259    private static Log _log = LogFactoryUtil.getLog(SocialActivityPersistenceImpl.class);
3260}