package fr.ifremer.quadrige3.core.dao.system.generalCondition;
   
   /*-
    * #%L
    * Quadrige3 Core :: Server API
    * %%
    * Copyright (C) 2017 - 2024 Ifremer
    * %%
    * This program is free software: you can redistribute it and/or modify
   * it under the terms of the GNU Affero General Public License as published by
   * the Free Software Foundation, either version 3 of the License, or
   * (at your option) any later version.
   * 
   * This program is distributed in the hope that it will be useful,
   * but WITHOUT ANY WARRANTY; without even the implied warranty of
   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   * GNU General Public License for more details.
   * 
   * You should have received a copy of the GNU Affero General Public License
   * along with this program.  If not, see <http://www.gnu.org/licenses/>.
   * #L%
   */
  
  import com.google.common.collect.Maps;
  import fr.ifremer.quadrige3.core.dao.referential.StatusCode;
  import fr.ifremer.quadrige3.core.dao.technical.Assert;
  import fr.ifremer.quadrige3.core.dao.technical.jdbc.OptionalDataSourceJdbcDaoSupport;
  import fr.ifremer.quadrige3.core.vo.system.generalCondition.GeneralConditionVO;
  import org.springframework.beans.factory.InitializingBean;
  import org.springframework.stereotype.Repository;
  
  import javax.annotation.Resource;
  import javax.sql.DataSource;
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.util.Map;
  import java.util.Properties;
  
  @Repository("generalConditionJdbcDao")
  public class GeneralConditionJdbcDaoImpl extends OptionalDataSourceJdbcDaoSupport
      implements InitializingBean {
  
      private final static String QUERIES_FILE_PATH = "queries.jdbc.xml";
  
      @Resource(name = "queriesJdbcProperties")
      private Properties queriesJdbcProperties;
  
      public GeneralConditionJdbcDaoImpl(DataSource dataSource) {
          super(dataSource);
      }
  
      public GeneralConditionVO getLast() {
          String sql = queriesJdbcProperties.getProperty("lastGeneralCondition");
          Map<String, Object> paramMap = Maps.newHashMap();
          paramMap.put("statusCd", StatusCode.ENABLE.getValue());
          return query(null, sql, paramMap, this::toGeneralConditionVO);
      }
  
      public boolean isAcceptedForUser(int id, int userId) {
          String sql = queriesJdbcProperties.getProperty("acceptedGeneralCondition");
          Map<String, Object> paramMap = Maps.newHashMap();
          paramMap.put("id", id);
          paramMap.put("userId", userId);
          Long count = queryCount(null, sql, paramMap);
          return count >= 1;
      }
  
  
      public void accept(int id, int userId) {
          String sql = queriesJdbcProperties.getProperty("acceptGeneralCondition");
          Map<String, Object> paramMap = Maps.newHashMap();
          paramMap.put("id", id);
          paramMap.put("userId", userId);
          queryUpdateAndCommit(null, sql, paramMap);
      }
  
      protected GeneralConditionVO toGeneralConditionVO(ResultSet source) throws SQLException {
          GeneralConditionVO target = new GeneralConditionVO();
          int col = 0;
          target.setId(safeGetInteger(source, ++col));
          target.setContent(source.getString(++col));
          return target;
      }
  
      @Override
      public void afterPropertiesSet() throws Exception {
          checkQueryExists("lastGeneralCondition");
          checkQueryExists("acceptedGeneralCondition");
          checkQueryExists("acceptGeneralCondition");
      }
  
      protected void checkQueryExists(String queryName) {
          Assert.notBlank(queriesJdbcProperties.getProperty(queryName),
              "Property with name [%s] not exists on JDBC queries file");
      }
  }