/*!
 * This program is free software; you can redistribute it and/or modify it under the
 * terms of the GNU Lesser General Public License, version 2.1 as published by the Free Software
 * Foundation.
 *
 * You should have received a copy of the GNU Lesser General Public License along with this
 * program; if not, you can obtain a copy at http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html
 * or from the Free Software Foundation, Inc.,
 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
 *
 * 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 Lesser General Public License for more details.
 *
 * Copyright (c) 2002-2013 Pentaho Corporation..  All rights reserved.
 */

package org.pentaho.platform.plugin.action.jfreereport.helper;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.pentaho.commons.connection.IMultiDimensionalMetaData;
import org.pentaho.commons.connection.IMultiDimensionalResultSet;
import org.pentaho.commons.connection.IPentahoResultSet;
import org.pentaho.platform.api.util.IVersionHelper;
import org.pentaho.platform.engine.core.system.PentahoSystem;
import org.pentaho.platform.plugin.action.messages.Messages;
import org.pentaho.reporting.engine.classic.core.util.CloseableTableModel;

import javax.swing.table.AbstractTableModel;

// import org.jfree.report.modules.misc.tablemodel.TypeMapper;

public class PentahoTableModel extends AbstractTableModel implements CloseableTableModel {
  private static final long serialVersionUID = 696878055074045444L;

  private IPentahoResultSet resultSet;

  private transient Object[][] rowHeaders;

  public PentahoTableModel( final IPentahoResultSet rs ) {
    super();
    resultSet = rs;
  }

  /**
   * returns the logger object
   * 
   * @return log
   */
  public Log getLogger() {
    return LogFactory.getLog( getClass() );
  }

  @SuppressWarnings( "deprecation" )
  public int getColumnCount() {
    if ( resultSet == null ) {
      return 0;
    }

    if ( rowHeaders == null ) {
      rowHeaders = resultSet.getMetaData().getRowHeaders();
    }

    if ( ( rowHeaders != null ) && ( rowHeaders.length > 0 ) ) {
      return rowHeaders[0].length + resultSet.getColumnCount();
    } else {
      return resultSet.getColumnCount();
    }
  }

  @SuppressWarnings( "deprecation" )
  public Object getValueAt( final int rowIndex, int columnIndex ) {
    if ( resultSet == null ) {
      return null;
    }

    if ( rowHeaders == null ) {
      rowHeaders = resultSet.getMetaData().getRowHeaders();
    }

    if ( rowHeaders != null ) {
      if ( columnIndex < rowHeaders[0].length ) {
        return rowHeaders[rowIndex][columnIndex];
      } else {
        columnIndex -= rowHeaders[0].length;
      }
    }

    // catch any exceptions so we don't blow up the entire jfreereport
    Object val = null;
    try {
      val = resultSet.getValueAt( rowIndex, columnIndex );
    } catch ( IndexOutOfBoundsException e1 ) {
      //
      // MB - This isn't an error condition. Indeed, it will happen when there are zero rows of
      // data. So, log an info message and be done with it. We also don't want an if-check to be
      // done on every cell for this boundary case.
      //
      getLogger().info( Messages.getInstance().getErrorString( "PentahoTableModel.ERROR_0001_GET_VALUE_AT" ) ); //$NON-NLS-1$
    } catch ( Throwable t ) {
      IVersionHelper versionHelper = PentahoSystem.get( IVersionHelper.class, null );
      getLogger().error( "Error Start: Pentaho " + versionHelper.getVersionInformation( this.getClass() ) ); //$NON-NLS-1$
      getLogger().error( Messages.getInstance().getErrorString( "PentahoTableModel.ERROR_0001_GET_VALUE_AT" ), t ); //$NON-NLS-1$
      getLogger().error( "Error end:" ); //$NON-NLS-1$
    }

    return val;
  }

  public int getRowCount() {
    if ( resultSet != null ) {
      return resultSet.getRowCount();
    }
    return 0;
  }

  @SuppressWarnings( "deprecation" )
  @Override
  public String getColumnName( int columnNumber ) {
    if ( resultSet == null ) {
      return null;
    }

    // Flatten out the column headers into one column-name
    Object[][] columnHeaders = resultSet.getMetaData().getColumnHeaders();
    if ( rowHeaders == null ) {
      rowHeaders = resultSet.getMetaData().getRowHeaders();
    }

    if ( ( rowHeaders != null ) && ( rowHeaders.length > 0 ) ) {
      if ( columnNumber < rowHeaders[0].length ) {
        if ( resultSet instanceof IMultiDimensionalResultSet ) {
          // If the requested column number is in the range, return it. Otherwise return a blank string
          final String[] columnNames = ( (IMultiDimensionalMetaData) resultSet.getMetaData() ).getRowHeaderNames();
          return ( columnNumber >= 0 && columnNumber < columnNames.length ) ? columnNames[columnNumber] : ""; //$NON-NLS-1$
        }
      } else {
        columnNumber -= rowHeaders[0].length;
      }
    }
    StringBuffer buf = new StringBuffer();
    if ( ( columnHeaders != null ) && ( columnHeaders.length > 0 ) ) {
      for ( int i = 0; i < columnHeaders.length; i++ ) {
        if ( i > 0 ) {
          buf.append( "/" ); //$NON-NLS-1$
        }
        buf.append( columnHeaders[i][columnNumber].toString() );
      }
    }
    return buf.toString();
  }

  public void close() {
    // Close the old result set if needed.
    if ( resultSet != null ) {
      resultSet.closeConnection();
      resultSet.close();
    }
    resultSet = null;
    // JFreeReport wont listen, but it is always good style to comply to
    // the contract ..
    fireTableStructureChanged();
  }
}