001    /**
002     * Copyright (c) 2000-2010 Liferay, Inc. All rights reserved.
003     *
004     * This library is free software; you can redistribute it and/or modify it under
005     * the terms of the GNU Lesser General Public License as published by the Free
006     * Software Foundation; either version 2.1 of the License, or (at your option)
007     * any later version.
008     *
009     * This library is distributed in the hope that it will be useful, but WITHOUT
010     * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
011     * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
012     * details.
013     */
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    /**
056     * @author    Brian Wing Shun Chan
057     * @see       SocialActivityPersistence
058     * @see       SocialActivityUtil
059     * @generated
060     */
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    }