/**
* Constructs a ClutoTree diaplay which is initialized with tableModel as the data model, and the
* given selection model.
*
* @param clutoSolution The clustering solution
* @param tableContext The context which manages views and selections.
* @param tableModel the data model for the parallel coordinate display
*/
public ClutoTree(ClutoSolution clutoSolution, TableContext tableContext, TableModel tableModel) {
ctx = tableContext;
tm = tableModel;
lsm = ctx.getRowSelectionModel(tm);
// labelModel
int ncol = tm.getColumnCount();
for (int i = 0; i < ncol; i++) {
labelModel.addElement(tm.getColumnName(i));
}
setLayout(new BorderLayout());
btnP = new JToolBar();
add(btnP, BorderLayout.NORTH);
labelChoice.addItemListener(
new ItemListener() {
public void itemStateChanged(ItemEvent e) {
if (e.getStateChange() == ItemEvent.SELECTED) {
labelColumn = 0;
String ln = (String) e.getItem();
if (ln != null) {
for (int c = 0; c < tm.getColumnCount(); c++) {
if (ln.equals(tm.getColumnName(c))) {
labelColumn = c;
break;
}
}
}
graph.invalidate();
validate();
repaint();
}
}
});
btnP.add(labelChoice);
graph = new SimpleGraph();
graph.getGraphDisplay().setOpaque(true);
graph.getGraphDisplay().setBackground(Color.white);
graph.getGraphDisplay().setGridColor(new Color(220, 220, 220));
graph.showGrid(false);
graph.showAxis(BorderLayout.WEST, false);
graph.showAxis(BorderLayout.EAST, true);
graph.getAxisDisplay(BorderLayout.EAST).setZoomable(true);
graph.getAxisDisplay(BorderLayout.EAST).setAxisLabeler(labeler);
((LinearAxis) graph.getYAxis()).setTickIncrement(-1.);
graph.getAxisDisplay(BorderLayout.SOUTH).setZoomable(true);
gs = new GraphSegments();
gs.setColor(Color.blue);
idxSelColor = new IndexSelectColor(Color.cyan, null, new DefaultListSelectionModel());
gs.setIndexedColor(idxSelColor);
graph.addGraphItem(gs);
graph.getGraphDisplay().addMouseListener(ma);
add(graph);
if (lsm != null) {
lsm.addListSelectionListener(selListener);
}
display(makeTree(clutoSolution));
}
/** Overrides <code>JComponent</code>'s <code>getToolTipText</code> */
public String getToolTipText(MouseEvent e) {
String tip = null;
java.awt.Point p = e.getPoint();
int rowIndex = rowAtPoint(p);
// int colIndex = columnAtPoint(p);
// int realColumnIndex = convertColumnIndexToModel(colIndex);
TableModel model = getModel();
tip = (String) model.getValueAt(rowIndex, 1);
return tip;
}
//
// Implement the PropertyChangeListener
//
public void propertyChange(PropertyChangeEvent e) {
// When the TableModel changes we need to update the listeners
// and column widths
if ("model".equals(e.getPropertyName())) {
TableModel model = (TableModel) e.getOldValue();
model.removeTableModelListener(this);
model = (TableModel) e.getNewValue();
model.addTableModelListener(this);
adjustColumns();
}
}
public void valueChanged(ListSelectionEvent e) {
int maxRows;
int[] selRows;
Object value;
if (!e.getValueIsAdjusting()) {
selRows = aTable.getSelectedRows();
if (selRows.length > 0) {
for (int i = 0; i < 3; i++) {
// get Table data
TableModel tm = aTable.getModel();
value = tm.getValueAt(selRows[0], i);
System.out.println("Selection : " + value);
}
System.out.println();
}
}
}
protected Comparator getComparator(int column) {
Class columnType = tableModel.getColumnClass(column);
Comparator comparator = (Comparator) columnComparators.get(columnType);
if (comparator != null) {
return comparator;
}
if (Comparable.class.isAssignableFrom(columnType)) {
return COMPARABLE_COMAPRATOR;
}
return LEXICAL_COMPARATOR;
}
/**
* Return a label for the given point on the graph axis
*
* @param value the value on the graph
* @return the label for the given value
*/
private String getLeafLabel(double value) {
String label = Double.toString(value);
try {
int v = (int) value;
int r = idxMap.getSrc(v);
if (r < 0 || r >= tm.getRowCount()) {
return "";
}
if (labelColumn >= 0 && labelColumn < tm.getColumnCount()) {
Object o = tm.getValueAt(r, labelColumn);
return o != null ? o.toString() : "";
}
} catch (Exception ex) {
ExceptionHandler.popupException("" + ex);
}
try {
label = Integer.toString((int) value);
} catch (Exception ex) {
ExceptionHandler.popupException("" + ex);
}
return label;
}
private Row[] getViewToModel() {
if (viewToModel == null) {
int tableModelRowCount = tableModel.getRowCount();
viewToModel = new Row[tableModelRowCount];
for (int row = 0; row < tableModelRowCount; row++) {
viewToModel[row] = new Row(row);
}
if (isSorting()) {
Arrays.sort(viewToModel);
}
}
return viewToModel;
}
/**
* Display the tree rooted at node tn in the graph as a dendogram.
*
* @param tn the root node of the tree to display
*/
private void display(TreeNode tn) {
double[] segs = dendogram(tn);
double distance = 10.;
if (tn instanceof Cluster) {
distance = ((Cluster) tn).getSimilarity();
} else {
distance = ((DefaultMutableTreeNode) tn).getDepth();
}
gs.setData(segs, GraphDataModel.FORMAT_XY);
graph.getXAxis().setMin(distance);
graph.getXAxis().setMax(0.);
graph.getYAxis().setMin(tm.getRowCount() - .5);
graph.getYAxis().setMax(-.5);
repaint();
}
public void calculaSumas() {
try {
TableModel tm = this.tablaPrincipal.getModel();
int tamTabla = tm.getRowCount();
double costo, cantidad, totalFila, sumaTotal;
sumaTotal = 0.0;
for (int i = 0; i < tamTabla; i++) {
if (tm.getValueAt(i, 2) != null && tm.getValueAt(i, 3) != null) {
costo = Double.valueOf(String.valueOf(tm.getValueAt(i, 2)));
cantidad = Double.valueOf(String.valueOf(tm.getValueAt(i, 3)));
totalFila = costo * cantidad;
tm.setValueAt(totalFila, i, 4);
sumaTotal += totalFila;
}
}
txtSumaTotal.setText(String.valueOf(sumaTotal));
} catch (Exception e) {
Dialogos.lanzarAlerta("Cantidades invalidas, puede que algun numero este mal escrito");
}
}
public void tableChanged(TableModelEvent tme) {
int baris = tme.getFirstRow();
int kolom = tme.getColumn();
TableModel model = (TableModel) tme.getSource();
int id = (Integer) model.getValueAt(baris, 0);
String query = "";
switch (kolom) {
case 1:
String nama = (String) model.getValueAt(baris, kolom);
query = "UPDATE produk SET nama_produk='" + nama + "' WHERE id_produk=" + id;
prosesEdit(query);
break;
case 2:
String jenis = (String) model.getValueAt(baris, kolom);
try {
query = "select * from jenis where nama_jenis='" + jenis + "'";
ResultSet rs = stm.executeQuery(query);
if (rs.next()) {
int idJenis = rs.getInt("id_jenis");
query = "UPDATE produk SET id_jenis=" + idJenis + " WHERE id_produk=" + id;
prosesEdit(query);
} else {
setDataTabel();
JOptionPane.showMessageDialog(null, "gagal,jenis tidak ada");
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
}
break;
case 3:
int stok = (Integer) model.getValueAt(baris, kolom);
query = "UPDATE `stok_produk` SET stok=" + stok + " WHERE id_produk=" + id;
prosesEdit(query);
break;
case 4:
int harga = (Integer) model.getValueAt(baris, kolom);
query = "UPDATE produk SET harga=" + harga + " WHERE id_produk=" + id;
prosesEdit(query);
break;
case 5:
String suplier = (String) model.getValueAt(baris, kolom);
try {
query = "SELECT * FROM suplier WHERE nama_suplier='" + suplier + "'";
ResultSet rs = stm.executeQuery(query);
if (rs.next()) {
int idSuplier = rs.getInt("id_suplier");
query = "UPDATE produk SET id_suplier=" + idSuplier + " WHERE id_produk=" + id;
prosesEdit(query);
} else {
setDataTabel();
JOptionPane.showMessageDialog(null, "gagal,suplier belum terdaftar");
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
}
break;
default:
break;
}
}
public void setValueAt(Object aValue, int row, int column) {
tableModel.setValueAt(aValue, modelIndex(row), column);
}
public Object getValueAt(int row, int column) {
return tableModel.getValueAt(modelIndex(row), column);
}
public Class getColumnClass(int column) {
return tableModel.getColumnClass(column);
}
public String getColumnName(int column) {
return tableModel.getColumnName(column);
}
public int getColumnCount() {
return (tableModel == null) ? 0 : tableModel.getColumnCount();
}
public int getRowCount() {
return (tableModel == null) ? 0 : tableModel.getRowCount();
}
