/*
    * Copyright 2003 - 2013 The eFaps Team
    *
    * Licensed under the Apache License, Version 2.0 (the "License");
    * you may not use this file except in compliance with the License.
    * You may obtain a copy of the License at
    *
    *     http://www.apache.org/licenses/LICENSE-2.0
    *
   * Unless required by applicable law or agreed to in writing, software
   * distributed under the License is distributed on an "AS IS" BASIS,
   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   * See the License for the specific language governing permissions and
   * limitations under the License.
   *
   * Revision:        $Rev$
   * Last Changed:    $Date$
   * Last Changed By: $Author$
   */
  
  package org.efaps.admin.datamodel.attributetype;
  
  import java.sql.SQLException;
  import java.util.List;
  
  import org.efaps.admin.datamodel.Attribute;
  import org.efaps.db.wrapper.AbstractSQLInsertUpdate;
  import org.efaps.util.EFapsException;
  
  /**
   * Implements the mapping between values in the database and {@link Double}
   * values in eFaps.
   *
   * @author The eFaps Team
   * @version $Id$
   */
  public class RealType
      extends AbstractType
  {
      /**
       * Needed for serialization.
       */
      private static final long serialVersionUID = 1L;
  
      /**
       * {@inheritDoc}
       */
      @Override
      protected void prepare(final AbstractSQLInsertUpdate<?> _insertUpdate,
                             final Attribute _attribute,
                             final Object... _values)
          throws SQLException
      {
          checkSQLColumnSize(_attribute, 1);
          _insertUpdate.column(_attribute.getSqlColNames().get(0), eval(_values));
      }
  
      /**
       * Evaluate the value.
       * @param _value value to be evaluated
       * @return Long value
       */
      protected Double eval(final Object[] _value)
      {
          final Double ret;
  
          if (_value == null) {
              ret = null;
          } else if ((_value[0] instanceof String) && (((String) _value[0]).length() > 0)) {
              ret = Double.parseDouble((String) _value[0]);
          } else if (_value[0] instanceof Number) {
              ret = ((Number) _value[0]).doubleValue();
          } else  {
              ret = null;
          }
  
          return ret;
      }
  
      /**
       * {@inheritDoc}
       */
      @Override
      public Object readValue(final Attribute _attribute,
                              final List<Object> _objectList)
      {
          Double ret = null;
          final Object obj = _objectList.get(0);
          if (obj instanceof Number) {
              ret = ((Number) obj).doubleValue();
          } else if (obj != null) {
              ret = Double.parseDouble(obj.toString());
          }
          return ret;
      }
  
      /**
       * {@inheritDoc}
       */
     @Override
     public String toString4Where(final Object _value)
         throws EFapsException
     {
         String ret = "";
         if (_value instanceof Number) {
             ret =  ((Number) _value).toString();
         } else if (_value instanceof String) {
             ret = (String) _value;
         } else if (_value != null) {
             ret = _value.toString();
         }
         return ret;
     }
 }