View Javadoc
1   package fr.ifremer.tutti.persistence.service.referential;
2   
3   /*
4    * #%L
5    * Tutti :: Persistence
6    * $Id:$
7    * $HeadURL:$
8    * %%
9    * Copyright (C) 2012 - 2014 Ifremer
10   * %%
11   * This program is free software: you can redistribute it and/or modify
12   * it under the terms of the GNU General Public License as
13   * published by the Free Software Foundation, either version 3 of the
14   * License, or (at your option) any later version.
15   * 
16   * This program is distributed in the hope that it will be useful,
17   * but WITHOUT ANY WARRANTY; without even the implied warranty of
18   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
19   * GNU General Public License for more details.
20   * 
21   * You should have received a copy of the GNU General Public
22   * License along with this program.  If not, see
23   * <http://www.gnu.org/licenses/gpl-3.0.html>.
24   * #L%
25   */
26  
27  import fr.ifremer.adagio.core.dao.referential.StatusCode;
28  import fr.ifremer.adagio.core.dao.referential.StatusDao;
29  import fr.ifremer.adagio.core.service.technical.CacheService;
30  import fr.ifremer.tutti.persistence.entities.referential.Status;
31  import fr.ifremer.tutti.persistence.entities.referential.Statuss;
32  import fr.ifremer.tutti.persistence.entities.referential.TuttiReferentialEntity;
33  import fr.ifremer.tutti.persistence.service.AbstractPersistenceService;
34  import org.hibernate.Query;
35  
36  import javax.annotation.Resource;
37  import java.util.Iterator;
38  
39  /**
40   * Created on 11/3/14.
41   *
42   * @author Tony Chemit - chemit@codelutin.com
43   * @since 3.8
44   */
45  public abstract class ReferentialPersistenceServiceSupport extends AbstractPersistenceService {
46  
47      @Resource(name = "statusDao")
48      private StatusDao statusDao;
49  
50      @Resource(name = "cacheService")
51      protected CacheService cacheService;
52  
53      protected Iterator<Object[]> queryListWithStatus(String queryName, Object... params) {
54          Query query = createQuery(queryName, params);
55          query.setString("statusValidCode", StatusCode.ENABLE.getValue());
56          query.setString("statusTemporaryCode", StatusCode.TEMPORARY.getValue());
57  
58          return query.iterate();
59      }
60  
61      protected Iterator<Object[]> queryListWithStatus2(String queryName, Object... params) {
62          Query query = createQuery(queryName, params);
63          query.setString("statusValidCode", StatusCode.ENABLE.getValue());
64          query.setString("statusTemporaryCode", StatusCode.TEMPORARY.getValue());
65          query.setString("statusDisableCode", StatusCode.DISABLE.getValue());
66  
67          return query.iterate();
68      }
69  
70      protected Object[] queryUniqueWithStatus(String queryName, Object... params) {
71  
72          Query query = createQuery(queryName, params);
73          query.setString("statusValidCode", StatusCode.ENABLE.getValue());
74          query.setString("statusTemporaryCode", StatusCode.TEMPORARY.getValue());
75  
76          Object result = query.uniqueResult();
77          return (Object[]) result;
78      }
79  
80      protected Object[] queryUniqueWithStatus2(String queryName, Object... params) {
81  
82          Query query = createQuery(queryName, params);
83          query.setString("statusValidCode", StatusCode.ENABLE.getValue());
84          query.setString("statusTemporaryCode", StatusCode.TEMPORARY.getValue());
85          query.setString("statusDisableCode", StatusCode.DISABLE.getValue());
86  
87          Object result = query.uniqueResult();
88          return (Object[]) result;
89      }
90  
91      protected <E extends TuttiReferentialEntity> void setStatus(String statusCode, E entity) {
92          Status newStatus = Statuss.newStatus();
93          fr.ifremer.adagio.core.dao.referential.Status status = statusDao.load(statusCode);
94          newStatus.setId(status.getCode());
95          newStatus.setName(status.getName());
96          entity.setStatus(newStatus);
97      }
98  
99  }