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