1
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
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}