/*
 * ECatalog is a database front-end, with two main features:
 * 1. Use of preferences
 *  A preference-based approach, where the user is allowed to define the importance of each criterion.
 *  Then the items are ranked accordingly to his criteria.
 * 2. Trade-off analysis
 *  A cooperative database approach, where the system "argues" with the user about his criteria.
 *  When there are no matching items, the system explains the minimal conflicting set and
 *  give some possible strong and weak relaxations about his criteria.
 * This package also containts the software and the set-up details used for our User Study,
 * comparing the use or not of the two previous features mentioned above.
 *
 * Copyright (C) 2006 David Portabella Clotet, Artificial Intelligence Laboratory, EPFL
 * 
 * This file is part of ecatalog-1.0.zip
 * 
 * ECatalog is free software and a free user study set-up;
 * you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 * 
 * ECatalog 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 General Public License
 * along with ECatalog; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 * 
 * @version 1.0
 * @author David Portabella
 * To contact the author:
 * email: david@portabella.name and david.portabella@epfl.ch
 * 
 * More information about ECatalog:
 *  http://sourceforge.net/projects/ecatalog/
 *  http://icwww.epfl.ch/~portabel/ecatalogs/
 */

package external;

import ecatalog.ECatalog;
import ecatalog.gui.MainGui;
import ecatalog.db.Database;
import ecatalog.db.Attribute;
import ecatalog.db.BooleanAttribute;
import ecatalog.db.Item;

import ecatalog.gui.visualization.ECatalogItemTableRenderer;
import utils.itemTable.*;
import utils.ComponentTableCellRenderer;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.table.*;
import javax.swing.border.*;
import java.util.Vector;
import java.sql.*;

import java.awt.Color;
import javax.swing.table.TableCellRenderer;


/* The class concerned with the table rendering */
public class MovieItemTableRenderer extends ECatalogItemTableRenderer {
    Database db;

    public void init(Database db) {
	this.db = db;
    }


    /* Get the number of columns */
    public int getNbrColumns() {
	return 10;
    }
    /* Get the number of rows for each item */
    public int getNbrItemRows() {
	return 4;
    }

    /* Get the column name
     * @param itemRow  the row index (not the table row, but the item row)
     * @param tableCol  the column index
     */
    public String getColumnName(int itemRow, int tableCol) {
	int attributeIndex = getItemAttributeIndex(itemRow, tableCol);
	return db.getAttribute(attributeIndex).getConfig().getLabel();
    }

    /* Get the cell which will be rendered, given itemRow and tableCol
     * @param itemRow  the row index (not the table row, but the item row)
     * @param tableCol  the column index
     * @retrun the cell to be used. (change [int,int] by a class width itemRow and tableCol attributes)
     */
    public CellIndex getVisibleCell(int itemRow, int tableCol) {
	if (itemRow == 0)
	    return new CellIndex(0, tableCol);
	return new CellIndex(itemRow, 0);
    }


    /* Get the horizontal and vertical span
     * @param itemRow  the row index (not the table row, but the item row)
     * @param tableCol  the column index
     */
    public CellSpan getCellSpan(int itemRow, int tableCol) {
	if (itemRow == 0)
	    return new CellSpan(1,1);
	return new CellSpan(10, 1);
    }

    /* Get the cell size
     * @param itemRow   the row index (not the table row, but the item row)
     * @param tableCol  the column index
     * @result          the size for the specified cell.
     cellSize.width == -1 means no width preference (use default)
     cellSize.height == -1 means no height preference (use default)
     cellSize == null means no width nor height preference (use default)
    */
    public CellSize getCellSize(int itemRow, int tableCol) {
	return null;
    }


    /* the class implementing this interface should know to extract the information from the Item 
     * @param item      the item from where to extract the requested information
     * @param itemRow   the row index (not the table row, but the item row)
     * @param tableCol  the column index
     */
    public Object getValueAt(Object item, int itemRow, int itemColumn) {
	try {
	    Attribute at = db.getAttribute(getItemAttributeIndex(itemRow, itemColumn));
	    return at.getValueString(at.getValueIndex((Item)item));
	} catch (SQLException e) { return ""; }
    }


    /* gets the renderer for the specified cell 
     * @param itemRow  the row index (not the table row, but the item row)
     * @param tableCol  the column index
     * @result a renderer for this cell, or null if non specified (in this case, the default one should be used)
     */
    public ItemTableCellRenderer getItemTableCellRenderer(int itemIndex, int itemRow, int tableCol) {
	return null;
    }


    /* Returns true if the items can be sorted using this attribute.
     * If so, and the user ask to sort, sortBy will be called
     */
    public boolean isSortableByAttribute(int attributeIndex) {
	return true;
    }

    /* Return the attribute index associated to the cell specified by itemRow,tableCol.
     * @param itemRow  the row index (not the table row, but the item row)
     * @param tableCol  the column index

     * @ result         the attribute index associated to the cell specified by itemRow,tableCol.
     *                  If that cell is not associated to any attribute, return -1
     */
    public int getItemAttributeIndex(int itemRow, int tableCol) {
	int attributeIndex = (itemRow == 0) ? tableCol : (9 + itemRow);
	return attributeIndex;
    }


    /* returns whether the attribute is satisfied by the constraints given by the user 
     * ignoring the database
     */
    public boolean isCellSatisfied(Item item, int itemRow, int tableCol) {
	try {
	    int attributeIndex = getItemAttributeIndex(itemRow, tableCol);
	    Attribute at = db.getAttribute(attributeIndex);
	    return at.getValueSatisfiesConstraints(item.getValueIndex(attributeIndex));
	} catch (SQLException e) { throw new Error(e); }
    }
}