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